Brewing Spreadsheets.

**Orfy** · 12-26-2006, 12:13 PM

I thought it'd be good to have on thread for brewing spread sheets that people are working on.
It's work in progress and I'm sure there's errors. It'd be good if anyone lets me know what they are.

One error I think I had was in the mash effieciency formula.
It's in cell (model) E17 and I think it should be.
=(((E17-1000)*E15/C15)/(C17-1000)*C16)
The more run off I was getting at specified OG the lower the efficiency. I should be the other way. so I swap C15/E15 to E15/C15 and it seems to of corrected it.

**Orfy** · 12-26-2006, 12:21 PM

Here's a link to other spreadsheets. I'll had more when I find them.

Orfy's xls
BatchSparge xls[
Dudes xls
BYO xls

Mike & John · 12-26-2006, 04:49 PM

I'd like to swap spreadsheets with ya. my email is babinson @ yahoo dot com

mine is not fantastic but the only thing I really wanted to do was to be able enter my grain bill in percentage and have it give me the mass [which was accomplished]

there are some other things like bucket calibrations that may not be applicable to you.

homebrewer_99 · 12-26-2006, 05:12 PM

I have 2 spreadsheets (one file) to offer, but don't have any place to post it so others can download.

On the first sheet you input the OG and FG and it calculates the ABV and ABW, the second is a larger chart (for printing) that lists all the calculations when you subtract the FG from the OG; i.e., if your difference is 0.44 then the ABW is 4.620 and ABV is 5.775.

I keep mine in a document protector and pinned to a bulletin board over my stove.

**Orfy** · 12-26-2006, 05:16 PM

Here's the link to mine. (It's on my signature)
http://www.4shared.com/file/7924621/7d5ebaf0/brew.html

I can reccomend 4shared.

If you email me your brew sheets I'll upload them for you if you wish.

dave123taylor--------------at-----------------hotmail.com

change the at to @ and delete the --------------------

homebrewer_99 · 12-27-2006, 03:55 AM

Done...

**Dude** · 12-27-2006, 02:05 PM

Here's a thread with mine. Feel free to download and host it, orfy.

http://www.homebrewtalk.com/f14/christmas-september-14187/

**Orfy** · 12-29-2006, 06:29 PM

Ok. Gotta try and put a user name to real name here.

Jason? (Awesome sheet)

I'm trying to backwards engineer some of your formulae.
1st of a few I guess.
Is the Gravity figure post boil? If not how have you figured in evaporation from the boil?
What I'm looking at is if thats the gravity based on a 75% mash.

i.e 1053 and I reduce the wort by 10% on boil then I need to /90% to get my sg to fermenter.
i.e (53/90%)=59 of 1059

Can any one suggest?

**knipknup** · 12-30-2006, 01:29 PM

Here's the one I used until I purchased beersmith
http://spreadsheets.google.com/pub?key=pmiOYuaMYQ1G1_EI0MSxBTw