{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Form 48","Background Lists"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Form 48","index":0,"n_rows":223,"n_cols":15,"rows_kept":223,"cut":false,"hidden":false,"merged":[[20,4,20,10],[15,1,15,3],[15,4,15,10],[16,1,16,3],[16,4,16,10],[17,1,17,3],[17,4,17,10],[9,2,9,4],[9,6,9,8],[11,1,11,3],[11,4,11,10],[9,10,10,14],[18,1,18,3],[60,1,60,3],[61,1,61,3],[55,2,55,4],[55,6,55,8],[57,1,57,3],[57,4,57,10],[54,1,54,14],[55,10,56,14],[59,4,59,10],[60,4,60,10],[61,4,61,10],[58,1,58,3],[58,4,58,10],[59,1,59,3],[49,1,49,3],[50,1,50,3],[48,4,48,10],[49,4,49,10],[50,4,50,10],[47,1,47,3],[47,4,47,10],[48,1,48,3],[18,4,18,10],[40,1,40,4],[40,5,40,8],[45,2,45,4],[45,6,45,8],[41,9,42,11],[38,1,38,3],[38,4,38,10],[35,1,35,3],[35,4,35,10],[36,1,36,3],[36,4,36,10],[37,1,37,3],[37,4,37,10],[32,1,32,3],[32,4,32,10],[41,12,42,12],[41,1,42,3],[41,4,42,4],[41,5,42,7],[41,8,42,8],[31,4,31,10],[1,1,1,4],[1,5,1,9],[2,1,2,4],[2,5,2,7],[3,1,3,13],[5,7,6,7],[5,8,6,8],[5,9,6,10],[5,11,6,11],[5,12,6,12],[2,10,2,13],[1,10,1,14],[4,7,4,14],[5,13,6,14],[4,1,4,2],[5,1,5,2],[6,1,6,2],[4,4,5,5],[4,6,5,6],[6,4,6,5],[19,1,19,3],[12,1,12,3],[12,4,12,10],[28,4,28,10],[24,1,24,4],[24,6,24,8],[23,10,23,14],[24,10,24,13],[26,6,26,8],[28,1,28,3],[13,1,13,3],[13,4,13,10],[14,1,14,3],[14,4,14,10],[21,1,21,3],[21,4,21,10],[26,2,26,4],[23,1,23,5],[23,6,23,9],[8,1,8,14],[19,4,19,10],[20,1,20,3],[33,1,33,3],[33,4,33,10],[34,1,34,3],[34,4,34,10],[29,1,29,3],[29,4,29,10],[30,1,30,3],[30,4,30,10],[31,1,31,3],[62,4,62,10],[63,4,63,10],[64,4,64,10],[65,4,65,10],[66,4,66,10],[67,4,67,10],[62,1,62,3],[63,1,63,3],[64,1,64,3],[65,1,65,3],[66,1,66,3],[72,2,72,4],[72,6,72,8],[74,1,74,3],[74,4,74,10],[67,1,67,3],[70,10,70,13],[69,10,69,14],[75,1,75,3],[69,1,69,5],[69,6,69,9],[70,1,70,4],[70,6,70,8],[81,1,81,3],[82,1,82,3],[83,1,83,3],[84,1,84,3],[75,4,75,10],[76,4,76,10],[77,4,77,10],[78,4,78,10],[79,4,79,10],[80,4,80,10],[81,4,81,10],[82,4,82,10],[83,4,83,10],[84,4,84,10],[76,1,76,3],[77,1,77,3],[78,1,78,3],[79,1,79,3],[80,1,80,3],[90,2,90,4],[90,6,90,8],[92,1,92,3],[92,4,92,10],[86,1,86,4],[86,5,86,8],[87,9,87,11],[87,1,87,3],[87,5,87,7],[99,1,99,14],[100,2,100,4],[100,6,100,8],[102,1,102,3],[102,4,102,10],[93,1,93,3],[93,4,93,10],[94,1,94,3],[94,4,94,10],[95,1,95,3],[95,4,95,10],[100,10,101,14],[106,1,106,3],[106,4,106,10],[107,1,107,3],[107,4,107,10],[108,1,108,3],[108,4,108,10],[103,1,103,3],[103,4,103,10],[104,1,104,3],[104,4,104,10],[105,1,105,3],[105,4,105,10],[112,1,112,3],[112,4,112,10],[114,1,114,5],[114,6,114,9],[109,1,109,3],[109,4,109,10],[110,1,110,3],[110,4,110,10],[111,1,111,3],[111,4,111,10],[114,10,114,14],[119,1,119,3],[119,4,119,10],[120,1,120,3],[120,4,120,10],[121,1,121,3],[121,4,121,10],[117,2,117,4],[117,6,117,8],[115,1,115,4],[115,6,115,8],[115,10,115,13],[125,1,125,3],[125,4,125,10],[126,1,126,3],[126,4,126,10],[127,1,127,3],[127,4,127,10],[122,1,122,3],[122,4,122,10],[123,1,123,3],[123,4,123,10],[124,1,124,3],[124,4,124,10],[132,9,132,11],[135,2,135,4],[135,6,135,8],[128,1,128,3],[128,4,128,10],[129,1,129,3],[129,4,129,10],[131,1,131,4],[131,5,131,8],[132,1,132,3],[132,5,132,7],[140,1,140,3],[140,4,140,10],[145,2,145,4],[145,6,145,8],[137,1,137,3],[137,4,137,10],[138,1,138,3],[138,4,138,10],[139,1,139,3],[139,4,139,10],[145,10,146,14],[144,1,144,14],[150,1,150,3],[150,4,150,10],[151,1,151,3],[151,4,151,10],[152,1,152,3],[152,4,152,10],[147,1,147,3],[147,4,147,10],[148,1,148,3],[148,4,148,10],[149,1,149,3],[149,4,149,10],[156,1,156,3],[156,4,156,10],[157,1,157,3],[157,4,157,10],[159,1,159,5],[159,6,159,9],[153,1,153,3],[153,4,153,10],[154,1,154,3],[154,4,154,10],[155,1,155,3],[155,4,155,10],[159,10,159,14],[164,1,164,3],[164,4,164,10],[165,1,165,3],[165,4,165,10],[166,1,166,3],[166,4,166,10],[162,2,162,4],[162,6,162,8],[160,1,160,4],[160,6,160,8],[160,10,160,13],[170,1,170,3],[170,4,170,10],[171,1,171,3],[171,4,171,10],[172,1,172,3],[172,4,172,10],[167,1,167,3],[167,4,167,10],[168,1,168,3],[168,4,168,10],[169,1,169,3],[169,4,169,10],[177,9,177,11],[180,2,180,4],[180,6,180,8],[173,1,173,3],[173,4,173,10],[174,1,174,3],[174,4,174,10],[176,1,176,4],[176,5,176,8],[177,1,177,3],[177,5,177,7],[185,1,185,3],[185,4,185,10],[190,2,190,4],[190,6,190,8],[182,1,182,3],[182,4,182,10],[183,1,183,3],[183,4,183,10],[184,1,184,3],[184,4,184,10],[189,1,189,14],[190,10,191,14],[195,1,195,3],[195,4,195,10],[196,1,196,3],[196,4,196,10],[197,1,197,3],[197,4,197,10],[192,1,192,3],[192,4,192,10],[193,1,193,3],[193,4,193,10],[194,1,194,3],[194,4,194,10],[201,1,201,3],[201,4,201,10],[202,1,202,3],[202,4,202,10],[204,1,204,5],[204,6,204,9],[198,1,198,3],[198,4,198,10],[199,1,199,3],[199,4,199,10],[200,1,200,3],[200,4,200,10],[204,10,204,14],[209,4,209,10],[210,1,210,3],[210,4,210,10],[211,1,211,3],[211,4,211,10],[207,2,207,4],[207,6,207,8],[205,1,205,4],[205,6,205,8],[205,10,205,13],[41,13,42,13],[41,14,42,14],[222,9,222,11],[218,1,218,3],[218,4,218,10],[219,1,219,3],[219,4,219,10],[221,1,221,4],[221,5,221,8],[222,1,222,3],[222,5,222,7],[215,1,215,3],[215,4,215,10],[216,1,216,3],[216,4,216,10],[217,1,217,3],[217,4,217,10],[212,1,212,3],[212,4,212,10],[213,1,213,3],[213,4,213,10],[214,1,214,3],[214,4,214,10],[209,1,209,3]]}
[]
[null,"Name (Last, First MI)",null,null,null,"Academic Institution/AFROTC Detachment",null,null,null,null,"Academic Major / Major Code"]
[null,null,null,null,null,null,null,null,"/",675]
[]
[null,"OU checksheet Hour Rqmt:",null,null,"Transfer Credit Hours that are included in Cum GPA:",null,null,"Completion of this plan should result in"]
[null,"Advanced Placement Hours:",null,null,null,null,null,"a",null,"Degree after",null,null,"Term"]
[null,"Hours Required for Degree:",null,null,"Points Transferred:"]
[]
[null,"AS 100 Year"]
[null,"Term:",null,null,null,"Year:",null,null,null,null,"Fall Certification:"]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N13=\"I\",N13=\"W\",ISBLANK(N13)),\"\",IF(N13=\"A\",4*L13,IF(N13=\"B\",3*L13,IF(N13=\"C\",2*L13,IF(N13=\"D\",1*L13,IF(N13=\"A-\",3.75*L13,IF(N13=\"B+\",3.25*L13,IF(N13=\"B-\",2.75*L13,IF(N13=\"C+\",2.25*L13,IF(N13=\"C-\",1.75*L13,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N14=\"I\",N14=\"W\",ISBLANK(N14)),\"\",IF(N14=\"A\",4*L14,IF(N14=\"B\",3*L14,IF(N14=\"C\",2*L14,IF(N14=\"D\",1*L14,IF(N14=\"A-\",3.75*L14,IF(N14=\"B+\",3.25*L14,IF(N14=\"B-\",2.75*L14,IF(N14=\"C+\",2.25*L14,IF(N14=\"C-\",1.75*L14,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N15=\"I\",N15=\"W\",ISBLANK(N15)),\"\",IF(N15=\"A\",4*L15,IF(N15=\"B\",3*L15,IF(N15=\"C\",2*L15,IF(N15=\"D\",1*L15,IF(N15=\"A-\",3.75*L15,IF(N15=\"B+\",3.25*L15,IF(N15=\"B-\",2.75*L15,IF(N15=\"C+\",2.25*L15,IF(N15=\"C-\",1.75*L15,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N22=\"I\",N22=\"W\",ISBLANK(N22)),\"\",IF(N22=\"A\",4*L22,IF(N22=\"B\",3*L22,IF(N22=\"C\",2*L22,IF(N22=\"D\",1*L22,IF(N22=\"A-\",3.75*L22,IF(N22=\"B+\",3.25*L22,IF(N22=\"B-\",2.75*L22,IF(N22=\"C+\",2.25*L22,IF(N22=\"C-\",1.75*L22,0))))))))))","v":""}]
[]
[null,"Academic Advisor Reviewed / Date",null,null,null,null,"Cadet Reviewed / Date",null,null,null,"AFROTC Cadre Reviewed / Date"]
[]
[]
[null,"Term:",null,null,null,"Year:",null,null,null,null,"Totals:",{"$f":"SUMIFS(L13:L22,N13:N22,\"<>W\",N13:N22,\"<>I\")","v":0},{"$f":"SUMIFS(M13:M22,N13:N22,\"<>F\",N13:N22,\"<>W\",N13:N22,\"<>I\",N13:N22,\"<>U\",N13:N22,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L13:L22,N13:N22,\"<>\",N13:N22,\"<>I\",N13:N22,\"<>W\",N13:N22,\"<>P\",N13:N22,\"<>S\",N13:N22,\"<>R\")>0,SUMIFS(O13:O22,N13:N22,\"<>\",N13:N22,\"<>I\",N13:N22,\"<>W\",N13:N22,\"<>S\",N13:N22,\"<>R\")/SUMIFS(L13:L22,N13:N22,\"<>\",N13:N22,\"<>I\",N13:N22,\"<>W\",N13:N22,\"<>P\",N13:N22,\"<>S\",N13:N22,\"<>R\"),\"\")","v":""}]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N30=\"I\",N30=\"W\",ISBLANK(N30)),\"\",IF(N30=\"A\",4*L30,IF(N30=\"B\",3*L30,IF(N30=\"C\",2*L30,IF(N30=\"D\",1*L30,IF(N30=\"A-\",3.75*L30,IF(N30=\"B+\",3.25*L30,IF(N30=\"B-\",2.75*L30,IF(N30=\"C+\",2.25*L30,IF(N30=\"C-\",1.75*L30,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N31=\"I\",N31=\"W\",ISBLANK(N31)),\"\",IF(N31=\"A\",4*L31,IF(N31=\"B\",3*L31,IF(N31=\"C\",2*L31,IF(N31=\"D\",1*L31,IF(N31=\"A-\",3.75*L31,IF(N31=\"B+\",3.25*L31,IF(N31=\"B-\",2.75*L31,IF(N31=\"C+\",2.25*L31,IF(N31=\"C-\",1.75*L31,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N32=\"I\",N32=\"W\",ISBLANK(N32)),\"\",IF(N32=\"A\",4*L32,IF(N32=\"B\",3*L32,IF(N32=\"C\",2*L32,IF(N32=\"D\",1*L32,IF(N32=\"A-\",3.75*L32,IF(N32=\"B+\",3.25*L32,IF(N32=\"B-\",2.75*L32,IF(N32=\"C+\",2.25*L32,IF(N32=\"C-\",1.75*L32,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N39=\"I\",N39=\"W\",ISBLANK(N39)),\"\",IF(N39=\"A\",4*L39,IF(N39=\"B\",3*L39,IF(N39=\"C\",2*L39,IF(N39=\"D\",1*L39,IF(N39=\"A-\",3.75*L39,IF(N39=\"B+\",3.25*L39,IF(N39=\"B-\",2.75*L39,IF(N39=\"C+\",2.25*L39,IF(N39=\"C-\",1.75*L39,0))))))))))","v":""}]
[]
[null,"Cadet Reviewed / Date",null,null,null,"AFROTC Cadre Reviewed / Date",null,null,null,null,"Totals:",{"$f":"SUMIFS(L30:L39,N30:N39,\"<>W\",N30:N39,\"<>I\")","v":0},{"$f":"SUMIFS(M30:M39,N30:N39,\"<>F\",N30:N39,\"<>W\",N30:N39,\"<>I\",N30:N39,\"<>U\",N30:N39,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L30:L39,N30:N39,\"<>\",N30:N39,\"<>I\",N30:N39,\"<>W\",N30:N39,\"<>P\",N30:N39,\"<>S\",N30:N39,\"<>R\")>0,SUMIFS(O30:O39,N30:N39,\"<>\",N30:N39,\"<>I\",N30:N39,\"<>W\",N30:N39,\"<>S\",N30:N39,\"<>R\")/SUMIFS(L30:L39,N30:N39,\"<>\",N30:N39,\"<>I\",N30:N39,\"<>W\",N30:N39,\"<>P\",N30:N39,\"<>S\",N30:N39,\"<>R\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Credits Remaining After Freshman Year:",null,null,{"$f":"D7-M27-M41","v":0},"CGPA:",{"$f":"IF((G5+SUMIFS(L13:L22,N13:N22,\"<>\",N13:N22,\"<>I\",N13:N22,\"<>W\",N13:N22,\"<>P\",N13:N22,\"<>S\",N13:N22,\"<>R\")+SUMIFS(L30:L39,N30:N39,\"<>\",N30:N39,\"<>I\",N30:N39,\"<>W\",N30:N39,\"<>P\",N30:N39,\"<>S\",N30:N39,\"<>R\"))>0,(G7+SUMIFS(O13:O22,N13:N22,\"<>\",N13:N22,\"<>I\",N13:N22,\"<>W\")+SUMIFS(O30:O39,N30:N39,\"<>\",N30:N39,\"<>I\",N30:N39,\"<>W\"))/(G5+SUMIFS(L13:L22,N13:N22,\"<>\",N13:N22,\"<>I\",N13:N22,\"<>W\",N13:N22,\"<>P\",N13:N22,\"<>S\",N13:N22,\"<>R\")+SUMIFS(L30:L39,N30:N39,\"<>\",N30:N39,\"<>I\",N30:N39,\"<>W\",N30:N39,\"<>P\",N30:N39,\"<>S\",N30:N39,\"<>R\")),\"\")","v":""}]
[]
[]
[]
[null,"Term:",null,null,null,"Year:",null,null,null,null,null,{"$f":"(G5+SUMIFS(L13:L22,N13:N22,\"<>\",N13:N22,\"<>I\",N13:N22,\"<>W\",N13:N22,\"<>P\",N13:N22,\"<>S\",N13:N22,\"<>R\")+SUMIFS(L30:L39,N30:N39,\"<>\",N30:N39,\"<>I\",N30:N39,\"<>W\",N30:N39,\"<>P\",N30:N39,\"<>S\",N30:N39,\"<>R\"))","v":0},null,null,{"$f":"(G7+SUMIFS(O13:O22,N13:N22,\"<>\",N13:N22,\"<>I\",N13:N22,\"<>W\",N13:N22,\"<>P\",N13:N22,\"<>S\")+SUMIFS(O30:O39,N30:N39,\"<>\",N30:N39,\"<>I\",N30:N39,\"<>W\",N30:N39,\"<>P\",N30:N39,\"<>S\"))","v":0}]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N49=\"I\",N49=\"W\",ISBLANK(N49)),\"\",IF(N49=\"A\",4*L49,IF(N49=\"B\",3*L49,IF(N49=\"C\",2*L49,IF(N49=\"D\",1*L49,IF(N49=\"A-\",3.75*L49,IF(N49=\"B+\",3.25*L49,IF(N49=\"B-\",2.75*L49,IF(N49=\"C+\",2.25*L49,IF(N49=\"C-\",1.75*L49,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N50=\"I\",N50=\"W\",ISBLANK(N50)),\"\",IF(N50=\"A\",4*L50,IF(N50=\"B\",3*L50,IF(N50=\"C\",2*L50,IF(N50=\"D\",1*L50,IF(N50=\"A-\",3.75*L50,IF(N50=\"B+\",3.25*L50,IF(N50=\"B-\",2.75*L50,IF(N50=\"C+\",2.25*L50,IF(N50=\"C-\",1.75*L50,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N51=\"I\",N51=\"W\",ISBLANK(N51)),\"\",IF(N51=\"A\",4*L51,IF(N51=\"B\",3*L51,IF(N51=\"C\",2*L51,IF(N51=\"D\",1*L51,IF(N51=\"A-\",3.75*L51,IF(N51=\"B+\",3.25*L51,IF(N51=\"B-\",2.75*L51,IF(N51=\"C+\",2.25*L51,IF(N51=\"C-\",1.75*L51,0))))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUMIFS(L49:L51,N49:N51,\"<>I\",N49:N51,\"<>W\")","v":0},{"$f":"SUMIFS(M49:M51,N49:N51,\"<>F\",N49:N51,\"<>W\",N49:N51,\"<>I\",N49:N51,\"<>U\",N49:N51,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L49:L51,N49:N51,\"<>\",N49:N51,\"<>I\",N49:N51,\"<>W\",N49:N51,\"<>P\",N49:N51,\"<>S\",N49:N51,\"<>R\")>0,SUMIFS(O49:O51,N49:N51,\"<>\",N49:N51,\"<>I\",N49:N51,\"<>W\",N49:N51,\"<>S\")/SUMIFS(L49:L51,N49:N51,\"<>\",N49:N51,\"<>I\",N49:N51,\"<>W\",N49:N51,\"<>P\",N49:N51,\"<>S\",N49:N51,\"<>R\"),\"\")","v":""}]
[]
[null,"AS 200/250 Year"]
[null,"Term:",null,null,null,"Year:",null,null,null,null,"Fall Certification:"]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N59=\"I\",N59=\"W\",ISBLANK(N59)),\"\",IF(N59=\"A\",4*L59,IF(N59=\"B\",3*L59,IF(N59=\"C\",2*L59,IF(N59=\"D\",1*L59,IF(N59=\"A-\",3.75*L59,IF(N59=\"B+\",3.25*L59,IF(N59=\"B-\",2.75*L59,IF(N59=\"C+\",2.25*L59,IF(N59=\"C-\",1.75*L59,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N60=\"I\",N60=\"W\",ISBLANK(N60)),\"\",IF(N60=\"A\",4*L60,IF(N60=\"B\",3*L60,IF(N60=\"C\",2*L60,IF(N60=\"D\",1*L60,IF(N60=\"A-\",3.75*L60,IF(N60=\"B+\",3.25*L60,IF(N60=\"B-\",2.75*L60,IF(N60=\"C+\",2.25*L60,IF(N60=\"C-\",1.75*L60,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N61=\"I\",N61=\"W\",ISBLANK(N61)),\"\",IF(N61=\"A\",4*L61,IF(N61=\"B\",3*L61,IF(N61=\"C\",2*L61,IF(N61=\"D\",1*L61,IF(N61=\"A-\",3.75*L61,IF(N61=\"B+\",3.25*L61,IF(N61=\"B-\",2.75*L61,IF(N61=\"C+\",2.25*L61,IF(N61=\"C-\",1.75*L61,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N68=\"I\",N68=\"W\",ISBLANK(N68)),\"\",IF(N68=\"A\",4*L68,IF(N68=\"B\",3*L68,IF(N68=\"C\",2*L68,IF(N68=\"D\",1*L68,IF(N68=\"A-\",3.75*L68,IF(N68=\"B+\",3.25*L68,IF(N68=\"B-\",2.75*L68,IF(N68=\"C+\",2.25*L68,IF(N68=\"C-\",1.75*L68,0))))))))))","v":""}]
[]
[null,"Academic Advisor Reviewed / Date",null,null,null,null,"Cadet Reviewed / Date",null,null,null,"AFROTC Cadre Reviewed / Date"]
[]
[]
[null,"Term:",null,null,null,"Year:",null,null,null,null,"Totals:",{"$f":"SUMIFS(L59:L68,N59:N68,\"<>W\",N59:N68,\"<>I\")","v":0},{"$f":"SUMIFS(M59:M68,N59:N68,\"<>F\",N59:N68,\"<>W\",N59:N68,\"<>I\",N59:N68,\"<>U\",N59:N68,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L59:L68,N59:N68,\"<>\",N59:N68,\"<>I\",N59:N68,\"<>W\",N59:N68,\"<>P\",N59:N68,\"<>S\",N59:N68,\"<>R\")>0,SUMIFS(O59:O68,N59:N68,\"<>\",N59:N68,\"<>I\",N59:N68,\"<>W\",N59:N68,\"<>S\")/SUMIFS(L59:L68,N59:N68,\"<>\",N59:N68,\"<>I\",N59:N68,\"<>W\",N59:N68,\"<>P\",N59:N68,\"<>S\",N59:N68,\"<>R\"),\"\")","v":""}]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N76=\"I\",N76=\"W\",ISBLANK(N76)),\"\",IF(N76=\"A\",4*L76,IF(N76=\"B\",3*L76,IF(N76=\"C\",2*L76,IF(N76=\"D\",1*L76,IF(N76=\"A-\",3.75*L76,IF(N76=\"B+\",3.25*L76,IF(N76=\"B-\",2.75*L76,IF(N76=\"C+\",2.25*L76,IF(N76=\"C-\",1.75*L76,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N77=\"I\",N77=\"W\",ISBLANK(N77)),\"\",IF(N77=\"A\",4*L77,IF(N77=\"B\",3*L77,IF(N77=\"C\",2*L77,IF(N77=\"D\",1*L77,IF(N77=\"A-\",3.75*L77,IF(N77=\"B+\",3.25*L77,IF(N77=\"B-\",2.75*L77,IF(N77=\"C+\",2.25*L77,IF(N77=\"C-\",1.75*L77,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N78=\"I\",N78=\"W\",ISBLANK(N78)),\"\",IF(N78=\"A\",4*L78,IF(N78=\"B\",3*L78,IF(N78=\"C\",2*L78,IF(N78=\"D\",1*L78,IF(N78=\"A-\",3.75*L78,IF(N78=\"B+\",3.25*L78,IF(N78=\"B-\",2.75*L78,IF(N78=\"C+\",2.25*L78,IF(N78=\"C-\",1.75*L78,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N85=\"I\",N85=\"W\",ISBLANK(N85)),\"\",IF(N85=\"A\",4*L85,IF(N85=\"B\",3*L85,IF(N85=\"C\",2*L85,IF(N85=\"D\",1*L85,IF(N85=\"A-\",3.75*L85,IF(N85=\"B+\",3.25*L85,IF(N85=\"B-\",2.75*L85,IF(N85=\"C+\",2.25*L85,IF(N85=\"C-\",1.75*L85,0))))))))))","v":""}]
[]
[null,"Cadet Reviewed / Date",null,null,null,"AFROTC Cadre Reviewed / Date",null,null,null,null,"Totals:",{"$f":"SUMIFS(L76:L85,N76:N85,\"<>W\",N76:N85,\"<>I\")","v":0},{"$f":"SUMIFS(M76:M85,N76:N85,\"<>F\",N76:N85,\"<>W\",N76:N85,\"<>I\",N76:N85,\"<>U\",N76:N85,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L76:L85,N76:N85,\"<>\",N76:N85,\"<>I\",N76:N85,\"<>W\",N76:N85,\"<>P\",N76:N85,\"<>S\",N76:N85,\"<>R\")>0,SUMIFS(O76:O85,N76:N85,\"<>\",N76:N85,\"<>I\",N76:N85,\"<>W\",N76:N85,\"<>S\")/SUMIFS(L76:L85,N76:N85,\"<>\",N76:N85,\"<>I\",N76:N85,\"<>W\",N76:N85,\"<>P\",N76:N85,\"<>S\",N76:N85,\"<>R\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Credits Remaining After Sophomore Year:",null,null,{"$f":"M42-M53-M73-M87","v":0},"CGPA:",{"$f":"IF((L46+SUMIFS(L49:L51,N49:N51,\"<>\",N49:N51,\"<>I\",N49:N51,\"<>W\",N49:N51,\"<>P\",N49:N51,\"<>S\",N49:N51,\"<>R\")+SUMIFS(L59:L68,N59:N68,\"<>\",N59:N68,\"<>I\",N59:N68,\"<>W\",N59:N68,\"<>P\",N59:N68,\"<>S\",N59:N68,\"<>R\")+SUMIFS(L76:L85,N76:N85,\"<>\",N76:N85,\"<>I\",N76:N85,\"<>W\",N76:N85,\"<>P\",N76:N85,\"<>S\",N76:N85,\"<>R\"))>0,(O46+SUMIFS(O49:O51,N49:N51,\"<>\",N49:N51,\"<>I\",N49:N51,\"<>W\")+SUMIFS(O59:O68,N59:N68,\"<>\",N59:N68,\"<>I\",N59:N68,\"<>W\")+SUMIFS(O76:O85,N76:N85,\"<>\",N76:N85,\"<>I\",N76:N85,\"<>W\"))/(L46+SUMIFS(L49:L51,N49:N51,\"<>\",N49:N51,\"<>I\",N49:N51,\"<>W\",N49:N51,\"<>P\",N49:N51,\"<>S\",N49:N51,\"<>R\")+SUMIFS(L59:L68,N59:N68,\"<>\",N59:N68,\"<>I\",N59:N68,\"<>W\",N59:N68,\"<>P\",N59:N68,\"<>S\",N59:N68,\"<>R\")+SUMIFS(L76:L85,N76:N85,\"<>\",N76:N85,\"<>I\",N76:N85,\"<>W\",N76:N85,\"<>P\",N76:N85,\"<>S\",N76:N85,\"<>R\")),\"\")","v":""}]
[]
[]
[null,"Term:",null,null,null,"Year:",null,null,null,null,null,{"$f":"(L46+SUMIFS(L49:L51,N49:N51,\"<>\",N49:N51,\"<>I\",N49:N51,\"<>W\",N49:N51,\"<>P\",N49:N51,\"<>R\")+SUMIFS(L59:L68,N59:N68,\"<>\",N59:N68,\"<>I\",N59:N68,\"<>W\",N59:N68,\"<>P\",N59:N68,\"<>R\")+SUMIFS(L76:L85,N76:N85,\"<>\",N76:N85,\"<>I\",N76:N85,\"<>W\",N76:N85,\"<>P\",N76:N85,\"<>R\"))","v":0},null,null,{"$f":"O46+SUMIFS(O49:O51,N49:N51,\"<>\",N49:N51,\"<>I\",N49:N51,\"<>W\",N49:N51,\"<>P\")+SUMIFS(O59:O68,N59:N68,\"<>\",N59:N68,\"<>I\",N59:N68,\"<>W\",N59:N68,\"<>P\")+SUMIFS(O76:O85,N76:N85,\"<>\",N76:N85,\"<>I\",N76:N85,\"<>W\",N76:N85,\"<>P\")","v":0}]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N94=\"I\",N94=\"W\",ISBLANK(N94)),\"\",IF(N94=\"A\",4*L94,IF(N94=\"B\",3*L94,IF(N94=\"C\",2*L94,IF(N94=\"D\",1*L94,IF(N94=\"A-\",3.75*L94,IF(N94=\"B+\",3.25*L94,IF(N94=\"B-\",2.75*L94,IF(N94=\"C+\",2.25*L94,IF(N94=\"C-\",1.75*L94,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N95=\"I\",N95=\"W\",ISBLANK(N95)),\"\",IF(N95=\"A\",4*L95,IF(N95=\"B\",3*L95,IF(N95=\"C\",2*L95,IF(N95=\"D\",1*L95,IF(N95=\"A-\",3.75*L95,IF(N95=\"B+\",3.25*L95,IF(N95=\"B-\",2.75*L95,IF(N95=\"C+\",2.25*L95,IF(N95=\"C-\",1.75*L95,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N96=\"I\",N96=\"W\",ISBLANK(N96)),\"\",IF(N96=\"A\",4*L96,IF(N96=\"B\",3*L96,IF(N96=\"C\",2*L96,IF(N96=\"D\",1*L96,IF(N96=\"A-\",3.75*L96,IF(N96=\"B+\",3.25*L96,IF(N96=\"B-\",2.75*L96,IF(N96=\"C+\",2.25*L96,IF(N96=\"C-\",1.75*L96,0))))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUMIFS(L94:L96,N94:N96,\"<>I\",N94:N96,\"<>W\")","v":0},{"$f":"SUMIFS(M94:M96,N94:N96,\"<>F\",N94:N96,\"<>W\",N94:N96,\"<>I\",N94:N96,\"<>U\",N94:N96,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L94:L96,N94:N96,\"<>\",N94:N96,\"<>I\",N94:N96,\"<>W\",N94:N96,\"<>P\",N94:N96,\"<>S\",N94:N96,\"<>R\")>0,SUMIFS(O94:O96,N94:N96,\"<>\",N94:N96,\"<>I\",N94:N96,\"<>W\",N94:N96,\"<>S\")/SUMIFS(L94:L96,N94:N96,\"<>\",N94:N96,\"<>I\",N94:N96,\"<>W\",N94:N96,\"<>P\",N94:N96,\"<>S\",N94:N96,\"<>R\"),\"\")","v":""}]
[]
[null,"AS 300 Year"]
[null,"Term:",null,null,null,"Year:",null,null,null,null,"Fall Certification:"]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N104=\"I\",N104=\"W\",ISBLANK(N104)),\"\",IF(N104=\"A\",4*L104,IF(N104=\"B\",3*L104,IF(N104=\"C\",2*L104,IF(N104=\"D\",1*L104,IF(N104=\"A-\",3.75*L104,IF(N104=\"B+\",3.25*L104,IF(N104=\"B-\",2.75*L104,IF(N104=\"C+\",2.25*L104,IF(N104=\"C-\",1.75*L104,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N105=\"I\",N105=\"W\",ISBLANK(N105)),\"\",IF(N105=\"A\",4*L105,IF(N105=\"B\",3*L105,IF(N105=\"C\",2*L105,IF(N105=\"D\",1*L105,IF(N105=\"A-\",3.75*L105,IF(N105=\"B+\",3.25*L105,IF(N105=\"B-\",2.75*L105,IF(N105=\"C+\",2.25*L105,IF(N105=\"C-\",1.75*L105,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N106=\"I\",N106=\"W\",ISBLANK(N106)),\"\",IF(N106=\"A\",4*L106,IF(N106=\"B\",3*L106,IF(N106=\"C\",2*L106,IF(N106=\"D\",1*L106,IF(N106=\"A-\",3.75*L106,IF(N106=\"B+\",3.25*L106,IF(N106=\"B-\",2.75*L106,IF(N106=\"C+\",2.25*L106,IF(N106=\"C-\",1.75*L106,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N113=\"I\",N113=\"W\",ISBLANK(N113)),\"\",IF(N113=\"A\",4*L113,IF(N113=\"B\",3*L113,IF(N113=\"C\",2*L113,IF(N113=\"D\",1*L113,IF(N113=\"A-\",3.75*L113,IF(N113=\"B+\",3.25*L113,IF(N113=\"B-\",2.75*L113,IF(N113=\"C+\",2.25*L113,IF(N113=\"C-\",1.75*L113,0))))))))))","v":""}]
[]
[null,"Academic Advisor Reviewed / Date",null,null,null,null,"Cadet Reviewed / Date",null,null,null,"AFROTC Cadre Reviewed / Date"]
[]
[]
[null,"Term:",null,null,null,"Year:",null,null,null,null,"Totals:",{"$f":"SUMIFS(L104:L113,N104:N113,\"<>W\",N104:N113,\"<>I\")","v":0},{"$f":"SUMIFS(M104:M113,N104:N113,\"<>F\",N104:N113,\"<>W\",N104:N113,\"<>I\",N104:N113,\"<>U\",N104:N113,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L104:L113,N104:N113,\"<>\",N104:N113,\"<>I\",N104:N113,\"<>W\",N104:N113,\"<>P\",N104:N113,\"<>S\",N104:N113,\"<>R\")>0,SUMIFS(O104:O113,N104:N113,\"<>\",N104:N113,\"<>I\",N104:N113,\"<>W\",N104:N113,\"<>S\")/SUMIFS(L104:L113,N104:N113,\"<>\",N104:N113,\"<>I\",N104:N113,\"<>W\",N104:N113,\"<>P\",N104:N113,\"<>S\",N104:N113,\"<>R\"),\"\")","v":""}]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N121=\"I\",N121=\"W\",ISBLANK(N121)),\"\",IF(N121=\"A\",4*L121,IF(N121=\"B\",3*L121,IF(N121=\"C\",2*L121,IF(N121=\"D\",1*L121,IF(N121=\"A-\",3.75*L121,IF(N121=\"B+\",3.25*L121,IF(N121=\"B-\",2.75*L121,IF(N121=\"C+\",2.25*L121,IF(N121=\"C-\",1.75*L121,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N122=\"I\",N122=\"W\",ISBLANK(N122)),\"\",IF(N122=\"A\",4*L122,IF(N122=\"B\",3*L122,IF(N122=\"C\",2*L122,IF(N122=\"D\",1*L122,IF(N122=\"A-\",3.75*L122,IF(N122=\"B+\",3.25*L122,IF(N122=\"B-\",2.75*L122,IF(N122=\"C+\",2.25*L122,IF(N122=\"C-\",1.75*L122,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N123=\"I\",N123=\"W\",ISBLANK(N123)),\"\",IF(N123=\"A\",4*L123,IF(N123=\"B\",3*L123,IF(N123=\"C\",2*L123,IF(N123=\"D\",1*L123,IF(N123=\"A-\",3.75*L123,IF(N123=\"B+\",3.25*L123,IF(N123=\"B-\",2.75*L123,IF(N123=\"C+\",2.25*L123,IF(N123=\"C-\",1.75*L123,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N130=\"I\",N130=\"W\",ISBLANK(N130)),\"\",IF(N130=\"A\",4*L130,IF(N130=\"B\",3*L130,IF(N130=\"C\",2*L130,IF(N130=\"D\",1*L130,IF(N130=\"A-\",3.75*L130,IF(N130=\"B+\",3.25*L130,IF(N130=\"B-\",2.75*L130,IF(N130=\"C+\",2.25*L130,IF(N130=\"C-\",1.75*L130,0))))))))))","v":""}]
[]
[null,"Cadet Reviewed / Date",null,null,null,"AFROTC Cadre Reviewed / Date",null,null,null,null,"Totals:",{"$f":"SUMIFS(L121:L130,N121:N130,\"<>W\",N121:N130,\"<>I\")","v":0},{"$f":"SUMIFS(M121:M130,N121:N130,\"<>F\",N121:N130,\"<>W\",N121:N130,\"<>I\",N121:N130,\"<>U\",N121:N130,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L121:L130,N121:N130,\"<>\",N121:N130,\"<>I\",N121:N130,\"<>W\",N121:N130,\"<>P\",N121:N130,\"<>S\",N121:N130,\"<>R\")>0,SUMIFS(O121:O130,N121:N130,\"<>\",N121:N130,\"<>I\",N121:N130,\"<>W\",N121:N130,\"<>S\")/SUMIFS(L121:L130,N121:N130,\"<>\",N121:N130,\"<>I\",N121:N130,\"<>W\",N121:N130,\"<>P\",N121:N130,\"<>S\",N121:N130,\"<>R\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Credits Remaining After Junior Year:",null,null,{"$f":"M88-M98-M118-M132","v":0},"CGPA:",{"$f":"IF((L91+SUMIFS(L94:L96,N94:N96,\"<>\",N94:N96,\"<>I\",N94:N96,\"<>W\",N94:N96,\"<>P\",N94:N96,\"<>S\",N94:N96,\"<>R\")+SUMIFS(L104:L113,N104:N113,\"<>\",N104:N113,\"<>I\",N104:N113,\"<>W\",N104:N113,\"<>P\",N104:N113,\"<>S\",N104:N113,\"<>R\")+SUMIFS(L121:L130,N121:N130,\"<>\",N121:N130,\"<>I\",N121:N130,\"<>W\",N121:N130,\"<>P\",N121:N130,\"<>S\",N121:N130,\"<>R\"))>0,(O91+SUMIFS(O94:O96,N94:N96,\"<>\",N94:N96,\"<>I\",N94:N96,\"<>W\")+SUMIFS(O104:O113,N104:N113,\"<>\",N104:N113,\"<>I\",N104:N113,\"<>W\")+SUMIFS(O121:O130,N121:N130,\"<>\",N121:N130,\"<>I\",N121:N130,\"<>W\"))/(L91+SUMIFS(L94:L96,N94:N96,\"<>\",N94:N96,\"<>I\",N94:N96,\"<>W\",N94:N96,\"<>P\",N94:N96,\"<>S\",N94:N96,\"<>R\")+SUMIFS(L104:L113,N104:N113,\"<>\",N104:N113,\"<>I\",N104:N113,\"<>W\",N104:N113,\"<>P\",N104:N113,\"<>S\",N104:N113,\"<>R\")+SUMIFS(L121:L130,N121:N130,\"<>\",N121:N130,\"<>I\",N121:N130,\"<>W\",N121:N130,\"<>P\",N121:N130,\"<>S\",N121:N130,\"<>R\")),\"\")","v":""}]
[]
[]
[null,"Term:",null,null,null,"Year:",null,null,null,null,null,{"$f":"(L91+SUMIFS(L94:L96,N94:N96,\"<>\",N94:N96,\"<>I\",N94:N96,\"<>W\",N94:N96,\"<>P\",N94:N96,\"<>R\")+SUMIFS(L104:L113,N104:N113,\"<>\",N104:N113,\"<>I\",N104:N113,\"<>W\",N104:N113,\"<>P\",N104:N113,\"<>R\")+SUMIFS(L121:L130,N121:N130,\"<>\",N121:N130,\"<>I\",N121:N130,\"<>W\",N121:N130,\"<>P\",N121:N130,\"<>R\"))","v":0},null,null,{"$f":"O91+SUMIFS(O94:O96,N94:N96,\"<>\",N94:N96,\"<>I\",N94:N96,\"<>W\",N94:N96,\"<>P\")+SUMIFS(O104:O113,N104:N113,\"<>\",N104:N113,\"<>I\",N104:N113,\"<>W\",N104:N113,\"<>P\")+SUMIFS(O121:O130,N121:N130,\"<>\",N121:N130,\"<>I\",N121:N130,\"<>W\",N121:N130,\"<>P\")","v":0}]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N139=\"I\",N139=\"W\",ISBLANK(N139)),\"\",IF(N139=\"A\",4*L139,IF(N139=\"B\",3*L139,IF(N139=\"C\",2*L139,IF(N139=\"D\",1*L139,IF(N139=\"A-\",3.75*L139,IF(N139=\"B+\",3.25*L139,IF(N139=\"B-\",2.75*L139,IF(N139=\"C+\",2.25*L139,IF(N139=\"C-\",1.75*L139,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N140=\"I\",N140=\"W\",ISBLANK(N140)),\"\",IF(N140=\"A\",4*L140,IF(N140=\"B\",3*L140,IF(N140=\"C\",2*L140,IF(N140=\"D\",1*L140,IF(N140=\"A-\",3.75*L140,IF(N140=\"B+\",3.25*L140,IF(N140=\"B-\",2.75*L140,IF(N140=\"C+\",2.25*L140,IF(N140=\"C-\",1.75*L140,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N141=\"I\",N141=\"W\",ISBLANK(N141)),\"\",IF(N141=\"A\",4*L141,IF(N141=\"B\",3*L141,IF(N141=\"C\",2*L141,IF(N141=\"D\",1*L141,IF(N141=\"A-\",3.75*L141,IF(N141=\"B+\",3.25*L141,IF(N141=\"B-\",2.75*L141,IF(N141=\"C+\",2.25*L141,IF(N141=\"C-\",1.75*L141,0))))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUMIFS(L139:L141,N139:N141,\"<>I\",N139:N141,\"<>W\")","v":0},{"$f":"SUMIFS(M139:M141,N139:N141,\"<>F\",N139:N141,\"<>W\",N139:N141,\"<>I\",N139:N141,\"<>U\",N139:N141,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L139:L141,N139:N141,\"<>\",N139:N141,\"<>I\",N139:N141,\"<>W\",N139:N141,\"<>P\",N139:N141,\"<>S\",N139:N141,\"<>R\")>0,SUMIFS(O139:O141,N139:N141,\"<>\",N139:N141,\"<>I\",N139:N141,\"<>W\",N139:N141,\"<>S\")/SUMIFS(L139:L141,N139:N141,\"<>\",N139:N141,\"<>I\",N139:N141,\"<>W\",N139:N141,\"<>P\",N139:N141,\"<>S\",N139:N141,\"<>R\"),\"\")","v":""}]
[]
[null,"AS 400 Year"]
[null,"Term:",null,null,null,"Year:",null,null,null,null,"Fall Certification:"]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N149=\"I\",N149=\"W\",ISBLANK(N149)),\"\",IF(N149=\"A\",4*L149,IF(N149=\"B\",3*L149,IF(N149=\"C\",2*L149,IF(N149=\"D\",1*L149,IF(N149=\"A-\",3.75*L149,IF(N149=\"B+\",3.25*L149,IF(N149=\"B-\",2.75*L149,IF(N149=\"C+\",2.25*L149,IF(N149=\"C-\",1.75*L149,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N150=\"I\",N150=\"W\",ISBLANK(N150)),\"\",IF(N150=\"A\",4*L150,IF(N150=\"B\",3*L150,IF(N150=\"C\",2*L150,IF(N150=\"D\",1*L150,IF(N150=\"A-\",3.75*L150,IF(N150=\"B+\",3.25*L150,IF(N150=\"B-\",2.75*L150,IF(N150=\"C+\",2.25*L150,IF(N150=\"C-\",1.75*L150,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N151=\"I\",N151=\"W\",ISBLANK(N151)),\"\",IF(N151=\"A\",4*L151,IF(N151=\"B\",3*L151,IF(N151=\"C\",2*L151,IF(N151=\"D\",1*L151,IF(N151=\"A-\",3.75*L151,IF(N151=\"B+\",3.25*L151,IF(N151=\"B-\",2.75*L151,IF(N151=\"C+\",2.25*L151,IF(N151=\"C-\",1.75*L151,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N158=\"I\",N158=\"W\",ISBLANK(N158)),\"\",IF(N158=\"A\",4*L158,IF(N158=\"B\",3*L158,IF(N158=\"C\",2*L158,IF(N158=\"D\",1*L158,IF(N158=\"A-\",3.75*L158,IF(N158=\"B+\",3.25*L158,IF(N158=\"B-\",2.75*L158,IF(N158=\"C+\",2.25*L158,IF(N158=\"C-\",1.75*L158,0))))))))))","v":""}]
[]
[null,"Academic Advisor Reviewed / Date",null,null,null,null,"Cadet Reviewed / Date",null,null,null,"AFROTC Cadre Reviewed / Date"]
[]
[]
[null,"Term:",null,null,null,"Year:",null,null,null,null,"Totals:",{"$f":"SUMIFS(L149:L158,N149:N158,\"<>W\",N149:N158,\"<>I\")","v":0},{"$f":"SUMIFS(M149:M158,N149:N158,\"<>F\",N149:N158,\"<>W\",N149:N158,\"<>I\",N149:N158,\"<>U\",N149:N158,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L149:L158,N149:N158,\"<>\",N149:N158,\"<>I\",N149:N158,\"<>W\",N149:N158,\"<>P\",N149:N158,\"<>S\",N149:N158,\"<>R\")>0,SUMIFS(O149:O158,N149:N158,\"<>\",N149:N158,\"<>I\",N149:N158,\"<>W\",N149:N158,\"<>S\")/SUMIFS(L149:L158,N149:N158,\"<>\",N149:N158,\"<>I\",N149:N158,\"<>W\",N149:N158,\"<>P\",N149:N158,\"<>S\",N149:N158,\"<>R\"),\"\")","v":""}]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N166=\"I\",N166=\"W\",ISBLANK(N166)),\"\",IF(N166=\"A\",4*L166,IF(N166=\"B\",3*L166,IF(N166=\"C\",2*L166,IF(N166=\"D\",1*L166,IF(N166=\"A-\",3.75*L166,IF(N166=\"B+\",3.25*L166,IF(N166=\"B-\",2.75*L166,IF(N166=\"C+\",2.25*L166,IF(N166=\"C-\",1.75*L166,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N167=\"I\",N167=\"W\",ISBLANK(N167)),\"\",IF(N167=\"A\",4*L167,IF(N167=\"B\",3*L167,IF(N167=\"C\",2*L167,IF(N167=\"D\",1*L167,IF(N167=\"A-\",3.75*L167,IF(N167=\"B+\",3.25*L167,IF(N167=\"B-\",2.75*L167,IF(N167=\"C+\",2.25*L167,IF(N167=\"C-\",1.75*L167,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N168=\"I\",N168=\"W\",ISBLANK(N168)),\"\",IF(N168=\"A\",4*L168,IF(N168=\"B\",3*L168,IF(N168=\"C\",2*L168,IF(N168=\"D\",1*L168,IF(N168=\"A-\",3.75*L168,IF(N168=\"B+\",3.25*L168,IF(N168=\"B-\",2.75*L168,IF(N168=\"C+\",2.25*L168,IF(N168=\"C-\",1.75*L168,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N175=\"I\",N175=\"W\",ISBLANK(N175)),\"\",IF(N175=\"A\",4*L175,IF(N175=\"B\",3*L175,IF(N175=\"C\",2*L175,IF(N175=\"D\",1*L175,IF(N175=\"A-\",3.75*L175,IF(N175=\"B+\",3.25*L175,IF(N175=\"B-\",2.75*L175,IF(N175=\"C+\",2.25*L175,IF(N175=\"C-\",1.75*L175,0))))))))))","v":""}]
[]
[null,"Cadet Reviewed / Date",null,null,null,"AFROTC Cadre Reviewed / Date",null,null,null,null,"Totals:",{"$f":"SUMIFS(L166:L175,N166:N175,\"<>W\",N166:N175,\"<>I\")","v":0},{"$f":"SUMIFS(M166:M175,N166:N175,\"<>F\",N166:N175,\"<>W\",N166:N175,\"<>I\",N166:N175,\"<>U\",N166:N175,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L166:L175,N166:N175,\"<>\",N166:N175,\"<>I\",N166:N175,\"<>W\",N166:N175,\"<>P\",N166:N175,\"<>S\",N166:N175,\"<>R\")>0,SUMIFS(O166:O175,N166:N175,\"<>\",N166:N175,\"<>I\",N166:N175,\"<>W\",N166:N175,\"<>S\")/SUMIFS(L166:L175,N166:N175,\"<>\",N166:N175,\"<>I\",N166:N175,\"<>W\",N166:N175,\"<>P\",N166:N175,\"<>S\",N166:N175,\"<>R\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Credits Remaining After Senior Year:",null,null,{"$f":"M133-M143-M163-M177","v":0},"CGPA:",{"$f":"IF((L136+SUMIFS(L139:L141,N139:N141,\"<>\",N139:N141,\"<>I\",N139:N141,\"<>W\",N139:N141,\"<>P\",N139:N141,\"<>S\",N139:N141,\"<>R\")+SUMIFS(L149:L158,N149:N158,\"<>\",N149:N158,\"<>I\",N149:N158,\"<>W\",N149:N158,\"<>P\",N149:N158,\"<>S\",N149:N158,\"<>R\")+SUMIFS(L166:L175,N166:N175,\"<>\",N166:N175,\"<>I\",N166:N175,\"<>W\",N166:N175,\"<>P\",N166:N175,\"<>S\",N166:N175,\"<>R\"))>0,(O136+SUMIFS(O139:O141,N139:N141,\"<>\",N139:N141,\"<>I\",N139:N141,\"<>W\")+SUMIFS(O149:O158,N149:N158,\"<>\",N149:N158,\"<>I\",N149:N158,\"<>W\")+SUMIFS(O166:O175,N166:N175,\"<>\",N166:N175,\"<>I\",N166:N175,\"<>W\"))/(L136+SUMIFS(L139:L141,N139:N141,\"<>\",N139:N141,\"<>I\",N139:N141,\"<>W\",N139:N141,\"<>P\",N139:N141,\"<>S\",N139:N141,\"<>R\")+SUMIFS(L149:L158,N149:N158,\"<>\",N149:N158,\"<>I\",N149:N158,\"<>W\",N149:N158,\"<>P\",N149:N158,\"<>S\",N149:N158,\"<>R\")+SUMIFS(L166:L175,N166:N175,\"<>\",N166:N175,\"<>I\",N166:N175,\"<>W\",N166:N175,\"<>P\",N166:N175,\"<>S\",N166:N175,\"<>R\")),\"\")","v":""}]
[]
[]
[null,"Term:",null,null,null,"Year:",null,null,null,null,null,{"$f":"(L136+SUMIFS(L139:L141,N139:N141,\"<>\",N139:N141,\"<>I\",N139:N141,\"<>W\",N139:N141,\"<>R\")+SUMIFS(L149:L158,N149:N158,\"<>\",N149:N158,\"<>I\",N149:N158,\"<>W\",N149:N158,\"<>R\")+SUMIFS(L166:L175,N166:N175,\"<>\",N166:N175,\"<>I\",N166:N175,\"<>W\",N166:N175,\"<>R\"))","v":0},null,null,{"$f":"O136+SUMIFS(O139:O141,N139:N141,\"<>\",N139:N141,\"<>I\",N139:N141,\"<>W\",N139:N141,\"<>P\")+SUMIFS(O149:O158,N149:N158,\"<>\",N149:N158,\"<>I\",N149:N158,\"<>W\",N149:N158,\"<>P\")+SUMIFS(O166:O175,N166:N175,\"<>\",N166:N175,\"<>I\",N166:N175,\"<>W\",N166:N175,\"<>P\")","v":0}]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N184=\"I\",N184=\"W\",ISBLANK(N184)),\"\",IF(N184=\"A\",4*L184,IF(N184=\"B\",3*L184,IF(N184=\"C\",2*L184,IF(N184=\"D\",1*L184,IF(N184=\"A-\",3.75*L184,IF(N184=\"B+\",3.25*L184,IF(N184=\"B-\",2.75*L184,IF(N184=\"C+\",2.25*L184,IF(N184=\"C-\",1.75*L184,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N185=\"I\",N185=\"W\",ISBLANK(N185)),\"\",IF(N185=\"A\",4*L185,IF(N185=\"B\",3*L185,IF(N185=\"C\",2*L185,IF(N185=\"D\",1*L185,IF(N185=\"A-\",3.75*L185,IF(N185=\"B+\",3.25*L185,IF(N185=\"B-\",2.75*L185,IF(N185=\"C+\",2.25*L185,IF(N185=\"C-\",1.75*L185,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N186=\"I\",N186=\"W\",ISBLANK(N186)),\"\",IF(N186=\"A\",4*L186,IF(N186=\"B\",3*L186,IF(N186=\"C\",2*L186,IF(N186=\"D\",1*L186,IF(N186=\"A-\",3.75*L186,IF(N186=\"B+\",3.25*L186,IF(N186=\"B-\",2.75*L186,IF(N186=\"C+\",2.25*L186,IF(N186=\"C-\",1.75*L186,0))))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUMIFS(L184:L186,N184:N186,\"<>I\",N184:N186,\"<>W\")","v":0},{"$f":"SUMIFS(M184:M186,N184:N186,\"<>F\",N184:N186,\"<>W\",N184:N186,\"<>I\",N184:N186,\"<>U\",N184:N186,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L184:L186,N184:N186,\"<>\",N184:N186,\"<>I\",N184:N186,\"<>W\",N184:N186,\"<>P\",N184:N186,\"<>S\",N184:N186,\"<>R\")>0,SUMIFS(O184:O186,N184:N186,\"<>\",N184:N186,\"<>I\",N184:N186,\"<>W\",N184:N186,\"<>S\")/SUMIFS(L184:L186,N184:N186,\"<>\",N184:N186,\"<>I\",N184:N186,\"<>W\",N184:N186,\"<>P\",N184:N186,\"<>S\",N184:N186,\"<>R\"),\"\")","v":""}]
[]
[null,"AS 700/800 Year"]
[null,"Term:",null,null,null,"Year:",null,null,null,null,"Fall Certification:"]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N194=\"I\",N194=\"W\",ISBLANK(N194)),\"\",IF(N194=\"A\",4*L194,IF(N194=\"B\",3*L194,IF(N194=\"C\",2*L194,IF(N194=\"D\",1*L194,IF(N194=\"A-\",3.75*L194,IF(N194=\"B+\",3.25*L194,IF(N194=\"B-\",2.75*L194,IF(N194=\"C+\",2.25*L194,IF(N194=\"C-\",1.75*L194,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N195=\"I\",N195=\"W\",ISBLANK(N195)),\"\",IF(N195=\"A\",4*L195,IF(N195=\"B\",3*L195,IF(N195=\"C\",2*L195,IF(N195=\"D\",1*L195,IF(N195=\"A-\",3.75*L195,IF(N195=\"B+\",3.25*L195,IF(N195=\"B-\",2.75*L195,IF(N195=\"C+\",2.25*L195,IF(N195=\"C-\",1.75*L195,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N196=\"I\",N196=\"W\",ISBLANK(N196)),\"\",IF(N196=\"A\",4*L196,IF(N196=\"B\",3*L196,IF(N196=\"C\",2*L196,IF(N196=\"D\",1*L196,IF(N196=\"A-\",3.75*L196,IF(N196=\"B+\",3.25*L196,IF(N196=\"B-\",2.75*L196,IF(N196=\"C+\",2.25*L196,IF(N196=\"C-\",1.75*L196,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N203=\"I\",N203=\"W\",ISBLANK(N203)),\"\",IF(N203=\"A\",4*L203,IF(N203=\"B\",3*L203,IF(N203=\"C\",2*L203,IF(N203=\"D\",1*L203,IF(N203=\"A-\",3.75*L203,IF(N203=\"B+\",3.25*L203,IF(N203=\"B-\",2.75*L203,IF(N203=\"C+\",2.25*L203,IF(N203=\"C-\",1.75*L203,0))))))))))","v":""}]
[]
[null,"Academic Advisor Reviewed / Date",null,null,null,null,"Cadet Reviewed / Date",null,null,null,"AFROTC Cadre Reviewed / Date"]
[]
[]
[null,"Term:",null,null,null,"Year:",null,null,null,null,"Totals:",{"$f":"SUMIFS(L194:L203,N194:N203,\"<>W\",N194:N203,\"<>I\")","v":0},{"$f":"SUMIFS(M194:M203,N194:N203,\"<>F\",N194:N203,\"<>W\",N194:N203,\"<>I\",N194:N203,\"<>U\",N194:N203,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L194:L203,N194:N203,\"<>\",N194:N203,\"<>I\",N194:N203,\"<>W\",N194:N203,\"<>P\",N194:N203,\"<>S\",N194:N203,\"<>R\")>0,SUMIFS(O194:O203,N194:N203,\"<>\",N194:N203,\"<>I\",N194:N203,\"<>W\",N194:N203,\"<>S\")/SUMIFS(L194:L203,N194:N203,\"<>\",N194:N203,\"<>I\",N194:N203,\"<>W\",N194:N203,\"<>P\",N194:N203,\"<>S\",N194:N203,\"<>R\"),\"\")","v":""}]
[]
[null,"Course Number:",null,null,"Course Title:",null,null,null,null,null,null,"Credit Hours","Hours Toward Degree","Grade","Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N211=\"I\",N211=\"W\",ISBLANK(N211)),\"\",IF(N211=\"A\",4*L211,IF(N211=\"B\",3*L211,IF(N211=\"C\",2*L211,IF(N211=\"D\",1*L211,IF(N211=\"A-\",3.75*L211,IF(N211=\"B+\",3.25*L211,IF(N211=\"B-\",2.75*L211,IF(N211=\"C+\",2.25*L211,IF(N211=\"C-\",1.75*L211,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N212=\"I\",N212=\"W\",ISBLANK(N212)),\"\",IF(N212=\"A\",4*L212,IF(N212=\"B\",3*L212,IF(N212=\"C\",2*L212,IF(N212=\"D\",1*L212,IF(N212=\"A-\",3.75*L212,IF(N212=\"B+\",3.25*L212,IF(N212=\"B-\",2.75*L212,IF(N212=\"C+\",2.25*L212,IF(N212=\"C-\",1.75*L212,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N213=\"I\",N213=\"W\",ISBLANK(N213)),\"\",IF(N213=\"A\",4*L213,IF(N213=\"B\",3*L213,IF(N213=\"C\",2*L213,IF(N213=\"D\",1*L213,IF(N213=\"A-\",3.75*L213,IF(N213=\"B+\",3.25*L213,IF(N213=\"B-\",2.75*L213,IF(N213=\"C+\",2.25*L213,IF(N213=\"C-\",1.75*L213,0))))))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(N220=\"I\",N220=\"W\",ISBLANK(N220)),\"\",IF(N220=\"A\",4*L220,IF(N220=\"B\",3*L220,IF(N220=\"C\",2*L220,IF(N220=\"D\",1*L220,IF(N220=\"A-\",3.75*L220,IF(N220=\"B+\",3.25*L220,IF(N220=\"B-\",2.75*L220,IF(N220=\"C+\",2.25*L220,IF(N220=\"C-\",1.75*L220,0))))))))))","v":""}]
[]
[null,"Cadet Reviewed / Date",null,null,null,"AFROTC Cadre Reviewed / Date",null,null,null,null,"Totals:",{"$f":"SUMIFS(L211:L220,N211:N220,\"<>W\",N211:N220,\"<>I\")","v":0},{"$f":"SUMIFS(M211:M220,N211:N220,\"<>F\",N211:N220,\"<>W\",N211:N220,\"<>I\",N211:N220,\"<>U\",N211:N220,\"<>R\")","v":0},"TGPA:",{"$f":"IF(SUMIFS(L211:L220,N211:N220,\"<>\",N211:N220,\"<>I\",N211:N220,\"<>W\",N211:N220,\"<>P\",N211:N220,\"<>S\",N211:N220,\"<>R\")>0,SUMIFS(O211:O220,N211:N220,\"<>\",N211:N220,\"<>I\",N211:N220,\"<>W\",N211:N220,\"<>S\")/SUMIFS(L211:L220,N211:N220,\"<>\",N211:N220,\"<>I\",N211:N220,\"<>W\",N211:N220,\"<>P\",N211:N220,\"<>S\",N211:N220,\"<>R\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Credits Remaining After Fifth Year:",null,null,{"$f":"M178-M188-M208-M222","v":0},"CGPA:",{"$f":"IF((L181+SUMIFS(L184:L186,N184:N186,\"<>\",N184:N186,\"<>I\",N184:N186,\"<>W\",N184:N186,\"<>P\",N184:N186,\"<>S\",N184:N186,\"<>R\")+SUMIFS(L194:L203,N194:N203,\"<>\",N194:N203,\"<>I\",N194:N203,\"<>W\",N194:N203,\"<>P\",N194:N203,\"<>S\",N194:N203,\"<>R\")+SUMIFS(L211:L220,N211:N220,\"<>\",N211:N220,\"<>I\",N211:N220,\"<>W\",N211:N220,\"<>P\",N211:N220,\"<>S\",N211:N220,\"<>R\"))>0,(O181+SUMIFS(O184:O186,N184:N186,\"<>\",N184:N186,\"<>I\",N184:N186,\"<>W\")+SUMIFS(O194:O203,N194:N203,\"<>\",N194:N203,\"<>I\",N194:N203,\"<>W\")+SUMIFS(O211:O220,N211:N220,\"<>\",N211:N220,\"<>I\",N211:N220,\"<>W\"))/(L181+SUMIFS(L184:L186,N184:N186,\"<>\",N184:N186,\"<>I\",N184:N186,\"<>W\",N184:N186,\"<>P\",N184:N186,\"<>S\",N184:N186,\"<>R\")+SUMIFS(L194:L203,N194:N203,\"<>\",N194:N203,\"<>I\",N194:N203,\"<>W\",N194:N203,\"<>P\",N194:N203,\"<>S\",N194:N203,\"<>R\")+SUMIFS(L211:L220,N211:N220,\"<>\",N211:N220,\"<>I\",N211:N220,\"<>W\",N211:N220,\"<>P\",N211:N220,\"<>S\",N211:N220,\"<>R\")),\"\")","v":""}]

{"sheet":"Background Lists","index":1,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"To modify any of the lists below do the following: \n\nHighlight a row within the current list. For example if adding the grade of E, highlight the row containing F so you can add E above F.\n\nRight-Click on the row number.\n\nClick on Insert. \n\nAdd the option you want to include in the list. For example: E. \n\nCheck that the option you added is now included in the dropdown menus on the Form 48. All of the cells using this list should be updated with the change."]
[null,"Degree Types"]
[null,"BA"]
[null,"BM"]
[null,"BS"]
[null,"MA"]
[null,"MS"]
[null,"PhD"]
[]
[null,"School Options"]
[null,"The University of Oklahoma"]
[null,"Oklahoma City Community College"]
[null,"Oklahoma Baptist University"]
[null,"Oklahoma Christian University"]
[null,"Oklahoma City University"]
[null,"Rose State College"]
[null,"University of Central Oklahoma"]
[]
[null,"Term Completed"]
[null,"Spring"]
[null,"Fall"]
[null,"Summer"]
[]
[null,"Grades"]
[null,"A"]
[null,"A-"]
[null,"B+"]
[null,"B"]
[null,"B-"]
[null,"C+"]
[null,"C"]
[null,"C-"]
[null,"D"]
[null,"F"]
[null,"S"]
[null,"U"]
[null,"P"]
[null,"I"]
[null,"W"]
[null,"R"]