Perl Monk, Perl Meditation PerlMonks

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

by eduardo (Curate)
 on Jul 01, 2003 at 00:30 UTC ( #270371=note: print w/replies, xml ) Need Help??

in reply to Re: Alpha base-26 to base-10...
in thread Alpha base-26 to base-10...

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.

Replies are listed 'Best First'.
Re: Re: Re: Alpha base-26 to base-10...
by wolfger (Deacon) on Jul 01, 2003 at 00:33 UTC
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

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).

We're all going to hell for resurrecting a dead thread, but how do you do double digits without a zero? Still, I think you've got the right idea. The alphabet is best used as a base-26 system, with A as zero. So AA would be the same as A. Z is 25, BA is 26, and so forth.

Now I'm curious to see how the Mayans did math...

I think you will find it's called Bijective base 26 (non 0 Alpha) to base 10

Create A New User
Node Status?
node history
Node Type: note [id://270371]
help
Chatterbox?
 [jedikaiti]: :-)

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (13)
As of 2017-07-24 15:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
Voting Booth?
I came, I saw, I ...

Results (355 votes). Check out past polls.