Pyramid calculate

  • Thread starter Thread starter Michel Norway
  • Start date Start date
M

Michel Norway

How do I calculate a pyramid using existing formels in exel. Exampel if the
pyramid is 10x10 m² and 45˚, and I want to find out m² wall surface.
 
This is not an Excel specific question but if I recall my school studies, in
case of a 45Ëš pyramid the formula is
=(2*A1^2)/SQRT(2)+A1^2 (=241,4213562)

10 being in A1

Sorry if I made a mistake!

Regards,
Stefi

„Michel Norway†ezt írta:
 
Thank you for right answer!!!
Sorry I put the question in wrong group!
Still, if 45Ëš is 30Ëš or something else. (Excuse my english) How can I do that?

Stefi skrev:
 
Still, if 45Ëš is 30Ëš or something else...how can I do that?

I believe this is the equation. x is the side, and d is the angle in
Degrees.

=x^2*(1+SQRT(1+TAN(RADIANS(d))^2))

If x=10, and d=45, then I get the same answer 241,4213562

HTH
Dana DeLouis
 
Back
Top