Search results

Australia & New Zealand Homebrewing Forum

Help Support Australia & New Zealand Homebrewing Forum:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.
  1. ianh

    Anyone else stupid enough to be up this early

    Best time of day. I BIAB normally on a Wednesday, have a timer that comes on at 04:50 so I can start brewing at 05:30 Good luck with the brews.
  2. ianh

    Crown Urn: volume undershot by 6L

    If you measure the water level then drop in the strainer then remeasure you can make allowance for the strainer. Fortunately I am set up with a pulley system so don't need to cover the element, just raise the bag. cheers
  3. ianh

    Crown Urn: volume undershot by 6L

    Hi shacked I think your initial measurement of water may be one problem. If you look at my spreadsheet BIAB Beer Designer pinned to this forum it is set up for using a Crown 40 L urn. You measure the water volume by measuring the depth using a steel rule, You measure again at start and end of...
  4. ianh

    Kit And Extract Beer Spreadsheet

    Hi bingggo, thanks, and good to see another Tassie brewer. What I recommend is that you do minimum of 10 litre boils and don't use the HCF, get a 19 litre pot from BigW. Without the HCF the bitterness calculation is done using Tinseth's method and is the one normally used by the vast majority...
  5. ianh

    Biab Beer Designer Spreadsheet

    Congrats on the first BIAB nvs-brews. If its too high in OG could always add some water.
  6. ianh

    Biab Beer Designer Spreadsheet

    Hi Matt Two ways alter spreadsheet as per post 88 (could send solipsist a pm see if he's done it) or if you have a number of hops that are added at the same time you could add new hops to the Hop worksheet that are a combination of Hops, just have to work out a weighted average AA%. Cheers Ian
  7. ianh

    Biab Beer Designer Spreadsheet

    What normally happens is the macro takes the information from the Brewday worksheet and pastes it as a comment in cell C on the Brews worksheet. Giving you a record of every brew you do. The only way I found of doing this was to copy the info, paste into MS Word (which the macro opens in...
  8. ianh

    Biab Beer Designer Spreadsheet

    Hi poggor Thanks. At that point in the macro it calls MS word in the background to copy the Brewday sheet info onto the Brew sheet as a comment. So you need both Excel and Word on the computer to get it to run properly. That's the only way I could find of copying part of a worksheet to a...
  9. ianh

    Digital Thermometer Recommendations

    I use one of these and very happy with it. http://www.ebay.com.au/itm/New-Digital-COOKING-FOOD-MEAT-KITCHEN-THERMOMETER-MEAT-Stab-PROBE-TEMPERATURE-/301006279906?pt=AU_Decor_Furnishing&hash=item46155f54e2
  10. ianh

    Biab Beer Designer Spreadsheet

    Thanks. To add more hop lines On Main worksheet copy down the last hop row - hop columns A to H for the number you want to add. You will then need to alter IBU formula in cell K14 You then need to add the Spin Buttons to the new D & F columns (Developer - Insert - Spin buttons), not sure...
  11. ianh

    Kit And Extract Beer Spreadsheet

    Thanks. But the only way around the LME problem is to create another LME on the Malt worksheet that combines 2 of your LME's
  12. ianh

    Kit And Extract Beer Spreadsheet

    You need to press the Save Recipe button on the Main worksheet to save a recipe. However all the recipes you have done should be on the Brews worksheet, if you look at the comments attached to the cells in Column C it gives you the recipe. You could enter this back into the Main worksheet and...
  13. ianh

    Kit And Extract Beer Spreadsheet

    There should be a Recipes worksheet. Fifth Tab along the bottom.
  14. ianh

    Bleach as Sanitizer

    Also note that Woolies Homebrand is 42 g/l whilst Coles is only 35 g/l Sodium Hypochlorite. I use 40 ml Bleach and 40 ml White Vinegar whilst filling my plastic fermenter.
  15. ianh

    Carbonating AG versus Extract

    If you use a calculator as suggested. The temperature input is the highest temperature the beer has reached after the beer has finished fermenting. A beer that has reached 23C after fermentation requires 10% more sugar than one that has only reached 18C maximum for the same CO2 level. Have you...
  16. ianh

    Spreadsheet

    Just add them on the Grains and Adjuncts worksheets. Just insert a row where you want them and fill in the rest of the columns.
  17. ianh

    Another BIAB thread

    One thing I do is put the hops in bags which I remove at the end of the boil, saves me worrying about the effects of no chill. I also usually dry hop in the fermenter after FG is reached. Have fun with your first.
  18. ianh

    Kit And Extract Beer Spreadsheet

    The spreadsheet uses an efficiency factor for steeping grains, you would need to change that for mashing..
  19. ianh

    question regarding kit and extract beer designer spreadsheet

    Hi Greg If you go to the Styles worksheet and say select the Dry Stout cell, you can read the comments associated with Dry Stout. If you cannot read them all, right click and select edit comments will allow you to read the whole comment. If you are looking for a Guinness type stout then Dry...
  20. ianh

    Biab Beer Designer Spreadsheet

    Not sure how you want to scale up but if you select pot rather than urn you can basically put in any size for your initial volume. Sorry for delay replying but I'm O/S on holiday ATM.
Back
Top