{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["INSTRUCTIONS","SEMESTER TRACKER","SINGLE COURSE","CUMULATIVE GPA","METRICS","TOOLS","NOTES"],"not_rendered":{"charts":2,"images":15,"macros":1,"external_links":0,"defined_names":5,"comments":2,"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":"INSTRUCTIONS","index":0,"n_rows":293,"n_cols":15,"rows_kept":293,"cut":false,"hidden":false,"merged":[[9,14,11,17],[29,1,31,1],[7,9,7,10],[9,9,9,10],[11,9,11,10],[6,1,12,2],[7,4,7,6],[9,4,9,5],[11,4,11,5]]}
[]
[]
[null,"GRADE CALCULATOR v3.0",null,null,null,null,"Updated January 2014"]
[null,"INSTRUCTIONS"]
[]
[]
[null,"QUICK \nNAVIGATION\n( click link, then \nscroll if necessary )"]
[null,null,null,null,{"$f":"HYPERLINK(\"[GradeCalcV3.xlsm]INSTRUCTIONS!A16\",\"GENERAL INFORMATION\")","v":"GENERAL INFORMATION"},null,null,null,null,{"$f":"HYPERLINK(\"[GradeCalcV3.xlsm]INSTRUCTIONS!A53\",\"SEMESTER TRACKER\")","v":"SEMESTER TRACKER"},null,null,null,"GRADE WORKBOOK OWNER:"]
[]
[null,null,null,null,{"$f":"HYPERLINK(\"[GradeCalcV3.xlsm]INSTRUCTIONS!A207\",\"FAQs\")","v":"FAQs"},null,null,null,null,{"$f":"HYPERLINK(\"[GradeCalcV3.xlsm]INSTRUCTIONS!A107\",\"SINGLE COURSE\")","v":"SINGLE COURSE"},null,null,null,null,"< type name >"]
[]
[null,null,null,null,{"$f":"HYPERLINK(\"[GradeCalcV3.xlsm]INSTRUCTIONS!A270\",\"LEGAL\")","v":"LEGAL"},null,null,null,null,{"$f":"HYPERLINK(\"[GradeCalcV3.xlsm]INSTRUCTIONS!A152\",\"CUMULATIVE GPA\")","v":"CUMULATIVE GPA"}]
[]
[]
[]
[null,"GENERAL INFORMATION"]
[]
[]
[null,"Congratulations on making the decision to use the most efficient and effective grade calculating tool for Ryerson Students."]
[null,"If there are any questions regarding this application, the developer (Aaron Mohammed) can be contacted"]
[null,"at aaron.8903@live.com. "]
[]
[null,"Similarly, if a bug/issue is found, please send a brief report to the address provided (include system details by clicking \"SYSTEM INFORMATION\" button at top)."]
[]
[null,"Enjoy, and best of luck in your studies."]
[]
[null,"NOTE: Be sure macros are enabled - a warning message may be displayed when opening this application."]
[null,null,"This application does not contain any malicious code or virus."]
[]
[null,"TIPS:","● Leave any field you do not need/want blank."]
[null,null,"● The \"Control Panel\" includes tab-specifc buttons; always located at top (where applicable)."]
[null,null,"● Save often to prevent lost data."]
[]
[]
[null,"Various calculators and tools exist on separate tabs, as shown in the below image:"]
[]
[]
[]
[null,null,"Navigate the difference areas of the application by selection of a tab at the bottom."]
[]
[null,"SEMESTER TRACKER = calculate marks/GPAs of up to 7 courses for a semester."]
[null,"SINGLE COURSE = a standalone course calculator that allows for mark calculation."]
[null,"CUMULATIVE GPA = keep track of your entire University career as you progress. Type all your courses (by course year) and select grade points to see your CGPA fluctuate."]
[null,"METRICS = get a glance of some key statistics/metrics of your University career."]
[null,"TOOLS = general tools relating to application; save a snapshot (i.e. certain calculations), calculate a percentage, or target a grade for a course."]
[null,"NOTES = add simple notes to current courses."]
[]
[null,"For information on Ryerson's GPA determination, please see: http://www.ryerson.ca/currentstudents/essr/gpa/"]
[]
[]
[]
[]
[null,"SEMESTER TRACKER"]
[]
[]
[null,"This calculator keeps track of your current semester; you may fill information as it is received/completed."]
[]
[null,"See below for a procedural graphic:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"To add extra rows for items (i.e. tests, quizzes, labs, etc.), click the \"ADD ITEM (all courses)\" button in the Control Panel. This will add a new item for all courses (must be done to preserve formulas)."]
[]
[]
[]
[]
[]
[]
[]
[null,"SINGLE COURSE"]
[]
[]
[null,"This calculator works similarly to the SEMESTER TRACKER, however, is an isolated course calculator. This means no data is directly linked to this course (although "]
[null,"can target a grade using the \"GRADE TARGETER\" tool in the TOOLS tab if necessary). To be used for quick calculations outside of your regular semester."]
[]
[null,"See below for a procedural graphic:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"To add extra rows for items (i.e. tests, quizzes, labs, etc.), click the \"ADD ITEM\" button in the Control Panel. Note that rows are added before the last item to preserve formulas."]
[]
[]
[]
[]
[]
[]
[]
[null,"CUMULATIVE GPA "]
[]
[]
[null,"This calculator helps keep track of all completed courses throughout your University career. Once a semester is completed, and grades are released, move the grades"]
[null,"to this sheet by placing the course names and corresponding grade points."]
[]
[null,"Information from this calculator performs insightful metrics (in the METRICS tab)."]
[]
[null,"NOTE: There is a pre-determined size of a maximum of 15 courses per year. Most programs revolve around a 4-year schedule (even co-op programs), thus if the course is a Year 2 course, place in Year 2."]
[null,null,"However, you may re-arrange courses based on time if you wish (i.e. if a Year 3 course was taken in Year 1, place in Year 1 Courses)."]
[]
[null,"See below for a procedural graphic:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"From Ryerson website:"]
[null,"A cumulative grade point average is calculated as an indicator of overall academic performance in a program and is used as a criterion for graduation requirements, "]
[null,"for honours graduation or other academic distinctions, and for determining academic standing during study in a program."]
[]
[null,"By factoring your current semester into your CGPA, you can make the best decisions to have the best-possible-outcome of your University career."]
[]
[]
[null,"FREQUENTLY ASKED QUESTIONS (FAQs)"]
[]
[]
[null,1,"Q. How does the application determine my Grade Points for a course?"]
[null,null,"A. By using the Ryerson GPA calculations, shown below:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"More information can be found at: http://www.ryerson.ca/currentstudents/essr/gpa/",null,null,null,null,null,null,null,null,null,"NOTE: Grade Point conversions have been updated in the Grade Calculator V3 as of January 2014."]
[]
[]
[]
[null,2,"Q. Does this application have a malware, spyware, or virus?"]
[null,null,"A. No, it has been built ground-up and no malicious code or viruses have been inserted."]
[]
[]
[]
[null,3,"Q. How does the application round marks and Grade Points?"]
[null,null,"A. Calculated values, such as marks, are rounded to two (2) decimal places. GPAs, and CGPAs, are rounded to three (3) decimals places as per Ryerson standards."]
[null,null,null,"Note that GPAs may have minor variances due to rounding practices for this application versus the institution."]
[null,null,null,"Moreover, Grade Points are found using rounded final marks (e.g: 79.8% = 80% = 3.67 Grade Points). Some professors may not round up or down marks."]
[]
[]
[]
[null,4,"Q. I have a question on the application, who can I contact?"]
[null,null,"A. The developer, Aaron Mohammed, can be contacted at aaron.8903@live.com."]
[]
[]
[]
[null,5,"Q. In the SEMESTER TRACKER, the \"Average Mark\" and \"GPA\" do not match. Why?"]
[null,null,"A. Because they are not related. You should be most concerned with the calculated GPA, although the percentage is also given to show an alternate perspective."]
[]
[]
[]
[null,6,"Q. Should I know the course faculty for my courses? Does it matter?"]
[null,null,"A. All course faculties at Ryerson University, as of the January 2014 calculator update, use a single GPA scale/system. Thus, it is irrelevant for calculations."]
[null,null,null,"Previous versions of this calculator requested faculty information; it is no longer necessary."]
[]
[]
[]
[null,7,"Q. Can I modify formulas or other parts of this application?"]
[null,null,"A. To minimize errors/issues, no you cannot modify this application other than inputting course information (as-intended)."]
[null,null,null,"If you found a bug, or have a requested feature, please notify the developer."]
[]
[]
[]
[]
[null,"LEGAL"]
[]
[]
[null,"[PART I]:"]
[null,"Grade Calc V3 is copyright (©) to its owner, "]
[null,"Aaron Mohammed, from 2012 and onward. Any modications,"]
[null,"to code or sheet formulas, is strictly prohibited. Any item of this"]
[null,"application cannot be reproduced, copied, or modified without"]
[null,"proper authority from the owner."]
[]
[null,"You may freely share, send, and copy the \"entire\" application "]
[null,"file (\"GradeCalcV3.xlsm\") without penalty."]
[]
[null,"[PART II]:"]
[null,"The developer is not responsible for any negative effects"]
[null,"that may arise with the use of the application. It is intended"]
[null,"as a tool to assist in the calculation of marks, and should an "]
[null,"error occur, whether in code or otherwise, the developer has no"]
[null,"legal association."]
[]
[null,"[PART III]:"]
[null,"By using this application, you have agreed to the above [PART I/II]"]
[null,"and will adhere to any rules or conditions given."]
[null," "]

{"sheet":"SEMESTER TRACKER","index":1,"n_rows":53,"n_cols":28,"rows_kept":53,"cut":false,"hidden":false,"merged":[[14,9,14,11],[17,9,17,11],[33,9,35,9],[14,5,14,7],[17,5,17,7],[33,5,35,5],[15,9,15,11],[16,9,16,11],[16,5,16,7],[14,1,14,3],[41,1,44,2],[41,3,42,5],[43,3,44,5],[15,1,15,3],[15,5,15,7],[41,6,42,6],[43,6,44,6],[17,1,17,3],[33,1,35,1],[16,1,16,3],[14,13,14,15],[17,13,17,15],[33,13,35,13],[14,17,14,19],[17,17,17,19],[33,17,35,17],[15,13,15,15],[15,17,15,19],[16,17,16,19],[16,13,16,15],[14,21,14,23],[17,21,17,23],[33,21,35,21],[14,25,14,27],[17,25,17,27],[33,25,35,25],[15,21,15,23],[15,25,15,27],[16,25,16,27],[16,21,16,23]]}
[]
[]
[null,"GRADE CALCULATOR v3.0"]
[null,"SEMESTER TRACKER"]
[]
[null,"FACULTY","TED ROGERS SCHOOL OF MANAGEMENT"]
[null,null,"FACULTY OF ARTS",null,null,null,"CourseStatus","ENABLED",null,"DATE","Wednesday, January 01, 2014"]
[null,null,"FACULTY OF COMMUNICATION AND DESIGN",null,null,null,null,"DISABLED"]
[null,null,"FACULTY OF COMMUNITY SERVICES"]
[null,null,"FACULTY OF ENGINEERING AND ARCHITECTURAL SCIENCE"]
[null,null,"FACULTY OF SCIENCE"]
[]
[null,"INSERT ALL SEMESTER COURSE INFORMATION BELOW:"]
[]
[null,"(1)",null,null,null,"(2)",null,null,null,"(3)",null,null,null,"(4)",null,null,null,"(5)",null,null,null,"(6)",null,null,null,"(7)"]
[null,"ENABLED",null,null,null,"ENABLED",null,null,null,"DISABLED",null,null,null,"DISABLED",null,null,null,"DISABLED",null,null,null,"DISABLED",null,null,null,"DISABLED"]
[]
[null,"EXG 101",null,null,null,"EXG 102"]
[null,"ITEM","MARK (%)","WEIGHT (%)",null,"ITEM","MARK (%)","WEIGHT (%)",null,"ITEM","MARK (%)","WEIGHT (%)",null,"ITEM","MARK (%)","WEIGHT (%)",null,"ITEM","MARK (%)","WEIGHT (%)",null,"ITEM","MARK (%)","WEIGHT (%)",null,"ITEM","MARK (%)","WEIGHT (%)"]
[null,"Test #1",80,15,null,"Lab 1",80,10]
[null,"Quiz A",100,2.5,null,"Lab 2",68,10]
[null,"Quiz B",95,2.5,null,"Test #1",100,40]
[null,"Test #2",65,30]
[null,"Lab",87.5,10]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TOTAL COMPLETED (%)",{"$f":"SUM(D20:D30)","v":60},null,null,"TOTAL COMPLETED (%)",{"$f":"SUM(H20:H30)","v":60},null,null,"TOTAL COMPLETED (%)",{"$f":"SUM(L20:L30)","v":0},null,null,"TOTAL COMPLETED (%)",{"$f":"SUM(P20:P30)","v":0},null,null,"TOTAL COMPLETED (%)",{"$f":"SUM(T20:T30)","v":0},null,null,"TOTAL COMPLETED (%)",{"$f":"SUM(X20:X30)","v":0},null,null,"TOTAL COMPLETED (%)",{"$f":"SUM(AB20:AB30)","v":0}]
[]
[null,"COURSE SUMMARY:","Average Mark (%):",{"$f":"ROUND((SUMPRODUCT(C20:C30,D20:D30)/SUM(D20:D30)),2)","v":75.209999999999994},null,"COURSE SUMMARY:","Average Mark (%):",{"$f":"ROUND((SUMPRODUCT(G20:G30,H20:H30)/SUM(H20:H30)),2)","v":91.33},null,"COURSE SUMMARY:","Average Mark (%):",{"$f":"ROUND((SUMPRODUCT(K20:K30,L20:L30)/SUM(L20:L30)),2)","v":{"$error":"#DIV/0!"}},null,"COURSE SUMMARY:","Average Mark (%):",{"$f":"ROUND((SUMPRODUCT(O20:O30,P20:P30)/SUM(P20:P30)),2)","v":{"$error":"#DIV/0!"}},null,"COURSE SUMMARY:","Average Mark (%):",{"$f":"ROUND((SUMPRODUCT(S20:S30,T20:T30)/SUM(T20:T30)),2)","v":{"$error":"#DIV/0!"}},null,"COURSE SUMMARY:","Average Mark (%):",{"$f":"ROUND((SUMPRODUCT(W20:W30,X20:X30)/SUM(X20:X30)),2)","v":{"$error":"#DIV/0!"}},null,"COURSE SUMMARY:","Average Mark (%):",{"$f":"ROUND((SUMPRODUCT(AA20:AA30,AB20:AB30)/SUM(AB20:AB30)),2)","v":{"$error":"#DIV/0!"}}]
[null,null,"Grade Points:",{"$f":"IF(ROUND(D34,0)<=49,0,IF(ROUND(D34,0)<=52,0.67,IF(ROUND(D34,0)<=56,1,IF(ROUND(D34,0)<=59,1.33,IF(ROUND(D34,0)<=62,1.67,IF(ROUND(D34,0)<=66,2,IF(ROUND(D34,0)<=69,2.33,IF(ROUND(D34,0)<=72,2.67,IF(ROUND(D34,0)<=76,3,IF(ROUND(D34,0)<=79,3.33,IF(ROUND(D34,0)<=84,3.67,IF(ROUND(D34,0)<=89,4,IF(ROUND(D34,0)<=100,4.33,IF(ROUND(D34,0)>=101,4.33))))))))))))))","v":3},null,null,"Grade Points:",{"$f":"IF(ROUND(H34,0)<=49,0,IF(ROUND(H34,0)<=52,0.67,IF(ROUND(H34,0)<=56,1,IF(ROUND(H34,0)<=59,1.33,IF(ROUND(H34,0)<=62,1.67,IF(ROUND(H34,0)<=66,2,IF(ROUND(H34,0)<=69,2.33,IF(ROUND(H34,0)<=72,2.67,IF(ROUND(H34,0)<=76,3,IF(ROUND(H34,0)<=79,3.33,IF(ROUND(H34,0)<=84,3.67,IF(ROUND(H34,0)<=89,4,IF(ROUND(H34,0)<=100,4.33,IF(ROUND(H34,0)>=101,4.33))))))))))))))","v":4.33},null,null,"Grade Points:",{"$f":"IF(ROUND(L34,0)<=49,0,IF(ROUND(L34,0)<=52,0.67,IF(ROUND(L34,0)<=56,1,IF(ROUND(L34,0)<=59,1.33,IF(ROUND(L34,0)<=62,1.67,IF(ROUND(L34,0)<=66,2,IF(ROUND(L34,0)<=69,2.33,IF(ROUND(L34,0)<=72,2.67,IF(ROUND(L34,0)<=76,3,IF(ROUND(L34,0)<=79,3.33,IF(ROUND(L34,0)<=84,3.67,IF(ROUND(L34,0)<=89,4,IF(ROUND(L34,0)<=100,4.33,IF(ROUND(L34,0)>=101,4.33))))))))))))))","v":{"$error":"#DIV/0!"}},null,null,"Grade Points:",{"$f":"IF(ROUND(P34,0)<=49,0,IF(ROUND(P34,0)<=52,0.67,IF(ROUND(P34,0)<=56,1,IF(ROUND(P34,0)<=59,1.33,IF(ROUND(P34,0)<=62,1.67,IF(ROUND(P34,0)<=66,2,IF(ROUND(P34,0)<=69,2.33,IF(ROUND(P34,0)<=72,2.67,IF(ROUND(P34,0)<=76,3,IF(ROUND(P34,0)<=79,3.33,IF(ROUND(P34,0)<=84,3.67,IF(ROUND(P34,0)<=89,4,IF(ROUND(P34,0)<=100,4.33,IF(ROUND(P34,0)>=101,4.33))))))))))))))","v":{"$error":"#DIV/0!"}},null,null,"Grade Points:",{"$f":"IF(ROUND(T34,0)<=49,0,IF(ROUND(T34,0)<=52,0.67,IF(ROUND(T34,0)<=56,1,IF(ROUND(T34,0)<=59,1.33,IF(ROUND(T34,0)<=62,1.67,IF(ROUND(T34,0)<=66,2,IF(ROUND(T34,0)<=69,2.33,IF(ROUND(T34,0)<=72,2.67,IF(ROUND(T34,0)<=76,3,IF(ROUND(T34,0)<=79,3.33,IF(ROUND(T34,0)<=84,3.67,IF(ROUND(T34,0)<=89,4,IF(ROUND(T34,0)<=100,4.33,IF(ROUND(T34,0)>=101,4.33))))))))))))))","v":{"$error":"#DIV/0!"}},null,null,"Grade Points:",{"$f":"IF(ROUND(X34,0)<=49,0,IF(ROUND(X34,0)<=52,0.67,IF(ROUND(X34,0)<=56,1,IF(ROUND(X34,0)<=59,1.33,IF(ROUND(X34,0)<=62,1.67,IF(ROUND(X34,0)<=66,2,IF(ROUND(X34,0)<=69,2.33,IF(ROUND(X34,0)<=72,2.67,IF(ROUND(X34,0)<=76,3,IF(ROUND(X34,0)<=79,3.33,IF(ROUND(X34,0)<=84,3.67,IF(ROUND(X34,0)<=89,4,IF(ROUND(X34,0)<=100,4.33,IF(ROUND(X34,0)>=101,4.33))))))))))))))","v":{"$error":"#DIV/0!"}},null,null,"Grade Points:",{"$f":"IF(ROUND(AB34,0)<=49,0,IF(ROUND(AB34,0)<=52,0.67,IF(ROUND(AB34,0)<=56,1,IF(ROUND(AB34,0)<=59,1.33,IF(ROUND(AB34,0)<=62,1.67,IF(ROUND(AB34,0)<=66,2,IF(ROUND(AB34,0)<=69,2.33,IF(ROUND(AB34,0)<=72,2.67,IF(ROUND(AB34,0)<=76,3,IF(ROUND(AB34,0)<=79,3.33,IF(ROUND(AB34,0)<=84,3.67,IF(ROUND(AB34,0)<=89,4,IF(ROUND(AB34,0)<=100,4.33,IF(ROUND(AB34,0)>=101,4.33))))))))))))))","v":{"$error":"#DIV/0!"}}]
[null,null,"Letter Grade:",{"$f":"IF(D35 = 0, \"F\", IF(D35 = 0.67, \"D-\", IF(D35 = 1, \"D\", IF(D35 = 1.33, \"D+\", IF(D35 = 1.67, \"C-\", IF(D35 = 2, \"C\", IF(D35 = 2.33, \"C+\", IF(D35 = 2.67, \"B-\", IF(D35 = 3, \"B\", IF(D35 = 3.33, \"B+\", IF(D35 = 3.67, \"A-\", IF(D35 = 4, \"A\", IF(D35 = 4.33, \"A+\")))))))))))))","v":"B"},null,null,"Letter Grade:",{"$f":"IF(H35 = 0, \"F\", IF(H35 = 0.67, \"D-\", IF(H35 = 1, \"D\", IF(H35 = 1.33, \"D+\", IF(H35 = 1.67, \"C-\", IF(H35 = 2, \"C\", IF(H35 = 2.33, \"C+\", IF(H35 = 2.67, \"B-\", IF(H35 = 3, \"B\", IF(H35 = 3.33, \"B+\", IF(H35 = 3.67, \"A-\", IF(H35 = 4, \"A\", IF(H35 = 4.33, \"A+\")))))))))))))","v":"A+"},null,null,"Letter Grade:",{"$f":"IF(L35 = 0, \"F\", IF(L35 = 0.67, \"D-\", IF(L35 = 1, \"D\", IF(L35 = 1.33, \"D+\", IF(L35 = 1.67, \"C-\", IF(L35 = 2, \"C\", IF(L35 = 2.33, \"C+\", IF(L35 = 2.67, \"B-\", IF(L35 = 3, \"B\", IF(L35 = 3.33, \"B+\", IF(L35 = 3.67, \"A-\", IF(L35 = 4, \"A\", IF(L35 = 4.33, \"A+\")))))))))))))","v":{"$error":"#DIV/0!"}},null,null,"Letter Grade:",{"$f":"IF(P35 = 0, \"F\", IF(P35 = 0.67, \"D-\", IF(P35 = 1, \"D\", IF(P35 = 1.33, \"D+\", IF(P35 = 1.67, \"C-\", IF(P35 = 2, \"C\", IF(P35 = 2.33, \"C+\", IF(P35 = 2.67, \"B-\", IF(P35 = 3, \"B\", IF(P35 = 3.33, \"B+\", IF(P35 = 3.67, \"A-\", IF(P35 = 4, \"A\", IF(P35 = 4.33, \"A+\")))))))))))))","v":{"$error":"#DIV/0!"}},null,null,"Letter Grade:",{"$f":"IF(T35 = 0, \"F\", IF(T35 = 0.67, \"D-\", IF(T35 = 1, \"D\", IF(T35 = 1.33, \"D+\", IF(T35 = 1.67, \"C-\", IF(T35 = 2, \"C\", IF(T35 = 2.33, \"C+\", IF(T35 = 2.67, \"B-\", IF(T35 = 3, \"B\", IF(T35 = 3.33, \"B+\", IF(T35 = 3.67, \"A-\", IF(T35 = 4, \"A\", IF(T35 = 4.33, \"A+\")))))))))))))","v":{"$error":"#DIV/0!"}},null,null,"Letter Grade:",{"$f":"IF(X35 = 0, \"F\", IF(X35 = 0.67, \"D-\", IF(X35 = 1, \"D\", IF(X35 = 1.33, \"D+\", IF(X35 = 1.67, \"C-\", IF(X35 = 2, \"C\", IF(X35 = 2.33, \"C+\", IF(X35 = 2.67, \"B-\", IF(X35 = 3, \"B\", IF(X35 = 3.33, \"B+\", IF(X35 = 3.67, \"A-\", IF(X35 = 4, \"A\", IF(X35 = 4.33, \"A+\")))))))))))))","v":{"$error":"#DIV/0!"}},null,null,"Letter Grade:",{"$f":"IF(AB35 = 0, \"F\", IF(AB35 = 0.67, \"D-\", IF(AB35 = 1, \"D\", IF(AB35 = 1.33, \"D+\", IF(AB35 = 1.67, \"C-\", IF(AB35 = 2, \"C\", IF(AB35 = 2.33, \"C+\", IF(AB35 = 2.67, \"B-\", IF(AB35 = 3, \"B\", IF(AB35 = 3.33, \"B+\", IF(AB35 = 3.67, \"A-\", IF(AB35 = 4, \"A\", IF(AB35 = 4.33, \"A+\")))))))))))))","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[null,"SEMESTER SUMMARY",null,"AVERAGE MARK:",null,null,{"$f":"ROUND(SUM(IF(B16=\"ENABLED\", D34), IF(F16=\"ENABLED\", H34), IF(J16=\"ENABLED\", L34), IF(N16=\"ENABLED\", P34), IF(R16=\"ENABLED\", T34), IF(V16=\"ENABLED\", X34), IF(Z16=\"ENABLED\", AB34))/COUNTIF(B16:AB16, \"ENABLED\"), 2)&\"%\"","v":"83.27%"}]
[]
[null,null,null,"GRADE POINT AVERAGE (GPA):",null,null,{"$f":"ROUND(SUM(IF(B16=\"ENABLED\", D35), IF(F16=\"ENABLED\", H35), IF(J16=\"ENABLED\", L35), IF(N16=\"ENABLED\", P35), IF(R16=\"ENABLED\", T35), IF(V16=\"ENABLED\", X35), IF(Z16=\"ENABLED\", AB35))/COUNTIF(B16:AB16, \"ENABLED\"), 3)","v":3.665}]
[]
[]
[]
[]
[]
[]
[null,null," COURSE STATISTICS"]
[null,null,"Number of Courses Enrolled:",{"$f":"COUNTA(B18:AB18)","v":2},"--","Checks courses for any inputted names."]
[null,null,"Number of Courses \"ENABLED\":",{"$f":"COUNTIF(B16:AB16, \"ENABLED\")","v":2},"--","Checks courses set to \"ENABLED\" status."]

{"sheet":"SINGLE COURSE","index":2,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,1,34,1],[16,1,16,3],[14,1,14,3]]}
[]
[]
[null,"GRADE CALCULATOR v3.0"]
[null,"SINGLE COURSE"]
[]
[null,"FACULTY","TED ROGERS SCHOOL OF MANAGEMENT"]
[null,null,"FACULTY OF ARTS"]
[null,null,"FACULTY OF COMMUNICATION AND DESIGN"]
[null,null,"FACULTY OF COMMUNITY SERVICES"]
[null,null,"FACULTY OF ENGINEERING AND ARCHITECTURAL SCIENCE"]
[null,null,"FACULTY OF SCIENCE"]
[]
[null,"INSERT COURSE INFORMATION BELOW:"]
[]
[null,"SINGLE COURSE"]
[]
[null,"SAM 100"]
[null,"ITEM","MARK (%)","WEIGHT (%)"]
[null,"Practice Test",97,0]
[null,"Test #1",77,30]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TOTAL COMPLETED (%)",{"$f":"SUM(D19:D30)","v":30}]
[]
[null,"COURSE SUMMARY:","Average Mark (%):",{"$f":"ROUND((SUMPRODUCT(C19:C30,D19:D30)/SUM(D19:D30)),2)","v":77}]
[null,null,"Grade Points:",{"$f":"IF(ROUND(D33,0)<=49,0,IF(ROUND(D33,0)<=52,0.67,IF(ROUND(D33,0)<=56,1,IF(ROUND(D33,0)<=59,1.33,IF(ROUND(D33,0)<=62,1.67,IF(ROUND(D33,0)<=66,2,IF(ROUND(D33,0)<=69,2.33,IF(ROUND(D33,0)<=72,2.67,IF(ROUND(D33,0)<=76,3,IF(ROUND(D33,0)<=79,3.33,IF(ROUND(D33,0)<=84,3.67,IF(ROUND(D33,0)<=89,4,IF(ROUND(D33,0)<=100,4.33,IF(ROUND(D33,0)>=101,4.33))))))))))))))","v":3.33}]
[null,null,"Letter Grade:",{"$f":"IF(D34 = 0, \"F\", IF(D34 = 0.67, \"D-\", IF(D34 = 1, \"D\", IF(D34 = 1.33, \"D+\", IF(D34 = 1.67, \"C-\", IF(D34 = 2, \"C\", IF(D34 = 2.33, \"C+\", IF(D34 = 2.67, \"B-\", IF(D34 = 3, \"B\", IF(D34 = 3.33, \"B+\", IF(D34 = 3.67, \"A-\", IF(D34 = 4, \"A\", IF(D34 = 4.33, \"A+\")))))))))))))","v":"B+"}]

{"sheet":"CUMULATIVE GPA","index":3,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[14,5,14,7],[14,9,14,11],[14,13,14,15],[37,1,40,2],[37,3,40,3],[14,1,14,3],[37,5,40,6],[37,7,40,7]]}
[]
[]
[null,"GRADE CALCULATOR v3.0"]
[null,"CUMULATIVE GPA"]
[]
[null,"GPAs",4.33,4,3.67,3.33,3,2.67,2.33,2,1.67,1.33,1,0.67,0]
[]
[]
[]
[]
[]
[]
[null,"INSERT CUMULATIVE GPA (CGPA) INFORMATION BELOW:"]
[]
[null,"YEAR 1 COURSES",null,null,null,"YEAR 2 COURSES",null,null,null,"YEAR 3 COURSES",null,null,null,"YEAR 4 COURSES"]
[null,null,"COURSE CODE","GRADE POINTS",null,null,"COURSE CODE","GRADE POINTS",null,null,"COURSE CODE","GRADE POINTS",null,null,"COURSE CODE","GRADE POINTS"]
[null,1,"EXG 101",3.67,"`",1,null,null,null,1,null,null,"`",1]
[null,2,"EXG 102",3.33,null,2,null,null,null,2,null,null,null,2]
[null,3,"EXG 103",4.33,null,3,null,null,null,3,null,null,null,3]
[null,4,"EXG 104",4,null,4,null,null,null,4,null,null,null,4]
[null,5,"EXG 105",3,null,5,null,null,null,5,null,null,null,5]
[null,6,"EXG 106",2.67,null,6,null,null,null,6,null,null,null,6]
[null,7,"EXG 107",4,null,7,null,null,null,7,null,null,null,7]
[null,8,"EXG 108",3,null,8,null,null,null,8,null,null,null,8]
[null,9,"EXG 109",4,null,9,null,null,null,9,null,null,null,9]
[null,10,"EXG 110",3.33,null,10,null,null,null,10,null,null,null,10]
[null,11,null,null,null,11,null,null,null,11,null,null,null,11]
[null,12,null,null,null,12,null,null,null,12,null,null,null,12]
[null,13,null,null,null,13,null,null,null,13,null,null,null,13]
[null,14,null,null,null,14,null,null,null,14,null,null,null,14]
[null,15,null,null,null,15,null,null,null,15,null,null,null,15]
[]
[null,null,"GRADE POINT AVERAGE:",{"$f":"IF(COUNTA(D17:D31)<>0, ROUND(SUM(D17:D31)/COUNTA(D17:D31), 3), \"\")","v":3.5329999999999999},null,null,"GRADE POINT AVERAGE:",{"$f":"IF(COUNTA(H17:H31)<>0,ROUND(SUM(H17:H31)/COUNTA(H17:H31),3),\"\")","v":""},null,null,"GRADE POINT AVERAGE:",{"$f":"IF(COUNTA(L17:L31)<>0, ROUND(SUM(L17:L31)/COUNTA(L17:L31),3), \"\")","v":""},null,null,"GRADE POINT AVERAGE:",{"$f":"IF(COUNTA(P17:P31)<>0, ROUND(SUM(P17:P31)/COUNTA(P17:P31),3), \"\")","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(AND(H38>=1,H38<=1.66), AND(D38>=1,D38<=1.66)), \"CGPA Within Probationary Range (1.00 - 1.66) Detected\", \"\"), \"\")","v":""}]
[null,"CUMULATIVE GPA",null,{"$f":"ROUND((SUM(D17:D31, H17:H31, L17:L31, P17:P31))/COUNTA(D17:D31, H17:H31, L17:L31, P17:P31),3)","v":3.5329999999999999},null,"CUMULATIVE GPA\n(includes current semester) *",null,{"$f":"ROUND((SUM(D17:D31, H17:H31, L17:L31, P17:P31, IF('SEMESTER TRACKER'!B16=\"ENABLED\", 'SEMESTER TRACKER'!D35, 0), IF('SEMESTER TRACKER'!F16=\"ENABLED\", 'SEMESTER TRACKER'!H35, 0), IF('SEMESTER TRACKER'!J16=\"ENABLED\", 'SEMESTER TRACKER'!L35, 0), IF('SEMESTER TRACKER'!N16=\"ENABLED\", 'SEMESTER TRACKER'!P35, 0), IF('SEMESTER TRACKER'!R16=\"ENABLED\", 'SEMESTER TRACKER'!T35, 0), IF('SEMESTER TRACKER'!V16=\"ENABLED\", 'SEMESTER TRACKER'!X35, 0), IF('SEMESTER TRACKER'!Z16=\"ENABLED\", 'SEMESTER TRACKER'!AB35, 0)))/SUM(COUNTA(D17:D31, H17:H31, L17:L31, P17:P31), COUNTIF('SEMESTER TRACKER'!B16:AB16, \"ENABLED\")),3)","v":3.5550000000000002},null,null,{"$f":"IFERROR(IF(OR(AND(H38>=1,H38<=1.66), AND(D38>=1,D38<=1.66)), \"Please consult with your program office.\", \"\"), \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(H38<1, D38<1), \"CGPA Below 1.00 Detected\", \"\"), \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(OR(H38<1, D38<1), \"Please check your academic standing on RAMSS and consult your program office.\", \"\"), \"\")","v":""}]
[]
[null,null,null,null,null,null,"* any enabled courses are included"]

{"sheet":"METRICS","index":4,"n_rows":61,"n_cols":5,"rows_kept":61,"cut":false,"hidden":false,"merged":[[6,1,12,2],[7,4,7,6],[11,4,11,6],[9,4,9,6]]}
[]
[]
[null,"GRADE CALCULATOR v3.0"]
[null,"METRICS"]
[]
[]
[null,"QUICK \nNAVIGATION\n( click link, then \nscroll if necessary )"]
[null,null,null,null,{"$f":"HYPERLINK(\"[GradeCalcV3.xlsm]METRICS!A19\",\"YEARLY GPA TREND\")","v":"YEARLY GPA TREND"}]
[]
[null,null,null,null,{"$f":"HYPERLINK(\"[GradeCalcV3.xlsm]METRICS!A44\",\"DISTRIBUTION OF GRADE POINTS\")","v":"DISTRIBUTION OF GRADE POINTS"}]
[]
[]
[]
[]
[null,"SEE BELOW FOR VARIOUS CAREER METRICS:"]
[]
[null,"CUMULATIVE STATISTICS"]
[]
[null,"YEARLY GPA TREND"]
[]
[null,"NOTE: This metric uses data from the CUMULATIVE GPA tab."]
[]
[null,"YEAR","Grade Point Average"]
[null,"1",{"$f":"IF('CUMULATIVE GPA'!$D$33<>\"\", 'CUMULATIVE GPA'!$D$33, NA())","v":3.5329999999999999}]
[null,"2",{"$f":"IF('CUMULATIVE GPA'!$H$33<>\"\", 'CUMULATIVE GPA'!$H$33, NA())","v":{"$error":"#N/A"}}]
[null,"3",{"$f":"IF('CUMULATIVE GPA'!$L$33<>\"\", 'CUMULATIVE GPA'!$L$33, NA())","v":{"$error":"#N/A"}}]
[null,"4",{"$f":"IF('CUMULATIVE GPA'!$P$33<>\"\", 'CUMULATIVE GPA'!$P$33, NA())","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Once Year 2 courses are added (after Year 1 completion), a linear trendline appears. This shows the general direction"]
[null,null,"in which your GPA is progressing; whether trending higher (upward slope, /), trending lower (downward slope, \\), or remaining stagnant (horizontal slope, ─)."]
[]
[]
[null,"DISTRIBUTION OF GRADE POINTS"]
[]
[null,"NOTE: This metric uses data from the CUMULATIVE GPA tab."]
[]
[null,"Grade Points","# Times GPA Assigned"]
[null,4.33,{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B49), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B49),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B49),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B49))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B49), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B49),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B49),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B49)))","v":1}]
[null,"4.00",{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B50), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B50),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B50),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B50))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B50), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B50),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B50),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B50)))","v":3}]
[null,3.67,{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B51), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B51),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B51),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B51))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B51), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B51),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B51),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B51)))","v":1}]
[null,3.33,{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B52), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B52),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B52),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B52))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B52), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B52),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B52),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B52)))","v":2}]
[null,"3.00",{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B53), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B53),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B53),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B53))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B53), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B53),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B53),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B53)))","v":2}]
[null,2.67,{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B54), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B54),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B54),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B54))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B54), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B54),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B54),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B54)))","v":1}]
[null,2.33,{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B55), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B55),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B55),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B55))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B55), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B55),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B55),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B55)))","v":{"$error":"#N/A"}}]
[null,"2.00",{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B56), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B56),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B56),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B56))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B56), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B56),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B56),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B56)))","v":{"$error":"#N/A"}}]
[null,1.67,{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B57), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B57),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B57),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B57))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B57), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B57),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B57),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B57)))","v":{"$error":"#N/A"}}]
[null,1.33,{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B58), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B58),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B58),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B58))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B58), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B58),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B58),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B58)))","v":{"$error":"#N/A"}}]
[null,"1.00",{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B59), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B59),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B59),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B59))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B59), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B59),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B59),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B59)))","v":{"$error":"#N/A"}}]
[null,0.67,{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B60), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B60),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B60),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B60))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B60), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B60),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B60),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B60)))","v":{"$error":"#N/A"}}]
[null,0,{"$f":"IF(SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B61), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B61),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B61),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B61))=0, NA(), SUM(COUNTIF('CUMULATIVE GPA'!$D$17:$D$31, B61), COUNTIF('CUMULATIVE GPA'!$H$17:$H$31, B61),COUNTIF('CUMULATIVE GPA'!$L$17:$L$31, B61),COUNTIF('CUMULATIVE GPA'!$P$17:$P$31, B61)))","v":{"$error":"#N/A"}}]

