Search results

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.

Count me in

Given the IBU's of the can you should expect something like that. If you enter a ferment volume of 23 litres and the enter a recipe, you should be able to see the values change as you change the ferment volume.

I am with Thomas Wood on this one. Only occasionally used LME when a full tin was required. But became an extract brewer (over 200 brews) and used DME almost exclusively. Use to buy 20kg bags and split into approx 1kg lots which was stored in ziploc bags. Dissolved DME in hot water separately...

Hi opercularia. Had a chance to look at the recipe deletion problem.The recipes are grouped in sets of 10, it appears not to move recipe 11 to 10 correctly. To fix the problem you need to get access to the "deleterecipe" macro how to do this depends on the Excel version. You need to edit the...

Hi opercularia I am not at home atm, should be back in a few days and will look at the problem. Hangover68 the spreadsheet cannot be used in openoffice as the macros will not run. cheers Ian