Criteria · Buying a Car
Six pass/fail gates that rule cars out before you compare anything. Then 80 questions across four weighted criteria, scored across up to five cars.
The problem
There are hundreds of models on sale, times trims, times model years once used is on the table. Scoring works on a shortlist. It does not work on a market.
So the first job is elimination, not comparison. That is what the gates do. They are pass or fail, they remove whole categories, and they cannot be outweighed by something else that scored well.
Only then does scoring make sense, and only across the cars that survived.
Start here
A gate is not a preference. One fail and the car is out. Not scored lower. Out.
No charging where it sleeps and none at work? An EV is out, however much you want one.
A surprise repair bill would genuinely hurt? Older used is out.
One number covering payment, insurance, fuel and maintenance. Written down first.
Salvage or rebuilt. Walk away. Every time, at any price.
An independent pre-purchase inspection is refused? The car is out.
It physically fits your parking space and garage. Measured, not guessed.
What you get
13 pages, US Letter, built to be printed and written on at a viewing.
Eight tabs. Name the cars once on the Gates tab and they flow everywhere.
Inside the spreadsheet
That is deliberate. You can see exactly what you are giving up, and it does not change the answer. The ranking skips it.
Yellow cells are yours. Everything else works itself out.
| Criterion | Weight | 2022 Hybrid SE | 2019 Wagon |
|---|---|---|---|
| Gates | CLEARED | OUT | |
| The money | 5 | 20.00 | 10.00 |
| The reliability | 4 | 20.00 | 12.00 |
| The fit | 4 | 12.00 | 20.00 |
| The deal | 3 | 12.00 | 12.00 |
| Weighted total | 16 | 64.00 | 54.00 |
| Rank | 1 | — |
The weights
A starting point, not a verdict. Both files are built for you to overwrite them.
| Criterion | Weight | Why |
|---|---|---|
| The money | The only one that can end the decision | |
| The reliability | A year and an engine, not a badge | |
| The fit | You live in it every day | |
| The deal | How you buy, not what you buy |
How it works
Pass or fail. One fail and the car is out.
Or open the spreadsheet. Either works alone.
1 to 5, in the moment, before you talk yourself round.
Your judgement, not an average. One alarming answer should not get averaged away by nineteen fine ones.
A gap of two or three points is noise. A gap of eight is telling you something.
Go back and find the criterion you underweighted. It is usually the money.
Straight answers
Two files. A 13-page printable workbook with six pass/fail gates and 80 questions across four weighted criteria, plus the signs to walk away from and what you can check yourself. And an Excel scorecard with eight tabs that scores up to five cars and calculates the weighted totals.
A gate is a pass or fail condition that removes a car entirely and cannot be outweighed by anything else. A criterion is scored one to five and traded off against the others. Salvage title is a gate. Fuel economy is a criterion. The workbook runs six gates before you score anything.
Yes. The gates cover the EV question directly, since home charging is treated as pass or fail rather than a preference. The money section covers financing and depreciation for both new and used. The reliability section is written mainly for used cars, where it does the most work.
The workbook opens in Excel, Google Sheets and Numbers. All formulas are standard. If you would rather work on paper, the PDF stands alone and includes its own scorecard page.
Yes, and you should. They are pre-filled as a starting point and both files are built for you to overwrite them. In the spreadsheet, changing a weight recalculates every total instantly.
Five in the spreadsheet. The PDF scorecard has three columns, and you can print extra copies for more.
No. It is a decision framework: the questions to ask, what to verify independently, and a way to score what you find. It does not tell you which car to buy, and it is not a substitute for a mechanic or a financial adviser.
The second largest purchase most people make
Six gates. Four weighted criteria. Five cars. Two files, instantly.
Get the workbook — $19