{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["InputOutput","InputOutput (2)","Weighting"],"read":"whole","date_system":"1900"}

{"sheet":"InputOutput","index":0,"n_rows":30,"n_cols":16,"rows_kept":30,"merged":[[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3]]}
[]
[]
[]
["Instructions for using the BBA Core GPA Calculator:"]
["A) Enter letter grades received. "]
["B) If you repeated a course using repeat forgive*, include the new (second) letter grade in the Repeat Forgive column. You must also enter the initial grade in the Grade Received column."]
["C) If you repeated a course using repeat credit*, include the new (second) letter grade in the Repeat Credit column. You must also enter the initial grade in the Grade Received column. "]
["D) Do not include grades received from courses taken outside of JMU as a transfer credit."]
["E) Once all grades have been included, press Enter."]
[]
["Course","Grade Received","Repeat Forgive* Grade Received","Repeat Credit* Grade Received","Withdrawn"]
["COB 191 - Business Analytics I, or MATH 220**",{"$nulls":4},{"$f":"VLOOKUP(B12,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(B12=0,0,F12)","v":0},null,{"$f":"VLOOKUP(C12,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(C12=0,0,I12)","v":0},{"$f":"VLOOKUP(D12,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(D12=0,0,K12)","v":0},{"$f":"IF(AND(C12=\"\",D12=\"\"),G12,IF(AND(C12=\"\",D12>0),((G12+L12)),IF(AND(C12>0,D12=\"\"),J12,((J12+L12)))))","v":0}]
["COB 202 - Interpersonal Skills",{"$nulls":4},{"$f":"VLOOKUP(B13,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C13,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D13,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["COB 204 - Computer Information Systems",{"$nulls":4},{"$f":"VLOOKUP(B14,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C14,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D14,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["COB 241 - Financial Accounting",{"$nulls":4},{"$f":"VLOOKUP(B15,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C15,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D15,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["COB 291 - Business Analytics II",{"$nulls":4},{"$f":"VLOOKUP(B16,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C16,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D16,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["ECON 200- Macroeconomics",{"$nulls":4},{"$f":"VLOOKUP(B17,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C17,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D17,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["ECON 201 - Microeconomics",{"$nulls":4},{"$f":"VLOOKUP(B18,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C18,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D18,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["COB 242 - Managerial Accounting",{"$nulls":4},{"$f":"VLOOKUP(B19,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C19,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D19,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0,null,null,"Does not count towards BBA Core GPA"]
["MATH 205 or 235 - (Introductory) Calculus",{"$nulls":4},{"$f":"VLOOKUP(B20,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C20,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D20,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
[{"$nulls":5},{"$f":"VLOOKUP(B21,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C21,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D21,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
[{"$nulls":5},{"$f":"VLOOKUP(B22,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(B22=0,0,F22)","v":0},null,{"$f":"VLOOKUP(C22,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(C22=0,0,I22)","v":0},{"$f":"VLOOKUP(D22,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(D22=0,0,K22)","v":0},{"$f":"IF(AND(C22=\"\",D22=\"\"),G22,IF(AND(C22=\"\",D22>0),((G22+L22)),IF(AND(C22>0,D22=\"\"),J22,((J22+L22)))))","v":0}]
[{"$nulls":6},{"$f":"COUNTA(B12:B18)","v":0},{"$nulls":4},{"$f":"COUNTA(D12:D18)","v":0},{"$f":"SUM(M12:M18)","v":0}]
[]
["BBA Core GPA:",{"$f":"IFERROR(M23/(G23+L23),0)","v":0}]
[]
["*All core classes are restricted to two attempts, which include a \"W\"."]
["* Repeat Forgive removes the first letter grade from your GPA calculation and adds the second grade, even if the second grade is lower.  Repeat Credit includes both letter grades in the GPA calculation.  "]
["**MATH 220, Elementary Statistics, may be taken in place of COB 191.  If both COB 191 and MATH 220 have been taken, the letter grade received in COB 191 will be used in computing the BBA Core GPA.  "]
["Created by Jessica Liss, Katherine Nguyen, Tori Kendall, and Tyler Zogg"]

{"sheet":"InputOutput (2)","index":1,"n_rows":30,"n_cols":16,"rows_kept":30,"merged":[[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3]]}
[]
[]
[]
["Instructions for using the BBA Core GPA Calculator:"]
["a) Enter letter grades received. "]
["b) If you repeated a course using an official university repeat forgive*, include the new (second) letter grade in the repeat forgive column.  "]
["c) If you repeated a course using repeat credit*, include the new (second) letter grade in the repeat credit column."]
["d) Do not include grades received from courses taken outside of JMU as a transfer credit."]
["e) Once all grades have been included, press Enter."]
[]
["Course","Grade Received","Repeat Forgive* Grade Received","Repeat Credit* Grade Received","Withdrawn"]
["COB 191 - Business Analytics I, or MATH 220**",{"$nulls":4},{"$f":"VLOOKUP(B12,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(B12=0,0,F12)","v":0},null,{"$f":"VLOOKUP(C12,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(C12=0,0,I12)","v":0},{"$f":"VLOOKUP(D12,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(D12=0,0,K12)","v":0},{"$f":"IF(AND(C12=\"\",D12=\"\"),G12,IF(AND(C12=\"\",D12>0),((G12+L12)),IF(AND(C12>0,D12=\"\"),J12,((J12+L12)))))","v":0}]
["COB 202 - Interpersonal Skills",{"$nulls":4},{"$f":"VLOOKUP(B13,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C13,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D13,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["COB 204 - Computer Information Systems",{"$nulls":4},{"$f":"VLOOKUP(B14,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C14,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D14,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["COB 241 - Financial Accounting",{"$nulls":4},{"$f":"VLOOKUP(B15,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C15,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D15,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["COB 291 - Business Analytics II",{"$nulls":4},{"$f":"VLOOKUP(B16,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C16,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D16,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["ECON 200- Macroeconomics",{"$nulls":4},{"$f":"VLOOKUP(B17,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C17,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D17,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["ECON 201 - Microeconomics",{"$nulls":4},{"$f":"VLOOKUP(B18,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C18,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D18,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
["COB 242 - Managerial Accounting",{"$nulls":4},{"$f":"VLOOKUP(B19,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C19,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D19,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0,null,null,"Does not count towards BBA Core GPA"]
["MATH 205 or 235 - (Introductory) Calculus",{"$nulls":4},{"$f":"VLOOKUP(B20,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C20,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D20,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
[{"$nulls":5},{"$f":"VLOOKUP(B21,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,null,{"$f":"VLOOKUP(C21,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,{"$f":"VLOOKUP(D21,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},0,0]
[{"$nulls":5},{"$f":"VLOOKUP(B22,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(B22=0,0,F22)","v":0},null,{"$f":"VLOOKUP(C22,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(C22=0,0,I22)","v":0},{"$f":"VLOOKUP(D22,Weighting!$A$1:$B$12,2)","v":{"$error":"#N/A"}},{"$f":"IF(D22=0,0,K22)","v":0},{"$f":"IF(AND(C22=\"\",D22=\"\"),G22,IF(AND(C22=\"\",D22>0),((G22+L22)),IF(AND(C22>0,D22=\"\"),J22,((J22+L22)))))","v":0}]
[{"$nulls":6},{"$f":"COUNTA(B12:B18)","v":0},{"$nulls":4},{"$f":"COUNTA(D12:D18)","v":0},{"$f":"SUM(M12:M18)","v":0}]
[]
["BBA Core GPA:",{"$f":"IFERROR(M23/(G23+L23),0)","v":0}]
[]
["*All core classes are restricted to two attempts, which include a \"W\"."]
["* Repeat Forgive removes the first letter grade from your GPA calculation and adds the second grade, even if the second grade is lower.  Repeat Credit averages both letter grades.  "]
["**MATH 220, Elementary Statistics, may be taken in place of COB 191.  If both COB 191 and MATH 220 have been taken, the letter grade received in COB 191 will be used in computing the BBA Core GPA.  "]
["Created by Jessica Liss, Katherine Nguyen, Tori Kendall, and Tyler Zogg"]

{"sheet":"Weighting","index":2,"n_rows":12,"n_cols":2,"rows_kept":12,"hidden":true}
["A",4]
["A-",3.7]
["B",3]
["B-",2.7]
["B+",3.3]
["C",2]
["C-",1.7]
["C+",2.3]
["D",1]
["D-",0.7]
["D+",1.3]
["F",0]