Concept explainers
Create a table that shows the windchill temperatures for the given range of ambient air temperature and wind speed.
Answer to Problem 19P
A table is created for the windchill temperatures with the given range of ambient air temperature and wind speed by using excel.
Explanation of Solution
Given data:
The range of ambient air temperature is
The range of wind speed is
Formula used:
Formula to calculate the more common equivalent windchill temperatures is,
Here,
Calculation:
Refer to the Figure 1:
Column A shows the wind speed (V) with range from
For the cell B9, the formula used to find the equivalent windchill temperatures as “
Written as “=(0.045*((5.27*($A$9)^0.5)+10.45-(0.28*$A$9))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is
For the cell B10, the formula used to find the equivalent windchill temperatures as “
Written as “=(0.045*((5.27*($A$10)^0.5)+10.45-(0.28*$A$10))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is
For the cell B11, the formula used to find the equivalent windchill temperatures as “
Written as “=(0.045*((5.27*($A$11)^0.5)+10.45-(0.28*$A$11))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is
For the cell B12, the formula used to find the equivalent windchill temperatures as “
Written as “=(0.045*((5.27*($A$12)^0.5)+10.45-(0.28*$A$12))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is
For the cell B13, the formula used to find the equivalent windchill temperatures as “
Written as “=(0.045*((5.27*($A$13)^0.5)+10.45-(0.28*$A$13))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is
For the cell B14, the formula used to find the equivalent windchill temperatures as “
Written as “=(0.045*((5.27*($A$14)^0.5)+10.45-(0.28*$A$14))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is
For the cell B15, the formula used to find the equivalent windchill temperatures as “
Written as “=(0.045*((5.27*($A$15)^0.5)+10.45-(0.28*$A$15))*(B8-33))+33”. Here, B8 cell represents the value of ambient air temperature is
Table 1 is created to shows a Wind Chill Temperature.
Table 1
Wind speed (Km/h) | Ambient Temperature | ||||||||
-30 | -25 | -20 | -15 | -10 | -5 | 0 | 5 | 10 | |
20 | -47.6 | -41.2 | -34.8 | -28.4 | -22.0 | -15.6 | -9.2 | -2.8 | 3.6 |
30 | -54.6 | -47.7 | -40.7 | -33.8 | -26.8 | -19.9 | -12.9 | -6.0 | 1.0 |
40 | -59.4 | -52.0 | -44.7 | -37.4 | -30.0 | -22.7 | -15.4 | -8.1 | -0.7 |
50 | -62.6 | -55.0 | -47.4 | -39.8 | -32.2 | -24.7 | -17.1 | -9.5 | -1.9 |
60 | -64.7 | -57.0 | -49.2 | -41.5 | -33.7 | -25.9 | -18.2 | -10.4 | -2.7 |
70 | -66.1 | -58.2 | -50.3 | -42.5 | -34.6 | -26.8 | -18.9 | -11.0 | -3.2 |
80 | -66.8 | -58.8 | -50.9 | -43.0 | -35.1 | -27.2 | -19.3 | -11.3 | -3.4 |
Figure 2 shows a wind chill table in the excel sheet has obtained as similar to given Problem 14.19 in the textbook
Conclusion:
Hence, a table is created for the windchill temperatures with the given range of an ambient air temperature, and wind speed have been explained using excel.
Want to see more full solutions like this?
Chapter 14 Solutions
ENGINEERING FUNDAMENTALS
- Using the information given in Table 10.4, determine the ratio of local pressure and density to sea-level values. Estimate the value of air density at the cruising altitude of most commercial airliners. Altitude (m) sealevel PPsealevel 0 (sea level) 1000 3000 5000 8000 10,000 12,000 14,000 15,000arrow_forwardProblem 2. 45. According to Newton's law of cooling, the rate at which a substance cools in air is directly proportional to the difference between the temperatures of the substance and that of air. If the temperature of the air is 30° and the substance cools from 100° to 70° in 15 minutes, how long will it take to cool 100° to 50°?arrow_forwardIf a natural gas has a specific gravity of 0.60 relative to air at 14.70-psi-abs and 68 degrees Fahrenheit. a. Calculate the density of gas at constant pressure and temperature b. Determine its specific weight.arrow_forward
- Question 02 Define by which curve the relation between amount of energy absorbed and test temperature is shown, why? Energy absorbed B Temperaturearrow_forward14.11. As we explained in Chapter 7, the air resistance to motion of a vehicle is something important that engineers investigate. As you may also know, the drag force acting on a car is determined experimentally by placing the car in a wind tunnel. The air speed inside the tunnel is changed, and the drag force acting on the car is measured. For a given car, the experimental data is generally represented by a single coefficient that is called drag coefficient. It is defined by the following relationship: Fa Cả where Ca = drag coefficient (unitless) Fa = measured drag force (N or 1b) p= air density (kg/m³ or slugs/ft') V = air speed inside the wind tunnel (m/s or ft/s) A = frontal area of the car (m? or ft') The frontal area A represents the frontal projection of the car's area and could be approximated simply by multiplying 0.85 times the width and the height of a rectangle that outlines the front of a car. This is the area that you see when you view the car from a direction normal to…arrow_forwardA volume of 25 in of air is measured at a pressure of 30 in HG absolute and a temperature of 70°F. What is the volume in cm3 at 10 psig and 2°C?arrow_forward
- ) Room ventilation is an important area of environmental and architectural engineering for the application of fluid mechanics. Suppose there is a source S (mass per unit time) of air pollution in a room of volume V. Examples include carbon monoxide from cigarette smoke or an unvented kerosene heater, emissions from household cleaning products, and vapors given off by evaporation of volatile organic compounds from an open container. Let C represent the mass concentration (mass of contaminant per unit volume of air) and Q represent the volumetric flow rate of fresh air entering the room. If the room air is well mixed so that the concentration is uniform throughout the room, but varies with time, the differential equation for mass concentration in the room is: Where kw is an adsorption coefficient and As is the surface area of walls, floors, etc., that adsorb some of the contaminant. V.dC/dt = S-QC-Aw.As.C Write the primary dimensions of the first three additive terms in the equation,…arrow_forward13. What is the name for a vector that represents the sum of two vectors? C. scalar A. moment B. torque 14. A diagram which shows only the forces acting on the body. A. cash flow B. forces flow diagram C. free body diagram 15. What is the right equivalent of one horsepower? A. 1126 joules B. 980 volt-amperes C. 746 watts D. resultant D. motion diagram D. All of thesearrow_forwardWhat is the density of air (in kg/m³) at 2 atm at 25 degrees Celsius in kg per cu. Meter if gas constant is 4.015 kJ/(kg-K)? O 0.0169 O 0.0619 O 0.1694 169.4arrow_forward
- 2. The main elevator of the CN tower in Toronto rises about 350 m and for most of its run has a constant speed of 22 kph. Assume that both the acceler- ation and deceleration have a constant magnitude of 0.25g-g standing for gravitational acceleration-then determine the duration of 1 elevator run. Set your own variables for each parameter as you see fit.arrow_forward8. Suppose that an object initially having a temperature of 20 degrees is placed in a large temperature controlled room of 80 degrees and one hour later, the object has a temperature of 35 degrees. What will its temperature be after three hours? (Make sure to show your initial differential equation)arrow_forwardFluid Mechanics question: For a given hypothetical flow, the velocity from time t=0 to t=5s was u=2m/s, v=0. Then, from time t=5s to t=10s, the velocity was u=+3m/s, v=-4m/s. A dye streak was started at a point in the flow field at time t=0, and the path of a particle in the fluid was also traced from that same point starting at the same time. Draw to scale the streakline, pathline of the particle, and streamlines at time t=10s.arrow_forward
- Engineering Fundamentals: An Introduction to Engi...Civil EngineeringISBN:9781305084766Author:Saeed MoaveniPublisher:Cengage Learning