{"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},"支出細目 (NT$)",null,null,"總成本 (NT$)"]
[null,"區域","項目","數量","預估","實際","差額","預估 ","實際 ","差額 "]
[null,"浴缸/淋浴","浴缸，鑄鐵，5 英呎，標準",1,{"v":250,"d":"NT$250.00"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":253,"d":"NT$253.00"}},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-3,"d":"(NT$3.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":250,"d":"NT$250.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":253,"d":"NT$253.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-3,"d":"(NT$3.00)"}}]
[null,"浴缸/淋浴","淋浴間門板，絞鏈門，標準",1,{"v":200,"d":"NT$200.00"},{"v":202,"d":"NT$202.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-2,"d":"(NT$2.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":200,"d":"NT$200.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":202,"d":"NT$202.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-2,"d":"(NT$2.00)"}}]
[null,"浴缸/淋浴","蓮蓬頭，標準",1,{"v":50,"d":"NT$50.00"},{"v":66,"d":"NT$66.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-16,"d":"(NT$16.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":50,"d":"NT$50.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":66,"d":"NT$66.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-16,"d":"(NT$16.00)"}}]
[null,"浴缸/淋浴","浴缸周圍牆面，標準",1,{"v":200,"d":"NT$200.00"},{"v":206,"d":"NT$206.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-6,"d":"(NT$6.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":200,"d":"NT$200.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":206,"d":"NT$206.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-6,"d":"(NT$6.00)"}}]
[null,"收納櫃","24 吋藥櫃，豪華",1,{"v":200,"d":"NT$200.00"},{"v":218,"d":"NT$218.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-18,"d":"(NT$18.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":200,"d":"NT$200.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":218,"d":"NT$218.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-18,"d":"(NT$18.00)"}}]
[null,"收納櫃","30 吋梳妝臺組，標準",2,{"v":100,"d":"NT$100.00"},{"v":104,"d":"NT$104.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-4,"d":"(NT$4.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":200,"d":"NT$200.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":208,"d":"NT$208.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-8,"d":"(NT$8.00)"}}]
[null,"洗手台","磁磚，豪華 (數量以直線距離的英呎計算)",5,{"v":22.5,"d":"NT$22.50"},{"v":41,"d":"NT$41.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-18.5,"d":"(NT$18.50)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":112.5,"d":"NT$112.50"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":205,"d":"NT$205.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-92.5,"d":"(NT$92.50)"}}]
[null,"水龍頭","水龍頭，浴缸，標準",1,{"v":90,"d":"NT$90.00"},{"v":102,"d":"NT$102.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-12,"d":"(NT$12.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":90,"d":"NT$90.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":102,"d":"NT$102.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-12,"d":"(NT$12.00)"}}]
[null,"水龍頭","水龍頭，淋浴，單把手，標準",1,{"v":115,"d":"NT$115.00"},{"v":123,"d":"NT$123.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-8,"d":"(NT$8.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":115,"d":"NT$115.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":123,"d":"NT$123.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-8,"d":"(NT$8.00)"}}]
[null,"水龍頭","水槽水龍頭，標準",1,{"v":95,"d":"NT$95.00"},{"v":106,"d":"NT$106.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-11,"d":"(NT$11.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":95,"d":"NT$95.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":106,"d":"NT$106.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-11,"d":"(NT$11.00)"}}]
[null,"地板","磁磚，標準 (數量以平方英呎計算)",35,{"v":12,"d":"NT$12.00"},{"v":23,"d":"NT$23.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-11,"d":"(NT$11.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":420,"d":"NT$420.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":805,"d":"NT$805.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-385,"d":"(NT$385.00)"}}]
[null,"硬體","毛巾架，標準",2,{"v":15,"d":"NT$15.00"},{"v":21,"d":"NT$21.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-6,"d":"(NT$6.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":30,"d":"NT$30.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":42,"d":"NT$42.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-12,"d":"(NT$12.00)"}}]
[null,"硬體","衛生紙架",1,{"v":10,"d":"NT$10.00"},{"v":17,"d":"NT$17.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-7,"d":"(NT$7.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":10,"d":"NT$10.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":17,"d":"NT$17.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-7,"d":"(NT$7.00)"}}]
[null,"照明","嵌燈，標準",4,{"v":25,"d":"NT$25.00"},{"v":43,"d":"NT$43.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-18,"d":"(NT$18.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":100,"d":"NT$100.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":172,"d":"NT$172.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-72,"d":"(NT$72.00)"}}]
[null,"水槽","盥洗室，標準",2,{"v":60,"d":"NT$60.00"},{"v":70,"d":"NT$70.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-10,"d":"(NT$10.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":120,"d":"NT$120.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":140,"d":"NT$140.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-20,"d":"(NT$20.00)"}}]
[null,"其他",null,1,{"v":20,"d":"NT$20.00"},{"v":28,"d":"NT$28.00"},{"$f":"IFERROR(成本[[#This Row],[預估]]-成本[[#This Row],[實際]], \"\")","v":{"v":-8,"d":"(NT$8.00)"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[預估]], \"\")","v":{"v":20,"d":"NT$20.00"}},{"$f":"IFERROR(成本[[#This Row],[數量]]*成本[[#This Row],[實際]], \"\")","v":{"v":28,"d":"NT$28.00"}},{"$f":"IFERROR(成本[[#This Row],[預估 ]]-成本[[#This Row],[實際 ]], \"\")","v":{"v":-8,"d":"(NT$8.00)"}}]
[null,"小計",null,null,{"$f":"SUBTOTAL(109,成本[預估])","v":{"v":1464.5,"d":"NT$1,464.50"}},{"$f":"SUBTOTAL(109,成本[實際])","v":{"v":1623,"d":"NT$1,623.00"}},{"$f":"SUBTOTAL(109,成本[差額])","v":{"v":-158.5,"d":"(NT$158.50)"}},{"$f":"SUBTOTAL(109,成本[[預估 ]])","v":{"v":2212.5,"d":"NT$2,212.50"}},{"$f":"SUBTOTAL(109,成本[[實際 ]])","v":{"v":2893,"d":"NT$2,893.00"}},{"$f":"SUBTOTAL(109,成本[[差額 ]])","v":{"v":-680.5,"d":"(NT$680.50)"}}]
[]
[null,"非預期成本 (預估外加 30%)",null,null,{"$f":"IFERROR(成本[[#Totals],[預估]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"NT$439.35"}},null,null,{"$f":"IFERROR(成本[[#Totals],[預估 ]]*0.3, \"\")","v":{"v":663.75,"d":"NT$663.75"}}]
[null,"總成本",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"NT$1,464.50"}},null,null,{"$f":"IFERROR(SUM(成本[[#Totals],[預估 ]],溢額), \"\")","v":{"v":2876.25,"d":"NT$2,876.25"}}]