{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instrukcija","Izlase nr1","F. Ieņēmumi","F. Izdevumi","Tiesibas"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":15,"comments":1,"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":"Instrukcija","index":0,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,2,1,8],[2,3,2,8],[3,3,3,8]]}
[]
[null,"Apraksts:","https://exceldarbariki.mozello.lv/produkti/izlases/"]
[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/"]
[]
[null,"Nejauša izlase "]
[null,"Izmantojot Excel funkciju RandBetween – izlases diapazons ir no datu pirmās  līdz pēdējai rindai."]
[null,"Ar funkciju nejauši tiek izvelēta rinda, kas ir starp datu diapazona pirmo un pēdējo rindu."]
[null,"Un tā, kamēr tiks atlasīts nepieciešama darījumu kopsumma vai darījumu skaits (darījumu kopsumma nav uzradīta)."]
[null,"Ja funkcijas rezultātā izvēle būs uz iepriekš izvelēto rindu, tad tā atlase tiks atkārtota, kamēr netiks izvelēta rinda, kura iepriekš netika izvelēta. Tiek ignorētas visas rindas, kuras vērtība ir zemāka nekā darījuma minimāla summa"]
[]
[null,"Pēc paraugu ņemšanas intervāla "]
[null,"Izmantojot nepieciešamo darījumu skaitu, intervālu un minimālo darījuma summa, notiek atlase pēc algoritma"]
[null,"Izlases diapazons (rindas) no 20-as rindas + datuma numurs, kad tiek veikta izlase. Piemēram, ja izlases datums ir 2016.03.12, tad izlases pirmā rinda = 20 + 12 = 32."]
[null,"Izlases pēdēja rinda – ir pēdēja rinda ar datiem."]
[null,"Tālāk tiek veikta katra darījuma summēšana pēc kārtas līdz tam, kad tiks sasniegts uzradītais intervāls. Kad tas ir sasniegts, tas darījums tiek atlasīts pārbaudei. Darījumu skaitītājs tiek samazināts uz 1 un tā kamēr nepieciešamais darījumu skaits izlases nesasniegs 0."]
[null,"Tiek izslēgti visi darījumi, kuram summa ir lielāka nekā Izpildes Būtiskums."]
[null,"Ja izlases procesā tiks sasniegta datu pēdējā rinda, bet darījumu skaits nebūs vēl atlasīts, tad izlase sāksies no sākuma, bet ignorējot iepriekš atlasītos darījumus."]
[null,"Un tā kamēr tiks atlasīts nepieciešamais darījumu skaits. "]
[]
[null,"Pēc izpildes būtiskuma"]
[null,"Tiek atlasīti visi darījumi, kuru vērtība ir lielāka vai vienāda ar izpildes būtiskumu."]
[]
[null,"Ir iespējams veikt pamatizlasi un, ja nepieciešams, papildus izlasi."]
[null,"Izlases rezultāti netiek jaukti, tas nozīme kā darījumi no pamatizlases netiks izskatīti papildus izlasē.  "]
[null,"Pamata izlasei un papildus izlasei  atlases veikšanas algoritmi ir vienādi."]
[]
[null,"Ja izlases tips ir «Neatkarīgs», tad Neviena no izlases metodēm netiek jauktā, tādejādi neviens darījums nevar būt atlasīts pēc vairākām metodēm."]
[null,"Ja izlases tips ir «Jaukts», tad izlases metodēm netiek parbaidīts vai darijums jau tika izvelēts ar citu izlases metodi, tādejādi viens darījums var būt atlasīts pēc vairākām metodēm."]
[]
[null,"Eksportēt ar lapu - ļauj eksportēt izlases rezultātus ar 1 no definētam drukas formām. Ir iespējams aizvietot formas, kas ir pēc noklusējuma, ar savam formām."]
[]
[null,"Uz izlases lapas pie katra no izlases kritērija ir komentārs, kas paskaidro, ko tas nozīme un kurai no metodēm tas attiecas."]

{"sheet":"Izlase nr1","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,2,1],[4,1,5,3],[11,1,12,3],[18,1,18,2]]}
[]
[null,null,null,"Eksportēt ar lapu (F.*)","Risks","Info"]
[]
[]
[]
[]
[null,"Skaits","Skaits","Izpild. Būtisk. (EUR)"]
[]
[null,"MinDarSum(EUR)","Intervāls (EUR)","Izlases tips"]
[null,null,null,"Neatkarīgs"]
[]
[]
[]
[null,"Skaits","Skaits","Izpild. Būtisk. (EUR)"]
[]
[null,"MinDarSum(EUR)","Intervāls (EUR)","Izlases tips"]
[null,null,null,"Neatkarīgs"]
[]
[null,"Metodes",null,"Eksporta secība -->>"]
["*","RAN","PI","IB"]

{"sheet":"F. Ieņēmumi","index":2,"n_rows":117,"n_cols":15,"rows_kept":117,"cut":false,"hidden":false,"merged":[[98,14,98,15],[93,14,93,15],[94,14,94,15],[95,14,95,15],[96,14,96,15],[97,14,97,15],[88,14,88,15],[89,14,89,15],[90,14,90,15],[91,14,91,15],[92,14,92,15],[84,14,84,15],[85,14,85,15],[86,14,86,15],[87,14,87,15],[78,14,78,15],[79,14,79,15],[80,14,80,15],[81,14,81,15],[82,14,82,15],[75,14,75,15],[76,14,76,15],[77,14,77,15],[68,14,68,15],[69,14,69,15],[70,14,70,15],[71,14,71,15],[72,14,72,15],[83,14,83,15],[66,14,66,15],[67,14,67,15],[58,14,58,15],[59,14,59,15],[60,14,60,15],[61,14,61,15],[62,14,62,15],[73,14,73,15],[74,14,74,15],[107,14,107,15],[43,14,43,15],[44,14,44,15],[45,14,45,15],[46,14,46,15],[47,14,47,15],[38,14,38,15],[39,14,39,15],[40,14,40,15],[41,14,41,15],[42,14,42,15],[53,14,53,15],[54,14,54,15],[55,14,55,15],[56,14,56,15],[57,14,57,15],[48,14,48,15],[49,14,49,15],[50,14,50,15],[51,14,51,15],[52,14,52,15],[63,14,63,15],[64,14,64,15],[65,14,65,15],[1,8,2,12],[3,8,4,12],[7,12,7,14],[8,7,8,8],[7,11,11,11],[33,14,33,15],[34,14,34,15],[35,14,35,15],[36,14,36,15],[19,14,19,15],[20,14,20,15],[21,14,21,15],[22,14,22,15],[23,14,23,15],[24,14,24,15],[25,14,25,15],[26,14,26,15],[27,14,27,15],[28,14,28,15],[29,14,29,15],[30,14,30,15],[31,14,31,15],[32,14,32,15],[116,3,116,14],[18,1,18,15],[101,1,101,15],[17,14,17,15],[16,10,16,15],[103,14,103,15],[102,14,102,15],[104,14,104,15],[9,1,11,6],[9,7,9,8],[10,7,10,8],[12,1,13,6],[13,7,13,8],[14,7,14,8],[8,14,11,14],[8,13,11,13],[8,12,11,12],[108,14,108,15],[109,14,109,15],[37,14,37,15],[110,14,110,15],[111,14,111,15],[105,14,105,15],[106,14,106,15]]}
[]
[null,"Auditors: ",null,"SIA",null,null,null,null,"Postenis: Ieņēmumi un debitori"]
[null,"Klients: ",null,"SIA"]
[null,"Pārbaudīja:    ",null,null,"revīzijas grupas vadītāja",null,null,null,"Pārbaudītās izlases vienības protokols"]
[null,"Izpildīja:",null,null,"zvērinātā revidenta palīgs"]
[null,"Izpildes datums:"]
[]
[null,"Pārliecības pakāpei IZLASES vienības noteikšanas pamatojums",null,null,null,null,null,null,null,null,null,"Risku novērtējums","Minimālās izlases vienības skaits"]
[null,"1. Tiek pārbaudīti lielumi:  ",null,null,null,null,null,"Izpildes būtiskums",null,null,null,null,"Kopas kopējais skaits <200","Kopas kopējais skaits no 200 līdz 1000","Kopas kopējais skaits >1000"]
[null,"  a) visi lielumi, kuru vērtība pārsniedz izpildes būtiskumu (IB); \n  b) kurus nosaka dators pēc summas intervala sasniegšanas principa (PI);\n  c) kurus nejauši izvēlas dators (RAN).",null,null,null,null,null,"Kritērija vērtība"]
[null,null,null,null,null,null,null,"Kritērija skaits"]
[]
[null,"2. Ja tiek atklātas neatbilstības, tad jāpalielina izlases apjoms par 10 \nvienībām pēc profesionāla sprieduma un nejaušības principa.",null,null,null,null,null,null,null,null,null,"AR",40,50,60]
[null,null,null,null,null,null,null,"pārbaudītas kopas vērtība",null,{"$f":"I100","v":0},null,"VR",30,40,50]
[null,null,null,null,null,null,null,"pārbaudītas kopas īpatsvars",null,{"$f":"IFERROR(J14/J10,0)","v":0},null,"ZR",20,30,40]
[]
[null,null,null,null,null,null,null,null,null,null,"Kontroles"]
[null,"Nr.","Izvēles pama-tojums","Debeta konta \nNr.","Kredīta\nkonta \nNr. ","Rēķina Nr. ","Rēķina datums","Klienta nosaukums","Summa dokumentā \n(EUR) ","Summa sistēmā\n(EUR)","Starpība EUR (summa sistēmā - summa dokumen-tā)","Vai rēķins no abām pusēm parakstīts?","Vai dokumenta numurs un serija sakrīt?","Vai datums sakrīt?","Piezīmes"]
[null,"Īpašo posteņu izvēle"]
[null,1,null,null,null,null,null,null,null,{"$f":"I20","v":0},{"$f":"I20-J20","v":0},"Jā","Jā","Jā"]
[null,{"$f":"B20+1","v":2},null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,3,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,4,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,5,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,6,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,7,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,8,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,9,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,10,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,11,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,12,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,13,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,14,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,15,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,16,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,17,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,18,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,19,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,20,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,21,null,null,null,null,null,null,null,{"$f":"I40","v":0},{"$f":"I40-J40","v":0},"Jā","Jā","Jā"]
[null,22,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,23,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,24,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,25,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,26,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,27,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,28,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,29,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,30,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,31,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,32,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,33,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,34,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,35,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,36,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,37,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,38,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,39,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,40,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,41,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,42,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,43,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,44,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,45,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,46,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,47,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,48,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,49,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,50,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,51,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,52,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,53,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,54,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,55,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,56,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,57,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,58,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,59,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,60,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,61,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,62,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,63,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,64,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,65,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,66,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,67,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,68,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,69,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,70,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,71,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,72,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,73,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,74,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,75,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,76,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,77,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,78,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,79,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,80,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,"Kopā",null,null,null,null,null,null,{"$f":"SUM(I20:I99)","v":0},{"$f":"SUM(J20:J99)","v":0},{"$f":"SUM(K20:K99)","v":0}]
[]
[null,"Papildus darbs (gadījumā, ja bija konstatētas vai sagaidītas nesakritības un starpības)"]
[null,{"$f":"B99+1","v":81},null,null,null,null,null,null,null,{"$f":"I103","v":0},{"$f":"I103-J103","v":0},"Jā","Jā","Jā"]
[null,{"$f":"B103+1","v":82},null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,83,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,84,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,85,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,86,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,87,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,88,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,89,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,90,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,"Kopā",null,null,null,null,null,null,{"$f":"SUM(I103:I112)","v":0},{"$f":"SUM(J103:J112)","v":0},{"$f":"SUM(K103:K112)","v":0}]
[]
[null,"Pārbaudītās kopas lielums",null,null,null,null,null,null,{"$f":"I113+I100","v":0},{"$f":"J113+J100","v":0},{"$f":"K113+K100","v":0}]
[]
[null,null,null,"Secinājums: Izlases veidā pārbaudītās vienības atspoguļotas korekti, starpības netika konstatētas. Visi dokumenti iegrāmatoti pareizajā periodā un atbilst summām, kas iegrāmatotas. Var paļauties uz profesionālo spriedumu par izvēlēto testējamo vienību un izlases kopas pietiekamību un veiktās procedūras uzskatīt par pietiekošām revidenta secinājuma veikšanai. Pārbaudāmā kopa ir apstiprināta."]

{"sheet":"F. Izdevumi","index":3,"n_rows":117,"n_cols":15,"rows_kept":117,"cut":false,"hidden":false,"merged":[[110,14,110,15],[111,14,111,15],[116,3,116,14],[104,14,104,15],[105,14,105,15],[106,14,106,15],[107,14,107,15],[108,14,108,15],[109,14,109,15],[96,14,96,15],[97,14,97,15],[98,14,98,15],[101,1,101,15],[102,14,102,15],[103,14,103,15],[90,14,90,15],[91,14,91,15],[92,14,92,15],[93,14,93,15],[94,14,94,15],[95,14,95,15],[84,14,84,15],[85,14,85,15],[86,14,86,15],[87,14,87,15],[88,14,88,15],[89,14,89,15],[78,14,78,15],[79,14,79,15],[80,14,80,15],[81,14,81,15],[82,14,82,15],[83,14,83,15],[72,14,72,15],[73,14,73,15],[74,14,74,15],[75,14,75,15],[76,14,76,15],[77,14,77,15],[66,14,66,15],[67,14,67,15],[68,14,68,15],[69,14,69,15],[70,14,70,15],[71,14,71,15],[60,14,60,15],[61,14,61,15],[62,14,62,15],[63,14,63,15],[64,14,64,15],[65,14,65,15],[54,14,54,15],[55,14,55,15],[56,14,56,15],[57,14,57,15],[58,14,58,15],[59,14,59,15],[48,14,48,15],[49,14,49,15],[50,14,50,15],[51,14,51,15],[52,14,52,15],[53,14,53,15],[42,14,42,15],[43,14,43,15],[44,14,44,15],[45,14,45,15],[46,14,46,15],[47,14,47,15],[36,14,36,15],[37,14,37,15],[38,14,38,15],[39,14,39,15],[40,14,40,15],[41,14,41,15],[30,14,30,15],[31,14,31,15],[32,14,32,15],[33,14,33,15],[34,14,34,15],[35,14,35,15],[16,10,16,15],[17,14,17,15],[24,14,24,15],[25,14,25,15],[26,14,26,15],[27,14,27,15],[28,14,28,15],[29,14,29,15],[18,1,18,15],[19,14,19,15],[20,14,20,15],[21,14,21,15],[22,14,22,15],[23,14,23,15],[1,8,2,12],[3,8,4,12],[14,7,14,8],[13,7,13,8],[10,7,10,8],[9,7,9,8],[8,7,8,8],[12,1,13,6],[9,1,11,6],[7,11,11,11],[7,12,7,14],[8,12,11,12],[8,13,11,13],[8,14,11,14]]}
[]
[null,"Auditors: ",null,"SIA",null,null,null,null,"Postenis: Izdevumi un kreditori"]
[null,"Klients: ",null,"SIA"]
[null,"Pārbaudīja:    ",null,null,"revīzijas grupas vadītāja",null,null,null,"Pārbaudītās izlases vienības protokols"]
[null,"Izpildīja:",null,null,"zvērinātā revidenta palīgs"]
[null,"Izpildes datums:"]
[]
[null,"Pārliecības pakāpei IZLASES vienības noteikšanas pamatojums",null,null,null,null,null,null,null,null,null,"Risku novērtējums","Minimālās izlases vienības skaits"]
[null,"1. Tiek pārbaudīti lielumi:  ",null,null,null,null,null,"Izpildes būtiskums",null,null,null,null,"Kopas kopējais skaits <200","Kopas kopējais skaits no 200 līdz 1000","Kopas kopējais skaits >1000"]
[null,"  a) visi lielumi, kuru vērtība pārsniedz izpildes būtiskumu (IB); \n  b) kurus nosaka dators pēc summas intervala sasniegšanas principa (PI);\n  c) kurus nejauši izvēlas dators (RAN).",null,null,null,null,null,"Kritērija vērtība"]
[null,null,null,null,null,null,null,"Kritērija skaits"]
[]
[null,"2. Ja tiek atklātas neatbilstības, tad jāpalielina izlases apjoms par 10 \nvienībām pēc profesionāla sprieduma un nejaušības principa.",null,null,null,null,null,null,null,null,null,"AR",40,50,60]
[null,null,null,null,null,null,null,"pārbaudītas kopas vērtība",null,{"$f":"I100","v":0},null,"VR",30,40,50]
[null,null,null,null,null,null,null,"pārbaudītas kopas īpatsvars",null,{"$f":"IFERROR(J14/J10,0)","v":0},null,"ZR",20,30,40]
[]
[null,null,null,null,null,null,null,null,null,null,"Kontroles"]
[null,"Nr.","Izvēles pama-tojums","Debeta konta \nNr.","Kredīta\nkonta \nNr. ","Rēķina Nr. ","Rēķina datums","Klienta nosaukums","Summa dokumentā \n(EUR) ","Summa sistēmā\n(EUR)","Starpība EUR (summa sistēmā - summa dokumen-tā)","Vai rēķins no abām pusēm parakstīts?","Vai dokumenta numurs un serija sakrīt?","Vai datums sakrīt?","Piezīmes"]
[null,"Īpašo posteņu izvēle"]
[null,1,null,null,null,null,null,null,null,{"$f":"I20","v":0},{"$f":"I20-J20","v":0},"Jā","Jā","Jā"]
[null,{"$f":"B20+1","v":2},null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,3,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,4,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,5,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,6,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,7,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,8,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,9,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,10,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,11,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,12,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,13,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,14,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,15,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,16,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,17,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,18,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,19,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,20,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,21,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,22,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,23,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,24,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,25,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,26,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,27,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,28,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,29,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,30,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,31,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,32,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,33,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,34,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,35,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,36,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,37,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,38,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,39,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,40,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,41,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,42,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,43,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,44,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,45,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,46,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,47,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,48,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,49,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,50,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,51,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,52,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,53,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,54,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,55,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,56,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,57,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,58,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,59,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,60,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,61,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,62,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,63,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,64,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,65,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,{"$f":"B84+1","v":66},null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,67,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,68,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,69,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,70,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,71,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,72,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,73,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,74,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,75,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,76,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,77,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,78,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,79,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,80,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,"Kopā",null,null,null,null,null,null,{"$f":"SUM(I20:I99)","v":0},{"$f":"SUM(J20:J99)","v":0},{"$f":"SUM(K20:K99)","v":0}]
[]
[null,"Papildus darbs (gadījumā, ja bija konstatētas vai sagaidītas nesakritības un starpības)"]
[null,{"$f":"B99+1","v":81},null,null,null,null,null,null,null,{"$f":"I103","v":0},{"$f":"I103-J103","v":0},"Jā","Jā","Jā"]
[null,{"$f":"B103+1","v":82},null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,83,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,84,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,85,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,86,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,87,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,88,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,89,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,90,null,null,null,null,null,null,null,0,0,"Jā","Jā","Jā"]
[null,"Kopā",null,null,null,null,null,null,{"$f":"SUM(I103:I112)","v":0},{"$f":"SUM(J103:J112)","v":0},{"$f":"SUM(K103:K112)","v":0}]
[]
[null,"Pārbaudītās kopas lielums",null,null,null,null,null,null,{"$f":"I113+I100","v":0},{"$f":"J113+J100","v":0},{"$f":"K113+K100","v":0}]
[]
[null,null,null,"Secinājums: Izlases veidā pārbaudītās vienības atspoguļotas korekti, starpības netika konstatētas. Visi dokumenti iegrāmatoti pareizajā periodā un atbilst summām, kas iegrāmatotas. Var paļauties uz profesionālo spriedumu par izvēlēto testējamo vienību un izlases kopas pietiekamību un veiktās procedūras uzskatīt par pietiekošām revidenta secinājuma veikšanai. Pārbaudāmā kopa ir apstiprināta."]

{"sheet":"Tiesibas","index":4,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"DatumsNo","2025-05-05",null,null,"TisWbName","ThisWbCustId","RN","ActivationDate","CompName/Path","Processor/HddSerialId","PROCESSOR_REVISION","USERNAME"]
[null,null,null,"DatumsLidz","2025-05-15",null,null,"IZLAS",1,24,"2020-09-09","-","-","-","-"]
[null,null,null,"Skaitītājs (demo versijai)"]
[]
[null,null,null,"ThisWbName","IZLAS"]
[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!"]