{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["AGED-TCHG","GRAD CHECK","ADVISOR'S NOTES"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"AGED-TCHG","index":0,"n_rows":42,"n_cols":39,"rows_kept":42,"cut":false,"hidden":false,"merged":[[18,2,18,3],[18,8,18,11],[22,0,22,11],[19,2,19,3],[19,8,19,11],[20,2,20,3],[20,8,20,11],[23,33,23,34],[17,33,17,34],[12,33,12,34],[13,33,13,34],[12,23,12,24],[13,23,13,24],[18,23,18,24],[20,33,20,34],[16,33,16,34],[15,33,15,34],[14,33,14,34],[27,16,27,17],[22,16,22,17],[23,16,23,17],[20,16,20,22],[24,16,24,17],[25,16,25,17],[26,16,26,17],[24,33,24,34],[25,33,25,34],[26,33,26,34],[27,33,27,34],[29,33,29,34],[28,33,28,34],[43,33,43,34],[44,33,44,34],[28,16,28,17],[38,33,38,34],[39,33,39,34],[40,33,40,34],[30,33,30,34],[41,33,41,34],[42,33,42,34],[7,2,7,3],[7,8,7,11],[16,23,16,24],[7,23,7,24],[10,23,10,24],[11,23,11,24],[15,2,15,3],[15,8,15,11],[13,8,13,11],[13,2,13,3],[16,2,16,3],[16,8,16,11],[11,2,11,3],[11,8,11,11],[12,2,12,3],[12,8,12,11],[9,23,9,24],[8,23,8,24],[9,2,9,3],[9,8,9,11],[17,2,17,3],[15,23,15,24],[14,23,14,24],[17,23,17,24],[17,8,17,11],[14,2,14,3],[14,8,14,11],[11,33,11,34],[10,33,10,34],[0,1,0,16],[0,18,0,24],[0,32,0,34],[6,2,6,3],[6,8,6,11],[6,23,6,24],[0,25,0,27],[7,33,7,34],[10,2,10,3],[10,8,10,11],[8,33,8,34],[9,33,9,34],[8,2,8,3],[8,8,8,11]]}
["NAME:","Name, Student's",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ID:","999-999-99",null,null,null,null,null,null,"AGED-NRES",null,null,"ADV:",null,null,null,"ADVISOR"]
[]
["General Education Requirements: 40 Hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"College/Dept. Requirements: 33 Hours",null,null,null,null,null,null,null,null,null,"Major Requirements: 46 Hours",null,null,null,null,null,null,null,"2016-17"]
[]
["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,"Natural Resources: 19 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,"ANSI",1124,null,{"$f":"IF(W8<>\"\",W8,3)*IF(S8=\"A\",4,IF(S8=\"B\",3,IF(S8=\"C\",2,IF(S8=\"D\",1,IF(AND(S8>=0,S8<=4,ISNUMBER(S8)),S8,0)))))","v":0},{"$f":"IF(OR(S8=\"A\",S8=\"B\",S8=\"C\",S8=\"D\",S8=\"F\",AND(S8>=0,S8<=4,ISNUMBER(S8))),IF(W8<>\"\",W8,3),\"\")","v":""},{"$f":"IF(OR(S8=\"A\",S8=\"B\",S8=\"C\",S8=\"D\",S8=\"P\",AND(S8>=0,S8<=4,ISNUMBER(S8))),IF(W8<>\"\",W8,3),\"\")","v":""},4]
["HIST",1103,null,null,0,"","",null,null,null,null,null,null,null,null,null,"AGED",4713,null,0,"",""]
["POLS",1113,null,null,0,"","",null,null,null,null,null,null,null,null,null,"FDSC",1133,null,0,"",""]
["MATH",1513,null,null,0,"","",null,null,null,null,null,null,null,null,null,"HORT",1013,null,0,"",""]
["(H)",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,"PLNT",1213,null,0,"",""]
["(H)",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,"MCAG",3011,null,0,"","",1,null,null,null,"NREM",1014,null,{"$f":"IF(AG13<>\"\",AG13,3)*IF(AC13=\"A\",4,IF(AC13=\"B\",3,IF(AC13=\"C\",2,IF(AC13=\"D\",1,IF(AND(AC13>=0,AC13<=4,ISNUMBER(AC13)),AC13,0)))))","v":0},{"$f":"IF(OR(AC13=\"A\",AC13=\"B\",AC13=\"C\",AC13=\"D\",AC13=\"F\",AND(AC13>=0,AC13<=4,ISNUMBER(AC13))),IF(AG13<>\"\",AG13,3),\"\")","v":""},{"$f":"IF(OR(AC13=\"A\",AC13=\"B\",AC13=\"C\",AC13=\"D\",AC13=\"P\",AND(AC13>=0,AC13<=4,ISNUMBER(AC13))),IF(AG13<>\"\",AG13,3),\"\")","v":""},4]
["(N)",null,null,null,{"$f":"IF(H14<>\"\",H14,3)*IF(C14=\"A\",4,IF(C14=\"B\",3,IF(C14=\"C\",2,IF(C14=\"D\",1,IF(AND(C14>=0,C14<=4,ISNUMBER(C14)),C14,0)))))","v":0},{"$f":"IF(OR(C14=\"A\",C14=\"B\",C14=\"C\",C14=\"D\",C14=\"F\",AND(C14>=0,C14<=4,ISNUMBER(C14))),IF(H14<>\"\",H14,3),\"\")","v":""},{"$f":"IF(OR(C14=\"A\",C14=\"B\",C14=\"C\",C14=\"D\",C14=\"P\",AND(C14>=0,C14<=4,ISNUMBER(C14))),IF(H14<>\"\",H14,3),\"\")","v":""},null,null,null,null,null,null,null,null,null,"MCAG",3211,null,0,"","",1,null,null,null,"NREM",2013,null,0,"",""]
["CHEM",1314,null,null,0,"","",4,null,null,null,null,null,null,null,null,"MCAG",3222,null,0,"","",2,null,null,null,"NREM",null,null,0,"",""]
["AGEC",1113,null,null,0,"","",null,null,null,null,null,null,null,null,null,"MCAG",4101,null,0,"","",1,null,null,null,"NREM",null,null,0,"",""]
["AGCM",3203,null,null,0,"","",null,null,null,null,null,null,null,null,null,"SOIL",2124,null,0,"","",4,null,null,null,"NREM",null,null,0,"",""]
["GENED",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,"BIOL",1114,null,0,"","",4,null,null,null,"NREM",null,null,0,"",""]
["GENED",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,"AGCM",3103,null,0,"",""]
["(D)",null,null,null,{"$f":"IF(H20<>\"\",H20,3)*IF(C20=\"A\",4,IF(C20=\"B\",3,IF(C20=\"C\",2,IF(C20=\"D\",1,IF(AND(C20>=0,C20<=4,ISNUMBER(C20)),C20,0)))))","v":0},{"$f":"IF(OR(C20=\"A\",C20=\"B\",C20=\"C\",C20=\"D\",C20=\"F\",AND(C20>=0,C20<=4,ISNUMBER(C20))),IF(H20<>\"\",H20,3),\"\")","v":""},{"$f":"IF(OR(C20=\"A\",C20=\"B\",C20=\"C\",C20=\"D\",C20=\"P\",AND(C20>=0,C20<=4,ISNUMBER(C20))),IF(H20<>\"\",H20,3),\"\")","v":""}]
["(I)",null,null,null,0,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graduate Semester"]
[null,null,null,null,null,null,null,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,"Professional Core: 27 Hours",null,null,null,null,null,null,null,null,null,null,null,"patt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G7:G19,V7:V19,AF9:AF18,AF21:AF21,AF24:AF31,G27:G42,O27:O42)","v":0},null,"Hours for graduation"]
["Elective Hours:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F7:F19,U7:U19,AE9:AE18,AE24:AE31,F27:F42,N27:N42)=0,\"N/A\",ROUNDDOWN(SUM(E7:E19,T7:T19,AD9:AD18,AD24:AD31,E27:E42,M27:M42)/SUM(F7:F19,U7:U19,AE9:AE18,AE24:AE31,F27:F42,N27:N42),2))","v":"N/A"},null,"Grad/Ret GPA",null,null,null,null,null,null,null,"AGED",3101,null,{"$f":"IF(AG24<>\"\",AG24,3)*IF(AC24=\"A\",4,IF(AC24=\"B\",3,IF(AC24=\"C\",2,IF(AC24=\"D\",1,IF(AND(AC24>=0,AC24<=4,ISNUMBER(AC24)),AC24,0)))))","v":0},{"$f":"IF(OR(AC24=\"A\",AC24=\"B\",AC24=\"C\",AC24=\"D\",AC24=\"F\",AND(AC24>=0,AC24<=4,ISNUMBER(AC24))),IF(AG24<>\"\",AG24,3),\"\")","v":""},{"$f":"IF(OR(AC24=\"A\",AC24=\"B\",AC24=\"C\",AC24=\"D\",AC24=\"P\",AND(AC24>=0,AC24<=4,ISNUMBER(AC24))),IF(AG24<>\"\",AG24,3),\"\")","v":""},1]
["Non-Ag",null,null,null,null,null,null,null,null,"Ag Elect 6 hours ",null,null,null,null,null,null,{"$f":"SUMIF(B7:B19,\">2999\",F7:F19)+SUMIF(B27:B42,\">2999\",F27:F42)+SUMIF(J27:J42,\">2999\",L27:L42)+SUMIF(R7:R19,\">2999\",U7:U19)+SUMIF(AB9:AB18,\">2999\",AF9:AF18)+SUMIF(AB24:AB31,\">2999\",AF24:AF31)","v":0},null,"UPPER DIV HOURS (40)",null,null,null,null,null,null,null,"AGED",3103,null,0,"",""]
["Course",null,"Grd","Cr",null,null,null,null,"Course",null,"Grd","Cr","GPts","GPACr","GrCr",null,{"$f":"SUMIF(B7:B19,\">2999\",E7:E19)+SUMIF(B27:B42,\">2999\",E27:E42)+SUMIF(J27:J42,\">2999\",M27:O42)+SUMIF(R7:R19,\">2999\",T7:T19)+SUMIF(AB9:AB18,\">2999\",AD9:AD18)+SUMIF(AB24:AB31,\">2999\",AD24:AD31)","v":0},null,"Upper div points (100)",null,null,null,null,null,null,null,"AGED",3203,null,0,"",""]
[null,null,null,null,{"$f":"D27*IF(OR(C27=\"A\",C27=\"RA\"),4,IF(OR(C27=\"B\",C27=\"RB\"),3,IF(OR(C27=\"C\",C27=\"RC\"),2,IF(OR(C27=\"D\",C27=\"RD\"),1,IF(AND(C27>=0,C27<=4,ISNUMBER(C27)),C27,0)))))","v":0},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(OR(C27=\"A\",C27=\"B\",C27=\"C\",C27=\"D\",C27=\"F\",C27=\"RA\",C27=\"RB\",C27=\"RC\",C27=\"RD\",C27=\"RF\",AND(C27>=0,C27<=4,ISNUMBER(C27))),D27,\"\"))","v":""},{"$f":"IF(OR(C27=\"\",D27=\"\"),\"\",IF(OR(C27=\"A\",C27=\"B\",C27=\"C\",C27=\"D\",C27=\"P\",AND(C27>=0,C27<=4,ISNUMBER(C27))),D27,\"\"))","v":""},null,null,null,null,null,{"$f":"L27*IF(OR(K27=\"A\",K27=\"RA\"),4,IF(OR(K27=\"B\",K27=\"RB\"),3,IF(OR(K27=\"C\",K27=\"RC\"),2,IF(OR(K27=\"D\",K27=\"RD\"),1,IF(AND(K27>=0,K27=4,ISNUMBER(K27)),K27,0)))))","v":0},{"$f":"IF(OR(K27=\"\",L27=\"\"),\"\",IF(OR(K27=\"A\",K27=\"B\",K27=\"C\",K27=\"D\",K27=\"F\",K27=\"RA\",K27=\"RB\",K27=\"RC\",K27=\"RD\",K27=\"RF\",AND(K27>=0,K27<=4,ISNUMBER(K27))),L27,\"\"))","v":""},{"$f":"IF(OR(K27=\"\",L27=\"\"),\"\",IF(OR(K27=\"A\",K27=\"B\",K27=\"C\",K27=\"D\",K27=\"P\",AND(K27>=0,K27<=4,ISNUMBER(K27))),L27,\"\"))","v":""},null,{"$f":"IF(SUM(Q26)=0,\"N/A\",Q26/Q25)","v":"N/A"},null,"Upper div GPA",null,null,null,null,null,null,null,"AGED",4103,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"","",null,null,null,"60 Senior College Hours",null,null,null,null,null,null,null,"AGED",4113,null,0,"",""]
[null,null,null,null,0,"","",null,null,null,null,null,0,"","",null,125,null,"HOURS NEEDED",null,null,null,null,null,null,null,"AGED",4200,null,0,"","",9]
[null,null,null,null,0,"","",null,null,null,null,null,0,"","",null,null,null,null,null,null,null,null,null,null,null,"EPSY",3213,null,{"$f":"IF(AG30<>\"\",AG30,3)*IF(AC30=\"A\",4,IF(AC30=\"B\",3,IF(AC30=\"C\",2,IF(AC30=\"D\",1,IF(AND(AC30>=0,AC30<=4,ISNUMBER(AC30)),AC30,0)))))","v":0},{"$f":"IF(OR(AC30=\"A\",AC30=\"B\",AC30=\"C\",AC30=\"D\",AC30=\"F\",AND(AC30>=0,AC30<=4,ISNUMBER(AC30))),IF(AG30<>\"\",AG30,3),\"\")","v":""},{"$f":"IF(OR(AC30=\"A\",AC30=\"B\",AC30=\"C\",AC30=\"D\",AC30=\"P\",AND(AC30>=0,AC30<=4,ISNUMBER(AC30))),IF(AG30<>\"\",AG30,3),\"\")","v":""}]
[null,null,null,null,0,"","",null,null,null,null,null,0,"","",null,"NOTES:",null,null,null,null,null,null,null,null,null,"SPED",3202,null,0,"","",2]
[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,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,"",""]

{"sheet":"GRAD CHECK","index":1,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[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],[18,1,18,2],[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]]}
["GRADUATION CHECK"]
["By"]
["COLLEGE OF AGRICULTURE SCIENCES AND NATURAL RESOURCES"]
[]
[]
["Name:",null,null,null,"Date:"]
[null,{"$f":"'AGED-TCHG'!B1:Q1","v":"Name, Student's"}]
[]
["ID:",null,null,null,"Graduation Date:"]
[null,{"$f":"'AGED-TCHG'!S1","v":"999-999-99"},null,null,{"$f":"'AGED-TCHG'!Q21","v":"00:00:00"}]
[]
["EMAIL:",null,null,null,"Major:"]
[null,null,null,null,{"$f":"'AGED-TCHG'!Z1","v":"AGED-NRES"}]
[]
["Advisor:",null,null,null,"Grad/Ret GPA:"]
[null,{"$f":"'AGED-TCHG'!AG1","v":"ADVISOR"},null,null,{"$f":"'AGED-TCHG'!Q24","v":"N/A"}]
[]
[null,"REMINDER:",null,null,"Upper Division GPA:"]
[null,null,null,null,{"$f":"'AGED-TCHG'!Q27","v":"N/A"}]
["Total Hours to Date:",null,{"$f":"'AGED-TCHG'!Q23","v":0},null,"Total  Upper Div Hours to Date:",{"$f":"'AGED-TCHG'!Q25","v":0}]
["Current Enrollment:",null,null,null,"Total  Upper Div Points to Date:",{"$f":"'AGED-TCHG'!Q26","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"]