{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["Menu","Datu pilnība","VG un iBanka","Dinamika konti","Dinamika konti 18m","Dinamika konti DK","Dinamika konti DK 18m","Dinamika konti klienti DK","Dinamika konti klienti DK 18m","Klienti un konti","Klienti un konti 18m","Kor.konti","Lietotāji","Apaļas summas","Lielās summas","Brīvdienas","Pēc slēgšanas grāmatojumi","Ārpus perioda grāmatojumi","VG","iBanka","OperZur","OperZur2","OperZur3","OperZur4","Format","Tiesibas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":41,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":29,"n_cols":21,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,19,1,20],[14,1,19,6],[28,3,28,8],[26,2,26,8],[27,3,27,8],[21,1,22,6],[1,3,1,6],[3,3,3,6],[4,3,4,6],[5,3,5,6],[13,1,13,6]]}
[]
[null,"Auditors: ","SIA","…",null,null,null,null,"Svētku dienas",null,"Aktuālie klienti","Tips",null,"Aktuālie konti","Tips",null,"<-- Testam",null,null,"Testu saraksts"]
[null,null,null,null,null,null,null,null,"2025-01-01",null,null,null,null,null,null,null," Klienti un Konti",null,null,"x","Datu pilnība"]
[null,"Klients:","SIA","…",null,null,null,null,"2025-04-18",null,null,null,null,null,null,null,null,null,null,"x","VG un iBanka"]
[null,"Audita vadītājs:",null,"…",null,null,null,null,"2025-04-20",null,null,null,null,null,null,null,null,null,null,null,"Dinamika konti"]
[null,"Grāmatvedības sistēma:",null,"…",null,null,null,null,"2025-04-21",null,null,null,null,null,null,null,null,null,null,"x","Dinamika konti DK"]
[null,null,null,null,null,null,null,null,"2025-05-01",null,null,null,null,null,null,null,null,null,null,"x","Dinamika konti klienti DK"]
[null,null,null,"No","Līdz",null,"Izpildes datums",null,"2025-05-04",null,null,null,null,null,null,null,null,null,null,"x","Klienti un konti"]
[null,"Pārbaudes periods:",null,"2025-01-01","2025-12-31",null,null,null,"2025-05-11",null,null,null,null,null,null,null,null,null,null,"x","Kor.konti"]
[null,null,null,null,null,null,null,null,"2025-06-08",null,null,null,null,null,null,null,null,null,null,null,"Lietotāji"]
[null,"Būtiskums:",null,null,null,{"$f":"MID(1/10,2,1)","v":"."},"Dec. atdalītais",null,"2025-06-23",null,null,null,null,null,null,null,null,null,null,"x","Apaļas summas"]
[null,"Izpildes būtiskums:",null,null,null,null,"Tūkst. atdalītais",null,"2025-06-24",null,null,null,null,null,null,null,null,null,null,"x","Lielās summas"]
[null,null,null,null,null,null,null,null,"2025-11-18",null,null,null,null,null,null,null,null,null,null,"x","Brīvdienas"]
[null,"Piezīmes:",null,null,null,null,null,null,"2025-12-24",null,null,null,null,null,null,null,null,null,null,null,"Pēc slēgšanas grāmatojumi"]
[null,null,null,null,null,null,null,null,"2025-12-25",null,null,null,null,null,null,null,null,null,null,null,"Ārpus perioda grāmatojumi"]
[null,null,null,null,null,null,null,null,"2025-12-26",null,null,null,null,null,null,null,null,null,null,null,"Dinamika konti 18m"]
[null,null,null,null,null,null,null,null,"2025-12-31",null,null,null,null,null,null,null,null,null,null,null,"Dinamika konti DK 18m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dinamika konti klienti DK 18m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Klienti un konti 18m"]
[]
[]
[null,"Veicot jebkuru no testiem (zaļas lapas) atkārtoti, \nmanuāli ierakstīta informācija zem 10-as rindas, tiek izdzēsta. ",null,null,null,null,null,null,"OperZur Periods"]
[null,null,null,null,null,null,null,null,"1 pilns gads"]
[]
[]
[]
[null,"Apraksts:","https://exceldarbariki.mozello.lv/produkti/operzurnals/"]
[null,"Kā ieslēgt makrosus:",null,"https://exceldarbariki.mozello.lv/produkti/instrukcijas/"]
[null,"Kā atbloķēt makrosus:",null,"https://exceldarbariki.mozello.lv/produkti/ka-atbloket-makrosus/"]

{"sheet":"Datu pilnība","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,2,3,8],[1,2,1,5],[7,5,7,7],[7,3,7,4],[2,2,2,8]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,null,null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas D:G"]
[null,"Mērķis","Salīdzināt virsgrāmatu ar operācijas žurnālu un pārbaudīt datu pilnību",null,null,null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,{"$f":"ROUND(SUM(D9:D1048576),2)","v":0},0,0,0,0,0]
[]
[null,"Konts","Nosaukums","Virsgrāmatas saldo",null,"Operāciju žurnāla",null,null,"Beigu saldo","Skaidrojums"]
[null,null,null,"Sākumā","Beigās","Apgr.debets","Apgr.kredīts","Beigu saldo","starpība"]

{"sheet":"VG un iBanka","index":2,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,2,2,8],[3,2,3,8]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,null,null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas D:G"]
[null,"Mērķis","Salīdzināt virsgrāmatu ar bankas izdruku un pārbaudīt datu pilnību. ",null,null,null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,{"$f":"ROUND(SUM(D9:D1048576),2)","v":0},0,0,0,0,0]
[]
[null,"Konts","Nosaukums","BANKA","VG","Novirze","BANKA","VG","Novirze","Skaidrojums"]
[null,null,null,"Ienākošais","Debets",null,"Izejošais","Kredīts"]

{"sheet":"Dinamika konti","index":3,"n_rows":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,2,1,13],[2,2,2,16],[3,2,3,16],[8,4,8,15]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,null,null,null,null,null,null,null,null,null,null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas D:Q"]
[null,"Mērķis","Atlasīt kontu grāmatojumu dinamiku ar mērķi identificēt neparastas tendences.",null,null,null,null,null,null,null,null,null,null,null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,{"$f":"ROUND(SUM(D9:D1048576),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Konts","Nosaukums","Sākumā",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"DATE(YEAR(E8),MONTH(E8)+2,0)","v":"2025-02-28"},{"$f":"DATE(YEAR(F8),MONTH(F8)+2,0)","v":"2025-03-31"},"2025-04-30","2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","Beigās","Komentārs"]
[null,null,null,"Saldo","Apgrozījums",null,null,null,null,null,null,null,null,null,null,null,"Saldo"]

{"sheet":"Dinamika konti 18m","index":4,"n_rows":9,"n_cols":24,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,2,1,19],[2,2,2,22],[3,2,3,22],[8,4,8,21]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas D:W"]
[null,"Mērķis","Atlasīt kontu grāmatojumu dinamiku ar mērķi identificēt neparastas tendences.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,{"$f":"ROUND(SUM(D9:D1048576),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Konts","Nosaukums","Sākumā",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"DATE(YEAR(E8),MONTH(E8)+2,0)","v":"2025-02-28"},{"$f":"DATE(YEAR(F8),MONTH(F8)+2,0)","v":"2025-03-31"},"2025-04-30","2025-05-31","2025-06-30","2025-07-31",{"$f":"DATE(YEAR(K8),MONTH(K8)+2,0)","v":"2025-08-31"},{"$f":"DATE(YEAR(L8),MONTH(L8)+2,0)","v":"2025-09-30"},{"$f":"DATE(YEAR(M8),MONTH(M8)+2,0)","v":"2025-10-31"},{"$f":"DATE(YEAR(N8),MONTH(N8)+2,0)","v":"2025-11-30"},{"$f":"DATE(YEAR(O8),MONTH(O8)+2,0)","v":"2025-12-31"},{"$f":"DATE(YEAR(P8),MONTH(P8)+2,0)","v":"2026-01-31"},{"$f":"DATE(YEAR(Q8),MONTH(Q8)+2,0)","v":"2026-02-28"},{"$f":"DATE(YEAR(R8),MONTH(R8)+2,0)","v":"2026-03-31"},{"$f":"DATE(YEAR(S8),MONTH(S8)+2,0)","v":"2026-04-30"},{"$f":"DATE(YEAR(T8),MONTH(T8)+2,0)","v":"2026-05-31"},{"$f":"DATE(YEAR(U8),MONTH(U8)+2,0)","v":"2026-06-30"},"Beigās","Komentārs"]
[null,null,null,"Saldo","Apgrozījums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saldo"]

{"sheet":"Dinamika konti DK","index":5,"n_rows":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,13],[2,2,2,16],[3,2,3,16],[8,4,8,15]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,null,null,null,null,null,null,null,null,null,null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas D:Q"]
[null,"Mērķis","Atlasīt kontu grāmatojumu dinamiku ar mērķi identificēt neparastas tendences.",null,null,null,null,null,null,null,null,null,null,null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,{"$f":"ROUND(SUM(D9:D1048576),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Konts","Nosaukums","Sākumā",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"DATE(YEAR(E8),MONTH(E8)+2,0)","v":"2025-02-28"},{"$f":"DATE(YEAR(F8),MONTH(F8)+2,0)","v":"2025-03-31"},"2025-04-30","2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","Beigās","Komentārs"]
[null,null,null,"Saldo","Apgrozījums",null,null,null,null,null,null,null,null,null,null,null,"Saldo"]

{"sheet":"Dinamika konti DK 18m","index":6,"n_rows":9,"n_cols":24,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,2,1,19],[2,2,2,22],[3,2,3,22],[8,4,8,21]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas D:W"]
[null,"Mērķis","Atlasīt kontu grāmatojumu dinamiku ar mērķi identificēt neparastas tendences.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,{"$f":"ROUND(SUM(D9:D1048576),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Konts","Nosaukums","Sākumā",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"DATE(YEAR(E8),MONTH(E8)+2,0)","v":"2025-02-28"},{"$f":"DATE(YEAR(F8),MONTH(F8)+2,0)","v":"2025-03-31"},"2025-04-30","2025-05-31","2025-06-30","2025-07-31",{"$f":"DATE(YEAR(K8),MONTH(K8)+2,0)","v":"2025-08-31"},{"$f":"DATE(YEAR(L8),MONTH(L8)+2,0)","v":"2025-09-30"},{"$f":"DATE(YEAR(M8),MONTH(M8)+2,0)","v":"2025-10-31"},{"$f":"DATE(YEAR(N8),MONTH(N8)+2,0)","v":"2025-11-30"},{"$f":"DATE(YEAR(O8),MONTH(O8)+2,0)","v":"2025-12-31"},{"$f":"DATE(YEAR(P8),MONTH(P8)+2,0)","v":"2026-01-31"},{"$f":"DATE(YEAR(Q8),MONTH(Q8)+2,0)","v":"2026-02-28"},{"$f":"DATE(YEAR(R8),MONTH(R8)+2,0)","v":"2026-03-31"},{"$f":"DATE(YEAR(S8),MONTH(S8)+2,0)","v":"2026-04-30"},{"$f":"DATE(YEAR(T8),MONTH(T8)+2,0)","v":"2026-05-31"},{"$f":"DATE(YEAR(U8),MONTH(U8)+2,0)","v":"2026-06-30"},"Beigās","Komentārs"]
[null,null,null,"Saldo","Apgrozījums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saldo"]

{"sheet":"Dinamika konti klienti DK","index":7,"n_rows":9,"n_cols":17,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,2,2,15],[3,2,3,15],[8,4,8,15],[1,2,1,12]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,null,null,null,null,null,null,null,null,null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas D:Q"]
[null,"Mērķis","Atlasīt kontu grāmatojumu dinamiku ar mērķi identificēt neparastas tendences.",null,null,null,null,null,null,null,null,null,null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null,null,null,null,null,null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,null,{"$f":"ROUND(SUMIFS(E9:E1048576,$D$9:$D$1048576,\"<>\"\"\"),2)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Konts","Nosauk.","Klients",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"DATE(YEAR(E8),MONTH(E8)+2,0)","v":"2025-02-28"},{"$f":"DATE(YEAR(F8),MONTH(F8)+2,0)","v":"2025-03-31"},"2025-04-30","2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","Komentārs"]
[null,null,null,null,"Apgrozījums"]

{"sheet":"Dinamika konti klienti DK 18m","index":8,"n_rows":9,"n_cols":23,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,2,1,18],[2,2,2,21],[3,2,3,21],[8,4,8,21]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas E:V"]
[null,"Mērķis","Atlasīt kontu grāmatojumu dinamiku ar mērķi identificēt neparastas tendences.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,null,{"$f":"ROUND(SUMIFS(E9:E1048576,$D$9:$D$1048576,\"<>\"\"\"),2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Konts","Nosauk.","Klients",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"DATE(YEAR(E8),MONTH(E8)+2,0)","v":"2025-02-28"},{"$f":"DATE(YEAR(F8),MONTH(F8)+2,0)","v":"2025-03-31"},"2025-04-30","2025-05-31","2025-06-30",{"$f":"DATE(YEAR(J8),MONTH(J8)+2,0)","v":"2025-07-31"},{"$f":"DATE(YEAR(K8),MONTH(K8)+2,0)","v":"2025-08-31"},{"$f":"DATE(YEAR(L8),MONTH(L8)+2,0)","v":"2025-09-30"},{"$f":"DATE(YEAR(M8),MONTH(M8)+2,0)","v":"2025-10-31"},{"$f":"DATE(YEAR(N8),MONTH(N8)+2,0)","v":"2025-11-30"},{"$f":"DATE(YEAR(O8),MONTH(O8)+2,0)","v":"2025-12-31"},{"$f":"DATE(YEAR(P8),MONTH(P8)+2,0)","v":"2026-01-31"},{"$f":"DATE(YEAR(Q8),MONTH(Q8)+2,0)","v":"2026-02-28"},{"$f":"DATE(YEAR(R8),MONTH(R8)+2,0)","v":"2026-03-31"},{"$f":"DATE(YEAR(S8),MONTH(S8)+2,0)","v":"2026-04-30"},{"$f":"DATE(YEAR(T8),MONTH(T8)+2,0)","v":"2026-05-31"},{"$f":"DATE(YEAR(U8),MONTH(U8)+2,0)","v":"2026-06-30"},"Komentārs"]
[null,null,null,null,"Apgrozījums"]

{"sheet":"Klienti un konti","index":9,"n_rows":9,"n_cols":21,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,16],[2,2,2,19],[3,2,3,19],[8,7,8,18]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas H:T"]
[null,"Mērķis","Atlasīt klientu un kontu grāmatojumu dinamiku pa menešiem ar mērķi identificēt neparastas tendences.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,"Klienti -->","visi","visi","<-- Konti  |  Apraksts -->","nē"]
[]
[null,"Klienta","Klients","Konta","Konts","Nosaukums","Apraksts",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"DATE(YEAR(H8),MONTH(H8)+2,0)","v":"2025-02-28"},{"$f":"DATE(YEAR(I8),MONTH(I8)+2,0)","v":"2025-03-31"},"2025-04-30","2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","Kopā","Komentārs"]
[null,"tips",null,"tips",null,null,null,"Apgrozījums"]

{"sheet":"Klienti un konti 18m","index":10,"n_rows":9,"n_cols":27,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,2,1,22],[2,2,2,25],[3,2,3,25],[8,7,8,24]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas H:Z"]
[null,"Mērķis","Atlasīt klientu un kontu grāmatojumu dinamiku pa menešiem ar mērķi identificēt neparastas tendences.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,"Klienti -->","visi","visi","<-- Konti  |  Apraksts -->","nē"]
[]
[null,"Klienta","Klients","Konta","Konts","Nosaukums","Apraksts",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"DATE(YEAR(H8),MONTH(H8)+2,0)","v":"2025-02-28"},{"$f":"DATE(YEAR(I8),MONTH(I8)+2,0)","v":"2025-03-31"},"2025-04-30","2025-05-31","2025-06-30",{"$f":"DATE(YEAR(M8),MONTH(M8)+2,0)","v":"2025-07-31"},{"$f":"DATE(YEAR(N8),MONTH(N8)+2,0)","v":"2025-08-31"},{"$f":"DATE(YEAR(O8),MONTH(O8)+2,0)","v":"2025-09-30"},{"$f":"DATE(YEAR(P8),MONTH(P8)+2,0)","v":"2025-10-31"},{"$f":"DATE(YEAR(Q8),MONTH(Q8)+2,0)","v":"2025-11-30"},{"$f":"DATE(YEAR(R8),MONTH(R8)+2,0)","v":"2025-12-31"},{"$f":"DATE(YEAR(S8),MONTH(S8)+2,0)","v":"2026-01-31"},{"$f":"DATE(YEAR(T8),MONTH(T8)+2,0)","v":"2026-02-28"},{"$f":"DATE(YEAR(U8),MONTH(U8)+2,0)","v":"2026-03-31"},{"$f":"DATE(YEAR(V8),MONTH(V8)+2,0)","v":"2026-04-30"},{"$f":"DATE(YEAR(W8),MONTH(W8)+2,0)","v":"2026-05-31"},{"$f":"DATE(YEAR(X8),MONTH(X8)+2,0)","v":"2026-06-30"},"Kopā","Komentārs"]
[null,"tips",null,"tips",null,null,null,"Apgrozījums"]

{"sheet":"Kor.konti","index":11,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,4,7,5],[7,6,7,7],[1,2,1,5],[2,2,2,8],[3,2,3,8]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,null,null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas G:H"]
[null,"Mērķis","Atlasīt kontu grāmatojumu korespondences ar mērķi identificēt neparastas kombinācijas vai reti lietojamus grāmatojumus.",null,null,null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,null,null,null,{"$f":"ROUND(SUM(G9:G1048576),2)","v":0},{"$f":"ROUND(SUM(H9:H1048576),2)","v":0},{"$f":"ROUND(SUM(I9:I1048576),2)","v":0}]
[]
[null,"Konts","Nosaukums","Gram.","Korespondējošie konti",null,"Kor. konta apgrozījums",null,"Kombinac.","Komentārs"]
[null,null,null,"skaits","Konts","Nosaukums","Debets","Kredīts","skaits"]

{"sheet":"Lietotāji","index":12,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,2,1,3],[2,2,2,6],[3,2,3,6]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonna E"]
[null,"Mērķis","Identificēt aizdomīgus lietotājus, kas ir veikuši grāmatojumus.",null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,{"$f":"ROUND(SUM(D9:D1048576),2)","v":0},{"$f":"ROUND(SUM(E9:E1048576),2)","v":0}]
[]
[null,"Lietotājs","Izmantotie","Grām.","Grām.","Lietotāja","Pozīcija","Komentārs"]
[null,null,"konti","skaits","Summa","atšifrējums"]

{"sheet":"Apaļas summas","index":13,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,2,2,6],[3,2,3,6],[8,3,8,4],[7,3,7,4]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonna F"]
[null,"Mērķis","Identificē žurnālu ierakstus, kas beidzas ar \"*.97\" - \"*.99\" ",null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,null,null,{"$f":"ROUND(SUM(F9:F1048576),2)","v":0},1000,"<- Atlasīt transakcijas virs"]
[]
[null,"Konti","Apraksts","Klients",null,"Summa","Dok.","Komentārs"]
[null,"Debets/Kredīts",null,null,null,null,"datums"]

{"sheet":"Lielās summas","index":14,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,3],[3,2,3,6],[2,2,2,6],[8,3,8,4],[7,3,7,4]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonna F"]
[null,"Mērķis","Identificē transakcijas, kas lielākas par noteikto vērtību.",null,null,null,null," - virs Būtiskuma"]
[null,"Secinājums",null,null,null,null,null," - zem Būtiskuma, bet virs IB"]
[]
[null,null,null,null,null,{"$f":"ROUND(SUM(F9:F1048576),2)","v":0},1000,"<- Atlasīt transakcijas virs"]
[]
[null,"Konti","Apraksts","Klients",null,"Summa","Dok.","Komentārs"]
[null,"Debets/Kredīts",null,null,null,null,"datums"]

{"sheet":"Brīvdienas","index":15,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,2,2,6],[3,2,3,6],[7,5,7,7],[8,5,8,7]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonna A"]
[null,"Mērķis","Identificēt grāmatojumus, kas veikti brīvdienās un svētku dienās.",null,null,null,null," - Svētkudiena"]
[null,"Secinājums",null,null,null,null,null," - Brīvdiena"]
[]
[null,null,null,null,{"$f":"ROUND(SUM(E9:E1048576),2)","v":0}]
[]
[null,"Reģ.","Dok.","Konti","Summa","Klients",null,null,"Apraksts","Komentārs"]
[null,"datums","datums","Debets/Kredīts"]

{"sheet":"Pēc slēgšanas grāmatojumi","index":16,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,2,1,3],[2,2,2,6],[3,2,3,6],[8,4,8,5]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas A, H"]
[null,"Mērķis","Identificē grāmatojumus, kas ir veikti pēc VG slēgšanas datuma, vai reģistrēti gada pēdējos datumos.",null,null,null,null," - Svētkudiena"]
[null,"Secinājums",null,null,null,null,null," - Brīvdiena"]
[]
[null,null,"2024-01-01","<-VG slēgšanas (gram.) datums / gada pēdējie (dok.) datumi",null,null,{"$f":"ROUND(SUM(F9:F1048576),2)","v":0}]
[]
[null,"Reģ.","Konti","Klients","Apraksts",null,"Summa","Grām.","Komentārs"]
[null,"datums","Debets/Kredīts",null,null,null,null,"datums"]

{"sheet":"Ārpus perioda grāmatojumi","index":17,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,2,1,3],[2,2,2,6],[3,2,3,6],[8,4,8,5]]}
[]
[null,"Klients",{"$f":"Menu!$C$4&\" \"&Menu!$D$4","v":"SIA …"},null,"Periods",{"$f":"Menu!$D$9","v":"2025-01-01"},{"$f":"Menu!$E$9","v":"2025-12-31"},"Ja kolonnas A, G"]
[null,"Mērķis","Identificē grāmatojumus, kas ir par ārpus pārbaudes periodu",null,null,null,null," - Svētkudiena"]
[null,"Secinājums",null,null,null,null,null," - Brīvdiena"]
[]
[null,null,null,null,null,null,{"$f":"ROUND(SUM(G9:G1048576),2)","v":0}]
[]
[null,"Dok.","Konti","Klients","Apraksts",null,"Summa","Grām.","Komentārs"]
[null,"datums","Debets/Kredīts",null,null,null,null,"datums"]

{"sheet":"VG","index":18,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,6,2,6],[1,5,2,5],[1,4,2,4],[1,3,2,3],[1,8,2,8]]}
[]
[null,null,"VG izejas datu struktūra",{"$f":"SUM(INDIRECT(\"D6:D1048576\"))","v":0},{"$f":"SUM(INDIRECT(\"e6:e1048576\"))","v":0},{"$f":"SUM(INDIRECT(\"f6:f1048576\"))","v":0},{"$f":"SUM(INDIRECT(\"g6:g1048576\"))","v":0},null,"Datus var ielādēt manuāli - sakot ar 6-to rindu.\nVai automātiski, atbilstoši aprakstām komentārā pie šis šūnas."]
[null,null,"2 + 6 kolonnas"]
[]
[null,"Konts","Nosaukums",{"$f":"Menu!$D$9","v":"2025-01-01"},"Debeta \napgrozījums","Kredīta \napgrozījums",{"$f":"Menu!E9","v":"2025-12-31"}]

{"sheet":"iBanka","index":19,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,3,2,5],[4,2,4,3],[4,4,4,5]]}
[]
[null,null,null,"Datus var ielādēt manuāli - sakot ar 7-to rindu.\nVai automātiski, atbilstoši aprakstām komentārā pie šis šūnas."]
[]
[]
[null,"Npk.","Bankas izdruka",null,"Uzņēmuma",null,"Konta",null,null,null,null,null,"VG Konta"]
[null,".","Izveidota","Periods","Nosaukums","Reģ.ņr.","Numurs","Sākuma atl.","Ienākošais","Izejošais","Beigu atl.","Valūta","numurs"]

{"sheet":"OperZur","index":20,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,6,2,6],[1,3,2,5],[1,7,2,9],[1,11,2,17]]}
[]
[null,null,null,"Datus var ielādēt manuāli - \nsakot ar 6-to rindu.",null,null,"VAI","Automātiski, atbilstoši aprakstām komentārā pie šis šūnas.",null,null,null,"Katrai kolonnai 3. rindā jāizvēlas \"Pazīme\" no izkrītoša saraksta. \nVislabākie testa rezultāti būs ja izejas dati satur debeta un kredīta kontu 1 rindā."]

