{"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":"_xlfn.SINGLE(年)","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":"_xlfn.SINGLE(年)","v":"年份"}]
[null,"收支百分比"]
[null,{"$f":"NET_MONTHLY_EXPENSES/NET_MONTHLY_INCOME","v":{"v":0.7454545454545455,"d":"75%"}}]
[null,{"$f":"B5","v":0.7454545454545455}]
[null,"每月净收入","每月净支出","余额"]
[null,{"$f":"C10","v":{"v":2750,"d":"¥2,750"}},{"$f":"每月净支出!C4+学期支出!D4","v":{"v":2050,"d":"¥2,050"}},{"$f":"NET_MONTHLY_INCOME-NET_MONTHLY_EXPENSES","v":{"v":700,"d":"¥700"}}]
[null,"学期所含月数",4]
[null,"每月收入",{"$f":"SUM(每月收入[金额])","v":{"v":2750,"d":"¥2,750"}}]
[null,"项目","金额"]
[null,"固定收入",{"v":1500,"d":"¥1,500"}]
[null,"助学金",{"v":500,"d":"¥500"}]
[null,"贷款",{"v":500,"d":"¥500"}]
[null,"其他收入",{"v":250,"d":"¥250"}]

{"sheet":"每月净支出","index":3,"n_rows":15,"n_cols":3,"rows_kept":15}
[null,{"$f":"大学","v":"大学"}]
[null,"预算跟踪表"]
[null,"每月支出",{"$f":"_xlfn.SINGLE(年)","v":"年份"}]
[null,"每月支出",{"$f":"SUM(每月支出[金额])","v":{"v":1675,"d":"¥1,675"}}]
[null,"项目","金额"]
[null,"租金",{"v":300,"d":"¥300"}]
[null,"公共事业",{"v":50,"d":"¥50"}]
[null,"移动电话",{"v":75,"d":"¥75"}]
[null,"日用杂货",{"v":250,"d":"¥250"}]
[null,"汽车开支",{"v":50,"d":"¥50"}]
[null,"学生贷款",{"v":500,"d":"¥500"}]
[null,"信用卡",{"v":275,"d":"¥275"}]
[null,"保险",{"v":125,"d":"¥125"}]
[null,"娱乐",{"v":50,"d":"¥50"}]
[null,"杂项",{"v":0,"d":"¥0"}]

{"sheet":"学期支出","index":4,"n_rows":11,"n_cols":4,"rows_kept":11}
[null,{"$f":"大学","v":"大学"}]
[null,"预算跟踪表"]
[null,"学期支出",{"$f":"_xlfn.SINGLE(年)","v":"年份"}]
[null,"学期支出（总计/每月）",{"$f":"SUM(学期支出[金额])","v":{"v":1500,"d":"¥1,500"}},{"$f":"SUM(学期支出[每月])","v":{"v":375,"d":"¥375"}}]
[null,"项目","金额","每月"]
[null,"学费",{"v":750,"d":"¥750"},{"$f":"学期支出[[#This Row],[金额]]/Months_in_term","v":{"v":187.5,"d":"¥188"}}]
[null,"实验室费用",{"v":250,"d":"¥250"},{"$f":"学期支出[[#This Row],[金额]]/Months_in_term","v":{"v":62.5,"d":"¥63"}}]
[null,"图书",{"v":500,"d":"¥500"},{"$f":"学期支出[[#This Row],[金额]]/Months_in_term","v":{"v":125,"d":"¥125"}}]
[null,"存款",{"v":0,"d":"¥0"},{"$f":"学期支出[[#This Row],[金额]]/Months_in_term","v":{"v":0,"d":"¥0"}}]
[null,"交通费",{"v":0,"d":"¥0"},{"$f":"学期支出[[#This Row],[金额]]/Months_in_term","v":{"v":0,"d":"¥0"}}]
[null,"其他费用",{"v":0,"d":"¥0"},{"$f":"学期支出[[#This Row],[金额]]/Months_in_term","v":{"v":0,"d":"¥0"}}]

{"sheet":"图书","index":5,"n_rows":7,"n_cols":7,"rows_kept":7}
[null,{"$f":"大学","v":"大学"}]
[null,"图书跟踪表"]
[null,"书单"]
[null,"书名","作者","课程","购买渠道","ISBN","备注"]
[null,"书名","作者","课程","地点","编号"]
[null,"书名","作者","课程","地点","编号"]
[null,"书名","作者","课程","地点","编号"]