G'day Ian,

The speadsheet is a great Idea and you have done a great job.

On the issues of Coopers kits, they explain how to get the values on their FAQ page. Basically it is the number times the can weight divided by the volume.

Eg. IPA is 710 IBU which is times 1.7 then divided by 23L is 52.478 IBU (your value was 30.9 which is 710/23) same goes for colour values.

They then go on to say that fermantation will lower these valuse by 10 to 30 percent so the final IBU in the brew due to the kit may be between 36.735 to 47.230 IBU for this example.

Not really sure how you calculate how much is lost due to fermentation I would say that the entire brew would have the loss i.e. the Kit IBU of 52.478 added to the IBU from hop addition then reduced by somewhere between 10 to 30 percent?

Similar to EBC from kit plus all additions then reduced?

Sorry if this is confusing, I have confused myself, just starting to look at all these factors for the first time.