Excel Calculating arched beam surface area and volume on excel

[Eddy Ardavin]

I was hoping someone had a formula for calculating the surface area of three sides and volume of an rectangular arched beam. current dimensions i have are width = 8" , radius of arch bottom = 2'-10" , length = 7'-8" , maximum height = 2'-6" , minimum height = 1' . Any and all help is greatly appreciated!!!!

 

[Becky]

A diagram would be very helpful

 

[Eddy Ardavin]

i can provide a picture of a similar beam. creating a diagram involves computer skills well beyond my own.

 

[Becky]

Ah ok, this seems like more of an engineering /QS question rather than an Excel question... Normally I'd have a bash at working it out but I'm on strong painkillers at the mo and my brain is fuzzy