{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["支出預算"],"not_rendered":{"charts":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"支出預算","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"merged":[[0,1,0,4],[0,5,0,6],[16,1,16,6],[47,1,47,6]]}
[null,"支出預算",{"$nulls":3},"CONTOSO，2013 年"]
[]
[]
[null," 人事預算"]
{"$rows_empty":7}
[null,"狀態","人事","預算","實際","差額","差異百分比"]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[實際]]/tblPersonnelExpenses[[#This Row],[預算]],\"\")","v":{"v":1.13,"d":"$1.13"}},"辦公室",{"v":15000,"d":"NT$15,000.00"},{"v":16950,"d":"NT$16,950.00"},{"$f":"tblPersonnelExpenses[[#This Row],[預算]]-tblPersonnelExpenses[[#This Row],[實際]]","v":{"v":-1950,"d":"-NT$1,950.00"}},{"$f":"IFERROR(tblPersonnelExpenses[差額]/tblPersonnelExpenses[預算],\"\")","v":{"v":-0.13,"d":"-13%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[實際]]/tblPersonnelExpenses[[#This Row],[預算]],\"\")","v":{"v":1.2,"d":"$1.20"}},"商店",{"v":3750,"d":"NT$3,750.00"},{"v":4500,"d":"NT$4,500.00"},{"$f":"tblPersonnelExpenses[[#This Row],[預算]]-tblPersonnelExpenses[[#This Row],[實際]]","v":{"v":-750,"d":"-NT$750.00"}},{"$f":"IFERROR(tblPersonnelExpenses[差額]/tblPersonnelExpenses[預算],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[實際]]/tblPersonnelExpenses[[#This Row],[預算]],\"\")","v":{"v":1,"d":"$1.00"}},"銷售人員",{"v":3000,"d":"NT$3,000.00"},{"v":3000,"d":"NT$3,000.00"},{"$f":"tblPersonnelExpenses[[#This Row],[預算]]-tblPersonnelExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblPersonnelExpenses[差額]/tblPersonnelExpenses[預算],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblPersonnelExpenses[[#This Row],[實際]]/tblPersonnelExpenses[[#This Row],[預算]],\"\")","v":{"v":0.9,"d":"$0.90"}},"其他",{"v":3000,"d":"NT$3,000.00"},{"v":2700,"d":"NT$2,700.00"},{"$f":"tblPersonnelExpenses[[#This Row],[預算]]-tblPersonnelExpenses[[#This Row],[實際]]","v":{"v":300,"d":"NT$300.00"}},{"$f":"IFERROR(tblPersonnelExpenses[差額]/tblPersonnelExpenses[預算],\"\")","v":{"v":0.1,"d":"10%"}}]
[]
[]
[null," 營運預算"]
{"$rows_empty":7}
[null,"狀態","營運","預算","實際","差額","差異百分比"]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":{"v":0.98,"d":"$0.98"}},"廣告",{"v":7500,"d":"NT$7,500.00"},{"v":7350,"d":"NT$7,350.00"},{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":150,"d":"NT$150.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":{"v":0.02,"d":"2%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":{"v":1.2,"d":"$1.20"}},"負債",{"v":3750,"d":"NT$3,750.00"},{"v":4500,"d":"NT$4,500.00"},{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":-750,"d":"-NT$750.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":{"v":-0.2,"d":"-20%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":{"v":1,"d":"$1.00"}},"津貼",{"v":3000,"d":"NT$3,000.00"},{"v":3000,"d":"NT$3,000.00"},{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":{"v":0,"d":"0%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":{"v":0.9,"d":"$0.90"}},"辦公用品",{"v":3000,"d":"NT$3,000.00"},{"v":2700,"d":"NT$2,700.00"},{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":300,"d":"NT$300.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":{"v":0.1,"d":"10%"}}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"郵資",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"房租或房貸",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"銷售費用",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"稅款",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"水電費",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"其他",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"保險",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"利息",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"電話",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"保養維修",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"法律費",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"折舊",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"運費",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"儲存",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[實際]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""},"其他",null,null,{"$f":"tblOperatingExpenses[[#This Row],[預算]]-tblOperatingExpenses[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(tblOperatingExpenses[[#This Row],[差額]]/tblOperatingExpenses[[#This Row],[預算]],\"\")","v":""}]
[null,null,"總支出",{"$f":"SUBTOTAL(109,tblOperatingExpenses[預算],tblPersonnelExpenses[預算])","v":{"v":42000,"d":"NT$42,000.00"}},{"$f":"SUBTOTAL(109,tblOperatingExpenses[實際],tblPersonnelExpenses[實際])","v":{"v":44700,"d":"NT$44,700.00"}},{"$f":"SUBTOTAL(109,tblOperatingExpenses[差額],tblPersonnelExpenses[差額])","v":{"v":-2700,"d":"-NT$2,700.00"}},{"$f":"IFERROR(SUM(tblOperatingExpenses[[#Totals],[差額]]/tblOperatingExpenses[[#Totals],[預算]]),\"\")","v":{"v":-0.06428571428571428,"d":"-6%"}}]