Interesting to see that I'm not the only that tracks this kind of info on an excel spreadsheet. I initially started the spreadsheet in 2004 to track my flashlight spending and to correlate with my paypal account records since the sole reason I started a paypal account was to buy stuff on this forum. To this day, I still don't have an eBay account.
Anyway, mine is more general and messy because I was/am using it to track my paypal spending, so every little LED, UCL, reflector, battery, flashlight, etc is on it, which makes it kind of messy and hard to find actual flashlights in the spreadsheet. My column headings are "description, qty, price USD, price CAD, unit price CAD, exchange rate, date, notes".
One thing I do to help quickly identify stuff on my chronologically sorted spreadsheet is to use a coloring scheme in the Description. e.g. all my emitter/LED purchases are in yellow text on gray background, reflectors are gray text on white background, surefire stuff in orange text, Arc stuff in dark green text, etc.
It's kind of interesting to see my progression in spending on this hobby and what I've bought over the years. My very first paypal transaction and flashlight related purchase was 2 SMD+ kits from lambda, an old member that used to be on here for $25 USD each in Aug 2004. These were low-dome lux1 mini-mag drop-ins, kind of like a cheaper alternative to the sandwiches from the Shoppe. My first bare LED purchase was a week later from Fred, aka PhotonFanatic for 2 Lux3 TX0K emitters for $16.50 USD each. He used a different CPF handle/alias back then, which I can't remember what it was anymore, only that it had some zeroes in it. Ahhh... the nostalgia...
