{"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":81,"n_cols":45,"rows_kept":81,"cut":false,"hidden":false,"merged":[[52,12,58,12],[2,7,2,14],[3,11,3,12],[3,13,3,14],[60,10,64,10],[61,11,67,11],[51,11,58,11],[6,7,30,7],[6,8,30,8],[6,9,30,9],[6,10,30,10],[76,1,79,2],[51,2,58,2],[59,2,67,2],[5,1,33,1],[50,1,67,1],[34,1,49,2],[22,2,33,2],[14,2,21,2],[6,2,13,2],[68,1,75,2],[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]]}
[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,null,"フレッシュマンセミナー",1,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q6=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q6,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F6","v":0},{"$f":"IF($Q6=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q6,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G6","v":0},{"$f":"IF($Q6=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q6,目標ごとの達成度!$N$94:$N$102,0),1))*(F6+G6)","v":0},{"$f":"IF(OR(D6=\"○\",D6=\"◎\"),U6,0)","v":0},{"$f":"IF(P6=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P6,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q7,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F7","v":0},{"$f":"IF($Q7=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q7,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G7","v":0},{"$f":"IF($Q7=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q7,目標ごとの達成度!$N$94:$N$102,0),1))*(F7+G7)","v":0},{"$f":"IF(OR(D7=\"○\",D7=\"◎\"),U7,0)","v":0},{"$f":"IF(P7=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P7,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q8,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F8","v":0},{"$f":"IF($Q8=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q8,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G8","v":0},{"$f":"IF($Q8=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q8,目標ごとの達成度!$N$94:$N$102,0),1))*(F8+G8)","v":0},0,{"$f":"IF(P8=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P8,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q9,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F9","v":0},{"$f":"IF($Q9=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q9,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G9","v":0},{"$f":"IF($Q9=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q9,目標ごとの達成度!$N$94:$N$102,0),1))*(F9+G9)","v":0},0,{"$f":"IF(P9=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P9,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q10,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F10","v":0},{"$f":"IF($Q10=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q10,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G10","v":0},{"$f":"IF($Q10=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q10,目標ごとの達成度!$N$94:$N$102,0),1))*(F10+G10)","v":0},0,{"$f":"IF(P10=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P10,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q11,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F11","v":0},{"$f":"IF($Q11=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q11,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G11","v":0},{"$f":"IF($Q11=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q11,目標ごとの達成度!$N$94:$N$102,0),1))*(F11+G11)","v":0},0,{"$f":"IF(P11=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P11,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q12,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F12","v":0},{"$f":"IF($Q12=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q12,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G12","v":0},{"$f":"IF($Q12=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q12,目標ごとの達成度!$N$94:$N$102,0),1))*(F12+G12)","v":0},0,{"$f":"IF(P12=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P12,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q13,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F13","v":0},{"$f":"IF($Q13=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q13,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G13","v":0},{"$f":"IF($Q13=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q13,目標ごとの達成度!$N$94:$N$102,0),1))*(F13+G13)","v":0},0,{"$f":"IF(P13=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P13,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q14,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F14","v":0},{"$f":"IF($Q14=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q14,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G14","v":0},{"$f":"IF($Q14=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q14,目標ごとの達成度!$N$94:$N$102,0),1))*(F14+G14)","v":0},0,{"$f":"IF(P14=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P14,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q15,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F15","v":0},{"$f":"IF($Q15=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q15,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G15","v":0},{"$f":"IF($Q15=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q15,目標ごとの達成度!$N$94:$N$102,0),1))*(F15+G15)","v":0},0,{"$f":"IF(P15=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P15,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q16,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F16","v":0},{"$f":"IF($Q16=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q16,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G16","v":0},{"$f":"IF($Q16=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q16,目標ごとの達成度!$N$94:$N$102,0),1))*(F16+G16)","v":0},0,{"$f":"IF(P16=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P16,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q17,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F17","v":0},{"$f":"IF($Q17=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q17,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G17","v":0},{"$f":"IF($Q17=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q17,目標ごとの達成度!$N$94:$N$102,0),1))*(F17+G17)","v":0},0,{"$f":"IF(P17=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P17,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q18,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F18","v":0},{"$f":"IF($Q18=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q18,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G18","v":0},{"$f":"IF($Q18=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q18,目標ごとの達成度!$N$94:$N$102,0),1))*(F18+G18)","v":0},0,{"$f":"IF(P18=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P18,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q19,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F19","v":0},{"$f":"IF($Q19=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q19,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G19","v":0},{"$f":"IF($Q19=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q19,目標ごとの達成度!$N$94:$N$102,0),1))*(F19+G19)","v":0},0,{"$f":"IF(P19=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P19,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q20,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F20","v":0},{"$f":"IF($Q20=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q20,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G20","v":0},{"$f":"IF($Q20=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q20,目標ごとの達成度!$N$94:$N$102,0),1))*(F20+G20)","v":0},0,{"$f":"IF(P20=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P20,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q21,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F21","v":0},{"$f":"IF($Q21=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q21,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G21","v":0},{"$f":"IF($Q21=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q21,目標ごとの達成度!$N$94:$N$102,0),1))*(F21+G21)","v":0},0,{"$f":"IF(P21=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P21,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q22,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F22","v":0},{"$f":"IF($Q22=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q22,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G22","v":0},{"$f":"IF($Q22=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q22,目標ごとの達成度!$N$94:$N$102,0),1))*(F22+G22)","v":0},0,{"$f":"IF(P22=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P22,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q23,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F23","v":0},{"$f":"IF($Q23=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q23,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G23","v":0},{"$f":"IF($Q23=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q23,目標ごとの達成度!$N$94:$N$102,0),1))*(F23+G23)","v":0},0,{"$f":"IF(P23=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P23,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q24,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F24","v":0},{"$f":"IF($Q24=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q24,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G24","v":0},{"$f":"IF($Q24=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q24,目標ごとの達成度!$N$94:$N$102,0),1))*(F24+G24)","v":0},0,{"$f":"IF(P24=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P24,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q25,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F25","v":0},{"$f":"IF($Q25=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q25,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G25","v":0},{"$f":"IF($Q25=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q25,目標ごとの達成度!$N$94:$N$102,0),1))*(F25+G25)","v":0},0,{"$f":"IF(P25=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P25,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q26,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F26","v":0},{"$f":"IF($Q26=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q26,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G26","v":0},{"$f":"IF($Q26=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q26,目標ごとの達成度!$N$94:$N$102,0),1))*(F26+G26)","v":0},0,{"$f":"IF(P26=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P26,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q27,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F27","v":0},{"$f":"IF($Q27=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q27,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G27","v":0},{"$f":"IF($Q27=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q27,目標ごとの達成度!$N$94:$N$102,0),1))*(F27+G27)","v":0},0,{"$f":"IF(P27=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P27,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q28,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F28","v":0},{"$f":"IF($Q28=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q28,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G28","v":0},{"$f":"IF($Q28=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q28,目標ごとの達成度!$N$94:$N$102,0),1))*(F28+G28)","v":0},0,{"$f":"IF(P28=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P28,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q29,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F29","v":0},{"$f":"IF($Q29=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q29,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G29","v":0},{"$f":"IF($Q29=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q29,目標ごとの達成度!$N$94:$N$102,0),1))*(F29+G29)","v":0},0,{"$f":"IF(P29=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P29,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q30,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F30","v":0},{"$f":"IF($Q30=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q30,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G30","v":0},{"$f":"IF($Q30=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q30,目標ごとの達成度!$N$94:$N$102,0),1))*(F30+G30)","v":0},0,{"$f":"IF(P30=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P30,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q31,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F31","v":0},{"$f":"IF($Q31=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q31,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G31","v":0},{"$f":"IF($Q31=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q31,目標ごとの達成度!$N$94:$N$102,0),1))*(F31+G31)","v":0},0,{"$f":"IF(P31=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P31,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q32,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F32","v":0},{"$f":"IF($Q32=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q32,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G32","v":0},{"$f":"IF($Q32=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q32,目標ごとの達成度!$N$94:$N$102,0),1))*(F32+G32)","v":0},0,{"$f":"IF(P32=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P32,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q33,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F33","v":0},{"$f":"IF($Q33=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q33,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G33","v":0},{"$f":"IF($Q33=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q33,目標ごとの達成度!$N$94:$N$102,0),1))*(F33+G33)","v":0},0,{"$f":"IF(P33=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P33,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q34,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F34","v":0},{"$f":"IF($Q34=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q34,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G34","v":0},{"$f":"IF($Q34=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q34,目標ごとの達成度!$N$94:$N$102,0),1))*(F34+G34)","v":0},0,{"$f":"IF(P34=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P34,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q35,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F35","v":0},{"$f":"IF($Q35=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q35,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G35","v":0},{"$f":"IF($Q35=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q35,目標ごとの達成度!$N$94:$N$102,0),1))*(F35+G35)","v":0},0,{"$f":"IF(P35=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P35,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q36,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F36","v":0},{"$f":"IF($Q36=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q36,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G36","v":0},{"$f":"IF($Q36=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q36,目標ごとの達成度!$N$94:$N$102,0),1))*(F36+G36)","v":0},0,{"$f":"IF(P36=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P36,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q37,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F37","v":0},{"$f":"IF($Q37=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q37,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G37","v":0},{"$f":"IF($Q37=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q37,目標ごとの達成度!$N$94:$N$102,0),1))*(F37+G37)","v":0},0,{"$f":"IF(P37=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P37,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q38,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F38","v":0},{"$f":"IF($Q38=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q38,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G38","v":0},{"$f":"IF($Q38=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q38,目標ごとの達成度!$N$94:$N$102,0),1))*(F38+G38)","v":0},0,{"$f":"IF(P38=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P38,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q39,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F39","v":0},{"$f":"IF($Q39=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q39,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G39","v":0},{"$f":"IF($Q39=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q39,目標ごとの達成度!$N$94:$N$102,0),1))*(F39+G39)","v":0},0,{"$f":"IF(P39=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P39,目標ごとの達成度!$N$108:$N$118,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,"○","数理情報概論",2,null,null,2,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q40=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q40,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F40","v":0},{"$f":"IF($Q40=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q40,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G40","v":0},{"$f":"IF($Q40=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q40,目標ごとの達成度!$N$94:$N$102,0),1))*(F40+G40)","v":0},{"$f":"IF(OR(D40=\"○\",D40=\"◎\"),U40,0)","v":0},{"$f":"IF(P40=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P40,目標ごとの達成度!$N$108:$N$118,0),1))","v":99},{"$f":"IF($W40=X$5,$S40+$T40,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($W40=AI$5,$V40,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($Q41=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q41,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F41","v":0},{"$f":"IF($Q41=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q41,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G41","v":0},{"$f":"IF($Q41=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q41,目標ごとの達成度!$N$94:$N$102,0),1))*(F41+G41)","v":0},0,{"$f":"IF(P41=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P41,目標ごとの達成度!$N$108:$N$118,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($Q42=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q42,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F42","v":0},{"$f":"IF($Q42=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q42,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G42","v":0},{"$f":"IF($Q42=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q42,目標ごとの達成度!$N$94:$N$102,0),1))*(F42+G42)","v":0},0,{"$f":"IF(P42=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P42,目標ごとの達成度!$N$108:$N$118,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($Q43=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q43,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F43","v":0},{"$f":"IF($Q43=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q43,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G43","v":0},{"$f":"IF($Q43=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q43,目標ごとの達成度!$N$94:$N$102,0),1))*(F43+G43)","v":0},0,{"$f":"IF(P43=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P43,目標ごとの達成度!$N$108:$N$118,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($Q44=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q44,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F44","v":0},{"$f":"IF($Q44=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q44,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G44","v":0},{"$f":"IF($Q44=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q44,目標ごとの達成度!$N$94:$N$102,0),1))*(F44+G44)","v":0},0,{"$f":"IF(P44=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P44,目標ごとの達成度!$N$108:$N$118,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($Q45=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q45,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F45","v":0},{"$f":"IF($Q45=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q45,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G45","v":0},{"$f":"IF($Q45=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q45,目標ごとの達成度!$N$94:$N$102,0),1))*(F45+G45)","v":0},0,{"$f":"IF(P45=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P45,目標ごとの達成度!$N$108:$N$118,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($Q46=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q46,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F46","v":0},{"$f":"IF($Q46=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q46,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G46","v":0},{"$f":"IF($Q46=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q46,目標ごとの達成度!$N$94:$N$102,0),1))*(F46+G46)","v":0},0,{"$f":"IF(P46=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P46,目標ごとの達成度!$N$108:$N$118,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($Q47=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q47,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F47","v":0},{"$f":"IF($Q47=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q47,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G47","v":0},{"$f":"IF($Q47=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q47,目標ごとの達成度!$N$94:$N$102,0),1))*(F47+G47)","v":0},0,{"$f":"IF(P47=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P47,目標ごとの達成度!$N$108:$N$118,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($Q48=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q48,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F48","v":0},{"$f":"IF($Q48=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q48,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G48","v":0},{"$f":"IF($Q48=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q48,目標ごとの達成度!$N$94:$N$102,0),1))*(F48+G48)","v":0},0,{"$f":"IF(P48=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P48,目標ごとの達成度!$N$108:$N$118,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($Q49=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q49,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F49","v":0},{"$f":"IF($Q49=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q49,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G49","v":0},{"$f":"IF($Q49=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q49,目標ごとの達成度!$N$94:$N$102,0),1))*(F49+G49)","v":0},0,{"$f":"IF(P49=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P49,目標ごとの達成度!$N$108:$N$118,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($Q50=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q50,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F50","v":0},{"$f":"IF($Q50=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q50,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G50","v":0},{"$f":"IF($Q50=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q50,目標ごとの達成度!$N$94:$N$102,0),1))*(F50+G50)","v":0},0,{"$f":"IF(P50=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P50,目標ごとの達成度!$N$108:$N$118,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,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($Q51=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q51,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F51","v":0},{"$f":"IF($Q51=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q51,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G51","v":0},{"$f":"IF($Q51=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q51,目標ごとの達成度!$N$94:$N$102,0),1))*(F51+G51)","v":0},0,{"$f":"IF(P51=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P51,目標ごとの達成度!$N$108:$N$118,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($Q52=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q52,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F52","v":0},{"$f":"IF($Q52=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q52,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G52","v":0},{"$f":"IF($Q52=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q52,目標ごとの達成度!$N$94:$N$102,0),1))*(F52+G52)","v":0},0,{"$f":"IF(P52=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P52,目標ごとの達成度!$N$108:$N$118,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($Q53=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q53,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F53","v":0},{"$f":"IF($Q53=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q53,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G53","v":0},{"$f":"IF($Q53=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q53,目標ごとの達成度!$N$94:$N$102,0),1))*(F53+G53)","v":0},0,{"$f":"IF(P53=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P53,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q54,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F54","v":0},{"$f":"IF($Q54=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q54,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G54","v":0},{"$f":"IF($Q54=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q54,目標ごとの達成度!$N$94:$N$102,0),1))*(F54+G54)","v":0},0,{"$f":"IF(P54=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P54,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q55,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F55","v":0},{"$f":"IF($Q55=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q55,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G55","v":0},{"$f":"IF($Q55=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q55,目標ごとの達成度!$N$94:$N$102,0),1))*(F55+G55)","v":0},0,{"$f":"IF(P55=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P55,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q56,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F56","v":0},{"$f":"IF($Q56=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q56,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G56","v":0},{"$f":"IF($Q56=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q56,目標ごとの達成度!$N$94:$N$102,0),1))*(F56+G56)","v":0},0,{"$f":"IF(P56=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P56,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q57,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F57","v":0},{"$f":"IF($Q57=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q57,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G57","v":0},{"$f":"IF($Q57=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q57,目標ごとの達成度!$N$94:$N$102,0),1))*(F57+G57)","v":0},0,{"$f":"IF(P57=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P57,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($Q58,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F58","v":0},{"$f":"IF($Q58=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q58,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G58","v":0},{"$f":"IF($Q58=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q58,目標ごとの達成度!$N$94:$N$102,0),1))*(F58+G58)","v":0},0,{"$f":"IF(P58=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P58,目標ごとの達成度!$N$108:$N$118,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($Q59=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q59,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F59","v":0},{"$f":"IF($Q59=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q59,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G59","v":0},{"$f":"IF($Q59=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q59,目標ごとの達成度!$N$94:$N$102,0),1))*(F59+G59)","v":0},0,{"$f":"IF(P59=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P59,目標ごとの達成度!$N$108:$N$118,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($Q60=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q60,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F60","v":0},{"$f":"IF($Q60=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q60,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G60","v":0},{"$f":"IF($Q60=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q60,目標ごとの達成度!$N$94:$N$102,0),1))*(F60+G60)","v":0},0,{"$f":"IF(P60=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P60,目標ごとの達成度!$N$108:$N$118,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($Q61=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q61,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F61","v":0},{"$f":"IF($Q61=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q61,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G61","v":0},{"$f":"IF($Q61=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q61,目標ごとの達成度!$N$94:$N$102,0),1))*(F61+G61)","v":0},0,{"$f":"IF(P61=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P61,目標ごとの達成度!$N$108:$N$118,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($Q62=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q62,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F62","v":0},{"$f":"IF($Q62=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q62,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G62","v":0},{"$f":"IF($Q62=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q62,目標ごとの達成度!$N$94:$N$102,0),1))*(F62+G62)","v":0},0,{"$f":"IF(P62=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P62,目標ごとの達成度!$N$108:$N$118,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($Q63=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q63,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F63","v":0},{"$f":"IF($Q63=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q63,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G63","v":0},{"$f":"IF($Q63=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q63,目標ごとの達成度!$N$94:$N$102,0),1))*(F63+G63)","v":0},0,{"$f":"IF(P63=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P63,目標ごとの達成度!$N$108:$N$118,0),1))","v":99},0,0,{"$f":"IF($W63=Z$5,$S63+$T63,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($W63=AK$5,$V63,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($Q64=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q64,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F64","v":0},{"$f":"IF($Q64=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q64,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G64","v":0},{"$f":"IF($Q64=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q64,目標ごとの達成度!$N$94:$N$102,0),1))*(F64+G64)","v":0},0,{"$f":"IF(P64=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P64,目標ごとの達成度!$N$108:$N$118,0),1))","v":99},{"$f":"IF($W64=X$5,$S64+$T64,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF($W64=AI$5,$V64,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($Q65=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q65,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F65","v":0},{"$f":"IF($Q65=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q65,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G65","v":0},{"$f":"IF($Q65=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q65,目標ごとの達成度!$N$94:$N$102,0),1))*(F65+G65)","v":0},0,{"$f":"IF(P65=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P65,目標ごとの達成度!$N$108:$N$118,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($Q66=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q66,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F66","v":0},{"$f":"IF($Q66=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q66,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G66","v":0},{"$f":"IF($Q66=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q66,目標ごとの達成度!$N$94:$N$102,0),1))*(F66+G66)","v":0},0,{"$f":"IF(P66=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P66,目標ごとの達成度!$N$108:$N$118,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($Q67=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q67,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F67","v":0},{"$f":"IF($Q67=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q67,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G67","v":0},{"$f":"IF($Q67=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q67,目標ごとの達成度!$N$94:$N$102,0),1))*(F67+G67)","v":0},0,{"$f":"IF(P67=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P67,目標ごとの達成度!$N$108:$N$118,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($Q68=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q68,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F68","v":0},{"$f":"IF($Q68=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q68,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G68","v":0},{"$f":"IF($Q68=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q68,目標ごとの達成度!$N$94:$N$102,0),1))*(F68+G68)","v":0},0,{"$f":"IF(P68=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P68,目標ごとの達成度!$N$108:$N$118,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($Q69=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q69,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F69","v":0},{"$f":"IF($Q69=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q69,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G69","v":0},{"$f":"IF($Q69=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q69,目標ごとの達成度!$N$94:$N$102,0),1))*(F69+G69)","v":0},0,{"$f":"IF(P69=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P69,目標ごとの達成度!$N$108:$N$118,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($Q70=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q70,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F70","v":0},{"$f":"IF($Q70=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q70,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G70","v":0},{"$f":"IF($Q70=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q70,目標ごとの達成度!$N$94:$N$102,0),1))*(F70+G70)","v":0},0,{"$f":"IF(P70=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P70,目標ごとの達成度!$N$108:$N$118,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($Q71=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q71,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F71","v":0},{"$f":"IF($Q71=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q71,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G71","v":0},{"$f":"IF($Q71=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q71,目標ごとの達成度!$N$94:$N$102,0),1))*(F71+G71)","v":0},0,{"$f":"IF(P71=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P71,目標ごとの達成度!$N$108:$N$118,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($Q72=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q72,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F72","v":0},{"$f":"IF($Q72=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q72,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G72","v":0},{"$f":"IF($Q72=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q72,目標ごとの達成度!$N$94:$N$102,0),1))*(F72+G72)","v":0},{"$f":"IF(OR(D72=\"○\",D72=\"◎\"),U72,0)","v":0},{"$f":"IF(P72=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P72,目標ごとの達成度!$N$108:$N$118,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($Q73=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q73,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F73","v":0},{"$f":"IF($Q73=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q73,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G73","v":0},{"$f":"IF($Q73=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q73,目標ごとの達成度!$N$94:$N$102,0),1))*(F73+G73)","v":0},0,{"$f":"IF(P73=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P73,目標ごとの達成度!$N$108:$N$118,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($Q74=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q74,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F74","v":0},{"$f":"IF($Q74=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q74,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G74","v":0},{"$f":"IF($Q74=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q74,目標ごとの達成度!$N$94:$N$102,0),1))*(F74+G74)","v":0},0,{"$f":"IF(P74=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P74,目標ごとの達成度!$N$108:$N$118,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($Q75=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q75,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F75","v":0},{"$f":"IF($Q75=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q75,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G75","v":0},{"$f":"IF($Q75=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q75,目標ごとの達成度!$N$94:$N$102,0),1))*(F75+G75)","v":0},0,{"$f":"IF(P75=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P75,目標ごとの達成度!$N$108:$N$118,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($Q76=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q76,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F76","v":0},{"$f":"IF($Q76=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q76,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G76","v":0},{"$f":"IF($Q76=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q76,目標ごとの達成度!$N$94:$N$102,0),1))*(F76+G76)","v":0},0,{"$f":"IF(P76=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P76,目標ごとの達成度!$N$108:$N$118,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($Q77=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q77,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F77","v":0},{"$f":"IF($Q77=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q77,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G77","v":0},{"$f":"IF($Q77=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q77,目標ごとの達成度!$N$94:$N$102,0),1))*(F77+G77)","v":0},0,{"$f":"IF(P77=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P77,目標ごとの達成度!$N$108:$N$118,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($Q78=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q78,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F78","v":0},{"$f":"IF($Q78=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q78,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G78","v":0},{"$f":"IF($Q78=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q78,目標ごとの達成度!$N$94:$N$102,0),1))*(F78+G78)","v":0},0,{"$f":"IF(P78=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P78,目標ごとの達成度!$N$108:$N$118,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($Q79=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q79,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F79","v":0},{"$f":"IF($Q79=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q79,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G79","v":0},{"$f":"IF($Q79=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q79,目標ごとの達成度!$N$94:$N$102,0),1))*(F79+G79)","v":0},0,{"$f":"IF(P79=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P79,目標ごとの達成度!$N$108:$N$118,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($Q80=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q80,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F80","v":0},{"$f":"IF($Q80=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q80,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*G80","v":0},{"$f":"IF($Q80=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($Q80,目標ごとの達成度!$N$94:$N$102,0),1))*(F80+G80)","v":0},0,{"$f":"IF(P80=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(P80,目標ごとの達成度!$N$108:$N$118,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:S80)","v":0},{"$f":"SUM(T6:T80)","v":0},0,0,null,{"$f":"SUM($X6:X80)","v":0},{"$f":"SUM($X6:Y80)","v":0},{"$f":"SUM($X6:Z80)","v":0},{"$f":"SUM($X6:AA80)","v":0},{"$f":"SUM($X6:AB80)","v":0},{"$f":"SUM($X6:AC80)","v":0},{"$f":"SUM($X6:AD80)","v":0},{"$f":"SUM($X6:AE80)","v":0},{"$f":"SUM($X6:AF80)","v":0},{"$f":"SUM($X6:AG80)","v":0},{"$f":"SUM($X6:AH80)","v":0},{"$f":"SUM($AI6:AI80)","v":0},{"$f":"SUM($AI6:AJ80)","v":0},{"$f":"SUM($AI6:AK80)","v":0},{"$f":"SUM($AI6:AL80)","v":0},{"$f":"SUM($AI6:AM80)","v":0},{"$f":"SUM($AI6:AN80)","v":0},{"$f":"SUM($AI6:AO80)","v":0},{"$f":"SUM($AI6:AP80)","v":0},{"$f":"SUM($AI6:AQ80)","v":0},{"$f":"SUM($AI6:AR80)","v":0},{"$f":"SUM($AI6:AS80)","v":0}]

