[ \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 ]
Have you built or used an AASHTO flexible pavement design Excel spreadsheet? Share your templates, macros, or troubleshooting tips in the comments below. aashto flexible pavement design excel spreadsheet
First, compute (D₁_min from structural or min construction – say 2 inches). If SN₁ alone insufficient, add base: [ \log_10(W_18) = Z_R \times S_o + 9
Enter the —a powerful, accessible tool that automates iterations, visualizes layer thickness, and ensures compliance with AASHTO 1993 standards. If SN₁ alone insufficient, add base: Enter the
= A21 - LOG10( Input_ESALs ) Goal Seek: Set cell A22 to value 0 by changing cell A20. Create a VBA button:
In cell A22, compute the difference:
Then: D₂ = SN₂_required / (a₂ × m₂)