Thanks for posting up the extra files Michael - that is excellent!
I noticed in your calculator file that there were some formulas over-written and a few errors in how you input the figures. So, what I thought we might do here, is test out stux's latest calculator and then after that we'll take a look at BeerSmith2. Looking forward to this!
[center]
Converting using The Calculator 2.0 (Easy)[/center]
What I did was downloaded stux's latest Maxi-BIAB Calculator from
here and then deleted the maxi-BIAB tabs.
Then I did the following...
Volumes Tab
I'm not using your volume or efficiency figures for now Michael for reasons I'll explain later.
Typed in 21.3 for 'Brew Length'
Typed in 81.7 for 'End of Boil Efficiency'
Typed in 1.062 for 'End of Boil Gravity' (from your .doc)
Typed in 40 for 'Diameter of Kettle'
Doing the above gives us the same figures (given a decimal point or two) as are used in the 'Pot (13 Gal/50L) - BIAB' BeerSmith2 equipment profile. This will make things easier later and give us all some common ground to work on.
Grain Bill Tab
Here I typed in the grain bill from your .doc file.
Hop Bill Tab
On your spreadsheet you had some funny things happening so I'll give a bit more detail here. (Wow! Just saw stux's hop chart on the right - somehow I had missed that before. Cool!!!)
We know from your .doc file that the end of boil volume on the original recipe was 6 gallons so I typed in 22.71 in Cell E6.
Next I typed in the hop bill from the original recipe in columns A,B,C and G. Notice how I have typed in the same AA% as in the original recipe? I have also made sure I put in the correct times.
Then in Column J, I typed in the default AA% for each hop as used in BeerSmith2. You can change these though to the AA% of hops in your fridge or if you intend substituting to a different hop then use the AA% of the different hop.
If your pot was 40cm in diameter, we would have to do nothing more. You would end up with this.
The Calculator 2.0 Sierra Nevada Celebration - 40cm.xls
You can change the 40 cm to the 34.3 cms of your pot and you will be good to go.
So, your recipe is the first conversion with stux's flash new calculator! Good on you stux

