Lets see your brewing Excel Spreadsheets

[LS_Grimmy]

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]

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]

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 .

 

[Orfy]

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.

 

[DeathBrewer]

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.

 

[LS_Grimmy]

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

 

[Orfy]

'an you.

Here's one.
www.google.com/custom?q=excel&hl=en...w.homebrewtalk.com&oe=ISO-8859-1&start=0&sa=N

 

[mrfocus]

Here's what I've been developing as a fermentation log to keep track of things:

 

[razyrsharpe]

well, these are all really impressive, and i am sincere in that, but you math oriented guys are making my head hurt.

 

[FlyGuy]

well, these are all really impressive, and i am sincere in that, but you math oriented guys are making my head hurt.

Don't read his home page then:
http://www.moorescott.net/marc/homebrew.htm#Beer_Math

 

[SayWhat1]

Don't read his home page then:
http://www.moorescott.net/marc/homebrew.htm#Beer_Math

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!

 

[LS_Grimmy]

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]

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]

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?

 

[LS_Grimmy]

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

 

[weetodd]

Thanks for the explanation. That's a pretty cool way to do it.

 

[LS_Grimmy]

did this work for u? weetodd

 

[millerhd]

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.

 

[triangulum33]

Any updated links?

 

[julian81]

LS_Grimmy, the links to your spreadsheet are no longer working. Would you be able to repost your spreadsheet?

Much appreciated!

--j