Originally posted by GrahamK
View Post
Announcement
Collapse
No announcement yet.
Excel RoastMonitor Spreadsheet/Chart
Collapse
X
-
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
- Flag
-
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
- Flag
Leave a comment:
-
Spreadsheet
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.Originally posted by Kevinjspark View PostThis is great. Will help a lot!!!
Thanks a lot.
- Flag
Leave a comment:
-
Re: Excel RoastMonitor Spreadsheet/Chart
Originally posted by 16312B3A3333363B3A2F2B375F0 link=1214989367/0#0 date=1214989367Hi,
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
- Flag
Leave a comment:
-
Re: Excel RoastMonitor Spreadsheet/Chart
Originally posted by 2510030A030F29620 link=1214989367/19#19 date=1257235457Unfortunately 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
- Flag
Leave a comment:
-
Re: Excel RoastMonitor Spreadsheet/Chart
Fantastic work Graham, thanks very much! [smiley=thumbsup.gif]
- Flag
Leave a comment:
-
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
- Flag
Leave a comment:
-
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
- Flag
Leave a comment:
-
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.
- Flag
Leave a comment:
-
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
- Flag
Leave a comment:
-
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
- Flag
Leave a comment:
-
Re: Excel RoastMonitor Spreadsheet/Chart
Aha -- figured it would be something like that -- thanks guys
- Flag
Leave a comment:
-
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.
- Flag
Leave a comment:

Leave a comment: