Thanks for the bump ibast.
I'm going to post what I did yesterday so you guys can get an idea of what I'm trying to do. It's a little underdone at the moment so please bear that in mind.
Thanks to Dr Smurto for posting his list earlier. I've used most of your numbers for the ones you already had. I've also added all of the muntons kits (as per their website).
You'll note that when it comes to colour, plenty of numbers are a bit out of whack. Please stick with them as I've tried to apply the same rules to all of the kits so as to maintain some continuity. The equivalent EBC of the finished product might be a half a point off the mark, but relative to the other kits it should be OK.
The reason is that when it comes to colour, EBC is not a different measurement of the same thing as SRM or Lovibond. The two measurements measure different things, so in fact there's no "conversion" factor for them at all. I've provided a regression analysis to show how to approximate the two. I've been webhunting and the fact is there are a lot of formulas being offered that are just plain wrong. Anything where you have to add or subtract a fixed number from one unit before mutliplying is in itself wrong because at different concentrations, you get different numbers when the ratio SHOULD stay the same. (I.e. if you convert EBC to SRM at can level, you get a different conversion to if you dilute the can in 23L and then convert it)
Dr Smurto had the best approximation I've seen with his 0.508 but I've just slightly tried to improve on it by using a power function.
Please also note that the "commercial beers" tab is a bit empty at the moment but I'm working on it, any help is greatly appreciated. There are also tabs with helpful information about bitterness and colour etc. And I've included all the manufacturer's descriptions for their kits (except MSB) so that you can try to get an idea for the difference between the kits whose colour and bitterness are the same.
Have I forgotten anything? I hope not, any questions, let me know.
PLEASE HELP ME BUILD THIS INTO SOMETHING MORE USEFUL
View attachment Colour_and_IBU.xls