I don't know about Excel's pattern abilities. I thought at first I'd do it with IF statements, but the more I tested that the more complicated it got. Instead I treated it as a base-number calculation, using ROW() as the sequential number and calculating each of the three columns. See the attached x.xlsx.
I'm used to R1C1 notation, but most folks prefer A1 so I'll give it a try despite its limitations. Columns X, Y and Z calculate the value of each position—except to make the calculation simpler they go from 0 to 2, 0 to 20 and 0 to 99. Then U, V and W add 1 to each value and convert it to a character string with leading zeroes. In column A you concatenate the three values together with hyphens. You can skip U-V-W and do the conversion and concatenation in column A if you'd rather.
|