
Annual Report
Docs + Word6 pages
FeaturedFree
Cost per wear is price divided by how often you wear a piece, and it falls every time you put it on. The Items tab covers each piece, with its category, price, any wears from before you started and a target cost per wear. The Wears tab is a plain list of dates and items. The sheet counts the log, adds the earlier wears and shows a verdict: Yes when the cost per wear is at or under your target, Not yet when it is above and Not worn when the piece is still unworn.
The Cost per Wear tab compares categories such as outerwear, shoes and dresses, with a chart. It also shows total wardrobe spend, total wears and how many pieces have never been worn. A formal dress worn twice shows why the number can be high, while a winter coat worn all season drops quickly.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Items tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Divide the price by the number of times you have worn the item. A $240 coat worn 28 times costs about $8.57 per wear and keeps dropping with each wear.
It depends on the piece. Everyday shoes can reasonably aim for a few dollars; an occasion dress may never get low. Set a target for each item before you buy.
Logging gives the best figure, but you can enter an estimate of earlier wears and log only the rest. The total is earlier wears plus logged wears.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
FreeSheets + Excel6 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel5 tabs
Free
Sheets + Excel5 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel6 tabs
FreeSheets + Excel7 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel5 tabs
FreeSheets + Excel5 tabs
FreeSheets + Excel5 tabs
Free