{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["E&E","M&M","SP","Grad point","Choices"],"not_rendered":{"charts":0,"images":0,"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":"E&E","index":0,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[7,12,7,17],[25,2,25,10],[7,1,7,2],[7,5,7,10]]}
[null,"Rev 10-02-2015"]
[]
[null,null,"Student:",null,null,null,null,null,null,"SID:"]
[]
[null,null,"Determining if Candidacy Requirements have been met for:"]
[null,null,"MS Ecology and Evolution",null,null,null,null,null,"Units",30]
[]
[null,"Courses - CR/NC",null,null,null,"Graduate Courses - Graded",null,null,null,null,null,null,"Undergraduate Courses - Graded"]
[null,"Course","Units",null,null,"Course","Units","Letter Grade","Units graded","Grade Pt","GPU",null,"Course","Units","Letter Grade","Units Graded","Grade Pt","GPU"]
[null,"BIOL 201",null,null,null,"BIOL 202*",null,null,{"$f":"IF(H10<>\"\",G10,\"\")","v":""},{"$f":"IF(H10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(H10<>\"\",(J10*G10),\"\")","v":""},null,null,null,null,{"$f":"IF(O10<>\"\",N10,\"\")","v":""},{"$f":"IF(O10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!O10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(O10<>\"\",(Q10*N10),\"\")","v":""}]
[null,"BIOL 201",null,null,null,"BIOL 255E",null,null,{"$f":"IF(H11<>\"\",G11,\"\")","v":""},{"$f":"IF(H11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,{"$f":"IF(O11<>\"\",N11,\"\")","v":""},{"$f":"IF(O11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!O11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(O11<>\"\",(Q11*N11),\"\")","v":""}]
[null,"BIOL 298",null,null,null,"BIOL 218",null,null,"",{"$f":"IF(H12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!O12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(O12<>\"\",(Q12*N12),\"\")","v":""}]
[null,"BIOL 298",null,null,null,"BIOL 256",null,null,"",{"$f":"IF(H13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!O13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 298",null,null,null,"CHOOSE",null,null,"",{"$f":"IF(H14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 298",null,null,null,"CHOOSE",null,null,"",{"$f":"IF(H15<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H15,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 299",null,null,null,"CHOOSE",null,null,"",{"$f":"IF(H16<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H16,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 280",null,null,null,"CHOOSE",null,null,"",{"$f":"IF(H17<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H17,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!O18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H19<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H19,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O19<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!O19,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H20<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H20,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O20<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!O20,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H21<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H21,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O21<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!O21,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H22<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!H22,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O22<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!O22,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"TOTAL",{"$f":"SUM(C10:C22)","v":0},null,null,"TOTAL",{"$f":"SUM(G10:G22)","v":0},null,{"$f":"SUM(I10:I22)","v":0},{"$f":"SUM(J10:J22)","v":0},{"$f":"SUM(K10:K22)","v":0},null,"TOTAL",{"$f":"SUM(N10:N22)","v":0},null,{"$f":"SUM(P10:P22)","v":0},{"$f":"SUM(Q10:Q22)","v":0},{"$f":"SUM(R10:R22)","v":0}]
[]
[]
[null,null,"CRITERIA      "]
[null,null,null,null,null,"Units for"]
[null,null,null,null,null,"BIOL 201",{"$f":"IF(SUM(C10:C11)>=I28, \"OK\",\"Need\")","v":"Need"},"Must be >=",1]
["* Must be completed BEFORE turning in candidacy form!",null,null,null,null,"BIOL 202",{"$f":"IF(G10=3,IF(J29<>\"Must be B\",\"OK\",\"Need\"),\"Need\")","v":"Need"},"Must be =",3,{"$f":"IF(J10>=3,\"\",IF(J10<3,\"Must be B\",\"\"))","v":""}]
[null,null,null,null,null,"BIOL 255E",{"$f":"IF(G11>0,\"OK\",\"Need\")","v":"Need"},"Must be >",0]
[null,null,null,null,null,"BIOL 218",{"$f":"IF(G12>0,\"OK\",\"Need\")","v":"Need"}]
[null,null,null,null,null,"BIOL 256","Need"]
[null,null,null,null,null,"BIOL 298",{"$f":"IF(SUM(C12:C15)>7,\"Too High\",IF(SUM(C12:C15)<4, \"Too Low\",\"OK\"))","v":"Too Low"},"Must be","4 to 7"]
[null,null,null,null,null,"BIOL 299",{"$f":"IF(C16=1,\"OK\",\"Need\")","v":"Need"},"Must be =",1]
[null,null,null,null,null,"Units of Grad courses graded",{"$f":"G23","v":0}]
[null,null,null,null,null,"Units of Undergraduate courses graded",{"$f":"N23","v":0}]
[null,null,null,null,null,"Total units graded",{"$f":"G35+G36","v":0}]
[null,null,null,null,null,"Graduate units",{"$f":"C23+G23","v":0},null,"Required"]
[null,null,null,null,"Percent Graduate Units",{"$f":"IF(F41>0,G38/F41,0)","v":0},{"$f":"IF(F41>0, IF(G38>=I39,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be > =",0.5,{"$f":"I39*J6","v":15},"units"]
[null,null,null,null,"Percent Graded Units",{"$f":"IF(F41>0,G37/F41,0)","v":0},{"$f":"IF(F41>0, IF(G37>=J40,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",0.6,{"$f":"I40*J6","v":18},"units"]
[null,null,null,null,"TOTAL UNITS",{"$f":"C23+G23+N23","v":0},{"$f":"IF(F41<>I41, IF(F41>I41, \"Too High\",\"Too Low\"),\"OK\")","v":"Too Low"},"Must be =",{"$f":"J6","v":30}]
[null,null,null,null,"GPA",{"$f":"IF((K23+R23)>0,(K23+R23)/(I23+P23),0)","v":0},{"$f":"IF(F42>0,IF(F42>=3,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",3]

{"sheet":"M&M","index":1,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":false,"merged":[[7,12,7,17],[7,1,7,2],[7,5,7,10]]}
[null,{"$f":"'E&E'!B1","v":"Rev 10-02-2015"}]
[]
[null,null,"Student:",null,null,null,null,null,null,"SID:"]
[]
[null,null,"Determining if Candidacy Requirements have been met for:"]
[null,null,"MS Molecular Biology and Microbiology 2014-2015"]
[null,null,null,null,null,"Units",30]
[null,"Courses - CR/NC",null,null,null,"Graduate Courses - Graded",null,null,null,null,null,null,"Undergraduate Courses - Graded"]
[null,"Course","Units",null,null,"Course","Units","Letter Grade","Units graded","Grade Pt","GPU",null,"Course","Units","Letter Grade","Units Graded","Grade Pt","GPU"]
[null,"BIOL 201",null,null,null,"BIOL 202*",null,null,{"$f":"IF(H10<>\"\",G10,\"\")","v":""},{"$f":"IF(H10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(H10<>\"\",(J10*G10),\"\")","v":""},null,null,null,null,{"$f":"IF(O10<>\"\",N10,\"\")","v":""},{"$f":"IF(O10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(O10<>\"\",(Q10*N10),\"\")","v":""}]
[null,"BIOL 201",null,null,null,"BIOL 205",null,null,{"$f":"IF(H11<>\"\",G11,\"\")","v":""},{"$f":"IF(H11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,{"$f":"IF(O11<>\"\",N11,\"\")","v":""},{"$f":"IF(O11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(O11<>\"\",(Q11*N11),\"\")","v":""}]
[null,"BIOL 298",null,null,null,"BIOL 220",null,null,"",{"$f":"IF(H12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 298",null,null,null,"BIOL 256",null,null,"",{"$f":"IF(H13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 298",null,null,null,"CHOOSE",null,null,"",{"$f":"IF(H14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 298",null,null,null,"CHOOSE",null,null,"",{"$f":"IF(H15<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H15,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O15<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O15,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 299",null,null,null,"CHOOSE",null,null,"",{"$f":"IF(H16<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H16,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O16<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O16,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,"CHOOSE",null,null,"",{"$f":"IF(H17<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H17,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O17<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O17,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H19<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H19,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O19<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O19,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H20<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H20,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O20<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O20,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H21<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H21,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O21<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O21,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H22<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H22,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O22<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O22,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H23<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H23,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O23<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O23,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H24<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!H24,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O24<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!O24,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"TOTAL",{"$f":"SUM(C10:C24)","v":0},null,null,"TOTAL",{"$f":"SUM(G10:G24)","v":0},null,{"$f":"SUM(I10:I24)","v":0},{"$f":"SUM(J10:J24)","v":0},{"$f":"SUM(K10:K24)","v":0},null,"TOTAL",{"$f":"SUM(N10:N24)","v":0},null,{"$f":"SUM(P10:P24)","v":0},{"$f":"SUM(Q10:Q24)","v":0},{"$f":"SUM(R10:R24)","v":0}]
[]
[null,null,null,null,null,null,"CRITERIA      "]
[null,null,null,null,null,"Units for"]
[null,null,null,null,null,"BIOL 201",{"$f":"IF(SUM(C10:C11)>=I29, \"OK\",\"Need\")","v":"Need"},"Must be >=",1]
["*Needs to be completed BEFORE you turn in your Candidacy form",null,null,null,null,"BIOL 202",{"$f":"IF(G10=3,IF(J30<>\"Must be B\",\"OK\",\"Need\"),\"Need\")","v":"Need"},"Must be =",3,{"$f":"IF(I10>=3,\"\",IF(I10<3,\"Must be B\",\"\"))","v":""}]
[null,null,null,null,null,"BIOL 205",{"$f":"IF($G11=I31, \"OK\",\"Need\")","v":"Need"},"Must be =",4]
[null,null,null,null,null,"BIOL 255M or BIOL 215",{"$f":"IF(G14>=2,\"OK\",\"Need\")","v":"Need"},"Must be >=",2]
[null,null,null,null,null,"BIOL 220",{"$f":"IF($G12=I33, \"OK\",\"Need\")","v":"Need"},"Must be =",3]
[null,null,null,null,null,"BIOL 256",{"$f":"IF($G13=I34, \"OK\",\"Need\")","v":"Need"},"Must be =",3]
[null,null,null,null,null,"BIOL 210, 233, 255L, 255M or MICR 270    ",{"$f":"IF(SUM(G15:G17)>0,IF(SUM(G15:G17)<=4,\"OK\", \"Too high\"),\"Need\")","v":"Need"},"Must be 1 to  4"]
[null,null,null,null,null,"BIOL 298",{"$f":"IF(SUM(C12:C15)>10,\"Too High\",IF(SUM(C12:C15)<4, \"Too Low\",\"OK\"))","v":"Too Low"},"Must be 4 to 10"]
[null,null,null,null,null,"BIOL 299",{"$f":"IF(C16>2,\"Too High\",IF(C16<1,\"Too Low\",\"OK\"))","v":"Too Low"},"Must be 1 or 2"]
[null,null,null,null,null,"Units of Grad courses graded",{"$f":"G25","v":0}]
[null,null,null,null,null,"Units of Undergraduate courses graded",{"$f":"N25","v":0}]
[null,null,null,null,null,"Total units graded",{"$f":"G38+G39","v":0}]
[null,null,null,null,null,"Graduate units",{"$f":"C25+G25","v":0},null,"Required"]
[null,null,null,"Percent Graduate Units",null,{"$f":"IF(F44>0,G41/F44,0)","v":0},{"$f":"IF(F44>0, IF(F42>=I42,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",0.5,{"$f":"I42*G$7","v":15},"units"]
[null,null,null,"Percent Graded Units",null,{"$f":"IF(F44>0,G40/F44,0)","v":0},{"$f":"IF(F44>0, IF(F43>=I43,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",0.6,{"$f":"I43*G$7","v":18},"units"]
[null,null,null,"TOTAL UNITS",null,{"$f":"C25+G25+N25","v":0},{"$f":"IF(F44<>30, IF(F44>30, \"Too High\",\"Too Low\"),\"OK\")","v":"Too Low"},"Must be = ",{"$f":"G7","v":30}]
[null,null,null,"GPA",null,{"$f":"IF((K25+R25)>0,(K25+R25)/(I25+P25),0)","v":0},{"$f":"IF(F45>0,IF(F45>=I45,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",3]

{"sheet":"SP","index":2,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[7,12,7,17],[25,2,25,10],[7,1,7,2],[7,5,7,10]]}
[null,{"$f":"'E&E'!B1","v":"Rev 10-02-2015"}]
[]
[null,null,"Student:",null,null,null,null,null,null,"SID:"]
[]
[null,null,"Determining if Candidacy Requirements have been met for:"]
[null,null,"MS Systems Physiology",null,null,null,null,"Units",30]
[]
[null,"Courses - CR/NC",null,null,null,"Graduate Courses - Graded",null,null,null,null,null,null,"Undergraduate Courses - Graded"]
[null,"Course","Units",null,null,"Course","Units","Letter Grade","Units graded","Grade Pt","GPU",null,"Course","Units","Letter Grade","Units Graded","Grade Pt","GPU"]
[null,"BIOL 201",null,null,null,"BIOL 202*",null,null,{"$f":"IF(H10<>\"\",G10,\"\")","v":""},{"$f":"IF(H10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!H10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(H10<>\"\",(J10*G10),\"\")","v":""},null,null,null,null,{"$f":"IF(O10<>\"\",N10,\"\")","v":""},{"$f":"IF(O10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!O10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(O10<>\"\",(Q10*N10),\"\")","v":""}]
[null,"BIOL 201",null,null,null,"CHOOSE",null,null,{"$f":"IF(H11<>\"\",G11,\"\")","v":""},{"$f":"IF(H11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!H11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,{"$f":"IF(O11<>\"\",N11,\"\")","v":""},{"$f":"IF(O11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!O11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 298",null,null,null,"CHOOSE",null,null,"",{"$f":"IF(H12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!H12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!O12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 298",null,null,null,"CHOOSE",null,null,"",{"$f":"IF(H13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!H13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!O13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 298",null,null,null,"CHOOSE",null,null,"",{"$f":"IF(H14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!H14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!O14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 298",null,null,null,"CHOOSE",null,null,""]
[null,"BIOL 299",null,null,null,"CHOOSE",null,null,""]
[null,"BIOL 280",null,null,null,"CHOOSE"]
[]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H19<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!H19,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O19<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!O19,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H20<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!H20,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O20<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!O20,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H21<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!H21,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O21<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!O21,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(H22<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!H22,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(O22<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!O22,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,{"$f":"SUM(C10:C22)","v":0},null,null,"TOTAL",{"$f":"SUM(G10:G22)","v":0},null,{"$f":"SUM(I10:I22)","v":0},{"$f":"SUM(J10:J22)","v":0},{"$f":"SUM(K10:K22)","v":0},null,"TOTAL",{"$f":"SUM(N10:N22)","v":0},null,{"$f":"SUM(P10:P22)","v":0},{"$f":"SUM(Q10:Q22)","v":0},{"$f":"SUM(R10:R22)","v":0}]
[]
[null,"* Use total units rather than individual classes"]
[null,null,"CRITERIA     "]
[null,null,null,null,null,"Units for"]
[null,null,null,null,null,"BIOL 201",{"$f":"IF(SUM(C10:C11)>=I28, \"OK\",\"Need\")","v":"Need"},"Must be >=",1]
[null,null,null,null,null,"BIOL 202",{"$f":"IF(G10=3,IF(J29<>\"Must be B\",\"OK\",\"Need\"),\"Need\")","v":"Need"},"Must be=",3,{"$f":"IF(J10>=3,\"\",IF(J10<3,\"Must be B\",\"\"))","v":""},"* Must be completed BEFORE turning in candidacy form!"]
[null,null,null,null,null,"BIOL 255P, BIOL 227, BIOL 230 ",{"$f":"IF(SUM(G11:G13)>=I30,IF(SUM(G11:G13)<=6,\"OK\",\"Too High\"), \"Need\")","v":"Need"},"Must be ",5]
[null,null,null,null,null,"Electives (BIOL 255E, 255L, 255M, 255P)",{"$f":"IF(SUM(G14:G21,P23)>=4,IF(SUM(G14:G21,P23)<=17,\"OK\",\"Too High\"), \"Need\")","v":"Need"},"Must be ",9]
[null,null,null,null,null,"BIOL 298",{"$f":"IF(SUM(C12:C15)>10, \"Too Many\",IF(SUM(C12:C15)>=4,\"OK\",\"Too Low\"))","v":"Too Low"},"Must be 4 to 10"]
[null,null,null,null,null,"BIOL 299",{"$f":"IF(C16=1,\"OK\", IF(C16=0, \"Too Low\",\"Too High\"))","v":"Too Low"},"Must be =",1]
[null,null,null,null,null,"Units of Grad courses graded",{"$f":"G23","v":0}]
[null,null,null,null,null,"Units of Undergraduate courses graded",{"$f":"N23","v":0}]
[null,null,null,null,null,"Total units graded",{"$f":"G34+G35","v":0}]
[null,null,null,null,null,"Graduate units",{"$f":"C23+G23","v":0},null,"Required"]
[null,null,null,"Percent Graduate Units",null,{"$f":"IF(F40>0,G37/F40,0)","v":0},{"$f":"IF(F40>0, IF(F38>=I38,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",0.5,{"$f":"I38*I$6","v":15},"units"]
[null,null,null,"Percent Graded Units",null,{"$f":"IF(F40>0,G36/F40,0)","v":0},{"$f":"IF(F40>0, IF(G36>=J39,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",0.6,{"$f":"I39*I$6","v":18},"units"]
[null,null,null,"TOTAL UNITS",null,{"$f":"C23+G23+N23","v":0},{"$f":"IF(F40<>I40, IF(F40>I40, \"Too High\",\"Too Low\"),\"OK\")","v":"Too Low"},"Must be = ",{"$f":"I6","v":30}]
[null,null,null,"GPA",null,{"$f":"IF((K23+R23)>0,(K23+R23)/(I23+P23),0)","v":0},{"$f":"IF(F41>0,IF(F41>=3,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",3]

{"sheet":"Grad point","index":3,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"Grade","Grad Pt."]
[null,null,null,"A",4]
[null,null,null,"A-",3.7]
[null,null,null,"A+",4]
[null,null,null,"B-",2.7]
[null,null,null,"B",3]
[null,null,null,"B+",3.3]
[null,null,null,"C",2]
[null,null,null,"C-",1.7]
[null,null,null,"C+",2.2999999999999998]
[null,null,null,"D",1]
[null,null,null,"D+",1.3]
[null,null,null,"F",0]
[]
[null,null,null,"B",{"$f":"INDEX($E$4:$E$15, MATCH(D17,$D$4:$D$15,0))","v":3}]

{"sheet":"Choices","index":4,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,"CourseChoice",null,"AddCourse",null,"SPAdd",null,"SpElectives",null,"EEElect"]
[null,"CHOOSE",null,"CHOOSE",null,"CHOOSE",null,"CHOOSE",null,"CHOOSE"]
[null,"BIOL 215",null,"BIOL 210",null,"BIOL 227",null,"BIOL 255E",null,"BIOL 255E"]
[null,"BIOL 255M",null,"BIOL 233",null,"BIOL 230",null,"BIOL 255L",null,"BIOL 255P"]
[null,null,null,"BIOL 255L",null,"BIOL 255P",null,"BIOL 255M",null,"BIOL 255M"]
[null,null,null,"BIOL 255M",null,null,null,"BIOL 255P",null,"BIOL 255L"]
[null,null,null,"MICR 270"]