Develop a spreadsheet that looks exactly like the one below.

Follow the NFPA procedure for thrust block design and find the thrust block areas for the condition below.

The yellow blocks should be used to calculate the gold blocks with the forces and the final areas.

A user should be able to change any yellow cell and the sheet will update. The grader will change one or more cells to confirm the new result.

The green cells for the block areas should copy the values from the force section.

You will compute the thrust block areas for $4,6,8,10$ and $12$ inch ductile iron pipes.

$px$ and py are the net pressure in the $x$ and $y$ direction summed over the inlet and outlet.

For a $45$ bend and a $100$ psi pipe pressure, $px=29\mathrm{.}3$ and $py=71\mathrm{.}7.$ With pipe area, you can find the total force as we did in class.

$\backslash$table$[[$Pressure $($psi$),100,,,,],[,,,,,],[,,,,,],[,$Force $($lbs$),,,],[$Diameter$,,$Angle,,lb$/$in$2],[($inches$),$Tee,$90,,px=F\frac{x}{?}$ unit area $py=F\frac{y}{?}$ unit area$],[,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[$Soil bearing capacity,,$1000,$psf$,,],[$Safety Factor,,$1\mathrm{.}5,,,],[,,,,,],[$Thrust block size,,$FSf=$AtSb,,,$],[,,,,,],[,,$Area$(ft2),,,],[$Diameter$,,$Angle,,,$],[($inches$),$Tee,$90,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,],[,,,,,]]$