Announcement

Collapse
No announcement yet.

Excel RoastMonitor Spreadsheet/Chart

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

  • #16
    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

    Comment


    • #17
      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.

      Comment


      • #18
        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

        Comment


        • #19
          Re: Excel RoastMonitor Spreadsheet/Chart

          thanks

          Comment


          • #20
            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

            Comment


            • #21
              Re: Excel RoastMonitor Spreadsheet/Chart

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

              Comment


              • #22
                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

                Comment


                • #23
                  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

                  Comment


                  • #24
                    This is great. Will help a lot!!!

                    Comment


                    • #25
                      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.

                      Comment


                      • #26
                        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

                        Comment


                        • #27
                          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

                          Comment

                          Working...
                          X