Recommended Posts

Posted

Cigar-Spreadsheet.png.e7e5d5d6826948d0ee449964f5150352.png

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):

Aging-rates.png.897709118749f7e607d71c26f6369a4f.png

 

Also made a small "dashboard" where I can see my numbers by marca, cigar and vitola:

Dashboard.png.d9a47eed09cf76f597632033ed5f676a.png

Still working in progress. I'll share with everybody in FOH interested in using it.

Posted
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 -

  1. Anything else/new to consider?
  2. 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?  :)

Posted
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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.

Community Software by Invision Power Services, Inc.