Bean Storage Spreadsheet

[fivegallon]

Does anyone have a bean storage spreadsheet they care to share before i go reinventing the wheel?

I just spent a considerable amount of time searching through the site and also through google and came up with very little.
The only links i found here on CS were from 2006 and the links werent working for me.

[GrahamK]

Re: Bean Storage Spreadsheet

Not sure what you mean by a Bean Storage spreadsheet. However I have a workbook that I use which tracks my coffee purchases, coffee roasting and provides a report of my current green bean situation including financially. While its not particularly difficult, it does require a bit of maintenance when you add new beans etc to the various lists to ensure the report stays current, so you will need some Excel expertise to maintain it.

I also track my hottop cleaning and filter changes in the roasting log.

I generally print out the Roasting and Purchasing logs as well as the Green bean status report, and file them on a regular basis.

I too have a Hottop, so the Roasting log is based around that. If its what you are looking for, at least a starting point or something you can adapt for yourself, let me know and Ill post it on the forum.

GrahamK

[fivegallon]

Re: Bean Storage Spreadsheet

Not sure what you mean by a Bean Storage spreadsheet. However I have a workbook that I use which tracks my coffee purchases, coffee roasting and provides a report of my current green bean situation including financially. While its not particularly difficult, it does require a bit of maintenance when you add new beans etc to the various lists to ensure the report stays current, so you will need some Excel expertise to maintain it.

I also track my hottop cleaning and filter changes in the roasting log.

I generally print out the Roasting and Purchasing logs as well as the Green bean status report, and file them on a regular basis.

I too have a Hottop, so the Roasting log is based around that. If its what you are looking for, at least a starting point or something you can adapt for yourself, let me know and Ill post it on the forum.

GrahamK

Sounds good Graham, i would be keen to take a look and adapt for my requirements. Im ok with Excel and have done some VBA in the past also
Mostly i wanted it just to track bean purchases but having the roasting side also would be a bonus.

[Javaphile]

Re: Bean Storage Spreadsheet

Heres a post about one that many of us have been using for quite a few years now: http://coffeesnobs.com.au/YaBB.pl?num=1159680974/113#113


Java "Records it all!" phile

[GrahamK]

Re: Bean Storage Spreadsheet

Attached is my Excel Workbook. I have cobbled together some rough instructions on the 1st worksheet.

PM me if you need any help with it

[fivegallon]

Re: Bean Storage Spreadsheet

Nice one, cheers Graham!

[fivegallon]

Re: Bean Storage Spreadsheet

Heres a post about one that many of us have been using for quite a few years now: http://coffeesnobs.com.au/YaBB.pl?num=1159680974/113#113
That was one of the few i stumbled across earlier, unfortunately i dont have Access with my Office 2007. I did look at the 2010 upgrade some time back but didnt see a need at the time.
Looking at the screenshots maybe i will reconsider.
Cheers Javaphile

Java "Records it all!" phile

technical glitch forced a reboot...

Thanks Java, i did stumble across that one this morning but i dont have Access with my 2007 version of office.
I had previously not seen a need to upgrade to the 2010 version but may reconsider after seeing the screenshots of the database, even though it looks fairly intense.
Cheers

[Javaphile]

Re: Bean Storage Spreadsheet

i dont have Access with my 2007 version of office.

You might try Open Office. It may very well be able to deal with the db for free.

Yes, it is pretty intense. But you of course dont have to use all its capabilities. Ive been using it for quite a few years now and Ive yet to utilize all of its capabilities. In fact I just found a new one tonight when a screen Id never seen before accidentally got opened as I was formulating a new blend. The current db Im using covers all of my roasts and beans going back 6 years. Nice information to have. As with any other important data, make sure you do regular backups of it in multiple locations!



Java "Back that data up!" phile

[Dimal]

Re: Bean Storage Spreadsheet

You might try Open Office. It may very well be able to deal with the db for free.

Found it to work fine with Open Office Java, so worth considering in my opinion. These sorts of tasks are always handled and managed better in a DB anyway.... 8-)

Mal.

[fivegallon]

Re: Bean Storage Spreadsheet

i dont have Access with my 2007 version of office.

You might try Open Office. It may very well be able to deal with the db for free.

Yes, it is pretty intense. But you of course dont have to use all its capabilities. Ive been using it for quite a few years now and Ive yet to utilize all of its capabilities. In fact I just found a new one tonight when a screen Id never seen before accidentally got opened as I was formulating a new blend. The current db Im using covers all of my roasts and beans going back 6 years. Nice information to have. As with any other important data, make sure you do regular backups of it in multiple locations!



Java "Back that data up!" phile

Ahhh forgot about that, nice one Java "good call" phile

[GrahamK]

Re: Bean Storage Spreadsheet

No problems Mark.

However as mentioned :

These sorts of tasks are always handled and managed better in a DB anyway

If you can get the D/B up and running, its probabaly a better option. I set up the Workbook, because at the time there were a few things the D/B did not provide for me, and a lot I did not intend to use at the time. However after a time the spreadsheets get unwieldy, and need more maintenence.

GrahamK

[Dimal]

Re: Bean Storage Spreadsheet

Wasnt a criticism Graham, just a personal observation from my own personal experience managing data over many years (in a previous life)....

Mal.

[GrahamK]

Re: Bean Storage Spreadsheet

Wasnt a criticism Graham

No worries Mal, I did not take it as such, I agree with your observation.  [smiley=wink.gif]

[ijan]

Re: Bean Storage Spreadsheet

TS, uve got PM!