Recent content by ianh

Hi Hefty The red dot should be =SERIES("RECIPE",MAIN!$Z$30,MAIN!$AA$30,8) then cell z30 =k14 the ibu value and AA30 is =K11 the OG It may be easier to download the Excel file again. Hope that helps. cheers Ian

Something does not appear to be right, you are starting with 24litres and finishing with 12 litres. You have say 3kg grain to absorb water and then say 25% loss due to the boil. Figures dont add up. cheers Ian

When I started brewing over 50 years ago in the UK. I used a plastic dustbin with lid for the primary fermentation (which to me is an open fermentation). Then transferred to a demijohn with airlock for secondary then bottle.

I have just had one of these installed https://istore.net.au/istore-270/ Set it up to run on off peak tarrif and my solar. So far so good. Can't help with Vic pricing as I am in Tas. Cheers Ian

Agree with MHB comment "There are lots of factors that affect how hops/hop products behave in a boil." I did the Kit and Extract Spreadsheet and incorporated a Hop Concentration Factor to try and allow for small size boils. Suggest you have a look at the spreadsheet and hopefully it may help...

All I can suggest is to Google "compare two excel files" and follow the Microsoft answer.

Sounds way too much dextrose to me. I use 6.75 grams in 1500ml bottles for my bitters.

=IF(AND(ISNUMBER(R2),ISNUMBER(S2)),IF(ISNUMBER(AC2),(R2-S2)/7.45,(R2-S2)/7.45+0.4),"") in Cell T2 =IF(AND(ISNUMBER(R2),ISNUMBER(S2)),100*(R2-S2)/R2,"") in Cell U2 These Cells are copied down the Worksheet Only get values if using hydrometer ie inputs in Cols R and S Cheers Ian

Hi. The mash temp and time are only manually set. The strike temp can be increased by increasing the value in the Factor for grain absorbtion cell.

No you cannot just change the batch size saved in recipes. When you save recipe it just saves the value thats in the Ferment Volume cell.

No the initial gravity will change.

I use mine for collecting green waste from around the garden and then when I have a load take then to the council green waste place.

Geez I only used 20 gram roasted Barley in my extract Irish Reds, along with some CaraRed and CaraAroma..

Hi Tony The link in the first post in this thread is the current one. Cheers Ian

G'day good to see another member from Tassie.