
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
- A sample of Achilles saturated with water has a mass of 1710 g. After heating in an oven, a constant mass of 1815 g is obtained. The density of solid Achilles seeds is 2.78 g/cm3. We are asked to calculate: a) The water content and void ratio b) The porosity and specific gravity of the clayey soil c) The wet density of the clayey soil, the corresponding dry density and dry densityarrow_forward8. A prestressed concrete beam is subjected to the following stress distributions: Pi is the initial prestressing force, Pe is the effective prestressing force, M, is the bending moment due to self- weight, Ma and M, are the dead load and live load bending moment, respectively. The concrete has the following properties: fr = 6000 psi and fri = 4200 psi +250 -85 -2500 +550 Pe+ Mo+Ma+Mi P alone P₁+ Mo -2450 -3500 Stress at midspan +210 +250 P, alone Pe alone -2500 -3500 Stress at ends Using Table 22.1, evaluate whether the stresses at the center of the span and the end of the span comply with the permissible stress limits. The beam is classified as U-class. Provide justifications for each condition listed in the table. Note: Calculated stresses are to be taken from the above diagram, and permissible stresses are to be calculated using Table 22.1. Compressive stresses immediately after transfer Tensile stresses immediately after transfer Compressive stresses under sustained and total…arrow_forward10. A short column is subjected to an eccentric loading. The axial load P = 1000 kips and the eccentricity e = 12 in. The material strengths are fy = 60 ksi and f = 6000 psi. The Young's modulus of steel is 29000 ksi. (a) Fill in the blanks in the interaction diagram shown below. (2pts each, 10pt total) Po Pn (1) failure range H 3" 30" Ast 6 No. 10 bars = P 22" I e H 3" (4) e = e small Load path for given e Radial lines show constant (2) eb (3) e large failure range Mn (5) e= Mo (b) Compute the balanced failure point, i.e., P and Mb.arrow_forward
- No chatgpt plsarrow_forward11. The prestressed T beam shown below is pretensioned using low relaxation stress-relieved Grade 270 strands. The steel area Aps = 2.5 in². The tensile strength is fpu = 270 ksi, and the concrete compressive strength is fr = 6000 psi. (a) Calculate the nominal moment strength Mn with hr = 6 in. 22" 15" T hf (b) Since this beam is a T-beam, the nominal moment strength M₁ increases with a thicker hf. However, M, stops increasing if he reaches a value. Determine the minimum thickness hy that can achieve the maximum nominal moment strength Mr. Also, calculate the corresponding maximum nominal moment strength Mn with the computed hf.arrow_forward10. A short column is subjected to an eccentric loading. The axial load P = 1000 kips and the eccentricity e = 12 in. The material strengths are fy = 60 ksi and f = 6000 psi. The Young's modulus of steel is 29000 ksi. (a) Fill in the blanks in the interaction diagram shown below. 30" Ast 6 No. 10 bars = Pn (1) Po (4) e = e small Load path for given e failure range Radial lines show constant (2) eb (3) e large failure range Mn (5) e= Mo (b) Compute the balanced failure point, i.e., P and Mb. H 3" P 22" I e H 3"arrow_forward
- 10. A short column is subjected to an eccentric loading. The axial load P = 1000 kips and the eccentricity e = 12 in. The material strengths are fy = 60 ksi and f = 6000 psi. The Young's modulus of steel is 29000 ksi. (a) Fill in the blanks in the interaction diagram shown below. 30" Ast 6 No. 10 bars = Pn (1) Po (4) e = e small Load path for given e failure range Radial lines show constant (2) eb (3) e large failure range Mn (5) e= Mo (b) Compute the balanced failure point, i.e., P and Mb. H 3" P 22" I e H 3"arrow_forward7. Match the given strand profiles with the corresponding loading conditions for a prestressed concrete (PSC) beam. Strand profile (b) (d) (c) (a) Ꮎ Load on a beamarrow_forward4. For serviceability considerations, the effective moment of inertia (Ie) is calculated using the following formula: le 1 - 1cr ((2/3) Mcr) Ma 2 - وا ≥ Note that the upper bound was previously set as Iut in the earlier ACI equation. (a) Arrange the following moment of inertia values in ascending order (from smallest to largest): le, Ier, Ig and lut (b) Mer is the cracking moment. Choose the cross-section that should be used to compute Mcr. NA. h 5. Identify and circle the figure that represents the scenario in which the torsional effect is permitted to be reduced according to the ACI code provisions. (3 pts) mt mi B (b)arrow_forward
- I will rate, thanksarrow_forward. 9. A reinforced concrete beam is subjected to V/ = 40 kips and Tu/ = 12 ft kips at the critical section. Given conditions: ⚫ Longitudinal reinforcements use No. 8 grade 60 steel with an effective depth d = 20 in. For shear capacity, V = 18 kips and V₂ = 22 kips • For transverse reinforcements, use No. 3 bars with grade 60. • The effective torsional area of A. = 150 in². • Crack angle = 45° ⚫ The minimum stirrup spacing is Smin = 4" and the maximum stirrup spacing is Smax = Find the required stirrup spacing at the critical section. 8".arrow_forward3. The beam shown on the right uses three No. 8 bars made of Grade 60 steel as longitudinal reinforcement. The allowable maximum center-to-center spacing of the longitudinal rebars has been determined to be 10 inches. Now assume that Grade 80 steel will be used instead. Determine whether the beam satisfies the rebar spacing requirements according to the ACI Code. Additional assumptions: • Estimate fs = fy • 20" Clear cover: ? 12" Clear side cover: 1.5" The clear cover depth cc and the clear side cover remain unchanged, regardless of the change in material.arrow_forward
- Engineering Fundamentals: An Introduction to Engi...Civil EngineeringISBN:9781305084766Author:Saeed MoaveniPublisher:Cengage Learning
