Re: Bean Storage Spreadsheet
TS, uve got PM!
Announcement
Collapse
No announcement yet.
Bean Storage Spreadsheet
Collapse
X
-
Re: Bean Storage Spreadsheet
No worries Mal, I did not take it as such, I agree with your observation. [smiley=wink.gif]Originally posted by 163B3F333E520 link=1299977613/11#11 date=1300085493Wasnt a criticism Graham
- Flag
Leave a comment:
-
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.
- Flag
Leave a comment:
-
Re: Bean Storage Spreadsheet
No problems Mark.
However as mentioned :
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.Originally posted by 4B66626E630F0 link=1299977613/8#8 date=1300023523These sorts of tasks are always handled and managed better in a DB anyway
GrahamK
- Flag
Leave a comment:
-
Re: Bean Storage Spreadsheet
Ahhh forgot about that, nice one Java "good call" phileOriginally posted by 4A6176617068696C65000 link=1299977613/7#7 date=1300016463You might try Open Office. It may very well be able to deal with the db for free.Originally posted by 6867786B696F626261600E0 link=1299977613/6#6 date=1300002473i dont have Access with my 2007 version of office.
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
- Flag
Leave a comment:
-
Re: Bean Storage Spreadsheet
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-)Originally posted by 775C4B5C4D555451583D0 link=1299977613/7#7 date=1300016463You might try Open Office. It may very well be able to deal with the db for free.
Mal.
- Flag
Leave a comment:
-
Re: Bean Storage Spreadsheet
You might try Open Office. It may very well be able to deal with the db for free.Originally posted by 6867786B696F626261600E0 link=1299977613/6#6 date=1300002473i dont have Access with my 2007 version of office.
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
- Flag
Leave a comment:
-
Re: Bean Storage Spreadsheet
technical glitch forced a reboot...Originally posted by 42697E69786061646D080 link=1299977613/3#3 date=1299985057Heres 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
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
- Flag
Leave a comment:
-
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
- Flag
Leave a comment:
-
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
- Flag
Leave a comment:
-
Re: Bean Storage Spreadsheet
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 alsoOriginally posted by 6257444D44486E250 link=1299977613/1#1 date=1299980433Not 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
Mostly i wanted it just to track bean purchases but having the roasting side also would be a bonus.
- Flag
Leave a comment:
-
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
- Flag
Leave a comment:
-
Bean Storage Spreadsheet
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.Tags: None
- Flag

Leave a comment: