{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["開始","禮物預算與追蹤工具","資料"],"not_rendered":{"charts":1,"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":10,"n_cols":13,"rows_kept":10,"merged":[[0,1,0,4],[0,5,0,12],[1,1,1,2],[2,1,2,12],[3,1,3,3]]}
["在此工作表中建立個人禮物預算和追蹤工具。右側儲存格是工作表標題，而儲存格 F1 是提示。您可以在此欄的儲存格中找到有關如何使用此工作表的實用指示。","禮物預算與追蹤工具",{"$nulls":3},"在新的一年開始時，請盡可能填寫。輸入親朋好友的姓名、選取禮物場合、選取活動月份，然後輸入您想要花費的金額。對於每個不同的場合 (生日、假期、派對等)，每個人可能會在表格中出現多次。"]
["右側儲存格是每月概觀標籤，而儲存格 D2 是提示。","每月概觀",null,"使用圖表查看未來的月份，以便提前規劃。記錄您的購買項目，以追蹤您的預算。"]
["右側儲存格是預算金額的直條圖，其上覆蓋花費金額的折線圖。","此儲存格是預算金額的直條圖，其上覆蓋花費金額的折線圖。"]
["禮物預算和追蹤工具標籤位於右邊的儲存格中。","禮物預算與追蹤工具"]
["在從右側儲存格開始的 [預算追蹤工具] 表格中，輸入詳細資料。","送禮對象","場合","月份","金額\n已設定預算","金額\n已花費","禮物","禮物連結","商店/\n網路","已購買?","已包裝?","已送達?","附註"]
[null,"姓名 1","生日","六月",{"v":50,"d":"NT$50"},{"v":30,"d":"NT$30"},"鞋子","賣方","網路","是","否","否","6/16，電影票"]
[null,"姓名 2","紀念日","四月",{"v":20,"d":"NT$20"},{"v":20,"d":"NT$20"},"貓咪","賣方","商店","否","否","否","他提到自己喜歡狗"]
[null,"姓名 3","假日","七月",{"v":50,"d":"NT$50"},{"v":70,"d":"NT$70"},"耳機","賣方","網路","否","否","否","宿舍的東西"]
[null,"姓名 4","生日","一月",{"v":20,"d":"NT$20"},{"v":30,"d":"NT$30"},"遊戲","賣方","商店","是","是","是"]
[null,"姓名 5","婚禮","六月",{"v":100,"d":"NT$100"},{"v":150,"d":"NT$150"},"水晶瓶","賣方","商店","是","是","否"]

{"sheet":"資料","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"hidden":true}
["場合",null,"日期","日期","預算金額\n生日","預算金額\n假日","預算金額\n其他","已花費的金額"]
["生日",null,"一月","1 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"一月\",預算追蹤工具[場合],\"生日\")","v":{"v":20,"d":"NT$20"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"一月\",預算追蹤工具[場合],\"假日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"一月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"一月\")","v":{"v":30,"d":"NT$30"}}]
["假日",null,"二月","2 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"二月\",預算追蹤工具[場合],\"生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"二月\",預算追蹤工具[場合],\"假日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"二月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"二月\")","v":{"v":0,"d":"NT$0"}}]
["紀念日",null,"三月","3 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"三月\",預算追蹤工具[場合],\"生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"三月\",預算追蹤工具[場合],\"假日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"三月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"三月\")","v":{"v":0,"d":"NT$0"}}]
["婚禮",null,"四月","4 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"四月\",預算追蹤工具[場合],\"生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"四月\",預算追蹤工具[場合],\"假日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"四月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":20,"d":"NT$20"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"四月\")","v":{"v":20,"d":"NT$20"}}]
["婚前單身派對",null,"五月","5 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"五月\",預算追蹤工具[場合],\"生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"五月\",預算追蹤工具[場合],\"假日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"五月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"五月\")","v":{"v":0,"d":"NT$0"}}]
["產前派對",null,"六月","6 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"六月\",預算追蹤工具[場合],\"生日\")","v":{"v":50,"d":"NT$50"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"六月\",預算追蹤工具[場合],\"假日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"六月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":100,"d":"NT$100"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"六月\")","v":{"v":180,"d":"NT$180"}}]
["畢業",null,"七月","7 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"七月\",預算追蹤工具[場合],\"生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"七月\",預算追蹤工具[場合],\"假日\")","v":{"v":50,"d":"NT$50"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"七月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"七月\")","v":{"v":70,"d":"NT$70"}}]
["其他",null,"八月","8 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"八月\",預算追蹤工具[場合],\"生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"八月\",預算追蹤工具[場合],\"假日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"八月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"八月\")","v":{"v":0,"d":"NT$0"}}]
[null,null,"九月","9 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"九月\",預算追蹤工具[場合],\"生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"九月\",預算追蹤工具[場合],\"假日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"九月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"九月\")","v":{"v":0,"d":"NT$0"}}]
[null,null,"十月","10 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"十月\",預算追蹤工具[場合],\"生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"十月\",預算追蹤工具[場合],\"假日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"十月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"十月\")","v":{"v":0,"d":"NT$0"}}]
[null,null,"十一月","11 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"十一月\",預算追蹤工具[場合],\"生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"十一月\",預算追蹤工具[場合],\"假日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"十一月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"十一月\")","v":{"v":0,"d":"NT$0"}}]
[null,null,"十二月","12 月",{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"十二月\",預算追蹤工具[場合],\"生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"十二月\",預算追蹤工具[場合],\"假日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已設定預算],預算追蹤工具[月份],\"十二月\",預算追蹤工具[場合],\"<>假日\",預算追蹤工具[場合],\"<>生日\")","v":{"v":0,"d":"NT$0"}},{"$f":"SUMIFS(預算追蹤工具[金額\n已花費],預算追蹤工具[月份],\"十二月\")","v":{"v":0,"d":"NT$0"}}]