{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["大學學分規劃工具","學期摘要資料"],"not_rendered":{"charts":1,"defined_names":5,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"大學學分規劃工具","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]]}
[]
["大學學分規劃工具",null,"音樂史 文學士"]
[]
[]
[null,null,"學分要求","合計","已得","需要"," "]
[null,null,"主修",54,{"$f":"IFERROR(SUMIFS(課程[學分],課程[學位要求],學位要求[[#This Row],[學分要求]],課程[完成？],\"=是\"),\"\")","v":22},{"$f":"IFERROR(學位要求[[#This Row],[合計]]-學位要求[[#This Row],[已得]],\"\")","v":32},{"$f":"學位要求[[#This Row],[需要]]","v":32}]
[null,null,"副修","NA",{"$f":"IFERROR(SUMIFS(課程[學分],課程[學位要求],學位要求[[#This Row],[學分要求]],課程[完成？],\"=是\"),\"\")","v":0},{"$f":"IFERROR(學位要求[[#This Row],[合計]]-學位要求[[#This Row],[已得]],\"\")","v":""},{"$f":"學位要求[[#This Row],[需要]]","v":""}]
[null,null,"選修課程",4,{"$f":"IFERROR(SUMIFS(課程[學分],課程[學位要求],學位要求[[#This Row],[學分要求]],課程[完成？],\"=是\"),\"\")","v":4},{"$f":"IFERROR(學位要求[[#This Row],[合計]]-學位要求[[#This Row],[已得]],\"\")","v":0},{"$f":"學位要求[[#This Row],[需要]]","v":0}]
[null,null,"一般研究",66,{"$f":"IFERROR(SUMIFS(課程[學分],課程[學位要求],學位要求[[#This Row],[學分要求]],課程[完成？],\"=是\"),\"\")","v":42},{"$f":"IFERROR(學位要求[[#This Row],[合計]]-學位要求[[#This Row],[已得]],\"\")","v":24},{"$f":"學位要求[[#This Row],[需要]]","v":24}]
[null,null,"合計",{"$f":"SUBTOTAL(109,學位要求[合計])","v":124},{"$f":"SUBTOTAL(109,學位要求[已得])","v":68},{"$f":"SUBTOTAL(109,學位要求[需要])","v":56}]
[]
[null,null,"整體進度：",{"$f":"CreditsEarned","v":68},null,{"$f":"TEXT(學位要求[[#Totals],[已得]]/學位要求[[#Totals],[合計]],\"##%\")&\" 完成！\"","v":"55% 完成！"}]
[{"$nulls":3},{"$f":"IF(CreditsEarned>=(CreditsNeeded),\" Congratulations!\",IF(CreditsEarned>=(CreditsNeeded*0.75),\" 再不久就可以完成！\",IF(CreditsEarned>=(CreditsNeeded*0.5),\" 您已超過目標的 1/2！\",IF(CreditsEarned>=(CreditsNeeded*0.25),\" 繼續努力！\",\"\"))))","v":" 您已超過目標的 1/2！"}]
[]
["大學課程"]
["課程標題","課程編號","學位要求","學分","完成？","學期"," ","  "]
["人類學","GEN 108","一般研究",20,"是","第 1 學期"]
["應用音樂","MUS 215","主修",3,null,"第 3 學期"]
["藝術史","ART 101","一般研究",2,"是","第 1 學期"]
["藝術史 ","ART 201","一般研究",2,"是","第 2 學期"]
["音感練習 I","MUS 113","主修",2,"是","第 1 學期"]
["音感練習 II","MUS 213","主修",2,"是","第 2 學期"]
["音感練習 III","MUS 313","主修",2,null,"第 3 學期"]
["音感練習 IV","MUS 413","主修",2,null,"第 4 學期"]
["指揮 I","MUS 114","主修",2,"是","第 1 學期"]
["英文寫作","ENG 101","一般研究",3,"是","第 1 學期"]
["英文寫作","ENG 201","一般研究",3,"是","第 2 學期"]
["曲式分析","MUS 214","主修",2,"是","第 2 學期"]
["人類學入門","GEN 208","一般研究",3,"是","第 2 學期"]
["數學 101","MAT 101","一般研究",3,"是","第 1 學期"]
["西方文明音樂史 I","MUS 101","主修",2,"是","第 1 學期"]
["西方文明音樂史 II","MUS 201","主修",2,"是","第 1 學期"]
["音樂理論 I","MUS 110","主修",2,"是","第 2 學期"]
["音樂理論 II","MUS 210","主修",2,"是","第 3 學期"]
["音樂理論 III","MUS 310","主修",2,null,"第 4 學期"]
["音樂理論 IV","MUS 410","主修",2,null,"第 5 學期"]
["鋼琴課","MUS 109","主修",2,"是","第 1 學期"]
["社會科學 101","SOC 101","一般研究",3,"是","第 1 學期"]
["社會研究 101","SOC 201","一般研究",3,"是","第 1 學期"]
["爵士樂世界","MUS 105","選修課程",4,"是","第 2 學期"]
["音樂世界 I","MUS 112","主修",2,"是","第 1 學期"]
["音樂世界 II","MUS 212","主修",2,"是","第 2 學期"]
["音樂世界 III","MUS 213","主修",2,null,"第 3 學期"]

{"sheet":"學期摘要資料","index":1,"n_rows":10,"n_cols":3,"rows_kept":10}
[]
["學期摘要資料",null,"此樞紐分析表是 [大學學分規劃工具] 工作表上學期摘要樞紐分析表的資料來源。"]
[]
["課程","學分 ","課程"]
["第 1 學期",46,12]
["第 3 學期",9,4]
["第 2 學期",20,8]
["第 4 學期",4,2]
["第 5 學期",2,1]
["合計",81,27]