Question

In: Civil Engineering

How do you calculate the overturning moment for each story of the building in Excel. Suppose...

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

Solutions

Expert Solution

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


Related Solutions

How do you calculate the overturning moment for each story of the building in Excel. Suppose...
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...
How do you calculate the overturning moment for each story of the building in Excel. Suppose...
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...
How do you calculate Profit Present Value in excel?
How do you calculate Profit Present Value in excel?
How do you make an excel spreadsheet that will enable users to calculate and compare 3...
How do you make an excel spreadsheet that will enable users to calculate and compare 3 car loans? The table should include the total amount paid for given loan amount with different interest rates and number of finance months
How do you calculate Payback Period on Excel by using FAME function? What is the formula?
How do you calculate Payback Period on Excel by using FAME function? What is the formula?
How would you calculate this with an excel formula on excel: •What is the future value...
How would you calculate this with an excel formula on excel: •What is the future value of the following cash flows if the discount rate is 8%? What is the future value if the discount rate is 5%? (this is asking you take the future value of the cash flows. Please find the future value at year 4. ))
A retailer pays $190,000 rent each year for its two-story building. The space in this building...
A retailer pays $190,000 rent each year for its two-story building. The space in this building is occupied by five departments as specified here. Jewelry department 1,470 square feet of first-floor space Cosmetics department 3,430 square feet of first-floor space Housewares department 2,058 square feet of second-floor space Tools department 980 square feet of second-floor space Shoes department 1,862 square feet of second-floor space The company allocates 60% of total rent expense to the first floor and 40% to the...
how do you add the chart in excel?
how do you add the chart in excel?
The property you are appraising is a five-story office building. Each floor has 10,000 square feet...
The property you are appraising is a five-story office building. Each floor has 10,000 square feet of rentable space and is suitable for single occupancy. Two tenants have leases. Floor 3 is occupied under a five-year lease with three years remaining. The current rental is $128,600 per year. Floor 4 is occupied under a new five-year lease and the rent is $150,000 per year. Floors 1, 2, and 5 are vacant. The rent being paid for the fourth floor is...
How do I calculate the bin minimum, maximum, and length in Microsoft Excel?
How do I calculate the bin minimum, maximum, and length in Microsoft Excel?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT