ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Roof Angle (https://www.excelbanter.com/excel-discussion-misc-queries/232162-roof-angle.html)

Amos Carver

Roof Angle
 
I need to know how to convert the roof pitch stated at 6/12 into degrees. I
know I have a rise of six inches per foot. I am using Excel 2007 and cannot
seem to get the formula correct. Please help me out. This is really bugging
me Thanks
--
Amos

FSt1

Roof Angle
 
hi
in trig...
TAN(a)=Rise/Run
but all that will give you is 50% slope(grade).
see this site....
http://www.1728.com/gradient.htm
it will calculate degrees, grades, etc.

I think you want to calculate ratio.

Regards
FSt1

"Amos Carver" wrote:

I need to know how to convert the roof pitch stated at 6/12 into degrees. I
know I have a rise of six inches per foot. I am using Excel 2007 and cannot
seem to get the formula correct. Please help me out. This is really bugging
me Thanks
--
Amos


Gary Keramidas

Roof Angle
 
maybe this will help

http://www.math.com/school/subject3/.../S3U3L4DP.html



--

Gary Keramidas
Excel 2003


"Amos Carver" wrote in message
...
I need to know how to convert the roof pitch stated at 6/12 into degrees.
I
know I have a rise of six inches per foot. I am using Excel 2007 and
cannot
seem to get the formula correct. Please help me out. This is really
bugging
me Thanks
--
Amos



learnlearn52

Roof Angle
 


"Amos Carver" wrote:

I need to know how to convert the roof pitch stated at 6/12 into degrees. I
know I have a rise of six inches per foot. I am using Excel 2007 and cannot
seem to get the formula correct. Please help me out. This is really bugging
me Thanks
--
Amos


Try this formula:

=DEGREES(ATAN(rise/run))

You can make two columns, the first column being the rise, and the second
column being the run. The third column is the calculated ratio of the
rise/run. In the fourth column type the above formula.


All times are GMT +1. The time now is 09:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com