Excel Problem
posted by Angel .
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
Respond to this Question
Similar Questions

Caluculus
Can anyone help me with this problem? Suppose that during a controlled experiment, the temperature in a beaker containing some chemical substance at time t is rising at a rate of (15/13)t^2(7t) degrees centigrade per minute. If the 
HELP! MATH
cold yam is put into a hot oven, the temperature of the yam begins to rise. The rate R in degrees per minute at which the temperature rises is governed by Newton's Law of Heating, which says that the rate is proportional to the temperature … 
moles of water produced?
We mixed HCl and NaOH into water and got this table, all for trial 1 Here is all of the info for trial 1: trial 1: volume of 2 M NaOH used: 50.0 mL initial temperature of NaOH: 24.4 degrees C volume of 2 M HCl used: 50.0 mL initial … 
Physics Help!!!
The water in your bathtub is getting cold. You currently have 36 liters at 31°C. What is the new temperature after you add 10 liters of 70°C hot water? 
physics
water 20 degrees celsius flows through a 25 mm diameter pipe at a rate of 50 liters per minute. is this laminar or turbulant flow or both? 
Chemistry
I am having a hard time solving this problem. The formula given is: T=Tin  (Tin  Tinit.)e(v/v)t If the initial temperature Tinit is 115 (degrees F), the cold water temperature is 35 (degrees F) (1.7 degrees C), and the volume and … 
Chemstry/(microsoft excel)
I am having a hard time solving this problem. The formula given is: T=Tin  (Tin  Tinit.)e(v/v)t If the initial temperature Tinit is 115 (degrees F), the cold water temperature is 35 (degrees F) (1.7 degrees C), and the volume and … 
Physics
a BATH CONTAINS 100 KG OF WATER AT 60 DEGREES CELCIUS. HOT AND COLD TAPS ARE THEN TURNED ON TO DELIVER 20KG PER MINUTE EACH A TEMPERATURE 70 DEGREES CELSIUS AND 10 DEGREES CELSIUS RESPECTIVELY. HOW LONG WILL IT BE BEFORE THE TEMPERATURE … 
chemistry
a container with an initial volume of 6 liters at a temperature of 30 degrees celsius with a pressure of 2atm is changed so the temperature is now 90 degrees celsius and the volume is 8 liters. calculate the new pressure 
PHYSICS
A BATH CONTAINS 100 KG OF WATER AT 60 DEGREES CELCIUS. HOT AND COLD TAPS ARE THEN TURNED ON TO DELIVER 20KG PER MINUTE EACH A TEMPERATURE 70 DEGREES CELSIUS AND 10 DEGREES CELSIUS RESPECTIVELY. HOW LONG WILL IT BE BEFORE THE TEMPERATURE …