{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instruction","MySaldo Partners","MySaldo Documents","Tiesibas","Format"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":14,"comments":2,"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":"Instruction","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,2,1,8],[2,3,2,8],[3,3,3,8],[8,2,8,3],[9,2,9,3]]}
[]
[]
[null,"How to enable macro:",null,"https://exceldarbariki.mozello.lv/produkti/instrukcijas/"]
[null,"How unblock macro:",null,"https://exceldarbariki.mozello.lv/produkti/ka-atbloket-makrosus/"]
[]
[]
[]
[]
[null,{"$f":"MID(1/10,2,1)","v":"."},"Decimal separator"]
[null,null,"Thousand separator"]

{"sheet":"MySaldo Partners","index":1,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,4,1,5]]}
[]
[null,"Sender",null,null,"Reconciliation",null,"Total "]
[null,"Reg.num.","Organisation name","Country","Ccy","Date","d.Amount","k.Amount","p.d.Amount","p.k.Amount","d.Balance","k.Balance"]
[null,null,null,null,null,null,{"$f":"SUM(G6:G1048576)","v":0},0,0,0,0,0]
[]
[null,"Reg.num.","Organisation name","Country","Ccy","Legal pers.","d.Amount","k.Amount","p.d.Amount","p.k.Amount","d.Balance","k.Balance","Address","e-Mail","Notes","Notes2"]

{"sheet":"MySaldo Documents","index":2,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,2,1,7],[1,8,1,11]]}
[]
[null,"Partner","Document",null,null,null,null,null,"Unpaid documents"]
[null,"Reg.num.","Date","Type","Number","Ccy","Due date","Amount","d.Amount","d.Amount a.v.","k.Amount","k.Amount a.v"]

{"sheet":"Tiesibas","index":3,"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,"MYSAL",1,25,"2020-09-09","-","-","-","-"]
[null,null,null,"Skaitītājs (demo versijai)"]
[]
[null,null,null,"ThisWbName","MYSAL"]
[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!"]

{"sheet":"Format","index":4,"n_rows":2,"n_cols":17,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,{"$f":"SUMIFS('MySaldo Documents'!J:J,'MySaldo Documents'!$B:$B,$B2)","v":0},{"$f":"SUMIFS('MySaldo Documents'!L:L,'MySaldo Documents'!$B:$B,$B2)","v":0},null,null,{"$f":"IF(ABS(SUM(G2,I2))-ABS(SUM(H2,J2))>0,SUM(G2,I2),0)","v":0},{"$f":"IF(ABS(SUM(H2,J2))-ABS(SUM(G2,I2))>0,SUM(H2,J2),0)","v":0},null,null,null,null," "]