#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,494
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
angle from atan Randall_Fos New Users to Excel 2 April 5th 07 01:30 PM
degree or angle ekkeindoha Excel Worksheet Functions 3 January 29th 07 01:54 PM
If I know that a value in a cell is the TAN of an Angle, How do I Dr. Darrell Excel Discussion (Misc queries) 4 August 26th 06 11:22 AM
How to calculate future cost of roof rcortese Excel Worksheet Functions 3 June 30th 06 03:46 AM
How to angle columns? Please Help! Elara Excel Discussion (Misc queries) 3 October 18th 05 03:31 PM


All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"