{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Ievads","Bilance un Finanšu prognoze","Naudas plūsma 1. gads","Naudas plūsma 2. gads"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":5,"comments":0,"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":"Ievads","index":0,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[70,3,70,16],[60,3,60,16],[61,4,61,16],[63,4,63,16],[65,3,65,16],[68,4,68,16],[66,4,66,16],[67,4,67,16],[9,3,9,16],[13,3,13,16],[11,3,11,16],[21,3,21,8],[22,3,22,8],[20,9,21,14],[6,1,6,16],[71,4,71,16],[72,4,72,16],[28,3,28,16],[29,3,29,16],[62,4,62,16],[54,4,54,16],[55,4,55,16],[56,4,56,16],[47,3,47,16],[48,4,48,16],[51,4,51,16],[53,3,53,16],[58,3,58,16],[49,5,49,16],[50,5,50,16]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FINANŠU INFORMĀCIJA (JP)"]
[]
[]
[]
[]
[null,"Skaidrojumi par veidlapas izmantošanu"]
[]
[null,"PAR VEIDLAPU"]
[null,null,"1.1.","Veidlapas mērķis ir sagatavot uzņēmuma nākotnes finanšu prognozi, lai saprastu, kādi un cik lieli būs uzņēmuma nākotnes ieņēmumi un izdevumi, sadalījumā pa mēnešiem, kā arī lai gūtu pārliecību, ka:\n          • no saņemtajiem ieņēmumiem uzņēmums spēs segt visas izmaksas, t.sk., aizdevuma maksājumus, parādus kreditoriem;\n          • uzņēmumam ir pietiekami līdzekļi, lai nodrošinātu un attīstītu savu turpmāko darbību"]
[]
[null,null,"1.2.","Šī veidlapa ir paredzēta gan pieredzējušiem, gan nedibinātiem uzņēmumiem, kas darbojas ar lauksaimniecību nesaistītās nozarēs. Uzņēmumiem, kas darbojas lauksaimniecības nozarēs ir atsevišķa veidlapa."]
[]
[null,null,"1.3.","Veidlapa sastāv no darba lapām: \"Bilance un Finanšu prognoze\", \"Naudas plūsma 1.gads\" un \"Naudas plūsma 2.gads\" ."]
[]
[]
[]
[]
[]
[]
[null,null,null,"Darba lapā:",null,null,null,null,null," Darba lapās sniedz informāciju par nākamajos divos gados plānotajiem ieņēmumiem un izdevumiem sadalījumā pa mēnešiem \n(sīkāki skaidrojumi sniegti zemāk)"]
[null,null,null,"• A) Bilance- ievada informāciju no pēdējā operatīvā finanšu pārskata par: īpašumā esošajiem ilgtermiņa aktīviem (piederošie pamatlīdzekļi, nemateriālie aktīvi, inventārs un citi aktīvi), īstermiņa aktīviem (uzņēmuma rīcībā esošie krājumi, debitori, pieejamie naudas līdzekļi, u.tml.), ilgtermiņa saistībām un īstermiņa saistībām (parādi kredītiestādēm, piegādātājiem,  darbiniekiem u.c.)."]
[null,null,null,"• B) Finanšu prognoze- sniedz pamatojumu par nākotnes ieņēmumu un izdevumu  prognozi turpmākajiem 12 mēnešiem"]
[]
[]
[null,"PAPILDUS INFORMĀCIJA PAR \"NAUDAS PLŪSMAS 1.gads\" AIZPILDĪŠANU:"]
[]
[null,null,null,"Principi: "]
[null,null,null,"• naudas plūsmas prognozē ieņēmumus/ izdevumus un to apmēru norāda tajos mēnešos, kad paredzēta to faktiskā saņemšana/ veikšana, nevis rēķinu izrakstīšana. Piemēram, ja Jūsu uzņēmums rēķinu par sniegtajiem pakalpojumiem izrakstīs marta mēnesī, bet faktisko samaksu no klienta saņems tikai jūnijā, tad naudas plūsmas prognozē attiecīgie ieņēmumi ir jānorāda jūnija mēnesī. Atbilstoši rīkojas arī ar izdevumiem."]
[null,null,null,"• uzņēmumi, kas ir PVN maksātāji- visās naudas plūsmas sadaļās summas norāda EUR neieskaitot PVN, papildus kolonnā \"PVN likme\"- norāda ar kādu PVN likmi apliek konkrēto ieņēmumu/ izdevumu pozīciju. Ja konkrētā ieņēmumu/ izdevumu pozīcija netiek aplikta ar PVN (piemēram, darba algas, apdrošināšanas izmaksas, u.c.), tad pie PVN likmes norāda \"0%\" (sīkāk skatīt skaidrojumu Nr.3)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Izvēlas mēnesi, ar kuru sākt aizpildīt naudas plūsmas prognozi (lauks \"Naudas plūsmas sākuma mēnesis\"):"]
[null,null,null,null,"• jau reģistrēti/ strādājoši uzņēmumi:"]
[null,null,null,null,null," - kā sākuma mēnesi norāda nākamo mēnesi pēc pēdējā operatīvā finanšu pārskata sagatavošanas (piemēram, ja pēdējais operatīvais finanšu pārskats ir sagatavots uz 31.03.2021, tad naudas plūsmā kā sākuma mēnesis jānorāda nākamais mēnesis, t.i. aprīlis),"]
[null,null,null,null,null," - papildus šūnā \"Bilance perioda sākumā\" norāda naudas atlikumu, kāds uzņēmumam bija operatīvo finanšu pārskata sagatavošanas datumā uzņēmuma norēķinu kontos un kasē,"]
[null,null,null,null,"• vēl nereģistrētam uzņēmumam-  kā naudas plūsmas sākuma mēnesi norāda mēnesi, kurā gatavo aizdevuma pieteikumu, un \"Bilance perioda sākumā\" ir \"0\" EUR"]
[]
[null,null,null,"Sadaļā \"Ieņēmumi\": "]
[null,null,null,null,"• rindās \"Pamatdarbības ieņēmumi\" ievada informāciju- no kā veidosies pamatdarbības ieņēmumi un plānoto ieņēmumu apmēru EUR sadalījumā pa mēnešiem."]
[null,null,null,null,"• rindās \"Ieņēmumi, kas saņemti no debitoru parādu atgūšanas\" un \"Ieņēmumi no krājumu pārdošanas\" ievada informāciju,  ja kādā no turpmākajiem mēnešiem plānots saņemt būtiskus ieņēmumus no debitoru parādu atgūšanas vai krājumu pārdošanas."]
[null,null,null,null,"• rindās \"Citi ieņēmumi\" ievada informāciju par  vienreizējiem ieņēmumiem, kas nav saistīti ar uzņēmuma pamatdarbību (piemēram, pieprasītā aizdevuma saņemšana, pamatkapitāla palielināšana, ES struktūrfondu atbalsta saņemšana, u.c.)"]
[]
[null,null,null,"Kolonnā \"PVN likme\" norāda, kāda PVN likme tiek piemērota attiecīgajiem ieņēmumiem/ izdevumiem (uzņēmumi, kas ir PVN nemaksātāji gan pie ieņēmumiem, gan pie izdevumiem norāda PVN likmi \"0%\" un pie ieņēmumiem/ izdevumiem norāda kopējo ieņēmumu/ izdevumu summu). Lapā automātiski aprēķinās aprēķinātais PVN priekšnodoklis un maksājamais PVN;"]
[]
[null,null,null,"Sadaļā \"Izdevumi\":"]
[null,null,null,null,"• Rindās \"Mainīgās izmaksas\" norāda tās izmaksas, kas mainās atkarībā no ražošanas/ pakalpojumu sniegšanas apjoma- piemēram, izejmateriāli produkcijas saražošanai, energoresursi, u.tml. Uzņēmums naudas plūsmā jau iestrādātās galveno izmaksu pozīcijas var pārsaukt atbilstoši uzņēmuma darbības specifikai un galvenajām izmaksu pozīcijām;"]
[null,null,null,null,"• Sadaļā \"Mainīgās izmaksas\" rindā \"Gaidāmie maksājumi\" papildus norāda uzņēmuma aktuālos parādus piegādātājiem un citām trešajām personām;"]
[null,null,null,null,"• Sadaļā \"Fiksētās izmaksas\" norāda tās izmaksas, kas uzņēmumam būs neatkarīgi no ražošanas/ pārdošanas apmēriem- piemēram, telpu nomas maksājums, patstāvīgi strādājošo darbinieku darba algas, u.c. izmaksas;"]
[]
[null,null,null,"Sadaļā \"Citas izmaksas\" norāda izmaksas, ka saistītas ar:"]
[null,null,null,null,"• pieprasītā aizdevuma izlietojumu- šajā pozīcijā norāda kopējo projekta izmaksu daļu, kas saistīta ar investīcijām (iekārtu, nekustamā īpašuma iegāde, būvniecība u.tml.). Savukārt jāpārliecinās vai pieprasītā apgrozāmo līdzekļu aizdevuma izlietojums ir atspoguļots pie mainīgajām/ fiksētajām izmaksām;"]
[null,null,null,null,"• esošo aizdevumu un līzingu maksājumi;"]
[null,null,null,null,"• citām ar ikdienas saimniecisko darbību nesaistītām izmaksām (piemēram, nākotnē paredzētās investīcijas pamatlīdzekļu iegādē, uzņēmuma izsniegtie aizdevumi u.c.;"]
[]
[null,null,null,"Rezultējošā sadaļa naudas plūsmas prognozē aprēķinās automātiski."]
[null,null,null,null,"• Rindā \"Perioda bilance\" redzama attiecīgā mēneša darbības bilance (jeb starpība starp attiecīgā mēneša ieņēmumiem un izdevumiem);"]
[null,null,null,null,"• Rindā \"Beigu bilance\" atspoguļojas uzkrātā plānoto ieņēmumu un izdevumu starpība."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versija- 7"]

{"sheet":"Bilance un Finanšu prognoze","index":1,"n_rows":230,"n_cols":17,"rows_kept":230,"cut":false,"hidden":false,"merged":[[142,2,142,7],[143,2,143,7],[144,2,144,7],[102,2,102,8],[103,2,103,8],[104,2,104,8],[81,2,81,4],[40,2,40,4],[8,3,8,7],[13,2,13,9],[11,7,11,9],[38,2,38,4],[39,2,39,4],[52,2,52,8],[82,2,82,4],[88,2,88,4],[17,9,17,11],[53,2,53,8],[61,2,61,5],[62,2,62,5],[63,2,63,5],[64,2,64,5],[65,2,65,5],[70,2,70,5],[200,2,200,5],[21,2,21,7],[22,2,22,7],[23,2,23,7],[24,2,24,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[28,2,28,7],[161,2,161,5],[92,2,92,4],[93,2,93,4],[94,2,94,4],[95,2,95,4],[96,2,96,4],[141,2,141,7],[94,5,94,6],[95,5,95,6],[96,5,96,6],[121,5,121,7],[97,2,97,4],[120,5,120,7],[89,2,89,4],[83,2,83,4],[71,2,71,5],[72,2,72,5],[73,2,73,5],[74,2,74,5],[79,2,79,4],[80,2,80,4],[33,2,33,4],[34,2,34,4],[87,5,87,6],[35,2,35,4],[51,2,51,8],[41,2,41,4],[42,2,42,4],[43,2,43,4],[49,2,49,8],[92,5,92,6],[93,5,93,6],[50,2,50,8],[6,3,6,7],[36,2,36,4],[37,2,37,4],[131,2,131,7],[132,2,132,7],[109,2,109,8],[110,2,110,8],[111,2,111,8],[88,5,88,6],[89,5,89,6],[90,5,90,6],[91,5,91,6],[97,5,97,6],[123,2,123,4],[123,5,123,7],[124,2,124,4],[124,5,124,7],[125,2,125,4],[125,5,125,7],[122,2,122,4],[122,5,122,7],[121,2,121,4],[90,2,90,4],[91,2,91,4],[228,9,228,11],[223,2,223,8],[218,2,218,8],[222,2,222,8],[228,3,228,4],[227,3,227,4],[224,2,224,8],[210,2,210,8],[211,2,211,8],[212,2,212,8],[213,2,213,8],[216,2,216,8],[217,2,217,8],[214,2,214,8],[215,2,215,8],[201,2,201,8],[209,2,209,8],[227,6,227,7],[228,6,228,7],[149,2,149,7],[158,2,158,9],[145,2,145,7],[162,2,162,5],[163,2,163,5],[164,2,164,5],[165,2,165,5],[166,2,166,5],[167,2,167,5],[159,2,160,4],[190,2,190,5],[182,2,183,5],[191,2,191,5],[192,2,192,5],[193,2,193,5],[194,2,194,5],[195,2,195,5],[196,2,196,5],[197,2,197,5],[198,2,198,5],[199,2,199,5],[133,2,133,7],[134,2,134,7],[135,2,135,7],[184,2,184,5],[185,2,185,5],[186,2,186,5],[187,2,187,5],[188,2,188,5],[189,2,189,5],[140,2,140,7],[146,2,146,7],[147,2,147,7],[148,2,148,7],[168,2,168,5],[169,2,169,5],[170,2,170,5],[171,2,171,5],[172,2,172,5],[173,2,173,5],[174,2,174,5],[175,2,175,5],[176,2,176,5],[177,2,177,5],[178,2,178,8]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LVL"]
[null,null,null,null,null,null,null,null,null,null,null,"FINANŠU INFORMĀCIJA (JP)",null,null,"EUR"]
[]
[null,"Informācija par aizņēmēju"]
[]
[null,"Nosaukums"]
[]
[null,"Reģ. Nr.",null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,2]
[]
["A)","Bilance",null,null,null,null,"Bilances uzņemšanas datums"]
[]
[null,null,"Uzņemot sava uzņēmuma bilanci norādītajā datumā, novērtējiet krājumus ražošanai un nepabeigto ražošanu pēc to pašizmaksas, bet preces pārdošanai un pamatlīdzekļus - tirgus cenās bez PVN."]
[]
[]
[]
[null,"Ilgtermiņa ieguldījumi"]
[]
[null,null,"Nekustamais īpašums (zemes gabali, ēkas, būves)",null,null,null,null,null,null,null,null,null,null,{"$f":"N30","v":{"$error":"#REF!"}}]
[null,null,"Adrese vai atrašanās vieta",null,null,null,null,null,"Platība, ha/m2","Vērtība, EUR",null,null,null,{"$f":"N30","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J22=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J23=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J24=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J25=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J26=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J27=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J28=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J29=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J22:J29)","v":0},null,null,null,{"$f":"IF(AND(J30=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Tehnoloģiskās iekārtas un mašīnas",null,null,null,null,null,null,null,null,null,null,{"$f":"N45","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N45","v":{"$error":"#REF!"}}]
[null,null,"Nosaukums",null,null,"Marka","Stāvoklis","Izgatavošanas gads","Vai ir līzingā?","Vērtība, EUR",null,null,null,{"$f":"N45","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J34=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J35=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J36=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J37=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J38=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J39=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J40=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J41=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J42=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J43=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J44=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J34:J44)","v":0},null,null,null,{"$f":"IF(AND(J45=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Citi ilgtermiņa ieguldījumi",null,null,null,null,null,null,null,null,null,null,{"$f":"N55","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N55","v":{"$error":"#REF!"}}]
[]
[null,null,"Nosaukums",null,null,null,null,null,null,"Vērtība, EUR",null,null,null,{"$f":"N55","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J50=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J51=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J52=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J53=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J54=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J50:J54)","v":0},null,null,null,{"$f":"IF(AND(J55=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N55","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Ilgtermiņa ieguldījumi kopā",{"$f":"SUM(J30+J45+J55)","v":0},null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Īstermiņa aktīvi",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Krājumi ražošanai (izejvielas, pamatmateriāli un palīgmateriāli)",null,null,null,null,null,null,null,null,null,null,{"$f":"N67","v":{"$error":"#REF!"}}]
[null,null,"Nosaukums",null,null,null,"Daudzums","Mērvienība",{"$f":"\" Vienības pašizmaksa, \"&IF($O$10=2,\"EUR\",\"LVL\")","v":" Vienības pašizmaksa, EUR"},"Summa, EUR",null,null,null,{"$f":"N67","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G62*I62","v":0},null,null,null,{"$f":"IF(AND(I62=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G63*I63","v":0},null,null,null,{"$f":"IF(AND(I63=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G64*I64","v":0},null,null,null,{"$f":"IF(AND(I64=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G65*I65","v":0},null,null,null,{"$f":"IF(AND(I65=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G66*I66","v":0},null,null,null,{"$f":"IF(AND(I66=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J62:J66)","v":0},null,null,null,{"$f":"IF(AND(J67=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Nepabeigtie ražojumi",null,null,null,null,null,null,null,null,null,null,{"$f":"N76","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N76","v":{"$error":"#REF!"}}]
[null,null,"Nosaukums",null,null,null,"Daudzums","Mērvienība","Vienības pašizmaksa,EUR","Summa, EUR",null,null,null,{"$f":"N76","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G71*I71","v":0},null,null,null,{"$f":"IF(AND(I71=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G72*I72","v":0},null,null,null,{"$f":"IF(AND(I72=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G73*I73","v":0},null,null,null,{"$f":"IF(AND(I73=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G74*I74","v":0},null,null,null,{"$f":"IF(AND(I74=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G75*I75","v":0},null,null,null,{"$f":"IF(AND(I75=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J71:J75)","v":0},null,null,null,{"$f":"IF(AND(J76=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[]
[null,null,"Gatavie ražojumi un preces pārdošanai",null,null,null,null,null,null,null,null,null,null,{"$f":"N85","v":{"$error":"#REF!"}}]
[null,null,"Nosaukums",null,null,"Realiz. datums","Daudzums","Mērvienība",{"$f":"\"Cena, \"&IF($O$10=2,\"EUR\",\"LVL\")","v":"Cena, EUR"},"Summa, EUR",null,null,null,{"$f":"N85","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G80*I80","v":0},null,null,null,{"$f":"IF(AND(I80=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G81*I81","v":0},null,null,null,{"$f":"IF(AND(I81=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G82*I82","v":0},null,null,null,{"$f":"IF(AND(I82=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G83*I83","v":0},null,null,null,{"$f":"IF(AND(I83=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"G84*I84","v":0},null,null,null,{"$f":"IF(AND(I84=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J80:J84)","v":0},null,null,null,{"$f":"IF(AND(J85=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[]
[null,null,"Pircēju un pasūtītāju parādi un citi Debitori (atgūstami 12 mēnešu laikā)",null,null,null,null,null,null,null,null,null,null,{"$f":"N99","v":{"$error":"#REF!"}}]
[null,null,"Debitors",null,null,"Par ko?",null,"Kad bija jāsaņem?","Plānots saņemt","Summa, EUR",null,null,null,{"$f":"N99","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J89=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J90=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J91=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J92=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J98=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J89:J98)","v":0},null,null,null,{"$f":"IF(AND(J99=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[]
[null,null,"Citi īstermiņa aktīvi",null,null,null,null,null,null,null,null,null,null,{"$f":"N106","v":{"$error":"#REF!"}}]
[null,null,"Nosaukums",null,null,null,null,null,null,"Summa, EUR",null,null,null,{"$f":"N106","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J103=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J104=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J105=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J103:J105)","v":0},null,null,null,{"$f":"IF(AND(J106=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[]
[null,null,"Naudas līdzekļi",null,null,null,null,null,null,null,null,null,null,{"$f":"N113","v":{"$error":"#REF!"}}]
[null,null,"Bankas nosaukums vai kase",null,null,null,null,null,null,"Summa, EUR",null,null,null,{"$f":"N113","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J110=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J111=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J112=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J110:J112)","v":0},null,null,null,{"$f":"IF(AND(J113=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,"Īstermiņa aktīvi kopā",{"$f":"J67+J76+J85+J99+J106+J113","v":0},null,null,null,{"$f":"IF(AND(J115=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"Ilgtermiņa ieguldījumi un īstermiņa aktīvi kopā",{"$f":"J57+J115","v":0},null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Ilgtermiņa kreditori",null,null,null,null,null,null,null,null,null,null,{"$f":"N127","v":{"$error":"#REF!"}}]
[null,null,"Ilgtermiņa parādi (t.sk., bankām un līzinga kompānijām), kam maksājuma termiņš iestājas pēc 12 mēnešiem ",null,null,null,null,null,null,null,null,null,null,{"$f":"N127","v":{"$error":"#REF!"}}]
[null,null,"Kreditors",null,null,"Par ko?",null,null,"Gala atmaks. term.","Summa, EUR",null,null,null,{"$f":"N127","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J122=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J123=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J124=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J125=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J126=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J122:J126)","v":0},null,null,null,{"$f":"IF(AND(J127=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[]
[null,null,"Īstermiņa kreditori",null,null,null,null,null,null,null,null,null,null,{"$f":"N151","v":{"$error":"#REF!"}}]
[null,null,"Parādi (t.sk., bankām un līzinga kompānijām), kas jānomaksā tuvākajos 12 mēnešos ",null,null,null,null,null,null,null,null,null,null,{"$f":"N137","v":{"$error":"#REF!"}}]
[null,null,"Kreditors",null,null,null,null,null,"Maksājuma datums","Summa, EUR",null,null,null,{"$f":"N137","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J132=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J133=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J134=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J135=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J136=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J132:J136)","v":0},null,null,null,{"$f":"IF(AND(J137=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[]
[null,null,"Parādi piegādātājiem un citi īstermiņa parādi (elektrība, nodokļi, telefons, darba alga utt.)",null,null,null,null,null,null,null,null,null,null,{"$f":"N151","v":{"$error":"#REF!"}}]
[null,null,"Nosaukums",null,null,null,null,null,"Maksājuma datums","Summa, EUR",null,null,null,{"$f":"N151","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J141=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J147=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J148=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J149=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J150=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J141:J150)","v":0},null,null,null,{"$f":"IF(AND(J151=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,"Īstermiņa kreditori kopā",{"$f":"J137+J151","v":0},null,null,null,{"$f":"IF(AND(J153=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,"Kreditori kopā",{"$f":"J127+J153","v":0},null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["B)","Finanšu prognoze turpmākiem 12 mēnešiem"]
[null,"Uzņēmuma ieņēmumu prognoze turpmākiem 12 mēnešiem (bez PVN)",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"jāaizpilda gdījumos, ja uzņēmuma nākotnes prognozes atšķiras par +/-20% no līdzšinējās uzņēmuma darbības, vai, ja citos dokumentos nav sniegta informācija par darbības apjomiem"]
[null,null,"Prognozētais ienākumu gūšanas veids \n(preces, pakalpojumi)",null,null,null,"A","B","C","BxC",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Mērvienība","Realizācijas\napjoms/ daudzums",{"$f":"\"Cena par preces/ pakalpojuma vienību, \"&IF($O$10=2,\"EUR\",\"LVL\")","v":"Cena par preces/ pakalpojuma vienību, EUR"},{"$f":"\"Prognozētie ieņēmumi, \"&IF($O$10=2,\"EUR\",\"LVL\")","v":"Prognozētie ieņēmumi, EUR"},null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H162*I162","v":0},null,null,null,{"$f":"IF(AND(I162=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H163*I163","v":0},null,null,null,{"$f":"IF(AND(I163=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I164=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I165=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I166=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I167=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I168=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I169=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I170=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I171=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I172=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I173=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I174=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I175=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I176=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I177=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I178=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Uzņēmuma kopējie ieņēmumi",null,null,null,null,null,null,{"$f":"SUM(J162:J178)","v":0},null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Uzņēmuma izdevumu prognoze turpmākajiem 12 mēnešiem (bez PVN)",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Mainīgās izmaksas",null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Iepērkamā prece, izejvielas, darba algas, energoresursi, transporta izmaksas, pārdošanas izmaksas,  u.c."]
[null,null,null,null,null,null,"Mērvienība","Patēriņš/ daudzums",{"$f":"IF($O$10=2,\"EUR\",\"LVL\")&\"/vienība\"","v":"EUR/vienība"},"Summa, EUR",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H185*I185","v":0},null,null,null,{"$f":"IF(AND(I185=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H186*I186","v":0},null,null,null,{"$f":"IF(AND(I186=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I187=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I188=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I189=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I190=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I191=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I192=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I193=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I194=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I195=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I196=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I197=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I198=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I199=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"IF(AND(I200=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H201*I201","v":0},null,null,null,{"$f":"IF(AND(I201=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Mainīgās izmaksas kopā",null,null,null,null,null,null,{"$f":"SUM(J185:J201)","v":0},null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Prognozētā peļņa vai zaudējumi",null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Uzņēmuma kopējie ieņēmumi",null,null,null,null,null,null,{"$f":"J179","v":0},null,null,null,1]
[null,null,"Mainīgās izmaksas kopā",null,null,null,null,null,null,{"$f":"J202","v":0},null,null,null,1]
[null,null,"Bruto peļņa (Uzņēmuma kopējie ienākumi - Mainīgās izmaksas kopā)",null,null,null,null,null,null,{"$f":"J206-J207","v":0},null,null,null,1]
[null,null,"Pastāvīgās izmaksas",null,null,null,null,null,null,"Summa, EUR",null,null,null,{"$f":"N220","v":{"$error":"#REF!"}}]
[null,null,"Pastāvīgi strādājošo (t.sk., vadītāju) algas un sociālais nodoklis",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(I210=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Transporta izmaksas (degviela u.c.)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J211=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Elektrība, kurināmais",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J212=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Apdrošināšana",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J213=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Nodokļi un nodevas",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J214=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Ēku un ceļu remonts ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J215=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Tehnikas remonts",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J216=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Nomas maksa par ēkām, zemi",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J217=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Cits",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J218=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Cits",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J219=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Kopā",{"$f":"SUM(J210:J219)","v":0},null,null,null,{"$f":"IF(AND(J220=0,#REF!=0,#REF!=0),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Izdevumi kopā (Mainīgās izmaksas kopā + Pastāvīgās izmaksas kopā)",{"$f":"J207+J220","v":0},null,null,null,1]
[null,null,null,null,null,null,null,null,"Peļņa vai zaudējumi pirms procentu maksājumiem un amortizācijas (Uzņēmuma kopējie ieņēmumi - Izdevumi kopā)",{"$f":"J206-J221","v":0},null,null,null,1]
[null,null,"ALTUM aizdevumu procenti",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J223=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Citu aizdevumu procenti",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J224=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,"Pamtlīdzekļu nolietojums un amortizācija",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J225=\"\",#REF!=\"\",#REF!=\"\"),0,1)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Peļņa vai zaudējumi (pirms ienākumu nodokļa)",{"$f":"J222-J223-J224-J225","v":0},null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Aizņēmēja vārdā:",null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,"(Vārds, uzvārds)",null,null,"(Datums)",null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Naudas plūsma 1. gads","index":2,"n_rows":85,"n_cols":40,"rows_kept":85,"cut":false,"hidden":false,"merged":[[84,7,84,10],[83,7,83,10],[76,3,76,4],[77,3,77,4],[84,12,84,13],[83,12,83,13],[78,3,78,4],[83,2,84,4],[73,3,73,4],[74,3,74,4],[72,3,72,4],[68,3,68,4],[75,3,75,4]]}
[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,null,1,null,1]
[null,null,null,{"$f":"IF('Bilance un Finanšu prognoze'!D7=\"\",\"Lūdzu norādiet Aizņēmēja nosaukumu darba lapā- Bilance un Finanšu prognoze!\",'Bilance un Finanšu prognoze'!D7 &\" Naudas plūsmas grafiks (JP) 1. gadam\")","v":"Lūdzu norādiet Aizņēmēja nosaukumu darba lapā- Bilance un Finanšu prognoze!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,1,"LVL",1,"A7",null,null,null,null,null,null,1,7]
[null,null,"Ieņēmumi, EUR",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,null,"EUR"]
[null,null,null,null,"Naudas plūsmas sākuma mēnesis",{"$f":"AF55","v":"jan"},{"$f":"AF56","v":"feb"},{"$f":"AF57","v":"mar"},{"$f":"AF58","v":"apr"},{"$f":"AF59","v":"mai"},{"$f":"AF60","v":"jūn"},{"$f":"AF61","v":"jūl"},{"$f":"AF62","v":"aug"},{"$f":"AF63","v":"sep"},{"$f":"AF64","v":"okt"},{"$f":"AF65","v":"nov"},{"$f":"AF66","v":"dec"},null,"Kopā",null,null,null,null,null,null,null,null,null,null,null,"$A$32",null,null,null,null,null,null,null,2,8]
[null,null,null,null,"Bilance perioda sākumā",null,{"$f":"F83","v":0},{"$f":"G83","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,9]
[null,null,null,null,"PVN likme",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,null,null,null,null,null,null,null,null,4,10]
[null,null,null,"Ieņēmumi, kas saņemti no debitoru parādu atgūšanas",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F7:Q7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,11]
[null,null,null,"Ieņēmumi no krājumu pārdošanas",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,12]
[null,null,null,null,"Kopā",{"$f":"SUM(F7:F8)","v":0},null,{"$f":"SUM(H7:H8)","v":0},0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,"Pamatdarbības ieņēmumi"]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,13]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,14]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,15]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,16]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,17]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,22]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,23]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,28]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"D.P.  10.08.2021- VAI ŠIS IR AKTUĀLI- Neatrpodu iespēju ģenerēt grafiku?",null,null,null,null,null,null,null,null,15,29]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,30]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,31]
[null,null,null,null,"Kopā",{"$f":"SUM(F11:F21)","v":0},{"$f":"SUM(G11:G21)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(S11:S21)","v":0},null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"AE22-1","v":1},null,2,{"$f":"AH22-1","v":1},null,null,null,18,32]
[null,null,null,"Citi ieņēmumi"]
[null,null,null,"Saņemtie īstermiņa Aizdevēja* aizdevumi",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F24:Q24)","v":0},null,null,null,null,null,null,null,null,null,null,"INV NOBĪDE",null,null,"AL NOBĪDE",null,null,null,null,null,19,33]
[null,null,null,"Saņemtie ilgtermiņa Aizdevēja* aizdevumi",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F25:Q25)","v":0},null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AF22>=$AC$25,0,$AC$25)","v":0},{"$f":"IF(AD25=0,0,LOOKUP(AD25,$AC$25:$AC$51,#REF!))","v":0},{"$f":"IF(AD25=0,0,LOOKUP(AD25,$AC$25:$AC$51,#REF!))","v":0},{"$f":"IF($AI$22>=AC25,0,AC25)","v":0},{"$f":"IF($AG$25=0,0,LOOKUP($AG$25,$AC$25:$AC$51,#REF!))","v":0},{"$f":"IF(AG25=0,0,LOOKUP(AG25,$AC$25:$AC$51,#REF!))","v":0},null,null,null,20,34]
[null,null,null,"Ārkārtas ieņēmumi",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,2,{"$f":"IF($AF$22>=AC26,0,AD25+1)","v":1},{"$f":"IF(AD26=0,0,LOOKUP(AD26,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD26=0,0,LOOKUP(AD26,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF($AI$22>=AC26,0,AG25+1)","v":1},{"$f":"IF(AG26=0,0,LOOKUP(AG26,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG26=0,0,LOOKUP(AG26,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,21,35]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,3,2,{"$f":"IF(AD27=0,0,LOOKUP(AD27,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD27=0,0,LOOKUP(AD27,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},2,{"$f":"IF(AG27=0,0,LOOKUP(AG27,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG27=0,0,LOOKUP(AG27,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,22,36]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,4,3,{"$f":"IF(AD28=0,0,LOOKUP(AD28,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD28=0,0,LOOKUP(AD28,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},3,{"$f":"IF(AG28=0,0,LOOKUP(AG28,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG28=0,0,LOOKUP(AG28,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,23,37]
[null,null,null,null,"Saņemtais PVN",{"$f":"(F7*$E$7)+(F8*$E$8)+(F11*$E$11)+(F12*$E$12)+(F13*$E$13)+(F14*$E$14)+(F15*$E$15)+(F16*$E$16)+(F17*$E$17)+(F18*$E$18)+(F19*$E$19)+(F20*$E$20)+(F21*$E$21)+(F24*$E$24)+(F25*$E$25)+(F26*$E$26)+(F27*$E$27)+(F28*$E$28)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(S7*$E$7)+(S8*$E$8)+(S11*$E$11)+(S12*$E$12)+(S13*$E$13)+(S14*$E$14)+(S15*$E$15)+(S16*$E$16)+(S17*$E$17)+(S18*$E$18)+(S19*$E$19)+(S20*$E$20)+(S21*$E$21)+(S24*$E$24)+(S25*$E$25)+(S26*$E$26)+(S27*$E$27)+(S28*$E$28)","v":0},null,null,null,null,null,null,null,null,null,5,4,{"$f":"IF(AD29=0,0,LOOKUP(AD29,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD29=0,0,LOOKUP(AD29,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},4,{"$f":"IF(AG29=0,0,LOOKUP(AG29,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG29=0,0,LOOKUP(AG29,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,24,38]
[null,null,null,null,"Kopā ieņēmumi",{"$f":"SUM(F9)+F22+SUM(F24:F29)","v":0},{"$f":"SUM(G9)+G22+SUM(G24:G29)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(S7:S8,S22,S24:S29)","v":0},null,null,null,null,null,null,null,null,null,6,5,{"$f":"IF(AD30=0,0,LOOKUP(AD30,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD30=0,0,LOOKUP(AD30,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},5,{"$f":"IF(AG30=0,0,LOOKUP(AG30,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG30=0,0,LOOKUP(AG30,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,25,39]
[null,null,"Izdevumi, EUR",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,7,6,{"$f":"IF(AD31=0,0,LOOKUP(AD31,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD31=0,0,LOOKUP(AD31,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},6,{"$f":"IF(AG31=0,0,LOOKUP(AG31,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG31=0,0,LOOKUP(AG31,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,26,40]
[null,null,null,"Mainīgās izmaksas",null,{"$f":"F4","v":"jan"},"feb","mar","apr","mai","jūn","jūl","aug","sep","okt","nov","dec",null,"Kopā"]
[null,null,null,"Gaidāmie maksājumi",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F33:Q33)","v":0},null,null,null,null,null,null,null,null,null,8,{"$f":"IF($AF$22>=AC33,0,AD31+1)","v":7},{"$f":"IF(AD33=0,0,LOOKUP(AD33,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD33=0,0,LOOKUP(AD33,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF($AI$22>=AC33,0,AG31+1)","v":7},{"$f":"IF(AG33=0,0,LOOKUP(AG33,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG33=0,0,LOOKUP(AG33,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,27,42]
[]
[null,null,null,"Izejmateriāli",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,9,{"$f":"IF($AF$22>=AC35,0,AD33+1)","v":8},{"$f":"IF(AD35=0,0,LOOKUP(AD35,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD35=0,0,LOOKUP(AD35,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF($AI$22>=AC35,0,AG33+1)","v":8},{"$f":"IF(AG35=0,0,LOOKUP(AG35,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG35=0,0,LOOKUP(AG35,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,28,43]
[null,null,null,"Palīgmateriāli",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,10,9,{"$f":"IF(AD36=0,0,LOOKUP(AD36,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD36=0,0,LOOKUP(AD36,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},9,{"$f":"IF(AG36=0,0,LOOKUP(AG36,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG36=0,0,LOOKUP(AG36,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,29,44]
[null,null,null,"Ražošanā strādājošo darba alga un sociālais nodoklis",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,11,10,{"$f":"IF(AD37=0,0,LOOKUP(AD37,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD37=0,0,LOOKUP(AD37,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},10,{"$f":"IF(AG37=0,0,LOOKUP(AG37,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG37=0,0,LOOKUP(AG37,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,30,45]
[null,null,null,"Energoresursi",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,12,11,{"$f":"IF(AD38=0,0,LOOKUP(AD38,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD38=0,0,LOOKUP(AD38,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},11,{"$f":"IF(AG38=0,0,LOOKUP(AG38,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG38=0,0,LOOKUP(AG38,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,31,46]
[null,null,null,"Realizācijas izmaksas",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,13,12,{"$f":"IF(AD39=0,0,LOOKUP(AD39,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD39=0,0,LOOKUP(AD39,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},12,{"$f":"IF(AG39=0,0,LOOKUP(AG39,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG39=0,0,LOOKUP(AG39,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,32,47]
[null,null,null,"Transporta izmaksas ",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,14,13,{"$f":"IF(AD40=0,0,LOOKUP(AD40,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD40=0,0,LOOKUP(AD40,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},13,{"$f":"IF(AG40=0,0,LOOKUP(AG40,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG40=0,0,LOOKUP(AG40,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,33,48]
[null,null,null,"cits",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,15,14,{"$f":"IF(AD41=0,0,LOOKUP(AD41,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD41=0,0,LOOKUP(AD41,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},14,{"$f":"IF(AG41=0,0,LOOKUP(AG41,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG41=0,0,LOOKUP(AG41,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,34,49]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,16,15,{"$f":"IF(AD42=0,0,LOOKUP(AD42,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD42=0,0,LOOKUP(AD42,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},15,{"$f":"IF(AG42=0,0,LOOKUP(AG42,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG42=0,0,LOOKUP(AG42,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,35,50]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,17,16,{"$f":"IF(AD43=0,0,LOOKUP(AD43,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD43=0,0,LOOKUP(AD43,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},16,{"$f":"IF(AG43=0,0,LOOKUP(AG43,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG43=0,0,LOOKUP(AG43,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,36,51]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,18,17,{"$f":"IF(AD44=0,0,LOOKUP(AD44,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD44=0,0,LOOKUP(AD44,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},17,{"$f":"IF(AG44=0,0,LOOKUP(AG44,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG44=0,0,LOOKUP(AG44,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,37,52]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,19,18,{"$f":"IF(AD45=0,0,LOOKUP(AD45,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD45=0,0,LOOKUP(AD45,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},18,{"$f":"IF(AG45=0,0,LOOKUP(AG45,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG45=0,0,LOOKUP(AG45,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,38,53]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,20,19,{"$f":"IF(AD46=0,0,LOOKUP(AD46,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD46=0,0,LOOKUP(AD46,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},19,{"$f":"IF(AG46=0,0,LOOKUP(AG46,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG46=0,0,LOOKUP(AG46,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,39,54]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,21,20,{"$f":"IF(AD47=0,0,LOOKUP(AD47,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD47=0,0,LOOKUP(AD47,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},20,{"$f":"IF(AG47=0,0,LOOKUP(AG47,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG47=0,0,LOOKUP(AG47,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,40,62]
[null,null,null,null,"Kopā",{"$f":"SUM(F35:F47)","v":0},{"$f":"SUM(G35:G47)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(S35:S47)","v":0},null,null,null,null,null,null,null,null,null,22,21,{"$f":"IF(AD48=0,0,LOOKUP(AD48,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD48=0,0,LOOKUP(AD48,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},21,{"$f":"IF(AG48=0,0,LOOKUP(AG48,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG48=0,0,LOOKUP(AG48,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,41,63]
[null,null,null,"Fiksētās izmaksas"]
[null,null,null,"Pastāvīgi strādājošo algas un sociālais nodoklis",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,23,{"$f":"IF($AF$22>=AC50,0,AD48+1)","v":22},{"$f":"IF(AD50=0,0,LOOKUP(AD50,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD50=0,0,LOOKUP(AD50,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF($AI$22>=AC50,0,AG48+1)","v":22},{"$f":"IF(AG50=0,0,LOOKUP(AG50,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG50=0,0,LOOKUP(AG50,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,42,64]
[null,null,null,"Transporta izmaksas (degviela u.c.)",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,24,23,{"$f":"IF(AD51=0,0,LOOKUP(AD51,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AD51=0,0,LOOKUP(AD51,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},23,{"$f":"IF(AG51=0,0,LOOKUP(AG51,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AG51=0,0,LOOKUP(AG51,$AC$25:$AC$51,#REF!))","v":{"$error":"#REF!"}},null,null,null,43,65]
[null,null,null,"Apdrošināšana",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,66]
[null,null,null,"Nodokļi un nodevas",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(#REF!,AM3:AM52,AN3:AN52)","v":{"$error":"#REF!"}}]
[null,null,null,"Ēku un ceļu remonts",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"MĒNEŠI NAUDAS PLŪSMĀ"]
[null,null,null,"Tehnikas remonts",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,1,"jan",{"$f":"AC79","v":1},{"$f":"AD79","v":"jan"}]
[null,null,null,"Nomas maksa par ēkām, zemi",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,2,"feb",{"$f":"IF(AE55=24,1,AE55+1)","v":2},{"$f":"LOOKUP(AE56,$AC$55:$AC$78,$AD$55:$AD$78)","v":"feb"}]
[null,null,null,"cits",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,3,"mar",3,"mar"]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,4,"apr",4,"apr"]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,5,"mai",5,"mai"]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,6,"jūn",6,"jūn"]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,7,"jūl",7,"jūl"]
[null,null,null,null,0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,8,"aug",8,"aug"]
[null,null,null,null,"Kopā",{"$f":"SUM(F50:F62)","v":0},{"$f":"SUM(G50:G62)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(S50:S62)","v":0},null,null,null,null,null,null,null,null,null,9,"sep",9,"sep"]
[null,null,null,"Līzingu maksājumi: procenti",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,10,"okt",{"$f":"IF(AE63=24,1,AE63+1)","v":10},"okt"]
[null,null,null,"Līzingu maksājumi: pamatsumma",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,11,"nov",11,"nov"]
[null,null,null,"Aizdevēja* aizdevuma izlietojums",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,12,"dec",12,"dec"]
[null,null,null,"Aizdevēja* aizdevuma izlietojums",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,13,"jan",13,{"$f":"LOOKUP(AE67,$AC$55:$AC$78,$AD$55:$AD$78)&\"-2.gads\"","v":"jan-2.gads"}]
[null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,14,"feb",14,"feb-2.gads"]
[null,null,null,"PVN priekšnodoklis",null,{"$f":"(F33*$E$33)+(F35*$E$35)+(F36*$E$36)+(F37*$E$37)+(F38*$E$38)+(F39*$E$39)+(F40*$E$40)+(F41*$E$41)+(F42*$E$43)+(F43*$E$43)+(F44*$E$44)+(F45*$E$45)+(F46*$E$46)+(F47*$E$47)+(F50*$E$50)+(F51*$E$51)+(F52*$E$52)+(F53*$E$53)+(F54*$E$54)+(F55*$E$55)+(F56*$E$56)+(F57*$E$57)+(F58*$E$58)+(F59*$E$59)+(F60*$E$60)+(F61*$E$61)+(F62*$E$62)+(F64*$E$64)+(F65*$E$65)+(F66*$E$66)+(F67*$E$67)+(F68*$E$68)","v":0},{"$f":"(G33*$E$33)+(G35*$E$35)+(G36*$E$36)+(G37*$E$37)+(G38*$E$38)+(G39*$E$39)+(G40*$E$40)+(G41*$E$41)+(G42*$E$43)+(G43*$E$43)+(G44*$E$44)+(G45*$E$45)+(G46*$E$46)+(G47*$E$47)+(G50*$E$50)+(G51*$E$51)+(G52*$E$52)+(G53*$E$53)+(G54*$E$54)+(G55*$E$55)+(G56*$E$56)+(G57*$E$57)+(G58*$E$58)+(G59*$E$59)+(G60*$E$60)+(G61*$E$61)+(G62*$E$62)+(G64*$E$64)+(G65*$E$65)+(G66*$E$66)+(G67*$E$67)+(G68*$E$68)","v":0},0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,null,null,null,null,null,null,15,"mar",15,"mar-2.gads"]
[null,null,null,"Pieprasītā Aizdevēja* aizdevuma procenti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F70:Q70)","v":0},null,null,null,null,null,null,null,null,null,16,"apr",16,"apr-2.gads"]
[null,null,null,"Pieprasītā Aizdevēja* aizdevuma pamatsumma",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F71:Q71)","v":0},null,null,null,null,null,null,null,null,null,17,"mai",17,"mai-2.gads"]
[null,null,null,"Esošo Aizdevēja* aizdevumu procenti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F72:Q72)","v":0},null,null,null,null,null,null,null,null,null,18,"jūn",18,"jūn-2.gads"]
[null,null,null,"Esošo Aizdevēja* aizdevumu pamatsumma",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,19,"jūl",19,"jūl-2.gads"]
[null,null,null,"Citu aizdevumu procenti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,20,"aug",20,"aug-2.gads"]
[null,null,null,"Citu aizdevumu pamatsummas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,21,"sep",21,"sep-2.gads"]
[null,null,null,"Ar pamatdarbību nesaistīto aizdevumu pamatsummas un procenti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F76:Q76)","v":0},null,null,null,null,null,null,null,null,null,22,"okt",{"$f":"IF(AE75=24,1,AE75+1)","v":22},"okt-2.gads"]
[null,null,null,"Ienākuma nodoklis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,23,"nov",{"$f":"IF(AE76=24,1,AE76+1)","v":23},"nov-2.gads"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F78:Q78)","v":0},null,null,null,null,null,null,null,null,null,24,"dec",{"$f":"IF(AE77=24,1,AE77+1)","v":24},"dec-2.gads"]
[null,null,null,"Maksājamais Pievienotās vērtības nodoklis",null,null,{"$f":"F29-F69","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(F79:Q79)","v":0},null,null,null,null,null,null,null,null,null,1,{"$f":"LOOKUP(AC79,$AC$55:$AC$78,$AD$55:$AD$78)","v":"jan"},null,{"$error":"#N/A"}]
[null,null,null,null,"Kopējie izdevumi",{"$f":"SUM(F33,F48,F63,F64:F79)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(S33,S48,S63,S64:S79)","v":0}]
[null,null,null,null,"Perioda bilance",{"$f":"F30-F80","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"S30-S80","v":0}]
[]
[null,null,null,null,"Beigu bilance",{"$f":"F5+F30-F80","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"*Aizdevējs - AS \"Attīstības finanšu institūcija Altum\"",null,null,null,"Aizņēmēja vārdā:",{"$f":"IF('Bilance un Finanšu prognoze'!D228=\"\",\"\",'Bilance un Finanšu prognoze'!D228)","v":""},null,null,null,null,{"$f":"IF('Bilance un Finanšu prognoze'!G228=\"\",\"\",'Bilance un Finanšu prognoze'!G228)","v":""}]
[null,null,null,null,null,null,null,"(Vārds, uzvārds)",null,null,null,null,"(Datums)"]

{"sheet":"Naudas plūsma 2. gads","index":3,"n_rows":85,"n_cols":41,"rows_kept":85,"cut":false,"hidden":false,"merged":[[84,6,84,9],[84,11,84,12],[84,14,84,15],[77,2,77,3],[76,2,76,3],[78,2,78,3],[83,6,83,9],[83,2,85,2],[70,2,70,3],[72,2,72,3],[68,2,68,3],[83,11,83,12],[83,14,83,15],[73,2,73,3],[74,2,74,3],[75,2,75,3],[69,2,69,3],[71,2,71,3]]}
[]
[null,null,null,null,null,null,null,null,{"$f":"IF('Bilance un Finanšu prognoze'!E7=\"\",\"\",'Bilance un Finanšu prognoze'!E7)","v":""},null,null,null,null,null,null,null,null,"Naudas plūsma (JP) 2. gads",null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"\"A\"&AO53","v":"A66"},null,null,null,null,null,null,1,7]
[null,"Ieņēmumi, EUR"]
[null,null,null,null,{"$f":"'Naudas plūsma 1. gads'!F4","v":"jan"},{"$f":"'Naudas plūsma 1. gads'!G4","v":"feb"},{"$f":"'Naudas plūsma 1. gads'!H4","v":"mar"},{"$f":"'Naudas plūsma 1. gads'!I4","v":"apr"},{"$f":"'Naudas plūsma 1. gads'!J4","v":"mai"},{"$f":"'Naudas plūsma 1. gads'!K4","v":"jūn"},{"$f":"'Naudas plūsma 1. gads'!L4","v":"jūl"},{"$f":"'Naudas plūsma 1. gads'!M4","v":"aug"},{"$f":"'Naudas plūsma 1. gads'!N4","v":"sep"},{"$f":"'Naudas plūsma 1. gads'!O4","v":"okt"},{"$f":"'Naudas plūsma 1. gads'!P4","v":"nov"},{"$f":"'Naudas plūsma 1. gads'!Q4","v":"dec"},null,"Kopā",null,null,null,null,null,null,null,null,null,null,null,null,null,"$H$35",null,null,null,null,null,null,null,2,8]
[null,null,null,null,{"$f":"'Naudas plūsma 1. gads'!Q83","v":0},{"$f":"E83","v":0},{"$f":"F83","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,9]
[null,null,null,"PVN likme",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,null,null,null,null,null,null,null,null,null,null,4,10]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D7=\"\",\"\",'Naudas plūsma 1. gads'!D7)","v":"Ieņēmumi, kas saņemti no debitoru parādu atgūšanas"},{"$f":"'Naudas plūsma 1. gads'!E7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E7:P7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,11]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D8=\"\",\"\",'Naudas plūsma 1. gads'!D8)","v":"Ieņēmumi no krājumu pārdošanas"},{"$f":"'Naudas plūsma 1. gads'!E8","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,12]
[null,null,null,"Kopā",{"$f":"SUM(E7:E8)","v":0},{"$f":"SUM(F7:F8)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"Pamatdarbības"]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D11=\"\",\"\",'Naudas plūsma 1. gads'!D11)","v":""},{"$f":"'Naudas plūsma 1. gads'!E11","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,13]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D12=\"\",\"\",'Naudas plūsma 1. gads'!D12)","v":""},{"$f":"'Naudas plūsma 1. gads'!E12","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,14]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D13=\"\",\"\",'Naudas plūsma 1. gads'!D13)","v":""},{"$f":"'Naudas plūsma 1. gads'!E13","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,15]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D14=\"\",\"\",'Naudas plūsma 1. gads'!D14)","v":""},{"$f":"'Naudas plūsma 1. gads'!E14","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,16]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D15=\"\",\"\",'Naudas plūsma 1. gads'!D15)","v":""},{"$f":"'Naudas plūsma 1. gads'!E15","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,17]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D16=\"\",\"\",'Naudas plūsma 1. gads'!D16)","v":""},{"$f":"'Naudas plūsma 1. gads'!E16","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,18]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D17=\"\",\"\",'Naudas plūsma 1. gads'!D17)","v":""},{"$f":"'Naudas plūsma 1. gads'!E17","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,19]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D18=\"\",\"\",'Naudas plūsma 1. gads'!D18)","v":""},{"$f":"'Naudas plūsma 1. gads'!E18","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,28]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D19=\"\",\"\",'Naudas plūsma 1. gads'!D19)","v":""},{"$f":"'Naudas plūsma 1. gads'!E19","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,29]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D20=\"\",\"\",'Naudas plūsma 1. gads'!D20)","v":""},{"$f":"'Naudas plūsma 1. gads'!E20","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,30]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D21=\"\",\"\",'Naudas plūsma 1. gads'!D21)","v":""},{"$f":"'Naudas plūsma 1. gads'!E21","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,31]
[null,null,null,"Kopā",{"$f":"SUM(E11:E21)","v":0},{"$f":"SUM(F11:F21)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R11:R21)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,32]
[null,null,"Citi ieņēmumi"]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D24=\"\",\"\",'Naudas plūsma 1. gads'!D24)","v":"Saņemtie īstermiņa Aizdevēja* aizdevumi"},{"$f":"'Naudas plūsma 1. gads'!E24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:P24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,33]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D25=\"\",\"\",'Naudas plūsma 1. gads'!D25)","v":"Saņemtie ilgtermiņa Aizdevēja* aizdevumi"},{"$f":"'Naudas plūsma 1. gads'!E25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:P25)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,34]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D26=\"\",\"\",'Naudas plūsma 1. gads'!D26)","v":"Ārkārtas ieņēmumi"},{"$f":"'Naudas plūsma 1. gads'!E26","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,35]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D27=\"\",\"\",'Naudas plūsma 1. gads'!D27)","v":""},{"$f":"'Naudas plūsma 1. gads'!E27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,36]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D28=\"\",\"\",'Naudas plūsma 1. gads'!D28)","v":""},{"$f":"'Naudas plūsma 1. gads'!E28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,37]
[null,null,null,"Saņemtais PVN",{"$f":"($D$7*E7)+($D$8*E8)+($D$11*E11)+($D$12*E12)+($D$13*E13)+($D$14*E14)+($D$15*E15)+($D$16*E16)+($D$17*E17)+($D$18*E18)+($D$19*E19)+($D$20*E20)+($D$21*E21)+($D$24*E24)+($D$25*E25)+($D$26*E26)+($D$27*E27)+($D$28*E$28)","v":0},{"$f":"($D$7*F7)+($D$8*F8)+($D$11*F11)+($D$12*F12)+($D$13*F13)+($D$14*F14)+($D$15*F15)+($D$16*F16)+($D$17*F17)+($D$18*F18)+($D$19*F19)+($D$20*F20)+($D$21*F21)+($D$24*F24)+($D$25*F25)+($D$26*F26)+($D$27*F27)+($D$28*F$28)","v":0},0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,38]
[null,null,null,"Kopējie ieņēmumi",{"$f":"E9+E22+SUM(E24:E29)","v":0},{"$f":"F9+F22+SUM(F24:F29)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R7:R8,R22,R24:R29)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,39]
[null,"Izdevumi, EUR",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,null,null,null,null,null,null,null,null,null,null,null,null,26,40]
[null,null,"Mainīgās izmaksas",null,{"$f":"E4","v":"jan"},{"$f":"F4","v":"feb"},"mar","apr","mai","jūn","jūl","aug","sep","okt","nov","dec",null,"Kopā"]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D33=\"\",\"\",'Naudas plūsma 1. gads'!D33)","v":"Gaidāmie maksājumi"},{"$f":"'Naudas plūsma 1. gads'!E33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E33:P33)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,42]
[]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D35=\"\",\"\",'Naudas plūsma 1. gads'!D35)","v":"Izejmateriāli"},{"$f":"'Naudas plūsma 1. gads'!E35","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,43]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D36=\"\",\"\",'Naudas plūsma 1. gads'!D36)","v":"Palīgmateriāli"},{"$f":"'Naudas plūsma 1. gads'!E36","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,44]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D37=\"\",\"\",'Naudas plūsma 1. gads'!D37)","v":"Ražošanā strādājošo darba alga un sociālais nodoklis"},{"$f":"'Naudas plūsma 1. gads'!E37","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,45]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D38=\"\",\"\",'Naudas plūsma 1. gads'!D38)","v":"Energoresursi"},{"$f":"'Naudas plūsma 1. gads'!E38","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,46]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D39=\"\",\"\",'Naudas plūsma 1. gads'!D39)","v":"Realizācijas izmaksas"},{"$f":"'Naudas plūsma 1. gads'!E39","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,47]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D40=\"\",\"\",'Naudas plūsma 1. gads'!D40)","v":"Transporta izmaksas "},{"$f":"'Naudas plūsma 1. gads'!E40","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,48]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D41=\"\",\"\",'Naudas plūsma 1. gads'!D41)","v":"cits"},{"$f":"'Naudas plūsma 1. gads'!E41","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,49]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D42=\"\",\"\",'Naudas plūsma 1. gads'!D42)","v":""},{"$f":"'Naudas plūsma 1. gads'!E42","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,50]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D43=\"\",\"\",'Naudas plūsma 1. gads'!D43)","v":""},{"$f":"'Naudas plūsma 1. gads'!E43","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,51]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D44=\"\",\"\",'Naudas plūsma 1. gads'!D44)","v":""},{"$f":"'Naudas plūsma 1. gads'!E44","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,52]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D45=\"\",\"\",'Naudas plūsma 1. gads'!D45)","v":""},{"$f":"'Naudas plūsma 1. gads'!E45","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,53]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D46=\"\",\"\",'Naudas plūsma 1. gads'!D46)","v":""},{"$f":"'Naudas plūsma 1. gads'!E46","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,54]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D47=\"\",\"\",'Naudas plūsma 1. gads'!D47)","v":""},{"$f":"'Naudas plūsma 1. gads'!E47","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,62]
[null,null,null,"Kopā",{"$f":"SUM(E35:E47)","v":0},{"$f":"SUM(F35:F47)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R35:R47)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,63]
[null,null,"Fiksētās izmaksas"]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D50=\"\",\"\",'Naudas plūsma 1. gads'!D50)","v":"Pastāvīgi strādājošo algas un sociālais nodoklis"},{"$f":"'Naudas plūsma 1. gads'!E50","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,64]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D51=\"\",\"\",'Naudas plūsma 1. gads'!D51)","v":"Transporta izmaksas (degviela u.c.)"},{"$f":"'Naudas plūsma 1. gads'!E51","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,65]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D52=\"\",\"\",'Naudas plūsma 1. gads'!D52)","v":"Apdrošināšana"},{"$f":"'Naudas plūsma 1. gads'!E52","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,66]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D53=\"\",\"\",'Naudas plūsma 1. gads'!D53)","v":"Nodokļi un nodevas"},{"$f":"'Naudas plūsma 1. gads'!E53","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AF2,AN2:AN52,AO2:AO52)","v":66}]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D54=\"\",\"\",'Naudas plūsma 1. gads'!D54)","v":"Ēku un ceļu remonts"},{"$f":"'Naudas plūsma 1. gads'!E54","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D55=\"\",\"\",'Naudas plūsma 1. gads'!D55)","v":"Tehnikas remonts"},{"$f":"'Naudas plūsma 1. gads'!E55","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D56=\"\",\"\",'Naudas plūsma 1. gads'!D56)","v":"Nomas maksa par ēkām, zemi"},{"$f":"'Naudas plūsma 1. gads'!E56","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D57=\"\",\"\",'Naudas plūsma 1. gads'!D57)","v":"cits"},{"$f":"'Naudas plūsma 1. gads'!E57","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D58=\"\",\"\",'Naudas plūsma 1. gads'!D58)","v":""},{"$f":"'Naudas plūsma 1. gads'!E58","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D59=\"\",\"\",'Naudas plūsma 1. gads'!D59)","v":""},{"$f":"'Naudas plūsma 1. gads'!E59","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D60=\"\",\"\",'Naudas plūsma 1. gads'!D60)","v":""},{"$f":"'Naudas plūsma 1. gads'!E60","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D61=\"\",\"\",'Naudas plūsma 1. gads'!D61)","v":""},{"$f":"'Naudas plūsma 1. gads'!E61","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D62=\"\",\"\",'Naudas plūsma 1. gads'!D62)","v":""},{"$f":"'Naudas plūsma 1. gads'!E62","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Kopā",{"$f":"SUM(E50:E62)","v":0},{"$f":"SUM(F50:F62)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R50:R62)","v":0}]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D64=\"\",\"\",'Naudas plūsma 1. gads'!D64)","v":"Līzingu maksājumi: procenti"},{"$f":"'Naudas plūsma 1. gads'!E64","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D65=\"\",\"\",'Naudas plūsma 1. gads'!D65)","v":"Līzingu maksājumi: pamatsumma"},{"$f":"'Naudas plūsma 1. gads'!E65","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Aizdevuma izlietojums",{"$f":"'Naudas plūsma 1. gads'!E66","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D67=\"\",\"\",'Naudas plūsma 1. gads'!D67)","v":"Aizdevēja* aizdevuma izlietojums"},{"$f":"'Naudas plūsma 1. gads'!E67","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D68=\"\",\"\",'Naudas plūsma 1. gads'!D68)","v":""},{"$f":"'Naudas plūsma 1. gads'!E68","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E68:P68)","v":0}]
[null,null,"PVN priekšnodoklis",null,{"$f":"($D$33*E33)+($D$35*E35)+($D$36*E36)+($D$37*E37)+($D$38*E38)+($D$39*E39)+($D$40*E40)+($D$41*E41)+($D$42*E42)+($D$43*E43)+($D$44*E44)+($D$45*E45)+($D$46*E46)+($D$47*E47)+($D$50*E50)+($D$51*E51)+($D$52*E52)+($D$53*E53)+($D$54*E54)+($D$55*E55)+($D$56*E56)+($D$57*E57)+($D$58*E58)+($D$59*E59)+($D$60*E60)+($D$61*E61)+($D$62*E62)+($D$64*E64)+($D$65*E65)+($D$66*E66)+($D$67*E67)+($D$68*E68)","v":0},{"$f":"($D$33*F33)+($D$35*F35)+($D$36*F36)+($D$37*F37)+($D$38*F38)+($D$39*F39)+($D$40*F40)+($D$41*F41)+($D$42*F42)+($D$43*F43)+($D$44*F44)+($D$45*F45)+($D$46*F46)+($D$47*F47)+($D$50*F50)+($D$51*F51)+($D$52*F52)+($D$53*F53)+($D$54*F54)+($D$55*F55)+($D$56*F56)+($D$57*F57)+($D$58*F58)+($D$59*F59)+($D$60*F60)+($D$61*F61)+($D$62*F62)+($D$64*F64)+($D$65*F65)+($D$66*F66)+($D$67*F67)+($D$68*F68)","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D70=\"\",\"\",'Naudas plūsma 1. gads'!D70)","v":"Pieprasītā Aizdevēja* aizdevuma procenti"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D71=\"\",\"\",'Naudas plūsma 1. gads'!D71)","v":"Pieprasītā Aizdevēja* aizdevuma pamatsumma"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E71:P71)","v":0}]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D72=\"\",\"\",'Naudas plūsma 1. gads'!D72)","v":"Esošo Aizdevēja* aizdevumu procenti"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D73=\"\",\"\",'Naudas plūsma 1. gads'!D73)","v":"Esošo Aizdevēja* aizdevumu pamatsumma"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D74=\"\",\"\",'Naudas plūsma 1. gads'!D74)","v":"Citu aizdevumu procenti"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D75=\"\",\"\",'Naudas plūsma 1. gads'!D75)","v":"Citu aizdevumu pamatsummas"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D76=\"\",\"\",'Naudas plūsma 1. gads'!D76)","v":"Ar pamatdarbību nesaistīto aizdevumu pamatsummas un procenti"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E76:P76)","v":0}]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D77=\"\",\"\",'Naudas plūsma 1. gads'!D77)","v":"Ienākuma nodoklis"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Naudas plūsma 1. gads'!D78=\"\",\"\",'Naudas plūsma 1. gads'!D78)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E78:P78)","v":0}]
[null,null,"Maksājamais Pievienotās vērtības nodoklis",null,{"$f":"'Naudas plūsma 1. gads'!Q29-'Naudas plūsma 1. gads'!Q69","v":0},{"$f":"E29-E69","v":0},{"$f":"F29-F69","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(E79:P79)","v":0}]
[null,null,null,"Kopējie izdevumi",{"$f":"SUM(E33,E48,E63,E64:E79)","v":0},{"$f":"SUM(F33,F48,F63,F64:F79)","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,"Perioda bilance",{"$f":"E30-E80","v":0},{"$f":"F30-F80","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[]
[null,null,null,"Beigu bilance",{"$f":"E5+E30-E80","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"*Aizdevējs - AS \"Attīstības finanšu institūcija Altum\"",null,null,"Aizņēmēja vārdā:",{"$f":"IF('Bilance un Finanšu prognoze'!D228=\"\",\"\",'Bilance un Finanšu prognoze'!D228)","v":""},null,null,null,null,{"$f":"IF('Bilance un Finanšu prognoze'!G228=\"\",\"\",'Bilance un Finanšu prognoze'!G228)","v":""}]
[null,null,null,null,null,null,"(Vārds, uzvārds)",null,null,null,null,"(Datums)"]