{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["STROŠKI PRENOVE KOPALNICE"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"STROŠKI PRENOVE KOPALNICE","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[1,1,2,3],[2,4,2,6],[2,7,2,9],[21,1,21,3],[21,4,21,6],[21,7,21,9],[22,1,22,3],[22,4,22,6],[22,7,22,9]]}
[null,"DELOVNI LIST S PREGLEDOM STROŠKOV PRENOVE KOPALNICE"]
[null,"OPOMBA: Stolpci z razlikami prikazujejo, ali so dejanski zneski presegli predvidene zneske. Rdeče številke prikazujejo zneske, ki so presegli predvidene zneske (negativni), črne pa zneske, ki predvidenih zneskov niso presegli (pozitivni). "]
[{"$nulls":4},"Razčlenjeni stroški (€)",null,null,"Skupni strošek (€)"]
[null,"Področje","Elementi","Količina","Predvideno","Dejansko","Razlika","Predvideno ","Dejansko ","Razlika "]
[null,"Kopalnice/tuši","Kad, litoželezna, 1,5 m, standardna",1,{"v":250,"d":"250.00 €"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":255,"d":"255.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-5,"d":"-5.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":250,"d":"250.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":255,"d":"255.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-5,"d":"-5.00 €"}}]
[null,"Kopalnice/tuši","Tuš vrata, nihajna, standardna",1,{"v":200,"d":"200.00 €"},{"v":210,"d":"210.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-10,"d":"-10.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":210,"d":"210.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-10,"d":"-10.00 €"}}]
[null,"Kopalnice/tuši","Tuš glava, standardna",1,{"v":50,"d":"50.00 €"},{"v":55,"d":"55.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-5,"d":"-5.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":50,"d":"50.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":55,"d":"55.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-5,"d":"-5.00 €"}}]
[null,"Kopalnice/tuši","Kopalniška stena za kad, standardna",1,{"v":200,"d":"200.00 €"},{"v":219,"d":"219.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-19,"d":"-19.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":219,"d":"219.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-19,"d":"-19.00 €"}}]
[null,"Omarice","Omarica za zdravila, 60 cm, nadstandardna",1,{"v":200,"d":"200.00 €"},{"v":215,"d":"215.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-15,"d":"-15.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":215,"d":"215.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-15,"d":"-15.00 €"}}]
[null,"Omarice","Modularna lepotilna mizica, 76 cm, standardna",2,{"v":100,"d":"100.00 €"},{"v":107,"d":"107.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-7,"d":"-7.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":214,"d":"214.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-14,"d":"-14.00 €"}}]
[null,"Pulti","Keramične ploščice, nadstandardne  (v cm)",5,{"v":22.5,"d":"22.50 €"},{"v":28,"d":"28.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-5.5,"d":"-5.50 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":112.5,"d":"112.50 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":140,"d":"140.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-27.5,"d":"-27.50 €"}}]
[null,"Pipe","Pipa, kad, standardno",1,{"v":90,"d":"90.00 €"},{"v":108,"d":"108.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-18,"d":"-18.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":90,"d":"90.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":108,"d":"108.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-18,"d":"-18.00 €"}}]
[null,"Pipe","Pipa, tuš, enojna ročica, standardno",1,{"v":115,"d":"115.00 €"},{"v":122,"d":"122.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-7,"d":"-7.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":115,"d":"115.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":122,"d":"122.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-7,"d":"-7.00 €"}}]
[null,"Pipe","Pipa za umivalnik, standardna",1,{"v":95,"d":"95.00 €"},{"v":110,"d":"110.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-15,"d":"-15.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":95,"d":"95.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":110,"d":"110.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-15,"d":"-15.00 €"}}]
[null,"Talne obloge","Keramične ploščice, standardne (v cm)",35,{"v":12,"d":"12.00 €"},{"v":29,"d":"29.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-17,"d":"-17.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":420,"d":"420.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":1015,"d":"1,015.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-595,"d":"-595.00 €"}}]
[null,"Strojna oprema","Držalo za brisače, standardno",2,{"v":15,"d":"15.00 €"},{"v":23,"d":"23.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-8,"d":"-8.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":30,"d":"30.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":46,"d":"46.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-16,"d":"-16.00 €"}}]
[null,"Strojna oprema","Držalo za toaletni papir",1,{"v":10,"d":"10.00 €"},{"v":24,"d":"24.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-14,"d":"-14.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":10,"d":"10.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":24,"d":"24.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-14,"d":"-14.00 €"}}]
[null,"Osvetlitev","Vgradne luči, standardne",4,{"v":25,"d":"25.00 €"},{"v":28,"d":"28.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-3,"d":"-3.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":100,"d":"100.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":112,"d":"112.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-12,"d":"-12.00 €"}}]
[null,"Korita","Straniščna školjka, standardna",2,{"v":60,"d":"60.00 €"},{"v":64,"d":"64.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-4,"d":"-4.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":120,"d":"120.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":128,"d":"128.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-8,"d":"-8.00 €"}}]
[null,"Drugo",null,1,{"v":20,"d":"20.00 €"},{"v":25,"d":"25.00 €"},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno]]-Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":-5,"d":"-5.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Predvideno]], \"\")","v":{"v":20,"d":"20.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Količina]]*Stroški[[#This Row],[Dejansko]], \"\")","v":{"v":25,"d":"25.00 €"}},{"$f":"IFERROR(Stroški[[#This Row],[Predvideno ]]-Stroški[[#This Row],[Dejansko ]], \"\")","v":{"v":-5,"d":"-5.00 €"}}]
[null,"Delna vsota",null,null,{"$f":"SUBTOTAL(109,Stroški[Predvideno])","v":{"v":1464.5,"d":"1,464.50 €"}},{"$f":"SUBTOTAL(109,Stroški[Dejansko])","v":{"v":1622,"d":"1,622.00 €"}},{"$f":"SUBTOTAL(109,Stroški[Razlika])","v":{"v":-157.5,"d":"-157.50 €"}},{"$f":"SUBTOTAL(109,Stroški[[Predvideno ]])","v":{"v":2212.5,"d":"2,212.50 €"}},{"$f":"SUBTOTAL(109,Stroški[[Dejansko ]])","v":{"v":2998,"d":"2,998.00 €"}},{"$f":"SUBTOTAL(109,Stroški[[Razlika ]])","v":{"v":-785.5,"d":"-785.50 €"}}]
[null,"Nepričakovani stroški (dodaj predvideno 30 %)",null,null,{"$f":"IFERROR(Stroški[[#Totals],[Predvideno]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"439.35 €"}},null,null,{"$f":"IFERROR(Stroški[[#Totals],[Predvideno ]]*0.3, \"\")","v":{"v":663.75,"d":"663.75 €"}}]
[null,"Skupni stroški",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"1,464.50 €"}},null,null,{"$f":"IFERROR(SUM(Stroški[[#Totals],[Predvideno ]],Presežek), \"\")","v":{"v":2876.25,"d":"2,876.25 €"}}]