{"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":24,"n_cols":10,"rows_kept":24,"merged":[[1,1,2,3],[2,4,2,6],[2,7,2,9],[22,1,22,3],[22,4,22,6],[22,7,22,9],[23,1,23,3],[23,4,23,6],[23,7,23,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":265,"d":"€ 265.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":250,"d":"€ 250.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":265,"d":"€ 265.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-15,"d":"€ -15.00"}}]
[null,"Bad/douche","Douchedeuren, scharnierend, standaard",1,{"v":200,"d":"€ 200.00"},{"v":205,"d":"€ 205.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":200,"d":"€ 200.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":205,"d":"€ 205.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-5,"d":"€ -5.00"}}]
[null,"Bad/douche","Douchekop, standaard",1,{"v":50,"d":"€ 50.00"},{"v":52,"d":"€ 52.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-2,"d":"€ -2.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":52,"d":"€ 52.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-2,"d":"€ -2.00"}}]
[null,"Bad/douche","Badwand, standaard",1,{"v":200,"d":"€ 200.00"},{"v":212,"d":"€ 212.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":200,"d":"€ 200.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":212,"d":"€ 212.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-12,"d":"€ -12.00"}}]
[null,"Kasten","Medicijnkastje 60 cm, luxe",1,{"v":200,"d":"€ 200.00"},{"v":210,"d":"€ 210.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":210,"d":"€ 210.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-10,"d":"€ -10.00"}}]
[null,"Kasten","Modulaire toilettafel 76 cm, standaard",2,{"v":100,"d":"€ 100.00"},{"v":114,"d":"€ 114.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":228,"d":"€ 228.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-28,"d":"€ -28.00"}}]
[null,"Aanrechten","Keramische tegels, luxe (strekkende meter)",5,{"v":22.5,"d":"€ 22.50"},{"v":31,"d":"€ 31.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-8.5,"d":"€ -8.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":155,"d":"€ 155.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-42.5,"d":"€ -42.50"}}]
[null,"Kranen","Kraan, badkuip, standaard",1,{"v":90,"d":"€ 90.00"},{"v":105,"d":"€ 105.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":90,"d":"€ 90.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":105,"d":"€ 105.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-15,"d":"€ -15.00"}}]
[null,"Kranen","Kraan, douche, één greep, standaard",1,{"v":115,"d":"€ 115.00"},{"v":129,"d":"€ 129.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":115,"d":"€ 115.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":129,"d":"€ 129.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-14,"d":"€ -14.00"}}]
[null,"Kranen","Wastafelkraan, standaard",1,{"v":95,"d":"€ 95.00"},{"v":115,"d":"€ 115.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":95,"d":"€ 95.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":115,"d":"€ 115.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-20,"d":"€ -20.00"}}]
[null,"Vloer","Keramische tegels, standaard (m²)",35,{"v":12,"d":"€ 12.00"},{"v":18,"d":"€ 18.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-6,"d":"€ -6.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":630,"d":"€ 630.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-210,"d":"€ -210.00"}}]
[null,"Hardware","Handdoekrek, standaard",2,{"v":15,"d":"€ 15.00"},{"v":31,"d":"€ 31.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-16,"d":"€ -16.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":62,"d":"€ 62.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-32,"d":"€ -32.00"}}]
[null,"Hardware","Toiletrolhouder",1,{"v":10,"d":"€ 10.00"},{"v":13,"d":"€ 13.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":10,"d":"€ 10.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":13,"d":"€ 13.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-3,"d":"€ -3.00"}}]
[null,"Verlichting","Inbouwlampen, standaard",4,{"v":25,"d":"€ 25.00"},{"v":35,"d":"€ 35.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":100,"d":"€ 100.00"}},{"$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":-40,"d":"€ -40.00"}}]
[null,"Wasbakken","Wastafel, standaard",2,{"v":60,"d":"€ 60.00"},{"v":68,"d":"€ 68.00"},{"$f":"IFERROR(Kosten[[#This Row],[Geschat]]-Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":-8,"d":"€ -8.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":136,"d":"€ 136.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-16,"d":"€ -16.00"}}]
[null,"Overig",null,1,{"v":20,"d":"€ 20.00"},{"v":30,"d":"€ 30.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":20,"d":"€ 20.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Aantal]]*Kosten[[#This Row],[Werkelijk]], \"\")","v":{"v":30,"d":"€ 30.00"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschat ]]-Kosten[[#This Row],[Werkelijk ]], \"\")","v":{"v":-10,"d":"€ -10.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":1633,"d":"€ 1,633.00"}},{"$f":"SUBTOTAL(109,Kosten[Verschil])","v":{"v":-168.5,"d":"€ -168.50"}},{"$f":"SUBTOTAL(109,Kosten[[Geschat ]])","v":{"v":2212.5,"d":"€ 2,212.50"}},{"$f":"SUBTOTAL(109,Kosten[[Werkelijk ]])","v":{"v":2687,"d":"€ 2,687.00"}},{"$f":"SUBTOTAL(109,Kosten[[Verschil ]])","v":{"v":-474.5,"d":"€ -474.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"}}]