ENGN 110 Assignment: Beam Deflection Parametric Problem This assignment must be completed using Excel (If not you will receive zero points) Your grade will be based on the following areas: 50% - Correctness of the solution . 50% - Spreadsheet formatted according to the guidelines for creating engineering spreadsheets from module 7 The vertical deflection of the beam in the figure below is given by the following equation: A = - ( W x ) 24 ( E . I) (1' -2LX) + x' ) The allowable beam deflection in inches is determined from the following equation (length must be in inches): A allowable L 360 V2 WIL Symbol Variable Name Unit A Vertical deflection in allowable Allowable beam deflection in X Distance from left support in L Beam length in Wo Distributed load Ib/ft E Modulus of elasticity b/in? Moment of inertia in4 Properties of the Beam Length 30 ft Modulus of elasticity 29,000,000 1b/in Moment of inertia 510 in Distributed load 850 1b/ft Create an engineering spreadsheet in Excel to calculate the beam's deflection every 1 it from the left support. Determine the allowable beam deflection and state if the deflection at each foot is acceptable. Watch your units use an appropriate number of significant figures