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

{"sheet":"個人每月預算表","index":0,"n_rows":63,"n_cols":10,"rows_kept":63,"merged":[[1,1,1,9],[2,1,2,3],[3,1,5,1],[3,2,3,3],[3,6,4,8],[3,9,4,9],[4,2,4,3],[5,2,5,3],[5,6,6,8],[5,9,6,9],[6,1,8,1],[6,2,6,3],[7,2,7,3],[7,6,8,8],[7,9,8,9],[8,2,8,3],[21,6,21,9],[22,1,22,4],[30,6,30,9],[32,1,32,4],[37,6,37,9],[39,1,39,4],[43,6,43,9],[45,1,45,4],[49,6,49,9],[53,1,53,4],[56,6,56,9],[57,6,58,8],[57,9,58,9],[59,6,60,8],[59,9,60,9],[61,6,62,8],[61,9,62,9]]}
[]
[null,"個人每月預算表"]
[]
[null,"預計月收入","收入 1",null,{"v":2500,"d":"NT$2,500"},null,"預計餘額 (預計收入扣除支出)",null,null,{"$f":"E6-J58","v":{"v":940,"d":"NT$940"}}]
[null,null,"其他收入",null,{"v":500,"d":"NT$500"}]
[null,null,"每月總收入",null,{"$f":"SUM(E4:E5)","v":{"v":3000,"d":"NT$3,000"}},null,"實際餘額 (實際收入扣除支出)",null,null,{"$f":"E9-J60","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":"J6-J4","v":{"v":20,"d":"NT$20"}}]
[null,null,"每月總收入",null,{"$f":"SUM(E7:E8)","v":{"v":3000,"d":"NT$3,000"}}]
[]
[null,"住宅","預計成本","實際成本","差額",null,"娛樂","預計成本","實際成本","差額"]
[null,"貸款或租賃",{"v":1500,"d":"NT$1,500"},{"v":1400,"d":"NT$1,400"},{"$f":"表格1[預計成本]-表格1[實際成本]","v":{"v":100,"d":"NT$100"}},null,"錄影帶/DVD",{"v":0,"d":"NT$0"},{"v":50,"d":"NT$50"},{"$f":"表格2[預計成本]-表格2[實際成本]","v":{"v":-50,"d":"-NT$50"}}]
[null,"電信/網路",{"v":60,"d":"NT$60"},{"v":100,"d":"NT$100"},{"$f":"表格1[預計成本]-表格1[實際成本]","v":{"v":-40,"d":"-NT$40"}},null,"CD",null,null,{"$f":"表格2[預計成本]-表格2[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"電費",{"v":50,"d":"NT$50"},{"v":60,"d":"NT$60"},{"$f":"表格1[預計成本]-表格1[實際成本]","v":{"v":-10,"d":"-NT$10"}},null,"電影",null,null,{"$f":"表格2[預計成本]-表格2[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"瓦斯",{"v":200,"d":"NT$200"},{"v":180,"d":"NT$180"},{"$f":"表格1[預計成本]-表格1[實際成本]","v":{"v":20,"d":"NT$20"}},null,"音樂會",null,null,{"$f":"表格2[預計成本]-表格2[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"水費",null,null,{"$f":"表格1[預計成本]-表格1[實際成本]","v":{"v":0,"d":"NT$0"}},null,"體育賽事",null,null,{"$f":"表格2[預計成本]-表格2[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"有線電視",null,null,{"$f":"表格1[預計成本]-表格1[實際成本]","v":{"v":0,"d":"NT$0"}},null,"舞台劇",null,null,{"$f":"表格2[預計成本]-表格2[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"清潔費",null,null,{"$f":"表格1[預計成本]-表格1[實際成本]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格2[預計成本]-表格2[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"保養或維修",null,null,{"$f":"表格1[預計成本]-表格1[實際成本]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格2[預計成本]-表格2[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"生活用品",null,null,{"$f":"表格1[預計成本]-表格1[實際成本]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格2[預計成本]-表格2[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"表格1[預計成本]-表格1[實際成本]","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[預計成本]-表格8[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"車貸",{"v":250,"d":"NT$250"},{"v":250,"d":"NT$250"},{"$f":"表格3[預計成本]-表格3[實際成本]","v":{"v":0,"d":"NT$0"}},null,"學生",null,null,{"$f":"表格8[預計成本]-表格8[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"公車/計程車費用",null,null,{"$f":"表格3[預計成本]-表格3[實際成本]","v":{"v":0,"d":"NT$0"}},null,"信用卡",null,null,{"$f":"表格8[預計成本]-表格8[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"保險",null,null,{"$f":"表格3[預計成本]-表格3[實際成本]","v":{"v":0,"d":"NT$0"}},null,"信用卡",null,null,{"$f":"表格8[預計成本]-表格8[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"通行證",null,null,{"$f":"表格3[預計成本]-表格3[實際成本]","v":{"v":0,"d":"NT$0"}},null,"信用卡",null,null,{"$f":"表格8[預計成本]-表格8[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"油資",null,null,{"$f":"表格3[預計成本]-表格3[實際成本]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格8[預計成本]-表格8[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"保養",null,null,{"$f":"表格3[預計成本]-表格3[實際成本]","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[預計成本]-表格3[實際成本]","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[預計成本]-表格9[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"保險","預計成本","實際成本","差額",null,"土地/房屋",null,null,{"$f":"表格9[預計成本]-表格9[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"家用",null,null,{"$f":"表格4[預計成本]-表格4[實際成本]","v":{"v":0,"d":"NT$0"}},null,"燃料/牌照",null,null,{"$f":"表格9[預計成本]-表格9[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"健康",null,null,{"$f":"表格4[預計成本]-表格4[實際成本]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格9[預計成本]-表格9[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"人壽",null,null,{"$f":"表格4[預計成本]-表格4[實際成本]","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[預計成本]-表格4[實際成本]","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[預計成本]-表格10[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"飲食","預計成本","實際成本","差額",null,"投資帳戶",null,null,{"$f":"表格10[預計成本]-表格10[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"雜貨",null,null,{"$f":"表格5[預計成本]-表格5[實際成本]","v":{"v":0,"d":"NT$0"}},null,"其他",null,null,{"$f":"表格10[預計成本]-表格10[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"外食",null,null,{"$f":"表格5[預計成本]-表格5[實際成本]","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[預計成本]-表格5[實際成本]","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[預計成本]-表格11[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"寵物","預計成本","實際成本","差額",null,"慈善 2",null,null,{"$f":"表格11[預計成本]-表格11[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"飲食",null,null,{"$f":"表格6[預計成本]-表格6[實際成本]","v":{"v":0,"d":"NT$0"}},null,"慈善 3",null,null,{"$f":"表格11[預計成本]-表格11[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"醫療",null,null,{"$f":"表格6[預計成本]-表格6[實際成本]","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[預計成本]-表格6[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"玩具",null,null,{"$f":"表格6[預計成本]-表格6[實際成本]","v":{"v":0,"d":"NT$0"}},null,"其他","預計成本","實際成本","差額"]
[null,"其他",null,null,{"$f":"表格6[預計成本]-表格6[實際成本]","v":{"v":0,"d":"NT$0"}},null,"教育",null,null,{"$f":"表格12[預計成本]-表格12[實際成本]","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[預計成本]-表格12[實際成本]","v":{"v":0,"d":"NT$0"}}]
[{"$nulls":6},"其他",null,null,{"$f":"表格12[預計成本]-表格12[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"個人衛生","預計成本","實際成本","差額",null,"其他",null,null,{"$f":"表格12[預計成本]-表格12[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"醫療",null,null,{"$f":"表格7[預計成本]-表格7[實際成本]","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[預計成本]-表格7[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"服裝",null,null,{"$f":"表格7[預計成本]-表格7[實際成本]","v":{"v":0,"d":"NT$0"}},null,"預計總成本",null,null,{"$f":"SUM(C22,C32,C39,C45,C53,C63,H21,H30,H37,H43,H49,H56)","v":{"v":2060,"d":"NT$2,060"}}]
[null,"洗衣",null,null,{"$f":"表格7[預計成本]-表格7[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"運動",null,null,{"$f":"表格7[預計成本]-表格7[實際成本]","v":{"v":0,"d":"NT$0"}},null,"實際總成本",null,null,{"$f":"SUM(D22,D32,D39,D45,D53,D63,I21,I30,I37,I43,I49,I56)","v":{"v":2040,"d":"NT$2,040"}}]
[null,"會費",null,null,{"$f":"表格7[預計成本]-表格7[實際成本]","v":{"v":0,"d":"NT$0"}}]
[null,"其他",null,null,{"$f":"表格7[預計成本]-表格7[實際成本]","v":{"v":0,"d":"NT$0"}},null,"總差額",null,null,{"$f":"SUM(E22,E32,E39,E45,E53,E63,J21,J30,J37,J43,J49,J56)","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"}}]