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 and what would it be. 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

Enter data from A1 to C7 as in images

Type Formula in cell D2,E2,F2,G2,H2,I2,J2 as in images

select the cells D2,E2,F2,G2,H2,I2,J2 and drag it down, this will copy the formula