FYI, there does not seem to be a way to delete a user-created blend of beans either on Roast World or in RoasTime.
I created a blend twice, because Roast World crashed the first time. Now, the blend is listed twice as a duplicate. The only option available to the user is to edit the blend, but not to delete it.
Also, I’m sure cafes will want to know if these blends are public or private. There should be a way to keep blends proprietary.
I am curious: Are you pre-roast blending? or Post roast blending?
I do most of my blending post-roast. I need to build (yet another) spreadsheet to track that.
I haven’t been relying on the inventory feature of Roast World. I need to do a physical inventory of the beans I have on hand and then correct the Inventory in Roast World.
I’ve successfully blended both pre- and post-roast coffees. A while back, I blended Brazilian and Ethiopian coffees that I had separately roasted. I used a 50/50 ratio and roasted them at different temperatures. The Brazilian was roasted at a medium roast, while the Ethiopian was roasted at a medium-light roast. Surprisingly, the blend was delicious on its own or in a cappuccino.
I also blended a pre-roast blend with Roast World to target chocolate flavors. I blended 50% Brazil, 25% Colombia, and 25% Nicaragua and took them to the right before SC. I haven’t tried it yet, but the aroma smells very promising!
However, I was disappointed when I discovered this blending feature in Roast World and then found all the odd limitations that make it impossible for me to use it.
How do you manage your blends in a spreadsheet? Are you using formulas connected to your inventory?
I do most of my blends post roast. Usually I have an idea of what I want to accomplish with flavors. and then will use roasts that I have already done and brew a cup or 2 of each roast. Then I will start with the roast that I want for my base and measure some of that into a new cup tracking the weight. Then I will add some of one of the blend components keeping track of the weight or that roast, and so on until I get the flavor profile that I want.
Then I can look at the weights of that components used an convert that to a ratio for the blend.
Back in May of last year I posted an experience that I had at a coffee café in St. Helena.
I have done a few blends where I used the same bean roasted to different levels to try to bring out some of the fruity characteristics.
I have bought a few blends from bean vendors that I like. One in particular is Coffee Bean Corral’s Red Sea Blend. they are pre-roast blending a Yemen natural beans with some Ethiopian natural beans.
It is reasonably priced and (for me) it gives me some of that mid-eastern old world earthiness that I find enjoyable.
In answer to the other part of your question: I am not currently tracking my bean inventory. I do have a spreadsheet that has a list of all of the purchases that I have made going back to the beginning of 2023.
I don’t roast commercially. But I do a lot of experimenting with roasting profiles and recipes. And I have some very well caffeinated neighbors and friends
I need to go through my physical inventory and weigh all of the beans I have on hand and then go into Roast World and correct the amounts shown in my Roast World inventory.
Tracking inventory with a spreadsheet and trying to link it to Roast world would be a very ambitious project.
I have changed my Roast naming convention so that the roast number is the first part of the name, Then the date of the roast, then the initials of the vendor, then the world origin of the beans and then the name that the vendor uses for sales, then pre-heat temp and then the Drop temp.
In my Roasts spreadsheet, I have a list of the names of the roasts which I copy and paste from Roast World. I also embed a screen capture of the roast profile from RoasTime into the cell so that the screen capture will pop up when I hover over the cell.
This is quite comprehensive! Thank you for sharing. I’ll probably start setting up something similar since the Roast World blend functionality is not that useful at the moment.
I am definitely developing a bias in favor of post-roast blending for flexibility in adjusting the different components.
(posts now need to be at least 50 characters … and my reply is too “quick” so I need to wait at least 5 mins to post … must be anti-bot and spam feature to combat the spam some of you may have noticed a week or so ago on the forum)