{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ANSI-PROD","GRAD CHECK","ADVISOR'S NOTES","CourseLeaf Degree Sheet"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":3,"comments":1,"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":"ANSI-PROD","index":0,"n_rows":43,"n_cols":35,"rows_kept":43,"cut":false,"hidden":false,"merged":[[14,23,14,24],[15,23,15,24],[24,16,24,17],[26,16,26,17],[17,16,17,17],[9,33,9,34],[28,33,28,34],[39,33,39,34],[38,33,38,34],[36,33,36,34],[32,33,32,34],[33,33,33,34],[34,33,34,34],[19,33,19,34],[18,33,18,34],[17,2,17,3],[17,8,17,11],[23,16,23,17],[20,16,20,17],[21,16,21,17],[22,16,22,17],[21,0,21,11],[18,2,18,3],[18,8,18,11],[19,2,19,3],[19,8,19,11],[20,2,20,3],[20,8,20,11],[18,16,18,22],[15,2,15,3],[15,8,15,11],[16,2,16,3],[16,8,16,11],[11,2,11,3],[11,8,11,11],[13,2,13,3],[13,8,13,11],[12,2,12,3],[12,8,12,11],[14,2,14,3],[14,8,14,11],[6,23,6,24],[10,2,10,3],[10,8,10,11],[9,23,9,24],[9,2,9,3],[9,8,9,11],[0,1,0,16],[8,2,8,3],[8,8,8,11],[7,23,7,24],[27,33,27,34],[0,18,0,24],[0,32,0,34],[8,33,8,34],[20,33,20,34],[21,33,21,34],[26,33,26,34],[8,23,8,24],[7,2,7,3],[7,8,7,11],[6,2,6,3],[6,8,6,11]]}
["NAME:","LNAME, FNAME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID:","999-99-999",null,null,null,null,null,null,"ANSI-PROD",null,null,"ADV:",null,null,null,"LNAME"]
[]
["General Education Requirements: 40 Hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"College/Dept. Requirements: 29 Hours",null,null,null,null,null,null,null,null,null,"Major Requirements: 51 Hours",null,null,null,null,null,null,null,"2018-19"]
[]
["Course",null,"Grade",null,"GPts","GPACr","GrCr",null,null,"Deviation",null,null,null,null,null,null,"Course",null,"Grade","GPts","GPACr","GrCr",null,"Deviation",null,null,"Course",null,"Grade","GPts","GPACr","GrCr",null,"Deviation"]
[]
["ENGL ",1113,null,null,{"$f":"IF(H7<>\"\",H7,3)*IF(C7=\"A\",4,IF(C7=\"B\",3,IF(C7=\"C\",2,IF(C7=\"D\",1,IF(AND(C7>=0,C7<=4,ISNUMBER(C7)),C7,0)))))","v":0},{"$f":"IF(OR(C7=\"A\",C7=\"B\",C7=\"C\",C7=\"D\",C7=\"F\",AND(C7>=0,C7<=4,ISNUMBER(C7))),IF(H7<>\"\",H7,3),\"\")","v":""},{"$f":"IF(OR(C7=\"A\",C7=\"B\",C7=\"C\",C7=\"D\",C7=\"P\",AND(C7>=0,C7<=4,ISNUMBER(C7))),IF(H7<>\"\",H7,3),\"\")","v":""},null,null,null,null,null,null,null,null,null,"AG",1011,null,{"$f":"IF(W7<>\"\",W7,3)*IF(S7=\"A\",4,IF(S7=\"B\",3,IF(S7=\"C\",2,IF(S7=\"D\",1,IF(AND(S7>=0,S7<=4,ISNUMBER(S7)),S7,0)))))","v":0},{"$f":"IF(OR(S7=\"A\",S7=\"B\",S7=\"C\",S7=\"D\",S7=\"F\",AND(S7>=0,S7<=4,ISNUMBER(S7))),IF(W7<>\"\",W7,3),\"\")","v":""},{"$f":"IF(OR(S7=\"A\",S7=\"B\",S7=\"C\",S7=\"D\",S7=\"P\",AND(S7>=0,S7<=4,ISNUMBER(S7))),IF(W7<>\"\",W7,3),\"\")","v":""},1,null,null,null,"Core Courses: 36 Hours"]
["ENGL ",1213,null,null,{"$f":"IF(H8<>\"\",H8,3)*IF(C8=\"A\",4,IF(C8=\"B\",3,IF(C8=\"C\",2,IF(C8=\"D\",1,IF(AND(C8>=0,C8<=4,ISNUMBER(C8)),C8,0)))))","v":0},{"$f":"IF(OR(C8=\"A\",C8=\"B\",C8=\"C\",C8=\"D\",C8=\"F\",AND(C8>=0,C8<=4,ISNUMBER(C8))),IF(H8<>\"\",H8,3),\"\")","v":""},{"$f":"IF(OR(C8=\"A\",C8=\"B\",C8=\"C\",C8=\"D\",C8=\"P\",AND(C8>=0,C8<=4,ISNUMBER(C8))),IF(H8<>\"\",H8,3),\"\")","v":""},null,null,null,null,null,null,null,null,null,"PLNT",1213,null,0,"",""]
["HIST",1103,null,null,0,"","",null,null,null,null,null,null,null,null,null,"ANSI",2111,null,0,"","",1,null,null,null,"ACCT",2103,null,{"$f":"IF(AG9<>\"\",AG9,3)*IF(AC9=\"A\",4,IF(AC9=\"B\",3,IF(AC9=\"C\",2,IF(AC9=\"D\",1,IF(AND(AC9>=0,AC9<=4,ISNUMBER(AC9)),AC9,0)))))","v":0},{"$f":"IF(OR(AC9=\"A\",AC9=\"B\",AC9=\"C\",AC9=\"D\",AC9=\"F\",AND(AC9>=0,AC9<=4,ISNUMBER(AC9))),IF(AG9<>\"\",AG9,3),\"\")","v":""},{"$f":"IF(OR(AC9=\"A\",AC9=\"B\",AC9=\"C\",AC9=\"D\",AC9=\"P\",AND(AC9>=0,AC9<=4,ISNUMBER(AC9))),IF(AG9<>\"\",AG9,3),\"\")","v":""}]
["POLS",1113,null,null,0,"","",null,null,null,null,null,null,null,null,null,"ANSI",1124,null,0,"","",4,null,null,null,"AGEC",3423,null,{"$f":"IF(AG10<>\"\",AG10,3)*IF(AC10=\"A\",4,IF(AC10=\"B\",3,IF(AC10=\"C\",2,IF(AC10=\"D\",1,IF(AND(AC10>=0,AC10<=4,ISNUMBER(AC10)),AC10,0)))))","v":0},{"$f":"IF(OR(AC10=\"A\",AC10=\"B\",AC10=\"C\",AC10=\"D\",AC10=\"F\",AND(AC10>=0,AC10<=4,ISNUMBER(AC10))),IF(AG10<>\"\",AG10,3),\"\")","v":""},{"$f":"IF(OR(AC10=\"A\",AC10=\"B\",AC10=\"C\",AC10=\"D\",AC10=\"P\",AND(AC10>=0,AC10<=4,ISNUMBER(AC10))),IF(AG10<>\"\",AG10,3),\"\")","v":""}]
["MATH",1513,null,null,0,"","",null,null,null,null,null,null,null,null,null,"ANSI",2112,null,0,"","",2,null,null,null,"ANSI",3333,null,{"$f":"IF(AG11<>\"\",AG11,3)*IF(AC11=\"A\",4,IF(AC11=\"B\",3,IF(AC11=\"C\",2,IF(AC11=\"D\",1,IF(AND(AC11>=0,AC11<=4,ISNUMBER(AC11)),AC11,0)))))","v":0},{"$f":"IF(OR(AC11=\"A\",AC11=\"B\",AC11=\"C\",AC11=\"D\",AC11=\"F\",AND(AC11>=0,AC11<=4,ISNUMBER(AC11))),IF(AG11<>\"\",AG11,3),\"\")","v":""},{"$f":"IF(OR(AC11=\"A\",AC11=\"B\",AC11=\"C\",AC11=\"D\",AC11=\"P\",AND(AC11>=0,AC11<=4,ISNUMBER(AC11))),IF(AG11<>\"\",AG11,3),\"\")","v":""}]
["MATH",1613,null,null,0,"","",null,null,null,null,null,null,null,null,null,"ANSI",2253,null,0,"","",null,null,null,null,"ANSI",3423,null,{"$f":"IF(AG12<>\"\",AG12,3)*IF(AC12=\"A\",4,IF(AC12=\"B\",3,IF(AC12=\"C\",2,IF(AC12=\"D\",1,IF(AND(AC12>=0,AC12<=4,ISNUMBER(AC12)),AC12,0)))))","v":0},{"$f":"IF(OR(AC12=\"A\",AC12=\"B\",AC12=\"C\",AC12=\"D\",AC12=\"F\",AND(AC12>=0,AC12<=4,ISNUMBER(AC12))),IF(AG12<>\"\",AG12,3),\"\")","v":""},{"$f":"IF(OR(AC12=\"A\",AC12=\"B\",AC12=\"C\",AC12=\"D\",AC12=\"P\",AND(AC12>=0,AC12<=4,ISNUMBER(AC12))),IF(AG12<>\"\",AG12,3),\"\")","v":""}]
["(H)",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,"CHEM",1314,null,0,"","",4,null,null,null,"ANSI",3433,null,0,"",""]
["(H)",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,"CHEM",1225,null,0,"","",5,null,null,null,"ANSI",3443,null,0,"",""]
["(N)",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,"AGCM",3103,null,0,"","",null,null,null,null,"ANSI",3543,null,0,"",""]
["BIOL",1114,null,null,0,"","",4,null,null,null,null,null,null,null,null,"SPCH",2713,null,0,"","",null,null,null,null,"ANSI",3623,null,0,"",""]
["AGEC",1113,null,null,0,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANSI",3653,null,0,"",""]
["GENED",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANSI",4803,null,0,"",""]
["GENED",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graduate Semester",null,null,"ANSI",4863,null,0,"",""]
["(D)",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,"Credits and GPAs as of this date:",null,null,null,null,null,null,null,null,null,"ENTO",3003,null,0,"",""]
["(I)",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,{"$f":"SUM(G7:G21,V7:V16,AF9:AF22,AF27:AF29,AF33:AF35,G26:G41,O26:O41)","v":0},null,"Hours for graduation",null,null,null,null,null,null,null,null,null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F7:F21,AE9:AE22,AE27:AE29, AE33:AE35,F26:F41,N26:N41, U7:U12)=0,\"N/A\",ROUNDDOWN(SUM(E7:E21,T7:T16,AD9:AD22,AD27:AD29,AD33:AD35,E26:E41,M26:M41)/SUM(F7:F21,U7:U16,AE9:AE22,AE27:AE29,AE33:AE35,F26:F41,N26:N41),2))","v":"N/A"},null,"Grad/Ret GPA",null,null,null,null,null,null,null,null,null,null,0,"",""]
["Elective Hours:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B21,\">2999\",F7:G21)+SUMIF(B26:B41,\">2999\",F26:G41)+SUMIF(J26:J41,\">2999\",N26:N41)+SUMIF(R7:R16,\">2999\",U7:U16)+SUMIF(AB9:AB25,\">2999\",AE9:AE25)+SUMIF(AB27:AB38,\">2999\",AE27:AE38)","v":0},null,"UPPER DIV HOURS (40)"]
["Non-Ag",null,null,null,null,null,null,null,"Ag Elect",null,null,null,null,null,null,null,{"$f":"SUMIF(B7:B21,\">2999\",E7:E21)+SUMIF(B26:B41,\">2999\",E26:G41)+SUMIF(J26:J41,\">2999\",M26:M41)+SUMIF(R7:R16,\">2999\",T7:V16)+SUMIF(AB9:AB25,\">2999\",AD9:AD25)+SUMIF(AB27:AB29,\">2999\",AD27:AD29)+SUMIF(AB33:AB38,\">2999\",AD33:AD38)","v":0},null,"Upper div points (100)",null,null,null,null,null,null,null,"9 hours from species: "]
["Course",null,"Grd","Cr",null,null,null,null,"Course",null,"Grd","Cr",null,null,null,null,{"$f":"IF(SUM(Q24)=0,\"N/A\",Q24/Q23)","v":"N/A"},null,"Upper div GPA"]
[null,null,null,null,{"$f":"D26*IF(OR(C26=\"A\",C26=\"RA\"),4,IF(OR(C26=\"B\",C26=\"RB\"),3,IF(OR(C26=\"C\",C26=\"RC\"),2,IF(OR(C26=\"D\",C26=\"RD\"),1,IF(AND(C26>=0,C26<=4,ISNUMBER(C26)),C26,0)))))","v":0},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(OR(C26=\"A\",C26=\"B\",C26=\"C\",C26=\"D\",C26=\"F\",C26=\"RA\",C26=\"RB\",C26=\"RC\",C26=\"RD\",C26=\"RF\",AND(C26>=0,C26<=4,ISNUMBER(C26))),D26,\"\"))","v":""},{"$f":"IF(OR(C26=\"\",D26=\"\"),\"\",IF(OR(C26=\"A\",C26=\"B\",C26=\"C\",C26=\"D\",C26=\"P\",AND(C26>=0,C26<=4,ISNUMBER(C26))),D26,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,"60 Senior College Hours"]
[null,null,null,null,0,"","",null,null,null,null,null,"GPts","GPACr","GrCr",null,120,null,"HOURS NEEDED",null,null,null,null,null,null,null,"ANSI",null,null,{"$f":"IF(AG27<>\"\",AG27,3)*IF(AC27=\"A\",4,IF(AC27=\"B\",3,IF(AC27=\"C\",2,IF(AC27=\"D\",1,IF(AND(AC27>=0,AC27<=4,ISNUMBER(AC27)),AC27,0)))))","v":0},{"$f":"IF(OR(AC27=\"A\",AC27=\"B\",AC27=\"C\",AC27=\"D\",AC27=\"F\",AND(AC27>=0,AC27<=4,ISNUMBER(AC27))),IF(AG27<>\"\",AG27,3),\"\")","v":""},{"$f":"IF(OR(AC27=\"A\",AC27=\"B\",AC27=\"C\",AC27=\"D\",AC27=\"P\",AND(AC27>=0,AC27<=4,ISNUMBER(AC27))),IF(AG27<>\"\",AG27,3),\"\")","v":""}]
[null,null,null,null,0,"","",null,null,null,null,null,{"$f":"L26*IF(OR(K26=\"A\",K26=\"RA\"),4,IF(OR(K26=\"B\",K26=\"RB\"),3,IF(OR(K26=\"C\",K26=\"RC\"),2,IF(OR(K26=\"D\",K26=\"RD\"),1,IF(AND(K26>=0,K26=4,ISNUMBER(K26)),K26,0)))))","v":0},{"$f":"IF(OR(K26=\"\",L26=\"\"),\"\",IF(OR(K26=\"A\",K26=\"B\",K26=\"C\",K26=\"D\",K26=\"F\",K26=\"RA\",K26=\"RB\",K26=\"RC\",K26=\"RD\",K26=\"RF\",AND(K26>=0,K26<=4,ISNUMBER(K26))),L26,\"\"))","v":""},{"$f":"IF(OR(K26=\"\",L26=\"\"),\"\",IF(OR(K26=\"A\",K26=\"B\",K26=\"C\",K26=\"D\",K26=\"P\",AND(K26>=0,K26<=4,ISNUMBER(K26))),L26,\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,"ANSI",null,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"","",null,"NOTES:",null,null,null,null,null,null,null,null,null,"ANSI",null,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"","",null,null,null,null,null,null,null,null,null,null,null,"Related Courses: 6 Hours"]
[null,null,null,null,0,"","",null,null,null,null,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG33<>\"\",AG33,3)*IF(AC33=\"A\",4,IF(AC33=\"B\",3,IF(AC33=\"C\",2,IF(AC33=\"D\",1,IF(AND(AC33>=0,AC33<=4,ISNUMBER(AC33)),AC33,0)))))","v":0},{"$f":"IF(OR(AC33=\"A\",AC33=\"B\",AC33=\"C\",AC33=\"D\",AC33=\"F\",AND(AC33>=0,AC33<=4,ISNUMBER(AC33))),IF(AG33<>\"\",AG33,3),\"\")","v":""},{"$f":"IF(OR(AC33=\"A\",AC33=\"B\",AC33=\"C\",AC33=\"D\",AC33=\"P\",AND(AC33>=0,AC33<=4,ISNUMBER(AC33))),IF(AG33<>\"\",AG33,3),\"\")","v":""}]
[null,null,null,null,0,"","",null,null,null,null,null,0,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,0,"",""]

{"sheet":"GRAD CHECK","index":1,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,44,8],[24,1,24,5],[27,1,27,2],[28,1,28,3],[28,4,28,5],[38,1,38,8],[41,1,41,8],[20,2,20,3],[0,0,0,5],[1,0,1,5],[2,0,2,5],[6,1,6,3],[6,4,6,5],[9,1,9,3],[12,1,12,3],[12,4,12,6],[13,1,13,2],[15,1,15,2],[17,1,18,3]]}
["GRADUATION CHECK"]
["By"]
["COLLEGE OF AGRICULTURAL SCIENCES AND NATURAL RESOURCES"]
[]
[]
["Name:",null,null,null,"Date:"]
[null,{"$f":"'ANSI-PROD'!B1","v":"LNAME, FNAME"}]
[]
["ID:",null,null,null,"Graduation Date:"]
[null,{"$f":"'ANSI-PROD'!S1","v":"999-99-999"},null,null,{"$f":"'ANSI-PROD'!Q16","v":"SPCH"}]
[]
["EMAIL:",null,null,null,"Major:"]
[null,null,null,null,{"$f":"'ANSI-PROD'!Z1","v":"ANSI-PROD"}]
[]
["Advisor:",null,null,null,"Grad/Ret GPA:"]
[null,{"$f":"'ANSI-PROD'!AG1","v":"LNAME"},null,null,{"$f":"'ANSI-PROD'!Q19","v":0}]
[]
[null,"REMINDER:",null,null,"Upper Division GPA:"]
[null,null,null,null,{"$f":"'ANSI-PROD'!Q22","v":"N/A"}]
["Total Hours to Date:",null,{"$f":"'ANSI-PROD'!Q18","v":0},null,"Total  Upper Div Hours to Date:",{"$f":"'ANSI-PROD'!Q20","v":"Credits and GPAs as of this date:"}]
["Current Enrollment:",null,null,null,"Total  Upper Div Points to Date:",{"$f":"'ANSI-PROD'!Q21","v":0}]
[]
["Deficiencies/Remaining Hours:"]
[]
[]
[]
["Hours Needed from a 4 yr. School: ",null,null,null,"Upper Div. hours & points needed: "]
[]
[]
[]
["Number of hours needed to complete requirements:"]
[null,null,null,null,"(hrs. = current courses + deficiencies)"]
[]
[]
[]
[]
[]
["APPROVED BY:"]
[null,"________________________________________________________________________ Adviser/Date Signed"]
[]
[]
[null,"_______________________________________________________________ Department Head/Date Signed"]
[]
[]
[null,"____________________________________________________________________ Assoc. Dean/Date Signed"]

{"sheet":"ADVISOR'S NOTES","index":2,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE","NOTES"]

{"sheet":"CourseLeaf Degree Sheet","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}