Shopping

Wishlist priority score: rate each item on need, use and cost

A wishlist priority scoring sheet: rate each item 1 to 5 on need, expected use and cost, add a formula that ranks the list, and test it on six made-up items.

Editorial illustration for Wishlist priority score: rate each item on need, use and cost

A wishlist priority score gives every item a number so that the list sorts itself. Rate each one from 1 to 5 on need, expected use and how easily you can afford it, combine the three with a simple formula, and buy from the top down. It takes ten minutes and replaces mood with a method.

The three ratings

  • Need (1 to 5): 1 means nice to have, 5 means something is broken or missing without it.
  • Use (1 to 5): 1 means a few times a year, 5 means most days.
  • Cost (1 to 5): this is an affordability score. 5 means comfortably within your budget, 1 means it would strain a month.

Scoring cost so that higher is better keeps all three columns pointing the same way, and the highest total is the best candidate.

The formula

Put need in column B, use in C and cost in D, with the score in E. A simple version is =B2*2+C2+D2, which counts need twice. Need is doubled because a broken mixer should outrank a cheap gadget you would use daily. If you disagree, change the weights, but fix them before you score so you do not tune the answer.

Six made-up items

ItemNeedUseCostScore
Running shoes54317
Mixer grinder55217
Laptop stand35415
Winter jacket42212
Air fryer23310
Bluetooth speaker1349

Check the arithmetic: shoes are 5 times 2 plus 4 plus 3, which is 17. The mixer grinder is 10 plus 5 plus 2, also 17. The laptop stand is 6 plus 5 plus 4, which is 15. Two items tie at 17, so decide a tie-break in advance. A sensible one is the higher cost score, which means the cheaper item goes first. Here the shoes win.

Sorting the list automatically

  1. In Excel 365 or 2021: =SORTBY(A2:A7,E2:E7,-1,D2:D7,-1) lists items by score from highest, then by cost score from highest.
  2. In Google Sheets: =SORT(A2:E7,5,FALSE,4,FALSE) sorts the whole table by column 5 and then column 4, both descending.
  3. In older Excel, sort the table by hand with Data then Sort, choosing Score first and Cost second.

A caution on scoring: scores drift upwards when you want something. Two habits help. First, write a one-line reason beside any need score of 5, for example the old one stopped working. Second, ask someone at home to score the same list and compare. Where you differ by two points or more, you have found an item worth talking about before spending. For shared items, such as a sofa or a cooler, agree the scores together, and keep the sheet where everyone at home can see it.

What do you do with the ranking?

Draw a line under what your budget this month can cover. If you have ₹6,000 for wishlist items and the shoes cost ₹3,500, they fit, and the mixer grinder at ₹5,500 does not, so it goes next month. Items below the line stay on the list and wait. If an item sits at the bottom through three rounds, it is a candidate for deleting.

A tracker for the next step

When a sheet stops being enough, say you want to set aside money for the top item, SpendixAI has savings goals and budgets on the Pro plan, and statement imports show what you actually spent in a month. The scoring sheet itself works well in any spreadsheet.

Before you buy

  • Check the price is still what you scored.
  • Ask whether a smaller, cheaper version would meet the need.
  • Re-score if your situation has changed.
  • Record the purchase and the date so the list stays short.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports