{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1-2016  ","2-2016   ","3-2016 "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1-2016  ","index":0,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,6,4,6],[3,7,3,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[0,12,2,13],[0,17,0,18],[0,22,1,22],[0,23,1,23],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[0,0,1,0],[0,1,1,1],[0,2,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6]]}
["Vozač","Slobodan","BH1954563DE",null,"Mjesec",1,2016,null,null,null,null,null,{"$f":"X5","v":22.805555555555557},null,null,null,null,null,null,null,null,null,32,"Unos maksimalne potrošnje lit/100"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prosjek","Prosjek","Prosjek"]
["SALDO:",{"$f":"IF(C4-D4-E4-F4-G4,C4-D4-E4-F4-G4,\"0.00\")","v":"0.00"},{"$f":"SUM(C7:C37)","v":0},{"$f":"SUM(D7:D37)","v":0},{"$f":"SUM(E7:E37)","v":0},{"$f":"SUM(F7:F37)","v":0},{"$f":"SUM(G7:G37)","v":0},"CENA PREVOZA",null,null,"Ukupno goriva",{"$f":"SUM(K7:K37)","v":200},"Ukupno pređeno kilometara",{"$f":"SUM(N7:N37)","v":1100},{"$f":"L4*100/N4","v":18.181818181818183},{"$f":"AVERAGEIF(P7:P37, \"<>0\")","v":11},{"$f":"AVERAGEIF(Q7:Q37, \"<>0\")","v":3.5},null,null,null,"Pros. obe ture tonaza","Unos optim.potrosnje","Kooficijent po toni","Ukupn.Prosjek potrošnje lit/100","Valuta EUR"]
[null,null,null,null,null,null,null,{"$f":"SUM(H7:H37)","v":0},{"$f":"SUM(I7:I37)","v":0},{"$f":"SUM(J7:J37)","v":0},null,null,null,null,null,null,null,null,0.1,null,{"$f":"AVERAGE(P4,Q4)","v":7.25},22,5.0000000000000001E-3,{"$f":"AVERAGE(Y7:Y15)","v":22.805555555555557},1.95583]
["Datum","Vrsta prihoda-rashoda","PRIHOD","RASHOD KM","Nagrade","Prekovrem.rad","Plata","EUR","KM","Ukupno KM","Količina Lit","Početno stanje Km","Završno stanje Km","Ukupno Km","Lit/100","Tonaza u polasku","Tonaza u povratku",null,"lit/100","%","Osnova za platu","Gorivi po toni/polazak","Gorivi po toni/povratak","Prosjek za obracun","Gorivi pol/pov   po turi"]
[null,null,null,null,null,null,null,null,null,{"$f":"H7*Y5+I7","v":0},200,100,1200,{"$f":"M7-L7","v":1100},{"$f":"IFERROR(K7*100/N7,\" \")","v":18.181818181818183},10,3,null,"28.00",0.14000000000000001,{"$f":"J7*S5","v":0},{"$f":"P7*W5*100","v":5},{"$f":"Q7*W5*100","v":1.5},{"$f":"AVERAGE(V7,W7)","v":3.25},{"$f":"V5+X7","v":25.25}]
[null,null,null,null,null,null,null,null,null,{"$f":"H8*Y5+I8","v":0},null,null,null,{"$f":"M8-L8","v":0}," ",12,4,null,"28.50","13.50%",{"$f":"J8*S5","v":0},{"$f":"P8*W5*100","v":6},{"$f":"Q8*W5*100","v":2},{"$f":"AVERAGE(V8,W8)","v":4},{"$f":"V5+X8","v":26}]
[null,null,null,null,null,null,null,null,null,{"$f":"H9*Y5+I9","v":0},null,null,null,{"$f":"M9-L9","v":0}," ",null,null,null,29,0.13,null,{"$f":"P9*W5*100","v":0},{"$f":"Q9*W5*100","v":0},{"$f":"AVERAGE(V9,W9)","v":0},{"$f":"V5+X9","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H10*Y5+I10","v":0},null,null,null,0," ",null,null,null,"29.50","12.20%",null,{"$f":"P10*W5*100","v":0},{"$f":"Q10*W5*100","v":0},{"$f":"AVERAGE(V10,W10)","v":0},{"$f":"V5+X10","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H11*Y5+I11","v":0},null,null,null,0," ",null,null,null,30,"11.8%",null,{"$f":"P11*W5*100","v":0},{"$f":"Q11*W5*100","v":0},0,{"$f":"V5+X11","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H12*Y5+I12","v":0},null,null,null,0," ",null,null,null,31,"11.3%",null,{"$f":"P12*W5*100","v":0},{"$f":"Q12*W5*100","v":0},0,{"$f":"V5+X12","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H13*Y5+I13","v":0},null,null,null,0," ",null,null,null,"31.50",0.11,null,{"$f":"P13*W5*100","v":0},{"$f":"Q13*W5*100","v":0},0,{"$f":"V5+X13","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H14*Y5+I14","v":0},null,null,null,0," ",null,null,null,32,"10.80%",null,{"$f":"P14*W5*100","v":0},{"$f":"Q14*W5*100","v":0},0,{"$f":"V5+X14","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H15*Y5+I15","v":0},null,null,null,0," ",null,null,null,"32.50","10.30%",null,{"$f":"P15*W5*100","v":0},{"$f":"Q15*W5*100","v":0},0,{"$f":"V5+X15","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H16*Y5+I16","v":0},null,null,null,0," ",null,null,null,33,"10.20%",null,{"$f":"P16*W5*100","v":0},{"$f":"Q16*W5*100","v":0},0,{"$f":"V5+X16","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H17*Y5+I17","v":0},null,null,null,0," ",null,null,null,"33.50",0.1,null,{"$f":"P17*W5*100","v":0},{"$f":"Q17*W5*100","v":0},0,{"$f":"V5+X17","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H18*Y5+I18","v":0},null,null,null,0," ",null,null,null,34,"9.80%",null,{"$f":"P18*W5*100","v":0},{"$f":"Q18*W5*100","v":0},0,{"$f":"V5+X18","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H19*Y5+I19","v":0},null,null,null,0," ",null,null,null,"34.50","9.60%",null,{"$f":"P19*W5*100","v":0},{"$f":"Q19*W5*100","v":0},0,{"$f":"V5+X19","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H20*Y5+I20","v":0},null,null,null,0," ",null,null,null,35,"9.30%",null,{"$f":"P20*W5*100","v":0},{"$f":"Q20*W5*100","v":0},0,{"$f":"V5+X20","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H21*Y5+I21","v":0},null,null,null,0," ",null,null,null,"35.50","9.00%",null,{"$f":"P21*W5*100","v":0},{"$f":"Q21*W55*100","v":0},0,{"$f":"V5+X21","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H22*Y5+I22","v":0},null,null,null,0," ",null,null,null,36,"8.50%",null,{"$f":"P22*W5*100","v":0},{"$f":"Q22*W5*100","v":0},0,{"$f":"V5+X22","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H23*Y5+I23","v":0},null,null,null,0," ",null,null,null,"36.50",0.08,null,{"$f":"P23*W5*100","v":0},{"$f":"Q23*W5*100","v":0},0,{"$f":"V5+X23","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H24*Y5+I24","v":0},null,null,null,0," ",null,null,null,37,"7.50%",null,{"$f":"P24*W5*100","v":0},{"$f":"Q24*W5*100","v":0},0,{"$f":"V5+X24","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H25*Y5+I25","v":0},null,null,null,0," ",null,null,null,38,"7.00%",null,{"$f":"P25*W5*100","v":0},{"$f":"Q25*W5*100","v":0},0,{"$f":"V5+X25","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H26*Y5+I26","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P26*W5*100","v":0},{"$f":"Q26*W5*100","v":0},0,{"$f":"V5+X26","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H27*Y5+I27","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P27*W5*100","v":0},{"$f":"Q27*W5*100","v":0},0,{"$f":"V5+X27","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H28*Y5+I28","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P28*W5*100","v":0},{"$f":"Q28*W5*100","v":0},0,{"$f":"V5+X28","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H29*Y5+I29","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P29*W5*100","v":0},{"$f":"Q29*W5*100","v":0},0,{"$f":"V5+X29","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H30*Y5+I30","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P30*W5*100","v":0},{"$f":"Q30*W5*100","v":0},0,{"$f":"V5+X30","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H31*Y5+I31","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P31*W5*100","v":0},{"$f":"Q31*W5*100","v":0},0,{"$f":"V5+X31","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H32*Y5+I32","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P32*W5*100","v":0},{"$f":"Q32*W5*100","v":0},0,{"$f":"V5+X32","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H33*Y5+I33","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P33*W5*100","v":0},{"$f":"Q33*W5*100","v":0},0,{"$f":"V5+X33","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H34*Y5+I34","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P34*W5*100","v":0},{"$f":"Q34*W5*100","v":0},0,{"$f":"V5+X34","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H35*Y5+I35","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P35*W5*100","v":0},{"$f":"Q35*W5*100","v":0},0,{"$f":"V5+X35","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H36*Y5+I36","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P36*W5*100","v":0},{"$f":"Q36*W5*100","v":0},0,{"$f":"V5+X36","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H37*Y5+I37","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P37*W5*100","v":0},{"$f":"Q37*W5*100","v":0},0,{"$f":"V5+X37","v":22}]

{"sheet":"2-2016   ","index":1,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,6,4,6],[3,7,3,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[0,12,2,13],[0,17,0,18],[0,22,1,22],[0,23,1,23],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[0,0,1,0],[0,1,1,1],[0,2,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6]]}
["Vozač","Slobodan","BH1954563DE",null,"Mjesec",2,2016,null,null,null,null,null,{"$f":"X5","v":22.805555555555557},null,null,null,null,null,null,null,null,null,32,"Unos maksimalne potrošnje lit/100"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prosjek","Prosjek","Prosjek"]
["SALDO:",{"$f":"IF(C4-D4-E4-F4-G4,C4-D4-E4-F4-G4,\"0.00\")","v":"0.00"},{"$f":"SUM(C7:C37)","v":0},{"$f":"SUM(D7:D37)","v":0},{"$f":"SUM(E7:E37)","v":0},{"$f":"SUM(F7:F37)","v":0},{"$f":"SUM(G7:G37)","v":0},"CENA PREVOZA",null,null,"Ukupno goriva",{"$f":"SUM(K7:K37)","v":200},"Ukupno pređeno kilometara",{"$f":"SUM(N7:N37)","v":1100},{"$f":"L4*100/N4","v":18.181818181818183},{"$f":"AVERAGEIF(P7:P37, \"<>0\")","v":11},{"$f":"AVERAGEIF(Q7:Q37, \"<>0\")","v":3.5},null,null,null,"Pros. obe ture tonaza","Unos optim.potrosnje","Kooficijent po toni","Ukupn.Prosjek potrošnje lit/100","Valuta EUR"]
[null,null,null,null,null,null,null,{"$f":"SUM(H7:H37)","v":0},{"$f":"SUM(I7:I37)","v":0},{"$f":"SUM(J7:J37)","v":0},null,null,null,null,null,null,null,null,0.1,null,{"$f":"AVERAGE(P4,Q4)","v":7.25},22,5.0000000000000001E-3,{"$f":"AVERAGE(Y7:Y15)","v":22.805555555555557},1.95583]
["Datum","Vrsta prihoda-rashoda","PRIHOD","RASHOD KM","Nagrade","Prekovrem.rad","Plata","EUR","KM","Ukupno KM","Količina Lit","Početno stanje Km","Završno stanje Km","Ukupno Km","Lit/100","Tonaza u polasku","Tonaza u povratku",null,"lit/100","%","Osnova za platu","Gorivi po toni/polazak","Gorivi po toni/povratak","Prosjek za obracun","Gorivi pol/pov   po turi"]
[null,null,null,null,null,null,null,null,null,{"$f":"H7*Y5+I7","v":0},200,100,1200,{"$f":"M7-L7","v":1100},{"$f":"IFERROR(K7*100/N7,\" \")","v":18.181818181818183},10,3,null,"28.00",0.14000000000000001,{"$f":"J7*S5","v":0},{"$f":"P7*W5*100","v":5},{"$f":"Q7*W5*100","v":1.5},{"$f":"AVERAGE(V7,W7)","v":3.25},{"$f":"V5+X7","v":25.25}]
[null,null,null,null,null,null,null,null,null,{"$f":"H8*Y5+I8","v":0},null,null,null,{"$f":"M8-L8","v":0}," ",12,4,null,"28.50","13.50%",{"$f":"J8*S5","v":0},{"$f":"P8*W5*100","v":6},{"$f":"Q8*W5*100","v":2},{"$f":"AVERAGE(V8,W8)","v":4},{"$f":"V5+X8","v":26}]
[null,null,null,null,null,null,null,null,null,{"$f":"H9*Y5+I9","v":0},null,null,null,{"$f":"M9-L9","v":0}," ",null,null,null,29,0.13,null,{"$f":"P9*W5*100","v":0},{"$f":"Q9*W5*100","v":0},{"$f":"AVERAGE(V9,W9)","v":0},{"$f":"V5+X9","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H10*Y5+I10","v":0},null,null,null,0," ",null,null,null,"29.50","12.20%",null,{"$f":"P10*W5*100","v":0},{"$f":"Q10*W5*100","v":0},{"$f":"AVERAGE(V10,W10)","v":0},{"$f":"V5+X10","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H11*Y5+I11","v":0},null,null,null,0," ",null,null,null,30,"11.8%",null,{"$f":"P11*W5*100","v":0},{"$f":"Q11*W5*100","v":0},0,{"$f":"V5+X11","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H12*Y5+I12","v":0},null,null,null,0," ",null,null,null,31,"11.3%",null,{"$f":"P12*W5*100","v":0},{"$f":"Q12*W5*100","v":0},0,{"$f":"V5+X12","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H13*Y5+I13","v":0},null,null,null,0," ",null,null,null,"31.50",0.11,null,{"$f":"P13*W5*100","v":0},{"$f":"Q13*W5*100","v":0},0,{"$f":"V5+X13","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H14*Y5+I14","v":0},null,null,null,0," ",null,null,null,32,"10.80%",null,{"$f":"P14*W5*100","v":0},{"$f":"Q14*W5*100","v":0},0,{"$f":"V5+X14","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H15*Y5+I15","v":0},null,null,null,0," ",null,null,null,"32.50","10.30%",null,{"$f":"P15*W5*100","v":0},{"$f":"Q15*W5*100","v":0},0,{"$f":"V5+X15","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H16*Y5+I16","v":0},null,null,null,0," ",null,null,null,33,"10.20%",null,{"$f":"P16*W5*100","v":0},{"$f":"Q16*W5*100","v":0},0,{"$f":"V5+X16","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H17*Y5+I17","v":0},null,null,null,0," ",null,null,null,"33.50",0.1,null,{"$f":"P17*W5*100","v":0},{"$f":"Q17*W5*100","v":0},0,{"$f":"V5+X17","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H18*Y5+I18","v":0},null,null,null,0," ",null,null,null,34,"9.80%",null,{"$f":"P18*W5*100","v":0},{"$f":"Q18*W5*100","v":0},0,{"$f":"V5+X18","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H19*Y5+I19","v":0},null,null,null,0," ",null,null,null,"34.50","9.60%",null,{"$f":"P19*W5*100","v":0},{"$f":"Q19*W5*100","v":0},0,{"$f":"V5+X19","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H20*Y5+I20","v":0},null,null,null,0," ",null,null,null,35,"9.30%",null,{"$f":"P20*W5*100","v":0},{"$f":"Q20*W5*100","v":0},0,{"$f":"V5+X20","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H21*Y5+I21","v":0},null,null,null,0," ",null,null,null,"35.50","9.00%",null,{"$f":"P21*W5*100","v":0},{"$f":"Q21*W55*100","v":0},0,{"$f":"V5+X21","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H22*Y5+I22","v":0},null,null,null,0," ",null,null,null,36,"8.50%",null,{"$f":"P22*W5*100","v":0},{"$f":"Q22*W5*100","v":0},0,{"$f":"V5+X22","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H23*Y5+I23","v":0},null,null,null,0," ",null,null,null,"36.50",0.08,null,{"$f":"P23*W5*100","v":0},{"$f":"Q23*W5*100","v":0},0,{"$f":"V5+X23","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H24*Y5+I24","v":0},null,null,null,0," ",null,null,null,37,"7.50%",null,{"$f":"P24*W5*100","v":0},{"$f":"Q24*W5*100","v":0},0,{"$f":"V5+X24","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H25*Y5+I25","v":0},null,null,null,0," ",null,null,null,38,"7.00%",null,{"$f":"P25*W5*100","v":0},{"$f":"Q25*W5*100","v":0},0,{"$f":"V5+X25","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H26*Y5+I26","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P26*W5*100","v":0},{"$f":"Q26*W5*100","v":0},0,{"$f":"V5+X26","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H27*Y5+I27","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P27*W5*100","v":0},{"$f":"Q27*W5*100","v":0},0,{"$f":"V5+X27","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H28*Y5+I28","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P28*W5*100","v":0},{"$f":"Q28*W5*100","v":0},0,{"$f":"V5+X28","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H29*Y5+I29","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P29*W5*100","v":0},{"$f":"Q29*W5*100","v":0},0,{"$f":"V5+X29","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H30*Y5+I30","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P30*W5*100","v":0},{"$f":"Q30*W5*100","v":0},0,{"$f":"V5+X30","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H31*Y5+I31","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P31*W5*100","v":0},{"$f":"Q31*W5*100","v":0},0,{"$f":"V5+X31","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H32*Y5+I32","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P32*W5*100","v":0},{"$f":"Q32*W5*100","v":0},0,{"$f":"V5+X32","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H33*Y5+I33","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P33*W5*100","v":0},{"$f":"Q33*W5*100","v":0},0,{"$f":"V5+X33","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H34*Y5+I34","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P34*W5*100","v":0},{"$f":"Q34*W5*100","v":0},0,{"$f":"V5+X34","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H35*Y5+I35","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P35*W5*100","v":0},{"$f":"Q35*W5*100","v":0},0,{"$f":"V5+X35","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H36*Y5+I36","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P36*W5*100","v":0},{"$f":"Q36*W5*100","v":0},0,{"$f":"V5+X36","v":22}]
[null,null,null,null,null,null,null,null,null,{"$f":"H37*Y5+I37","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"P37*W5*100","v":0},{"$f":"Q37*W5*100","v":0},0,{"$f":"V5+X37","v":22}]

{"sheet":"3-2016 ","index":2,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,8,4,8],[3,9,4,9],[0,17,1,17],[3,4,4,4],[3,5,4,5],[0,16,1,16],[0,11,0,12],[3,10,4,10],[0,0,1,0],[0,6,2,7],[3,0,4,0],[3,6,4,6],[3,7,4,7],[3,1,3,3]]}
[2016,null,null,null,null,null,{"$f":"R5","v":22.361111111111111},null,null,null,null,null,null,null,null,null,32,"Unos maksimalne potrošnje lit/100"]
[]
[null,null,null,null,null,null,null,null,"Prosjek","Prosjek","Prosjek"]
[null,"CENA PREVOZA",null,null,"Ukupno goriva",{"$f":"SUM(E7:E37)","v":300},"Ukupno pređeno kilometara",{"$f":"SUM(H7:H37)","v":1200},{"$f":"F4*100/H4","v":25},{"$f":"AVERAGEIF(J7:J37, \"<>0\")","v":10},{"$f":"AVERAGEIF(K7:K37, \"<>0\")","v":3},null,null,null,"Pros. obe ture tonaza","Unos optim.potrosnje","Kooficijent po toni","Ukupn.Prosjek potrošnje lit/100","Valuta EUR"]
[null,{"$f":"SUM(B7:B37)","v":300},{"$f":"SUM(C7:C37)","v":200},{"$f":"SUM(D7:D37)","v":786.74900000000002},null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(J4,K4)","v":6.5},22,5.0000000000000001E-3,{"$f":"AVERAGE(S7:S15)","v":22.361111111111111},1.95583]
["Plata","EUR","KM","Ukupno KM","Količina Lit","Početno stanje Km","Završno stanje Km","Ukupno Km","Lit/100","Tonaza u polasku","Tonaza u povratku",null,"lit/100","%","Osnova za platu","Gorivi po toni/polazak","Gorivi po toni/povratak","Prosjek za obracun","Gorivi pol/pov   po turi"]
[null,300,200,{"$f":"B7*S5+C7","v":786.74900000000002},300,100,1300,{"$f":"G7-F7","v":1200},{"$f":"IFERROR(E7*100/H7,\" \")","v":25},10,3,{"$f":"VLOOKUP($I7,$M$7:$N$25,2,TRUE)","v":14},0,14,{"$f":"D7*M5","v":0},{"$f":"J7*Q5*100","v":5},{"$f":"K7*Q5*100","v":1.5},{"$f":"AVERAGE(P7,Q7)","v":3.25},{"$f":"P5+R7","v":25.25}]
[null,null,null,{"$f":"B8*S5+C8","v":0},null,null,null,{"$f":"G8-F8","v":0}," ",null,null,null,28,13.5,{"$f":"D8*M5","v":0},{"$f":"J8*Q5*100","v":0},{"$f":"K8*Q5*100","v":0},{"$f":"AVERAGE(P8,Q8)","v":0},{"$f":"P5+R8","v":22}]
[null,null,null,{"$f":"B9*S5+C9","v":0},null,null,null,{"$f":"G9-F9","v":0}," ",null,null,null,28.5,13,null,{"$f":"J9*Q5*100","v":0},{"$f":"K9*Q5*100","v":0},{"$f":"AVERAGE(P9,Q9)","v":0},{"$f":"P5+R9","v":22}]
[null,null,null,{"$f":"B10*S5+C10","v":0},null,null,null,0," ",null,null,null,29,12.2,null,{"$f":"J10*Q5*100","v":0},{"$f":"K10*Q5*100","v":0},{"$f":"AVERAGE(P10,Q10)","v":0},{"$f":"P5+R10","v":22}]
[null,null,null,{"$f":"B11*S5+C11","v":0},null,null,null,0," ",null,null,null,29.5,11.8,null,{"$f":"J11*Q5*100","v":0},{"$f":"K11*Q5*100","v":0},0,{"$f":"P5+R11","v":22}]
[null,null,null,{"$f":"B12*S5+C12","v":0},null,null,null,0," ",null,null,null,30,11.3,null,{"$f":"J12*Q5*100","v":0},{"$f":"K12*Q5*100","v":0},{"$f":"AVERAGE(P12,Q12)","v":0},{"$f":"P5+R12","v":22}]
[null,null,null,{"$f":"B13*S5+C13","v":0},null,null,null,0," ",null,null,null,31,11,null,{"$f":"J13*Q5*100","v":0},{"$f":"K13*Q5*100","v":0},0,{"$f":"P5+R13","v":22}]
[null,null,null,{"$f":"B14*S5+C14","v":0},null,null,null,0," ",null,null,null,31.5,10.8,null,{"$f":"J14*Q5*100","v":0},{"$f":"K14*Q5*100","v":0},0,{"$f":"P5+R14","v":22}]
[null,null,null,{"$f":"B15*S5+C15","v":0},null,null,null,0," ",null,null,null,32,10.3,null,{"$f":"J15*Q5*100","v":0},{"$f":"K15*Q5*100","v":0},0,{"$f":"P5+R15","v":22}]
[null,null,null,{"$f":"B16*S5+C16","v":0},null,null,null,0," ",null,null,null,32.5,10.199999999999999,null,{"$f":"J16*Q5*100","v":0},{"$f":"K16*Q5*100","v":0},0,{"$f":"P5+R16","v":22}]
[null,null,null,{"$f":"B17*S5+C17","v":0},null,null,null,0," ",null,null,null,33,10,null,{"$f":"J17*Q5*100","v":0},{"$f":"K17*Q5*100","v":0},0,{"$f":"P5+R17","v":22}]
[null,null,null,{"$f":"B18*S5+C18","v":0},null,null,null,0," ",null,null,null,33.5,9.8000000000000007,null,{"$f":"J18*Q5*100","v":0},{"$f":"K18*Q5*100","v":0},0,{"$f":"P5+R18","v":22}]
[null,null,null,{"$f":"B19*S5+C19","v":0},null,null,null,0," ",null,null,null,34,9.6,null,{"$f":"J19*Q5*100","v":0},{"$f":"K19*Q5*100","v":0},0,{"$f":"P5+R19","v":22}]
[null,null,null,{"$f":"B20*S5+C20","v":0},null,null,null,0," ",null,null,null,34.5,9.3000000000000007,null,{"$f":"J20*Q5*100","v":0},{"$f":"K20*Q5*100","v":0},0,{"$f":"P5+R20","v":22}]
[null,null,null,{"$f":"B21*S5+C21","v":0},null,null,null,0," ",null,null,null,35,9,null,{"$f":"J21*Q5*100","v":0},{"$f":"K21*Q55*100","v":0},0,{"$f":"P5+R21","v":22}]
[null,null,null,{"$f":"B22*S5+C22","v":0},null,null,null,0," ",null,null,null,35.5,8.5,null,{"$f":"J22*Q5*100","v":0},{"$f":"K22*Q5*100","v":0},0,{"$f":"P5+R22","v":22}]
[null,null,null,{"$f":"B23*S5+C23","v":0},null,null,null,0," ",null,null,null,36,8,null,{"$f":"J23*Q5*100","v":0},{"$f":"K23*Q5*100","v":0},0,{"$f":"P5+R23","v":22}]
[null,null,null,{"$f":"B24*S5+C24","v":0},null,null,null,0," ",null,null,null,36.5,7.5,null,{"$f":"J24*Q5*100","v":0},{"$f":"K24*Q5*100","v":0},0,{"$f":"P5+R24","v":22}]
[null,null,null,{"$f":"B25*S5+C25","v":0},null,null,null,0," ",null,null,null,37,7,null,{"$f":"J25*Q5*100","v":0},{"$f":"K25*Q5*100","v":0},0,{"$f":"P5+R25","v":22}]
[null,null,null,{"$f":"B26*S5+C26","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J26*Q5*100","v":0},{"$f":"K26*Q5*100","v":0},0,{"$f":"P5+R26","v":22}]
[null,null,null,{"$f":"B27*S5+C27","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J27*Q5*100","v":0},{"$f":"K27*Q5*100","v":0},0,{"$f":"P5+R27","v":22}]
[null,null,null,{"$f":"B28*S5+C28","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J28*Q5*100","v":0},{"$f":"K28*Q5*100","v":0},0,{"$f":"P5+R28","v":22}]
[null,null,null,{"$f":"B29*S5+C29","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J29*Q5*100","v":0},{"$f":"K29*Q5*100","v":0},0,{"$f":"P5+R29","v":22}]
[null,null,null,{"$f":"B30*S5+C30","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J30*Q5*100","v":0},{"$f":"K30*Q5*100","v":0},0,{"$f":"P5+R30","v":22}]
[null,null,null,{"$f":"B31*S5+C31","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J31*Q5*100","v":0},{"$f":"K31*Q5*100","v":0},0,{"$f":"P5+R31","v":22}]
[null,null,null,{"$f":"B32*S5+C32","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J32*Q5*100","v":0},{"$f":"K32*Q5*100","v":0},0,{"$f":"P5+R32","v":22}]
[null,null,null,{"$f":"B33*S5+C33","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J33*Q5*100","v":0},{"$f":"K33*Q5*100","v":0},0,{"$f":"P5+R33","v":22}]
[null,null,null,{"$f":"B34*S5+C34","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J34*Q5*100","v":0},{"$f":"K34*Q5*100","v":0},0,{"$f":"P5+R34","v":22}]
[null,null,null,{"$f":"B35*S5+C35","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J35*Q5*100","v":0},{"$f":"K35*Q5*100","v":0},0,{"$f":"P5+R35","v":22}]
[null,null,null,{"$f":"B36*S5+C36","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J36*Q5*100","v":0},{"$f":"K36*Q5*100","v":0},0,{"$f":"P5+R36","v":22}]
[null,null,null,{"$f":"B37*S5+C37","v":0},null,null,null,0," ",null,null,null,null,null,null,{"$f":"J37*Q5*100","v":0},{"$f":"K37*Q5*100","v":0},0,{"$f":"P5+R37","v":22}]