Excel Problem
posted by Angel on .
If the initial temperature is 115 F (46 degrees C), the cold water temperature is 1.7 (degrees C), and the volume and volumetric flow rate are 3,000 liters and 30 liters per minute, respectively,
(a) Calculate the expected water temperature at 5minute intervals for the first 60 minutes after the flow of cold water is established
( I have no idea how to solve this problem am completely lost on the equation use and everything please help)

heat lost by hot water + heat gained by cold water = 0
initial volume = 3000 L
30 L/min x 5 min = 150L
[mass cold water x specific heat x (TfinalTinitial)] + [mass warm water x specific heat x (TfinalTinitial)] = 0
You know mass cold water (150L = 150kg
You know specific heat water
You know initial T of warm water = 46 C
You know initial T of cold water = 1.7 C.
The only unknown is Tfinal. You can calculate that at 0 min = 46 C
First 5 minutes given by above equation. The next 5 min interval is done the same way. 
the formula giving was T= Tin.  (Tin.  Tint.)e (v/v)
Where Tin = 1.7 degrees C
and Tin is the to the temperature of the cold water flowing into the tank