Sneaker spreadsheets tend to be reseller spreadsheets. They compute cost of goods, platform fees and a tax summary, and somewhere underneath all that is a list of the pairs you own. This one is the other way round. It works out a cost per wear on every pair you keep, and it is built for the person who is keeping the shoes.
Cost per wear: what each pair actually costs you
The phone apps log your wears. The reseller spreadsheets hold your money. The two rarely meet in one file, so neither can tell you what a pair costs you to put on.
Log a wear here — a date and a Pair ID is the whole habit — and every pair gets a real number. The Dashboard then ranks it both ways: the pairs earning their place, and the pairs still costing you. A $70 pair worn every week and a $210 pair worn twice are the same line item in a tracker that only records what you paid. They are not the same thing, and after a month of logging you can see it.
A valuation history, with its sources written down
The usual approach is a single “current value” cell that you overwrite. That means you can never see your collection move, and you can never tell what a figure was based on.
Here each valuation is its own dated row that records where the number came from — a last sale, a lowest ask (the cheapest pair listed right now), a sold comp (what a comparable pair actually sold for), or an appraisal. The Rotation reads the newest one on file for each pair, so every value on every tab can tell you how old it is. Value a pair twice, months apart, and the difference shows up on the Dashboard.
This workbook has no live price feed and no price database. It does arithmetic on numbers you look up and type in. That is deliberate: an automatic value you cannot inspect is one you can only take on faith.
Your size, brand by brand, from your own pairs
Sneaker sizing is not consistent between brands. General advice about how a brand runs can only ever describe a tendency, because it is not your foot in the shoe.
Rate how a pair actually fitted and the Fit & Sizing tab works out the size that would have gone on, then averages that per brand and per silhouette. The Grails tab calls the size on a pair you do not own yet — and says plainly when it has no pairs of that brand to go on, rather than inventing a recommendation.
The pair you forgot you owned
Days since you last wore a pair, judged against the threshold for that pair’s own role — a beater and a grail are not the same question. A pair that is both neglected and still worth what you paid for it gets a wear-it-or-move-it verdict; everything else gets a gentler nudge or none at all.
Nothing here tells you to sell anything. A pair you love and never wear is a perfectly good reason to own a pair. The arithmetic is there so the trade-off is visible when you want to look at it.
A schedule you can hand to an insurer
The Insurance Schedule tab computes itself from the other tabs. Every line carries a dated figure and the source it came from, which is the difference between a schedule an adjuster can work from and a list of shoes.
It is a record you prepared, not an appraisal — an insurer may still want a professional valuation, receipts or photographs. The Proof column is there to point at whichever of those you have.
Own it, don’t rent it
A collection app can cap how many pairs you add, put your export behind a subscription, or simply shut down and take the record of what you own with it.
This is a plain workbook. The .xlsx opens in Excel and LibreOffice with no connection at all, and the Google Sheets copy is a real native version made by a “Make a copy” link — not an import that loses your dropdowns. No account, no subscription, no pair limit, and nothing to renew.
Condition grading is a market convention rather than a standard, and practice differs between marketplaces — so every grade and every value factor in the workbook is an ordinary cell you can edit. Ardent Workshop is not affiliated with, endorsed by, or connected to any footwear brand, marketplace or app; brand and model names identify which shoe is meant, nothing more.
Try it before you buy
Want to see how it feels first? The free sneaker rotation starter is a one-tab taste of the full workbook — a row per pair, a have/want flag so your collection and your grail list sit in the same place, and three counts that keep themselves current. No email, no signup. It counts what you type in and stops there: cost per wear, the dated value history and the size call are what the full tracker adds. And if you collect more than sneakers, the rest of the Trackers line catalogs the other things you love the same way.