{"sheet":"専門科目","index":1,"n_rows":51,"n_cols":43,"rows_kept":51,"cut":false,"hidden":false,"merged":[[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],[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]]}
[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$94:$O$102,MATCH($P6,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E6","v":0},{"$f":"IF($P6=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P6,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F6","v":0},{"$f":"IF($P6=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P6,目標ごとの達成度!$N$94:$N$102,0),1))*(E6+F6)","v":0},{"$f":"IF(O6=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O6,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P7,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E7","v":0},{"$f":"IF($P7=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P7,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F7","v":0},{"$f":"IF($P7=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P7,目標ごとの達成度!$N$94:$N$102,0),1))*(E7+F7)","v":0},{"$f":"IF(O7=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O7,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P8,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E8","v":0},{"$f":"IF($P8=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P8,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F8","v":0},{"$f":"IF($P8=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P8,目標ごとの達成度!$N$94:$N$102,0),1))*(E8+F8)","v":0},{"$f":"IF(O8=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O8,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P9,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E9","v":0},{"$f":"IF($P9=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P9,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F9","v":0},{"$f":"IF($P9=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P9,目標ごとの達成度!$N$94:$N$102,0),1))*(E9+F9)","v":0},{"$f":"IF(O9=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O9,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P10,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E10","v":0},{"$f":"IF($P10=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P10,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F10","v":0},{"$f":"IF($P10=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P10,目標ごとの達成度!$N$94:$N$102,0),1))*(E10+F10)","v":0},{"$f":"IF(O10=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O10,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P11,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E11","v":0},{"$f":"IF($P11=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P11,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F11","v":0},{"$f":"IF($P11=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P11,目標ごとの達成度!$N$94:$N$102,0),1))*(E11+F11)","v":0},{"$f":"IF(O11=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O11,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P12,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E12","v":0},{"$f":"IF($P12=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P12,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F12","v":0},{"$f":"IF($P12=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P12,目標ごとの達成度!$N$94:$N$102,0),1))*(E12+F12)","v":0},{"$f":"IF(O12=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O12,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P13,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E13","v":0},{"$f":"IF($P13=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P13,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F13","v":0},{"$f":"IF($P13=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P13,目標ごとの達成度!$N$94:$N$102,0),1))*(E13+F13)","v":0},{"$f":"IF(O13=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O13,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P14,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E14","v":0},{"$f":"IF($P14=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P14,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F14","v":0},{"$f":"IF($P14=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P14,目標ごとの達成度!$N$94:$N$102,0),1))*(E14+F14)","v":0},{"$f":"IF(O14=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O14,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P15,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E15","v":0},{"$f":"IF($P15=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P15,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F15","v":0},{"$f":"IF($P15=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P15,目標ごとの達成度!$N$94:$N$102,0),1))*(E15+F15)","v":0},{"$f":"IF(O15=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O15,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P16,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E16","v":0},{"$f":"IF($P16=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P16,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F16","v":0},{"$f":"IF($P16=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P16,目標ごとの達成度!$N$94:$N$102,0),1))*(E16+F16)","v":0},{"$f":"IF(O16=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O16,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P17,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E17","v":0},{"$f":"IF($P17=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P17,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F17","v":0},{"$f":"IF($P17=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P17,目標ごとの達成度!$N$94:$N$102,0),1))*(E17+F17)","v":0},{"$f":"IF(O17=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O17,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P18,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E18","v":0},{"$f":"IF($P18=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P18,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F18","v":0},{"$f":"IF($P18=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P18,目標ごとの達成度!$N$94:$N$102,0),1))*(E18+F18)","v":0},{"$f":"IF(O18=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O18,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P19,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E19","v":0},{"$f":"IF($P19=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P19,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F19","v":0},{"$f":"IF($P19=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P19,目標ごとの達成度!$N$94:$N$102,0),1))*(E19+F19)","v":0},{"$f":"IF(O19=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O19,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P20,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E20","v":0},{"$f":"IF($P20=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P20,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F20","v":0},{"$f":"IF($P20=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P20,目標ごとの達成度!$N$94:$N$102,0),1))*(E20+F20)","v":0},{"$f":"IF(O20=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O20,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P21,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E21","v":0},{"$f":"IF($P21=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P21,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F21","v":0},{"$f":"IF($P21=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P21,目標ごとの達成度!$N$94:$N$102,0),1))*(E21+F21)","v":0},{"$f":"IF(O21=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O21,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P22,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E22","v":0},{"$f":"IF($P22=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P22,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F22","v":0},{"$f":"IF($P22=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P22,目標ごとの達成度!$N$94:$N$102,0),1))*(E22+F22)","v":0},{"$f":"IF(O22=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O22,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P23,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E23","v":0},{"$f":"IF($P23=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P23,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F23","v":0},{"$f":"IF($P23=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P23,目標ごとの達成度!$N$94:$N$102,0),1))*(E23+F23)","v":0},{"$f":"IF(O23=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O23,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P24,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E24","v":0},{"$f":"IF($P24=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P24,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F24","v":0},{"$f":"IF($P24=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P24,目標ごとの達成度!$N$94:$N$102,0),1))*(E24+F24)","v":0},{"$f":"IF(O24=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O24,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P25,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E25","v":0},{"$f":"IF($P25=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P25,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F25","v":0},{"$f":"IF($P25=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P25,目標ごとの達成度!$N$94:$N$102,0),1))*(E25+F25)","v":0},{"$f":"IF(O25=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O25,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P26,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E26","v":0},{"$f":"IF($P26=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P26,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F26","v":0},{"$f":"IF($P26=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P26,目標ごとの達成度!$N$94:$N$102,0),1))*(E26+F26)","v":0},{"$f":"IF(O26=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O26,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P27,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E27","v":0},{"$f":"IF($P27=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P27,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F27","v":0},{"$f":"IF($P27=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P27,目標ごとの達成度!$N$94:$N$102,0),1))*(E27+F27)","v":0},{"$f":"IF(O27=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O27,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P28,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E28","v":0},{"$f":"IF($P28=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P28,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F28","v":0},{"$f":"IF($P28=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P28,目標ごとの達成度!$N$94:$N$102,0),1))*(E28+F28)","v":0},{"$f":"IF(O28=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O28,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P29,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E29","v":0},{"$f":"IF($P29=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P29,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F29","v":0},{"$f":"IF($P29=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P29,目標ごとの達成度!$N$94:$N$102,0),1))*(E29+F29)","v":0},{"$f":"IF(O29=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O29,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P30,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E30","v":0},{"$f":"IF($P30=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P30,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F30","v":0},{"$f":"IF($P30=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P30,目標ごとの達成度!$N$94:$N$102,0),1))*(E30+F30)","v":0},{"$f":"IF(O30=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O30,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P31,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E31","v":0},{"$f":"IF($P31=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P31,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F31","v":0},{"$f":"IF($P31=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P31,目標ごとの達成度!$N$94:$N$102,0),1))*(E31+F31)","v":0},{"$f":"IF(O31=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O31,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P32,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E32","v":0},{"$f":"IF($P32=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P32,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F32","v":0},{"$f":"IF($P32=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P32,目標ごとの達成度!$N$94:$N$102,0),1))*(E32+F32)","v":0},{"$f":"IF(O32=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O32,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P33,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E33","v":0},{"$f":"IF($P33=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P33,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F33","v":0},{"$f":"IF($P33=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P33,目標ごとの達成度!$N$94:$N$102,0),1))*(E33+F33)","v":0},{"$f":"IF(O33=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O33,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P34,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E34","v":0},{"$f":"IF($P34=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P34,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F34","v":0},{"$f":"IF($P34=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P34,目標ごとの達成度!$N$94:$N$102,0),1))*(E34+F34)","v":0},{"$f":"IF(O34=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O34,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P35,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E35","v":0},{"$f":"IF($P35=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P35,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F35","v":0},{"$f":"IF($P35=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P35,目標ごとの達成度!$N$94:$N$102,0),1))*(E35+F35)","v":0},{"$f":"IF(O35=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O35,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P36,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E36","v":0},{"$f":"IF($P36=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P36,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F36","v":0},{"$f":"IF($P36=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P36,目標ごとの達成度!$N$94:$N$102,0),1))*(E36+F36)","v":0},{"$f":"IF(O36=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O36,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P37,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E37","v":0},{"$f":"IF($P37=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P37,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F37","v":0},{"$f":"IF($P37=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P37,目標ごとの達成度!$N$94:$N$102,0),1))*(E37+F37)","v":0},{"$f":"IF(O37=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O37,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P38,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E38","v":0},{"$f":"IF($P38=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P38,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F38","v":0},{"$f":"IF($P38=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P38,目標ごとの達成度!$N$94:$N$102,0),1))*(E38+F38)","v":0},{"$f":"IF(O38=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O38,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P39,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E39","v":0},{"$f":"IF($P39=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P39,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F39","v":0},{"$f":"IF($P39=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P39,目標ごとの達成度!$N$94:$N$102,0),1))*(E39+F39)","v":0},{"$f":"IF(O39=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O39,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P40,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E40","v":0},{"$f":"IF($P40=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P40,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F40","v":0},{"$f":"IF($P40=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P40,目標ごとの達成度!$N$94:$N$102,0),1))*(E40+F40)","v":0},{"$f":"IF(O40=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O40,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P41,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E41","v":0},{"$f":"IF($P41=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P41,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F41","v":0},{"$f":"IF($P41=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P41,目標ごとの達成度!$N$94:$N$102,0),1))*(E41+F41)","v":0},{"$f":"IF(O41=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O41,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P42,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E42","v":0},{"$f":"IF($P42=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P42,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F42","v":0},{"$f":"IF($P42=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P42,目標ごとの達成度!$N$94:$N$102,0),1))*(E42+F42)","v":0},{"$f":"IF(O42=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O42,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P43,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E43","v":0},{"$f":"IF($P43=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P43,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F43","v":0},{"$f":"IF($P43=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P43,目標ごとの達成度!$N$94:$N$102,0),1))*(E43+F43)","v":0},{"$f":"IF(O43=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O43,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P44,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E44","v":0},{"$f":"IF($P44=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P44,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F44","v":0},{"$f":"IF($P44=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P44,目標ごとの達成度!$N$94:$N$102,0),1))*(E44+F44)","v":0},{"$f":"IF(O44=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O44,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P45,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E45","v":0},{"$f":"IF($P45=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P45,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F45","v":0},{"$f":"IF($P45=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P45,目標ごとの達成度!$N$94:$N$102,0),1))*(E45+F45)","v":0},{"$f":"IF(O45=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O45,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P46,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E46","v":0},{"$f":"IF($P46=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P46,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F46","v":0},{"$f":"IF($P46=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P46,目標ごとの達成度!$N$94:$N$102,0),1))*(E46+F46)","v":0},{"$f":"IF(O46=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O46,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P47,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E47","v":0},{"$f":"IF($P47=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P47,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F47","v":0},{"$f":"IF($P47=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P47,目標ごとの達成度!$N$94:$N$102,0),1))*(E47+F47)","v":0},{"$f":"IF(O47=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O47,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P48,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E48","v":0},{"$f":"IF($P48=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P48,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F48","v":0},{"$f":"IF($P48=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P48,目標ごとの達成度!$N$94:$N$102,0),1))*(E48+F48)","v":0},{"$f":"IF(O48=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O48,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P49,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E49","v":0},{"$f":"IF($P49=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P49,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F49","v":0},{"$f":"IF($P49=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P49,目標ごとの達成度!$N$94:$N$102,0),1))*(E49+F49)","v":0},{"$f":"IF(O49=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O49,目標ごとの達成度!$N$108:$N$118,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$94:$O$102,MATCH($P50,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*E50","v":0},{"$f":"IF($P50=\"\",0,IF(INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P50,目標ごとの達成度!$N$94:$N$102,0),1)>0,1,0))*F50","v":0},{"$f":"IF($P50=\"\",0,INDEX(目標ごとの達成度!$O$94:$O$102,MATCH($P50,目標ごとの達成度!$N$94:$N$102,0),1))*(E50+F50)","v":0},{"$f":"IF(O50=\"\",99,INDEX(目標ごとの達成度!$M$108:$M$118,MATCH(O50,目標ごとの達成度!$N$108:$N$118,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":[[0,1,0,9],[1,3,1,5],[1,1,2,2],[1,8,2,9],[2,3,2,4],[1,6,2,7],[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],[27,1,27,2],[27,3,27,9],[19,1,19,9],[20,1,20,2],[21,1,25,1],[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]]}
[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:T50)","v":0},null,{"$f":"SUM(共通科目!S35:S50)","v":0},{"$f":"SUM(共通科目!U35:U50)","v":0},null,{"$f":"IF(D5=0,0,G5/D5)","v":0}]
[null,null,"産業・経営リテラシー",{"$f":"SUM(共通科目!S51:T68)","v":0},null,{"$f":"SUM(共通科目!S51:S68)","v":0},{"$f":"SUM(共通科目!U51:U68)","v":0},null,0]
[null,null,"グローバルコミュニケーション",{"$f":"SUM(共通科目!S69:T76)","v":0},null,{"$f":"SUM(共通科目!S69:S76)","v":0},{"$f":"SUM(共通科目!U69:U76)","v":0},null,0]
[null,null,"健康運動科学",{"$f":"SUM(共通科目!S77:T80)","v":0},null,{"$f":"SUM(共通科目!S77:S80)","v":0},{"$f":"SUM(共通科目!U77:U80)","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:V80)+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":118,"n_cols":37,"rows_kept":118,"cut":false,"hidden":false,"merged":[[25,1,40,1],[41,1,50,1],[25,2,25,3],[86,1,91,1],[90,2,90,3],[88,2,88,3],[89,2,89,3],[84,2,84,3],[86,2,86,3],[87,2,87,3],[78,2,78,3],[80,2,80,3],[86,10,91,10],[13,2,13,3],[41,0,65,0],[41,8,50,8],[25,8,40,8],[27,2,27,3],[60,2,60,3],[65,2,65,3],[41,10,50,10],[48,2,48,3],[25,9,40,9],[43,2,43,3],[51,10,59,10],[86,8,91,8],[71,8,85,8],[86,9,91,9],[66,2,66,3],[51,1,59,1],[72,2,72,3],[85,2,85,3],[69,2,69,3],[57,2,57,3],[71,1,85,1],[79,2,79,3],[56,2,56,3],[60,1,65,1],[70,2,70,3],[68,2,68,3],[19,2,19,3],[6,2,6,3],[7,2,7,3],[14,2,14,3],[24,2,24,3],[12,8,24,8],[91,2,91,3],[25,10,40,10],[71,2,71,3],[67,2,67,3],[71,10,85,10],[81,2,81,3],[83,2,83,3],[74,2,74,3],[64,2,64,3],[63,2,63,3],[62,2,62,3],[61,2,61,3],[73,2,73,3],[76,2,76,3],[77,2,77,3],[75,2,75,3],[71,9,85,9],[82,2,82,3],[42,2,42,3],[51,8,59,8],[52,2,52,3],[53,2,53,3],[50,2,50,3],[47,2,47,3],[54,2,54,3],[51,2,51,3],[55,2,55,3],[59,2,59,3],[12,2,12,3],[18,2,18,3],[2,2,2,3],[3,2,3,3],[8,2,8,3],[0,0,0,10],[17,2,17,3],[1,0,1,1],[2,10,11,10],[12,10,24,10],[10,2,10,3],[11,2,11,3],[16,2,16,3],[21,2,21,3],[22,2,22,3],[9,2,9,3],[2,0,40,0],[29,2,29,3],[2,1,11,1],[28,2,28,3],[30,2,40,2],[23,2,23,3],[12,1,24,1],[5,2,5,3],[66,0,91,0],[66,1,70,1],[60,8,65,8],[60,9,65,9],[60,10,65,10],[66,8,70,8],[66,9,70,9],[66,10,70,10],[1,2,1,3],[41,2,41,3],[20,2,20,3],[4,2,4,3],[15,2,15,3],[58,2,58,3],[51,9,59,9],[45,2,45,3],[46,2,46,3],[44,2,44,3],[49,2,49,3],[2,9,11,9],[12,9,24,9],[2,8,11,8],[41,9,50,9],[26,2,26,3]]}
["「学習・教育到達目標」ごとの達成度"]
["学習・教育到達目標",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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C3,LEN(C3)-1),共通科目!E$6:Q$80,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$94:$O$103,MATCH(H3,$N$94:$N$103,0),1))","v":0},{"$f":"IF(OR(F3=\"\",H3=\"\"),0,F3*IF(INDEX($O$94:$O$103,MATCH(H3,$N$94:$N$103,0),1)>0,1,0))","v":0},{"$f":"IF(G3=\"\",99,INDEX($M$108:$M$118,MATCH(G3,$N$108:$N$118,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C4,LEN(C4)-1),共通科目!E$6:Q$80,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C5,LEN(C5)-1),共通科目!E$6:Q$80,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C6,LEN(C6)-1),共通科目!E$6:Q$80,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),共通科目!E$6:Q$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C7,LEN(C7)-1),共通科目!E$6:Q$80,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C10,LEN(C10)-1),共通科目!E$6:Q$80,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C11,LEN(C11)-1),共通科目!E$6:Q$80,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C12,LEN(C12)-1),共通科目!E$6:Q$80,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C13,LEN(C13)-1),共通科目!E$6:Q$80,13,FALSE)&\"\"","v":""},{"$f":"SUM(N13:N25)","v":0},{"$f":"IF(SUM(N13:N25)=0,\"0\",SUM(M13:M25))","v":"0"},{"$f":"IF(SUM(N13:N25)=0,\"0\",SUM(M13:M25)/SUM(N13:N25))","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(C14,LEN(C14)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C14,LEN(C14)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,{"$f":"IF($O14=AA$2,$N14,0)","v":0},{"$f":"IF($O14=AB$2,$N14,0)","v":0},{"$f":"IF($O14=AC$2,$N14,0)","v":0},{"$f":"IF($O14=AD$2,$N14,0)","v":0},{"$f":"IF($O14=AE$2,$N14,0)","v":0},{"$f":"IF($O14=AF$2,$N14,0)","v":0},{"$f":"IF($O14=AG$2,$N14,0)","v":0},{"$f":"IF($O14=AH$2,$N14,0)","v":0},{"$f":"IF($O14=AI$2,$N14,0)","v":0},{"$f":"IF($O14=AJ$2,$N14,0)","v":0},{"$f":"IF($O14=AK$2,$N14,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"　物理学演習Ⅰ",null,"１年前期",1,{"$f":"VLOOKUP(RIGHT(C15,LEN(C15)-1),共通科目!E$6:Q$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C15,LEN(C15)-1),共通科目!E$6:Q$80,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C16,LEN(C16)-1),共通科目!E$6:Q$80,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C17,LEN(C17)-1),共通科目!E$6:Q$80,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C18,LEN(C18)-1),共通科目!E$6:Q$80,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C19,LEN(C19)-1),共通科目!E$6:Q$80,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(C20,LEN(C20)-1),共通科目!E$6:Q$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C20,LEN(C20)-1),共通科目!E$6:Q$80,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($O20=AB$2,$M20,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"　地球科学実験",null,"２年後期",1,{"$f":"VLOOKUP(RIGHT(C21,LEN(C21)-1),共通科目!E$6:Q$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C21,LEN(C21)-1),共通科目!E$6:Q$80,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($O21=AA$2,$M21,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"◎環境生態学",null,"２年前期",2,{"$f":"VLOOKUP(RIGHT(C22,LEN(C22)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C22,LEN(C22)-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(C23,LEN(C23)-1),共通科目!E$6:Q$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C23,LEN(C23)-1),共通科目!E$6:Q$80,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,99,{"$f":"IF($O23=AA$2,$N23,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(C24,LEN(C24)-1),共通科目!E$6:Q$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C24,LEN(C24)-1),共通科目!E$6:Q$80,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(C25,LEN(C25)-1),共通科目!E$6:Q$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C25,LEN(C25)-1),共通科目!E$6:Q$80,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(C26,LEN(C26)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C26,LEN(C26)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},{"$f":"SUM(N26:N41)","v":0},{"$f":"IF(SUM(N26:N41)=0,\"0\",SUM(M26:M41))","v":"0"},{"$f":"IF(SUM(N26:N41)=0,\"0\",SUM(M26:M41)/SUM(N26:N41))","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(C27,LEN(C27)-1),共通科目!E$6:Q$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C27,LEN(C27)-1),共通科目!E$6:Q$80,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,"　建設マネジメント",null,"３年後期",2,{"$f":"VLOOKUP(RIGHT(C30,LEN(C30)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C30,LEN(C30)-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(D31=\"\",\"\",\"１～２年\")","v":""},{"$f":"IF(D31=\"\",\"\",INDEX(共通科目!$G$7:$G$50,MATCH(D31,共通科目!$E$7:$E$50,0),1))","v":""},{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,共通科目!E$6:Q$80,12,FALSE)&\"\")","v":""},{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,共通科目!E$6:Q$80,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$50,MATCH(D32,共通科目!$E$7:$E$50,0),1))","v":""},{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,共通科目!E$6:Q$80,12,FALSE)&\"\")","v":""},{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,共通科目!E$6:Q$80,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(D32=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D32))","v":""},{"$f":"IF(D33=\"\",\"\",\"１～２年\")","v":""},{"$f":"IF(D33=\"\",\"\",INDEX(共通科目!$G$7:$G$50,MATCH(D33,共通科目!$E$7:$E$50,0),1))","v":""},{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,共通科目!E$6:Q$80,12,FALSE)&\"\")","v":""},{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,共通科目!E$6:Q$80,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,99,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($O33=AA$2,$M33,0)","v":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$50,MATCH(D34,共通科目!$E$7:$E$50,0),1))","v":""},{"$f":"IF(D34=\"\",\"\",VLOOKUP(D34,共通科目!E$6:Q$80,12,FALSE)&\"\")","v":""},{"$f":"IF(D34=\"\",\"\",VLOOKUP(D34,共通科目!E$6:Q$80,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(D34=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D34))","v":""},"",{"$f":"IF(D35=\"\",\"\",INDEX(共通科目!$G$7:$G$50,MATCH(D35,共通科目!$E$7:$E$50,0),1))","v":""},{"$f":"IF(D35=\"\",\"\",VLOOKUP(D35,共通科目!E$6:Q$80,12,FALSE)&\"\")","v":""},{"$f":"IF(D35=\"\",\"\",VLOOKUP(D35,共通科目!E$6:Q$80,13,FALSE)&\"\")","v":""},null,null,null,null,0,0,99,{"$f":"IF($O35=AA$2,$N35,0)","v":0},{"$f":"IF($O35=AB$2,$N35,0)","v":0},{"$f":"IF($O35=AC$2,$N35,0)","v":0},{"$f":"IF($O35=AD$2,$N35,0)","v":0},{"$f":"IF($O35=AE$2,$N35,0)","v":0},{"$f":"IF($O35=AF$2,$N35,0)","v":0},{"$f":"IF($O35=AG$2,$N35,0)","v":0},{"$f":"IF($O35=AH$2,$N35,0)","v":0},{"$f":"IF($O35=AI$2,$N35,0)","v":0},{"$f":"IF($O35=AJ$2,$N35,0)","v":0},{"$f":"IF($O35=AK$2,$N35,0)","v":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$50,MATCH(D36,共通科目!$E$7:$E$50,0),1))","v":""},{"$f":"IF(D36=\"\",\"\",VLOOKUP(D36,共通科目!E$6:Q$80,12,FALSE)&\"\")","v":""},{"$f":"IF(D36=\"\",\"\",VLOOKUP(D36,共通科目!E$6:Q$80,13,FALSE)&\"\")","v":""},null,null,null,null,{"$f":"IF(OR(F36=\"\",H36=\"\"),0,F36*INDEX($O$94:$O$103,MATCH(H36,$N$94:$N$103,0),1))","v":0},{"$f":"IF(OR(F36=\"\",H36=\"\"),0,F36*IF(INDEX($O$94:$O$103,MATCH(H36,$N$94:$N$103,0),1)>0,1,0))","v":0},{"$f":"IF(G36=\"\",99,INDEX($M$108:$M$118,MATCH(G36,$N$108:$N$118,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,{"$f":"IF(D36=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D36))","v":""},"",{"$f":"IF(D37=\"\",\"\",INDEX(共通科目!$G$7:$G$50,MATCH(D37,共通科目!$E$7:$E$50,0),1))","v":""},{"$f":"IF(D37=\"\",\"\",VLOOKUP(D37,共通科目!E$6:Q$80,12,FALSE)&\"\")","v":""},{"$f":"IF(D37=\"\",\"\",VLOOKUP(D37,共通科目!E$6:Q$80,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$50,MATCH(D38,共通科目!$E$7:$E$50,0),1))","v":""},{"$f":"IF(D38=\"\",\"\",VLOOKUP(D38,共通科目!E$6:Q$80,12,FALSE)&\"\")","v":""},{"$f":"IF(D38=\"\",\"\",VLOOKUP(D38,共通科目!E$6:Q$80,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$50,MATCH(D39,共通科目!$E$7:$E$50,0),1))","v":""},{"$f":"IF(D39=\"\",\"\",VLOOKUP(D39,共通科目!E$6:Q$80,12,FALSE)&\"\")","v":""},{"$f":"IF(D39=\"\",\"\",VLOOKUP(D39,共通科目!E$6:Q$80,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$50,MATCH(D40,共通科目!$E$7:$E$50,0),1))","v":""},{"$f":"IF(D40=\"\",\"\",VLOOKUP(D40,共通科目!E$6:Q$80,12,FALSE)&\"\")","v":""},{"$f":"IF(D40=\"\",\"\",VLOOKUP(D40,共通科目!E$6:Q$80,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(D40=\"\",\"\",SearchKamoku(共通科目!E$7:Q$34,D40))","v":""},"",{"$f":"IF(D41=\"\",\"\",INDEX(共通科目!$G$7:$G$50,MATCH(D41,共通科目!$E$7:$E$50,0),1))","v":""},{"$f":"IF(D41=\"\",\"\",VLOOKUP(D41,共通科目!E$6:Q$80,12,FALSE)&\"\")","v":""},{"$f":"IF(D41=\"\",\"\",VLOOKUP(D41,共通科目!E$6:Q$80,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(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":""},{"$f":"SUM(N42:N51)","v":0},{"$f":"IF(SUM(N42:N51)=0,\"0\",SUM(M42:M51))","v":"0"},{"$f":"IF(SUM(N42:N51)=0,\"0\",SUM(M42:M51)/SUM(N42:N51))","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(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,{"$f":"IF($O43=AA$2,$N43,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(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,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,{"$f":"IF($O50=AA$2,$M50,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,"◎測量学",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":""},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(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":""},{"$f":"SUM(N52:N60)","v":0},{"$f":"IF(SUM(N52:N60)=0,\"0\",SUM(M52:M60))","v":"0"},{"$f":"IF(SUM(N52:N60)=0,\"0\",SUM(M52:M60)/SUM(N52:N60))","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(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,null,"◎環境都市設計製図",null,"３年後期",1,{"$f":"VLOOKUP(RIGHT(C60,LEN(C60)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C60,LEN(C60)-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,"１年前期",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":""},{"$f":"SUM(N61:N66)","v":0},{"$f":"IF(SUM(N61:N66)=0,\"0\",SUM(M61:M66))","v":"0"},{"$f":"IF(SUM(N61:N66)=0,\"0\",SUM(M61:M66)/SUM(N61:N66))","v":"0"},null,0,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C63,LEN(C63)-1),共通科目!E$6:Q$80,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$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C64,LEN(C64)-1),共通科目!E$6:Q$80,13,FALSE)&\"\"","v":""},null,null,null,null,0,0,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,"１年前期",1,{"$f":"VLOOKUP(RIGHT(C67,LEN(C67)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C67,LEN(C67)-1),専門科目!D$6:P$50,13,FALSE)&\"\"","v":""},{"$f":"SUM(N67:N71)","v":0},{"$f":"IF(SUM(N67:N71)=0,\"0\",SUM(M67:M71))","v":"0"},{"$f":"IF(SUM(N67:N71)=0,\"0\",SUM(M67:M71)/SUM(N67:N71))","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,"◎English SeminarⅠ",null,"１年前期",1,{"$f":"VLOOKUP(RIGHT(C68,LEN(C68)-1),共通科目!E$6:Q$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C68,LEN(C68)-1),共通科目!E$6:Q$80,13,FALSE)&\"\"","v":""},null,null,null,null,{"$f":"IF(OR(F68=\"\",H68=\"\"),0,F68*INDEX($O$94:$O$103,MATCH(H68,$N$94:$N$103,0),1))","v":0},{"$f":"IF(OR(F68=\"\",H68=\"\"),0,F68*IF(INDEX($O$94:$O$103,MATCH(H68,$N$94:$N$103,0),1)>0,1,0))","v":0},{"$f":"IF(G68=\"\",99,INDEX($M$108:$M$118,MATCH(G68,$N$108:$N$118,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,"◎English SeminarⅡ",null,"１年後期",1,{"$f":"VLOOKUP(RIGHT(C69,LEN(C69)-1),共通科目!E$6:Q$80,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C69,LEN(C69)-1),共通科目!E$6:Q$80,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(C70,LEN(C70)-1),専門科目!D$6:P$50,12,FALSE)&\"\"","v":""},{"$f":"VLOOKUP(RIGHT(C70,LEN(C70)-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(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,"(H) 社会基盤整備の応用技術\n(社会基盤の整備に対する基本的理論と応用的な技術を習得する)","◎地盤解析学",null,"２年後期",2,{"$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":""},{"$f":"SUM(N72:N86)","v":0},{"$f":"IF(SUM(N72:N86)=0,\"0\",SUM(M72:M86))","v":"0"},{"$f":"IF(SUM(N72:N86)=0,\"0\",SUM(M72:M86)/SUM(N72:N86))","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(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":""},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(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,{"$f":"IF($O75=AA$2,$N75,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(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,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,{"$f":"IF(OR(F80=\"\",H80=\"\"),0,F80*INDEX($O$94:$O$103,MATCH(H80,$N$94:$N$103,0),1))","v":0},{"$f":"IF(OR(F80=\"\",H80=\"\"),0,F80*IF(INDEX($O$94:$O$103,MATCH(H80,$N$94:$N$103,0),1)>0,1,0))","v":0},{"$f":"IF(G80=\"\",99,INDEX($M$108:$M$118,MATCH(G80,$N$108:$N$118,0),1))","v":99},{"$f":"IF($O80=AA$2,$N80,0)","v":0},{"$f":"IF($O80=AB$2,$N80,0)","v":0},{"$f":"IF($O80=AC$2,$N80,0)","v":0},{"$f":"IF($O80=AD$2,$N80,0)","v":0},{"$f":"IF($O80=AE$2,$N80,0)","v":0},{"$f":"IF($O80=AF$2,$N80,0)","v":0},{"$f":"IF($O80=AG$2,$N80,0)","v":0},{"$f":"IF($O80=AH$2,$N80,0)","v":0},{"$f":"IF($O80=AI$2,$N80,0)","v":0},{"$f":"IF($O80=AJ$2,$N80,0)","v":0},{"$f":"IF($O80=AK$2,$N80,0)","v":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$94:$O$103,MATCH(H81,$N$94:$N$103,0),1))","v":0},{"$f":"IF(OR(F81=\"\",H81=\"\"),0,F81*IF(INDEX($O$94:$O$103,MATCH(H81,$N$94:$N$103,0),1)>0,1,0))","v":0},{"$f":"IF(G81=\"\",99,INDEX($M$108:$M$118,MATCH(G81,$N$108:$N$118,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,{"$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,{"$f":"IF($O82=AA$2,$M82,0)","v":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,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,"(I) デザイン能力\n(自ら問題を発見し，調査・分析・評価・提案を行うことにより問題を解決する能力を身につける)","◎社会工学基礎Ⅳ",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":""},{"$f":"SUM(N87:N92)","v":0},{"$f":"IF(SUM(N87:N92)=0,\"0\",SUM(M87:M92))","v":"0"},{"$f":"IF(SUM(N87:N92)=0,\"0\",SUM(M87:M92)/SUM(N87:N92))","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(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":""},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(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,{"$f":"IF($O89=AA$2,$N89,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(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,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(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,"４年次",8,{"$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,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,"入学年度",2020]
[]
[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$105&\"年度　前期\"","v":"2020年度　前期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"O$105&\"年度　後期\"","v":"2020年度　後期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"O$105+1&\"年度　前期\"","v":"2021年度　前期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"O$105+1&\"年度　後期\"","v":"2021年度　後期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"O$105+2&\"年度　前期\"","v":"2022年度　前期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"O$105+2&\"年度　後期\"","v":"2022年度　後期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"O$105+3&\"年度　前期\"","v":"2023年度　前期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"O$105+3&\"年度　後期\"","v":"2023年度　後期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"O$105+4&\"年度　前期\"","v":"2024年度　前期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"O$105+4&\"年度　後期\"","v":"2024年度　後期"}]
[null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"O$105+5&\"年度　以降\"","v":"2025年度　以降"}]

{"sheet":"総括表","index":4,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[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],[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]]}
[null,"入学年度：",{"$f":"目標ごとの達成度!O105","v":2020},"年度",null,null,null,null,null,{"$f":"NOW()","v":"2020-03-18T15:34:28.400"}]
["「学習・教育到達目標」達成状況の総括表"]
["※学期ごとに，これらの数値をＪノートの総括表に転記すること"]
["学習・教育目標",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":""},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$3:Q12))","v":""},{"$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":""},{"$f":"IF(D$30>$J$1,\"\",IF(D7=0,0,SUM(目標ごとの達成度!$AA$3:AB12)/D7))","v":""},{"$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:P25))","v":""},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:Q25))","v":""},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:R25))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:S25))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:T25))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:U25))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:V25))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:W25))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:X25))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:Y25))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$13:Z25))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C9=0,0,SUM(目標ごとの達成度!$AA$13:AA25)/C9))","v":""},{"$f":"IF(D$30>$J$1,\"\",IF(D9=0,0,SUM(目標ごとの達成度!$AA$13:AB25)/D9))","v":""},{"$f":"IF(E$30>$J$1,\"\",IF(E9=0,0,SUM(目標ごとの達成度!$AA$13:AC25)/E9))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F9=0,0,SUM(目標ごとの達成度!$AA$13:AD25)/F9))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G9=0,0,SUM(目標ごとの達成度!$AA$13:AE25)/G9))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H9=0,0,SUM(目標ごとの達成度!$AA$13:AF25)/H9))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I9=0,0,SUM(目標ごとの達成度!$AA$13:AG25)/I9))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J9=0,0,SUM(目標ごとの達成度!$AA$13:AH25)/J9))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K9=0,0,SUM(目標ごとの達成度!$AA$13:AI25)/K9))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L9=0,0,SUM(目標ごとの達成度!$AA$13:AJ25)/L9))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M9=0,0,SUM(目標ごとの達成度!$AA$13:AK25)/M9))","v":""}]
["(C)多面的思考と技術者倫理","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$26:P41))","v":""},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$26:Q41))","v":""},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$26:R41))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$26:S41))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$26:T41))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$26:U41))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$26:V41))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$26:W41))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$26:X41))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$26:Y41))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$26:Z41))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C11=0,0,SUM(目標ごとの達成度!$AA$26:AA41)/C11))","v":""},{"$f":"IF(D$30>$J$1,\"\",IF(D11=0,0,SUM(目標ごとの達成度!$AA$26:AB41)/D11))","v":""},{"$f":"IF(E$30>$J$1,\"\",IF(E11=0,0,SUM(目標ごとの達成度!$AA$26:AC41)/E11))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F11=0,0,SUM(目標ごとの達成度!$AA$26:AD41)/F11))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G11=0,0,SUM(目標ごとの達成度!$AA$26:AE41)/G11))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H11=0,0,SUM(目標ごとの達成度!$AA$26:AF41)/H11))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I11=0,0,SUM(目標ごとの達成度!$AA$26:AG41)/I11))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J11=0,0,SUM(目標ごとの達成度!$AA$26:AH41)/J11))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K11=0,0,SUM(目標ごとの達成度!$AA$26:AI41)/K11))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L11=0,0,SUM(目標ごとの達成度!$AA$26:AJ41)/L11))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M11=0,0,SUM(目標ごとの達成度!$AA$26:AK41)/M11))","v":""}]
["(D)主要専門基礎","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$42:P51))","v":""},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$42:Q51))","v":""},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$42:R51))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$42:S51))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$42:T51))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$42:U51))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$42:V51))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$42:W51))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$42:X51))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$42:Y51))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$42:Z51))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C13=0,0,SUM(目標ごとの達成度!$AA$42:AA51)/C13))","v":""},{"$f":"IF(D$30>$J$1,\"\",IF(D13=0,0,SUM(目標ごとの達成度!$AA$42:AB51)/D13))","v":""},{"$f":"IF(E$30>$J$1,\"\",IF(E13=0,0,SUM(目標ごとの達成度!$AA$42:AC51)/E13))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F13=0,0,SUM(目標ごとの達成度!$AA$42:AD51)/F13))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G13=0,0,SUM(目標ごとの達成度!$AA$42:AE51)/G13))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H13=0,0,SUM(目標ごとの達成度!$AA$42:AF51)/H13))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I13=0,0,SUM(目標ごとの達成度!$AA$42:AG51)/I13))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J13=0,0,SUM(目標ごとの達成度!$AA$42:AH51)/J13))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K13=0,0,SUM(目標ごとの達成度!$AA$42:AI51)/K13))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L13=0,0,SUM(目標ごとの達成度!$AA$42:AJ51)/L13))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M13=0,0,SUM(目標ごとの達成度!$AA$42:AK51)/M13))","v":""}]
["(E)自主学習・応用能力","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$52:P60))","v":""},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$52:Q60))","v":""},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$52:R60))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$52:S60))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$52:T60))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$52:U60))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$52:V60))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$52:W60))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$52:X60))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$52:Y60))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$52:Z60))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C15=0,0,SUM(目標ごとの達成度!$AA$52:AA60)/C15))","v":""},{"$f":"IF(D$30>$J$1,\"\",IF(D15=0,0,SUM(目標ごとの達成度!$AA$52:AB60)/D15))","v":""},{"$f":"IF(E$30>$J$1,\"\",IF(E15=0,0,SUM(目標ごとの達成度!$AA$52:AC60)/E15))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F15=0,0,SUM(目標ごとの達成度!$AA$52:AD60)/F15))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G15=0,0,SUM(目標ごとの達成度!$AA$52:AE60)/G15))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H15=0,0,SUM(目標ごとの達成度!$AA$52:AF60)/H15))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I15=0,0,SUM(目標ごとの達成度!$AA$52:AG60)/I15))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J15=0,0,SUM(目標ごとの達成度!$AA$52:AH60)/J15))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K15=0,0,SUM(目標ごとの達成度!$AA$52:AI60)/K15))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L15=0,0,SUM(目標ごとの達成度!$AA$52:AJ60)/L15))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M15=0,0,SUM(目標ごとの達成度!$AA$52:AK60)/M15))","v":""}]
["(F)チームによる実体験","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$61:P66))","v":""},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$61:Q66))","v":""},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$61:R66))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$61:S66))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$61:T66))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$61:U66))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$61:V66))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$61:W66))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$61:X66))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$61:Y66))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$61:Z66))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C17=0,0,SUM(目標ごとの達成度!$AA$61:AA66)/C17))","v":""},{"$f":"IF(D$30>$J$1,\"\",IF(D17=0,0,SUM(目標ごとの達成度!$AA$61:AB66)/D17))","v":""},{"$f":"IF(E$30>$J$1,\"\",IF(E17=0,0,SUM(目標ごとの達成度!$AA$61:AC66)/E17))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F17=0,0,SUM(目標ごとの達成度!$AA$61:AD66)/F17))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G17=0,0,SUM(目標ごとの達成度!$AA$61:AE66)/G17))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H17=0,0,SUM(目標ごとの達成度!$AA$61:AF66)/H17))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I17=0,0,SUM(目標ごとの達成度!$AA$61:AG66)/I17))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J17=0,0,SUM(目標ごとの達成度!$AA$61:AH66)/J17))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K17=0,0,SUM(目標ごとの達成度!$AA$61:AI66)/K17))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L17=0,0,SUM(目標ごとの達成度!$AA$61:AJ66)/L17))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M17=0,0,SUM(目標ごとの達成度!$AA$61:AK66)/M17))","v":""}]
["(G)コミュニケーション能力","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:P71))","v":""},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:Q71))","v":""},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:R71))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:S71))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:T71))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:U71))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:V71))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:W71))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:X71))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:Y71))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$67:Z71))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C19=0,0,SUM(目標ごとの達成度!$AA$67:AA71)/C19))","v":""},{"$f":"IF(D$30>$J$1,\"\",IF(D19=0,0,SUM(目標ごとの達成度!$AA$67:AB71)/D19))","v":""},{"$f":"IF(E$30>$J$1,\"\",IF(E19=0,0,SUM(目標ごとの達成度!$AA$67:AC71)/E19))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F19=0,0,SUM(目標ごとの達成度!$AA$67:AD71)/F19))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G19=0,0,SUM(目標ごとの達成度!$AA$67:AE71)/G19))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H19=0,0,SUM(目標ごとの達成度!$AA$67:AF71)/H19))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I19=0,0,SUM(目標ごとの達成度!$AA$67:AG71)/I19))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J19=0,0,SUM(目標ごとの達成度!$AA$67:AH71)/J19))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K19=0,0,SUM(目標ごとの達成度!$AA$67:AI71)/K19))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L19=0,0,SUM(目標ごとの達成度!$AA$67:AJ71)/L19))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M19=0,0,SUM(目標ごとの達成度!$AA$67:AK71)/M19))","v":""}]
["(H)社会基盤の応用技術","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$72:P86))","v":""},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$72:Q86))","v":""},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$72:R86))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$72:S86))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$72:T86))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$72:U86))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$72:V86))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$72:W86))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$72:X86))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$72:Y86))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$72:Z86))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C21=0,0,SUM(目標ごとの達成度!$AA$72:AA86)/C21))","v":""},{"$f":"IF(D$30>$J$1,\"\",IF(D21=0,0,SUM(目標ごとの達成度!$AA$72:AB86)/D21))","v":""},{"$f":"IF(E$30>$J$1,\"\",IF(E21=0,0,SUM(目標ごとの達成度!$AA$72:AC86)/E21))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F21=0,0,SUM(目標ごとの達成度!$AA$72:AD86)/F21))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G21=0,0,SUM(目標ごとの達成度!$AA$72:AE86)/G21))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H21=0,0,SUM(目標ごとの達成度!$AA$72:AF86)/H21))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I21=0,0,SUM(目標ごとの達成度!$AA$72:AG86)/I21))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J21=0,0,SUM(目標ごとの達成度!$AA$72:AH86)/J21))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K21=0,0,SUM(目標ごとの達成度!$AA$72:AI86)/K21))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L21=0,0,SUM(目標ごとの達成度!$AA$72:AJ86)/L21))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M21=0,0,SUM(目標ごとの達成度!$AA$72:AK86)/M21))","v":""}]
["(I)デザイン能力","単位数",{"$f":"IF(C$30>$J$1,\"\",SUM(目標ごとの達成度!$P$87:P92))","v":""},{"$f":"IF(D$30>$J$1,\"\",SUM(目標ごとの達成度!$P$87:Q92))","v":""},{"$f":"IF(E$30>$J$1,\"\",SUM(目標ごとの達成度!$P$87:R92))","v":""},{"$f":"IF(F$30>$J$1,\"\",SUM(目標ごとの達成度!$P$87:S92))","v":""},{"$f":"IF(G$30>$J$1,\"\",SUM(目標ごとの達成度!$P$87:T92))","v":""},{"$f":"IF(H$30>$J$1,\"\",SUM(目標ごとの達成度!$P$87:U92))","v":""},{"$f":"IF(I$30>$J$1,\"\",SUM(目標ごとの達成度!$P$87:V92))","v":""},{"$f":"IF(J$30>$J$1,\"\",SUM(目標ごとの達成度!$P$87:W92))","v":""},{"$f":"IF(K$30>$J$1,\"\",SUM(目標ごとの達成度!$P$87:X92))","v":""},{"$f":"IF(L$30>$J$1,\"\",SUM(目標ごとの達成度!$P$87:Y92))","v":""},{"$f":"IF(M$30>$J$1,\"\",SUM(目標ごとの達成度!$P$87:Z92))","v":""}]
[null,"GPA",{"$f":"IF(C$30>$J$1,\"\",IF(C23=0,0,SUM(目標ごとの達成度!$AA87:AA$92)/C23))","v":""},{"$f":"IF(D$30>$J$1,\"\",IF(D23=0,0,SUM(目標ごとの達成度!$AA87:AB$92)/D23))","v":""},{"$f":"IF(E$30>$J$1,\"\",IF(E23=0,0,SUM(目標ごとの達成度!$AA87:AC$92)/E23))","v":""},{"$f":"IF(F$30>$J$1,\"\",IF(F23=0,0,SUM(目標ごとの達成度!$AA87:AD$92)/F23))","v":""},{"$f":"IF(G$30>$J$1,\"\",IF(G23=0,0,SUM(目標ごとの達成度!$AA87:AE$92)/G23))","v":""},{"$f":"IF(H$30>$J$1,\"\",IF(H23=0,0,SUM(目標ごとの達成度!$AA87:AF$92)/H23))","v":""},{"$f":"IF(I$30>$J$1,\"\",IF(I23=0,0,SUM(目標ごとの達成度!$AA87:AG$92)/I23))","v":""},{"$f":"IF(J$30>$J$1,\"\",IF(J23=0,0,SUM(目標ごとの達成度!$AA87:AH$92)/J23))","v":""},{"$f":"IF(K$30>$J$1,\"\",IF(K23=0,0,SUM(目標ごとの達成度!$AA87:AI$92)/K23))","v":""},{"$f":"IF(L$30>$J$1,\"\",IF(L23=0,0,SUM(目標ごとの達成度!$AA87:AJ$92)/L23))","v":""},{"$f":"IF(M$30>$J$1,\"\",IF(M23=0,0,SUM(目標ごとの達成度!$AA87:AK$92)/M23))","v":""}]
["土木GPT対象科目の単位数",null,{"$f":"IF(C$30>$J$1,\"\",共通科目!X81+専門科目!V51)","v":""},{"$f":"IF(D$30>$J$1,\"\",共通科目!Y81+専門科目!W51)","v":""},{"$f":"IF(E$30>$J$1,\"\",共通科目!Z81+専門科目!X51)","v":""},{"$f":"IF(F$30>$J$1,\"\",共通科目!AA81+専門科目!Y51)","v":""},{"$f":"IF(G$30>$J$1,\"\",共通科目!AB81+専門科目!Z51)","v":""},{"$f":"IF(H$30>$J$1,\"\",共通科目!AC81+専門科目!AA51)","v":""},{"$f":"IF(I$30>$J$1,\"\",共通科目!AD81+専門科目!AB51)","v":""},{"$f":"IF(J$30>$J$1,\"\",共通科目!AE81+専門科目!AC51)","v":""},{"$f":"IF(K$30>$J$1,\"\",共通科目!AF81+専門科目!AD51)","v":""},{"$f":"IF(L$30>$J$1,\"\",共通科目!AG81+専門科目!AE51)","v":""},{"$f":"IF(M$30>$J$1,\"\",共通科目!AH81+専門科目!AF51)","v":""}]
["土木GPT対象科目のGPA",null,{"$f":"IF(C$30>$J$1,\"\",IF(C25=0,0,C27/C25))","v":""},"","","","","","","","","",""]
["土木GPT",null,{"$f":"IF(C$30>$J$1,\"\",共通科目!AI81+専門科目!AG51)","v":""},{"$f":"IF(D$30>$J$1,\"\",共通科目!AJ81+専門科目!AH51)","v":""},{"$f":"IF(E$30>$J$1,\"\",共通科目!AK81+専門科目!AI51)","v":""},{"$f":"IF(F$30>$J$1,\"\",共通科目!AL81+専門科目!AJ51)","v":""},{"$f":"IF(G$30>$J$1,\"\",共通科目!AM81+専門科目!AK51)","v":""},{"$f":"IF(H$30>$J$1,\"\",共通科目!AN81+専門科目!AL51)","v":""},{"$f":"IF(I$30>$J$1,\"\",共通科目!AO81+専門科目!AM51)","v":""},{"$f":"IF(J$30>$J$1,\"\",共通科目!AP81+専門科目!AN51)","v":""},{"$f":"IF(K$30>$J$1,\"\",共通科目!AQ81+専門科目!AO51)","v":""},{"$f":"IF(L$30>$J$1,\"\",共通科目!AR81+専門科目!AP51)","v":""},{"$f":"IF(M$30>$J$1,\"\",共通科目!AS81+専門科目!AQ51)","v":""}]
[null,null,{"$f":"C1","v":2020},{"$f":"C28+1","v":2021},{"$f":"D28","v":2021},{"$f":"E28+1","v":2022},{"$f":"F28","v":2022},{"$f":"G28+1","v":2023},{"$f":"H28","v":2023},{"$f":"I28+1","v":2024},{"$f":"J28","v":2024},{"$f":"K28+1","v":2025},{"$f":"L28","v":2025}]
[null,null,9,3,9,3,9,3,9,3,9,3,9]
[null,null,{"$f":"DATE(C28,C29,1)","v":"2020-09-01"},{"$f":"DATE(D28,D29,1)","v":"2021-03-01"},"2021-09-01","2022-03-01","2022-09-01","2023-03-01","2023-09-01","2024-03-01","2024-09-01","2025-03-01","2025-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:N25)","v":0},{"$f":"SUM(目標ごとの達成度!M13:M25)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P13:P25)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:Q25)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:R25)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:S25)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:T25)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:U25)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:V25)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:W25)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:X25)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:Y25)","v":0},{"$f":"SUM(目標ごとの達成度!$P13:Z25)","v":0},{"$f":"SUM(目標ごとの達成度!$AA13:AA25)","v":0},{"$f":"SUM(目標ごとの達成度!AB13:AB25)","v":0},{"$f":"SUM(目標ごとの達成度!AC13:AC25)","v":0},{"$f":"SUM(目標ごとの達成度!AD13:AD25)","v":0},{"$f":"SUM(目標ごとの達成度!AE13:AE25)","v":0},{"$f":"SUM(目標ごとの達成度!AF13:AF25)","v":0},{"$f":"SUM(目標ごとの達成度!AG13:AG25)","v":0},{"$f":"SUM(目標ごとの達成度!AH13:AH25)","v":0},{"$f":"SUM(目標ごとの達成度!AI13:AI25)","v":0},{"$f":"SUM(目標ごとの達成度!AJ13:AJ25)","v":0},{"$f":"SUM(目標ごとの達成度!AK13:AK25)","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(目標ごとの達成度!N26:N41)","v":0},{"$f":"SUM(目標ごとの達成度!M26:M41)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P26:P41)","v":0},{"$f":"SUM(目標ごとの達成度!$P26:Q41)","v":0},{"$f":"SUM(目標ごとの達成度!$P26:R41)","v":0},{"$f":"SUM(目標ごとの達成度!$P26:S41)","v":0},{"$f":"SUM(目標ごとの達成度!$P26:T41)","v":0},{"$f":"SUM(目標ごとの達成度!$P26:U41)","v":0},{"$f":"SUM(目標ごとの達成度!$P26:V41)","v":0},{"$f":"SUM(目標ごとの達成度!$P26:W41)","v":0},{"$f":"SUM(目標ごとの達成度!$P26:X41)","v":0},{"$f":"SUM(目標ごとの達成度!$P26:Y41)","v":0},{"$f":"SUM(目標ごとの達成度!$P26:Z41)","v":0},{"$f":"SUM(目標ごとの達成度!$AA26:AA41)","v":0},{"$f":"SUM(目標ごとの達成度!AB26:AB41)","v":0},{"$f":"SUM(目標ごとの達成度!AC26:AC41)","v":0},{"$f":"SUM(目標ごとの達成度!AD26:AD41)","v":0},{"$f":"SUM(目標ごとの達成度!AE26:AE41)","v":0},{"$f":"SUM(目標ごとの達成度!AF26:AF41)","v":0},{"$f":"SUM(目標ごとの達成度!AG26:AG41)","v":0},{"$f":"SUM(目標ごとの達成度!AH26:AH41)","v":0},{"$f":"SUM(目標ごとの達成度!AI26:AI41)","v":0},{"$f":"SUM(目標ごとの達成度!AJ26:AJ41)","v":0},{"$f":"SUM(目標ごとの達成度!AK26:AK41)","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(目標ごとの達成度!N42:N51)","v":0},{"$f":"SUM(目標ごとの達成度!M42:M51)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P42:P51)","v":0},{"$f":"SUM(目標ごとの達成度!$P42:Q51)","v":0},{"$f":"SUM(目標ごとの達成度!$P42:R51)","v":0},{"$f":"SUM(目標ごとの達成度!$P42:S51)","v":0},{"$f":"SUM(目標ごとの達成度!$P42:T51)","v":0},{"$f":"SUM(目標ごとの達成度!$P42:U51)","v":0},{"$f":"SUM(目標ごとの達成度!$P42:V51)","v":0},{"$f":"SUM(目標ごとの達成度!$P42:W51)","v":0},{"$f":"SUM(目標ごとの達成度!$P42:X51)","v":0},{"$f":"SUM(目標ごとの達成度!$P42:Y51)","v":0},{"$f":"SUM(目標ごとの達成度!$P42:Z51)","v":0},{"$f":"SUM(目標ごとの達成度!$AA42:AA51)","v":0},{"$f":"SUM(目標ごとの達成度!AB42:AB51)","v":0},{"$f":"SUM(目標ごとの達成度!AC42:AC51)","v":0},{"$f":"SUM(目標ごとの達成度!AD42:AD51)","v":0},{"$f":"SUM(目標ごとの達成度!AE42:AE51)","v":0},{"$f":"SUM(目標ごとの達成度!AF42:AF51)","v":0},{"$f":"SUM(目標ごとの達成度!AG42:AG51)","v":0},{"$f":"SUM(目標ごとの達成度!AH42:AH51)","v":0},{"$f":"SUM(目標ごとの達成度!AI42:AI51)","v":0},{"$f":"SUM(目標ごとの達成度!AJ42:AJ51)","v":0},{"$f":"SUM(目標ごとの達成度!AK42:AK51)","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(目標ごとの達成度!N52:N60)","v":0},{"$f":"SUM(目標ごとの達成度!M52:M60)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P52:P60)","v":0},{"$f":"SUM(目標ごとの達成度!$P52:Q60)","v":0},{"$f":"SUM(目標ごとの達成度!$P52:R60)","v":0},{"$f":"SUM(目標ごとの達成度!$P52:S60)","v":0},{"$f":"SUM(目標ごとの達成度!$P52:T60)","v":0},{"$f":"SUM(目標ごとの達成度!$P52:U60)","v":0},{"$f":"SUM(目標ごとの達成度!$P52:V60)","v":0},{"$f":"SUM(目標ごとの達成度!$P52:W60)","v":0},{"$f":"SUM(目標ごとの達成度!$P52:X60)","v":0},{"$f":"SUM(目標ごとの達成度!$P52:Y60)","v":0},{"$f":"SUM(目標ごとの達成度!$P52:Z60)","v":0},{"$f":"SUM(目標ごとの達成度!$AA52:AA60)","v":0},{"$f":"SUM(目標ごとの達成度!AB52:AB60)","v":0},{"$f":"SUM(目標ごとの達成度!AC52:AC60)","v":0},{"$f":"SUM(目標ごとの達成度!AD52:AD60)","v":0},{"$f":"SUM(目標ごとの達成度!AE52:AE60)","v":0},{"$f":"SUM(目標ごとの達成度!AF52:AF60)","v":0},{"$f":"SUM(目標ごとの達成度!AG52:AG60)","v":0},{"$f":"SUM(目標ごとの達成度!AH52:AH60)","v":0},{"$f":"SUM(目標ごとの達成度!AI52:AI60)","v":0},{"$f":"SUM(目標ごとの達成度!AJ52:AJ60)","v":0},{"$f":"SUM(目標ごとの達成度!AK52:AK60)","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(目標ごとの達成度!N61:N66)","v":0},{"$f":"SUM(目標ごとの達成度!M61:M66)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P61:P66)","v":0},{"$f":"SUM(目標ごとの達成度!$P61:Q66)","v":0},{"$f":"SUM(目標ごとの達成度!$P61:R66)","v":0},{"$f":"SUM(目標ごとの達成度!$P61:S66)","v":0},{"$f":"SUM(目標ごとの達成度!$P61:T66)","v":0},{"$f":"SUM(目標ごとの達成度!$P61:U66)","v":0},{"$f":"SUM(目標ごとの達成度!$P61:V66)","v":0},{"$f":"SUM(目標ごとの達成度!$P61:W66)","v":0},{"$f":"SUM(目標ごとの達成度!$P61:X66)","v":0},{"$f":"SUM(目標ごとの達成度!$P61:Y66)","v":0},{"$f":"SUM(目標ごとの達成度!$P61:Z66)","v":0},{"$f":"SUM(目標ごとの達成度!$AA61:AA66)","v":0},{"$f":"SUM(目標ごとの達成度!AB61:AB66)","v":0},{"$f":"SUM(目標ごとの達成度!AC61:AC66)","v":0},{"$f":"SUM(目標ごとの達成度!AD61:AD66)","v":0},{"$f":"SUM(目標ごとの達成度!AE61:AE66)","v":0},{"$f":"SUM(目標ごとの達成度!AF61:AF66)","v":0},{"$f":"SUM(目標ごとの達成度!AG61:AG66)","v":0},{"$f":"SUM(目標ごとの達成度!AH61:AH66)","v":0},{"$f":"SUM(目標ごとの達成度!AI61:AI66)","v":0},{"$f":"SUM(目標ごとの達成度!AJ61:AJ66)","v":0},{"$f":"SUM(目標ごとの達成度!AK61: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:N71)","v":0},{"$f":"SUM(目標ごとの達成度!M67:M71)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P67:P71)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:Q71)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:R71)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:S71)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:T71)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:U71)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:V71)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:W71)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:X71)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:Y71)","v":0},{"$f":"SUM(目標ごとの達成度!$P67:Z71)","v":0},{"$f":"SUM(目標ごとの達成度!$AA67:AA71)","v":0},{"$f":"SUM(目標ごとの達成度!AB67:AB71)","v":0},{"$f":"SUM(目標ごとの達成度!AC67:AC71)","v":0},{"$f":"SUM(目標ごとの達成度!AD67:AD71)","v":0},{"$f":"SUM(目標ごとの達成度!AE67:AE71)","v":0},{"$f":"SUM(目標ごとの達成度!AF67:AF71)","v":0},{"$f":"SUM(目標ごとの達成度!AG67:AG71)","v":0},{"$f":"SUM(目標ごとの達成度!AH67:AH71)","v":0},{"$f":"SUM(目標ごとの達成度!AI67:AI71)","v":0},{"$f":"SUM(目標ごとの達成度!AJ67:AJ71)","v":0},{"$f":"SUM(目標ごとの達成度!AK67:AK71)","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(目標ごとの達成度!N72:N86)","v":0},{"$f":"SUM(目標ごとの達成度!M72:M86)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P72:P86)","v":0},{"$f":"SUM(目標ごとの達成度!$P72:Q86)","v":0},{"$f":"SUM(目標ごとの達成度!$P72:R86)","v":0},{"$f":"SUM(目標ごとの達成度!$P72:S86)","v":0},{"$f":"SUM(目標ごとの達成度!$P72:T86)","v":0},{"$f":"SUM(目標ごとの達成度!$P72:U86)","v":0},{"$f":"SUM(目標ごとの達成度!$P72:V86)","v":0},{"$f":"SUM(目標ごとの達成度!$P72:W86)","v":0},{"$f":"SUM(目標ごとの達成度!$P72:X86)","v":0},{"$f":"SUM(目標ごとの達成度!$P72:Y86)","v":0},{"$f":"SUM(目標ごとの達成度!$P72:Z86)","v":0},{"$f":"SUM(目標ごとの達成度!$AA72:AA86)","v":0},{"$f":"SUM(目標ごとの達成度!AB72:AB86)","v":0},{"$f":"SUM(目標ごとの達成度!AC72:AC86)","v":0},{"$f":"SUM(目標ごとの達成度!AD72:AD86)","v":0},{"$f":"SUM(目標ごとの達成度!AE72:AE86)","v":0},{"$f":"SUM(目標ごとの達成度!AF72:AF86)","v":0},{"$f":"SUM(目標ごとの達成度!AG72:AG86)","v":0},{"$f":"SUM(目標ごとの達成度!AH72:AH86)","v":0},{"$f":"SUM(目標ごとの達成度!AI72:AI86)","v":0},{"$f":"SUM(目標ごとの達成度!AJ72:AJ86)","v":0},{"$f":"SUM(目標ごとの達成度!AK72:AK86)","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(目標ごとの達成度!N87:N92)","v":0},{"$f":"SUM(目標ごとの達成度!M87:M92)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(目標ごとの達成度!$P87:P92)","v":0},{"$f":"SUM(目標ごとの達成度!$P87:Q92)","v":0},{"$f":"SUM(目標ごとの達成度!$P87:R92)","v":0},{"$f":"SUM(目標ごとの達成度!$P87:S92)","v":0},{"$f":"SUM(目標ごとの達成度!$P87:T92)","v":0},{"$f":"SUM(目標ごとの達成度!$P87:U92)","v":0},{"$f":"SUM(目標ごとの達成度!$P87:V92)","v":0},{"$f":"SUM(目標ごとの達成度!$P87:W92)","v":0},{"$f":"SUM(目標ごとの達成度!$P87:X92)","v":0},{"$f":"SUM(目標ごとの達成度!$P87:Y92)","v":0},{"$f":"SUM(目標ごとの達成度!$P87:Z92)","v":0},{"$f":"SUM(目標ごとの達成度!$AA87:AA92)","v":0},{"$f":"SUM(目標ごとの達成度!AB87:AB92)","v":0},{"$f":"SUM(目標ごとの達成度!AC87:AC92)","v":0},{"$f":"SUM(目標ごとの達成度!AD87:AD92)","v":0},{"$f":"SUM(目標ごとの達成度!AE87:AE92)","v":0},{"$f":"SUM(目標ごとの達成度!AF87:AF92)","v":0},{"$f":"SUM(目標ごとの達成度!AG87:AG92)","v":0},{"$f":"SUM(目標ごとの達成度!AH87:AH92)","v":0},{"$f":"SUM(目標ごとの達成度!AI87:AI92)","v":0},{"$f":"SUM(目標ごとの達成度!AJ87:AJ92)","v":0},{"$f":"SUM(目標ごとの達成度!AK87:AK92)","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)"]