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

{"sheet":"Badezimmer-Umbaukosten","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,"Arbeitsblatt für Badezimmerumbau"]
[null,"ANMERKUNG: Die Differenzspalten in der Tabelle zeigen an, ob die Ist-Beträge die geschätzten Beträge überschritten haben.  Rote Zahlen zeigen eine Überschreitung (negativ) und schwarze eine Unterschreitung (positiv) an. "]
[{"$nulls":4},"Aufgeschlüsselte Kosten (€)",null,null,"Gesamtkosten (€)"]
[null,"Bereich","Artikel","Menge","Geschätzt","Tatsächlich","Differenz","Geschätzt ","Tatsächlich ","Differenz "]
[null,"Bad/Dusche","Badewanne, Gusseisen, 5', Standard",1,{"v":250,"d":"250.00 €"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":260,"d":"260.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-10,"d":"-10.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":250,"d":"250.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":260,"d":"260.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-10,"d":"-10.00 €"}}]
[null,"Bad/Dusche","Duschtüren, mit Scharnieren, Standard",1,{"v":200,"d":"200.00 €"},{"v":216,"d":"216.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-16,"d":"-16.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":216,"d":"216.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-16,"d":"-16.00 €"}}]
[null,"Bad/Dusche","Duschkopf, Standard",1,{"v":50,"d":"50.00 €"},{"v":53,"d":"53.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-3,"d":"-3.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":50,"d":"50.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":53,"d":"53.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-3,"d":"-3.00 €"}}]
[null,"Bad/Dusche","Wandabdeckung Duschtasse, Standard",1,{"v":200,"d":"200.00 €"},{"v":203,"d":"203.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-3,"d":"-3.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":203,"d":"203.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-3,"d":"-3.00 €"}}]
[null,"Schränke","Medizinschrank 60 cm', Deluxe",1,{"v":200,"d":"200.00 €"},{"v":211,"d":"211.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-11,"d":"-11.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":211,"d":"211.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-11,"d":"-11.00 €"}}]
[null,"Schränke","Toilettentisch modular 75 cm, Standard",2,{"v":100,"d":"100.00 €"},{"v":108,"d":"108.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-8,"d":"-8.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":200,"d":"200.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":216,"d":"216.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-16,"d":"-16.00 €"}}]
[null,"Arbeitsplatten","Keramikfliesen, Deluxe (Menge in m2).",5,{"v":22.5,"d":"22.50 €"},{"v":32,"d":"32.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-9.5,"d":"-9.50 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":112.5,"d":"112.50 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":160,"d":"160.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-47.5,"d":"-47.50 €"}}]
[null,"Wasserhähne","Wasserhahn Badewanne, Standard",1,{"v":90,"d":"90.00 €"},{"v":100,"d":"100.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-10,"d":"-10.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":90,"d":"90.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":100,"d":"100.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-10,"d":"-10.00 €"}}]
[null,"Wasserhähne","Wasserhahn Dusche, Einhebel, Standard",1,{"v":115,"d":"115.00 €"},{"v":122,"d":"122.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-7,"d":"-7.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":115,"d":"115.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":122,"d":"122.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-7,"d":"-7.00 €"}}]
[null,"Wasserhähne","Wasserhahn Ausguss, Standard",1,{"v":95,"d":"95.00 €"},{"v":105,"d":"105.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-10,"d":"-10.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":95,"d":"95.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":105,"d":"105.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-10,"d":"-10.00 €"}}]
[null,"Fußbodenbelag","Keramikfliesen, Standard (Menge in m2).",35,{"v":12,"d":"12.00 €"},{"v":21,"d":"21.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-9,"d":"-9.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":420,"d":"420.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":735,"d":"735.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-315,"d":"-315.00 €"}}]
[null,"Eisenwaren","Handtuchhalter, Standard",2,{"v":15,"d":"15.00 €"},{"v":26,"d":"26.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-11,"d":"-11.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":30,"d":"30.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":52,"d":"52.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-22,"d":"-22.00 €"}}]
[null,"Eisenwaren","Toilettenpapierhalter",1,{"v":10,"d":"10.00 €"},{"v":12,"d":"12.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-2,"d":"-2.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":10,"d":"10.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":12,"d":"12.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-2,"d":"-2.00 €"}}]
[null,"Beleuchtung","Deckenlampen, Standard",4,{"v":25,"d":"25.00 €"},{"v":45,"d":"45.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-20,"d":"-20.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":100,"d":"100.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":180,"d":"180.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-80,"d":"-80.00 €"}}]
[null,"Ausguss","Toilette, Standard",2,{"v":60,"d":"60.00 €"},{"v":65,"d":"65.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-5,"d":"-5.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":120,"d":"120.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":130,"d":"130.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-10,"d":"-10.00 €"}}]
[null,"Sonstige",null,1,{"v":20,"d":"20.00 €"},{"v":36,"d":"36.00 €"},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt]]-Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":-16,"d":"-16.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Geschätzt]], \"\")","v":{"v":20,"d":"20.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Menge]]*Kosten[[#This Row],[Tatsächlich]], \"\")","v":{"v":36,"d":"36.00 €"}},{"$f":"IFERROR(Kosten[[#This Row],[Geschätzt ]]-Kosten[[#This Row],[Tatsächlich ]], \"\")","v":{"v":-16,"d":"-16.00 €"}}]
[null,"Zwischensumme",null,null,{"$f":"SUBTOTAL(109,Kosten[Geschätzt])","v":{"v":1464.5,"d":"1,464.50 €"}},{"$f":"SUBTOTAL(109,Kosten[Tatsächlich])","v":{"v":1615,"d":"1,615.00 €"}},{"$f":"SUBTOTAL(109,Kosten[Differenz])","v":{"v":-150.5,"d":"-150.50 €"}},{"$f":"SUBTOTAL(109,Kosten[[Geschätzt ]])","v":{"v":2212.5,"d":"2,212.50 €"}},{"$f":"SUBTOTAL(109,Kosten[[Tatsächlich ]])","v":{"v":2791,"d":"2,791.00 €"}},{"$f":"SUBTOTAL(109,Kosten[[Differenz ]])","v":{"v":-578.5,"d":"-578.50 €"}}]
[]
[null,"Unerwartete Kosten (30 % zu Schätzung addieren)",null,null,{"$f":"IFERROR(Kosten[[#Totals],[Geschätzt]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"439.35 €"}},null,null,{"$f":"IFERROR(Kosten[[#Totals],[Geschätzt ]]*0.3, \"\")","v":{"v":663.75,"d":"663.75 €"}}]
[null,"Gesamtkosten",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"1,464.50 €"}},null,null,{"$f":"IFERROR(SUM(Kosten[[#Totals],[Geschätzt ]],Überschuss), \"\")","v":{"v":2876.25,"d":"2,876.25 €"}}]