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

{"sheet":"浴室改造费用","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[1,1,2,3],[2,4,2,6],[2,7,2,9],[21,1,21,3],[21,4,21,6],[21,7,21,9],[22,1,22,3],[22,4,22,6],[22,7,22,9]]}
[null,"浴室改造费用工作表"]
[null,"注意：如果实际金额超过预计金额，表中将显示差额列。红色数字表示金额超出（负数），黑色表示盈余（正数）。 "]
[{"$nulls":4},"明细费用 ($)",null,null,"总费用 ($)"]
[null,"区域","物品​","数量","估计","实际","差额","估计 ","实际 ","差额 "]
[null,"浴室/淋浴","浴缸，铸铁，5 英尺，标准",1,{"v":250,"d":"¥250.00"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":261,"d":"¥261.00"}},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-11,"d":"(¥11.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":250,"d":"¥250.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":261,"d":"¥261.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-11,"d":"(¥11.00)"}}]
[null,"浴室/淋浴","浴室门，铰链式，标准",1,{"v":200,"d":"¥200.00"},{"v":210,"d":"¥210.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-10,"d":"(¥10.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":210,"d":"¥210.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-10,"d":"(¥10.00)"}}]
[null,"浴室/淋浴","喷头，标准",1,{"v":50,"d":"¥50.00"},{"v":68,"d":"¥68.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-18,"d":"(¥18.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":50,"d":"¥50.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":68,"d":"¥68.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-18,"d":"(¥18.00)"}}]
[null,"浴室/淋浴","浴缸壁围绕物，标准",1,{"v":200,"d":"¥200.00"},{"v":206,"d":"¥206.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-6,"d":"(¥6.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":206,"d":"¥206.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-6,"d":"(¥6.00)"}}]
[null,"橱柜","药柜，24 英寸，豪华",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,"橱柜","单元式梳妆台，30 英寸，标准",2,{"v":100,"d":"¥100.00"},{"v":115,"d":"¥115.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-15,"d":"(¥15.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":230,"d":"¥230.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-30,"d":"(¥30.00)"}}]
[null,"台面","瓷砖，豪华（数量以英尺为单位）",5,{"v":22.5,"d":"¥22.50"},{"v":40,"d":"¥40.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-17.5,"d":"(¥17.50)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":112.5,"d":"¥112.50"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-87.5,"d":"(¥87.50)"}}]
[null,"水龙头","水龙头，浴缸，标准",1,{"v":90,"d":"¥90.00"},{"v":102,"d":"¥102.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-12,"d":"(¥12.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":90,"d":"¥90.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":102,"d":"¥102.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-12,"d":"(¥12.00)"}}]
[null,"水龙头","水龙头，淋浴，单把手，标准",1,{"v":115,"d":"¥115.00"},{"v":120,"d":"¥120.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-5,"d":"(¥5.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":115,"d":"¥115.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":120,"d":"¥120.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-5,"d":"(¥5.00)"}}]
[null,"水龙头","水槽水龙头，标准",1,{"v":95,"d":"¥95.00"},{"v":107,"d":"¥107.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-12,"d":"(¥12.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":95,"d":"¥95.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":107,"d":"¥107.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-12,"d":"(¥12.00)"}}]
[null,"地板","瓷砖，标准（数量以平方英尺为单位）",35,{"v":12,"d":"¥12.00"},{"v":24,"d":"¥24.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-12,"d":"(¥12.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":420,"d":"¥420.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":840,"d":"¥840.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-420,"d":"(¥420.00)"}}]
[null,"硬件","毛巾杆，标准",2,{"v":15,"d":"¥15.00"},{"v":34,"d":"¥34.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-19,"d":"(¥19.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":30,"d":"¥30.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":68,"d":"¥68.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-38,"d":"(¥38.00)"}}]
[null,"硬件","卫生纸架",1,{"v":10,"d":"¥10.00"},{"v":13,"d":"¥13.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-3,"d":"(¥3.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":10,"d":"¥10.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":13,"d":"¥13.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-3,"d":"(¥3.00)"}}]
[null,"照明","嵌壁灯，标准",4,{"v":25,"d":"¥25.00"},{"v":44,"d":"¥44.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-19,"d":"(¥19.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":100,"d":"¥100.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":176,"d":"¥176.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-76,"d":"(¥76.00)"}}]
[null,"水槽","盥洗台，标准",2,{"v":60,"d":"¥60.00"},{"v":72,"d":"¥72.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-12,"d":"(¥12.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":120,"d":"¥120.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":144,"d":"¥144.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-24,"d":"(¥24.00)"}}]
[null,"其他",null,1,{"v":20,"d":"¥20.00"},{"v":26,"d":"¥26.00"},{"$f":"IFERROR(费用[[#This Row],[估计]]-费用[[#This Row],[实际]], \"\")","v":{"v":-6,"d":"(¥6.00)"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[估计]], \"\")","v":{"v":20,"d":"¥20.00"}},{"$f":"IFERROR(费用[[#This Row],[数量]]*费用[[#This Row],[实际]], \"\")","v":{"v":26,"d":"¥26.00"}},{"$f":"IFERROR(费用[[#This Row],[估计 ]]-费用[[#This Row],[实际 ]], \"\")","v":{"v":-6,"d":"(¥6.00)"}}]
[null,"小计",null,null,{"$f":"SUBTOTAL(109,费用[估计])","v":{"v":1464.5,"d":"¥1,464.50"}},{"$f":"SUBTOTAL(109,费用[实际])","v":{"v":1662,"d":"¥1,662.00"}},{"$f":"SUBTOTAL(109,费用[差额])","v":{"v":-197.5,"d":"(¥197.50)"}},{"$f":"SUBTOTAL(109,费用[[估计 ]])","v":{"v":2212.5,"d":"¥2,212.50"}},{"$f":"SUBTOTAL(109,费用[[实际 ]])","v":{"v":2991,"d":"¥2,991.00"}},{"$f":"SUBTOTAL(109,费用[[差额 ]])","v":{"v":-778.5,"d":"(¥778.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"}}]