{"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":9,"rows_kept":63,"merged":[[0,0,0,8],[2,5,2,6],[7,5,7,6]]}
["個人月預算"]
[]
[null,"預計支出總計","實際支出總計","差額總計",null,"預計月收入"]
[null,{"$f":"SUM(B18,B27,B33,B38,B45,B54,B63,G41,G47,G52,G57,G63)","v":{"v":1195,"d":"$1,195"}},{"$f":"SUM(C18,C27,C33,C38,C45,C54,C63,H41,H47,H52,H57,H63)","v":{"v":1236,"d":"$1,236"}},{"$f":"SUM(D18,D27,D33,D38,D45,D54,D63,I41,I47,I52,I57,I63)","v":{"v":-41,"d":"($41)"}},null,"收入 1",{"v":4300,"d":"$4,300"}]
[{"$nulls":5},"額外收入",{"v":300,"d":"$300"}]
[null,"預計支出","實際支出","差額",null,"月收入總計",{"$f":"SUM(G4:G5)","v":{"v":4600,"d":"$4,600"}}]
["居住"]
["房貸或租金",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},{"$f":"B8-C8","v":{"v":0,"d":"$0"}},null,"實際月收入"]
["電話",{"v":54,"d":"$54"},{"v":100,"d":"$100"},{"v":-46,"d":"($46)"},null,"收入 1",{"v":4000,"d":"$4,000"}]
["電",{"v":44,"d":"$44"},{"v":56,"d":"$56"},{"v":-12,"d":"($12)"},null,"額外收入",{"v":300,"d":"$300"}]
["瓦斯",{"v":22,"d":"$22"},{"v":28,"d":"$28"},{"v":-6,"d":"($6)"},null,"月收入總計",{"$f":"SUM(G9:G10)","v":{"v":4300,"d":"$4,300"}}]
["水及污水處理",{"v":8,"d":"$8"},{"v":8,"d":"$8"},{"v":0,"d":"$0"}]
["有線電視",{"v":34,"d":"$34"},{"v":34,"d":"$34"},{"v":0,"d":"$0"},null,"預計餘額\n(預計收入減去開銷)",{"$f":"G6-B4","v":{"v":3405,"d":"$3,405"}}]
["垃圾處理",{"v":10,"d":"$10"},{"v":10,"d":"$10"},{"v":0,"d":"$0"}]
["維護或修繕",{"v":23,"d":"$23"},{"v":0,"d":"$0"},{"v":23,"d":"$23"},null,"實際餘額\n(實際收入減去開銷)",{"$f":"G11-C4","v":{"v":3064,"d":"$3,064"}}]
["用品",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["其他",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},null,"差額 (實際減去預計)",{"$f":"G15-G13","v":{"v":-341,"d":"($341)"}}]
["小計",{"$f":"SUM(B8:B17)","v":{"v":1195,"d":"$1,195"}},{"$f":"SUM(C8:C17)","v":{"v":1236,"d":"$1,236"}},{"$f":"SUM(D8:D17)","v":{"v":-41,"d":"($41)"}}]
["交通費"]
["汽車罰款",null,null,{"$f":"B20-C20","v":{"v":0,"d":"$0"}}]
["公車/計程車費",null,null,{"v":0,"d":"$0"}]
["保險",null,null,{"v":0,"d":"$0"}]
["牌照",null,null,{"v":0,"d":"$0"}]
["燃料",null,null,{"v":0,"d":"$0"}]
["維護",null,null,{"v":0,"d":"$0"}]
["其他",null,null,{"v":0,"d":"$0"}]
["小計",{"$f":"SUM(B20:B26)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C20:C26)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D20:D26)","v":{"v":0,"d":"$0"}}]
["保險"]
["住家",null,null,{"$f":"B29-C29","v":{"v":0,"d":"$0"}}]
["健保",null,null,{"$f":"B30-C30","v":{"v":0,"d":"$0"}}]
["人壽",null,null,{"$f":"B31-C31","v":{"v":0,"d":"$0"}}]
["其他",null,null,{"$f":"B32-C32","v":{"v":0,"d":"$0"}}]
["小計",{"$f":"SUM(B29:B32)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C29:C32)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D29:D32)","v":{"v":0,"d":"$0"}},null,null,"預計支出","實際支出","差額"]
["食物",{"$nulls":4},"貸款"]
["雜貨",null,null,{"$f":"B35-C35","v":{"v":0,"d":"$0"}},null,"個人",null,null,{"$f":"G35-H35","v":{"v":0,"d":"$0"}}]
["外出用餐",null,null,{"$f":"B36-C36","v":{"v":0,"d":"$0"}},null,"學生",null,null,{"v":0,"d":"$0"}]
["其他",null,null,{"$f":"B37-C37","v":{"v":0,"d":"$0"}},null,"信用卡",null,null,{"v":0,"d":"$0"}]
["小計",{"$f":"SUM(B35:B37)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C35:C37)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D35:D37)","v":{"v":0,"d":"$0"}},null,"信用卡",null,null,{"v":0,"d":"$0"}]
["寵物",{"$nulls":4},"信用卡",null,null,{"v":0,"d":"$0"}]
["食物",null,null,{"$f":"B40-C40","v":{"v":0,"d":"$0"}},null,"其他",null,null,{"v":0,"d":"$0"}]
["醫療",null,null,{"$f":"B41-C41","v":{"v":0,"d":"$0"}},null,"小計",{"$f":"SUM(G35:G40)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H35:H40)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I35:I40)","v":{"v":0,"d":"$0"}}]
["修容",null,null,{"$f":"B42-C42","v":{"v":0,"d":"$0"}},null,"稅"]
["玩具",null,null,{"$f":"B43-C43","v":{"v":0,"d":"$0"}},null,"所得稅",null,null,{"$f":"G43-H43","v":{"v":0,"d":"$0"}}]
["其他",null,null,{"$f":"B44-C44","v":{"v":0,"d":"$0"}},null,"房屋稅",null,null,{"$f":"G44-H44","v":{"v":0,"d":"$0"}}]
["小計",{"$f":"SUM(B40:B44)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C40:C44)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D40:D44)","v":{"v":0,"d":"$0"}},null,"土地稅",null,null,{"$f":"G45-H45","v":{"v":0,"d":"$0"}}]
["個人保養",{"$nulls":4},"其他",null,null,{"$f":"G46-H46","v":{"v":0,"d":"$0"}}]
["醫療",null,null,{"$f":"B47-C47","v":{"v":0,"d":"$0"}},null,"小計",{"$f":"SUM(G43:G46)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H43:H46)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I43:I46)","v":{"v":0,"d":"$0"}}]
["美髮/修指甲",null,null,{"v":0,"d":"$0"},null,"存款或投資"]
["治裝",null,null,{"v":0,"d":"$0"},null,"退休帳戶",null,null,{"$f":"G49-H49","v":{"v":0,"d":"$0"}}]
["乾洗衣物",null,null,{"v":0,"d":"$0"},null,"投資帳戶",null,null,{"$f":"G50-H50","v":{"v":0,"d":"$0"}}]
["健身俱樂部",null,null,{"v":0,"d":"$0"},null,"其他",null,null,{"$f":"G51-H51","v":{"v":0,"d":"$0"}}]
["會費或規費",null,null,{"v":0,"d":"$0"},null,"小計",{"$f":"SUM(G49:G51)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H49:H51)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I49:I51)","v":{"v":0,"d":"$0"}}]
["其他",null,null,{"v":0,"d":"$0"},null,"禮物及捐贈"]
["小計",{"$f":"SUM(B47:B53)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C47:C53)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D47:D53)","v":{"v":0,"d":"$0"}},null,"捐款 1",null,null,{"$f":"G54-H54","v":{"v":0,"d":"$0"}}]
["娛樂",{"$nulls":4},"捐款 2",null,null,{"$f":"G55-H55","v":{"v":0,"d":"$0"}}]
["錄影帶/DVD",null,null,{"$f":"B56-C56","v":{"v":0,"d":"$0"}},null,"捐款 3",null,null,{"$f":"G56-H56","v":{"v":0,"d":"$0"}}]
["CD",null,null,{"v":0,"d":"$0"},null,"小計",{"$f":"SUM(G54:G56)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H54:H56)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I54:I56)","v":{"v":0,"d":"$0"}}]
["電影",null,null,{"v":0,"d":"$0"},null,"法務"]
["音樂會",null,null,{"v":0,"d":"$0"},null,"律師",null,null,{"$f":"G59-H59","v":{"v":0,"d":"$0"}}]
["體育活動",null,null,{"v":0,"d":"$0"},null,"贍養費",null,null,{"$f":"G60-H60","v":{"v":0,"d":"$0"}}]
["現場劇院",null,null,{"v":0,"d":"$0"},null,"扣押或審判款",null,null,{"$f":"G61-H61","v":{"v":0,"d":"$0"}}]
["其他",null,null,{"v":0,"d":"$0"},null,"其他",null,null,{"$f":"G62-H62","v":{"v":0,"d":"$0"}}]
["小計",{"$f":"SUM(B56:B62)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C56:C62)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D56:D62)","v":{"v":0,"d":"$0"}},null,"小計",{"$f":"SUM(G59:G62)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H59:H62)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I59:I62)","v":{"v":0,"d":"$0"}}]