{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["GPA Calculator","RSCOB and CONH Admission GPA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"GPA Calculator","index":0,"n_rows":26,"n_cols":34,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,23,7,24],[18,25,18,26],[2,7,3,7],[3,23,3,24],[1,1,1,7],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[9,9,9,11],[17,9,17,11],[11,9,11,11],[15,5,18,7],[15,4,20,4],[20,5,20,7],[8,9,8,11],[1,9,1,12],[2,9,6,9],[2,10,6,10],[19,9,19,11],[20,9,20,11],[14,9,14,11],[14,1,14,7],[12,9,12,11],[15,9,15,11]]}
[]
[null,"Current Semester",null,null,null,null,null,null,null,"Transcript Totals"]
[null,"Course","Hours","Grade","Repeat & Replace?","Old Hours","Old Grade","Quarter or Semester?",null,"Enter values into these boxes",null,"GPA Hours "]
[null,null,null,null,null,null,null,null,null,null,null,"Quality Points ",null,null,null,null,"Key",null,null,null,null,null,null,"Transcript Totals",null,"Current Term"]
[null,null,null,null,null,null,null,null,null,null,null,"Earned Hours ",null,null,null,null,"Hours","Grade Options","Grade Value","Repeat & Replace","Course Type",null,null,"Hours","Points","Course Hours","Course Points","Repeat & Replace","Repeat Hours","Repeat Points","Earned","Attempted","Subtract"]
[null,null,null,null,null,null,null,null,null,null,null,"Attempted Hours ",null,null,null,null,1,"A",4,"Yes","Quarter",null,null,{"$f":"IF($M$7= \"Quarter\", M3/1.5, M3)","v":0},{"$f":"IF($M$7= \"Quarter\", M4/1.5, M4)","v":0},{"$f":"IF(OR(D5=\"W\",D5=\"K\",D5=\"I\",D5=\"M\",D5=\"N\"), 0, C5)","v":0},{"$f":"Z6*(IF(D5=\"A\",4,(IF(D5=\"B\",3,(IF(D5=\"C\",2,(IF(D5=\"D\",1,(IF(D5=\"F\",0,(IF(D5=\"X\",0,0))))))))))))","v":0},{"$f":"E5","v":0},{"$f":"IF(AB6=\"Yes\", F5,0)","v":0},{"$f":"AC6*(IF(G5=\"A\",4,(IF(G5=\"B\",3,(IF(G5=\"C\",2,(IF(G5=\"D\",1,(IF(G5=\"F\",0,(IF(G5=\"X\",0,0))))))))))))","v":0},{"$f":"IF(OR(D5=\"A\", D5=\"B\", D5=\"C\", D5=\"D\", D5=\"M\"),C5, 0)","v":0},{"$f":"C5","v":0},{"$f":"IF(NOT(AD6=0),F5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Quarter or Semester? ",null,null,null,null,2,"B",3,"No","Semester",null,null,null,null,{"$f":"IF(OR(D6=\"W\",D6=\"K\",D6=\"I\",D6=\"M\",D6=\"N\"), 0, C6)","v":0},{"$f":"Z7*(IF(D6=\"A\",4,(IF(D6=\"B\",3,(IF(D6=\"C\",2,(IF(D6=\"D\",1,(IF(D6=\"F\",0,(IF(D6=\"X\",0,0))))))))))))","v":0},{"$f":"E6","v":0},{"$f":"IF(AB7=\"Yes\", F6,0)","v":0},{"$f":"AC7*(IF(G6=\"A\",4,(IF(G6=\"B\",3,(IF(G6=\"C\",2,(IF(G6=\"D\",1,(IF(G6=\"F\",0,(IF(G6=\"X\",0,0))))))))))))","v":0},{"$f":"IF(OR(D6=\"A\", D6=\"B\", D6=\"C\", D6=\"D\", D6=\"M\"),C6, 0)","v":0},{"$f":"C6","v":0},{"$f":"IF(NOT(AD7=0),F6,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"C",2,null,null,null,null,"Cumulative Totals",null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Past Cumulative GPA ",null,null,{"$f":"TRUNC(IF(M3= 0, 0, M4/M3),3)","v":0},null,null,null,4,"D",1,null,null,null,null,"Before Hours","Before Points",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Past Completion Percentage ",null,null,{"$f":"TRUNC(IF(OR(M6<=0,M5<0, M6<M5),0,M5/M6),2)","v":0},null,null,null,5,"F",0,null,null,null,null,{"$f":"SUM(X6,Z16)","v":0},{"$f":"SUM(Y6,AA16)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"X",0,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Current Semester GPA ",null,null,{"$f":"TRUNC(IF(Z16=0, 0, AA16/Z16),3)","v":0},null,null,null,7,"W",null,null,null,null,null,"After Hours","After Points",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Current Semester Completion Percentage ",null,null,{"$f":"TRUNC(IF(AF22=0, 0, AE22/AF22),2)","v":0},null,null,null,8,"K",null,null,null,null,"Minus Qtr",{"$f":"IF(NOT($M$7=\"Quarter\"), M3*1.5, M3) - AC16","v":0},{"$f":"IF(NOT($M$7=\"Quarter\"), M4*1.5, M4) - AD16","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I",null,null,null,null,"Minus Sem",{"$f":"TRUNC(X13/1.5-AC17+Z16, 3)","v":0},{"$f":"TRUNC(Y13/1.5-AD17+AA16, 3)","v":0},0,0,0,0,0,0,0,0]
[null,"Pass/Fail Courses (for SAP/Probation Calculation)",null,null,null,null,null,null,null,"Cumulative GPA before Repeat & Replace ",null,null,{"$f":"TRUNC(IF(X10=0, 0, Y10/X10),3)","v":0},null,null,null,null,"N",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Enter current semester course information here",null,null,null,"Cumulative GPA after Repeat & Replace ",null,null,{"$f":"TRUNC(IF(X14=0, 0, Y14/X14),3)","v":0},null,null,null,null,"P",null,null,null,null,null,null,"Totals =====>",{"$f":"SUM(Z6:Z15)","v":0},{"$f":"SUM(AA6:AA15)","v":0},"Quarter Total ==>",{"$f":"SUM(IF($H$5=\"Quarter\",AC$6,0),IF($H$6=\"Quarter\", AC$7,0),IF($H$7=\"Quarter\", AC$8,0),IF($H$8=\"Quarter\", AC$9,0),IF($H$9=\"Quarter\", AC$10,0),IF($H$10=\"Quarter\", AC$11,0),IF($H$11=\"Quarter\", AC$12,0),IF($H$12=\"Quarter\", AC$13,0),IF($H$13=\"Quarter\", AC$14,0),IF($H$14=\"Quarter\", AC$15,0))","v":0},{"$f":"SUM(IF($H$5=\"Quarter\",AD$6,0),IF($H$6=\"Quarter\", AD$7,0),IF($H$7=\"Quarter\", AD$8,0),IF($H$8=\"Quarter\", AD$9,0),IF($H$9=\"Quarter\", AD$10,0),IF($H$10=\"Quarter\", AD$11,0),IF($H$11=\"Quarter\", AD$12,0),IF($H$12=\"Quarter\", AD$13,0),IF($H$13=\"Quarter\", AD$14,0),IF($H$14=\"Quarter\", AD$15,0))","v":0},{"$f":"IF(OR(D16=\"P\", D16=\"M\"),C16, 0)","v":0},{"$f":"C16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U",null,null,null,null,null,null,null,null,null,"Semester Total =>",{"$f":"SUM(IF($H$5=\"Semester\",AC$6,0),IF($H$6=\"Semester\", AC$7,0),IF($H$7=\"Semester\", AC$8,0),IF($H$8=\"Semester\", AC$9,0),IF($H$9=\"Semester\", AC$10,0),IF($H$10=\"Semester\", AC$11,0),IF($H$11=\"Semester\", AC$12,0),IF($H$12=\"Semester\", AC$13,0),IF($H$13=\"Semester\", AC$14,0),IF($H$14=\"Semester\", AC$15,0))","v":0},{"$f":"SUM(IF($H$5=\"Semester\",AD$6,0),IF($H$6=\"Semester\", AD$7,0),IF($H$7=\"Semester\", AD$8,0),IF($H$8=\"Semester\", AD$9,0),IF($H$9=\"Semester\", AD$10,0),IF($H$10=\"Semester\", AD$11,0),IF($H$11=\"Semester\", AD$12,0),IF($H$12=\"Semester\", AD$13,0),IF($H$13=\"Semester\", AD$14,0),IF($H$14=\"Semester\", AD$15,0))","v":0},{"$f":"IF(OR(D17=\"P\", D17=\"M\"),C17, 0)","v":0},0]
[null,null,null,null,null,null,null,null,null,"Completion Percentage at End of Semester ",null,null,{"$f":"TRUNC(IF(OR(AA26<=0, Z26<0, AA26<Z26), 0, Z26/AA26),2)","v":0},null,null,null,null,"W",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K",null,null,null,null,null,null,null,"SAP Totals",null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,"SAP Met? ",null,null,{"$f":"IF(OR(M16=0,M18=0), \"N/A\", IF(M16>=2, IF(M18>=0.67, \"YES\", \"NO\"),\"NO\"))","v":"N/A"},null,null,null,null,"I",null,null,null,null,null,null,null,"Earned","Attempted",null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,"Academic Probation? ",null,null,{"$f":"IF(M16=0, \"N/A\", IF(M16>=2, \"GOOD\", IF(M12>=2.25, IF(M13>=0.67, \"CONTINUE\", \"DISMISS\"),\"DISMISS\")))","v":"N/A"},null,null,null,null,"M",null,null,null,null,null,null,"Semester",{"$f":"IF($M$7= \"Quarter\", M5/1.5, M5)","v":0},{"$f":"IF($M$7= \"Quarter\", M6/1.5, M6)","v":0},null,null,null,0,0,{"$f":"SUM(IF($H$5=\"Quarter\", $AG$6,0), IF($H$6=\"Quarter\", $AG$7,0), IF($H$7=\"Quarter\", $AG$8,0), IF($H$8=\"Quarter\", $AG$9,0), IF($H$9=\"Quarter\", $AG$10,0), IF($H$10=\"Quarter\", $AG$11,0), IF($H$11=\"Quarter\", $AG$12,0), IF($H$12=\"Quarter\", $AG$13,0), IF($H$13=\"Quarter\", $AG$14,0), IF($H$14=\"Quarter\", $AG$15,0))","v":0},"<== Quarter Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N",null,null,null,null,null,null,"Quarter",{"$f":"Z21*1.5","v":0},{"$f":"AA21*1.5","v":0},null,null,"SAP Totals",{"$f":"SUM(AE6:AE20)","v":0},{"$f":"SUM(AF6:AF21)","v":0},{"$f":"SUM(IF($H$5=\"Semester\", $AG$6,0), IF($H$6=\"Semester\", $AG$7,0), IF($H$7=\"Semester\", $AG$8,0), IF($H$8=\"Semester\", $AG$9,0), IF($H$9=\"Semester\", $AG$10,0), IF($H$10=\"Semester\", $AG$11,0), IF($H$11=\"Semester\", $AG$12,0), IF($H$12=\"Semester\", $AG$13,0), IF($H$13=\"Semester\", $AG$14,0), IF($H$14=\"Semester\", $AG$15,0))","v":0},"<== Semester Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minus Quarter",{"$f":"Z22-AG21","v":0},{"$f":"AA22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sem Conversion",{"$f":"Z23/1.5","v":0},{"$f":"AA23/1.5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minus Semester",{"$f":"Z24-AG22","v":0},{"$f":"AA24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Semester",{"$f":"SUM(Z25,AE22)","v":0},{"$f":"SUM(AA25,AF22)","v":0}]

{"sheet":"RSCOB and CONH Admission GPA","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,5,1,6],[10,1,10,4],[1,2,1,4],[1,7,2,7],[1,1,2,1]]}
[]
[null,"Institution","Transcript",null,null,"Converted",null,"GPA",null,null,null,null,null,null,"Key"]
[null,null,"Hours","Quality Points","Quarter or Semester?","Hours","Quality Points",null,null,null,null,null,null,null,"Quarter or Semester"]
[null,"Wright State University",null,null,"Semester",{"$f":"IF(E4=\"Quarter\",C4*2/3,C4)","v":0},{"$f":"IF(E4=\"Quarter\",D4*2/3,D4)","v":0},{"$f":"IF(F4=0,0,TRUNC(G4/F4,3))","v":0},null,null,null,null,null,null,"Quarter"]
[null,null,null,null,null,{"$f":"IF(E5=\"Quarter\",C5*2/3,C5)","v":0},{"$f":"IF(E5=\"Quarter\",D5*2/3,D5)","v":0},0,null,null,null,null,null,null,"Semester"]
[null,null,null,null,null,{"$f":"IF(E6=\"Quarter\",C6*2/3,C6)","v":0},{"$f":"IF(E6=\"Quarter\",D6*2/3,D6)","v":0},0]
[null,null,null,null,null,{"$f":"IF(E7=\"Quarter\",C7*2/3,C7)","v":0},0,0]
[null,null,null,null,null,{"$f":"IF(E8=\"Quarter\",C8*2/3,C8)","v":0},0,0]
[null,null,null,null,null,{"$f":"IF(E9=\"Quarter\",C9*2/3,C9)","v":0},0,0]
[null,null,null,null,null,{"$f":"IF(E10=\"Quarter\",C10*2/3,C10)","v":0},0,0]
[null,"Totals:",null,null,null,{"$f":"SUM(F4:F10)","v":0},{"$f":"SUM(G4:G10)","v":0},{"$f":"IF(F11=0,0,TRUNC(G11/F11,3))","v":0}]