{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Policy","AP Status","Advising Projection Form","SAPRA","Quality Points Calculator","Sheet1","Grade Points","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Policy","index":0,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":true,"merged":[[0,1,0,10],[1,1,1,10],[13,1,13,3],[12,8,12,10],[13,8,13,10],[18,1,19,10],[21,1,21,10],[3,1,3,10],[8,8,8,10],[9,8,9,10],[9,1,9,3],[14,1,14,3],[14,8,14,10]]}
[null,"SATISFACTORY ACADEMIC PROGRESS POLICY"]
[null,"Effective January, 2012"]
[null,"POLICY"]
[null,"The Satisfactory Academic Progress Policy ensures that all students are maintaining satisfactory academic progress towards successful completion of their academic programs. The evaluation points and milestones contained in the policy are meant to identify problems for which actions of early intervention and/or remediation can be taken. Most critical to this policy is a student's ability to enroll in and complete courses in a consistent and successful manner. This ability is measured in three ways: cumulative grade point average (CGPA) and incremental completion rate (ICR) within a maximum timeframe (MTF). Failure to complete courses successfully for any reason may negatively affect satisfactory academic progress. Failing courses or withdrawing from courses could result in the loss of financial aid and academic termination. In order for a student to graduate, the minimum requirements are a CGPA of 2.0, an ICR of 66.67%, and completion of the program in no more than 150% of total program credits."]
[null,"MILESTONES AND EVALUATION POINTS"]
[null,"Evaluation Point",null,null,"Milestone (CGPA and ICR)",null,null,null,"Required Action"]
[null,"Certificate/Diploma"]
[null,"End of First Quarter",null,null,"< 1.0 CGPA and/or 33.33% ICR",null,null,null,"Academic/Financial Aid Warning"]
[null,"End of Second Quarter",null,null,"< 1.5 CGPA and/or 50.00% ICR",null,null,null,"Academic/Financial Aid Warning (if first time)\nAcademic/Financial Aid Dismissal (if on Warning)"]
[null,"End of Third Quarter and every quarter thereafter",null,null,"< 2.0 CGPA and/or 66.67% ICR",null,null,null,"Academic/Financial Aid Warning (if first time)\nAcademic/Financial Aid Dismissal (if on Warning)"]
[null,"Anything in excess of 150% MTF",null,null,null,null,null,null,"Dismissal"]
[null,"Degree"]
[null,"End of First Academic Year",null,null,"< 1.0 CGPA and/or 33.33% ICR",null,null,null,"Academic/Financial Aid Dismissal"]
[null,"End of Second Academic Year",null,null,"< 2.0 CGPA and/or 66.67% ICR",null,null,null,"Academic/Financial Aid Dismissal"]
[null,"End of Seventh Quarter and every Quarter thereafter",null,null,"< 2.0 CGPA and/or 66.67% ICR",null,null,null,"Academic/Financial Aid Warning (if first time)\nAcademic/Financial Aid Dismissal (if on Warning)"]
[null,"Anything in excess of 150% MTF",null,null,null,null,null,null,"Academic/Financial Aid Dismissal"]
[null,"Transitional Studies"]
[null,"At Any Time",null,null,"Three unsuccessful attempts",null,null,null,"Academic/Financial Aid Dismissal"]
[null,"Note: Students receiving VA benefits in California may have additional evaluation points. These are not for purposes of determining academic standing, but rather, are for purposes of determining continued eligibility to receive VA benefits."]
[]
[null,"TRANSITIONAL STUDIES"]
[null,"Transitional Studies Courses are based on the results of an academic placement test which is administered before new students start school. If students do not test out of these classes and do not have prior college credits that waive the requirement(s), students must successfully complete transitional classes in order to progress in their respective programs. Transitional studies course credits do not count towards total number of credits for graduation, CGPA, ICR, nor maximum timeframe (MTF). Failing or withdrawing from a transitional studies course three times will result in Academic/Financial Aid Dismissal. It is highly recommended that students do not take a break between failures of a transitional course."]

