Page 1 of 2 1 2 LastLast
Results 1 to 50 of 54
Like Tree1Likes

Thread: Roasting Guide Spreadsheet with Graph

  1. #1
    Senior Member
    Join Date
    Dec 2008
    Posts
    139

    Roasting Guide Spreadsheet with Graph

    Hi All,

    I thought I’d share my Coffee Roasting Guide / Excel Spreadsheet.

    Background:
    Ive taken a whole lot from coffee snobs over the years - I thought it was time to contribute something!

    I started roasting about 2 years ago - with 2 Breville popcorn makers. About 9 months ago I switched to the Corretto. The biggest challenge for me was working out exactly when to ramp the heat and when to back it off.

    My research and trials led me to designing this coffee roasting spreadsheet.
    The ‘Ideal Temp’ roast profile suits most roast I do – just change the values to suit your own profile.
    The ‘Current’ row is where I map my current roast, each minute I record the temperatures and try to keep them as close to the ‘Ideal Temp’ as possible.

    Anyhow – feel free to have a play, I’m interested in your feedback and hopefully this helps some beginners get started!

    Screenshot:


    Here’s the spreadsheet – just unzip the two files into the same folder. You will need macros enabled should you want to use the stopwatch!

    http://www.pivottechnology.com/hgbm/...preadsheet.zip


  2. #2
    CoffeeSnobs Owner Andy's Avatar
    Join Date
    Mar 2004
    Location
    Internet
    Posts
    15,207
    Blog Entries
    1

    Re: Roasting Guide Speadsheet with Graph


    Nice work Peter!

    Thanks for sharing, Im sure lots of roasters will love this.

  3. #3
    Senior Member flynnaus's Avatar
    Join Date
    May 2008
    Location
    Sydney
    Posts
    3,643

    Re: Roasting Guide Speadsheet with Graph

    Good one Peter.
    Im sure to give this a try when I get around to setting up my corretto. Care tio share what your corretto is made up of (including DMM assuming you are using one)

  4. #4
    Senior Member
    Join Date
    Dec 2008
    Posts
    139

    Re: Roasting Guide Speadsheet with Graph

    Thanks guys!

    Sure - my corretto setup is pretty standard - here are the specs:

    Bread Machine: Breville BB290, on Dough Cycle
    Heat Gun: Bosch PHG 630 DCE, digital control 50-630deg, 2000W
    DMM: Jaycar Digitech QM-1526 - with thermo probe.
    Cooling: Large 60cm Fan from BigW, use this to suck out the chaff during roast, and to cool the beans afterwards.

    The heat gun is mounted on an old guitar stand and the thermo probe is mounted about an inch from the base of the tin. I drilled a hole, fed it through and tied a knot to keep it in place.

    Ive tried a few heat guns, this has been the best - cant beat the digital control. It saves having to constantly adjust the distance from the beans - instead just increase or decrease the output temperature (increments of 10deg)

    Happy to take a few photos and post them if people are interested!

  5. #5
    Senior Member flynnaus's Avatar
    Join Date
    May 2008
    Location
    Sydney
    Posts
    3,643

    Re: Roasting Guide Speadsheet with Graph

    Yes please. Im curious how you use the exhaust fan for both blowing and cooling.

    Probably best added to a new thread or existing thread rather than this one that has now been made into a sticky post

    Many thanks
    Steve

  6. #6
    Mal Dimal's Avatar
    Join Date
    Oct 2004
    Location
    Warwick, QLD
    Posts
    15,201

    Re: Roasting Guide Speadsheet with Graph

    Gday pcf1978,

    Welcome to CoffeeSnobs mate..... [smiley=thumbsup.gif]

    Excellent roasting aid that Im sure lots of us will be taking advantage of. Great stuff mate 8-)

    Mal.

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

    Re: Roasting Guide Speadsheet with Graph

    Nice work Peter.

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

    Re: Roasting Guide Speadsheet with Graph

    Nice one Peter
    I have downloaded it
    Will give a go when the new roaster is built and running ;)
    Hopefully sooner than later

    KK

  9. #9
    Senior Member greenman's Avatar
    Join Date
    May 2007
    Location
    Perth, Western Australia
    Posts
    2,952

    Re: Roasting Guide Speadsheet with Graph

    Looks great Peter, I intend playing with it, I hope it loads onto my old laptop with Windows 98!
    Ive been running manual roast profiles so far and keeping them for reference.
    ajoesmith likes this.

  10. #10
    Senior Member greenman's Avatar
    Join Date
    May 2007
    Location
    Perth, Western Australia
    Posts
    2,952

    Re: Roasting Guide Speadsheet with Graph

    unzipped it on my main computer and transferred to laptop, works a treat!!

  11. #11
    Senior Member
    Join Date
    Dec 2008
    Posts
    139

    Re: Roasting Guide Speadsheet with Graph

    Hey greenman - glad to hear its working on Win98!!!

  12. #12
    Senior Member greenman's Avatar
    Join Date
    May 2007
    Location
    Perth, Western Australia
    Posts
    2,952

    Re: Roasting Guide Speadsheet with Graph

    I just ran through my roast profiles, my probe reads a bit lower than a lot of CSers profiles so Ive loaded in my average temps for each stage and will do a roast later, it should be great, Ill report back on result.
    I usually reach 1st crack around 185-190C on my DM, 2nd crack around 205-210Cish.
    Thanks for making this available Peter!!!

  13. #13
    Senior Member
    Join Date
    Dec 2008
    Posts
    139

    Re: Roasting Guide Speadsheet with Graph

    My pleasure! Yeah - each setup is going to report temperatures differently. As long as the readings are consistent, it doesnt matter - the profile still looks the same! Looking forward to your results!!

  14. #14
    Senior Member greenman's Avatar
    Join Date
    May 2007
    Location
    Perth, Western Australia
    Posts
    2,952

    Re: Roasting Guide Speadsheet with Graph

    Ive done several roasts using the software now.
    Ive gone through my profiles and the ones I repeat often I have done a save-as and made a file for that specific profile, I have several of these so that when I do a roast I just click on the profile I want to replicate and it comes up ready to go. If Im doing Monsoon Malabar I just click on that file and its ready to go.
    Once again thanks Peter!!!
    Have a great Christmas......................cheers from greenman

  15. #15
    Senior Member
    Join Date
    Dec 2008
    Posts
    139

    Re: Roasting Guide Speadsheet with Graph

    Good stuff greenman! Ive been thinking about building this feature into the one speadsheet - but I think your method works just as well, one file per profile - perfect!

    I do need to start sorting out my profiles, Ive been lazy and mostly using the one ideal for all roasts, maybe varying the length into second crack. I’m happy with the results - but Im sure they can be better with a personalised profile to bring out their best…

    Glad you’ve made use of the guide – have an awesome Christmas!

    cheers, pete

  16. #16
    Senior Member Pavoniboy's Avatar
    Join Date
    Jan 2009
    Location
    Minnamurra NSW
    Posts
    693

    Re: Roasting Guide Speadsheet with Graph

    Thanks a lot for this. I have just set up a coretto roaster and will be doing my first roast tomorrow with some Costa Rica Tarrazu. I believe this will be my guide, and a great tool to start logging my roasts.
    Ill make a post with some pics as to how my first roast got along. Thanks again.

  17. #17
    Senior Member
    Join Date
    Dec 2008
    Posts
    139

    Re: Roasting Guide Speadsheet with Graph

    Hi Pavoniboy, welcome to the world of corretto roasting!
    I look forward to seeing your results...

  18. #18
    Senior Member Pavoniboy's Avatar
    Join Date
    Jan 2009
    Location
    Minnamurra NSW
    Posts
    693

    Re: Roasting Guide Speadsheet with Graph

    The results are up! See my new thread: First roast - corretto with costa rica tarrazu.
    The guide worked well. My thermometer wasnt accurate so hit 2nd crack earlier than expected, I also didnt back off the heatgun enough at first crack - will remember to move it back more next time. But, overall went really well for a first roast. With these corrections I am very excited about the next roast. Thanks again - it did help a newbie get started.

  19. #19
    Member
    Join Date
    Nov 2004
    Posts
    48

    Re: Roasting Guide Speadsheet with Graph

    Thanks for the software, unfortunately I have no idea how to use it. I got my roast monitor software to work, but I cant make a graph in excell. The trouble is that I am doing all this in the garage where the hammer is dangerously close. *
    Does this software work with the roast monitor somehow?
    How do I get the saved file from the roast monitor to work in this software?
    If I had a rocket launcher!!!
    Thanks...
    Bruce...

  20. #20
    Senior Member
    Join Date
    Dec 2008
    Posts
    139

    Re: Roasting Guide Speadsheet with Graph

    Gday Bruce!

    The software is pretty elementary in that you just enter the temperatures manually as you roast. It doesnt link in with any other roast monitor software. Its stand alone.

    Basic instructions:
    Before roasting, you type in your ideal profile in the "Ideal Temp" row (green).
    Start timer, and during your roast, you log the temperature at 1 minute intervals "Current" row (red).

    Its really just a guide, not so much a retrospective tool.

    Hope this helps!

    Cheers,
    Pete


  21. #21
    Junior Member
    Join Date
    Jun 2007
    Location
    Buln Buln
    Posts
    26

    Re: Roasting Guide Spreadsheet with Graph

    Hey Pete,

    that software is really cool. Love the clean look of it too. Thanks for sharing.

    Al.

  22. #22
    CoffeeSnobs Owner Andy's Avatar
    Join Date
    Mar 2004
    Location
    Internet
    Posts
    15,207
    Blog Entries
    1

    Re: Roasting Guide Speadsheet with Graph

    Quote Originally Posted by Bruce link=1228795908/0#18 date=1231377629
    Thanks for the software, unfortunately I have no idea how to use it. I got my roast monitor software to work, but I cant make a graph in excell. The trouble is that I am doing all this in the garage where the hammer is dangerously close. *
    Does this software work with the roast monitor somehow?
    How do I get the saved file from the roast monitor to work in this software?
    If I had a rocket launcher!!!
    Thanks...
    Bruce...
    slightly off topic but it was in this thread so I will reply here (sorry)

    Hey Bruce,
    what you want is Intellidepths excel sheet in another thread. It was designed to work with the CoffeeSnobs Roast Monitor software that you are talking about...
    http://coffeesnobs.com.au/YaBB.pl?num=1214989367

    What Peter has posted here is a stand-alone "manual" solution that doesnt use a datalogging multi meter output.

    8-)

  23. #23
    Junior Member
    Join Date
    Jan 2009
    Posts
    2

    Re: Roasting Guide Spreadsheet with Graph

    Quote Originally Posted by 485B5E09010F00380 link=1228795908/0#0 date=1228795908
    Hi All,

    I thought I’d share my Coffee Roasting Guide / Excel Spreadsheet.

    Background:
    Ive taken a whole lot from coffee snobs over the years - I thought it was time to contribute something!

    I started roasting about 2 years ago - with 2 Breville popcorn makers. About 9 months ago I switched to the Corretto. The biggest challenge for me was working out exactly when to ramp the heat and when to back it off.

    My research and trials led me to designing this coffee roasting spreadsheet.
    The ‘Ideal Temp’ roast profile suits most roast I do – just change the values to suit your own profile.
    The ‘Current’ row is where I map my current roast, each minute I record the temperatures and try to keep them as close to the ‘Ideal Temp’ as possible.

    Anyhow – feel free to have a play, I’m interested in your feedback and hopefully this helps some beginners get started!

    Screenshot:


    Here’s the spreadsheet – just unzip the two files into the same folder. You will need macros enabled should you want to use the stopwatch!

    http://www.pivottechnology.com/hgbm/...preadsheet.zip
    thanks for sharing this pcf1978. Its good that somebody like yourself to prepare a graph like this. I can be an "expert" then. Just kidding
    :P

  24. #24
    Junior Member
    Join Date
    Jan 2009
    Posts
    12

    Re: Roasting Guide Spreadsheet with Graph

    Thanks for the spreadsheet! *This is one of the few places Ive seen recommendations on time vs. temp for roasting, most resources only talk about your roast progressing with temperature. *I roasted a batch with this profile yesterday, it smells better than my other batches but I havent brewed with it yet. *

    Are there any resources out there explaining the theory behind the slow ramp-up to first crack and then the long wait to second crack? *Id like to be able to intelligently alter my profile for different coffee varieties rather than using a single profile. *I own the book Home Coffee Roasting but it only discusses temperature and visuals.

    Edit: good links in this post: *http://coffeesnobs.com.au/YaBB.pl?num=1232283238... *

    Thanks!

    P.S. - the slow ramp up & hold made the effort of making my PIDd Correto worthwhile! *Previously I had brought it up to first crack as fast as possible and always had a rolling second crack.

  25. #25
    Mal Dimal's Avatar
    Join Date
    Oct 2004
    Location
    Warwick, QLD
    Posts
    15,201

    Re: Roasting Guide Spreadsheet with Graph

    Welcome David.... [smiley=thumbsup.gif]

    Id recommend reading through the "Ruling the Roast" chapters on this page.... http://www.bootcoffee.com/articles.html for the sort of information youre asking about. As youll see, there are no easy answers and a requirement to experiment with your profiles to learn as much as you can about the beans being roasted.

    Cheers mate :)
    Mal.

  26. #26
    Junior Member
    Join Date
    Jan 2009
    Posts
    10

    Re: Roasting Guide Spreadsheet with Graph

    Hey Folks

    First of all what a great idea, the spreadsheet has helped heaps as a new roaster having this as a guide is an invaluable tool. My question / idea for poaching others successs in roasting different beans is that if anyone has a printout for different roasts for the various bean types these could be posted as reference for others. Maybe not the entire graph but just the data input numbers so they can be transfered onto our own profiles, this might help us newbie roasters with a roasting formula so we might have an idea what they are meant to turn out like. get a bit of a data base started.

    Again fantastic idea pcf1978

    Cheers
    Craig


  27. #27
    Junior Member
    Join Date
    Mar 2009
    Posts
    29

    Re: Roasting Guide Spreadsheet with Graph

    very helpful, thanks - great posting

  28. #28
    Junior Member
    Join Date
    May 2005
    Posts
    8

    Re: Roasting Guide Spreadsheet with Graph

    Great work Peter - and thanks for sharing!

  29. #29
    Senior Member
    Join Date
    Jan 2008
    Location
    Brisbane, Queensland, Australia, Australia
    Posts
    1,756

    Re: Roasting Guide Spreadsheet with Graph

    Hey peter,
    Thanks for the spreadsheet, great idea, just one thing, im using office 2003 on vista, when i open the spreadsheet the timer pops up for a microsecond and then disappears? any ideas?
    cheers again!

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

    Re: Roasting Guide Spreadsheet with Graph

    Quote Originally Posted by 0A0E283131342B3C335D0 link=1228795908/28#28 date=1242740233
    Thanks for the spreadsheet, great idea, just one thing, im using office 2003 on vista, when i open the spreadsheet the timer pops up for a microsecond and then disappears? any ideas?

    I think you need to enable macros from memory

    KK

  31. #31
    A_M
    A_M is offline
    Guest
    Join Date
    Mar 2006
    Posts
    6,382

    Re: Roasting Guide Spreadsheet with Graph

    Quote Originally Posted by 6C684E5757524D5A553B0 link=1228795908/28#28 date=1242740233
    Hey peter,
    Thanks for the spreadsheet, great idea, just one thing, im using office 2003 on vista, when i open the spreadsheet the timer pops up for a microsecond and then disappears? any ideas?
    cheers again!
    Macros and security... In office 2007 it gets even worse as it runs in compatibility mode as well.

    Check for the Settings as to Disable with/without notification... For me I now have it set for disabled with notification. I then get an option to enable the macro for this run.. I select yes and then all is OK.

    Let us know how you go..


    Your in Brisy, so if teh Nth Side.. Let me know and I may be able to assist if you still get stuck.

    AM



  32. #32
    Senior Member
    Join Date
    Jan 2008
    Location
    Brisbane, Queensland, Australia, Australia
    Posts
    1,756

    Re: Roasting Guide Spreadsheet with Graph

    No luck, im pretty computer savvy and had changed the security before, i changed it to medium so it asks but no luck, i enable macros and it pops up for a split second and flashes off, i must admit i dont know too much about embedding flash apps though, really keen to pop this little spreadsheet on the laptop and do some roast profiles with it.........the missus is going to think ive completly lost the plot! I had a laugh
    cheers

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

    Re: Roasting Guide Spreadsheet with Graph

    Also try the un-zoom or smaller view as it may go off the page this happened to me

    KK

  34. #34
    A_M
    A_M is offline
    Guest
    Join Date
    Mar 2006
    Posts
    6,382

    Re: Roasting Guide Spreadsheet with Graph

    Quote Originally Posted by 456168686B6B5145617D63610E0 link=1228795908/32#32 date=1242804134
    Also try the un-zoom or smaller view as it may go off the page this happened to me

    KK
    AND

    Quote Originally Posted by 595D7B626267786F600E0 link=1228795908/31#31 date=1242803341
    No luck, im pretty computer savvy and had changed the security before, i changed it to medium so it asks but no luck, i enable macros and it pops up for a split second and flashes off, i must admit i dont know too much about embedding flash apps though, really keen to pop this little spreadsheet on the laptop and do some roast profiles with it.........the missus is going to think ive completly lost the plot! I had a laugh
    cheers
    Oh... Some times you may have to go to the security in IE or any other security package and allow the flash / shockwave app to run..

  35. #35
    Senior Member
    Join Date
    Dec 2008
    Posts
    139

    Re: Roasting Guide Spreadsheet with Graph

    Quote Originally Posted by 0501273E3E3B24333C520 link=1228795908/28#28 date=1242740233
    Hey peter,
    Thanks for the spreadsheet, great idea, just one thing, im using office 2003 on vista, when i open the spreadsheet the timer pops up for a microsecond and then disappears? any ideas?
    cheers again!
    Hmm - I did have this happen to me once on my garage pc. The solution in the end was to just to start with a fresh copy of the spreadsheet and stopwatch in a new folder - it seemed to run fine after that.... in the end I think it may have just got corrupted somehow.

    You do need macro settings at least on Medium.

    Let me know how you go!!
    Peter

  36. #36
    Junior Member
    Join Date
    Jun 2007
    Posts
    12

    Re: Roasting Guide Spreadsheet with Graph

    You know sometimes pen and paper are more convenient than a laptop or desktop around roasting equipment.

    You can print off that ideal profile and pencil in the temps by hand. Plenty of time to even graph it by hand, then you have a hard copy to file with any comments you like to make and other relevant notes as well.

    i know thats what Ill be doing , next roast.

    Thanks Peter. :)

  37. #37
    Junior Member
    Join Date
    Mar 2010
    Posts
    7

    Re: Roasting Guide Spreadsheet with Graph

    Thanks this is very helpful. Ive decided to get a roaster

  38. #38
    Senior Member nikko.the.scorpio's Avatar
    Join Date
    May 2008
    Location
    Coffs Harbour, NSW
    Posts
    131

    Re: Roasting Guide Spreadsheet with Graph

    Thanks this is exactly what I was about to do manually myself - much appreciated.

    Thanks for sharing.

    :-)

  39. #39
    Life-long Learner DesigningByCoffee's Avatar
    Join Date
    Aug 2008
    Location
    Millthorpe NSW
    Posts
    1,822

    Re: Roasting Guide Spreadsheet with Graph

    Quote Originally Posted by 7B49454A280 link=1228795908/35#35 date=1244946183
    You know sometimes pen and paper are more convenient than a laptop or desktop around roasting equipment.

    You can print off that ideal profile and pencil in the temps by hand. Plenty of time to even graph it by hand, then you have a hard copy to file with any comments you like to make and other relevant notes as well.
    Just the ticket. I like the pencil method too… but roasting is pretty new to me, so though I could share a few experiences - especially when borrowing PCF1978s profile above to get going!

    Here is my fairly recent Corretto rig. Really got into roasting when roasted beans from my preferred supplier got to $40kg - and now im hooked! A few shockers so far (8 minute roasts with pervading flavour of ash, or 40 minute, still underdone roasts!) , but now were getting somewhere.
    My setup therefore now consists of the following…

    • Basic BBM100 breadmaker (we replaced this old one with a brand new one for bread duties for $99!)
    • Ryobi bottom of the range 2000w heatgun ($49 from Bunnings)
    • Work light separated for lighting & tripod duties - graduated scale on the centre column marked for height adjustment recording (as heat gun itself is not adjustable)
    • Bean cooler - plastic bucket & exhaust fan from Bunnings (total about $30 - I splurged and got the expensive fan with ball bearings - $21). The colander is simply a $3 food cover from the local cheapo shop.
    • Andys multimeter & temp probe - the probe is held in place with a half chewed kids eraser, with an undersized hole drilled through the centre, held in place with gaffer tape - works a treat! The grippy eraser keeps it from moving about - but still allowed me to drill oversize holes for easy easy insertion/extraction through the three layers of breadmaker.
    • Corretto cover - this has made a massive difference! As our temperature range here in Millthorpe (near Orange NSW) can range from -7 overnight to only 5 during the day during winter, up towards 40 in summer, this will hopefully even things out a bit. It is simply an old spring form cake tin base, shaped over the bread pan with a kick at the back as an exhaust, a hardwood off-cut handle, and a tin can chimney - the chimney has really helped getting the gun height right without the fan blowing away all the heat before it gets into the pan.
    • Ive borrowed the great profile from PCF1978 above as a starting point, which Ive set up as a PDF to fill in by hand (Ive downloaded the roast monitor software, but Im entirely MAC based - and havent got it working yet - and this is quite fun with old pencil on the fly!).

    And after two roasts today (got the multimeter thursday) - pretty close on the money! The main adjustments once I have the basic height set (gun basically level with top of chimney) seems to be at first crack, which in future I think will consist of lifting the gun up about an inch, and turning the cooling fan from low up to high - enough air gets under the edge of the lid/across the chimney to keep the temp rise to about 1 degree per minute. Roast of about 18minutes all up - nice even colour and great aroma! Will see in a few days how it cups…

    Hope this helps!

    DBC




  40. #40
    Life-long Learner DesigningByCoffee's Avatar
    Join Date
    Aug 2008
    Location
    Millthorpe NSW
    Posts
    1,822

    Re: Roasting Guide Spreadsheet with Graph

    And another…


  41. #41
    Life-long Learner DesigningByCoffee's Avatar
    Join Date
    Aug 2008
    Location
    Millthorpe NSW
    Posts
    1,822

    Re: Roasting Guide Spreadsheet with Graph

    One more…


  42. #42
    Life-long Learner DesigningByCoffee's Avatar
    Join Date
    Aug 2008
    Location
    Millthorpe NSW
    Posts
    1,822

    Re: Roasting Guide Spreadsheet with Graph

    And the PDF of my hand drawn profile log - in case it helps!

    Happy roasting!

    DBC


  43. #43
    Life-long Learner DesigningByCoffee's Avatar
    Join Date
    Aug 2008
    Location
    Millthorpe NSW
    Posts
    1,822

    Re: Roasting Guide Spreadsheet with Graph

    And following another roast today - the file without typos :-)


  44. #44
    Junior Member
    Join Date
    Dec 2011
    Posts
    9
    Wow - Awesome!

  45. #45
    Member sando's Avatar
    Join Date
    Jul 2012
    Location
    Avalon NSW
    Posts
    82
    If anyone is interested in manually logging your roasts here are the Excel sheets that I use.
    They have evolved over the last 2 years and work for me.
    Even though I use the Data Logger and RML software I still do it manually.

    1. The ‘Manual Roasting Log’ is for filling in while roasting.
    I record the Blank spaces on the form.

    2. ‘After Roasting Form’ is for generating Graphs and transferring the info after roasting. Again fill in the blank spaces.

    I have all this info for every roast I have done. Looking back it helps in decisions I make and helps me make decisions for future roasts.

    Plus a graph is so much better than words.

    So if it helps…great.

    If you feel the need to discuss any aspects please PM me as I am always happy to learn more and make corrections.

    PM me if you want the Excel files as I am not sure how to attach them ??

    After Roast Form.PNGManual Roasting Form.PNG

  46. #46
    Member sando's Avatar
    Join Date
    Jul 2012
    Location
    Avalon NSW
    Posts
    82

    New Generic version of My Graphing Roast Data with a few fancy bells and whistles.

    Time for an updated version.
    Please see wish list in the instructions, if anyone can help please assist.

    cheers
    Sando

    Roast Data Graphing Excel.zip

    Generic Roast Data Graphing Excel.JPG
    Instructions.JPG

  47. #47
    Member sando's Avatar
    Join Date
    Jul 2012
    Location
    Avalon NSW
    Posts
    82

    Cool Final !! Upgrade of Roast Log and Graphing

    Final !! Upgrade of Roast Log and Graphing
    Complete package now includes:
    1.Manual Roasting Log v1.1
    2.After Roasting Graph v1.1

    Now with auto spotting of First and Second Crack and Temp on the graph line with Temp in deg C.
    This was on the wish list of previous version and resolved, thanks to an 'ExcelSnobs' type site..

    I hope you can adapt to your needs whatever they are.
    Click on Zip file and when downloaded open with browser (Internet Explorer) to unzip.
    If you have problems unzipping email me and I will send you the files with no zipping

    If you want any changes just let me know.
    Cheers
    Sando

    happy graphing

    Sample of Graph.JPG
    Attached Files Attached Files
    Last edited by sando; 12th February 2013 at 02:00 PM. Reason: typo

  48. #48
    Junior Member
    Join Date
    Apr 2013
    Posts
    6
    Great work sando!

  49. #49
    Member sando's Avatar
    Join Date
    Jul 2012
    Location
    Avalon NSW
    Posts
    82

    Compare Roasts and Templates

    Ever wanted to compare your previous roasts to a current one or a Past Roast Template??
    Or just compare Templates/Roasts...

    Graph with first crack and second crack and Temps will display.
    Over time this info is valuable if you are a nerd like me!!

    Well the result is an Excel 2010 file.
    Just Right Mouse click and use Windows Explorer to unzip the file.

    I have left a few of my roasts and Templates in so you can see how it works.

    If you are using my Manual Roasting Log etc (see earlier posts) it is easy to just copy the info over...
    If not ...Now is a good time ....

    Any suggestions, mods, info please PM me.

    Happy Roasting.
    Sando

    Click on and download the file then unzip
    Templates Comparisons CS.zip

    Compare.JPG
    Last edited by sando; 19th May 2013 at 03:59 PM. Reason: because

  50. #50
    Member sando's Avatar
    Join Date
    Jul 2012
    Location
    Avalon NSW
    Posts
    82
    Behmor Coffee Roaster
    Data Mining information from your roasting records!!
    No Mining Tax Payable !!

    After copying all my roast record info into the 'Compare Roast & Templates' data section the value of this information is a lot clearer.

    Sort the data by any of the columns available.

    To illustrate this pic shows my roasts #1 (the very first one), #50 (roughly 1year later), #110 and #111 the latest.
    It sure has settled down from wild all over the place to stable repeatable and very very nice results. IMHO.
    Fitting the USB Data Logger, the Bosch HG and also the insulating of the Corretto roaster have made huge changes and when looking back, that now sticks out in the info & graphs.
    Not to mention the help from all the CS community...tks

    So to all those who doubt the value of keeping roasting records, well reconsider as the results are well worth it in the end.
    It only takes a few minutes. Any info or help needed gladly given.

    Happy roasting.
    Sando

    Capture.JPG

Page 1 of 2 1 2 LastLast

Similar Threads

  1. Guide to Roasting...
    By CoffeeRoasters in forum Home Roasting - Tips, Tricks, Ideas
    Replies: 34
    Last Post: 20th April 2017, 02:14 PM
  2. roasting guide spreadsheet(fahrenheit)
    By stoss in forum Home Roasting - Tips, Tricks, Ideas
    Replies: 3
    Last Post: 14th April 2013, 10:30 PM
  3. Roasting - A Guide
    By andreasb in forum Home Roasting - Tips, Tricks, Ideas
    Replies: 19
    Last Post: 14th January 2011, 05:31 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
  •