{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["College Credit Planner","Semester Summary Data"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"College Credit Planner","index":0,"n_rows":100,"n_cols":35,"rows_kept":100,"cut":false,"hidden":false,"merged":[[1,2,1,4],[3,0,3,1],[10,4,10,5],[11,0,12,1],[11,3,11,4],[11,5,11,6],[12,3,12,4]]}
[null,null,null,null,null,null,null,null,1412]
["College Credit Planner",null,"Bachelor of ????\nin ????",null,null,null,"2016-12-12T14:55:14"]
[]
[]
["SEMESTER SUMMARY",null,"CREDIT REQUIREMENTS","TOTAL","EARNED","NEEDED"]
[null,null,"Academic Major",0,{"$f":"IFERROR(SUMIFS(Courses[CREDITS],Courses[DEGREE REQUIREMENT],DegreeRequirements[[#This Row],[CREDIT REQUIREMENTS]],Courses[COMPLETED?],\"=Yes\"),\"\")","v":0},{"$f":"IFERROR(DegreeRequirements[[#This Row],[TOTAL]]-DegreeRequirements[[#This Row],[EARNED]],\"\")","v":0}]
[null,null,"Academic Minor",0,{"$f":"IFERROR(SUMIFS(Courses[CREDITS],Courses[DEGREE REQUIREMENT],DegreeRequirements[[#This Row],[CREDIT REQUIREMENTS]],Courses[COMPLETED?],\"=Yes\"),\"\")","v":0},{"$f":"IFERROR(DegreeRequirements[[#This Row],[TOTAL]]-DegreeRequirements[[#This Row],[EARNED]],\"\")","v":0}]
[null,null,"Elective Course",0,{"$f":"IFERROR(SUMIFS(Courses[CREDITS],Courses[DEGREE REQUIREMENT],DegreeRequirements[[#This Row],[CREDIT REQUIREMENTS]],Courses[COMPLETED?],\"=Yes\"),\"\")","v":0},{"$f":"IFERROR(DegreeRequirements[[#This Row],[TOTAL]]-DegreeRequirements[[#This Row],[EARNED]],\"\")","v":0}]
[null,null,"General Study",0,{"$f":"IFERROR(SUMIFS(Courses[CREDITS],Courses[DEGREE REQUIREMENT],DegreeRequirements[[#This Row],[CREDIT REQUIREMENTS]],Courses[COMPLETED?],\"=Yes\"),\"\")","v":0},{"$f":"IFERROR(DegreeRequirements[[#This Row],[TOTAL]]-DegreeRequirements[[#This Row],[EARNED]],\"\")","v":0}]
[null,null,"TOTALS",{"$f":"SUBTOTAL(109,DegreeRequirements[TOTAL])","v":0},{"$f":"SUBTOTAL(109,DegreeRequirements[EARNED])","v":0},{"$f":"SUBTOTAL(109,DegreeRequirements[NEEDED])","v":0}]
[null,null,"Cumulative GPA:",{"$f":"IFERROR(ROUND(M17,3),0)","v":0},{"$f":"IFERROR(IF(D11>2.999,\"You Earned a $500 per semester Book Stipend!\",\"\"),\"\")","v":""}]
["To update the above PivotChart, right-click in an empty area\nof the chart and then click Refresh.",null,"OVERALL PROGRESS:",{"$f":"CreditsEarned","v":0},null,{"$f":"IFERROR(TEXT(DegreeRequirements[[#Totals],[EARNED]]/DegreeRequirements[[#Totals],[TOTAL]],\"##%\")&\" COMPLETED!\",\"\")","v":""}]
[null,null,null,{"$f":"IF(CreditsEarned = 0,\"\",IF(CreditsEarned>=(CreditsNeeded),\" Congratulations!\",IF(CreditsEarned>=(CreditsNeeded*0.75),\" It won't be long now!\",IF(CreditsEarned>=(CreditsNeeded*0.5),\" You've reached over 1/2 of your goal!\",IF(CreditsEarned>=(CreditsNeeded*0.25),\" Keep up the good work!\",\"\")))))","v":""}]
[]
["College Courses",null,null,null,null,null,"Your Name"]
["COURSE TITLE","COURSE #","DEGREE REQUIREMENT","CREDITS","COMPLETED?","SEMESTER","School","Grade","GPA Pts"]
[null,null,null,null,null,"Semester 1",null,null,{"$f":"IF(AND(E17 = \"YES\",H17 <> \"\"),SUM(D17 * (LOOKUP(H17,Grades))),0)","v":0},null,{"$f":"SUBTOTAL(109,I17:I100)","v":0},{"$f":"IFERROR(SUMIFS(Courses[CREDITS],Courses[SEMESTER],\"<>Transfer\",Courses[COMPLETED?],\"=Yes\"),\"\")","v":0},{"$f":"SUM(K17/L17)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(M17,3)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Semester 1",null,null,0]
[null,null,null,null,null,"Semester 1",null,null,0]
[null,null,null,null,null,"Semester 1",null,null,0]
[null,null,null,null,null,"Semester 1",null,null,0]
[null,null,null,null,null,"Semester 1",null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",4]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A-",3.67]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A+",4.33]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",3]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B-",2.67]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B+",3.33]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",2]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C-",1.67]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C+",2.33]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",1]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D-",0.67]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D+",1.33]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(E49 = \"YES\",H49 <> \"\"),SUM(D49 * (LOOKUP(H49,Grades))),0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(E81 = \"YES\",H81 <> \"\"),SUM(D81 * (LOOKUP(H81,Grades))),0)","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]

{"sheet":"Semester Summary Data","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["Semester Summary Data",null,"This PivotTable is the data source for the Semester Summary PivotChart on the College Credit Planner sheet."]
[]
["CLASSES","CREDITS  ","CLASSES "]
["Semester 1"]
["(blank)"]
["TOTAL"]