As my flavor stash continuously grew, I was finding it harder and harder to a) keep track of how much of what flavor I had and b) what flavors I had. Yes, ATF does have your stash saved, but lack of search function and not being organized by Flavor house kind of annoyed me.
__
I decided to hop on excel and whip up something of my own! I present Flavor Inventory!.
__
Basically from left to right I've got The Vendor, The concentrate, and The Amount (bottle size). Then I have a simple indicator so I know the level remaining in the bottle. From full down to 1/2 is green, from 1/2 to 1/4 is yellow and then 1/4 down is red. Then the next section is Back Up, if I've got a back up and the size of it goes into that column that way I don't accidentally order something I've already got. For shits and giggles I also set it up so that every time you add a concentrate in it keeps count down at the bottom of the sheet. I was hoping to be able to set it up so that once you change the bottle level marker to red it would automatically grab the flavor name from that row and add it onto my Order List on the next page but that seemed to have exceeded my Excel capabilities so I gave up. If anyone is good with Excel and knows how to do that, let me know! I'll edit the document so that it can do that.
__
It worked out way better than I thought it would and I figured I'd throw it into a Google Doc so that if anyone wanted to download it and use it for themselves they could!
__
I cleaned up the columns and made them more uniform to each other and cleared them all out so that you don't need to delete all of the ones I put in.
__
https://docs.google.com/spreadsheets/d/1k_tVNTlpKsLh5RdpPbvpnPtdbTX2D-sB305oa901KLU/edit?usp=sharing . That should be a downloadable link so you can grab it and save it for your own usage.
__
Happy Friday and mix some damn juice!
HotRod's calculator does all this and a whole lot more by the way.
https://www.e-cigarette-forum.com/threads/new-calculator-to-try.480587/
I LOVE THIS. Thank you so much for making it and sharing it. The Backup column is genius. I have my list on ELR (and a huge stack of invoices to add "when I get a round tuit.)" and not having it by house really annoys me too.
I'm not good at working with spreadsheets but I'm learning. This will motivate me to get good.
I wonder if there's a way to code flavors to make a sort into, "strawberry list" or 'vanilla list." This may have to do with pivot tables though, in which case I will run away.
Thank you! Stoked to hear that!
I’m not a pro by any means but I can get around, if you need any help just lemme know I’d be glad to help!
I don’t know if it’s the most efficient way to do it but you could add certain symbols to the flavor name which would trigger it to add to a list on the side.
Basically add a * to all the strawberries and then put a formula in a column on the side to add every cells content that has a * in it. I think that would work.
Mostly you'd want to do a regular expression that would be fairly complex, but even that wouldn't get all the flavors that have been polluted by strawberry if they don't have some variation of strawberry in the name. You could add another column for tags, so you could indicate 'fruit' or 'tobacco' or 'spice' or 'floral' or 'cream' or 'shitty^^^^^^^^^aka ^^^^^^^^^strawberry, ^^^^^^^^^peachlike, ^^^^^^^^^vanilla, ^^^^^^^^^etc ' or whatever.
> you'd want to do a regular expression that would be fairly complex
> /([a-zA-Z ]+)?[Ss]trawberr.*/g
PCRE compatible. Using global because the scope is a list, not single item. I wouldn't classify this as "fairly complex." If you need another version let me know.
Edit: Can regex, can't reddit. Formatting. Edit2: Also I don't prefer greedy operators but it works sometimes.
The complexity would be involved elsewhere. Now, a database would be easier to deal with (and would render the /g incorrect, as you'd be checking individual fields in your select statement, but if you're dealing with a spreadsheet, sorting by order of if a regular expression is satisfied, and making that regular expression flexible enough to capture any particular flavor that the user chooses?
I like this column idea a lot. Yes!
I only have about half the flavour stash you have, but I'm using (and liking) VaporSuite app. It's really cheap and comes with a lot of default flavours saved already (just need to star them and/or add the amounts), favourites function, comments, recipe calculator and an expenses tracker. So, having that as a guide, I store all my flavours alphabetically :)
Mine is...a little less organized.
Every so often, someone comes out with a spreadsheet/app/database/whatever for mixers, and usually inventory tracking is part of it... and not once have I seen one that would utilize proper time travel technology to populate itself back when you first acquired your flavors, and appropriately update your amounts on hand to what they actually are.
All in all, great idea for people just about to get started in DIY, but not completely worthwhile otherwise.
It actually wasn’t all that bad to put everything in. I think it was around 120 all together. It’ll be far easier to do now as each order comes in.
For someone like id10t, I can see that being a total pain in the ass and not worth the time.
I don't have as many flavors as he does, but I've got over a hundred bottles with unknown amounts in them... not exactly something that these inventory tracking things are useful for. unless I only enter the unopened bottles, and then update with new bottles as they come in.
I use my complete failure at any sort of inventory tracking as a opportunity to explore creative solutions.
I also accidentally order extra bottles of things I already have all the damn time. One day all get around to giving a bunch of stuff from the duplicates box away again.
I made an app for inventory management for my final college project, not super happy with it so haven't put it out yet but you can input a flavour by name, brand and volume as fast as you can type it in. Also takes mix % and any notes you wanna add among other bells and whistles.
I use it myself and I've found weighing an old bottle from the same brand and noting the weight and working out the difference gives a fairly accurate volume for pre-app inventory. Not incorporated weight in the app yet but it's a fairly easy update since the backend is set up for future scope.
Will probably never get to finish it as I have so much other work but it's nice to use something I made myself.
Props to OP!
I bought a $12 nail polish stand and I put them all in that. I have about 120ish flavors too and I fit almost all of them on that thing. Amazon, baby. They’re organized by profile mostly.
This is basically what I do with my inventory. I store it on an Excel doc and add it to ATF. Just something basic that I color the flavorings I need when they get low.
What I would really want is a way to make a calculator + inventory in Excel. Like, have all your flavors and mls, then everytime you make a recipe, it automatically subtracts that amount.
I know some calculators have it already and ATF has a feature like that as well, but I am someone who wants a 'physical' copy of his stuff just incase the internet/site/program goes down.