{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["浴室改造费用"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"浴室改造费用","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,"浴室改造费用工作表"]
[null,"注意：如果实际金额超过预计金额，表中将显示差额列。红色数字表示金额超出（负数），黑色表示盈余（正数）。 "]
[{"$nulls":4},"明细费用 (¥)",null,null,"总费用 (¥)"]
[null,"区域","物品​","数量","估计","实际","差额","估计 ","实际 ","差额 "]
[null,"浴室/淋浴","浴缸，铸铁，5 英尺，标准",1,{"v":250,"d":"¥250.00"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":270,"d":"¥270.00"}},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-20,"d":"(¥20.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":250,"d":"¥250.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":270,"d":"¥270.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-20,"d":"(¥20.00)"}}]
[null,"浴室/淋浴","浴室门，铰链式，标准",1,{"v":200,"d":"¥200.00"},{"v":208,"d":"¥208.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-8,"d":"(¥8.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":208,"d":"¥208.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-8,"d":"(¥8.00)"}}]
[null,"浴室/淋浴","喷头，标准",1,{"v":50,"d":"¥50.00"},{"v":59,"d":"¥59.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-9,"d":"(¥9.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":50,"d":"¥50.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":59,"d":"¥59.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-9,"d":"(¥9.00)"}}]
[null,"浴室/淋浴","浴缸壁围绕物，标准",1,{"v":200,"d":"¥200.00"},{"v":220,"d":"¥220.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-20,"d":"(¥20.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":220,"d":"¥220.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-20,"d":"(¥20.00)"}}]
[null,"橱柜","药柜，24 英寸，豪华",1,{"v":200,"d":"¥200.00"},{"v":211,"d":"¥211.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-11,"d":"(¥11.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":211,"d":"¥211.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-11,"d":"(¥11.00)"}}]
[null,"橱柜","单元式梳妆台，30 英寸，标准",2,{"v":100,"d":"¥100.00"},{"v":108,"d":"¥108.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-8,"d":"(¥8.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":216,"d":"¥216.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-16,"d":"(¥16.00)"}}]
[null,"台面","瓷砖，豪华（数量以英尺为单位）",5,{"v":22.5,"d":"¥22.50"},{"v":25,"d":"¥25.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-2.5,"d":"(¥2.50)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":112.5,"d":"¥112.50"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":125,"d":"¥125.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-12.5,"d":"(¥12.50)"}}]
[null,"水龙头","水龙头，浴缸，标准",1,{"v":90,"d":"¥90.00"},{"v":106,"d":"¥106.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-16,"d":"(¥16.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":90,"d":"¥90.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":106,"d":"¥106.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-16,"d":"(¥16.00)"}}]
[null,"水龙头","水龙头，淋浴，单把手，标准",1,{"v":115,"d":"¥115.00"},{"v":134,"d":"¥134.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-19,"d":"(¥19.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":115,"d":"¥115.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":134,"d":"¥134.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-19,"d":"(¥19.00)"}}]
[null,"水龙头","水槽水龙头，标准",1,{"v":95,"d":"¥95.00"},{"v":108,"d":"¥108.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-13,"d":"(¥13.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":95,"d":"¥95.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":108,"d":"¥108.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-13,"d":"(¥13.00)"}}]
[null,"地板","瓷砖，标准（数量以平方英尺为单位）",35,{"v":12,"d":"¥12.00"},{"v":20,"d":"¥20.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-8,"d":"(¥8.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":420,"d":"¥420.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":700,"d":"¥700.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-280,"d":"(¥280.00)"}}]
[null,"硬件","毛巾杆，标准",2,{"v":15,"d":"¥15.00"},{"v":27,"d":"¥27.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-12,"d":"(¥12.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":30,"d":"¥30.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":54,"d":"¥54.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-24,"d":"(¥24.00)"}}]
[null,"硬件","卫生纸架",1,{"v":10,"d":"¥10.00"},{"v":27,"d":"¥27.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-17,"d":"(¥17.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":10,"d":"¥10.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":27,"d":"¥27.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-17,"d":"(¥17.00)"}}]
[null,"照明","嵌壁灯，标准",4,{"v":25,"d":"¥25.00"},{"v":30,"d":"¥30.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-5,"d":"(¥5.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":100,"d":"¥100.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":120,"d":"¥120.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-20,"d":"(¥20.00)"}}]
[null,"水槽","盥洗台，标准",2,{"v":60,"d":"¥60.00"},{"v":64,"d":"¥64.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-4,"d":"(¥4.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":120,"d":"¥120.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":128,"d":"¥128.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-8,"d":"(¥8.00)"}}]
[null,"其他",null,1,{"v":20,"d":"¥20.00"},{"v":29,"d":"¥29.00"},{"$f":"IFERROR(成本[[#This Row],[估计]]-成本[[#This Row],[实际]], \"\")","v":{"v":-9,"d":"(¥9.00)"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[估计]], \"\")","v":{"v":20,"d":"¥20.00"}},{"$f":"IFERROR(成本[[#This Row],[数量]]*成本[[#This Row],[实际]], \"\")","v":{"v":29,"d":"¥29.00"}},{"$f":"IFERROR(成本[[#This Row],[估计 ]]-成本[[#This Row],[实际 ]], \"\")","v":{"v":-9,"d":"(¥9.00)"}}]
[null,"小计",null,null,{"$f":"SUBTOTAL(109,成本[估计])","v":{"v":1464.5,"d":"¥1,464.50"}},{"$f":"SUBTOTAL(109,成本[实际])","v":{"v":1646,"d":"¥1,646.00"}},{"$f":"SUBTOTAL(109,成本[差额])","v":{"v":-181.5,"d":"(¥181.50)"}},{"$f":"SUBTOTAL(109,成本[[估计 ]])","v":{"v":2212.5,"d":"¥2,212.50"}},{"$f":"SUBTOTAL(109,成本[[实际 ]])","v":{"v":2715,"d":"¥2,715.00"}},{"$f":"SUBTOTAL(109,成本[[差额 ]])","v":{"v":-502.5,"d":"(¥502.50)"}}]
[]
[null,"非预期支出（预计加 30%）",null,null,{"$f":"IFERROR(成本[[#Totals],[估计]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"¥439.35"}},null,null,{"$f":"IFERROR(成本[[#Totals],[估计 ]]*0.3, \"\")","v":{"v":663.75,"d":"¥663.75"}}]
[null,"总费用",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"¥1,464.50"}},null,null,{"$f":"IFERROR(SUM(成本[[#Totals],[估计 ]],超额), \"\")","v":{"v":2876.25,"d":"¥2,876.25"}}]