{"sheet":"TOOLS","index":5,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[64,2,64,3],[64,4,64,5],[64,7,64,8],[62,7,62,8],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[61,4,61,5],[62,4,62,5],[59,4,59,5],[60,4,60,5],[59,7,59,8],[60,7,60,8],[61,7,61,8],[55,2,55,3],[55,7,55,8],[56,2,56,3],[57,2,57,3],[58,2,58,3],[55,4,55,5],[56,7,56,8],[57,7,57,8],[58,7,58,8],[56,4,56,5],[57,4,57,5],[58,4,58,5],[42,1,42,2],[42,3,42,4],[42,5,42,6],[9,4,9,6],[11,4,11,6],[6,1,12,2],[7,4,7,6],[41,1,41,2],[41,3,41,4],[41,5,41,6]]}
[]
[]
[null,"GRADE CALCULATOR v3.0"]
[null,"TOOLS"]
[]
[]
[null,"QUICK \nNAVIGATION\n( click link, then \nscroll if necessary )"]
[null,null,null,null,{"$f":"HYPERLINK(\"[GradeCalcV3.xlsm]TOOLS!A16\",\"SAVE WORKBOOK SNAPSHOT\")","v":"SAVE WORKBOOK SNAPSHOT"}]
[]
[null,null,null,null,{"$f":"HYPERLINK(\"[GradeCalcV3.xlsm]TOOLS!A37\",\"PERCENTAGE FINDER\")","v":"PERCENTAGE FINDER"}]
[]
[null,null,null,null,{"$f":"HYPERLINK(\"[GradeCalcV3.xlsm]TOOLS!A49\",\"GRADE TARGETER\")","v":"GRADE TARGETER"}]
[]
[]
[]
[null,"SAVE WORKBOOK SNAPSHOT"]
[]
[]
[null,"Click the following button to save a copy of this workbook:"]
[]
[]
[]
[null,"The current date is automatically included in the file name, however, you may name the file to anything you choose."]
[null,"Once saved, the file is located in the same directory as the currently opened file \"GradeCalcV3.xlsm\"."]
[]
[]
[null,null,null,null,null,null,null,null,"NOTE: You continue to work and save in the file \"GradeCalcV3.xlsm\" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PERCENTAGE FINDER"]
[]
[]
[null,"Use this tool to convert scores of assignments, quizzes, tests, and other items:"]
[]
[null,"MARK",null,"out of",null,"TOTAL MARKS"]
[null,26,null,null,null,30,null,"=",{"$f":"ROUND((B43/F43)*100, 2)","v":86.67},"%"]
[]
[null,null,null,null,null,null,null,null,"Above answer is rounded to 2 decimal places."]
[]
[]
[]
[null,"GRADE TARGETER"]
[]
[]
[null,"NOTE: This tool uses existing inputted data from the SEMESTER TRACKER sheet."]
[]
[null,"Enter the target grades for each of your courses below. Course names are pre-populated based on SEMESTER TRACKER worksheet."]
[]
[null,"COURSE #","COURSE NAME",null,"TARGET GRADE (%)",null,null,"GRADE NEEDED (%)"]
[null,1,{"$f":"IF('SEMESTER TRACKER'!$B$18=\"\", \"\", 'SEMESTER TRACKER'!$B$18)","v":"EXG 101"},null,90,null,null,{"$f":"IF(E57<>\"\", ROUND(((E57*100)-(('SEMESTER TRACKER'!D34)*('SEMESTER TRACKER'!D32)))/(100-'SEMESTER TRACKER'!D32),2), \"\")","v":112.19},null,"----",{"$f":"IF(H57<>\"\", CONCATENATE(\"You need to get a grade (or average grade) of \", H57, \"% in the remaining \", 100-'SEMESTER TRACKER'!D32, \"% of the course.\"), \"\")","v":"You need to get a grade (or average grade) of 112.19% in the remaining 40% of the course."}]
[null,2,{"$f":"IF('SEMESTER TRACKER'!$F$18=\"\", \"\", 'SEMESTER TRACKER'!$F$18)","v":"EXG 102"},null,85,null,null,{"$f":"IF(E58<>\"\", ROUND(((E58*100)-(('SEMESTER TRACKER'!H34)*('SEMESTER TRACKER'!H32)))/(100-'SEMESTER TRACKER'!H32),2), \"\")","v":75.510000000000005},null,"----",{"$f":"IF(H58<>\"\", CONCATENATE(\"You need to get a grade (or average grade) of \", H58, \"% in the remaining \", 100-'SEMESTER TRACKER'!H32, \"% of the course.\"), \"\")","v":"You need to get a grade (or average grade) of 75.51% in the remaining 40% of the course."}]
[null,3,{"$f":"IF('SEMESTER TRACKER'!$J$18=\"\", \"\", 'SEMESTER TRACKER'!$J$18)","v":""},null,null,null,null,{"$f":"IF(E59<>\"\", ROUND(((E59*100)-(('SEMESTER TRACKER'!L34)*('SEMESTER TRACKER'!L32)))/(100-'SEMESTER TRACKER'!L32),2), \"\")","v":""},null,"----",{"$f":"IF(H59<>\"\", CONCATENATE(\"You need to get a grade (or average grade) of \", H59, \"% in the remaining \", 100-'SEMESTER TRACKER'!L32, \"% of the course.\"),\"\")","v":""}]
[null,4,{"$f":"IF('SEMESTER TRACKER'!$N$18=\"\", \"\", 'SEMESTER TRACKER'!$N$18)","v":""},null,null,null,null,{"$f":"IF(E60<>\"\", ROUND(((E60*100)-(('SEMESTER TRACKER'!P34)*('SEMESTER TRACKER'!P32)))/(100-'SEMESTER TRACKER'!P32),2), \"\")","v":""},null,"----",{"$f":"IF(H60<>\"\", CONCATENATE(\"You need to get a grade (or average grade) of \", H60, \"% in the remaining \", 100-'SEMESTER TRACKER'!P32, \"% of the course.\"),\"\")","v":""}]
[null,5,{"$f":"IF('SEMESTER TRACKER'!$R$18=\"\", \"\", 'SEMESTER TRACKER'!$R$18)","v":""},null,null,null,null,{"$f":"IF(E61<>\"\", ROUND(((E61*100)-(('SEMESTER TRACKER'!T34)*('SEMESTER TRACKER'!T32)))/(100-'SEMESTER TRACKER'!T32),2), \"\")","v":""},null,"----",{"$f":"IF(H61<>\"\", CONCATENATE(\"You need to get a grade (or average grade) of \", H61, \"% in the remaining \", 100-'SEMESTER TRACKER'!T32, \"% of the course.\"), \"\")","v":""}]
[null,6,{"$f":"IF('SEMESTER TRACKER'!$V$18=\"\", \"\", 'SEMESTER TRACKER'!$V$18)","v":""},null,null,null,null,{"$f":"IF(E62<>\"\", ROUND(((E62*100)-(('SEMESTER TRACKER'!X34)*('SEMESTER TRACKER'!X32)))/(100-'SEMESTER TRACKER'!X32),2), \"\")","v":""},null,"----",{"$f":"IF(H62<>\"\", CONCATENATE(\"You need to get a grade (or average grade) of \", H62, \"% in the remaining \", 100-'SEMESTER TRACKER'!X32, \"% of the course.\"), \"\")","v":""}]
[null,7,{"$f":"IF('SEMESTER TRACKER'!$Z$18=\"\", \"\", 'SEMESTER TRACKER'!$Z$18)","v":""},null,null,null,null,{"$f":"IF(E63<>\"\", ROUND(((E63*100)-(('SEMESTER TRACKER'!AB34)*('SEMESTER TRACKER'!AB32)))/(100-'SEMESTER TRACKER'!AB32),2), \"\")","v":""},null,"----",{"$f":"IF(H63<>\"\", CONCATENATE(\"You need to get a grade (or average grade) of \", H63, \"% in the remaining \", 100-'SEMESTER TRACKER'!AB32, \"% of the course.\"), \"\")","v":""}]
[]
[null,"(single)",{"$f":"IF('SINGLE COURSE'!B17=\"\", \"\", 'SINGLE COURSE'!B17)","v":"SAM 100"},null,null,null,null,{"$f":"IF(E65<>\"\", ROUND(((E65*100)-(('SINGLE COURSE'!D33)*('SINGLE COURSE'!D31)))/(100-'SINGLE COURSE'!D31),2), \"\")","v":""},null,"----",{"$f":"IF(H65<>\"\", CONCATENATE(\"You need to get a grade (or average grade) of \", H65, \"% in the remaining \", 100-'SINGLE COURSE'!D31, \"% of the course.\"), \"\")","v":""}]
[]
[null,null,null,null,null,null,null,"If grade above highlighted green; target grade is attainable."]
[null,null,null,null,null,null,null,"If grade above highlighted red; target grade is unattainable."]

