Announcement

Collapse
No announcement yet.

Green Bean Tracking Spreadsheet

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Koffee_Kosmo
    replied
    Re: Green Bean Tracking Spreadsheet

    Templates available on the Microsoft site as well

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

    KK

    Leave a comment:


  • speleomike
    replied
    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.


    Leave a comment:


  • Thundergod
    replied
    Re: Green Bean Tracking Spreadsheet

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

    Leave a comment:


  • Coffee2Di4
    replied
    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)

    Leave a comment:


  • Thundergod
    replied
    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).

    Leave a comment:


  • Ronin
    replied
    Re: Green Bean Tracking Spreadsheet

    Thats a great idea, PM sent

    Thanks

    Leave a comment:


  • madpierre06
    replied
    Re: Green Bean Tracking Spreadsheet

    Great idea young miss....pm sent

    Leave a comment:


  • Coffee2Di4
    replied
    Re: Green Bean Tracking Spreadsheet

    All sent, young man...

    Leave a comment:


  • A_M
    replied
    Re: Green Bean Tracking Spreadsheet

    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.

    Leave a comment:


  • Coffee2Di4
    replied
    Re: Green Bean Tracking Spreadsheet

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

    Leave a comment:


  • flynnaus
    replied
    Re: Green Bean Tracking Spreadsheet

    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

    Leave a comment:


  • Coffee2Di4
    started a topic Green Bean Tracking Spreadsheet

    Green Bean Tracking Spreadsheet

    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!
Working...
X