In preparation I have been having a play about with the impressive Biabacus spreadsheet...and what a feat of spreadsheet engineering it is!
For my first brew I was planning on attempting a go at the Brewdog Dead Pony Club as this is my default session ale and the prospect of being able to churn out a batch of this is very appealing...and will help win the wife over to my new brewing kit! Hopefully I have not bitten off more than I can chew for my first batch, although it all looks fairly straight forward *famous last words*.
I am having an issue with some of the outputs on the spreadsheet. I know I must have missed something, or done something wrong but cant figure out what. Whatever I have done has resulted on strange Final Gravity and ABV outputs.
Can anyone see where I have gone wrong?

Brew Report ...
[center]BIABacus Pre-Release 1.3T RECIPE REPORT[/center]
[center]BIAB Recipe Designer, Calculator and Scaler.[/center]
[center](Please visit http://www.biabrewer.info" onclick="window.open(this.href);return false; for the latest version.)[/center]
[center](Not quite) Dead Pony Club - Batch 1[/center]
Recipe Overview
Brewer: Duffer
Style: IPA
Source Recipe Link:
ABV: 100523.3% (assumes any priming sugar used is diluted.)
Original Gravity (OG): 1040
IBU's (Tinseth): 35
Bitterness to Gravity Ratio: 0
Colour:
Kettle Efficiency (as in EIB and EAW): -392891.8 %
Efficiency into Fermentor (EIF): -353970.6 %
Note: This is a Pure BIAB (Full Volume Mash)
Times and Temperatures
Mash: 90 mins at 62 C = 143.6 F
Boil: 60 min
Ferment: 5 days at 19 C = 66.2 F
Volumes & Gravities
(Note that VAW below is the Volume at Flame-Out (VFO) less shrinkage.)
The, "Clear Brewing Terminology," thread at http://www.biabrewer.info/" onclick="window.open(this.href);return false;
Total Water Needed (TWN):
Volume into Boil (VIB): 30 L = 7.92 G @ 920.771
Volume of Ambient Wort (VAW): 25.53 L = 6.74 G @ 1040
Volume into Fermentor (VIF): 23 L = 6.08 G @ 1040
Volume into Packaging (VIP): 21.3 L = 5.63 G @ 260.75 assuming apparent attenuation of 75 %
The Grain Bill (Also includes extracts, sugars and adjuncts)
Note: If extracts, sugars or adjuncts are not followed by an exclamation mark, go to http://www.biabrewer.info" onclick="window.open(this.href);return false; (needs link)
#VALUE!
#VALUE!
#VALUE!
The Hop Bill (Based on Tinseth Formula)
(Dry Hopped)
(Dry Hopped)
(Dry Hopped)
Mash Steps
Mash Type: Pure BIAB (Full-Volume Mash): Saccharifiaction for 90 mins at 62 C = 143.6 F
Strike Water Needed (SWN):
Mashout for for 15 mins at 74 C = 165.2 F
Miscellaneous Ingredients
#VALUE!
Chilling & Hop Management Methods
Hopsock Used: y
Chilling Method: Immersion Chiller (Employed 15 mins after boil end.)
Fermentation & Conditioning
Fermentation: Safale US-05 for 5 days at 19 C = 66.2 F
Secondary Used: y
Condition for 14 days.
Consume within 6 months.
Special Instructions/Notes on this Beer
Cheers