{"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},"Itemized 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":267,"d":"$267.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":250,"d":"$250.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":267,"d":"$267.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-17,"d":"($17.00)"}}]
[null,"Bath/Shower","Shower doors, hinged, standard",1,{"v":200,"d":"$200.00"},{"v":212,"d":"$212.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":200,"d":"$200.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":212,"d":"$212.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-12,"d":"($12.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":209,"d":"$209.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":200,"d":"$200.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":209,"d":"$209.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-9,"d":"($9.00)"}}]
[null,"Cabinets","Medicine cabinet 24'', deluxe",1,{"v":200,"d":"$200.00"},{"v":219,"d":"$219.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-19,"d":"($19.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":219,"d":"$219.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-19,"d":"($19.00)"}}]
[null,"Cabinets","Modular vanity 30'', standard",2,{"v":100,"d":"$100.00"},{"v":120,"d":"$120.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":200,"d":"$200.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":240,"d":"$240.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-40,"d":"($40.00)"}}]
[null,"Countertops","Ceramic tile, deluxe (qty. in lin. ft.)",5,{"v":22.5,"d":"$22.50"},{"v":26,"d":"$26.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-3.5,"d":"($3.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":130,"d":"$130.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-17.5,"d":"($17.50)"}}]
[null,"Faucets","Faucet, bathtub, standard",1,{"v":90,"d":"$90.00"},{"v":96,"d":"$96.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-6,"d":"($6.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":96,"d":"$96.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-6,"d":"($6.00)"}}]
[null,"Faucets","Faucet, shower, single handle, standard",1,{"v":115,"d":"$115.00"},{"v":126,"d":"$126.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-11,"d":"($11.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":126,"d":"$126.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-11,"d":"($11.00)"}}]
[null,"Faucets","Sink faucet, standard",1,{"v":95,"d":"$95.00"},{"v":100,"d":"$100.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":95,"d":"$95.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":100,"d":"$100.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-5,"d":"($5.00)"}}]
[null,"Flooring","Ceramic tile, standard (qty. in sq. ft.)",35,{"v":12,"d":"$12.00"},{"v":26,"d":"$26.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-14,"d":"($14.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":910,"d":"$910.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-490,"d":"($490.00)"}}]
[null,"Hardware","Towel bar, standard",2,{"v":15,"d":"$15.00"},{"v":29,"d":"$29.00"},{"$f":"IFERROR(Costs[[#This Row],[Estimated]]-Costs[[#This Row],[Actual]], \"\")","v":{"v":-14,"d":"($14.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":58,"d":"$58.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-28,"d":"($28.00)"}}]
[null,"Hardware","Toilet Paper holder",1,{"v":10,"d":"$10.00"},{"v":17,"d":"$17.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":10,"d":"$10.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":17,"d":"$17.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-7,"d":"($7.00)"}}]
[null,"Lighting","Recessed lights, standard",4,{"v":25,"d":"$25.00"},{"v":43,"d":"$43.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":100,"d":"$100.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":172,"d":"$172.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-72,"d":"($72.00)"}}]
[null,"Sinks","Lavatory, standard",2,{"v":60,"d":"$60.00"},{"v":69,"d":"$69.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":120,"d":"$120.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":138,"d":"$138.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-18,"d":"($18.00)"}}]
[null,"Other",null,1,{"v":20,"d":"$20.00"},{"v":23,"d":"$23.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":20,"d":"$20.00"}},{"$f":"IFERROR(Costs[[#This Row],[Quantity]]*Costs[[#This Row],[Actual]], \"\")","v":{"v":23,"d":"$23.00"}},{"$f":"IFERROR(Costs[[#This Row],[Estimated ]]-Costs[[#This Row],[Actual ]], \"\")","v":{"v":-3,"d":"($3.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":1637,"d":"$1,637.00"}},{"$f":"SUBTOTAL(109,Costs[Difference])","v":{"v":-172.5,"d":"($172.50)"}},{"$f":"SUBTOTAL(109,Costs[[Estimated ]])","v":{"v":2212.5,"d":"$2,212.50"}},{"$f":"SUBTOTAL(109,Costs[[Actual ]])","v":{"v":2972,"d":"$2,972.00"}},{"$f":"SUBTOTAL(109,Costs[[Difference ]])","v":{"v":-759.5,"d":"($759.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"}}]