Increment Alphanumeric List

Find this formula in D1 of the attached filled down to row 5000. It will work in Excel 2013 and newer.

Formula:

=BASE(DECIMAL("AA",36)+CEILING(ROWS($A$1:$A1)/(59*9),1)-1,36)&MOD(CEILING(ROWS($A$1:$A1)/9,1)-1,59)+11&

TEXT(MOD(ROWS($A$1:$A1)-1,9)+1,"000")

PS I haven't found a way to make it stop after YD yet. Working on it.