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

{"sheet":"Verbouwingskosten badkamer","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,"Werkblad voor berekening verbouwingskosten badkamer"]
[null,"OPMERKING: Verschilkolommen in de tabel laten zien of de werkelijke bedragen de geschatte hebben overschreden. Rode getallen geven een overschrijding aan (negatief) en zwarte getallen hebben geen overschrijding (positief) "]
[{"$nulls":4},"Kosten per stuk (€)",null,null,"Totale kosten (€)"]
[null,"Sectie","Artikelen","Aantal","Geschat","Werkelijk","Verschil","Geschat ","Werkelijk ","Verschil "]
[null,"Bad/douche","Badkuip, gietijzer, 150 cm, standaard",1,{"v":250,"d":"€ 250.00"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":268,"d":"€ 268.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-18,"d":"€ -18.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":250,"d":"€ 250.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":268,"d":"€ 268.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-18,"d":"€ -18.00"}}]
[null,"Bad/douche","Douchedeuren, scharnierend, standaard",1,{"v":200,"d":"€ 200.00"},{"v":204,"d":"€ 204.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-4,"d":"€ -4.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":200,"d":"€ 200.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":204,"d":"€ 204.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-4,"d":"€ -4.00"}}]
[null,"Bad/douche","Douchekop, standaard",1,{"v":50,"d":"€ 50.00"},{"v":54,"d":"€ 54.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-4,"d":"€ -4.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":50,"d":"€ 50.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":54,"d":"€ 54.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-4,"d":"€ -4.00"}}]
[null,"Bad/douche","Badwand, standaard",1,{"v":200,"d":"€ 200.00"},{"v":203,"d":"€ 203.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-3,"d":"€ -3.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":200,"d":"€ 200.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":203,"d":"€ 203.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-3,"d":"€ -3.00"}}]
[null,"Kasten","Medicijnkastje 60 cm, luxe",1,{"v":200,"d":"€ 200.00"},{"v":214,"d":"€ 214.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-14,"d":"€ -14.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":200,"d":"€ 200.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":214,"d":"€ 214.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-14,"d":"€ -14.00"}}]
[null,"Kasten","Modulaire toilettafel 76 cm, standaard",2,{"v":100,"d":"€ 100.00"},{"v":110,"d":"€ 110.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-10,"d":"€ -10.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":200,"d":"€ 200.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":220,"d":"€ 220.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-20,"d":"€ -20.00"}}]
[null,"Aanrechten","Keramische tegels, luxe (strekkende meter)",5,{"v":22.5,"d":"€ 22.50"},{"v":28,"d":"€ 28.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-5.5,"d":"€ -5.50"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":112.5,"d":"€ 112.50"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":140,"d":"€ 140.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-27.5,"d":"€ -27.50"}}]
[null,"Kranen","Kraan, badkuip, standaard",1,{"v":90,"d":"€ 90.00"},{"v":102,"d":"€ 102.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-12,"d":"€ -12.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":90,"d":"€ 90.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":102,"d":"€ 102.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-12,"d":"€ -12.00"}}]
[null,"Kranen","Kraan, douche, één greep, standaard",1,{"v":115,"d":"€ 115.00"},{"v":118,"d":"€ 118.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-3,"d":"€ -3.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":115,"d":"€ 115.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":118,"d":"€ 118.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-3,"d":"€ -3.00"}}]
[null,"Kranen","Wastafelkraan, standaard",1,{"v":95,"d":"€ 95.00"},{"v":113,"d":"€ 113.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-18,"d":"€ -18.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":95,"d":"€ 95.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":113,"d":"€ 113.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-18,"d":"€ -18.00"}}]
[null,"Vloer","Keramische tegels, standaard (m²)",35,{"v":12,"d":"€ 12.00"},{"v":30,"d":"€ 30.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-18,"d":"€ -18.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":420,"d":"€ 420.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":1050,"d":"€ 1,050.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-630,"d":"€ -630.00"}}]
[null,"Hardware","Handdoekrek, standaard",2,{"v":15,"d":"€ 15.00"},{"v":24,"d":"€ 24.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-9,"d":"€ -9.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":30,"d":"€ 30.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":48,"d":"€ 48.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-18,"d":"€ -18.00"}}]
[null,"Hardware","Toiletrolhouder",1,{"v":10,"d":"€ 10.00"},{"v":28,"d":"€ 28.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-18,"d":"€ -18.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":10,"d":"€ 10.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":28,"d":"€ 28.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-18,"d":"€ -18.00"}}]
[null,"Verlichting","Inbouwlampen, standaard",4,{"v":25,"d":"€ 25.00"},{"v":45,"d":"€ 45.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-20,"d":"€ -20.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":100,"d":"€ 100.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":180,"d":"€ 180.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-80,"d":"€ -80.00"}}]
[null,"Wasbakken","Wastafel, standaard",2,{"v":60,"d":"€ 60.00"},{"v":75,"d":"€ 75.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-15,"d":"€ -15.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":120,"d":"€ 120.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":150,"d":"€ 150.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-30,"d":"€ -30.00"}}]
[null,"Overig",null,1,{"v":20,"d":"€ 20.00"},{"v":25,"d":"€ 25.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-5,"d":"€ -5.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Geschat]], \"\")","v":{"v":20,"d":"€ 20.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":25,"d":"€ 25.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-5,"d":"€ -5.00"}}]
[null,"Subtotaal",null,null,{"$f":"SUBTOTAL(109,Kosten[Geschat])","v":{"v":1464.5,"d":"€ 1,464.50"}},{"$f":"SUBTOTAL(109,Kosten[Werkelijk])","v":{"v":1641,"d":"€ 1,641.00"}},{"$f":"SUBTOTAL(109,Kosten[Verschil])","v":{"v":-176.5,"d":"€ -176.50"}},{"$f":"SUBTOTAL(109,Kosten[[Geschat ]])","v":{"v":2212.5,"d":"€ 2,212.50"}},{"$f":"SUBTOTAL(109,Kosten[[Werkelijk ]])","v":{"v":3117,"d":"€ 3,117.00"}},{"$f":"SUBTOTAL(109,Kosten[[Verschil ]])","v":{"v":-904.5,"d":"€ -904.50"}}]
[null,"Onvoorziene kosten (schatting van 30%)",null,null,{"$f":"IFERROR(Kosten[[#Totals],[Geschat]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"€ 439.35"}},null,null,{"$f":"IFERROR(Kosten[[#Totals],[Geschat ]]*0.3, \"\")","v":{"v":663.75,"d":"€ 663.75"}}]
[null,"Totale kosten",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"€ 1,464.50"}},null,null,{"$f":"IFERROR(SUM(Kosten[[#Totals],[Geschat ]],Overschrijding), \"\")","v":{"v":2876.25,"d":"€ 2,876.25"}}]