Step 3: Prepare the Spreadsheet. In this tutorial, we will create a very simple macro to change the color, size and boldness of text. In your spreadsheet, type in some text in any of the cells. We will later record a macro to change the formatting of this text.
The average cooling capacity of a dorm fridge is somewhere around 150 BTU/hr, that is, it is capable of moving 150 BTUs of heat in 1 hour, regardless of how efficient (or inefficient) it is in terms of energy usage.
1 lb. of water requires removing 1 BTU to lower its temperature 1Â°F.*. Using this to calculate theoretical water-chilling capacity: 1 ton of refrigeration (12,000 BTUs per hour) will chill. 12,000 lbs. water/fish 1Â°F in 1 hour. Theoretically, then, a sample application to chill seawater and fish: 40 tons refrigeration (480,000 BTUs per hour) will chill. 120,000 lbs. water/fish 20Â°F in 5 hours.