{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["College Credit Planner","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":43,"n_cols":8,"rows_kept":43,"merged":[[1,2,1,4],[3,0,3,1],[11,3,11,4],[11,5,11,7],[12,3,12,4]]}
[]
["College Credit Planner",null,"Bachelor of Arts \nin Music History"]
[]
[]
[null,null,"CREDIT REQUIREMENTS","TOTAL","EARNED","NEEDED"," "]
[null,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},{"$f":"DegreeRequirements[[#This Row],[NEEDED]]","v":32}]
[null,null,"Academic Minor","NA",{"$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":""},{"$f":"DegreeRequirements[[#This Row],[NEEDED]]","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},{"$f":"DegreeRequirements[[#This Row],[NEEDED]]","v":0}]
[null,null,"General Study",66,{"$f":"IFERROR(SUMIFS(Courses[CREDITS],Courses[DEGREE REQUIREMENT],DegreeRequirements[[#This Row],[CREDIT REQUIREMENTS]],Courses[COMPLETED?],\"=Yes\"),\"\")","v":42},{"$f":"IFERROR(DegreeRequirements[[#This Row],[TOTAL]]-DegreeRequirements[[#This Row],[EARNED]],\"\")","v":24},{"$f":"DegreeRequirements[[#This Row],[NEEDED]]","v":24}]
[null,null,"TOTALS",{"$f":"SUBTOTAL(109,DegreeRequirements[TOTAL])","v":124},{"$f":"SUBTOTAL(109,DegreeRequirements[EARNED])","v":68},{"$f":"SUBTOTAL(109,DegreeRequirements[NEEDED])","v":56}]
[]
[null,null,"OVERALL PROGRESS:",{"$f":"CreditsEarned","v":68},null,{"$f":"TEXT(DegreeRequirements[[#Totals],[EARNED]]/DegreeRequirements[[#Totals],[TOTAL]],\"##%\")&\" COMPLETED!\"","v":"55% 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":" You've reached over 1/2 of your goal!"}]
[]
["College Courses"]
["COURSE TITLE","COURSE #","DEGREE REQUIREMENT","CREDITS","COMPLETED?","SEMESTER"," ","  "]
["Anthropology","GEN 108","General Study",20,"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"]
["Mathmatics 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,null,"Semester 3"]

{"sheet":"Semester Summary Data","index":1,"n_rows":10,"n_cols":3,"rows_kept":10}
[]
["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",46,12]
["Semester 2",20,8]
["Semester 3",9,4]
["Semester 4",4,2]
["Semester 5",2,1]
["TOTAL",81,27]