{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["個人每月預算"],"read":"whole","date_system":"1900"}

{"sheet":"個人每月預算","index":0,"n_rows":62,"n_cols":10,"rows_kept":62,"merged":[[0,1,0,9],[2,1,4,1],[2,2,2,3],[2,7,2,8],[3,2,3,3],[3,7,3,8],[4,2,4,3],[4,6,4,8],[5,1,7,1],[5,2,5,3],[5,7,5,8],[6,2,6,3],[6,7,6,8],[7,2,7,3],[7,6,7,8],[20,6,20,9],[21,1,21,4],[29,6,29,9],[31,1,31,4],[36,6,36,9],[38,1,38,4],[42,6,42,9],[44,1,44,4],[48,6,48,9],[52,1,52,4],[55,6,55,9]]}
[null,"個人每月預算"]
[]
[null,"預計每月收入","收入 1",null,{"v":2500,"d":"NT$2,500"},null,"預計總支出 ","(預計收入減支出)",null,{"$f":"SUM(C21,C31,C38,C44,C52,C62,H20,H29,H36,H42,H48,H55)","v":{"v":2060,"d":"NT$2,060"}}]
[null,null,"額外收入",null,{"v":500,"d":"NT$500"},null,"實際總支出 ","(實際收入減支出)",null,{"$f":"SUM(D21,D31,D38,D44,D52,D62,I20,I29,I36,I42,I48,I55)","v":{"v":2040,"d":"NT$2,040"}}]
[null,null,"每月總收入",null,{"$f":"SUM(E3:E4)","v":{"v":3000,"d":"NT$3,000"}},null,"總支出差額",null,null,{"$f":"SUM(E21,E31,E38,E44,E52,E62,J20,J29,J36,J42,J48,J55)","v":{"v":20,"d":"NT$20"}}]
[null,"實際每月收入","收入 1",null,{"v":2500,"d":"NT$2,500"},null,"預計餘額","(預計收入減支出)",null,{"$f":"E5-J3","v":{"v":940,"d":"NT$940"}}]
[null,null,"額外收入",null,{"v":500,"d":"NT$500"},null,"實際餘額","(實際收入減支出)",null,{"$f":"E8-J4","v":{"v":960,"d":"NT$960"}}]
[null,null,"每月總收入",null,{"$f":"SUM(E6:E7)","v":{"v":3000,"d":"NT$3,000"}},null,"餘額差額 (實際扣除預計)",null,null,{"$f":"J7-J6","v":{"v":20,"d":"NT$20"}}]
[]
[null,"住宅","預計支出","實際支出","差額",null,"娛樂","預計支出","實際支出","差額"]
[null,"貸款或房租",{"v":1500,"d":"NT$1,500"},{"v":1400,"d":"NT$1,400"},{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":100,"d":"NT$100"}},null,"錄影帶/DVD",{"v":0,"d":"NT$0"},{"v":50,"d":"NT$50"},{"$f":"娛樂[[#This Row],[預計支出]]-娛樂[[#This Row],[實際支出]]","v":{"v":-50,"d":"-NT$50"}}]
[null,"電話",{"v":60,"d":"NT$60"},{"v":100,"d":"NT$100"},{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":-40,"d":"-NT$40"}},null,"CD",null,null,{"$f":"娛樂[[#This Row],[預計支出]]-娛樂[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"電費",{"v":50,"d":"NT$50"},{"v":60,"d":"NT$60"},{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":-10,"d":"-NT$10"}},null,"電影",null,null,{"$f":"娛樂[[#This Row],[預計支出]]-娛樂[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"瓦斯費",{"v":200,"d":"NT$200"},{"v":180,"d":"NT$180"},{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":20,"d":"NT$20"}},null,"演唱會",null,null,{"$f":"娛樂[[#This Row],[預計支出]]-娛樂[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"水費和汙水處理費",null,null,{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"體育活動",null,null,{"$f":"娛樂[[#This Row],[預計支出]]-娛樂[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"有線電視",null,null,{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"舞臺劇",null,null,{"$f":"娛樂[[#This Row],[預計支出]]-娛樂[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"垃圾處理",null,null,{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"娛樂[[#This Row],[預計支出]]-娛樂[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"保養或維修",null,null,{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"娛樂[[#This Row],[預計支出]]-娛樂[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"日用品",null,null,{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"娛樂[[#This Row],[預計支出]]-娛樂[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"住宅[[#This Row],[預計支出]]-住宅[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,娛樂[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,娛樂[實際支出])","v":{"v":50,"d":"NT$50"}},{"$f":"SUBTOTAL(109,娛樂[差額])","v":{"v":-50,"d":"-NT$50"}}]
[null,"合計",{"$f":"SUBTOTAL(109,住宅[預計支出])","v":{"v":1810,"d":"NT$1,810"}},{"$f":"SUBTOTAL(109,住宅[實際支出])","v":{"v":1740,"d":"NT$1,740"}},{"$f":"SUBTOTAL(109,住宅[差額])","v":{"v":70,"d":"NT$70"}}]
[{"$nulls":6},"貸款","預計支出","實際支出","差額"]
[null,"交通","預計支出","實際支出","差額",null,"個人",null,null,{"$f":"貸款[[#This Row],[預計支出]]-貸款[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"汽車還款",{"v":250,"d":"NT$250"},{"v":250,"d":"NT$250"},{"$f":"交通[[#This Row],[預計支出]]-交通[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"助學貸款",null,null,{"$f":"貸款[[#This Row],[預計支出]]-貸款[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"公車/計程車費",null,null,{"$f":"交通[[#This Row],[預計支出]]-交通[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"信用卡",null,null,{"$f":"貸款[[#This Row],[預計支出]]-貸款[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"保險",null,null,{"$f":"交通[[#This Row],[預計支出]]-交通[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"信用卡",null,null,{"$f":"貸款[[#This Row],[預計支出]]-貸款[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"牌照",null,null,{"$f":"交通[[#This Row],[預計支出]]-交通[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"信用卡",null,null,{"$f":"貸款[[#This Row],[預計支出]]-貸款[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"燃料",null,null,{"$f":"交通[[#This Row],[預計支出]]-交通[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"貸款[[#This Row],[預計支出]]-貸款[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"保養",null,null,{"$f":"交通[[#This Row],[預計支出]]-交通[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,貸款[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,貸款[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,貸款[差額])","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"交通[[#This Row],[預計支出]]-交通[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"合計",{"$f":"SUBTOTAL(109,交通[預計支出])","v":{"v":250,"d":"NT$250"}},{"$f":"SUBTOTAL(109,交通[實際支出])","v":{"v":250,"d":"NT$250"}},{"$f":"SUBTOTAL(109,交通[差額])","v":{"v":0,"d":"NT$0"}},null,"稅金","預計支出","實際支出","差額"]
[{"$nulls":6},"聯邦稅",null,null,{"$f":"稅金[[#This Row],[預計支出]]-稅金[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"保險","預計支出","實際支出","差額",null,"州稅",null,null,{"$f":"稅金[[#This Row],[預計支出]]-稅金[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"住宅險",null,null,{"$f":"保險[[#This Row],[預計支出]]-保險[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"地方稅",null,null,{"$f":"稅金[[#This Row],[預計支出]]-稅金[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"醫療險",null,null,{"$f":"保險[[#This Row],[預計支出]]-保險[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"稅金[[#This Row],[預計支出]]-稅金[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"壽險",null,null,{"$f":"保險[[#This Row],[預計支出]]-保險[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,稅金[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,稅金[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,稅金[差額])","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"保險[[#This Row],[預計支出]]-保險[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"合計",{"$f":"SUBTOTAL(109,保險[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,保險[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,保險[差額])","v":{"v":0,"d":"NT$0"}},null,"儲蓄或投資","預計支出","實際支出","差額"]
[{"$nulls":6},"退休帳戶",null,null,{"$f":"儲蓄或投資[[#This Row],[預計支出]]-儲蓄或投資[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"伙食","預計支出","實際支出","差額",null,"投資帳戶",null,null,{"$f":"儲蓄或投資[[#This Row],[預計支出]]-儲蓄或投資[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"雜貨",null,null,{"$f":"伙食[[#This Row],[預計支出]]-伙食[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"儲蓄或投資[[#This Row],[預計支出]]-儲蓄或投資[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"外食",null,null,{"$f":"伙食[[#This Row],[預計支出]]-伙食[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,儲蓄或投資[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,儲蓄或投資[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,儲蓄或投資[差額])","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"伙食[[#This Row],[預計支出]]-伙食[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"合計",{"$f":"SUBTOTAL(109,伙食[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,伙食[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,伙食[差額])","v":{"v":0,"d":"NT$0"}},null,"禮物與捐款","預計支出","實際支出","差額"]
[{"$nulls":6},"慈善機構 1",null,null,{"$f":"禮物與捐款[[#This Row],[預計支出]]-禮物與捐款[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"寵物","預計支出","實際支出","差額",null,"慈善機構 2",null,null,{"$f":"禮物與捐款[[#This Row],[預計支出]]-禮物與捐款[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"伙食",null,null,{"$f":"寵物[[#This Row],[預計支出]]-寵物[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"慈善機構 3",null,null,{"$f":"禮物與捐款[[#This Row],[預計支出]]-禮物與捐款[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"醫療",null,null,{"$f":"寵物[[#This Row],[預計支出]]-寵物[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,禮物與捐款[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,禮物與捐款[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,禮物與捐款[差額])","v":{"v":0,"d":"NT$0"}}]
[null,"寵物美容",null,null,{"$f":"寵物[[#This Row],[預計支出]]-寵物[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"玩具",null,null,{"$f":"寵物[[#This Row],[預計支出]]-寵物[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"法律","預計支出","實際支出","差額"]
[null,"其他",null,null,{"$f":"寵物[[#This Row],[預計支出]]-寵物[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"律師",null,null,{"$f":"法律[[#This Row],[預計支出]]-法律[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"合計",{"$f":"SUBTOTAL(109,寵物[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,寵物[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,寵物[差額])","v":{"v":0,"d":"NT$0"}},null,"贍養費",null,null,{"$f":"法律[[#This Row],[預計支出]]-法律[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[{"$nulls":6},"留置權或判決的款項",null,null,{"$f":"法律[[#This Row],[預計支出]]-法律[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"個人保健","預計支出","實際支出","差額",null,"其他",null,null,{"$f":"法律[[#This Row],[預計支出]]-法律[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"醫療",null,null,{"$f":"個人保健[[#This Row],[預計支出]]-個人保健[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,法律[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,法律[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,法律[差額])","v":{"v":0,"d":"NT$0"}}]
[null,"剪髮/美甲",null,null,{"$f":"個人保健[[#This Row],[預計支出]]-個人保健[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"服裝",null,null,{"$f":"個人保健[[#This Row],[預計支出]]-個人保健[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"乾洗",null,null,{"$f":"個人保健[[#This Row],[預計支出]]-個人保健[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"健康俱樂部",null,null,{"$f":"個人保健[[#This Row],[預計支出]]-個人保健[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"社團會費或費用",null,null,{"$f":"個人保健[[#This Row],[預計支出]]-個人保健[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"個人保健[[#This Row],[預計支出]]-個人保健[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"合計",{"$f":"SUBTOTAL(109,個人保健[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,個人保健[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,個人保健[差額])","v":{"v":0,"d":"NT$0"}}]