{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["EE un ilgtsp.fin.novērt.","Energoefektivitātes pasākumi","AER pašpatēriņam","Atjaunojamā enerģija","Zaļo ēku celtniecība","Ēku atjaunošana","Transporta risinājumi","Enerģijas izmaksu samazināšana","Izvelnes"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"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":"EE un ilgtsp.fin.novērt.","index":0,"n_rows":93,"n_cols":13,"rows_kept":93,"cut":false,"hidden":false,"merged":[[79,6,80,7],[81,6,82,7],[90,2,90,4],[89,2,89,4],[2,6,6,12],[85,1,85,12],[86,1,86,9],[79,1,80,1],[10,2,10,5],[10,6,10,7],[11,2,11,5],[11,6,11,7],[12,1,13,1],[12,2,12,5],[60,1,61,1],[75,1,75,4],[22,1,23,1],[35,1,35,4],[15,5,16,9],[75,6,75,8],[22,2,22,5],[22,6,22,9],[74,6,74,8],[60,2,60,5],[34,6,34,8],[35,6,35,8],[60,6,60,9],[58,1,58,9],[59,1,59,9],[39,1,40,1],[39,2,39,5],[39,6,39,9]]}
[]
[]
[null,null,null,null,null,null,"PROJEKTA ENERGOEFEKTIVITĀTES UN/ VAI ILGTSPĒJAS \nFINANSIĀLAIS NOVĒRTĒJUMS"]
[]
[]
[]
[]
[]
[null,"Vispārīga informācija"]
[]
[null,"Klients"]
[null,null,"Nosaukums",null,null,null,"Reģistrācijas Nr."]
[null,"Kādu energoefektivitātes/ ilgtspējas pasākumu plāno īstenot?"]
[]
[]
[null,"Kopējās projekta izmaksas, EUR"]
[null,"Aizdevuma summa, EUR"]
[]
[]
[]
[null,"Saimnieciskās darbības ieņēmumi (gadā, bez PVN)"]
[]
[null,"Produkts / pakalpojums","Esošie apjomi gadā",null,null,null,"Izmaiņas pēc projekta īstenošanas"]
[null,null,"Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR"]
[null,null,null,null,null,{"$f":"IF(AND(D25<>\"\",E25<>\"\"),D25*E25,\"\")","v":""},{"$f":"IF(C25=\"\",\"\",C25)","v":""},null,null,{"$f":"IF(AND(H25<>\"\",I25<>\"\"),H25*I25,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(D26<>\"\",E26<>\"\"),D26*E26,\"\")","v":""},{"$f":"IF(C26=\"\",\"\",C26)","v":""},null,null,{"$f":"IF(AND(H26<>\"\",I26<>\"\"),H26*I26,\"\")","v":""}]
[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,{"$f":"IF(AND(D30<>\"\",E30<>\"\"),D30*E30,\"\")","v":""},{"$f":"IF(C30=\"\",\"\",C30)","v":""},null,null,{"$f":"IF(AND(H30<>\"\",I30<>\"\"),H30*I30,\"\")","v":""}]
[null,null,null,null,null,"","",null,null,""]
[null,null,null,null,null,"",{"$f":"IF(C32=\"\",\"\",C32)","v":""},null,null,""]
[null,null,null,null,null,"","",null,null,""]
[null,null,null,null,null,"","",null,null,""]
[null,null,{"$f":"IF(COUNTIF(C25:C34,\"cits\"),\"Cita veida mērvienībām norādiet tās nosaukumu blakus produkta nosaukuma\",\"\")","v":""},null,"Kopā, EUR",{"$f":"SUM(F25:F34)","v":0},"Kopā, EUR",null,null,{"$f":"SUM(J25:J34)","v":0}]
[]
[]
[null,"Izdevumi par energoresursiem (gadā, bez PVN)",null,null,null,null,null,null,null,null,null,"Enerģijas ietaupījums"]
[]
[null,"Izejviela","Esošie apjomi gadā",null,null,null,"Izmaiņas pēc projekta īstenošanas",null,null,null,null,"Energoresursa ietaupījums, kopā","Energoresursa ietaupījums uz 1 vienību"]
[null,null,"Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR",null,"%","%"]
[null,"Siltumenerģija",null,null,null,{"$f":"IF(AND(D42<>\"\",E42<>\"\"),D42*E42,\"\")","v":""},{"$f":"IF(C42<>\"\",C42,\"\")","v":""},null,null,{"$f":"IF(AND(H42<>\"\",I42<>\"\"),H42*I42,\"\")","v":""},null,{"$f":"IFERROR(IF(OR(H42=\"\",D42=\"\"),\"\",1-H42/D42),0)","v":""},{"$f":"IFERROR(IF(AND(D42=\"\",H42=\"\"),\"\",1-(H42/SUM($H$25:$H$34))/(D42/SUM($D$25:$D$34))),0)","v":""}]
[null,"Elektroenerģija, no tīkla",null,null,null,"","",null,null,{"$f":"IF(AND(H43<>\"\",I43<>\"\"),H43*I43,\"\")","v":""},null,{"$f":"IFERROR(IF(OR(H43=\"\",D43=\"\"),\"\",1-H43/D43),0)","v":""},{"$f":"IFERROR(IF(AND(D43=\"\",H43=\"\"),\"\",1-(H43/SUM($H$25:$H$34))/(D43/SUM($D$25:$D$34))),0)","v":""}]
[null,"Elektroenerģija, pašražotā",null,null,null,"","",null,null,{"$f":"IF(AND(H44<>\"\",I44<>\"\"),H44*I44,\"\")","v":""},null,{"$f":"IFERROR(IF(OR(H44=\"\",D44=\"\"),\"\",1-H44/D44),0)","v":""},{"$f":"IFERROR(IF(AND(D44=\"\",H44=\"\"),\"\",1-(H44/SUM($H$25:$H$34))/(D44/SUM($D$25:$D$34))),0)","v":""}]
[null,"Šķelda",null,null,null,"","",null,null,{"$f":"IF(AND(H45<>\"\",I45<>\"\"),H45*I45,\"\")","v":""},null,{"$f":"IFERROR(IF(OR(H45=\"\",D45=\"\"),\"\",1-H45/D45),0)","v":""},""]
[null,"Granulas",null,null,null,"","",null,null,"",null,"",""]
[null,"Saspiestā gāze",null,null,null,"","",null,null,"",null,"",""]
[null,"Sašķidrinātā propāna gāze",null,null,null,"","",null,null,"",null,"",""]
[null,"Dīzeļdegviela",null,null,null,"","",null,null,"",null,"",""]
[null,"Benzīns",null,null,null,"","",null,null,"",null,"",""]
[null,"Biogāze",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,{"$f":"IF(AND(D55<>\"\",E55<>\"\"),D55*E55,\"\")","v":""},"",null,null,{"$f":"IF(AND(H55<>\"\",I55<>\"\"),H55*I55,\"\")","v":""},null,"",""]
[null,{"$f":"IF(COUNTIF(C42:C55,\"cits\"),\"Cita veida mērvienībām norādiet tās nosaukumu blakus izejvielas nosaukumam\",\"\")","v":""},null,null,"Kopā, EUR",{"$f":"SUM(F42:F55)","v":0},null,null,"Kopā, EUR",{"$f":"SUM(J42:J55)","v":0}]
[]
[null,"Saimnieciskās darbības izdevumi, kas nav saistīti ar energoresursiem"]
[null,"Tabulā norādiet izmaksas, kas nav tieši saistītas ar energoresursu patērēšanu, bet projekta realizācijas rezultātā mainīsies, piemēram: pieaugs izejvielu izmaksas, pieaugot ražošanas apjomam,"]
[null," darbinieki, remontu izdevumi, uzturēšanas izdevumi, apkopes, izejmateriāli produkcijas saražošanai, ja projekta ieviešanas rezultātā tiek sasniegta izejmateriāla ekonomija, u.c."]
[null,"Izejviela","Esošie apjomi gadā",null,null,null,"Izmaiņas pēc projekta īstenošanas"]
[null,null,"Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR"]
[null,"Darbinieki","skaits",null,null,{"$f":"IF(AND(D63<>\"\",E63<>\"\"),D63*E63,\"\")","v":""},{"$f":"IF(C63=\"\",\"\",C63)","v":"skaits"},null,null,{"$f":"IF(AND(H63<>\"\",I63<>\"\"),H63*I63,\"\")","v":""}]
[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,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,null,"","",null,null,""]
[null,null,{"$f":"IF(COUNTIF(C63:C74,\"cits\"),\"Cita veida mērvienībām norādiet tās nosaukumu blakus izejvielas nosaukumam\",\"\")","v":""},null,"Kopā, EUR",{"$f":"SUM(F63:F74)","v":0},"Kopā, EUR",null,null,{"$f":"SUM(J63:J74)","v":0}]
[]
[]
[null,"Finansiālais ietaupījums/ novērtējums "]
[]
[null,{"$f":"Izvelnes!$E$22","v":"Pamatlīdzekļu lietderīgais izmantošanas periods, gados"}]
[]
[null,"Finansiālais ieguvums, EUR",{"$f":"(J35-J56-J75)-(F35-F56-F75)","v":0}]
[null,"Investīciju atdeves periods, gados",{"$f":"IF(C82=0,0,C16/C82)","v":0}]
[null,"Aizdevuma atdeves periods, gados",{"$f":"IF(C82=0,0,C17/C82)","v":0}]
[]
[]
[null,"Komentāri (pamatojums pieņēmumiem par apjomu pieaugumu, izmaksu samazināšanos u.c.)"]
[]
[]
[]
[null,"Vārds, uzvārds","Amats",null,null,"Sagatavošanas datums"]
[]
[null,"4.versija",null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-10-12"}]

{"sheet":"Energoefektivitātes pasākumi","index":1,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":true,"merged":[[37,14,38,15],[39,14,40,15],[19,14,19,15],[19,16,19,17],[17,14,17,17],[19,7,19,11],[16,4,16,8],[40,1,41,2],[6,4,6,8],[36,7,36,9],[7,4,7,8],[8,4,8,8],[9,4,9,8],[10,4,10,8],[11,4,11,8],[12,4,12,8],[13,4,13,8],[14,4,14,8],[15,4,15,8],[6,1,10,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[19,1,20,1],[19,2,19,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERGOEFEKTIVITĀTES PASĀKUMU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"energoresursu patēriņš"]
[]
[null,"Šo lapu aizpildiet, ja plānojat īstenot energoefektivitātes pasākumus!"]
[]
[null,"Ja projektam ir tieša ietekme uz apgrozījuma pieaugumu, atzīmējiet vismaz vienu produktu, pret kuru aprēķināms energoresursu ietaupījums uz vienību!",null,{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!),\"I\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!),\"\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B25","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B26","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B27","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B28","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B29","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B30","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B31","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B32","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B33","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B34","v":0}]
[null,"Lūdzu norādiet tabulā esošos un plānotos energoresursu apjomus, kuri tiks ietaupīti pēc projekta īstenošanas:",null,null,null,null,null,null,null,null,null,null,null,null,"Enerģijas ietaupījums"]
[]
[null,"Izejviela","Esošie apjomi gadā",null,null,null,null,"Izmaiņas pēc projekta īstenošanas",null,null,null,null,null,null,"Ietaupījums",null,"Ietaupījums uz 1 vienību"]
[null,null,"Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR","Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR",null,null,"Apjoms gadā","%","Apjoms gadā","%"]
[null,"Siltumenerģija",null,null,null,{"$f":"IF(AND(D22<>\"\",E22<>\"\"),D22*E22,\"\")","v":""},{"$f":"IFERROR(IF(OR($B22=\"\",$F22=\"\",$D$7=\"\"),0,(F22/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},{"$f":"IF(C22<>\"\",C22,\"\")","v":""},null,null,{"$f":"IF(AND(I22<>\"\",J22<>\"\"),I22*J22,\"\")","v":""},{"$f":"IFERROR(IF(OR($B22=\"\",$K22=\"\",$D$7=\"\"),0,(K22/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,{"$f":"IFERROR(IF(OR(I22=\"\"),\"\",D22-I22),0)","v":""},{"$f":"IFERROR(IF(OR(O22=\"\",D22=\"\"),\"\",O22/D22),0)","v":""},{"$f":"IFERROR(IF(AND(D22=\"\",I22=\"\"),\"\",G22-L22),0)","v":""},{"$f":"IFERROR(IF(OR(D22=\"\",Q22=\"\"),\"\",Q22/G22),0)","v":""}]
[null,"Elektroenerģija",null,null,null,"",{"$f":"IFERROR(IF(OR($B23=\"\",$F23=\"\",$D$7=\"\"),0,(F23/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},{"$f":"IF(C23<>\"\",C23,\"\")","v":""},null,null,{"$f":"IF(AND(I23<>\"\",J23<>\"\"),I23*J23,\"\")","v":""},{"$f":"IFERROR(IF(OR($B23=\"\",$K23=\"\",$D$7=\"\"),0,(K23/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,{"$f":"IFERROR(IF(OR(I23=\"\"),\"\",D23-I23),0)","v":""},{"$f":"IFERROR(IF(OR(O23=\"\",D23=\"\"),\"\",O23/D23),0)","v":""},{"$f":"IFERROR(IF(AND(D23=\"\",I23=\"\"),\"\",G23-L23),0)","v":""},{"$f":"IFERROR(IF(OR(D23=\"\",Q23=\"\"),\"\",Q23/G23),0)","v":""}]
[null,"Šķelda","tonna",100,100000,10000000,{"$f":"IFERROR(IF(OR($B24=\"\",$F24=\"\",$D$7=\"\"),0,(F24/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"tonna",100,100000,{"$f":"IF(AND(I24<>\"\",J24<>\"\"),I24*J24,\"\")","v":10000000},{"$f":"IFERROR(IF(OR($B24=\"\",$K24=\"\",$D$7=\"\"),0,(K24/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,{"$f":"IFERROR(IF(OR(I24=\"\"),\"\",D24-I24),0)","v":0},{"$f":"IFERROR(IF(OR(O24=\"\",D24=\"\"),\"\",O24/D24),0)","v":0},{"$f":"IFERROR(IF(AND(D24=\"\",I24=\"\"),\"\",G24-L24),0)","v":0},0]
[null,"Granulas",null,null,null,{"$f":"IF(AND(D25<>\"\",E25<>\"\"),D25*E25,\"\")","v":""},{"$f":"IFERROR(IF(OR($B25=\"\",$F25=\"\",$D$7=\"\"),0,(F25/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},{"$f":"IF(C25<>\"\",C25,\"\")","v":""},null,null,{"$f":"IF(AND(I25<>\"\",J25<>\"\"),I25*J25,\"\")","v":""},{"$f":"IFERROR(IF(OR($B25=\"\",$K25=\"\",$D$7=\"\"),0,(K25/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Saspiestā gāze",null,null,null,"",{"$f":"IFERROR(IF(OR($B26=\"\",$F26=\"\",$D$7=\"\"),0,(F26/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B26=\"\",$K26=\"\",$D$7=\"\"),0,(K26/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Sašķidrinātā propāna gāze",null,null,null,"",{"$f":"IFERROR(IF(OR($B27=\"\",$F27=\"\",$D$7=\"\"),0,(F27/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B27=\"\",$K27=\"\",$D$7=\"\"),0,(K27/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Akmeņogles",null,null,null,"",{"$f":"IFERROR(IF(OR($B28=\"\",$F28=\"\",$D$7=\"\"),0,(F28/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B28=\"\",$K28=\"\",$D$7=\"\"),0,(K28/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Mazuts",null,null,null,"",{"$f":"IFERROR(IF(OR($B29=\"\",$F29=\"\",$D$7=\"\"),0,(F29/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B29=\"\",$K29=\"\",$D$7=\"\"),0,(K29/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Dīzelis",null,null,null,"",{"$f":"IFERROR(IF(OR($B30=\"\",$F30=\"\",$D$7=\"\"),0,(F30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B30=\"\",$K30=\"\",$D$7=\"\"),0,(K30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Benzīns",null,null,null,"",{"$f":"IFERROR(IF(OR($B31=\"\",$F31=\"\",$D$7=\"\"),0,(F31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B31=\"\",$K31=\"\",$D$7=\"\"),0,(K31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Bioetanols",null,null,null,"",{"$f":"IFERROR(IF(OR($B32=\"\",$F32=\"\",$D$7=\"\"),0,(F32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B32=\"\",$K32=\"\",$D$7=\"\"),0,(K32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Biogāze",null,null,null,"",{"$f":"IFERROR(IF(OR($B33=\"\",$F33=\"\",$D$7=\"\"),0,(F33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B33=\"\",$K33=\"\",$D$7=\"\"),0,(K33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($B34=\"\",$F34=\"\",$D$7=\"\"),0,(F34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B34=\"\",$K34=\"\",$D$7=\"\"),0,(K34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($B35=\"\",$F35=\"\",$D$7=\"\"),0,(F35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B35=\"\",$K35=\"\",$D$7=\"\"),0,(K35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($B36=\"\",$F36=\"\",$D$7=\"\"),0,(F36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B36=\"\",$K36=\"\",$D$7=\"\"),0,(K36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,{"$f":"IF(COUNTIF(C22:C36,\"cits\"),\"Cita veida mērvienībām norādiet tās nosaukumu blakus izejvielas nosaukumam\",\"\")","v":""},null,null,"Kopā, EUR",{"$f":"SUM(F22:F36)","v":10000000},{"$f":"SUM(G22:G36)","v":0},"Kopā, EUR",null,null,{"$f":"SUM(K22:K36)","v":10000000},{"$f":"SUM(L22:L36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums, EUR",null,{"$f":"F37-K37","v":0}]
[null,"Finansiālais ietaupījums/ novērtējums"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums uz vienību, EUR",null,{"$f":"G37-L37","v":0}]
[null,{"$f":"Izvelnes!$E$22","v":"Pamatlīdzekļu lietderīgais izmantošanas periods, gados"},null,25,{"$f":"IF(D45>D41,Izvelnes!$E$23,\"\")","v":""}]
[]
[null,"Kopējais finansiālais ietaupījums",null,{"$f":"'EE un ilgtsp.fin.novērt.'!$J$77+Q38","v":0}]
[null,"Investīciju atdeves periods, gados",null,{"$f":"IF(D43<>0,'EE un ilgtsp.fin.novērt.'!$C$16/D43,0)","v":0}]
[null,"Aizdevuma atdeves periods, gados",null,{"$f":"IF(D43<>0,'EE un ilgtsp.fin.novērt.'!$C$17/D43,0)","v":0}]

{"sheet":"AER pašpatēriņam","index":2,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":true,"merged":[[44,1,44,2],[36,7,36,9],[37,14,38,15],[39,14,40,15],[40,1,41,2],[42,1,42,2],[43,1,43,2],[17,14,17,17],[19,1,20,1],[19,2,19,6],[19,7,19,11],[19,14,19,15],[19,16,19,17],[16,4,16,8],[6,1,9,2],[6,4,6,8],[7,4,7,8],[8,4,8,8],[9,4,9,8],[10,4,10,8],[11,4,11,8],[12,4,12,8],[13,4,13,8],[14,4,14,8],[15,4,15,8]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AER PASĀKUMI PAŠPATĒRIŅAM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"energoresursu patēriņš"]
[]
[null,"Šo lapu aizpildiet, ja plānojat īstenot atjaunojamās enerģijas pasākumus pašpatēriņam!"]
[]
[null,"Balstoties uz kuriem no ieņēmumu tabulā norādītajiem produktiem/pakalpojumiem tiks rēķināta iegūstamā efektivitāte/ ilgtspēja?",null,{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!),\"I\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!),\"\",\"Izvēlieties vismaz 1 produktu !\")","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B25","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B26","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B27","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B28","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B29","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B30","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B31","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B32","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B33","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B34","v":0}]
[null,"Lūdzu norādiet tabulā esošos un plānotos energoresursu apjomus, kuri tiks ietaupīti pēc projekta īstenošanas:",null,null,null,null,null,null,null,null,null,null,null,null,"Enerģijas ietaupījums"]
[]
[null,"Izejviela","Esošie apjomi gadā",null,null,null,null,"Izmaiņas pēc projekta īstenošanas",null,null,null,null,null,null,"Ietaupījums",null,"Ietaupījums uz 1 vienību"]
[null,null,"Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR","Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR",null,null,"Apjoms gadā","%","Apjoms gadā","%"]
[null,"Elektroenerģija, no tīkla",null,null,null,{"$f":"IF(AND(D22<>\"\",E22<>\"\"),D22*E22,\"\")","v":""},{"$f":"IFERROR(IF(OR($B22=\"\",$F22=\"\",$D$7=\"\"),0,(F22/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},{"$f":"IF(C22<>\"\",C22,\"\")","v":""},null,null,{"$f":"IF(AND(I22<>\"\",J22<>\"\"),I22*J22,\"\")","v":""},{"$f":"IFERROR(IF(OR($B22=\"\",$K22=\"\",$D$7=\"\"),0,(K22/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,{"$f":"IF(OR(I22=\"\"),\"\",D22-I22)","v":""},{"$f":"IFERROR(IF(OR(O22=\"\",D22=\"\"),\"\",O22/D22),0)","v":""},{"$f":"IF(AND(D22=\"\",I22=\"\"),\"\",G22-L22)","v":""},{"$f":"IFERROR(IF(OR(D22=\"\",Q22=\"\"),\"\",Q22/G22),0)","v":""}]
[null,"Elektroenerģija, pašražotā",null,null,null,"",{"$f":"IFERROR(IF(OR($B23=\"\",$F23=\"\",$D$7=\"\"),0,(F23/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},{"$f":"IF(C23<>\"\",C23,\"\")","v":""},null,null,{"$f":"IF(AND(I23<>\"\",J23<>\"\"),I23*J23,\"\")","v":""},{"$f":"IFERROR(IF(OR($B23=\"\",$K23=\"\",$D$7=\"\"),0,(K23/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,{"$f":"IF(OR(I23=\"\"),\"\",D23-I23)","v":""},{"$f":"IFERROR(IF(OR(O23=\"\",D23=\"\"),\"\",O23/D23),0)","v":""},{"$f":"IF(AND(D23=\"\",I23=\"\"),\"\",G23-L23)","v":""},{"$f":"IFERROR(IF(OR(D23=\"\",Q23=\"\"),\"\",Q23/G23),0)","v":""}]
[null,"Šķelda","m3",20000,20,400000,{"$f":"IFERROR(IF(OR($B24=\"\",$F24=\"\",$D$7=\"\"),0,(F24/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"m3",22000,20,{"$f":"IF(AND(I24<>\"\",J24<>\"\"),I24*J24,\"\")","v":440000},{"$f":"IFERROR(IF(OR($B24=\"\",$K24=\"\",$D$7=\"\"),0,(K24/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,{"$f":"IF(OR(I24=\"\"),\"\",D24-I24)","v":-2000},-0.1,{"$f":"IF(AND(D24=\"\",I24=\"\"),\"\",G24-L24)","v":0},0]
[null,"Granulas",null,null,null,"",{"$f":"IFERROR(IF(OR($B25=\"\",$F25=\"\",$D$7=\"\"),0,(F25/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,{"$f":"IF(AND(I25<>\"\",J25<>\"\"),I25*J25,\"\")","v":""},{"$f":"IFERROR(IF(OR($B25=\"\",$K25=\"\",$D$7=\"\"),0,(K25/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,{"$f":"IF(OR(I25=\"\"),\"\",D25-I25)","v":""},"",{"$f":"IF(AND(D25=\"\",I25=\"\"),\"\",G25-L25)","v":""},""]
[null,"Saspiestā gāze",null,null,null,"",{"$f":"IFERROR(IF(OR($B26=\"\",$F26=\"\",$D$7=\"\"),0,(F26/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B26=\"\",$K26=\"\",$D$7=\"\"),0,(K26/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Sašķidrinātā propāna gāze",null,null,null,"",{"$f":"IFERROR(IF(OR($B27=\"\",$F27=\"\",$D$7=\"\"),0,(F27/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B27=\"\",$K27=\"\",$D$7=\"\"),0,(K27/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Akmeņogles",null,null,null,"",{"$f":"IFERROR(IF(OR($B28=\"\",$F28=\"\",$D$7=\"\"),0,(F28/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B28=\"\",$K28=\"\",$D$7=\"\"),0,(K28/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Mazuts",null,null,null,"",{"$f":"IFERROR(IF(OR($B29=\"\",$F29=\"\",$D$7=\"\"),0,(F29/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B29=\"\",$K29=\"\",$D$7=\"\"),0,(K29/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Dīzelis",null,null,null,"",{"$f":"IFERROR(IF(OR($B30=\"\",$F30=\"\",$D$7=\"\"),0,(F30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B30=\"\",$K30=\"\",$D$7=\"\"),0,(K30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Benzīns",null,null,null,"",{"$f":"IFERROR(IF(OR($B31=\"\",$F31=\"\",$D$7=\"\"),0,(F31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B31=\"\",$K31=\"\",$D$7=\"\"),0,(K31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Bioetanols",null,null,null,"",{"$f":"IFERROR(IF(OR($B32=\"\",$F32=\"\",$D$7=\"\"),0,(F32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B32=\"\",$K32=\"\",$D$7=\"\"),0,(K32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Biogāze",null,null,null,"",{"$f":"IFERROR(IF(OR($B33=\"\",$F33=\"\",$D$7=\"\"),0,(F33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B33=\"\",$K33=\"\",$D$7=\"\"),0,(K33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,"Siltumenerģija, centralizētā",null,null,null,"",{"$f":"IFERROR(IF(OR($B34=\"\",$F34=\"\",$D$7=\"\"),0,(F34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B34=\"\",$K34=\"\",$D$7=\"\"),0,(K34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($B35=\"\",$F35=\"\",$D$7=\"\"),0,(F35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B35=\"\",$K35=\"\",$D$7=\"\"),0,(K35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(OR($B36=\"\",$F36=\"\",$D$7=\"\"),0,(F36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34))),0)","v":0},"",null,null,"",{"$f":"IFERROR(IF(OR($B36=\"\",$K36=\"\",$D$7=\"\"),0,(K36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34))),0)","v":0},null,null,"","","",""]
[null,{"$f":"IF(COUNTIF(C22:C36,\"cits\"),\"Cita veida mērvienībām norādiet tās nosaukumu blakus izejvielas nosaukumam\",\"\")","v":""},null,null,"Kopā, EUR",{"$f":"SUM(F22:F36)","v":400000},{"$f":"SUM(G22:G36)","v":0},"Kopā, EUR",null,null,{"$f":"SUM(K22:K36)","v":440000},{"$f":"SUM(L22:L36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums, EUR",null,{"$f":"F37-K37","v":-40000}]
[null,"Finansiālais ietaupījums/ novērtējums"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums uz vienību, EUR",null,{"$f":"G37-L37","v":0}]
[null,{"$f":"Izvelnes!$E$22","v":"Pamatlīdzekļu lietderīgais izmantošanas periods, gados"},null,null,{"$f":"IF(D45>D41,Izvelnes!$E$23,\"\")","v":""}]
[]
[null,"Kopējais finansiālais ietaupījums",null,{"$f":"'EE un ilgtsp.fin.novērt.'!$J$77+Q38","v":-40000}]
[null,"Investīciju atdeves periods, gados",null,{"$f":"IF(D43<>0,'EE un ilgtsp.fin.novērt.'!$C$16/D43,0)","v":0}]
[null,"Aizdevuma atdeves periods, gados",null,{"$f":"IF(D43<>0,'EE un ilgtsp.fin.novērt.'!$C$17/D43,0)","v":0}]

{"sheet":"Atjaunojamā enerģija","index":3,"n_rows":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":true,"merged":[[6,1,8,2],[19,1,20,1],[19,2,19,6],[19,7,19,11],[19,14,19,15],[6,4,6,8],[7,4,7,8],[8,4,8,8],[9,4,9,8],[10,4,10,8],[11,4,11,8],[12,4,12,8],[13,4,13,8],[14,4,14,8],[15,4,15,8],[16,4,16,8],[40,1,41,2],[19,16,19,17],[36,1,37,2],[36,7,36,9],[37,14,38,15],[39,14,40,15],[46,1,48,2],[50,3,52,12],[50,1,52,2],[42,1,42,2],[43,1,43,2],[44,1,44,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ATJAUNOJAMĀS ENERĢIJAS PASĀKUMU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"energoresursu patēriņš"]
[]
[null,"Šo lapu aizpildiet, ja plānojat īstenot atjaunojamās enerģijas pasākumus enerģijas nodošanai tīklā!"]
[]
[null,"Balstoties uz kuriem no ieņēmumu tabulā norādītajiem produktiem/pakalpojumiem tiks rēķināta  iegūstamā efektivitāte/ ilgtspēja?",null,{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!),\"I\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!),\"\",\"Izvēlieties vismaz 1 produktu !\")","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B25","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B26","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B27","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B28","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B29","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B30","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B31","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B32","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B33","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B34","v":0}]
[null,"Lūdzu norādiet tabulā esošos un plānotos energoresursu apjomus, kuri tiks ietaupīti pēc projekta īstenošanas (jaunas ražotnes gadījumā ietaupījums var neveidoties!):",null,null,null,null,null,null,null,null,null,null,null,null,"Enerģijas ietaupījums"]
[]
[null,"Izejviela","Esošie apjomi gadā",null,null,null,null,"Izmaiņas pēc projekta īstenošanas",null,null,null,null,null,null,"Ietaupījums",null,"Ietaupījums uz 1 vienību"]
[null,null,"Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR","Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR",null,null,"Apjoms gadā","%","Apjoms gadā","%"]
[null,"Siltumenerģija",null,null,null,{"$f":"IF(AND(D22<>\"\",E22<>\"\"),D22*E22,\"\")","v":""},{"$f":"IF(OR($B22=\"\",$F22=\"\",$D$7=\"\"),0,(F22/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},{"$f":"IF(C22<>\"\",C22,\"\")","v":""},null,null,{"$f":"IF(AND(I22<>\"\",J22<>\"\"),I22*J22,\"\")","v":""},{"$f":"IF(OR($B22=\"\",$K22=\"\",$D$7=\"\"),0,(K22/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(OR(I22=\"\"),\"\",D22-I22)","v":""},{"$f":"IF(OR(O22=\"\",D22=\"\"),\"\",O22/D22)","v":""},{"$f":"IF(AND(D22=\"\",I22=\"\"),\"\",G22-L22)","v":""},{"$f":"IF(OR(D22=\"\",Q22=\"\"),\"\",Q22/G22)","v":""}]
[null,"Elektroenerģija",null,null,null,"",{"$f":"IF(OR($B23=\"\",$F23=\"\",$D$7=\"\"),0,(F23/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},{"$f":"IF(C23<>\"\",C23,\"\")","v":""},null,null,"",{"$f":"IF(OR($B23=\"\",$K23=\"\",$D$7=\"\"),0,(K23/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(OR(I23=\"\"),\"\",D23-I23)","v":""},{"$f":"IF(OR(O23=\"\",D23=\"\"),\"\",O23/D23)","v":""},{"$f":"IF(AND(D23=\"\",I23=\"\"),\"\",G23-L23)","v":""},{"$f":"IF(OR(D23=\"\",Q23=\"\"),\"\",Q23/G23)","v":""}]
[null,"Šķelda",null,null,null,"",{"$f":"IF(OR($B24=\"\",$F24=\"\",$D$7=\"\"),0,(F24/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B24=\"\",$K24=\"\",$D$7=\"\"),0,(K24/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","",{"$f":"IF(AND(D24=\"\",I24=\"\"),\"\",G24-L24)","v":""},""]
[null,"Granulas",null,null,null,"",{"$f":"IF(OR($B25=\"\",$F25=\"\",$D$7=\"\"),0,(F25/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B25=\"\",$K25=\"\",$D$7=\"\"),0,(K25/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,"Saspiestā gāze",null,null,null,"",{"$f":"IF(OR($B26=\"\",$F26=\"\",$D$7=\"\"),0,(F26/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B26=\"\",$K26=\"\",$D$7=\"\"),0,(K26/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,"Sašķidrinātā propāna gāze",null,null,null,"",{"$f":"IF(OR($B27=\"\",$F27=\"\",$D$7=\"\"),0,(F27/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B27=\"\",$K27=\"\",$D$7=\"\"),0,(K27/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,"Akmeņogles",null,null,null,"",{"$f":"IF(OR($B28=\"\",$F28=\"\",$D$7=\"\"),0,(F28/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B28=\"\",$K28=\"\",$D$7=\"\"),0,(K28/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,"Mazuts",null,null,null,"",{"$f":"IF(OR($B29=\"\",$F29=\"\",$D$7=\"\"),0,(F29/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B29=\"\",$K29=\"\",$D$7=\"\"),0,(K29/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,"Dīzelis",null,null,null,"",{"$f":"IF(OR($B30=\"\",$F30=\"\",$D$7=\"\"),0,(F30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B30=\"\",$K30=\"\",$D$7=\"\"),0,(K30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,"Benzīns",null,null,null,"",{"$f":"IF(OR($B31=\"\",$F31=\"\",$D$7=\"\"),0,(F31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B31=\"\",$K31=\"\",$D$7=\"\"),0,(K31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,"Bioetanols",null,null,null,"",{"$f":"IF(OR($B32=\"\",$F32=\"\",$D$7=\"\"),0,(F32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B32=\"\",$K32=\"\",$D$7=\"\"),0,(K32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,"Biogāze",null,null,null,"",{"$f":"IF(OR($B33=\"\",$F33=\"\",$D$7=\"\"),0,(F33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B33=\"\",$K33=\"\",$D$7=\"\"),0,(K33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B34=\"\",$F34=\"\",$D$7=\"\"),0,(F34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B34=\"\",$K34=\"\",$D$7=\"\"),0,(K34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B35=\"\",$F35=\"\",$D$7=\"\"),0,(F35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B35=\"\",$K35=\"\",$D$7=\"\"),0,(K35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B36=\"\",$F36=\"\",$D$7=\"\"),0,(F36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B36=\"\",$K36=\"\",$D$7=\"\"),0,(K36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,{"$f":"IF(COUNTIF(C22:C36,\"cits\"),\"Cita veida mērvienībām norādiet tās nosaukumu blakus izejvielas nosaukumam\",\"\")","v":""},null,null,"Kopā, EUR",{"$f":"SUM(F22:F36)","v":0},{"$f":"SUM(G22:G36)","v":{"$error":"#REF!"}},"Kopā, EUR",null,null,{"$f":"SUM(K22:K36)","v":0},{"$f":"SUM(L22:L36)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums, EUR",null,{"$f":"F37-K37","v":0}]
[null,"Finansiālais ietaupījums/ novērtējums"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums uz vienību, EUR",null,{"$f":"G37-L37","v":{"$error":"#REF!"}}]
[null,{"$f":"Izvelnes!$E$22","v":"Pamatlīdzekļu lietderīgais izmantošanas periods, gados"},null,null,{"$f":"IF(D45>D41,Izvelnes!$E$23,\"\")","v":""}]
[]
[null,"Ieņēmumu un izdevumu starpība",null,{"$f":"'EE un ilgtsp.fin.novērt.'!$J$35-'EE un ilgtsp.fin.novērt.'!$J$75-$K$37","v":0}]
[null,"Investīciju atdeves periods, gados",null,{"$f":"IF(D43<>0,'EE un ilgtsp.fin.novērt.'!$C$16/D43,0)","v":0}]
[null,"Aizdevuma atdeves periods, gados",null,{"$f":"IF(D43<>0,'EE un ilgtsp.fin.novērt.'!$C$17/D43,0)","v":0}]
[]
[null,"Vai projekta īstenošana veicinās uzņēmuma attīstību/ apgrozījuma pieaugumu?"]
[]
[]
[]
[null,{"$f":"IF(A55=TRUE,\"apraksts  par to, kā projekta īstenošana veicinās uzņēmuma attīstību\",\"\")","v":""}]
[]
[]
[]
[false]
[false]

{"sheet":"Zaļo ēku celtniecība","index":4,"n_rows":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":true,"merged":[[10,1,11,2],[25,1,25,7],[27,1,28,1],[27,2,27,6],[22,3,22,6],[23,3,23,6],[14,1,19,1],[13,3,13,6],[17,3,17,6],[18,3,18,6],[19,3,19,6],[20,3,20,6],[21,3,21,6],[14,3,14,6],[15,3,15,6],[16,3,16,6],[44,1,45,2],[55,1,57,1],[59,1,62,1],[59,2,62,6],[49,3,50,6],[49,1,50,1]]}
[]
[null,null,null,null,null,null,"ZAĻO ĒKU CELTNIECĪBAS PASĀKUMU"]
[null,null,null,null,null,null,"energoresursu patēriņš"]
[]
[null,"Šo lapu aizpildiet, ja plānojat īstenot jaunas zaļās ēkas celtniecības pasākumu!"]
[]
[null,"Kāda būs apsildāmās ēkas platība?"]
[null,null,null,"kv.m"]
[null,"Pagaidu energosertifikāta datums:"]
[]
[null,"Kāds būs plānotais ēkas siltumenerģijas patēriņš saskaņā ar Ēkas pagaidu energosertifikātu?"]
[null,null,null,"kWh/m2"]
[]
[null,null,{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!J33,'EE un ilgtsp.fin.novērt.'!J34,'EE un ilgtsp.fin.novērt.'!J35,'EE un ilgtsp.fin.novērt.'!J36,'EE un ilgtsp.fin.novērt.'!J37,'EE un ilgtsp.fin.novērt.'!J58,'EE un ilgtsp.fin.novērt.'!J59,'EE un ilgtsp.fin.novērt.'!J60,'EE un ilgtsp.fin.novērt.'!J61,'EE un ilgtsp.fin.novērt.'!J62),\"I\",\"\")","v":""},{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!),\"\",\"Izvēlieties vismaz 1 produktu !\")","v":{"$error":"#REF!"}}]
[null,"Balstoties uz kuru no ieņēmumu tabulā norādīto produktu/pakalpojumu tiks rēķināta iegūstamā  efektivitāte/ ilgtspēja?",null,{"$f":"'EE un ilgtsp.fin.novērt.'!B25","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B26","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B27","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B28","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B29","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B30","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B31","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B32","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B33","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B34","v":0}]
[]
[null,"Lūdzu norādiet tabulā plānotos energoresursu patēriņa apjomus:"]
[]
[null,"Izejviela","Pēc projekta īstenošanas"]
[null,null,"Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR"]
[null,null,null,null,null,{"$f":"IF(AND(D30<>\"\",E30<>\"\"),D30*E30,0)","v":0},{"$f":"IF(OR($B30=\"\",$F30=\"\",$D$14<>\"\"),0,(F30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B31=\"\",$F31=\"\",$D$14<>\"\"),0,(F31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B32=\"\",$F32=\"\",$D$14<>\"\"),0,(F32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B33=\"\",$F33=\"\",$D$14<>\"\"),0,(F33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B34=\"\",$F34=\"\",$D$14<>\"\"),0,(F34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B35=\"\",$F35=\"\",$D$14<>\"\"),0,(F35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B36=\"\",$F36=\"\",$D$14<>\"\"),0,(F36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B37=\"\",$F37=\"\",$D$14<>\"\"),0,(F37/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B38=\"\",$F38=\"\",$D$14<>\"\"),0,(F38/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B39=\"\",$F39=\"\",$D$14<>\"\"),0,(F39/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B40=\"\",$F40=\"\",$D$14<>\"\"),0,(F40/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B41=\"\",$F41=\"\",$D$14<>\"\"),0,(F41/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B42=\"\",$F42=\"\",$D$14<>\"\"),0,(F42/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B43=\"\",$F43=\"\",$D$14<>\"\"),0,(F43/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,0,{"$f":"IF(OR($B44=\"\",$F44=\"\",$D$14<>\"\"),0,(F44/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(COUNTIF(C30:C44,\"cits\"),\"Cita veida mērvienībām norādiet tās nosaukumu blakus izejvielas nosaukumam\",\"\")","v":""},null,null,"Kopā, EUR",{"$f":"SUM(F30:F44)","v":0},{"$f":"SUM(G30:G44)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Finansiālais ietaupījums/ novērtējums"]
[]
[null,{"$f":"Izvelnes!$E$22","v":"Pamatlīdzekļu lietderīgais izmantošanas periods, gados"},null,{"$f":"IF(C54>C50,Izvelnes!$E$23,\"\")","v":""}]
[]
[null,"Ieņēmumu un izdevumu starpība",{"$f":"'EE un ilgtsp.fin.novērt.'!$J$35-'EE un ilgtsp.fin.novērt.'!$J$75-$F$45","v":0}]
[null,"Investīciju atdeves periods, gados",{"$f":"IF(C52<>0,'EE un ilgtsp.fin.novērt.'!$C$16/C52,0)","v":0}]
[null,"Aizdevuma atdeves periods, gados",{"$f":"IF(C52<>0,'EE un ilgtsp.fin.novērt.'!$C$17/C52,0)","v":0}]
[]
[null,"Vai projekta īstenošana veicinās uzņēmuma attīstību/ apgrozījuma pieaugumu?"]
[]
[]
[]
[null,{"$f":"IF(A65=TRUE,\"apraksts  par to, kā projekta īstenošana veicinās uzņēmuma attīstību\",\"\")","v":""}]
[]
[]
[]
[]
[false]
[false]

{"sheet":"Ēku atjaunošana","index":5,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":true,"merged":[[45,12,46,13],[47,12,48,13],[8,1,9,2],[27,1,28,1],[27,2,27,6],[27,7,27,11],[27,12,27,13],[18,3,18,6],[19,3,19,6],[20,3,20,6],[21,3,21,6],[22,3,22,6],[23,3,23,6],[13,3,13,6],[3,5,3,8],[51,6,51,10],[49,1,50,1],[27,14,27,15],[6,1,7,2],[10,1,11,2],[25,12,25,15],[8,5,9,6],[8,9,9,10],[14,1,19,1],[14,3,14,6],[15,3,15,6],[16,3,16,6],[17,3,17,6],[44,1,45,2],[44,7,44,9]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ĒKU ATJAUNOŠANAS PASĀKUMU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"energoresursu patēriņš"]
[null,"Šo lapu aizpildiet, ja plānojat īstenot ēku atjaunošanas pasākumus!"]
[null,"Kāda ir apsildāmā ēkas platība?"]
[null,null,null,"kv.m"]
[null,"Kāds ir esošais ēkas siltumenerģijas patēriņš saskaņā ar Ēkas energosertifikātu?"]
[null,null,null,"kWh/m2"]
[null,"Kāds būs plānotais ēkas siltumenerģijas patēriņš saskaņā ar Ēkas pagaidu energosertifikātu?",null,null,null,"Ēkas siltumenerģijas ietaupījums",null,{"$f":"D7-D9","v":0},null,"Ēkas siltumenerģijas ietaupījums %",null,{"$f":"(D7-D9)/D7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"kWh/m2",null,null,null,"kWh/m2"]
[null,"Cik būs projekta izmaksas, kuras tieši ietekmē energoefektivitāti?",null,null,{"$f":"IF(OR(D11=\"\",'EE un ilgtsp.fin.novērt.'!C16=\"\"),\"\",\" (\"&TEXT((D11/'EE un ilgtsp.fin.novērt.'!C16),\"0.00%\")&\" no kopējām izmaksām)\")","v":""}]
[null,null,null,"EUR",{"$f":"IF(OR(D11=\"\",'EE un ilgtsp.fin.novērt.'!C16=\"\"),\"\",IF(D11/'EE un ilgtsp.fin.novērt.'!C16>0.5,\"Nedrīkst pārsniegt 50% no kopējām projekta izmaksām!\",\"\"))","v":""}]
[]
[null,null,null,{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!),\"\",\"Izvēlieties vismaz 1 produktu !\")","v":{"$error":"#REF!"}}]
[null,"Balstoties uz kuru no ieņēmumu tabulā norādīto produktu/pakalpojumu tiks rēķināta  iegūstamā efektivitāte/ ilgtspēja?",null,{"$f":"'EE un ilgtsp.fin.novērt.'!B25","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B26","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B27","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B28","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B29","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B30","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B31","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B32","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B33","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B34","v":0}]
[]
[null,"Lūdzu norādiet tabulā esošos un plānotos energoresursu apjomus, kuri tiks ietaupīti pēc projekta īstenošanas:",null,null,null,null,null,null,null,null,null,null,"Enerģijas ietaupījums"]
[]
[null,"Izejviela","Esošie apjomi gadā",null,null,null,null,"Izmaiņas pēc projekta īstenošanas",null,null,null,null,"Ietaupījums",null,"Ietaupījums uz 1 vienību"]
[null,null,"Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR","Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR","Apjoms gadā","%","Apjoms gadā","%"]
[null,null,null,null,null,{"$f":"IF(AND(D30<>\"\",E30<>\"\"),D30*E30,\"\")","v":""},{"$f":"IF(OR($B30=\"\",$F30=\"\",$D$14<>\"\"),0,(F30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},{"$f":"IF(C30<>\"\",C30,\"\")","v":""},null,null,{"$f":"IF(AND(I30<>\"\",J30<>\"\"),I30*J30,\"\")","v":""},{"$f":"IF(OR($B30=\"\",$K30=\"\",$D$7=\"\"),0,(K30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},{"$f":"IF(OR(I30=\"\"),\"\",D30-I30)","v":""},{"$f":"IF(OR(M30=\"\",D30=\"\"),\"\",M30/D30)","v":""},{"$f":"IF(AND(D30=\"\",I30=\"\"),\"\",G30-L30)","v":""},{"$f":"IF(OR(D30=\"\",O30=\"\"),\"\",O30/L30)","v":""}]
[null,null,null,null,null,"",{"$f":"IF(OR($B31=\"\",$F31=\"\",$D$14<>\"\"),0,(F31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},{"$f":"IF(C31<>\"\",C31,\"\")","v":""},null,null,"",{"$f":"IF(OR($B31=\"\",$K31=\"\",$D$7=\"\"),0,(K31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B32=\"\",$F32=\"\",$D$14<>\"\"),0,(F32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B32=\"\",$K32=\"\",$D$7=\"\"),0,(K32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B33=\"\",$F33=\"\",$D$14<>\"\"),0,(F33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B33=\"\",$K33=\"\",$D$7=\"\"),0,(K33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B34=\"\",$F34=\"\",$D$14<>\"\"),0,(F34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B34=\"\",$K34=\"\",$D$7=\"\"),0,(K34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B35=\"\",$F35=\"\",$D$14<>\"\"),0,(F35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B35=\"\",$K35=\"\",$D$7=\"\"),0,(K35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B36=\"\",$F36=\"\",$D$14<>\"\"),0,(F36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B36=\"\",$K36=\"\",$D$7=\"\"),0,(K36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B37=\"\",$F37=\"\",$D$14<>\"\"),0,(F37/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B37=\"\",$K37=\"\",$D$7=\"\"),0,(K37/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B38=\"\",$F38=\"\",$D$14<>\"\"),0,(F38/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B38=\"\",$K38=\"\",$D$7=\"\"),0,(K38/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B39=\"\",$F39=\"\",$D$14<>\"\"),0,(F39/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B39=\"\",$K39=\"\",$D$7=\"\"),0,(K39/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B40=\"\",$F40=\"\",$D$14<>\"\"),0,(F40/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B40=\"\",$K40=\"\",$D$7=\"\"),0,(K40/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B41=\"\",$F41=\"\",$D$14<>\"\"),0,(F41/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B41=\"\",$K41=\"\",$D$7=\"\"),0,(K41/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B42=\"\",$F42=\"\",$D$14<>\"\"),0,(F42/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B42=\"\",$K42=\"\",$D$7=\"\"),0,(K42/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B43=\"\",$F43=\"\",$D$14<>\"\"),0,(F43/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B43=\"\",$K43=\"\",$D$7=\"\"),0,(K43/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B44=\"\",$F44=\"\",$D$14<>\"\"),0,(F44/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B44=\"\",$K44=\"\",$D$7=\"\"),0,(K44/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},"","","",""]
[null,{"$f":"IF(COUNTIF(C30:C44,\"cits\"),\"Cita veida mērvienībām norādiet tās nosaukumu blakus izejvielas nosaukumam\",\"\")","v":""},null,null,"Kopā, EUR",{"$f":"SUM(F30:F44)","v":0},{"$f":"SUM(G30:G44)","v":{"$error":"#REF!"}},"Kopā, EUR",null,null,{"$f":"SUM(K30:K44)","v":0},{"$f":"SUM(L30:L44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums, EUR",null,{"$f":"F45-K45","v":0}]
[]
[null,"Finansiālais ietaupījums/ novērtējums",null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums uz vienību, EUR",null,{"$f":"G45-L45","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"Izvelnes!$E$22","v":"Pamatlīdzekļu lietderīgais izmantošanas periods, gados"},null,{"$f":"IF(C54>C50,Izvelnes!$E$23,\"\")","v":""}]
[]
[null,"Kopējais finansiālais ietaupījums",{"$f":"'EE un ilgtsp.fin.novērt.'!$J$77+F45-K45","v":0}]
[null,"Investīciju atdeves periods, gados",{"$f":"IF(C52<>0,'EE un ilgtsp.fin.novērt.'!$C$16/C52,0)","v":0}]
[null,"Aizdevuma atdeves periods, gados",{"$f":"IF(C52<>0,'EE un ilgtsp.fin.novērt.'!$C$17/C52,0)","v":0}]

{"sheet":"Transporta risinājumi","index":6,"n_rows":68,"n_cols":18,"rows_kept":68,"cut":false,"hidden":true,"merged":[[25,14,25,17],[27,14,27,15],[27,16,27,17],[45,14,46,15],[47,14,48,15],[6,6,6,7],[8,6,8,7],[27,1,28,1],[27,7,27,11],[13,3,13,6],[14,1,19,1],[14,3,14,6],[15,3,15,6],[16,3,16,6],[17,3,17,6],[18,3,18,6],[19,3,19,6],[20,3,20,6],[49,1,50,2],[52,1,52,2],[21,3,21,6],[22,3,22,6],[23,3,23,6],[27,2,27,6],[55,1,57,2],[59,1,61,2],[59,3,61,11],[53,1,53,2],[51,1,51,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ILGTSPĒJĪGO TRANSPORTA RISINĀJUMU PASĀKUMU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"energoresursu patēriņš"]
[null,"Šo lapu aizpildiet, ja plānojat īstenot ilgtspējīga transporta risinājuma pasākumu!"]
[null,"Cik plānots gadā nobraukt, km?"]
[null,null,null,"km"]
[null,"Esošais degvielas patēriņš",null,null,null,{"$f":"IF(OR(D7=\"\",E7=\"\"),\"\",VLOOKUP(D7,Izvelnes!$B$12:$C$17,2,FALSE)*E7)","v":""},{"$f":"IF(OR(D7=\"\",E7=\"\"),\"\",\" (1 L = \" & VLOOKUP(D7,Izvelnes!$B$12:$C$17,2,FALSE)&\" kWh)\")","v":""}]
[null,null,null,"Degviela","Patēriņš, litri","kWh"]
[null,"Plānotais degvielas patēriņš",null,null,null,{"$f":"IF(OR(D9=\"\",E9=\"\"),\"\",VLOOKUP(D9,Izvelnes!$B$12:$C$17,2,FALSE)*E9)","v":""},{"$f":"IF(OR(D9=\"\",E9=\"\"),\"\",\" (1 L = \" & VLOOKUP(D9,Izvelnes!$B$12:$C$17,2,FALSE)&\" kWh)\")","v":""}]
[null,null,null,"Degviela","Patēriņš, litri","kWh"]
[null,"Aizstātā fosilā enerģija:",null,{"$f":"IF(F7=\"\",0,F7&\" kWh\")","v":0}]
[]
[]
[null,null,null,{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!),\"\",\"Izvēlieties vismaz 1 produktu !\")","v":{"$error":"#REF!"}}]
[null,"Balstoties uz kuru no ieņēmumu tabulā norādīto produktu/pakalpojumu tiks rēķināta iegūstamā  efektivitāte/ ilgtspēja?",null,{"$f":"'EE un ilgtsp.fin.novērt.'!B25","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B26","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B27","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B28","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B29","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B30","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B31","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B32","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B33","v":0}]
[null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B34","v":0}]
[]
[null,"Lūdzu norādiet tabulā esošos un plānotos energoresursu apjomus, kuri tiks ietaupīti pēc projekta īstenošanas:",null,null,null,null,null,null,null,null,null,null,null,null,"Enerģijas ietaupījums"]
[]
[null,"Izejviela","Esošie apjomi gadā",null,null,null,null,"Izmaiņas pēc projekta īstenošanas",null,null,null,null,null,null,"Ietaupījums",null,"Ietaupījums uz 1 vienību"]
[null,null,"Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR","Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR",null,null,"Apjoms gadā","%","Apjoms gadā","%"]
[null,null,null,null,null,{"$f":"IF(AND(D30<>\"\",E30<>\"\"),D30*E30,\"\")","v":""},{"$f":"IF(OR($B30=\"\",$F30=\"\",$D$14<>\"\"),0,(F30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},{"$f":"IF(C30<>\"\",C30,\"\")","v":""},null,null,{"$f":"IF(AND(I30<>\"\",J30<>\"\"),I30*J30,\"\")","v":""},{"$f":"IF(OR($B30=\"\",$K30=\"\",$D$7=\"\"),0,(K30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,{"$f":"IF(OR(D30=\"\",I30=\"\"),\"\",D30-I30)","v":""},{"$f":"IF(OR(O30=\"\",D30=\"\"),\"\",O30/D30)","v":""},{"$f":"IF(AND(B22=\"\",G30=\"\"),\"\",G30-L30)","v":{"$error":"#REF!"}},{"$f":"IF(OR(B30=\"\",Q30=\"\"),\"\",Q30/G30)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"IF(AND(D31<>\"\",E31<>\"\"),D31*E31,\"\")","v":""},{"$f":"IF(OR($B31=\"\",$F31=\"\",$D$14<>\"\"),0,(F31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},{"$f":"IF(C31<>\"\",C31,\"\")","v":""},null,null,"",{"$f":"IF(OR($B31=\"\",$K31=\"\",$D$7=\"\"),0,(K31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B32=\"\",$F32=\"\",$D$14<>\"\"),0,(F32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,{"$f":"IF(AND(I32<>\"\",J32<>\"\"),I32*J32,\"\")","v":""},{"$f":"IF(OR($B32=\"\",$K32=\"\",$D$7=\"\"),0,(K32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$f":"IF(OR(B32=\"\",Q32=\"\"),\"\",Q32/G32)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"",{"$f":"IF(OR($B33=\"\",$F33=\"\",$D$14<>\"\"),0,(F33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B33=\"\",$K33=\"\",$D$7=\"\"),0,(K33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B34=\"\",$F34=\"\",$D$14<>\"\"),0,(F34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B34=\"\",$K34=\"\",$D$7=\"\"),0,(K34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B35=\"\",$F35=\"\",$D$14<>\"\"),0,(F35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B35=\"\",$K35=\"\",$D$7=\"\"),0,(K35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B36=\"\",$F36=\"\",$D$14<>\"\"),0,(F36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B36=\"\",$K36=\"\",$D$7=\"\"),0,(K36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B37=\"\",$F37=\"\",$D$14<>\"\"),0,(F37/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B37=\"\",$K37=\"\",$D$7=\"\"),0,(K37/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B38=\"\",$F38=\"\",$D$14<>\"\"),0,(F38/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B38=\"\",$K38=\"\",$D$7=\"\"),0,(K38/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B39=\"\",$F39=\"\",$D$14<>\"\"),0,(F39/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B39=\"\",$K39=\"\",$D$7=\"\"),0,(K39/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B40=\"\",$F40=\"\",$D$14<>\"\"),0,(F40/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B40=\"\",$K40=\"\",$D$7=\"\"),0,(K40/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B41=\"\",$F41=\"\",$D$14<>\"\"),0,(F41/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,{"$f":"IF(AND(I41<>\"\",J41<>\"\"),I41*J41,\"\")","v":""},{"$f":"IF(OR($B41=\"\",$K41=\"\",$D$7=\"\"),0,(K41/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B42=\"\",$F42=\"\",$D$14<>\"\"),0,(F42/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B42=\"\",$K42=\"\",$D$7=\"\"),0,(K42/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B43=\"\",$F43=\"\",$D$14<>\"\"),0,(F43/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B43=\"\",$K43=\"\",$D$7=\"\"),0,(K43/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,"",{"$f":"IF(OR($B44=\"\",$F44=\"\",$D$14<>\"\"),0,(F44/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B44=\"\",$K44=\"\",$D$7=\"\"),0,(K44/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":0},null,null,"","",{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(COUNTIF(H30:H44,\"cits\"),\"Cita veida mērvienībām norādiet tās nosaukumu blakus izejvielas nosaukumam\",\"\")","v":""},null,null,"Kopā, EUR",{"$f":"SUM(F30:F44)","v":0},{"$f":"SUM(G30:G44)","v":{"$error":"#REF!"}},null,null,"Kopā, EUR",{"$f":"SUM(K30:K44)","v":0},{"$f":"SUM(L30:L44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums, EUR",null,{"$f":"F45-K45","v":0}]
[]
[null,"Finansiālais ietaupījums/ novērtējums",null,null,null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums uz vienību, EUR",null,{"$f":"G45-L45","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"Izvelnes!$E$22","v":"Pamatlīdzekļu lietderīgais izmantošanas periods, gados"},null,null,{"$f":"IF(D54>D50,Izvelnes!$E$23,\"\")","v":""}]
[]
[null,"Ieņēmumu un izdevumu starpība",null,{"$f":"'EE un ilgtsp.fin.novērt.'!$J$35-'EE un ilgtsp.fin.novērt.'!$J$75-$K$45","v":0}]
[null,"Investīciju atdeves periods, gados",null,{"$f":"IF(D52<>0,'EE un ilgtsp.fin.novērt.'!$C$16/D52,0)","v":0}]
[null,"Aizdevuma atdeves periods, gados",null,{"$f":"IF(D52<>0,'EE un ilgtsp.fin.novērt.'!$C$17/D52,0)","v":0}]
[]
[null,"Vai projekta īstenošana veicinās uzņēmuma attīstību/ apgrozījuma pieaugumu?"]
[]
[]
[]
[null,{"$f":"IF(A67=TRUE,\"apraksts  par to, kā projekta īstenošana veicinās uzņēmuma attīstību\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[false]
[false]

{"sheet":"Enerģijas izmaksu samazināšana","index":7,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":true,"merged":[[39,14,40,15],[17,14,17,17],[15,4,15,8],[19,14,19,15],[19,16,19,17],[5,5,5,8],[37,14,38,15],[10,4,10,8],[11,4,11,8],[12,4,12,8],[13,4,13,8],[14,4,14,8],[6,4,6,8],[7,4,7,8],[8,4,8,8],[9,4,9,8],[6,1,9,2],[43,1,43,2],[44,1,44,2],[16,4,16,8],[36,1,37,2],[19,1,20,1],[19,2,19,6],[19,7,19,11],[36,7,36,9],[42,1,42,2],[40,1,41,2]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERĢIJAS IZMAKSU SAMAZINĀŠANAS PASĀKUMU"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"energoresursu patēriņš"]
[]
[null,"Šo lapu aizpildiet, ja plānojat īstenot enerģijas izmaksu samazināšanas pasākumu!"]
[]
[null,"Balstoties uz kuriem no ieņēmumu tabulā norādītajiem produktiem/pakalpojumiem tiks rēķināta iegūstamā efektivitāte/ ilgtspēja?",null,{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!),\"I\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(OR('EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!,'EE un ilgtsp.fin.novērt.'!#REF!),\"\",\"Izvēlieties vismaz 1 produktu !\")","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B25","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B26","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B27","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B28","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B29","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B30","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B31","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B32","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B33","v":0}]
[null,null,null,null,{"$f":"'EE un ilgtsp.fin.novērt.'!B34","v":0}]
[null,"Lūdzu norādiet tabulā esošos un plānotos energoresursu apjomus, kuri tiks ietaupīti pēc projekta īstenošanas:",null,null,null,null,null,null,null,null,null,null,null,null,"Enerģijas ietaupījums"]
[]
[null,"Izejviela","Esošie apjomi gadā",null,null,null,null,"Izmaiņas pēc projekta īstenošanas",null,null,null,null,null,null,"Ietaupījums",null,"Ietaupījums uz 1 vienību"]
[null,null,"Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR","Mērvienība","Apjoms gadā","Vienības cena, EUR","Summa, EUR","Izdevumi uz vienību, EUR",null,null,"Apjoms gadā","%","Apjoms gadā","%"]
[null,null,null,null,null,{"$f":"IF(AND(D22<>\"\",E22<>\"\"),D22*E22,\"\")","v":""},{"$f":"IF(OR($B22=\"\",$F22=\"\",$D$7=\"\"),0,(F22/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},{"$f":"IF(C22<>\"\",C22,\"\")","v":""},null,null,{"$f":"IF(AND(I22<>\"\",J22<>\"\"),I22*J22,\"\")","v":""},{"$f":"IF(OR($B22=\"\",$K22=\"\",$D$7=\"\"),0,(K22/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(OR(I22=\"\"),\"\",D22-I22)","v":""},{"$f":"IF(OR(O22=\"\",D22=\"\"),\"\",O22/D22)","v":""},{"$f":"IF(AND(D22=\"\",I22=\"\"),\"\",G22-L22)","v":""},{"$f":"IF(OR(D22=\"\",Q22=\"\"),\"\",Q22/G22)","v":""}]
[null,null,null,null,null,"",{"$f":"IF(OR($B23=\"\",$F23=\"\",$D$7=\"\"),0,(F23/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},{"$f":"IF(C23<>\"\",C23,\"\")","v":""},null,null,"",{"$f":"IF(OR($B23=\"\",$K23=\"\",$D$7=\"\"),0,(K23/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(OR(I23=\"\"),\"\",D23-I23)","v":""},{"$f":"IF(OR(O23=\"\",D23=\"\"),\"\",O23/D23)","v":""},{"$f":"IF(AND(D23=\"\",I23=\"\"),\"\",G23-L23)","v":""},{"$f":"IF(OR(D23=\"\",Q23=\"\"),\"\",Q23/G23)","v":""}]
[null,null,null,null,null,"",{"$f":"IF(OR($B24=\"\",$F24=\"\",$D$7=\"\"),0,(F24/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B24=\"\",$K24=\"\",$D$7=\"\"),0,(K24/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","",{"$f":"IF(AND(D24=\"\",I24=\"\"),\"\",G24-L24)","v":""},""]
[null,null,null,null,null,"",{"$f":"IF(OR($B25=\"\",$F25=\"\",$D$7=\"\"),0,(F25/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B25=\"\",$K25=\"\",$D$7=\"\"),0,(K25/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B26=\"\",$F26=\"\",$D$7=\"\"),0,(F26/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B26=\"\",$K26=\"\",$D$7=\"\"),0,(K26/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B27=\"\",$F27=\"\",$D$7=\"\"),0,(F27/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B27=\"\",$K27=\"\",$D$7=\"\"),0,(K27/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B28=\"\",$F28=\"\",$D$7=\"\"),0,(F28/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B28=\"\",$K28=\"\",$D$7=\"\"),0,(K28/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B29=\"\",$F29=\"\",$D$7=\"\"),0,(F29/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B29=\"\",$K29=\"\",$D$7=\"\"),0,(K29/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B30=\"\",$F30=\"\",$D$7=\"\"),0,(F30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B30=\"\",$K30=\"\",$D$7=\"\"),0,(K30/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B31=\"\",$F31=\"\",$D$7=\"\"),0,(F31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B31=\"\",$K31=\"\",$D$7=\"\"),0,(K31/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B32=\"\",$F32=\"\",$D$7=\"\"),0,(F32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B32=\"\",$K32=\"\",$D$7=\"\"),0,(K32/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B33=\"\",$F33=\"\",$D$7=\"\"),0,(F33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B33=\"\",$K33=\"\",$D$7=\"\"),0,(K33/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B34=\"\",$F34=\"\",$D$7=\"\"),0,(F34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B34=\"\",$K34=\"\",$D$7=\"\"),0,(K34/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B35=\"\",$F35=\"\",$D$7=\"\"),0,(F35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B35=\"\",$K35=\"\",$D$7=\"\"),0,(K35/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,null,null,null,null,"",{"$f":"IF(OR($B36=\"\",$F36=\"\",$D$7=\"\"),0,(F36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$D$25:$D$34)))","v":{"$error":"#REF!"}},"",null,null,"",{"$f":"IF(OR($B36=\"\",$K36=\"\",$D$7=\"\"),0,(K36/SUMIF('EE un ilgtsp.fin.novērt.'!#REF!,TRUE,'EE un ilgtsp.fin.novērt.'!$H$25:$H$34)))","v":{"$error":"#REF!"}},null,null,"","","",""]
[null,{"$f":"IF(COUNTIF(C22:C36,\"cits\"),\"Cita veida mērvienībām norādiet tās nosaukumu blakus izejvielas nosaukumam\",\"\")","v":""},null,null,"Kopā, EUR",{"$f":"SUM(F22:F36)","v":0},{"$f":"SUM(G22:G36)","v":{"$error":"#REF!"}},"Kopā, EUR",null,null,{"$f":"SUM(K22:K36)","v":0},{"$f":"SUM(L22:L36)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums, EUR",null,{"$f":"F37-K37","v":0}]
[null,"Finansiālais ietaupījums/ novērtējums"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopējais ietaupījums uz vienību, EUR",null,{"$f":"G37-L37","v":{"$error":"#REF!"}}]
[null,{"$f":"Izvelnes!$E$22","v":"Pamatlīdzekļu lietderīgais izmantošanas periods, gados"},null,null,{"$f":"IF(D45>D41,Izvelnes!$E$23,\"\")","v":""}]
[]
[null,"Kopējais finansiālais ietaupījums",null,{"$f":"'EE un ilgtsp.fin.novērt.'!$J$77+Q38","v":0}]
[null,"Investīciju atdeves periods, gados",null,{"$f":"IF(D43<>0,'EE un ilgtsp.fin.novērt.'!$C$16/D43,0)","v":0}]
[null,"Aizdevuma atdeves periods, gados",null,{"$f":"IF(D43<>0,'EE un ilgtsp.fin.novērt.'!$C$17/D43,0)","v":0}]

{"sheet":"Izvelnes","index":8,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Mērvienība","Nr.",null,"Pasākums","Nr"]
[null,"kWh",1,null,"Energoefektivitātes pasākumi",1]
[null,"MWh",2,null,"Atjaunojamo energoresursu pasākumi (pašpatēriņam)",2]
[null,"m3",3,null,"Atjaunojamās enerģijas pasākumi",3,null,"Enerģijas izmaksu samazināšanas pasākumi"]
[null,"tonna",4,null,"Zaļo ēku pasākumi (jaunu ēku celtniecība)",4]
[null,"litri",5,null,"Zaļo ēku pasākumi (ēku atjaunošana)",5]
[null,"gab.",6,null,"Ilgtspējīga transporta risinājumi",6]
[null,"cits",7,null,"Enerģijas izmaksu samazināšanas pasākumi",7]
[null,null,null,null,"Pasākumi pārejai uz zema oglekļa ekonomiku",8]
[null,"Mērvienība","Nr."]
[null,"Benzīns, litri",9.61]
[null,"Dīzelis, litri",10.96]
[null,"Propāns, litri",6.98,null,"Visi produkti",false]
[null,"Elektrība, kWh",1]
[null,"Biodegviela, litri",10.96]
[null,"Kerosīns, litri",10.31]
[]
[]
[null,"Ienākumu tabulas izvēlne"]
[null,"Visiem produktiem",null,null,"Teksti"]
[null,{"$f":"IF('EE un ilgtsp.fin.novērt.'!B25<>\"\",'EE un ilgtsp.fin.novērt.'!B25,\"\")","v":""},null,null,"Pamatlīdzekļu lietderīgais izmantošanas periods, gados"]
[null,{"$f":"IF('EE un ilgtsp.fin.novērt.'!B26<>\"\",'EE un ilgtsp.fin.novērt.'!B26,\"\")","v":""},null,null,"Lietderīgais izmantošanas periods ir mazāks par aizdevuma atdeves periodu!"]
[null,{"$f":"IF('EE un ilgtsp.fin.novērt.'!B27<>\"\",'EE un ilgtsp.fin.novērt.'!B27,\"\")","v":""}]
[null,{"$f":"IF('EE un ilgtsp.fin.novērt.'!B28<>\"\",'EE un ilgtsp.fin.novērt.'!B28,\"\")","v":""}]
[null,{"$f":"IF('EE un ilgtsp.fin.novērt.'!B29<>\"\",'EE un ilgtsp.fin.novērt.'!B29,\"\")","v":""}]
[null,{"$f":"IF('EE un ilgtsp.fin.novērt.'!B30<>\"\",'EE un ilgtsp.fin.novērt.'!B30,\"\")","v":""}]
[null,{"$f":"IF('EE un ilgtsp.fin.novērt.'!B31<>\"\",'EE un ilgtsp.fin.novērt.'!B31,\"\")","v":""}]
[null,{"$f":"IF('EE un ilgtsp.fin.novērt.'!B32<>\"\",'EE un ilgtsp.fin.novērt.'!B32,\"\")","v":""}]
[null,{"$f":"IF('EE un ilgtsp.fin.novērt.'!B33<>\"\",'EE un ilgtsp.fin.novērt.'!B33,\"\")","v":""}]
[null,{"$f":"IF('EE un ilgtsp.fin.novērt.'!B34<>\"\",'EE un ilgtsp.fin.novērt.'!B34,\"\")","v":""}]
[null,{"$f":"IF('EE un ilgtsp.fin.novērt.'!B35<>\"\",'EE un ilgtsp.fin.novērt.'!B35,\"\")","v":""}]