NorthCoast85 Posted November 26, 2015 Share Posted November 26, 2015 Well' date=' I signed up to Aussie Home Brewer and, three weeks on, I'm still being moderated and cannot access IanH's spreadsheet. This is despite contacting them twice to try and rectify the problem. They can blow it out of their collective a***s. Has anyone seen this spreadsheet posted elsewhere? I really would like to get a look at it. Cheers[/quote'] Post #65 from this thread by Magnaman has a link to a thread that has the spreadsheet and a bunch of resources Link to comment Share on other sites More sharing options...
Beerlust Posted November 26, 2015 Share Posted November 26, 2015 Well' date=' I signed up to Aussie Home Brewer and, three weeks on, I'm still being moderated and cannot access IanH's spreadsheet. This is despite contacting them twice to try and rectify the problem. They can blow it out of their collective a***s. Has anyone seen this spreadsheet posted elsewhere? I really would like to get a look at it.[/quote'] Antsi has kindly placed a copy on his personal webspace. His post & link to that can be found HERE. Cheers, Lusty. Link to comment Share on other sites More sharing options...
NorthCoast85 Posted November 26, 2015 Share Posted November 26, 2015 Well' date=' I signed up to Aussie Home Brewer and, three weeks on, I'm still being moderated and cannot access IanH's spreadsheet. This is despite contacting them twice to try and rectify the problem. They can blow it out of their collective a***s. Has anyone seen this spreadsheet posted elsewhere? I really would like to get a look at it.[/quote'] Antsi has kindly placed a copy on his personal webspace. His post & link to that can be found HERE. Cheers, Lusty. Which is the same thread linked to in post #65 Link to comment Share on other sites More sharing options...
Beerlust Posted November 26, 2015 Share Posted November 26, 2015 Well' date=' I signed up to Aussie Home Brewer and, three weeks on, I'm still being moderated and cannot access IanH's spreadsheet. This is despite contacting them twice to try and rectify the problem. They can blow it out of their collective a***s. Has anyone seen this spreadsheet posted elsewhere? I really would like to get a look at it.[/quote'] Antsi has kindly placed a copy on his personal webspace. His post & link to that can be found HERE. Cheers, Lusty. Which is the same thread linked to in post #65 Incorrect. I suggest you look again. Link to comment Share on other sites More sharing options...
ChristinaS1 Posted November 26, 2015 Share Posted November 26, 2015 I guess Ian will need to update his spreadsheet what with the new cans in the Thomas Cooper line? Link to comment Share on other sites More sharing options...
NorthCoast85 Posted November 26, 2015 Share Posted November 26, 2015 Well' date=' I signed up to Aussie Home Brewer and, three weeks on, I'm still being moderated and cannot access IanH's spreadsheet. This is despite contacting them twice to try and rectify the problem. They can blow it out of their collective a***s. Has anyone seen this spreadsheet posted elsewhere? I really would like to get a look at it.[/quote'] Antsi has kindly placed a copy on his personal webspace. His post & link to that can be found HERE. Cheers, Lusty. Which is the same thread linked to in post #65 Incorrect. I suggest you look again. Same source - different post, you got me. First hyperlink in the linked thread, menu option: excel calculators, there it is. I was a little light on directions but it's certainly in there with a heap of other goodies. Link to comment Share on other sites More sharing options...
NorthCoast85 Posted November 26, 2015 Share Posted November 26, 2015 I guess Ian will need to update his spreadsheet what with the new cans in the Thomas Cooper line? I hadn't thought of that!! I'll definitely be keeping an eye on the mega thread over on AHB to see if Ian posts an updated version or if someone posts all the specs for us to plug in ourselves or we might have to do all the hard work ourselves!!! Link to comment Share on other sites More sharing options...
Away Posted November 26, 2015 Share Posted November 26, 2015 Thanks, one and all. The link worked a treat. For some reason the earlier link in this thread did not work for me. Cheers Link to comment Share on other sites More sharing options...
antiphile Posted November 26, 2015 Share Posted November 26, 2015 That link should work (albeit slowly) most of the time, unless MagnificentMacho is flooding the bandwidth with pornographic pictures of himself. I have to admit, I particularly liked the photo of himsellf with a priest, a rabbi and an Episcopalian minister! Link to comment Share on other sites More sharing options...
MitchellScott Posted August 4, 2019 Share Posted August 4, 2019 Digging up an old thread to ask a question... When using the HCF (Hop Concentration Factor) for hop boils, why does the HCF number and therefore bitterness levels change when changing the "style" of the beer at the top of the spreadsheet? Example: Centenarillo Ale with "American Pale Ale" beer style selected: Centenarillo Ale with "American IPA" beer style selected: The HCF changes and therefore changes the bitterness of the two brews. Can anyone explain why the HCF would change depending on beer styles? I would have thought it was just based on boil volume. Cheers Link to comment Share on other sites More sharing options...
Shamus O'Sean Posted August 4, 2019 Share Posted August 4, 2019 1 hour ago, MitchellScott said: When using the HCF (Hop Concentration Factor) for hop boils, why does the HCF number and therefore bitterness levels change when changing the "style" of the beer at the top of the spreadsheet? Hi Mitch I do not know why it is, but the formula in the spreadsheet uses the Mid Range IBU value of the style you are shooting for in the calculation of Hop Concentration Factor. The formula is: {[(Fermenter volume/Hop Boil volume) x Mid IBU of style] - IBU of kit cans}/260 The notes tab says it is a calculation method by Garetz. Maybe google him. 1 Link to comment Share on other sites More sharing options...
MitchellScott Posted August 5, 2019 Share Posted August 5, 2019 On 8/4/2019 at 12:55 PM, Shamus O'Sean said: Hi Mitch I do not know why it is, but the formula in the spreadsheet uses the Mid Range IBU value of the style you are shooting for in the calculation of Hop Concentration Factor. The formula is: {[(Fermenter volume/Hop Boil volume) x Mid IBU of style] - IBU of kit cans}/260 The notes tab says it is a calculation method by Garetz. Maybe google him. Well I did some research into the different formulas etc and I really shouldn't have cause now I am even more confused Most people agree that the HCF should be turned on for lower boil volumes but why it incorporates the "target" IBU of the beer beats me. My Anarchy IPA tastes reasonably bitter (not super bitter) but when I enter the recipe in with HCF on I only get 30IBU and it certainly tastes like more then that. Using the Tinseth method and it rises to just over 40 which is around where I think it sits in the real world. Now I dont know what method to use in the future hahaha oh dear. 1 Link to comment Share on other sites More sharing options...
MitchellScott Posted August 5, 2019 Share Posted August 5, 2019 Adding onto what I wrote above. IanH recommends 10L boils without HCF (as seen below). So for my own recipes, that's what I guess I will roll with :). Cheers. 1 Link to comment Share on other sites More sharing options...
Otto Von Blotto Posted August 5, 2019 Share Posted August 5, 2019 To add even more confusion, when I did the centenarillo ale I used a 5 or 6 litre boil and had the HCF on. It predicted just over 30 IBUs. With it turned off it went up to about 50, and I don't think the beer tasted like 50 IBUs. It was closer to the 32/33 or whatever it was. I was always under the impression that the calculation works on dilution in a similar way to the hopped kits. I don't know exact numbers but for arguments sake, from the hop additions you get 300 IBUs in the 5 litres of boiled wort which is then diluted down to 35 or 40 or whatever in the full batch. I'm just guessing here, it's been a long time since I've had to deal with it. Link to comment Share on other sites More sharing options...
MitchellScott Posted August 5, 2019 Share Posted August 5, 2019 14 minutes ago, Otto Von Blotto said: To add even more confusion, when I did the centenarillo ale I used a 5 or 6 litre boil and had the HCF on. It predicted just over 30 IBUs. With it turned off it went up to about 50, and I don't think the beer tasted like 50 IBUs. It was closer to the 32/33 or whatever it was. I was always under the impression that the calculation works on dilution in a similar way to the hopped kits. I don't know exact numbers but for arguments sake, from the hop additions you get 300 IBUs in the 5 litres of boiled wort which is then diluted down to 35 or 40 or whatever in the full batch. I'm just guessing here, it's been a long time since I've had to deal with it. Who knows haha... From the looks of things all IBU calculators are a guide only and so many factors influence the outcome so is hard to get a perfect calculation. I just did my Centenarillo Ale with HCF on with a 6L boil too and did it exactly as per the recipe so will be interesting to see how that goes when it comes time to taste. The general concensus is bigger boils are better and once you hit 10L you should use the tinseth method so I'll use that... I could do a bigger boil (my pot is 15L) however cooling that much volume becomes a task and a half. Mitch. Link to comment Share on other sites More sharing options...
kmar92 Posted October 31, 2019 Share Posted October 31, 2019 I have downloaded IanH's spreadsheet but I have been unable to get it working in OpenOffice. I have enabled the macros but still no luck. Anyone have it functioning in OpenOffice? Link to comment Share on other sites More sharing options...
Titan Posted October 31, 2019 Share Posted October 31, 2019 55 minutes ago, kmar92 said: I have downloaded IanH's spreadsheet but I have been unable to get it working in OpenOffice. I have enabled the macros but still no luck. Anyone have it functioning in OpenOffice? I would say no. Many of these clone apps will claim they are ms office compatable. Problem is when you import them, the calculation functions do not work because the formula is not there. Its like copy and paste in excel from one sheet to another. Formula gets copied as a value rather than the formula itself. Link to comment Share on other sites More sharing options...
kmar92 Posted October 31, 2019 Share Posted October 31, 2019 Thanks Titan. Link to comment Share on other sites More sharing options...
Journeyman Posted October 31, 2019 Share Posted October 31, 2019 14 hours ago, kmar92 said: I have downloaded IanH's spreadsheet but I have been unable to get it working in OpenOffice. I have enabled the macros but still no luck. Anyone have it functioning in OpenOffice? LibreOffice is the Linux version of OO - I have the sheet working fine. What isn't working? The calcs? Link to comment Share on other sites More sharing options...
Aussiekraut Posted October 31, 2019 Share Posted October 31, 2019 31 minutes ago, Journeyman said: LibreOffice is the Linux version of OO - I have the sheet working fine. What isn't working? The calcs? Actually LibreOffice is a fork of OpenOffice available for Linux, macOS and Windows. Does saving and loading of recipes work in LibreOffice? I don't have MSO either and the online version of Excel can't handle this functionality. It only sees the buttons but not the functionality behind it. The spreadsheet is a great tool and I'd love to be able to save some ideas for later re-visit or tweaking. Link to comment Share on other sites More sharing options...
Journeyman Posted October 31, 2019 Share Posted October 31, 2019 (edited) 29 minutes ago, Aussiekraut said: Does saving and loading of recipes work in LibreOffice? The 'New Recipe' button works but not the others. They give VBA errors. I hadn't got as far as trying those but just checked. Edited October 31, 2019 by Journeyman Link to comment Share on other sites More sharing options...
Aussiekraut Posted October 31, 2019 Share Posted October 31, 2019 5 minutes ago, Journeyman said: The 'New Recipe' button works but not the others. They give VBA errors. I hadn't got as far as trying those but just checked. Bugger. I really don't want to sponsor Microsoft and fork out a couple of hundred bucks for an Office licence. Link to comment Share on other sites More sharing options...
Journeyman Posted October 31, 2019 Share Posted October 31, 2019 Maybe @IanH might take a look at the code? Output for 'Save Recipe' is attached Recipe Spreadsheet error.doc Link to comment Share on other sites More sharing options...
kmar92 Posted November 1, 2019 Share Posted November 1, 2019 2 hours ago, Journeyman said: LibreOffice is the Linux version of OO - I have the sheet working fine. What isn't working? The calcs? Glad you have it working in LibreOffice, although it sounds like it is only with limited functionality. In OpenOffice virtually nothing works. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now