I figured it out. Excel and Open office do calculations in "Radians" and not degrees. So you have to manually input the cosine of the pitch. For all of you who need this information for you roof take offs, If you would like the file, I have an open office spread sheet with the formulas already done, just let me know you email address and I will send it to you. Be sure you convert you span and overhang into inches first. You will then need to use a calculator to get the cosine of your pitch and input that number into the "COS of Pitch" column. Your end result is the length of your rafter in feet. Sure wish this could be done easier in VW.