Let's have a look at these spreadsheets
Seriously, any time you want to pop around you can check it out.
No problem sending you a blank copy if you want a template, but you need to be as anal as I am to keep them updated.
Just to give you a heads up on each worksheet:-
1. All hardware purchases - dates, vendors, order details, item details, prices, etc
2. Events - chronological recording of deliveries and despatches, stuff sold on, gear loaned out, battery changes etc
3. Bases and concentrates - details on purchases of PG, VG, nic, concentrates, syringes, bottles etc - notes on each concentrate, recommended %s etc and reminders for shopping!
4. Juice stock - list of all finished juices, when and how they're made up, reference numbers. Juice bottles are labelled and numbered to cross refer. I can search for a flavour and find which bottle it's in and how much is in it.
5. Used juice - details from 4 transfered here when the bottle's used up
6. Premade juice - details on all the premade juices I've vaped
7. 5ml testers - detailed notes on all flavour trials
8. Recipes - when I'm stumbling around the web and find a new recipe I'd like to trial this is where I capture it
9. Rebuilding materials - notes on all kinds of wire and wicking
10. Builds - a record of every build I've put into each RTA and RDA - number of coils, former, wire, wraps, ohms and notes on the atty
11. Wicking - results from my trials on silica, braided silica, organic cotton, Japanese cotton, China grass, Rayon
So it's my database on everything to do with my vaping ... enough data to keep me amused, counter my shocking memory and feel like I've a handle on it all.
I've the strangest feeling that not many vapers are as anal about it.