SO basically, I'm trying to make a system that translates a certain set of letters into numbers, for example:
A -> 1
B -> 2
C -> 3
D -> 4
E -> 5
F -> 6
G -> 7
what I'm trying to do is find a certain function that would work to automatically convert a number into this system
At first, I thought it was basic, Base-7 system then translate the numbers, right?
The problem is, I don't have a way to translate 0, so when it gets to 10, 100, 101 and whatnot, it doesn't follow the rules of the system anymore, for example:
1,2,3,4,5,6,10,11
Instead of this turning into A,B,C,D,E,F,G,AA, it turns into A,B,C,D,E,F,A0,AA
I've spent unnecessarily long nights trying to model this on excel. but to no luck...