Aashto Flexible Pavement Design Excel Spreadsheet — ((install))

This is a story about the quiet, calculated victory of an engineer and their digital ally: the AASHTO flexible pavement design Excel spreadsheet

Sheet 2: CALCULATIONS

This sheet performs the heavy lifting. It is usually hidden or locked. aashto flexible pavement design excel spreadsheet

The AASHTO 1993 flexible pavement design procedure uses an empirical equation to determine a Structural Number ( cap S cap N This is a story about the quiet, calculated

[ \log_10(W_18) = Z_R \times S_o + 9.36 \times \log_10(SN+1) - 0.20 + \frac\log_10\left(\frac\Delta PSI4.2 - 1.5\right)0.40 + \frac1094(SN+1)^5.19 + 2.32 \times \log_10(M_R) - 8.07 ] Reliability ( log base 10 of open paren

Estimated cumulative 18-kip Equivalent Single Axle Loads (ESALs) over the pavement's design life. Reliability (

log base 10 of open paren cap W sub 18 close paren equals cap Z sub cap R cross cap S sub 0 plus 9.36 cross 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 cross log base 10 of open paren cap M sub cap R close paren minus 8.07 2. Key Input Variables Needed in the Spreadsheet