{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["E&E","M&M","SP","Grad point"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[7,11,7,16],[21,2,21,9],[2,3,2,6],[2,9,2,10],[7,1,7,2],[7,4,7,9]]}
[]
[]
[null,null,"Student:",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,"Units",30]
[]
[null,"Courses - CR/NC",null,null,"Graduate Courses - Graded",null,null,null,null,null,null,"Undergraduate Courses - Graded"]
[null,"Course","Units",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,"BIOL 202*",3,null,{"$f":"IF(G10<>\"\",F10,\"\")","v":""},{"$f":"IF(G10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!G10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(G10<>\"\",(I10*F10),\"\")","v":""},null,null,null,null,{"$f":"IF(N10<>\"\",M10,\"\")","v":""},{"$f":"IF(N10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!N10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(N10<>\"\",(P10*M10),\"\")","v":""}]
[null,"BIOL 280",null,null,"BIOL 255",null,null,{"$f":"IF(G11<>\"\",F11,\"\")","v":""},{"$f":"IF(G11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!G11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(G11<>\"\",(I11*F11),\"\")","v":""},null,null,null,null,{"$f":"IF(N11<>\"\",M11,\"\")","v":""},{"$f":"IF(N11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!N11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(N11<>\"\",(P11*M11),\"\")","v":""}]
[null,"BIOL 298",null,null,null,null,null,"",{"$f":"IF(G12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!G12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(G12<>\"\",(I12*F12),\"\")","v":""},null,null,null,null,"",{"$f":"IF(N12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!N12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(N12<>\"\",(P12*M12),\"\")","v":""}]
[null,"BIOL 299",null,null,null,null,null,"",{"$f":"IF(G13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!G13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!N13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!G14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!N14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G15<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!G15,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N15<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!N15,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G16<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!G16,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N16<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!N16,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G17<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!G17,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N17<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!N17,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!G18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('E&E'!N18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"TOTAL",{"$f":"SUM(C10:C18)","v":0},null,"TOTAL",{"$f":"SUM(F10:F18)","v":3},null,{"$f":"SUM(H10:H18)","v":0},{"$f":"SUM(I10:I18)","v":0},{"$f":"SUM(J10:J18)","v":0},null,"TOTAL",{"$f":"SUM(M10:M18)","v":0},null,{"$f":"SUM(O10:O18)","v":0},{"$f":"SUM(P10:P18)","v":0},{"$f":"SUM(Q10:Q18)","v":0}]
[]
[]
[null,null,"CRITERIA      "]
[null,null,null,null,"Units for"]
[null,null,null,null,"BIOL 201",{"$f":"IF($C10>0, \"OK\",\"Need\")","v":"Need"},"Must be>=0.5"]
[null,null,null,null,"BIOL 202",{"$f":"IF(F10=3,IF(H10<>\"\",\"OK\",\"Need\"),\"Need\")","v":"Need"},"Must be =3",null,"* Must be completed BEFORE turning in candidacy form!"]
[null,null,null,null,"BIOL 255",{"$f":"IF(F11>0,\"OK\",\"Need\")","v":"Need"},"Must be >0"]
[null,null,null,null,"BIOL 299",{"$f":"IF(C13>0,\"OK\",\"Need\")","v":"Need"},"Must be >0"]
[null,null,null,"Units of Grad courses graded",{"$f":"C11+F19","v":3}]
[null,null,null,"Units of Undergraduate courses graded",{"$f":"M19","v":0}]
[null,null,null,"Total units graded",{"$f":"E28+E29","v":3}]
[null,null,null,"Graduate units",{"$f":"C19+F19","v":3},null,null,null,"Required","Required"]
[null,null,null,"Percent Graduate Units",{"$f":"IF(E35>0,E31/E35,\"\")","v":1},{"$f":"IF(E35>0, IF(E31>=J32,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be > =",null,0.5,{"$f":"I32*I6","v":15},"units"]
[null,null,null,"Percent Graded Units",{"$f":"IF(E35>0,E30/E35,\"\")","v":1},{"$f":"IF(E35>0, IF(E30>=J33,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",null,0.6,{"$f":"I33*I6","v":18},"units"]
[null,null,null,"1<=298+299<=6",{"$f":"C12+C13","v":0},{"$f":"IF(C12+C13>6, \"Too High\", IF(SUM(C12:C13)>=1,\"OK\",\"Too Low\"))","v":"Too Low"},"Must be between 1 and 6"]
[null,null,null,"TOTAL UNITS",{"$f":"C19+F19+M19","v":3},{"$f":"IF(E35<>I35, IF(E35>I35, \"Too High\",\"Too Low\"),\"OK\")","v":"Too Low"},"Must be =",null,{"$f":"I6","v":30}]
[null,null,null,"GPA",{"$f":"IF((J19+Q19)>0,(J19+Q19)/(H19+O19),0)","v":0},{"$f":"IF(E36>0,IF(E36>=3,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=3.0"]

{"sheet":"M&M","index":1,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[7,11,7,16],[20,2,20,9],[2,3,2,6],[2,9,2,10],[7,1,7,2],[7,4,7,9]]}
[]
[]
[null,null,"Student:",null,null,null,null,null,"SID:"]
[]
[null,null,"Determining if Candidacy Requirements have been met for:"]
[null,null,"MS Molecular Biology and Microbiology"]
[null,null,null,null,"Units",30]
[null,"Courses - CR/NC",null,null,"Graduate Courses - Graded",null,null,null,null,null,null,"Undergraduate Courses - Graded"]
[null,"Course","Units",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,"BIOL 202*",null,null,{"$f":"IF(G10<>\"\",F10,\"\")","v":""},{"$f":"IF(G10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!G10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(G10<>\"\",(I10*F10),\"\")","v":""},null,null,null,null,{"$f":"IF(N10<>\"\",M10,\"\")","v":""},{"$f":"IF(N10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!N10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(N10<>\"\",(P10*M10),\"\")","v":""}]
[null,"BIOL 280",null,null,"BIOL 205",null,null,{"$f":"IF(G11<>\"\",F11,\"\")","v":""},{"$f":"IF(G11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!G11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,{"$f":"IF(N11<>\"\",M11,\"\")","v":""},{"$f":"IF(N11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!N11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 298",null,null,"BIOL 233",null,null,"",{"$f":"IF(G12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!G12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!N12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 299",null,null,"BIOL 255M",null,null,"",{"$f":"IF(G13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!G13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!N13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,"MICR 270",null,null,"",{"$f":"IF(G14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!G14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!N14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G15<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!G15,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N15<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!N15,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G16<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!G16,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N16<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!N16,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G17<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!G17,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N17<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!N17,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!G18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH('M&M'!N18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"TOTAL",{"$f":"SUM(C10:C18)","v":0},null,"TOTAL",{"$f":"SUM(F10:F18)","v":0},null,{"$f":"SUM(H10:H18)","v":0},{"$f":"SUM(I10:I18)","v":0},{"$f":"SUM(J10:J18)","v":0},null,"TOTAL",{"$f":"SUM(M10:M18)","v":0},null,{"$f":"SUM(O10:O18)","v":0},{"$f":"SUM(P10:P18)","v":0},{"$f":"SUM(Q10:Q18)","v":0}]
[]
[null,null,"CRITERIA      "]
[null,null,null,null,"Units for"]
[null,null,null,null,"BIOL 201",{"$f":"IF($C10>=1, \"OK\",\"Need\")","v":"Need"},"Must be>=1"]
[null,null,null,null,"BIOL 202",{"$f":"IF(F10=3,IF(H10<>\"\",\"OK\",\"Need\"),\"Need\")","v":"Need"},"Must be=3",null,"*Needs to be completed BEFORE you turn in tour Candidacy form"]
[null,null,null,null,"BIOL 205, 233, 255M or MICR 270    ",{"$f":"IF(SUM(F11:F14)>0,\"OK\",\"Need\")","v":"Need"},"Must be >=1"]
[null,null,null,null,"BIOL 299",{"$f":"IF(C13>0,\"OK\",\"Need\")","v":"Need"},"Must be >0"]
[null,null,null,"Units of Grad courses graded",{"$f":"C11+F19","v":0}]
[null,null,null,"Units of Undergraduate courses graded",{"$f":"M19","v":0}]
[null,null,null,"Total units graded",{"$f":"E27+E28","v":0}]
[null,null,null,"Graduate units",{"$f":"C19+F19","v":0},null,null,null,"Required"]
[null,null,null,"Percent Graduate Units",{"$f":"IF(E34>0,E30/E34,\"\")","v":""},{"$f":"IF(E34>0, IF(E30>=J31,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",null,0.5,{"$f":"I31*F7","v":15},"units"]
[null,null,null,"Percent Graded Units",{"$f":"IF(E34>0,E29/E34,\"\")","v":""},{"$f":"IF(E34>0, IF(E29>=J32,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",null,0.6,{"$f":"I32*F7","v":18},"units"]
[null,null,null,"1<=298+299<=6",{"$f":"C12+C13","v":0},{"$f":"IF(C12+C13>6, \"Too High\", IF(SUM(C12:C13)>=1,\"OK\", \"Too Low\"))","v":"Too Low"},"Must be between 1 and 6"]
[null,null,null,"TOTAL UNITS",{"$f":"C19+F19+M19","v":0},{"$f":"IF(E34<>30, IF(E34>30, \"Too High\",\"Too Low\"),\"OK\")","v":"Too Low"},"Must be = ",null,{"$f":"F7","v":30}]
[null,null,null,"GPA",{"$f":"IF((J19+Q19)>0,(J19+Q19)/(H19+O19),0)","v":0},{"$f":"IF(E35>0,IF(E35>=3,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=3.0"]

{"sheet":"SP","index":2,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":false,"merged":[[7,11,7,16],[21,2,21,9],[2,3,2,6],[2,9,2,10],[7,1,7,2],[7,4,7,9]]}
[]
[]
[null,null,"Student:",null,null,null,null,null,"SID:"]
[]
[null,null,"Determining if Candidacy Requirements have been met for:"]
[null,null,"MS Systems Physiology",null,null,null,"Units",30]
[]
[null,"Courses - CR/NC",null,null,"Graduate Courses - Graded",null,null,null,null,null,null,"Undergraduate Courses - Graded"]
[null,"Course","Units",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,"BIOL 202*",null,null,{"$f":"IF(G10<>\"\",F10,\"\")","v":""},{"$f":"IF(G10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!G10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(G10<>\"\",(I10*F10),\"\")","v":""},null,null,null,null,{"$f":"IF(N10<>\"\",M10,\"\")","v":""},{"$f":"IF(N10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!N10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(N10<>\"\",(P10*M10),\"\")","v":""}]
[null,"BIOL 280",null,null,"BIOL 227",null,null,{"$f":"IF(G11<>\"\",F11,\"\")","v":""},{"$f":"IF(G11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!G11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,{"$f":"IF(N11<>\"\",M11,\"\")","v":""},{"$f":"IF(N11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!N11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 284",null,null,"BIOL 255P",null,null,"",{"$f":"IF(G12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!G12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!N12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 298",null,null,null,null,null,"",{"$f":"IF(G13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!G13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!N13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 299",null,null,null,null,null,"",{"$f":"IF(G14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!G14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!N14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G15<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!G15,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N15<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!N15,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G16<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!G16,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N16<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!N16,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G17<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!G17,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N17<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!N17,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!G18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(SP!N18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,{"$f":"SUM(C10:C18)","v":0},null,"TOTAL",{"$f":"SUM(F10:F18)","v":0},null,{"$f":"SUM(H10:H18)","v":0},{"$f":"SUM(I10:I18)","v":0},{"$f":"SUM(J10:J18)","v":0},null,"TOTAL",{"$f":"SUM(M10:M18)","v":0},null,{"$f":"SUM(O10:O18)","v":0},{"$f":"SUM(P10:P18)","v":0},{"$f":"SUM(Q10:Q18)","v":0}]
[]
[]
[null,null,"CRITERIA     "]
[null,null,null,null,"Units for"]
[null,null,null,null,"BIOL 201",{"$f":"IF($C10>0, \"OK\",\"Need\")","v":"Need"},"Must be>=0.5"]
[null,null,null,null,"BIOL 202",{"$f":"IF(F10=3,IF(H10<>\"\",\"OK\",\"Need\"),\"Need\")","v":"Need"},"Must be=3",null,"* Must be completed BEFORE turning in candidacy form!"]
[null,null,null,null,"BIOL 284",{"$f":"IF(C12>0,\"OK\",\"Need\")","v":"Need"},"Must be>0"]
[null,null,null,null,"BIOL 255P or BIOL 227    ",{"$f":"IF(F11>0,\"OK\",IF(F12>0,\"OK\",\"Need\"))","v":"Need"},"Must be >0"]
[null,null,null,null,"BIOL 299",{"$f":"IF(C14>0,\"OK\",\"Need\")","v":"Need"},"Must be >0"]
[null,null,null,"Units of Grad courses graded",{"$f":"C11+F19","v":0}]
[null,null,null,"Units of Undergraduate courses graded",{"$f":"M19","v":0}]
[null,null,null,"Total units graded",{"$f":"E29+E30","v":0}]
[null,null,null,"Graduate units",{"$f":"C19+F19","v":0},null,null,null,"Required"]
[null,null,null,"Percent Graduate Units",{"$f":"IF(E36>0,E32/I36,\"\")","v":""},{"$f":"IF(E36>0, IF(E32>=J33,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",null,0.5,{"$f":"I33*H$6","v":15},"units"]
[null,null,null,"Percent Graded Units",{"$f":"IF(E36>0,E31/I36,\"\")","v":""},{"$f":"IF(E36>0, IF(E31>=J34,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",null,0.6,{"$f":"I34*H$6","v":18},"units"]
[null,null,null,"1<=298+299<=6",{"$f":"C13+C14","v":0},{"$f":"IF(C13+C14>6, \"Too Many\",IF(SUM(C12:C13)>=1,\"OK\",\"Too Low\"))","v":"Too Low"},"Must be between 1 and 6"]
[null,null,null,"TOTAL UNITS",{"$f":"C19+F19+M19","v":0},{"$f":"IF(E36<>I36, IF(E36>I36, \"Too High\",\"Too Low\"),\"OK\")","v":"Too Low"},"Must be = ",null,{"$f":"H6","v":30}]
[null,null,null,"GPA",{"$f":"IF((J19+Q19)>0,(J19+Q19)/(H19+O19),0)","v":0},{"$f":"IF(E37>0,IF(E37>=3,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=3.0"]

{"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}]