shokao Posted November 3, 2022 Posted November 3, 2022 That's my actual inventory sheet. It has some info and you can setup your "age values" for GOOD DATE and PRIME DATE. I'm considering in this screenshot, the widely discussed 3-5 years. But I can't setup an specific age setting to apply my "Aging Rate". I'm currently working with 3 rates: LOW (< 3 years), GOOD (> 3 years < 5 years) and PRIME (> 5 years): Also made a small "dashboard" where I can see my numbers by marca, cigar and vitola: Still working in progress. I'll share with everybody in FOH interested in using it.
TR Posted November 3, 2022 Posted November 3, 2022 3 hours ago, hawkeye5050 said: I have built up a small collection and need a way to track inventory other than looking at old receipts! Gone through everything listed in this thread, Cigar Scanner and Excel/Google Sheets seems to be the best options for me. Before starting the fun of data entry wanted to double check - Anything else/new to consider? Any great example/templates for excel or google sheets to share? Cigar Scanner seems pretty slick & easy but don't see a way to export the data and like having a copy...which Excel/Google would give. Not married? Who keeps receipts if you are married?
hawkeye5050 Posted November 3, 2022 Posted November 3, 2022 54 minutes ago, TR said: Not married? Who keeps receipts if you are married? Ha! Just old emails really that I search when trying to remember what is what. 1 hour ago, shokao said: I'll share with everybody in FOH interested in using it. Good stuff, nice how you are doing the aggregate in the dashboard. If you can share I would appreciate it.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now