{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["1. gads","2. gads","3. gads","4. gads","g","R"],"not_rendered":{"charts":0,"images":1,"macros":1,"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":"1. gads","index":0,"n_rows":87,"n_cols":39,"rows_kept":87,"cut":false,"hidden":false,"merged":[[86,12,86,13],[79,3,79,4],[74,3,74,4],[86,15,86,16],[85,15,85,16],[86,7,86,10],[85,7,85,10],[78,3,78,4],[77,3,77,4],[85,12,85,13],[85,2,86,4],[80,3,80,4],[1,10,1,18],[85,5,85,6],[2,2,2,3],[2,5,2,7],[3,5,3,7],[75,3,75,4],[76,3,76,4],[70,3,70,4],[72,3,72,4],[71,3,71,4],[73,3,73,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,1,null,1]
[null,null,null,null,null,null,null,null,null,null,"NAUDAS PLŪSMA\n(1. GADS)\nSOCIĀLĀS UZŅĒMĒJDARBĪBAS PROGRAMMĀ\nDARBĪBAS PROGRAMMAS „IZAUGSME UN NODARBINĀTĪBA” \n9.1.1. SPECIFISKĀ ATBALSTA MĒRĶA “PALIELINĀT NELABVĒLĪGĀKĀ SITUĀCIJĀ \nESOŠU BEZDARBNIEKU IEKĻAUŠANOS DARBA TIRGŪ” 9.1.1.3. PASĀKUMS “ATBALSTS SOCIĀLAJAI \nUZŅĒMĒJDARBĪBAI” NR.9.1.1.3/15/i/001. PROJEKTS TIEK FINANSĒTS NO EIROPAS SOCIĀLĀ FONDA",null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,1,"LVL",1,{"$f":"\"A\"&AM55","v":"A7"},null,null,null,null,null,null,1,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,"EUR"]
[null,null,null,"Programmas dalībnieka nosaukums / Vārds, uzvārds",null,"Reģistrācijas Nr. / personas kods"]
[null,null,"Ieņēmumi, EUR"]
[null,null,null,null,"Naudas plūsmas sākuma mēnesis",{"$f":"AE57","v":"jan"},{"$f":"AE58","v":"feb"},{"$f":"AE59","v":"mar"},{"$f":"AE60","v":"apr"},{"$f":"AE61","v":"mai"},{"$f":"AE62","v":"jūn"},{"$f":"AE63","v":"jūl"},{"$f":"AE64","v":"aug"},{"$f":"AE65","v":"sep"},{"$f":"AE66","v":"okt"},{"$f":"AE67","v":"nov"},{"$f":"AE68","v":"dec"},null,"Kopā",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 sakuma",0,{"$f":"F85","v":0},{"$f":"G85","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,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,4,10]
[null,null,null,"Ieņēmumi, kas saņemti no debitoru parādu atgūšanas",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F9:Q9)","v":0},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,6,12]
[null,null,null,null,"Kopā",{"$f":"SUM(F9:F10)","v":0},{"$f":"SUM(G9:G10)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Pamatdarbības"]
[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,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,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,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,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,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,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,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,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,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,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,17,31]
[null,null,null,null,"Kopā",{"$f":"SUM(F13:F23)","v":0},{"$f":"SUM(G13:G23)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(S13:S23)","v":0},null,null,null,null,null,null,null,null,null,null,2,{"$f":"AD24-1","v":1},null,2,{"$f":"AG24-1","v":1},null,null,null,18,32]
[null,null,null,"Citi ieņēmumi"]
[null,null,null,"Saņemtie granti ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F26:Q26)","v":0},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,"Līdzdalība",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F27:Q27)","v":0},null,null,null,null,null,null,null,null,1,{"$f":"IF(AE24>=$AB$27,0,$AB$27)","v":0},{"$f":"IF(AC27=0,0,LOOKUP(AC27,$AB$27:$AB$53,#REF!))","v":0},{"$f":"IF(AC27=0,0,LOOKUP(AC27,$AB$27:$AB$53,#REF!))","v":0},{"$f":"IF($AH$24>=AB27,0,AB27)","v":0},{"$f":"IF($AF$27=0,0,LOOKUP($AF$27,$AB$27:$AB$53,#REF!))","v":0},{"$f":"IF(AF27=0,0,LOOKUP(AF27,$AB$27:$AB$53,#REF!))","v":0},null,null,null,20,34]
[null,null,null,"Ārkārtas ieņēmumi",0.21,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,2,{"$f":"IF($AE$24>=AB28,0,AC27+1)","v":1},{"$f":"IF(AC28=0,0,LOOKUP(AC28,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC28=0,0,LOOKUP(AC28,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF($AH$24>=AB28,0,AF27+1)","v":1},{"$f":"IF(AF28=0,0,LOOKUP(AF28,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF28=0,0,LOOKUP(AF28,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},null,null,null,21,35]
[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,3,2,{"$f":"IF(AC29=0,0,LOOKUP(AC29,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC29=0,0,LOOKUP(AC29,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},2,{"$f":"IF(AF29=0,0,LOOKUP(AF29,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF29=0,0,LOOKUP(AF29,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},null,null,null,22,36]
[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,4,3,{"$f":"IF(AC30=0,0,LOOKUP(AC30,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC30=0,0,LOOKUP(AC30,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},3,{"$f":"IF(AF30=0,0,LOOKUP(AF30,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF30=0,0,LOOKUP(AF30,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},null,null,null,23,37]
[null,null,null,null,"Saņemtais PVN",{"$f":"(F9*$E$9)+(F10*$E$10)+(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)+(F22*$E$22)+(F23*$E$23)+(F26*$E$26)+(F27*$E$27)+(F28*$E$28)+(F29*$E$29)+(F30*$E$30)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"(S9*$E$9)+(S10*$E$10)+(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)+(S22*$E$22)+(S23*$E$23)+(S26*$E$26)+(S27*$E$27)+(S28*$E$28)+(S29*$E$29)+(S30*$E$30)","v":0},null,null,null,null,null,null,null,null,5,4,{"$f":"IF(AC31=0,0,LOOKUP(AC31,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC31=0,0,LOOKUP(AC31,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},4,{"$f":"IF(AF31=0,0,LOOKUP(AF31,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF31=0,0,LOOKUP(AF31,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},null,null,null,24,38]
[null,null,null,null,"Kopā ieņēmumi",{"$f":"SUM(F11)+F24+SUM(F26:F31)","v":0},{"$f":"SUM(G11)+G24+SUM(G26:G31)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(S9:S10,S24,S26:S31)","v":0},null,null,null,null,null,null,null,null,6,5,{"$f":"IF(AC32=0,0,LOOKUP(AC32,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC32=0,0,LOOKUP(AC32,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},5,{"$f":"IF(AF32=0,0,LOOKUP(AF32,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF32=0,0,LOOKUP(AF32,$AB$27:$AB$53,#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,7,6,{"$f":"IF(AC33=0,0,LOOKUP(AC33,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC33=0,0,LOOKUP(AC33,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},6,{"$f":"IF(AF33=0,0,LOOKUP(AF33,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF33=0,0,LOOKUP(AF33,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},null,null,null,26,40]
[null,null,null,"Mainīgās izmaksas",null,{"$f":"F6","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.21,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F35:Q35)","v":0},null,null,null,null,null,null,null,null,8,{"$f":"IF($AE$24>=AB35,0,AC33+1)","v":7},{"$f":"IF(AC35=0,0,LOOKUP(AC35,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC35=0,0,LOOKUP(AC35,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF($AH$24>=AB35,0,AF33+1)","v":7},{"$f":"IF(AF35=0,0,LOOKUP(AF35,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF35=0,0,LOOKUP(AF35,$AB$27:$AB$53,#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,9,{"$f":"IF($AE$24>=AB37,0,AC35+1)","v":8},{"$f":"IF(AC37=0,0,LOOKUP(AC37,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC37=0,0,LOOKUP(AC37,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF($AH$24>=AB37,0,AF35+1)","v":8},{"$f":"IF(AF37=0,0,LOOKUP(AF37,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF37=0,0,LOOKUP(AF37,$AB$27:$AB$53,#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,10,9,{"$f":"IF(AC38=0,0,LOOKUP(AC38,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC38=0,0,LOOKUP(AC38,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},9,{"$f":"IF(AF38=0,0,LOOKUP(AF38,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF38=0,0,LOOKUP(AF38,$AB$27:$AB$53,#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,11,10,{"$f":"IF(AC39=0,0,LOOKUP(AC39,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC39=0,0,LOOKUP(AC39,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},10,{"$f":"IF(AF39=0,0,LOOKUP(AF39,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF39=0,0,LOOKUP(AF39,$AB$27:$AB$53,#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,12,11,{"$f":"IF(AC40=0,0,LOOKUP(AC40,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC40=0,0,LOOKUP(AC40,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},11,{"$f":"IF(AF40=0,0,LOOKUP(AF40,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF40=0,0,LOOKUP(AF40,$AB$27:$AB$53,#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,13,12,{"$f":"IF(AC41=0,0,LOOKUP(AC41,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC41=0,0,LOOKUP(AC41,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},12,{"$f":"IF(AF41=0,0,LOOKUP(AF41,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF41=0,0,LOOKUP(AF41,$AB$27:$AB$53,#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,14,13,{"$f":"IF(AC42=0,0,LOOKUP(AC42,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC42=0,0,LOOKUP(AC42,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},13,{"$f":"IF(AF42=0,0,LOOKUP(AF42,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF42=0,0,LOOKUP(AF42,$AB$27:$AB$53,#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,15,14,{"$f":"IF(AC43=0,0,LOOKUP(AC43,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC43=0,0,LOOKUP(AC43,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},14,{"$f":"IF(AF43=0,0,LOOKUP(AF43,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF43=0,0,LOOKUP(AF43,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},null,null,null,34,49]
[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,16,15,{"$f":"IF(AC44=0,0,LOOKUP(AC44,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC44=0,0,LOOKUP(AC44,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},15,{"$f":"IF(AF44=0,0,LOOKUP(AF44,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF44=0,0,LOOKUP(AF44,$AB$27:$AB$53,#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,17,16,{"$f":"IF(AC45=0,0,LOOKUP(AC45,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC45=0,0,LOOKUP(AC45,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},16,{"$f":"IF(AF45=0,0,LOOKUP(AF45,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF45=0,0,LOOKUP(AF45,$AB$27:$AB$53,#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,18,17,{"$f":"IF(AC46=0,0,LOOKUP(AC46,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC46=0,0,LOOKUP(AC46,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},17,{"$f":"IF(AF46=0,0,LOOKUP(AF46,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF46=0,0,LOOKUP(AF46,$AB$27:$AB$53,#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,19,18,{"$f":"IF(AC47=0,0,LOOKUP(AC47,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC47=0,0,LOOKUP(AC47,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},18,{"$f":"IF(AF47=0,0,LOOKUP(AF47,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF47=0,0,LOOKUP(AF47,$AB$27:$AB$53,#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,20,19,{"$f":"IF(AC48=0,0,LOOKUP(AC48,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC48=0,0,LOOKUP(AC48,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},19,{"$f":"IF(AF48=0,0,LOOKUP(AF48,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF48=0,0,LOOKUP(AF48,$AB$27:$AB$53,#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,21,20,{"$f":"IF(AC49=0,0,LOOKUP(AC49,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC49=0,0,LOOKUP(AC49,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},20,{"$f":"IF(AF49=0,0,LOOKUP(AF49,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF49=0,0,LOOKUP(AF49,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},null,null,null,40,62]
[null,null,null,null,"Kopā",{"$f":"SUM(F37:F49)","v":0},{"$f":"SUM(G37:G49)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(S37:S49)","v":0},null,null,null,null,null,null,null,null,22,21,{"$f":"IF(AC50=0,0,LOOKUP(AC50,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC50=0,0,LOOKUP(AC50,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},21,{"$f":"IF(AF50=0,0,LOOKUP(AF50,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF50=0,0,LOOKUP(AF50,$AB$27:$AB$53,#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,23,{"$f":"IF($AE$24>=AB52,0,AC50+1)","v":22},{"$f":"IF(AC52=0,0,LOOKUP(AC52,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC52=0,0,LOOKUP(AC52,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF($AH$24>=AB52,0,AF50+1)","v":22},{"$f":"IF(AF52=0,0,LOOKUP(AF52,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF52=0,0,LOOKUP(AF52,$AB$27:$AB$53,#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,24,23,{"$f":"IF(AC53=0,0,LOOKUP(AC53,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AC53=0,0,LOOKUP(AC53,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},23,{"$f":"IF(AF53=0,0,LOOKUP(AF53,$AB$27:$AB$53,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(AF53=0,0,LOOKUP(AF53,$AB$27:$AB$53,#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,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,{"$f":"LOOKUP(AD2,AL2:AL54,AM2:AM54)","v":7}]
[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,"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,1,"jan",{"$f":"AB81","v":1},{"$f":"AC81","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,2,"feb",{"$f":"IF(AD57=24,1,AD57+1)","v":2},{"$f":"LOOKUP(AD58,$AB$57:$AB$80,$AC$57:$AC$80)","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,3,"mar",3,"mar"]
[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,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,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,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,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,8,"aug",8,"aug"]
[null,null,null,null,"Kopā",{"$f":"SUM(F52:F64)","v":0},{"$f":"SUM(G52:G64)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(S52:S64)","v":0},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,10,"okt",{"$f":"IF(AD65=24,1,AD65+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,11,"nov",11,"nov"]
[null,null,null,"Grantu izlietojums",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,12,"dec",12,"dec"]
[null,null,null,"Līdzdalības izlietojums",0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,13,"jan",13,{"$f":"LOOKUP(AD69,$AB$57:$AB$80,$AC$57:$AC$80)&\"-2.gads\"","v":"jan-2.gads"}]
[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,14,"feb",14,"feb-2.gads"]
[null,null,null,"PVN priekšnodoklis",null,{"$f":"(F35*$E$35)+(F37*$E$37)+(F38*$E$38)+(F39*$E$39)+(F40*$E$40)+(F41*$E$41)+(F42*$E$42)+(F43*$E$43)+(F44*$E$44)+(F45*$E$45)+(F46*$E$46)+(F47*$E$47)+(F48*$E$48)+(F49*$E$49)+(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)+(F63*$E$63)+(F64*$E$64)+(F66*$E$66)+(F67*$E$67)+(F68*$E$68)+(F69*$E$69)+(F70*$E$70)","v":0},{"$f":"(G35*$E$35)+(G37*$E$37)+(G38*$E$38)+(G39*$E$39)+(G40*$E$40)+(G41*$E$41)+(G42*$E$42)+(G43*$E$43)+(G44*$E$44)+(G45*$E$45)+(G46*$E$46)+(G47*$E$47)+(G48*$E$48)+(G49*$E$49)+(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)+(G63*$E$63)+(G64*$E$64)+(G66*$E$66)+(G67*$E$67)+(G68*$E$68)+(G69*$E$69)+(G70*$E$70)","v":0},0,0,0,0,0,0,0,0,0,0,null,0,null,null,null,null,null,null,null,null,15,"mar",15,"mar-2.gads"]
[null,null,null,"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,16,"apr",16,"apr-2.gads"]
[null,null,null,"Aizdevumu pamatsumma",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F73:Q73)","v":0},null,null,null,null,null,null,null,null,17,"mai",17,"mai-2.gads"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F74:Q74)","v":0},null,null,null,null,null,null,null,null,18,"jūn",18,"jūn-2.gads"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,19,"jūl",19,"jūl-2.gads"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,20,"aug",20,"aug-2.gads"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,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(F78:Q78)","v":0},null,null,null,null,null,null,null,null,22,"okt",{"$f":"IF(AD77=24,1,AD77+1)","v":22},"okt-2.gads"]
[null,null,null,"Ienākuma nodoklis / Mikrouzņēmuma nodoklis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,23,"nov",{"$f":"IF(AD78=24,1,AD78+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(F80:Q80)","v":0},null,null,null,null,null,null,null,null,24,"dec",{"$f":"IF(AD79=24,1,AD79+1)","v":24},"dec-2.gads"]
[null,null,null,"Maksājamais Pievienotās vērtības nodoklis",null,null,{"$f":"F31-F71","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(F81:Q81)","v":0},null,null,null,null,null,null,null,null,1,{"$f":"LOOKUP(AB81,$AB$57:$AB$80,$AC$57:$AC$80)","v":"jan"},null,{"$error":"#N/A"}]
[null,null,null,null,"Kopējie izdevumi",{"$f":"SUM(F35,F50,F65,F66:F81)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(S35,S50,S65,S66:S81)","v":0}]
[null,null,null,null,"Perioda bilance",{"$f":"F32-F82","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"S32-S82","v":0}]
[]
[null,null,null,null,"Beigu bilance",{"$f":"F7+F32-F82","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"\n* Dokuments var būt bez paraksta, ja dokuments ir jāparaksta tikai Programmas dalībnieka pārstāvim un šis pārstāvis iesniedzis dokumentu izmantojot attālināto darījumu sistēmu internetā mans.altum.lv",null,null,"Programmas dalībnieka vārdā:"]
[null,null,null,null,null,null,null,"(Vārds, uzvārds)",null,null,null,null,"(Datums)",null,null,"(Paraksts)*"]

{"sheet":"2. gads","index":1,"n_rows":86,"n_cols":41,"rows_kept":86,"cut":false,"hidden":false,"merged":[[71,2,71,3],[73,2,73,3],[69,2,69,3],[84,11,84,12],[84,14,84,15],[74,2,74,3],[75,2,75,3],[76,2,76,3],[70,2,70,3],[72,2,72,3],[78,2,78,3],[77,2,77,3],[79,2,79,3],[84,6,84,9],[84,2,86,3],[1,8,2,17],[84,4,84,5],[85,6,85,9],[85,11,85,12],[85,14,85,15]]}
[]
[null,null,null,null,null,null,null,null,"NAUDAS PLŪSMA\n(2. GADS)\nSOCIĀLĀS UZŅĒMĒJDARBĪBAS PROGRAMMĀ\nDARBĪBAS PROGRAMMAS „IZAUGSME UN NODARBINĀTĪBA” \n9.1.1. SPECIFISKĀ ATBALSTA MĒRĶA “PALIELINĀT NELABVĒLĪGĀKĀ SITUĀCIJĀ \nESOŠU BEZDARBNIEKU IEKĻAUŠANOS DARBA TIRGŪ” 9.1.1.3. PASĀKUMS “ATBALSTS SOCIĀLAJAI \nUZŅĒMĒJDARBĪBAI” NR.9.1.1.3/15/i/001. PROJEKTS TIEK FINANSĒTS NO EIROPAS SOCIĀLĀ FONDA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"\"A\"&AO54","v":"A66"},null,null,null,null,null,null,1,7]
[null,{"$f":"IF('1. gads'!$C$3=\"\",\"\",'1. gads'!$C$3)","v":""}]
[null,"Ieņēmumi, EUR"]
[null,null,null,null,{"$f":"'1. gads'!F6","v":"jan"},{"$f":"'1. gads'!G6","v":"feb"},{"$f":"'1. gads'!H6","v":"mar"},{"$f":"'1. gads'!I6","v":"apr"},{"$f":"'1. gads'!J6","v":"mai"},{"$f":"'1. gads'!K6","v":"jūn"},{"$f":"'1. gads'!L6","v":"jūl"},{"$f":"'1. gads'!M6","v":"aug"},{"$f":"'1. gads'!N6","v":"sep"},{"$f":"'1. gads'!O6","v":"okt"},{"$f":"'1. gads'!P6","v":"nov"},{"$f":"'1. gads'!Q6","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":"'1. gads'!Q85","v":0},{"$f":"E84","v":0},{"$f":"F84","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('1. gads'!D9=\"\",\"\",'1. gads'!D9)","v":"Ieņēmumi, kas saņemti no debitoru parādu atgūšanas"},{"$f":"'1. gads'!E9","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:P8)","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('1. gads'!D10=\"\",\"\",'1. gads'!D10)","v":"Ieņēmumi no krājumu pārdošanas"},{"$f":"'1. gads'!E10","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(E8:E9)","v":0},{"$f":"SUM(F8:F9)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R8:R9)","v":0}]
[null,null,"Pamatdarbības"]
[null,null,{"$f":"IF('1. gads'!D13=\"\",\"\",'1. gads'!D13)","v":""},{"$f":"'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,7,13]
[null,null,{"$f":"IF('1. gads'!D14=\"\",\"\",'1. gads'!D14)","v":""},{"$f":"'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,8,14]
[null,null,{"$f":"IF('1. gads'!D15=\"\",\"\",'1. gads'!D15)","v":""},{"$f":"'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,9,15]
[null,null,{"$f":"IF('1. gads'!D16=\"\",\"\",'1. gads'!D16)","v":""},{"$f":"'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,10,16]
[null,null,{"$f":"IF('1. gads'!D17=\"\",\"\",'1. gads'!D17)","v":""},{"$f":"'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,11,17]
[null,null,{"$f":"IF('1. gads'!D18=\"\",\"\",'1. gads'!D18)","v":""},{"$f":"'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,12,18]
[null,null,{"$f":"IF('1. gads'!D19=\"\",\"\",'1. gads'!D19)","v":""},{"$f":"'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,13,19]
[null,null,{"$f":"IF('1. gads'!D20=\"\",\"\",'1. gads'!D20)","v":""},{"$f":"'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,14,28]
[null,null,{"$f":"IF('1. gads'!D21=\"\",\"\",'1. gads'!D21)","v":""},{"$f":"'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,15,29]
[null,null,{"$f":"IF('1. gads'!D22=\"\",\"\",'1. gads'!D22)","v":""},{"$f":"'1. gads'!E22","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('1. gads'!D23=\"\",\"\",'1. gads'!D23)","v":""},{"$f":"'1. gads'!E23","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(E12:E22)","v":0},{"$f":"SUM(F12:F22)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R12:R22)","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('1. gads'!D26=\"\",\"\",'1. gads'!D26)","v":"Saņemtie granti "},{"$f":"'1. gads'!E26","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,19,33]
[null,null,{"$f":"IF('1. gads'!D27=\"\",\"\",'1. gads'!D27)","v":"Līdzdalība"},{"$f":"'1. gads'!E27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E26:P26)","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('1. gads'!D28=\"\",\"\",'1. gads'!D28)","v":"Ārkārtas ieņēmumi"},{"$f":"'1. gads'!E28","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,21,35]
[null,null,{"$f":"IF('1. gads'!D29=\"\",\"\",'1. gads'!D29)","v":""},{"$f":"'1. gads'!E29","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,22,36]
[null,null,{"$f":"IF('1. gads'!D30=\"\",\"\",'1. gads'!D30)","v":""},{"$f":"'1. gads'!E30","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,23,37]
[null,null,null,"Saņemtais PVN",{"$f":"($D$8*E8)+($D$9*E9)+($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$22*E22)+($D$25*E25)+($D$26*E26)+($D$27*E27)+($D$28*E28)+($D$29*E29)","v":0},{"$f":"($D$8*F8)+($D$9*F9)+($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$22*F22)+($D$25*F25)+($D$26*F26)+($D$27*F27)+($D$28*F28)+($D$29*F29)","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":"E10+E23+SUM(E25:E30)","v":0},{"$f":"F10+F23+SUM(F25:F30)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R8:R9,R23,R25:R30)","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":"E5","v":"jan"},{"$f":"F5","v":"feb"},"mar","apr","mai","jūn","jūl","aug","sep","okt","nov","dec",null,"Kopā"]
[null,null,{"$f":"IF('1. gads'!D35=\"\",\"\",'1. gads'!D35)","v":"Gaidāmie maksājumi"},{"$f":"'1. gads'!E35","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E34:P34)","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('1. gads'!D37=\"\",\"\",'1. gads'!D37)","v":"Izejmateriāli"},{"$f":"'1. gads'!E37","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('1. gads'!D38=\"\",\"\",'1. gads'!D38)","v":"Palīgmateriāli"},{"$f":"'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,29,44]
[null,null,{"$f":"IF('1. gads'!D39=\"\",\"\",'1. gads'!D39)","v":"Ražošanā strādājošo darba alga un sociālais nodoklis"},{"$f":"'1. gads'!E39","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('1. gads'!D40=\"\",\"\",'1. gads'!D40)","v":"Energoresursi"},{"$f":"'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,31,46]
[null,null,{"$f":"IF('1. gads'!D41=\"\",\"\",'1. gads'!D41)","v":"Realizācijas izmaksas"},{"$f":"'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,32,47]
[null,null,{"$f":"IF('1. gads'!D42=\"\",\"\",'1. gads'!D42)","v":"Transporta izmaksas "},{"$f":"'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,33,48]
[null,null,{"$f":"IF('1. gads'!D43=\"\",\"\",'1. gads'!D43)","v":"cits"},{"$f":"'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,34,49]
[null,null,{"$f":"IF('1. gads'!D44=\"\",\"\",'1. gads'!D44)","v":"cits"},{"$f":"'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,35,50]
[null,null,{"$f":"IF('1. gads'!D45=\"\",\"\",'1. gads'!D45)","v":""},{"$f":"'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,36,51]
[null,null,{"$f":"IF('1. gads'!D46=\"\",\"\",'1. gads'!D46)","v":""},{"$f":"'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,37,52]
[null,null,{"$f":"IF('1. gads'!D47=\"\",\"\",'1. gads'!D47)","v":""},{"$f":"'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,38,53]
[null,null,{"$f":"IF('1. gads'!D48=\"\",\"\",'1. gads'!D48)","v":""},{"$f":"'1. gads'!E48","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('1. gads'!D49=\"\",\"\",'1. gads'!D49)","v":""},{"$f":"'1. gads'!E49","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(E36:E48)","v":0},{"$f":"SUM(F36:F48)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R36:R48)","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('1. gads'!D52=\"\",\"\",'1. gads'!D52)","v":"Pastāvīgi strādājošo algas un sociālais nodoklis"},{"$f":"'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,42,64]
[null,null,{"$f":"IF('1. gads'!D53=\"\",\"\",'1. gads'!D53)","v":"Transporta izmaksas (degviela u.c.)"},{"$f":"'1. gads'!E53","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('1. gads'!D54=\"\",\"\",'1. gads'!D54)","v":"Apdrošināšana"},{"$f":"'1. gads'!E54","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('1. gads'!D55=\"\",\"\",'1. gads'!D55)","v":"Nodokļi un nodevas"},{"$f":"'1. gads'!E55","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:AN53,AO2:AO53)","v":66}]
[null,null,{"$f":"IF('1. gads'!D56=\"\",\"\",'1. gads'!D56)","v":"Ēku un ceļu remonts"},{"$f":"'1. gads'!E56","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D57=\"\",\"\",'1. gads'!D57)","v":"Tehnikas remonts"},{"$f":"'1. gads'!E57","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D58=\"\",\"\",'1. gads'!D58)","v":"Nomas maksa par ēkām, zemi"},{"$f":"'1. gads'!E58","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D59=\"\",\"\",'1. gads'!D59)","v":"cits"},{"$f":"'1. gads'!E59","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D60=\"\",\"\",'1. gads'!D60)","v":"cits"},{"$f":"'1. gads'!E60","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D61=\"\",\"\",'1. gads'!D61)","v":""},{"$f":"'1. gads'!E61","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D62=\"\",\"\",'1. gads'!D62)","v":""},{"$f":"'1. gads'!E62","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D63=\"\",\"\",'1. gads'!D63)","v":""},{"$f":"'1. gads'!E63","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D64=\"\",\"\",'1. gads'!D64)","v":""},{"$f":"'1. gads'!E64","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Kopā",{"$f":"SUM(E51:E63)","v":0},{"$f":"SUM(F51:F63)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R51:R63)","v":0}]
[null,null,{"$f":"IF('1. gads'!D66=\"\",\"\",'1. gads'!D66)","v":"Līzingu maksājumi: procenti"},{"$f":"'1. gads'!E66","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D67=\"\",\"\",'1. gads'!D67)","v":"Līzingu maksājumi: pamatsumma"},{"$f":"'1. gads'!E67","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Aizdevuma izlietojums",{"$f":"'1. gads'!E68","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D69=\"\",\"\",'1. gads'!D69)","v":"Līdzdalības izlietojums"},{"$f":"'1. gads'!E69","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D70=\"\",\"\",'1. gads'!D70)","v":""},{"$f":"'1. gads'!E70","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E69:P69)","v":0}]
[null,null,"PVN priekšnodoklis",null,{"$f":"($D$34*E34)+($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$48*E48)+($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$63*E63)+($D$65*E65)+($D$66*E66)+($D$67*E67)+($D$68*E68)+($D$69*E69)","v":0},{"$f":"($D$34*F34)+($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$48*F48)+($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$63*F63)+($D$65*F65)+($D$66*F66)+($D$67*F67)+($D$68*F68)+($D$69*F69)","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,{"$f":"IF('1. gads'!D72=\"\",\"\",'1. gads'!D72)","v":"Aizdevumu procenti"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D73=\"\",\"\",'1. gads'!D73)","v":"Aizdevumu pamatsumma"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E72:P72)","v":0}]
[null,null,{"$f":"IF('1. gads'!D74=\"\",\"\",'1. gads'!D74)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D75=\"\",\"\",'1. gads'!D75)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D76=\"\",\"\",'1. gads'!D76)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D77=\"\",\"\",'1. gads'!D77)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D78=\"\",\"\",'1. gads'!D78)","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(E77:P77)","v":0}]
[null,null,{"$f":"IF('1. gads'!D79=\"\",\"\",'1. gads'!D79)","v":"Ienākuma nodoklis / Mikrouzņēmuma nodoklis"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D80=\"\",\"\",'1. gads'!D80)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E79:P79)","v":0}]
[null,null,"Maksājamais Pievienotās vērtības nodoklis",null,{"$f":"'1. gads'!Q31-'1. gads'!Q71","v":0},{"$f":"E30-E70","v":0},{"$f":"F30-F70","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(E80:P80)","v":0}]
[null,null,null,"Kopējie izdevumi",{"$f":"SUM(E34,E49,E64,E65:E80)","v":0},{"$f":"SUM(F34,F49,F64,F65:F80)","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,"Perioda bilance",{"$f":"E31-E81","v":0},{"$f":"F31-F81","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[]
[null,null,null,"Beigu bilance",{"$f":"E6+E31-E81","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"\n* Dokuments var būt bez paraksta, ja dokuments ir jāparaksta tikai Programmas dalībnieka pārstāvim un šis pārstāvis iesniedzis dokumentu izmantojot attālināto darījumu sistēmu internetā mans.altum.lv",null,"Programmas dalībnieka vārdā:",null,{"$f":"IF('1. gads'!H86=\"\",\"\",'1. gads'!H86)","v":""},null,null,null,null,{"$f":"IF('1. gads'!M86=\"\",\"\",'1. gads'!M86)","v":""}]
[null,null,null,null,null,null,"(Vārds, uzvārds)",null,null,null,null,"(Datums)",null,null,"(Paraksts)*"]

{"sheet":"3. gads","index":2,"n_rows":86,"n_cols":41,"rows_kept":86,"cut":false,"hidden":false,"merged":[[74,2,74,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[85,6,85,9],[85,11,85,12],[85,14,85,15],[75,2,75,3],[76,2,76,3],[77,2,77,3],[78,2,78,3],[79,2,79,3],[84,2,86,3],[1,8,2,17],[84,4,84,5],[84,6,84,9],[84,11,84,12],[84,14,84,15]]}
[]
[null,null,null,null,null,null,null,null,"NAUDAS PLŪSMA\n(3. GADS)\nSOCIĀLĀS UZŅĒMĒJDARBĪBAS PROGRAMMĀ\nDARBĪBAS PROGRAMMAS „IZAUGSME UN NODARBINĀTĪBA” \n9.1.1. SPECIFISKĀ ATBALSTA MĒRĶA “PALIELINĀT NELABVĒLĪGĀKĀ SITUĀCIJĀ \nESOŠU BEZDARBNIEKU IEKĻAUŠANOS DARBA TIRGŪ” 9.1.1.3. PASĀKUMS “ATBALSTS SOCIĀLAJAI \nUZŅĒMĒJDARBĪBAI” NR.9.1.1.3/15/i/001. PROJEKTS TIEK FINANSĒTS NO EIROPAS SOCIĀLĀ FONDA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"\"A\"&AO54","v":"A66"},null,null,null,null,null,null,1,7]
[null,{"$f":"IF('1. gads'!$C$3=\"\",\"\",'1. gads'!$C$3)","v":""}]
[null,"Ieņēmumi, EUR"]
[null,null,null,null,{"$f":"'1. gads'!F6","v":"jan"},{"$f":"'1. gads'!G6","v":"feb"},{"$f":"'1. gads'!H6","v":"mar"},{"$f":"'1. gads'!I6","v":"apr"},{"$f":"'1. gads'!J6","v":"mai"},{"$f":"'1. gads'!K6","v":"jūn"},{"$f":"'1. gads'!L6","v":"jūl"},{"$f":"'1. gads'!M6","v":"aug"},{"$f":"'1. gads'!N6","v":"sep"},{"$f":"'1. gads'!O6","v":"okt"},{"$f":"'1. gads'!P6","v":"nov"},{"$f":"'1. gads'!Q6","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":"'2. gads'!P84","v":0},{"$f":"E84","v":0},{"$f":"F84","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('1. gads'!D9=\"\",\"\",'1. gads'!D9)","v":"Ieņēmumi, kas saņemti no debitoru parādu atgūšanas"},{"$f":"'1. gads'!E9","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:P8)","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('1. gads'!D10=\"\",\"\",'1. gads'!D10)","v":"Ieņēmumi no krājumu pārdošanas"},{"$f":"'1. gads'!E10","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(E8:E9)","v":0},{"$f":"SUM(F8:F9)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R8:R9)","v":0}]
[null,null,"Pamatdarbības"]
[null,null,{"$f":"IF('1. gads'!D13=\"\",\"\",'1. gads'!D13)","v":""},{"$f":"'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,7,13]
[null,null,{"$f":"IF('1. gads'!D14=\"\",\"\",'1. gads'!D14)","v":""},{"$f":"'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,8,14]
[null,null,{"$f":"IF('1. gads'!D15=\"\",\"\",'1. gads'!D15)","v":""},{"$f":"'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,9,15]
[null,null,{"$f":"IF('1. gads'!D16=\"\",\"\",'1. gads'!D16)","v":""},{"$f":"'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,10,16]
[null,null,{"$f":"IF('1. gads'!D17=\"\",\"\",'1. gads'!D17)","v":""},{"$f":"'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,11,17]
[null,null,{"$f":"IF('1. gads'!D18=\"\",\"\",'1. gads'!D18)","v":""},{"$f":"'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,12,18]
[null,null,{"$f":"IF('1. gads'!D19=\"\",\"\",'1. gads'!D19)","v":""},{"$f":"'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,13,19]
[null,null,{"$f":"IF('1. gads'!D20=\"\",\"\",'1. gads'!D20)","v":""},{"$f":"'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,14,28]
[null,null,{"$f":"IF('1. gads'!D21=\"\",\"\",'1. gads'!D21)","v":""},{"$f":"'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,15,29]
[null,null,{"$f":"IF('1. gads'!D22=\"\",\"\",'1. gads'!D22)","v":""},{"$f":"'1. gads'!E22","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('1. gads'!D23=\"\",\"\",'1. gads'!D23)","v":""},{"$f":"'1. gads'!E23","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(E12:E22)","v":0},{"$f":"SUM(F12:F22)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R12:R22)","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('1. gads'!D26=\"\",\"\",'1. gads'!D26)","v":"Saņemtie granti "},{"$f":"'1. gads'!E26","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,19,33]
[null,null,{"$f":"IF('1. gads'!D27=\"\",\"\",'1. gads'!D27)","v":"Līdzdalība"},{"$f":"'1. gads'!E27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E26:P26)","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('1. gads'!D28=\"\",\"\",'1. gads'!D28)","v":"Ārkārtas ieņēmumi"},{"$f":"'1. gads'!E28","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,21,35]
[null,null,{"$f":"IF('1. gads'!D29=\"\",\"\",'1. gads'!D29)","v":""},{"$f":"'1. gads'!E29","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,22,36]
[null,null,{"$f":"IF('1. gads'!D30=\"\",\"\",'1. gads'!D30)","v":""},{"$f":"'1. gads'!E30","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,23,37]
[null,null,null,"Saņemtais PVN",{"$f":"($D$8*E8)+($D$9*E9)+($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$22*E22)+($D$25*E25)+($D$26*E26)+($D$27*E27)+($D$28*E28)+($D$29*E29)","v":0},{"$f":"($D$8*F8)+($D$9*F9)+($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$22*F22)+($D$25*F25)+($D$26*F26)+($D$27*F27)+($D$28*F28)+($D$29*F29)","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":"E10+E23+SUM(E25:E30)","v":0},{"$f":"F10+F23+SUM(F25:F30)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R8:R9,R23,R25:R30)","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":"E5","v":"jan"},{"$f":"F5","v":"feb"},"mar","apr","mai","jūn","jūl","aug","sep","okt","nov","dec",null,"Kopā"]
[null,null,{"$f":"IF('1. gads'!D35=\"\",\"\",'1. gads'!D35)","v":"Gaidāmie maksājumi"},{"$f":"'1. gads'!E35","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E34:P34)","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('1. gads'!D37=\"\",\"\",'1. gads'!D37)","v":"Izejmateriāli"},{"$f":"'1. gads'!E37","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('1. gads'!D38=\"\",\"\",'1. gads'!D38)","v":"Palīgmateriāli"},{"$f":"'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,29,44]
[null,null,{"$f":"IF('1. gads'!D39=\"\",\"\",'1. gads'!D39)","v":"Ražošanā strādājošo darba alga un sociālais nodoklis"},{"$f":"'1. gads'!E39","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('1. gads'!D40=\"\",\"\",'1. gads'!D40)","v":"Energoresursi"},{"$f":"'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,31,46]
[null,null,{"$f":"IF('1. gads'!D41=\"\",\"\",'1. gads'!D41)","v":"Realizācijas izmaksas"},{"$f":"'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,32,47]
[null,null,{"$f":"IF('1. gads'!D42=\"\",\"\",'1. gads'!D42)","v":"Transporta izmaksas "},{"$f":"'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,33,48]
[null,null,{"$f":"IF('1. gads'!D43=\"\",\"\",'1. gads'!D43)","v":"cits"},{"$f":"'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,34,49]
[null,null,{"$f":"IF('1. gads'!D44=\"\",\"\",'1. gads'!D44)","v":"cits"},{"$f":"'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,35,50]
[null,null,{"$f":"IF('1. gads'!D45=\"\",\"\",'1. gads'!D45)","v":""},{"$f":"'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,36,51]
[null,null,{"$f":"IF('1. gads'!D46=\"\",\"\",'1. gads'!D46)","v":""},{"$f":"'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,37,52]
[null,null,{"$f":"IF('1. gads'!D47=\"\",\"\",'1. gads'!D47)","v":""},{"$f":"'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,38,53]
[null,null,{"$f":"IF('1. gads'!D48=\"\",\"\",'1. gads'!D48)","v":""},{"$f":"'1. gads'!E48","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('1. gads'!D49=\"\",\"\",'1. gads'!D49)","v":""},{"$f":"'1. gads'!E49","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(E36:E48)","v":0},{"$f":"SUM(F36:F48)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R36:R48)","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('1. gads'!D52=\"\",\"\",'1. gads'!D52)","v":"Pastāvīgi strādājošo algas un sociālais nodoklis"},{"$f":"'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,42,64]
[null,null,{"$f":"IF('1. gads'!D53=\"\",\"\",'1. gads'!D53)","v":"Transporta izmaksas (degviela u.c.)"},{"$f":"'1. gads'!E53","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('1. gads'!D54=\"\",\"\",'1. gads'!D54)","v":"Apdrošināšana"},{"$f":"'1. gads'!E54","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('1. gads'!D55=\"\",\"\",'1. gads'!D55)","v":"Nodokļi un nodevas"},{"$f":"'1. gads'!E55","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:AN53,AO2:AO53)","v":66}]
[null,null,{"$f":"IF('1. gads'!D56=\"\",\"\",'1. gads'!D56)","v":"Ēku un ceļu remonts"},{"$f":"'1. gads'!E56","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D57=\"\",\"\",'1. gads'!D57)","v":"Tehnikas remonts"},{"$f":"'1. gads'!E57","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D58=\"\",\"\",'1. gads'!D58)","v":"Nomas maksa par ēkām, zemi"},{"$f":"'1. gads'!E58","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D59=\"\",\"\",'1. gads'!D59)","v":"cits"},{"$f":"'1. gads'!E59","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D60=\"\",\"\",'1. gads'!D60)","v":"cits"},{"$f":"'1. gads'!E60","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D61=\"\",\"\",'1. gads'!D61)","v":""},{"$f":"'1. gads'!E61","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D62=\"\",\"\",'1. gads'!D62)","v":""},{"$f":"'1. gads'!E62","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D63=\"\",\"\",'1. gads'!D63)","v":""},{"$f":"'1. gads'!E63","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D64=\"\",\"\",'1. gads'!D64)","v":""},{"$f":"'1. gads'!E64","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Kopā",{"$f":"SUM(E51:E63)","v":0},{"$f":"SUM(F51:F63)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R51:R63)","v":0}]
[null,null,{"$f":"IF('1. gads'!D66=\"\",\"\",'1. gads'!D66)","v":"Līzingu maksājumi: procenti"},{"$f":"'1. gads'!E66","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D67=\"\",\"\",'1. gads'!D67)","v":"Līzingu maksājumi: pamatsumma"},{"$f":"'1. gads'!E67","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Aizdevuma izlietojums",{"$f":"'1. gads'!E68","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D69=\"\",\"\",'1. gads'!D69)","v":"Līdzdalības izlietojums"},{"$f":"'1. gads'!E69","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D70=\"\",\"\",'1. gads'!D70)","v":""},{"$f":"'1. gads'!E70","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E69:P69)","v":0}]
[null,null,"PVN priekšnodoklis",null,{"$f":"($D$34*E34)+($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$48*E48)+($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$63*E63)+($D$65*E65)+($D$66*E66)+($D$67*E67)+($D$68*E68)+($D$69*E69)","v":0},{"$f":"($D$34*F34)+($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$48*F48)+($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$63*F63)+($D$65*F65)+($D$66*F66)+($D$67*F67)+($D$68*F68)+($D$69*F69)","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,{"$f":"IF('1. gads'!D72=\"\",\"\",'1. gads'!D72)","v":"Aizdevumu procenti"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D73=\"\",\"\",'1. gads'!D73)","v":"Aizdevumu pamatsumma"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E72:P72)","v":0}]
[null,null,{"$f":"IF('1. gads'!D74=\"\",\"\",'1. gads'!D74)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D75=\"\",\"\",'1. gads'!D75)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D76=\"\",\"\",'1. gads'!D76)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D77=\"\",\"\",'1. gads'!D77)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D78=\"\",\"\",'1. gads'!D78)","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(E77:P77)","v":0}]
[null,null,{"$f":"IF('1. gads'!D79=\"\",\"\",'1. gads'!D79)","v":"Ienākuma nodoklis / Mikrouzņēmuma nodoklis"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D80=\"\",\"\",'1. gads'!D80)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E79:P79)","v":0}]
[null,null,"Maksājamais Pievienotās vērtības nodoklis",null,{"$f":"'2. gads'!P30-'2. gads'!P70","v":0},{"$f":"E30-E70","v":0},{"$f":"F30-F70","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(E80:P80)","v":0}]
[null,null,null,"Kopējie izdevumi",{"$f":"SUM(E34,E49,E64,E65:E80)","v":0},{"$f":"SUM(F34,F49,F64,F65:F80)","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,"Perioda bilance",{"$f":"E31-E81","v":0},{"$f":"F31-F81","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[]
[null,null,null,"Beigu bilance",{"$f":"E6+E31-E81","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"\n* Dokuments var būt bez paraksta, ja dokuments ir jāparaksta tikai Programmas dalībnieka pārstāvim un šis pārstāvis iesniedzis dokumentu izmantojot attālināto darījumu sistēmu internetā mans.altum.lv",null,"Programmas dalībnieka vārdā:",null,{"$f":"IF('1. gads'!H86=\"\",\"\",'1. gads'!H86)","v":""},null,null,null,null,{"$f":"IF('1. gads'!M86=\"\",\"\",'1. gads'!M86)","v":""}]
[null,null,null,null,null,null,"(Vārds, uzvārds)",null,null,null,null,"(Datums)",null,null,"(Paraksts)*"]

{"sheet":"4. gads","index":3,"n_rows":86,"n_cols":41,"rows_kept":86,"cut":false,"hidden":false,"merged":[[79,2,79,3],[1,8,2,17],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[74,2,74,3],[75,2,75,3],[76,2,76,3],[77,2,77,3],[78,2,78,3],[84,2,86,3],[84,6,84,9],[84,11,84,12],[84,14,84,15],[85,6,85,9],[85,11,85,12],[85,14,85,15],[84,4,84,5]]}
[]
[null,null,null,null,null,null,null,null,"NAUDAS PLŪSMA\n(4. GADS)\nSOCIĀLĀS UZŅĒMĒJDARBĪBAS PROGRAMMĀ\nDARBĪBAS PROGRAMMAS „IZAUGSME UN NODARBINĀTĪBA” \n9.1.1. SPECIFISKĀ ATBALSTA MĒRĶA “PALIELINĀT NELABVĒLĪGĀKĀ SITUĀCIJĀ \nESOŠU BEZDARBNIEKU IEKĻAUŠANOS DARBA TIRGŪ” 9.1.1.3. PASĀKUMS “ATBALSTS SOCIĀLAJAI \nUZŅĒMĒJDARBĪBAI” NR.9.1.1.3/15/i/001. PROJEKTS TIEK FINANSĒTS NO EIROPAS SOCIĀLĀ FONDA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"\"A\"&AO54","v":"A66"},null,null,null,null,null,null,1,7]
[null,{"$f":"IF('1. gads'!$C$3=\"\",\"\",'1. gads'!$C$3)","v":""}]
[null,"Ieņēmumi, EUR"]
[null,null,null,null,{"$f":"'1. gads'!F6","v":"jan"},{"$f":"'1. gads'!G6","v":"feb"},{"$f":"'1. gads'!H6","v":"mar"},{"$f":"'1. gads'!I6","v":"apr"},{"$f":"'1. gads'!J6","v":"mai"},{"$f":"'1. gads'!K6","v":"jūn"},{"$f":"'1. gads'!L6","v":"jūl"},{"$f":"'1. gads'!M6","v":"aug"},{"$f":"'1. gads'!N6","v":"sep"},{"$f":"'1. gads'!O6","v":"okt"},{"$f":"'1. gads'!P6","v":"nov"},{"$f":"'1. gads'!Q6","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":"'3. gads'!P84","v":0},{"$f":"E84","v":0},{"$f":"F84","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('1. gads'!D9=\"\",\"\",'1. gads'!D9)","v":"Ieņēmumi, kas saņemti no debitoru parādu atgūšanas"},{"$f":"'1. gads'!E9","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:P8)","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('1. gads'!D10=\"\",\"\",'1. gads'!D10)","v":"Ieņēmumi no krājumu pārdošanas"},{"$f":"'1. gads'!E10","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(E8:E9)","v":0},{"$f":"SUM(F8:F9)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R8:R9)","v":0}]
[null,null,"Pamatdarbības"]
[null,null,{"$f":"IF('1. gads'!D13=\"\",\"\",'1. gads'!D13)","v":""},{"$f":"'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,7,13]
[null,null,{"$f":"IF('1. gads'!D14=\"\",\"\",'1. gads'!D14)","v":""},{"$f":"'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,8,14]
[null,null,{"$f":"IF('1. gads'!D15=\"\",\"\",'1. gads'!D15)","v":""},{"$f":"'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,9,15]
[null,null,{"$f":"IF('1. gads'!D16=\"\",\"\",'1. gads'!D16)","v":""},{"$f":"'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,10,16]
[null,null,{"$f":"IF('1. gads'!D17=\"\",\"\",'1. gads'!D17)","v":""},{"$f":"'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,11,17]
[null,null,{"$f":"IF('1. gads'!D18=\"\",\"\",'1. gads'!D18)","v":""},{"$f":"'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,12,18]
[null,null,{"$f":"IF('1. gads'!D19=\"\",\"\",'1. gads'!D19)","v":""},{"$f":"'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,13,19]
[null,null,{"$f":"IF('1. gads'!D20=\"\",\"\",'1. gads'!D20)","v":""},{"$f":"'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,14,28]
[null,null,{"$f":"IF('1. gads'!D21=\"\",\"\",'1. gads'!D21)","v":""},{"$f":"'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,15,29]
[null,null,{"$f":"IF('1. gads'!D22=\"\",\"\",'1. gads'!D22)","v":""},{"$f":"'1. gads'!E22","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('1. gads'!D23=\"\",\"\",'1. gads'!D23)","v":""},{"$f":"'1. gads'!E23","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(E12:E22)","v":0},{"$f":"SUM(F12:F22)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R12:R22)","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('1. gads'!D26=\"\",\"\",'1. gads'!D26)","v":"Saņemtie granti "},{"$f":"'1. gads'!E26","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,19,33]
[null,null,{"$f":"IF('1. gads'!D27=\"\",\"\",'1. gads'!D27)","v":"Līdzdalība"},{"$f":"'1. gads'!E27","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E26:P26)","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('1. gads'!D28=\"\",\"\",'1. gads'!D28)","v":"Ārkārtas ieņēmumi"},{"$f":"'1. gads'!E28","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,21,35]
[null,null,{"$f":"IF('1. gads'!D29=\"\",\"\",'1. gads'!D29)","v":""},{"$f":"'1. gads'!E29","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,22,36]
[null,null,{"$f":"IF('1. gads'!D30=\"\",\"\",'1. gads'!D30)","v":""},{"$f":"'1. gads'!E30","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,23,37]
[null,null,null,"Saņemtais PVN",{"$f":"($D$8*E8)+($D$9*E9)+($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$22*E22)+($D$25*E25)+($D$26*E26)+($D$27*E27)+($D$28*E28)+($D$29*E29)","v":0},{"$f":"($D$8*F8)+($D$9*F9)+($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$22*F22)+($D$25*F25)+($D$26*F26)+($D$27*F27)+($D$28*F28)+($D$29*F29)","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":"E10+E23+SUM(E25:E30)","v":0},{"$f":"F10+F23+SUM(F25:F30)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R8:R9,R23,R25:R30)","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":"E5","v":"jan"},{"$f":"F5","v":"feb"},"mar","apr","mai","jūn","jūl","aug","sep","okt","nov","dec",null,"Kopā"]
[null,null,{"$f":"IF('1. gads'!D35=\"\",\"\",'1. gads'!D35)","v":"Gaidāmie maksājumi"},{"$f":"'1. gads'!E35","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E34:P34)","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('1. gads'!D37=\"\",\"\",'1. gads'!D37)","v":"Izejmateriāli"},{"$f":"'1. gads'!E37","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('1. gads'!D38=\"\",\"\",'1. gads'!D38)","v":"Palīgmateriāli"},{"$f":"'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,29,44]
[null,null,{"$f":"IF('1. gads'!D39=\"\",\"\",'1. gads'!D39)","v":"Ražošanā strādājošo darba alga un sociālais nodoklis"},{"$f":"'1. gads'!E39","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('1. gads'!D40=\"\",\"\",'1. gads'!D40)","v":"Energoresursi"},{"$f":"'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,31,46]
[null,null,{"$f":"IF('1. gads'!D41=\"\",\"\",'1. gads'!D41)","v":"Realizācijas izmaksas"},{"$f":"'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,32,47]
[null,null,{"$f":"IF('1. gads'!D42=\"\",\"\",'1. gads'!D42)","v":"Transporta izmaksas "},{"$f":"'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,33,48]
[null,null,{"$f":"IF('1. gads'!D43=\"\",\"\",'1. gads'!D43)","v":"cits"},{"$f":"'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,34,49]
[null,null,{"$f":"IF('1. gads'!D44=\"\",\"\",'1. gads'!D44)","v":"cits"},{"$f":"'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,35,50]
[null,null,{"$f":"IF('1. gads'!D45=\"\",\"\",'1. gads'!D45)","v":""},{"$f":"'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,36,51]
[null,null,{"$f":"IF('1. gads'!D46=\"\",\"\",'1. gads'!D46)","v":""},{"$f":"'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,37,52]
[null,null,{"$f":"IF('1. gads'!D47=\"\",\"\",'1. gads'!D47)","v":""},{"$f":"'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,38,53]
[null,null,{"$f":"IF('1. gads'!D48=\"\",\"\",'1. gads'!D48)","v":""},{"$f":"'1. gads'!E48","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('1. gads'!D49=\"\",\"\",'1. gads'!D49)","v":""},{"$f":"'1. gads'!E49","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(E36:E48)","v":0},{"$f":"SUM(F36:F48)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R36:R48)","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('1. gads'!D52=\"\",\"\",'1. gads'!D52)","v":"Pastāvīgi strādājošo algas un sociālais nodoklis"},{"$f":"'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,42,64]
[null,null,{"$f":"IF('1. gads'!D53=\"\",\"\",'1. gads'!D53)","v":"Transporta izmaksas (degviela u.c.)"},{"$f":"'1. gads'!E53","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('1. gads'!D54=\"\",\"\",'1. gads'!D54)","v":"Apdrošināšana"},{"$f":"'1. gads'!E54","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('1. gads'!D55=\"\",\"\",'1. gads'!D55)","v":"Nodokļi un nodevas"},{"$f":"'1. gads'!E55","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:AN53,AO2:AO53)","v":66}]
[null,null,{"$f":"IF('1. gads'!D56=\"\",\"\",'1. gads'!D56)","v":"Ēku un ceļu remonts"},{"$f":"'1. gads'!E56","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D57=\"\",\"\",'1. gads'!D57)","v":"Tehnikas remonts"},{"$f":"'1. gads'!E57","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D58=\"\",\"\",'1. gads'!D58)","v":"Nomas maksa par ēkām, zemi"},{"$f":"'1. gads'!E58","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D59=\"\",\"\",'1. gads'!D59)","v":"cits"},{"$f":"'1. gads'!E59","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D60=\"\",\"\",'1. gads'!D60)","v":"cits"},{"$f":"'1. gads'!E60","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D61=\"\",\"\",'1. gads'!D61)","v":""},{"$f":"'1. gads'!E61","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D62=\"\",\"\",'1. gads'!D62)","v":""},{"$f":"'1. gads'!E62","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D63=\"\",\"\",'1. gads'!D63)","v":""},{"$f":"'1. gads'!E63","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D64=\"\",\"\",'1. gads'!D64)","v":""},{"$f":"'1. gads'!E64","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Kopā",{"$f":"SUM(E51:E63)","v":0},{"$f":"SUM(F51:F63)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R51:R63)","v":0}]
[null,null,{"$f":"IF('1. gads'!D66=\"\",\"\",'1. gads'!D66)","v":"Līzingu maksājumi: procenti"},{"$f":"'1. gads'!E66","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D67=\"\",\"\",'1. gads'!D67)","v":"Līzingu maksājumi: pamatsumma"},{"$f":"'1. gads'!E67","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Aizdevuma izlietojums",{"$f":"'1. gads'!E68","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D69=\"\",\"\",'1. gads'!D69)","v":"Līdzdalības izlietojums"},{"$f":"'1. gads'!E69","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D70=\"\",\"\",'1. gads'!D70)","v":""},{"$f":"'1. gads'!E70","v":0.21},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E69:P69)","v":0}]
[null,null,"PVN priekšnodoklis",null,{"$f":"($D$34*E34)+($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$48*E48)+($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$63*E63)+($D$65*E65)+($D$66*E66)+($D$67*E67)+($D$68*E68)+($D$69*E69)","v":0},{"$f":"($D$34*F34)+($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$48*F48)+($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$63*F63)+($D$65*F65)+($D$66*F66)+($D$67*F67)+($D$68*F68)+($D$69*F69)","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,{"$f":"IF('1. gads'!D72=\"\",\"\",'1. gads'!D72)","v":"Aizdevumu procenti"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D73=\"\",\"\",'1. gads'!D73)","v":"Aizdevumu pamatsumma"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E72:P72)","v":0}]
[null,null,{"$f":"IF('1. gads'!D74=\"\",\"\",'1. gads'!D74)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D75=\"\",\"\",'1. gads'!D75)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D76=\"\",\"\",'1. gads'!D76)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D77=\"\",\"\",'1. gads'!D77)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D78=\"\",\"\",'1. gads'!D78)","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(E77:P77)","v":0}]
[null,null,{"$f":"IF('1. gads'!D79=\"\",\"\",'1. gads'!D79)","v":"Ienākuma nodoklis / Mikrouzņēmuma nodoklis"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('1. gads'!D80=\"\",\"\",'1. gads'!D80)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E79:P79)","v":0}]
[null,null,"Maksājamais Pievienotās vērtības nodoklis",null,{"$f":"'3. gads'!P30-'3. gads'!P70","v":0},{"$f":"E30-E70","v":0},{"$f":"F30-F70","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(E80:P80)","v":0}]
[null,null,null,"Kopējie izdevumi",{"$f":"SUM(E34,E49,E64,E65:E80)","v":0},{"$f":"SUM(F34,F49,F64,F65:F80)","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,null,"Perioda bilance",{"$f":"E31-E81","v":0},{"$f":"F31-F81","v":0},0,0,0,0,0,0,0,0,0,0,null,0]
[]
[null,null,null,"Beigu bilance",{"$f":"E6+E31-E81","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"\n* Dokuments var būt bez paraksta, ja dokuments ir jāparaksta tikai Programmas dalībnieka pārstāvim un šis pārstāvis iesniedzis dokumentu izmantojot attālināto darījumu sistēmu internetā mans.altum.lv",null,"Programmas dalībnieka vārdā:",null,{"$f":"IF('1. gads'!H86=\"\",\"\",'1. gads'!H86)","v":""},null,null,null,null,{"$f":"IF('1. gads'!M86=\"\",\"\",'1. gads'!M86)","v":""}]
[null,null,null,null,null,null,"(Vārds, uzvārds)",null,null,null,null,"(Datums)",null,null,"(Paraksts)*"]

{"sheet":"g","index":4,"n_rows":256,"n_cols":20,"rows_kept":256,"cut":false,"hidden":true,"merged":[[5,0,5,4],[5,6,5,9],[5,11,5,14],[5,16,5,19]]}
[null,null,"Maksājumu grafiks","LINEĀRS",1,"LINEĀRS",null,"Maksājumu grafiks","LINEĀRS",null,null,null,"Maksājumu grafiks","LINEĀRS",1,"reizi mēnesī",null,"Maksājumu grafiks","LINEĀRS"]
["Aizdevuma kopsumma :",null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},null,2,"ANUITĀRS","Aizdevuma kopsumma :",{"$f":"C2","v":{"$error":"#REF!"}},null,null,null,"Aizdevuma kopsumma :",{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},null,2,"reizi ceturksnī","Aizdevuma kopsumma :",{"$f":"M2","v":{"$error":"#REF!"}}]
["Aizdevuma gala atmaksāšanas termiņš:",null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},"mēneši",3,"NEREGULĀRS","Aizdevuma gala atmaksāšanas termiņš:",{"$f":"C3","v":{"$error":"#REF!"}},"mēneši",null,null,"Aizdevuma gala atmaksāšanas termiņš:",{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},"mēneši",null,1,"Aizdevuma gala atmaksāšanas termiņš:",{"$f":"M3","v":{"$error":"#REF!"}},"mēneši"]
["Izsniegtā aizdevuma % mēnesī :",null,{"$f":"D4/12","v":{"$error":"#REF!"}},{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},1,{"$f":"LOOKUP(E4,$E$1:$E$3,$F$1:$F$3)","v":"LINEĀRS"},"Izsniegtā aizdevuma % mēnesī :",{"$f":"I4/12","v":{"$error":"#REF!"}},{"$f":"D4","v":{"$error":"#REF!"}},null,null,"Izsniegtā aizdevuma % mēnesī :",{"$f":"N4/12","v":{"$error":"#REF!"}},{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},null,1,"Izsniegtā aizdevuma % mēnesī :",{"$f":"S4/12","v":{"$error":"#REF!"}},{"$f":"N4","v":{"$error":"#REF!"}}]
["Cik mēnešus nemaksā pamatsummu:",null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},"mēneši",1,{"$f":"LOOKUP(E5,$E$1:$E$3,$F$1:$F$3)","v":"LINEĀRS"},"Cik mēnešus nemaksā pamatsummu:",{"$f":"C5","v":{"$error":"#REF!"}},"mēneši",null,null,"Cik mēnešus nemaksā pamatsummu:",{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},"mēneši",null,null,"Cik mēnešus nemaksā pamatsummu:",{"$f":"M5","v":{"$error":"#REF!"}},"mēneši"]
["INV LINEĀRS",null,null,null,null,null,"INV ANUITĀRS",null,null,null,null,"AL LINEĀRS",null,null,null,null,"AL ANUITĀRS"]
[null,null,null,null,"Aizdevuma kop-",null,null,null,null,"Aizdevuma kop-",null,null,null,null,"Aizdevuma kop-",null,null,null,null,"Aizdevuma kop-"]
["kārtas",null,"pamats. daļa","% summa","summas atlikums",null,null,"pamats. daļa","% summa","summas atlikums",null,null,"pamats. daļa","% summa","summas atlikums",null,null,"pamats. daļa","% summa","summas atlikums"]
["numurs"]
[0,null,0,0,{"$f":"C2","v":{"$error":"#REF!"}},null,null,0,0,{"$f":"H2","v":{"$error":"#REF!"}},null,null,0,0,{"$f":"M2","v":{"$error":"#REF!"}},null,null,0,0,{"$f":"R2","v":{"$error":"#REF!"}}]
[1,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF($E$4=3,B11,IF(A11>$C$3,0,IF(A11<=$C$5,0,$C$2/($C$3-$C$5))))","v":{"$error":"#REF!"}},{"$f":"IF(A11>$C$3,0,E10*$C$4)","v":{"$error":"#REF!"}},{"$f":"IF(A11>$C$3,0,E10-C11)","v":{"$error":"#REF!"}},null,null,{"$f":"IF(A11<=$H$5,0,PPMT($H$4,A11-$H$5,$H$3-$H$5,-$H$2))","v":{"$error":"#REF!"}},{"$f":"IF(A11<=$H$5,$H$2*$H$4,IPMT($H$4,A11-$H$5,$H$3-$H$5,-$H$2))","v":{"$error":"#REF!"}},{"$f":"IF(A11>$H$3,0,J10-H11)","v":{"$error":"#REF!"}},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF($E$5=3,L11,IF(A11>$M$3,0,IF(A11<=$M$5,0,$M$2/($M$3-$M$5))))","v":{"$error":"#REF!"}},{"$f":"IF(A11>$M$3,0,O10*$M$4)","v":{"$error":"#REF!"}},{"$f":"IF(A11>$M$3,0,O10-M11)","v":{"$error":"#REF!"}},null,null,{"$f":"IF(A11<=$R$5,0,PPMT($R$4,A11-$R$5,$R$3-$R$5,-$R$2))","v":{"$error":"#REF!"}},{"$f":"IF(A11<=$R$5,$R$2*$R$4,IPMT($R$4,A11-$R$5,$R$3-$R$5,-$R$2))","v":{"$error":"#REF!"}},{"$f":"IF(A11>$R$3,0,T10-R11)","v":{"$error":"#REF!"}}]
[2,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF($E$4=3,B12,IF(A12>$C$3,0,IF(A12<=$C$5,0,$C$2/($C$3-$C$5))))","v":{"$error":"#REF!"}},{"$f":"IF(A12>$C$3,0,E11*$C$4)","v":{"$error":"#REF!"}},{"$f":"IF(A12>$C$3,0,E11-C12)","v":{"$error":"#REF!"}},null,null,{"$f":"IF(A12<=$H$5,0,PPMT($H$4,A12-$H$5,$H$3-$H$5,-$H$2))","v":{"$error":"#REF!"}},{"$f":"IF(A12<=$H$5,$H$2*$H$4,IPMT($H$4,A12-$H$5,$H$3-$H$5,-$H$2))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF($E$5=3,L12,IF(A12>$M$3,0,IF(A12<=$M$5,0,$M$2/($M$3-$M$5))))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"IF(A12<=$R$5,0,PPMT($R$4,A12-$R$5,$R$3-$R$5,-$R$2))","v":{"$error":"#REF!"}},{"$f":"IF(A12<=$R$5,$R$2*$R$4,IPMT($R$4,A12-$R$5,$R$3-$R$5,-$R$2))","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[3,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(A13>$C$3,0,E12-C13)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[4,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[5,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[6,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[7,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[8,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[9,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[10,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[11,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[12,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'1. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[13,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[14,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[15,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[16,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[17,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[18,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[19,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[20,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[21,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[22,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[23,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[24,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"'2. gads'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[25,null,{"$f":"IF(A35>$C$3,0,IF(A35<=$C$5,0,$C$2/($C$3-$C$5)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"IF(A35>$M$3,0,IF(A35<=$M$5,0,$M$2/($M$3-$M$5)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[26,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[27,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[28,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[29,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[30,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[31,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[32,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[33,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[34,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[35,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[36,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[37,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[38,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[39,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[40,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[41,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[42,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[43,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[44,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[45,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[46,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[47,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[48,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[49,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[50,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[51,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[52,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[53,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[54,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[55,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[56,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[57,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[58,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[59,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[60,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[61,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[62,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[63,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[64,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[65,null,{"$f":"IF(A75>$C$3,0,IF(A75<=$C$5,0,$C$2/($C$3-$C$5)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(A75>$H$3,0,J74-H75)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$f":"IF(A75>$M$3,0,O74*$M$4)","v":{"$error":"#REF!"}},{"$f":"IF(A75>$M$3,0,O74-M75)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(A75>$R$3,0,T74-R75)","v":{"$error":"#REF!"}}]
[66,null,{"$error":"#REF!"},{"$f":"IF(A76>$C$3,0,E75*$C$4)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"IF(A76<=$H$5,0,PPMT($H$4,A76-$H$5,$H$3-$H$5,-$H$2))","v":{"$error":"#REF!"}},{"$f":"IF(A76<=$H$5,$H$2*$H$4,IPMT($H$4,A76-$H$5,$H$3-$H$5,-$H$2))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"IF(A76>$M$3,0,IF(A76<=$M$5,0,$M$2/($M$3-$M$5)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"IF(A76<=$R$5,0,PPMT($R$4,A76-$R$5,$R$3-$R$5,-$R$2))","v":{"$error":"#REF!"}},{"$f":"IF(A76<=$R$5,$R$2*$R$4,IPMT($R$4,A76-$R$5,$R$3-$R$5,-$R$2))","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[67,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(A77>$C$3,0,E76-C77)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[68,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[69,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[70,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[71,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[72,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[73,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[74,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[75,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[76,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[77,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[78,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[79,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[80,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[81,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[82,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[83,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[84,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[85,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[86,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[87,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[88,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[89,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[90,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[91,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[92,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[93,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[94,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[95,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[96,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[97,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[98,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[99,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[100,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[101,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[102,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[103,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[104,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[105,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[106,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[107,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[108,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[109,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[110,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[111,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[112,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[113,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[114,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[115,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[116,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[117,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[118,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[119,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[120,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[121,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[122,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[123,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[124,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[125,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[126,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[127,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[128,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[129,null,{"$f":"IF(A139>$C$3,0,IF(A139<=$C$5,0,$C$2/($C$3-$C$5)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(A139>$H$3,0,J138-H139)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$f":"IF(A139>$M$3,0,O138*$M$4)","v":{"$error":"#REF!"}},{"$f":"IF(A139>$M$3,0,O138-M139)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(A139>$R$3,0,T138-R139)","v":{"$error":"#REF!"}}]
[130,null,{"$error":"#REF!"},{"$f":"IF(A140>$C$3,0,E139*$C$4)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"IF(A140<=$H$5,0,PPMT($H$4,A140-$H$5,$H$3-$H$5,-$H$2))","v":{"$error":"#REF!"}},{"$f":"IF(A140<=$H$5,$H$2*$H$4,IPMT($H$4,A140-$H$5,$H$3-$H$5,-$H$2))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"IF(A140>$M$3,0,IF(A140<=$M$5,0,$M$2/($M$3-$M$5)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"IF(A140<=$R$5,0,PPMT($R$4,A140-$R$5,$R$3-$R$5,-$R$2))","v":{"$error":"#REF!"}},{"$f":"IF(A140<=$R$5,$R$2*$R$4,IPMT($R$4,A140-$R$5,$R$3-$R$5,-$R$2))","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[131,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(A141>$C$3,0,E140-C141)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[132,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[133,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[134,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[135,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[136,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[137,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[138,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[139,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[140,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[141,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[142,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[143,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[144,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[145,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[146,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[147,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[148,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[149,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[150,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[151,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[152,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[153,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[154,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[155,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[156,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[157,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[158,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[159,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[160,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[161,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[162,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[163,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[164,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[165,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[166,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[167,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[168,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[169,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[170,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[171,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[172,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[173,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[174,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[175,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[176,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[177,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[178,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[179,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[180,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[181,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[182,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[183,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[184,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[185,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[186,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[187,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[188,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[189,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[190,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[191,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[192,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[193,null,{"$f":"IF(A203>$C$3,0,IF(A203<=$C$5,0,$C$2/($C$3-$C$5)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(A203>$H$3,0,J202-H203)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$f":"IF(A203>$M$3,0,O202*$M$4)","v":{"$error":"#REF!"}},{"$f":"IF(A203>$M$3,0,O202-M203)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(A203>$R$3,0,T202-R203)","v":{"$error":"#REF!"}}]
[194,null,{"$error":"#REF!"},{"$f":"IF(A204>$C$3,0,E203*$C$4)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"IF(A204<=$H$5,0,PPMT($H$4,A204-$H$5,$H$3-$H$5,-$H$2))","v":{"$error":"#REF!"}},{"$f":"IF(A204<=$H$5,$H$2*$H$4,IPMT($H$4,A204-$H$5,$H$3-$H$5,-$H$2))","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"IF(A204>$M$3,0,IF(A204<=$M$5,0,$M$2/($M$3-$M$5)))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$f":"IF(A204<=$R$5,0,PPMT($R$4,A204-$R$5,$R$3-$R$5,-$R$2))","v":{"$error":"#REF!"}},{"$f":"IF(A204<=$R$5,$R$2*$R$4,IPMT($R$4,A204-$R$5,$R$3-$R$5,-$R$2))","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[195,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(A205>$C$3,0,E204-C205)","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[196,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[197,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[198,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[199,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[200,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[201,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[202,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[203,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[204,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[205,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[206,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[207,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[208,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[209,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[210,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[211,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[212,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[213,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[214,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[215,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[216,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[217,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[218,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[219,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[220,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[221,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[222,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[223,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[224,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[225,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[226,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[227,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[228,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[229,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[230,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[231,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[232,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[233,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[234,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[235,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[236,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[237,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[238,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[239,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[240,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,{"$f":"SUM(C11:C250)","v":{"$error":"#REF!"}},{"$f":"SUM(D11:D250)","v":{"$error":"#REF!"}}," ",null,null,{"$f":"SUM(H11:H250)","v":{"$error":"#REF!"}},{"$f":"SUM(I11:I250)","v":{"$error":"#REF!"}}," ",null,null,{"$f":"SUM(M11:M250)","v":{"$error":"#REF!"}},{"$f":"SUM(N11:N250)","v":{"$error":"#REF!"}}," ",null,null,{"$f":"SUM(R11:R250)","v":{"$error":"#REF!"}},{"$f":"SUM(S11:S250)","v":{"$error":"#REF!"}}," "]
[]
[]
[null,null,null,"AIZŅĒMĒJS"]
[]
[null,null,null,"___________________________"]

{"sheet":"R","index":5,"n_rows":49,"n_cols":16,"rows_kept":49,"cut":false,"hidden":true,"merged":[[1,2,1,13],[2,3,2,4],[2,8,2,9],[2,14,2,15]]}
[null,"netiek izmantots"]
[null,null,"Finanšu rādītāju minimālās vērtības pa nozarēm"]
[null,"Nozare","Koriģētā kopējā likviditāte","Koriģēts Faktiskā pašu kapitāla īpatsvars ",null,"Prognozētā pamatdarbības apgrozījuma rentabilitāte","Saistību seguma koeficients\njābūt lielākam par","Koriģētais procentu seguma koeficients (tikai veicot saīsinātajo aizņēmēja kredītspējas noteikšanu)","Investīciju analīze",null,"Nodrošinājums","Līdzdalība","Saistību slogs (kopējās finanšu saistības/EBITDA)\njābūt mazākam par...",null,"Koriģēts Faktiskā pašu kapitāla īpatsvars "]
[null,null,null,"Pieredzējis uzņēmums","Jauns uzņēmums (0-3 gadi)",null,null,null,"IRR","Jūtīguma analīze",null,null,null,null,"Pieredzējis mazs uzņēmums","Jauns mazs uzņēmums"]
[null,"Lauksaimniecība",0.7,0.3,0.4,">0%",0.25,"<25%","-","-","<75%","-",5,"3)",0.2,0.3]
[1,null,"-","-","-","-","-","-","-","-","-","-",null,null,"-","-"]
[2,"Zvejniecība",0.7,0.4,0.5,">10%",0.25,"<17%",0.12,"Iztur 8% svārstību amplitūdu","<60%","-",4,null,0.3,0.4]
[3,"Pakalpojumi, viesnīcas",0.7,0.25,0.35,">10%",0.2,"<25%",0.12,"Iztur 8% svārstību amplitūdu","<75%","-",4,null,0.15,0.25]
[4,"Pārtikas rūpniecība",0.9,0.3,0.4,">3%",0.2,"<25%",0.12,"Iztur 8% svārstību amplitūdu","<75%","-",5,null,0.2,0.3]
[5,"Ieguves rūpniecība",0.7,0.3,0.4,">10%",0.2,"<25%",0.12,"Iztur 8% svārstību amplitūdu","<75%","-",5,null,0.2,0.3]
[6,"Operācijas ar NĪ  ",1,0.3,0.4,">10%",0.2,"<25%",0.12,"Iztur 8% svārstību amplitūdu","<75%","-",5,null,0.2,0.3]
[7,"Būvniecība",0.7,0.25,0.35,">5%",0.2,"<25%",0.12,"Iztur 8% svārstību amplitūdu","<75%","-",4,"7)",0.15,0.25]
[8,"Tirdzniecība",1,0.3,0.4,">5%",0.2,"<25%",0.12,"Iztur 8% svārstību amplitūdu","<75%","-",5,"5)",0.2,0.3]
[9,"Transports",0.7,0.25,0.35,">5%",0.2,"<25%",0.12,"Iztur 8% svārstību amplitūdu","<75%","-",4,null,0.15,0.25]
[10,"Rūpniecība",0.9,0.25,0.35,">5%",0.2,"<25%",0.12,"Iztur 8% svārstību amplitūdu","<75%","-",5,null,0.15,0.25]
[11,"Enerģētika",0.6,0.3,0.4,">10%",0.2,"<25%",0.12,"Iztur 8% svārstību amplitūdu","<75%","-",5,null,0.2,0.3]
[12,"Izglītība, veselība, sports",0.7,0.2,0.3,">0",0.2,"<25%",0.12,"Iztur 8% svārstību amplitūdu","<75%","-",5,null,0.1,0.2]
[]
[]
[]
[null,1,null,1,2,3,4]
[null,null,{"$f":"LOOKUP($B$21,$A$6:$A$18,C6:C17)","v":"-"},"-","-","-","-","-","-","-","-","-",0,null,{"$f":"LOOKUP($B$21,$A$6:$A$18,O6:O17)","v":"-"},{"$f":"LOOKUP($B$21,$A$6:$A$18,P6:P17)","v":"-"}]
[null,1]
[null,{"$f":"D4","v":"Pieredzējis uzņēmums"},null,{"$f":"LOOKUP(B23,D29:G29,D30:G30)","v":"-"}]
[null,{"$f":"E4","v":"Jauns uzņēmums (0-3 gadi)"}]
[null,{"$f":"O4","v":"Pieredzējis mazs uzņēmums"}]
[null,{"$f":"P4","v":"Jauns mazs uzņēmums"}]
[]
[null,null,null,1,2,3,4]
[null,"lūkapi jauniem/veciem",null,{"$f":"D22","v":"-"},{"$f":"E22","v":"-"},{"$f":"O22","v":"-"},{"$f":"P22","v":"-"}]
[]
[]
[1,"UIN maksātājs"]
[2,"Mikrouzņēmuma nodokļa maksātājs"]
[3,"Pārējie nodokļa maksātāji"]
[]
[null,1]
[]
[null,"Uzņēmuma ienākumu nodoklis (UIN)"]
[null,"Mikrouzņēmuma nodoklis"]
[]
[null,{"$f":"IF(B37=1,B39,IF(B37=2,B40,B39))","v":"Uzņēmuma ienākumu nodoklis (UIN)"}]
[]
[null,"IF((F44-F45-F46-F47*2)>0;(F44-F45-F46-F47*2)*0.15;0)"]
[null,null,null,null,null,null,"Formula Ienākumu nodoklim",null,"Formula Mikrouzņēmuma nodoklim"]
[null,{"$f":"IF(B37=1,IF((#REF!-#REF!-#REF!-#REF!*2)>0,(#REF!-#REF!-#REF!-#REF!*2)*0.15,0),IF(B37=2,#REF!*0.09,0))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF((#REF!-#REF!-#REF!-#REF!*2)>0,(#REF!-#REF!-#REF!-#REF!*2)*0.15,0)","v":{"$error":"#REF!"}},null,{"$f":"IF(#REF!>0,#REF!*0.09+#REF!*0.1,#REF!*0.09)","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"IF(B37=2,#REF!*0.09,0)","v":0}]
[null,{"$f":"IF(B37=1,IF((#REF!-#REF!-#REF!-#REF!*2)>0,(#REF!-#REF!-#REF!-#REF!*2)*0.15,0),IF(B37=2,#REF!*0.09,0))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF((#REF!-#REF!-#REF!-#REF!*2)>0,(#REF!-#REF!-#REF!-#REF!*2)*0.15,0)","v":{"$error":"#REF!"}},null,{"$f":"IF(#REF!>0,#REF!*0.09+#REF!*0.1,#REF!*0.09)","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"IF(B37=2,#REF!*0.09,0)","v":0}]
[null,{"$f":"IF(B37=1,IF((#REF!-#REF!-#REF!-#REF!*2)>0,(#REF!-#REF!-#REF!-#REF!*2)*0.15,0),IF(B37=2,#REF!*0.09,0))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF((#REF!-#REF!-#REF!-#REF!*2)>0,(#REF!-#REF!-#REF!-#REF!*2)*0.15,0)","v":{"$error":"#REF!"}},null,{"$f":"IF(#REF!>0,#REF!*0.09+#REF!*0.1,#REF!*0.09)","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"IF(B37=2,#REF!*0.09,0)","v":0}]
[null,{"$f":"IF(B37=1,IF((#REF!-#REF!-#REF!-#REF!*2)>0,(#REF!-#REF!-#REF!-#REF!*2)*0.15,0),IF(B37=2,#REF!*0.09,0))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF((#REF!-#REF!-#REF!-#REF!*2)>0,(#REF!-#REF!-#REF!-#REF!*2)*0.15,0)","v":{"$error":"#REF!"}},null,{"$f":"IF(#REF!>0,#REF!*0.09+#REF!*0.1,#REF!*0.09)","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"IF(B37=2,#REF!*0.09,0)","v":0}]