ScentLedger Collection Tracker Template
========================================

A free, standalone spreadsheet for tracking your own bottles, wishlist, and decants. It does not sync with any app and no account is required. Scentledger.app publishes secondary-market resale pricing, price history, per-mL cost breakdowns, and a popular list. It does not track personal collections.

WHAT IS IN THIS FOLDER
- scentledger-collection-tracker.xlsx : the full template with five tabs (Collection, Wishlist, Decant Inventory, Cost per mL Calculator, Read Me). Formulas are live.
- csv/collection.csv : Collection tab as a standalone CSV
- csv/wishlist.csv : Wishlist tab as a standalone CSV
- csv/decant-inventory.csv : Decant Inventory tab as a standalone CSV
- csv/cost-per-ml-calculator.csv : Calculator tab as a standalone CSV with formulas embedded as text

IMPORTING INTO GOOGLE SHEETS
Option A: upload the .xlsx to Google Drive and open it with Google Sheets. All tabs and formulas carry over.
Option B: in Sheets, use File > Import > Upload for each CSV and choose "Insert new sheet(s)", then rename each tab to match its file name.
In Excel or Numbers, just open the xlsx directly.

THE FORMULAS
Collection tab, Cost per mL = Purchase Price / Size (mL)
Decant Inventory tab, Fill Remaining (%) = Fill Remaining (mL) / Size (mL), formatted as a percentage
Decant Inventory tab, Cost per mL = Cost / Size (mL)
Calculator, Total landed cost = price + shipping or tax paid
Calculator, Cost per mL = total landed cost / size (mL)
Calculator, Decant premium per mL = decant cost per mL - full-bottle cost per mL
Calculator, Same-spend comparison = total decant spend / full-bottle cost per mL

ABOUT THE EXAMPLE ROWS
Every example row uses synthetic data and fictional house names invented for illustration. Replace them with your own bottles. No row represents a real market price or a recommendation to buy anything.

Template by ScentLedger (scentledger.app)
