Results 1 to 12 of 12

Thread: Green Bean Tracking Spreadsheet

  1. #1
    Senior Member Coffee2Di4's Avatar
    Join Date
    Sep 2008
    Location
    Ipswich, QLD
    Posts
    1,472

    Green Bean Tracking Spreadsheet

    Gene Cafe Coffee Roaster $850 - Free Beans Free Freight
    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!

  2. #2
    Senior Member flynnaus's Avatar
    Join Date
    May 2008
    Location
    Sydney
    Posts
    4,025

    Re: Green Bean Tracking Spreadsheet

    Quote Originally Posted by 775046544C3F0 link=1259118260/0#0 date=1259118260
    A bit disappointed - I only have 16 varieties and 36 kilos of greens
    Lightweight ;D

    PM sent - thanks

  3. #3
    Senior Member Coffee2Di4's Avatar
    Join Date
    Sep 2008
    Location
    Ipswich, QLD
    Posts
    1,472

    Re: Green Bean Tracking Spreadsheet

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

  4. #4
    A_M
    A_M is offline
    Guest
    Join Date
    Mar 2006
    Posts
    6,381

    Re: Green Bean Tracking Spreadsheet

    Quote Originally Posted by 2A0D1B0911620 link=1259118260/2#2 date=1259118750
    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.

  5. #5
    Senior Member Coffee2Di4's Avatar
    Join Date
    Sep 2008
    Location
    Ipswich, QLD
    Posts
    1,472

    Re: Green Bean Tracking Spreadsheet

    All sent, young man... ;)

  6. #6
    Senior Member
    Join Date
    Jan 2009
    Posts
    366

    Re: Green Bean Tracking Spreadsheet

    Great idea young miss....pm sent

  7. #7
    Senior Member
    Join Date
    Mar 2009
    Posts
    547

    Re: Green Bean Tracking Spreadsheet

    Thats a great idea, PM sent

    Thanks

  8. #8
    Sleep is overrated Thundergod's Avatar
    Join Date
    Jul 2006
    Location
    Sydney
    Posts
    10,496

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

  9. #9
    Senior Member Coffee2Di4's Avatar
    Join Date
    Sep 2008
    Location
    Ipswich, QLD
    Posts
    1,472

    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)


  10. #10
    Sleep is overrated Thundergod's Avatar
    Join Date
    Jul 2006
    Location
    Sydney
    Posts
    10,496

    Re: Green Bean Tracking Spreadsheet

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

  11. #11
    Senior Member speleomike's Avatar
    Join Date
    Nov 2005
    Location
    Sydney
    Posts
    922

    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

    Code:
    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.



  12. #12
    Senior Member Koffee_Kosmo's Avatar
    Join Date
    Apr 2008
    Location
    Brisbane
    Posts
    5,113

    Re: Green Bean Tracking Spreadsheet

    Behmor Brazen - $249 - Free Freight
    Templates available on the Microsoft site as well

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

    KK



Similar Threads

  1. Bean Storage Spreadsheet
    By fivegallon in forum General Coffee Related...
    Replies: 13
    Last Post: 18th April 2011, 12:21 AM
  2. 2 Bean to Blend from Green Bean Sale
    By chalermchait in forum Blending Room
    Replies: 4
    Last Post: 9th December 2010, 03:21 PM
  3. Green Bean stock on hand spreadsheet/database needed...
    By cksyd in forum General Coffee Related...
    Replies: 7
    Last Post: 21st March 2009, 07:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •