![]() |
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 |
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 |
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 |
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