Brewing Spreadsheet - Home Brew Forums

Register Now!
Home Brew Forums > Home Brewing Beer > Brewing Software > Brewing Spreadsheet

Reply
 
Thread Tools
Old 01-11-2009, 07:40 PM   #1
albannach
Recipes 
 
Jul 2008
Georgia
Posts: 190
Liked 4 Times on 4 Posts



New member, long time lurker.

I use a Mac so I was never able to use ProMash or any other brewing software. Over the past year or two I've developed and refined this Excel Spreadsheet to do all my brewing calculations and recipe formulations. I thought I'd share it and see what everyone thinks. If enough people like it I could make some walkthroughs that demonstrate how to use it (I know from experience how difficult it can be to figure out someone else's spreadsheet).

Note: There are macros in the spreadsheet so don't be alarmed by Excel's macro warning. There are three macros, they just reset all the data in the spreadsheet and print the beer summary pages. If you don't like them, just select "Disable Macros" when it opens. I also included an OpenOffice version of the spreadsheet for those who don't have Excel. The macros in the OpenOffice version don't work, I don't know why.

Open office can be downloaded for free from here: http://www.openoffice.org/


Downloads are free, just scroll down and select the "File Factory basic service"

Matt's Brew Builder - Excel version:
http://www.filefactory.com/file/a017...er_3_excel_xls

Matt's Brew Builder - OpenOffice version:
http://www.filefactory.com/file/a18g...OpenOffice_ods


Feedback is appreciated, let me know what you think of it. I can make directions, improve the spreadsheet, or add new features if enough people like it. At worst, it's a free alternative to brewing software (maybe).

 
Reply With Quote
Old 01-11-2009, 08:51 PM   #2
albannach
Recipes 
 
Jul 2008
Georgia
Posts: 190
Liked 4 Times on 4 Posts


oops, should have put this in "Brewing Software". Sorry.

 
Reply With Quote
Old 01-11-2009, 09:00 PM   #3
craigd
 
craigd's Avatar
Recipes 
 
Oct 2008
Central Florida
Posts: 316
Liked 2 Times on 2 Posts


OK, some quick minor feedback from a geek that lives by spreadsheets. FWIW I used open office to test because I was using my Mac when I came across your post.

In your formulas, anywhere you have a value referenced on other lines it should be a named range so that lines can be added/inserted/deleted without compromising the spreadsheet's other calculations. For instance I used a big belgian as a test recipe to see what it would do and there weren't enough grain lines to handle the bill. Adding lines was a mess because the calcs include direct references to cells so I had to correct all the formulas after autofill.

On the Mash tab the bottom formula says volume in quarts but delivers the answer in gallons.

It would be nice if the brew builder would scale when you change the custom volume in the scaling tab so you could scale water to go with your scaled recipe.

Most thorough of the spreadsheets I have seen though - good work!
__________________
-Craig

 
Reply With Quote
Old 01-11-2009, 10:18 PM   #4
albannach
Recipes 
 
Jul 2008
Georgia
Posts: 190
Liked 4 Times on 4 Posts


I'll have to figure out how to do that cell reference thing. I didn't even know Excel could do that, but that would solve the fixed number of grains. I should also do that with the grain data so that anyone could add grains/adjuncts to the list.

I just noticed the step mashing typo. whoops!

I have tried to figure out a way to make the recipe scaling automatically change the recipe but have not yet succeeded.

I'm almost embarrassed at how sloppy it is but I've only learned Excel by playing around with it since I was 13, no formal training.

Thanks for the feedback

 
Reply With Quote
Old 01-12-2009, 04:22 AM   #5
craigd
 
craigd's Avatar
Recipes 
 
Oct 2008
Central Florida
Posts: 316
Liked 2 Times on 2 Posts


Cell reference is easy - highlight the cell and type over the cell reference (B5) with your reference name (VOL) and hit enter. You can then use VOL in place of B5 in formulas. You can also use the same to reference a whole range of values by highlighting them and doing the same thing...

I wouldn't call it sloppy at all - everyone needs a fresh eye to look at things sometimes...
__________________
-Craig

 
Reply With Quote
Old 02-13-2013, 04:20 PM   #6
AnimalHouseBrewery
Recipes 
 
Jan 2012
Wauconda, IL
Posts: 16
Liked 1 Times on 1 Posts


Anyone still have this? Looks like the link is broken. Thanks

 
Reply With Quote
Old 08-19-2013, 08:48 PM   #7
Pittvkyle7
Recipes 
 
Jul 2013
Posts: 2

I would like to have a copy as well

 
Reply With Quote
Old 08-22-2013, 06:07 AM   #8
DU99
HBT_LIFETIMESUPPORTER.png
 
DU99's Avatar
Recipes 
 
Aug 2013
Melbourne, Australia
Posts: 2,161
Liked 299 Times on 210 Posts


Dead link

 
Reply With Quote


Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Yet Another Brewing Spreadsheet Walker All Grain & Partial Mash Brewing 19 12-12-2009 01:31 AM
how to use spreadsheet Stubbs5150 Brew Science 2 08-30-2009 08:26 PM
I use my Excel Spreadsheet LS_Grimmy Brewing Software 15 08-07-2009 07:01 PM
Help with Palmer's RA Spreadsheet BigNastyBrew All Grain & Partial Mash Brewing 2 02-09-2009 09:44 PM
spreadsheet shrades Mead Forum 7 01-20-2009 12:57 AM


Forum Jump