{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Decode","Instrukcija","Preces","Iestādes","Transports","eRēķins","Rēķins","Tiesibas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":16,"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":"Decode","index":0,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Kods","Lv"]
["tris","trīs"]
["cetri","četri"]
["sesi","seši"]
["septini","septiņi"]
["astoni","astoņi"]
["devini","deviņi"]
["trispadsmit","trīspadsmit"]
["cetrpadsmit","četrpadsmit"]
["sespadsmit","sešpadsmit"]
["septinpadsmit","septiņpadsmit"]
["astonpadsmit","astoņpadsmit"]
["devinpadsmit","deviņpadsmit"]
["devinpadsmit","deviņpadsmit"]
["trisdesmit","trīsdesmit"]
["cetrdesmit","četrdesmit"]
["sesdesmit","sešdesmit"]
["septindesmit","septiņdesmit"]
["astondesmit","astoņdesmit"]
["devindesmit","deviņdesmit"]
["tukstotis","tūkstotis"]
["tukstosi","tūkstoši"]

{"sheet":"Instrukcija","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,2,1,8],[2,3,2,8],[3,3,3,8]]}
[]
[]
[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":"Preces","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[" Nr.p.k.","Preces nosaukums","EUR bez PVN"]
[1,"...",1.7]
[2,"...",2]

{"sheet":"Iestādes","index":3,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Nr.p.k.","Iestāde","Adrese","Kontaktpersona","Tālrunis","e-pasts"]
[1,"Pašvaldības ...","...","...","...","..."]
[2,"... vidusskola","...","...","...","..."]

{"sheet":"Transports","index":4,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Nr.p.k.","Transports","Vadītājs"]
[1,"...","..."]
[2,"-","-"]
[3]
[4]

{"sheet":"eRēķins","index":5,"n_rows":67,"n_cols":21,"rows_kept":67,"cut":false,"hidden":false,"merged":[[49,2,49,3],[50,2,50,3],[51,2,51,3],[52,2,52,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[6,6,6,8],[6,13,7,13],[6,17,6,18],[7,6,7,8],[1,20,13,22],[7,17,7,18],[8,6,8,8],[8,17,8,18],[1,17,1,18],[2,17,2,18],[3,1,3,8],[5,6,5,8],[5,17,5,18],[10,1,10,2],[10,3,10,4],[10,6,10,8],[10,17,10,18],[11,1,11,2],[11,3,11,4],[11,6,11,8],[11,13,12,13],[11,17,11,18],[12,1,12,2],[12,3,12,4],[12,6,12,8],[12,17,12,18],[18,6,18,8],[13,6,13,8],[13,17,13,18],[14,1,15,2],[14,3,15,4],[14,5,15,6],[14,7,15,8],[16,1,17,2],[16,3,17,4],[16,5,17,5],[16,6,17,8],[16,13,17,17],[29,2,29,3],[19,4,19,5],[19,6,19,8],[20,1,20,2],[21,4,21,6],[21,7,21,8],[23,4,23,8],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[56,1,56,3],[57,4,57,7],[59,3,59,8],[66,1,66,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[53,2,53,3],[54,2,54,3],[55,1,55,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3]]}
[]
[null,null,null,null,null,null,"PAVADZĪME ","MKZ 000001",null,null,null,null,"[Rekina numurs]:",{"$f":"H2","v":"MKZ 000001"},null,null,"[Rekina datums]:",{"$f":"B4","v":"2025-05-05"},null,null,"Kolonnās M:N ir salikta informācija ar formulām no pamata rēķina. Pamatojoties uz šo diapazonu, tiks izveidots e-rēķins XML, kuru var augšupielādēt latvija.lv, rakstot jaunu vēstuli un izvēloties veidlapu \"e-rēķins\".\nJa nepieciešams, šī diapazona formulas var palabot, piemēram \"Piezīmes\" lai būtu atspoguļota aktuāla informācija."]
[null,null,null,null,null,null,null,null,null,null,null,null,"[Atsauce uz ligumu]:",{"$f":"D21","v":"Līguma Nr. .../2024/5"},null,null,"[Samaksas termins]:",{"$f":"H22","v":"2025-05-20"}]
[null,{"$f":"TODAY()","v":"2025-05-05"}]
[]
[null,"Piegādātājs",null,"SIA ...",null,"Reģ. Nr.","...",null,null,null,null,null,"[Piegadatajs]:",{"$f":"D6","v":"SIA ..."},null,null,"[Reg. Nr.1]:",{"$f":"G6","v":"..."}]
[null,"Juridiskā adrese",null,"...",null,"PVN Nr.","...",null,null,null,null,null,"[Jur. adrese1]:",{"$f":"D7","v":"..."},null,null,"[PVN Nr.1]:",{"$f":"G7","v":"..."}]
[null,"Kredītiestādes nosaukums",null,"...",null,"Kods","...",null,null,null,null,null,null,null,null,null,"[Valsts kods1]:",{"$f":"LEFT(R7,2)","v":".."}]
[null,"Preču izsniegšanas adrese",null,"...",null,"konta Nr.","...",null,null,null,null,null,"[Bankas konts1]:",{"$f":"G9","v":"..."},null,null,"[Bankas kods1]:",{"$f":"G8","v":"..."}]
[]
[null,"Maksātājs",null,"... pašvaldība",null,"Reģ. Nr.","...",null,null,null,null,null,"[Pasutitajs]:",{"$f":"D11","v":"... pašvaldība"},null,null,"[Reg. Nr.2]:",{"$f":"G11","v":"..."}]
[null,"Juridiskā adrese",null,"...",null,"PVN Nr.","...",null,null,null,null,null,"[Jur. adrese2]:",{"$f":"D12","v":"..."},null,null,"[PVN Nr.2]:",{"$f":"G12","v":"..."}]
[null,"Faktiskā adrese",null,{"$f":"D12","v":"..."},null,"Kods","...",null,null,null,null,null,null,null,null,null,"[Valsts kods2]:",{"$f":"LEFT(R12,2)","v":".."}]
[null,"Kredītiestādes nosaukums",null,"....",null,"konta Nr.","...",null,null,null,null,null,"[Bankas konts2]:",{"$f":"G14","v":"..."},null,null,"[Bankas kods2]:",{"$f":"G13","v":"..."}]
[null,"Preču saņēmējs",null,null,null,"Kontaktpersona:",null,{"$f":"IFERROR(VLOOKUP(D15,Iestādes!B2:D3,3,0),\"- - -\")","v":"- - -"}]
[]
[null,"Preču saņemšanas adrese",null,{"$f":"IFERROR(VLOOKUP(D15,Iestādes!B2:C3,2,0),\"- - -\")","v":"- - -"},null,"E-pasts:",{"$f":"IFERROR(VLOOKUP(D15,Iestādes!B2:F3,5,0),\"- - -\")","v":"- - -"},null,null,null,null,null,"[Piezimes]:",{"$f":"B15&\": \"&D15&CHAR(10)&F15&\" \"&H15& \"; \"&F17&\" \"&G17","v":"Preču saņēmējs: \nKontaktpersona: - - -; E-pasts: - - -"}]
[]
[null,"Preču pārvadātājs"]
[null,"Transportlīdzekļa valsts Nr.",null,"-","Autovadītājs",null,{"$f":"VLOOKUP(D20,Transports!B2:C3,2,0)","v":"-"}]
[null,"Piezīmes",null,"Līguma Nr. .../2024/5"]
[null,"Maksājuma veids:",null,"Pārskaitījums"," Apmaksas termiņš:",null,null,{"$f":"B4+15","v":"2025-05-20"}]
[]
[]
[null,"Nr.","Nosaukums",null,"Mērv.","Daudz.","Cena","Atlaide","Summa",null,null,null,"[Nr.]:","[Nosaukums]:","[Daudz.]:","[Mērv.]:","[Cena]:","[Atlaide]:","[Summa]:"]
[null,"1.","...",null,"gab.",11,2.2999999999999998,null,{"$f":"IFERROR((F26*G26)*(1-H26), \"\")","v":25.299999999999997},null,null,null,1,{"$f":"IF(O26=\"\",\"\",C26)","v":"..."},{"$f":"IF(ROUND(F26,2)=0,\"\",ROUND(F26,2))","v":11},{"$f":"IF(O26=\"\",\"\",E26)","v":"gab."},{"$f":"IF(O26=\"\",\"\",G26)","v":2.2999999999999998},{"$f":"IF(O26=\"\",\"\",ROUND(F26*G26*H26,2))","v":0},{"$f":"IF(O26=\"\",\"\",ROUND(O26*Q26,2)-R26)","v":25.3}]
[null,"2.","...",null,"gab.",3,1.7,null,{"$f":"IFERROR((F27*G27)*(1-H27), \"\")","v":5.0999999999999996},null,null,null,2,{"$f":"IF(O27=\"\",\"\",C27)","v":"..."},{"$f":"IF(ROUND(F27,2)=0,\"\",ROUND(F27,2))","v":3},{"$f":"IF(O27=\"\",\"\",E27)","v":"gab."},{"$f":"IF(O27=\"\",\"\",G27)","v":1.7},{"$f":"IF(O27=\"\",\"\",ROUND(F27*G27*H27,2))","v":0},{"$f":"IF(O27=\"\",\"\",ROUND(O27*Q27,2)-R27)","v":5.0999999999999996}]
[null,"3.","...",null,"gab.",1,10,0.1,9,null,null,null,3,"...",1,"gab.",10,1,9]
[null,"4.","...",null,"gab.",1,2,0.1,1.8,null,null,null,4,"...",1,"gab.",2,0.2,1.8]
[null,"5.","...",null,"gab.",10,4.5,null,45,null,null,null,5,"...",10,"gab.",4.5,0,45]
[null,"6.","...",null,"gab.",10,2,0.1,18,null,null,null,6,"...",10,"gab.",2,2,18]
[null,"7.","...",null,"gab.",2,4.5,null,9,null,null,null,7,"...",2,"gab.",4.5,0,9]
[null,"8.","...",null,"gab.",2,4.5,0.1,8.1,null,null,null,8,"...",2,"gab.",4.5,0.9,8.1]
[null,"9.","...",null,"gab.",1,18,0.1,{"$f":"IFERROR((F34*G34)*(1-H34), \"\")","v":16.2},null,null,null,9,{"$f":"IF(O34=\"\",\"\",C34)","v":"..."},{"$f":"IF(ROUND(F34,2)=0,\"\",ROUND(F34,2))","v":1},{"$f":"IF(O34=\"\",\"\",E34)","v":"gab."},{"$f":"IF(O34=\"\",\"\",G34)","v":18},{"$f":"IF(O34=\"\",\"\",ROUND(F34*G34*H34,2))","v":1.8},{"$f":"IF(O34=\"\",\"\",ROUND(O34*Q34,2)-R34)","v":16.2}]
[null,"10.","...",null,"gab.",3,2.7,null,8.1000000000000014,null,null,null,10,"...",3,"gab.",2.7,0,8.1]
[null,"11.","...",null,"gab.",9,2.7,null,24.3,null,null,null,11,"...",9,"gab.",2.7,0,24.3]
[null,"12.","...",null,"gab.",5,2.7,null,13.5,null,null,null,12,"...",5,"gab.",2.7,0,13.5]
[null,"13.","...",null,"gab.",3,1.7,null,5.0999999999999996,null,null,null,13,"...",3,"gab.",1.7,0,5.0999999999999996]
[null,"14.","...",null,"gab.",5,4.5,null,22.5,null,null,null,14,"...",5,"gab.",4.5,0,22.5]
[null,"15.","...",null,"gab.",5,3.5,0.1,15.75,null,null,null,15,"...",5,"gab.",3.5,1.75,15.75]
[null,"16.","...",null,"gab.",6,2.7,null,16.200000000000003,null,null,null,16,"...",6,"gab.",2.7,0,16.2]
[null,"17.","...",null,"gab.",4,4.5,null,18,null,null,null,17,"...",4,"gab.",4.5,0,18]
[null,"18.","...",null,"gab.",2,3.5,0.1,6.3,null,null,null,18,"...",2,"gab.",3.5,0.7,6.3]
[null,"19.","...",null,"gab.",12,2.7,null,32.400000000000006,null,null,null,19,"...",12,"gab.",2.7,0,32.4]
[null,"20.","...",null,"gab.",6,2.7,null,16.200000000000003,null,null,null,20,"...",6,"gab.",2.7,0,16.2]
[null,"21.","...",null,"gab.",2,4.5,null,9,null,null,null,21,"...",2,"gab.",4.5,0,9]
[null,"22.","...",null,"gab.",2,3.5,0.1,6.3,null,null,null,22,"...",2,"gab.",3.5,0.7,6.3]
[null,"23.","...",null,"gab.",8,2.7,null,21.6,null,null,null,23,"...",8,"gab.",2.7,0,21.6]
[null,"24.","...",null,"gab.",7,2.7,null,18.900000000000002,null,null,null,24,"...",7,"gab.",2.7,0,18.899999999999999]
[null,"25.","...",null,"gab.",20,2.7,null,54,null,null,null,25,"...",20,"gab.",2.7,0,54]
[null,"26.","...",null,"gab.",30,3,null,90,null,null,null,26,"...",30,"gab.",3,0,90]
[null,"27.","...",null,"gab.",16,2.7,null,43.2,null,null,null,27,"...",16,"gab.",2.7,0,43.2]
[null,null,null,null,"gab.",null,{"$f":"IFERROR(VLOOKUP(D53,Preces!B4:C10,2,FALSE), \"\")","v":""},null,"",null,null,null,28,"","","","","",""]
[null,null,null,null,"gab.",null,{"$f":"IFERROR(VLOOKUP(D54,Preces!B4:C11,2,FALSE), \"\")","v":""},null,"",null,null,null,29,"","","","","",""]
[null,null,null,null,"gab.",null,{"$f":"IFERROR(VLOOKUP(D55,Preces!B4:C12,2,FALSE), \"\")","v":""},null,"",null,null,null,30,"","","","","",""]
[null,"Kopā izsniegts",null,null,"-",{"$f":"SUM(F26:F55)","v":186},"-",null,{"$f":"SUM(I26:I55)","v":558.85}]
[null,"Pievienotās vērtības nodoklis",null,null,0.21,null,null,"summa",{"$f":"SUMPRODUCT(IFERROR(ROUND(($I$26:$I$55)*$E$57,2),0))","v":117.35},null,null,null,null,null,null,null,null,"[SummaK]:",{"$f":"SUM(S26:S55)","v":558.84999999999991}]
[null,null,null,null,"KOPĀ APMAKSAS SUMMA EUR: ",null,null,null,{"$f":"I56+I57","v":676.2},null,null,null,null,null,null,null,null,"[PVN%]:",{"$f":"$E$57*100","v":21}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[PVNK]:",{"$f":"SUMPRODUCT(IFERROR(ROUND($S$26:$S$55*$S$58/100,2),0))","v":117.35}]
[null,"(ar vārdiem)",null,{"$f":"SummaVardiem(I58)","v":"Seši simti septiņdesmit seši eiro, 20 centi"},null,null,null,null,null,null,null,null,null,null,null,null,null,"[Kopa]:",{"$f":"SUM(S57,S59)","v":676.19999999999993}]
[]
[]
[]
[]
[]
[]
[null,"Rēķins ir sagatavots elektroniski un ir derīgs bez paraksta"]

{"sheet":"Rēķins","index":6,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":true,"merged":[[10,3,10,4],[10,6,10,7],[3,1,3,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[8,6,8,7],[23,2,23,3],[11,1,11,2],[11,3,11,4],[12,6,12,7],[14,6,14,7],[15,6,15,7],[17,6,17,7],[18,4,18,5],[18,6,18,7],[19,1,19,2],[20,4,20,6],[22,4,22,7],[24,2,24,3],[25,1,25,3],[26,1,26,3],[28,3,28,7],[35,1,35,3]]}
[]
[null," ",null,null,null,null,"PAVADZĪME ","MZ 005210"]
[]
[null,"2024.gada 4.martā"]
[]
[null,"Piegādātājs",null,"SIA Mārupes Zieds",null,"Reģ. Nr.",40003177615]
[null,"Juridiskā adrese",null,"Marsa gatve 10-10, Rīga, LV-1082",null,"PVN Nr.","LV40003177615"]
[null,"Kredītiestādes nosaukums",null,"A/S \"Swedbank\"",null,"Kods","HABALV22"]
[null,"Preču izsniegšanas adrese",null,"Mazā Pils iela 15, Rīga, LV-1050",null,"konta Nr.","LV18HABA0001408037447"]
[]
[null,"Maksatājs",null,"Ropažu novada pašvaldība",null,"Reģ. Nr.",90000067986]
[null,"Preču saņēmējs",null,"Upesleju sākumskola"]
[null,"Juridiskā adrese",null,"Institūta iela 1A, Ulbroka, Stopiņu pag., Ropažu nov., LV-2130",null,"PVN Nr.","LV90000067986"]
[null,"Faktiskā adrese",null,{"$f":"D13","v":"Institūta iela 1A, Ulbroka, Stopiņu pag., Ropažu nov., LV-2130"}]
[null,"Kredītiestādes nosaukums",null,"AS “SEB banka”",null,"Kods","UNLALV2X"]
[null,"Preču saņemšanas adrese",null,"Skolas iela 12, Upeslejas, Stopiņu pagasts, Ropažu novads, LV-2118",null,"konta Nr.","LV79UNLA0033300130908"]
[]
[null,"Preču pārvadātājs"]
[null,"Transportlīdzekļa valsts Nr.",null,"ZE40","Autovadītājs",null,"Elita Bērziņa"]
[null,"Piezīmes",null,"Līguma Nr. 12.1/2024/5"]
[null,"Maksājuma veids:",null,"Pārskaitījums"," Apmaksas termiņš:",null,null,"19.03.2024."]
[]
[]
[null,"Nr.","Nosaukums",null,"Mērv.","Daudz.","Cena","Summa"]
[null,"1.","28.02.2024 Rozes 40 cm.",null,"gab.",5,1.7,{"$f":"F25*G25","v":8.5}]
[null,"Kopā izsniegts",null,null,"X",1,"X",8.5]
[null,"Pievienotās vērtības nodoklis",null,null,0.21,null,"summa",{"$f":"H26*E27","v":1.7849999999999999}]
[null,null,null,null,"KOPĀ APMAKSAS SUMMA EUR: ",null,null,{"$f":"H26+H27","v":10.285}]
[null,"(ar vārdiem)",null,"Astoņdesmit četri euro un 70 centi"]
[]
[null,"Izsniedza: ",null,null,"Pieņēma:"]
[null,"vārds, uzvārds          ",null,null,"vārds, uzvārds ___________________________"]
[null,{"$f":"B4","v":"2024.gada 4.martā"},null,null,{"$f":"B33","v":"2024.gada 4.martā"}]
[]
[null,"Paraksts",null,null,"Paraksts"]
[null,"Rēķins ir sagatavots elektroniski un ir derīgs bez paraksta"]

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