This project entails designing a cross section at mid span of a simply$-$supported beam $($given span length and loads$)$ and preparing a report of your calculations, a drawing, and narrative. You will develop a spreadsheet that calculates Mu at mid span of the beam and of Mn for the cross section that you design. Below are items that need to be included in the spreadsheet. This includes checks for bending moment strength, minimum beam width, minimum area of steel, and ductility $($tension$-$controlled$).$ Indicate units next to each input or calculated value. When checking whether a requirement is satisfied, the spreadsheet should return $"$OK$"$ or $"$NG$"$ next to the checked item.

Your spreadsheet should have cells for inputting the parameters below. The instructor will give you values for the items with an asterisk$*$ when you turn in your group members' names.

Span length, L$*$

Superimposed dead load $($distributed$),$ ySDI $*$

Live load $($distributed$),$ wha $*$

Superimposed dead load $($concentrated$),$ PSDL $*$

Live load $($concentrated$),$ PLL $*$

Concrete compressive strength, fe$*$

Aggregate diameter $*$

Density of reinforced concrete, $r,$ for load calculations

Density of reinforced concrete for material property $($Eq$)$ calculations

Yield strength of bars, fx$*$

Beam width, b

Beam height, h

Stirrup diameter, d s$*$

Required cover to stirrup

Required cover to longitudinal steel

Required clear distance between longitudinal bars in a layer

No$.$ of steel reinforcing bars in tension

Size of tensile reinforcing bars

Diameter of tensile reinforcing bars

In your spreadsheet, include calculations for:

Self$-$weight of beam, per foot, wSWX

Self$-$weight moment at mid span, Msww

Superimposed dead load moment at mid span, MSDL

Live load moment at midspan, MLLI

Show your formula for calculating Mu $,$ including load factors used

Ultimate moment, Mu

Distance from extreme compressive fiber to centroid of tensile steel, d $($this shall provide adequate cover to the stirrup and longitudinal steel$)$

Minimum beam width that will provide adequate clear distance between the longitudinal bars, b min

Check that b min is satisfied

Area of tensile reinforcement, As

Minimum area of steel requirement per ACI, As$,$min

Check that As meets the minimum area of steel requirement

b$1$

Use of C $=$ T to calculate depth of uniform compression block, a

Depth to neutral axis, c

Strain in tensile steel, e s $($and check for yielding$)$

Strain in tensile steel, e s $($and check that section is tension$-$controlled$)$

Phi, f

Bending moment design strength, fMa.

Check that $fM{o}^3$

Modulus of elasticity of concrete, Es

Moment due to unfactored $($service$)$ loads, Ma

For the service moment, Ma $,$ check whether the beam is cracked

For the service moment that you calculated, determine the moment of inertia that you would use to calculate mid span deflection of the beam

Mid span deflection of the beam under service loads

Long$-$term deflection of the beam, assuming that the self$-$weight and superimposed