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

{"sheet":"個人每月預算","index":0,"n_rows":64,"n_cols":10,"rows_kept":64,"merged":[[1,1,1,9],[2,1,2,9],[4,1,6,1],[4,2,4,3],[4,6,5,8],[4,9,5,9],[5,2,5,3],[6,2,6,3],[6,6,7,8],[6,9,7,9],[7,1,9,1],[7,2,7,3],[8,2,8,3],[8,6,9,8],[8,9,9,9],[9,2,9,3],[22,6,22,9],[23,1,23,4],[31,6,31,9],[33,1,33,4],[38,6,38,9],[40,1,40,4],[44,6,44,9],[46,1,46,4],[50,6,50,9],[54,1,54,4],[57,6,57,9],[58,6,59,8],[58,9,59,9],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9]]}
[]
[null,"個人每月預算"]
[]
[]
[null,"預計每月收入","收入 1",null,{"v":2500,"d":"NT$2,500"},null,"預計餘額 (預計收入扣除支出)",null,null,{"$f":"E7-J59","v":{"v":940,"d":"NT$940"}}]
[null,null,"額外收入",null,{"v":500,"d":"NT$500"}]
[null,null,"每月總收入",null,{"$f":"SUM(E5:E6)","v":{"v":3000,"d":"NT$3,000"}},null,"實際餘額 (實際收入扣除支出)",null,null,{"$f":"E10-J61","v":{"v":960,"d":"NT$960"}}]
[null,"實際每月收入","收入 1",null,{"v":2500,"d":"NT$2,500"}]
[null,null,"額外收入",null,{"v":500,"d":"NT$500"},null,"差額 (實際扣除預計)",null,null,{"$f":"J7-J5","v":{"v":20,"d":"NT$20"}}]
[null,null,"每月總收入",null,{"$f":"SUM(E8:E9)","v":{"v":3000,"d":"NT$3,000"}}]
[]
[null,"住宅","預計支出","實際支出","差額",null,"娛樂","預計支出","實際支出","差額"]
[null,"貸款或房租",{"v":1500,"d":"NT$1,500"},{"v":1400,"d":"NT$1,400"},{"$f":"表格1[[#This Row],[預計支出]]-表格1[[#This Row],[實際支出]]","v":{"v":100,"d":"NT$100"}},null,"錄影帶/DVD",{"v":0,"d":"NT$0"},{"v":50,"d":"NT$50"},{"$f":"表格2[[#This Row],[預計支出]]-表格2[[#This Row],[實際支出]]","v":{"v":-50,"d":"-NT$50"}}]
[null,"電話",{"v":60,"d":"NT$60"},{"v":100,"d":"NT$100"},{"$f":"表格1[[#This Row],[預計支出]]-表格1[[#This Row],[實際支出]]","v":{"v":-40,"d":"-NT$40"}},null,"CD",null,null,{"$f":"表格2[[#This Row],[預計支出]]-表格2[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"電費",{"v":50,"d":"NT$50"},{"v":60,"d":"NT$60"},{"$f":"表格1[[#This Row],[預計支出]]-表格1[[#This Row],[實際支出]]","v":{"v":-10,"d":"-NT$10"}},null,"電影",null,null,{"$f":"表格2[[#This Row],[預計支出]]-表格2[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"瓦斯費",{"v":200,"d":"NT$200"},{"v":180,"d":"NT$180"},{"$f":"表格1[[#This Row],[預計支出]]-表格1[[#This Row],[實際支出]]","v":{"v":20,"d":"NT$20"}},null,"演唱會",null,null,{"$f":"表格2[[#This Row],[預計支出]]-表格2[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"水費和汙水處理費",null,null,{"$f":"表格1[[#This Row],[預計支出]]-表格1[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"體育活動",null,null,{"$f":"表格2[[#This Row],[預計支出]]-表格2[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"有線電視",null,null,{"$f":"表格1[[#This Row],[預計支出]]-表格1[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"舞臺劇",null,null,{"$f":"表格2[[#This Row],[預計支出]]-表格2[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"垃圾處理",null,null,{"$f":"表格1[[#This Row],[預計支出]]-表格1[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格2[[#This Row],[預計支出]]-表格2[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"保養或維修",null,null,{"$f":"表格1[[#This Row],[預計支出]]-表格1[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格2[[#This Row],[預計支出]]-表格2[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"日用品",null,null,{"$f":"表格1[[#This Row],[預計支出]]-表格1[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格2[[#This Row],[預計支出]]-表格2[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"表格1[[#This Row],[預計支出]]-表格1[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,表格2[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格2[實際支出])","v":{"v":50,"d":"NT$50"}},{"$f":"SUBTOTAL(109,表格2[差額])","v":{"v":-50,"d":"-NT$50"}}]
[null,"合計",{"$f":"SUBTOTAL(109,表格1[預計支出])","v":{"v":1810,"d":"NT$1,810"}},{"$f":"SUBTOTAL(109,表格1[實際支出])","v":{"v":1740,"d":"NT$1,740"}},{"$f":"SUBTOTAL(109,表格1[差額])","v":{"v":70,"d":"NT$70"}}]
[{"$nulls":6},"貸款","預計支出","實際支出","差額"]
[null,"交通","預計支出","實際支出","差額",null,"個人",null,null,{"$f":"表格8[[#This Row],[預計支出]]-表格8[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"汽車還款",{"v":250,"d":"NT$250"},{"v":250,"d":"NT$250"},{"$f":"表格3[[#This Row],[預計支出]]-表格3[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"助學貸款",null,null,{"$f":"表格8[[#This Row],[預計支出]]-表格8[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"公車/計程車費",null,null,{"$f":"表格3[[#This Row],[預計支出]]-表格3[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"信用卡",null,null,{"$f":"表格8[[#This Row],[預計支出]]-表格8[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"保險",null,null,{"$f":"表格3[[#This Row],[預計支出]]-表格3[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"信用卡",null,null,{"$f":"表格8[[#This Row],[預計支出]]-表格8[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"牌照",null,null,{"$f":"表格3[[#This Row],[預計支出]]-表格3[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"信用卡",null,null,{"$f":"表格8[[#This Row],[預計支出]]-表格8[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"燃料",null,null,{"$f":"表格3[[#This Row],[預計支出]]-表格3[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格8[[#This Row],[預計支出]]-表格8[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"保養",null,null,{"$f":"表格3[[#This Row],[預計支出]]-表格3[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,表格8[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格8[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格8[差額])","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"表格3[[#This Row],[預計支出]]-表格3[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"合計",{"$f":"SUBTOTAL(109,表格3[預計支出])","v":{"v":250,"d":"NT$250"}},{"$f":"SUBTOTAL(109,表格3[實際支出])","v":{"v":250,"d":"NT$250"}},{"$f":"SUBTOTAL(109,表格3[差額])","v":{"v":0,"d":"NT$0"}},null,"稅金","預計支出","實際支出","差額"]
[{"$nulls":6},"聯邦稅",null,null,{"$f":"表格9[[#This Row],[預計支出]]-表格9[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"保險","預計支出","實際支出","差額",null,"州稅",null,null,{"$f":"表格9[[#This Row],[預計支出]]-表格9[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"住宅險",null,null,{"$f":"表格4[[#This Row],[預計支出]]-表格4[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"地方稅",null,null,{"$f":"表格9[[#This Row],[預計支出]]-表格9[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"醫療險",null,null,{"$f":"表格4[[#This Row],[預計支出]]-表格4[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格9[[#This Row],[預計支出]]-表格9[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"壽險",null,null,{"$f":"表格4[[#This Row],[預計支出]]-表格4[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,表格9[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格9[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格9[差額])","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"表格4[[#This Row],[預計支出]]-表格4[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"合計",{"$f":"SUBTOTAL(109,表格4[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格4[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格4[差額])","v":{"v":0,"d":"NT$0"}},null,"儲蓄或投資","預計支出","實際支出","差額"]
[{"$nulls":6},"退休帳戶",null,null,{"$f":"表格10[[#This Row],[預計支出]]-表格10[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"伙食","預計支出","實際支出","差額",null,"投資帳戶",null,null,{"$f":"表格10[[#This Row],[預計支出]]-表格10[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"雜貨",null,null,{"$f":"表格5[[#This Row],[預計支出]]-表格5[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格10[[#This Row],[預計支出]]-表格10[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"外食",null,null,{"$f":"表格5[[#This Row],[預計支出]]-表格5[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,表格10[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格10[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格10[差額])","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"表格5[[#This Row],[預計支出]]-表格5[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"合計",{"$f":"SUBTOTAL(109,表格5[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格5[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格5[差額])","v":{"v":0,"d":"NT$0"}},null,"禮物與捐款","預計支出","實際支出","差額"]
[{"$nulls":6},"慈善機構 1",null,null,{"$f":"表格11[[#This Row],[預計支出]]-表格11[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"寵物","預計支出","實際支出","差額",null,"慈善機構 2",null,null,{"$f":"表格11[[#This Row],[預計支出]]-表格11[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"伙食",null,null,{"$f":"表格6[[#This Row],[預計支出]]-表格6[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"慈善機構 3",null,null,{"$f":"表格11[[#This Row],[預計支出]]-表格11[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"醫療",null,null,{"$f":"表格6[[#This Row],[預計支出]]-表格6[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,表格11[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格11[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格11[差額])","v":{"v":0,"d":"NT$0"}}]
[null,"寵物美容",null,null,{"$f":"表格6[[#This Row],[預計支出]]-表格6[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"玩具",null,null,{"$f":"表格6[[#This Row],[預計支出]]-表格6[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"法律","預計支出","實際支出","差額"]
[null,"其他",null,null,{"$f":"表格6[[#This Row],[預計支出]]-表格6[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"律師",null,null,{"$f":"表格12[[#This Row],[預計支出]]-表格12[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"合計",{"$f":"SUBTOTAL(109,表格6[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格6[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格6[差額])","v":{"v":0,"d":"NT$0"}},null,"贍養費",null,null,{"$f":"表格12[[#This Row],[預計支出]]-表格12[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[{"$nulls":6},"留置權或判決的款項",null,null,{"$f":"表格12[[#This Row],[預計支出]]-表格12[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"個人保健","預計支出","實際支出","差額",null,"其他",null,null,{"$f":"表格12[[#This Row],[預計支出]]-表格12[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"醫療",null,null,{"$f":"表格7[[#This Row],[預計支出]]-表格7[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"合計",{"$f":"SUBTOTAL(109,表格12[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格12[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格12[差額])","v":{"v":0,"d":"NT$0"}}]
[null,"剪髮/美甲",null,null,{"$f":"表格7[[#This Row],[預計支出]]-表格7[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"服裝",null,null,{"$f":"表格7[[#This Row],[預計支出]]-表格7[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"總預計支出",null,null,{"$f":"SUM(C23,C33,C40,C46,C54,C64,H22,H31,H38,H44,H50,H57)","v":{"v":2060,"d":"NT$2,060"}}]
[null,"乾洗",null,null,{"$f":"表格7[[#This Row],[預計支出]]-表格7[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"健康俱樂部",null,null,{"$f":"表格7[[#This Row],[預計支出]]-表格7[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"總實際支出",null,null,{"$f":"SUM(D23,D33,D40,D46,D54,D64,I22,I31,I38,I44,I50,I57)","v":{"v":2040,"d":"NT$2,040"}}]
[null,"社團會費或費用",null,null,{"$f":"表格7[[#This Row],[預計支出]]-表格7[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"表格7[[#This Row],[預計支出]]-表格7[[#This Row],[實際支出]]","v":{"v":0,"d":"NT$0"}},null,"總差額",null,null,{"$f":"SUM(E23,E33,E40,E46,E54,E64,J22,J31,J38,J44,J50,J57)","v":{"v":20,"d":"NT$20"}}]
[null,"合計",{"$f":"SUBTOTAL(109,表格7[預計支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格7[實際支出])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,表格7[差額])","v":{"v":0,"d":"NT$0"}}]