{"sheet":"NOTES","index":6,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,3,14,10],[15,3,15,10],[8,3,8,10],[9,3,9,10],[10,3,10,10],[11,3,11,10],[12,3,12,10],[13,3,13,10],[13,1,13,2],[14,1,14,2],[15,1,15,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2]]}
[]
[]
[null,"GRADE CALCULATOR v3.0"]
[null,"NOTES"]
[]
[null,"ADD NOTES TO ANY CURRENTLY ENROLLED COURSES:"]
[]
[]
[null,"COURSE NAME*",null,"NOTES"]
[null,{"$f":"IF('SEMESTER TRACKER'!$B$18=\"\", \"\", 'SEMESTER TRACKER'!$B$18)","v":"EXG 101"},null,"Follow-up with Jenny on group project by next class."]
[null,{"$f":"IF('SEMESTER TRACKER'!$F$18=\"\", \"\", 'SEMESTER TRACKER'!$F$18)","v":"EXG 102"}]
[null,{"$f":"IF('SEMESTER TRACKER'!$J$18=\"\", \"\", 'SEMESTER TRACKER'!$J$18)","v":""}]
[null,{"$f":"IF('SEMESTER TRACKER'!$N$18=\"\", \"\", 'SEMESTER TRACKER'!$N$18)","v":""}]
[null,{"$f":"IF('SEMESTER TRACKER'!$R$18=\"\", \"\", 'SEMESTER TRACKER'!$R$18)","v":""}]
[null,{"$f":"IF('SEMESTER TRACKER'!$V$18=\"\", \"\", 'SEMESTER TRACKER'!$V$18)","v":""}]
[null,{"$f":"IF('SEMESTER TRACKER'!$Z$18=\"\", \"\", 'SEMESTER TRACKER'!$Z$18)","v":""}]
[]
[]
[null,"*","Course names are auto-populated from the \"SEMESTER TRACKER\""]