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

{"sheet":"開始","index":0,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"如何使用此範本"]
[null,"使用此節日預算規劃工具追蹤您的支出。"]
[null,"若要開始，請在每個類別表格輸入預算及實際費用。"]
[null,"假日、實際花費金額，以及差異會自動計算。"]

{"sheet":"節日預算規劃工具","index":1,"n_rows":36,"n_cols":14,"rows_kept":36,"merged":[[0,2,5,7],[2,10,2,11],[8,2,8,5],[8,10,8,13],[18,2,18,5],[18,10,18,13],[29,2,29,5],[29,10,29,13]]}
[null,null,"節日預算\n規劃工具"]
[]
[{"$nulls":10},"節日預算",null,null,{"$f":"SUM(禮物[預算],包裝[預算],(旅遊[預算],(飲食[預算],(娛樂活動[預算],雜項[預算]))))","v":{"v":750,"d":"NT$750.00"}}]
[{"$nulls":10},"實際花費",null,null,{"$f":"SUM((禮物[實際],(包裝[實際],(旅遊[實際],(飲食[實際],(娛樂活動[實際],(雜項[實際])))))))","v":{"v":820,"d":"NT$820.00"}}]
[]
[{"$nulls":10},"差額 (超過/低於預算)",null,null,{"$f":"SUM(N3-N4)","v":{"v":-70,"d":"(NT$70.00)"}}]
[]
[]
[null,null,"禮物",{"$nulls":7},"節日飲食"]
[null,null,"物品","預算","實際","差額",{"$nulls":4},"物品","預算","實際","差額"]
[null,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":4},"雜貨",null,null,{"$f":"飲食[[#This Row],[預算]]-飲食[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,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":4},"獻酒",null,null,{"$f":"飲食[[#This Row],[預算]]-飲食[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"同事",null,null,{"$f":"禮物[[#This Row],[預算]]-禮物[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"佈置裝飾",null,null,{"$f":"飲食[[#This Row],[預算]]-飲食[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"教師、保姆、托嬰等",null,null,{"$f":"禮物[[#This Row],[預算]]-禮物[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"飲食[[#This Row],[預算]]-飲食[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"慈善捐款",null,null,{"$f":"禮物[[#This Row],[預算]]-禮物[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":7},{"$f":"飲食[[#This Row],[預算]]-飲食[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"禮物[[#This Row],[預算]]-禮物[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,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"}},{"$nulls":4},"合計",{"$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,"包裝",{"$nulls":7},"娛樂活動"]
[null,null,"物品","預算","實際","差額",{"$nulls":4},"物品","預算","實際","差額"]
[null,null,"禮物包裝",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"派對幫手 (調酒師、宴會承辦商、清潔人員等)",null,null,{"$f":"娛樂活動[[#This Row],[預算]]-娛樂活動[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"標籤",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"佈置裝飾",null,null,{"$f":"娛樂活動[[#This Row],[預算]]-娛樂活動[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"耗材 (緞帶、膠帶等)",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"餐點和飲料",null,null,{"$f":"娛樂活動[[#This Row],[預算]]-娛樂活動[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"包裝盒",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"服裝",null,null,{"$f":"娛樂活動[[#This Row],[預算]]-娛樂活動[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"郵資",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"票券",null,null,{"$f":"娛樂活動[[#This Row],[預算]]-娛樂活動[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"包裝[[#This Row],[預算]]-包裝[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"外出晚餐",null,null,{"$f":"娛樂活動[[#This Row],[預算]]-娛樂活動[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":10},"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"娛樂活動[[#This Row],[預算]]-娛樂活動[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,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":4},"合計",{"$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,"旅遊",{"$nulls":7},"雜項"]
[null,null,"物品","預算","實際","差額",{"$nulls":4},"物品","預算","實際","差額"]
[null,null,"機票",null,null,{"$f":"旅遊[[#This Row],[預算]]-旅遊[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"節日相片",null,null,{"$f":"雜項[[#This Row],[預算]]-雜項[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"住宿",null,null,{"$f":"旅遊[[#This Row],[預算]]-旅遊[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"瓦斯費 ",null,null,{"$f":"雜項[[#This Row],[預算]]-雜項[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"交通",null,null,{"$f":"旅遊[[#This Row],[預算]]-旅遊[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}},{"$nulls":4},"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"雜項[[#This Row],[預算]]-雜項[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,null,"其他 (此列最後一欄的索引標籤，用來新增列)",null,null,{"$f":"旅遊[[#This Row],[預算]]-旅遊[[#This Row],[實際]]","v":{"v":0,"d":"NT$0.00"}}]
[null,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":4},"合計",{"$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"}}]