Thinking Like an Engineer: An Active Learning Approach (4th Edition)
Thinking Like an Engineer: An Active Learning Approach (4th Edition)
4th Edition
ISBN: 9780134639673
Author: Elizabeth A. Stephan, David R. Bowman, William J. Park, Benjamin L. Sill, Matthew W. Ohland
Publisher: PEARSON
bartleby

Videos

Textbook Question
Book Icon
Chapter 10, Problem 5RQ
  1. 5. You enjoy drinking coffee but are particular about the temperature (T) of your coffee. If the temperature is greater than or equal to 70 degrees Celsius [0C], the coffee is too hot to drink; less than or equal to 45°C is too cold by your standards. Your coffee pot produces coffee at the initial temperature (T0). The cooling of your coffee can be modeled by the following equation, where time (t) and the cooling factor (k) are in units per second:

    T = T0ekt

    1. a. At the top of the worksheet, create an area where the user can modify four properties of the coffee. For a sample test case, enter the following data.
      • Initial temperature (T0); for the initial problem, set to 80°C.
      • Cooling factor (k); set to 0.001 per second (s–1].
      • Temperature above which coffee is “Too Hot” to drink (Thot); set to 70°C.
      • Temperature below which coffee is “Too Cold” to drink (Tcold); set to 45°C.
    2. b. Create a temperature profile for the coffee:
      • In column A, generate a time range of 0–300 seconds, in 15-second intervals.
      • In column B, generate the temperature of the coffee, using the equation given and the input parameters set by the user (T0 and k).
    3. c. In column B, the temperature values should appear on a red background if the coffee is too hot to drink, and a blue background if it is too cold using conditional formatting.
  2. d. In column C, create a warning next to each temperature that says “Do Not Drink” if the calculated temperature in column B is too hot or too cold in comparison with the temperature values the user enters.

A sample worksheet is shown here for the test case described in part (a).

    Coffee Parameters
Initial Temperature(T0) 80 [°C]
Cooling Factor(k) 0.001 [1/s]
Too Hot Temperature(Thot) 70 [°C]
Too Cold Temperature (Tcold) 45 [°C]
Time[S] Temperature [deg C] Warning!
0 80 Do not Drink
15 79 Do not Drink
30 78 Do not Drink
45 76 Do not Drink
60 75 Do not Drink
75 74 Do not Drink
90 73 Do not Drink
105 72 Do not Drink
120 71 Do not Drink
135 70  
150 69  
165 68  
180 67  
Blurred answer
Students have asked these similar questions
: +0 usão العنوان on to A vertical true centrifugal casting process is used to produce bushings that are 250 mm long and 200 mm in outside diameter. If the rotational speed during solidification is 500 rev/min, determine the inside radii at the top and bottom of the bushing if R-2R. Take: -9.81 mis ۲/۱ ostrar
: +0 العنوان use only In conventional drawing of a stainless steel wire, the original diameter D.-3mm, the area reduction at each die stand r-40%, and the proposed final diameter D.-0.5mm, how many die stands are required to complete this process. он
In non-continuous dieless drawing process for copper tube as shown in Fig. (1), take the following data: Do-20mm, to=3mm, D=12mm, ti/to=0.6 and vo-15mm/s. Calculate: (1) area reduction RA, (2) drawing velocity v. Knowing that: t₁: final thickness D₁ V. Fig. (1) D

Chapter 10 Solutions

Thinking Like an Engineer: An Active Learning Approach (4th Edition)

Ch. 10.6 - In 1980, the Environmental Protection Agency (EPA)...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - A B C D E F 1 2 45 3 meters 4...Ch. 10 - ICA 10-5 The worksheet shown here was designed to...Ch. 10 - The worksheet provided was designed to calculate...Ch. 10 - Some alternate energy technologies, such as wind...Ch. 10 - The worksheet shown was designed to calculate the...Ch. 10 - The worksheet shown was designed to calculate the...Ch. 10 - Refer to the following worksheet. The following...Ch. 10 - Write the output value that would appear in a cell...Ch. 10 - Write the output value that would appear in a cell...Ch. 10 - Refer to the following worksheet. In all...Ch. 10 - Prob. 14ICACh. 10 - A bioengineer conducts clinical trials on...Ch. 10 - Refer to the Worksheet shown, set up to calculate...Ch. 10 - You are interested in analyzing different implant...Ch. 10 - You have a large stock of several values of...Ch. 10 - We accidentally drop a tomato from the balcony of...Ch. 10 - You are interested in calculating the best place...Ch. 10 - 1. A history major of your acquaintance is...Ch. 10 - Prob. 2RQCh. 10 - 3. A phase diagram for carbon and platinum is...Ch. 10 - 4. A simplified phase diagram for cobalt and...Ch. 10 - 5. You enjoy drinking coffee but are particular...Ch. 10 - 6. In the 1950s, a team at Los Alamos National...Ch. 10 - Use the following phase diagram for questions 7...Ch. 10 - Use the following phase diagram for questions 7...Ch. 10 - Use the following phase diagram for questions 9...Ch. 10 - Use the following phase diagram for questions 9...Ch. 10 - 11. When liquid and vapor coexist in a container...Ch. 10 - 12. The ideal gas law assumes that molecules...Ch. 10 - One of the NAE Grand Challenges for Engineering is...Ch. 10 - 15 Create an Excel worksheet that will allow the...Ch. 10 - Prob. 16RQ

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Knowledge Booster
Background pattern image
Mechanical Engineering
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, mechanical-engineering and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Principles of Heat Transfer (Activate Learning wi...
Mechanical Engineering
ISBN:9781305387102
Author:Kreith, Frank; Manglik, Raj M.
Publisher:Cengage Learning
Dimensional Analysis - in physics; Author: Jennifer Cash;https://www.youtube.com/watch?v=c_ZUnEUlTbM;License: Standard youtube license