Lab #$4$ Advanced Excel Concepts

Part $2$: Distribution of Slab Load to Columns $($Note that you'll also have to do similar

calculations for your semester project! Use this as a template for those!$)$

A $3-$story structure is about to be constructed on the UMass Amherst flagship campus. The

structural engineer who oversees the construction wants to estimate the load that is applied to

each of the columns. If the total floor load of a $6^(\text{'}\text{'})$ floor $($including the superimposed dead load

from the beams, the slab, the floor tiles, and the ceiling load$)$ is $160$ psf $,$ the floor live load is $70$

psf$,$ and the roof live load is $40$ psf $,$ determine the loads for each column and calculate the total

force at the base of each column. All floors have equal dimensions.

Plan View $($looking at building from the top$)$

Calculate the area of influence for each of the columns $($notice how some of the areas have the same dimensions, so you can copy some of your calculations$).$