{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["TERM","CREDITS","BUDGET","NET MONTHLY EXPENSES","TERM EXPENSES","BOOKS"],"not_rendered":{"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"TERM","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[2,3,2,4]]}
[null,"MY CLASS SCHEDULE"]
[null,"AUTUMN TERM"]
[null,null,"START TIME","TIME INTERVAL",null,"YEAR"]
[null,null,"09:00:00",60,"(In Minutes)"]
[null,"TIME ","MON","TUE","WED","THU","FRI","SAT","SUN"]
[null,{"$f":"StartTime+TIME(0,(ROW(A1)-1)*TimeInterval,0)","v":"09:00:00"},"Breakfast","Breakfast","Breakfast","Breakfast","Breakfast"]
[null,"10:00:00","Business: Lecture Bldg B, Rm 256"]
[null,"11:00:00",{"$nulls":3},"Physics: Lab \nBldg J, Rm 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":"CREDITS","index":1,"n_rows":17,"n_cols":8,"rows_kept":17}
[null,"COLLEGE"]
[null,"CREDIT PLANNER"]
[null,"Degree Title",{"$f":"Year","v":"YEAR"}]
[null,"OVERALL PROGRESS",null,"OVERALL PROGRESS"]
[null,{"$f":"AVERAGE(Courses[GRADE])","v":3.5},{"$f":"IFERROR(TEXT(AVERAGEIF(Courses[COMPLETED],\"Yes\",Courses[GRADE]),\"0.00\"),\"0.00\")&\" Current GPA\"","v":"3.50 Current GPA"},{"$f":"COUNTIF(Courses[COMPLETED],\"Yes\")/COUNTA(Courses[COURSE TITLE])","v":0.6666666666666666},{"$f":"TEXT(COUNTIF(Courses[COMPLETED],\"Yes\")/COUNTA(Courses[COURSE TITLE]),\"0%\")&\" Completed\"","v":"67% Completed"}]
[null,"Note: The following credit summary is automatically populated by your entries in the College Courses table below"]
[null,"REQUIREMENT","TOTAL CREDITS","EARNED","NEEDED"]
[null,"Academic Major",{"$f":"IF(SUMIF(Courses[REQUIREMENT],CREDITS!$B8,Courses[CREDITS])=0,\"0\",SUMIF(Courses[REQUIREMENT],CREDITS!$B8,Courses[CREDITS]))","v":4},{"$f":"SUMIFS(Courses[CREDITS],Courses[REQUIREMENT],CREDITS!$B8,Courses[COMPLETED],\"Yes\")","v":4},{"$f":"SUMIF(Courses[REQUIREMENT],CREDITS!$B8,Courses[CREDITS])-SUMIFS(Courses[CREDITS],Courses[REQUIREMENT],CREDITS!$B8,Courses[COMPLETED],\"Yes\")","v":0}]
[null,"Academic Minor",{"$f":"IF(SUMIF(Courses[REQUIREMENT],CREDITS!$B9,Courses[CREDITS])=0,\"0\",SUMIF(Courses[REQUIREMENT],CREDITS!$B9,Courses[CREDITS]))","v":3},{"$f":"SUMIFS(Courses[CREDITS],Courses[REQUIREMENT],CREDITS!$B9,Courses[COMPLETED],\"Yes\")","v":0},{"$f":"SUMIF(Courses[REQUIREMENT],CREDITS!$B9,Courses[CREDITS])-SUMIFS(Courses[CREDITS],Courses[REQUIREMENT],CREDITS!$B9,Courses[COMPLETED],\"Yes\")","v":3}]
[null,"Elective Course",{"$f":"IF(SUMIF(Courses[REQUIREMENT],CREDITS!$B10,Courses[CREDITS])=0,\"0\",SUMIF(Courses[REQUIREMENT],CREDITS!$B10,Courses[CREDITS]))","v":2},{"$f":"SUMIFS(Courses[CREDITS],Courses[REQUIREMENT],CREDITS!$B10,Courses[COMPLETED],\"Yes\")","v":2},{"$f":"SUMIF(Courses[REQUIREMENT],CREDITS!$B10,Courses[CREDITS])-SUMIFS(Courses[CREDITS],Courses[REQUIREMENT],CREDITS!$B10,Courses[COMPLETED],\"Yes\")","v":0}]
[null,"General Study",{"$f":"IF(SUMIF(Courses[REQUIREMENT],CREDITS!$B11,Courses[CREDITS])=0,\"0\",SUMIF(Courses[REQUIREMENT],CREDITS!$B11,Courses[CREDITS]))","v":"0"},{"$f":"SUMIFS(Courses[CREDITS],Courses[REQUIREMENT],CREDITS!$B11,Courses[COMPLETED],\"Yes\")","v":0},{"$f":"SUMIF(Courses[REQUIREMENT],CREDITS!$B11,Courses[CREDITS])-SUMIFS(Courses[CREDITS],Courses[REQUIREMENT],CREDITS!$B11,Courses[COMPLETED],\"Yes\")","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,CREDITS!$C$8:$C$11)","v":9},{"$f":"SUBTOTAL(109,CREDITS!$D$8:$D$11)","v":6},{"$f":"SUBTOTAL(109,CREDITS!$E$8:$E$11)","v":3}]
[null,"Courses"]
[null,"COURSE TITLE","COURSE #","REQUIREMENT","CREDITS","COMPLETED","GRADE","TERM"]
[null,"Course 1","Number","Academic Major",4,"Yes",{"v":4,"d":"4.0"},"Term 1"]
[null,"Course 2","Number","Academic Minor",3,"No",null,"Term 1"]
[null,"Course 3","Number","Elective Course",2,"Yes",{"v":3,"d":"3.0"},"Term 1"]

