
Planning systemDrawing 10 of 33
SPMP
Two Excel workbooks that ran my whole high school plan, every goal and deadline rolling up into one number on a front page. I built it for myself, but it's written in third person, like it was meant for other students too.
- StatusBuilt and used, 2019 to 2021, last version 10.0
- SizeTwo workbooks, 40 sheets, about 300 formulas, plus macros
- SpanA plan running from eighth grade to twelfth, 2020 to 2025
- Built inExcel, no code beyond what the spreadsheet gives you
Sheet 02 of 04/Why
Why a spreadsheet
High school throws grades, tests, deadlines and volunteer hours at you all at once, so I built one sheet that could hold the whole pile instead of just today's slice of it.


Sheet 03 of 04/Parts
Issued as separate drawings
This project is more than one project. Each part below is its own set, with its own sections and pictures.
Part 01 / 02
The plan
One number on the front sheet, and the three year timeline underneath it. Eighteen sheets, 287 formulas and a set of macros.
Part 02 / 02
The tracker
The second workbook, twenty universities deep, and the reason it should never have been a second workbook.
Sheet 04 of 04/Again
What I would do differently
If I did this again I'd use way fewer sheets, forty across two files was more than the plan ever needed.