{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["期數","學分","預算","每月淨支出","學期支出","書籍"],"not_rendered":{"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"期數","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[2,3,2,4]]}
[null,"我的課程表"]
[null,"秋季學期"]
[null,null,"開始時間","時間間隔",null,"年份"]
[null,null,"09:00:00",60,"(分鐘)"]
[null,"時間 ","週一","週二","週三","週四","週五","週六","週日"]
[null,{"$f":"開始時間+_xlfn.SINGLE(TIME(0,(ROW(A1)-1)*時間間隔,0))","v":"09:00:00"},"早餐","早餐","早餐","早餐","早餐"]
[null,"10:00:00","商業︰教學大樓 B 棟 256 室"]
[null,"11:00:00",{"$nulls":3},"物理︰實驗室\nJ 棟 309 室"]
[null,"12:00:00"]
[null,"13:00:00"]
[null,"14:00:00"]
[null,"15:00:00"]
[null,"16:00:00"]
[null,"17:00:00"]
[null,"18:00:00"]
[null,"19:00:00"]
[null,"20:00:00"]
[null,"21:00:00"]
[null,"22:00:00"]
[null,"23:00:00"]
[null,1]
[null,1.0416666666666665]
[null,1.0833333333333335]
[null,1.125]
[null,1.1666666666666665]
[null,1.2083333333333335]
[null,1.25]
[null,1.2916666666666665]
[null,1.3333333333333335]

{"sheet":"學分","index":1,"n_rows":17,"n_cols":8,"rows_kept":17}
[null,"系所"]
[null,"學分規劃工具"]
[null,"學位名稱",{"$f":"年份","v":"年份"}]
[null,"整體進度",null,"整體進度"]
[null,{"$f":"AVERAGE(課程[成績])","v":3.5},{"$f":"IFERROR(TEXT(AVERAGEIF(課程[是否修完],\"是\",課程[成績]),\"0.00\"),\"0.00\")&\" 目前 GPA\"","v":"3.50 目前 GPA"},{"$f":"COUNTIF(課程[是否修完],\"是\")/COUNTA(課程[課程名稱])","v":0.6666666666666666},{"$f":"TEXT(COUNTIF(課程[是否修完],\"是\")/COUNTA(課程[課程名稱]),\"0%\")&\" 已完成\"","v":"67% 已完成"}]
[null,"附註：下列學分摘要是系統根據您在下方的「系統課程」表格中輸入的內容自動填入"]
[null,"需求","總學分","已修得的學分","尚未修得的必要學分"]
[null,"主修",{"$f":"IF(SUMIF(課程[需求],學分!$B8,課程[學分])=0,\"0\",SUMIF(課程[需求],學分!$B8,課程[學分]))","v":4},{"$f":"SUMIFS(課程[學分],課程[需求],學分!$B8,課程[是否修完],\"是\")","v":4},{"$f":"SUMIF(課程[需求],學分!$B8,課程[學分])-SUMIFS(課程[學分],課程[需求],學分!$B8,課程[是否修完],\"是\")","v":0}]
[null,"副修",{"$f":"IF(SUMIF(課程[需求],學分!$B9,課程[學分])=0,\"0\",SUMIF(課程[需求],學分!$B9,課程[學分]))","v":3},{"$f":"SUMIFS(課程[學分],課程[需求],學分!$B9,課程[是否修完],\"是\")","v":0},{"$f":"SUMIF(課程[需求],學分!$B9,課程[學分])-SUMIFS(課程[學分],課程[需求],學分!$B9,課程[是否修完],\"是\")","v":3}]
[null,"選修課程",{"$f":"IF(SUMIF(課程[需求],學分!$B10,課程[學分])=0,\"0\",SUMIF(課程[需求],學分!$B10,課程[學分]))","v":2},{"$f":"SUMIFS(課程[學分],課程[需求],學分!$B10,課程[是否修完],\"是\")","v":2},{"$f":"SUMIF(課程[需求],學分!$B10,課程[學分])-SUMIFS(課程[學分],課程[需求],學分!$B10,課程[是否修完],\"是\")","v":0}]
[null,"通識課程",{"$f":"IF(SUMIF(課程[需求],學分!$B11,課程[學分])=0,\"0\",SUMIF(課程[需求],學分!$B11,課程[學分]))","v":"0"},{"$f":"SUMIFS(課程[學分],課程[需求],學分!$B11,課程[是否修完],\"是\")","v":0},{"$f":"SUMIF(課程[需求],學分!$B11,課程[學分])-SUMIFS(課程[學分],課程[需求],學分!$B11,課程[是否修完],\"是\")","v":0}]
[null,"總計",{"$f":"SUBTOTAL(109,學分!$C$8:$C$11)","v":9},{"$f":"SUBTOTAL(109,學分!$D$8:$D$11)","v":6},{"$f":"SUBTOTAL(109,學分!$E$8:$E$11)","v":3}]
[null,"課程"]
[null,"課程名稱","課程編號","需求","學分","是否修完","成績","學期"]
[null,"課程 1","編號","主修",4,"是",{"v":4,"d":"4.0"},"第 1 學期"]
[null,"課程 2","編號","副修",3,"否",null,"第 1 學期"]
[null,"課程 3","編號","選修課程",2,"是",{"v":3,"d":"3.0"},"第 1 學期"]

