{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["med prep","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"med prep","index":0,"n_rows":96,"n_cols":20,"rows_kept":96,"cut":false,"hidden":false,"merged":[[0,3,0,15],[1,3,1,15],[2,3,2,15],[5,0,5,1],[5,2,5,10],[5,11,5,14],[5,15,5,18],[2,16,2,17],[4,0,4,1],[4,2,4,10],[4,11,4,14],[86,3,86,15],[87,3,87,15],[89,2,89,8],[89,15,89,18],[4,15,4,18],[81,1,81,2],[81,3,81,4],[85,3,85,15],[80,1,80,2],[80,3,80,4],[90,2,90,8],[90,15,90,18],[87,16,87,17],[95,3,95,4],[95,6,95,8],[95,9,95,10],[95,11,95,15],[96,3,96,4],[96,6,96,8],[96,9,96,10],[96,11,96,15],[97,3,97,4],[97,6,97,8],[97,9,97,10],[97,11,97,15],[98,3,98,4],[98,6,98,8],[98,9,98,10],[98,11,98,15],[99,3,99,4],[99,6,99,8],[99,9,99,10],[99,11,99,15],[100,3,100,4],[100,6,100,8],[100,9,100,10],[100,11,100,15],[101,3,101,4],[101,6,101,8],[101,9,101,10],[101,11,101,15],[102,3,102,4],[102,6,102,8],[102,9,102,10],[102,11,102,15],[103,3,103,4],[103,6,103,8],[103,9,103,10],[103,11,103,15],[104,3,104,4],[104,6,104,8],[104,9,104,10],[104,11,104,15],[105,3,105,4],[105,6,105,8],[105,9,105,10],[105,11,105,15],[106,3,106,4],[106,6,106,8],[106,9,106,10],[106,11,106,15],[107,3,107,4],[107,6,107,8],[107,9,107,10],[107,11,107,15],[110,3,110,4],[110,6,110,8],[110,9,110,10],[110,11,110,15],[108,3,108,4],[108,6,108,8],[108,9,108,10],[108,11,108,15],[109,3,109,4],[109,6,109,8],[109,9,109,10],[109,11,109,15]]}
[null,null,null,"Department of Mechanical and Aerospace Engineering"]
[null,null,null,"2018-2019"]
[null,null,null,"Medical Preparation Option in Mechanical Engineering",null,null,null,null,null,null,null,null,null,null,null,null,"Credits =",null,{"$f":"SUM(A11:A17,H11:H17,H22:H28,A22:A28,A33:A39,H33:H39,H44:H50,A44:A50)","v":134}]
[]
["Student Name",null,null,null,null,null,null,null,null,null,null,"GWID"]
["Advisor",null,null,null,null,null,null,null,null,null,null,"Admit Date"]
[]
["FALL",null,null,null,null,null,null,"SPRING"]
["First Semester",null,null,"Credits = ",{"$f":"SUM(A11:A17)","v":17},null,null,"Second Semester",null,null,"Credits = ",{"$f":"SUM(H11:H17)","v":17},null,null,null,"NOT FOR DEGREE"]
["Hr","Course","Description","Grd","Date",null,null,"Hr","Course","Description","Grd","Date",null,null,"Hr","Course","Description","Grd","Date"]
[4,"UW 1020",null,null,null,{"$f":"IF(ISNUMBER(D11),D11*A11,IF(ISBLANK(D11),0,VLOOKUP(D11,$A$52:$B$79,2,FALSE)*A11))","v":0},null,4,"CHEM 1112",null,null,null,{"$f":"IF(ISNUMBER(K11),K11*H11,IF(ISBLANK(K11),0,VLOOKUP(K11,$A$52:$B$79,2,FALSE)*H11))","v":0},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(R11),R11*O11,IF(ISBLANK(R11),0,VLOOKUP(R11,$A$52:$B$79,2,FALSE)*O11))","v":0}]
[1,"MAE 1001",null,null,null,{"$f":"IF(ISNUMBER(D12),D12*A12,IF(ISBLANK(D12),0,VLOOKUP(D12,$A$52:$B$79,2,FALSE)*A12))","v":0},null,3,"MATH 1232",null,null,null,{"$f":"IF(ISNUMBER(K12),K12*H12,IF(ISBLANK(K12),0,VLOOKUP(K12,$A$52:$B$79,2,FALSE)*H12))","v":0},null,null,null,null,null,null,0]
[1,"SEAS 1001",null,null,null,{"$f":"IF(ISNUMBER(D13),D13*A13,IF(ISBLANK(D13),0,VLOOKUP(D13,$A$52:$B$79,2,FALSE)*A13))","v":0},null,3,"MATH 2184",null,null,null,{"$f":"IF(ISNUMBER(K13),K13*H13,IF(ISBLANK(K13),0,VLOOKUP(K13,$A$52:$B$79,2,FALSE)*H13))","v":0},null,null,null,null,null,null,0]
[4,"CHEM 1111",null,null,null,{"$f":"IF(ISNUMBER(D14),D14*A14,IF(ISBLANK(D14),0,VLOOKUP(D14,$A$52:$B$79,2,FALSE)*A14))","v":0},null,3,"CSI 1121",null,null,null,{"$f":"IF(ISNUMBER(K14),K14*H14,IF(ISBLANK(K14),0,VLOOKUP(K14,$A$52:$B$79,2,FALSE)*H14))","v":0},null,null,null,null,null,null,0]
[3,"MATH 1231",null,null,null,{"$f":"IF(ISNUMBER(D15),D15*A15,IF(ISBLANK(D15),0,VLOOKUP(D15,$A$52:$B$79,2,FALSE)*A15))","v":0},null,4,"PHYS 1021",null,null,null,{"$f":"IF(ISNUMBER(K15),K15*H15,IF(ISBLANK(K15),0,VLOOKUP(K15,$A$52:$B$79,2,FALSE)*H15))","v":0},null,null,null,null,null,null,0]
[3,"BISC 1115",null,null,null,{"$f":"IF(ISNUMBER(D16),D16*A16,IF(ISBLANK(D16),0,VLOOKUP(D16,$A$52:$B$79,2,FALSE)*A16))","v":0},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(K16),K16*H16,IF(ISBLANK(K16),0,VLOOKUP(K16,$A$52:$B$79,2,FALSE)*H16))","v":0},null,null,null,null,null,null,0]
[1,"BISC 1125",null,null,null,{"$f":"IF(ISNUMBER(D17),D17*A17,IF(ISBLANK(D17),0,VLOOKUP(D17,$A$52:$B$79,2,FALSE)*A17))","v":0},null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["FALL",null,null,null,null,null,null,"SPRING",null,null,null,null,null,null,null,null,null,null,null,0]
["Third Semester",null,null,"Credits = ",{"$f":"SUM(A22:A28)","v":20},null,null,"Fourth Semester",null,null,"Credits = ",{"$f":"SUM(H22:H28)","v":16},null,null,null,null,null,null,null,0]
["Hr","Course","Description","Grd","Date",null,null,"Hr","Course","Description","Grd","Date",null,null,null,null,null,null,null,0]
[3,"APSC 2057",null,null,null,{"$f":"IF(ISNUMBER(D22),D22*A22,IF(ISBLANK(D22),0,VLOOKUP(D22,$A$52:$B$79,2,FALSE)*A22))","v":0},null,3,"APSC 2058",null,null,null,{"$f":"IF(ISNUMBER(K22),K22*H22,IF(ISBLANK(K22),0,VLOOKUP(K22,$A$52:$B$79,2,FALSE)*H22))","v":0},null,null,null,null,null,null,0]
[3,"APSC 2113",null,null,null,{"$f":"IF(ISNUMBER(D23),D23*A23,IF(ISBLANK(D23),0,VLOOKUP(D23,$A$52:$B$79,2,FALSE)*A23))","v":0},null,4,"ECE 2110",null,null,null,{"$f":"IF(ISNUMBER(K23),K23*H23,IF(ISBLANK(K23),0,VLOOKUP(K23,$A$52:$B$79,2,FALSE)*H23))","v":0},null,null,null,null,null,null,0]
[3,"MAE 2117",null,null,null,{"$f":"IF(ISNUMBER(D24),D24*A24,IF(ISBLANK(D24),0,VLOOKUP(D24,$A$52:$B$79,2,FALSE)*A24))","v":0},null,3,"MAE 2131",null,null,null,{"$f":"IF(ISNUMBER(K24),K24*H24,IF(ISBLANK(K24),0,VLOOKUP(K24,$A$52:$B$79,2,FALSE)*H24))","v":0},null,null,null,null,null,null,0]
[3,"MATH 2233",null,null,null,{"$f":"IF(ISNUMBER(D25),D25*A25,IF(ISBLANK(D25),0,VLOOKUP(D25,$A$52:$B$79,2,FALSE)*A25))","v":0},null,3,"CE 2220",null,null,null,{"$f":"IF(ISNUMBER(K25),K25*H25,IF(ISBLANK(K25),0,VLOOKUP(K25,$A$52:$B$79,2,FALSE)*H25))","v":0},null,null,null,null,null,null,0]
[4,"PHYS 1022",null,null,null,{"$f":"IF(ISNUMBER(D26),D26*A26,IF(ISBLANK(D26),0,VLOOKUP(D26,$A$52:$B$79,2,FALSE)*A26))","v":0},null,3,"MAE 1004",null,null,null,{"$f":"IF(ISNUMBER(K26),K26*H26,IF(ISBLANK(K26),0,VLOOKUP(K26,$A$52:$B$79,2,FALSE)*H26))","v":0},null,null,null,null,null,null,0]
[3,"BISC 1116",null,null,null,{"$f":"IF(ISNUMBER(D27),D27*A27,IF(ISBLANK(D27),0,VLOOKUP(D27,$A$52:$B$79,2,FALSE)*A27))","v":0},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(K27),K27*H27,IF(ISBLANK(K27),0,VLOOKUP(K27,$A$52:$B$79,2,FALSE)*H27))","v":0}]
[1,"BISC 1126",null,null,null,{"$f":"IF(ISNUMBER(D28),D28*A28,IF(ISBLANK(D28),0,VLOOKUP(D28,$A$52:$B$79,2,FALSE)*A28))","v":0},null,null,null,null,null,null,0]
[]
["FALL",null,null,null,null,null,null,"SPRING"]
["Fifth Semester",null,null,"Credits = ",{"$f":"SUM(A33:A39)","v":16},null,null,"Sixth Semester",null,null,"Credits = ",{"$f":"SUM(H33:H39)","v":16}]
["Hr","Course","Description","Grd","Date",null,null,"Hr","Course","Description","Grd","Date"]
[3,"CHEM 2151",null,null,null,{"$f":"IF(ISNUMBER(D33),D33*A33,IF(ISBLANK(D33),0,VLOOKUP(D33,$A$52:$B$79,2,FALSE)*A33))","v":0},null,3,"CHEM 2152",null,null,null,{"$f":"IF(ISNUMBER(K33),K33*H33,IF(ISBLANK(K33),0,VLOOKUP(K33,$A$52:$B$79,2,FALSE)*H33))","v":0}]
[1,"CHEM 2153",null,null,null,{"$f":"IF(ISNUMBER(D34),D34*A34,IF(ISBLANK(D34),0,VLOOKUP(D34,$A$52:$B$79,2,FALSE)*A34))","v":0},null,1,"CHEM 2154",null,null,null,{"$f":"IF(ISNUMBER(K34),K34*H34,IF(ISBLANK(K34),0,VLOOKUP(K34,$A$52:$B$79,2,FALSE)*H34))","v":0}]
[3,"MAE 3126",null,null,null,{"$f":"IF(ISNUMBER(D35),D35*A35,IF(ISBLANK(D35),0,VLOOKUP(D35,$A$52:$B$79,2,FALSE)*A35))","v":0},null,3,"MAE 3120",null,null,null,{"$f":"IF(ISNUMBER(K35),K35*H35,IF(ISBLANK(K35),0,VLOOKUP(K35,$A$52:$B$79,2,FALSE)*H35))","v":0}]
[3,"APSC 3115",null,null,null,{"$f":"IF(ISNUMBER(D36),D36*A36,IF(ISBLANK(D36),0,VLOOKUP(D36,$A$52:$B$79,2,FALSE)*A36))","v":0},null,3,"MAE 3134",null,null,null,{"$f":"IF(ISNUMBER(K36),K36*H36,IF(ISBLANK(K36),0,VLOOKUP(K36,$A$52:$B$79,2,FALSE)*H36))","v":0}]
[3,"MAE 3191",null,null,null,{"$f":"IF(ISNUMBER(D37),D37*A37,IF(ISBLANK(D37),0,VLOOKUP(D37,$A$52:$B$79,2,FALSE)*A37))","v":0},null,3,"MAE 3193",null,null,null,{"$f":"IF(ISNUMBER(K37),K37*H37,IF(ISBLANK(K37),0,VLOOKUP(K37,$A$52:$B$79,2,FALSE)*H37))","v":0}]
[3,"H/SS 1","PSYC 1001",null,null,{"$f":"IF(ISNUMBER(D38),D38*A38,IF(ISBLANK(D38),0,VLOOKUP(D38,$A$52:$B$79,2,FALSE)*A38))","v":0},null,3,"MAE 3187",null,null,null,{"$f":"IF(ISNUMBER(K38),K38*H38,IF(ISBLANK(K38),0,VLOOKUP(K38,$A$52:$B$79,2,FALSE)*H38))","v":0}]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(D39),D39*A39,IF(ISBLANK(D39),0,VLOOKUP(D39,$A$52:$B$79,2,FALSE)*A39))","v":0},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(K39),K39*H39,IF(ISBLANK(K39),0,VLOOKUP(K39,$A$52:$B$79,2,FALSE)*H39))","v":0}]
[]
["FALL",null,null,null,null,null,null,"SPRING"]
["Seventh Semester",null,null,"Credits = ",{"$f":"SUM(A44:A50)","v":16},null,null,"Eighth Semester",null,null,"Credits = ",{"$f":"SUM(H44:H50)","v":16}]
["Hr","Course","Description","Grd","Date",null,null,"Hr","Course","Description","Grd","Date"]
[3,"MAE 4149",null,null,null,{"$f":"IF(ISNUMBER(D44),D44*A44,IF(ISBLANK(D44),0,VLOOKUP(D44,$A$52:$B$79,2,FALSE)*A44))","v":0},null,3,"MAE 4152W",null,null,null,{"$f":"IF(ISNUMBER(K44),K44*H44,IF(ISBLANK(K44),0,VLOOKUP(K44,$A$52:$B$79,2,FALSE)*H44))","v":0}]
[3,"MAE 4182",null,null,null,{"$f":"IF(ISNUMBER(D45),D45*A45,IF(ISBLANK(D45),0,VLOOKUP(D45,$A$52:$B$79,2,FALSE)*A45))","v":0},null,1,"MAE 3167W",null,null,null,{"$f":"IF(ISNUMBER(K45),K45*H45,IF(ISBLANK(K45),0,VLOOKUP(K45,$A$52:$B$79,2,FALSE)*H45))","v":0}]
[3,"MAE 3192",null,null,null,{"$f":"IF(ISNUMBER(D46),D46*A46,IF(ISBLANK(D46),0,VLOOKUP(D46,$A$52:$B$79,2,FALSE)*A46))","v":0},null,3,"H/SS 3",null,null,null,{"$f":"IF(ISNUMBER(K46),K46*H46,IF(ISBLANK(K46),0,VLOOKUP(K46,$A$52:$B$79,2,FALSE)*H46))","v":0}]
[1,"MAE 4151",null,null,null,{"$f":"IF(ISNUMBER(D47),D47*A47,IF(ISBLANK(D47),0,VLOOKUP(D47,$A$52:$B$79,2,FALSE)*A47))","v":0},null,3,"H/SS 4",null,null,null,{"$f":"IF(ISNUMBER(K47),K47*H47,IF(ISBLANK(K47),0,VLOOKUP(K47,$A$52:$B$79,2,FALSE)*H47))","v":0}]
[3,"MAE 3166W",null,null,null,{"$f":"IF(ISNUMBER(D48),D48*A48,IF(ISBLANK(D48),0,VLOOKUP(D48,$A$52:$B$79,2,FALSE)*A48))","v":0},null,3,"H/SS 5",null,null,null,{"$f":"IF(ISNUMBER(K48),K48*H48,IF(ISBLANK(K48),0,VLOOKUP(K48,$A$52:$B$79,2,FALSE)*H48))","v":0}]
[3,"H/SS 2",null,null,null,{"$f":"IF(ISNUMBER(D49),D49*A49,IF(ISBLANK(D49),0,VLOOKUP(D49,$A$52:$B$79,2,FALSE)*A49))","v":0},null,3,"H/SS 6",null,null,null,{"$f":"IF(ISNUMBER(K49),K49*H49,IF(ISBLANK(K49),0,VLOOKUP(K49,$A$52:$B$79,2,FALSE)*H49))","v":0}]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(D50),D50*A50,IF(ISBLANK(D50),0,VLOOKUP(D50,$A$52:$B$79,2,FALSE)*A50))","v":0},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(K50),K50*H50,IF(ISBLANK(K50),0,VLOOKUP(K50,$A$52:$B$79,2,FALSE)*H50))","v":0}]
[]
["A",4]
["A-",3.7]
["B+",3.3]
["B",3]
["B-",2.7]
["C+",2.2999999999999998]
["C",2]
["C-",1.7]
["D+",1.3]
["D",1]
["D-",0.7]
["F",0]
["Z",0]
["S",0]
["IP",0]
["W",0]
["F\\A",4]
["F\\A-",3.7]
["F\\B+",3.3]
["F\\B",3]
["F\\B-",2.7]
["F\\C+",2.2999999999999998]
["F\\C",2]
["F\\C-",1.7]
["F\\D+",1.3]
["F\\D",1]
["F\\D-",0.7]
["F\\F",0]
[]
[null,"Cumulative gpa",null,{"$f":"GPA(B44:B49,I44:I49,I33:I38,B33:B38,B22:B28,I22:I26,I11:I15,B11:B17)","v":0},null,null,null,null,"Needed"]
[null,"Technical gpa",null,{"$f":"GPA(B44:B48,I44:I45,I35:I38,B35:B37)","v":0},null,null,null,null,"In Progress"]
[null,null,null,null,null,null,null,null,"Take Action"]
[]
[]
[null,null,null,{"$f":"D1","v":"Department of Mechanical and Aerospace Engineering"}]
[null,null,null,{"$f":"D2","v":"2018-2019"}]
[null,null,null,{"$f":"D3","v":"Medical Preparation Option in Mechanical Engineering"},null,null,null,null,null,null,null,null,null,null,null,null,"Credits =",null,{"$f":"S3","v":134}]
[]
["Student Name",null,{"$f":"C5","v":0},null,null,null,null,null,null,null,null,null,null,null,"GWID:",{"$f":"P5","v":0}]
["Advisor",null,{"$f":"C6","v":0},null,null,null,null,null,null,null,null,null,null,null,"Admit Date:",{"$f":"P6","v":0}]
[]
[]
[]
[]
[null,"Sem. Hrs.","Semester","Year",null,null,"Sem. GPA",null,null,"Initials / Date",null,"Action"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}