{"sheet":"AP Status","index":1,"n_rows":27,"n_cols":33,"rows_kept":27,"cut":false,"hidden":true,"merged":[[0,1,0,5],[13,1,13,2],[13,4,13,5],[1,1,1,5],[7,4,7,5]]}
[null,"SAP CALCULATOR AND CURRENT AP STATUS"]
[null,"Enter student information into the white boxes below using transcript."]
[null,"Name",null,"Major"]
[null,null,null,null,"ID#"]
[null,"CURRENT SAP RESULTS",null,null,"Quarters Completed"]
[null,"ICR",{"$f":"IF(F5=0,\" \",IF(F16+C16-F17-F27=0,0,(C15-C17-C27)/(F16-F17-F27)))","v":" "},null,"Credits Left to Graduate",{"$f":"IF(F5=0,\" \",C12-(C15-C17-C27))","v":" "}]
[null,"CGPA",{"$f":"IF(F5=0,\" \",IF(C20=0,0,(F20-F26)/(C20)))","v":" "},null,"150% Creds Remaining",{"$f":"IF(F5=0,\" \",F15-(F16-F17-F27))","v":" "}]
[null,"SAP CGPA",{"$f":"IF(F5=0,\" \",IF(C20-C26=0,0,(F20-F26)/(C20-C26)))","v":" "},null,{"$f":"IF(F4=0,\" \",IF(F6>F7,\"150% Violation\",F7-F6 &\" Credit Window\"))","v":" "}]
[null,{"$f":"IF(F5=0,\" \",IF(C12>89,IF(C12>89,IF(AND(C6<0.3333,F5=3),VLOOKUP(F5,Table8[],3,FALSE),IF(AND(C6<0.3333,F5=3),VLOOKUP(F5,Table8[],3,FALSE),IF(AND(C6<0.6666,F5>5),VLOOKUP(F5,Table8[],3,FALSE),\" \"))),\" \"),IF('AP Status'!C12<89,IF('AP Status'!C12<89,IF(AND(C6<0.3333,F5<2),VLOOKUP(F5,Table6[],3,FALSE),IF(AND(F5<3,C6<0.5),VLOOKUP(F5,Table6[],3,FALSE),IF(AND(F5>2,C6<0.6666),VLOOKUP(F5,Table6[],3,FALSE),\" \"))),\" \"),\" \"))&\"   \"&IF(C12>89,IF(AND(C12>89,C8<1,F5=3),VLOOKUP(F5,Table9[],3,FALSE),IF(AND(C8<1,F5=3),VLOOKUP(F5,Table9[],3,FALSE),IF(AND(C8<1,F5=3),VLOOKUP(F5,Table9[],3,FALSE),IF(AND(C8<2,F5>5),VLOOKUP(F5,Table9[],3,FALSE),\" \")))),IF(C12<89,IF(AND(C12<89,C8<1,F5=1),VLOOKUP(F5,Table7[],3,FALSE),IF(AND(C8<1.5,F5=2),VLOOKUP(F5,Table7[],3,FALSE),IF(AND(C8<2,F5>2),VLOOKUP(F5,Table7[],3,FALSE),\" \"))),\" \")))","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,{"$f":"SEARCH(\"ICR\",B9)","v":{"$error":"#VALUE!"}},{"$f":"SEARCH(\"CGPA\",B9)","v":{"$error":"#VALUE!"}}]
[]
[null,"FOR ICR AND MTF (Enter info from student transcript)"]
[null,"Program Length (Credits)"]
[]
[null,"Earned Credits",null,null,"Attempted Credits"]
[null,"Total Credits Earned",null,null,"Max Allowable",{"$f":"IF(F5=0,\" \",C12*1.5)","v":" "}]
[null,"Transfer & Proficiency Credits",null,null,"Total Credits Attempted"]
[null,"Remedial Earned",null,null,"Remedial Attempted"]
[]
[null,"FOR CGPA (Enter info from student transcript)"]
[null,"Total Quality Credits",{"$f":"IF(F5=0,\"\",F16-C16-C21-F17-F21)","v":""},null,"Total Quality Points",46.6]
[null,"Repeated Creds (No Remedial)",null,null,"W/drawn Creds (No Remedial)"]
[]
[null,"If student previously changed their major or degree then complete the following:"]
[]
[null,"ADJUSTMENTS FROM PROGRAM CHANGE (if applicable)"]
[null,"Adjusted Quality Credits",null,null,"Adjusted Quality Points"]
[null,"Adjusted Earned Credits",null,null,"Adjusted Attempted Credits"]

{"sheet":"Advising Projection Form","index":2,"n_rows":71,"n_cols":34,"rows_kept":71,"cut":false,"hidden":true,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6],[7,5,7,6]]}
[null,"ADVISING PROJECTION FORM"]
[null,"Enter student information into the white boxes.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[]
[null,{"$f":"'AP Status'!B4","v":0},null,{"$f":"'AP Status'!D4","v":0},null,{"$f":"'AP Status'!E4","v":"ID#"},{"$f":"'AP Status'!F4","v":0}]
[null,"PROJECTED SAP RESULTS",null,null,null,"Quarters Completed",{"$f":"'AP Status'!F5","v":0}]
[null,"ICR",{"$f":"'AP Status'!C6","v":" "},null,null,"Credits Left to Graduate",{"$f":"IF(G4=0,\" \",'AP Status'!F6-P18-P29-P40-P51-P62)","v":" "}]
[null,"CGPA",{"$f":"'AP Status'!C7","v":" "},null,null,"150% Creds Remaining",{"$f":"IF(G4=0,\" \",'AP Status'!F7-SUM(C12:C17)-SUM(C23:C28)-SUM(C34:C39)-SUM(C45:C50)-SUM(C56:C61))","v":" "}]
[null,"SAP CGPA",{"$f":"'AP Status'!C8","v":" "},null,null,{"$f":"IF(G4=0,\" \",IF(G6>G7,\"150% Violation\",IF(G6=0,\"Graduate\",G7-G6 &\" Credit Window\")))","v":" "}]
[]
[null,"NEXT QUARTER…",null,null,null,"Quarter",{"$f":"IF(G4=0,\" \",G5+1)","v":" "}]
[null,null,"Credits","Letter Grade","Failed Before?",null,null,null,"Points","ICR Earned","Qual Att",null,"Sess Qual Att",null,"MTF Att","MTF Earned"]
[null,"Course 1",null,null,null,"When taking less than 6 classes,",null,null,{"$f":"IF(D12=\"W\",0,IF(ISNA(VLOOKUP(D12,Table2[],2,FALSE)*C12),0,(VLOOKUP(D12,Table2[],2,FALSE)*C12)))","v":0},{"$f":"IF(D12=\"W\",0,IF(ISNA(IF(I12=0,0,C12)),\" \",(IF(I12=0,0,C12))))","v":0},{"$f":"IF(OR(D12=\"W\",E12=\"Yes\"),0,C12)","v":0},null,{"$f":"IF(D12=\"W\",0,IF(ISNA(IF(I12=0,0,C12)),\" \",(IF(I12=0,0,C12))))","v":0},null,{"$f":"IF(ISBLANK(C12),0,C12)","v":0},{"$f":"IF(C12=0,0,IF(AND(D12<>\"F\",D12<>\"W\"),C12,0))","v":0},null,null," "]
[null,"Course 2",null,null,null,"make sure there is no credit value",null,null,{"$f":"IF(D13=\"W\",0,IF(ISNA(VLOOKUP(D13,Table2[],2,FALSE)*C13),0,(VLOOKUP(D13,Table2[],2,FALSE)*C13)))","v":0},{"$f":"IF(D13=\"W\",0,IF(ISNA(IF(I13=0,0,C13)),\" \",(IF(I13=0,0,C13))))","v":0},{"$f":"IF(OR(D13=\"W\",E13=\"Yes\"),0,C13)","v":0},null,{"$f":"IF(D13=\"W\",0,IF(ISNA(IF(I13=0,0,C13)),\" \",(IF(I13=0,0,C13))))","v":0},null,{"$f":"IF(ISBLANK(C13),0,C13)","v":0},{"$f":"IF(C13=0,0,IF(AND(D13<>\"F\",D13<>\"W\"),C13,0))","v":0}]
[null,"Course 3",null,null,null,"or letter grade value entered.",null,null,{"$f":"IF(D14=\"W\",0,IF(ISNA(VLOOKUP(D14,Table2[],2,FALSE)*C14),0,(VLOOKUP(D14,Table2[],2,FALSE)*C14)))","v":0},{"$f":"IF(D14=\"W\",0,IF(ISNA(IF(I14=0,0,C14)),\" \",(IF(I14=0,0,C14))))","v":0},0,null,0,null,0,0]
[null,"Course 4",null,null,null,null,null,null,{"$f":"IF(D15=\"W\",0,IF(ISNA(VLOOKUP(D15,Table2[],2,FALSE)*C15),0,(VLOOKUP(D15,Table2[],2,FALSE)*C15)))","v":0},0,0,null,0,null,0,0]
[null,"Course 5",null,null,null,"For projection purposes, remedial ",null,null,{"$f":"IF(D16=\"W\",0,IF(ISNA(VLOOKUP(D16,Table2[],2,FALSE)*C16),0,(VLOOKUP(D16,Table2[],2,FALSE)*C16)))","v":0},0,0,null,0,null,0,0]
[null,"Course 6",null,null,null,"courses are worth '0' credits.",null,null,{"$f":"IF(D17=\"W\",0,IF(ISNA(VLOOKUP(D17,Table2[],2,FALSE)*C17),0,(VLOOKUP(D17,Table2[],2,FALSE)*C17)))","v":0},0,0,null,0,null,0,0]
[null,"New ICR",{"$f":"IF(SUM(C12:C17)<3,C6,('AP Status'!C15-'AP Status'!C17-'AP Status'!C27+J18)/('AP Status'!F16-'AP Status'!F17-'AP Status'!F27+SUM(C12:C17)))","v":" "},null,null,{"$f":"IF(G4=0,\" \",IF('AP Status'!C12>89,IF('AP Status'!C12>89,IF(AND(C18<0.3333,G5+1=3),VLOOKUP(G5+1,Table8[],3,FALSE),IF(AND(C18<0.3333,G5+1<=3),VLOOKUP(G5+1,Table8[],3,FALSE),IF(AND(C18<0.6666,G5+1>5),VLOOKUP(G5+1,Table8[],3,FALSE),\" \"))),\" \"),IF('AP Status'!C12<89,IF('AP Status'!C12<89,IF(AND(C18<0.3333,G5+1<2),VLOOKUP(G5+1,Table6[],3,FALSE),IF(AND(G5+1<3,C18<0.5),VLOOKUP(G5+1,Table6[],3,FALSE),IF(AND(G5+1>2,C18<0.6666),VLOOKUP(G5+1,Table6[],3,FALSE),\" \"))),\" \"),\" \")))","v":" "},null,null,{"$f":"SUBTOTAL(9,I12:I17)","v":0},{"$f":"SUBTOTAL(9,J12:J17)","v":0},{"$f":"SUBTOTAL(9,K12:K17)","v":0},{"$f":"SEARCH(\"ICR\",F18)","v":{"$error":"#VALUE!"}},{"$f":"SUBTOTAL(9,M12:M17)","v":0},null,{"$f":"SUBTOTAL(9,O12:O17)","v":0},{"$f":"SUBTOTAL(9,P12:P17)","v":0}]
[null,"New SAP CGPA",{"$f":"IF(SUM(C12:C17)<3,C8,(I18+'AP Status'!F20-'AP Status'!F26)/IF(K18+'AP Status'!C20-'AP Status'!C26=0,1,(K18+'AP Status'!C20-'AP Status'!C26)))","v":" "},{"$f":"IF(SUM(C12:C17)<3,\"\",\"Sess GPA\")","v":""},{"$f":"IF(SUM(C12:C17)<3,\"\",IF(M18=0,0,I18/M18))","v":""},{"$f":"IF(G4=0,\" \",IF('AP Status'!C12>89,IF(AND('AP Status'!C12>89,C19<1,G5+1=3),VLOOKUP(G5+1,Table9[],3,FALSE),IF(AND(C19<1,G5+1=3),VLOOKUP(G5+1,Table9[],3,FALSE),IF(AND(C19<1,G5+1=3),VLOOKUP(G5+1,Table9[],3,FALSE),IF(AND(C19<2,G5+1>5),VLOOKUP(G5+1,Table9[],3,FALSE),\" \")))),IF('AP Status'!C12<89,IF(AND('AP Status'!C12<89,C19<1,G5+1=1),VLOOKUP(G5+1,Table7[],3,FALSE),IF(AND(C19<1.5,G5+1=2),VLOOKUP(G5+1,Table7[],3,FALSE),IF(AND(C19<2,G5+1>2),VLOOKUP(G5+1,Table7[],3,FALSE),\" \"))),\" \")))","v":" "},null,null,null,null,null,{"$f":"SEARCH(\"CGPA\",F19)","v":{"$error":"#VALUE!"}}]
[]
[null,"… AND THE QUARTER AFTER THAT",null,null,null,"Quarter",{"$f":"IF(G4=0,\" \",G5+2)","v":" "}]
[null,null,"Credits","Letter Grade","Failed Before?"]
[null,"Course 1",null,null,null,"When taking less than 6 classes,",null,null,{"$f":"IF(ISNA(VLOOKUP(D23,Table2[],2,FALSE)*C23),0,(VLOOKUP(D23,Table2[],2,FALSE)*C23))","v":0},{"$f":"IF(D23=\"W\",0,IF(ISNA(IF(I23=0,0,C23)),\" \",(IF(I23=0,0,C23))))","v":0},{"$f":"IF(OR(D23=\"W\",E23=\"Yes\"),0,C23)","v":0},null,{"$f":"IF(D23=\"W\",0,IF(ISNA(IF(I23=0,0,C23)),\" \",(IF(I23=0,0,C23))))","v":0},null,{"$f":"IF(ISBLANK(C23),0,C23)","v":0},{"$f":"IF(C23=0,0,IF(AND(D23<>\"F\",D23<>\"W\"),C23,0))","v":0}]
[null,"Course 2",null,null,null,"make sure there is no credit value",null,null,{"$f":"IF(ISNA(VLOOKUP(D24,Table2[],2,FALSE)*C24),0,(VLOOKUP(D24,Table2[],2,FALSE)*C24))","v":0},{"$f":"IF(D24=\"W\",0,IF(ISNA(IF(I24=0,0,C24)),\" \",(IF(I24=0,0,C24))))","v":0},{"$f":"IF(OR(D24=\"W\",E24=\"Yes\"),0,C24)","v":0},null,{"$f":"IF(D24=\"W\",0,IF(ISNA(IF(I24=0,0,C24)),\" \",(IF(I24=0,0,C24))))","v":0},null,{"$f":"IF(ISBLANK(C24),0,C24)","v":0},{"$f":"IF(C24=0,0,IF(AND(D24<>\"F\",D24<>\"W\"),C24,0))","v":0}]
[null,"Course 3",null,null,null,"or letter grade value entered.",null,null,{"$f":"IF(ISNA(VLOOKUP(D25,Table2[],2,FALSE)*C25),0,(VLOOKUP(D25,Table2[],2,FALSE)*C25))","v":0},{"$f":"IF(D25=\"W\",0,IF(ISNA(IF(I25=0,0,C25)),\" \",(IF(I25=0,0,C25))))","v":0},0,null,0,null,0,0]
[null,"Course 4",null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(D26,Table2[],2,FALSE)*C26),0,(VLOOKUP(D26,Table2[],2,FALSE)*C26))","v":0},0,0,null,0,null,0,0]
[null,"Course 5",null,null,null,"For projection purposes, remedial ",null,null,{"$f":"IF(ISNA(VLOOKUP(D27,Table2[],2,FALSE)*C27),0,(VLOOKUP(D27,Table2[],2,FALSE)*C27))","v":0},0,0,null,0,null,0,0]
[null,"Course 6",null,null,null,"courses are worth '0' credits.",null,null,{"$f":"IF(ISNA(VLOOKUP(D28,Table2[],2,FALSE)*C28),0,(VLOOKUP(D28,Table2[],2,FALSE)*C28))","v":0},0,0,null,0,null,0,0]
[null,"New ICR",{"$f":"IF(SUM(C23:C28)<3,C18,('AP Status'!C15-'AP Status'!C17-'AP Status'!C27+J18+J29)/('AP Status'!F16-'AP Status'!F17-'AP Status'!F27+SUM(C12:C17)+SUM(C23:C28)))","v":" "},null,null,{"$f":"IF(G4=0,\" \",IF('AP Status'!C12>89,IF('AP Status'!C12>89,IF(AND(C29<0.3333,G5+2=3),VLOOKUP(G5+2,Table8[],3,FALSE),IF(AND(C29<0.3333,G5+2=3),VLOOKUP(G5+2,Table8[],3,FALSE),IF(AND(C29<0.6666,G5+2>5),VLOOKUP(G5+2,Table8[],3,FALSE),\" \"))),\" \"),IF('AP Status'!C12<89,IF('AP Status'!C12<89,IF(AND(C29<0.3333,G5+2<2),VLOOKUP(G5+2,Table6[],3,FALSE),IF(AND(G5+2<3,C29<0.5),VLOOKUP(G5+2,Table6[],3,FALSE),IF(AND(G5+2>2,C29<0.6666),VLOOKUP(G5+2,Table6[],3,FALSE),\" \"))),\" \"),\" \")))","v":" "},null,null,{"$f":"SUBTOTAL(9,I23:I28)","v":0},{"$f":"SUBTOTAL(9,J23:J28)","v":0},{"$f":"SUBTOTAL(9,K23:K28)","v":0},{"$f":"SEARCH(\"ICR\",F29)","v":{"$error":"#VALUE!"}},{"$f":"SUBTOTAL(9,M23:M28)","v":0},null,{"$f":"SUBTOTAL(9,O23:O28)","v":0},{"$f":"SUBTOTAL(9,P23:P28)","v":0}]
[null,"New SAP CGPA",{"$f":"IF(SUM(C23:C28)<3,C19,(I18+I29+'AP Status'!F20-'AP Status'!F26)/(K18+K29+'AP Status'!C20-'AP Status'!C26))","v":" "},{"$f":"IF(SUM(C23:C28)<3,\"\",\"Sess GPA\")","v":""},{"$f":"IF(SUM(C23:C28)<3,\"\",IF(M29=0,0,I29/M29))","v":""},{"$f":"IF(G4=0,\" \",IF('AP Status'!C12>89,IF(AND('AP Status'!C12>89,C30<1,G5+2=3),VLOOKUP(G5+2,Table9[],3,FALSE),IF(AND(C30<1,G5+2=3),VLOOKUP(G5+2,Table9[],3,FALSE),IF(AND(C30<1,G5+2=3),VLOOKUP(G5+2,Table9[],3,FALSE),IF(AND(C30<2,G5+2>5),VLOOKUP(G5+2,Table9[],3,FALSE),\" \")))),IF('AP Status'!C12<89,IF(AND('AP Status'!C12<89,C30<1,G5+2=1),VLOOKUP(G5+2,Table7[],3,FALSE),IF(AND(C30<1.5,G5+2=2),VLOOKUP(G5+2,Table7[],3,FALSE),IF(AND(C30<2,G5+2>2),VLOOKUP(G5+2,Table7[],3,FALSE),\" \"))),\" \")))","v":" "},null,null,null,null,null,{"$f":"SEARCH(\"CGPA\",F30)","v":{"$error":"#VALUE!"}}]
[]
[null,"… AND THE QUARTER AFTER THAT",null,null,null,"Quarter",{"$f":"IF(G4=0,\" \",G5+3)","v":" "}]
[null,null,"Credits","Letter Grade","Failed Before?"]
[null,"Course 1",null,null,null,"When taking less than 6 classes,",null,null,{"$f":"IF(ISNA(VLOOKUP(D34,Table2[],2,FALSE)*C34),0,(VLOOKUP(D34,Table2[],2,FALSE)*C34))","v":0},{"$f":"IF(D34=\"W\",0,IF(ISNA(IF(I34=0,0,C34)),\" \",(IF(I34=0,0,C34))))","v":0},{"$f":"IF(OR(D34=\"W\",E34=\"Yes\"),0,C34)","v":0},null,{"$f":"IF(D34=\"W\",0,IF(ISNA(IF(I34=0,0,C34)),\" \",(IF(I34=0,0,C34))))","v":0},null,{"$f":"IF(ISBLANK(C34),0,C34)","v":0},{"$f":"IF(C34=0,0,IF(AND(D34<>\"F\",D34<>\"W\"),C34,0))","v":0}]
[null,"Course 2",null,null,null,"make sure there is no credit value",null,null,{"$f":"IF(ISNA(VLOOKUP(D35,Table2[],2,FALSE)*C35),0,(VLOOKUP(D35,Table2[],2,FALSE)*C35))","v":0},{"$f":"IF(D35=\"W\",0,IF(ISNA(IF(I35=0,0,C35)),\" \",(IF(I35=0,0,C35))))","v":0},{"$f":"IF(OR(D35=\"W\",E35=\"Yes\"),0,C35)","v":0},null,{"$f":"IF(D35=\"W\",0,IF(ISNA(IF(I35=0,0,C35)),\" \",(IF(I35=0,0,C35))))","v":0},null,{"$f":"IF(ISBLANK(C35),0,C35)","v":0},{"$f":"IF(C35=0,0,IF(AND(D35<>\"F\",D35<>\"W\"),C35,0))","v":0}]
[null,"Course 3",null,null,null,"or letter grade value entered.",null,null,{"$f":"IF(ISNA(VLOOKUP(D36,Table2[],2,FALSE)*C36),0,(VLOOKUP(D36,Table2[],2,FALSE)*C36))","v":0},{"$f":"IF(D36=\"W\",0,IF(ISNA(IF(I36=0,0,C36)),\" \",(IF(I36=0,0,C36))))","v":0},0,null,0,null,0,0]
[null,"Course 4",null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(D37,Table2[],2,FALSE)*C37),0,(VLOOKUP(D37,Table2[],2,FALSE)*C37))","v":0},0,0,null,0,null,0,0]
[null,"Course 5",null,null,null,"For projection purposes, remedial ",null,null,{"$f":"IF(ISNA(VLOOKUP(D38,Table2[],2,FALSE)*C38),0,(VLOOKUP(D38,Table2[],2,FALSE)*C38))","v":0},0,0,null,0,null,0,0]
[null,"Course 6",null,null,null,"courses are worth '0' credits.",null,null,{"$f":"IF(ISNA(VLOOKUP(D39,Table2[],2,FALSE)*C39),0,(VLOOKUP(D39,Table2[],2,FALSE)*C39))","v":0},0,0,null,0,null,0,0]
[null,"New ICR",{"$f":"IF(SUM(C34:C39)<3,C29,('AP Status'!C15-'AP Status'!C17-'AP Status'!C27+J18+J29+J40)/('AP Status'!F16-'AP Status'!F17-'AP Status'!F27+SUM(C12:C17)+SUM(C23:C28)+SUM(C34:C39)))","v":" "},null,null,{"$f":"IF(G4=0,\" \",IF('AP Status'!C12>89,IF('AP Status'!C12>89,IF(AND(C40<0.3333,G5+3=3),VLOOKUP(G5+3,Table8[],3,FALSE),IF(AND(C40<0.3333,G5+3=3),VLOOKUP(G5+3,Table8[],3,FALSE),IF(AND(C40<0.6666,G5+3>5),VLOOKUP(G5+3,Table8[],3,FALSE),\" \"))),\" \"),IF('AP Status'!C12<89,IF('AP Status'!C12<89,IF(AND(C40<0.3333,G5+3<2),VLOOKUP(G5+3,Table6[],3,FALSE),IF(AND(G5+3<3,C40<0.5),VLOOKUP(G5+3,Table6[],3,FALSE),IF(AND(G5+3>2,C40<0.6666),VLOOKUP(G5+3,Table6[],3,FALSE),\" \"))),\" \"),\" \")))","v":" "},null,null,{"$f":"SUBTOTAL(9,I34:I39)","v":0},{"$f":"SUBTOTAL(9,J34:J39)","v":0},{"$f":"SUBTOTAL(9,K34:K39)","v":0},{"$f":"SEARCH(\"ICR\",F40)","v":{"$error":"#VALUE!"}},{"$f":"SUBTOTAL(9,M34:M39)","v":0},null,{"$f":"SUBTOTAL(9,O34:O39)","v":0},{"$f":"SUBTOTAL(9,P34:P39)","v":0}]
[null,"New SAP CGPA",{"$f":"IF(SUM(C34:C39)<3,C30,(I18+I29+I40+'AP Status'!F20-'AP Status'!F26)/(K18+K29+K40+'AP Status'!C20-'AP Status'!C26))","v":" "},{"$f":"IF(SUM(C34:C39)<3,\"\",\"Sess GPA\")","v":""},{"$f":"IF(SUM(C34:C39)<3,\"\",IF(M40=0,0,I40/M40))","v":""},{"$f":"IF(G4=0,\" \",IF('AP Status'!C12>89,IF(AND('AP Status'!C12>89,C41<1,G5+3=3),VLOOKUP(G5+3,Table9[],3,FALSE),IF(AND(C41<1,G5+3=3),VLOOKUP(G5+3,Table9[],3,FALSE),IF(AND(C41<2,G5+3>5),VLOOKUP(G5+3,Table9[],3,FALSE),\" \"))),IF('AP Status'!C12<89,IF(AND('AP Status'!C12<89,C41<1,G5+3=1),VLOOKUP(G5+3,Table7[],3,FALSE),IF(AND(C41<1.5,G5+3=2),VLOOKUP(G5+3,Table7[],3,FALSE),IF(AND(C41<2,G5+3>2),VLOOKUP(G5+3,Table7[],3,FALSE),\" \"))),\" \")))","v":" "},null,null,null,null,null,{"$f":"SEARCH(\"CGPA\",F41)","v":{"$error":"#VALUE!"}}]
[]
[null,"… AND THE QUARTER AFTER THAT",null,null,null,"Quarter",{"$f":"IF(G4=0,\" \",G5+4)","v":" "}]
[null,null,"Credits","Letter Grade","Failed Before?"]
[null,"Course 1",null,null,null,"When taking less than 6 classes,",null,null,{"$f":"IF(ISNA(VLOOKUP(D45,Table2[],2,FALSE)*C45),0,(VLOOKUP(D45,Table2[],2,FALSE)*C45))","v":0},{"$f":"IF(D45=\"W\",0,IF(ISNA(IF(I45=0,0,C45)),\" \",(IF(I45=0,0,C45))))","v":0},{"$f":"IF(OR(D45=\"W\",E45=\"Yes\"),0,C45)","v":0},null,{"$f":"IF(D45=\"W\",0,IF(ISNA(IF(I45=0,0,C45)),\" \",(IF(I45=0,0,C45))))","v":0},null,{"$f":"IF(ISBLANK(C45),0,C45)","v":0},{"$f":"IF(C45=0,0,IF(AND(D45<>\"F\",D45<>\"W\"),C45,0))","v":0}]
[null,"Course 2",null,null,null,"make sure there is no credit value",null,null,{"$f":"IF(ISNA(VLOOKUP(D46,Table2[],2,FALSE)*C46),0,(VLOOKUP(D46,Table2[],2,FALSE)*C46))","v":0},{"$f":"IF(D46=\"W\",0,IF(ISNA(IF(I46=0,0,C46)),\" \",(IF(I46=0,0,C46))))","v":0},{"$f":"IF(OR(D46=\"W\",E46=\"Yes\"),0,C46)","v":0},null,{"$f":"IF(D46=\"W\",0,IF(ISNA(IF(I46=0,0,C46)),\" \",(IF(I46=0,0,C46))))","v":0},null,{"$f":"IF(ISBLANK(C46),0,C46)","v":0},{"$f":"IF(C46=0,0,IF(AND(D46<>\"F\",D46<>\"W\"),C46,0))","v":0}]
[null,"Course 3",null,null,null,"or letter grade value entered.",null,null,{"$f":"IF(ISNA(VLOOKUP(D47,Table2[],2,FALSE)*C47),0,(VLOOKUP(D47,Table2[],2,FALSE)*C47))","v":0},0,0,null,0,null,0,0]
[null,"Course 4",null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(D48,Table2[],2,FALSE)*C48),0,(VLOOKUP(D48,Table2[],2,FALSE)*C48))","v":0},0,0,null,0,null,0,0]
[null,"Course 5",null,null,null,"For projection purposes, remedial ",null,null,{"$f":"IF(ISNA(VLOOKUP(D49,Table2[],2,FALSE)*C49),0,(VLOOKUP(D49,Table2[],2,FALSE)*C49))","v":0},0,0,null,0,null,0,0]
[null,"Course 6",null,null,null,"courses are worth '0' credits.",null,null,{"$f":"IF(ISNA(VLOOKUP(D50,Table2[],2,FALSE)*C50),0,(VLOOKUP(D50,Table2[],2,FALSE)*C50))","v":0},0,0,null,0,null,0,0]
[null,"New ICR",{"$f":"IF(SUM(C45:C50)<3,C40,('AP Status'!C15-'AP Status'!C17-'AP Status'!C27+J18+J29+J40+J51)/('AP Status'!F16-'AP Status'!F17-'AP Status'!F27+SUM(C12:C17)+SUM(C23:C28)+SUM(C34:C39)+SUM(C45:C50)))","v":" "},null,null,{"$f":"IF(G4=0,\" \",IF('AP Status'!C12>89,IF('AP Status'!C12>89,IF(AND(C51<0.3333,G5+4=3),VLOOKUP(G5+4,Table8[],3,FALSE),IF(AND(C51<0.3333,G5+4=3),VLOOKUP(G5+4,Table8[],3,FALSE),IF(AND(C51<0.6666,G5+4>5),VLOOKUP(G5+4,Table8[],3,FALSE),\" \"))),\" \"),IF('AP Status'!C12<89,IF('AP Status'!C12<89,IF(AND(C51<0.3333,G5+4<2),VLOOKUP(G5+4,Table6[],3,FALSE),IF(AND(G5+4<3,C51<0.5),VLOOKUP(G5+4,Table6[],3,FALSE),IF(AND(G5+4>2,C51<0.6666),VLOOKUP(G5+4,Table6[],3,FALSE),\" \"))),\" \"),\" \")))","v":" "},null,null,{"$f":"SUBTOTAL(9,I45:I50)","v":0},{"$f":"SUBTOTAL(9,J45:J50)","v":0},{"$f":"SUBTOTAL(9,K45:K50)","v":0},{"$f":"SEARCH(\"ICR\",F51)","v":{"$error":"#VALUE!"}},{"$f":"SUBTOTAL(9,M45:M50)","v":0},null,{"$f":"SUBTOTAL(9,O45:O50)","v":0},{"$f":"SUBTOTAL(9,P45:P50)","v":0}]
[null,"New SAP CGPA",{"$f":"IF(SUM(C45:C50)<3,C41,(I18+I29+I40+I51+'AP Status'!F20-'AP Status'!F26)/(K18+K29+K40+K51+'AP Status'!C20-'AP Status'!C26))","v":" "},{"$f":"IF(SUM(C45:C50)<3,\"\",\"Sess GPA\")","v":""},{"$f":"IF(SUM(C45:C50)<3,\"\",IF(M51=0,0,I51/M51))","v":""},{"$f":"IF(G4=0,\" \",IF('AP Status'!C12>89,IF(AND('AP Status'!C12>89,C52<1,G5+4=3),VLOOKUP(G5+4,Table9[],3,FALSE),IF(AND(C52<1,G5+4=3),VLOOKUP(G5+4,Table9[],3,FALSE),IF(AND(C52<2,G5+4>5),VLOOKUP(G5+4,Table9[],3,FALSE),\" \"))),IF('AP Status'!C12<89,IF(AND('AP Status'!C12<89,C52<1,G5+4=1),VLOOKUP(G5+4,Table7[],3,FALSE),IF(AND(C52<1.5,G5+4=2),VLOOKUP(G5+4,Table7[],3,FALSE),IF(AND(C52<2,G5+4>2),VLOOKUP(G5+4,Table7[],3,FALSE),\" \"))),\" \")))","v":" "},null,null,null,null,null,{"$f":"SEARCH(\"CGPA\",F52)","v":{"$error":"#VALUE!"}}]
[]
[null,"… AND THE QUARTER AFTER THAT",null,null,null,"Quarter",{"$f":"IF(G4=0,\" \",G5+5)","v":" "}]
[null,null,"Credits","Letter Grade","Failed Before?"]
[null,"Course 1",null,null,null,"When taking less than 6 classes,",null,null,{"$f":"IF(ISNA(VLOOKUP(D56,Table2[],2,FALSE)*C56),0,(VLOOKUP(D56,Table2[],2,FALSE)*C56))","v":0},{"$f":"IF(D56=\"W\",0,IF(ISNA(IF(I56=0,0,C56)),\" \",(IF(I56=0,0,C56))))","v":0},{"$f":"IF(OR(D56=\"W\",E56=\"Yes\"),0,C56)","v":0},null,{"$f":"IF(D56=\"W\",0,IF(ISNA(IF(I56=0,0,C56)),\" \",(IF(I56=0,0,C56))))","v":0},null,{"$f":"IF(ISBLANK(C56),0,C56)","v":0},{"$f":"IF(C56=0,0,IF(AND(D56<>\"F\",D56<>\"W\"),C56,0))","v":0}]
[null,"Course 2",null,null,null,"make sure there is no credit value",null,null,{"$f":"IF(ISNA(VLOOKUP(D57,Table2[],2,FALSE)*C57),0,(VLOOKUP(D57,Table2[],2,FALSE)*C57))","v":0},{"$f":"IF(D57=\"W\",0,IF(ISNA(IF(I57=0,0,C57)),\" \",(IF(I57=0,0,C57))))","v":0},{"$f":"IF(OR(D57=\"W\",E57=\"Yes\"),0,C57)","v":0},null,{"$f":"IF(D57=\"W\",0,IF(ISNA(IF(I57=0,0,C57)),\" \",(IF(I57=0,0,C57))))","v":0},null,{"$f":"IF(ISBLANK(C57),0,C57)","v":0},{"$f":"IF(C57=0,0,IF(AND(D57<>\"F\",D57<>\"W\"),C57,0))","v":0}]
[null,"Course 3",null,null,null,"or letter grade value entered.",null,null,{"$f":"IF(ISNA(VLOOKUP(D58,Table2[],2,FALSE)*C58),0,(VLOOKUP(D58,Table2[],2,FALSE)*C58))","v":0},0,0,null,0,null,0,0]
[null,"Course 4",null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(D59,Table2[],2,FALSE)*C59),0,(VLOOKUP(D59,Table2[],2,FALSE)*C59))","v":0},0,0,null,0,null,0,0]
[null,"Course 5",null,null,null,"For projection purposes, remedial ",null,null,{"$f":"IF(ISNA(VLOOKUP(D60,Table2[],2,FALSE)*C60),0,(VLOOKUP(D60,Table2[],2,FALSE)*C60))","v":0},0,0,null,0,null,0,0]
[null,"Course 6",null,null,null,"courses are worth '0' credits.",null,null,{"$f":"IF(ISNA(VLOOKUP(D61,Table2[],2,FALSE)*C61),0,(VLOOKUP(D61,Table2[],2,FALSE)*C61))","v":0},0,0,null,0,null,0,0]
[null,"New ICR",{"$f":"IF(SUM(C56:C61)<3,C51,('AP Status'!C15-'AP Status'!C17-'AP Status'!C27+J18+J29+J40+J51+J62)/('AP Status'!F16-'AP Status'!F17-'AP Status'!F27+SUM(C12:C17)+SUM(C23:C28)+SUM(C34:C39)+SUM(C45:C50)+SUM(C56:C61)))","v":" "},null,null,{"$f":"IF(G4=0,\" \",IF('AP Status'!C12>89,IF('AP Status'!C12>89,IF(AND(C62<0.3333,G5+5=3),VLOOKUP(G5+5,Table8[],3,FALSE),IF(AND(C62<0.3333,G5+5=3),VLOOKUP(G5+5,Table8[],3,FALSE),IF(AND(C62<0.6666,G5+5>5),VLOOKUP(G5+5,Table8[],3,FALSE),\" \"))),\" \"),IF('AP Status'!C12<89,IF('AP Status'!C12<89,IF(AND(C62<0.3333,G5+5<2),VLOOKUP(G5+5,Table6[],3,FALSE),IF(AND(G5+5<3,C62<0.5),VLOOKUP(G5+5,Table6[],3,FALSE),IF(AND(G5+5>2,C62<0.6666),VLOOKUP(G5+5,Table6[],3,FALSE),\" \"))),\" \"),\" \")))","v":" "},null,null,{"$f":"SUBTOTAL(9,I56:I61)","v":0},{"$f":"SUBTOTAL(9,J56:J61)","v":0},{"$f":"SUBTOTAL(9,K56:K61)","v":0},{"$f":"SEARCH(\"ICR\",F62)","v":{"$error":"#VALUE!"}},{"$f":"SUBTOTAL(9,M56:M61)","v":0},null,{"$f":"SUBTOTAL(9,O56:O61)","v":0},{"$f":"SUBTOTAL(9,P56:P61)","v":0}]
[null,"New SAP CGPA",{"$f":"IF(SUM(C56:C61)<3,C52,(I18+I29+I40+I51+I62+'AP Status'!F20-'AP Status'!F26)/(K18+K29+K40+K51+K62+'AP Status'!C20-'AP Status'!C26))","v":" "},{"$f":"IF(SUM(C56:C61)<3,\"\",\"Sess GPA\")","v":""},{"$f":"IF(SUM(C56:C61)<3,\"\",IF(M62=0,0,I62/M62))","v":""},{"$f":"IF(G4=0,\" \",IF('AP Status'!C12>89,IF(AND('AP Status'!C12>89,C63<1,G5+5=3),VLOOKUP(G5+5,Table9[],3,FALSE),IF(AND(C63<1,G5+5=3),VLOOKUP(G5+5,Table9[],3,FALSE),IF(AND(C63<2,G5+5>5),VLOOKUP(G5+5,Table9[],3,FALSE),\" \"))),IF('AP Status'!C12<89,IF(AND('AP Status'!C12<89,C63<1,G5+5=1),VLOOKUP(G5+5,Table7[],3,FALSE),IF(AND(C63<1.5,G5+5=2),VLOOKUP(G5+5,Table7[],3,FALSE),IF(AND(C63<2,G5+5>2),VLOOKUP(G5+5,Table7[],3,FALSE),\" \"))),\" \")))","v":" "},null,null,null,null,null,{"$f":"SEARCH(\"CGPA\",F63)","v":{"$error":"#VALUE!"}}]
[]
[null,"ACKNOWLEDGEMENTS"]
[]
[]
[null,"Student Signature",null,null,null,null,"Date"]
[]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-10-18"}]
[null,"School Official (Print)",null,null,null,"Signature","Date"]

