b i o

m a t h

a m - s t u d

l a t i n

e n g l i s h

How it works 🔎

Our formulas are based on a library called math.js, but are setup to work without coding skills.

Days Late

This formula calculates the number of days between the due date and submission. In case of excused tardiness, correct the submission date or delete the formula and turn this column into a simple number.

dateBetween(prop("Due"), prop("Submitted"), "days") * -1

Final Grade

This formula takes late policies into consideration. It also accounts for any tardiness that's been excused.

`prop("Grade") - prop("Days Late") * prop("Late Penalty") * 100 * toNumber(not prop("Excused"))`

Class Grade

This formula calculates points per assignment. The sum is your grade in the class.

`prop("Final Grade") * prop("Weighting")`

⚠ Note: If you modify any of the table's properties, you'll need to adjust the above formulas accordingly.