Announcement

Collapse
No announcement yet.

Excel RoastMonitor Spreadsheet/Chart

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

  • BirmansMad
    replied
    Originally posted by GrahamK View Post
    Hi BMad,

    Welcome to CoffeeSnobs

    I ceased using my version of the spreadsheet, which derived its data from Andy's original CS Monitor output. CS Monitor has moved on quite a lot from those days (2009), including the ability to take a jpeg snapshot of the screen, RML programming ability, and a number of extra output columns, which basically made the spreadsheet redundant to some degree. (To use the CS Monitor you will need the meter and fit a thermocouple etc).

    There is also the "Behmor Thing software", which I believe is free, and which may be something you could make use of? (An internet search should find it)

    I can dig out an old version of the original workbook if you would still like it, but it would need some changes to make it work for you, and I cannot find the version for which I included instructions mentioned my post in 2009 unfortunately. (PM me if you still want it).

    GrahamK
    Thanks Graham. I will search for the Behmor software and use the spreadsheet provided by another user (forgot their name!) in this thread for the time being just to get my head around roasting. Then the plan is to get the CS software & meter happening - once I know what I am doing! BMad

    Leave a comment:


  • GrahamK
    replied
    Hi BMad,

    Welcome to CoffeeSnobs

    I ceased using my version of the spreadsheet, which derived its data from Andy's original CS Monitor output. CS Monitor has moved on quite a lot from those days (2009), including the ability to take a jpeg snapshot of the screen, RML programming ability, and a number of extra output columns, which basically made the spreadsheet redundant to some degree. (To use the CS Monitor you will need the meter and fit a thermocouple etc).

    There is also the "Behmor Thing software", which I believe is free, and which may be something you could make use of? (An internet search should find it)

    I can dig out an old version of the original workbook if you would still like it, but it would need some changes to make it work for you, and I cannot find the version for which I included instructions mentioned my post in 2009 unfortunately. (PM me if you still want it).

    GrahamK

    Leave a comment:


  • BirmansMad
    replied
    Spreadsheet

    Originally posted by Kevinjspark View Post
    This is great. Will help a lot!!!
    Can someone who has this spreadsheet please attach a copy as I would like to have a squiz. I am about to purchase a Behmor and enter this wonderfully mysterious coffee roasting world. Some earlier posts of this spreadsheet looks like it could be a valuable tool for me to use.
    Thanks a lot.

    Leave a comment:


  • Kevinjspark
    replied
    This is great. Will help a lot!!!

    Leave a comment:


  • four_ad
    replied
    Re: Excel RoastMonitor Spreadsheet/Chart

    Originally posted by 16312B3A3333363B3A2F2B375F0 link=1214989367/0#0 date=1214989367
    Hi,

    Attached is an Excel spreadsheet/charting tool you can use for your downloaded RoastMonitor .csv data.  Instructions are contained in the spreadsheet.

    My humble thanks goes to NewToEspresso for the original spreadsheets that Ive modified slightly to hopefully suit most CSers roast profiles and data needs.

    If you have any improvements, please feel free to make them and upload your version  

    (Whilst it is possible to have the events automatically noted on the datapoints, it also puts a zero at every other datapoint making the chart unreadably messy. So for simplicity graphic boxes and arrow connectors have been used instead.)

    Best regards,
    Intellidepth

    Thank you

    Leave a comment:


  • Gra
    replied
    Re: Excel RoastMonitor Spreadsheet/Chart

    Originally posted by 2510030A030F29620 link=1214989367/19#19 date=1257235457
    Unfortunately it was developed in Excel 2007 (xlsx) format, and when I tried to save it to the older (xls) version it came up with too many incompatabilities so you will need Excel 2007.

    Will also open in OpenOffice.org...

    Cheers Gra

    Leave a comment:


  • gregpullman
    replied
    Re: Excel RoastMonitor Spreadsheet/Chart

    Fantastic work Graham, thanks very much! [smiley=thumbsup.gif]

    Leave a comment:


  • GrahamK
    replied
    Re: Excel RoastMonitor Spreadsheet/Chart

    Following a reply to a recent post on roasting with a Hottop where I provided a sample output chart, I was asked if I could provide my version of the Excel spreadsheet, which to be honest was developed from the one posted here originally. Therefore here I provide my updated version of the Excel workbook. Unfortunately it was developed in Excel 2007 (xlsx) format, and when I tried to save it to the older (xls) version it came up with too many incompatabilities so you will need Excel 2007.

    I have included a Worksheet of instructions, and it should open on that first.

    have fun

    Graham

    Leave a comment:


  • blackbean
    replied
    Re: Excel RoastMonitor Spreadsheet/Chart

    thanks

    Leave a comment:


  • sugilun
    replied
    Re: Excel RoastMonitor Spreadsheet/Chart

    But the graph starts at 1 on the x-axis instead of 0. How can i make it starts at 0 min?

    O got it ! dont worry about answering~~~
    Thx a lot~~~It rocks!!!I love it

    Leave a comment:


  • Intellidepth
    replied
    Re: Excel RoastMonitor Spreadsheet/Chart

    Hi Tony, Ive been unwell, just noticed your post. Ill respond here in case others have the same question, and send you a PM to notify you.

    For the purpose of a simple graph, not using RoastMonitor software but just inputting the basic data by hand:

    1) delete the information in columns A and C, and the formulas in D.
    2) input each minute number 1-30 down Column D.
    3) input the temperature for each minute in Column B on the same row as the corresponding minute it relates to.
    4) optional: input the event name (first crack, second crack) next to the minute it happened in Column C. This doesnt automatically appear on the graph - its just a reference point for you to go and play around with the labels on the graph later. You can then go to to the graph, and move the graphic "event" boxes and arrows around physically with your mouse to match.

    Hope this helps.

    Leave a comment:


  • sugilun
    replied
    Re: Excel RoastMonitor Spreadsheet/Chart

    I have lots of trouble using this graph. Im confused about the columes in spread sheet 2. Especially, the one about "time converted to min". CAn someone teach me how to use it? Or this excel file is only build for the roasting sofeware? As my thermometer doesnt connect to my PC, I have to manually input my data into the spread sheet. I record my temp every minute. Also, I cant event put in where FC is and stuff like that. Can anyone teach me how to do it?

    Many thanks,

    Tony

    Leave a comment:


  • Ollie
    replied
    Re: Excel RoastMonitor Spreadsheet/Chart

    Thanks for supplying the spreadsheet Intellidepth.
    Ive tried to create one myself with no luck. This is super.

    Cheers
    Ollie

    Leave a comment:


  • sdg
    replied
    Re: Excel RoastMonitor Spreadsheet/Chart

    Aha -- figured it would be something like that -- thanks guys

    Leave a comment:


  • Intellidepth
    replied
    Re: Excel RoastMonitor Spreadsheet/Chart

    Hi Simone, the third column stores labels like "Load" "First Crack" etc, activated by the user of the RoastMonitor software as the roast goes along by clicking on a button on-screen during the roast cycle. Its part of the data automatically saved by RoastMonitor.

    Youre right: the chart doesnt use them, however I kept that column there as an easy reference for the user to adjust the graphic arrows to the right data point.

    Leave a comment:

Working...
X