{"sheet":"SAPRA","index":3,"n_rows":57,"n_cols":41,"rows_kept":57,"cut":false,"hidden":true,"merged":[[0,1,0,11],[16,2,16,11],[17,2,17,11],[19,6,19,7],[1,1,1,11],[52,10,52,11],[55,10,55,11],[20,6,20,7],[11,6,12,7],[11,8,12,11],[44,1,44,6],[44,7,44,11],[21,6,21,7],[32,6,32,10],[34,6,34,10],[30,1,30,11],[38,1,38,11],[25,1,27,11]]}
[null,"SATISFACTORY ACADEMIC PROGRESS RESPONSIBILITY AGREEMENT (SAPRA)"]
[null,"Enter student information into the white boxes.",null,null,null,null,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":"I4+1","v":1},null,"Dismissal",null,"a 1.0 CGPA and/or 33.33% ICR",null,null,null,"Yes","WI",2011]
[null,"Student Name",null,null,"Student ID","Major","Term","Year","Quarters Completed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I4+2","v":2},null,"Warning",null,"a 1.25 CGPA and/or 50% ICR",null,null,null,"No","SP",2012]
[null,{"$f":"'AP Status'!B4","v":0},null,null,{"$f":"'AP Status'!F4","v":0},{"$f":"'AP Status'!D4","v":0},"FA",2014,{"$f":"'AP Status'!F5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I4+3","v":3},null,"Probation",null,"a 1.50 CGPA and/or 50% ICR",null,null,null,"Not Applicable","SU",2013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a 2.0 CGPA and/or 66.67% ICR",null,null,null,null,"FA",2014]
[null,"CURRENT ACADEMIC STANDING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3x Remedial",null,null,null,null,null,2015]
[null,"As of Quarter:",{"$f":"I4","v":0},"CGPA:",{"$f":"'AP Status'!C8","v":" "},"ICR:",{"$f":"'AP Status'!C6","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,"Maximum Allowable Timeframe (MTF)"]
[null,"ICR/CGPA Status:",{"$f":"'AP Status'!B9","v":" "}]
[null,"MTF Status:",{"$f":"'AP Status'!E8","v":" "}]
[]
[null,"ACADEMIC PROGRESS EVALUATION CRITERIA"]
[null,"Next evaluation point is at the end of quarter:",null,null,null,null,"Minimum standard to meet:"]
[null,"Inability to meet minimum standards will result in:",null,null,null,"Dismissal"]
[]
[]
[null,"FOR STUDENTS PLACED ON WARNING OR PROBATION (APPEAL)"]
[null,null,"Student has been approved for a ONE quarter probation*"]
[null,null,"Student has been approved for a TWO quarter probation (Degree students only are eligible)*"]
[]
[null,"Quarter",{"$f":"IF(E4=0,\" \",I4+1)","v":" "},"Credits earned/attempted",null,{"$f":"'Advising Projection Form'!P18&\"/\"&'Advising Projection Form'!O18","v":"0/0"},"CGPA/Sess GPA",null,3,"ICR to earn",null,0.65910000000000002]
[null,"Quarter",{"$f":"IF(E4=0,\" \",I4+2)","v":" "},"Credits earned/attempted",null,{"$f":"'Advising Projection Form'!P29&\"/\"&'Advising Projection Form'!O29","v":"0/0"},"CGPA/Sess GPA",null,3.22,"ICR to earn",null,0.70299999999999996]
[null,"Quarter",{"$f":"IF(E4=0,\" \",I4+3)","v":" "},"Credits earned/attempted",null,{"$f":"'Advising Projection Form'!P40&\"/\"&'Advising Projection Form'!O40","v":"0/0"},"CGPA/Sess GPA",null," ","ICR to earn",null," "]
[]
[null,"*Student must meet outlined probation requirements in order to continue to probation 2 status."]
[null,"Additional Notes and Recommendations:"]
[]
[]
[]
[]
[null,"FOR STUDENTS APPROACHING THIRD ATTEMPT AT TRANSITIONAL STUDIES/REMEDIAL COURSES"]
[null,"Transitional Studies/Remedial Courses: Transitional Studies/Remedial courses may be individually attempted no more than three (3) times. Failing (earning below a C grade) and/or withdrawing from a Transitional Studies/Remedial course three (3) times will result in Dismissal. Transitional Studies/Remedial course credits do not count towards the total number of credits for graduation, CGPA, ICR, or maximum timeframe (MTF)."]
[]
[null,"Third (3rd) attempt for Transitional Studies/Remedial Course(s):"]
[]
[null,"Inability to meet standard will result in:",null,null,null,null,"Dismissal"]
[]
[]
[null,"FOR STUDENTS APPROACHING MAXIMUM ALLOWABLE TIMEFRAME (MTF)"]
[null,"Maximum Time Frame: Students must complete all program requirements within the maximum time frame, which is 150% of total program credits. Students may not attempt more than 150% of the total program credits. Exceeding 150% of the credits required in the program will result in Dismissal."]
[]
[null,"Credits remaining that student may attempt minus Credits remaining to complete all program requirements:",null,null,null,null,null,null,null,null,null,{"$f":"IF(E4=0,\" \",'AP Status'!F7-'AP Status'!F6)","v":" "}]
[]
[null,"Inability to meet standard will result in Dismissal."]
[]
[null,"Students on Warning or Probation status are strongly encourage\nto meet regularly with an Academic Advisor. Meetings will be held:"]
[]
[]
[null,"ACKNOWLEDGEMENTS"]
[]
[]
[null,"Student Signature",null,null,null,null,null,null,null,null,"Date"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-10-18"}]
[null,"Advisor/Academic Department Director (Print)",null,null,null,"Signature",null,null,null,null,"Date"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-10-18"}]
[null,"Dean of Academic Affairs (Print)",null,null,null,"Signature",null,null,null,null,"Date"]

{"sheet":"Quality Points Calculator","index":4,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[9,8,9,9],[0,0,1,4],[21,11,21,12],[22,11,22,12]]}
["ICR/GPA CALCULATOR",null,null,null,null,null,"Student Name:"]
[null,null,null,null,null,null,"Student ID:"]
["SAP PROJECTION TOOL"]
["Grade","Course Credits","Grade Value","Grade Points","Credits",null,"Course Title",null,"Credits Attempted","Credits Earned","GPA","ICR","Grade Points"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,{"$f":"SUM(B5:B49)+SUM(I13:I25)+SUM(J13:J49)","v":0},{"$f":"SUM(E5:E49)+SUM(J13:J49)","v":0},{"$f":"SUM(D5:D49)/I7","v":{"$error":"#DIV/0!"}},{"$f":"J5/I5","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D5:D100)","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,"Credits Attempted (GPA)"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,{"$f":"SUM(B5:B49)","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,"Credits ","Nursing GPA"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,"Credit Amounts Go Here ",null,null,{"$f":"SUM(M13:M21)","v":0},{"$f":"SUM(O13:O21)/L10","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,"Retake/Withdraw","Transfer",null,"Grade","Course Credits","Grade Value","Grade Points","Credits","Courses"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table5[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]),\"\",Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]))","v":" "},null,"WBIS"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table5[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]),\"\",Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]))","v":" "},null,"PSYCH"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table5[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]),\"\",Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]))","v":" "},null,"NURS 200"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table5[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]),\"\",Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]))","v":" "},null,"SCI 1"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table5[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]),\"\",Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]))","v":" "},null,"SCI 2"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table5[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]),\"\",Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]))","v":" "},null,"SCI 3"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table5[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]),\"\",Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]))","v":" "},null,"SCI 4"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table5[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]),\"\",Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]))","v":" "},null,"USP/NE"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table5[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table5[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]),\"\",Table5[[#This Row],[Course Credits]]*Table5[[#This Row],[Grade Value]]))","v":" "},null,"USP/NE"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,"Quick Projection"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,"GPA Credits"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,"Grade Points"]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0},null,null,null,null,null,null,"GPA",{"$f":"(M5+M25)/(I7+M24)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]
[null,null,{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",VLOOKUP(Table4[[#This Row],[Grade]],Table2[#Data],2,FALSE))","v":" "},{"$f":"IF(Table4[[#This Row],[Course Credits]]<1,\" \",IF(ISNA(Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]),\"\",Table4[[#This Row],[Course Credits]]*Table4[[#This Row],[Grade Value]]))","v":" "},{"$f":"IF(Table4[[#This Row],[Grade Points]]<1, 0, Table4[[#This Row],[Course Credits]])","v":0}]

{"sheet":"Sheet1","index":5,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["Diploma ICR",null,null,null,"Diploma CGPA",null,null,null,"Degree ICR",null,null,null,"Degree CGPA"]
["Quarter","Action","Reason",null,"Quarter","Action","Reason",null,"Quarter","Action","Reason",null,"Quarter","Action","Reason"]
[1,"Academic Warning","ICR less than 33.33% after 1st Quarter",null,1,"Academic Warning","CGPA less than 1.0 after 1st Quarter",null,1,"Academic Warning"," ",null,1,"Academic Warning"," "]
[2,"Academic Warning","ICR less than 50% after 2nd Quarter",null,2,"Academic Warning","CGPA less than 1.5 after 2nd Quarter",null,2,"Academic Warning"," ",null,2,"Academic Warning"," "]
[3,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,3,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,3,"Academic Warning","ICR less than 33.33% after 3rd Quarter",null,3,"Academic Warning","CGPA less than 1.0 after 3rd Quarter"]
[4,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,4,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,4,"Academic Warning"," ",null,4,"Academic Warning"," "]
[5,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,5,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,5,"Academic Warning"," ",null,5,"Academic Warning"," "]
[6,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,6,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,6,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,6,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[7,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,7,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,7,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,7,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[8,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,8,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,8,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,8,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[9,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,9,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,9,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,9,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[10,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,10,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,10,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,10,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[11,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,11,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,11,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,11,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[12,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,12,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,12,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,12,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[13,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,13,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,13,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,13,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[14,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,14,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,14,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,14,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[15,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,15,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,15,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,15,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[16,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,16,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,16,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,16,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[17,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,17,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,17,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,17,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[18,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,18,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,18,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,18,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[19,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,19,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,19,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,19,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[20,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,20,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,20,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,20,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[21,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,21,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,21,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,21,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[22,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,22,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,22,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,22,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[23,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,23,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,23,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,23,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[24,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,24,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,24,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,24,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[25,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,25,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,25,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,25,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[26,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,26,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,26,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,26,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[27,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,27,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,27,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,27,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[28,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,28,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,28,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,28,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[29,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,29,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,29,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,29,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[30,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,30,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,30,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,30,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[31,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,31,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,31,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,31,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[32,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,32,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,32,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,32,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[33,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,33,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,33,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,33,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[34,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,34,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,34,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,34,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[35,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,35,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,35,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,35,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]
[36,"Academic Warning","ICR less than 66.67% after 3rd Quarter",null,36,"Academic Warning","CGPA less than 2.0 after 3rd Quarter",null,36,"Academic Warning","ICR less than 66.67% after 6th Quarter",null,36,"Academic Warning","CGPA less than 2.0 after 6th Quarter"]

{"sheet":"Grade Points","index":6,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Grade","Point Value"]
["A",4]
["A-",3.67]
["B+",3.33]
["B",3]
["B-",2.67]
["C+",2.33]
["C",2]
["C-",1.67]
["D+",1.33]
["D",1]
["D-",0.67]
["F",0]
["AB",3.5]
["BC",2.5]
["CD",1.5]

{"sheet":"Sheet2","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}