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

{"sheet":"Bath Remodel Costs","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,"Bathroom Remodel Costs Worksheet"]
[null,"NOTE: Difference columns in table will show if actual went over estimated amounts.  Red numbers show went over (negative) and black shows under numbers (positive). "]
[{"$nulls":4},"Itemised Cost (£)",null,null,"Total Cost (£)"]
[null,"Area","Items","Quantity","Estimated","Actual","Difference","Estimated ","Actual ","Difference "]
[null,"Bath/Shower","Tub, cast iron, 5', standard",1,{"v":250,"d":"£250.00"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":270,"d":"£270.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-20,"d":"-£20.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":250,"d":"£250.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":270,"d":"£270.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-20,"d":"-£20.00"}}]
[null,"Bath/Shower","Shower doors, hinged, standard",1,{"v":200,"d":"£200.00"},{"v":203,"d":"£203.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-3,"d":"-£3.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":200,"d":"£200.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":203,"d":"£203.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-3,"d":"-£3.00"}}]
[null,"Bath/Shower","Showerhead, standard",1,{"v":50,"d":"£50.00"},{"v":55,"d":"£55.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-5,"d":"-£5.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":50,"d":"£50.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":55,"d":"£55.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-5,"d":"-£5.00"}}]
[null,"Bath/Shower","Tub wall surround, standard",1,{"v":200,"d":"£200.00"},{"v":208,"d":"£208.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-8,"d":"-£8.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":200,"d":"£200.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":208,"d":"£208.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-8,"d":"-£8.00"}}]
[null,"Cabinets","Medicine cabinet 24'', deluxe",1,{"v":200,"d":"£200.00"},{"v":207,"d":"£207.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-7,"d":"-£7.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":200,"d":"£200.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":207,"d":"£207.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-7,"d":"-£7.00"}}]
[null,"Cabinets","Modular vanity 30'', standard",2,{"v":100,"d":"£100.00"},{"v":116,"d":"£116.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-16,"d":"-£16.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":200,"d":"£200.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":232,"d":"£232.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-32,"d":"-£32.00"}}]
[null,"Countertops","Ceramic tile, deluxe (qty. in lin. ft.)",5,{"v":22.5,"d":"£22.50"},{"v":38,"d":"£38.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-15.5,"d":"-£15.50"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":112.5,"d":"£112.50"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":190,"d":"£190.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-77.5,"d":"-£77.50"}}]
[null,"Faucets","Faucet, bathtub, standard",1,{"v":90,"d":"£90.00"},{"v":92,"d":"£92.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-2,"d":"-£2.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":90,"d":"£90.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":92,"d":"£92.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-2,"d":"-£2.00"}}]
[null,"Faucets","Faucet, shower, single handle, standard",1,{"v":115,"d":"£115.00"},{"v":132,"d":"£132.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-17,"d":"-£17.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":115,"d":"£115.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":132,"d":"£132.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-17,"d":"-£17.00"}}]
[null,"Faucets","Sink faucet, standard",1,{"v":95,"d":"£95.00"},{"v":108,"d":"£108.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-13,"d":"-£13.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":95,"d":"£95.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":108,"d":"£108.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-13,"d":"-£13.00"}}]
[null,"Flooring","Ceramic tile, standard (qty. in sq. ft.)",35,{"v":12,"d":"£12.00"},{"v":30,"d":"£30.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-18,"d":"-£18.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":420,"d":"£420.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":1050,"d":"£1,050.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-630,"d":"-£630.00"}}]
[null,"Hardware","Towel bar, standard",2,{"v":15,"d":"£15.00"},{"v":24,"d":"£24.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-9,"d":"-£9.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":30,"d":"£30.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":48,"d":"£48.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-18,"d":"-£18.00"}}]
[null,"Hardware","Toilet Paper holder",1,{"v":10,"d":"£10.00"},{"v":12,"d":"£12.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-2,"d":"-£2.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":10,"d":"£10.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":12,"d":"£12.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-2,"d":"-£2.00"}}]
[null,"Lighting","Recessed lights, standard",4,{"v":25,"d":"£25.00"},{"v":40,"d":"£40.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-15,"d":"-£15.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":100,"d":"£100.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":160,"d":"£160.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-60,"d":"-£60.00"}}]
[null,"Sinks","Lavatory, standard",2,{"v":60,"d":"£60.00"},{"v":72,"d":"£72.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-12,"d":"-£12.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":120,"d":"£120.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":144,"d":"£144.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-24,"d":"-£24.00"}}]
[null,"Other",null,1,{"v":20,"d":"£20.00"},{"v":38,"d":"£38.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-18,"d":"-£18.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Estimated]], \"\")","v":{"v":20,"d":"£20.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":38,"d":"£38.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-18,"d":"-£18.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Costs[Estimated])","v":{"v":1464.5,"d":"£1,464.50"}},{"$f":"SUBTOTAL(109,Costs[Actual])","v":{"v":1645,"d":"£1,645.00"}},{"$f":"SUBTOTAL(109,Costs[Difference])","v":{"v":-180.5,"d":"-£180.50"}},{"$f":"SUBTOTAL(109,Costs[[Estimated ]])","v":{"v":2212.5,"d":"£2,212.50"}},{"$f":"SUBTOTAL(109,Costs[[Actual ]])","v":{"v":3149,"d":"£3,149.00"}},{"$f":"SUBTOTAL(109,Costs[[Difference ]])","v":{"v":-936.5,"d":"-£936.50"}}]
[]
[null,"Unexpected Costs (add 30% estimated)",null,null,{"$f":"IFERROR(Costs[[#Totals],[Estimated]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"£439.35"}},null,null,{"$f":"IFERROR(Costs[[#Totals],[Estimated ]]*0.3, \"\")","v":{"v":663.75,"d":"£663.75"}}]
[null,"Total costs",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"£1,464.50"}},null,null,{"$f":"IFERROR(SUM(Costs[[#Totals],[Estimated ]],Overage), \"\")","v":{"v":2876.25,"d":"£2,876.25"}}]