. You will simply use the grain bill shown in column G of the 'Grain Bill' tab and the hop bill shown in column I of the 'Hop Bill' tab.
(You might be wondering why The Calculator says 50.8 IBU's compared to the original recipe's 82.2. This will probably be due to the Rager formula being used instead of Tinseth. We will check this in BeerSmith2.)
[center]
General Comments on your BeerSmith2 Files[/center]
You have done a really good job at setting up your equipment profile. Only one problem mate and I think you forgot to tick your 'Calculate Boil Vol Automatically' box. Having this unticked can get you into all sorts of problems so open up your profile now, tick the box and save it. All else is great!
One thing I couldn't work out though is that in your profile, the Brewhouse Efficiency is 70% but in the recipe you uploaded it is 75%. Also your batch size/volume has been changed.
Be really careful when playing around with these figures in the recipe design view. It is really easy to bugger things up. Until you have done a few brews, make sure that in your case Michael, the Recipe Design tab shows your Batch Size is 23 L, your 'Tot Efficiency' is 70% and double check your 'Est Mash Eff' reads as 81.6%. No playing
Finally I see that you have used Nugget hops instead of Chinook. This is fine but what I think I will do for our example here, is just use the same hops as in the original recipe and the default BeerSmith2 AA% for each hop. You can change these yourself later to whatever you want just the same as I suggested you do in The Calculator 2.0 above.
[center]
Converting using BeerSmith2 & THe Calculator 2.0 - (Easy)[/center]
Now that we have a calculator file made up, things are easy to put into BeerSmith2 as The Calculator has already done the converting for us. All you would have to do in The Calculator file above is change the pot diameter and the AA% of any hops in column J to the AA% of the hops you intend to use.
Then you would 'Add Recipe' on BeerSmith2, make sure your equipment profile is selected and then transfer the grain bill from column D and the hop bill info from column G, I and J.
Another thing you could do is not change the cms in the Calculator file. Instead, you would select the 'Pot (13 Gal/50L) - BIAB' BeerSmith2 equipment profile, type in the grains and hops and then hit the 'Scale Recipe' button. You would then scale to the 'Michael's Pot' profile. Cool!
For those who do use the 'Pot (13 Gal/50L) - BIAB' profile, here is what your BeerSmith2 recipe would look like.
Celebration Sierra Nevada Clone - 40cm.bsmx
[center]
Converting using BeerSmith2 - (Harder)[/center]
If your recipe had come to you in the form of a beersmith file, you could simply use the 'Scale Recipe' button to convert the recipe to your 'Michaels' Pot.' Once again, easy peasy. But...
Yours is an external recipe so we have to do more work. Assuming we wanted to convert your recipe completely only using BeerSmith2 we would do the following...
1. Click Add Recipe
2. Click on the tick beside the equipment profile - I am assuming yours is the default and change the batch volume to 22.7 L and change 'Loss to Trub and Chiller' to zero. This will give BeerSmith2 a 6 gallon (22.7 L) end of boil volume to work on as was used in the original recipe.
3. Don't touch anything else, just click OK.
4. Now type in the ingredients from the original recipe exactly as they are using the same weights, AA%, hop names and times etc.
5. Now, see how the IBU's read as 55.4? This is still a long way off from the original recipes 82.2. In BeerSmith2, no matter what sort of hop formula I use, I can't get it to match the original recipes very high IBU. Unless you were able to contact the writer of the original recipe, there is no way to understand what he has done there. 82.2 is way too high for an American IPA so I would not be worrying about it.
6. The next thing I want to do is match the efficiency of the original recipe. To do this I will keep changing the 'Tot Efficiency' figure until I see the 'Est Original Gravity' change to 1.068. It ends up that 68% is correct. (Doing this has increased our bitterness slightly but this is fine).
7. Finally I am going to scale the recipe back to your equipment profile. So, I click on 'Scale Recipe' and even though 'Michael's Pot' is already displayed, I will click on it and then select it from the drop down list and press okay. Here is what your recipe would look like at this stage.
Celebration Sierra Nevada Clone - Original.bsmx
8. Finally we have to go through and change the hops one by one to suit our AA%. This is a bit laborious and for this reason, 'The Calculator' is a faster tool to use to convert external recipes.
You might remember that we have chosen to select the BeerSmith2 AA% defaults for our hops. They are Chinook 13%, Centennial 10% and Cascade 5.5%. So, luckilly the only one we have to play with is Cascade - we need to change this from 5.75% to 5.5%. As two of the Cascade additons are at zero minutes or dry hopped, we really don't have to worry about these. Let's have a look at the 15 minute Cascade addition though.
See how it says this contributes 7.9 IBU's? Double click on that and change the 5.75% to 5.5% and click okay. You'll now see that addition is only contribuiting 7.6 IBUs. What I need to do now is play around with the weight until it equals 8.0. Typing in 44.8 grams gives this result.
So, here is the recipe I came up with for your equipment.
Celebration Sierra Nevada Clone - 34.3 cm.bsmx
[center]
Finally[/center]
Okay we are finally done! When I come to NZ Michael, I expect a few pints of your Celebration Sierra Nevada

Yum! It was actually quite interesting though exploring Stux's new calculator and BeerSmith2. You'll see a few differences in the conversion methods but nothing to worry about and it has given me a couple of questions to ask so thanks for the challenge and thanks for providing all the good info to work with.
Don't think converting a recipe takes ages though. It really would only take about 5 minutes to convert it in The Calculator and then another 5 to type it into BeerSmith2. The above makes it look hard but there are some easy traps to fall into. Once you get the hang of things it is all fairly quick and easy.
I haven't double-checked the above but let me know if anything is unclear etc.
PP
You do not have the required permissions to view the files attached to this post.