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.