{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["共通科目","専門科目","土木GPT","目標ごとの達成度","総括表","GPT","GPA","グラフ用データ"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"GPT","index":5,"reason":"not_a_worksheet"},{"sheet":"GPA","index":6,"reason":"not_a_worksheet"}],"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":"共通科目","index":0,"n_rows":80,"n_cols":45,"rows_kept":80,"cut":false,"hidden":false,"merged":[[1,3,1,16],[0,3,0,16],[3,7,3,8],[3,9,3,10],[2,1,4,2],[2,3,4,4],[2,16,4,16],[2,5,3,6],[2,15,4,15],[75,1,78,2],[50,2,57,2],[58,2,66,2],[5,1,33,1],[49,1,66,1],[34,1,48,2],[22,2,33,2],[14,2,21,2],[6,2,13,2],[67,1,74,2],[51,12,57,12],[2,7,2,14],[3,11,3,12],[3,13,3,14],[59,10,63,10],[60,11,66,11],[50,11,57,11],[6,7,30,7],[6,8,30,8],[6,9,30,9],[6,10,30,10]]}
[null,null,null,"共通科目チェックシート"]
[null,null,null,"黄色背景の成績欄をドロップダウンリストによって入力すること\nバグや不具合があれば，森河（morikawa.yukihiro@nitech.ac.jp）まで．"]
[null,"区分",null,"授業科目名\n（○：土木GPT対応科目）",null,"単位数",null,"毎週授業時間数",null,null,null,null,null,null,null,"単位取得\n年度・学期","成績"]
[null,null,null,null,null,null,null,"1年次",null,"2年次",null,"3年次",null,"4年次"]
[null,null,null,null,null,"必修","選択","前期","後期","前期","後期","前期","後期","前期","後期",null,null,null,"必修単位","選択単位","GP","土木GP","学期",1,2,3,4,5,6,7,8,9,10,11,1,2,3,4,5,6,7,8,9,10,11]
[null,"人間社会",null,"○","フレッシュマンセミナー",2,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q6=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q6,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F6","v":0},{"$f":"IF($Q6=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q6,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G6","v":0},{"$f":"IF($Q6=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q6,目標ごとの達成度!$N$95:$N$103,0),1))*(F6+G6)","v":0},{"$f":"IF(OR(D6=\"○\",D6=\"◎\"),U6,0)","v":0},{"$f":"IF(P6=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P6,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},{"$f":"IF($W6=X$5,$S6+$T6,0)","v":0},{"$f":"IF($W6=Y$5,$S6+$T6,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($W6=AI$5,$V6,0)","v":0},{"$f":"IF($W6=AJ$5,$V6,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"技術と人間・心理","○","異文化理解",null,2,4,2,2,2,null,null,null,null,null,null,null,{"$f":"IF($Q7=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q7,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F7","v":0},{"$f":"IF($Q7=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q7,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G7","v":0},{"$f":"IF($Q7=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q7,目標ごとの達成度!$N$95:$N$103,0),1))*(F7+G7)","v":0},{"$f":"IF(OR(D7=\"○\",D7=\"◎\"),U7,0)","v":0},{"$f":"IF(P7=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P7,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},{"$f":"IF($W7=X$5,$S7+$T7,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($W7=AI$5,$V7,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","感性と社会",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q8=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q8,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F8","v":0},{"$f":"IF($Q8=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q8,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G8","v":0},{"$f":"IF($Q8=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q8,目標ごとの達成度!$N$95:$N$103,0),1))*(F8+G8)","v":0},0,{"$f":"IF(P8=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P8,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","心理学",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q9=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q9,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F9","v":0},{"$f":"IF($Q9=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q9,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G9","v":0},{"$f":"IF($Q9=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q9,目標ごとの達成度!$N$95:$N$103,0),1))*(F9+G9)","v":0},0,{"$f":"IF(P9=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P9,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","生物と環境",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q10=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q10,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F10","v":0},{"$f":"IF($Q10=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q10,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G10","v":0},{"$f":"IF($Q10=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q10,目標ごとの達成度!$N$95:$N$103,0),1))*(F10+G10)","v":0},0,{"$f":"IF(P10=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P10,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","対人コミュニケーション論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q11=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q11,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F11","v":0},{"$f":"IF($Q11=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q11,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G11","v":0},{"$f":"IF($Q11=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q11,目標ごとの達成度!$N$95:$N$103,0),1))*(F11+G11)","v":0},0,{"$f":"IF(P11=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P11,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","日本文化論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q12=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q12,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F12","v":0},{"$f":"IF($Q12=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q12,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G12","v":0},{"$f":"IF($Q12=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q12,目標ごとの達成度!$N$95:$N$103,0),1))*(F12+G12)","v":0},0,{"$f":"IF(P12=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P12,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","人間行動学",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q13=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q13,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F13","v":0},{"$f":"IF($Q13=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q13,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G13","v":0},{"$f":"IF($Q13=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q13,目標ごとの達成度!$N$95:$N$103,0),1))*(F13+G13)","v":0},0,{"$f":"IF(P13=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P13,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","人間社会ゼミナール",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q14=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q14,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F14","v":0},{"$f":"IF($Q14=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q14,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G14","v":0},{"$f":"IF($Q14=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q14,目標ごとの達成度!$N$95:$N$103,0),1))*(F14+G14)","v":0},0,{"$f":"IF(P14=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P14,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"技術と歴史・哲学","○","アジア・太平洋史",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q15=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q15,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F15","v":0},{"$f":"IF($Q15=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q15,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G15","v":0},{"$f":"IF($Q15=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q15,目標ごとの達成度!$N$95:$N$103,0),1))*(F15+G15)","v":0},0,{"$f":"IF(P15=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P15,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","科学技術史",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q16=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q16,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F16","v":0},{"$f":"IF($Q16=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q16,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G16","v":0},{"$f":"IF($Q16=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q16,目標ごとの達成度!$N$95:$N$103,0),1))*(F16+G16)","v":0},0,{"$f":"IF(P16=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P16,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","科学思想史",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q17=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q17,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F17","v":0},{"$f":"IF($Q17=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q17,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G17","v":0},{"$f":"IF($Q17=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q17,目標ごとの達成度!$N$95:$N$103,0),1))*(F17+G17)","v":0},0,{"$f":"IF(P17=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P17,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","科学と哲学",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q18=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q18,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F18","v":0},{"$f":"IF($Q18=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q18,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G18","v":0},{"$f":"IF($Q18=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q18,目標ごとの達成度!$N$95:$N$103,0),1))*(F18+G18)","v":0},0,{"$f":"IF(P18=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P18,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","共生社会論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q19=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q19,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F19","v":0},{"$f":"IF($Q19=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q19,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G19","v":0},{"$f":"IF($Q19=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q19,目標ごとの達成度!$N$95:$N$103,0),1))*(F19+G19)","v":0},0,{"$f":"IF(P19=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P19,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","近現代史",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q20=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q20,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F20","v":0},{"$f":"IF($Q20=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q20,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G20","v":0},{"$f":"IF($Q20=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q20,目標ごとの達成度!$N$95:$N$103,0),1))*(F20+G20)","v":0},0,{"$f":"IF(P20=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P20,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","公共の哲学",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q21=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q21,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F21","v":0},{"$f":"IF($Q21=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q21,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G21","v":0},{"$f":"IF($Q21=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q21,目標ごとの達成度!$N$95:$N$103,0),1))*(F21+G21)","v":0},0,{"$f":"IF(P21=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P21,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","宗教文化論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q22=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q22,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F22","v":0},{"$f":"IF($Q22=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q22,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G22","v":0},{"$f":"IF($Q22=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q22,目標ごとの達成度!$N$95:$N$103,0),1))*(F22+G22)","v":0},0,{"$f":"IF(P22=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P22,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"技術と社会・国際","○","経済学",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q23=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q23,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F23","v":0},{"$f":"IF($Q23=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q23,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G23","v":0},{"$f":"IF($Q23=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q23,目標ごとの達成度!$N$95:$N$103,0),1))*(F23+G23)","v":0},0,{"$f":"IF(P23=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P23,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","現代社会論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q24=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q24,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F24","v":0},{"$f":"IF($Q24=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q24,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G24","v":0},{"$f":"IF($Q24=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q24,目標ごとの達成度!$N$95:$N$103,0),1))*(F24+G24)","v":0},0,{"$f":"IF(P24=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P24,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","現代政治論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q25=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q25,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F25","v":0},{"$f":"IF($Q25=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q25,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G25","v":0},{"$f":"IF($Q25=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q25,目標ごとの達成度!$N$95:$N$103,0),1))*(F25+G25)","v":0},0,{"$f":"IF(P25=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P25,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","公共政策論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q26=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q26,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F26","v":0},{"$f":"IF($Q26=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q26,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G26","v":0},{"$f":"IF($Q26=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q26,目標ごとの達成度!$N$95:$N$103,0),1))*(F26+G26)","v":0},0,{"$f":"IF(P26=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P26,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","生涯学習論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q27=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q27,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F27","v":0},{"$f":"IF($Q27=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q27,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G27","v":0},{"$f":"IF($Q27=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q27,目標ごとの達成度!$N$95:$N$103,0),1))*(F27+G27)","v":0},0,{"$f":"IF(P27=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P27,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","情報社会論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q28=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q28,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F28","v":0},{"$f":"IF($Q28=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q28,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G28","v":0},{"$f":"IF($Q28=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q28,目標ごとの達成度!$N$95:$N$103,0),1))*(F28+G28)","v":0},0,{"$f":"IF(P28=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P28,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","地域研究Ⅰ",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q29=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q29,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F29","v":0},{"$f":"IF($Q29=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q29,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G29","v":0},{"$f":"IF($Q29=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q29,目標ごとの達成度!$N$95:$N$103,0),1))*(F29+G29)","v":0},0,{"$f":"IF(P29=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P29,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","地域研究Ⅱ",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q30=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q30,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F30","v":0},{"$f":"IF($Q30=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q30,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G30","v":0},{"$f":"IF($Q30=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q30,目標ごとの達成度!$N$95:$N$103,0),1))*(F30+G30)","v":0},0,{"$f":"IF(P30=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P30,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","日本国憲法",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q31=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q31,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F31","v":0},{"$f":"IF($Q31=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q31,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G31","v":0},{"$f":"IF($Q31=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q31,目標ごとの達成度!$N$95:$N$103,0),1))*(F31+G31)","v":0},0,{"$f":"IF(P31=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P31,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","日本語表現法（留学生）",null,2,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q32=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q32,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F32","v":0},{"$f":"IF($Q32=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q32,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G32","v":0},{"$f":"IF($Q32=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q32,目標ごとの達成度!$N$95:$N$103,0),1))*(F32+G32)","v":0},0,{"$f":"IF(P32=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P32,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","日本語日本文化（留学生）",null,2,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q33=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q33,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F33","v":0},{"$f":"IF($Q33=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q33,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G33","v":0},{"$f":"IF($Q33=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q33,目標ごとの達成度!$N$95:$N$103,0),1))*(F33+G33)","v":0},0,{"$f":"IF(P33=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P33,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","日本語日本社会（留学生）",null,2,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q34=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q34,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F34","v":0},{"$f":"IF($Q34=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q34,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G34","v":0},{"$f":"IF($Q34=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q34,目標ごとの達成度!$N$95:$N$103,0),1))*(F34+G34)","v":0},0,{"$f":"IF(P34=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P34,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"自然科学基礎",null,"○","線形代数Ⅰ",2,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q35=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q35,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F35","v":0},{"$f":"IF($Q35=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q35,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G35","v":0},{"$f":"IF($Q35=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q35,目標ごとの達成度!$N$95:$N$103,0),1))*(F35+G35)","v":0},0,{"$f":"IF(P35=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P35,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","線形代数Ⅱ",2,null,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q36=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q36,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F36","v":0},{"$f":"IF($Q36=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q36,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G36","v":0},{"$f":"IF($Q36=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q36,目標ごとの達成度!$N$95:$N$103,0),1))*(F36+G36)","v":0},0,{"$f":"IF(P36=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P36,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","微分積分Ⅰ及び演習",3,null,3,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q37=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q37,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F37","v":0},{"$f":"IF($Q37=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q37,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G37","v":0},{"$f":"IF($Q37=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q37,目標ごとの達成度!$N$95:$N$103,0),1))*(F37+G37)","v":0},0,{"$f":"IF(P37=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P37,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","微分積分Ⅱ及び演習",null,3,null,3,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q38=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q38,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F38","v":0},{"$f":"IF($Q38=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q38,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G38","v":0},{"$f":"IF($Q38=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q38,目標ごとの達成度!$N$95:$N$103,0),1))*(F38+G38)","v":0},0,{"$f":"IF(P38=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P38,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","力学",2,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q39=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q39,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F39","v":0},{"$f":"IF($Q39=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q39,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G39","v":0},{"$f":"IF($Q39=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q39,目標ごとの達成度!$N$95:$N$103,0),1))*(F39+G39)","v":0},0,{"$f":"IF(P39=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P39,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},{"$f":"IF($W39=X$5,$S39+$T39,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($W39=AI$5,$V39,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","物理学演習Ⅰ",null,1,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q40=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q40,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F40","v":0},{"$f":"IF($Q40=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q40,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G40","v":0},{"$f":"IF($Q40=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q40,目標ごとの達成度!$N$95:$N$103,0),1))*(F40+G40)","v":0},0,{"$f":"IF(P40=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P40,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","電磁気学",null,2,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q41=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q41,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F41","v":0},{"$f":"IF($Q41=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q41,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G41","v":0},{"$f":"IF($Q41=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q41,目標ごとの達成度!$N$95:$N$103,0),1))*(F41+G41)","v":0},0,{"$f":"IF(P41=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P41,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","物理学実験",null,2,null,4,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q42=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q42,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F42","v":0},{"$f":"IF($Q42=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q42,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G42","v":0},{"$f":"IF($Q42=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q42,目標ごとの達成度!$N$95:$N$103,0),1))*(F42+G42)","v":0},0,{"$f":"IF(P42=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P42,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","基礎化学",null,2,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q43=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q43,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F43","v":0},{"$f":"IF($Q43=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q43,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G43","v":0},{"$f":"IF($Q43=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q43,目標ごとの達成度!$N$95:$N$103,0),1))*(F43+G43)","v":0},0,{"$f":"IF(P43=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P43,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","化学結合論",null,2,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q44=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q44,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F44","v":0},{"$f":"IF($Q44=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q44,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G44","v":0},{"$f":"IF($Q44=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q44,目標ごとの達成度!$N$95:$N$103,0),1))*(F44+G44)","v":0},0,{"$f":"IF(P44=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P44,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","地球科学",null,2,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($Q45=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q45,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F45","v":0},{"$f":"IF($Q45=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q45,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G45","v":0},{"$f":"IF($Q45=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q45,目標ごとの達成度!$N$95:$N$103,0),1))*(F45+G45)","v":0},0,{"$f":"IF(P45=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P45,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","地球科学実験",null,1,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($Q46=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q46,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F46","v":0},{"$f":"IF($Q46=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q46,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G46","v":0},{"$f":"IF($Q46=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q46,目標ごとの達成度!$N$95:$N$103,0),1))*(F46+G46)","v":0},0,{"$f":"IF(P46=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P46,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","生体機能科学",null,2,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($Q47=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q47,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F47","v":0},{"$f":"IF($Q47=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q47,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G47","v":0},{"$f":"IF($Q47=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q47,目標ごとの達成度!$N$95:$N$103,0),1))*(F47+G47)","v":0},0,{"$f":"IF(P47=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P47,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","専門基礎科学Ⅰ（留学生）",null,2,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q48=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q48,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F48","v":0},{"$f":"IF($Q48=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q48,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G48","v":0},{"$f":"IF($Q48=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q48,目標ごとの達成度!$N$95:$N$103,0),1))*(F48+G48)","v":0},0,{"$f":"IF(P48=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P48,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","専門基礎科学Ⅱ（留学生）",null,2,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q49=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q49,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F49","v":0},{"$f":"IF($Q49=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q49,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G49","v":0},{"$f":"IF($Q49=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q49,目標ごとの達成度!$N$95:$N$103,0),1))*(F49+G49)","v":0},0,{"$f":"IF(P49=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P49,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"産業・経営リテラシー",null,null,"産業論",2,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($Q50=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q50,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F50","v":0},{"$f":"IF($Q50=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q50,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G50","v":0},{"$f":"IF($Q50=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q50,目標ごとの達成度!$N$95:$N$103,0),1))*(F50+G50)","v":0},0,{"$f":"IF(P50=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P50,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"経営リテラシー",null,"金融学",null,2,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($Q51=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q51,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F51","v":0},{"$f":"IF($Q51=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q51,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G51","v":0},{"$f":"IF($Q51=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q51,目標ごとの達成度!$N$95:$N$103,0),1))*(F51+G51)","v":0},0,{"$f":"IF(P51=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P51,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"法工学",null,2,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF($Q52=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q52,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F52","v":0},{"$f":"IF($Q52=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q52,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G52","v":0},{"$f":"IF($Q52=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q52,目標ごとの達成度!$N$95:$N$103,0),1))*(F52+G52)","v":0},0,{"$f":"IF(P52=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P52,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"知的財産権",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q53=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q53,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F53","v":0},{"$f":"IF($Q53=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q53,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G53","v":0},{"$f":"IF($Q53=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q53,目標ごとの達成度!$N$95:$N$103,0),1))*(F53+G53)","v":0},0,{"$f":"IF(P53=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P53,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"マーケティング",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q54=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q54,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F54","v":0},{"$f":"IF($Q54=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q54,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G54","v":0},{"$f":"IF($Q54=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q54,目標ごとの達成度!$N$95:$N$103,0),1))*(F54+G54)","v":0},0,{"$f":"IF(P54=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P54,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"経営戦略",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q55=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q55,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F55","v":0},{"$f":"IF($Q55=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q55,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G55","v":0},{"$f":"IF($Q55=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q55,目標ごとの達成度!$N$95:$N$103,0),1))*(F55+G55)","v":0},0,{"$f":"IF(P55=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P55,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"政策科学",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q56=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q56,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F56","v":0},{"$f":"IF($Q56=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q56,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G56","v":0},{"$f":"IF($Q56=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q56,目標ごとの達成度!$N$95:$N$103,0),1))*(F56+G56)","v":0},0,{"$f":"IF(P56=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P56,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"会計学",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q57=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q57,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F57","v":0},{"$f":"IF($Q57=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q57,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G57","v":0},{"$f":"IF($Q57=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q57,目標ごとの達成度!$N$95:$N$103,0),1))*(F57+G57)","v":0},0,{"$f":"IF(P57=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P57,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"管理工学",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q58=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q58,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F58","v":0},{"$f":"IF($Q58=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q58,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G58","v":0},{"$f":"IF($Q58=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q58,目標ごとの達成度!$N$95:$N$103,0),1))*(F58+G58)","v":0},0,{"$f":"IF(P58=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P58,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"産業社会",null,"ものづくりとデザイン",null,2,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($Q59=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q59,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F59","v":0},{"$f":"IF($Q59=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q59,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G59","v":0},{"$f":"IF($Q59=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q59,目標ごとの達成度!$N$95:$N$103,0),1))*(F59+G59)","v":0},0,{"$f":"IF(P59=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P59,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"自治体行政",null,2,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($Q60=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q60,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F60","v":0},{"$f":"IF($Q60=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q60,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G60","v":0},{"$f":"IF($Q60=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q60,目標ごとの達成度!$N$95:$N$103,0),1))*(F60+G60)","v":0},0,{"$f":"IF(P60=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P60,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"コミュニティと技術",null,2,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($Q61=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q61,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F61","v":0},{"$f":"IF($Q61=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q61,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G61","v":0},{"$f":"IF($Q61=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q61,目標ごとの達成度!$N$95:$N$103,0),1))*(F61+G61)","v":0},0,{"$f":"IF(P61=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P61,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"男女共同参画社会論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q62=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q62,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F62","v":0},{"$f":"IF($Q62=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q62,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G62","v":0},{"$f":"IF($Q62=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q62,目標ごとの達成度!$N$95:$N$103,0),1))*(F62+G62)","v":0},0,{"$f":"IF(P62=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P62,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,{"$f":"IF($W62=Z$5,$S62+$T62,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($W62=AK$5,$V62,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"企業経営",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q63=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q63,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F63","v":0},{"$f":"IF($Q63=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q63,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G63","v":0},{"$f":"IF($Q63=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q63,目標ごとの達成度!$N$95:$N$103,0),1))*(F63+G63)","v":0},0,{"$f":"IF(P63=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P63,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},{"$f":"IF($W63=X$5,$S63+$T63,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($W63=AI$5,$V63,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"キャリア・コミュニケーション論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q64=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q64,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F64","v":0},{"$f":"IF($Q64=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q64,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G64","v":0},{"$f":"IF($Q64=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q64,目標ごとの達成度!$N$95:$N$103,0),1))*(F64+G64)","v":0},0,{"$f":"IF(P64=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P64,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"労働者管理基礎論",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q65=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q65,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F65","v":0},{"$f":"IF($Q65=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q65,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G65","v":0},{"$f":"IF($Q65=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q65,目標ごとの達成度!$N$95:$N$103,0),1))*(F65+G65)","v":0},0,{"$f":"IF(P65=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P65,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"食糧工学",null,2,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q66=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q66,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F66","v":0},{"$f":"IF($Q66=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q66,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G66","v":0},{"$f":"IF($Q66=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q66,目標ごとの達成度!$N$95:$N$103,0),1))*(F66+G66)","v":0},0,{"$f":"IF(P66=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P66,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"キャリアデザイン",null,2,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q67=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q67,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F67","v":0},{"$f":"IF($Q67=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q67,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G67","v":0},{"$f":"IF($Q67=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q67,目標ごとの達成度!$N$95:$N$103,0),1))*(F67+G67)","v":0},0,{"$f":"IF(P67=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P67,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"グローバル\nコミュニケーション",null,"○","Academic EnglishⅠ",2,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q68=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q68,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F68","v":0},{"$f":"IF($Q68=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q68,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G68","v":0},{"$f":"IF($Q68=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q68,目標ごとの達成度!$N$95:$N$103,0),1))*(F68+G68)","v":0},0,{"$f":"IF(P68=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P68,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","Academic EnglishⅡ",2,null,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q69=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q69,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F69","v":0},{"$f":"IF($Q69=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q69,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G69","v":0},{"$f":"IF($Q69=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q69,目標ごとの達成度!$N$95:$N$103,0),1))*(F69+G69)","v":0},0,{"$f":"IF(P69=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P69,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","English SeminarⅠ",1,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q70=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q70,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F70","v":0},{"$f":"IF($Q70=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q70,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G70","v":0},{"$f":"IF($Q70=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q70,目標ごとの達成度!$N$95:$N$103,0),1))*(F70+G70)","v":0},0,{"$f":"IF(P70=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P70,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","English SeminarⅡ",1,null,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q71=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q71,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F71","v":0},{"$f":"IF($Q71=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q71,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G71","v":0},{"$f":"IF($Q71=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q71,目標ごとの達成度!$N$95:$N$103,0),1))*(F71+G71)","v":0},{"$f":"IF(OR(D71=\"○\",D71=\"◎\"),U71,0)","v":0},{"$f":"IF(P71=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P71,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"○","Academic EnglishⅢ",2,null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($Q72=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q72,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F72","v":0},{"$f":"IF($Q72=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q72,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G72","v":0},{"$f":"IF($Q72=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q72,目標ごとの達成度!$N$95:$N$103,0),1))*(F72+G72)","v":0},0,{"$f":"IF(P72=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P72,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Academic EnglishⅣ",null,2,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($Q73=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q73,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F73","v":0},{"$f":"IF($Q73=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q73,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G73","v":0},{"$f":"IF($Q73=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q73,目標ごとの達成度!$N$95:$N$103,0),1))*(F73+G73)","v":0},0,{"$f":"IF(P73=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P73,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Global EnglishⅠ",null,1,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($Q74=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q74,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F74","v":0},{"$f":"IF($Q74=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q74,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G74","v":0},{"$f":"IF($Q74=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q74,目標ごとの達成度!$N$95:$N$103,0),1))*(F74+G74)","v":0},0,{"$f":"IF(P74=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P74,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Global EnglishⅡ",null,1,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF($Q75=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q75,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F75","v":0},{"$f":"IF($Q75=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q75,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G75","v":0},{"$f":"IF($Q75=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q75,目標ごとの達成度!$N$95:$N$103,0),1))*(F75+G75)","v":0},0,{"$f":"IF(P75=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P75,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"健康運動科学",null,null,"体育実技Ⅰ",1,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q76=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q76,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F76","v":0},{"$f":"IF($Q76=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q76,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G76","v":0},{"$f":"IF($Q76=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q76,目標ごとの達成度!$N$95:$N$103,0),1))*(F76+G76)","v":0},0,{"$f":"IF(P76=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P76,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"体育実技Ⅱ",1,null,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q77=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q77,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F77","v":0},{"$f":"IF($Q77=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q77,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G77","v":0},{"$f":"IF($Q77=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q77,目標ごとの達成度!$N$95:$N$103,0),1))*(F77+G77)","v":0},0,{"$f":"IF(P77=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P77,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"健康運動科学演習A",null,1,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q78=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q78,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F78","v":0},{"$f":"IF($Q78=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q78,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G78","v":0},{"$f":"IF($Q78=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q78,目標ごとの達成度!$N$95:$N$103,0),1))*(F78+G78)","v":0},0,{"$f":"IF(P78=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P78,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"健康運動科学演習B",null,1,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q79=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q79,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F79","v":0},{"$f":"IF($Q79=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q79,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*G79","v":0},{"$f":"IF($Q79=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($Q79,目標ごとの達成度!$N$95:$N$103,0),1))*(F79+G79)","v":0},0,{"$f":"IF(P79=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(P79,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S6:S79)","v":0},{"$f":"SUM(T6:T79)","v":0},0,0,null,{"$f":"SUM($X6:X79)","v":0},{"$f":"SUM($X6:Y79)","v":0},{"$f":"SUM($X6:Z79)","v":0},{"$f":"SUM($X6:AA79)","v":0},{"$f":"SUM($X6:AB79)","v":0},{"$f":"SUM($X6:AC79)","v":0},{"$f":"SUM($X6:AD79)","v":0},{"$f":"SUM($X6:AE79)","v":0},{"$f":"SUM($X6:AF79)","v":0},{"$f":"SUM($X6:AG79)","v":0},{"$f":"SUM($X6:AH79)","v":0},{"$f":"SUM($AI6:AI79)","v":0},{"$f":"SUM($AI6:AJ79)","v":0},{"$f":"SUM($AI6:AK79)","v":0},{"$f":"SUM($AI6:AL79)","v":0},{"$f":"SUM($AI6:AM79)","v":0},{"$f":"SUM($AI6:AN79)","v":0},{"$f":"SUM($AI6:AO79)","v":0},{"$f":"SUM($AI6:AP79)","v":0},{"$f":"SUM($AI6:AQ79)","v":0},{"$f":"SUM($AI6:AR79)","v":0},{"$f":"SUM($AI6:AS79)","v":0}]

{"sheet":"専門科目","index":1,"n_rows":51,"n_cols":43,"rows_kept":51,"cut":false,"hidden":false,"merged":[[36,2,47,2],[5,1,49,1],[10,2,23,2],[2,6,2,13],[2,1,4,2],[2,3,4,3],[2,4,3,5],[3,6,3,7],[3,8,3,9],[2,14,4,14],[0,3,0,15],[1,3,1,15],[3,10,3,11],[24,2,35,2],[2,15,4,15],[5,2,9,2],[3,12,3,13]]}
[null,null,null,"専門科目チェックシート"]
[null,null,null,"黄色背景の成績欄をドロップダウンリストによって入力すること\nバグや不具合があれば，森河（morikawa.yukihiro@nitech.ac.jp）まで．"]
[null,"区分",null,"授業科目名\n（すべて土木GPT対応科目）","単位数",null,"毎週授業時間数",null,null,null,null,null,null,null,"単位取得\n年度・学期","成績"]
[null,null,null,null,null,null,"1年次",null,"2年次",null,"3年次",null,"4年次"]
[null,null,null,null,"必修","選択","前期","後期","前期","後期","前期","後期","前期","後期",null,null,null,"必修単位","選択単位","GP","学期",1,2,3,4,5,6,7,8,9,10,11,1,2,3,4,5,6,7,8,9,10,11]
[null,"専門教育科目","学科共通科目","社会工学概論",2,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($P6=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P6,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E6","v":0},{"$f":"IF($P6=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P6,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F6","v":0},{"$f":"IF($P6=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P6,目標ごとの達成度!$N$95:$N$103,0),1))*(E6+F6)","v":0},{"$f":"IF(O6=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O6,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},{"$f":"IF($U6=V$5,$R6+$S6,0)","v":0},{"$f":"IF($U6=W$5,$R6+$S6,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($U6=AG$5,$T6,0)","v":0},{"$f":"IF($U6=AH$5,$T6,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"社会工学基礎Ⅰ",2,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($P7=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P7,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E7","v":0},{"$f":"IF($P7=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P7,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F7","v":0},{"$f":"IF($P7=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P7,目標ごとの達成度!$N$95:$N$103,0),1))*(E7+F7)","v":0},{"$f":"IF(O7=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O7,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},{"$f":"IF($U7=V$5,$R7+$S7,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($U7=AG$5,$T7,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"社会工学基礎Ⅱ",2,null,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($P8=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P8,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E8","v":0},{"$f":"IF($P8=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P8,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F8","v":0},{"$f":"IF($P8=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P8,目標ごとの達成度!$N$95:$N$103,0),1))*(E8+F8)","v":0},{"$f":"IF(O8=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O8,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"社会工学基礎Ⅲ",2,null,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($P9=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P9,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E9","v":0},{"$f":"IF($P9=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P9,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F9","v":0},{"$f":"IF($P9=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P9,目標ごとの達成度!$N$95:$N$103,0),1))*(E9+F9)","v":0},{"$f":"IF(O9=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O9,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"社会工学基礎Ⅳ",2,null,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($P10=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P10,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E10","v":0},{"$f":"IF($P10=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P10,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F10","v":0},{"$f":"IF($P10=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P10,目標ごとの達成度!$N$95:$N$103,0),1))*(E10+F10)","v":0},{"$f":"IF(O10=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O10,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"基盤科目","測量学",2,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($P11=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P11,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E11","v":0},{"$f":"IF($P11=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P11,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F11","v":0},{"$f":"IF($P11=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P11,目標ごとの達成度!$N$95:$N$103,0),1))*(E11+F11)","v":0},{"$f":"IF(O11=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O11,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"環境水理学Ⅰ",2,null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($P12=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P12,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E12","v":0},{"$f":"IF($P12=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P12,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F12","v":0},{"$f":"IF($P12=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P12,目標ごとの達成度!$N$95:$N$103,0),1))*(E12+F12)","v":0},{"$f":"IF(O12=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O12,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"環境生態学",2,null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($P13=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P13,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E13","v":0},{"$f":"IF($P13=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P13,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F13","v":0},{"$f":"IF($P13=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P13,目標ごとの達成度!$N$95:$N$103,0),1))*(E13+F13)","v":0},{"$f":"IF(O13=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O13,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"構造力学Ⅰ",2,null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($P14=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P14,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E14","v":0},{"$f":"IF($P14=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P14,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F14","v":0},{"$f":"IF($P14=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P14,目標ごとの達成度!$N$95:$N$103,0),1))*(E14+F14)","v":0},{"$f":"IF(O14=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O14,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"構築材質学",2,null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($P15=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P15,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E15","v":0},{"$f":"IF($P15=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P15,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F15","v":0},{"$f":"IF($P15=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P15,目標ごとの達成度!$N$95:$N$103,0),1))*(E15+F15)","v":0},{"$f":"IF(O15=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O15,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"地盤力学",2,null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($P16=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P16,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E16","v":0},{"$f":"IF($P16=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P16,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F16","v":0},{"$f":"IF($P16=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P16,目標ごとの達成度!$N$95:$N$103,0),1))*(E16+F16)","v":0},{"$f":"IF(O16=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O16,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"社会基盤計画学",2,null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($P17=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P17,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E17","v":0},{"$f":"IF($P17=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P17,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F17","v":0},{"$f":"IF($P17=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P17,目標ごとの達成度!$N$95:$N$103,0),1))*(E17+F17)","v":0},{"$f":"IF(O17=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O17,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"環境水理学Ⅱ",2,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($P18=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P18,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E18","v":0},{"$f":"IF($P18=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P18,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F18","v":0},{"$f":"IF($P18=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P18,目標ごとの達成度!$N$95:$N$103,0),1))*(E18+F18)","v":0},{"$f":"IF(O18=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O18,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"構造力学Ⅱ",2,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($P19=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P19,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E19","v":0},{"$f":"IF($P19=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P19,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F19","v":0},{"$f":"IF($P19=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P19,目標ごとの達成度!$N$95:$N$103,0),1))*(E19+F19)","v":0},{"$f":"IF(O19=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O19,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"コンクリート構造学",2,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($P20=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P20,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E20","v":0},{"$f":"IF($P20=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P20,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F20","v":0},{"$f":"IF($P20=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P20,目標ごとの達成度!$N$95:$N$103,0),1))*(E20+F20)","v":0},{"$f":"IF(O20=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O20,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"地盤解析学",2,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($P21=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P21,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E21","v":0},{"$f":"IF($P21=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P21,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F21","v":0},{"$f":"IF($P21=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P21,目標ごとの達成度!$N$95:$N$103,0),1))*(E21+F21)","v":0},{"$f":"IF(O21=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O21,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"環境都市技術者倫理",2,null,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($P22=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P22,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E22","v":0},{"$f":"IF($P22=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P22,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F22","v":0},{"$f":"IF($P22=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P22,目標ごとの達成度!$N$95:$N$103,0),1))*(E22+F22)","v":0},{"$f":"IF(O22=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O22,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"構造シミュレーション",2,null,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($P23=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P23,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E23","v":0},{"$f":"IF($P23=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P23,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F23","v":0},{"$f":"IF($P23=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P23,目標ごとの達成度!$N$95:$N$103,0),1))*(E23+F23)","v":0},{"$f":"IF(O23=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O23,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},{"$f":"IF($U23=V$5,$R23+$S23,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($U23=AG$5,$T23,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"交通環境計画学",2,null,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($P24=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P24,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E24","v":0},{"$f":"IF($P24=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P24,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F24","v":0},{"$f":"IF($P24=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P24,目標ごとの達成度!$N$95:$N$103,0),1))*(E24+F24)","v":0},{"$f":"IF(O24=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O24,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"展開科目","維持管理工学",null,2,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($P25=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P25,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E25","v":0},{"$f":"IF($P25=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P25,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F25","v":0},{"$f":"IF($P25=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P25,目標ごとの達成度!$N$95:$N$103,0),1))*(E25+F25)","v":0},{"$f":"IF(O25=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O25,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"環境地盤工学",null,2,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($P26=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P26,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E26","v":0},{"$f":"IF($P26=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P26,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F26","v":0},{"$f":"IF($P26=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P26,目標ごとの達成度!$N$95:$N$103,0),1))*(E26+F26)","v":0},{"$f":"IF(O26=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O26,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"構造設計学",null,2,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($P27=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P27,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E27","v":0},{"$f":"IF($P27=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P27,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F27","v":0},{"$f":"IF($P27=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P27,目標ごとの達成度!$N$95:$N$103,0),1))*(E27+F27)","v":0},{"$f":"IF(O27=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O27,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"都市・地域計画学",null,2,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($P28=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P28,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E28","v":0},{"$f":"IF($P28=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P28,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F28","v":0},{"$f":"IF($P28=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P28,目標ごとの達成度!$N$95:$N$103,0),1))*(E28+F28)","v":0},{"$f":"IF(O28=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O28,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"防災地質学",null,2,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($P29=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P29,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E29","v":0},{"$f":"IF($P29=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P29,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F29","v":0},{"$f":"IF($P29=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P29,目標ごとの達成度!$N$95:$N$103,0),1))*(E29+F29)","v":0},{"$f":"IF(O29=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O29,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"水域防災工学",null,2,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($P30=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P30,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E30","v":0},{"$f":"IF($P30=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P30,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F30","v":0},{"$f":"IF($P30=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P30,目標ごとの達成度!$N$95:$N$103,0),1))*(E30+F30)","v":0},{"$f":"IF(O30=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O30,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"建設マネジメント",null,2,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF($P31=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P31,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E31","v":0},{"$f":"IF($P31=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P31,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F31","v":0},{"$f":"IF($P31=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P31,目標ごとの達成度!$N$95:$N$103,0),1))*(E31+F31)","v":0},{"$f":"IF(O31=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O31,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"交通システム工学",null,2,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF($P32=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P32,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E32","v":0},{"$f":"IF($P32=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P32,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F32","v":0},{"$f":"IF($P32=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P32,目標ごとの達成度!$N$95:$N$103,0),1))*(E32+F32)","v":0},{"$f":"IF(O32=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O32,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"地震リスク工学",null,2,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF($P33=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P33,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E33","v":0},{"$f":"IF($P33=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P33,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F33","v":0},{"$f":"IF($P33=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P33,目標ごとの達成度!$N$95:$N$103,0),1))*(E33+F33)","v":0},{"$f":"IF(O33=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O33,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"耐震工学",null,2,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF($P34=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P34,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E34","v":0},{"$f":"IF($P34=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P34,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F34","v":0},{"$f":"IF($P34=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P34,目標ごとの達成度!$N$95:$N$103,0),1))*(E34+F34)","v":0},{"$f":"IF(O34=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O34,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"橋工学",null,2,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF($P35=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P35,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E35","v":0},{"$f":"IF($P35=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P35,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F35","v":0},{"$f":"IF($P35=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P35,目標ごとの達成度!$N$95:$N$103,0),1))*(E35+F35)","v":0},{"$f":"IF(O35=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O35,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"流域環境工学",null,2,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF($P36=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P36,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E36","v":0},{"$f":"IF($P36=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P36,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F36","v":0},{"$f":"IF($P36=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P36,目標ごとの達成度!$N$95:$N$103,0),1))*(E36+F36)","v":0},{"$f":"IF(O36=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O36,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"実験・演習","測量実習",1,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($P37=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P37,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E37","v":0},{"$f":"IF($P37=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P37,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F37","v":0},{"$f":"IF($P37=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P37,目標ごとの達成度!$N$95:$N$103,0),1))*(E37+F37)","v":0},{"$f":"IF(O37=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O37,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"環境都市情報技術",1,null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($P38=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P38,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E38","v":0},{"$f":"IF($P38=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P38,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F38","v":0},{"$f":"IF($P38=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P38,目標ごとの達成度!$N$95:$N$103,0),1))*(E38+F38)","v":0},{"$f":"IF(O38=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O38,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"環境都市基礎製図",1,null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($P39=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P39,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E39","v":0},{"$f":"IF($P39=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P39,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F39","v":0},{"$f":"IF($P39=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P39,目標ごとの達成度!$N$95:$N$103,0),1))*(E39+F39)","v":0},{"$f":"IF(O39=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O39,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},{"$f":"IF($U39=V$5,$R39+$S39,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($U39=AG$5,$T39,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"構造力学Ⅰ演習",1,null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($P40=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P40,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E40","v":0},{"$f":"IF($P40=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P40,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F40","v":0},{"$f":"IF($P40=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P40,目標ごとの達成度!$N$95:$N$103,0),1))*(E40+F40)","v":0},{"$f":"IF(O40=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O40,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"構造力学Ⅱ演習",1,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($P41=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P41,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E41","v":0},{"$f":"IF($P41=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P41,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F41","v":0},{"$f":"IF($P41=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P41,目標ごとの達成度!$N$95:$N$103,0),1))*(E41+F41)","v":0},{"$f":"IF(O41=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O41,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"環境水理学演習",1,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($P42=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P42,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E42","v":0},{"$f":"IF($P42=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P42,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F42","v":0},{"$f":"IF($P42=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P42,目標ごとの達成度!$N$95:$N$103,0),1))*(E42+F42)","v":0},{"$f":"IF(O42=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O42,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"地盤力学演習",1,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($P43=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P43,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E43","v":0},{"$f":"IF($P43=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P43,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F43","v":0},{"$f":"IF($P43=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P43,目標ごとの達成度!$N$95:$N$103,0),1))*(E43+F43)","v":0},{"$f":"IF(O43=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O43,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"社会基盤計画学演習",1,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($P44=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P44,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E44","v":0},{"$f":"IF($P44=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P44,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F44","v":0},{"$f":"IF($P44=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P44,目標ごとの達成度!$N$95:$N$103,0),1))*(E44+F44)","v":0},{"$f":"IF(O44=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O44,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"コンクリート構造学演習",1,null,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($P45=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P45,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E45","v":0},{"$f":"IF($P45=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P45,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F45","v":0},{"$f":"IF($P45=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P45,目標ごとの達成度!$N$95:$N$103,0),1))*(E45+F45)","v":0},{"$f":"IF(O45=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O45,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"環境都市工学実験Ⅰ",1,null,null,null,null,null,2,null,null,null,null,null,null,{"$f":"IF($P46=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P46,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E46","v":0},{"$f":"IF($P46=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P46,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F46","v":0},{"$f":"IF($P46=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P46,目標ごとの達成度!$N$95:$N$103,0),1))*(E46+F46)","v":0},{"$f":"IF(O46=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O46,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"環境都市工学実験Ⅱ",1,null,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF($P47=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P47,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E47","v":0},{"$f":"IF($P47=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P47,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F47","v":0},{"$f":"IF($P47=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P47,目標ごとの達成度!$N$95:$N$103,0),1))*(E47+F47)","v":0},{"$f":"IF(O47=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O47,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"環境都市設計製図",1,null,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF($P48=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P48,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E48","v":0},{"$f":"IF($P48=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P48,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F48","v":0},{"$f":"IF($P48=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P48,目標ごとの達成度!$N$95:$N$103,0),1))*(E48+F48)","v":0},{"$f":"IF(O48=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O48,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"実践研究セミナー",2,null,null,null,null,null,null,4,null,null,null,null,null,{"$f":"IF($P49=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P49,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E49","v":0},{"$f":"IF($P49=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P49,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F49","v":0},{"$f":"IF($P49=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P49,目標ごとの達成度!$N$95:$N$103,0),1))*(E49+F49)","v":0},{"$f":"IF(O49=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O49,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"卒業研究",8,null,null,null,null,null,null,null,20,20,null,null,null,{"$f":"IF($P50=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P50,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*E50","v":0},{"$f":"IF($P50=\"\",0,IF(INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P50,目標ごとの達成度!$N$95:$N$103,0),1)>0,1,0))*F50","v":0},{"$f":"IF($P50=\"\",0,INDEX(目標ごとの達成度!$O$95:$O$103,MATCH($P50,目標ごとの達成度!$N$95:$N$103,0),1))*(E50+F50)","v":0},{"$f":"IF(O50=\"\",99,INDEX(目標ごとの達成度!$M$109:$M$119,MATCH(O50,目標ごとの達成度!$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R6:R50)","v":0},{"$f":"SUM(S6:S50)","v":0},{"$f":"SUM(T6:T50)","v":0},null,{"$f":"SUM($V6:V50)","v":0},{"$f":"SUM($V6:W50)","v":0},{"$f":"SUM($V6:X50)","v":0},{"$f":"SUM($V6:Y50)","v":0},{"$f":"SUM($V6:Z50)","v":0},{"$f":"SUM($V6:AA50)","v":0},{"$f":"SUM($V6:AB50)","v":0},{"$f":"SUM($V6:AC50)","v":0},{"$f":"SUM($V6:AD50)","v":0},{"$f":"SUM($V6:AE50)","v":0},{"$f":"SUM($V6:AF50)","v":0},{"$f":"SUM($AG6:AG50)","v":0},{"$f":"SUM($AG6:AH50)","v":0},{"$f":"SUM($AG6:AI50)","v":0},{"$f":"SUM($AG6:AJ50)","v":0},{"$f":"SUM($AG6:AK50)","v":0},{"$f":"SUM($AG6:AL50)","v":0},{"$f":"SUM($AG6:AM50)","v":0},{"$f":"SUM($AG6:AN50)","v":0},{"$f":"SUM($AG6:AO50)","v":0},{"$f":"SUM($AG6:AP50)","v":0},{"$f":"SUM($AG6:AQ50)","v":0}]

{"sheet":"土木GPT","index":2,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[11,6,11,7],[26,1,26,2],[26,3,26,9],[20,3,20,9],[21,8,25,9],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[25,3,25,7],[11,3,11,5],[27,1,27,2],[27,3,27,9],[19,1,19,9],[20,1,20,2],[21,1,25,1],[8,8,8,9],[9,8,9,9],[3,1,7,1],[8,1,8,2],[3,7,7,7],[3,9,7,9],[3,4,7,4],[8,6,8,7],[9,6,9,7],[8,3,8,4],[9,3,9,4],[9,1,9,2],[0,1,0,9],[1,3,1,5],[1,1,2,2],[1,8,2,9],[2,3,2,4],[1,6,2,7]]}
[null,"集計結果"]
[null,"科目区分",null,"取得単位数",null,null,"GPT(参考値)",null,"GPA(参考値)"]
[null,null,null,"必修＋選択",null,"必修"]
[null,"共通科目","人間社会",{"$f":"SUM(共通科目!S6:T34)","v":0},{"$f":"SUM(D4:D8)","v":0},{"$f":"SUM(共通科目!S6:S34)","v":0},{"$f":"SUM(共通科目!U6:U34)","v":0},{"$f":"SUM(G4:G8)","v":0},{"$f":"IF(D4=0,0,G4/D4)","v":0},{"$f":"IF(E4=0,0,H4/E4)","v":0}]
[null,null,"自然科学基礎",{"$f":"SUM(共通科目!S35:T49)","v":0},null,{"$f":"SUM(共通科目!S35:S49)","v":0},{"$f":"SUM(共通科目!U35:U49)","v":0},null,{"$f":"IF(D5=0,0,G5/D5)","v":0}]
[null,null,"産業・経営リテラシー",{"$f":"SUM(共通科目!S50:T67)","v":0},null,{"$f":"SUM(共通科目!S50:S67)","v":0},{"$f":"SUM(共通科目!U50:U67)","v":0},null,0]
[null,null,"グローバルコミュニケーション",{"$f":"SUM(共通科目!S68:T75)","v":0},null,{"$f":"SUM(共通科目!S68:S75)","v":0},{"$f":"SUM(共通科目!U68:U75)","v":0},null,0]
[null,null,"健康運動科学",{"$f":"SUM(共通科目!S76:T79)","v":0},null,{"$f":"SUM(共通科目!S76:S79)","v":0},{"$f":"SUM(共通科目!U76:U79)","v":0},null,0]
[null,"専門教育科目",null,{"$f":"SUM(専門科目!R6:S50)","v":0},null,{"$f":"SUM(専門科目!R6:R50)","v":0},{"$f":"SUM(専門科目!T6:T50)","v":0},null,0]
[null,"合計",null,{"$f":"E4+D9","v":0},null,{"$f":"SUM(F4:F9)","v":0},{"$f":"H4+G9","v":0},null,0]
[]
[null,null,null,"土木GPT(重要)",null,null,{"$f":"SUM(共通科目!V6:V79)+G9","v":0}]
[null,"計算条件"]
[null,null,"・対象科目は，共通科目の一部と環境都市分野の専門科目すべて"]
[null,null,"・対象となる共通科目は，「共通科目」タブの科目のうち，科目名の左に○がついたもの"]
[null,null,"・除外科目はない"]
[null,null,"・卒研（合はA扱い）や単位認定（科目一覧にあれば），再受講免除の科目も含む"]
[null,null,"・GPAの分母は履修登録単位数ではなく，取得単位数"]
[]
[null,"卒業認定基準"]
[null,"科目区分",null,"条件"]
[null,"共通科目","人間社会","必修2単位及び複数区分から8単位",null,null,null,null,"左記条件を満たし，\n50単位以上"]
[null,null,"自然科学基礎","必修全科目を含めて20単位"]
[null,null,"産業・経営リテラシー","必修2単位及び経営リテラシー区分から4単位"]
[null,null,"グローバルコミュニケーション","必修8単位"]
[null,null,"健康運動科学","必修2単位"]
[null,"専門教育科目",null,"必修全科目を含め74単位以上"]
[null,"合計",null,"124単位以上"]

{"sheet":"目標ごとの達成度","index":3,"n_rows":119,"n_cols":37,"rows_kept":119,"cut":false,"hidden":false,"merged":[[1,2,1,3],[40,2,40,3],[19,2,19,3],[4,2,4,3],[14,2,14,3],[57,2,57,3],[59,2,59,3],[50,9,58,9],[59,9,65,9],[44,2,44,3],[45,2,45,3],[43,2,43,3],[48,2,48,3],[2,9,11,9],[12,9,23,9],[2,8,11,8],[40,9,49,9],[25,2,25,3],[12,8,23,8],[12,2,12,3],[17,2,17,3],[2,2,2,3],[3,2,3,3],[0,0,0,10],[16,2,16,3],[1,0,1,1],[2,10,11,10],[12,10,23,10],[56,2,56,3],[2,0,39,0],[28,2,28,3],[2,1,11,1],[27,2,27,3],[29,2,39,2],[22,2,22,3],[41,2,41,3],[50,8,58,8],[51,2,51,3],[52,2,52,3],[49,2,49,3],[46,2,46,3],[53,2,53,3],[50,2,50,3],[54,2,54,3],[58,2,58,3],[12,1,23,1],[5,2,5,3],[8,2,8,3],[18,2,18,3],[6,2,6,3],[7,2,7,3],[13,2,13,3],[23,2,23,3],[10,2,10,3],[11,2,11,3],[15,2,15,3],[20,2,20,3],[21,2,21,3],[9,2,9,3],[24,10,39,10],[72,2,72,3],[68,2,68,3],[72,10,86,10],[59,8,65,8],[59,10,65,10],[66,10,71,10],[82,2,82,3],[84,2,84,3],[75,2,75,3],[64,2,64,3],[63,2,63,3],[62,2,62,3],[66,9,71,9],[61,2,61,3],[74,2,74,3],[77,2,77,3],[78,2,78,3],[76,2,76,3],[72,9,86,9],[83,2,83,3],[73,2,73,3],[86,2,86,3],[70,2,70,3],[87,8,92,8],[72,8,86,8],[87,9,92,9],[67,2,67,3],[50,1,58,1],[24,1,39,1],[40,1,49,1],[66,1,71,1],[24,2,24,3],[59,1,65,1],[87,1,92,1],[91,2,91,3],[89,2,89,3],[72,1,86,1],[80,2,80,3],[55,2,55,3],[40,0,65,0],[66,8,71,8],[40,8,49,8],[24,8,39,8],[26,2,26,3],[60,2,60,3],[65,2,65,3],[40,10,49,10],[47,2,47,3],[24,9,39,9],[42,2,42,3],[50,10,58,10],[66,0,92,0],[71,2,71,3],[69,2,69,3],[66,2,66,3],[90,2,90,3],[85,2,85,3],[87,2,87,3],[88,2,88,3],[79,2,79,3],[81,2,81,3],[92,2,92,3],[87,10,92,10]]}
["「学習・教育到達目標」ごとの達成度"]
["学習・教育到達目標",null,"関連する科目（◎必修）",null,"開講時期","単位数","単位取得\n年度・学期","成績","取得\n単位数","GPT","GPA",null,"点数","取得単位数","学期",1,2,3,4,5,6,7,8,9,10,11,1,2,3,4,5,6,7,8,9,10,11]
["Ⅰ　幅広い教養と技術者倫理","(A) 科学技術基礎\n(科学技術の共通基礎科目として数学・外国語・情報処理能力を習得する)","◎線形代数Ⅰ",null,"１年前期",2,{"$f":"VLOOKUP(RIGHT(C3,LEN(C3)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C3,LEN(C3)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},{"$f":"SUM(N3:N12)","v":0},{"$f":"IF(SUM(N3:N12)=0,\"0\",SUM(M3:M12))","v":"0"},{"$f":"IF(SUM(N3:N12)=0,\"0\",SUM(M3:M12)/SUM(N3:N12))","v":"0"},null,{"$f":"IF(OR(F3=\"\",H3=\"\"),0,F3*INDEX($O$95:$O$104,MATCH(H3,$N$95:$N$104,0),1))","v":0},{"$f":"IF(OR(F3=\"\",H3=\"\"),0,F3*IF(INDEX($O$95:$O$104,MATCH(H3,$N$95:$N$104,0),1)>0,1,0))","v":0},{"$f":"IF(G3=\"\",99,INDEX($M$109:$M$119,MATCH(G3,$N$109:$N$119,0),1))","v":99},{"$f":"IF($O3=AA$2,$N3,0)","v":0},{"$f":"IF($O3=AB$2,$N3,0)","v":0},{"$f":"IF($O3=AC$2,$N3,0)","v":0},{"$f":"IF($O3=AD$2,$N3,0)","v":0},{"$f":"IF($O3=AE$2,$N3,0)","v":0},{"$f":"IF($O3=AF$2,$N3,0)","v":0},{"$f":"IF($O3=AG$2,$N3,0)","v":0},{"$f":"IF($O3=AH$2,$N3,0)","v":0},{"$f":"IF($O3=AI$2,$N3,0)","v":0},{"$f":"IF($O3=AJ$2,$N3,0)","v":0},{"$f":"IF($O3=AK$2,$N3,0)","v":0},{"$f":"IF($O3=AA$2,$M3,0)","v":0},{"$f":"IF($O3=AB$2,$M3,0)","v":0},{"$f":"IF($O3=AC$2,$M3,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,"◎線形代数Ⅱ",null,"１年後期",2,{"$f":"VLOOKUP(RIGHT(C4,LEN(C4)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C4,LEN(C4)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,{"$f":"IF($O4=AA$2,$N4,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($O4=AA$2,$M4,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"◎微分積分Ⅰ及び演習",null,"１年前期",3,{"$f":"VLOOKUP(RIGHT(C5,LEN(C5)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C5,LEN(C5)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　微分積分Ⅱ及び演習",null,"１年後期",3,{"$f":"VLOOKUP(RIGHT(C6,LEN(C6)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C6,LEN(C6)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎社会工学基礎Ⅰ",null,"１年前期",2,{"$f":"VLOOKUP(RIGHT(C7,LEN(C7)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C7,LEN(C7)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,{"$f":"IF($O7=AA$2,$N7,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎社会工学基礎Ⅱ",null,"１年後期",2,{"$f":"VLOOKUP(RIGHT(C8,LEN(C8)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C8,LEN(C8)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境都市情報技術",null,"２年前期",1,{"$f":"VLOOKUP(RIGHT(C9,LEN(C9)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C9,LEN(C9)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎Academic EnglishⅠ",null,"１年前期",2,{"$f":"VLOOKUP(RIGHT(C10,LEN(C10)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C10,LEN(C10)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,{"$f":"IF($O10=AA$2,$N10,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎Academic EnglishⅡ",null,"１年後期",2,{"$f":"VLOOKUP(RIGHT(C11,LEN(C11)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C11,LEN(C11)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎Academic EnglishⅢ",null,"２年前期",2,{"$f":"VLOOKUP(RIGHT(C12,LEN(C12)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C12,LEN(C12)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"(B) 自然科学 \n(自然科学全般に関する広い知識を修得し、科学的思考能力を高める)","◎力学",null,"１年前期",2,{"$f":"VLOOKUP(RIGHT(C13,LEN(C13)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C13,LEN(C13)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},{"$f":"SUM(N13:N24)","v":0},{"$f":"IF(SUM(N13:N24)=0,\"0\",SUM(M13:M24))","v":"0"},{"$f":"IF(SUM(N13:N24)=0,\"0\",SUM(M13:M24)/SUM(N13:N24))","v":"0"},null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　物理学演習Ⅰ",null,"１年前期",1,{"$f":"VLOOKUP(RIGHT(C14,LEN(C14)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C14,LEN(C14)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　物理学実験",null,"１年後期",2,{"$f":"VLOOKUP(RIGHT(C15,LEN(C15)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C15,LEN(C15)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　電磁気学",null,"１年後期",2,{"$f":"VLOOKUP(RIGHT(C16,LEN(C16)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C16,LEN(C16)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　基礎化学",null,"１年後期",2,{"$f":"VLOOKUP(RIGHT(C17,LEN(C17)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C17,LEN(C17)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　化学結合論",null,"１年前期",2,{"$f":"VLOOKUP(RIGHT(C18,LEN(C18)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C18,LEN(C18)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　地球科学",null,"２年前期",2,{"$f":"VLOOKUP(RIGHT(C19,LEN(C19)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C19,LEN(C19)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($O19=AB$2,$M19,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"　地球科学実験",null,"２年後期",1,{"$f":"VLOOKUP(RIGHT(C20,LEN(C20)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C20,LEN(C20)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($O20=AA$2,$M20,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境生態学",null,"２年前期",2,{"$f":"VLOOKUP(RIGHT(C21,LEN(C21)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C21,LEN(C21)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　生体機能科学",null,"２年後期",2,{"$f":"VLOOKUP(RIGHT(C22,LEN(C22)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C22,LEN(C22)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,{"$f":"IF($O22=AA$2,$N22,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　専門基礎科学Ⅰ（留学生）",null,"１年前期",2,{"$f":"VLOOKUP(RIGHT(C23,LEN(C23)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C23,LEN(C23)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　専門基礎科学Ⅱ（留学生）",null,"１年後期",2,{"$f":"VLOOKUP(RIGHT(C24,LEN(C24)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C24,LEN(C24)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"(C) 多面的思考と技術者倫理 \n(人類の文化，社会や自然に関する多面的な思考力を修得し，技術者としての倫理・責任感を身につける)","◎環境生態学",null,"２年前期",2,{"$f":"VLOOKUP(RIGHT(C25,LEN(C25)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C25,LEN(C25)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},{"$f":"SUM(N25:N40)","v":0},{"$f":"IF(SUM(N25:N40)=0,\"0\",SUM(M25:M40))","v":"0"},{"$f":"IF(SUM(N25:N40)=0,\"0\",SUM(M25:M40)/SUM(N25:N40))","v":"0"},null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎産業論",null,"２年後期",2,{"$f":"VLOOKUP(RIGHT(C26,LEN(C26)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C26,LEN(C26)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境都市技術者倫理",null,"２年後期",2,{"$f":"VLOOKUP(RIGHT(C27,LEN(C27)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C27,LEN(C27)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎実践研究セミナー",null,"３年後期",2,{"$f":"VLOOKUP(RIGHT(C28,LEN(C28)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C28,LEN(C28)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　建設マネジメント",null,"３年後期",2,{"$f":"VLOOKUP(RIGHT(C29,LEN(C29)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C29,LEN(C29)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"人間社会",{"$f":"SearchKamoku(共通科目!E$7:Q$34,\"\")","v":""},{"$f":"IF(D30=\"\",\"\",\"１～２年\")","v":""},{"$f":"IF(D30=\"\",\"\",INDEX(共通科目!$G$7:$G$49,MATCH(D30,共通科目!$E$7:$E$49,0),1))","v":""},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,共通科目!E$6:Q$79,12,FALSE)&\"\")","v":""},{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,共通科目!E$6:Q$79,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D30=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D30))","v":""},{"$f":"IF(D31=\"\",\"\",\"１～２年\")","v":""},{"$f":"IF(D31=\"\",\"\",INDEX(共通科目!$G$7:$G$49,MATCH(D31,共通科目!$E$7:$E$49,0),1))","v":""},{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,共通科目!E$6:Q$79,12,FALSE)&\"\")","v":""},{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,共通科目!E$6:Q$79,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D31=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D31))","v":""},{"$f":"IF(D32=\"\",\"\",\"１～２年\")","v":""},{"$f":"IF(D32=\"\",\"\",INDEX(共通科目!$G$7:$G$49,MATCH(D32,共通科目!$E$7:$E$49,0),1))","v":""},{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,共通科目!E$6:Q$79,12,FALSE)&\"\")","v":""},{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,共通科目!E$6:Q$79,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,{"$f":"IF(G32=\"\",99,INDEX($M$109:$M$119,MATCH(G32,$N$109:$N$119,0),1))","v":99},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($O32=AA$2,$M32,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D32=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D32))","v":""},"",{"$f":"IF(D33=\"\",\"\",INDEX(共通科目!$G$7:$G$49,MATCH(D33,共通科目!$E$7:$E$49,0),1))","v":""},{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,共通科目!E$6:Q$79,12,FALSE)&\"\")","v":""},{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,共通科目!E$6:Q$79,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D33=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D33))","v":""},"",{"$f":"IF(D34=\"\",\"\",INDEX(共通科目!$G$7:$G$49,MATCH(D34,共通科目!$E$7:$E$49,0),1))","v":""},{"$f":"IF(D34=\"\",\"\",VLOOKUP(D34,共通科目!E$6:Q$79,12,FALSE)&\"\")","v":""},{"$f":"IF(D34=\"\",\"\",VLOOKUP(D34,共通科目!E$6:Q$79,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,99,{"$f":"IF($O34=AA$2,$N34,0)","v":0},{"$f":"IF($O34=AB$2,$N34,0)","v":0},{"$f":"IF($O34=AC$2,$N34,0)","v":0},{"$f":"IF($O34=AD$2,$N34,0)","v":0},{"$f":"IF($O34=AE$2,$N34,0)","v":0},{"$f":"IF($O34=AF$2,$N34,0)","v":0},{"$f":"IF($O34=AG$2,$N34,0)","v":0},{"$f":"IF($O34=AH$2,$N34,0)","v":0},{"$f":"IF($O34=AI$2,$N34,0)","v":0},{"$f":"IF($O34=AJ$2,$N34,0)","v":0},{"$f":"IF($O34=AK$2,$N34,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D34=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D34))","v":""},"",{"$f":"IF(D35=\"\",\"\",INDEX(共通科目!$G$7:$G$49,MATCH(D35,共通科目!$E$7:$E$49,0),1))","v":""},{"$f":"IF(D35=\"\",\"\",VLOOKUP(D35,共通科目!E$6:Q$79,12,FALSE)&\"\")","v":""},{"$f":"IF(D35=\"\",\"\",VLOOKUP(D35,共通科目!E$6:Q$79,13,FALSE)&\"\")","v":""},null,null,null,null,{"$f":"IF(OR(F35=\"\",H35=\"\"),0,F35*INDEX($O$95:$O$104,MATCH(H35,$N$95:$N$104,0),1))","v":0},{"$f":"IF(OR(F35=\"\",H35=\"\"),0,F35*IF(INDEX($O$95:$O$104,MATCH(H35,$N$95:$N$104,0),1)>0,1,0))","v":0},99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D35=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D35))","v":""},"",{"$f":"IF(D36=\"\",\"\",INDEX(共通科目!$G$7:$G$49,MATCH(D36,共通科目!$E$7:$E$49,0),1))","v":""},{"$f":"IF(D36=\"\",\"\",VLOOKUP(D36,共通科目!E$6:Q$79,12,FALSE)&\"\")","v":""},{"$f":"IF(D36=\"\",\"\",VLOOKUP(D36,共通科目!E$6:Q$79,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D36=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D36))","v":""},"",{"$f":"IF(D37=\"\",\"\",INDEX(共通科目!$G$7:$G$49,MATCH(D37,共通科目!$E$7:$E$49,0),1))","v":""},{"$f":"IF(D37=\"\",\"\",VLOOKUP(D37,共通科目!E$6:Q$79,12,FALSE)&\"\")","v":""},{"$f":"IF(D37=\"\",\"\",VLOOKUP(D37,共通科目!E$6:Q$79,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D37=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D37))","v":""},"",{"$f":"IF(D38=\"\",\"\",INDEX(共通科目!$G$7:$G$49,MATCH(D38,共通科目!$E$7:$E$49,0),1))","v":""},{"$f":"IF(D38=\"\",\"\",VLOOKUP(D38,共通科目!E$6:Q$79,12,FALSE)&\"\")","v":""},{"$f":"IF(D38=\"\",\"\",VLOOKUP(D38,共通科目!E$6:Q$79,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D38=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D38))","v":""},"",{"$f":"IF(D39=\"\",\"\",INDEX(共通科目!$G$7:$G$49,MATCH(D39,共通科目!$E$7:$E$49,0),1))","v":""},{"$f":"IF(D39=\"\",\"\",VLOOKUP(D39,共通科目!E$6:Q$79,12,FALSE)&\"\")","v":""},{"$f":"IF(D39=\"\",\"\",VLOOKUP(D39,共通科目!E$6:Q$79,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D39=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D39))","v":""},"",{"$f":"IF(D40=\"\",\"\",INDEX(共通科目!$G$7:$G$49,MATCH(D40,共通科目!$E$7:$E$49,0),1))","v":""},{"$f":"IF(D40=\"\",\"\",VLOOKUP(D40,共通科目!E$6:Q$79,12,FALSE)&\"\")","v":""},{"$f":"IF(D40=\"\",\"\",VLOOKUP(D40,共通科目!E$6:Q$79,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Ⅱ　基礎的学理・専門知識・応用能力","(D) 主要専門基礎 \n(主要専門科目の基礎を身につける)","◎社会工学概論",null,"１年前期",2,{"$f":"VLOOKUP(RIGHT(C41,LEN(C41)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C41,LEN(C41)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},{"$f":"SUM(N41:N50)","v":0},{"$f":"IF(SUM(N41:N50)=0,\"0\",SUM(M41:M50))","v":"0"},{"$f":"IF(SUM(N41:N50)=0,\"0\",SUM(M41:M50)/SUM(N41:N50))","v":"0"},null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎構造力学Ⅰ",null,"２年前期",2,{"$f":"VLOOKUP(RIGHT(C42,LEN(C42)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C42,LEN(C42)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,{"$f":"IF($O42=AA$2,$N42,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎構造力学Ⅱ",null,"２年後期",2,{"$f":"VLOOKUP(RIGHT(C43,LEN(C43)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C43,LEN(C43)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎構築材質学",null,"２年前期",2,{"$f":"VLOOKUP(RIGHT(C44,LEN(C44)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C44,LEN(C44)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎コンクリート構造学",null,"２年後期",2,{"$f":"VLOOKUP(RIGHT(C45,LEN(C45)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C45,LEN(C45)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎地盤力学",null,"２年前期",2,{"$f":"VLOOKUP(RIGHT(C46,LEN(C46)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C46,LEN(C46)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境水理学Ⅰ",null,"２年前期",2,{"$f":"VLOOKUP(RIGHT(C47,LEN(C47)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C47,LEN(C47)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境水理学Ⅱ",null,"２年後期",2,{"$f":"VLOOKUP(RIGHT(C48,LEN(C48)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C48,LEN(C48)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎社会基盤計画学",null,"２年前期",2,{"$f":"VLOOKUP(RIGHT(C49,LEN(C49)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C49,LEN(C49)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($O49=AA$2,$M49,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"◎測量学",null,"１年前期",2,{"$f":"VLOOKUP(RIGHT(C50,LEN(C50)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C50,LEN(C50)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"(E) 自主学習・応用能力\n(演習を通じて、自己学習の習慣を身につけ、応用能力を高める)","◎社会工学基礎Ⅲ",null,"１年後期",2,{"$f":"VLOOKUP(RIGHT(C51,LEN(C51)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C51,LEN(C51)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},{"$f":"SUM(N51:N59)","v":0},{"$f":"IF(SUM(N51:N59)=0,\"0\",SUM(M51:M59))","v":"0"},{"$f":"IF(SUM(N51:N59)=0,\"0\",SUM(M51:M59)/SUM(N51:N59))","v":"0"},null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎構造力学Ⅰ演習",null,"２年前期",1,{"$f":"VLOOKUP(RIGHT(C52,LEN(C52)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C52,LEN(C52)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎構造力学Ⅱ演習",null,"２年後期",1,{"$f":"VLOOKUP(RIGHT(C53,LEN(C53)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C53,LEN(C53)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎コンクリート構造学演習",null,"３年前期",1,{"$f":"VLOOKUP(RIGHT(C54,LEN(C54)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C54,LEN(C54)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎地盤力学演習",null,"２年後期",1,{"$f":"VLOOKUP(RIGHT(C55,LEN(C55)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C55,LEN(C55)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境水理学演習",null,"２年後期",1,{"$f":"VLOOKUP(RIGHT(C56,LEN(C56)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C56,LEN(C56)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎社会基盤計画学演習",null,"２年後期",1,{"$f":"VLOOKUP(RIGHT(C57,LEN(C57)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C57,LEN(C57)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境都市基礎製図",null,"２年前期",1,{"$f":"VLOOKUP(RIGHT(C58,LEN(C58)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C58,LEN(C58)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境都市設計製図",null,"３年後期",1,{"$f":"VLOOKUP(RIGHT(C59,LEN(C59)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C59,LEN(C59)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"(F) チームによる実体験\n(実験・実習を通して現象の理解を深めるとともに，チームワーク能力を身につける)","◎フレッシュマンセミナー",null,"１年前期",2,{"$f":"VLOOKUP(RIGHT(C60,LEN(C60)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C60,LEN(C60)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},{"$f":"SUM(N60:N66)","v":0},{"$f":"IF(SUM(N60:N66)=0,\"0\",SUM(M60:M66))","v":"0"},{"$f":"IF(SUM(N60:N66)=0,\"0\",SUM(M60:M66)/SUM(N60:N66))","v":"0"},null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎測量実習",null,"１年前期",1,{"$f":"VLOOKUP(RIGHT(C61,LEN(C61)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C61,LEN(C61)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,{"$f":"IF(OR(F61=\"\",H61=\"\"),0,F61*INDEX($O$95:$O$104,MATCH(H61,$N$95:$N$104,0),1))","v":0},{"$f":"IF(OR(F61=\"\",H61=\"\"),0,F61*IF(INDEX($O$95:$O$104,MATCH(H61,$N$95:$N$104,0),1)>0,1,0))","v":0},99,{"$f":"IF($O61=AA$2,$N61,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎社会工学基礎Ⅳ",null,"１年後期",2,{"$f":"VLOOKUP(RIGHT(C62,LEN(C62)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C62,LEN(C62)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　物理学実験",null,"１年後期",2,{"$f":"VLOOKUP(RIGHT(C63,LEN(C63)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C63,LEN(C63)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,{"$f":"IF($O63=AB$2,$N63,0)","v":0},{"$f":"IF($O63=AC$2,$N63,0)","v":0},{"$f":"IF($O63=AD$2,$N63,0)","v":0},{"$f":"IF($O63=AE$2,$N63,0)","v":0},{"$f":"IF($O63=AF$2,$N63,0)","v":0},{"$f":"IF($O63=AG$2,$N63,0)","v":0},{"$f":"IF($O63=AH$2,$N63,0)","v":0},{"$f":"IF($O63=AI$2,$N63,0)","v":0},{"$f":"IF($O63=AJ$2,$N63,0)","v":0},{"$f":"IF($O63=AK$2,$N63,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　地球科学実験",null,"２年後期",1,{"$f":"VLOOKUP(RIGHT(C64,LEN(C64)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C64,LEN(C64)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,{"$f":"IF(G64=\"\",99,INDEX($M$109:$M$119,MATCH(G64,$N$109:$N$119,0),1))","v":99},{"$f":"IF($O64=AA$2,$N64,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境都市工学実験Ⅰ",null,"３年前期",1,{"$f":"VLOOKUP(RIGHT(C65,LEN(C65)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C65,LEN(C65)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,{"$f":"IF($O65=AA$2,$N65,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($O65=AA$2,$M65,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境都市工学実験Ⅱ",null,"３年後期",1,{"$f":"VLOOKUP(RIGHT(C66,LEN(C66)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C66,LEN(C66)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Ⅲ　社会に貢献できる技術者としての素養","(G) コミュニケーション能力  (説明責任を果たすためのコミュニケーション能力を習得する)","◎フレッシュマンセミナー",null,"１年前期",2,{"$f":"VLOOKUP(RIGHT(C67,LEN(C67)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C67,LEN(C67)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},{"$f":"SUM(N67:N72)","v":0},{"$f":"IF(SUM(N67:N72)=0,\"0\",SUM(M67:M72))","v":"0"},{"$f":"IF(SUM(N67:N72)=0,\"0\",SUM(M67:M72)/SUM(N67:N72))","v":"0"},null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎測量実習",null,"１年前期",1,{"$f":"VLOOKUP(RIGHT(C68,LEN(C68)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C68,LEN(C68)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎English SeminarⅠ",null,"１年前期",1,{"$f":"VLOOKUP(RIGHT(C69,LEN(C69)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C69,LEN(C69)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎English SeminarⅡ",null,"１年後期",1,{"$f":"VLOOKUP(RIGHT(C70,LEN(C70)-1),共通科目!E$6:Q$79,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C70,LEN(C70)-1),共通科目!E$6:Q$79,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎実践研究セミナー",null,"３年後期",2,{"$f":"VLOOKUP(RIGHT(C71,LEN(C71)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C71,LEN(C71)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎卒業研究",null,"４年次",8,{"$f":"VLOOKUP(RIGHT(C72,LEN(C72)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C72,LEN(C72)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"(H) 社会基盤整備の応用技術\n(社会基盤の整備に対する基本的理論と応用的な技術を習得する)","◎地盤解析学",null,"２年後期",2,{"$f":"VLOOKUP(RIGHT(C73,LEN(C73)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C73,LEN(C73)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},{"$f":"SUM(N73:N87)","v":0},{"$f":"IF(SUM(N73:N87)=0,\"0\",SUM(M73:M87))","v":"0"},{"$f":"IF(SUM(N73:N87)=0,\"0\",SUM(M73:M87)/SUM(N73:N87))","v":"0"},null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎構造シミュレーション",null,"３年前期",2,{"$f":"VLOOKUP(RIGHT(C74,LEN(C74)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C74,LEN(C74)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　構造設計学",null,"３年前期",2,{"$f":"VLOOKUP(RIGHT(C75,LEN(C75)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C75,LEN(C75)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　橋工学",null,"３年後期",2,{"$f":"VLOOKUP(RIGHT(C76,LEN(C76)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C76,LEN(C76)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,{"$f":"IF($O76=AA$2,$N76,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　耐震工学",null,"３年後期",2,{"$f":"VLOOKUP(RIGHT(C77,LEN(C77)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C77,LEN(C77)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　地震リスク工学",null,"３年後期",2,{"$f":"VLOOKUP(RIGHT(C78,LEN(C78)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C78,LEN(C78)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　維持管理工学",null,"３年前期",2,{"$f":"VLOOKUP(RIGHT(C79,LEN(C79)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C79,LEN(C79)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　環境地盤工学",null,"３年前期",2,{"$f":"VLOOKUP(RIGHT(C80,LEN(C80)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C80,LEN(C80)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　防災地質学",null,"３年前期",2,{"$f":"VLOOKUP(RIGHT(C81,LEN(C81)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C81,LEN(C81)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,{"$f":"IF(OR(F81=\"\",H81=\"\"),0,F81*INDEX($O$95:$O$104,MATCH(H81,$N$95:$N$104,0),1))","v":0},{"$f":"IF(OR(F81=\"\",H81=\"\"),0,F81*IF(INDEX($O$95:$O$104,MATCH(H81,$N$95:$N$104,0),1)>0,1,0))","v":0},{"$f":"IF(G81=\"\",99,INDEX($M$109:$M$119,MATCH(G81,$N$109:$N$119,0),1))","v":99},{"$f":"IF($O81=AA$2,$N81,0)","v":0},{"$f":"IF($O81=AB$2,$N81,0)","v":0},{"$f":"IF($O81=AC$2,$N81,0)","v":0},{"$f":"IF($O81=AD$2,$N81,0)","v":0},{"$f":"IF($O81=AE$2,$N81,0)","v":0},{"$f":"IF($O81=AF$2,$N81,0)","v":0},{"$f":"IF($O81=AG$2,$N81,0)","v":0},{"$f":"IF($O81=AH$2,$N81,0)","v":0},{"$f":"IF($O81=AI$2,$N81,0)","v":0},{"$f":"IF($O81=AJ$2,$N81,0)","v":0},{"$f":"IF($O81=AK$2,$N81,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　水域防災工学",null,"３年前期",2,{"$f":"VLOOKUP(RIGHT(C82,LEN(C82)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C82,LEN(C82)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　流域環境工学",null,"３年後期",2,{"$f":"VLOOKUP(RIGHT(C83,LEN(C83)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C83,LEN(C83)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($O83=AA$2,$M83,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"◎交通環境計画学",null,"３年前期",2,{"$f":"VLOOKUP(RIGHT(C84,LEN(C84)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C84,LEN(C84)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　交通システム工学",null,"３年後期",2,{"$f":"VLOOKUP(RIGHT(C85,LEN(C85)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C85,LEN(C85)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　都市・地域計画学",null,"３年前期",2,{"$f":"VLOOKUP(RIGHT(C86,LEN(C86)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C86,LEN(C86)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　建設マネジメント",null,"３年後期",2,{"$f":"VLOOKUP(RIGHT(C87,LEN(C87)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C87,LEN(C87)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"(I) デザイン能力\n(自ら問題を発見し，調査・分析・評価・提案を行うことにより問題を解決する能力を身につける)","◎社会工学基礎Ⅳ",null,"１年後期",2,{"$f":"VLOOKUP(RIGHT(C88,LEN(C88)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C88,LEN(C88)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},{"$f":"SUM(N88:N93)","v":0},{"$f":"IF(SUM(N88:N93)=0,\"0\",SUM(M88:M93))","v":"0"},{"$f":"IF(SUM(N88:N93)=0,\"0\",SUM(M88:M93)/SUM(N88:N93))","v":"0"},null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境都市工学実験Ⅰ",null,"３年前期",1,{"$f":"VLOOKUP(RIGHT(C89,LEN(C89)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C89,LEN(C89)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境都市工学実験Ⅱ",null,"３年後期",1,{"$f":"VLOOKUP(RIGHT(C90,LEN(C90)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C90,LEN(C90)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,{"$f":"IF($O90=AA$2,$N90,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境都市設計製図",null,"３年後期",1,{"$f":"VLOOKUP(RIGHT(C91,LEN(C91)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C91,LEN(C91)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎実践研究セミナー",null,"３年後期",2,{"$f":"VLOOKUP(RIGHT(C92,LEN(C92)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C92,LEN(C92)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"◎卒業研究",null,"４年次",8,{"$f":"VLOOKUP(RIGHT(C93,LEN(C93)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C93,LEN(C93)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"S",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"B",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"C",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"D",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"単位認定",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"合",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"否",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"入学年度",30]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"年度"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"\"平成\"&O$106&\"年前期\"","v":"平成30年前期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"\"平成\"&O$106&\"年後期\"","v":"平成30年後期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"\"平成\"&O$106+1&\"年前期\"","v":"平成31年前期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"\"平成\"&O$106+1&\"年後期\"","v":"平成31年後期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"\"平成\"&O$106+2&\"年前期\"","v":"平成32年前期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"\"平成\"&O$106+2&\"年後期\"","v":"平成32年後期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"\"平成\"&O$106+3&\"年前期\"","v":"平成33年前期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"\"平成\"&O$106+3&\"年後期\"","v":"平成33年後期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"\"平成\"&O$106+4&\"年前期\"","v":"平成34年前期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"\"平成\"&O$106+4&\"年後期\"","v":"平成34年後期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"\"平成\"&O$106+5&\"年以降\"","v":"平成35年以降"}]

{"sheet":"総括表","index":4,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,0,26,1],[24,0,24,1],[25,0,25,1],[1,0,1,12],[2,0,2,12],[16,0,17,0],[18,0,19,0],[22,0,23,0],[20,0,21,0],[3,0,5,1],[14,0,15,0],[6,0,7,0],[8,0,9,0],[10,0,11,0],[12,0,13,0],[0,9,0,12],[4,4,4,5],[4,6,4,7],[4,8,4,9],[3,2,3,12],[4,10,4,11],[4,12,5,12],[4,2,4,3]]}
[null,"入学年度：平成",{"$f":"目標ごとの達成度!O106","v":30},"年度",null,null,null,null,null,{"$f":"NOW()","v":"2019-04-03T11:32:14.290"}]
["「学習・教育到達目標」達成状況の総括表"]
["※学期ごとに，これらの数値をＪノートの総括表に転記すること"]
["学習・教育目標",null,"各期の累計取得単位数と累計GPA"]
[null,null,"１年",null,"２年",null,"３年",null,"４年",null,null,null,"それ\n以降"]
[null,null,"前期","後期","前期","後期","前期","後期","前期","後期","前期","後期"]
["(A)科学技術基礎","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:P12))","v":0},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:Q12))","v":0},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:R12))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:S12))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:T12))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:U12))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:V12))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:W12))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:X12))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:Y12))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:Z12))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C7=0,0,SUM(目標ごとの達成度!$AA$3:AA12)/C7))","v":0},{"$f":"IF(D$30>$J$1,\"\",IF(D7=0,0,SUM(目標ごとの達成度!$AA$3:AB12)/D7))","v":0},{"$f":"IF(E$30>$J$1,\"\",IF(E7=0,0,SUM(目標ごとの達成度!$AA$3:AC12)/E7))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F7=0,0,SUM(目標ごとの達成度!$AA$3:AD12)/F7))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G7=0,0,SUM(目標ごとの達成度!$AA$3:AE12)/G7))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H7=0,0,SUM(目標ごとの達成度!$AA$3:AF12)/H7))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I7=0,0,SUM(目標ごとの達成度!$AA$3:AG12)/I7))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J7=0,0,SUM(目標ごとの達成度!$AA$3:AH12)/J7))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K7=0,0,SUM(目標ごとの達成度!$AA$3:AI12)/K7))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L7=0,0,SUM(目標ごとの達成度!$AA$3:AJ12)/L7))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M7=0,0,SUM(目標ごとの達成度!$AA$3:AK12)/M7))","v":""}]
["(B)自然科学","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:P24))","v":0},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:Q24))","v":0},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:R24))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:S24))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:T24))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:U24))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:V24))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:W24))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:X24))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:Y24))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:Z24))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C9=0,0,SUM(目標ごとの達成度!$AA$13:AA24)/C9))","v":0},{"$f":"IF(D$30>$J$1,\"\",IF(D9=0,0,SUM(目標ごとの達成度!$AA$13:AB24)/D9))","v":0},{"$f":"IF(E$30>$J$1,\"\",IF(E9=0,0,SUM(目標ごとの達成度!$AA$13:AC24)/E9))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F9=0,0,SUM(目標ごとの達成度!$AA$13:AD24)/F9))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G9=0,0,SUM(目標ごとの達成度!$AA$13:AE24)/G9))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H9=0,0,SUM(目標ごとの達成度!$AA$13:AF24)/H9))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I9=0,0,SUM(目標ごとの達成度!$AA$13:AG24)/I9))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J9=0,0,SUM(目標ごとの達成度!$AA$13:AH24)/J9))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K9=0,0,SUM(目標ごとの達成度!$AA$13:AI24)/K9))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L9=0,0,SUM(目標ごとの達成度!$AA$13:AJ24)/L9))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M9=0,0,SUM(目標ごとの達成度!$AA$13:AK24)/M9))","v":""}]
["(C)多面的思考と技術者倫理","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$25:P40))","v":0},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$25:Q40))","v":0},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$25:R40))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$25:S40))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$25:T40))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$25:U40))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$25:V40))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$25:W40))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$25:X40))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$25:Y40))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$25:Z40))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C11=0,0,SUM(目標ごとの達成度!$AA$25:AA40)/C11))","v":0},{"$f":"IF(D$30>$J$1,\"\",IF(D11=0,0,SUM(目標ごとの達成度!$AA$25:AB40)/D11))","v":0},{"$f":"IF(E$30>$J$1,\"\",IF(E11=0,0,SUM(目標ごとの達成度!$AA$25:AC40)/E11))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F11=0,0,SUM(目標ごとの達成度!$AA$25:AD40)/F11))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G11=0,0,SUM(目標ごとの達成度!$AA$25:AE40)/G11))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H11=0,0,SUM(目標ごとの達成度!$AA$25:AF40)/H11))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I11=0,0,SUM(目標ごとの達成度!$AA$25:AG40)/I11))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J11=0,0,SUM(目標ごとの達成度!$AA$25:AH40)/J11))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K11=0,0,SUM(目標ごとの達成度!$AA$25:AI40)/K11))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L11=0,0,SUM(目標ごとの達成度!$AA$25:AJ40)/L11))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M11=0,0,SUM(目標ごとの達成度!$AA$25:AK40)/M11))","v":""}]
["(D)主要専門基礎","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$41:P50))","v":0},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$41:Q50))","v":0},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$41:R50))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$41:S50))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$41:T50))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$41:U50))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$41:V50))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$41:W50))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$41:X50))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$41:Y50))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$41:Z50))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C13=0,0,SUM(目標ごとの達成度!$AA$41:AA50)/C13))","v":0},{"$f":"IF(D$30>$J$1,\"\",IF(D13=0,0,SUM(目標ごとの達成度!$AA$41:AB50)/D13))","v":0},{"$f":"IF(E$30>$J$1,\"\",IF(E13=0,0,SUM(目標ごとの達成度!$AA$41:AC50)/E13))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F13=0,0,SUM(目標ごとの達成度!$AA$41:AD50)/F13))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G13=0,0,SUM(目標ごとの達成度!$AA$41:AE50)/G13))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H13=0,0,SUM(目標ごとの達成度!$AA$41:AF50)/H13))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I13=0,0,SUM(目標ごとの達成度!$AA$41:AG50)/I13))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J13=0,0,SUM(目標ごとの達成度!$AA$41:AH50)/J13))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K13=0,0,SUM(目標ごとの達成度!$AA$41:AI50)/K13))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L13=0,0,SUM(目標ごとの達成度!$AA$41:AJ50)/L13))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M13=0,0,SUM(目標ごとの達成度!$AA$41:AK50)/M13))","v":""}]
["(E)自主学習・応用能力","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$51:P59))","v":0},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$51:Q59))","v":0},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$51:R59))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$51:S59))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$51:T59))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$51:U59))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$51:V59))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$51:W59))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$51:X59))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$51:Y59))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$51:Z59))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C15=0,0,SUM(目標ごとの達成度!$AA$51:AA59)/C15))","v":0},{"$f":"IF(D$30>$J$1,\"\",IF(D15=0,0,SUM(目標ごとの達成度!$AA$51:AB59)/D15))","v":0},{"$f":"IF(E$30>$J$1,\"\",IF(E15=0,0,SUM(目標ごとの達成度!$AA$51:AC59)/E15))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F15=0,0,SUM(目標ごとの達成度!$AA$51:AD59)/F15))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G15=0,0,SUM(目標ごとの達成度!$AA$51:AE59)/G15))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H15=0,0,SUM(目標ごとの達成度!$AA$51:AF59)/H15))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I15=0,0,SUM(目標ごとの達成度!$AA$51:AG59)/I15))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J15=0,0,SUM(目標ごとの達成度!$AA$51:AH59)/J15))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K15=0,0,SUM(目標ごとの達成度!$AA$51:AI59)/K15))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L15=0,0,SUM(目標ごとの達成度!$AA$51:AJ59)/L15))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M15=0,0,SUM(目標ごとの達成度!$AA$51:AK59)/M15))","v":""}]
["(F)チームによる実体験","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$60:P66))","v":0},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$60:Q66))","v":0},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$60:R66))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$60:S66))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$60:T66))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$60:U66))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$60:V66))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$60:W66))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$60:X66))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$60:Y66))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$60:Z66))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C17=0,0,SUM(目標ごとの達成度!$AA$60:AA66)/C17))","v":0},{"$f":"IF(D$30>$J$1,\"\",IF(D17=0,0,SUM(目標ごとの達成度!$AA$60:AB66)/D17))","v":0},{"$f":"IF(E$30>$J$1,\"\",IF(E17=0,0,SUM(目標ごとの達成度!$AA$60:AC66)/E17))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F17=0,0,SUM(目標ごとの達成度!$AA$60:AD66)/F17))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G17=0,0,SUM(目標ごとの達成度!$AA$60:AE66)/G17))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H17=0,0,SUM(目標ごとの達成度!$AA$60:AF66)/H17))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I17=0,0,SUM(目標ごとの達成度!$AA$60:AG66)/I17))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J17=0,0,SUM(目標ごとの達成度!$AA$60:AH66)/J17))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K17=0,0,SUM(目標ごとの達成度!$AA$60:AI66)/K17))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L17=0,0,SUM(目標ごとの達成度!$AA$60:AJ66)/L17))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M17=0,0,SUM(目標ごとの達成度!$AA$60:AK66)/M17))","v":""}]
["(G)コミュニケーション能力","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:P72))","v":0},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:Q72))","v":0},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:R72))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:S72))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:T72))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:U72))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:V72))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:W72))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:X72))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:Y72))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:Z72))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C19=0,0,SUM(目標ごとの達成度!$AA$67:AA72)/C19))","v":0},{"$f":"IF(D$30>$J$1,\"\",IF(D19=0,0,SUM(目標ごとの達成度!$AA$67:AB72)/D19))","v":0},{"$f":"IF(E$30>$J$1,\"\",IF(E19=0,0,SUM(目標ごとの達成度!$AA$67:AC72)/E19))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F19=0,0,SUM(目標ごとの達成度!$AA$67:AD72)/F19))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G19=0,0,SUM(目標ごとの達成度!$AA$67:AE72)/G19))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H19=0,0,SUM(目標ごとの達成度!$AA$67:AF72)/H19))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I19=0,0,SUM(目標ごとの達成度!$AA$67:AG72)/I19))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J19=0,0,SUM(目標ごとの達成度!$AA$67:AH72)/J19))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K19=0,0,SUM(目標ごとの達成度!$AA$67:AI72)/K19))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L19=0,0,SUM(目標ごとの達成度!$AA$67:AJ72)/L19))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M19=0,0,SUM(目標ごとの達成度!$AA$67:AK72)/M19))","v":""}]
["(H)社会基盤の応用技術","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$73:P87))","v":0},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$73:Q87))","v":0},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$73:R87))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$73:S87))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$73:T87))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$73:U87))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$73:V87))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$73:W87))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$73:X87))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$73:Y87))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$73:Z87))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C21=0,0,SUM(目標ごとの達成度!$AA$73:AA87)/C21))","v":0},{"$f":"IF(D$30>$J$1,\"\",IF(D21=0,0,SUM(目標ごとの達成度!$AA$73:AB87)/D21))","v":0},{"$f":"IF(E$30>$J$1,\"\",IF(E21=0,0,SUM(目標ごとの達成度!$AA$73:AC87)/E21))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F21=0,0,SUM(目標ごとの達成度!$AA$73:AD87)/F21))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G21=0,0,SUM(目標ごとの達成度!$AA$73:AE87)/G21))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H21=0,0,SUM(目標ごとの達成度!$AA$73:AF87)/H21))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I21=0,0,SUM(目標ごとの達成度!$AA$73:AG87)/I21))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J21=0,0,SUM(目標ごとの達成度!$AA$73:AH87)/J21))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K21=0,0,SUM(目標ごとの達成度!$AA$73:AI87)/K21))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L21=0,0,SUM(目標ごとの達成度!$AA$73:AJ87)/L21))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M21=0,0,SUM(目標ごとの達成度!$AA$73:AK87)/M21))","v":""}]
["(I)デザイン能力","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$88:P93))","v":0},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$88:Q93))","v":0},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$88:R93))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$88:S93))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$88:T93))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$88:U93))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$88:V93))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$88:W93))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$88:X93))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$88:Y93))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$88:Z93))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C23=0,0,SUM(目標ごとの達成度!$AA88:AA$93)/C23))","v":0},{"$f":"IF(D$30>$J$1,\"\",IF(D23=0,0,SUM(目標ごとの達成度!$AA88:AB$93)/D23))","v":0},{"$f":"IF(E$30>$J$1,\"\",IF(E23=0,0,SUM(目標ごとの達成度!$AA88:AC$93)/E23))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F23=0,0,SUM(目標ごとの達成度!$AA88:AD$93)/F23))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G23=0,0,SUM(目標ごとの達成度!$AA88:AE$93)/G23))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H23=0,0,SUM(目標ごとの達成度!$AA88:AF$93)/H23))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I23=0,0,SUM(目標ごとの達成度!$AA88:AG$93)/I23))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J23=0,0,SUM(目標ごとの達成度!$AA88:AH$93)/J23))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K23=0,0,SUM(目標ごとの達成度!$AA88:AI$93)/K23))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L23=0,0,SUM(目標ごとの達成度!$AA88:AJ$93)/L23))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M23=0,0,SUM(目標ごとの達成度!$AA88:AK$93)/M23))","v":""}]
["土木GPT対象科目の単位数",null,{"$f":"IF(C$30>$J$1,\"\",共通科目!X80+専門科目!V51)","v":0},{"$f":"IF(D$30>$J$1,\"\",共通科目!Y80+専門科目!W51)","v":0},{"$f":"IF(E$30>$J$1,\"\",共通科目!Z80+専門科目!X51)","v":""},{"$f":"IF(F$30>$J$1,\"\",共通科目!AA80+専門科目!Y51)","v":""},{"$f":"IF(G$30>$J$1,\"\",共通科目!AB80+専門科目!Z51)","v":""},{"$f":"IF(H$30>$J$1,\"\",共通科目!AC80+専門科目!AA51)","v":""},{"$f":"IF(I$30>$J$1,\"\",共通科目!AD80+専門科目!AB51)","v":""},{"$f":"IF(J$30>$J$1,\"\",共通科目!AE80+専門科目!AC51)","v":""},{"$f":"IF(K$30>$J$1,\"\",共通科目!AF80+専門科目!AD51)","v":""},{"$f":"IF(L$30>$J$1,\"\",共通科目!AG80+専門科目!AE51)","v":""},{"$f":"IF(M$30>$J$1,\"\",共通科目!AH80+専門科目!AF51)","v":""}]
["土木GPT対象科目のGPA",null,{"$f":"IF(C$30>$J$1,\"\",IF(C25=0,0,C27/C25))","v":0},0,"","","","","","","","",""]
["土木GPT",null,{"$f":"IF(C$30>$J$1,\"\",共通科目!AI80+専門科目!AG51)","v":0},{"$f":"IF(D$30>$J$1,\"\",共通科目!AJ80+専門科目!AH51)","v":0},{"$f":"IF(E$30>$J$1,\"\",共通科目!AK80+専門科目!AI51)","v":""},{"$f":"IF(F$30>$J$1,\"\",共通科目!AL80+専門科目!AJ51)","v":""},{"$f":"IF(G$30>$J$1,\"\",共通科目!AM80+専門科目!AK51)","v":""},{"$f":"IF(H$30>$J$1,\"\",共通科目!AN80+専門科目!AL51)","v":""},{"$f":"IF(I$30>$J$1,\"\",共通科目!AO80+専門科目!AM51)","v":""},{"$f":"IF(J$30>$J$1,\"\",共通科目!AP80+専門科目!AN51)","v":""},{"$f":"IF(K$30>$J$1,\"\",共通科目!AQ80+専門科目!AO51)","v":""},{"$f":"IF(L$30>$J$1,\"\",共通科目!AR80+専門科目!AP51)","v":""},{"$f":"IF(M$30>$J$1,\"\",共通科目!AS80+専門科目!AQ51)","v":""}]
[null,null,{"$f":"C1+1988","v":2018},{"$f":"C28+1","v":2019},{"$f":"D28","v":2019},{"$f":"E28+1","v":2020},{"$f":"F28","v":2020},{"$f":"G28+1","v":2021},{"$f":"H28","v":2021},{"$f":"I28+1","v":2022},{"$f":"J28","v":2022},{"$f":"K28+1","v":2023},{"$f":"L28","v":2023}]
[null,null,9,3,9,3,9,3,9,3,9,3,9]
[null,null,{"$f":"DATE(C28,C29,1)","v":"2018-09-01"},{"$f":"DATE(D28,D29,1)","v":"2019-03-01"},"2019-09-01","2020-03-01","2020-09-01","2021-03-01","2021-09-01","2022-03-01","2022-09-01","2023-03-01","2023-09-01"]

{"sheet":"グラフ用データ","index":7,"n_rows":21,"n_cols":37,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,26,0,36],[0,15,0,25],[0,0,1,0],[0,2,1,2],[0,1,1,1],[0,3,1,3],[0,4,0,14]]}
["学習・教育到達目標","取得\n単位数","GPT","GPA","各期の累計取得単位数",null,null,null,null,null,null,null,null,null,null,"各期のGPT",null,null,null,null,null,null,null,null,null,null,"各期の累計GPA"]
[null,null,null,null,{"$f":"目標ごとの達成度!P2","v":1},{"$f":"目標ごとの達成度!Q2","v":2},{"$f":"目標ごとの達成度!R2","v":3},{"$f":"目標ごとの達成度!S2","v":4},{"$f":"目標ごとの達成度!T2","v":5},{"$f":"目標ごとの達成度!U2","v":6},{"$f":"目標ごとの達成度!V2","v":7},{"$f":"目標ごとの達成度!W2","v":8},{"$f":"目標ごとの達成度!X2","v":9},{"$f":"目標ごとの達成度!Y2","v":10},{"$f":"目標ごとの達成度!Z2","v":11},{"$f":"E2","v":1},2,3,4,5,6,7,8,9,10,11,{"$f":"E2","v":1},2,3,4,5,6,7,8,9,10,11]
["(A) 科学技術基礎",{"$f":"SUM(目標ごとの達成度!N3:N12)","v":0},{"$f":"SUM(目標ごとの達成度!M3:M12)","v":0},{"$f":"C3/B3","v":{"$error":"#DIV/0!"}},{"$f":"SUM(目標ごとの達成度!$P3:P12)","v":0},{"$f":"SUM(目標ごとの達成度!$P3:Q12)","v":0},{"$f":"SUM(目標ごとの達成度!$P3:R12)","v":0},{"$f":"SUM(目標ごとの達成度!$P3:S12)","v":0},{"$f":"SUM(目標ごとの達成度!$P3:T12)","v":0},{"$f":"SUM(目標ごとの達成度!$P3:U12)","v":0},{"$f":"SUM(目標ごとの達成度!$P3:V12)","v":0},{"$f":"SUM(目標ごとの達成度!$P3:W12)","v":0},{"$f":"SUM(目標ごとの達成度!$P3:X12)","v":0},{"$f":"SUM(目標ごとの達成度!$P3:Y12)","v":0},{"$f":"SUM(目標ごとの達成度!$P3:Z12)","v":0},{"$f":"SUM(目標ごとの達成度!$AA3:AA12)","v":0},{"$f":"SUM(目標ごとの達成度!AB3:AB12)","v":0},{"$f":"SUM(目標ごとの達成度!AC3:AC12)","v":0},{"$f":"SUM(目標ごとの達成度!AD3:AD12)","v":0},{"$f":"SUM(目標ごとの達成度!AE3:AE12)","v":0},{"$f":"SUM(目標ごとの達成度!AF3:AF12)","v":0},{"$f":"SUM(目標ごとの達成度!AG3:AG12)","v":0},{"$f":"SUM(目標ごとの達成度!AH3:AH12)","v":0},{"$f":"SUM(目標ごとの達成度!AI3:AI12)","v":0},{"$f":"SUM(目標ごとの達成度!AJ3:AJ12)","v":0},{"$f":"SUM(目標ごとの達成度!AK3:AK12)","v":0},{"$f":"IF(E3=0,0,SUM($P3:P3)/E3)","v":0},{"$f":"IF(F3=0,0,SUM($P3:Q3)/F3)","v":0},{"$f":"IF(G3=0,0,SUM($P3:R3)/G3)","v":0},{"$f":"IF(H3=0,0,SUM($P3:S3)/H3)","v":0},{"$f":"IF(I3=0,0,SUM($P3:T3)/I3)","v":0},{"$f":"IF(J3=0,0,SUM($P3:U3)/J3)","v":0},{"$f":"IF(K3=0,0,SUM($P3:V3)/K3)","v":0},{"$f":"IF(L3=0,0,SUM($P3:W3)/L3)","v":0},{"$f":"IF(M3=0,0,SUM($P3:X3)/M3)","v":0},{"$f":"IF(N3=0,0,SUM($P3:Y3)/N3)","v":0},{"$f":"IF(O3=0,0,SUM($P3:Z3)/O3)","v":0}]
["(B) 自然科学",{"$f":"SUM(目標ごとの達成度!N13:N24)","v":0},{"$f":"SUM(目標ごとの達成度!M13:M24)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P13:P24)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:Q24)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:R24)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:S24)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:T24)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:U24)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:V24)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:W24)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:X24)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:Y24)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:Z24)","v":0},{"$f":"SUM(目標ごとの達成度!$AA13:AA24)","v":0},{"$f":"SUM(目標ごとの達成度!AB13:AB24)","v":0},{"$f":"SUM(目標ごとの達成度!AC13:AC24)","v":0},{"$f":"SUM(目標ごとの達成度!AD13:AD24)","v":0},{"$f":"SUM(目標ごとの達成度!AE13:AE24)","v":0},{"$f":"SUM(目標ごとの達成度!AF13:AF24)","v":0},{"$f":"SUM(目標ごとの達成度!AG13:AG24)","v":0},{"$f":"SUM(目標ごとの達成度!AH13:AH24)","v":0},{"$f":"SUM(目標ごとの達成度!AI13:AI24)","v":0},{"$f":"SUM(目標ごとの達成度!AJ13:AJ24)","v":0},{"$f":"SUM(目標ごとの達成度!AK13:AK24)","v":0},{"$f":"IF(E4=0,0,SUM($P4:P4)/E4)","v":0},{"$f":"IF(F4=0,0,SUM($P4:Q4)/F4)","v":0},{"$f":"IF(G4=0,0,SUM($P4:R4)/G4)","v":0},{"$f":"IF(H4=0,0,SUM($P4:S4)/H4)","v":0},{"$f":"IF(I4=0,0,SUM($P4:T4)/I4)","v":0},{"$f":"IF(J4=0,0,SUM($P4:U4)/J4)","v":0},{"$f":"IF(K4=0,0,SUM($P4:V4)/K4)","v":0},{"$f":"IF(L4=0,0,SUM($P4:W4)/L4)","v":0},{"$f":"IF(M4=0,0,SUM($P4:X4)/M4)","v":0},{"$f":"IF(N4=0,0,SUM($P4:Y4)/N4)","v":0},{"$f":"IF(O4=0,0,SUM($P4:Z4)/O4)","v":0}]
["(C) 多面的思考と倫理",{"$f":"SUM(目標ごとの達成度!N25:N40)","v":0},{"$f":"SUM(目標ごとの達成度!M25:M40)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P25:P40)","v":0},{"$f":"SUM(目標ごとの達成度!$P25:Q40)","v":0},{"$f":"SUM(目標ごとの達成度!$P25:R40)","v":0},{"$f":"SUM(目標ごとの達成度!$P25:S40)","v":0},{"$f":"SUM(目標ごとの達成度!$P25:T40)","v":0},{"$f":"SUM(目標ごとの達成度!$P25:U40)","v":0},{"$f":"SUM(目標ごとの達成度!$P25:V40)","v":0},{"$f":"SUM(目標ごとの達成度!$P25:W40)","v":0},{"$f":"SUM(目標ごとの達成度!$P25:X40)","v":0},{"$f":"SUM(目標ごとの達成度!$P25:Y40)","v":0},{"$f":"SUM(目標ごとの達成度!$P25:Z40)","v":0},{"$f":"SUM(目標ごとの達成度!$AA25:AA40)","v":0},{"$f":"SUM(目標ごとの達成度!AB25:AB40)","v":0},{"$f":"SUM(目標ごとの達成度!AC25:AC40)","v":0},{"$f":"SUM(目標ごとの達成度!AD25:AD40)","v":0},{"$f":"SUM(目標ごとの達成度!AE25:AE40)","v":0},{"$f":"SUM(目標ごとの達成度!AF25:AF40)","v":0},{"$f":"SUM(目標ごとの達成度!AG25:AG40)","v":0},{"$f":"SUM(目標ごとの達成度!AH25:AH40)","v":0},{"$f":"SUM(目標ごとの達成度!AI25:AI40)","v":0},{"$f":"SUM(目標ごとの達成度!AJ25:AJ40)","v":0},{"$f":"SUM(目標ごとの達成度!AK25:AK40)","v":0},{"$f":"IF(E5=0,0,SUM($P5:P5)/E5)","v":0},{"$f":"IF(F5=0,0,SUM($P5:Q5)/F5)","v":0},{"$f":"IF(G5=0,0,SUM($P5:R5)/G5)","v":0},{"$f":"IF(H5=0,0,SUM($P5:S5)/H5)","v":0},{"$f":"IF(I5=0,0,SUM($P5:T5)/I5)","v":0},{"$f":"IF(J5=0,0,SUM($P5:U5)/J5)","v":0},{"$f":"IF(K5=0,0,SUM($P5:V5)/K5)","v":0},{"$f":"IF(L5=0,0,SUM($P5:W5)/L5)","v":0},{"$f":"IF(M5=0,0,SUM($P5:X5)/M5)","v":0},{"$f":"IF(N5=0,0,SUM($P5:Y5)/N5)","v":0},{"$f":"IF(O5=0,0,SUM($P5:Z5)/O5)","v":0}]
["(D) 専門基礎",{"$f":"SUM(目標ごとの達成度!N41:N50)","v":0},{"$f":"SUM(目標ごとの達成度!M41:M50)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P41:P50)","v":0},{"$f":"SUM(目標ごとの達成度!$P41:Q50)","v":0},{"$f":"SUM(目標ごとの達成度!$P41:R50)","v":0},{"$f":"SUM(目標ごとの達成度!$P41:S50)","v":0},{"$f":"SUM(目標ごとの達成度!$P41:T50)","v":0},{"$f":"SUM(目標ごとの達成度!$P41:U50)","v":0},{"$f":"SUM(目標ごとの達成度!$P41:V50)","v":0},{"$f":"SUM(目標ごとの達成度!$P41:W50)","v":0},{"$f":"SUM(目標ごとの達成度!$P41:X50)","v":0},{"$f":"SUM(目標ごとの達成度!$P41:Y50)","v":0},{"$f":"SUM(目標ごとの達成度!$P41:Z50)","v":0},{"$f":"SUM(目標ごとの達成度!$AA41:AA50)","v":0},{"$f":"SUM(目標ごとの達成度!AB41:AB50)","v":0},{"$f":"SUM(目標ごとの達成度!AC41:AC50)","v":0},{"$f":"SUM(目標ごとの達成度!AD41:AD50)","v":0},{"$f":"SUM(目標ごとの達成度!AE41:AE50)","v":0},{"$f":"SUM(目標ごとの達成度!AF41:AF50)","v":0},{"$f":"SUM(目標ごとの達成度!AG41:AG50)","v":0},{"$f":"SUM(目標ごとの達成度!AH41:AH50)","v":0},{"$f":"SUM(目標ごとの達成度!AI41:AI50)","v":0},{"$f":"SUM(目標ごとの達成度!AJ41:AJ50)","v":0},{"$f":"SUM(目標ごとの達成度!AK41:AK50)","v":0},{"$f":"IF(E6=0,0,SUM($P6:P6)/E6)","v":0},{"$f":"IF(F6=0,0,SUM($P6:Q6)/F6)","v":0},{"$f":"IF(G6=0,0,SUM($P6:R6)/G6)","v":0},{"$f":"IF(H6=0,0,SUM($P6:S6)/H6)","v":0},{"$f":"IF(I6=0,0,SUM($P6:T6)/I6)","v":0},{"$f":"IF(J6=0,0,SUM($P6:U6)/J6)","v":0},{"$f":"IF(K6=0,0,SUM($P6:V6)/K6)","v":0},{"$f":"IF(L6=0,0,SUM($P6:W6)/L6)","v":0},{"$f":"IF(M6=0,0,SUM($P6:X6)/M6)","v":0},{"$f":"IF(N6=0,0,SUM($P6:Y6)/N6)","v":0},{"$f":"IF(O6=0,0,SUM($P6:Z6)/O6)","v":0}]
["(E) 自主学習",{"$f":"SUM(目標ごとの達成度!N51:N59)","v":0},{"$f":"SUM(目標ごとの達成度!M51:M59)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P51:P59)","v":0},{"$f":"SUM(目標ごとの達成度!$P51:Q59)","v":0},{"$f":"SUM(目標ごとの達成度!$P51:R59)","v":0},{"$f":"SUM(目標ごとの達成度!$P51:S59)","v":0},{"$f":"SUM(目標ごとの達成度!$P51:T59)","v":0},{"$f":"SUM(目標ごとの達成度!$P51:U59)","v":0},{"$f":"SUM(目標ごとの達成度!$P51:V59)","v":0},{"$f":"SUM(目標ごとの達成度!$P51:W59)","v":0},{"$f":"SUM(目標ごとの達成度!$P51:X59)","v":0},{"$f":"SUM(目標ごとの達成度!$P51:Y59)","v":0},{"$f":"SUM(目標ごとの達成度!$P51:Z59)","v":0},{"$f":"SUM(目標ごとの達成度!$AA51:AA59)","v":0},{"$f":"SUM(目標ごとの達成度!AB51:AB59)","v":0},{"$f":"SUM(目標ごとの達成度!AC51:AC59)","v":0},{"$f":"SUM(目標ごとの達成度!AD51:AD59)","v":0},{"$f":"SUM(目標ごとの達成度!AE51:AE59)","v":0},{"$f":"SUM(目標ごとの達成度!AF51:AF59)","v":0},{"$f":"SUM(目標ごとの達成度!AG51:AG59)","v":0},{"$f":"SUM(目標ごとの達成度!AH51:AH59)","v":0},{"$f":"SUM(目標ごとの達成度!AI51:AI59)","v":0},{"$f":"SUM(目標ごとの達成度!AJ51:AJ59)","v":0},{"$f":"SUM(目標ごとの達成度!AK51:AK59)","v":0},{"$f":"IF(E7=0,0,SUM($P7:P7)/E7)","v":0},{"$f":"IF(F7=0,0,SUM($P7:Q7)/F7)","v":0},{"$f":"IF(G7=0,0,SUM($P7:R7)/G7)","v":0},{"$f":"IF(H7=0,0,SUM($P7:S7)/H7)","v":0},{"$f":"IF(I7=0,0,SUM($P7:T7)/I7)","v":0},{"$f":"IF(J7=0,0,SUM($P7:U7)/J7)","v":0},{"$f":"IF(K7=0,0,SUM($P7:V7)/K7)","v":0},{"$f":"IF(L7=0,0,SUM($P7:W7)/L7)","v":0},{"$f":"IF(M7=0,0,SUM($P7:X7)/M7)","v":0},{"$f":"IF(N7=0,0,SUM($P7:Y7)/N7)","v":0},{"$f":"IF(O7=0,0,SUM($P7:Z7)/O7)","v":0}]
["(F) チームによる実体験",{"$f":"SUM(目標ごとの達成度!N60:N66)","v":0},{"$f":"SUM(目標ごとの達成度!M60:M66)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P60:P66)","v":0},{"$f":"SUM(目標ごとの達成度!$P60:Q66)","v":0},{"$f":"SUM(目標ごとの達成度!$P60:R66)","v":0},{"$f":"SUM(目標ごとの達成度!$P60:S66)","v":0},{"$f":"SUM(目標ごとの達成度!$P60:T66)","v":0},{"$f":"SUM(目標ごとの達成度!$P60:U66)","v":0},{"$f":"SUM(目標ごとの達成度!$P60:V66)","v":0},{"$f":"SUM(目標ごとの達成度!$P60:W66)","v":0},{"$f":"SUM(目標ごとの達成度!$P60:X66)","v":0},{"$f":"SUM(目標ごとの達成度!$P60:Y66)","v":0},{"$f":"SUM(目標ごとの達成度!$P60:Z66)","v":0},{"$f":"SUM(目標ごとの達成度!$AA60:AA66)","v":0},{"$f":"SUM(目標ごとの達成度!AB60:AB66)","v":0},{"$f":"SUM(目標ごとの達成度!AC60:AC66)","v":0},{"$f":"SUM(目標ごとの達成度!AD60:AD66)","v":0},{"$f":"SUM(目標ごとの達成度!AE60:AE66)","v":0},{"$f":"SUM(目標ごとの達成度!AF60:AF66)","v":0},{"$f":"SUM(目標ごとの達成度!AG60:AG66)","v":0},{"$f":"SUM(目標ごとの達成度!AH60:AH66)","v":0},{"$f":"SUM(目標ごとの達成度!AI60:AI66)","v":0},{"$f":"SUM(目標ごとの達成度!AJ60:AJ66)","v":0},{"$f":"SUM(目標ごとの達成度!AK60:AK66)","v":0},{"$f":"IF(E8=0,0,SUM($P8:P8)/E8)","v":0},{"$f":"IF(F8=0,0,SUM($P8:Q8)/F8)","v":0},{"$f":"IF(G8=0,0,SUM($P8:R8)/G8)","v":0},{"$f":"IF(H8=0,0,SUM($P8:S8)/H8)","v":0},{"$f":"IF(I8=0,0,SUM($P8:T8)/I8)","v":0},{"$f":"IF(J8=0,0,SUM($P8:U8)/J8)","v":0},{"$f":"IF(K8=0,0,SUM($P8:V8)/K8)","v":0},{"$f":"IF(L8=0,0,SUM($P8:W8)/L8)","v":0},{"$f":"IF(M8=0,0,SUM($P8:X8)/M8)","v":0},{"$f":"IF(N8=0,0,SUM($P8:Y8)/N8)","v":0},{"$f":"IF(O8=0,0,SUM($P8:Z8)/O8)","v":0}]
["(G) コミュニケーション",{"$f":"SUM(目標ごとの達成度!N67:N72)","v":0},{"$f":"SUM(目標ごとの達成度!M67:M72)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P67:P72)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:Q72)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:R72)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:S72)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:T72)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:U72)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:V72)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:W72)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:X72)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:Y72)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:Z72)","v":0},{"$f":"SUM(目標ごとの達成度!$AA67:AA72)","v":0},{"$f":"SUM(目標ごとの達成度!AB67:AB72)","v":0},{"$f":"SUM(目標ごとの達成度!AC67:AC72)","v":0},{"$f":"SUM(目標ごとの達成度!AD67:AD72)","v":0},{"$f":"SUM(目標ごとの達成度!AE67:AE72)","v":0},{"$f":"SUM(目標ごとの達成度!AF67:AF72)","v":0},{"$f":"SUM(目標ごとの達成度!AG67:AG72)","v":0},{"$f":"SUM(目標ごとの達成度!AH67:AH72)","v":0},{"$f":"SUM(目標ごとの達成度!AI67:AI72)","v":0},{"$f":"SUM(目標ごとの達成度!AJ67:AJ72)","v":0},{"$f":"SUM(目標ごとの達成度!AK67:AK72)","v":0},{"$f":"IF(E9=0,0,SUM($P9:P9)/E9)","v":0},{"$f":"IF(F9=0,0,SUM($P9:Q9)/F9)","v":0},{"$f":"IF(G9=0,0,SUM($P9:R9)/G9)","v":0},{"$f":"IF(H9=0,0,SUM($P9:S9)/H9)","v":0},{"$f":"IF(I9=0,0,SUM($P9:T9)/I9)","v":0},{"$f":"IF(J9=0,0,SUM($P9:U9)/J9)","v":0},{"$f":"IF(K9=0,0,SUM($P9:V9)/K9)","v":0},{"$f":"IF(L9=0,0,SUM($P9:W9)/L9)","v":0},{"$f":"IF(M9=0,0,SUM($P9:X9)/M9)","v":0},{"$f":"IF(N9=0,0,SUM($P9:Y9)/N9)","v":0},{"$f":"IF(O9=0,0,SUM($P9:Z9)/O9)","v":0}]
["(H) 応用技術",{"$f":"SUM(目標ごとの達成度!N73:N87)","v":0},{"$f":"SUM(目標ごとの達成度!M73:M87)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P73:P87)","v":0},{"$f":"SUM(目標ごとの達成度!$P73:Q87)","v":0},{"$f":"SUM(目標ごとの達成度!$P73:R87)","v":0},{"$f":"SUM(目標ごとの達成度!$P73:S87)","v":0},{"$f":"SUM(目標ごとの達成度!$P73:T87)","v":0},{"$f":"SUM(目標ごとの達成度!$P73:U87)","v":0},{"$f":"SUM(目標ごとの達成度!$P73:V87)","v":0},{"$f":"SUM(目標ごとの達成度!$P73:W87)","v":0},{"$f":"SUM(目標ごとの達成度!$P73:X87)","v":0},{"$f":"SUM(目標ごとの達成度!$P73:Y87)","v":0},{"$f":"SUM(目標ごとの達成度!$P73:Z87)","v":0},{"$f":"SUM(目標ごとの達成度!$AA73:AA87)","v":0},{"$f":"SUM(目標ごとの達成度!AB73:AB87)","v":0},{"$f":"SUM(目標ごとの達成度!AC73:AC87)","v":0},{"$f":"SUM(目標ごとの達成度!AD73:AD87)","v":0},{"$f":"SUM(目標ごとの達成度!AE73:AE87)","v":0},{"$f":"SUM(目標ごとの達成度!AF73:AF87)","v":0},{"$f":"SUM(目標ごとの達成度!AG73:AG87)","v":0},{"$f":"SUM(目標ごとの達成度!AH73:AH87)","v":0},{"$f":"SUM(目標ごとの達成度!AI73:AI87)","v":0},{"$f":"SUM(目標ごとの達成度!AJ73:AJ87)","v":0},{"$f":"SUM(目標ごとの達成度!AK73:AK87)","v":0},{"$f":"IF(E10=0,0,SUM($P10:P10)/E10)","v":0},{"$f":"IF(F10=0,0,SUM($P10:Q10)/F10)","v":0},{"$f":"IF(G10=0,0,SUM($P10:R10)/G10)","v":0},{"$f":"IF(H10=0,0,SUM($P10:S10)/H10)","v":0},{"$f":"IF(I10=0,0,SUM($P10:T10)/I10)","v":0},{"$f":"IF(J10=0,0,SUM($P10:U10)/J10)","v":0},{"$f":"IF(K10=0,0,SUM($P10:V10)/K10)","v":0},{"$f":"IF(L10=0,0,SUM($P10:W10)/L10)","v":0},{"$f":"IF(M10=0,0,SUM($P10:X10)/M10)","v":0},{"$f":"IF(N10=0,0,SUM($P10:Y10)/N10)","v":0},{"$f":"IF(O10=0,0,SUM($P10:Z10)/O10)","v":0}]
["(I) デザイン能力",{"$f":"SUM(目標ごとの達成度!N88:N93)","v":0},{"$f":"SUM(目標ごとの達成度!M88:M93)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P88:P93)","v":0},{"$f":"SUM(目標ごとの達成度!$P88:Q93)","v":0},{"$f":"SUM(目標ごとの達成度!$P88:R93)","v":0},{"$f":"SUM(目標ごとの達成度!$P88:S93)","v":0},{"$f":"SUM(目標ごとの達成度!$P88:T93)","v":0},{"$f":"SUM(目標ごとの達成度!$P88:U93)","v":0},{"$f":"SUM(目標ごとの達成度!$P88:V93)","v":0},{"$f":"SUM(目標ごとの達成度!$P88:W93)","v":0},{"$f":"SUM(目標ごとの達成度!$P88:X93)","v":0},{"$f":"SUM(目標ごとの達成度!$P88:Y93)","v":0},{"$f":"SUM(目標ごとの達成度!$P88:Z93)","v":0},{"$f":"SUM(目標ごとの達成度!$AA88:AA93)","v":0},{"$f":"SUM(目標ごとの達成度!AB88:AB93)","v":0},{"$f":"SUM(目標ごとの達成度!AC88:AC93)","v":0},{"$f":"SUM(目標ごとの達成度!AD88:AD93)","v":0},{"$f":"SUM(目標ごとの達成度!AE88:AE93)","v":0},{"$f":"SUM(目標ごとの達成度!AF88:AF93)","v":0},{"$f":"SUM(目標ごとの達成度!AG88:AG93)","v":0},{"$f":"SUM(目標ごとの達成度!AH88:AH93)","v":0},{"$f":"SUM(目標ごとの達成度!AI88:AI93)","v":0},{"$f":"SUM(目標ごとの達成度!AJ88:AJ93)","v":0},{"$f":"SUM(目標ごとの達成度!AK88:AK93)","v":0},{"$f":"IF(E11=0,0,SUM($P11:P11)/E11)","v":0},{"$f":"IF(F11=0,0,SUM($P11:Q11)/F11)","v":0},{"$f":"IF(G11=0,0,SUM($P11:R11)/G11)","v":0},{"$f":"IF(H11=0,0,SUM($P11:S11)/H11)","v":0},{"$f":"IF(I11=0,0,SUM($P11:T11)/I11)","v":0},{"$f":"IF(J11=0,0,SUM($P11:U11)/J11)","v":0},{"$f":"IF(K11=0,0,SUM($P11:V11)/K11)","v":0},{"$f":"IF(L11=0,0,SUM($P11:W11)/L11)","v":0},{"$f":"IF(M11=0,0,SUM($P11:X11)/M11)","v":0},{"$f":"IF(N11=0,0,SUM($P11:Y11)/N11)","v":0},{"$f":"IF(O11=0,0,SUM($P11:Z11)/O11)","v":0}]
[]
["SUM(目標ごとの達成度!N3:N12)"]
["SUM(目標ごとの達成度!N13:N24)"]
["SUM(目標ごとの達成度!N25:N43)"]
["SUM(目標ごとの達成度!N44:N53)"]
["SUM(目標ごとの達成度!N54:N62)"]
["SUM(目標ごとの達成度!N63:N69)"]
["SUM(目標ごとの達成度!N70:N75)"]
["SUM(目標ごとの達成度!N76:N89)"]
["SUM(目標ごとの達成度!N90:N95)"]