Answered step by step
Verified Expert Solution
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
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_reductionStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started