{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["GPACalc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"GPACalc","index":0,"n_rows":58,"n_cols":19,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,18,2,18],[8,18,11,18],[3,18,5,18],[1,6,1,7],[1,9,1,10],[1,2,1,4],[36,1,38,4],[33,1,33,2],[18,6,18,10],[23,6,23,10],[57,1,57,2],[23,1,26,4],[44,13,44,14],[2,1,2,10],[25,6,25,9],[4,5,4,10],[4,1,4,3],[13,2,14,4],[18,1,21,4],[57,6,57,9],[13,6,13,9],[14,6,14,9],[15,6,15,9],[12,6,12,10],[33,6,33,10],[53,3,53,4],[54,3,54,4],[44,3,44,4],[43,5,43,10],[28,6,28,10],[38,6,38,10],[28,1,31,4],[32,1,32,2],[43,1,43,2]]}
[]
[null,"Name:",null,null,null,"G#:",null,null,"Date: ",null,null,null,null,null,null,null,null,"←                   ","If you get an error message after clicking the CLEAR button:  "]
[null,"INSTRUCTIONS:   Fill in highlighted fields with information from the student transcript or from what the student plans to take in the future semester.  Non-highlighted fields should populate automatically."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Look for a SECURITY WARNING at top of your screen beneath the toolbar."]
[null,"1. List New Courses",null,null,null,"2.  List Courses to be Repeated"]
[null,null,"Course","Credits",null,null,"Course","Credits","Grade","Grade Value","Quality Points",null,null,1]
[null,"1st new course",null,null,"A","1st repeat course",null,null,null,{"$f":"IF(ISNA(VLOOKUP(I7,Grades,2,FALSE)),\"\",IF(VLOOKUP(I7,Grades,2,FALSE)=\"\",\"\",VLOOKUP(I7,Grades,2,FALSE)))","v":""},{"$f":"IF(AND(H7>0,I7<>\"\"),H7*J7,P48)","v":0},"A",null,2,null,null,null,null,"2. Select \"Options\" button"]
[null,"2nd new course",null,null,"B","2nd repeat course",null,null,null,{"$f":"IF(ISNA(VLOOKUP(I8,Grades,2,FALSE)),\"\",IF(VLOOKUP(I8,Grades,2,FALSE)=\"\",\"\",VLOOKUP(I8,Grades,2,FALSE)))","v":""},{"$f":"IF(AND(H8>0,I8<>\"\"),H8*J8,P49)","v":0},"B",null,3,null,null,null,null,"3. Select \"Enable this content\"."]
[null,"3rd new course",null,null,"C","3rd repeat course",null,null,null,{"$f":"IF(ISNA(VLOOKUP(I9,Grades,2,FALSE)),\"\",IF(VLOOKUP(I9,Grades,2,FALSE)=\"\",\"\",VLOOKUP(I9,Grades,2,FALSE)))","v":""},{"$f":"IF(AND(H9>0,I9<>\"\"),H9*J9,P50)","v":0},"C",null,4,null,null,null,null,"3. After you click \"OK\" and the window closes, the macro should work with the default security setting for Excel."]
[null,"4th new course",null,null,"D","4th repeat course",null,null,null,{"$f":"IF(ISNA(VLOOKUP(I10,Grades,2,FALSE)),\"\",IF(VLOOKUP(I10,Grades,2,FALSE)=\"\",\"\",VLOOKUP(I10,Grades,2,FALSE)))","v":""},{"$f":"IF(AND(H10>0,I10<>\"\"),H10*J10,P51)","v":0},"D",null,6]
[null,null,null,{"$f":"D7+D8+D9+D10","v":0},"E",null,null,{"$f":"H7+H8+H9+H10","v":0},null,null,{"$f":"SUM(K7:K10)","v":0},"E"]
[]
[null,null,null,null,null,null,"3. New Attempted Hours Total"]
[null,null,null,null,null,null,"Attempted Credit Hours (from transcript)",null,null,null,null,"F"]
[null,null,null,null,null,null,"+ Credit Hours to be repeated (line E, #1)",null,null,null,{"$f":"H11","v":0},"G"]
[null,null,null,null,null,null,"+ Credit Hours of new courses (line E, #2)",null,null,null,{"$f":"D11","v":0},"H"]
[null,null,null,null,null,null,"New Attempted Hours Total",null,null,null,{"$f":"SUM(K14:K16)","v":0},"I"]
[]
[null,"Deduct any quality points the student earned from courses being repeated.  Grades of F have no quality points, but grades of D and higher do. (see table)",null,null,null,null,"4. New Quality Points Total"]
[null,null,null,null,null,null,"Current Quality Points Total (from transcript)",null,null,null,null,"J"]
[null,null,null,null,null,null,"- Quality Points from Repeated Courses (line E)",null,null,null,{"$f":"K11","v":0},"K"]
[null,null,null,null,null,null,"New Quality Points Total",null,null,null,{"$f":"K20-K21","v":0},"L"]
[]
[null,"The GPA hours do not change when the student repeats a course.  Credit hours should only include new, non-repeated course credits.  ",null,null,null,null,"5. New GPA Hours Total"]
[null,null,null,null,null,null,"Current GPA Hours (from transcript)",null,null,null,null,"M"]
[null,null,null,null,null,null,"+ Credit Hours of new courses (line E, #2)",null,null,null,{"$f":"D11","v":0},"N"]
[null,null,null,null,null,null,"New GPA Hours Total",null,null,null,{"$f":"K25+K26","v":0},"O"]
[]
[null,"The minimum GPA required to avoid suspension depends on the total completed hours.  Please see the Retention Table if the Minimum GPA Required does not populate below. Enter desired GPA number equal or higher than the minimum in line Q at right.",null,null,null,null,"6. Quality Points Needed"]
[null,null,null,null,null,null,"New GPA Hours Total",null,null,null,{"$f":"K27","v":0},"P"]
[null,null,null,null,null,null,"x   Desired GPA",null,null,null,null,"Q"]
[null,null,null,null,null,null,"Quality Points Needed",null,null,null,{"$f":"K30*K31","v":0},"R"]
[null,"Minimum GPA Required = ",null,{"$f":"IF(K17>89,\"1.85\",IF(K17>59,\"1.55\",IF(K17>29,\"1.25\",IF(K17>16,\"1.00\",IF(K17>6,\"--*\",IF(K17=0,,))))))","v":0}]
[null,null,null,null,null,null,"7. Quality Point Difference"]
[null,null,null,null,null,null,"Quality Points Needed (line R)",null,null,null,{"$f":"K32","v":0},"S"]
[null,null,null,null,null,null,"-   New Quality Points Total (line L)",null,null,null,{"$f":"K22","v":0},"T"]
[null,"*NOTE:  Students with less than 17 attempted hours will receive an academic warning (not suspension) if GPA falls below 1.99",null,null,null,null,"Quality Point Difference",null,null,null,{"$f":"K35-K36","v":0},"U"]
[]
[null,null,null,null,null,null,"8. Average Quality Point needed per Credit"]
[null,null,null,null,null,null,"Quality Point Difference (Line U)",null,null,null,{"$f":"K37","v":0},"V"]
[null,null,null,null,null,null,"÷  Next Semester Credits (line E, #1 + #2)",null,null,null,{"$f":"D11+H11","v":0},"W"]
[null,null,null,null,null,null,"Average Quality Point Needed Per Credit",null,null,null,{"$f":"IF(K41>0.001,K40/K41,\"\")","v":""},"X"]
[]
[null,"Quality Points per Credit",null,null,null,"9. Estimated Future GPA"]
[null,"Grade Received","1 Credit",null,null,"New Courses","Repeated Courses","Credits","Potential Grade","Grade Value","Potential Quality Points",null,null,"Grades"]
[null,"A",4,null,null,{"$f":"IF(C7>0,C7,\"    \")","v":"    "},null,{"$f":"IF((D7>0),D7,\"\")","v":""},null,{"$f":"IF(ISNA(VLOOKUP(I46,Grades,2,FALSE)),\"\",IF(VLOOKUP(I46,Grades,2,FALSE)=\"\",\"\",VLOOKUP(I46,Grades,2,FALSE)))","v":""},{"$f":"IF(AND(H46>0,I46<>\"\"),H46*J46,P87)","v":0},null,null,"A",4]
[null,"A-",3.67,null,null,{"$f":"IF(C8>0,C8,\"    \")","v":"    "},null,"",null,"",{"$f":"IF(AND(H47>0,I47<>\"\"),H47*J47,P87)","v":0},null,null,"A-",3.67]
[null,"B+",3.33,null,null,{"$f":"IF(C9>0,C9,\"    \")","v":"    "},null,"",null,"",{"$f":"IF(AND(H48>0,I48<>\"\"),H48*J48,P87)","v":0},null,null,"B+",3.33,0]
[null,"B",3,null,null,{"$f":"IF(C10>0,C10,\"    \")","v":"    "},null,"",null,"",{"$f":"IF(AND(H49>0,I49<>\"\"),H49*J49,P87)","v":0},null,null,"B",3]
[null,"B-",2.67,null,null,null,{"$f":"IF(G7>0,G7,\"    \")","v":"    "},{"$f":"IF((H7>0),H7,\"\")","v":""},null,"",{"$f":"IF(AND(H50>0,I50<>\"\"),H50*J50,P88)","v":0},null,null,"B-",2.67]
[null,"C+",2.33,null,null,null,{"$f":"IF(G8>0,G8,\"    \")","v":"    "},{"$f":"IF((H8>0),H8,\"\")","v":""},null,"",{"$f":"IF(AND(H51>0,I51<>\"\"),H51*J51,P89)","v":0},null,null,"C+",2.33]
[null,"C+",2,null,null,null,{"$f":"IF(G9>0,G9,\"    \")","v":"    "},"",null,"",{"$f":"IF(AND(H52>0,I52<>\"\"),H52*J52,P90)","v":0},null,null,"C",2]
[null,"C-",1.67,null,null,null,{"$f":"IF(G10>0,G10,\"    \")","v":"    "},"",null,"",{"$f":"IF(AND(H53>0,I53<>\"\"),H53*J53,P91)","v":0},null,null,"C-",1.67]
[null,"D",1,null,null,null,null,null,null,"Potential Semester Quality Points  ",{"$f":"SUM(K46:K53)","v":0},null,null,"D",1]
[null,null,null,null,null,null,null,null,null,"+ New Quality Points Total   (line L)     ",{"$f":"K22","v":0},null,null,"F",0]
[null,null,null,null,null,null,null,null,null,"Quality Point Total    ",{"$f":"SUM(K54:K55)","v":0}]
[null,null,null,null,null,null,null,null,null," ÷ New GPA Hours Total    (line O)",{"$f":"K27","v":0}]
[null,"ESTIMATED FUTURE GPA",null,null,null,null,"Estimated Future GPA  ",null,null,null,{"$f":"IF(K57>0,K56/K57,\"\")","v":""}]