Perl Monk, Perl Meditation PerlMonks

Re: Alpha base-26 to base-10...

by wolfger (Deacon)
 on Jul 01, 2003 at 00:29 UTC ( #270370=note: print w/replies, xml ) Need Help??

in reply to Alpha base-26 to base-10...

Wow. I can't believe that nobody else has pointed out the fact that you are *not* using a base 26 system correctly.
a=0
z=25
In base 26, there will be no single-character representation of the number 26. Just as there is no single-character representation of 10 in base 10, or 2 in binary.

If you want "blank" = 0, a=1, z=26, then you are using base 27.

```Believe nothing, no matter where you read it, or who said it - even if
I have said it - unless it agrees with your own reason and your own
common sense.
-- Buddha
[download]```

Replies are listed 'Best First'.
Re: Re: Alpha base-26 to base-10...
by eduardo (Curate) on Jul 01, 2003 at 00:30 UTC
Actually tilly pointed out that it's not a real base-26 system in the chatterbox. It's the Excel column numbering system to be precise. The problem is that I have no idea what to call it other than a pseudo base-26ish system in which there is no symbol for 0, and the digits are represented by the letters of the english alphabet.
Well, as you're using it, it's base 27 with no defined symbol for zero. :-)

```Believe nothing, no matter where you read it, or who said it - even if
I have said it - unless it agrees with your own reason and your own
common sense.
-- Buddha
[download]```

It definately isn't base 27, or you would need to use **27 not **26.

It is base-26 in the same way as feet are in inches base 12, or hours are in minutes base 60. The only unusual thing, in computer terms, is that it is a 1-based number system not a 0-based, but in the real world, most things are 1-based.

We measure the months 1 - 12 not 0 - 11, the metres in a kilometer, millimetres in a metre, grams in a kilo etc etc. as 1 - 1000 not 0 - 999

Update:

To reenforce this point. If the system where base-27, then the cycle would repeat every 27 symbol. It doesn't it repeats every 26th. vis. It MUST be base-26.

If it makes people more comfortable to think of it as A representing 0 and Z representing 25, so be it, but for it to be base 27, you would require 27 symbols, but there only 26.

Examine what is said, not who speaks.
"Efficiency is intelligent laziness." -David Dunham
"When I'm working on a problem, I never think about beauty. I think only how to solve the problem. But when I have finished, if the solution is not beautiful, I know it is wrong." -Richard Buckminster Fuller

I know it's been years since the last post on this but I came across it in dealing with the same situation. I'm not seeing how "base27 with no defined symbol for zero" really describes this numbering system either. For example, the 27th integer (if that term really applies here) in the "MS Excel" system would be AA. "AA" in a base27 system would be the 28th integer. Maybe we should call it a Mayan base26 since their base6 system didn't have a zero either (because they never discovered it).
I think you will find it's called Bijective base 26 (non 0 Alpha) to base 10

Log In?
 Username: Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://270370]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (7)
As of 2019-10-18 09:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
Voting Booth?
In 2019 the site I miss most is:

Results (45 votes). Check out past polls.

Notices?