PLEASE SHOW FORMULAS IN EXCEL
NAME SN MEC 32P-2 October 11, 2021 PROJECT FOR MODULE 3 MRS. DIVINA GONZALES SEAT # Microsoft Excel SHEAR AND MOMENT DAGRAMS Dando HI BOX TAX - 0BVER1. A. Ard Create a program that will compute and graph the of the shear and moment values of the beam loaded as shown. After computing the shear and moment diagram, calculate also the resulting beam shearing stress, flexural stress and the maximum deflection in the given steel I beam. Encode at least 20 steel I beam of your choice from the table on the appendix given in Module 2 for the properties of the wide flanged section. 2 wdi wil wa 40 50 141 T . SHEAR DIAGRAM 300.000 100.000 100.000 200 000 200 000 100 000 1000 0000 0.500 1.000 1.000 2000 2000 1000 100.000 BEAMLINT MABSOLUTE a w N/m b 778427 w N/m 52 09 16 20 Lm Lm MOMENT DIAGRAM 15 LENGTH= 3.50 RB 493.50 M= -363.63 She X X M 0.000453900 00000 OU 100.000 017574 7 150 9000 3 09 093 . DO 000 D01 00 . 1086460 100 12 1305 13 1400 150 14003 151391435 1990 1750 4750 175015 15 2220 1905AN 12 200 112212222 2795 10 2016 2450 10 2 20 18 2000 2000 2001 11 350 150 15 11 3305 315 20 3.500 30 00 35 MAX MOMENTS MAX SHEAR: MOON 2020 IN 120 21 22 3000 100.000 0.001 W N/m 23 * T 180 D -0.000 400.000 100000 0.000 100 000 am 30 am DU 863.625 493.50 000000 Lm MERHADERNO MOMENT CANTILEVER 37 CAS start > COMPUTER ACCOUNT SE Home AND SHARM a 9 SAMPLE COMPUTATION: DAM wdl 40 wil 50 w 141 LENGTH P a . W N/m a Lm EN MORAM Lm R2 1 31 4) R1 N: 1110 Ri MAX MOMENT.6345 MOMENT MAX SHEAR 423.00 Nowy BRILLA . .4ual stan AN NAME SN MEC 32P-2 October 11, 2021 PROJECT FOR MODULE 3 MRS. DIVINA GONZALES SEAT # Microsoft Excel SHEAR AND MOMENT DAGRAMS Dando HI BOX TAX - 0BVER1. A. Ard Create a program that will compute and graph the of the shear and moment values of the beam loaded as shown. After computing the shear and moment diagram, calculate also the resulting beam shearing stress, flexural stress and the maximum deflection in the given steel I beam. Encode at least 20 steel I beam of your choice from the table on the appendix given in Module 2 for the properties of the wide flanged section. 2 wdi wil wa 40 50 141 T . SHEAR DIAGRAM 300.000 100.000 100.000 200 000 200 000 100 000 1000 0000 0.500 1.000 1.000 2000 2000 1000 100.000 BEAMLINT MABSOLUTE a w N/m b 778427 w N/m 52 09 16 20 Lm Lm MOMENT DIAGRAM 15 LENGTH= 3.50 RB 493.50 M= -363.63 She X X M 0.000453900 00000 OU 100.000 017574 7 150 9000 3 09 093 . DO 000 D01 00 . 1086460 100 12 1305 13 1400 150 14003 151391435 1990 1750 4750 175015 15 2220 1905AN 12 200 112212222 2795 10 2016 2450 10 2 20 18 2000 2000 2001 11 350 150 15 11 3305 315 20 3.500 30 00 35 MAX MOMENTS MAX SHEAR: MOON 2020 IN 120 21 22 3000 100.000 0.001 W N/m 23 * T 180 D -0.000 400.000 100000 0.000 100 000 am 30 am DU 863.625 493.50 000000 Lm MERHADERNO MOMENT CANTILEVER 37 CAS start > COMPUTER ACCOUNT SE Home AND SHARM a 9 SAMPLE COMPUTATION: DAM wdl 40 wil 50 w 141 LENGTH P a . W N/m a Lm EN MORAM Lm R2 1 31 4) R1 N: 1110 Ri MAX MOMENT.6345 MOMENT MAX SHEAR 423.00 Nowy BRILLA . .4ual stan AN
