Happy HolidaySs Giveaway - Winners Re-Re-Re-Re-Drawn - 24 hours to Claim!

Get your HBT Growlers, Shirts and Membership before the Rush!


Home Brew Forums > Home Brewing Beer > General Beer Discussion > Lets see your brewing Excel Spreadsheets
Reply
 
LinkBack Thread Tools
Old 02-07-2008, 07:27 PM   #1
LS_Grimmy
Feedback Score: 0 reviews
 
LS_Grimmy's Avatar
Recipes 
 
Join Date: Nov 2006
Location: Cold Lake , Alberta
Posts: 297
Liked 3 Times on 1 Posts

Default Lets see your brewing Excel Spreadsheets

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


LS_Grimmy is offline
 
Reply With Quote Quick reply to this message
Old 02-07-2008, 07:59 PM   #2
Lil' Sparky
Cowboys EAC
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Lil' Sparky's Avatar
Recipes 
 
Join Date: Feb 2006
Location: Honolulu, HI
Posts: 4,013
Liked 50 Times on 33 Posts

Default

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!
Lil' Sparky is offline
 
Reply With Quote Quick reply to this message
Old 02-07-2008, 08:10 PM   #3
FlyGuy
Feedback Score: 0 reviews
 
FlyGuy's Avatar
Recipes 
 
Join Date: Jan 2007
Location: Calgary, Alberta
Posts: 3,618
Liked 136 Times on 42 Posts
Likes Given: 7

Default

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.

FlyGuy is offline
 
Reply With Quote Quick reply to this message
Old 02-07-2008, 08:11 PM   #4
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Orfy's Avatar
Recipes 
 
Join Date: Sep 2005
Location: Cheshire, England
Posts: 11,853
Liked 69 Times on 52 Posts
Likes Given: 30

Default

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.

Orfy is offline
 
Reply With Quote Quick reply to this message
Old 02-07-2008, 08:27 PM   #5
DeathBrewer
Maniacally Malty
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
DeathBrewer's Avatar
Recipes 
 
Join Date: Apr 2007
Location: Oakland, CA
Posts: 21,899
Liked 214 Times on 119 Posts

Default

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...
DeathBrewer is offline
 
Reply With Quote Quick reply to this message
Old 02-07-2008, 08:51 PM   #6
LS_Grimmy
Feedback Score: 0 reviews
 
LS_Grimmy's Avatar
Recipes 
 
Join Date: Nov 2006
Location: Cold Lake , Alberta
Posts: 297
Liked 3 Times on 1 Posts

Default howdy

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

LS_Grimmy is offline
 
Reply With Quote Quick reply to this message
Old 02-07-2008, 08:59 PM   #7
Orfy
For the love of beer!
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
Orfy's Avatar
Recipes 
 
Join Date: Sep 2005
Location: Cheshire, England
Posts: 11,853
Liked 69 Times on 52 Posts
Likes Given: 30

Default

'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.
Orfy is offline
 
Reply With Quote Quick reply to this message
Old 02-07-2008, 11:30 PM   #8
mrfocus
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2007
Location: Montreal, Canada
Posts: 582
Liked 1 Times on 1 Posts
Likes Given: 1

Default

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)
mrfocus is offline
 
Reply With Quote Quick reply to this message
Old 02-07-2008, 11:34 PM   #9
razyrsharpe
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2007
Location: Lugoff, SC
Posts: 233
Liked 1 Times on 1 Posts
Likes Given: 41

Default

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!
razyrsharpe is offline
 
Reply With Quote Quick reply to this message
Old 02-08-2008, 12:40 AM   #10
FlyGuy
Feedback Score: 0 reviews
 
FlyGuy's Avatar
Recipes 
 
Join Date: Jan 2007
Location: Calgary, Alberta
Posts: 3,618
Liked 136 Times on 42 Posts
Likes Given: 7

Default

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
__________________
Cheap 10 gal cooler MLT$3 AutosiphonAluminum Pot FAQEasy Steam Injection Mash SystemMake a Frozen Yeast Bank
Improving Stovetop Boiling Improving AG Efficiency
FlyGuy 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
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 11:50 PM
Water-building software/spreadsheets Stevorino General Techniques 1 06-02-2009 05: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



Newest Threads

LATEST SPONSOR DEALS