Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pyramid calculate
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pyramid calculate
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: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pyramid calculate
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: 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: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pyramid calculate
http://www.easycalculation.com/area/pyramid.php
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: 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: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pyramid calculate
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 Stefi wrote: http://www.easycalculation.com/area/pyramid.php 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: 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: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pyramid diagrams - like food pyramid - How can it be done? | Excel Discussion (Misc queries) | |||
Drawing an Age Pyramid | Charts and Charting in Excel | |||
how can i do an age pyramid? | Excel Discussion (Misc queries) | |||
help for pyramid | Charts and Charting in Excel | |||
Pyramid charts | Charts and Charting in Excel |