{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["CrossList","Korean Master thesis","Korean Master nonthesis","Int Master thesis","Int Master nonthe"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"CrossList","index":0,"n_rows":315,"n_cols":14,"rows_kept":315,"cut":false,"hidden":false,"merged":[[0,3,0,7],[0,8,0,11]]}
["Course","Course Name","Course Name","MA",{"$nulls":4},"PhD"]
["Code","(Korean)","(English)","International\nCommerce","International\nPeace & Security","International Development\n& Cooperation","Area\nStudies","Korean\nStudies","International\nCommerce","International\nRelations","International\nDevelopment","Korean\nStudies"]
["IAC701","개별연구I","INDEPENDENT STUDY I"]
["IAC702","개별연구II","INDEPENDENT STUDY II"]
["IAC703","개별연구I","INDEPENDENT STUDY I"]
["IAC704","개별연구II","INDEPENDENT STUDY II"]
["IAC711","고급국제개발협력세미나I","ADVANCED SEMINAR IN INTERNATIONAL DEVELOPMENT AND COOPERATION I"]
["IAC712","고급국제개발협력세미나II","ADVANCED SEMINAR IN INTERNATIONAL DEVELOPMENT AND COOPERATION II"]
["IAC713","고급국제개발협력세미나III","ADVANCED SEMINAR IN INTERNATIONAL DEVELOPMENT AND COOPERATION III"]
["IAC714","고급국제개발협력세미나IV","ADVANCED SEMINAR IN INTERNATIONAL DEVELOPMENT AND COOPERATION IV"]
["IAC721","고급국제경영세미나I","ADVANCED SEMINAR IN INTERNATIONAL BUSINESS I"]
["IAC731","고급국제금융세미나I","ADVANCED SEMINAR IN INTERNATIONAL FINANCE I"]
["IAC732","고급국제금융세미나II","ADVANCED SEMINAR IN INTERNATIONAL FINANCE II"]
["IAC735","고급재정정책세미나I","ADVANCED SEMIINAR ON FISCAL POLICYI"]
["IAC736","고급재정정책세미나II","ADVANCED SEMINAR ON FISCAL POLICY  II"]
["IAC738","고급조세연구세미나I","ADVANCED SEMINAR ON TAX STUDY"]
["IAC739","고급조세연구세미나Ⅱ","ADVANCED SEMINAR ON TAX STUDY II"]
["IAC741","고급국제통상세미나I","ADVANCED SEMINAR IN INTERNATIONAL COMMERCE I"]
["IAC742","고급국제통상세미나II","ADVANCED SEMINAR IN INTERNATIONAL COMMERCE II"]
["IAC743","고급국제통상세미나Ⅲ","ADVANCED SEMINAR IN INTERNATIONAL COMMERCEⅢ"]
["IAC751","고급국제평화안보세미나I","ADVANCED SEMINAR IN INTERNATIONAL PEACE AND SECURITY I"]
["IAC752","고급국제평화안보세미나II","ADVANCED SEMINAR IN INTERNATIONAL PEACE AND SECURITY II"]
["IAC753","고급국제평화안보세미나III","ADVANCED SEMINAR IN INTERNATIONAL PEACE AND SECURITY III"]
["IAC754","고급국제평화안보세미나IV","ADVANCED SEMINAR IN INTERNATIONAL PEACE AND SECURITY IV"]
["IAC755","고급국제경영세미나II","ADVANCED SEMINAR IN INTERNATIONAL BUSINESS II"]
["IAC761","고급동아시아연구세미나I","ADVANCED SEMINAR IN EAST ASIAN STUDIES I"]
["IAC771","고급세계화와쟁점세미나I","ADVANCED SEMINAR ON GLOBALIZATION AND GLOBAL PROBLEMS I"]
["IAC781","고급유럽연구세미나I","ADVANCED SEMINAR IN EUROPEAN STUDIES I"]
["IAC782","고급유럽연구세미나II","ADVANCED SEMINAR IN EUROPEAN STUDIES II"]
["IAC783","고급유럽연구세미나III","ADVANCED SEMINAR IN EUROPEAN STUDIES III"]
["IAC791","고급전자통상세미나I","ADVANCED SEMINAR IN E-COMMERCE I"]
["IAC801","고급연구방법론I","ADVANCED RESEARCH METHODS I"]
["IAC802","고급연구방법론II","ADVANCED RESEARCH METHODS II"]
["IAC901","고급한국학세미나I","ADVANCE SEMINAR IN KOREAN STUDIES I"]
["IAS110","동아시아경제","THE EAST ASIAN ECONOMY","IIC",null,"IDC","IAS","IKS","IIC",null,"ID","Korean Studies"]
["IAS111","지역학특강I","SPECIAL TOPICS IN REGIONAL STUDIES I",null,null,null,"IAS"]
["IAS112","지역학특강II","SPECIAL TOPICS IN REGIONAL STUDIES II",null,null,null,"IAS"]
["IAS113","지역학특강III","SPECIAL TOPICS IN REGIONAL STUDIES III",null,null,null,"IAS"]
["IAS114","지역학특강IV","SPECIAL TOPICS IN REGIONAL STUDIES IV",null,null,null,"IAS"]
["IAS115","동아시아국제관계","INTERNATIONAL RELATIONS IN EAST ASIA",null,"IPS",null,"IAS","IKS",null,"IR",null,"Korean Studies"]
["IAS116","동아시아무역및투자환경","EAST ASIAN TRADE AND INVESTMENT: A FOCUS ON ASEAN+3","IIC",null,"IDC","IAS","IKS","IIC",null,"ID","Korean Studies"]
["IAS117","동아시아환경과개발","ENVIRONMENT AND DEVELOPMENT OF EAST ASIA",null,null,"IDC","IAS","IKS",null,null,"ID","Korean Studies"]
["IAS118","APEC연구","KOREA & APEC","IIC","IPS","IDC","IAS","IKS","IIC","IR","ID","Korean Studies"]
["IAS119","ASEAN연구","ASEAN AND SOUTHEAST ASIA",null,null,"IDC","IAS",null,null,"IR","ID"]
["IAS120","미국경제","THE U.S. ECONOMY","IIC",null,"IDC","IAS",null,"IIC",null,"ID"]
["IAS121","미국의대외경제사례연구","CASE STUDIES IN US FOREIGN ECONOMIC RELATIONS","IIC","IPS",null,"IAS",null,"IIC","IR"]
["IAS122","미국의외교정책","THE U.S. FOREIGN POLICY",null,"IPS",null,"IAS",null,null,"IR"]
["IAS123","미국의주요경제정책","ECONOMIC POLICIES OF THE U.S.","IIC",null,null,"IAS",null,"IIC"]
["IAS124","북미무역및투자환경","NORTH AMERICAN TRADE & INVESTMENT","IIC",null,null,"IAS",null,"IIC"]
["IAS125","미-중경쟁","US-CHINA RIVALRY",null,"IPS",null,"IAS",null,"IIC","IR"]
["IAS130","비교지역경제","COMPARATIVE REGIONAL ECONOMY","IIC",null,null,"IAS",null,"IIC",null,"ID"]
["IAS210","유럽경제","EU ECONOMY","IIC",null,null,"IAS",null,"IIC"]
["IAS211","유럽연구특강I","SPECIAL TOPICS IN EU STUDIES I",null,null,null,"IAS"]
["IAS212","유럽연구특강II","SPECIAL TOPICS IN EU STUDIES II",null,null,null,"IAS"]
["IAS215","유럽무역및투자환경","TRADE AND INVESTMENT IN THE EU","IIC",null,null,"IAS",null,"IIC"]
["IAS216","유럽연합국제관계","INTER-STATES RELATIONS OF THE EU",null,"IPS",null,"IAS",null,null,"IR"]
["IAS217","유럽연합법","EU LAW","IIC","IPS",null,"IAS",null,"IIC","IR"]
["IAS218","유럽연합정치","POLITICS OF THE EUROPEAN UNION",null,"IPS",null,"IAS",null,null,"IR"]
["IAS219","유럽의사회와문화","EUROPEAN SOCIETY AND CULTURE",null,"IPS",null,"IAS",null,null,"IR"]
["IAS220","유럽한국관계","KOREAN-EU RELATIONS",null,"IPS",null,"IAS","IKS",null,"IR",null,"Korean Studies"]
["IAS310","일본경제","THE JAPANESE ECONOMY","IIC",null,null,"IAS",null,"IIC"]
["IAS311","일본연구특강I","SPECIAL TOPICS IN JAPANESE STUDIES I",null,null,null,"IAS"]
["IAS312","일본연구특강II","SPECIAL TOPICS IN JAPANESE STUDIES II",null,null,null,"IAS"]
["IAS315","일본기업","JAPANESE FIRMS AND THEIR CORPORATE STRATEGIES","IIC",null,null,"IAS",null,"IIC"]
["IAS316","일본의대외정책","JAPANESE FOREIGN POLICY",null,"IPS",null,"IAS",null,null,"IR"]
["IAS317","일본의사회와문화","JAPANESE SOCIETY AND CULTURE",null,null,null,"IAS"]
["IAS318","일본의산업정책","INDUSTRIAL POLICY OF JAPAN","IIC",null,null,"IAS",null,"IIC"]
["IAS319","일본정치","THE JAPANESE POLITICS",null,null,null,"IAS"]
["IAS410","중국경제","THE CHINESE ECONOMY","IIC",null,"IDC","IAS",null,"IIC",null,"ID"]
["IAS411","중국연구특강I","SPECIAL TOPICS IN CHINESE STUDIES I",null,null,null,"IAS"]
["IAS412","중국연구특강II","SPECIAL TOPICS IN CHINESE STUDIES II",null,null,null,"IAS"]
["IAS415","중국의사회와문화","CHINESE SOCIETY AND CULTURE",null,null,null,"IAS"]
["IAS416","중국의외교정책","CHINESE FOREIGN POLICY",null,"IPS","IDC","IAS",null,null,"IR","ID"]
["IAS417","중국정치","THE CHINESE POLITICS",null,"IPS","IDC","IAS",null,null,"IR","ID"]
["IAS418","중국정치경제","CHINESE POLITICAL ECONOMY",null,"IPS","IDC","IAS",null,null,"IR","ID"]
["IAS419","중국환경및개발","ENVIRONMENT AND DEVELOPMENT IN CHINA",null,"IPS","IDC","IAS",null,null,"IR","ID"]
["IAS511","러시아연구특강I","SPECIAL TOPICS IN RUSSIAN STUDIES I",null,"IPS",null,"IAS",null,null,"IR"]
["IAS512","러시아연구특강II","SPECIAL TOPICS IN RUSSIAN STUDIES II",null,"IPS",null,"IAS",null,null,"IR"]
["IAS515","러시아의외교정책","RUSSIAN FOREIGN POLICY",null,"IPS","IDC","IAS",null,null,"IR","ID"]
["IAS610","동아시아의전쟁과평화","EAST ASIA IN WAR AND PEACE",null,"IPS",null,"IAS","IKS",null,"IR",null,"Korean Studies"]
["IAS611","동남아경제","SOUTHEAST ASIAN ECONOMY","IIC",null,"IDC","IAS",null,"IIC",null,"ID"]
["IAS612","동남아정치","POLITICS OF SOUTHEAST ASIA",null,"IPS","IDC","IAS",null,null,"IR","ID"]
["IAS613","동남아지역연구특강I","SPECIAL TOPICS IN  SOUTHEAST ASIAN STUDIES I",null,null,null,"IAS",null,null,"IR","ID"]
["IAS614","동남아지역연구특강II","SPECIAL TOPICS IN  SOUTHEAST ASIAN STUDIES II",null,null,null,"IAS",null,null,"IR","ID"]
["IAS615","동남아지역현안","CURRENT ISSUES IN SOUTHEAST ASIAN STUDIES",null,null,null,"IAS",null,null,"IR","ID"]
["IAS710","아프리카의이해","UNDERSTANDING AFRICA",null,"IPS","IDC","IAS",null,null,"IR","ID"]
["IAS711","아프리카경제","AFRICAN ECONOMY","IIC",null,"IDC","IAS",null,"IIC",null,"ID"]
["IAS810","세계속의이슬람","ISLAM IN THE WORLD",null,"IPS","IDC","IAS",null,null,"IR","ID"]
["IAS811","이슬람세계의경제와재정","ECONOMY AND FINANCE IN THE ISLAMIC WORLD"]
["IDC110","국제개발원조:제도및정책","INTERNATIONAL DEVELOPMENT ASSISTANCE: INSTITUTIONS AND POLICIES",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC111","국제개발협력특강I","SPECIAL TOPICS IN INTERNATIONAL DEVELOPMENT AND COOPERATION I",null,null,"IDC",{"$nulls":4},"ID"]
["IDC112","국제개발협력특강II","SPECIAL TOPICS IN INTERNATIONAL DEVELOPMENT AND COOPERATION II",null,null,"IDC",{"$nulls":4},"ID"]
["IDC113","국제개발협력특강III","SPECIAL TOPICS IN INTERNATIONAL DEVELOPMENT AND COOPERATION III",null,null,"IDC",{"$nulls":4},"ID"]
["IDC114","국제개발협력특강IV","SPECIAL TOPICS IN INTERNATIONAL DEVELOPMENT AND COOPERATION IV",null,null,"IDC",{"$nulls":4},"ID"]
["IDC115","국제기구","INTERNATIONAL ORGANIZATIONS","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IDC116","국제기구사례연구","CASE ANALYSIS OF INTERNATIONAL ORGANIZATIONS","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IDC117","글로벌거버넌스세미나","SEMINAR ON GLOBAL GOVERNANCE",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC118","비교사회","COMPARATIVE SOCIETIES",null,null,"IDC",null,"IKS",null,null,"ID","Korean Studies"]
["IDC119","지속가능발전과국제기구","SUSTAINABLE DEVELOPMENT AND INTERNATIONAL ORGANIZATIONS","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IDC120","NGO와세계시민사회","NGOS AND GLOBAL CIVIL SOCIETY",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC121","세계화의동학","DYNAMICS OF GLOBALIZATION","IIC","IPS","IDC",null,"IKS","IIC","IR","ID","Korean Studies"]
["IDC122","정책평가","POLICY EVALUATION","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IDC123","젠더와개발","GENDER AND DEVELOPMENT",null,"IPS","IDC",null,"IKS",null,null,"ID","Korean Studies"]
["IDC130","과학기술과외교","SCIENCE, TECHNOLOGY, AND DIPLOMACY","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IDC131","AI와국제관계","AI AND INTERNATIONAL RELATIONS"]
["IDC199","도시계획관리론","CITY PLANING AND MANAGEMENT",null,null,"IDC",{"$nulls":4},"ID"]
["IDC210","에너지정치경제","POLITICAL ECONOMY ON ENERGY","IIC","IPS","IDC","IAS",null,"IIC","IR","ID"]
["IDC211","에너지특강I","SPECIAL TOPICS IN ENERGY I",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC212","에너지특강II","SPECIAL TOPICS IN ENERGY II",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC215","자원관리","RESOURCE MANAGEMENT",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC216","게임이론과갈등관리","GAME THEORY AND CONFLICT MANAGEMENT","IIC","IPS","IDC","IAS",null,"IIC","IR","ID"]
["IDC217","사회불평등과복지정책","SOCIAL INEQUALITY AND WELFARE POLICIES","IIC",null,"IDC","IAS",null,"IIC",null,"ID"]
["IDC220","개발도상국의교육개발","EDUCATIONAL DEVELOPMENT IN DEVELOPING COUNTRIES","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IDC221","지속가능발전교육","EDUCATION FOR SUSTAINABLE DEVELOPMENT",null,null,"IDC",{"$nulls":4},"ID"]
["IDC290","환경관리론","ENVIRONMENTAL MANAGEMENT",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC291","도시개발론","URBAN DEVELOPMENT",null,null,"IDC",{"$nulls":4},"ID"]
["IDC292","교통관리론","TRANSPORTATION MANAGEMENT",null,null,"IDC",{"$nulls":4},"ID"]
["IDC293","도시재정론","PUBLIC FINANCE AND BUDGETING","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IDC294","행정조직과정책론","PUBLIC POLICY AND ORGANIZATION","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IDC295","조세정책","TAX POLICY","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IDC296","공공재정","PUBLIC FINANCE","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IDC297","조세정책과경제개발","TAX POLICY AND ECONOMIC DEVELOPMENT","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IDC298","조세이론","TAX THEORY","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IDC299","국제조세론및동향","INTERNATIONAL TAX THEORY AND TRENDS","IIC",{"$nulls":4},"IIC"]
["IDC310","개발과반부패","CORRUPTION IN DEVELOPING WORLD",null,null,"IDC",{"$nulls":4},"ID"]
["IDC311","국제인권특강I","SPECIAL TOPICS IN HUMAN RIGHTS I",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC312","국제인권특강II","SPECIAL TOPICS IN HUMAN RIGHTS II",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC315","국제인권","HUMAN RIGHTS IN GLOBAL AND REGIONAL CONTEXT",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC316","국제인권기구","INTERNATIONAL HUMAN RIGHTS ORGANIZATIONS",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC317","민주화와인권","DEMOCRACY AND HUMAN RIGHTS",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC318","기업과인권","BUSINESS AND HUMAN RIGHTS","IIC","IPS","IDC",null,null,null,"IR","ID"]
["IDC319","UN인권보호체제:규범과실제","UN HUMAN RIGHTS PROTECTION MECHANISM: NORMS AND PRACTICES",null,"IPS","IDC","IAS",null,null,"IR","ID"]
["IDC321","공공경제학Ⅰ","THE ECONOMICS OF PUBLIC POLICY I","IIC",{"$nulls":4},"IIC"]
["IDC390","도시행정론","MUNICIPAL ADMINISTRATION",null,null,"IDC",{"$nulls":4},"ID"]
["IDC391","전자정부론","E-GOVERNMENT",null,"IPS","IDC",{"$nulls":4},"ID"]
["IDC410","국제환경자원의법정책","LAW AND POLICY ON GLOBAL ENVIRONMENT AND RESOURCES","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IDC411","국제환경특강I","SPECIAL TOPICS IN GLOBAL ENVIRONMENT I",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC412","국제환경특강II","SPECIAL TOPICS IN GLOBAL ENVIRONMENT II",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC415","기후변화법과정치","LAW AND POLITICS OF CLIMATE CHANGE",null,"IPS","IDC",null,null,null,"IR","ID"]
["IDC416","환경과무역세미나","SEMINAR ON TRADE AND ENVIRONMENT","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IDC510","경제개발을위한다자및지역협력","MULTILATERAL AND REGIONAL COOPERATION FOR ECONOMIC DEVELOPMENT","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IDC511","경제개발","ECONOMIC DEVELOPMENT","IIC",null,"IDC","IAS","IKS","IIC",null,"ID","Korean Studies"]
["IDC512","경제성장개발및세계화","ECONOMIC GROWTH, DEVELOPMENT & GLOBALIZATION","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IDC513","국제개발기구","INTERNATIONAL DEVELOPMENT ORGANIZATIONS","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IDC514","국제개발입문","INTRODUCTION TO INTERNATIONAL DEVELOPMENT","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IDC515","국제개발협력사업","INTERNATIONAL DEVELOPMENT PROGRAMS AND PROJECTS",null,null,"IDC",{"$nulls":4},"ID"]
["IDC516","다국적기업과개발","MNCS IN INTERNATIONAL DEVELOPMENT","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IDC517","국제개발현장조사","INTERNATIONAL DEVELOPMENT FIELD RESEARCH DESIGN",null,null,"IDC",{"$nulls":4},"ID"]
["IDC518","국제개발특강I","SPECIAL TOPICS IN INTERNATIONAL DEVELOPMENT I",null,null,"IDC",{"$nulls":4},"ID"]
["IDC519","국제개발특강II","SPECIAL TOPICS IN INTERNATIONAL DEVELOPMENT II",null,null,"IDC",{"$nulls":4},"ID",null,null,"IIC"]
["IDC520","불확실성과위험성에대한계획","PLANNING FOR UNCERTAINTY AND RISK",null,null,"IDC",{"$nulls":4},"ID",null,null,"IPS"]
["IDC521","국제개발과위기관리","MAINSTREAMING RISK MANAGEMENT IN DEVELOPMENT","IIC",null,"IDC",null,null,"IIC",null,"ID",null,null,"IDC"]
["IDC522","물과국제개발","WATER AND INTERNATIONAL DEVELOPMENT","IIC","IPS","IDC",null,null,"IIC",null,"ID",null,null,"IAS"]
["IIC110","관리회계","MANAGEMENT ACCOUNTING","IIC",{"$nulls":4},"IIC",{"$nulls":4},"IKS"]
["IIC111","국제조직관리","INTERNATIONAL ORGANIZATION MANAGEMENT","IIC",{"$nulls":4},"IIC",{"$nulls":4},"IAS(Int’l Students only)"]
["IIC112","글로벌리더쉽","GLOBAL LEADERSHIP","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IIC113","글로벌마케팅","GLOBAL MARKETING","IIC",{"$nulls":4},"IIC"]
["IIC114","기업경영분석","CORPORATE ANALYSIS","IIC",{"$nulls":4},"IIC"]
["IIC115","마케팅관리","MARKETING MANAGEMENT","IIC",{"$nulls":4},"IIC"]
["IIC116","재무회계","FINANCIAL ACCOUNTING","IIC",{"$nulls":4},"IIC"]
["IIC117","전략경영","STRATEGIC MANAGEMENT","IIC",{"$nulls":4},"IIC"]
["IIC118","조직연구와비교경영","ORGANIZATIONAL STUDIES FROM THE COMPARATIVE MANAGEMENT PERSPECTIVE","IIC",{"$nulls":4},"IIC"]
["IIC119","지식재산권","INTELLECTUAL PROPERTY RIGHTS","IIC",{"$nulls":4},"IIC"]
["IIC121","경제학입문","INTRODUCTION TO ECONOMICS","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IIC210","국제금융","INTERNATIONAL FINANCE","IIC",{"$nulls":4},"IIC"]
["IIC211","국제금융특강I","SPECIAL TOPICS IN INTERNATIONAL FINANCE I","IIC",{"$nulls":4},"IIC"]
["IIC212","국제금융특강II","SPECIAL TOPICS IN INTERNATIONAL FINANCE II","IIC",{"$nulls":4},"IIC"]
["IIC213","환경경제","ENVIRONMENTAL ECONOMICS","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IIC215","국제무역과투자","INTERNATIONAL TRADE AND INVESTMENT","IIC",{"$nulls":4},"IIC"]
["IIC216","국제재무관리","GLOBAL CORPORATE FINANCIAL MANAGEMENT","IIC",{"$nulls":4},"IIC"]
["IIC217","다국적기업및해외투자","MNCS AND FOREIGN DIRECT INVESTMENT","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IIC218","세계각국의금융시장","INTERNATIONAL FINANCIAL MARKET","IIC",{"$nulls":4},"IIC"]
["IIC219","파생금융상품","FINANCIAL DERIVATIVES","IIC",{"$nulls":4},"IIC"]
["IIC220","해외투자와국제협력","OVERSEAS INVESTMENT & INTERNATIONAL ECONOMIC COOPERATI","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IIC241","미시경제학","MICROECONOMICS","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IIC242","거시경제","MACROECONOMICS","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IIC310","전자통상학입문","INTRODUCTION TO E-COMMERCE","IIC",{"$nulls":4},"IIC"]
["IIC311","전자상거래특강I","SPECIAL TOPICS IN E-COMMERCE I","IIC",{"$nulls":4},"IIC"]
["IIC314","정보사회마케팅","MARKETING IN THE INFORMATION SOCIETY","IIC",{"$nulls":4},"IIC"]
["IIC315","전자상거래시장이론","E-MARKET THEORY","IIC",{"$nulls":4},"IIC"]
["IIC316","전자통상법","E-COMMERCE LAW","IIC",{"$nulls":4},"IIC"]
["IIC317","디지털경제","DIGITAL ECONOMICS","IIC",null,"IDC",null,null,"IIC"]
["IIC318","정보경제","INFORMATION ECONOMY","IIC",{"$nulls":4},"IIC"]
["IIC319","정보사회","INFORMATION SOCIETY","IIC",{"$nulls":4},"IIC"]
["IIC320","정보통신산업정책","IT INDUSTRY POLICY","IIC",{"$nulls":4},"IIC"]
["IIC321","컴퓨터와전자상거래","COMPUTER & E-COMMERCE","IIC",{"$nulls":4},"IIC"]
["IIC322","e-비즈니스 경영","MANAGEMENT IN E-BUSINESS","IIC",{"$nulls":4},"IIC"]
["IIC331","통상이슈및무역분쟁","TRADE ISSUES AND TRADE DISPUTES","IIC","IPS","IDC",null,null,"IIC"]
["IIC332","디지털통상세미나I","SEMINAR IN DIGITAL COMMERCEI","IIC",null,"IDC","IAS",null,"IIC",null,"ID"]
["IIC333","디지털통상정책및이슈","DIGITAL TRADE POLICY AND CURRENT ISSUES","IIC","IPS","IDC",null,null,"IIC"]
["IIC334","디지털통상세미나II","SEMINAR IN DIGITAL COMMERCE II","IIC",null,"IDC","IAS",null,"IIC",null,"ID"]
["IIC335","통상안보및분쟁","COMMERCE SECURITY AND DISPUTES","IIC","IPS","IDC",null,null,"IIC"]
["IIC336","디지털통상규범","DIGITAL COMMERCE NORMS","IIC","IPS","IDC",null,null,"IIC"]
["IIC410","경제통합이론및실제","THEORY AND PRACTICES OF ECONOMIC INTEGRATION","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IIC411","국제통상특강I","SPECIAL TOPICS IN INTERNATIONAL COMMERCE I","IIC",{"$nulls":4},"IIC"]
["IIC412","국제통상특강II","SPECIAL TOPICS IN INTERNATIONAL COMMERCE II","IIC",{"$nulls":4},"IIC"]
["IIC415","국제경제기구","INTERNATIONAL ECONOMIC ORGANIZATIONS","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IIC416","국제경제법","INTERNATIONAL ECONOMIC LAW","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IIC417","국제경제협력사례연구","CASE STUDIES IN INTERNATIONAL ECONOMIC COOPERATION","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IIC418","국제통상현안","CURRENT ISSUES IN INTERNATIONAL COMMERCE","IIC",{"$nulls":4},"IIC"]
["IIC419","산업조직","INDUSTRIAL ORGANIZATION","IIC",{"$nulls":4},"IIC"]
["IIC420","신통상현안세미나","SEMINAR IN NEW TRADE ISSUES","IIC",{"$nulls":4},"IIC"]
["IIC421","통상정책","INTERNATIONAL TRADE POLICY","IIC","IPS",null,null,null,"IIC","IR"]
["IIC423","국제통상의법적경제적이해","LEGAL AND ECONOMIC ANALYSIS OF INTERNATIONAL COMMERCE","IIC",{"$nulls":4},"IIC"]
["IIC424","한국의조세재정","KOREAN FINANCE AND TAX POLICY","IIC",null,"IDC","IAS(only for itnl' students)","IKS","IIC","IR","ID","Korean Studies"]
["IIC425","통상분쟁과협상정책","TRADE DISPUTE AND NEGOTIATION POLICY","IIC",null,"IDC","IAS(only for itnl' students)",null,"IIC","IR"]
["IIC430","정부회계","GOVERNMENT ACCOUNTING"]
["IIC431","예산현안","FINANCE AND BUDGET ISSUES","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IIC432","예산제도및정책","BUDGET SYSTEMS AND POLICY","IIC",null,"IDC",null,null,"IIC",null,"ID"]
["IKS110","한국정치","THE KOREAN POLITICS",null,null,null,"IAS(only for itnl' students)","IKS",null,null,null,"Korean Studies"]
["IKS111","한국정치특강I","SPECIAL TOPICS IN KOREAN POLITICS I",null,null,null,"IAS(only for itnl' students)","IKS",null,null,null,"Korean Studies"]
["IKS112","한국정치특강II","SPECIAL TOPICS IN KOREAN POLITICS II",null,null,null,"IAS(only for itnl' students)","IKS",null,null,null,"Korean Studies"]
["IKS115","한국의사회운동과정치변화","SOCIAL MOVEMENTS AND POLITICAL CHANGE IN KOREA",null,null,null,"IAS(only for itnl' students)","IKS",null,null,"ID","Korean Studies"]
["IKS116","불평등과한국정치","POLITICS AND INEQUALITY IN KOREA"]
["IKS121","섹슈얼리티와한국사회","SEXUALITY IN KOREA",null,null,null,"IAS(only for itnl' students)","IKS",null,null,null,"Korean Studies"]
["IKS122","한국사회의이주와인종","MIGRATION AND RACE IN KOREA",null,null,"IDC","IAS(only for itnl' students)","IKS",null,null,"ID","Korean Studies"]
["IKS210","한국경제","THE KOREAN ECONOMY","IIC",null,null,"IAS(only for itnl' students)","IKS","IIC",null,"ID","Korean Studies"]
["IKS211","한국경제특강I","SPECIAL TOPICS IN KOREAN ECONOMY I","IIC",null,"IDC","IAS","IKS","IIC","IR","ID","Korean Studies"]
["IKS212","한국경제특강II","SPECIAL TOPICS IN KOREAN ECONOMY II","IIC",null,"IDC","IAS(only for itnl' students)","IKS","IIC","IR","ID","Korean Studies"]
["IKS215","한국의국제정치경제","INTERNATIONAL POLITICAL ECONOMY OF KOREA",null,"IPS","IDC","IAS(only for itnl' students)","IKS",null,"IR","ID","Korean Studies"]
["IKS216","한국산업조직","INDUSTRIAL ORGANIZATION OF KOREA","IIC",null,"IDC","IAS(only for itnl' students)","IKS","IIC",null,"ID","Korean Studies"]
["IKS217","한국의금융제도","FINANCIAL SYSTEM OF KOREA","IIC",null,null,"IAS(only for itnl' students)","IKS","IIC",null,"ID","Korean Studies"]
["IKS218","한국의기업경영","DYNAMICS OF KOREAN MANAGEMENT","IIC",null,null,"IAS(only for itnl' students)","IKS","IIC",null,null,"Korean Studies"]
["IKS219","한국의무역과해외투자","FOREIGN TRADE AND INVESTMENT OF KOREA","IIC",null,"IDC","IAS(only for itnl' students)","IKS","IIC",null,null,"Korean Studies"]
["IKS220","한국의정부기업관계","GOVERNMENT-BUSINESS RELATIONS OF KOREA","IIC",null,null,"IAS(only for itnl' students)","IKS","IIC",null,null,"Korean Studies"]
["IKS221","한국의조세행정및전략","TAX ADMINISTRATION IN KOREA AND ITS ACHIEVEMENT","IIC",null,"IDC","IAS(only for itnl' students)","IKS","IIC",null,"ID","Korean Studies"]
["IKS222","한국의재정관리및예산편성","PUBLIC FINANCIAL MANAGEMENT","IIC",null,"IDC","IAS(only for itnl' students)","IKS","IIC",null,"ID","Korean Studies"]
["IKS223","한국의조세법","TAX LAW IN KOREA","IIC",null,"IDC","IAS(only for itnl' students)","IKS","IIC",null,"ID","Korean Studies"]
["IKS310","한국의문화","KOREAN CULTURE",null,null,null,"IAS(only for itnl' students)","IKS",null,null,null,"Korean Studies"]
["IKS311","한국의사회문화특강I","SPECIAL TOPICS IN KOREAN SOCIETY  AND CULTURE I",null,null,null,"IAS(only for itnl' students)","IKS",null,null,null,"Korean Studies"]
["IKS312","한국의사회문화특강II","SPECIAL TOPICS IN KOREAN SOCIETY AND CULTURE II",null,null,null,"IAS(only for itnl' students)","IKS",null,null,null,"Korean Studies"]
["IKS313","한국의사회문화특강III","SPECIAL TOPICS IN KOREAN SOCIETY AND CULTURE III",null,null,null,"IAS(only for itnl' students)","IKS",null,null,null,"Korean Studies"]
["IKS315","한국의기업문화","BUSINESS CULTURE OF KOREA","IIC",null,null,"IAS(only for itnl' students)","IKS","IIC",null,null,"Korean Studies"]
["IKS316","한국영화","KOREAN CINEMA IN A GLOBAL CONTEXT",{"$nulls":4},"IKS",null,null,null,"Korean Studies"]
["IKS317","한국예술사","HISTORY OF KOREAN ART",{"$nulls":4},"IKS",null,null,null,"Korean Studies"]
["IKS318","한국의미학","KOREAN AESTHETICS",{"$nulls":4},"IKS",null,null,null,"Korean Studies"]
["IKS319","한국의종교","RELIGION IN KOREA",null,null,null,"IAS(only for itnl' students)","IKS",null,null,null,"Korean Studies"]
["IKS320","한국의사회변화","SOCIAL CHANGE IN KOREA",null,null,"IDC","IAS(only for itnl' students)","IKS",null,null,"ID","Korean Studies"]
["IKS350","북한사회","NORTH KOREA","IIC","IPS","IDC","IAS(only for itnl' students)","IKS","IIC","IR","ID","Korean Studies"]
["IKS410","한국의법제도","THE KOREAN LEGAL SYSTEM",null,null,"IDC","IAS(only for itnl' students)","IKS",null,"IR","ID","Korean Studies"]
["IKS411","한러관계","KOREAN-RUSSIAN RELATIONS",null,"IPS",null,"IAS","IKS",null,"IR",null,"Korean Studies"]
["IKS412","한미관계","KOREA-U.S. RELATIONS",null,"IPS",null,"IAS(only for itnl' students)","IKS",null,"IR",null,"Korean Studies"]
["IKS413","한일관계","KOREAN-JAPANESE RELATIONS",null,"IPS",null,"IAS","IKS",null,"IR",null,"Korean Studies"]
["IKS414","한인이민사","KOREAN DIASPORA",null,"IPS",null,null,"IKS",null,"IR",null,"Korean Studies"]
["IKS415","한국과세계화","KOREA IN THE ERA OF GLOBALIZATION",null,"IPS",null,"IAS(only for itnl' students)","IKS",null,"IR",null,"Korean Studies"]
["IKS420","한국어고급강독","ADVANCED READINGS IN KOREAN"]
["IKS421","한국어강독","READINGS IN KOREAN"]
["IPS110","국가경쟁력세미나","NATIONAL COMPETITIVENESS SEMINAR","IIC","IPS","IDC",null,null,"IIC","IR"]
["IPS111","국제평화안보특강I","SPECIAL TOPICS IN INTERNATIONAL PEACE AND SECURTY I",null,"IPS",{"$nulls":4},"IR"]
["IPS112","국제평화안보특강II","SPECIAL TOPICS IN INTERNATIONAL PEACE AND SECURTY II",null,"IPS",{"$nulls":4},"IR"]
["IPS115","국제관계사","HISTORY OF INTERNATIONAL RELATIONS",null,"IPS",{"$nulls":4},"IR"]
["IPS116","국제관계이론세미나","SEMINAR IN INTERNATIONAL RELATIONS",null,"IPS",{"$nulls":4},"IR"]
["IPS117","국제관계주요쟁점","ISSUES IN WORLD POLITICS","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IPS118","국제정치경제","INTERNATIONAL POLITICAL ECONOMY","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IPS119","국제정치사례분석","CASE STUDIES OF INTERNATIONAL RELATIONS",null,"IPS",{"$nulls":4},"IR"]
["IPS120","세계화의주요쟁점","GLOBALIZATION AND GLOBAL ISSUES","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IPS210","게임이론","GAME THEORY","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IPS211","국제평화","APPROACHES TO INTERNATIONAL PEACE",null,"IPS","IDC",null,null,null,"IR","ID"]
["IPS212","국제협상","INTERNATIONAL NEGOTIATIONS","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IPS213","국제회의외교","INTERNATIONAL CONFERENCE DIPLOMACY",null,"IPS","IDC",null,null,null,"IR","ID"]
["IPS214","여론과외교정책","MASS MEDIA, PUBLIC OPINION AND FOREIGN POLICY",null,"IPS","IDC","IAS","IKS",null,"IR","ID","Korean Studies"]
["IPS215","평화창출과평화유지","PEACE-BUILDING AND PEACE-KEEPING",null,"IPS","IDC",null,null,null,"IR","ID"]
["IPS216","한반도평화와인간안보","PEACE AND HUMAN SECURITY IN THE KOREAN PENINSULA",null,"IPS","IDC","IAS(only for itnl' students)","IKS",null,"IR","ID","Korean Studies"]
["IPS217","공공외교와주요이슈","KEY ISSUES IN PUBLIC DIPLOMACY",null,"IPS","IDC","IAS","IKS","IIC","IR","ID","Korean Studies"]
["IPS218","글로컬갈등관리세미나","SEMINAR ON GLOCAL CONFLICT MANAGEMENT","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IPS219","국제갈등의정치경제","THE POLITICAL ECONOMY OF INTERNATIONAL CONFLICT"]
["IPS310","국제동맹","INTERNATIONAL ALLIANCE",null,"IPS",{"$nulls":4},"IR"]
["IPS311","국제분쟁분석및관리","INTERNATIONAL CONFLICT ANALYSIS AND MANAGEMENT",null,"IPS","IDC",null,null,null,"IR","ID"]
["IPS312","국제안보및전략연구","NATIONAL SECURITY AND STRATEGIC STUDIES",null,"IPS",{"$nulls":4},"IR"]
["IPS313","군비통제","INTERNATIONAL ARMS CONTROL",null,"IPS",{"$nulls":4},"IR"]
["IPS314","비확산과반확산","ANTI-PROLIFERATION AND COUNTER-PROLIFERATION",null,"IPS",{"$nulls":4},"IR"]
["IPS315","인간안보","HUMAN SECURITY",null,"IPS","IDC",null,null,null,"IR","ID"]
["IPS316","전쟁의미래","FUTURE OF WAR","IIC","IPS","IDC",null,null,null,"IR","ID"]
["IPS410","국제법","INTERNATIONAL LAW","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IPS411","국제법사례연구","CASE STUDIES IN INTERNATIONAL LAW","IIC","IPS","IDC",null,null,"IIC","IR","ID"]
["IPS415","남북한관계","NORTH-SOUTH KOREAN RELATIONS","IIC","IPS",null,"IAS","IKS","IIC","IR","ID","Korean Studies"]
["IPS416","비교외교정책","COMPARATIVE FOREIGN POLICY","IIC","IPS","IDC",null,null,null,"IR"]
["IRC001","국제관계콜로키엄I","COLLOQUIUM ON INTERNATIONAL RELATIONS I"]
["IRC002","국제관계콜로키엄II","COLLOQUIUM ON INTERNATIONAL RELATIONS II"]
["IRC003","국제관계콜로키엄III","COLLOQUIUM ON INTERNATIONAL RELATIONS III"]
["IRC004","국제관계콜로키엄IV","COLLOQUIUM ON INTERNATIONAL RELATIONS IV"]
["IRC010","연구방법론","RESEARCH METHODS"]
["IRC011","논문지도세미나I","THESIS RESEARCH I"]
["IRC012","논문지도세미나II","THESIS RESEARCH II"]
["IRC013","연구방법론II","RESEARCH METHODS II"]
["IRC014","수료연구지도","TUTORIAL RESEARCH AFTER COMPLETION OF COURSE WORK"]
["IRC015","질적연구방법론","QUALITATIVE RESEARCH METHODS"]
["IRC016","연구지도","NON-THESIS RESEARCH"]
["IRC020","국제경영","INTERNATIONAL BUSINESS"]
["IRC030","국제경제","INTERNATIONAL ECONOMICS"]
["IRC040","국제정치","WORLD POLITICS: THEORY AND PRACTICE"]
["IRC050","한국근대사","MODERN HISTORY OF KOREA"]
["IRC051","한국어고급","KOREAN LANGUAGE III"]
["IRC052","한국어중급","KOREAN LANGUAGE II"]
["IRC053","한국어초급","KOREAN LANGUAGE I"]
["IRC060","현대한국입문","CONTEMPORARY KOREAN SOCIETY"]
["IRC070","국제개발협력입문","INTRODUCTION TO INTERNATIONAL DEVELOPMENT AND COOPERATION"]
["IRC110","통계데이터분석입문","STATISTICS AND DATA ANALYSIS"]
["IRC511","국제인턴십1","INTERNSHIP PROGRAM 1"]
["IRC512","국제인턴십2","INTERNSHIP PROGRAM 2"]
["IRC513","국제기구인턴십","INTERNATIONAL ORGANIZATION INTENSHIP"]
["IRC514","국제인턴십I","INTERNATIONAL INTERNSHIP PROGRAM I"]
["IRC515","국제인턴십II","INTERNATIONAL INTERNSHIP PROGRAM II"]
["IRC516","국제인턴십III","INTERNATIONAL INTERNSHIP PROGRAM III"]
["IRC517","국제기구인턴십I","INTERNATIONAL ORGANIZATION INTERNSHIP I"]
["IRC518","국제기구인턴십II","INTERNATIONAL ORGANIZATION INTERNSHIP II"]
["IRC519","국제기구인턴십III","INTERNATIONAL ORGANIZATION INTERNSHIP III"]
["IRC520","현지대학세미나","INTERNATIONAL SEMINAR"]
["IRC521","현지대학세미나I","INTERNATIONAL SEMINAR I"]
["IRC522","현지대학세미나II","INTERNATIONAL SEMINAR II"]
["IRC523","국제기구인턴십IV","INTERNATIONAL ORGANIZATION INTERNSHIP IV"]
["IRC524","현지대학세미나III","INTERNATIONAL SEMINAR III"]
["IRC901","커뮤니케이션기법I","ACADEMIC COMMUNICATION SKILLS I"]
["IRC902","커뮤니케이션기법II","ACADEMIC COMMUNICATION SKILLS II"]
["IRC903","논문개발세미나","THESIS DEVELOPMENT SEMINAR"]

{"sheet":"Korean Master thesis","index":1,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,1,49,3],[49,9,49,12],[40,12,47,12],[42,3,43,3],[44,3,45,3],[46,3,47,3],[48,1,48,3],[48,5,48,6],[48,9,48,12],[28,12,37,12],[38,1,38,3],[38,5,38,6],[38,9,38,12],[39,1,47,1],[39,11,47,11],[40,2,47,2],[40,3,41,3],[40,4,47,4],[40,10,47,10],[27,1,37,1],[28,2,37,2],[28,3,37,3],[28,4,37,4],[28,10,37,10],[28,11,37,11],[24,1,25,1],[24,10,25,10],[24,11,25,11],[24,12,25,12],[26,1,26,3],[26,5,26,6],[26,9,26,12],[23,1,23,3],[17,1,17,3],[17,5,17,6],[17,9,17,12],[18,1,19,1],[18,10,19,10],[18,11,19,11],[18,12,19,12],[20,1,20,3],[21,1,22,1],[21,10,22,10],[21,11,22,11],[21,12,22,12],[15,1,15,3],[15,5,15,6],[15,9,15,12],[9,1,10,1],[9,2,9,4],[9,5,9,8],[9,9,10,9],[9,10,9,11],[9,12,10,12],[11,1,14,1],[11,4,14,4],[11,10,14,10],[11,11,14,11],[11,12,14,12],[7,2,7,3],[1,1,1,12],[3,1,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3]]}
[]
[null,"Master's Degree Korean Studies - Thesis Track"]
[]
[null,"Student Information"]
[null,"Student No."]
[null,"Student Name"]
[null,"Major","Korean"]
[null,"Track"]
[]
[null,"Classification","Course you have to take",null,null,"Course you have taken",null,null,null,"Fields (only for major Courses)","Review Results",null,"비고\nNotes"]
[null,null,"Code","Name","Credit","Code","Name","Credit","Grade",null,"Status","Additional Credits Required"]
[null,"Core\nRequired - 1","IRC010","Research Methods",3,{"$nulls":5},{"$f":"IF(OR(AND(F12<>\"\",NOT(AND(LEN(F12)=6,IFERROR(FIND(UPPER(MID(F12,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F12,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F12,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F12,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F12,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F12,6,1)),\"\"))))),AND(F13<>\"\",NOT(AND(LEN(F13)=6,IFERROR(FIND(UPPER(MID(F13,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F13,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F13,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F13,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F13,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F13,6,1)),\"\"))))),AND(F14<>\"\",NOT(AND(LEN(F14)=6,IFERROR(FIND(UPPER(MID(F14,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F14,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F14,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F14,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F14,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F14,6,1)),\"\"))))),AND(F15<>\"\",NOT(AND(LEN(F15)=6,IFERROR(FIND(UPPER(MID(F15,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F15,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F15,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F15,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F15,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F15,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$12:$F$15<>\"\"),--((COUNTIF($F$12:$F$15,$F$12:$F$15)+COUNTIF($F$17:$F$17,$F$12:$F$15)+COUNTIF($F$19:$F$20,$F$12:$F$15)+COUNTIF($F$22:$F$23,$F$12:$F$15)+COUNTIF($F$25:$F$26,$F$12:$F$15)+COUNTIF($F$29:$F$38,$F$12:$F$15)+COUNTIF($F$40:$F$48,$F$12:$F$15))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(SUMPRODUCT(--($F$12:$F$15=$C$12:$C$15),--($H$12:$H$15>=3))>=1,\"completed\",\"not completed\")))","v":"not completed"},{"$f":"IF(K12=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(AND($H$16>=$E$16,K12=\"completed\"),\"Credit requirements fulfilled\",IF($E$16-$H$16=1,\"1 additional credit required\",MAX(0,$E$16-$H$16)&\" additional credits required\")))","v":"3 additional credits required"},"The requirement is met if at least one of the four courses is completed."]
[null,null,"IRC013","Research Methods II"]
[null,null,"IRC015"," Qualitative Research Methods"]
[null,null,"IRC110","Statistics and Data Analysis"]
[null,"Subtotal (total Core required 1 credits)",null,null,3,null,null,{"$f":"IF(SUMPRODUCT(--($F$12:$F$15=$C$12:$C$15),--($H$12:$H$15>=3))>=1,3,0)","v":0}]
[null,"Core\nRequired - 2","IRC011","Thesis Research I",3,{"$nulls":5},{"$f":"IF(OR(AND(F17<>\"\",NOT(AND(LEN(F17)=6,IFERROR(FIND(UPPER(MID(F17,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F17,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F17,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F17,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F17,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F17,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$17:$F$17<>\"\"),--((COUNTIF($F$12:$F$15,$F$17:$F$17)+COUNTIF($F$17:$F$17,$F$17:$F$17)+COUNTIF($F$19:$F$20,$F$17:$F$17)+COUNTIF($F$22:$F$23,$F$17:$F$17)+COUNTIF($F$25:$F$26,$F$17:$F$17)+COUNTIF($F$29:$F$38,$F$17:$F$17)+COUNTIF($F$40:$F$48,$F$17:$F$17))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND($F$17=$C$17,$H$17>=3),\"completed\",\"not completed\")))","v":"not completed"},{"$f":"IF(K17=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(AND($H$18>=$E$18,K17=\"completed\"),\"Credit requirements fulfilled\",IF($E$18-$H$18=1,\"1 additional credit required\",MAX(0,$E$18-$H$18)&\" additional credits required\")))","v":"3 additional credits required"},"Must take Thesis Research I in your 3rd semester"]
[null,"Subtotal (total Core required 2 credits)",null,null,3,null,null,{"$f":"IF(AND(F17=\"IRC011\",H17>=3),3,0)","v":0}]
[null,"Core\nRequired - 3","IRC050","Modern History of Korea",3,{"$nulls":5},{"$f":"IF(OR(AND(F19<>\"\",NOT(AND(LEN(F19)=6,IFERROR(FIND(UPPER(MID(F19,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F19,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F19,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F19,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F19,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F19,6,1)),\"\"))))),AND(F20<>\"\",NOT(AND(LEN(F20)=6,IFERROR(FIND(UPPER(MID(F20,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F20,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F20,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F20,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F20,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F20,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$19:$F$20<>\"\"),--((COUNTIF($F$12:$F$15,$F$19:$F$20)+COUNTIF($F$17:$F$17,$F$19:$F$20)+COUNTIF($F$19:$F$20,$F$19:$F$20)+COUNTIF($F$22:$F$23,$F$19:$F$20)+COUNTIF($F$25:$F$26,$F$19:$F$20)+COUNTIF($F$29:$F$38,$F$19:$F$20)+COUNTIF($F$40:$F$48,$F$19:$F$20))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND(COUNTIFS($F$19:$F$20,\"IRC050\",$H$19:$H$20,\">=3\")>=1,COUNTIFS($F$19:$F$20,\"IRC060\",$H$19:$H$20,\">=3\")>=1),\"completed\",\"not completed\")))","v":"not completed"},{"$f":"IF(K19=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(AND($H$21>=$E$21,K19=\"completed\"),\"Credit requirements fulfilled\",IF($E$21-$H$21=1,\"1 additional credit required\",MAX(0,$E$21-$H$21)&\" additional credits required\")))","v":"6 additional credits required"}]
[null,null,"IRC060","Contemporary Korean Society",3]
[null,"Subtotal (total Core required 3 credits)",null,null,6,null,null,{"$f":"3*COUNTIFS(F19:F20,\"IRC050\",H19:H20,\">=3\")+3*COUNTIFS(F19:F20,\"IRC060\",H19:H20,\">=3\")","v":0}]
[null,"Core\nRequired - 4","IKS420","Advanced Readings in Korean",3,{"$nulls":5},{"$f":"IF(OR(AND(F22<>\"\",NOT(AND(LEN(F22)=6,IFERROR(FIND(UPPER(MID(F22,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F22,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F22,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F22,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F22,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F22,6,1)),\"\"))))),AND(F23<>\"\",NOT(AND(LEN(F23)=6,IFERROR(FIND(UPPER(MID(F23,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F23,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F23,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F23,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F23,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F23,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$22:$F$23<>\"\"),--((COUNTIF($F$12:$F$15,$F$22:$F$23)+COUNTIF($F$17:$F$17,$F$22:$F$23)+COUNTIF($F$19:$F$20,$F$22:$F$23)+COUNTIF($F$22:$F$23,$F$22:$F$23)+COUNTIF($F$25:$F$26,$F$22:$F$23)+COUNTIF($F$29:$F$38,$F$22:$F$23)+COUNTIF($F$40:$F$48,$F$22:$F$23))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(OR(COUNTIFS($F$22:$F$23,\"IKS420\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"<>\")>=1,COUNTIFS($F$22:$F$23,\"IRC051\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"<>\")>=1),\"completed\",\"not completed\")))","v":"not completed"},{"$f":"IF(K22=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(AND($H$24>=$E$24,K22=\"completed\"),\"Credit requirements fulfilled\",IF($E$24-$H$24=1,\"1 additional credit required\",MAX(0,$E$24-$H$24)&\" additional credits required\")))","v":"3 additional credits required"}]
[null,null,"IRC051","Korean Language III",3]
[null,"Subtotal (total Core required 4 credits)",null,null,3,null,null,{"$f":"IF(OR(COUNTIFS(F22:F23,\"IKS420\",H22:H23,\">=3\",I22:I23,\"<>\")>=1,COUNTIFS(F22:F23,\"IRC051\",H22:H23,\">=3\",I22:I23,\"<>\")>=1),3,0)","v":0}]
[null,"Core\nRequired - 5","IRC052","Korean Language II",3,{"$nulls":5},{"$f":"IF(OR(AND(F25<>\"\",NOT(AND(LEN(F25)=6,IFERROR(FIND(UPPER(MID(F25,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F25,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F25,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F25,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F25,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F25,6,1)),\"\"))))),AND(F26<>\"\",NOT(AND(LEN(F26)=6,IFERROR(FIND(UPPER(MID(F26,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F26,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F26,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F26,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F26,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F26,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$25:$F$26<>\"\"),--((COUNTIF($F$12:$F$15,$F$25:$F$26)+COUNTIF($F$17:$F$17,$F$25:$F$26)+COUNTIF($F$19:$F$20,$F$25:$F$26)+COUNTIF($F$22:$F$23,$F$25:$F$26)+COUNTIF($F$25:$F$26,$F$25:$F$26)+COUNTIF($F$29:$F$38,$F$25:$F$26)+COUNTIF($F$40:$F$48,$F$25:$F$26))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(OR(COUNTIFS($F$22:$F$23,\"IKS420\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A\")>0,COUNTIFS($F$22:$F$23,\"IKS420\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A+\")>0,COUNTIFS($F$22:$F$23,\"IRC051\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A\")>0,COUNTIFS($F$22:$F$23,\"IRC051\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A+\")>0),\"completed\",IF(AND(COUNTIFS($F$25:$F$26,\"IRC052\",$H$25:$H$26,\">=3\")>=1,COUNTIFS($F$25:$F$26,\"IRC053\",$H$25:$H$26,\">=3\")>=1),\"completed\",\"not completed\"))))","v":"not completed"},{"$f":"IF(K25=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(OR(COUNTIFS($F$22:$F$23,\"IKS420\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A\")>0,COUNTIFS($F$22:$F$23,\"IKS420\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A+\")>0,COUNTIFS($F$22:$F$23,\"IRC051\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A\")>0,COUNTIFS($F$22:$F$23,\"IRC051\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A+\")>0),\"IRC052 and IRC053 are exempted; 6 additional major-course credits must be completed.\",IF(AND($H$27>=$E$27,K25=\"completed\"),\"Credit requirements fulfilled\",IF($E$27-$H$27=1,\"1 additional credit required\",MAX(0,$E$27-$H$27)&\" additional credits required\"))))","v":"6 additional credits required"}]
[null,null,"IRC053","Korean Language I",3]
[null,"Subtotal (total Core elective credits)",null,null,6,null,null,{"$f":"3*COUNTIFS(F25:F26,\"IRC052\",H25:H26,\">=3\")+3*COUNTIFS(F25:F26,\"IRC053\",H25:H26,\">=3\")","v":0}]
[null,"Major\nCourses\n","Code","Name","Credit","Code","Name","Credit",null,"Recognized field (Major Only)","Status","Additional Credits Required","비고 Notes"]
[null,null,"IKSxxx","IKS Major Courses",{"$f":"IF(OR(COUNTIFS($F$22:$F$23,\"IKS420\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A\")>0,COUNTIFS($F$22:$F$23,\"IKS420\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A+\")>0,COUNTIFS($F$22:$F$23,\"IRC051\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A\")>0,COUNTIFS($F$22:$F$23,\"IRC051\",$H$22:$H$23,\">=3\",$I$22:$I$23,\"A+\")>0),15,9)","v":9},{"$nulls":4},{"$f":"IF(F29=\"\",\"\",IFERROR(IF(VLOOKUP(F29,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""},{"$f":"IF(OR(AND(F29<>\"\",NOT(AND(LEN(F29)=6,IFERROR(FIND(UPPER(MID(F29,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F29,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F29,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F29,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F29,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F29,6,1)),\"\"))))),AND(F30<>\"\",NOT(AND(LEN(F30)=6,IFERROR(FIND(UPPER(MID(F30,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F30,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F30,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F30,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F30,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F30,6,1)),\"\"))))),AND(F31<>\"\",NOT(AND(LEN(F31)=6,IFERROR(FIND(UPPER(MID(F31,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F31,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F31,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F31,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F31,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F31,6,1)),\"\"))))),AND(F32<>\"\",NOT(AND(LEN(F32)=6,IFERROR(FIND(UPPER(MID(F32,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F32,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F32,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F32,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F32,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F32,6,1)),\"\"))))),AND(F33<>\"\",NOT(AND(LEN(F33)=6,IFERROR(FIND(UPPER(MID(F33,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F33,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F33,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F33,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F33,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F33,6,1)),\"\"))))),AND(F34<>\"\",NOT(AND(LEN(F34)=6,IFERROR(FIND(UPPER(MID(F34,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F34,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F34,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F34,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F34,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F34,6,1)),\"\"))))),AND(F35<>\"\",NOT(AND(LEN(F35)=6,IFERROR(FIND(UPPER(MID(F35,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F35,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F35,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F35,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F35,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F35,6,1)),\"\"))))),AND(F36<>\"\",NOT(AND(LEN(F36)=6,IFERROR(FIND(UPPER(MID(F36,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F36,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F36,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F36,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F36,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F36,6,1)),\"\"))))),AND(F37<>\"\",NOT(AND(LEN(F37)=6,IFERROR(FIND(UPPER(MID(F37,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F37,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F37,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F37,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F37,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F37,6,1)),\"\"))))),AND(F38<>\"\",NOT(AND(LEN(F38)=6,IFERROR(FIND(UPPER(MID(F38,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F38,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F38,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F38,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F38,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F38,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$29:$F$38<>\"\"),--((COUNTIF($F$12:$F$15,$F$29:$F$38)+COUNTIF($F$17:$F$17,$F$29:$F$38)+COUNTIF($F$19:$F$20,$F$29:$F$38)+COUNTIF($F$22:$F$23,$F$29:$F$38)+COUNTIF($F$25:$F$26,$F$29:$F$38)+COUNTIF($F$29:$F$38,$F$29:$F$38)+COUNTIF($F$40:$F$48,$F$29:$F$38))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(SUMIF($J$29:$J$38,\"*IKS*\",$H$29:$H$38)>=$E$39,\"completed\",\"not completed\")))","v":"not completed"},{"$f":"IF(K29=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(K29=\"completed\",\"Credit requirements fulfilled\",IF(MAX(0,$E$39-SUMIF($J$29:$J$38,\"*IKS*\",$H$29:$H$38))=1,\"1 additional credit required\",MAX(0,$E$39-SUMIF($J$29:$J$38,\"*IKS*\",$H$29:$H$38))&\" additional credits required\")))","v":"9 additional credits required"},"The list of KU GSIS Master's Major Courses for Cross-Major Recognition is ivailable on the KU GSIS homepage"]
[{"$nulls":9},{"$f":"IF(F30=\"\",\"\",IFERROR(IF(VLOOKUP(F30,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F31=\"\",\"\",IFERROR(IF(VLOOKUP(F31,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F32=\"\",\"\",IFERROR(IF(VLOOKUP(F32,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F33=\"\",\"\",IFERROR(IF(VLOOKUP(F33,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F34=\"\",\"\",IFERROR(IF(VLOOKUP(F34,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F35=\"\",\"\",IFERROR(IF(VLOOKUP(F35,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F36=\"\",\"\",IFERROR(IF(VLOOKUP(F36,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F37=\"\",\"\",IFERROR(IF(VLOOKUP(F37,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F38=\"\",\"\",IFERROR(IF(VLOOKUP(F38,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[null,"Subtotal (total Major elective credits)",null,null,{"$f":"E29","v":9},null,null,{"$f":"SUMIF($J$29:$J$38,\"*IKS*\",$H$29:$H$38)","v":0}]
[null,"General\nElectives","GRA511","Introduction to Graduate Studies",1,{"$nulls":5},{"$f":"IF(OR(AND(F40<>\"\",NOT(AND(LEN(F40)=6,IFERROR(FIND(UPPER(MID(F40,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F40,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,6,1)),\"\"))))),AND(F41<>\"\",NOT(AND(LEN(F41)=6,IFERROR(FIND(UPPER(MID(F41,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F41,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,6,1)),\"\"))))),AND(F42<>\"\",NOT(AND(LEN(F42)=6,IFERROR(FIND(UPPER(MID(F42,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F42,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,6,1)),\"\"))))),AND(F43<>\"\",NOT(AND(LEN(F43)=6,IFERROR(FIND(UPPER(MID(F43,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F43,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,6,1)),\"\"))))),AND(F44<>\"\",NOT(AND(LEN(F44)=6,IFERROR(FIND(UPPER(MID(F44,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F44,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,6,1)),\"\"))))),AND(F45<>\"\",NOT(AND(LEN(F45)=6,IFERROR(FIND(UPPER(MID(F45,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F45,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,6,1)),\"\"))))),AND(F46<>\"\",NOT(AND(LEN(F46)=6,IFERROR(FIND(UPPER(MID(F46,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F46,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F46,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F46,6,1)),\"\"))))),AND(F47<>\"\",NOT(AND(LEN(F47)=6,IFERROR(FIND(UPPER(MID(F47,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F47,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F47,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F47,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F47,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F47,6,1)),\"\"))))),AND(F48<>\"\",NOT(AND(LEN(F48)=6,IFERROR(FIND(UPPER(MID(F48,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F48,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F48,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F48,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$40:$F$48<>\"\"),--((COUNTIF($F$12:$F$15,$F$40:$F$48)+COUNTIF($F$17:$F$17,$F$40:$F$48)+COUNTIF($F$19:$F$20,$F$40:$F$48)+COUNTIF($F$22:$F$23,$F$40:$F$48)+COUNTIF($F$25:$F$26,$F$40:$F$48)+COUNTIF($F$29:$F$38,$F$40:$F$48)+COUNTIF($F$40:$F$48,$F$40:$F$48))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(COUNTIFS($F$40:$F$48,\"GRA511\",$H$40:$H$48,\">=1\")>=1,\"completed\",\"not completed\")))","v":"not completed"},{"$f":"IF(K40=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(AND(SUMIFS(H40:H48,F40:F48,\"<>GRA511\",F40:F48,\"<>\")>=9,COUNTIFS(F40:F48,\"GRA511\",H40:H48,\">=1\")=0),\"You must complete GRA511 (Introduction to Graduate Studies). Failure to complete this course will result in ineligibility for graduation.\",IF(H49<E49,IF(E49-H49=1,\"1 additional credit required\",(E49-H49)&\" additional credits required\"),IF(K40<>\"completed\",\"GRA511 must be completed\",IF(K41<>\"completed\",(9-SUMIFS(H40:H48,F40:F48,\"<>GRA511\",F40:F48,\"<>\"))&\" additional credits required\",\"Credit requirements fulfilled\")))))","v":"10 additional credits required"},"This course must be taken in the first semester; failure to do so will result in \n  ineligibility for graduation."]
[null,null,"Any Courses\nof following","IRC010/013/020/030/040/050/060/070/901/902",9,{"$nulls":5},{"$f":"IF(OR(AND(F40<>\"\",NOT(AND(LEN(F40)=6,IFERROR(FIND(UPPER(MID(F40,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F40,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,6,1)),\"\"))))),AND(F41<>\"\",NOT(AND(LEN(F41)=6,IFERROR(FIND(UPPER(MID(F41,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F41,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,6,1)),\"\"))))),AND(F42<>\"\",NOT(AND(LEN(F42)=6,IFERROR(FIND(UPPER(MID(F42,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F42,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,6,1)),\"\"))))),AND(F43<>\"\",NOT(AND(LEN(F43)=6,IFERROR(FIND(UPPER(MID(F43,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F43,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,6,1)),\"\"))))),AND(F44<>\"\",NOT(AND(LEN(F44)=6,IFERROR(FIND(UPPER(MID(F44,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F44,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,6,1)),\"\"))))),AND(F45<>\"\",NOT(AND(LEN(F45)=6,IFERROR(FIND(UPPER(MID(F45,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F45,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,6,1)),\"\"))))),AND(F46<>\"\",NOT(AND(LEN(F46)=6,IFERROR(FIND(UPPER(MID(F46,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F46,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F46,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F46,6,1)),\"\"))))),AND(F47<>\"\",NOT(AND(LEN(F47)=6,IFERROR(FIND(UPPER(MID(F47,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F47,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F47,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F47,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F47,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F47,6,1)),\"\"))))),AND(F48<>\"\",NOT(AND(LEN(F48)=6,IFERROR(FIND(UPPER(MID(F48,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F48,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F48,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F48,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$40:$F$48<>\"\"),--((COUNTIF($F$12:$F$15,$F$40:$F$48)+COUNTIF($F$17:$F$17,$F$40:$F$48)+COUNTIF($F$19:$F$20,$F$40:$F$48)+COUNTIF($F$22:$F$23,$F$40:$F$48)+COUNTIF($F$25:$F$26,$F$40:$F$48)+COUNTIF($F$29:$F$38,$F$40:$F$48)+COUNTIF($F$40:$F$48,$F$40:$F$48))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(SUMIFS($H$40:$H$48,$F$40:$F$48,\"<>GRA511\",$F$40:$F$48,\"<>\")>=9,\"completed\",\"not completed\")))","v":"not completed"},null,"* International Students can take Korean Language courses of KU GSIS \n* Short-term Program, courses taught in English of KU General Graduate School/other GSIS in Korea, etc.\n\n* Up to 9 credits can be taken in languages other than English (tentative) \n\n* Up to 15 Credits of Core Electives and General Electives can be from:\n     - Other universities int'l Studies programs (general electives)\n     - Other KU Graduate programs (Core Electives and General Electives)\n\n* For General Elective, please consult with the KU GSIS Administration Office"]
[]
[null,null,null,"International Studies(IICxxx, IDCxxx, IPSxxx, IASxxx)"]
[]
[null,null,null,"(Intl' Students only) Korean Language courses of KU GSIS or Short-term Program, courses taught in English of KU General Graduate School/other GSIS in Korea"]
[]
[null,null,null,"Korean Studies (IKSxxx)"]
[]
[null,"소계 Subtotal (General electives)",null,null,10,null,null,{"$f":"IF(AND(LEN(F40)=6,IFERROR(FIND(UPPER(MID(F40,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F40,3)),\"\"))),IF(ISNUMBER(H40),H40,0),0)+IF(AND(LEN(F41)=6,IFERROR(FIND(UPPER(MID(F41,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F41,3)),\"\"))),IF(ISNUMBER(H41),H41,0),0)+IF(AND(LEN(F42)=6,IFERROR(FIND(UPPER(MID(F42,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F42,3)),\"\"))),IF(ISNUMBER(H42),H42,0),0)+IF(AND(LEN(F43)=6,IFERROR(FIND(UPPER(MID(F43,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F43,3)),\"\"))),IF(ISNUMBER(H43),H43,0),0)+IF(AND(LEN(F44)=6,IFERROR(FIND(UPPER(MID(F44,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F44,3)),\"\"))),IF(ISNUMBER(H44),H44,0),0)+IF(AND(LEN(F45)=6,IFERROR(FIND(UPPER(MID(F45,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F45,3)),\"\"))),IF(ISNUMBER(H45),H45,0),0)+IF(AND(LEN(F46)=6,IFERROR(FIND(UPPER(MID(F46,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F46,3)),\"\"))),IF(ISNUMBER(H46),H46,0),0)+IF(AND(LEN(F47)=6,IFERROR(FIND(UPPER(MID(F47,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F47,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F47,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F47,3)),\"\"))),IF(ISNUMBER(H47),H47,0),0)+IF(AND(LEN(F48)=6,IFERROR(FIND(UPPER(MID(F48,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F48,3)),\"\"))),IF(ISNUMBER(H48),H48,0),0)","v":0}]
[null,"총계 Total",null,null,{"$f":"SUM(E49,E39,E27,E24,E21,E18,E16)","v":40},null,null,{"$f":"SUM(H49,H39,H27,H24,H21,H18,H16)","v":0},null,"A minimum of 40 credits must be earned, and all detailed requirements must also be satisfied"]

{"sheet":"Korean Master nonthesis","index":2,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[47,1,47,3],[47,9,47,12],[38,12,45,12],[40,3,41,3],[42,3,43,3],[44,3,45,3],[46,1,46,3],[46,5,46,6],[46,9,46,12],[37,1,45,1],[37,11,45,11],[38,2,45,2],[38,3,39,3],[38,4,45,4],[38,10,45,10],[22,12,23,12],[26,12,35,12],[36,1,36,3],[36,5,36,6],[36,9,36,12],[25,1,35,1],[26,2,35,2],[26,3,35,3],[26,4,35,4],[26,10,35,10],[26,11,35,11],[24,1,24,3],[24,5,24,6],[24,9,24,12],[16,1,17,1],[16,10,17,10],[16,11,17,11],[16,12,17,12],[18,1,18,3],[19,1,20,1],[19,10,20,10],[19,11,20,11],[19,12,20,12],[21,1,21,3],[22,1,23,1],[22,10,23,10],[22,11,23,11],[15,1,15,3],[15,5,15,6],[15,9,15,12],[9,1,10,1],[9,2,9,4],[9,5,9,8],[9,9,10,9],[9,10,9,11],[9,12,10,12],[11,1,14,1],[11,4,14,4],[11,10,14,10],[11,11,14,11],[11,12,14,12],[7,2,7,3],[1,1,1,12],[3,1,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3]]}
[]
[null,"Master's Degree Korean Studies - Non-Thesis Track"]
[]
[null,"Student Information"]
[null,"Student No."]
[null,"Student Name"]
[null,"Major","Korean"]
[null,"Track"]
[]
[null,"Classification","Course you have to take",null,null,"Course you have taken",null,null,null,"Fields (only for major Courses)","Review Results",null,"비고\nNotes"]
[null,null,"Code","Name","Credit","Code","Name","Credit","Grade",null,"Status","Additional Credits Required"]
[null,"Core\nRequired - 1","IRC010","Research Methods",3,{"$nulls":5},{"$f":"IF(OR(AND(F12<>\"\",NOT(AND(LEN(F12)=6,IFERROR(FIND(UPPER(MID(F12,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F12,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F12,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F12,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F12,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F12,6,1)),\"\"))))),AND(F13<>\"\",NOT(AND(LEN(F13)=6,IFERROR(FIND(UPPER(MID(F13,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F13,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F13,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F13,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F13,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F13,6,1)),\"\"))))),AND(F14<>\"\",NOT(AND(LEN(F14)=6,IFERROR(FIND(UPPER(MID(F14,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F14,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F14,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F14,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F14,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F14,6,1)),\"\"))))),AND(F15<>\"\",NOT(AND(LEN(F15)=6,IFERROR(FIND(UPPER(MID(F15,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F15,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F15,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F15,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F15,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F15,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$12:$F$15<>\"\"),--((COUNTIF($F$12:$F$15,$F$12:$F$15)+COUNTIF($F$17:$F$18,$F$12:$F$15)+COUNTIF($F$20:$F$21,$F$12:$F$15)+COUNTIF($F$23:$F$24,$F$12:$F$15)+COUNTIF($F$27:$F$36,$F$12:$F$15)+COUNTIF($F$38:$F$46,$F$12:$F$15))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(SUMPRODUCT(--($F$12:$F$15=$C$12:$C$15),--($H$12:$H$15>=3))>=1,\"completed\",\"not completed\")))","v":"not completed"},{"$f":"IF(K12=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(AND($H$16>=$E$16,K12=\"completed\"),\"Credit requirements fulfilled\",IF($E$16-$H$16=1,\"1 additional credit required\",MAX(0,$E$16-$H$16)&\" additional credits required\")))","v":"3 additional credits required"},"The requirement is met if at least one of the four courses is completed."]
[null,null,"IRC013","Research Methods II"]
[null,null,"IRC015"," Qualitative Research Methods"]
[null,null,"IRC110","Statistics and Data Analysis"]
[null,"Subtotal (total Core required 1 credits)",null,null,3,null,null,{"$f":"IF(SUMPRODUCT(--($F$12:$F$15=$C$12:$C$15),--($H$12:$H$15>=3))>=1,3,0)","v":0}]
[null,"Core\nRequired - 2","IRC050","Modern History of Korea",3,{"$nulls":5},{"$f":"IF(OR(AND(F17<>\"\",NOT(AND(LEN(F17)=6,IFERROR(FIND(UPPER(MID(F17,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F17,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F17,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F17,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F17,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F17,6,1)),\"\"))))),AND(F18<>\"\",NOT(AND(LEN(F18)=6,IFERROR(FIND(UPPER(MID(F18,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F18,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F18,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F18,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F18,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F18,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$17:$F$18<>\"\"),--((COUNTIF($F$12:$F$15,$F$17:$F$18)+COUNTIF($F$17:$F$18,$F$17:$F$18)+COUNTIF($F$20:$F$21,$F$17:$F$18)+COUNTIF($F$23:$F$24,$F$17:$F$18)+COUNTIF($F$27:$F$36,$F$17:$F$18)+COUNTIF($F$38:$F$46,$F$17:$F$18))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND(COUNTIFS($F$17:$F$18,\"IRC050\",$H$17:$H$18,\">=3\")>=1,COUNTIFS($F$17:$F$18,\"IRC060\",$H$17:$H$18,\">=3\")>=1),\"completed\",\"not completed\")))","v":"not completed"},{"$f":"IF(K17=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(AND($H$19>=$E$19,K17=\"completed\"),\"Credit requirements fulfilled\",IF($E$19-$H$19=1,\"1 additional credit required\",MAX(0,$E$19-$H$19)&\" additional credits required\")))","v":"6 additional credits required"}]
[null,null,"IRC060","Contemporary Korean Society",3]
[null,"Subtotal (total Core required 3 credits)",null,null,6,null,null,{"$f":"3*COUNTIFS(F17:F18,\"IRC050\",H17:H18,\">=3\")+3*COUNTIFS(F17:F18,\"IRC060\",H17:H18,\">=3\")","v":0}]
[null,"Core\nRequired - 3","IKS420","Advanced Readings in Korean",3,{"$nulls":5},{"$f":"IF(OR(AND(F20<>\"\",NOT(AND(LEN(F20)=6,IFERROR(FIND(UPPER(MID(F20,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F20,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F20,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F20,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F20,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F20,6,1)),\"\"))))),AND(F21<>\"\",NOT(AND(LEN(F21)=6,IFERROR(FIND(UPPER(MID(F21,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F21,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F21,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F21,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F21,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F21,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$20:$F$21<>\"\"),--((COUNTIF($F$12:$F$15,$F$20:$F$21)+COUNTIF($F$17:$F$18,$F$20:$F$21)+COUNTIF($F$20:$F$21,$F$20:$F$21)+COUNTIF($F$23:$F$24,$F$20:$F$21)+COUNTIF($F$27:$F$36,$F$20:$F$21)+COUNTIF($F$38:$F$46,$F$20:$F$21))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(OR(COUNTIFS($F$20:$F$21,\"IKS420\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"<>\")>=1,COUNTIFS($F$20:$F$21,\"IRC051\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"<>\")>=1),\"completed\",\"not completed\")))","v":"not completed"},{"$f":"IF(K20=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(AND($H$22>=$E$22,K20=\"completed\"),\"Credit requirements fulfilled\",IF($E$22-$H$22=1,\"1 additional credit required\",MAX(0,$E$22-$H$22)&\" additional credits required\")))","v":"3 additional credits required"}]
[null,null,"IRC051","Korean Language III",3]
[null,"Subtotal (total Core required 4 credits)",null,null,3,null,null,{"$f":"IF(OR(COUNTIFS(F20:F21,\"IKS420\",H20:H21,\">=3\",I20:I21,\"<>\")>=1,COUNTIFS(F20:F21,\"IRC051\",H20:H21,\">=3\",I20:I21,\"<>\")>=1),3,0)","v":0}]
[null,"Core\nRequired - 4","IRC052","Korean Language II",3,{"$nulls":5},{"$f":"IF(OR(AND(F23<>\"\",NOT(AND(LEN(F23)=6,IFERROR(FIND(UPPER(MID(F23,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F23,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F23,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F23,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F23,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F23,6,1)),\"\"))))),AND(F24<>\"\",NOT(AND(LEN(F24)=6,IFERROR(FIND(UPPER(MID(F24,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F24,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F24,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F24,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F24,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F24,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$23:$F$24<>\"\"),--((COUNTIF($F$12:$F$15,$F$23:$F$24)+COUNTIF($F$17:$F$18,$F$23:$F$24)+COUNTIF($F$20:$F$21,$F$23:$F$24)+COUNTIF($F$23:$F$24,$F$23:$F$24)+COUNTIF($F$27:$F$36,$F$23:$F$24)+COUNTIF($F$38:$F$46,$F$23:$F$24))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(OR(COUNTIFS($F$20:$F$21,\"IKS420\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A\")>0,COUNTIFS($F$20:$F$21,\"IKS420\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A+\")>0,COUNTIFS($F$20:$F$21,\"IRC051\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A\")>0,COUNTIFS($F$20:$F$21,\"IRC051\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A+\")>0),\"completed\",IF(AND(COUNTIFS($F$23:$F$24,\"IRC052\",$H$23:$H$24,\">=3\")>=1,COUNTIFS($F$23:$F$24,\"IRC053\",$H$23:$H$24,\">=3\")>=1),\"completed\",\"not completed\"))))","v":"not completed"},{"$f":"IF(K23=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(OR(COUNTIFS($F$20:$F$21,\"IKS420\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A\")>0,COUNTIFS($F$20:$F$21,\"IKS420\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A+\")>0,COUNTIFS($F$20:$F$21,\"IRC051\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A\")>0,COUNTIFS($F$20:$F$21,\"IRC051\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A+\")>0),\"IRC052 and IRC053 are exempted; 6 additional major-course credits must be completed.\",IF(AND($H$25>=$E$25,K23=\"completed\"),\"Credit requirements fulfilled\",IF($E$25-$H$25=1,\"1 additional credit required\",MAX(0,$E$25-$H$25)&\" additional credits required\"))))","v":"6 additional credits required"}]
[null,null,"IRC053","Korean Language I",3]
[null,"Subtotal (total Core elective credits)",null,null,6,null,null,{"$f":"3*COUNTIFS(F23:F24,\"IRC052\",H23:H24,\">=3\")+3*COUNTIFS(F23:F24,\"IRC053\",H23:H24,\">=3\")","v":0}]
[null,"Major\nCourses\n","Code","Name","Credit","Code","Name","Credit",null,"Recognized field (Major Only)","Status","Additional Credits Required","비고 Notes"]
[null,null,"IKSxxx","IKS Major Courses",{"$f":"IF(OR(COUNTIFS($F$20:$F$21,\"IKS420\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A\")>0,COUNTIFS($F$20:$F$21,\"IKS420\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A+\")>0,COUNTIFS($F$20:$F$21,\"IRC051\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A\")>0,COUNTIFS($F$20:$F$21,\"IRC051\",$H$20:$H$21,\">=3\",$I$20:$I$21,\"A+\")>0),21,15)","v":15},{"$nulls":4},{"$f":"IF(F27=\"\",\"\",IFERROR(IF(VLOOKUP(F27,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""},{"$f":"IF(OR(AND(F27<>\"\",NOT(AND(LEN(F27)=6,IFERROR(FIND(UPPER(MID(F27,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F27,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F27,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F27,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F27,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F27,6,1)),\"\"))))),AND(F28<>\"\",NOT(AND(LEN(F28)=6,IFERROR(FIND(UPPER(MID(F28,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F28,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F28,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F28,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F28,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F28,6,1)),\"\"))))),AND(F29<>\"\",NOT(AND(LEN(F29)=6,IFERROR(FIND(UPPER(MID(F29,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F29,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F29,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F29,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F29,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F29,6,1)),\"\"))))),AND(F30<>\"\",NOT(AND(LEN(F30)=6,IFERROR(FIND(UPPER(MID(F30,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F30,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F30,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F30,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F30,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F30,6,1)),\"\"))))),AND(F31<>\"\",NOT(AND(LEN(F31)=6,IFERROR(FIND(UPPER(MID(F31,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F31,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F31,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F31,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F31,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F31,6,1)),\"\"))))),AND(F32<>\"\",NOT(AND(LEN(F32)=6,IFERROR(FIND(UPPER(MID(F32,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F32,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F32,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F32,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F32,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F32,6,1)),\"\"))))),AND(F33<>\"\",NOT(AND(LEN(F33)=6,IFERROR(FIND(UPPER(MID(F33,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F33,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F33,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F33,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F33,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F33,6,1)),\"\"))))),AND(F34<>\"\",NOT(AND(LEN(F34)=6,IFERROR(FIND(UPPER(MID(F34,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F34,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F34,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F34,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F34,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F34,6,1)),\"\"))))),AND(F35<>\"\",NOT(AND(LEN(F35)=6,IFERROR(FIND(UPPER(MID(F35,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F35,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F35,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F35,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F35,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F35,6,1)),\"\"))))),AND(F36<>\"\",NOT(AND(LEN(F36)=6,IFERROR(FIND(UPPER(MID(F36,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F36,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F36,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F36,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F36,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F36,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$27:$F$36<>\"\"),--((COUNTIF($F$12:$F$15,$F$27:$F$36)+COUNTIF($F$17:$F$18,$F$27:$F$36)+COUNTIF($F$20:$F$21,$F$27:$F$36)+COUNTIF($F$23:$F$24,$F$27:$F$36)+COUNTIF($F$27:$F$36,$F$27:$F$36)+COUNTIF($F$38:$F$46,$F$27:$F$36))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF($H$37>=$E$37,\"completed\",\"not completed\")))","v":"not completed"},{"$f":"IF(K27=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(K27=\"completed\",\"Credit requirements fulfilled\",IF(MAX(0,$E$37-$H$37)=1,\"1 additional credit required\",MAX(0,$E$37-$H$37)&\" additional credits required\")))","v":"15 additional credits required"},"The list of KU GSIS Master's Major Courses for Cross-Major Recognition is ivailable on the KU GSIS homepage"]
[{"$nulls":9},{"$f":"IF(F28=\"\",\"\",IFERROR(IF(VLOOKUP(F28,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F29=\"\",\"\",IFERROR(IF(VLOOKUP(F29,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F30=\"\",\"\",IFERROR(IF(VLOOKUP(F30,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F31=\"\",\"\",IFERROR(IF(VLOOKUP(F31,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F32=\"\",\"\",IFERROR(IF(VLOOKUP(F32,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F33=\"\",\"\",IFERROR(IF(VLOOKUP(F33,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F34=\"\",\"\",IFERROR(IF(VLOOKUP(F34,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F35=\"\",\"\",IFERROR(IF(VLOOKUP(F35,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[{"$nulls":9},{"$f":"IF(F36=\"\",\"\",IFERROR(IF(VLOOKUP(F36,CrossList!$A$3:$H$315,8,FALSE)=\"IKS\",\"This course can be recognized as IKS\",\"Not recognized as a Korean Studies major course\"),\"Not recognized as a Korean Studies major course\"))","v":""}]
[null,"Subtotal (total Major elective credits)",null,null,{"$f":"E27","v":15},null,null,{"$f":"SUMIF($J$27:$J$36,\"*IKS*\",$H$27:$H$36)","v":0}]
[null,"General\nElectives","GRA511","Introduction to Graduate Studies",1,{"$nulls":5},{"$f":"IF(OR(AND(F38<>\"\",NOT(AND(LEN(F38)=6,IFERROR(FIND(UPPER(MID(F38,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F38,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F38,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F38,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F38,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F38,6,1)),\"\"))))),AND(F39<>\"\",NOT(AND(LEN(F39)=6,IFERROR(FIND(UPPER(MID(F39,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F39,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F39,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F39,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F39,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F39,6,1)),\"\"))))),AND(F40<>\"\",NOT(AND(LEN(F40)=6,IFERROR(FIND(UPPER(MID(F40,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F40,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,6,1)),\"\"))))),AND(F41<>\"\",NOT(AND(LEN(F41)=6,IFERROR(FIND(UPPER(MID(F41,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F41,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,6,1)),\"\"))))),AND(F42<>\"\",NOT(AND(LEN(F42)=6,IFERROR(FIND(UPPER(MID(F42,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F42,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,6,1)),\"\"))))),AND(F43<>\"\",NOT(AND(LEN(F43)=6,IFERROR(FIND(UPPER(MID(F43,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F43,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,6,1)),\"\"))))),AND(F44<>\"\",NOT(AND(LEN(F44)=6,IFERROR(FIND(UPPER(MID(F44,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F44,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,6,1)),\"\"))))),AND(F45<>\"\",NOT(AND(LEN(F45)=6,IFERROR(FIND(UPPER(MID(F45,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F45,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,6,1)),\"\"))))),AND(F46<>\"\",NOT(AND(LEN(F46)=6,IFERROR(FIND(UPPER(MID(F46,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F46,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F46,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F46,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$38:$F$46<>\"\"),--((COUNTIF($F$12:$F$15,$F$38:$F$46)+COUNTIF($F$17:$F$18,$F$38:$F$46)+COUNTIF($F$20:$F$21,$F$38:$F$46)+COUNTIF($F$23:$F$24,$F$38:$F$46)+COUNTIF($F$27:$F$36,$F$38:$F$46)+COUNTIF($F$38:$F$46,$F$38:$F$46))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(COUNTIFS($F$38:$F$46,\"GRA511\",$H$38:$H$46,\">=1\")>=1,\"completed\",\"not completed\")))","v":"not completed"},{"$f":"IF(K38=\"The same course has been entered more than once. Graduation assessment cannot be completed.\",\"\",IF(AND(SUMIFS(H38:H46,F38:F46,\"<>GRA511\",F38:F46,\"<>\")>=9,COUNTIFS(F38:F46,\"GRA511\",H38:H46,\">=1\")=0),\"You must complete GRA511 (Introduction to Graduate Studies). Failure to complete this course will result in ineligibility for graduation.\",IF(H47<E47,IF(E47-H47=1,\"1 additional credit required\",(E47-H47)&\" additional credits required\"),IF(K38<>\"completed\",\"GRA511 must be completed\",IF(K39<>\"completed\",(9-SUMIFS(H38:H46,F38:F46,\"<>GRA511\",F38:F46,\"<>\"))&\" additional credits required\",\"Credit requirements fulfilled\")))))","v":"10 additional credits required"},"This course must be taken in the first semester; failure to do so will result in \n  ineligibility for graduation."]
[null,null,"Any Courses\nof following","IRC010/013/020/030/040/050/060/070/901/902",9,{"$nulls":5},{"$f":"IF(OR(AND(F38<>\"\",NOT(AND(LEN(F38)=6,IFERROR(FIND(UPPER(MID(F38,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F38,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F38,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F38,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F38,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F38,6,1)),\"\"))))),AND(F39<>\"\",NOT(AND(LEN(F39)=6,IFERROR(FIND(UPPER(MID(F39,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F39,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F39,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F39,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F39,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F39,6,1)),\"\"))))),AND(F40<>\"\",NOT(AND(LEN(F40)=6,IFERROR(FIND(UPPER(MID(F40,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F40,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,6,1)),\"\"))))),AND(F41<>\"\",NOT(AND(LEN(F41)=6,IFERROR(FIND(UPPER(MID(F41,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F41,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,6,1)),\"\"))))),AND(F42<>\"\",NOT(AND(LEN(F42)=6,IFERROR(FIND(UPPER(MID(F42,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F42,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,6,1)),\"\"))))),AND(F43<>\"\",NOT(AND(LEN(F43)=6,IFERROR(FIND(UPPER(MID(F43,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F43,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,6,1)),\"\"))))),AND(F44<>\"\",NOT(AND(LEN(F44)=6,IFERROR(FIND(UPPER(MID(F44,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F44,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,6,1)),\"\"))))),AND(F45<>\"\",NOT(AND(LEN(F45)=6,IFERROR(FIND(UPPER(MID(F45,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F45,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,6,1)),\"\"))))),AND(F46<>\"\",NOT(AND(LEN(F46)=6,IFERROR(FIND(UPPER(MID(F46,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F46,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F46,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F46,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--($F$38:$F$46<>\"\"),--((COUNTIF($F$12:$F$15,$F$38:$F$46)+COUNTIF($F$17:$F$18,$F$38:$F$46)+COUNTIF($F$20:$F$21,$F$38:$F$46)+COUNTIF($F$23:$F$24,$F$38:$F$46)+COUNTIF($F$27:$F$36,$F$38:$F$46)+COUNTIF($F$38:$F$46,$F$38:$F$46))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(SUMIFS($H$38:$H$46,$F$38:$F$46,\"<>GRA511\",$F$38:$F$46,\"<>\")>=9,\"completed\",\"not completed\")))","v":"not completed"},null,"* International Students can take Korean Language courses of KU GSIS \n* Short-term Program, courses taught in English of KU General Graduate School/other GSIS in Korea, etc.\n\n* Up to 9 credits can be taken in languages other than English (tentative) \n\n* Up to 15 Credits of Core Electives and General Electives can be from:\n     - Other universities int'l Studies programs (general electives)\n     - Other KU Graduate programs (Core Electives and General Electives)\n\n* For General Elective, please consult with the KU GSIS Administration Office"]
[]
[null,null,null,"International Studies(IICxxx, IDCxxx, IPSxxx, IASxxx)"]
[]
[null,null,null,"(Intl' Students only) Korean Language courses of KU GSIS or Short-term Program, courses taught in English of KU General Graduate School/other GSIS in Korea"]
[]
[null,null,null,"Korean Studies (IKSxxx)"]
[]
[null,"소계 Subtotal (General electives)",null,null,10,null,null,{"$f":"IF(AND(LEN(F38)=6,IFERROR(FIND(UPPER(MID(F38,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F38,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F38,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F38,3)),\"\"))),IF(ISNUMBER(H38),H38,0),0)+IF(AND(LEN(F39)=6,IFERROR(FIND(UPPER(MID(F39,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F39,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F39,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F39,3)),\"\"))),IF(ISNUMBER(H39),H39,0),0)+IF(AND(LEN(F40)=6,IFERROR(FIND(UPPER(MID(F40,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F40,3)),\"\"))),IF(ISNUMBER(H40),H40,0),0)+IF(AND(LEN(F41)=6,IFERROR(FIND(UPPER(MID(F41,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F41,3)),\"\"))),IF(ISNUMBER(H41),H41,0),0)+IF(AND(LEN(F42)=6,IFERROR(FIND(UPPER(MID(F42,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F42,3)),\"\"))),IF(ISNUMBER(H42),H42,0),0)+IF(AND(LEN(F43)=6,IFERROR(FIND(UPPER(MID(F43,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F43,3)),\"\"))),IF(ISNUMBER(H43),H43,0),0)+IF(AND(LEN(F44)=6,IFERROR(FIND(UPPER(MID(F44,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F44,3)),\"\"))),IF(ISNUMBER(H44),H44,0),0)+IF(AND(LEN(F45)=6,IFERROR(FIND(UPPER(MID(F45,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F45,3)),\"\"))),IF(ISNUMBER(H45),H45,0),0)+IF(AND(LEN(F46)=6,IFERROR(FIND(UPPER(MID(F46,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F46,3)),\"\"))),IF(ISNUMBER(H46),H46,0),0)","v":0}]
[null,"총계 Total",null,null,43,null,null,{"$f":"SUM(H16,H19,H22,H25,H37,H47)","v":0},null,"A minimum of 43 credits must be earned, and all detailed requirements must also be satisfied"]

{"sheet":"Int Master thesis","index":3,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,1,57,3],[57,8,57,11],[48,11,55,11],[50,3,51,3],[52,3,53,3],[54,3,55,3],[56,1,56,3],[56,5,56,6],[56,8,56,11],[47,1,55,1],[47,10,55,10],[48,2,55,2],[48,3,49,3],[48,4,55,4],[48,9,55,9],[46,8,46,11],[37,1,37,3],[37,5,37,6],[37,8,37,11],[38,1,45,1],[38,2,41,2],[38,3,41,3],[38,4,41,4],[38,9,45,9],[38,10,45,10],[38,11,45,11],[42,2,45,2],[42,3,45,3],[42,4,45,4],[46,1,46,3],[46,5,46,6],[22,1,22,3],[22,5,22,6],[22,8,22,11],[23,1,36,1],[24,2,36,2],[24,3,36,3],[24,4,36,4],[24,9,36,9],[24,10,36,10],[24,11,36,11],[17,1,17,3],[17,5,17,6],[17,8,17,11],[18,1,21,1],[18,9,21,9],[18,10,21,10],[18,11,21,11],[15,1,15,3],[15,5,15,6],[15,8,15,11],[9,1,10,1],[9,2,9,4],[9,5,9,7],[9,8,10,8],[9,9,9,10],[9,11,10,11],[11,1,14,1],[11,4,14,4],[11,9,14,9],[11,10,14,10],[11,11,14,11],[7,2,7,3],[1,1,1,11],[3,1,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3]]}
[]
[null,"Master's Degree International Studies - Thesis Track"]
[]
[null,"Student Information"]
[null,"Student No."]
[null,"Student Name"]
[null,"Major","International Development&Cooperation"]
[null,"Track"]
[]
[null,"Classification","Course you have to take",null,null,"Course you have taken",null,null,"Fields (only for major Courses)","Review Results",null,"비고\nNotes"]
[null,null,"Code","Name","Credit","Code","Name","Credit",null,"Status","Additional Credits Required"]
[null,"Required\nCourses 1","IRC010","Research Methods",3,{"$nulls":4},{"$f":"IF(SUMPRODUCT(--($F$12:$F$15=$C$12:$C$15),--($H$12:$H$15>=3))>=1,\"completed\",\"not completed\")","v":"not completed"},{"$f":"IF(OR(AND(F12<>\"\",NOT(AND(LEN(F12)=6,IFERROR(FIND(UPPER(MID(F12,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F12,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F12,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F12,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F12,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F12,6,1)),\"\"))))),AND(F13<>\"\",NOT(AND(LEN(F13)=6,IFERROR(FIND(UPPER(MID(F13,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F13,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F13,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F13,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F13,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F13,6,1)),\"\"))))),AND(F14<>\"\",NOT(AND(LEN(F14)=6,IFERROR(FIND(UPPER(MID(F14,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F14,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F14,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F14,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F14,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F14,6,1)),\"\"))))),AND(F15<>\"\",NOT(AND(LEN(F15)=6,IFERROR(FIND(UPPER(MID(F15,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F15,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F15,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F15,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F15,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F15,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--(F12:F15<>\"\"),--((COUNTIF($F$12:$F$15,F12:F15)+COUNTIF($F$17:$F$17,F12:F15)+COUNTIF($F$19:$F$22,F12:F15)+COUNTIF($F$25:$F$37,F12:F15)+COUNTIF($F$39:$F$46,F12:F15)+COUNTIF($F$48:$F$56,F12:F15))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND($H$16>=$E$16,OR($J$12=\"completed\",$J$12=\"comleted\")),\n\"Credit requirements fulfilled\",\nIF(AND($H$16<$E$16,$J$12=\"not completed\"),\nIF($E$16-$H$16=1,\"1 additional credit required\",($E$16-$H$16)&\" additional credits required\"),\n\"\"))))","v":"3 additional credits required"},"The requirement is met if at least one of the four courses is completed."]
[null,null,"IRC013","Research Methods II"]
[null,null,"IRC015"," Qualitative Research Methods"]
[null,null,"IRC110","Statistics and Data Analysis"]
[null,"Subtotal (total required course1 credits)",null,null,3,null,null,{"$f":"IF(SUMPRODUCT(--($F$12:$F$15=$C$12:$C$15),--($H$12:$H$15>=3))>=1,3,0)","v":0}]
[null,"Required\nCourses 2","IRC011","Thesis Research I",3,{"$nulls":4},{"$f":"IF(AND($F$17=$C$17,$H$17>=3),\"completed\",\"not completed\")","v":"not completed"},{"$f":"IF(OR(AND(F17<>\"\",NOT(AND(LEN(F17)=6,IFERROR(FIND(UPPER(MID(F17,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F17,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F17,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F17,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F17,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F17,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--(F17:F17<>\"\"),--((COUNTIF($F$12:$F$15,F17:F17)+COUNTIF($F$17:$F$17,F17:F17)+COUNTIF($F$19:$F$22,F17:F17)+COUNTIF($F$25:$F$37,F17:F17)+COUNTIF($F$39:$F$46,F17:F17)+COUNTIF($F$48:$F$56,F17:F17))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND($H$18>=$E$18,OR($J$17=\"completed\",$J$17=\"comleted\")),\n\"Credit requirements fulfilled\",\nIF(AND($H$18<$E$18,$J$17=\"not completed\"),\nIF($E$18-$H$18=1,\"1 additional credit required\",($E$18-$H$18)&\" additional credits required\"),\n\"\"))))","v":"3 additional credits required"},"Must take Thesis Research I in your 3rd semester"]
[null,"Subtotal (total required course2 credits)",null,null,3,null,null,{"$f":"IF(AND(F17=\"IRC011\",H17>=3),3,0)","v":0}]
[null,"Core\nElectives","IRC020","International Business",3,{"$nulls":4},{"$f":"IF(AND($H$23>=9,SUMPRODUCT(--($F$19:$F$22=$C$19:$C$22),--($H$19:$H$22>0))>=3),\"completed\",\"not completed\")","v":"not completed"},{"$f":"IF(OR(AND(F19<>\"\",NOT(AND(LEN(F19)=6,IFERROR(FIND(UPPER(MID(F19,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F19,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F19,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F19,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F19,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F19,6,1)),\"\"))))),AND(F20<>\"\",NOT(AND(LEN(F20)=6,IFERROR(FIND(UPPER(MID(F20,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F20,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F20,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F20,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F20,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F20,6,1)),\"\"))))),AND(F21<>\"\",NOT(AND(LEN(F21)=6,IFERROR(FIND(UPPER(MID(F21,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F21,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F21,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F21,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F21,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F21,6,1)),\"\"))))),AND(F22<>\"\",NOT(AND(LEN(F22)=6,IFERROR(FIND(UPPER(MID(F22,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F22,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F22,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F22,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F22,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F22,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--(F19:F22<>\"\"),--((COUNTIF($F$12:$F$15,F19:F22)+COUNTIF($F$17:$F$17,F19:F22)+COUNTIF($F$19:$F$22,F19:F22)+COUNTIF($F$25:$F$37,F19:F22)+COUNTIF($F$39:$F$46,F19:F22)+COUNTIF($F$48:$F$56,F19:F22))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND($H$23>=$E$23,OR($J$19=\"completed\",$J$19=\"comleted\")),\n\"Credit requirements fulfilled\",\nIF(AND($H$23<$E$23,$J$19=\"not completed\"),\nIF($E$23-$H$23=1,\"1 additional credit required\",($E$23-$H$23)&\" additional credits required\"),\n\"\"))))","v":"9 additional credits required"},"* Select and take 3 courses out of 4.\n* If a first-year student takes and passes the Common Course Exemption Examination, up to 6 credits may be waived (up to 9 credits for students in the BA-MA program). If core electives are waived, any resulting credit deficiency must be made up by completing additional major courses."]
[null,null,"IRC030","International Economics",3]
[null,null,"IRC040","World Politics",3]
[null,null,"IRC070","Introduction to International \nDevelopment and Cooperation",3]
[null,"Subtotal (total Core elective credits)",null,null,9,null,null,{"$f":"3*SUMPRODUCT(--(COUNTIF($C$19:$C$22,F19:F22)>0),--(H19:H22>=3))","v":0}]
[null,"Major\nCourses\n","Code","Name","Credit","Code","Name","Credit","Recognized field (Major Only)"]
[null,null,"IIC/IDC\n/IPS/IAS","Completion of at least five courses corresponding to the student’s major",15,null,null,null,{"$f":"IF(F25=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F25,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F25,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F25,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F25,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F25,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""},{"$f":"IF(AND($H$38>=15,IF(TRIM($C$7)=\"International Commerce\",COUNTIFS($I$25:$I$37,\"*IIC*\",$H$25:$H$37,\">0\"),IF(TRIM($C$7)=\"International Development&Cooperation\",COUNTIFS($I$25:$I$37,\"*IDC*\",$H$25:$H$37,\">0\"),IF(TRIM($C$7)=\"International Peace&Security\",COUNTIFS($I$25:$I$37,\"*IPS*\",$H$25:$H$37,\">0\"),IF(TRIM($C$7)=\"Area Studies\",COUNTIFS($I$25:$I$37,\"*IAS*\",$H$25:$H$37,\">0\"),0))))>=5),\"completed\",\"not completed\")","v":"not completed"},{"$f":"IF(OR(AND(F25<>\"\",NOT(AND(LEN(F25)=6,IFERROR(FIND(UPPER(MID(F25,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F25,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F25,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F25,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F25,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F25,6,1)),\"\"))))),AND(F26<>\"\",NOT(AND(LEN(F26)=6,IFERROR(FIND(UPPER(MID(F26,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F26,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F26,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F26,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F26,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F26,6,1)),\"\"))))),AND(F27<>\"\",NOT(AND(LEN(F27)=6,IFERROR(FIND(UPPER(MID(F27,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F27,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F27,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F27,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F27,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F27,6,1)),\"\"))))),AND(F28<>\"\",NOT(AND(LEN(F28)=6,IFERROR(FIND(UPPER(MID(F28,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F28,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F28,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F28,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F28,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F28,6,1)),\"\"))))),AND(F29<>\"\",NOT(AND(LEN(F29)=6,IFERROR(FIND(UPPER(MID(F29,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F29,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F29,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F29,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F29,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F29,6,1)),\"\"))))),AND(F30<>\"\",NOT(AND(LEN(F30)=6,IFERROR(FIND(UPPER(MID(F30,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F30,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F30,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F30,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F30,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F30,6,1)),\"\"))))),AND(F31<>\"\",NOT(AND(LEN(F31)=6,IFERROR(FIND(UPPER(MID(F31,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F31,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F31,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F31,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F31,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F31,6,1)),\"\"))))),AND(F32<>\"\",NOT(AND(LEN(F32)=6,IFERROR(FIND(UPPER(MID(F32,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F32,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F32,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F32,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F32,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F32,6,1)),\"\"))))),AND(F33<>\"\",NOT(AND(LEN(F33)=6,IFERROR(FIND(UPPER(MID(F33,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F33,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F33,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F33,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F33,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F33,6,1)),\"\"))))),AND(F34<>\"\",NOT(AND(LEN(F34)=6,IFERROR(FIND(UPPER(MID(F34,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F34,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F34,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F34,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F34,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F34,6,1)),\"\"))))),AND(F35<>\"\",NOT(AND(LEN(F35)=6,IFERROR(FIND(UPPER(MID(F35,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F35,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F35,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F35,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F35,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F35,6,1)),\"\"))))),AND(F36<>\"\",NOT(AND(LEN(F36)=6,IFERROR(FIND(UPPER(MID(F36,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F36,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F36,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F36,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F36,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F36,6,1)),\"\"))))),AND(F37<>\"\",NOT(AND(LEN(F37)=6,IFERROR(FIND(UPPER(MID(F37,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F37,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F37,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F37,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F37,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F37,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--(F25:F37<>\"\"),--((COUNTIF($F$12:$F$15,F25:F37)+COUNTIF($F$17:$F$17,F25:F37)+COUNTIF($F$19:$F$22,F25:F37)+COUNTIF($F$25:$F$37,F25:F37)+COUNTIF($F$39:$F$46,F25:F37)+COUNTIF($F$48:$F$56,F25:F37))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND($H$38>=$E$38,OR($J$25=\"completed\",$J$25=\"comleted\")),\n\"Credit requirements fulfilled\",\nIF(AND($H$38<$E$38,$J$25=\"not completed\"),\nIF($E$38-$H$38=1,\"1 additional credit required\",($E$38-$H$38)&\" additional credits required\"),\n\"\"))))","v":"15 additional credits required"},"The list of KU GSIS Master's Major Courses for Cross-Major Recognition is ivailable on the KU GSIS homepage"]
[{"$nulls":8},{"$f":"IF(F26=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F26,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F26,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F26,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F26,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F26,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F27=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F27,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F27,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F27,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F27,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F27,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F28=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F28,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F28,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F28,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F28,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F28,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F29=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F29,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F29,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F29,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F29,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F29,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F30=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F30,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F30,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F30,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F30,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F30,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F31=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F31,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F31,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F31,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F31,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F31,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F32=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F32,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F32,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F32,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F32,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F32,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F33=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F33,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F33,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F33,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F33,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F33,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F34=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F34,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F34,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F34,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F34,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F34,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F35=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F35,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F35,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F35,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F35,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F35,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F36=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F36,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F36,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F36,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F36,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F36,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F37=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F37,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F37,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F37,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F37,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F37,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[null,"Subtotal (total Major elective credits)",null,null,15,null,null,{"$f":"IF(TRIM($C$7)=\"International Commerce\",SUMIF($I$25:$I$37,\"*IIC*\",$H$25:$H$37),IF(TRIM($C$7)=\"International Development&Cooperation\",SUMIF($I$25:$I$37,\"*IDC*\",$H$25:$H$37),IF(TRIM($C$7)=\"International Peace&Security\",SUMIF($I$25:$I$37,\"*IPS*\",$H$25:$H$37),IF(TRIM($C$7)=\"Area Studies\",SUMIF($I$25:$I$37,\"*IAS*\",$H$25:$H$37),0))))","v":0}]
[null,"Area Studies","Area Studies major","Completion of at least two IIC/IDC/IPS Major courses",6,null,null,null,{"$f":"IF(F39=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F39,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F39,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F39,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F39,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F39,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""},{"$f":"IF(OR(AND(ISNUMBER(SEARCH(\"Area\",$C$7)),SUMPRODUCT(--($F$43:$F$46<>\"\"))>0),AND(OR(ISNUMBER(SEARCH(\"Commerce\",$C$7)),ISNUMBER(SEARCH(\"Development\",$C$7)),ISNUMBER(SEARCH(\"Peace\",$C$7))),SUMPRODUCT(--($F$39:$F$42<>\"\"))>0)),\"This appears to have been written incorrectly. Please write it under your major\",IF(AND($H$47>=6,IF(ISNUMBER(SEARCH(\"Area\",$C$7)),SUMPRODUCT(--($F$39:$F$42<>\"\"),--($H$39:$H$42>0)),SUMPRODUCT(--($F$43:$F$46<>\"\"),--($H$43:$H$46>0)))>=2),\"completed\",\"not completed\"))","v":"not completed"},{"$f":"IF(OR(AND(F39<>\"\",NOT(AND(LEN(F39)=6,IFERROR(FIND(UPPER(MID(F39,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F39,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F39,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F39,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F39,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F39,6,1)),\"\"))))),AND(F40<>\"\",NOT(AND(LEN(F40)=6,IFERROR(FIND(UPPER(MID(F40,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F40,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,6,1)),\"\"))))),AND(F41<>\"\",NOT(AND(LEN(F41)=6,IFERROR(FIND(UPPER(MID(F41,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F41,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,6,1)),\"\"))))),AND(F42<>\"\",NOT(AND(LEN(F42)=6,IFERROR(FIND(UPPER(MID(F42,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F42,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,6,1)),\"\"))))),AND(F43<>\"\",NOT(AND(LEN(F43)=6,IFERROR(FIND(UPPER(MID(F43,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F43,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,6,1)),\"\"))))),AND(F44<>\"\",NOT(AND(LEN(F44)=6,IFERROR(FIND(UPPER(MID(F44,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F44,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,6,1)),\"\"))))),AND(F45<>\"\",NOT(AND(LEN(F45)=6,IFERROR(FIND(UPPER(MID(F45,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F45,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,6,1)),\"\"))))),AND(F46<>\"\",NOT(AND(LEN(F46)=6,IFERROR(FIND(UPPER(MID(F46,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F46,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F46,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F46,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F46,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--(F39:F46<>\"\"),--((COUNTIF($F$12:$F$15,F39:F46)+COUNTIF($F$17:$F$17,F39:F46)+COUNTIF($F$19:$F$22,F39:F46)+COUNTIF($F$25:$F$37,F39:F46)+COUNTIF($F$39:$F$46,F39:F46)+COUNTIF($F$48:$F$56,F39:F46))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(OR($J$39=\"completed\",$J$39=\"comleted\"),\"Credit requirements fulfilled\",IF($H$47<$E$47,IF($E$47-$H$47=1,\"1 additional credit required\",($E$47-$H$47)&\" additional credits required\"),\"\"))))","v":"6 additional credits required"},"* IIC, IDC or IPS Major: Must take Area Studies Courses\n* Area Studies Major: Must take IIC, IDC or IPS Courses\n\n* The list of KU GSIS Master's Major courses for Cross-Major Recognition is available on the KU GSIS homepage"]
[{"$nulls":8},{"$f":"IF(F40=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F40,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F40,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F40,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F40,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F40,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F41=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F41,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F41,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F41,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F41,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F41,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F42=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F42,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F42,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F42,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F42,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F42,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[null,null,"non-Area studies major","Completion of at least two IAS major courses",6,null,null,null,{"$f":"IF(F43=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F43,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F43,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F43,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F43,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F43,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F44=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F44,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F44,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F44,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F44,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F44,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F45=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F45,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F45,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F45,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F45,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F45,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F46=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F46,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F46,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F46,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F46,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F46,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[null,"소계 Subtotal (Area Studies)",null,null,6,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Area\",$C$7)),SUM($H$39:$H$42),IF(OR(ISNUMBER(SEARCH(\"Commerce\",$C$7)),ISNUMBER(SEARCH(\"Development\",$C$7)),ISNUMBER(SEARCH(\"Peace\",$C$7))),SUM($H$43:$H$46),0))","v":0}]
[null,"General\nElectives","GRA511","Introduction to Graduate Studies",1,{"$nulls":4},{"$f":"IF(AND(F48=C48,H48=1),\"completed\",\"not completed\")","v":"not completed"},{"$f":"IF(OR(AND(F48<>\"\",NOT(AND(LEN(F48)=6,IFERROR(FIND(UPPER(MID(F48,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F48,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F48,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F48,6,1)),\"\"))))),AND(F49<>\"\",NOT(AND(LEN(F49)=6,IFERROR(FIND(UPPER(MID(F49,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F49,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F49,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F49,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F49,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F49,6,1)),\"\"))))),AND(F50<>\"\",NOT(AND(LEN(F50)=6,IFERROR(FIND(UPPER(MID(F50,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F50,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F50,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F50,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F50,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F50,6,1)),\"\"))))),AND(F51<>\"\",NOT(AND(LEN(F51)=6,IFERROR(FIND(UPPER(MID(F51,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F51,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F51,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F51,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F51,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F51,6,1)),\"\"))))),AND(F52<>\"\",NOT(AND(LEN(F52)=6,IFERROR(FIND(UPPER(MID(F52,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F52,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F52,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F52,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F52,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F52,6,1)),\"\"))))),AND(F53<>\"\",NOT(AND(LEN(F53)=6,IFERROR(FIND(UPPER(MID(F53,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F53,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F53,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F53,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F53,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F53,6,1)),\"\"))))),AND(F54<>\"\",NOT(AND(LEN(F54)=6,IFERROR(FIND(UPPER(MID(F54,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F54,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F54,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F54,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F54,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F54,6,1)),\"\"))))),AND(F55<>\"\",NOT(AND(LEN(F55)=6,IFERROR(FIND(UPPER(MID(F55,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F55,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F55,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F55,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F55,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F55,6,1)),\"\"))))),AND(F56<>\"\",NOT(AND(LEN(F56)=6,IFERROR(FIND(UPPER(MID(F56,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F56,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F56,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F56,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F56,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F56,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--(F48:F56<>\"\"),--((COUNTIF($F$12:$F$15,F48:F56)+COUNTIF($F$17:$F$17,F48:F56)+COUNTIF($F$19:$F$22,F48:F56)+COUNTIF($F$25:$F$37,F48:F56)+COUNTIF($F$39:$F$46,F48:F56)+COUNTIF($F$48:$F$56,F48:F56))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND(SUMIFS($H$48:$H$56,$F$48:$F$56,\"<>GRA511\",$F$48:$F$56,\"<>\")>=3,COUNTIFS($F$48:$F$56,\"GRA511\",$H$48:$H$56,\">=1\")=0),\"You must complete GRA511 (Introduction to Graduate Studies). Failure to complete this course will result in ineligibility for graduation.\",IF(AND($H$57>=$E$57,$J$48=\"completed\"),\"Credit requirements fulfilled\",IF($H$57<$E$57,IF($E$57-$H$57=1,\"1 additional credit required\",($E$57-$H$57)&\" additional credits required\"),IF($J$48<>\"completed\",\"GRA511 must be completed\",\"\"))))))","v":"4 additional credits required"},"This course must be taken in the first semester; failure to do so will result in \n  ineligibility for graduation."]
[null,null,"Any Courses\nof following","IRC010/013/020/030/040/050/060/070/901/902",3,{"$nulls":4},{"$f":"IF(SUMIFS(H49:H56,F49:F56,\"<>\",F49:F56,\"<>GRA511\")>=3,\"completed\",\"not completed\")","v":"not completed"},null,"* International Students can take Korean Language courses of KU GSIS \n* Short-term Program, courses taught in English of KU General Graduate School/other GSIS in Korea, etc.\n\n* Up to 9 credits can be taken in languages other than English (tentative) \n\n* Up to 15 Credits of Core Electives and General Electives can be from:\n     - Other universities int'l Studies programs (general electives)\n     - Other KU Graduate programs (Core Electives and General Electives)\n\n* For General Elective, please consult with the KU GSIS Administration Office"]
[]
[null,null,null,"International Studies(IICxxx, IDCxxx, IPSxxx, IASxxx)"]
[]
[null,null,null,"(Intl' Students only) Korean Language courses of KU GSIS or Short-term Program, courses taught in English of KU General Graduate School/other GSIS in Korea"]
[]
[null,null,null,"Korean Studies (IKSxxx)"]
[]
[null,"소계 Subtotal (General electives)",null,null,4,null,null,{"$f":"IF(AND(LEN(F48)=6,IFERROR(FIND(UPPER(MID(F48,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F48,3)),\"\"))),IF(ISNUMBER(H48),H48,0),0)+IF(AND(LEN(F49)=6,IFERROR(FIND(UPPER(MID(F49,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F49,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F49,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F49,3)),\"\"))),IF(ISNUMBER(H49),H49,0),0)+IF(AND(LEN(F50)=6,IFERROR(FIND(UPPER(MID(F50,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F50,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F50,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F50,3)),\"\"))),IF(ISNUMBER(H50),H50,0),0)+IF(AND(LEN(F51)=6,IFERROR(FIND(UPPER(MID(F51,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F51,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F51,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F51,3)),\"\"))),IF(ISNUMBER(H51),H51,0),0)+IF(AND(LEN(F52)=6,IFERROR(FIND(UPPER(MID(F52,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F52,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F52,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F52,3)),\"\"))),IF(ISNUMBER(H52),H52,0),0)+IF(AND(LEN(F53)=6,IFERROR(FIND(UPPER(MID(F53,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F53,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F53,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F53,3)),\"\"))),IF(ISNUMBER(H53),H53,0),0)+IF(AND(LEN(F54)=6,IFERROR(FIND(UPPER(MID(F54,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F54,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F54,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F54,3)),\"\"))),IF(ISNUMBER(H54),H54,0),0)+IF(AND(LEN(F55)=6,IFERROR(FIND(UPPER(MID(F55,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F55,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F55,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F55,3)),\"\"))),IF(ISNUMBER(H55),H55,0),0)+IF(AND(LEN(F56)=6,IFERROR(FIND(UPPER(MID(F56,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F56,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F56,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F56,3)),\"\"))),IF(ISNUMBER(H56),H56,0),0)","v":0}]
[null,"총계 Total",null,null,{"$f":"E18+E23+E38+E47+E57+E16","v":40},null,null,{"$f":"SUM(H16,H18,H23,H38,H47,H57)","v":0},"A minimum of 40 credits must be earned, and all detailed requirements must also be satisfied"]

{"sheet":"Int Master nonthe","index":4,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,1,58,3],[58,8,58,11],[47,11,56,11],[49,3,50,3],[51,3,53,3],[54,3,56,3],[57,1,57,3],[57,5,57,6],[57,8,57,11],[46,1,56,1],[46,10,56,10],[47,2,56,2],[47,3,48,3],[47,4,56,4],[47,9,56,9],[37,11,44,11],[41,2,44,2],[41,3,44,3],[41,4,44,4],[45,1,45,3],[45,5,45,6],[45,8,45,11],[22,11,35,11],[36,1,36,3],[36,5,36,6],[36,8,36,11],[37,1,44,1],[37,2,40,2],[37,3,40,3],[37,4,40,4],[37,9,44,9],[37,10,44,10],[21,1,35,1],[22,2,35,2],[22,3,35,3],[22,4,35,4],[22,9,35,9],[22,10,35,10],[16,1,19,1],[16,9,19,9],[16,10,19,10],[16,11,19,11],[20,1,20,3],[20,5,20,6],[20,8,20,11],[15,1,15,3],[15,5,15,6],[15,8,15,11],[9,1,10,1],[9,2,9,4],[9,5,9,7],[9,8,10,8],[9,9,9,10],[9,11,10,11],[11,1,14,1],[11,4,14,4],[11,9,14,9],[11,10,14,10],[11,11,14,11],[7,2,7,3],[1,1,1,11],[3,1,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3]]}
[]
[null,"Master's Degree International Studies - Non-Thesis Track"]
[]
[null,"Student Information"]
[null,"Student No."]
[null,"Student Name"]
[null,"Major"]
[null,"Track"]
[]
[null,"Classification","Course you have to take",null,null,"Course you have taken",null,null,"Fields (only for major Courses)","Review Results",null,"비고\nNotes"]
[null,null,"Code","Name","Credit","Code","Name","Credit",null,"Status","Additional Credits Required"]
[null,"Required\nCourses 1","IRC010","Research Methods",3,{"$nulls":4},{"$f":"IF(SUMPRODUCT(--($F$12:$F$15=$C$12:$C$15),--($H$12:$H$15>=3))>=1,\"completed\",\"not completed\")","v":"not completed"},{"$f":"IF(OR(AND(F12<>\"\",NOT(AND(LEN(F12)=6,IFERROR(FIND(UPPER(MID(F12,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F12,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F12,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F12,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F12,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F12,6,1)),\"\"))))),AND(F13<>\"\",NOT(AND(LEN(F13)=6,IFERROR(FIND(UPPER(MID(F13,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F13,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F13,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F13,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F13,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F13,6,1)),\"\"))))),AND(F14<>\"\",NOT(AND(LEN(F14)=6,IFERROR(FIND(UPPER(MID(F14,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F14,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F14,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F14,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F14,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F14,6,1)),\"\"))))),AND(F15<>\"\",NOT(AND(LEN(F15)=6,IFERROR(FIND(UPPER(MID(F15,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F15,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F15,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F15,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F15,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F15,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--(F12:F15<>\"\"),--((COUNTIF($F$12:$F$15,F12:F15)+COUNTIF($F$17:$F$20,F12:F15)+COUNTIF($F$23:$F$36,F12:F15)+COUNTIF($F$38:$F$45,F12:F15)+COUNTIF($F$47:$F$57,F12:F15))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND($H$16>=$E$16,OR($J$12=\"completed\",$J$12=\"comleted\")),\n\"Credit requirements fulfilled\",\nIF(AND($H$16<$E$16,$J$12=\"not completed\"),\nIF($E$16-$H$16=1,\"1 additional credit required\",($E$16-$H$16)&\" additional credits required\"),\n\"\"))))","v":"3 additional credits required"},"The requirement is met if at least one of the four courses is completed."]
[null,null,"IRC013","Research Methods II"]
[null,null,"IRC015"," Qualitative Research Methods"]
[null,null,"IRC110","Statistics and Data Analysis"]
[null,"Subtotal (total required course1 credits)",null,null,3,null,null,{"$f":"IF(SUMPRODUCT(--($F$12:$F$15=$C$12:$C$15),--($H$12:$H$15>=3))>=1,3,0)","v":0}]
[null,"Core\nElectives","IRC020","International Business",3,{"$nulls":4},{"$f":"IF(AND($H$21>=9,SUMPRODUCT(--($F$17:$F$20=$C$17:$C$20),--($H$17:$H$20>0))>=3),\"completed\",\"not completed\")","v":"not completed"},{"$f":"IF(OR(AND(F17<>\"\",NOT(AND(LEN(F17)=6,IFERROR(FIND(UPPER(MID(F17,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F17,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F17,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F17,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F17,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F17,6,1)),\"\"))))),AND(F18<>\"\",NOT(AND(LEN(F18)=6,IFERROR(FIND(UPPER(MID(F18,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F18,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F18,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F18,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F18,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F18,6,1)),\"\"))))),AND(F19<>\"\",NOT(AND(LEN(F19)=6,IFERROR(FIND(UPPER(MID(F19,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F19,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F19,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F19,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F19,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F19,6,1)),\"\"))))),AND(F20<>\"\",NOT(AND(LEN(F20)=6,IFERROR(FIND(UPPER(MID(F20,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F20,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F20,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F20,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F20,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F20,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--(F17:F20<>\"\"),--((COUNTIF($F$12:$F$15,F17:F20)+COUNTIF($F$17:$F$20,F17:F20)+COUNTIF($F$23:$F$36,F17:F20)+COUNTIF($F$38:$F$45,F17:F20)+COUNTIF($F$47:$F$57,F17:F20))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND($H$21>=$E$21,OR($J$17=\"completed\",$J$17=\"comleted\")),\n\"Credit requirements fulfilled\",\nIF(AND($H$21<$E$21,$J$17=\"not completed\"),\nIF($E$21-$H$21=1,\"1 additional credit required\",($E$21-$H$21)&\" additional credits required\"),\n\"\"))))","v":"9 additional credits required"},"* Select and take 3 courses out of 4.\n* If a first-year student takes and passes the Common Course Exemption Examination, up to 6 credits may be waived (up to 9 credits for students in the BA-MA program). If core electives are waived, any resulting credit deficiency must be made up by completing additional major courses."]
[null,null,"IRC030","International Economics",3]
[null,null,"IRC040","World Politics",3]
[null,null,"IRC070","Introduction to International \nDevelopment and Cooperation",3]
[null,"Subtotal (total Core elective credits)",null,null,9,null,null,{"$f":"3*SUMPRODUCT(--(COUNTIF($C$17:$C$20,F17:F20)>0),--(H17:H20>=3))","v":0}]
[null,"Major\nCourses","Code","Name","Credit","Code","Name","Credit","Recognized field (Major Only)"]
[null,null,"IIC/IDC\n/IPS/IAS","Completion of at least five courses corresponding to the student’s major",21,null,null,null,{"$f":"IF(F23=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F23,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F23,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F23,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F23,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F23,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""},{"$f":"IF(AND($H$37>=21,IF(TRIM($C$7)=\"International Commerce\",COUNTIFS($I$23:$I$36,\"*IIC*\",$H$23:$H$36,\">0\"),IF(TRIM($C$7)=\"International Development&Cooperation\",COUNTIFS($I$23:$I$36,\"*IDC*\",$H$23:$H$36,\">0\"),IF(TRIM($C$7)=\"International Peace&Security\",COUNTIFS($I$23:$I$36,\"*IPS*\",$H$23:$H$36,\">0\"),IF(TRIM($C$7)=\"Area Studies\",COUNTIFS($I$23:$I$36,\"*IAS*\",$H$23:$H$36,\">0\"),0))))>=7),\"completed\",\"not completed\")","v":"not completed"},{"$f":"IF(OR(AND(F23<>\"\",NOT(AND(LEN(F23)=6,IFERROR(FIND(UPPER(MID(F23,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F23,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F23,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F23,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F23,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F23,6,1)),\"\"))))),AND(F24<>\"\",NOT(AND(LEN(F24)=6,IFERROR(FIND(UPPER(MID(F24,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F24,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F24,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F24,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F24,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F24,6,1)),\"\"))))),AND(F25<>\"\",NOT(AND(LEN(F25)=6,IFERROR(FIND(UPPER(MID(F25,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F25,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F25,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F25,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F25,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F25,6,1)),\"\"))))),AND(F26<>\"\",NOT(AND(LEN(F26)=6,IFERROR(FIND(UPPER(MID(F26,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F26,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F26,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F26,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F26,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F26,6,1)),\"\"))))),AND(F27<>\"\",NOT(AND(LEN(F27)=6,IFERROR(FIND(UPPER(MID(F27,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F27,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F27,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F27,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F27,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F27,6,1)),\"\"))))),AND(F28<>\"\",NOT(AND(LEN(F28)=6,IFERROR(FIND(UPPER(MID(F28,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F28,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F28,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F28,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F28,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F28,6,1)),\"\"))))),AND(F29<>\"\",NOT(AND(LEN(F29)=6,IFERROR(FIND(UPPER(MID(F29,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F29,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F29,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F29,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F29,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F29,6,1)),\"\"))))),AND(F30<>\"\",NOT(AND(LEN(F30)=6,IFERROR(FIND(UPPER(MID(F30,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F30,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F30,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F30,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F30,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F30,6,1)),\"\"))))),AND(F31<>\"\",NOT(AND(LEN(F31)=6,IFERROR(FIND(UPPER(MID(F31,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F31,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F31,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F31,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F31,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F31,6,1)),\"\"))))),AND(F32<>\"\",NOT(AND(LEN(F32)=6,IFERROR(FIND(UPPER(MID(F32,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F32,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F32,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F32,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F32,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F32,6,1)),\"\"))))),AND(F33<>\"\",NOT(AND(LEN(F33)=6,IFERROR(FIND(UPPER(MID(F33,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F33,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F33,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F33,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F33,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F33,6,1)),\"\"))))),AND(F34<>\"\",NOT(AND(LEN(F34)=6,IFERROR(FIND(UPPER(MID(F34,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F34,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F34,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F34,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F34,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F34,6,1)),\"\"))))),AND(F35<>\"\",NOT(AND(LEN(F35)=6,IFERROR(FIND(UPPER(MID(F35,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F35,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F35,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F35,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F35,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F35,6,1)),\"\"))))),AND(F36<>\"\",NOT(AND(LEN(F36)=6,IFERROR(FIND(UPPER(MID(F36,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F36,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F36,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F36,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F36,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F36,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--(F23:F36<>\"\"),--((COUNTIF($F$12:$F$15,F23:F36)+COUNTIF($F$17:$F$20,F23:F36)+COUNTIF($F$23:$F$36,F23:F36)+COUNTIF($F$38:$F$45,F23:F36)+COUNTIF($F$47:$F$57,F23:F36))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND($H$37>=$E$37,OR($J$23=\"completed\",$J$23=\"comleted\")),\n\"Credit requirements fulfilled\",\nIF(AND($H$37<$E$37,$J$23=\"not completed\"),\nIF($E$37-$H$37=1,\"1 additional credit required\",($E$37-$H$37)&\" additional credits required\"),\n\"\"))))","v":"21 additional credits required"},"The list of KU GSIS Master's Major Courses for Cross-Major Recognition is ivailable on the KU GSIS homepage"]
[{"$nulls":8},{"$f":"IF(F24=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F24,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F24,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F24,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F24,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F24,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F25=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F25,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F25,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F25,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F25,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F25,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F26=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F26,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F26,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F26,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F26,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F26,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F27=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F27,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F27,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F27,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F27,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F27,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F28=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F28,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F28,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F28,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F28,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F28,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F29=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F29,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F29,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F29,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F29,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F29,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F30=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F30,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F30,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F30,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F30,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F30,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F31=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F31,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F31,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F31,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F31,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F31,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F32=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F32,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F32,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F32,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F32,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F32,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F33=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F33,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F33,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F33,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F33,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F33,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F34=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F34,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F34,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F34,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F34,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F34,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F35=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F35,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F35,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F35,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F35,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F35,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F36=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F36,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F36,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F36,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F36,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F36,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[null,"Subtotal (total Major elective credits)",null,null,21,null,null,{"$f":"IF(TRIM($C$7)=\"International Commerce\",SUMIF($I$23:$I$36,\"*IIC*\",$H$23:$H$36),IF(TRIM($C$7)=\"International Development&Cooperation\",SUMIF($I$23:$I$36,\"*IDC*\",$H$23:$H$36),IF(TRIM($C$7)=\"International Peace&Security\",SUMIF($I$23:$I$36,\"*IPS*\",$H$23:$H$36),IF(TRIM($C$7)=\"Area Studies\",SUMIF($I$23:$I$36,\"*IAS*\",$H$23:$H$36),0))))","v":0}]
[null,"Area\nStudies","Area Studies\nmajor","Completion of at least two IIC/IDC/IPS Major courses",6,null,null,null,{"$f":"IF(F38=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F38,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F38,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F38,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F38,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F38,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""},{"$f":"IF(OR(AND(ISNUMBER(SEARCH(\"Area\",$C$7)),SUMPRODUCT(--($F$42:$F$45<>\"\"))>0),AND(OR(ISNUMBER(SEARCH(\"Commerce\",$C$7)),ISNUMBER(SEARCH(\"Development\",$C$7)),ISNUMBER(SEARCH(\"Peace\",$C$7))),SUMPRODUCT(--($F$38:$F$41<>\"\"))>0)),\"This appears to have been written incorrectly. Please write it under your major\",IF(AND($H$46>=6,IF(ISNUMBER(SEARCH(\"Area\",$C$7)),SUMPRODUCT(--($F$38:$F$41<>\"\"),--($H$38:$H$41>0)),SUMPRODUCT(--($F$42:$F$45<>\"\"),--($H$42:$H$45>0)))>=2),\"completed\",\"not completed\"))","v":"not completed"},{"$f":"IF(OR(AND(F38<>\"\",NOT(AND(LEN(F38)=6,IFERROR(FIND(UPPER(MID(F38,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F38,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F38,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F38,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F38,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F38,6,1)),\"\"))))),AND(F39<>\"\",NOT(AND(LEN(F39)=6,IFERROR(FIND(UPPER(MID(F39,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F39,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F39,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F39,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F39,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F39,6,1)),\"\"))))),AND(F40<>\"\",NOT(AND(LEN(F40)=6,IFERROR(FIND(UPPER(MID(F40,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F40,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F40,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F40,6,1)),\"\"))))),AND(F41<>\"\",NOT(AND(LEN(F41)=6,IFERROR(FIND(UPPER(MID(F41,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F41,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F41,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F41,6,1)),\"\"))))),AND(F42<>\"\",NOT(AND(LEN(F42)=6,IFERROR(FIND(UPPER(MID(F42,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F42,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F42,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F42,6,1)),\"\"))))),AND(F43<>\"\",NOT(AND(LEN(F43)=6,IFERROR(FIND(UPPER(MID(F43,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F43,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F43,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F43,6,1)),\"\"))))),AND(F44<>\"\",NOT(AND(LEN(F44)=6,IFERROR(FIND(UPPER(MID(F44,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F44,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F44,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F44,6,1)),\"\"))))),AND(F45<>\"\",NOT(AND(LEN(F45)=6,IFERROR(FIND(UPPER(MID(F45,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F45,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F45,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F45,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--(F38:F45<>\"\"),--((COUNTIF($F$12:$F$15,F38:F45)+COUNTIF($F$17:$F$20,F38:F45)+COUNTIF($F$23:$F$36,F38:F45)+COUNTIF($F$38:$F$45,F38:F45)+COUNTIF($F$47:$F$57,F38:F45))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(OR($J$38=\"completed\",$J$38=\"comleted\"),\"Credit requirements fulfilled\",IF($H$46<$E$46,IF($E$46-$H$46=1,\"1 additional credit required\",($E$46-$H$46)&\" additional credits required\"),\"\"))))","v":"6 additional credits required"},"* IIC, IDC or IPS Major: Must take Area Studies Courses\n* Area Studies Major: Must take IIC, IDC or IPS Courses\n\n* The list of KU GSIS Master's Major courses for Cross-Major Recognition is available on the KU GSIS homepage"]
[{"$nulls":8},{"$f":"IF(F39=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F39,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F39,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F39,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F39,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F39,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F40=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F40,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F40,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F40,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F40,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F40,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F41=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F41,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F41,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F41,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F41,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F41,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[null,null,"non-Area\nstudies major","Completion of at least two IAS major courses",6,null,null,null,{"$f":"IF(F42=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F42,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F42,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F42,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F42,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F42,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F43=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F43,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F43,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F43,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F43,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F43,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F44=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F44,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F44,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F44,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F44,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F44,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(F45=\"\",\"\",IFERROR(\"This course can be recognzied as a \"&VLOOKUP(F45,CrossList!$A$3:$H$315,4,FALSE)&\",\"&VLOOKUP(F45,CrossList!$A$3:$H$315,5,FALSE)&\",\"&VLOOKUP(F45,CrossList!$A$3:$H$315,6,FALSE)&\",\"&VLOOKUP(F45,CrossList!$A$3:$H$315,7,FALSE)&\",\"&VLOOKUP(F45,CrossList!$A$3:$H$315,8,FALSE)&\" fields\",\"\"))","v":""}]
[null,"소계 Subtotal (Area Studies)",null,null,6,null,null,{"$f":"IF(ISNUMBER(SEARCH(\"Area\",$C$7)),SUM($H$38:$H$41),IF(OR(ISNUMBER(SEARCH(\"Commerce\",$C$7)),ISNUMBER(SEARCH(\"Development\",$C$7)),ISNUMBER(SEARCH(\"Peace\",$C$7))),SUM($H$42:$H$45),0))","v":0}]
[null,"General\nElectives","GRA511","Introduction to Graduate Studies",1,{"$nulls":4},{"$f":"IF(AND(F47=C47,H47=1),\"completed\",\"not completed\")","v":"not completed"},{"$f":"IF(OR(AND(F47<>\"\",NOT(AND(LEN(F47)=6,IFERROR(FIND(UPPER(MID(F47,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F47,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F47,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F47,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F47,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F47,6,1)),\"\"))))),AND(F48<>\"\",NOT(AND(LEN(F48)=6,IFERROR(FIND(UPPER(MID(F48,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F48,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F48,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F48,6,1)),\"\"))))),AND(F49<>\"\",NOT(AND(LEN(F49)=6,IFERROR(FIND(UPPER(MID(F49,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F49,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F49,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F49,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F49,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F49,6,1)),\"\"))))),AND(F50<>\"\",NOT(AND(LEN(F50)=6,IFERROR(FIND(UPPER(MID(F50,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F50,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F50,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F50,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F50,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F50,6,1)),\"\"))))),AND(F51<>\"\",NOT(AND(LEN(F51)=6,IFERROR(FIND(UPPER(MID(F51,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F51,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F51,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F51,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F51,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F51,6,1)),\"\"))))),AND(F52<>\"\",NOT(AND(LEN(F52)=6,IFERROR(FIND(UPPER(MID(F52,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F52,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F52,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F52,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F52,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F52,6,1)),\"\"))))),AND(F53<>\"\",NOT(AND(LEN(F53)=6,IFERROR(FIND(UPPER(MID(F53,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F53,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F53,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F53,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F53,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F53,6,1)),\"\"))))),AND(F54<>\"\",NOT(AND(LEN(F54)=6,IFERROR(FIND(UPPER(MID(F54,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F54,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F54,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F54,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F54,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F54,6,1)),\"\"))))),AND(F55<>\"\",NOT(AND(LEN(F55)=6,IFERROR(FIND(UPPER(MID(F55,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F55,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F55,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F55,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F55,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F55,6,1)),\"\"))))),AND(F56<>\"\",NOT(AND(LEN(F56)=6,IFERROR(FIND(UPPER(MID(F56,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F56,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F56,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F56,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F56,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F56,6,1)),\"\"))))),AND(F57<>\"\",NOT(AND(LEN(F57)=6,IFERROR(FIND(UPPER(MID(F57,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F57,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F57,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(MID(F57,4,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F57,5,1)),\"\")),ISNUMBER(IFERROR(VALUE(MID(F57,6,1)),\"\")))))),\"Course code input error\",IF(SUMPRODUCT(--(F47:F57<>\"\"),--((COUNTIF($F$12:$F$15,F47:F57)+COUNTIF($F$17:$F$20,F47:F57)+COUNTIF($F$23:$F$36,F47:F57)+COUNTIF($F$38:$F$45,F47:F57)+COUNTIF($F$47:$F$57,F47:F57))>1))>0,\"The same course has been entered more than once. Graduation assessment cannot be completed.\",IF(AND(SUMIFS($H$47:$H$57,$F$47:$F$57,\"<>GRA511\",$F$47:$F$57,\"<>\")>=3,COUNTIFS($F$47:$F$57,\"GRA511\",$H$47:$H$57,\">=1\")=0),\"You must complete GRA511 (Introduction to Graduate Studies). Failure to complete this course will result in ineligibility for graduation.\",IF(AND($H$58>=$E$58,$J$47=\"completed\"),\"Credit requirements fulfilled\",IF($H$58<$E$58,IF($E$58-$H$58=1,\"1 additional credit required\",($E$58-$H$58)&\" additional credits required\"),IF($J$47<>\"completed\",\"GRA511 must be completed\",\"\"))))))","v":"4 additional credits required"},"This course must be taken in the first semester; failure to do so will result in \n  ineligibility for graduation."]
[null,null,"Any Courses\nof following","IRC010/013/020/030/040/050/060/070/901/902",3,{"$nulls":4},{"$f":"IF(SUMIFS(H48:H57,F48:F57,\"<>\",F48:F57,\"<>GRA511\")>=3,\"completed\",\"not completed\")","v":"not completed"},null,"* International Students can take Korean Language courses of KU GSIS \n* Short-term Program, courses taught in English of KU General Graduate School/other GSIS in Korea, etc.\n\n* Up to 9 credits can be taken in languages other than English (tentative) \n\n* Up to 15 Credits of Core Electives and General Electives can be from:\n     - Other universities int'l Studies programs (general electives)\n     - Other KU Graduate programs (Core Electives and General Electives)\n\n* For General Elective, please consult with the KU GSIS Administration Office"]
[]
[null,null,null,"International Studies(IICxxx, IDCxxx, IPSxxx, IASxxx)"]
[]
[null,null,null,"(Intl' Students only) Korean Language courses of KU GSIS or Short-term Program, courses taught in English of KU General Graduate School/other GSIS in Korea"]
[]
[]
[null,null,null,"Korean Studies (IKSxxx)"]
[]
[]
[null,"소계 Subtotal (General electives)",null,null,4,null,null,{"$f":"IF(AND(LEN(F47)=6,IFERROR(FIND(UPPER(MID(F47,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F47,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F47,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F47,3)),\"\"))),IF(ISNUMBER(H47),H47,0),0)+IF(AND(LEN(F48)=6,IFERROR(FIND(UPPER(MID(F48,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F48,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F48,3)),\"\"))),IF(ISNUMBER(H48),H48,0),0)+IF(AND(LEN(F49)=6,IFERROR(FIND(UPPER(MID(F49,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F49,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F49,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F49,3)),\"\"))),IF(ISNUMBER(H49),H49,0),0)+IF(AND(LEN(F50)=6,IFERROR(FIND(UPPER(MID(F50,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F50,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F50,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F50,3)),\"\"))),IF(ISNUMBER(H50),H50,0),0)+IF(AND(LEN(F51)=6,IFERROR(FIND(UPPER(MID(F51,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F51,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F51,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F51,3)),\"\"))),IF(ISNUMBER(H51),H51,0),0)+IF(AND(LEN(F52)=6,IFERROR(FIND(UPPER(MID(F52,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F52,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F52,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F52,3)),\"\"))),IF(ISNUMBER(H52),H52,0),0)+IF(AND(LEN(F53)=6,IFERROR(FIND(UPPER(MID(F53,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F53,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F53,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F53,3)),\"\"))),IF(ISNUMBER(H53),H53,0),0)+IF(AND(LEN(F54)=6,IFERROR(FIND(UPPER(MID(F54,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F54,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F54,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F54,3)),\"\"))),IF(ISNUMBER(H54),H54,0),0)+IF(AND(LEN(F55)=6,IFERROR(FIND(UPPER(MID(F55,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F55,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F55,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F55,3)),\"\"))),IF(ISNUMBER(H55),H55,0),0)+IF(AND(LEN(F56)=6,IFERROR(FIND(UPPER(MID(F56,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F56,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F56,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F56,3)),\"\"))),IF(ISNUMBER(H56),H56,0),0)+IF(AND(LEN(F57)=6,IFERROR(FIND(UPPER(MID(F57,1,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F57,2,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,IFERROR(FIND(UPPER(MID(F57,3,1)),\"ABCDEFGHIJKLMNOPQRSTUVWXYZ\"),0)>0,ISNUMBER(IFERROR(VALUE(RIGHT(F57,3)),\"\"))),IF(ISNUMBER(H57),H57,0),0)","v":0}]
[null,"총계 Total",null,null,{"$f":"SUM(E58,E46,E37,E21,E16)","v":43},null,null,{"$f":"SUM(H58,H46,H37,H21,H16)","v":0},"A minimum of 43 credits must be earned, and all detailed requirements must also be satisfied"]