{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["摘要","月收入","月支出","月儲蓄","圖表資料"],"not_rendered":{"charts":2,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"摘要","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[2,1,9,1],[2,3,10,7]]}
[null,"個人預算"]
[null,"收入支出百分比","摘要"]
[null,{"$f":"百分比_收入_支出","v":{"v":0.6229333333333333,"d":"62%"}},"月總收入","此儲存格中的直條圖會顯示月總收入與月總支出。"]
[null,null,{"$f":"SUM(月收入[[#All],[金額]])","v":{"v":3750,"d":"NT$3,750"}}]
[null,null,"月總支出"]
[null,null,{"$f":"SUM(月支出[[#All],[金額]])","v":{"v":2336,"d":"NT$2,336"}}]
[null,null,"月總儲蓄"]
[null,null,{"$f":"SUM(儲蓄[[#All],[金額]])","v":{"v":550,"d":"NT$550"}}]
[null,null,"現金餘額"]
[null,null,{"$f":"月總收入-月總支出-月總儲蓄","v":{"v":864,"d":"NT$864"}}]

{"sheet":"月收入","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"預算標題","v":"個人預算"}]
[null,"月收入"]
[null,"項目","金額"]
[null,"收入來源 1",{"v":2500,"d":"NT$2,500.00"}]
[null,"收入來源 2",{"v":1000,"d":"NT$1,000.00"}]
[null,"其他",{"v":250,"d":"NT$250.00"}]

{"sheet":"月支出","index":2,"n_rows":16,"n_cols":4,"rows_kept":16}
[null,{"$f":"預算標題","v":"個人預算"}]
[null,"月支出"]
[null,"項目","繳款期限","金額"]
[null,"房租/房貸","日期",{"v":800,"d":"NT$800.00"}]
[null,"電費","日期",{"v":120,"d":"NT$120.00"}]
[null,"瓦斯費","日期",{"v":50,"d":"NT$50.00"}]
[null,"手機","日期",{"v":45,"d":"NT$45.00"}]
[null,"雜貨","日期",{"v":500,"d":"NT$500.00"}]
[null,"車貸","日期",{"v":273,"d":"NT$273.00"}]
[null,"汽車支出","日期",{"v":120,"d":"NT$120.00"}]
[null,"助學貸款","日期",{"v":50,"d":"NT$50.00"}]
[null,"信用卡","日期",{"v":100,"d":"NT$100.00"}]
[null,"汽車保險","日期",{"v":78,"d":"NT$78.00"}]
[null,"個人保健","日期",{"v":50,"d":"NT$50.00"}]
[null,"娛樂活動","日期",{"v":100,"d":"NT$100.00"}]
[null,"雜項","日期",{"v":50,"d":"NT$50.00"}]

{"sheet":"月儲蓄","index":3,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"預算標題","v":"個人預算"}]
[null,"月儲蓄"]
[null,"日期","金額"]
[null,"日期",{"v":200,"d":"NT$200.00"}]
[null,"日期",{"v":250,"d":"NT$250.00"}]
[null,"日期",{"v":100,"d":"NT$100.00"}]

{"sheet":"圖表資料","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"hidden":true}
[]
[null,"圖表資料"]
[]
[null,{"$f":"MIN(1,1-B5)","v":{"v":0.37706666666666666,"d":"38%"}}]
[null,{"$f":"MIN(月總支出/月總收入,1)","v":{"v":0.6229333333333333,"d":"62%"}}]
[null,{"$f":"(月總支出/月總收入)>1","v":false}]