Lets see your brewing Excel Spreadsheets - Home Brew Forums
Home Brew Forums > Home Brewing Beer > General Beer Discussion > Lets see your brewing Excel Spreadsheets

Reply
 
Thread Tools
Old 02-07-2008, 07:27 PM   #1
LS_Grimmy
 
LS_Grimmy's Avatar
Recipes 
 
Nov 2006
Cold Lake , Alberta
Posts: 294
Liked 3 Times on 1 Posts



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


__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com



 
Reply With Quote
Old 02-07-2008, 07:59 PM   #2
Lil' Sparky
Cowboys EAC
HBT_LIFETIMESUPPORTER.png
 
Lil' Sparky's Avatar
Recipes 
 
Feb 2006
Honolulu, HI
Posts: 3,959
Liked 71 Times on 45 Posts


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!


__________________
Quote:
Originally Posted by duffman2 View Post
I dub this beer the Double Slutty Triple Nutty Bodacious Booty Brunette!

 
Reply With Quote
Old 02-07-2008, 08:10 PM   #3
FlyGuy
 
FlyGuy's Avatar
Recipes 
 
Jan 2007
Calgary, Alberta
Posts: 3,605
Liked 178 Times on 51 Posts


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 Batch Sparge Water Calculator.zip.

 
Reply With Quote
Old 02-07-2008, 08:11 PM   #4
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
 
Orfy's Avatar
Recipes 
 
Sep 2005
Cheshire, England
Posts: 11,732
Liked 94 Times on 62 Posts


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.

__________________
GET THE GOBLIN
Have a beer on me.

 
Reply With Quote
Old 02-07-2008, 08:27 PM   #5
DeathBrewer
Maniacally Malty
HBT_LIFETIMESUPPORTER.png
 
DeathBrewer's Avatar
Recipes 
 
Apr 2007
Oakland, CA
Posts: 21,790
Liked 259 Times on 132 Posts


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.

__________________
Easy Partial Mash Brewing - Stovetop All-Grain Brewing

"Death is always with us." - Brewpastor

Quote:
DIAICYLF
We will remember...

 
Reply With Quote
Old 02-07-2008, 08:51 PM   #6
LS_Grimmy
 
LS_Grimmy's Avatar
Recipes 
 
Nov 2006
Cold Lake , Alberta
Posts: 294
Liked 3 Times on 1 Posts


Quote:
Originally Posted by 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.

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
__________________
LS Grimmy

My Web Site:
www.grimmysbeer.com


 
Reply With Quote
Old 02-07-2008, 08:59 PM   #7
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
 
Orfy's Avatar
Recipes 
 
Sep 2005
Cheshire, England
Posts: 11,732
Liked 94 Times on 62 Posts


'an you.

Here's one.
http://www.google.com/custom?q=excel...1&start=0&sa=N
__________________
GET THE GOBLIN
Have a beer on me.

 
Reply With Quote
Old 02-07-2008, 11:30 PM   #8
mrfocus
Recipes 
 
Oct 2007
Montreal, Canada
Posts: 573
Liked 3 Times on 3 Posts


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

__________________
MOD EDIT: Sig only takes up 6 lines now. Fermenting: Apple cider x 2, Doppelbock, Red, Oatmeal Stout, West Coast IPA x 2
Bottle conditioning: RIS
Keg conditioning: La Fin du Monde clone
On tap: Maudite clone, Double Munchen, Oktoberfeast, Oktoberfest Pilsner
Planning: Brewed in 2011: 22 (2010: 15, 2009: 29, 2008: 21, 2007: 1)
Wine made in 2010: 6 kits (2009: 19, 2008: 30)

 
Reply With Quote
Old 02-07-2008, 11:34 PM   #9
razyrsharpe
HBT_SUPPORTER.png
 
razyrsharpe's Avatar
Recipes 
 
Feb 2007
Lugoff, SC
Posts: 412
Liked 20 Times on 15 Posts


well, these are all really impressive, and i am sincere in that, but you math oriented guys are making my head hurt.
__________________
I'd rather have a bottle in front of me than a frontal lobotamy!

 
Reply With Quote
Old 02-08-2008, 12:40 AM   #10
FlyGuy
 
FlyGuy's Avatar
Recipes 
 
Jan 2007
Calgary, Alberta
Posts: 3,605
Liked 178 Times on 51 Posts


Quote:
Originally Posted by razyrsharpe
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



 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Brewing Worksheet & yeast strains jrp3 Recipes/Ingredients 2 12-04-2013 11:07 PM
Need Some Excel Formatting Help jescholler Brewing Software 7 10-18-2009 10:50 PM
Water-building software/spreadsheets Stevorino General Techniques 1 06-02-2009 04:53 PM
Fun with excel uwjester General Beer Discussion 5 02-14-2009 12:14 AM
Brewing Spreadsheets. Orfy General Techniques 8 12-30-2006 02:29 PM


Forum Jump