{"sheet":"預算","index":2,"n_rows":15,"n_cols":4,"rows_kept":15}
[null,{"$f":"系所","v":"系所"}]
[null,"預算追蹤工具"]
[null,"我的預算",{"$f":"年份","v":"年份"}]
[null,"支出佔收入百分比"]
[null,{"$f":"淨_月_支出/淨_月_收入","v":{"v":0.7454545454545455,"d":"75%"}}]
[null,{"$f":"B5","v":0.7454545454545455}]
[null,"每月淨收入","每月淨支出","餘額"]
[null,{"$f":"C10","v":{"v":2750,"d":"NT$2,750"}},{"$f":"每月淨支出!C4+學期支出!D4","v":{"v":2050,"d":"NT$2,050"}},{"$f":"淨_月_收入-淨_月_支出","v":{"v":700,"d":"NT$700"}}]
[null,"學期月數",4]
[null,"月收入",{"$f":"SUM(MonthlyIncome[金額])","v":{"v":2750,"d":"NT$2,750"}}]
[null,"項目","金額"]
[null,"固定收入",{"v":1500,"d":"NT$1,500"}]
[null,"獎助學金",{"v":500,"d":"NT$500"}]
[null,"貸款",{"v":500,"d":"NT$500"}]
[null,"其他收入",{"v":250,"d":"NT$250"}]

{"sheet":"每月淨支出","index":3,"n_rows":15,"n_cols":3,"rows_kept":15}
[null,{"$f":"系所","v":"系所"}]
[null,"預算追蹤工具"]
[null,"月支出",{"$f":"年份","v":"年份"}]
[null,"月支出",{"$f":"SUM(MonthlyExpenses[金額])","v":{"v":1675,"d":"NT$1,675"}}]
[null,"項目","金額"]
[null,"房租",{"v":300,"d":"NT$300"}]
[null,"公用事業費用",{"v":50,"d":"NT$50"}]
[null,"手機",{"v":75,"d":"NT$75"}]
[null,"雜貨",{"v":250,"d":"NT$250"}]
[null,"汽車支出",{"v":50,"d":"NT$50"}]
[null,"助學貸款",{"v":500,"d":"NT$500"}]
[null,"信用卡",{"v":275,"d":"NT$275"}]
[null,"保險",{"v":125,"d":"NT$125"}]
[null,"娛樂活動",{"v":50,"d":"NT$50"}]
[null,"雜項",{"v":0,"d":"NT$0"}]

{"sheet":"學期支出","index":4,"n_rows":11,"n_cols":4,"rows_kept":11}
[null,{"$f":"系所","v":"系所"}]
[null,"預算追蹤工具"]
[null,"學期支出",{"$f":"年份","v":"年份"}]
[null,"學期支出 (總計/每月)",{"$f":"SUM(TermExpenses[金額])","v":{"v":1500,"d":"NT$1,500"}},{"$f":"SUM(TermExpenses[每月])","v":{"v":375,"d":"NT$375"}}]
[null,"項目","金額","每月"]
[null,"學費",{"v":750,"d":"NT$750"},{"$f":"TermExpenses[[#This Row],[金額]]/學期_總_月份","v":{"v":187.5,"d":"NT$188"}}]
[null,"實驗室費用",{"v":250,"d":"NT$250"},{"$f":"TermExpenses[[#This Row],[金額]]/學期_總_月份","v":{"v":62.5,"d":"NT$63"}}]
[null,"書籍",{"v":500,"d":"NT$500"},{"$f":"TermExpenses[[#This Row],[金額]]/學期_總_月份","v":{"v":125,"d":"NT$125"}}]
[null,"存款",{"v":0,"d":"NT$0"},{"$f":"TermExpenses[[#This Row],[金額]]/學期_總_月份","v":{"v":0,"d":"NT$0"}}]
[null,"交通",{"v":0,"d":"NT$0"},{"$f":"TermExpenses[[#This Row],[金額]]/學期_總_月份","v":{"v":0,"d":"NT$0"}}]
[null,"其他費用",{"v":0,"d":"NT$0"},{"$f":"TermExpenses[[#This Row],[金額]]/學期_總_月份","v":{"v":0,"d":"NT$0"}}]

{"sheet":"書籍","index":5,"n_rows":7,"n_cols":7,"rows_kept":7}
[null,{"$f":"系所","v":"系所"}]
[null,"書籍追蹤工具"]
[null,"書籍清單"]
[null,"書名","作者","課程","購買地點","ISBN","附註"]
[null,"書名","作者","課程","地點","編號"]
[null,"書名","作者","課程","地點","編號"]
[null,"書名","作者","課程","地點","編號"]