GratisAIlearning · field guide · local-first · no account
aid award worksheet

Rank Financial Aid Offers Before You Appeal One — Free

Paste each college's award letter as one dated line, and see which offer is really best once loans are split from grants — and the dollar gap your appeal has to close.

The proof surface

Award letters stack loans on top of grants so sticker totals look closer than they are; ranking the reader's own lines on grant share moves the real price ahead of the appeal call.

Inputthe award lines each college sent, pasted with their dates
Rare deviceconverts the reader's own award lines into a grant-share ranking and prices the exact gap an appeal must close, instead of re-explaining what a financial aid offer is
Output artifacta ranked worksheet with grant share per school and the gap your appeal has to close
Cost$0 · local-first · one free run · samples labelled
Sample, not your facts: Sample: Hollis $41,500 total on 2026-03-18 with $33,000 grants and $8,500 loans; Carver State $29,800 with $24,100 grants; Meredith $37,200 with $28,900 grants — three schools, three dates, three line types.

Why the flat version breaks

Comparing sticker totals

A bigger headline award can carry $6,000 more loans, which makes the cheap-looking school the expensive one by graduation.

Appealing with no number

An office cannot act on 'we need more aid'; without a named gap there is nothing to match against.

Waiting for the reply to organize

Appeals have short windows after the offer date, and the family that calls with the ranked sheet inside two weeks is the one that gets a decision.

How to work the aid award worksheet

Paste the offers

One dated line per school, keeping the words 'grants' and 'loans' on each line.

Set the gap

The dollar amount that decides where you enroll — this is what the appeal asks for.

Read the ranking

Each school is scored on total, grants and loans, with loans weighted against the offer.

Close the gap

Take the ranked sheet to the aid office that can actually match it, and cite your income change.

What the worksheet replaces

QuestionBeforeOn the worksheet
Which offer is besteyeball the biggest totalgrant-share rank with loans split out
What to ask fora vague 'more aid please'a priced gap the office can read in one line
Why the request is credibleno facts attachedyour own dated lines and income change beside the rank

The worksheet ranks the offers you paste; each college's aid office remains the authority on what it can change.

Run it on the samples, right here

FIRST-LOAD

Data note: Everything runs in this browser tab on the aid award worksheet: your offer lines and the gap you need closed stays on this device, nothing is uploaded, and the reading is rebuilt only when you press run.

Go deeper: the companion app files the same reading as a scored comparison matrix

The article demo above runs without limits. The companion app keeps a local history, exports the rows as CSV, prints the ready-to-mail packet, and holds your drafts on this device — one free run, then $ 9 one-time for the layer that keeps filing.

The ranking and the loan-burden split are free. The paid layer keeps every offer on this device, holds a draft appeal per school, and prints the comparison sheet for the call.

Open the aid award ranking worksheet companion

Boundary

This aid award worksheet works only on the award lines you paste you paste. It does not promise any college will change its offer, does not file the appeal for you, and does not advise on FAFSA eligibility rules. The figures describe what you supplied, not what is true in the world. Confirm anything you plan to act on with each college's financial aid office, and a school counselor for deadlines before you rely on it.

What this is built on

Before: the reader compared offers by sticker total. After: they can name that one school is $3,100 cheaper in real grant terms to the aid office, because they ranked the lines themselves.