
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
LMS Integrated for MindTap Engineering, 2 terms (12 months) Printed Access Card for Moavni's Engineering Fundamentals: An Introduction to Engineering, 5th
- Q3: The scanning process was completed from point F to point G. The direction of the line Fl and the angles of deviation and interior are shown in the figure below. Find the direction of the remaining sides? Azimn = 60° F 52° 52° 72° R= 572.958/D ° T-R tan(A/2) • LC 2R sin (A/2) • E-R (sec(A/2)-1) • M-R (1-cos (A/2)) L= 10 A/D •C=2R sin(2D/2) • d=Dc/10 c' 2R sin (d/2) • Y= √√R2-X2-K • K= R2- K=R-M G H معادلات :مفيدةarrow_forwardPlease write me Background Reviews;arrow_forwardQ1/ The specific gravity of the soil is 1.41 percentage of water content by weight at field capacity and wilting point are 15% and 7% respectively calculate the equivalent moisture content as equivalent depth for 1.2m root zone : 1. at permanent wilting point 2. at field capacity 3. for ready available waterarrow_forward
- Kindy explain the pie chart percentage and give some related study and references about Value of travel time connected to the pie chartarrow_forwardConsider the specifications for an asphaltic concrete mixture and the results of a sieve analysis below. Coarse aggregates: Fine aggregates: Filler: 60% 35% 5% Percent of Weight of Aggregate or Filler Passing Sieve Designation Retained on Sieve Designation Coarse Aggregate Fine Aggregate Mineral Filler 3/4 in. (19 mm) 1/2 in. 6 1/2 in. (12.5 mm) 3/8 in. 15 3/8 in. (9.5 mm) No. 4 50 - No. 4 (4.75 mm) No. 10 20 1 No. 10 (2 mm) No. 40 (0.425 mm) No. 40 9 35 - No. 80 31 40 No. 80 (0.180 mm) No. 200 (0.075 mm) Total No. 200 - 33 - - 25 35 100 100 100 Determine the proportion of different aggregates to obtain the required gradation. Percent of Total Weight of Mixture Passing Sieve Designation Retained on Sieve Designation Coarse Aggregate Fine Aggregate 3/4 in. (19 mm) 1/2 in. (12.5 mm) 3/8 in. (9.5 mm) 1/2 in. 3/8 in. No. 4 No. 4 (4.75 mm) No. 10 No. 10 (2 mm) No. 40 No. 40 (0.425 mm) No. 80 No. 80 (0.180 mm) No. 200 No. 200 (0.075 mm) Total Need Help? Read It Mineral Filler Total 100arrow_forwardResults obtained from laboratory tests on a sample of RC-250 asphalt cement are given. Determine whether the properties of this material meet the Asphalt Institute specifications for this type of material; if not, note the differences. (For each specification, enter the minimum acceptab value in the same units as used in the test results.) • Kinematic viscosity at 140°F (60°C) = 230 centistokes • Flash point (Tagliabue open cup) = 89°F • Distillation test where distillate percent by volume of total distillate to 680°F (360ºC) • To 437°F (225°C) = 27% • To 500°F (260°C) = 69% • To 600°F (316°C) = 72% • Residue from distillation to 680°F (360°C) by volume percentage of sample by difference • Tests on Residue from Distillation: • Ductility at 77°F (25°C) = 92 cm • Absolute viscosity at 140°F (60°C) = 620 poises ⚫ Solubility = 90% Property Kinematic Viscosity = 74% Specification Test Results Were Specifications Met? centistokes 230 centistokes ---Select--- ✓ Flash Point °F 89°F…arrow_forward
- Problem 2 Two machines produce rivets for a factory job. The number of sub-standard rivets per hour by the two machines are random variables, denoted by X1 and X2. The bivariate PMF of X1 and X2, Px,x,(x1,x2), is given in the table below. X2=0 X2=1 X2=2 X2=3 X₁-0 0.07 0.05 0.02 0.01 X₁ =1 0.05 0.16 0.12 0.02 X₁ =2 0.02 0.12 0.17 0.05 X₁ =3 0.01 0.01 0.05 0.07arrow_forwardPlease provide a handwritten solution to the questionarrow_forwardPlease solve the question by hand with a detailed explanation of the steps.arrow_forward
- Please provide a handwritten solution to the questionarrow_forwardplease helparrow_forwardAS Q1/ The specific gravity of the soil is 1.41 percentage of water content by weight at field capacity and wilting point are 15% and 7% respectively calculate the equivalent moisture content as equivalent depth for 1.2m root zone : 1. at permanent wilting point 2. at field capacity 3. for ready available waterarrow_forward
- Engineering Fundamentals: An Introduction to Engi...Civil EngineeringISBN:9781305084766Author:Saeed MoaveniPublisher:Cengage Learning
