The valid types of classes are Standard (no bonus to weighted GPA), Honors (+.5), AP (+1), College (+1), PLTW (+1), and Middle (not in GPA calculation).

These bonuses are the default settings, and may change depending on the values set in Settings.

Credit Hours (CrHrs) only apply to college classes. 0-2 hours means 0 credits, 3-4 means 1 credit, 5-8 means 2 credits, and 9+ means 3 high school credits.

This spreadsheet template is meant to cover North Carolina schools (and the default values set for Carteret County), and might not be accurate in other places.

Most of the heavy lifting is done by Named Formulas (basically functions in programming but in Google Sheets).

Don't store absences if it's too late for you to check them yourself, the exemptions rules have changed too much for anything for past classes to matter in the planner.

Put "N/A" as the exam type if you know there isn't an exam for that class at all.

Classes are marked as "Completed" when the grade is above 59 and the current date is after the 1st of January (for 1st semester classes) or the 1st of June (for 2nd semester). Credits are only counted when Completed.