tmbdistillery Posted October 4, 2023 Share Posted October 4, 2023 I have been working on a mash recipe calculator for a couple days now and put it to use yesterday on a corn mash. I didn't get the efficiency I was hoping for and thought my formulas might be off. Any excel gurus out there that would like to take a peek at the sheet and see if I have my numbers correct? Its basic but I think it can certainly get the job done. I have attached the file so feel free to download and make changes. Things to pay attention to: 1. Math to figure diastatic power 2. General formulas 3. Suggestions on things to add Thanks! Mash Recipe Builder.xlsx Link to comment Share on other sites More sharing options...
richard1 Posted October 5, 2023 Share Posted October 5, 2023 Nice spreadsheet. Unfortunately, I need to go through and change / convert as I am metric orientated and personally struggle with other units. My only preliminary comment is your FG where you have indicated 0.98. Obviously ideal but I would have gone something like 1.002. My simple spreadsheet looks something like this. Link to comment Share on other sites More sharing options...
tmbdistillery Posted October 5, 2023 Author Share Posted October 5, 2023 Richard, That's a lot to chew through. Thanks for replying. Do you have this available for me to download so I can try and compare yours and mine? Thanks! Link to comment Share on other sites More sharing options...
Tom Lenerz Posted October 5, 2023 Share Posted October 5, 2023 Morning -- Not sure about your spreadsheet, but if you really used 850 pounds for 250 gallons of water you were too thick and your yield most likely has something to do with that. What size batch are you targeting? Do you have live steam or is this jacketed? Are you using a roller mill or is this hammer milled? Link to comment Share on other sites More sharing options...
tmbdistillery Posted October 5, 2023 Author Share Posted October 5, 2023 Tom, ignore the lbs of grain and water. I was just plugging in numbers to see how the formulas behaved. If my math(formulas) are correct then the water and adjuncts should adjust total est. gravity and DP accordingly. I am just asking for a few extra sets of eyes on the formulas. Yes, 850/250 would make it a thick mash however, in order to get the desired gravity and DP with my current formulas, that is what it is showing I need to have in the pot to get those results. Mash tun is steam jacketed and the corn is hammer milled through a 3/8 screen. The barley is from BSG and is crushed to a medium. My MT has a capacity of 300gal. Link to comment Share on other sites More sharing options...
ryanh Posted November 14, 2023 Share Posted November 14, 2023 I do my calculations an entirely different way, but for what it's worth: I plugged in our recipes into your calculator and the numbers aren't too far off of actual yields. Where in the process were you disappointed in the yield? What are the steps in your mashing process? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now