{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["College credit planner","Course","Semester summary data"],"not_rendered":{"charts":1,"defined_names":5,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"College credit planner","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"merged":[[0,0,2,1],[1,2,1,5],[3,0,3,1],[4,0,9,1],[10,0,11,1],[10,3,10,4],[11,3,11,4]]}
["College credit planner"]
[null,null,"Bachelor of Arts \nMusic History"]
[]
["SEMESTER SUMMARY",null,"CREDIT REQUIREMENTS","TOTAL","EARNED","NEEDED"]
["Bar chart showing total credits and classes for each semester is in this cell. This PivotChart is automatically updated based on PivotTable in the Semester Summary Data worksheet.",null,"Academic major",54,{"$f":"IFERROR(SUMIFS(Courses[CREDITS],Courses[DEGREE REQUIREMENT],DegreeRequirements[[#This Row],[CREDIT REQUIREMENTS]],Courses[COMPLETED?],\"=Yes\"),\"\")","v":22},{"$f":"IFERROR(DegreeRequirements[[#This Row],[TOTAL]]-DegreeRequirements[[#This Row],[EARNED]],\"\")","v":32}]
[null,null,"Academic minor","N/A",{"$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":""}]
[null,null,"Elective course",4,{"$f":"IFERROR(SUMIFS(Courses[CREDITS],Courses[DEGREE REQUIREMENT],DegreeRequirements[[#This Row],[CREDIT REQUIREMENTS]],Courses[COMPLETED?],\"=Yes\"),\"\")","v":4},{"$f":"IFERROR(DegreeRequirements[[#This Row],[TOTAL]]-DegreeRequirements[[#This Row],[EARNED]],\"\")","v":0}]
[null,null,"General study",66,{"$f":"IFERROR(SUMIFS(Courses[CREDITS],Courses[DEGREE REQUIREMENT],DegreeRequirements[[#This Row],[CREDIT REQUIREMENTS]],Courses[COMPLETED?],\"=Yes\"),\"\")","v":26},{"$f":"IFERROR(DegreeRequirements[[#This Row],[TOTAL]]-DegreeRequirements[[#This Row],[EARNED]],\"\")","v":40}]
[null,null,"TOTALS",{"$f":"SUBTOTAL(109,DegreeRequirements[TOTAL])","v":124},{"$f":"SUBTOTAL(109,DegreeRequirements[EARNED])","v":52},{"$f":"SUBTOTAL(109,DegreeRequirements[NEEDED])","v":72}]
[]
["To update the above PivotChart, select the chart.  \nDo a single right mouse click to get the shortcut menu.\nSelect Refresh or Refresh All to update the chart.",null,"OVERALL PROGRESS:",{"$f":"CreditsEarned","v":52},null,{"$f":"TEXT(DegreeRequirements[[#Totals],[EARNED]]/DegreeRequirements[[#Totals],[TOTAL]],\"##%\")&\" COMPLETED!\"","v":"42% COMPLETED!"}]
[{"$nulls":3},{"$f":"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":" Keep up the good work!"}]

{"sheet":"Course","index":1,"n_rows":29,"n_cols":6,"rows_kept":29}
["College courses"]
["COURSE TITLE","COURSE #","DEGREE REQUIREMENT","CREDITS","COMPLETED?","SEMESTER"]
["Anthropology","GEN 108","General study",4,"Yes","Semester 1"]
["Applied Music","MUS 215","Academic major",3,null,"Semester 3"]
["Art History","ART 101","General study",2,"Yes","Semester 1"]
["Art History ","ART 201","General study",2,"Yes","Semester 2"]
["Aural Skills I","MUS 113","Academic major",2,"Yes","Semester 1"]
["Aural Skills II","MUS 213","Academic major",2,"Yes","Semester 2"]
["Aural Skills III","MUS 313","Academic major",2,null,"Semester 3"]
["Aural Skills IV","MUS 413","Academic major",2,null,"Semester 4"]
["Conducting I","MUS 114","Academic major",2,"Yes","Semester 1"]
["English Writing","ENG 101","General study",3,"Yes","Semester 1"]
["English Writing","ENG 201","General study",3,"Yes","Semester 2"]
["Form and Analysis","MUS 214","Academic major",2,"Yes","Semester 2"]
["Intro to Anthropology","GEN 208","General study",3,"Yes","Semester 2"]
["Mathematics 101","MAT 101","General study",3,"Yes","Semester 1"]
["Music History in Western Civilization I","MUS 101","Academic major",2,"Yes","Semester 1"]
["Music History in Western Civilization II","MUS 201","Academic major",2,"Yes","Semester 1"]
["Music Theory I","MUS 110","Academic major",2,"Yes","Semester 2"]
["Music Theory II","MUS 210","Academic major",2,"Yes","Semester 3"]
["Music Theory III","MUS 310","Academic major",2,null,"Semester 4"]
["Music Theory IV","MUS 410","Academic major",2,null,"Semester 5"]
["Piano Class","MUS 109","Academic major",2,"Yes","Semester 1"]
["Social Sciences 101","SOC 101","General study",3,"Yes","Semester 1"]
["Social Studies 101","SOC 201","General study",3,"Yes","Semester 1"]
["World of Jazz","MUS 105","Elective course",4,"Yes","Semester 2"]
["World of Music I","MUS 112","Academic major",2,"Yes","Semester 1"]
["World of Music II","MUS 212","Academic major",2,"Yes","Semester 2"]
["World of Music III","MUS 213","Academic major",2,"No","Semester 3"]

{"sheet":"Semester summary data","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"merged":[[0,0,2,1]]}
["Semester summary data"]
[null,null,"This PivotTable is the data source for the Semester summary PivotChart on the College credit planner sheet."]
[]
["CLASSES","CREDITS  ","CLASSES "]
["Semester 1",30,12]
["Semester 2",20,8]
["Semester 3",9,4]
["Semester 4",4,2]
["Semester 5",2,1]
["TOTAL",65,27]