{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Završni račun_raskid","Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Završni račun_raskid","index":0,"n_rows":199,"n_cols":8,"rows_kept":199,"merged":[[0,0,0,7],[1,0,2,7],[3,1,3,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,0,15,5],[16,0,16,7],[17,0,17,2],[17,3,17,7],[18,0,18,1],[18,6,18,7],[19,0,30,1],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[30,6,30,7],[31,0,42,1],[31,6,31,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[36,6,36,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[41,6,41,7],[42,6,42,7],[43,0,54,1],[43,6,43,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[47,6,47,7],[48,6,48,7],[49,6,49,7],[50,6,50,7],[51,6,51,7],[52,6,52,7],[53,6,53,7],[54,6,54,7],[55,0,66,1],[55,6,55,7],[56,6,56,7],[57,6,57,7],[58,6,58,7],[59,6,59,7],[60,6,60,7],[61,6,61,7],[62,6,62,7],[63,6,63,7],[64,6,64,7],[65,6,65,7],[66,6,66,7],[67,0,78,1],[67,6,67,7],[68,6,68,7],[69,6,69,7],[70,6,70,7],[71,6,71,7],[72,6,72,7],[73,6,73,7],[74,6,74,7],[75,6,75,7],[76,6,76,7],[77,6,77,7],[78,6,78,7],[79,0,90,1],[79,6,79,7],[80,6,80,7],[81,6,81,7],[82,6,82,7],[83,6,83,7],[84,6,84,7],[85,6,85,7],[86,6,86,7],[87,6,87,7],[88,6,88,7],[89,6,89,7],[90,6,90,7],[91,0,102,1],[91,6,91,7],[92,6,92,7],[93,6,93,7],[94,6,94,7],[95,6,95,7],[96,6,96,7],[97,6,97,7],[98,6,98,7],[99,6,99,7],[100,6,100,7],[101,6,101,7],[102,6,102,7],[103,0,114,1],[103,6,103,7],[104,6,104,7],[105,6,105,7],[106,6,106,7],[107,6,107,7],[108,6,108,7],[109,6,109,7],[110,6,110,7],[111,6,111,7],[112,6,112,7],[113,6,113,7],[114,6,114,7],[115,0,126,1],[115,6,115,7],[116,6,116,7],[117,6,117,7],[118,6,118,7],[119,6,119,7],[120,6,120,7],[121,6,121,7],[122,6,122,7],[123,6,123,7],[124,6,124,7],[125,6,125,7],[126,6,126,7],[127,0,138,1],[127,6,127,7],[128,6,128,7],[129,6,129,7],[130,6,130,7],[131,6,131,7],[132,6,132,7],[133,6,133,7],[134,6,134,7],[135,6,135,7],[136,6,136,7],[137,6,137,7],[138,6,138,7],[139,0,150,1],[139,6,139,7],[140,6,140,7],[141,6,141,7],[142,6,142,7],[143,6,143,7],[144,6,144,7],[145,6,145,7],[146,6,146,7],[147,6,147,7],[148,6,148,7],[149,6,149,7],[150,6,150,7],[151,0,162,1],[151,6,151,7],[152,6,152,7],[153,6,153,7],[154,6,154,7],[155,6,155,7],[156,6,156,7],[157,6,157,7],[158,6,158,7],[159,6,159,7],[160,6,160,7],[161,6,161,7],[162,6,162,7],[163,0,174,1],[163,6,163,7],[164,6,164,7],[165,6,165,7],[166,6,166,7],[167,6,167,7],[168,6,168,7],[169,6,169,7],[170,6,170,7],[171,6,171,7],[172,6,172,7],[173,6,173,7],[174,6,174,7],[175,0,186,1],[175,6,175,7],[176,6,176,7],[177,6,177,7],[178,6,178,7],[179,6,179,7],[180,6,180,7],[181,6,181,7],[182,6,182,7],[183,6,183,7],[184,6,184,7],[185,6,185,7],[186,6,186,7],[187,0,198,1],[187,6,187,7],[188,6,188,7],[189,6,189,7],[190,6,190,7],[191,6,191,7],[192,6,192,7],[193,6,193,7],[194,6,194,7],[195,6,195,7],[196,6,196,7],[197,6,197,7],[198,6,198,7]]}
["Dodatak 1 Priloga 1 Ugovora"]
["Tablica za Izračun naknade po Završnom računu za energetsku uslugu u slučaju raskida Ugovora uslijed krivnje Korisnika "]
[]
[1," Cijena energetske usluge, (C) ",{"$nulls":5},"EUR"]
[2,"Godišnja naknada za energetsku uslugu u razdoblju ostvarenja ušteda temeljem Zajamčene uštede energije, (Nz) ",{"$nulls":5},"EUR"]
[3,"Naknada za energetsku uslugu do završetka Energetske obnove, (Nen.ob) ",{"$nulls":5},"EUR"]
[4,"Iznos ukupno fakturirane (u trenutku raskida Ugovora) naknade za energetsku uslugu u Razdoblju do završetka Energetske obnove, (Nf) ",{"$nulls":5},"EUR"]
[5,"Koeficijent izvršenja energetske usluge u razdoblju do završetka Energetske obnove, (k)"]
[6,"Razdoblje ostvarenja ušteda, (Rušteda) ",{"$nulls":5},"godina"]
[7,"Broj mjesečnih naknada za energetsku uslugu u Razdoblju ostvarenja ušteda, koje je Pružatelj fakturirao Korisniku do trenutka raskida Ugovora, (f) "]
[8,"Broj preostalih  mjesečnih naknada za energetsku uslugu u Razdoblju ostvarenja ušteda, koje bi Pružatelj imao pravo obračunati Korisniku da nije nastupio raskid Ugovora uslijed krivnje Korisnika, (t) ",{"$nulls":4},{"$f":"G9*12-G10","v":0}]
[9,"Stopa inflacije u mjesecu koji prethodi mjesec-godini u kojem se ispostavlja Završni račun za energetsku uslugu u odnosu na bazni mjesec-godinu kada je dostavljena Ponuda, (s) "]
[10,"Koeficijent za izračun Osnovnog mjesečnog troška Pružatelja tijekom razdoblja ostvarenja ušteda (kos.mj.trošak) ",{"$nulls":4},0.000356]
[11,"Koeficijent mjesečnog rasta mjesečnog troška Pružatelja tijekom razdoblja ostvarenja ušteda, (krmj.rast) ",{"$nulls":4},{"v":1.00124148,"d":"1.001241"}]
[12,"Diskontna stopa, (d)"]
["Iznos nakande (bez pdv-a) po Završnom računu za energetsku uslugu \nu slučaju raskida Ugovora uslijed krivnje Korisnika.  \nDiskontirana vrijednost neostvarenih neto prihoda uslijed raskida  \nUgovora usklađena sa stopom inflacije (Nzavršno) ",{"$nulls":5},{"$f":"IF(OR(G4=\"\",G5=\"\",G6=\"\",G7=\"\",G8=\"\",G9=\"\",G10=\"\",G12=\"\",G15=\"\"),\"\",((1+G12)*((G6*G8-G7)+G8*NPV(G15/12,G20:G199))))","v":""},"EUR"]
["Napomene:\nPotrebno je popuniti (unesti vrijednosti) u zeleno označena polja (stavke 1, 2, 3, 4, 5, 6, 7, 9 i 12), a ostale vrijednosti se automatski izračunavaju. \nSve novčane vrijednosti se upisuju i iskazuju bez pdv-a, u eurima.\nOvom izračunu prilaže se tablica: \"Projekcija neostvarenih mjesečnih prihoda i rashoda Pružatelja u ugovornom Razdoblju ostvarenja ušteda, a koje bi Pružatelj ostvario od trenuka raskida Ugovora do redovnog isteka Ugovora u slučaju da nije nastupio raskid Ugovora uslijed krivnje Korisnika\""]
["Razdoblje \nostvarenja \nušteda",null,null,"Projekcija neostvarenih mjesečnih prihoda i rashoda Pružatelja\n u ugovornom Razdoblju ostvarenja ušteda, a koje bi Pružatelj ostvario od trenuka raskida Ugovora do redovnog isteka Ugovora u slučaju da nije nastupio raskid Ugovora uslijed krivnje Korisnika    "]
["Redni broj godine",null,"Redni broj mjeseca","Redni broj mjeseca (i)","Prihod - mjesečna naknada, bez pdv-a \nNmj(i)","Rashod - mjesečni rashod, bez pdv-a \nTmj(i)","Neto prihod \nPmj(i)"]
[1,null,1,{"$f":"IF(OR(C20=\"\",G$10=\"\"),\"\",IF(C20<=G$10,\"\",C20-G$10))","v":""},{"$f":"IF(OR(D20=\"\",G$5=\"\"),\"\",G$5/12)","v":""},{"$f":"IF(OR(D20=\"\",G$4=\"\",G$13=\"\",G$14=\"\"),\"\",ROUND(G$4*G$13*POWER(G$14,D20),2))","v":""},{"$f":"IF(D20=\"\",\"\",E20-F20)","v":""}]
[null,null,2,{"$f":"IF(OR(C21=\"\",G$10=\"\"),\"\",IF(C21<=G$10,\"\",C21-G$10))","v":""},{"$f":"IF(OR(D21=\"\",G$5=\"\"),\"\",G$5/12)","v":""},"",{"$f":"IF(D21=\"\",\"\",E21-F21)","v":""}]
[null,null,3,"","","",""]
[null,null,4,"","","",""]
[null,null,5,"","","",""]
[null,null,6,"","","",""]
[null,null,7,"","","",""]
[null,null,8,"","","",""]
[null,null,9,"","","",""]
[null,null,10,"","","",""]
[null,null,11,"","","",""]
[null,null,12,"","","",""]
[2,null,13,"","","",""]
[null,null,14,"","","",""]
[null,null,15,"","","",""]
[null,null,16,"","","",""]
[null,null,17,"","","",""]
[null,null,18,"","","",""]
[null,null,19,"","","",""]
[null,null,20,"","","",""]
[null,null,21,"","","",""]
[null,null,22,"","","",""]
[null,null,23,"","","",""]
[null,null,24,"","","",""]
[3,null,25,"","","",""]
[null,null,26,"","","",""]
[null,null,27,"","","",""]
[null,null,28,"","","",""]
[null,null,29,"","","",""]
[null,null,30,"","","",""]
[null,null,31,"","","",""]
[null,null,32,"","","",""]
[null,null,33,"","",{"$f":"IF(OR(D52=\"\",G$4=\"\",G$13=\"\",G$14=\"\"),\"\",ROUND(G$4*G$13*POWER(G$14,D52),2))","v":""},""]
[null,null,34,"","","",""]
[null,null,35,"","","",""]
[null,null,36,"","","",""]
[4,null,37,"","","",""]
[null,null,38,"","","",""]
[null,null,39,"","","",""]
[null,null,40,"","","",""]
[null,null,41,"","","",""]
[null,null,42,"","","",""]
[null,null,43,"","","",""]
[null,null,44,"","","",""]
[null,null,45,"","","",""]
[null,null,46,"","","",""]
[null,null,47,"","","",""]
[null,null,48,"","","",""]
[5,null,49,"","","",""]
[null,null,50,"","","",""]
[null,null,51,"","","",""]
[null,null,52,"","","",""]
[null,null,53,"","","",""]
[null,null,54,"","","",""]
[null,null,55,"","","",""]
[null,null,56,"","","",""]
[null,null,57,"","","",""]
[null,null,58,"","","",""]
[null,null,59,"","","",""]
[null,null,60,"","","",""]
[6,null,61,"","","",""]
[null,null,62,"","","",""]
[null,null,63,"","","",""]
[null,null,64,"","","",""]
[null,null,65,"","",{"$f":"IF(OR(D84=\"\",G$4=\"\",G$13=\"\",G$14=\"\"),\"\",ROUND(G$4*G$13*POWER(G$14,D84),2))","v":""},""]
[null,null,66,{"$f":"IF(OR(C85=\"\",G$10=\"\"),\"\",IF(C85<=G$10,\"\",C85-G$10))","v":""},{"$f":"IF(OR(D85=\"\",G$5=\"\"),\"\",G$5/12)","v":""},"",{"$f":"IF(D85=\"\",\"\",E85-F85)","v":""}]
[null,null,67,"","","",""]
[null,null,68,"","","",""]
[null,null,69,"","","",""]
[null,null,70,"","","",""]
[null,null,71,"","","",""]
[null,null,72,"","","",""]
[7,null,73,"","","",""]
[null,null,74,"","","",""]
[null,null,75,"","","",""]
[null,null,76,"","","",""]
[null,null,77,"","","",""]
[null,null,78,"","","",""]
[null,null,79,"","","",""]
[null,null,80,"","","",""]
[null,null,81,"","","",""]
[null,null,82,"","","",""]
[null,null,83,"","","",""]
[null,null,84,"","","",""]
[8,null,85,"","","",""]
[null,null,86,"","","",""]
[null,null,87,"","","",""]
[null,null,88,"","","",""]
[null,null,89,"","","",""]
[null,null,90,"","","",""]
[null,null,91,"","","",""]
[null,null,92,"","","",""]
[null,null,93,"","","",""]
[null,null,94,"","","",""]
[null,null,95,"","","",""]
[null,null,96,"","","",""]
[{"$f":"IF(G$9=\"\",\"\",IF(G$9>=9,9,\"\"))","v":""},null,{"$f":"IF(A116=\"\",\"\",97)","v":""},"","",{"$f":"IF(OR(D116=\"\",G$4=\"\",G$13=\"\",G$14=\"\"),\"\",ROUND(G$4*G$13*POWER(G$14,D116),2))","v":""},""]
[null,null,{"$f":"IF(C116=\"\",\"\",C116+1)","v":""},"","","",""]
[null,null,{"$f":"IF(C117=\"\",\"\",C117+1)","v":""},"","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[{"$f":"IF(G$9=\"\",\"\",IF(G$9>=10,10,\"\"))","v":""},null,{"$f":"IF(A128=\"\",\"\",109)","v":""},"","","",""]
[null,null,{"$f":"IF(C128=\"\",\"\",C128+1)","v":""},"","","",""]
[null,null,{"$f":"IF(C129=\"\",\"\",C129+1)","v":""},"","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[{"$f":"IF(G$9=\"\",\"\",IF(G$9>=11,11,\"\"))","v":""},null,{"$f":"IF(A140=\"\",\"\",121)","v":""},"","","",""]
[null,null,{"$f":"IF(C140=\"\",\"\",C140+1)","v":""},"","","",""]
[null,null,{"$f":"IF(C141=\"\",\"\",C141+1)","v":""},"","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","",{"$f":"IF(OR(D148=\"\",G$4=\"\",G$13=\"\",G$14=\"\"),\"\",ROUND(G$4*G$13*POWER(G$14,D148),2))","v":""},""]
[null,null,"",{"$f":"IF(OR(C149=\"\",G$10=\"\"),\"\",IF(C149<=G$10,\"\",C149-G$10))","v":""},{"$f":"IF(OR(D149=\"\",G$5=\"\"),\"\",G$5/12)","v":""},"",{"$f":"IF(D149=\"\",\"\",E149-F149)","v":""}]
[null,null,"","","","",""]
[null,null,"","","","",""]
[{"$f":"IF(G$9=\"\",\"\",IF(G$9>=12,12,\"\"))","v":""},null,{"$f":"IF(A152=\"\",\"\",133)","v":""},"","","",""]
[null,null,{"$f":"IF(C152=\"\",\"\",C152+1)","v":""},"","","",""]
[null,null,{"$f":"IF(C153=\"\",\"\",C153+1)","v":""},"","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[{"$f":"IF(G$9=\"\",\"\",IF(G$9>=13,13,\"\"))","v":""},null,{"$f":"IF(A164=\"\",\"\",145)","v":""},"","","",""]
[null,null,{"$f":"IF(C164=\"\",\"\",C164+1)","v":""},"","","",""]
[null,null,{"$f":"IF(C165=\"\",\"\",C165+1)","v":""},"","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[{"$f":"IF(G$9=\"\",\"\",IF(G$9>=14,14,\"\"))","v":""},null,{"$f":"IF(A176=\"\",\"\",157)","v":""},"","","",""]
[null,null,{"$f":"IF(C176=\"\",\"\",C176+1)","v":""},"","","",""]
[null,null,{"$f":"IF(C177=\"\",\"\",C177+1)","v":""},"","","",""]
[null,null,"","","","",""]
[null,null,"","","",{"$f":"IF(OR(D180=\"\",G$4=\"\",G$13=\"\",G$14=\"\"),\"\",ROUND(G$4*G$13*POWER(G$14,D180),2))","v":""},""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[{"$f":"IF(G$9=\"\",\"\",IF(G$9=15,15,\"\"))","v":""},null,{"$f":"IF(A188=\"\",\"\",169)","v":""},"","","",""]
[null,null,{"$f":"IF(C188=\"\",\"\",C188+1)","v":""},"","","",""]
[null,null,{"$f":"IF(C189=\"\",\"\",C189+1)","v":""},"","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]
[null,null,"","","","",""]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}