Author Topic: Partigyle Spreadsheet  (Read 2180 times)

Offline blatz

  • Brewmaster General
  • *******
  • Posts: 2453
  • Paul Blatz - Jupiter, FL
    • View Profile
Partigyle Spreadsheet
« on: November 19, 2009, 09:02:21 AM »
Anyone have a good partigyle spreadsheet or website link?
The happiest people don’t necessarily have the best of everything; they just make the best of everything they have.

BJCP National: F0281

Offline akr71

  • Brewmaster
  • *****
  • Posts: 549
  • Beer Ain't Drinkin' - Mojo Nixon
    • View Profile
Re: Partigyle Spreadsheet
« Reply #1 on: November 19, 2009, 09:43:20 AM »
No spreadsheet, but here is a good article by Randy Mosher which includes some lookup tables to estimate the gravites and SRM of the seperate runnings dependent of the estimate of the total OG (if it were one brew).
Article:
http://www.brewingtechniques.com/library/backissues/issue2.2/mosher.html

Tables:
http://www.brewingtechniques.com/library/backissues/issue2.2/moshertable.html

Hope it helps some.
Andy

Amherst, NS - Canada

Offline babalu87

  • Brewmaster
  • *****
  • Posts: 831
  • Grand Brewbah
    • View Profile
Re: Partigyle Spreadsheet
« Reply #2 on: November 19, 2009, 10:51:58 AM »
I miss Brewing Techniques

Was a good magazine
Jeff

On draught:
IIPA, Stout, Hefeweizen, Hallertau Pale Ale, Bitter

Primary:
Hefeweizen,Berliner Weisse, Mead

Offline tom

  • Senior Brewmaster
  • ******
  • Posts: 1110
  • Denver, CO
    • View Profile
Re: Partigyle Spreadsheet
« Reply #3 on: November 19, 2009, 01:33:55 PM »
A recent zymurgy had a table about the expected gravity of first runnings vs the mash ratio. I do parti-gyles for all of my big beers and use only the first runnings for the big beer. The thicker the mash, the higher the gravity (and less runnings per pound).

1.25 qt/lb will get first runnings close to 1.090, 1.1 upper 90's, 1.7 in the 70's.

You have to figure out the amount of grain backwards. What pre-boil gravity do you want? Let's say 1.090 . So we will mash at 1.25 qt/lb. (Or check the zymurgy chart.) Because of grain absorption (let's say 0.5 qtlb) you will only get 0.75 qt of first runnings per lb of grain. What pre-boil volume do you want? Let's say 6.5 gallons (or 26 quarts). To figure out the amount of grain, divide 26 by 0.75 and you'll require 34.66 lb of grain. Mash 34.66 lb of grain with 1.25 qt/lb (mash volume) = 43.3 qt of water (= 10.83 gallons). Add the volume of wet grain 34.66/3qt = 11.5 qt or 2.9 gal for a total mash volume of 10.83 + 2.9 = 13.7 gallons. Got a big mashtun?

Simply run off the first runnings (6.5 gallons) into the boil kettle. Then batch sparge with 6.5 gallons and collect 6.5 gallons of second runnings. In my experience the gravity of the second runnings will be about half of the gravity of the first runnings or ~ 1.045. If you have a second boil kettle you can have the 2nd beer boiling within 15 minutes of the first.

Brew on 
Brew on