{"sheet":"BUDGET","index":2,"n_rows":15,"n_cols":4,"rows_kept":15}
[null,{"$f":"College","v":"COLLEGE"}]
[null,"BUDGET TRACKER"]
[null,"My Budget",{"$f":"Year","v":"YEAR"}]
[null,"PERCENTAGE OF INCOME SPENT"]
[null,{"$f":"NET_MONTHLY_EXPENSES/NET_MONTHLY_INCOME","v":{"v":0.7454545454545455,"d":"75%"}}]
[null,{"$f":"B5","v":0.7454545454545455}]
[null,"NET MONTHLY INCOME","NET MONTHLY EXPENSES","BALANCE"]
[null,{"$f":"C10","v":{"v":2750,"d":"£2,750"}},{"$f":"'NET MONTHLY EXPENSES'!C4+'TERM EXPENSES'!D4","v":{"v":2050,"d":"£2,050"}},{"$f":"NET_MONTHLY_INCOME-NET_MONTHLY_EXPENSES","v":{"v":700,"d":"£700"}}]
[null,"Months in term",4]
[null,"MONTHLY INCOME",{"$f":"SUM(MonthlyIncome[AMOUNT])","v":{"v":2750,"d":"£2,750"}}]
[null,"ITEM","AMOUNT"]
[null,"Fixed income",{"v":1500,"d":"£1,500"}]
[null,"Financial aid",{"v":500,"d":"£500"}]
[null,"Loans",{"v":500,"d":"£500"}]
[null,"Other income",{"v":250,"d":"£250"}]

{"sheet":"NET MONTHLY EXPENSES","index":3,"n_rows":15,"n_cols":3,"rows_kept":15}
[null,{"$f":"College","v":"COLLEGE"}]
[null,"BUDGET TRACKER"]
[null,"Monthly Expenses",{"$f":"Year","v":"YEAR"}]
[null,"MONTHLY EXPENSES",{"$f":"SUM(MonthlyExpenses[AMOUNT])","v":{"v":1675,"d":"£1,675"}}]
[null,"ITEM","AMOUNT"]
[null,"Rent",{"v":300,"d":"£300"}]
[null,"Utilities",{"v":50,"d":"£50"}]
[null,"Cell phone",{"v":75,"d":"£75"}]
[null,"Groceries",{"v":250,"d":"£250"}]
[null,"Auto expenses",{"v":50,"d":"£50"}]
[null,"Student loans",{"v":500,"d":"£500"}]
[null,"Credit cards",{"v":275,"d":"£275"}]
[null,"Insurance",{"v":125,"d":"£125"}]
[null,"Entertainment",{"v":50,"d":"£50"}]
[null,"Miscellaneous",{"v":0,"d":"£0"}]

{"sheet":"TERM EXPENSES","index":4,"n_rows":11,"n_cols":4,"rows_kept":11}
[null,{"$f":"College","v":"COLLEGE"}]
[null,"BUDGET TRACKER"]
[null,"Term Expenses",{"$f":"Year","v":"YEAR"}]
[null,"TERM EXPENSES (Total/Per Month)",{"$f":"SUM(TermExpenses[AMOUNT])","v":{"v":1500,"d":"£1,500"}},{"$f":"SUM(TermExpenses[PER MONTH])","v":{"v":375,"d":"£375"}}]
[null,"ITEM","AMOUNT","PER MONTH"]
[null,"Tuition",{"v":750,"d":"£750"},{"$f":"TermExpenses[[#This Row],[AMOUNT]]/Months_in_term","v":{"v":187.5,"d":"£188"}}]
[null,"Lab fees",{"v":250,"d":"£250"},{"$f":"TermExpenses[[#This Row],[AMOUNT]]/Months_in_term","v":{"v":62.5,"d":"£63"}}]
[null,"Books",{"v":500,"d":"£500"},{"$f":"TermExpenses[[#This Row],[AMOUNT]]/Months_in_term","v":{"v":125,"d":"£125"}}]
[null,"Deposits",{"v":0,"d":"£0"},{"$f":"TermExpenses[[#This Row],[AMOUNT]]/Months_in_term","v":{"v":0,"d":"£0"}}]
[null,"Transportation",{"v":0,"d":"£0"},{"$f":"TermExpenses[[#This Row],[AMOUNT]]/Months_in_term","v":{"v":0,"d":"£0"}}]
[null,"Other fees",{"v":0,"d":"£0"},{"$f":"TermExpenses[[#This Row],[AMOUNT]]/Months_in_term","v":{"v":0,"d":"£0"}}]

{"sheet":"BOOKS","index":5,"n_rows":7,"n_cols":7,"rows_kept":7}
[null,{"$f":"College","v":"COLLEGE"}]
[null,"BOOK TRACKER"]
[null,"Book List"]
[null,"TITLE","AUTHOR","COURSE","WHERE TO BUY?","ISBN","NOTES"]
[null,"Book Title","Author","Course","Location","Number"]
[null,"Book Title","Author","Course","Location","Number"]
[null,"Book Title","Author","Course","Location","Number"]