Chemstry/(microsoft excel)
posted by Kadeem on .
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 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 seconds after the flow of cold water is established;

You really don't need an excel program to do this.
heat lost by warm water (3000L) + heat gained by cool water (30L/min) = 0
Five minutes into the operation you have 3000L of 115 C water(convert to C and call that Tinitial for the hot water.That part of the equation is
[mass hot water x specific heat H2O x (TfinalTinitial)]
At 30L/min x 5 min = 150L so that part of the equation is
[mass cool water x specific heat x (TfinalTinitial)] = 0
Tfinal is what you solve for.
Tinitial for warm water is 115F (but converted to C). Tinitial for cold water is 1.7C and Tfinal is what you solve for. Put all that together and you have your first point into the 5min operation. Then just redo the whole thing for the next 5 min cycle. The whole thing looks like this for the first cycle.
[3E6g x sp.h. x (Tfabout 46)] + [150E3g x sp.h. x (Tf1.7)] = 0
Solve for Tf.