Question

How do you calculate the overturning moment for each story of the building in Excel. Suppose we have a 5 story building that is 50 feet tall and each floor is 10 foot high. The force on the 5th floor is 10 kips, on the 4th floor it's 8 kips, on the 3rd floor it's 6 kips, on the 2nd floor it's 4 kips and on the first floor it's 2 kips. Is there a routine you can use in Excel that will calculate this without much effort. The fourth floor will have an overturning moment of 10*10=100; the third floor will have an overturning moment of 10*20+8*10=280; the second floor overturning moment is 10*30+8*20+6*10=520; the first floor's overturning moment is 10*40+8*30+6*20+4*10=800; the base overturning moment is 10*50+8*40+6*30+4*20+2*10=1100

Answer 1

Excel formula can be used, If its single problem or multiple problem case.

Revert back for formula

Drag the formula from D2 to J2 to D7 to J7