Thomas, very nice job on the file

.
One correction. On the first line of the hop bill change the 60 under grams to 7.8. That will get your Tinseth down to 55.4 so it looks like they are using Tinseth.
Second correction is instead of writing 6100g and 250g in Section C, just ype 6100 and 250. When you get rid of the g's, you'll see4 the right hand side of Section C will populate.
Now get ready to die of boredom...
As you have found the spreadsheet form limits us a bit when we gt over 8 jops or grains. We can only deal with this in a clumsy way but such recipes are rare.
Here's what you do...
Look for the hops that are being added at the same time. In this case we'll look at the 1 min hops. We have 23.5 grams @ 11.7%, 33.0 grams @ 13.0% and 37.6 grams at 6.0%. Multiply as follows 23.5 * 11.7 + 33.0 * 13.0 + 37.6 * 6.0 = 929.55
Instead of putting the 1 min additions in separately, you now put them in on one line as I have done on the attached file. On the left hand side of Section D you'll see we have 929.6 grams and on the right we have 1084.4.
1084.4 / 929.6 = 1.166. All you have to do now is multiply the original hops by 1.166. For example the 23.5 grams of Centennial becomes 27.4 grams.
Yep, I know it is a PITA but that is all we can do for these rare recipes atm. In real life, once you understand the above maths, it only takes a few seconds to work out. There is one further problem though

...
Let' say the Centennial hops you are using are 10.2 AA% while the ones in the original recipe are 11.7 AA%. You will then need to do one further calculation. You will need to multiply the 27.4 grams above by 11.7 / 10.2. In other words, you will need 31.4 grams.
You still awake?
The big problem...
The biggest problem we have here is time. Answering questions like yours well requires not a few minutes but sometimes several hours. Personally I had hoped that past members here whom I and a few others had spent the hours on would pass the baton on as it were. Unfortunately, most people just do a smash and grab of our time, say a quick thanks and rarely pass on the education. I know they don't mean to, especially in the excitement of learning how to brew but we are starting to realise here now that we are going to have to forget our hope that donations of time would get naturally passed on

.
This failure to hand on knowledge (a time donation) also creates a real Catch 22. For example, I can't find the time to write answers into articles that will work for a group as too many individual's forum answers are not being answered. I have found no time for the BIABacus in maybe three months.
So my problem is that I have run out of time this week for individuals let alone articles or BIABacus work!
Here's where I think we should go.
Maxi-BIAB is a very complex interplay of variables Thomas so can you do/study the following...
1. Use the Advanced Search feature here and look for posts made by me that contain the word 'juggle'. This will lead you to some posts that explain this interplay.
2. Use the Advanced Search feature here and look for posts made by me that contain the phrase 'sweet liquor shop posts'. Find and read those posts.
3. Use the Advanced Search feature here and look for posts made by me that contain the phrase 'extreme brewing'. Find and read those posts that relate to being sensible about how much beer you can brew given a small kettle.
4. After you have done the above and understand the knowledge being conveyed, play around with Section W. Have a few beers and see the effect that this has on red warnings and how much grain you need to use.
5. Find out where you will be buying your hops from. Ask them what the AA% of each hop is. Type those percentages into the right hand side of Section D.
6. You've done really well with Sections A to D. Try filling out E to H. There isn't much to do there as only a few fields in each section are required. I've done Section E for you already with a few changes on time and temps

.
7. Once you've done the above as best as you can, then post up your file again and maybe a few points on what you have learned and I or someone else will give some further tips or give yo a final thumbs up.
Nice work so far

PP
P.S. I have called the file an American IPA as that is what it really is. An English IPA is way different

.
You do not have the required permissions to view the files attached to this post.
If you have found
the above or anything else of value on BIABrewer.info, consider supporting us by
getting some BIPs!