I'll start another thread if I get no responses but for continuity purposes here's my most recent data:
Just mashed two batches as follows-
#1 5lbs Munich, 3lbs Peated, 2lbs Pilsen, .75lbs Rauche, .75lbs Pale Chocolate.
#2 10lbs 2 Row.
I used the aforementioned formula for max gravity along with the Excel spreadsheet mentioned before to come up with my numbers.
For batch #1 I mashed all grains (11.5lbs) with 23 quarts of water at a temp of 153 degrees for 60 minutes. I recycled 3 quarts before draining 4 gallons total with an SG of 1.055. I batch sparged 6 more quarts at 175 degrees, without recycling, and had a total of 5.25 gallons with an SG of 1.052. By the formula I got an efficiency of 58.5% for the 4 gallons and 72.2% for the 5.25 gallons. By the table on Braukaiser my initial wort was 87.3% efficient for the qt/lb. Using the spreadsheet I got 58% brewhouse efficiency, 62% lauter efficiency, and 93% extraction efficiency for the 4 gallons and 69% brewhouse efficiency, 73% lautering efficiency, and 94% extraction efficiency for the total 5.25 gallons w/sparge.
For batch #2 I mashed the 2 row (10lbs) with 20 quarts of water at a temp of 152 degrees for 60 minutes. I recycled 2 quarts before draining 2.75 gallons total with an SG of 1.064. I batch sparged 5 more quarts with 170 degrees, recycling 2 quarts at first and then 2 more again after a stuck filter, and had a total of 4 gallons with an SG of 1.058. By the formula I got an efficiency of 46% for the 2.5 gallons and 61% for the 4 gallons. By the table on Braukaiser my initial wort was 100% efficient for the qt/lb. Using the spreadsheet I got 49% brewhouse efficiency, 49% lauter efficiency, and 100% extraction efficiency for the 2.5 gallons and 65% brewhouse efficiency, 64% lauter efficiency, and 101% extraction efficiency for the 4 gallons w/sparge.