DIY_eJuice
https://ift.tt/eA8V8J
Flavor Inventory! https://ift.tt/2JRpWub

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!

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://ift.tt/2OBvCJJ . 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!

Submitted November 09, 2018 at 06:06PM by eyemakepizza
via reddit https://ift.tt/2z09J1N}

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s