Nice work Peter!
Thanks for sharing, Im sure lots of roasters will love this.
I thought I’d share my Coffee Roasting Guide / Excel Spreadsheet.
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!
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!
Nice work Peter!
Thanks for sharing, Im sure lots of roasters will love this.
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)
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!
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
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-)
Nice work Peter.
Nice one Peter
I have downloaded it
Will give a go when the new roaster is built and running ;)
Hopefully sooner than later
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.
unzipped it on my main computer and transferred to laptop, works a treat!!
Hey greenman - glad to hear its working on Win98!!!
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!!!
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!!
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
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!
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.
Hi Pavoniboy, welcome to the world of corretto roasting!
I look forward to seeing your results...
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.
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!!!
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.
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!
that software is really cool. Love the clean look of it too. Thanks for sharing.
slightly off topic but it was in this thread so I will reply here (sorry)Originally Posted by Bruce link=1228795908/0#18 date=1231377629
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...
What Peter has posted here is a stand-alone "manual" solution that doesnt use a datalogging multi meter output.
thanks for sharing this pcf1978. Its good that somebody like yourself to prepare a graph like this. I can be an "expert" then. Just kiddingOriginally Posted by 485B5E09010F00380 link=1228795908/0#0 date=1228795908
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... *
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.
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 :)
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
very helpful, thanks - great posting
Great work Peter - and thanks for sharing!
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?
Originally Posted by 0A0E283131342B3C335D0 link=1228795908/28#28 date=1242740233
I think you need to enable macros from memory
Macros and security... In office 2007 it gets even worse as it runs in compatibility mode as well.Originally Posted by 6C684E5757524D5A553B0 link=1228795908/28#28 date=1242740233
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.
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
Also try the un-zoom or smaller view as it may go off the page this happened to me
ANDOriginally Posted by 456168686B6B5145617D63610E0 link=1228795908/32#32 date=1242804134
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..Originally Posted by 595D7B626267786F600E0 link=1228795908/31#31 date=1242803341
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.Originally Posted by 0501273E3E3B24333C520 link=1228795908/28#28 date=1242740233
You do need macro settings at least on Medium.
Let me know how you go!!
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. :)
Thanks this is very helpful. Ive decided to get a roaster
Thanks this is exactly what I was about to do manually myself - much appreciated.
Thanks for sharing.
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!Originally Posted by 7B49454A280 link=1228795908/35#35 date=1244946183
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!
And the PDF of my hand drawn profile log - in case it helps!
And following another roast today - the file without typos :-)
Wow - Awesome!
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
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.
Sample of Graph.JPG
Last edited by sando; 12th February 2013 at 02:00 PM. Reason: typo
Great work sando!
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.
Click on and download the file then unzip
Templates Comparisons CS.zip
Last edited by sando; 19th May 2013 at 03:59 PM. Reason: because
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.