Hi
I need to create a spreadsheet to calculate the volume of the solid shown in the attached PDF (of my spreadsheet). It is hard to describe the solid, but it has two intersecting curved surfaces that are throwing me off. The attempt shown in the PDF is incomplete, as I had overlooked the intersecting curves, and now I'm stumped.
Note: the bottom surface is a rectangle, but the top face is not. The side and end views should help. Let me know if the views are confusing.
Also, using CAD, I know the volume is 5.12 m³, but I need to be able to calculate it with a spreadsheet for my purposes. I'm not expecting a finished spreadsheet, just some help with the formulae. I can share the Excel spreadsheet via Dropbox or similar if required.
Thanks in advance for your help!
I need to create a spreadsheet to calculate the volume of the solid shown in the attached PDF (of my spreadsheet). It is hard to describe the solid, but it has two intersecting curved surfaces that are throwing me off. The attempt shown in the PDF is incomplete, as I had overlooked the intersecting curves, and now I'm stumped.
Note: the bottom surface is a rectangle, but the top face is not. The side and end views should help. Let me know if the views are confusing.
Also, using CAD, I know the volume is 5.12 m³, but I need to be able to calculate it with a spreadsheet for my purposes. I'm not expecting a finished spreadsheet, just some help with the formulae. I can share the Excel spreadsheet via Dropbox or similar if required.
Thanks in advance for your help!