For staff only This tool produces a recommendation from figures a family reported. It is not an award and does not verify anything. Your committee makes the decision — record it below. Everything stays in this browser on this computer; export regularly so it isn't the only copy.

This Family

What the family reported. Nothing here is verified — treat it as their word.

How they land

Their income range —
Published tuition —
Reduction for additional children —

Recommended Award

A starting point, not a decision. Override it whenever your judgement says otherwise.

Suggested assistance — —

If you award the midpoint

Family pays for the year —
Per payment —
They pay this share of tuition —
—

Awards Recorded

Every decision you've entered, with what the tool suggested at the time.

Families awarded 0
Total awarded $0
Budget remaining —
Family Income Household Suggested Awarded Reason Date Remove

No awards recorded yet.

These records live in this browser on this computer only. Clearing site data, switching machines, or using a private window loses them. Export regularly and keep the spreadsheet as your real record.
Your ranges & settings Set once, then rarely touched

Ranges are written for a household of four. Thresholds adjust on their own for larger and smaller households, so you only enter one set of figures.

Up to They pay (low) They pay (high)

The last row is everyone above your top threshold. Set it to 100% if those families pay full tuition.

Settings save automatically to this browser.