{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["預算摘要","月收入","月支出","學期支出"],"not_rendered":{"charts":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"預算摘要","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[0,1,0,4],[1,1,1,2],[1,4,9,4],[3,1,3,2]]}
[null,"我的大學生活預算"]
[null,"收入支出百分比",null,null,"此儲存格為比較月收入和月支出的群組直條圖。"]
[null,{"$f":"月淨支出/月淨收入","v":{"v":0.6436363636363637,"d":"64%"}}]
[null,{"$f":"月淨支出","v":1770}]
[null,"月淨收入"]
[null,{"$f":"總計_月收入","v":{"v":2750,"d":"HK$2,750"}}]
[null,"月淨支出"]
[null,{"$f":"總計_月支出+總計_學期支出","v":{"v":1770,"d":"HK$1,770"}}]
[null,"餘額"]
[null,{"$f":"月淨收入-月淨支出","v":{"v":980,"d":"HK$980"}}]

{"sheet":"月收入","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[0,1,0,4]]}
[null,{"$f":"活頁簿_標題","v":"我的大學生活預算"}]
[null,"月收入"]
[null,"項目","金額"]
[null,"固定收入",{"v":1500,"d":"HK$1,500"}]
[null,"獎助學金",{"v":500,"d":"HK$500"}]
[null,"貸款",{"v":500,"d":"HK$500"}]
[null,"其他收入",{"v":250,"d":"HK$250"}]
[null,"合計",{"$f":"SUBTOTAL(109,月收入[金額])","v":{"v":2750,"d":"HK$2,750"}}]

{"sheet":"月支出","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[0,1,0,4]]}
[null,{"$f":"活頁簿_標題","v":"我的大學生活預算"}]
[null,"月支出"]
[null,"項目","金額"]
[null,"房租",{"v":20,"d":"HK$20"}]
[null,"公用事業費用",{"v":50,"d":"HK$50"}]
[null,"手機",{"v":75,"d":"HK$75"}]
[null,"雜貨",{"v":250,"d":"HK$250"}]
[null,"汽車支出",{"v":50,"d":"HK$50"}]
[null,"助學貸款",{"v":500,"d":"HK$500"}]
[null,"信用卡",{"v":275,"d":"HK$275"}]
[null,"保險",{"v":125,"d":"HK$125"}]
[null,"理髮",{"v":50,"d":"HK$50"}]
[null,"娛樂",{"v":0,"d":"HK$0"}]
[null,"雜項",{"v":0,"d":"HK$0"}]
[null,"合計",{"$f":"SUBTOTAL(109,月支出[金額])","v":{"v":1395,"d":"HK$1,395"}}]

{"sheet":"學期支出","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"merged":[[0,1,0,5],[10,1,10,2]]}
[null,{"$f":"活頁簿_標題","v":"我的大學生活預算"}]
[null,"學期支出 *"]
[null,"項目","金額","每月"]
[null,"學費",{"v":750,"d":"HK$750"},{"$f":"IFERROR(學期支出[[#This Row],[金額]]/4, \"\")","v":{"v":187.5,"d":"HK$188"}}]
[null,"實驗室費用",{"v":250,"d":"HK$250"},{"$f":"IFERROR(學期支出[[#This Row],[金額]]/4, \"\")","v":{"v":62.5,"d":"HK$63"}}]
[null,"書籍",{"v":500,"d":"HK$500"},{"$f":"IFERROR(學期支出[[#This Row],[金額]]/4, \"\")","v":{"v":125,"d":"HK$125"}}]
[null,"存款",{"v":0,"d":"HK$0"},{"$f":"IFERROR(學期支出[[#This Row],[金額]]/4, \"\")","v":{"v":0,"d":"HK$0"}}]
[null,"交通",{"v":0,"d":"HK$0"},{"$f":"IFERROR(學期支出[[#This Row],[金額]]/4, \"\")","v":{"v":0,"d":"HK$0"}}]
[null,"其他費用",{"v":0,"d":"HK$0"},{"$f":"IFERROR(學期支出[[#This Row],[金額]]/4, \"\")","v":{"v":0,"d":"HK$0"}}]
[null,"合計",{"$f":"SUBTOTAL(109,學期支出[金額])","v":{"v":1500,"d":"HK$1,500"}},{"$f":"SUBTOTAL(109,學期支出[每月])","v":{"v":375,"d":"HK$375"}}]
[null,"* 預設 4 個月為一學期"]