Quantcast

Lets see your brewing Excel Spreadsheets

HomeBrewTalk.com - Beer, Wine, Mead, & Cider Brewing Discussion Community.

Help Support Homebrew Talk:

LS_Grimmy

Well-Known Member
Joined
Nov 30, 2006
Messages
294
Reaction score
6
Location
Cold Lake , Alberta
Howdy,

I've been working on my Excel Spreadsheet on and off for about a year and during creation I have ran into a few fellas also making a brewing spreadsheet. I was wondering if anyone else has created their own and if so I would love to see it.

Here is mine below:
Excel Brewers Spreadsheet




Cheers,
Grimmy
 

Lil' Sparky

Cowboys EAC
Joined
Feb 6, 2006
Messages
3,952
Reaction score
91
Location
Honolulu, HI
I first thought about doing something like this and discovered that BeerSmith (or Pro Mash, BTP, etc.) are out there, and decided it wasn't worth it. I really like BeerSmith!

Cool spreadsheet, though!
 

FlyGuy

Well-Known Member
Joined
Jan 13, 2007
Messages
3,604
Reaction score
219
Location
Calgary, Alberta
I use Beersmith primarily too, but I did do up a little spreadsheet for calculating batch sparge water ratios. Beersmith is OK if your sparge water greatly exceeds your first runnings (it will calculate the required equal volumes for two or more sparges). But if you are limited on sparge water, then it is best (at least on my system) to get your sparge water volume to equal the first runnings, and Beersmith doesn't do this yet. I also do a mash-out infusion, and I don't like the way Beersmith handles that for batch sparges.

So, I did up a quick spreadsheet to calculate a mash-out volumes that achieve equal first and second runnings for single-sparge batch sparges. You can find it View attachment Batch Sparge Water Calculator.zip.
 

DeathBrewer

Maniacally Malty
Lifetime Supporter
Joined
Apr 9, 2007
Messages
21,788
Reaction score
314
Location
Oakland, CA
i made one simply for ABV, attenuation and calculating extract additions for partial mashes. i still use it sometimes, but i never went any further. ProMash does everything i need.

 
OP
LS_Grimmy

LS_Grimmy

Well-Known Member
Joined
Nov 30, 2006
Messages
294
Reaction score
6
Location
Cold Lake , Alberta
orfy said:
There is an old thread some where full of links.
You or I started it IIRC.

Yours is very similar to mine. I gave up >beersmith.

Hey Orfy... Ya I was looking around for it but couldn't find it so figured I would make another post. Glad to hear from ya again
 

razyrsharpe

Well-Known Member
Joined
Feb 25, 2007
Messages
421
Reaction score
26
Location
Lugoff, SC
well, these are all really impressive, and i am sincere in that, but you math oriented guys are making my head hurt.
 

SayWhat1

Well-Known Member
Joined
Feb 23, 2007
Messages
64
Reaction score
0
Location
Seaside, CA
FlyGuy said:
As a math major that just made me wet my pants. I've always wondered if there was an easy way to figure how many calories were in my beer. Most of my family are health nuts so they're always asking. My old standard when they asked how much sugar, etc. are in my beer I always told them at the whole point of beer is to turn the sugar into alcohol and that they shouldn't worry about it, but now I can wave numbers in front of them!
 
OP
LS_Grimmy

LS_Grimmy

Well-Known Member
Joined
Nov 30, 2006
Messages
294
Reaction score
6
Location
Cold Lake , Alberta
Yup good old beer math!

I'm actually not much of a math geek, but for some reason I really enjoy doing the beer math. Anyway glad I could help you find a calculation you needed. I put the site up because I was looking all over the web for these calculations. I finally decided to make one site for all brewing math so to make life easier for myself but for the most part others getting into brewing.

Anyway best of luck brewing!
Grimmy
 

85 Haro Designs

Well-Known Member
Joined
Jan 4, 2008
Messages
91
Reaction score
0
Location
Central PA
Wow, as a noob I checked out the first few formulas and my nose began bleeding profusely.

Mr. Beer sure doesn't know about "degrees of Plato".

(holding nose up in the air)

Really cool stuff however, hopefully someday I'll understand.
 

weetodd

Well-Known Member
Joined
Oct 30, 2006
Messages
197
Reaction score
1
Location
Seattle. WA
Grimmy: that is a nice worksheet. I'm pretty good at Excel but can't figure out how you have done the SRM color to update automatically. Any hints?
 
OP
LS_Grimmy

LS_Grimmy

Well-Known Member
Joined
Nov 30, 2006
Messages
294
Reaction score
6
Location
Cold Lake , Alberta
Howdy,

Well I'm sure you could do it an easier way but this is how I did it....

First I found an SRM chart ranging in colour from 1-30. Then I did a crop and made a seperate image with the same dimensions and named them 1-30.

Next I inserted each image into the spreadsheet but I placed them ontop of each other exactly. This way I could hide 29 of the images that I don't want to show, and only show the one image (srm colour) I wanted.

Now I wrote a little visual basic code to get the images to show/hide by using the image.visible=true or image.visible=false. Hopefully you know a little Visual Basic to get you by. Now the trick was to get the cell srm number into my code from the spreadsheet. The only way I got it to work was create a list box and link the cell to the combobox. Then use the combobox1.value in my code. Now what I did was create a bunch of nested if statements like the example below:

If Combobox1.value <=1 Then
image1.visible = True
image2.visible = false
image2.visible = false
ect....ect... until 30 is reached

else If Combobox1.value <=2 Then
Image1.visible = false
Image2.visible = true
Image3.visible = false
ect....ect.... until 30 is reached

else if Combobox1.value <=3 then
BLAH BLAH BLAH all the way to 30

end if



Hopefully this helps you. I'm sure you can figure out an easier way to get it to work.

If you have any questions feel free to contact me by email at [email protected] :)

Best of Luck,
Grimmy
 

millerhd

New Member
Joined
Oct 24, 2010
Messages
1
Reaction score
0
Location
Maupin, Or
Hey, sorry, I know this is an old thread, but it seems the link to your original excel sheet is no longer working. Is there any chance you could upload the sheet again? I'm just getting into home brewing and am looking for anything that might help me along. I also just downloaded qbrew, but I would like to try a few different methods when I begin to see what works best for me. Thanks.
 

julian81

Well-Known Member
Joined
Jan 16, 2011
Messages
197
Reaction score
5
Location
Seattle
LS_Grimmy, the links to your spreadsheet are no longer working. Would you be able to repost your spreadsheet?

Much appreciated!

--j
 
Top