Robusto_SingleMalt
New Member
- Joined
- May 17, 2014
- Messages
- 17
Hello,
I've made a cigar diary and purchase tracking spreadsheet.
It's a two-sheet spreadsheet where on the first sheed you keep track of the purchases and the humidor aging time.
Second sheet is the smoking log where you submit your notes and such.
Both sheets are interlinked, so the name and brand pops up in second sheet when giving the right "SKU" number, and the first sheet will keep track of your stock when a cigar is reported in second sheet.
The aging formulae for the humi is set to start aging 14 days after placing there.
Link: https://docs.google.com/spreadsheets/d/1tn9mVT8cifHSVWMp5ZtxZkUvy_79MDFU8mRPW_sKYLg/edit#gid=917361440
It's a shared google doc that is set to "view" but I think you should be able to download to excel or libreoffice to fiddle with yourself.
The input fields should be self explanatory. Just take care where you input and see that there is not a formula in the cell.
Purchase and overview sheet has 100 lines ready coded and the cigarlog has 1.000 prefilled lines.
I've made a first entry as an example in both sheets.
Enjoy
I've made a cigar diary and purchase tracking spreadsheet.
It's a two-sheet spreadsheet where on the first sheed you keep track of the purchases and the humidor aging time.
Second sheet is the smoking log where you submit your notes and such.
Both sheets are interlinked, so the name and brand pops up in second sheet when giving the right "SKU" number, and the first sheet will keep track of your stock when a cigar is reported in second sheet.
The aging formulae for the humi is set to start aging 14 days after placing there.
Link: https://docs.google.com/spreadsheets/d/1tn9mVT8cifHSVWMp5ZtxZkUvy_79MDFU8mRPW_sKYLg/edit#gid=917361440
It's a shared google doc that is set to "view" but I think you should be able to download to excel or libreoffice to fiddle with yourself.
The input fields should be self explanatory. Just take care where you input and see that there is not a formula in the cell.
Purchase and overview sheet has 100 lines ready coded and the cigarlog has 1.000 prefilled lines.
I've made a first entry as an example in both sheets.
Enjoy
