Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

it still continuous(temperatures data) 2) Data file named material_data.xls contains time, temperature, thermal expansion coefficient, elasticity modulus and yield stress data of the structural steel

image text in transcribedimage text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

it still continuous(temperatures data)

2) Data file named material_data.xls contains time, temperature, thermal expansion coefficient, elasticity modulus and yield stress data of the structural steel material. Sheet named temperature_reduction contains the reduction factors of yield stress of the material with respect to temperature. Please write a code to do the following tasks in order: 1. Read the data file material_data.xls. It has 2 sheets; temperature_data", "temperature_reduction". 2. Create an array that contains Time data from sheet1 in column 1. 3. Create an array that contains Temperature data from sheet 1 in column 2. 4. Create a parameter that contains the Thermal Expansion Coefficient" from sheet 1 in column 3. 5. Create a parameter that contains the Elasticity Modulus from sheet 1 using column 4. 6. Create a parameter that contains the Yield Stress of the material at 20C within the column 5 in the 1st sheet. 7. Create a loop: 7.1 Calculate thermal strain E, at each time increment by using the following expression: where a (see Notel) is the thermal expansion coefficient and AT = Ti-Ti-1. ET = aAT 7.2 Calculate the yield strain Eyield of the material at each time increment using the given values in sheet 2 (temperature_reduction) at each time increment by using the following expressions: yield Eyield where Oyield (see Note2) is the yield stress and E (see Notel) is E the elasticity modulus. 7.3 Take your student ID number's last two digits as a percentage value. For instance, if your student ID number is 110050178, your percentage value is 78%. 7.4 Compare the calculated thermal strain and calculated yield strain at each time increment: 7.4.1 Print a warning message if the thermal strain reaches your percentage value of the yield strain and automatically end the loop. 7.4.2 Print a message that states the material is safe if the thermal strain value never reaches to your percentage value of the yield strain. Note1: Thermal expansion coefficient a and elasticity modulus E are assumed that they do not change with respect to temperature. Note2: Yield stress Oyield changes with respect to temperature according to the reduction factors given in "temperature_reduction sheet. C D E F G un B 1 Temperature (C) Reduction_Factor 2 20 1 3 100 0,965 4 200 0,863 300 0,743 400 0,623 7 500 0,483 8 600 0,271 9 700 0,106 10 800 0,077 11 900 0,031 12 1000 0,014 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 temperature_data temperature_reduction Time(s) Temperature(C) Thermal_Exp_Coeff(1/C) E_Modulus(MPa) Yield_Stress(MPa) 0 20 1,275E-07 132500 2986 1 20 2 20 3 20 4 20 5 20 6 20 7 20 8 20 9 20 10 20 11 20 12 20 13 20 14 20 15 20 16 20 17 20 18 20 19 20 20 20 21 20 22 20 23 20 24 20 25 20 26 20 27 20 28 20 29 20 30 20 31 20 32 20 33 20 34 20 35 20 36 20 temperature_data temperature_reduction + 20 20 20 21 21 21 22 22 22 22 22 22 22 23 23 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 23 24 24 24 24 25 25 25 26 26 26 26 27 27 27 27 27 27 27 28 28 29 1ne 20 temperature data temperature_reduction 2) Data file named material_data.xls contains time, temperature, thermal expansion coefficient, elasticity modulus and yield stress data of the structural steel material. Sheet named temperature_reduction contains the reduction factors of yield stress of the material with respect to temperature. Please write a code to do the following tasks in order: 1. Read the data file material_data.xls. It has 2 sheets; temperature_data", "temperature_reduction". 2. Create an array that contains Time data from sheet1 in column 1. 3. Create an array that contains Temperature data from sheet 1 in column 2. 4. Create a parameter that contains the Thermal Expansion Coefficient" from sheet 1 in column 3. 5. Create a parameter that contains the Elasticity Modulus from sheet 1 using column 4. 6. Create a parameter that contains the Yield Stress of the material at 20C within the column 5 in the 1st sheet. 7. Create a loop: 7.1 Calculate thermal strain E, at each time increment by using the following expression: where a (see Notel) is the thermal expansion coefficient and AT = Ti-Ti-1. ET = aAT 7.2 Calculate the yield strain Eyield of the material at each time increment using the given values in sheet 2 (temperature_reduction) at each time increment by using the following expressions: yield Eyield where Oyield (see Note2) is the yield stress and E (see Notel) is E the elasticity modulus. 7.3 Take your student ID number's last two digits as a percentage value. For instance, if your student ID number is 110050178, your percentage value is 78%. 7.4 Compare the calculated thermal strain and calculated yield strain at each time increment: 7.4.1 Print a warning message if the thermal strain reaches your percentage value of the yield strain and automatically end the loop. 7.4.2 Print a message that states the material is safe if the thermal strain value never reaches to your percentage value of the yield strain. Note1: Thermal expansion coefficient a and elasticity modulus E are assumed that they do not change with respect to temperature. Note2: Yield stress Oyield changes with respect to temperature according to the reduction factors given in "temperature_reduction sheet. C D E F G un B 1 Temperature (C) Reduction_Factor 2 20 1 3 100 0,965 4 200 0,863 300 0,743 400 0,623 7 500 0,483 8 600 0,271 9 700 0,106 10 800 0,077 11 900 0,031 12 1000 0,014 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 temperature_data temperature_reduction Time(s) Temperature(C) Thermal_Exp_Coeff(1/C) E_Modulus(MPa) Yield_Stress(MPa) 0 20 1,275E-07 132500 2986 1 20 2 20 3 20 4 20 5 20 6 20 7 20 8 20 9 20 10 20 11 20 12 20 13 20 14 20 15 20 16 20 17 20 18 20 19 20 20 20 21 20 22 20 23 20 24 20 25 20 26 20 27 20 28 20 29 20 30 20 31 20 32 20 33 20 34 20 35 20 36 20 temperature_data temperature_reduction + 20 20 20 21 21 21 22 22 22 22 22 22 22 23 23 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 23 24 24 24 24 25 25 25 26 26 26 26 27 27 27 27 27 27 27 28 28 29 1ne 20 temperature data temperature_reduction

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions