Spike Brewing 12.5 Conical Fermenter Giveaway - Enter Now!

Home Brew Forums > Home Brewing Beer > Brewing Software > Brewing Spreadsheet

Reply
 
LinkBack Thread Tools
Old 01-11-2009, 06:40 PM   #1
albannach
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jul 2008
Location: Georgia
Posts: 203
Liked 3 Times on 3 Posts
Likes Given: 1

Default Brewing Spreadsheet

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/a0177a9/n/Brew_Builder_3_excel_xls

Matt's Brew Builder - OpenOffice version:
http://www.filefactory.com/file/a18g8f4/n/Brew_Builder_3_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).

__________________
albannach is offline
 
Reply With Quote Quick reply to this message
Old 01-11-2009, 07:51 PM   #2
albannach
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jul 2008
Location: Georgia
Posts: 203
Liked 3 Times on 3 Posts
Likes Given: 1

Default

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

__________________
albannach is offline
 
Reply With Quote Quick reply to this message
Old 01-11-2009, 08:00 PM   #3
craigd
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Central Florida
Posts: 318
Liked 2 Times on 2 Posts

Default

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

craigd is offline
 
Reply With Quote Quick reply to this message
Old 01-11-2009, 09:18 PM   #4
albannach
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jul 2008
Location: Georgia
Posts: 203
Liked 3 Times on 3 Posts
Likes Given: 1

Default

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

__________________
albannach is offline
 
Reply With Quote Quick reply to this message
Old 01-12-2009, 03:22 AM   #5
craigd
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2008
Location: Central Florida
Posts: 318
Liked 2 Times on 2 Posts

Default

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

craigd is offline
 
Reply With Quote Quick reply to this message
Old 02-13-2013, 03:20 PM   #6
AnimalHouseBrewery
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2012
Location: Wauconda, IL
Posts: 16
Liked 1 Times on 1 Posts

Default

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

__________________
AnimalHouseBrewery is offline
 
Reply With Quote Quick reply to this message
Old 08-19-2013, 08:48 PM   #7
Pittvkyle7
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jul 2013
Posts: 2
Default

I would like to have a copy as well

__________________
Pittvkyle7 is offline
 
Reply With Quote Quick reply to this message
Old 08-22-2013, 06:07 AM   #8
DU99
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
DU99's Avatar
Recipes 
 
Join Date: Aug 2013
Location: Melbourne WEST, Victoria
Posts: 109
Liked 17 Times on 8 Posts
Likes Given: 38

Default

Dead link

__________________
DU99 is offline
 
Reply With Quote Quick reply to this message
Reply


Quick Reply
Message:
Options
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 12: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 08:44 PM
spreadsheet shrades Mead Forum 7 01-19-2009 11:57 PM