Chemstry/(microsoft excel)
posted by Kadeem .
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;

Chemstry/(microsoft excel) 
DrBob222
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.
Respond to this Question
Similar Questions

Math
A pan of cold water with a temeprature of 35 degrees F is brought into a room with a temperature of 75 degrees F. After one hour, the temperature in the pan is 45 degrees F. a) Write a formula for the temperature (T) as a function … 
Excel Problem
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 … 
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 … 
physics
Equal 0.400kg mass of lead and tin at 60 degrees celsius are placed in 1kg of water at 20 degrees celsius. a) what is the equilibrium temperature of the system? 
PreCalc
You are taking a road trip in a car without A/C. The temperture in the car is 93 degrees F. You buy a cold pop at a gas station. Its initial temperature is 45 degrees F. The pop's temperature reaches 60 degrees F after 23 minutes. … 
Physics
A 250 g piece of tin at 99°C is dropped in 100 g of water at 10°C. If the final temperature of the mixture is 20°C, what is the specific heat of the tin? 
Math (Word Problem into formula)
A chemist is studying the properties of a bronze alloy (mixture) of copper and tin. She begins with 6 kg of an alloy that is one sixth tin. Keeping the amount of copper constant, she adds small amounts of tin to the alloy. Letting … 
Physcial Science
A friend infers from the graph that the temperature of a 10.0g sample of iron would rise 110 degrees Celsius. What should she ask before using the graph this way. (btw the graph depicts that 1 gram of aluminum's temperature rises … 
Thermochemistry
A piece of tin is heated to 695 °C and dropped into 158 g of water at 23.2 °C. The temperature of the system rises to 30.7 °C. What is the mass of the tin dropped into the water? 
Thermochemistry
A piece of tin is heated to 695 °C and dropped into 158 g of water at 23.2 °C. The temperature of the system rises to 30.7 °C. What is the mass of the tin dropped into the water?