Free download

Cost per wear spreadsheet

This free spreadsheet works out the cost per wear of every item in your wardrobe: the price plus care costs, divided by how often you wore it. Log a wear on one sheet and the totals on the other sheets update. It opens in Excel, Google Sheets, Numbers and LibreOffice.

Download the spreadsheet (.xlsx)

An .xlsx file of about 16 KB. Formulas only, no macros, no sign-up.

Download the Dutch version

What is inside

Wardrobe
One row per item, up to 100: name, category, price, care and repairs, and the wears you had before you started. The sheet calculates the total wears, the cost per wear, how many more wears an item needs to reach your target, and a status.
Wear log
One row each time you wear something: the date and the item, picked from a list. Every row adds one wear to that item, up to 1,000 rows.
Summary
Totals for your whole list: what you spent, how often you wore it, the average cost per wear, how many items reach your target, and how much money sits in clothes you have not worn yet.

How to use it

  1. 1. Set your target

    The cost per wear you aim for sits at the top of the Wardrobe sheet. It starts at €1, a common benchmark for everyday clothing. Change it and every status follows.

  2. 2. Start with ten items, not your whole wardrobe

    Add the ten things you bought most recently, or the ones you suspect you hardly wear, with the price from the receipt or your order history. No idea of the price? Leave it empty: the item still counts wears, just no cost.

  3. 3. Log what you wear

    Add a row on the Wear log sheet each evening, or once a week from memory or your photos. Wears from before you started go in the column Wears before you started, so a coat you have had for three winters does not start at zero.

  4. 4. Look again after a month

    Sort the Wardrobe sheet by cost per wear. The lowest numbers are your best buys and a model for what to buy next; the highest are the items to wear more, to style differently, or to stop buying more of.

Frequently asked questions

Does the spreadsheet work in Google Sheets?

Yes. In Google Drive choose New, File upload, and open the file with Google Sheets. The formulas use plain functions (SUM, COUNTIF, SUMIFS, IF), so they work in Google Sheets, Numbers and LibreOffice as well as in Excel.

Does the file contain macros?

No. It is a plain .xlsx file with formulas only, so Excel does not ask you to enable anything.

How do I track more than 100 items?

Copy the last row of the Wardrobe sheet down as far as you need, then widen the ranges in the formulas on the Summary sheet and in the item list of the Wear log to the same row.

Can an app keep the count instead?

Yes. In Looqa.ai you tap Wear today on an outfit and the wear counts for every item in it; on Pro, the app also shows the cost per wear for items with a price. The spreadsheet suits you if you want to see and change every formula yourself.

Read more

Let Looqa keep the count