Whether you are a junior engineer learning pavement design or a veteran project manager reviewing submittals, mastering this spreadsheet will streamline your work, reduce errors, and produce cost-effective, durable flexible pavements.
Without the spreadsheet, this would take three iterations and a page of scratch work. aashto flexible pavement design excel spreadsheet
LogW18_pred = Z_R * S_o + 9.36*LOG10(SN+1) - 0.20 + LOG10(ΔPSI/2.7) / (0.40+1094/(SN+1)^5.19) + 2.32*LOG10(M_R) - 8.07 Whether you are a junior engineer learning pavement
The following is an example of an AASHTO flexible pavement design Excel spreadsheet: and produce cost-effective
log base 10 of open paren cap W sub 18 close paren equals cap Z sub cap R center dot cap S sub o plus 9.36 center dot log base 10 of open paren cap S cap N plus 1 close paren minus 0.20 plus the fraction with numerator log base 10 of open bracket the fraction with numerator cap delta cap P cap S cap I and denominator 4.2 minus 1.5 end-fraction close bracket and denominator 0.40 plus the fraction with numerator 1094 and denominator open paren cap S cap N plus 1 close paren to the 5.19 power end-fraction end-fraction plus 2.32 center dot log base 10 of open paren cap M sub cap R close paren minus 8.07