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

{"sheet":"Bath Remodel Costs","index":0,"n_rows":28,"n_cols":10,"rows_kept":28,"merged":[[3,4,3,6],[3,7,3,9]]}
[]
[null,"Bathroom Remodel Costs Worksheet"]
[]
[{"$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(E6+2,E6+20)","v":{"v":257,"d":"$257.00"}},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-7,"d":"($7.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":250,"d":"$250.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":257,"d":"$257.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-7,"d":"($7.00)"}}]
[null,"Bath/Shower","Shower doors, hinged, standard",1,{"v":200,"d":"$200.00"},{"v":202,"d":"$202.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-2,"d":"($2.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":200,"d":"$200.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":202,"d":"$202.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-2,"d":"($2.00)"}}]
[null,"Bath/Shower","Showerhead, standard",1,{"v":50,"d":"$50.00"},{"v":53,"d":"$53.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-3,"d":"($3.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":50,"d":"$50.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":53,"d":"$53.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-3,"d":"($3.00)"}}]
[null,"Bath/Shower","Tub wall surround, standard",1,{"v":200,"d":"$200.00"},{"v":214,"d":"$214.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-14,"d":"($14.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":200,"d":"$200.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":214,"d":"$214.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-14,"d":"($14.00)"}}]
[null,"Cabinets","Medicine cabinet 24'', deluxe",1,{"v":200,"d":"$200.00"},{"v":205,"d":"$205.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-5,"d":"($5.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":200,"d":"$200.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":205,"d":"$205.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-5,"d":"($5.00)"}}]
[null,"Cabinets","Modular vanity 30'', standard",2,{"v":100,"d":"$100.00"},{"v":102,"d":"$102.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-2,"d":"($2.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":200,"d":"$200.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":204,"d":"$204.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-4,"d":"($4.00)"}}]
[null,"Countertops","Ceramic tile, deluxe (qty. in lin. ft.)",5,{"v":22.5,"d":"$22.50"},{"v":29,"d":"$29.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-6.5,"d":"($6.50)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":112.5,"d":"$112.50"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":145,"d":"$145.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-32.5,"d":"($32.50)"}}]
[null,"Faucets","Faucet, bathtub, standard",1,{"v":90,"d":"$90.00"},{"v":105,"d":"$105.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-15,"d":"($15.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":90,"d":"$90.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":105,"d":"$105.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-15,"d":"($15.00)"}}]
[null,"Faucets","Faucet, shower, single handle, standard",1,{"v":115,"d":"$115.00"},{"v":122,"d":"$122.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-7,"d":"($7.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":115,"d":"$115.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":122,"d":"$122.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-7,"d":"($7.00)"}}]
[null,"Faucets","Sink faucet, standard",1,{"v":95,"d":"$95.00"},{"v":114,"d":"$114.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-19,"d":"($19.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":95,"d":"$95.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":114,"d":"$114.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-19,"d":"($19.00)"}}]
[null,"Flooring","Ceramic tile, standard (qty. in sq. ft.)",35,{"v":12,"d":"$12.00"},{"v":31,"d":"$31.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-19,"d":"($19.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":420,"d":"$420.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":1085,"d":"$1,085.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-665,"d":"($665.00)"}}]
[null,"Hardware","Towel bar, standard",2,{"v":15,"d":"$15.00"},{"v":19,"d":"$19.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-4,"d":"($4.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":30,"d":"$30.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":38,"d":"$38.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-8,"d":"($8.00)"}}]
[null,"Hardware","Toilet Paper holder",1,{"v":10,"d":"$10.00"},{"v":23,"d":"$23.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-13,"d":"($13.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":10,"d":"$10.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":23,"d":"$23.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-13,"d":"($13.00)"}}]
[null,"Lighting","Recessed lights, standard",4,{"v":25,"d":"$25.00"},{"v":34,"d":"$34.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-9,"d":"($9.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":100,"d":"$100.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":136,"d":"$136.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-36,"d":"($36.00)"}}]
[null,"Sinks","Lavatory, standard",2,{"v":60,"d":"$60.00"},{"v":80,"d":"$80.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-20,"d":"($20.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":120,"d":"$120.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":160,"d":"$160.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-40,"d":"($40.00)"}}]
[null,"Toilets/Bidets","Toilet, standard",1,{"v":120,"d":"$120.00"},{"v":122,"d":"$122.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-2,"d":"($2.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":120,"d":"$120.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":122,"d":"$122.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-2,"d":"($2.00)"}}]
[null,"Ventilation","Exhaust fan/light, standard",1,{"v":60,"d":"$60.00"},{"v":79,"d":"$79.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-19,"d":"($19.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":60,"d":"$60.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":79,"d":"$79.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-19,"d":"($19.00)"}}]
[null,"Walls","Designer wallpaper, deluxe (qty. in sq. ft.)",192,{"v":0.95,"d":"$0.95"},{"v":10,"d":"$10.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-9.05,"d":"($9.05)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":182.39999999999998,"d":"$182.40"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":1920,"d":"$1,920.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-1737.6,"d":"($1,737.60)"}}]
[null,"Windows","Wood casement, deluxe",2,{"v":120,"d":"$120.00"},{"v":128,"d":"$128.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-8,"d":"($8.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":240,"d":"$240.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":256,"d":"$256.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-16,"d":"($16.00)"}}]
[null,"Other",null,1,{"v":20,"d":"$20.00"},{"v":40,"d":"$40.00"},{"$f":"tblCosts[[#This Row],[Estimated]]-tblCosts[[#This Row],[Actual]]","v":{"v":-20,"d":"($20.00)"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Estimated]]","v":{"v":20,"d":"$20.00"}},{"$f":"tblCosts[[#This Row],[Quantity]]*tblCosts[[#This Row],[Actual]]","v":{"v":40,"d":"$40.00"}},{"$f":"tblCosts[[#This Row],[Estimated ]]-tblCosts[[#This Row],[Actual ]]","v":{"v":-20,"d":"($20.00)"}}]
[null,null,"Subtotal",null,{"$f":"SUBTOTAL(109,tblCosts[Estimated])","v":{"v":1765.45,"d":"$1,765.45"}},{"$f":"SUBTOTAL(109,tblCosts[Actual])","v":{"v":1969,"d":"$1,969.00"}},{"$f":"SUBTOTAL(109,tblCosts[Difference])","v":{"v":-203.55,"d":"($203.55)"}},{"$f":"SUBTOTAL(109,tblCosts[[Estimated ]])","v":{"v":2814.9,"d":"$2,814.90"}},{"$f":"SUBTOTAL(109,tblCosts[[Actual ]])","v":{"v":5480,"d":"$5,480.00"}},{"$f":"SUBTOTAL(109,tblCosts[[Difference ]])","v":{"v":-2665.1,"d":"($2,665.10)"}}]
[null,null,"Unexpected Costs (add 30% estimated)",null,{"$f":"tblCosts[[#Totals],[Estimated]]*0.3","v":{"v":529.635,"d":"$529.64"}},null,null,{"$f":"tblCosts[[#Totals],[Estimated ]]*0.3","v":{"v":844.47,"d":"$844.47"}}]
[null,null,"Total",null,{"$f":"SUM(E26:E27)","v":{"v":2295.085,"d":"$2,295.09"}},null,null,{"$f":"SUM(tblCosts[[#Totals],[Estimated ]],Overage)","v":{"v":3659.37,"d":"$3,659.37"}}]