{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["START","PLANNED EXPENSES","ACTUAL EXPENSES","EXPENSE VARIANCES","EXPENSE ANALYSIS"],"not_rendered":{"charts":3,"images":3,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"START","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"O OVOM PREDLOŠKU"]
[null,"Upotrijebite radnu knjigu Proračun radnih troškova da biste pratili planirane i stvarne troškove i odstupanja."]
[null,"Unesite naziv tvrtke i dodajte logotip."]
[null,"Unesite pojedinosti u tablice na radnom listu Planirani troškovi i Stvarni troškovi."]
[null,"Tablice na radnom listu Odstupanje u troškovima i u grafikonima na radnom listu Analiza troškova automatski se ažuriraju"]
[null,"Napomena: "]
[null,"dodatne su upute navedene u stupcu A na svakom radnom listu. Ovaj je tekst namjerno skriven. Da biste uklonili tekst, odaberite stupac A, a zatim odaberite IZBRIŠI. Da biste otkrili tekst, odaberite stupac A, a zatim promijenite boju fonta."]
[null,"Da biste saznali više o tablicama, pritisnite SHIFT i zatim F10 na tablici pa odaberite mogućnost TABLICA i potom ZAMJENSKI TEKST."]

{"sheet":"PLANNED EXPENSES","index":1,"n_rows":37,"n_cols":18,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[3,17,12,19],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["U tablice na ovom radnom listu unesite planirane troškove zaposlenika, troškove ureda, troškove marketinga i troškove obuke ili putovanja. Ukupni se iznosi automatski izračunavaju. Upute za korištenje ovog radnog lista nalaze se u ćelijama u ovom stupcu. Pomoću tipke sa strelicom prema dolje počnite s radom.",{"$nulls":14}," "]
["U desnu ćeliju unesite naziv tvrtke, a u ćeliju N2 dodajte njezin logotip. Naslov ovog radnog lista nalazi se u ćeliji K2.","Naziv tvrtke",{"$nulls":8},"Detaljne procjene troškova",null,null,"U ovoj se ćeliji nalazi rezervirano mjesto za logotip."]
["Savjet se nalazi u ćeliji K3.",{"$nulls":9},"Osjenčane ćelije predstavljaju izračune."]
["Oznaka planiranih troškova nalazi se u desnoj ćeliji, mjeseci su u ćelijama od C4 do N4, oznaka godine nalazi se u ćeliji O4, a upute za korištenje predloška u ćeliji R4.","PLANIRANI TROŠKOVI","SIJ","VELJ","OŽU","TRA","SVI","LIP","SRP","KOL","RUJ","LIS","STU","PRO","GODINA",null,null,"Savjet: UPUTE ZA KORIŠTENJE PREDLOŠKA\nUnesite podatke u bijele ćelije na radnim listovima PLANIRANI TROŠKOVI i STVARNI TROŠKOVI, a podaci na listovima ODSTUPANJE U TROŠKOVIMA i ANALIZA TROŠKOVA bit će izračunati umjesto vas. Ako dodate redak na jedan list, drugi se listovi moraju podudarati."]
["U tablicu Plan za zaposlenike koja počinje ćelijom zdesna unesite troškove zaposlenika. Sljedeća je uputa u ćeliji A10.","Troškovi zaposlenika","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Plaće",{"v":85000,"d":"85,000.00 kn"},{"v":85000,"d":"85,000.00 kn"},{"v":85000,"d":"85,000.00 kn"},{"v":87500,"d":"87,500.00 kn"},{"v":87500,"d":"87,500.00 kn"},{"v":87500,"d":"87,500.00 kn"},{"v":87500,"d":"87,500.00 kn"},{"v":92400,"d":"92,400.00 kn"},{"v":92400,"d":"92,400.00 kn"},{"v":92400,"d":"92,400.00 kn"},{"v":92400,"d":"92,400.00 kn"},{"v":92400,"d":"92,400.00 kn"},{"$f":"SUM(C6:N6)","v":{"v":1067000,"d":"1,067,000.00 kn"}}]
[null,"Doprinosi",{"$f":"C6*0.27","v":{"v":22950,"d":"22,950.00 kn"}},{"v":22950,"d":"22,950.00 kn"},{"v":22950,"d":"22,950.00 kn"},{"v":23625,"d":"23,625.00 kn"},{"v":23625,"d":"23,625.00 kn"},{"v":23625,"d":"23,625.00 kn"},{"v":23625,"d":"23,625.00 kn"},{"v":24948,"d":"24,948.00 kn"},{"v":24948,"d":"24,948.00 kn"},{"v":24948,"d":"24,948.00 kn"},{"v":24948,"d":"24,948.00 kn"},{"v":24948,"d":"24,948.00 kn"},{"$f":"SUM(C7:N7)","v":{"v":288090,"d":"288,090.00 kn"}}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,EmployeePlan[Sij])","v":{"v":107950,"d":"107,950.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[Velj])","v":{"v":107950,"d":"107,950.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[Ožu])","v":{"v":107950,"d":"107,950.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[Tra])","v":{"v":111125,"d":"111,125.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[Svi])","v":{"v":111125,"d":"111,125.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[Lip])","v":{"v":111125,"d":"111,125.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[Srp])","v":{"v":111125,"d":"111,125.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[Kol])","v":{"v":117348,"d":"117,348.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[Ruj])","v":{"v":117348,"d":"117,348.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[Lis])","v":{"v":117348,"d":"117,348.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[Stu])","v":{"v":117348,"d":"117,348.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[Pro])","v":{"v":117348,"d":"117,348.00 kn"}},{"$f":"SUBTOTAL(109,EmployeePlan[GODINA])","v":{"v":1355090,"d":"1,355,090.00 kn"}}]
[]
["U tablicu Plan za ured koja počinje ćelijom zdesna unesite troškove ureda. Sljedeća je uputa u ćeliji A21.","Troškovi ureda","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Najam ureda",{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"$f":"SUM(C11:N11)","v":{"v":117600,"d":"117,600.00 kn"}}]
[null,"Plin",null,{"v":400,"d":"400.00 kn"},{"v":400,"d":"400.00 kn"},{"v":100,"d":"100.00 kn"},{"v":100,"d":"100.00 kn"},{"v":100,"d":"100.00 kn"},{"v":100,"d":"100.00 kn"},{"v":100,"d":"100.00 kn"},{"v":100,"d":"100.00 kn"},{"v":100,"d":"100.00 kn"},{"v":400,"d":"400.00 kn"},{"v":400,"d":"400.00 kn"},{"v":2300,"d":"2,300.00 kn"}]
[null,"Struja",{"v":300,"d":"300.00 kn"},{"v":300,"d":"300.00 kn"},{"v":300,"d":"300.00 kn"},{"v":300,"d":"300.00 kn"},{"v":300,"d":"300.00 kn"},{"v":300,"d":"300.00 kn"},{"v":300,"d":"300.00 kn"},{"v":300,"d":"300.00 kn"},{"v":300,"d":"300.00 kn"},{"v":300,"d":"300.00 kn"},{"v":300,"d":"300.00 kn"},{"v":300,"d":"300.00 kn"},{"v":3600,"d":"3,600.00 kn"}]
[null,"Voda",{"v":40,"d":"40.00 kn"},{"v":40,"d":"40.00 kn"},{"v":40,"d":"40.00 kn"},{"v":40,"d":"40.00 kn"},{"v":40,"d":"40.00 kn"},{"v":40,"d":"40.00 kn"},{"v":40,"d":"40.00 kn"},{"v":40,"d":"40.00 kn"},{"v":40,"d":"40.00 kn"},{"v":40,"d":"40.00 kn"},{"v":40,"d":"40.00 kn"},{"v":40,"d":"40.00 kn"},{"v":480,"d":"480.00 kn"}]
[null,"Telefon",{"v":250,"d":"250.00 kn"},{"v":250,"d":"250.00 kn"},{"v":250,"d":"250.00 kn"},{"v":250,"d":"250.00 kn"},{"v":250,"d":"250.00 kn"},{"v":250,"d":"250.00 kn"},{"v":250,"d":"250.00 kn"},{"v":250,"d":"250.00 kn"},{"v":250,"d":"250.00 kn"},{"v":250,"d":"250.00 kn"},{"v":250,"d":"250.00 kn"},{"v":250,"d":"250.00 kn"},{"v":3000,"d":"3,000.00 kn"}]
[null,"Pristup internetu",{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":2160,"d":"2,160.00 kn"}]
[null,"Uredski pribor",{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":2400,"d":"2,400.00 kn"}]
[null,"Sigurnost",{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":7200,"d":"7,200.00 kn"}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,OfficePlan[Sij])","v":{"v":11370,"d":"11,370.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[Velj])","v":{"v":11770,"d":"11,770.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[Ožu])","v":{"v":11770,"d":"11,770.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[Tra])","v":{"v":11470,"d":"11,470.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[Svi])","v":{"v":11470,"d":"11,470.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[Lip])","v":{"v":11470,"d":"11,470.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[Srp])","v":{"v":11470,"d":"11,470.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[Kol])","v":{"v":11470,"d":"11,470.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[Ruj])","v":{"v":11470,"d":"11,470.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[Lis])","v":{"v":11470,"d":"11,470.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[Stu])","v":{"v":11770,"d":"11,770.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[Pro])","v":{"v":11770,"d":"11,770.00 kn"}},{"$f":"SUBTOTAL(109,OfficePlan[GODINA])","v":{"v":138740,"d":"138,740.00 kn"}}]
[]
["U tablicu Plan za marketing koja počinje ćelijom zdesna unesite troškove marketinga. Sljedeća je uputa u ćeliji A30.","Troškovi marketinga","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Hostiranje web-mjesta",{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"$f":"SUM(C22:N22)","v":{"v":6000,"d":"6,000.00 kn"}}]
[null,"Ažuriranje web-mjesta",{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":1000,"d":"1,000.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":1000,"d":"1,000.00 kn"},{"v":4000,"d":"4,000.00 kn"}]
[null,"Priprema materijala",{"v":5000,"d":"5,000.00 kn"},{"v":0,"d":"0.00 kn"},{"v":0,"d":"0.00 kn"},{"v":5000,"d":"5,000.00 kn"},{"v":0,"d":"0.00 kn"},{"v":0,"d":"0.00 kn"},{"v":5000,"d":"5,000.00 kn"},{"v":0,"d":"0.00 kn"},{"v":0,"d":"0.00 kn"},{"v":5000,"d":"5,000.00 kn"},{"v":0,"d":"0.00 kn"},{"v":0,"d":"0.00 kn"},{"v":20000,"d":"20,000.00 kn"}]
[null,"Ispis materijala",{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":2400,"d":"2,400.00 kn"}]
[null,"Marketinški događaji",{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":5000,"d":"5,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":5000,"d":"5,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":5000,"d":"5,000.00 kn"},{"v":33000,"d":"33,000.00 kn"}]
[null,"Razni izdaci",{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":2400,"d":"2,400.00 kn"}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,MarketingPlan[Sij])","v":{"v":8100,"d":"8,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[Velj])","v":{"v":3100,"d":"3,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[Ožu])","v":{"v":3100,"d":"3,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[Tra])","v":{"v":11100,"d":"11,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[Svi])","v":{"v":3100,"d":"3,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[Lip])","v":{"v":3900,"d":"3,900.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[Srp])","v":{"v":8100,"d":"8,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[Kol])","v":{"v":6100,"d":"6,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[Ruj])","v":{"v":3100,"d":"3,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[Lis])","v":{"v":8100,"d":"8,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[Stu])","v":{"v":3100,"d":"3,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[Pro])","v":{"v":6900,"d":"6,900.00 kn"}},{"$f":"SUBTOTAL(109,MarketingPlan[GODINA])","v":{"v":67800,"d":"67,800.00 kn"}}]
[]
["U tablicu Plan za obuku i putovanja koja počinje ćelijom zdesna unesite troškove obuke i marketinga. Sljedeća je uputa u ćeliji A35.","Obuka/putovanja","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Obuka",{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"$f":"SUM(C31:N31)","v":{"v":24000,"d":"24,000.00 kn"}}]
[null,"Troškovi putovanja povezanih s obukom",{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"v":2000,"d":"2,000.00 kn"},{"$f":"SUM(C32:N32)","v":{"v":24000,"d":"24,000.00 kn"}}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Sij])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Velj])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Ožu])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Tra])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Svi])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Lip])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Srp])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Kol])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Ruj])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Lis])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Stu])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Pro])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[GODINA])","v":{"v":48000,"d":"48,000.00 kn"}}]
[]
["Ukupni su iznosi automatski izračunati u tablici Planirani zbroj koja počinje ćelijom zdesna.","UKUPNI IZNOSI","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","Godina"]
[null,"Mjesečni planirani troškovi",{"$f":"TrainingAndTravelPlan[[#Totals],[Sij]]+MarketingPlan[[#Totals],[Sij]]+OfficePlan[[#Totals],[Sij]]+EmployeePlan[[#Totals],[Sij]]","v":{"v":131420,"d":"131,420.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Velj]]+MarketingPlan[[#Totals],[Velj]]+OfficePlan[[#Totals],[Velj]]+EmployeePlan[[#Totals],[Velj]]","v":{"v":126820,"d":"126,820.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Ožu]]+MarketingPlan[[#Totals],[Ožu]]+OfficePlan[[#Totals],[Ožu]]+EmployeePlan[[#Totals],[Ožu]]","v":{"v":126820,"d":"126,820.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Tra]]+MarketingPlan[[#Totals],[Tra]]+OfficePlan[[#Totals],[Tra]]+EmployeePlan[[#Totals],[Tra]]","v":{"v":137695,"d":"137,695.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Svi]]+MarketingPlan[[#Totals],[Svi]]+OfficePlan[[#Totals],[Svi]]+EmployeePlan[[#Totals],[Svi]]","v":{"v":129695,"d":"129,695.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Lip]]+MarketingPlan[[#Totals],[Lip]]+OfficePlan[[#Totals],[Lip]]+EmployeePlan[[#Totals],[Lip]]","v":{"v":130495,"d":"130,495.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Srp]]+MarketingPlan[[#Totals],[Srp]]+OfficePlan[[#Totals],[Srp]]+EmployeePlan[[#Totals],[Srp]]","v":{"v":134695,"d":"134,695.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Kol]]+MarketingPlan[[#Totals],[Kol]]+OfficePlan[[#Totals],[Kol]]+EmployeePlan[[#Totals],[Kol]]","v":{"v":138918,"d":"138,918.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Ruj]]+MarketingPlan[[#Totals],[Ruj]]+OfficePlan[[#Totals],[Ruj]]+EmployeePlan[[#Totals],[Ruj]]","v":{"v":135918,"d":"135,918.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Lis]]+MarketingPlan[[#Totals],[Lis]]+OfficePlan[[#Totals],[Lis]]+EmployeePlan[[#Totals],[Lis]]","v":{"v":140918,"d":"140,918.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Stu]]+MarketingPlan[[#Totals],[Stu]]+OfficePlan[[#Totals],[Stu]]+EmployeePlan[[#Totals],[Stu]]","v":{"v":136218,"d":"136,218.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Pro]]+MarketingPlan[[#Totals],[Pro]]+OfficePlan[[#Totals],[Pro]]+EmployeePlan[[#Totals],[Pro]]","v":{"v":140018,"d":"140,018.00 kn"}},{"$f":"TrainingAndTravelPlan[[#Totals],[GODINA]]+MarketingPlan[[#Totals],[GODINA]]+OfficePlan[[#Totals],[GODINA]]+EmployeePlan[[#Totals],[GODINA]]","v":{"v":1609630,"d":"1,609,630.00 kn"}}]
[null,"UKUPNI planirani troškovi",{"$f":"SUM($C$36:C36)","v":{"v":131420,"d":"131,420.00 kn"}},{"$f":"SUM($C$36:D36)","v":{"v":258240,"d":"258,240.00 kn"}},{"$f":"SUM($C$36:E36)","v":{"v":385060,"d":"385,060.00 kn"}},{"$f":"SUM($C$36:F36)","v":{"v":522755,"d":"522,755.00 kn"}},{"$f":"SUM($C$36:G36)","v":{"v":652450,"d":"652,450.00 kn"}},{"$f":"SUM($C$36:H36)","v":{"v":782945,"d":"782,945.00 kn"}},{"$f":"SUM($C$36:I36)","v":{"v":917640,"d":"917,640.00 kn"}},{"$f":"SUM($C$36:J36)","v":{"v":1056558,"d":"1,056,558.00 kn"}},{"$f":"SUM($C$36:K36)","v":{"v":1192476,"d":"1,192,476.00 kn"}},{"$f":"SUM($C$36:L36)","v":{"v":1333394,"d":"1,333,394.00 kn"}},{"$f":"SUM($C$36:M36)","v":{"v":1469612,"d":"1,469,612.00 kn"}},{"$f":"SUM($C$36:N36)","v":{"v":1609630,"d":"1,609,630.00 kn"}}]

{"sheet":"ACTUAL EXPENSES","index":2,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["U tablice na ovom radnom listu unesite stvarne troškove zaposlenika, troškove ureda, troškove marketinga i troškove obuke ili putovanja. Ukupni se iznosi automatski izračunavaju. Upute za korištenje ovog radnog lista nalaze se u ćelijama u ovom stupcu. Pomoću tipke sa strelicom prema dolje počnite s radom.",{"$nulls":14}," "]
["Naziv tvrtke automatski se ažurira u ćeliji zdesna. Naslov ovog radnog lista nalazi se u ćeliji K2. Logotip unesite u ćeliju N2.",{"$f":"'PLANNED EXPENSES'!B2:D3","v":"Naziv tvrtke"},{"$nulls":8},{"$f":"worksheet_title","v":"Detaljne procjene troškova"},null,null,"U ovoj se ćeliji nalazi rezervirano mjesto za logotip."]
["Savjet se nalazi u ćeliji K3.",{"$nulls":9},"Osjenčane ćelije predstavljaju izračune."]
["Oznaka stvarnih troškova nalazi se u ćeliji zdesna, mjeseci su u ćelijama od C4 do N4, dok se oznaka godine nalazi u ćeliji O4.","STVARNI TROŠKOVI","SIJ","VELJ","OŽU","TRA","SVI","LIP","SRP","KOL","RUJ","LIS","STU","PRO","GODINA"]
["U tablicu Stvarni troškovi zaposlenika koja počinje ćelijom zdesna unesite troškove zaposlenika. Sljedeća je uputa u ćeliji A10.","Troškovi zaposlenika","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Plaće",{"v":85000,"d":"85,000.00 kn"},{"v":85000,"d":"85,000.00 kn"},{"v":85000,"d":"85,000.00 kn"},{"v":88000,"d":"88,000.00 kn"},{"v":88000,"d":"88,000.00 kn"},{"v":88000,"d":"88,000.00 kn"},{"$nulls":6},{"$f":"SUM(C6:N6)","v":{"v":519000,"d":"519,000.00 kn"}}]
[null,"Doprinosi",{"$f":"C6*0.27","v":{"v":22950,"d":"22,950.00 kn"}},{"v":22950,"d":"22,950.00 kn"},{"v":22950,"d":"22,950.00 kn"},{"v":23760,"d":"23,760.00 kn"},{"v":23760,"d":"23,760.00 kn"},{"v":23760,"d":"23,760.00 kn"},{"v":0,"d":"0.00 kn"},{"v":0,"d":"0.00 kn"},{"v":0,"d":"0.00 kn"},{"v":0,"d":"0.00 kn"},{"v":0,"d":"0.00 kn"},{"v":0,"d":"0.00 kn"},{"$f":"SUM(C7:N7)","v":{"v":140130,"d":"140,130.00 kn"}}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,EmployeeActual[Sij])","v":{"v":107950,"d":"107,950.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[Velj])","v":{"v":107950,"d":"107,950.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[Ožu])","v":{"v":107950,"d":"107,950.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[Tra])","v":{"v":111760,"d":"111,760.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[Svi])","v":{"v":111760,"d":"111,760.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[Lip])","v":{"v":111760,"d":"111,760.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[Srp])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[Kol])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[Ruj])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[Lis])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[Stu])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[Pro])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeActual[GODINA])","v":{"v":659130,"d":"659,130.00 kn"}}]
[]
["U tablicu Stvarni troškovi ureda koja počinje ćelijom zdesna unesite troškove ureda. Sljedeća je uputa u ćeliji A21.","Troškovi ureda","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Najam ureda",{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"v":9800,"d":"9,800.00 kn"},{"$nulls":6},{"$f":"SUM(C11:N11)","v":{"v":58800,"d":"58,800.00 kn"}}]
[null,"Plin",{"v":4,"d":"4.00 kn"},{"v":430,"d":"430.00 kn"},{"v":385,"d":"385.00 kn"},{"v":230,"d":"230.00 kn"},{"v":87,"d":"87.00 kn"},{"v":88,"d":"88.00 kn"},{"$nulls":6},{"v":1224,"d":"1,224.00 kn"}]
[null,"Struja",{"v":288,"d":"288.00 kn"},{"v":278,"d":"278.00 kn"},{"v":268,"d":"268.00 kn"},{"v":299,"d":"299.00 kn"},{"v":306,"d":"306.00 kn"},{"v":290,"d":"290.00 kn"},{"$nulls":6},{"v":1729,"d":"1,729.00 kn"}]
[null,"Voda",{"v":35,"d":"35.00 kn"},{"v":33,"d":"33.00 kn"},{"v":34,"d":"34.00 kn"},{"v":36,"d":"36.00 kn"},{"v":34,"d":"34.00 kn"},{"v":36,"d":"36.00 kn"},{"$nulls":6},{"v":208,"d":"208.00 kn"}]
[null,"Telefon",{"v":224,"d":"224.00 kn"},{"v":235,"d":"235.00 kn"},{"v":265,"d":"265.00 kn"},{"v":245,"d":"245.00 kn"},{"v":245,"d":"245.00 kn"},{"v":220,"d":"220.00 kn"},{"$nulls":6},{"v":1434,"d":"1,434.00 kn"}]
[null,"Pristup internetu",{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"v":180,"d":"180.00 kn"},{"$nulls":6},{"v":1080,"d":"1,080.00 kn"}]
[null,"Uredski pribor",{"v":256,"d":"256.00 kn"},{"v":142,"d":"142.00 kn"},{"v":160,"d":"160.00 kn"},{"v":221,"d":"221.00 kn"},{"v":256,"d":"256.00 kn"},{"v":240,"d":"240.00 kn"},{"$nulls":6},{"v":1275,"d":"1,275.00 kn"}]
[null,"Sigurnost",{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"v":600,"d":"600.00 kn"},{"$nulls":6},{"v":3600,"d":"3,600.00 kn"}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,OfficeActual[Sij])","v":{"v":11387,"d":"11,387.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[Velj])","v":{"v":11698,"d":"11,698.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[Ožu])","v":{"v":11692,"d":"11,692.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[Tra])","v":{"v":11611,"d":"11,611.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[Svi])","v":{"v":11508,"d":"11,508.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[Lip])","v":{"v":11454,"d":"11,454.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[Srp])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[Kol])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[Ruj])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[Lis])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[Stu])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[Pro])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,OfficeActual[GODINA])","v":{"v":69350,"d":"69,350.00 kn"}}]
[]
["U tablicu Stvarni troškovi marketinga koja počinje ćelijom zdesna unesite troškove marketinga. Sljedeća je uputa u ćeliji A30.","Troškovi marketinga","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Hostiranje web-mjesta",{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"v":500,"d":"500.00 kn"},{"$nulls":6},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"3,000.00 kn"}}]
[null,"Ažuriranje web-mjesta",{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":200,"d":"200.00 kn"},{"v":1500,"d":"1,500.00 kn"},{"$nulls":6},{"v":2500,"d":"2,500.00 kn"}]
[null,"Priprema materijala",{"v":4800,"d":"4,800.00 kn"},{"v":0,"d":"0.00 kn"},{"v":0,"d":"0.00 kn"},{"v":5500,"d":"5,500.00 kn"},{"v":0,"d":"0.00 kn"},{"v":0,"d":"0.00 kn"},{"$nulls":6},{"v":10300,"d":"10,300.00 kn"}]
[null,"Ispis materijala",{"v":100,"d":"100.00 kn"},{"v":500,"d":"500.00 kn"},{"v":100,"d":"100.00 kn"},{"v":100,"d":"100.00 kn"},{"v":600,"d":"600.00 kn"},{"v":180,"d":"180.00 kn"},{"$nulls":6},{"v":1580,"d":"1,580.00 kn"}]
[null,"Marketinški događaji",{"v":1800,"d":"1,800.00 kn"},{"v":2200,"d":"2,200.00 kn"},{"v":2200,"d":"2,200.00 kn"},{"v":4700,"d":"4,700.00 kn"},{"v":1500,"d":"1,500.00 kn"},{"v":2300,"d":"2,300.00 kn"},{"$nulls":6},{"v":14700,"d":"14,700.00 kn"}]
[null,"Razni izdaci",{"v":145,"d":"145.00 kn"},{"v":156,"d":"156.00 kn"},{"v":123,"d":"123.00 kn"},{"v":223,"d":"223.00 kn"},{"v":187,"d":"187.00 kn"},{"v":245,"d":"245.00 kn"},{"$nulls":6},{"v":1079,"d":"1,079.00 kn"}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,MarketingActual[Sij])","v":{"v":7545,"d":"7,545.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[Velj])","v":{"v":3556,"d":"3,556.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[Ožu])","v":{"v":3123,"d":"3,123.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[Tra])","v":{"v":11223,"d":"11,223.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[Svi])","v":{"v":2987,"d":"2,987.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[Lip])","v":{"v":4725,"d":"4,725.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[Srp])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[Kol])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[Ruj])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[Lis])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[Stu])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[Pro])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,MarketingActual[GODINA])","v":{"v":33159,"d":"33,159.00 kn"}}]
[]
["U tablicu Stvarni troškovi obuke i putovanja koja počinje ćelijom zdesna unesite troškove obuke i marketinga. Sljedeća je uputa u ćeliji A35.","Obuka/putovanja","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Obuka",{"v":1600,"d":"1,600.00 kn"},{"v":2400,"d":"2,400.00 kn"},{"v":1400,"d":"1,400.00 kn"},{"v":1600,"d":"1,600.00 kn"},{"v":1200,"d":"1,200.00 kn"},{"v":2800,"d":"2,800.00 kn"},{"$nulls":6},{"$f":"SUM(C31:N31)","v":{"v":11000,"d":"11,000.00 kn"}}]
[null,"Troškovi putovanja povezanih s obukom",{"v":1200,"d":"1,200.00 kn"},{"v":2200,"d":"2,200.00 kn"},{"v":1400,"d":"1,400.00 kn"},{"v":1200,"d":"1,200.00 kn"},{"v":800,"d":"800.00 kn"},{"v":3500,"d":"3,500.00 kn"},{"$nulls":6},{"$f":"SUM(C32:N32)","v":{"v":10300,"d":"10,300.00 kn"}}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Sij])","v":{"v":2800,"d":"2,800.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Velj])","v":{"v":4600,"d":"4,600.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Ožu])","v":{"v":2800,"d":"2,800.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Tra])","v":{"v":2800,"d":"2,800.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Svi])","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Lip])","v":{"v":6300,"d":"6,300.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Srp])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Kol])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Ruj])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Lis])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Stu])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Pro])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[GODINA])","v":{"v":21300,"d":"21,300.00 kn"}}]
[]
["Ukupni su stvarni troškovi automatski izračunati u tablici Ukupni zbroj stvarnih troškova koja počinje ćelijom zdesna.","UKUPNI planirani troškovi","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","Godina"]
[null,"Mjesečni stvarni troškovi",{"$f":"TrainingAndTravelActual[[#Totals],[Sij]]+MarketingActual[[#Totals],[Sij]]+OfficeActual[[#Totals],[Sij]]+EmployeeActual[[#Totals],[Sij]]","v":{"v":129682,"d":"129,682.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[Velj]]+MarketingActual[[#Totals],[Velj]]+OfficeActual[[#Totals],[Velj]]+EmployeeActual[[#Totals],[Velj]]","v":{"v":127804,"d":"127,804.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[Ožu]]+MarketingActual[[#Totals],[Ožu]]+OfficeActual[[#Totals],[Ožu]]+EmployeeActual[[#Totals],[Ožu]]","v":{"v":125565,"d":"125,565.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[Tra]]+MarketingActual[[#Totals],[Tra]]+OfficeActual[[#Totals],[Tra]]+EmployeeActual[[#Totals],[Tra]]","v":{"v":137394,"d":"137,394.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[Svi]]+MarketingActual[[#Totals],[Svi]]+OfficeActual[[#Totals],[Svi]]+EmployeeActual[[#Totals],[Svi]]","v":{"v":128255,"d":"128,255.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[Lip]]+MarketingActual[[#Totals],[Lip]]+OfficeActual[[#Totals],[Lip]]+EmployeeActual[[#Totals],[Lip]]","v":{"v":134239,"d":"134,239.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[Srp]]+MarketingActual[[#Totals],[Srp]]+OfficeActual[[#Totals],[Srp]]+EmployeeActual[[#Totals],[Srp]]","v":{"v":0,"d":"0.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[Kol]]+MarketingActual[[#Totals],[Kol]]+OfficeActual[[#Totals],[Kol]]+EmployeeActual[[#Totals],[Kol]]","v":{"v":0,"d":"0.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[Ruj]]+MarketingActual[[#Totals],[Ruj]]+OfficeActual[[#Totals],[Ruj]]+EmployeeActual[[#Totals],[Ruj]]","v":{"v":0,"d":"0.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[Lis]]+MarketingActual[[#Totals],[Lis]]+OfficeActual[[#Totals],[Lis]]+EmployeeActual[[#Totals],[Lis]]","v":{"v":0,"d":"0.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[Stu]]+MarketingActual[[#Totals],[Stu]]+OfficeActual[[#Totals],[Stu]]+EmployeeActual[[#Totals],[Stu]]","v":{"v":0,"d":"0.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[Pro]]+MarketingActual[[#Totals],[Pro]]+OfficeActual[[#Totals],[Pro]]+EmployeeActual[[#Totals],[Pro]]","v":{"v":0,"d":"0.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[GODINA]]+MarketingActual[[#Totals],[GODINA]]+OfficeActual[[#Totals],[GODINA]]+EmployeeActual[[#Totals],[GODINA]]","v":{"v":782939,"d":"782,939.00 kn"}}]
[null,"UKUPNI stvarni troškovi",{"$f":"SUM($C$36:C36)","v":{"v":129682,"d":"129,682.00 kn"}},{"$f":"SUM($C$36:D36)","v":{"v":257486,"d":"257,486.00 kn"}},{"$f":"SUM($C$36:E36)","v":{"v":383051,"d":"383,051.00 kn"}},{"$f":"SUM($C$36:F36)","v":{"v":520445,"d":"520,445.00 kn"}},{"$f":"SUM($C$36:G36)","v":{"v":648700,"d":"648,700.00 kn"}},{"$f":"SUM($C$36:H36)","v":{"v":782939,"d":"782,939.00 kn"}},{"$f":"SUM($C$36:I36)","v":{"v":782939,"d":"782,939.00 kn"}},{"$f":"SUM($C$36:J36)","v":{"v":782939,"d":"782,939.00 kn"}},{"$f":"SUM($C$36:K36)","v":{"v":782939,"d":"782,939.00 kn"}},{"$f":"SUM($C$36:L36)","v":{"v":782939,"d":"782,939.00 kn"}},{"$f":"SUM($C$36:M36)","v":{"v":782939,"d":"782,939.00 kn"}},{"$f":"SUM($C$36:N36)","v":{"v":782939,"d":"782,939.00 kn"}}]

{"sheet":"EXPENSE VARIANCES","index":3,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["U tablicama na ovom radnom listu automatski se izračunavaju odstupanja u troškovima zaposlenika, troškovima ureda, troškovima marketinga i troškovima obuke ili putovanja. Upute za korištenje ovog radnog lista nalaze se u ćelijama u ovom stupcu. Pomoću tipke sa strelicom prema dolje počnite s radom.",{"$nulls":14}," "]
["Naziv tvrtke automatski se ažurira u ćeliji zdesna. Naslov ovog radnog lista nalazi se u ćeliji K2. Logotip unesite u ćeliju N2.",{"$f":"'PLANNED EXPENSES'!B2:D3","v":"Naziv tvrtke"},{"$nulls":8},{"$f":"worksheet_title","v":"Detaljne procjene troškova"},null,null,"U ovoj se ćeliji nalazi rezervirano mjesto za logotip."]
["Savjet se nalazi u ćeliji K3.",{"$nulls":9},"Osjenčane ćelije predstavljaju izračune."]
["Oznaka odstupanja u troškovima nalazi se u ćeliji zdesna, mjeseci su u ćelijama od C4 do N4, dok se oznaka godine nalazi u ćeliji O4.","ODSTUPANJE U TROŠKOVIMA","SIJ","VELJ","OŽU","TRA","SVI","LIP","SRP","KOL","RUJ","LIS","STU","PRO","GODINA"]
["Odstupanje u troškovima zaposlenika automatski se izračunava u tablici Odstupanja za zaposlenike koja počinje ćelijom zdesna. Sljedeća je uputa u ćeliji A10.","Troškovi zaposlenika","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Plaće",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sij]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sij]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sij]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sij]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Velj]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Velj]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Velj]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Velj]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ožu]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ožu]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ožu]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ožu]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Tra]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Tra]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Tra]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Tra]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"-500.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Svi]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Svi]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Svi]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Svi]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"-500.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lip]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lip]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lip]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lip]],EmployeeActual[#Headers],0))","v":{"v":-500,"d":"-500.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Srp]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Srp]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Srp]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Srp]],EmployeeActual[#Headers],0))","v":{"v":87500,"d":"87,500.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kol]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kol]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kol]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kol]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"92,400.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ruj]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ruj]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ruj]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ruj]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"92,400.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lis]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lis]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lis]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lis]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"92,400.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Stu]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Stu]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Stu]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Stu]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"92,400.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Pro]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Pro]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Pro]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Pro]],EmployeeActual[#Headers],0))","v":{"v":92400,"d":"92,400.00 kn"}},{"$f":"SUM(EmployeeVariances[[#This Row],[Sij]:[Pro]])","v":{"v":548000,"d":"548,000.00 kn"}}]
[null,"Doprinosi",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sij]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sij]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sij]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sij]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Velj]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Velj]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Velj]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Velj]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ožu]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ožu]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ožu]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ožu]],EmployeeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Tra]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Tra]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Tra]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Tra]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"-135.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Svi]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Svi]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Svi]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Svi]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"-135.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lip]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lip]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lip]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lip]],EmployeeActual[#Headers],0))","v":{"v":-135,"d":"-135.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Srp]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Srp]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Srp]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Srp]],EmployeeActual[#Headers],0))","v":{"v":23625,"d":"23,625.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kol]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kol]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Kol]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Kol]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"24,948.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ruj]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ruj]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Ruj]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Ruj]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"24,948.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lis]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lis]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Lis]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Lis]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"24,948.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Stu]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Stu]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Stu]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Stu]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"24,948.00 kn"}},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Pro]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Pro]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Pro]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Pro]],EmployeeActual[#Headers],0))","v":{"v":24948,"d":"24,948.00 kn"}},{"$f":"SUM(EmployeeVariances[[#This Row],[Sij]:[Pro]])","v":{"v":147960,"d":"147,960.00 kn"}}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,EmployeeVariances[Sij])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Velj])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Ožu])","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Tra])","v":{"v":-635,"d":"-635.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Svi])","v":{"v":-635,"d":"-635.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Lip])","v":{"v":-635,"d":"-635.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Srp])","v":{"v":111125,"d":"111,125.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Kol])","v":{"v":117348,"d":"117,348.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Ruj])","v":{"v":117348,"d":"117,348.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Lis])","v":{"v":117348,"d":"117,348.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Stu])","v":{"v":117348,"d":"117,348.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Pro])","v":{"v":117348,"d":"117,348.00 kn"}},{"$f":"SUBTOTAL(109,EmployeeVariances[GODINA])","v":{"v":695960,"d":"695,960.00 kn"}}]
[]
["Odstupanje u troškovima ureda automatski se izračunava u tablici Odstupanja za ured koja počinje ćelijom zdesna. Sljedeća je uputa u ćeliji A21.","Troškovi ureda","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Najam ureda",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficeActual[#Headers],0))","v":{"v":9800,"d":"9,800.00 kn"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sij]:[Pro]])","v":{"v":58800,"d":"58,800.00 kn"}}]
[null,"Plin",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficeActual[#Headers],0))","v":{"v":-4,"d":"-4.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficeActual[#Headers],0))","v":{"v":-30,"d":"-30.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficeActual[#Headers],0))","v":{"v":15,"d":"15.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficeActual[#Headers],0))","v":{"v":-130,"d":"-130.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficeActual[#Headers],0))","v":{"v":13,"d":"13.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficeActual[#Headers],0))","v":{"v":12,"d":"12.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficeActual[#Headers],0))","v":{"v":100,"d":"100.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficeActual[#Headers],0))","v":{"v":100,"d":"100.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficeActual[#Headers],0))","v":{"v":100,"d":"100.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficeActual[#Headers],0))","v":{"v":100,"d":"100.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficeActual[#Headers],0))","v":{"v":400,"d":"400.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficeActual[#Headers],0))","v":{"v":400,"d":"400.00 kn"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sij]:[Pro]])","v":{"v":1076,"d":"1,076.00 kn"}}]
[null,"Struja",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficeActual[#Headers],0))","v":{"v":12,"d":"12.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficeActual[#Headers],0))","v":{"v":22,"d":"22.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficeActual[#Headers],0))","v":{"v":32,"d":"32.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficeActual[#Headers],0))","v":{"v":1,"d":"1.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficeActual[#Headers],0))","v":{"v":-6,"d":"-6.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficeActual[#Headers],0))","v":{"v":10,"d":"10.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficeActual[#Headers],0))","v":{"v":300,"d":"300.00 kn"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sij]:[Pro]])","v":{"v":1871,"d":"1,871.00 kn"}}]
[null,"Voda",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficeActual[#Headers],0))","v":{"v":5,"d":"5.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficeActual[#Headers],0))","v":{"v":7,"d":"7.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficeActual[#Headers],0))","v":{"v":6,"d":"6.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficeActual[#Headers],0))","v":{"v":4,"d":"4.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficeActual[#Headers],0))","v":{"v":6,"d":"6.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficeActual[#Headers],0))","v":{"v":4,"d":"4.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 kn"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sij]:[Pro]])","v":{"v":272,"d":"272.00 kn"}}]
[null,"Telefon",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficeActual[#Headers],0))","v":{"v":26,"d":"26.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficeActual[#Headers],0))","v":{"v":15,"d":"15.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficeActual[#Headers],0))","v":{"v":-15,"d":"-15.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficeActual[#Headers],0))","v":{"v":5,"d":"5.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficeActual[#Headers],0))","v":{"v":5,"d":"5.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficeActual[#Headers],0))","v":{"v":30,"d":"30.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficeActual[#Headers],0))","v":{"v":250,"d":"250.00 kn"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sij]:[Pro]])","v":{"v":1566,"d":"1,566.00 kn"}}]
[null,"Pristup internetu",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficeActual[#Headers],0))","v":{"v":180,"d":"180.00 kn"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sij]:[Pro]])","v":{"v":1080,"d":"1,080.00 kn"}}]
[null,"Uredski pribor",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"-56.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficeActual[#Headers],0))","v":{"v":58,"d":"58.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficeActual[#Headers],0))","v":{"v":40,"d":"40.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficeActual[#Headers],0))","v":{"v":-21,"d":"-21.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficeActual[#Headers],0))","v":{"v":-56,"d":"-56.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficeActual[#Headers],0))","v":{"v":-40,"d":"-40.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficeActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sij]:[Pro]])","v":{"v":1125,"d":"1,125.00 kn"}}]
[null,"Sigurnost",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sij]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sij]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Velj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Velj]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ožu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ožu]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Tra]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Tra]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Svi]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Svi]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lip]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lip]],OfficeActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Srp]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Srp]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Kol]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Kol]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Ruj]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Ruj]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Lis]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Lis]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Stu]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Stu]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 kn"}},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Pro]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Pro]],OfficeActual[#Headers],0))","v":{"v":600,"d":"600.00 kn"}},{"$f":"SUM(OfficeVariances[[#This Row],[Sij]:[Pro]])","v":{"v":3600,"d":"3,600.00 kn"}}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,OfficeVariances[Sij])","v":{"v":-17,"d":"-17.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[Velj])","v":{"v":72,"d":"72.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[Ožu])","v":{"v":78,"d":"78.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[Tra])","v":{"v":-141,"d":"-141.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[Svi])","v":{"v":-38,"d":"-38.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[Lip])","v":{"v":16,"d":"16.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[Srp])","v":{"v":11470,"d":"11,470.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[Kol])","v":{"v":11470,"d":"11,470.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[Ruj])","v":{"v":11470,"d":"11,470.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[Lis])","v":{"v":11470,"d":"11,470.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[Stu])","v":{"v":11770,"d":"11,770.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[Pro])","v":{"v":11770,"d":"11,770.00 kn"}},{"$f":"SUBTOTAL(109,OfficeVariances[GODINA])","v":{"v":69390,"d":"69,390.00 kn"}}]
[]
["Odstupanje u troškovima marketinga automatski se izračunava u tablici Odstupanja za marketing koja počinje ćelijom zdesna. Sljedeća je uputa u ćeliji A30.","Troškovi marketinga","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Hostiranje web-mjesta",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 kn"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sij]:[Pro]])","v":{"v":3000,"d":"3,000.00 kn"}}]
[null,"Ažuriranje web-mjesta",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"-500.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingActual[#Headers],0))","v":{"v":1000,"d":"1,000.00 kn"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sij]:[Pro]])","v":{"v":1500,"d":"1,500.00 kn"}}]
[null,"Priprema materijala",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingActual[#Headers],0))","v":{"v":-500,"d":"-500.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"5,000.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"5,000.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingActual[#Headers],0))","v":{"v":0,"d":"0.00 kn"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sij]:[Pro]])","v":{"v":9700,"d":"9,700.00 kn"}}]
[null,"Ispis materijala",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingActual[#Headers],0))","v":{"v":100,"d":"100.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"-300.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingActual[#Headers],0))","v":{"v":100,"d":"100.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingActual[#Headers],0))","v":{"v":100,"d":"100.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingActual[#Headers],0))","v":{"v":-400,"d":"-400.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingActual[#Headers],0))","v":{"v":20,"d":"20.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sij]:[Pro]])","v":{"v":820,"d":"820.00 kn"}}]
[null,"Marketinški događaji",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"-200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingActual[#Headers],0))","v":{"v":-200,"d":"-200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingActual[#Headers],0))","v":{"v":300,"d":"300.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingActual[#Headers],0))","v":{"v":500,"d":"500.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingActual[#Headers],0))","v":{"v":-300,"d":"-300.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"5,000.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingActual[#Headers],0))","v":{"v":5000,"d":"5,000.00 kn"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sij]:[Pro]])","v":{"v":18300,"d":"18,300.00 kn"}}]
[null,"Razni izdaci",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sij]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sij]],MarketingActual[#Headers],0))","v":{"v":55,"d":"55.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Velj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Velj]],MarketingActual[#Headers],0))","v":{"v":44,"d":"44.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ožu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ožu]],MarketingActual[#Headers],0))","v":{"v":77,"d":"77.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Tra]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Tra]],MarketingActual[#Headers],0))","v":{"v":-23,"d":"-23.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Svi]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Svi]],MarketingActual[#Headers],0))","v":{"v":13,"d":"13.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lip]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lip]],MarketingActual[#Headers],0))","v":{"v":-45,"d":"-45.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Srp]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Srp]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Kol]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Kol]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Ruj]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Ruj]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Lis]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Lis]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Stu]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Stu]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Pro]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Pro]],MarketingActual[#Headers],0))","v":{"v":200,"d":"200.00 kn"}},{"$f":"SUM(MarketingVariances[[#This Row],[Sij]:[Pro]])","v":{"v":1321,"d":"1,321.00 kn"}}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,MarketingVariances[Sij])","v":{"v":555,"d":"555.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[Velj])","v":{"v":-456,"d":"-456.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[Ožu])","v":{"v":-23,"d":"-23.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[Tra])","v":{"v":-123,"d":"-123.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[Svi])","v":{"v":113,"d":"113.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[Lip])","v":{"v":-825,"d":"-825.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[Srp])","v":{"v":8100,"d":"8,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[Kol])","v":{"v":6100,"d":"6,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[Ruj])","v":{"v":3100,"d":"3,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[Lis])","v":{"v":8100,"d":"8,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[Stu])","v":{"v":3100,"d":"3,100.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[Pro])","v":{"v":6900,"d":"6,900.00 kn"}},{"$f":"SUBTOTAL(109,MarketingVariances[GODINA])","v":{"v":34641,"d":"34,641.00 kn"}}]
[]
["Odstupanje u troškovima putovanja ili obuke automatski se izračunava u tablici Odstupanja za obuku i putovanja koja počinje ćelijom zdesna. Sljedeća je uputa u ćeliji A35.","Obuka/putovanja","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","GODINA"]
[null,"Obuka",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sij]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sij]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sij]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sij]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"400.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Velj]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Velj]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Velj]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Velj]],TrainingAndTravelActual[#Headers],0))","v":{"v":-400,"d":"-400.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ožu]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ožu]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ožu]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ožu]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"600.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Tra]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Tra]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Tra]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Tra]],TrainingAndTravelActual[#Headers],0))","v":{"v":400,"d":"400.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Svi]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Svi]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Svi]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Svi]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"800.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lip]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lip]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lip]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lip]],TrainingAndTravelActual[#Headers],0))","v":{"v":-800,"d":"-800.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Srp]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Srp]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Srp]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Srp]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kol]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kol]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kol]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kol]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ruj]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ruj]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ruj]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ruj]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lis]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lis]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lis]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lis]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Stu]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Stu]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Stu]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Stu]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Pro]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Pro]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Pro]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Pro]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[Sij]:[Pro]])","v":{"v":13000,"d":"13,000.00 kn"}}]
[null,"Troškovi putovanja povezanih s obukom",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sij]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sij]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sij]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sij]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"800.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Velj]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Velj]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Velj]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Velj]],TrainingAndTravelActual[#Headers],0))","v":{"v":-200,"d":"-200.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ožu]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ožu]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ožu]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ožu]],TrainingAndTravelActual[#Headers],0))","v":{"v":600,"d":"600.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Tra]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Tra]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Tra]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Tra]],TrainingAndTravelActual[#Headers],0))","v":{"v":800,"d":"800.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Svi]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Svi]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Svi]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Svi]],TrainingAndTravelActual[#Headers],0))","v":{"v":1200,"d":"1,200.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lip]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lip]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lip]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lip]],TrainingAndTravelActual[#Headers],0))","v":{"v":-1500,"d":"-1,500.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Srp]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Srp]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Srp]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Srp]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kol]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kol]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Kol]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Kol]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ruj]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ruj]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Ruj]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Ruj]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lis]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lis]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Lis]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Lis]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Stu]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Stu]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Stu]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Stu]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Pro]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Pro]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Pro]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Pro]],TrainingAndTravelActual[#Headers],0))","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[Sij]:[Pro]])","v":{"v":13700,"d":"13,700.00 kn"}}]
[null,"Podzbroj",{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Sij])","v":{"v":1200,"d":"1,200.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Velj])","v":{"v":-600,"d":"-600.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Ožu])","v":{"v":1200,"d":"1,200.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Tra])","v":{"v":1200,"d":"1,200.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Svi])","v":{"v":2000,"d":"2,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Lip])","v":{"v":-2300,"d":"-2,300.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Srp])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Kol])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Ruj])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Lis])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Stu])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Pro])","v":{"v":4000,"d":"4,000.00 kn"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[GODINA])","v":{"v":26700,"d":"26,700.00 kn"}}]
[]
["Odstupanja u troškovima automatski su izračunata u tablici Ukupna odstupanja koja počinje ćelijom zdesna.","UKUPNI IZNOSI","Sij","Velj","Ožu","Tra","Svi","Lip","Srp","Kol","Ruj","Lis","Stu","Pro","Godina"]
[null,"Mjesečni stvarni troškovi",{"$f":"TrainingAndTravelVariances[[#Totals],[Sij]]+MarketingVariances[[#Totals],[Sij]]+OfficeVariances[[#Totals],[Sij]]+EmployeeVariances[[#Totals],[Sij]]","v":{"v":1738,"d":"1,738.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Velj]]+MarketingVariances[[#Totals],[Velj]]+OfficeVariances[[#Totals],[Velj]]+EmployeeVariances[[#Totals],[Velj]]","v":{"v":-984,"d":"-984.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Ožu]]+MarketingVariances[[#Totals],[Ožu]]+OfficeVariances[[#Totals],[Ožu]]+EmployeeVariances[[#Totals],[Ožu]]","v":{"v":1255,"d":"1,255.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Tra]]+MarketingVariances[[#Totals],[Tra]]+OfficeVariances[[#Totals],[Tra]]+EmployeeVariances[[#Totals],[Tra]]","v":{"v":301,"d":"301.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Svi]]+MarketingVariances[[#Totals],[Svi]]+OfficeVariances[[#Totals],[Svi]]+EmployeeVariances[[#Totals],[Svi]]","v":{"v":1440,"d":"1,440.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Lip]]+MarketingVariances[[#Totals],[Lip]]+OfficeVariances[[#Totals],[Lip]]+EmployeeVariances[[#Totals],[Lip]]","v":{"v":-3744,"d":"-3,744.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Srp]]+MarketingVariances[[#Totals],[Srp]]+OfficeVariances[[#Totals],[Srp]]+EmployeeVariances[[#Totals],[Srp]]","v":{"v":134695,"d":"134,695.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Kol]]+MarketingVariances[[#Totals],[Kol]]+OfficeVariances[[#Totals],[Kol]]+EmployeeVariances[[#Totals],[Kol]]","v":{"v":138918,"d":"138,918.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Ruj]]+MarketingVariances[[#Totals],[Ruj]]+OfficeVariances[[#Totals],[Ruj]]+EmployeeVariances[[#Totals],[Ruj]]","v":{"v":135918,"d":"135,918.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Lis]]+MarketingVariances[[#Totals],[Lis]]+OfficeVariances[[#Totals],[Lis]]+EmployeeVariances[[#Totals],[Lis]]","v":{"v":140918,"d":"140,918.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Stu]]+MarketingVariances[[#Totals],[Stu]]+OfficeVariances[[#Totals],[Stu]]+EmployeeVariances[[#Totals],[Stu]]","v":{"v":136218,"d":"136,218.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Pro]]+MarketingVariances[[#Totals],[Pro]]+OfficeVariances[[#Totals],[Pro]]+EmployeeVariances[[#Totals],[Pro]]","v":{"v":140018,"d":"140,018.00 kn"}},{"$f":"TrainingAndTravelVariances[[#Totals],[GODINA]]+MarketingVariances[[#Totals],[GODINA]]+OfficeVariances[[#Totals],[GODINA]]+EmployeeVariances[[#Totals],[GODINA]]","v":{"v":826691,"d":"826,691.00 kn"}}]
[null,"UKUPNI stvarni troškovi",{"$f":"SUM($C$36:C36)","v":{"v":1738,"d":"1,738.00 kn"}},{"$f":"SUM($C$36:D36)","v":{"v":754,"d":"754.00 kn"}},{"$f":"SUM($C$36:E36)","v":{"v":2009,"d":"2,009.00 kn"}},{"$f":"SUM($C$36:F36)","v":{"v":2310,"d":"2,310.00 kn"}},{"$f":"SUM($C$36:G36)","v":{"v":3750,"d":"3,750.00 kn"}},{"$f":"SUM($C$36:H36)","v":{"v":6,"d":"6.00 kn"}},{"$f":"SUM($C$36:I36)","v":{"v":134701,"d":"134,701.00 kn"}},{"$f":"SUM($C$36:J36)","v":{"v":273619,"d":"273,619.00 kn"}},{"$f":"SUM($C$36:K36)","v":{"v":409537,"d":"409,537.00 kn"}},{"$f":"SUM($C$36:L36)","v":{"v":550455,"d":"550,455.00 kn"}},{"$f":"SUM($C$36:M36)","v":{"v":686673,"d":"686,673.00 kn"}},{"$f":"SUM($C$36:N36)","v":{"v":826691,"d":"826,691.00 kn"}}]

{"sheet":"EXPENSE ANALYSIS","index":4,"n_rows":14,"n_cols":16,"rows_kept":14,"merged":[[1,1,2,3],[1,5,1,6],[2,4,2,6],[11,1,11,2],[11,3,11,5],[13,1,36,5]]}
["Godišnji planirani i stvarni troškovi, odstupanja u troškovima i postotak odstupanja automatski se ažuriraju za svaku kategoriju troškova na ovom radnom listu. Upute za korištenje ovog radnog lista nalaze se u ćelijama u ovom stupcu. Pomoću tipke sa strelicom prema dolje počnite s radom. ",{"$nulls":5}," ",{"$nulls":8}," "]
["Naziv tvrtke automatski se ažurira u ćeliji zdesna. Logotip unesite u ćeliju F2.",{"$f":"'PLANNED EXPENSES'!B2:D3","v":"Naziv tvrtke"},{"$nulls":3},"U ovoj se ćeliji nalazi rezervirano mjesto za logotip."]
["Naslov ovog radnog lista nalazi se u ćeliji E3. Sljedeća je uputa u ćeliji A5.",{"$nulls":3},{"$f":"worksheet_title","v":"Detaljne procjene troškova"}]
[]
["Planirani troškovi, stvarni troškovi, odstupanja u troškovima i postotak odstupanja automatski se izračunavaju u tablici Analiza koja započinje ćelijom zdesna. Sljedeća je uputa u ćeliji A12.","Kategorije troškova","Planirani troškovi","Stvarni troškovi","Odstupanje u troškovima","Postotak odstupanja"]
[null,"Troškovi zaposlenika",{"$f":"EmployeePlan[[#Totals],[GODINA]]","v":{"v":1355090,"d":"1,355,090.00 kn"}},{"$f":"EmployeeActual[[#Totals],[GODINA]]","v":{"v":659130,"d":"659,130.00 kn"}},{"$f":"C6-D6","v":{"v":695960,"d":"695,960.00 kn"}},{"$f":"E6/C6","v":{"v":0.5135895032802249,"d":"51%"}}]
[null,{"$f":"'PLANNED EXPENSES'!B10","v":"Troškovi ureda"},{"$f":"OfficePlan[[#Totals],[GODINA]]","v":{"v":138740,"d":"138,740.00 kn"}},{"$f":"OfficeActual[[#Totals],[GODINA]]","v":{"v":69350,"d":"69,350.00 kn"}},{"$f":"C7-D7","v":{"v":69390,"d":"69,390.00 kn"}},{"$f":"E7/C7","v":{"v":0.5001441545336601,"d":"50%"}}]
[null,{"$f":"'PLANNED EXPENSES'!B21","v":"Troškovi marketinga"},{"$f":"MarketingPlan[[#Totals],[GODINA]]","v":{"v":67800,"d":"67,800.00 kn"}},{"$f":"MarketingActual[[#Totals],[GODINA]]","v":{"v":33159,"d":"33,159.00 kn"}},{"$f":"C8-D8","v":{"v":34641,"d":"34,641.00 kn"}},{"$f":"E8/C8","v":{"v":0.510929203539823,"d":"51%"}}]
[null,{"$f":"'PLANNED EXPENSES'!B30","v":"Obuka/putovanja"},{"$f":"TrainingAndTravelPlan[[#Totals],[GODINA]]","v":{"v":48000,"d":"48,000.00 kn"}},{"$f":"TrainingAndTravelActual[[#Totals],[GODINA]]","v":{"v":21300,"d":"21,300.00 kn"}},{"$f":"C9-D9","v":{"v":26700,"d":"26,700.00 kn"}},{"$f":"E9/C9","v":{"v":0.55625,"d":"56%"}}]
[null,{"$f":"'PLANNED EXPENSES'!B35","v":"UKUPNI IZNOSI"},{"$f":"'PLANNED EXPENSES'!O36","v":{"v":1609630,"d":"1,609,630.00 kn"}},{"$f":"'ACTUAL EXPENSES'!O36","v":{"v":782939,"d":"782,939.00 kn"}},{"$f":"C10-D10","v":{"v":826691,"d":"826,691.00 kn"}},{"$f":"E10/C10","v":{"v":0.5135907009685455,"d":"51%"}}]
[]
["Tortni grafikon planiranih troškova nalazi se u ćeliji zdesna, dok se tortni grafikon stvarnih troškova nalazi u ćeliji D12. Sljedeća je uputa u ćeliji A14.","Tortni grafikon koji prikazuje planirane troškove za različite kategorije nalazi se u ovoj ćeliji.",null,"Tortni grafikon koji prikazuje stvarne troškove za različite kategorije nalazi se u ovoj ćeliji."]
[]
["Grafikon koji prikazuje planirane i stvarne troškove i odstupanja u mjesečnim troškovima nalazi se u ćeliji zdesna."]