{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["開始","節日預算規劃工具"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"關於此範本"]
[null,"使用此節日預算規劃工具追蹤您的支出。"]
[null,"在表格的各個項目上輸入預算和產生的實際支出。"]
[null,"會為您自動計算節日預算、花費的實際總金額與差額。"]
[null,"附註： "]
[null,"我們已在「節日預算規劃工具」工作表的 A 欄提供額外指示。此文字已刻意隱藏。若要移除文字，請選取欄 A，然後選取 [刪除]。若要取消隱藏文字，請選取 A 欄，然後變更字型色彩。"]
[null,"若要深入了解表格，請在表格內按 SHIFT 並按 F10，選取 [表格] 選項，然後選取 [替代文字]。"]

{"sheet":"節日預算規劃工具","index":1,"n_rows":32,"n_cols":12,"rows_kept":32,"merged":[[1,1,5,4],[2,8,2,9],[3,8,3,9],[4,8,4,9],[6,1,6,4],[6,8,6,11],[15,1,15,4],[15,8,15,11],[25,1,25,4],[25,8,25,11]]}
["在此工作表的個別表格中輸入各類別的預算和實際支出。您可以在此欄的儲存格中找到有關如何使用此工作表的實用指示。按向下箭號以開始。 "]
["右側儲存格為此工作表的標題。","節日預算規劃工具"]
["儲存格 K3 會自動計算節日預算。",{"$nulls":7},"節日預算",null,{"$f":"SUM(禮物[預算],包裝[預算],(旅遊[預算],(飲食[預算],(娛樂[預算],其他[預算]))))","v":{"v":750,"d":"NT$750.00"}}]
["儲存格 K4 會自動計算實際花費。",{"$nulls":7},"實際花費",null,{"$f":"SUM((禮物[實際],(包裝[實際],(旅遊[實際],(飲食[實際],(娛樂[實際],(其他[實際])))))))","v":{"v":820,"d":"NT$820.00"}}]
["儲存格 K5 會自動計算差額。下一個指示位於儲存格 A7。",{"$nulls":7},"差額 (超過/低於預算)",null,{"$f":"SUM(K3-K4)","v":{"v":-70,"d":"(NT$70.00)"}}]
[]
["右側儲存格為禮物標籤，而儲存格 I7 為節日飲食標籤。","禮物",{"$nulls":6},"節日飲食"]
["在從右側儲存格開始的表格中輸入禮物支出，並在從儲存格 I8 開始的表格中輸入飲食支出。下一個指示位於儲存格 A16。","項目","預算","實際","差額",{"$nulls":3},"項目","預算","實際","差額"]
[null,"家人",{"v":500,"d":"NT$500.00"},{"v":495,"d":"NT$495.00"},{"$f":"禮物[[#This Row],[預算]]-禮物[[#This Row],[實際]]","v":{"v":5,"d":"NT$5.00"}},{"$nulls":3},"雜貨",null,null,{"$f":"飲食[[#This Row],[預算]]-飲食[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"好友",{"v":250,"d":"NT$250.00"},{"v":325,"d":"NT$325.00"},{"$f":"禮物[[#This Row],[預算]]-禮物[[#This Row],[實際]]","v":{"v":-75,"d":"-NT$75.00"}},{"$nulls":3},"獻酒",null,null,{"$f":"飲食[[#This Row],[預算]]-飲食[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"同事",null,null,{"$f":"禮物[[#This Row],[預算]]-禮物[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"佈置裝飾",null,null,{"$f":"飲食[[#This Row],[預算]]-飲食[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"教師、保姆、托嬰等",null,null,{"$f":"禮物[[#This Row],[預算]]-禮物[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"飲食[[#This Row],[預算]]-飲食[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"慈善捐款",null,null,{"$f":"禮物[[#This Row],[預算]]-禮物[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"合計",{"$f":"SUBTOTAL(109,飲食[預算])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,飲食[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,飲食[差額])","v":{"v":0,"d":"NT$0.00"}}]
[null,"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"禮物[[#This Row],[預算]]-禮物[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"合計",{"$f":"SUBTOTAL(109,禮物[預算])","v":{"v":750,"d":"NT$750.00"}},{"$f":"SUBTOTAL(109,禮物[實際])","v":{"v":820,"d":"NT$820.00"}},{"$f":"SUBTOTAL(109,禮物[差額])","v":{"v":-70,"d":"-NT$70.00"}}]
["右側儲存格為包裝標籤，而儲存格 I16 為娛樂標籤。","包裝",{"$nulls":6},"娛樂"]
["在從右側儲存格開始的表格中輸入包裝支出，並在從儲存格 I17 開始的表格中輸入娛樂支出。下一個指示位於儲存格 A26。","項目","預算","實際","差額",{"$nulls":3},"項目","預算","實際","差額"]
[null,"禮物包裝",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"派對幫手 (調酒師、宴會承辦商、清潔人員等)",null,null,{"$f":"娛樂[[#This Row],[預算]]-娛樂[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"標籤",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"佈置裝飾",null,null,{"$f":"娛樂[[#This Row],[預算]]-娛樂[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"耗材 (緞帶、膠帶等)",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"餐點和飲料",null,null,{"$f":"娛樂[[#This Row],[預算]]-娛樂[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"包裝盒",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"服裝",null,null,{"$f":"娛樂[[#This Row],[預算]]-娛樂[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"郵資",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"票券",null,null,{"$f":"娛樂[[#This Row],[預算]]-娛樂[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"外出晚餐",null,null,{"$f":"娛樂[[#This Row],[預算]]-娛樂[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"合計",{"$f":"SUBTOTAL(109,包裝[預算])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,包裝[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,包裝[差額])","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"娛樂[[#This Row],[預算]]-娛樂[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":8},"合計",{"$f":"SUBTOTAL(109,娛樂[預算])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,娛樂[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,娛樂[差額])","v":{"v":0,"d":"NT$0.00"}}]
["右側儲存格為旅遊標籤，而儲存格 I26 為其他標籤。","旅遊",{"$nulls":6},"其他"]
["在從右側儲存格開始的表格中輸入旅遊支出，並在從儲存格 I27 開始的表格中輸入其他支出。","項目","預算","實際","差額",{"$nulls":3},"項目","預算","實際","差額"]
[null,"機票",null,null,{"$f":"旅遊[[#This Row],[預算]]-旅遊[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"節日相片",null,null,{"$f":"其他[[#This Row],[預算]]-其他[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"住宿",null,null,{"$f":"旅遊[[#This Row],[預算]]-旅遊[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"瓦斯費 ",null,null,{"$f":"其他[[#This Row],[預算]]-其他[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"交通",null,null,{"$f":"旅遊[[#This Row],[預算]]-旅遊[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"其他[[#This Row],[預算]]-其他[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"旅遊[[#This Row],[預算]]-旅遊[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":3},"合計",{"$f":"SUBTOTAL(109,其他[預算])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,其他[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,其他[差額])","v":{"v":0,"d":"NT$0.00"}}]
[null,"合計",{"$f":"SUBTOTAL(109,旅遊[預算])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,旅遊[實際])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,旅遊[差額])","v":{"v":0,"d":"NT$0.00"}}]