I had to run an Excel spreadsheet for climb calculation..
Here is the formula in excel terms..
Code:
=100*tan(asin(vertical climb/length of road))
substitute the "vertical climb" and "the length of road" with the cell locations where they are stored...
Code:
=100*TAN(ASIN(A42/B42))
ex: A42 is the cell where the vertical value is stored , and B42 is the road distance is stored (both must be in the same unit ex. feet)..
Have fun..
If anyone wants an actual spreadsheet, please let me know and Ill post en example here..