/UTSC-cGPA-Excel

Quick script for cGPA spreadsheets given UTSC's cGPA distribution

Primary LanguagePython

UTSC cGPA Excel Builder

A quick script for building somewhat decent cGPA spreadsheets.
Requires OpenPyXl! (And yes, the code is disgusting as of right now. I'm fixing it.)

Sheet entry options

1 - Same entries, repeated %

Repeats subtitle for each entry, divides total worth evenly among entries
Useful for multiple entries of the same value (e.g. tests worth the same amount each time)
Ex1 Ex1_Sheet

2 - Same entries, different %

Repeats subtitle for each entry, assigns custom value to each entry
Useful for multiple entries with different values (e.g. assignments with different worth each)
Ex2 Ex2_Sheet

3 - Same entries, repeated % [top x of y]

Repeats subtitle for each entry, assigns same value to each entry but will calculate total based on top x of out y
Useful for taking a certain number of multiple entries of the same value (e.g. tests worth the same, but only 8 out of 10 are graded)
Ex3 Ex3_Sheet

4 - Lone entry

Single subtitle with specific worth
Useful for big entries (e.g. exam)
Ex4 Ex4_Sheet