{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Categorized View","APS View","Flowchart View","Critical Courses"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Categorized View","index":0,"n_rows":47,"n_cols":23,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,2,4,5],[4,8,4,10]]}
[null,null,null,null,null,null,null,null,null,"Categorized View (Fill Green Area)"]
[null,null,null,"Instructions:",null,"1. Input Grade or T (if transferred from previous school), R (currently enrolled), L (planned in the next term) under grade column."]
[null,null,null,null,null,"2. Input the semester information formatted as 20xx-s, where s is 1 if spring, 2 if summer, and 3 if fall. (For exmaple, if it is Fall 2020, input 2020-3.) "]
[null,null,null,null,null,"3. After input all the information, click 'Run'. Please make sure to check all three certifications are checked before submission. Save the file as BSSE_(ID Number)_(Name).xlsm and submit it."]
[null,"Name:",null,null,null,null,null,"800#:"]
[]
[null,"Course",null,"Credit ","Grade","Semester","Remark",null,"Course",null,"Credit ","Grade","Semester","Remark",null,"Course",null,"Credit ","Grade","Semester","Remark"]
[]
[]
[null,"Writing, Theme, CTCM (18 Credit Hours)",null,null,null,null,null,null,"Systems Engineering (48 Credit Hours)",null,null,null,null,null,null,"Mathematics & Mathematics Elective (18 Credit Hours)"]
[null,"UWRT/WRDS","1103/4",3,"-",null,null,"C","ENGR",1201,2,"-",null,null,"C","MATH",1241,3,"-"]
[null,"XXXX",1501,3,"-",null,null,"C","ENGR",1202,2,"-",null,null,"C","MATH",1242,3,"-"]
[null,"XXXX",1502,3,"-",null,null,null,"ENGR",3295,1,"-",null,null,null,"MATH",2241,3,"-"]
[null,"XXXX",1511,3,"-",null,null,"S","*SEGR",3201,3,"-",null,null,"C","MATH",2164,3,"-"]
[null,"XXXX",1512,3,"-",null,null,"S","*SEGR",3202,3,"-",null,null,"C","STAT",3128,3,"-"]
[null,"CTCM",2530,3,"-",null,null,"C","SEGR",2105,3,"-",null,null,null,"MATH",2171,3,"-"]
[null,null,"Total:",{"$f":"SUM(D11:D16)","v":18},{"$f":"SUM(SUMIFS(D11:D16,E11:E16,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))","v":0},null,null,null,"SEGR",2106,3,"-",null,null,null,null,"Total:",{"$f":"SUM(R11:R16)","v":18},{"$f":"+SUM(SUMIFS(R11:R12,S11:S12,{\"A\",\"B\",\"C\",\"T\",\"H\"}))+SUM(SUMIFS(R13,S13,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))+SUM(SUMIFS(R14:R15,S14:S15,{\"A\",\"B\",\"C\",\"T\",\"H\"}))+SUM(SUMIFS(R16,S16,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))","v":0}]
[null,null,null,null,null,null,null,null,"SEGR",2110,3,"-"]
[null,"Basic Science & Science Elective (15 Credit Hours) ",null,null,null,null,null,"C","SEGR",3102,3,"-",null,null,null,"Technical Electives (9 Credit Hours, at most 3 hours non-engineering)"]
[null,"Input course prefix and number of your science elective course in the first line",null,null,null,null,null,null,"SEGR",3105,3,"-",null,null,"E",null,null,3,"-",null,null,null,"SEGR"]
[null,null,null,3,null,null,null,"C","SEGR",3107,3,"-",null,null,"E",null,null,3,"-",null,null,null,"CEGR"]
["C","PHYS",2101,3,"-",null,null,null,"SEGR",3110,3,"-",null,null,null,null,null,3,"-",null,null,null,"ECGR"]
[null,"PHYS","2101L",1,"-",null,null,null,"SEGR",3111,3,"-",null,null,null,null,"Total:",{"$f":"SUM(R20:R22)","v":9},{"$f":"+SUM(SUMIFS(R20:R22,S20:S22,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))","v":0},null,null,null,"MEGR"]
[null,"PHYS ",2102,3,"-",null,null,"S","*SEGR",4114,3,"-"]
[null,"PHYS ","2102L",1,"-",null,null,null,"SEGR",4141,3,"-",null,null,null,"Concentration/Add'l Tech Electives (12 Credit Hours, 3xxx, 4xxx courses only)"]
[null,"CHEM",1251,3,"-",null,null,"S","*SEGR",4170,3,"-",null,null,null,null,null,3]
[null,"CHEM","1251L",1,"-",null,null,"C","SEGR ",3290,2,"-",null,null,null,null,null,3]
[null,null,"Total:",{"$f":"SUM(D21:D27)","v":15},{"$f":"SUM(SUMIFS(D21,E21,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))+SUM(SUMIFS(D22,E22,{\"A\",\"B\",\"C\",\"T\",\"H\"}))+SUM(SUMIFS(D23:D27,E23:E27,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))","v":0},null,null,null,"SEGR",3291,2,"-",null,null,null,null,null,3]
[null,"-",null,null,null,null,null,null,null,"Total:",{"$f":"SUM(K11:K28)","v":48},{"$f":"SUM(SUMIFS(K11:K12,L11:L12,{\"A\",\"B\",\"C\",\"T\",\"H\"}))+SUM(SUMIFS(K13:K15,L13:L15,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))+SUM(SUMIFS(K16,L16,{\"A\",\"B\",\"C\",\"T\",\"H\"}))+SUM(SUMIFS(K17:K18,L17:L18,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))+SUM(SUMIFS(K19,L19,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))+SUM(SUMIFS(K20,L20,{\"A\",\"B\",\"C\",\"T\",\"H\"}))+SUM(SUMIFS(K21,L21,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))+SUM(SUMIFS(K22:K26,L22:L26,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))+SUM(SUMIFS(K27,L27,{\"A\",\"B\",\"C\",\"T\",\"H\"}))+SUM(SUMIFS(K28,L28,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))","v":0},null,null,null,null,null,3]
[null,"R",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(R26:R29)","v":12},{"$f":"+SUM(SUMIFS(R26:R29,S26:S29,{\"A\",\"B\",\"C\",\"D\",\"T\",\"P\",\"H\"}))","v":0}]
[null,"L",null,null,null,null,null,null,null,"Required Hours:",{"$f":"SUM(D17,D28,K29,R17,R23,R30)","v":120}]
[null,"A","12F",null,null,null,null,null,null,"Completed Hours:",{"$f":"SUM(E17,E28,L29,S17,S23,S30)","v":0}]
[null,"B","12Su",null,null,null,null,null,null,"Expected Hours:",{"$f":"SUMIF($E$11:$E$16,\"R\",$D$11:$D$16)+SUMIF($E$21:$E$27,\"R\",$D$21:$D$27)+SUMIF($L$11:$L$28,\"R\",$K$11:$K$28)+SUMIF($S$11:$S$16,\"R\",$R$11:$R$16)+SUMIF($S$20:$S$22,\"R\",$R$20:$R$22)+SUMIF($S$26:$S$29,\"R\",$R$26:$R$29)+$K$32","v":0}]
[null,"C","12Sp"]
[null,"D","11F"]
[null,"F","11Su"]
[null,"T","11Sp"]
[null,"W","10F"]
[null,"P","10Su"]
["(ctr-r, abc)","H","10Sp"]
[null,null,"09F"]
[null,null,"09Su"]
[null,null,"09Sp"]
[null,null,"08F"]
[null,null,"08Su"]
[null,null,"08Sp"]
[null,null,"Earlier"]

{"sheet":"APS View","index":1,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,6],[18,1,18,3],[18,4,18,6],[7,1,7,6],[8,1,8,3],[8,4,8,6],[17,1,17,6],[2,2,2,3],[2,5,2,6],[37,1,37,6],[38,1,38,3],[38,4,38,6],[27,1,27,6],[28,1,28,3],[28,4,28,6]]}
[null,"APS View"]
[]
[null,"Name:",null,null,"ID:"]
[]
[null,null,"Students are responsible for checking and fulfilling prerequisites."]
[]
[]
[null,"Freshman Year",null,null,null,null,null,null,"Energy Systems Concentration"]
[null,"I",null,null,"II",null,null,null,"3 from {SEGR 4961, 4962, 4963, 4964}"]
[null,"Course ID","Course Name","Grade","Course ID","Course Name","Grade",null,"1 from {above courses} or {SEGR 4201, 4202, 4203}"]
[null,"ENGR 1201","Intro. to Engr. I","-","ENGR 1202","Intro. to Engr. II","-"]
[null,"MATH 1241","Calculus I","-","PHYS 2101","Physics I","-",null,"Color Legend"]
[null,"WRDS 1103/4","Writing","-","PHYS 2101L","Physics I Lab","-"]
[null,"XXXX 1501","Global Social Science","-","MATH 1242","Calculus II","-",null,null,"Completed"]
[null,{"$f":"CONCATENATE('Categorized View'!B21,\" \",'Categorized View'!C21)","v":" "},"Science Elective",null,"MATH 2164","Matrices & Linear Algebra","-"]
[null,null,null,null,null,null,null,null,null,"Planned"]
[]
[null,"Sophomore Year",null,null,null,null,null,null,null,"Need Attention for Senior Design"]
[null,"I",null,null,"II"]
[null,"Course ID","Course Name","Grade","Course ID","Course Name","Grade",null,null,"Incomplete"]
[null,"PHYS 2102","Physics II","-","SEGR 2110","Systems Engr. Concepts","-"]
[null,"PHYS 2102L","Physics II Lab","-","STAT 3128","Prob. & Stat. for Engr.","-"]
[null,"SEGR 2105","Comp. Meth. for Sys. Engr.","-","CHEM 1251","Principles of Chemistry I","-"]
[null,"MATH 2241","Calculus III","-","CHEM 1251L","Principles of Chemistry Lab. I","-"]
[null,"XXXX 1502","Local Social Science","-","CTCM 2530","Critical Thinking and Comm.","-"]
[null,"SEGR 2106","Engr. Economic Analysis","-",{"$f":"CONCATENATE('Categorized View'!P20, \" \",'Categorized View'!Q20)","v":" "},"Technical Elective","-"]
[]
[null,"Junior Year"]
[null,"I",null,null,"II"]
[null,"Course ID","Course Name","Grade","Course ID","Course Name","Grade"]
[null,"XXXX 1511","Global Arts/Humanities","-","SEGR 3102","Sys. Simul. Modeling & Anal.","-"]
[null,"SEGR 3105","Comp. Meth. for Sys. Engr. II","-","SEGR 3111","Project Management","-"]
[null,"SEGR 3107","Decision and Risk Analysis","-","MATH 2171","Differential Equations","-"]
[null,"SEGR 3201","Operations Res.-Deterministic","-","SEGR 3202","Operations Res.-Probabilistic","-"]
[null,{"$f":"CONCATENATE('Categorized View'!P26, \" \",'Categorized View'!Q26)","v":" "},"Concentration Course",null,"SEGR 3110","System Design and Deployment","-"]
[null,null,null,null,null,"Concentration Course"]
[]
[null,"Senior Year"]
[null,"I",null,null,"II"]
[null,"Course ID","Course Name","Grade","Course ID","Course Name","Grade"]
[null,"SEGR 3290","Sys. Design Project I","-","SEGR 3291","Design Project II","-"]
[null,"ENGR 3295","Prof. Development","-","SEGR 4170","Total Quality Systems","-"]
[null,"SEGR 4114","Production Control Systems","-","XXXX 1512","Local Arts/Humanites","-"]
[null,"SEGR 4141","Engr. Experimental Design","-",null,"Concentration Course","-"]
[null,null,"Concentration Course",null," ","Technical Elective"]
[null,null,"Technical Elective","-"]
[]
[null,"-"]
[null,"A"]
[null,"B"]
[null,"C"]
[null,"D"]
[null,"F"]
[null,"W"]
[null,"T"]

{"sheet":"Flowchart View","index":2,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,2,2,4],[2,7,2,9]]}
[null,null,null,null,null,null,null,"Flowchart View"]
[]
[null,"Name:",null,null,null,null,"ID Number:"]

{"sheet":"Critical Courses","index":3,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,2,2,4],[2,7,2,9]]}
[null,null,null,null,null,null,"Critical Path View"]
[]
[null,"Name:",null,null,null,null,"ID Number:"]