{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["開始","個人每月預算"],"not_rendered":{"images":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":66,"n_cols":10,"rows_kept":66,"merged":[[3,1,3,2],[3,4,4,6],[3,7,4,7],[5,4,6,6],[5,7,6,7],[7,4,8,6],[7,7,8,7],[8,1,8,2],[24,6,24,9],[25,1,25,4],[33,6,33,9],[35,1,35,4],[40,6,40,9],[42,1,42,4],[46,6,46,9],[48,1,48,4],[52,6,52,9],[56,1,56,4],[59,6,59,9],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9],[64,6,65,8],[64,9,65,9],[66,1,66,4]]}
["在此工作表中建立個人每月預算。您可以在此欄的儲存格中找到有關如何使用此工作表的實用指示。按向下箭號以開始。"]
["右側儲存格是此工作表的標題。下一個指示在儲存格 A5。",null,"個人每月預算"]
[]
["右側儲存格為每月的預計收入標籤。在儲存格 C5 中輸入收入 1 並在 C6 中輸入額外收入，以在 C7 中計算每月總收入。下一個指示在儲存格 A7。","預計月收入",null,null,"預計餘額\n(預計收入減去支出)",null,null,{"$f":"C7-J61","v":{"v":3405,"d":"NT$3,405.00"}}]
[null,"收入 1",{"v":4300,"d":"NT$4,300.00"}]
[null,"額外收入",{"v":300,"d":"NT$300.00"},null,"實際餘額\n(實際收入減去支出)",null,null,{"$f":"C12-J63","v":{"v":3064,"d":"NT$3,064.00"}}]
["儲存格 H4 會自動計算預計餘額、H6 會自動計算實際餘額，而 H8 會自動計算差額。下一個指示在儲存格 A9。","月總收入",{"$f":"SUM(C5:C6)","v":{"v":4600,"d":"NT$4,600.00"}}]
[{"$nulls":4},"差額\n(實際減去預計)",null,null,{"$f":"H6-H4","v":{"v":-341,"d":"(NT$341.00)"}}]
["右側儲存格為每月的實際收入標籤。在儲存格 C10 中輸入收入 1 並在 C11 中輸入額外收入，以在 C12 中計算每月總收入。下一個指示在儲存格 A14。","月實際收入"]
[null,"收入 1",{"v":4000,"d":"NT$4,000.00"}]
[null,"額外收入",{"v":300,"d":"NT$300.00"}]
[null,"每月總收入",{"$f":"SUM(C10:C11)","v":{"v":4300,"d":"NT$4,300.00"}}]
[]
["在從右側儲存格開始的 [住宅] 表格中輸入詳細資料，並在從儲存格 G14 開始的 [娛樂活動] 表格中輸入詳細資料。下一個指示在儲存格 A27。","住宅","預計支出","實際支出","差額",null,"娛樂活動","預計支出","實際支出","差額"]
[null,"貸款或房租",{"v":1000,"d":"NT$1,000.00"},{"v":1000,"d":"NT$1,000.00"},{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}},null,"錄影帶/DVD",null,null,{"$f":"娛樂活動[[#This Row],[預計支出]]-娛樂活動[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"電話",{"v":54,"d":"NT$54.00"},{"v":100,"d":"NT$100.00"},{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":-46,"d":"-NT$46.00"}},null,"CD",null,null,{"$f":"娛樂活動[[#This Row],[預計支出]]-娛樂活動[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"電費",{"v":44,"d":"NT$44.00"},{"v":56,"d":"NT$56.00"},{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":-12,"d":"-NT$12.00"}},null,"電影",null,null,{"$f":"娛樂活動[[#This Row],[預計支出]]-娛樂活動[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"瓦斯費",{"v":22,"d":"NT$22.00"},{"v":28,"d":"NT$28.00"},{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":-6,"d":"-NT$6.00"}},null,"演唱會",null,null,{"$f":"娛樂活動[[#This Row],[預計支出]]-娛樂活動[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"水費和汙水處理費",{"v":8,"d":"NT$8.00"},{"v":8,"d":"NT$8.00"},{"$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"}}]
[null,"有線電視",{"v":34,"d":"NT$34.00"},{"v":34,"d":"NT$34.00"},{"$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"}}]
[null,"垃圾處理",{"v":10,"d":"NT$10.00"},{"v":10,"d":"NT$10.00"},{"$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"}}]
[null,"保養或維修",{"v":23,"d":"NT$23.00"},{"v":0,"d":"NT$0.00"},{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":23,"d":"NT$23.00"}},null,"其他",null,null,{"$f":"娛樂活動[[#This Row],[預計支出]]-娛樂活動[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"日用品",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$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"}}]
[null,"其他",{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}},null,"小計",null,null,{"$f":"SUBTOTAL(109,娛樂活動[差額])","v":{"v":0,"d":"NT$0.00"}}]
[null,"小計",null,null,{"$f":"SUBTOTAL(109,住宅[差額])","v":{"v":-41,"d":"-NT$41.00"}}]
[{"$nulls":6},"貸款","預計支出","實際支出","差額"]
["在從右側儲存格開始的 [交通] 表格中輸入詳細資料，並在從儲存格 G26 開始的 [貸款] 表格中輸入詳細資料。下一個指示在儲存格 A37。","交通","預計支出","實際支出","差額",null,"個人",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"}},null,"助學貸款",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"}},null,"信用卡",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"}},null,"信用卡",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"}},null,"信用卡",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"}},null,"其他",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"}},null,"小計",null,null,{"$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,"小計",null,null,{"$f":"SUBTOTAL(109,交通[差額])","v":{"v":0,"d":"NT$0.00"}},null,"稅金","預計支出","實際支出","差額"]
[{"$nulls":6},"聯邦稅",null,null,{"$f":"稅金[[#This Row],[預計支出]]-稅金[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}}]
["在從右側儲存格開始的 [保險] 表格中輸入詳細資料，並在從儲存格 G35 開始的 [稅金] 表格中輸入詳細資料。下一個指示在儲存格 A44。","保險","預計支出","實際支出","差額",null,"州稅",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"}},null,"地方稅",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"}},null,"其他",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"}},null,"小計",null,null,{"$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,"小計",null,null,{"$f":"SUBTOTAL(109,保險[差額])","v":{"v":0,"d":"NT$0.00"}},null,"儲蓄或投資","預計支出","實際支出","差額"]
[{"$nulls":6},"退休帳戶",null,null,{"$f":"儲蓄[[#This Row],[預計支出]]-儲蓄[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}}]
["在從右側儲存格開始的 [伙食] 表格中輸入詳細資料，並在從儲存格 G42 開始的 [儲蓄] 表格中輸入詳細資料。下一個指示在儲存格 A50。","伙食","預計支出","實際支出","差額",null,"投資帳戶",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"}},null,"其他",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"}},null,"小計",null,null,{"$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,"小計",null,null,{"$f":"SUBTOTAL(109,伙食[差額])","v":{"v":0,"d":"NT$0.00"}},null,"禮物和捐款","預計支出","實際支出","差額"]
[{"$nulls":6},"慈善機構 1",null,null,{"$f":"禮物[[#This Row],[預計支出]]-禮物[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}}]
["在從右側儲存格開始的 [寵物] 表格中輸入詳細資料，並在從儲存格 G48 開始的 [禮物] 表格中輸入詳細資料。下一個指示在儲存格 A58。","寵物","預計支出","實際支出","差額",null,"慈善機構 2",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"}},null,"慈善機構 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"}},null,"小計",null,null,{"$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,"玩具",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,null,{"$f":"法律[[#This Row],[預計支出]]-法律[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}}]
[null,"小計",null,null,{"$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"}}]
[{"$nulls":6},"留置權或判決的款項",null,null,{"$f":"法律[[#This Row],[預計支出]]-法律[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}}]
["在從右側儲存格開始的 [個人保健] 表格中輸入詳細資料，並在從儲存格 G54 開始的 [法律] 表格中輸入詳細資料。下一個指示在儲存格 A61。","個人保健","預計支出","實際支出","差額",null,"其他",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"}},null,"小計",null,null,{"$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"}}]
["儲存格 J61 會自動計算總預計支出，儲存格 J63 會自動計算實際支出，而儲存格 J65 會自動計算總差額。","服裝",null,null,{"$f":"個人保健[[#This Row],[預計支出]]-個人保健[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0.00"}},null,"總預計支出",null,null,{"$f":"SUBTOTAL(109,住宅[預計支出],交通[預計支出],保險[預計支出],伙食[預計支出],寵物[預計支出],個人保健[預計支出],娛樂活動[預計支出],貸款[預計支出],稅金[預計支出],儲蓄[預計支出],禮物[預計支出],法律[預計支出])","v":{"v":1195,"d":"NT$1,195.00"}}]
[null,"乾洗",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"}},null,"總實際支出",null,null,{"$f":"SUBTOTAL(109,住宅[實際支出],交通[實際支出],保險[實際支出],伙食[實際支出],寵物[實際支出],個人保健[實際支出],娛樂活動[實際支出],貸款[實際支出],稅金[實際支出],儲蓄[實際支出],禮物[實際支出],法律[實際支出])","v":{"v":1236,"d":"NT$1,236.00"}}]
[null,"社團會費或費用",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"}},null,"總差額",null,null,{"$f":"J61-J63","v":{"v":-41,"d":"(NT$41.00)"}}]
[null,"小計",null,null,{"$f":"SUBTOTAL(109,個人保健[差額])","v":{"v":0,"d":"NT$0.00"}}]