334/4.2 (or more accurately 334J/4.186J = 79.79)Where does the 79.5 come from? And won't the final volume be 1,562, not 1,000?
Specific heat of ice is half that of water.
didn't know it was possible to add spreadsheets to the web - learn something everydayI'm intrigued. I can't quite figure out what you doing but I think it's quite clever. I think I'll write a spreadsheet! Does the increase in volume matter?
https://docs.google.com/spreadsheets/d/1oTxgVJExl5aT_p43jCjQyP81sYEgjeRgZS0y1Dmp5oo/edit?usp=sharing
You can only alter cells D1 to D5. Most domestic freezers are set at -18.
Play with the mass of ice until the energy figures in E17 and E19 match.
Would anyone actually add this much ice? You would have to boil a much reduced volume.
didn't know it was possible to add spreadsheets to the web - learn something every day.
... what people mean by "no-chill" can vary a lot, from putting a lid on your boiler at flame-out, through transferring to FV and on to using a "no-chill cube"Is "no chill" where you cover it and let it come to room temperature on its own, maybe use a water bath?
I done another google apps spreadsheet thingGood job. It works well and is a lot tidier than mine. I can edit in the red boxes but not elsewhere, as you intended. I think for people who have cooled their wort to 50C then adding ice might be very practical. But mine explains the philosophy/method.
Ice density is 0.92. That's why it might be better to use weight rather than volume. I know the difference is small. Plus, it's very hard to measure ice volume!
I can't 'unhide' column H. Where is this gram of which you speak?The idea being that you can have a plan inplace to get the right temperature as soon as possible - may be you could run a critical eye over it and tell me what you think - it sort of works apart from the odd stray gram that has me puzzled - LOL
Nothing very exciting in "H". But I will let you take a peak.I can't 'unhide' column H. Where is this gram of which you speak?
In a cloud ? it puzzles me too, but yes it is apparently an "Apps Script" so may be I have wrote an app ............ I must be a modern person - LOLOK. Where are the calculations done? Column H only has numbers. And why would you add kettle water. Does ice have priority over tap water?
I use the latter technique and my "no-chill cube" is a 5 gal HDPE jerry-can
I sent you a PM.may be you could run a critical eye over it and tell me what you think
Enter your email address to join: