Hoping there is a simple-ish formula expression to accomplish this eg, if the input is '26' the output is 'Z' if the input is '52' the output is 'ZZ'
Thanks
Small correction to the helpful workflow from @CoG
In the Generate Rows tool:
original Loop Expression: Floor((PreModulus)/26,1)
corrected Loop Expression: Floor((PreModulus)/26.001,1)
Column number | Manually verified Column Name | incorrect Column Name from original code |
52 | AZ | BZ |
78 | BZ | CZ |
702 | ZZ | AAZ |
Good catch, @ChrisTX !
Unfortunately, I think the "corrected loop expression" will provide incorrect results for absurdly large values (>26000). That being said, thanks to your insights, I was able to finally see clearly what I struggled for so long to see. I have updated the math so that the outputs match what you and now I have manually verified to be correct. This new workflow should work for every input value you can feasibly throw at it.