{"sheet":"OperZur2","index":21,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":true,"merged":[[1,3,2,5],[1,6,2,6],[1,7,2,9],[1,11,2,17]]}
[]
[null,null,null,"Datus var ielādēt manuāli - \nsakot ar 6-to rindu.",null,null,"VAI","Automātiski, atbilstoši aprakstām komentārā pie šis šūnas.",null,null,null,"Katrai kolonnai 3. rindā jāizvēlas \"Pazīme\" no izkrītoša saraksta. \nVislabākie testa rezultāti būs ja izejas dati satur debeta un kredīta kontu 1 rindā."]

{"sheet":"OperZur3","index":22,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":true,"merged":[[1,3,2,5],[1,6,2,6],[1,7,2,9],[1,11,2,17]]}
[]
[null,null,null,"Datus var ielādēt manuāli - \nsakot ar 6-to rindu.",null,null,"VAI","Automātiski, atbilstoši aprakstām komentārā pie šis šūnas.",null,null,null,"Katrai kolonnai 3. rindā jāizvēlas \"Pazīme\" no izkrītoša saraksta. \nVislabākie testa rezultāti būs ja izejas dati satur debeta un kredīta kontu 1 rindā."]

{"sheet":"OperZur4","index":23,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":true,"merged":[[1,3,2,5],[1,6,2,6],[1,7,2,9],[1,11,2,17]]}
[]
[null,null,null,"Datus var ielādēt manuāli - \nsakot ar 6-to rindu.",null,null,"VAI","Automātiski, atbilstoši aprakstām komentārā pie šis šūnas.",null,null,null,"Katrai kolonnai 3. rindā jāizvēlas \"Pazīme\" no izkrītoša saraksta. \nVislabākie testa rezultāti būs ja izejas dati satur debeta un kredīta kontu 1 rindā."]

{"sheet":"Format","index":24,"n_rows":66,"n_cols":26,"rows_kept":66,"cut":false,"hidden":true,"merged":[[16,3,16,4],[18,3,18,4],[12,5,12,7],[14,4,14,5]]}
["VG"]
[]
["HronoK2"]
[]
[]
["DatuPiln"]
[null,null,null,null,null,null,null,{"$f":"ROUND(D7+F7-G7,2)","v":0},{"$f":"ROUND(E7-H7,2)","v":0}]
["KorKonti"]
[]
["Lietotaji"]
[]
["Brivdienas"]
[]
["Pec sleg"]
[]
["Apalas"]
[]
["Lielas"]
[]
["Dinamika"]
[]
["KlKontDinamika"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H23:S23)","v":0}]
["HronK1"]
[]
[]
["DinamikaDK"]
[]
[]
["DinamikaDK"]
[]
[]
[]
[]
["DinamikaKlDK"]
[]
[]
[]
["DinamikaKlDK"]
[]
[]
[]
[]
["Vg_iBanka"]
[null,null,null,null,null,{"$f":"ROUND(D45-E45,0)","v":0},null,null,{"$f":"ROUND(G45-H45,0)","v":0}]
[]
["DataBanka"]
[]
[]
["Dinamika18m"]
[]
["KlKontDinamika18m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H53:Y53)","v":0}]
["DinamikaDK18m"]
[]
[]
["DinamikaDK18m"]
[]
[]
[]
[]
["DinamikaKlDK18m"]
[]
[]
[]
["DinamikaKlDK18m"]

{"sheet":"Tiesibas","index":25,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"DatumsNo","2025-09-09",null,null,"TisWbName","ThisWbCustId","RN","ActivationDate","CompName/Path","Processor/HddSerialId","PROCESSOR_REVISION","USERNAME"]
[null,null,null,"DatumsLidz","2025-09-20",null,null,"OZUR",1,25,"2020-09-09","-","-","-","-"]
[null,null,null,"Skaitītājs (demo versijai)"]
[]
[null,null,null,"ThisWbName","OZUR"]
[null,null,null,"ThisWbCustId",1]
[null,null,null,"Limenis","D"]
[]
[null,null,null,"Nesakonfigurētas tiesības!"]
[null,null,null,"Nesakonfigurētas tiesības versijai!"]
[null,null,null,"Versijas periods ir beidzies!"]
[null,null,null,"Versijas apstrādes uzņēmuma RegNr neatbilst definētam!"]
[null,null,null,"Izvelētais RegNr nav definēts šajā versijā!"]
[null,null,null,"Lūdzu aizpildiet reģistrācijas numuru!"]
[null,null,null,"Versijas Importa/Eksporta skaits sasniedza 20!"]
[null,null,null,"Lūdzu veikt faila aktivāciju uz lapas \"Instrukcija\"!"]
[null,null,null,"Fails jau ir aktivizēts šim datoram un lietotājam!"]