Green Bean Tracking Spreadsheet

[Coffee2Di4]

So, at home with the little tacker today and hes quite self-sufficient - at 3.75 years of age! - so thought Id get myself organised before I headed off to the Sunny Climes of Brisvegas in around 3.5 weeks time (eek!)

I created a spreadsheet in Excel of all the BeanBay Bean Descriptors (ie; the name of the Bean & Andys notes from the announcement) that appeared from September 2008 onwards and their offered month.  Then another column for whether I had some (how much?), my roast rating (in stars: ie; 5 stars for a great one) and then any comments (ie; get again if offered).

I then went through my cupboards and counted each lot and made a tally of around how much I had of how many varieties and put that in the tally column so I could keep track.

A bit disappointed - I only have 16 varieties and 36 kilos of greens -  I thought I had much more quantity and variety than that!

A really good exercise, though - one of the reasons I did it is because I know that theres beans there that I have bought in the past year and have tossed into the cupboard and not touched since.  It will make me identify different ones to roast up instead of just using my favourites to death or until they are gone.

Obviously, Im not trying though and have some seriously purchasing of beans to do once Im settled up in Qld!

Mind you, I blame Pete since as of a couple of months ago, he started making rude comments about how I had enough sandbags to stop  a flood around our house and I better start limiting my stocks due to our move...  [smiley=angry.gif]

If anyone would like a copy of the spreadsheet, PM me with your email address and I can send out if it would be helpful - if nothing else than a tool to see whats been offerred in the past.

Cheers
Di
(Not-Enough-Coffee2Di4-Must-Have-More!)

PS - Mods, if you think this would be more appropriate in Roasting or another area, please feel free to move!

[flynnaus]

Re: Green Bean Tracking Spreadsheet

A bit disappointed - I only have 16 varieties and 36 kilos of greens

Lightweight ;D

PM sent - thanks

[Coffee2Di4]

Re: Green Bean Tracking Spreadsheet

I know - Im almost embarrassed to admit to it!!! :-[

[A_M]

Re: Green Bean Tracking Spreadsheet

I know - Im almost embarrassed to admit to it!!!  :-[  

Dont.. I must be a feather weight these days... down to about 12kg ;D

Yes please as to teh spreadsheet.

[Coffee2Di4]

Re: Green Bean Tracking Spreadsheet

All sent, young man...

[madpierre06]

Re: Green Bean Tracking Spreadsheet

Great idea young miss....pm sent

[Ronin]

Re: Green Bean Tracking Spreadsheet

Thats a great idea, PM sent

Thanks

[Thundergod]

Re: Green Bean Tracking Spreadsheet

Di please send me a copy.
I can send you a copy of mine too if you like.
Im not at home at the moment but mine might have some of Andys descriptors from further back.

P.S. My record is 24 varieties and +100kg - almost one for each letter of the alphabet (I didnt have any A or Z).

[Coffee2Di4]

Re: Green Bean Tracking Spreadsheet

No problems - actually, Ive just realised that the attachment area below is not just for photos (yep, Im really quick off the mark! )

Here go, everyone - if anyones got tweaks that theyd like to suggest, fire away...

Cheers
Di

(E&OE)

[Thundergod]

Re: Green Bean Tracking Spreadsheet

Thanks Di.
Ill dig mine out soon (busy weekend).

[speleomike]

Re: Green Bean Tracking Spreadsheet

Hi all

Instead of a spreadsheet Im using an Sqlite database. http://www.sqlite.org/
Its a database contained in a single file and you can view and edit it using a Firefox plugin or the sqlitebrowser program available on Linux or Windows or via command line. The latter is really useful, e.g. below is a list of what green beans I have at present and their amounts.
I have two tables in the database; beans and roasts.
Table beans: name, continent, description, stock, batch, roast_notes.
Table roasts: roast_date,temp,time,quantity,ambient_temp,fc,fc_c omments,sc,sc_comments, temp_profile,roast_comments, cs_level,taste_comments, grinder_setting

Aceh Arabica Gr1 Wet Hulled  1.6       
Aceh Gajah Mountain Grade 1  1.7       
Brazil Cafezinho Bourbon     2.5       
Brazil Cafezinho Bourbon     2.5       
Brazil Ipanema Reserva Espe  2.5       
Brazil Original Bourbon      2.5       
Brazil Sweet Naturals        1.0       
Brazil Yellow Bourbon        0.4       
Colombian Caracolito Peaber  2.2       
Colombian Volcan Galeras Su  1.5       
Costa Rica Tarrazu Dota Coo  0.9       
Cuban Altura                 0.8       
Dem. Rep. of the Congo Mata  2.5       
El Salvadore  El Boqueron c  2.0       
El Salvadore San Emilio Far  0.5       
Ethiopia Kuzu                2.5       
Ethiopian Gambella Sundried  2.0       
Ethiopian Harar Longberry O  2.1       
Ethiopian Limmu              2.2       
Ethiopian Sidamo Koratie     2.5       
Ethiopian Yirgacheffe        1.8       
Guatemala Huehuetenango      2.5       
Honduras Los Bancos          2.5       
India Plantation A Grade     2.5       
Indian Chikmagalur A         1.3       
Indian Madikeri A            2.5       
Indian Monsooned Malabar AA  1.7       
Indian Mysore Nuggets A      1.3       
Java Blawan Estate WP1       2.5       
Mexican Jaltenango HG        0.7       
Mexican Vercruz HG Organic   1.8       
Mexico Cofre de Perote       2.5       
Mountain Top Estate Bin 35   0.7       
Mountain Top Estate Bin 478  1.0       
Mountain Top Estate Bin 549  1.6       
Nicaragua Finca Dipilto SHG  2.5       
Nicaragua High Grown Bold    1.0       
Nicaragua Ramacafe Fine Est  2.4       
PNG Gouno Highlands          2.5       
PNG Gouno Highlands          2.5       
PNG Jiwaka Peaberry          1.7       
PNG Wahgi AA                 1.0       
PNG Wahgi AA                 2.5       
Panama Boquete Bajo Volcanc  2.5       
Peru Ceja de Selva Estate    2.5       
Peru Ceja de Selva Estate    2.4       
Rwanda Karongi A             2.0       
Sumatra Blue Lintong         2.1       
Sumatra Mandheling Mystic T  2.5       
Uganda Busamaga              2.5       
Yemen Bani Ismail            2.5

61 unique beans totalling 98 kgs.

If anyone wants the sqlite db I can email it to them. Just ask.

[Koffee_Kosmo]

Re: Green Bean Tracking Spreadsheet

Templates available on the Microsoft site as well

http://office.microsoft.com/en-au/templates/CT101172541033.aspx

KK