{"product_id":"wardrobe-inventory-cost-per-wear","title":"Wardrobe Inventory and Cost Per Wear Spreadsheet","description":"\u003cp\u003eThis wardrobe inventory works out what each piece of clothing really costs you every time you wear it. It is for anyone building a capsule wardrobe or clearing out a closet who would rather decide from numbers than from a feeling about the coat at the back of the rail.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eTwo tabs do the work\u003c\/h2\u003e\u003cp\u003eItems holds what you own and the Wear Log holds what you wore. The wear log is four columns and takes about fifteen seconds a day. Everything else is arithmetic on those two tabs.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eItems: room for 400 pieces, with category, color, brand, season and price\u003c\/li\u003e\n\u003cli\u003eTimes worn, last worn and cost per wear: three columns you never fill in\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eCost per wear on everything\u003c\/h2\u003e\u003cp\u003eCost per wear is calculated on every item, then ranked twice against a line you set: the ten most expensive per wear and the ten best value. It is worked out by category too, which shows how you really dress. An expensive coat can turn out to cost far more per wear than you thought, and a plain tee far less.\u003c\/p\u003e\u003ch2\u003eOwned against worn\u003c\/h2\u003e\u003cp\u003eThe Gaps tab sets each category's share of your wardrobe beside its share of your wearing. In the demo, knitwear makes up 9.5% of what is owned but only 2.7% of what is worn, exactly the mismatch a capsule wardrobe is meant to prevent.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eNever worn, listed by name with the date bought and the full price, because that is what it has cost so far\u003c\/li\u003e\n\u003cli\u003eAnything not worn in ninety days is flagged\u003c\/li\u003e\n\u003cli\u003eOutfits that already work, counted by the days they actually appear in the log\u003c\/li\u003e\n\u003cli\u003eMonthly: wears, days dressed, what you bought and what it cost\u003c\/li\u003e\n\u003cli\u003eA wishlist with the total against what is left in your clothes budget\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eTen connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Items, Wear Log, Cost Per Wear, Outfits, Gaps, Wishlist, Monthly and Dashboard. It works as a closet inventory, outfit tracker and clothing tracker in one file. There are no photographs and no style advice: it divides two numbers correctly and shows you the answer, and what that means is yours to decide.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice. No Microsoft 365 subscription is required.\u003c\/li\u003e\n\u003cli\u003eNo subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: 42 items with nine months of wear and one cardigan never worn, and a blank one for your own closet\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eHow much do I have to log each day?\u003c\/h3\u003e\u003cp\u003eThe Wear Log is four columns and takes about fifteen seconds a day. Times worn, last worn and cost per wear are calculated for you.\u003c\/p\u003e\u003ch3\u003eHow is cost per wear worked out?\u003c\/h3\u003e\u003cp\u003eIt divides each item's price by the number of times you have worn it. Items never worn show their full price.\u003c\/p\u003e\u003ch3\u003eCan it help me declutter?\u003c\/h3\u003e\u003cp\u003eIt lists items you have never worn by name and flags anything not worn in ninety days, so you can decide what to keep.\u003c\/p\u003e\u003ch3\u003eCan I add photos of my clothes?\u003c\/h3\u003e\u003cp\u003eNo. It has no photographs and no style advice. It tracks what you own and wear and does the arithmetic.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597865680990,"sku":"OPX-098","price":18.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/wardrobe-inventory-cost-per-wear-01.jpg?v=1790832489","url":"https:\/\/opxviashop.com\/products\/wardrobe-inventory-cost-per-wear","provider":"OPXVIA","version":"1.0","type":"link"}