{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Vannitoa renoveerimiskulud"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Vannitoa renoveerimiskulud","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,"Vannitoa renoveerimiskulude tööleht"]
[null,"MÄRKUS. Tabeli erinevuse veerud näitavad, kas tegelik kulu ületas prognoositud summa. Punane arv näitab, et tegelikult kulus prognoosist rohkem raha (negatiivne), must näitab, et kulus vähem (positiivne). "]
[{"$nulls":4},"Ühiku hind (€)",null,null,"Kulud kokku (€)"]
[null,"Koht","Tooted","Kogus","Prognoos","Tegelik","Erinevus","Prognoos ","Tegelik ","Erinevus "]
[null,"Vann/dušš","Vann, malm, 150 cm, standardne",1,{"v":250,"d":"250.00 €"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":261,"d":"261.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-11,"d":"-11.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":250,"d":"250.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":261,"d":"261.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-11,"d":"-11.00 €"}}]
[null,"Vann/dušš","Dušikabiini uksed, hingedega, standardne",1,{"v":200,"d":"200.00 €"},{"v":213,"d":"213.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-13,"d":"-13.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":213,"d":"213.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-13,"d":"-13.00 €"}}]
[null,"Vann/dušš","Dušiotsik, standardne",1,{"v":50,"d":"50.00 €"},{"v":70,"d":"70.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-20,"d":"-20.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":50,"d":"50.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":70,"d":"70.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-20,"d":"-20.00 €"}}]
[null,"Vann/dušš","Vannikabiini seinad, standardne",1,{"v":200,"d":"200.00 €"},{"v":209,"d":"209.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-9,"d":"-9.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":209,"d":"209.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-9,"d":"-9.00 €"}}]
[null,"Kapid","Ravimikapp, 60 cm, eritellimus",1,{"v":200,"d":"200.00 €"},{"v":220,"d":"220.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-20,"d":"-20.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":220,"d":"220.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-20,"d":"-20.00 €"}}]
[null,"Kapid","Kosmeetikalaud, 75 cm, standardne",2,{"v":100,"d":"100.00 €"},{"v":118,"d":"118.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-18,"d":"-18.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":236,"d":"236.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-36,"d":"-36.00 €"}}]
[null,"Tööpinnad","Keraamilised plaadid, eritellimus (kogus jooksevmeetrites)",5,{"v":22.5,"d":"22.50 €"},{"v":35,"d":"35.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-12.5,"d":"-12.50 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":112.5,"d":"112.50 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":175,"d":"175.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-62.5,"d":"-62.50 €"}}]
[null,"Segistid","Vannikraan, standardne",1,{"v":90,"d":"90.00 €"},{"v":106,"d":"106.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-16,"d":"-16.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":90,"d":"90.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":106,"d":"106.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-16,"d":"-16.00 €"}}]
[null,"Segistid","Dušikraan, üks käepide, standardne",1,{"v":115,"d":"115.00 €"},{"v":123,"d":"123.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-8,"d":"-8.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":115,"d":"115.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":123,"d":"123.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-8,"d":"-8.00 €"}}]
[null,"Segistid","Valamukraan, standardne",1,{"v":95,"d":"95.00 €"},{"v":114,"d":"114.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-19,"d":"-19.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":95,"d":"95.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":114,"d":"114.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-19,"d":"-19.00 €"}}]
[null,"Põrandakate","Keraamilised plaadid, standardne (kogus ruutmeetrites)",35,{"v":12,"d":"12.00 €"},{"v":29,"d":"29.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-17,"d":"-17.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":420,"d":"420.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":1015,"d":"1,015.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-595,"d":"-595.00 €"}}]
[null,"Tööriistad","Rätikuhoidja, standardne",2,{"v":15,"d":"15.00 €"},{"v":22,"d":"22.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-7,"d":"-7.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":30,"d":"30.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":44,"d":"44.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-14,"d":"-14.00 €"}}]
[null,"Tööriistad","Tualettpaberihoidja",1,{"v":10,"d":"10.00 €"},{"v":22,"d":"22.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-12,"d":"-12.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":10,"d":"10.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":22,"d":"22.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-12,"d":"-12.00 €"}}]
[null,"Valgustus","Süvistatud valgustid, standardne",4,{"v":25,"d":"25.00 €"},{"v":35,"d":"35.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-10,"d":"-10.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":100,"d":"100.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":140,"d":"140.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-40,"d":"-40.00 €"}}]
[null,"Valamud","Tualettpott, standardne",2,{"v":60,"d":"60.00 €"},{"v":75,"d":"75.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-15,"d":"-15.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":120,"d":"120.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":150,"d":"150.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-30,"d":"-30.00 €"}}]
[null,"Muu",null,1,{"v":20,"d":"20.00 €"},{"v":40,"d":"40.00 €"},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos]]-Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":-20,"d":"-20.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Prognoos]], \"\")","v":{"v":20,"d":"20.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Kogus]]*Kulud[[#This Row],[Tegelik]], \"\")","v":{"v":40,"d":"40.00 €"}},{"$f":"IFERROR(Kulud[[#This Row],[Prognoos ]]-Kulud[[#This Row],[Tegelik ]], \"\")","v":{"v":-20,"d":"-20.00 €"}}]
[null,"Vahesumma",null,null,{"$f":"SUBTOTAL(109,Kulud[Prognoos])","v":{"v":1464.5,"d":"1,464.50 €"}},{"$f":"SUBTOTAL(109,Kulud[Tegelik])","v":{"v":1692,"d":"1,692.00 €"}},{"$f":"SUBTOTAL(109,Kulud[Erinevus])","v":{"v":-227.5,"d":"-227.50 €"}},{"$f":"SUBTOTAL(109,Kulud[[Prognoos ]])","v":{"v":2212.5,"d":"2,212.50 €"}},{"$f":"SUBTOTAL(109,Kulud[[Tegelik ]])","v":{"v":3138,"d":"3,138.00 €"}},{"$f":"SUBTOTAL(109,Kulud[[Erinevus ]])","v":{"v":-925.5,"d":"-925.50 €"}}]
[null,"Ootamatud kulutused (lisa prognoositud 30%)",null,null,{"$f":"IFERROR(Kulud[[#Totals],[Prognoos]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"439.35 €"}},null,null,{"$f":"IFERROR(Kulud[[#Totals],[Prognoos ]]*0.3, \"\")","v":{"v":663.75,"d":"663.75 €"}}]
[null,"Kogukulud",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"1,464.50 €"}},null,null,{"$f":"IFERROR(SUM(Kulud[[#Totals],[Prognoos ]],Ülekulu), \"\")","v":{"v":2876.25,"d":"2,876.25 €"}}]