one more question regarding counting in different bases

[youbet7469]

Hello,
First want to thank all of you who worked on the counting in bases functions. Your assistance is greatly appreciated.

In our discussion it was deteremined that the correct way to count in bases is
For example base 5:
0-1-2-3-4-10-11-12-13-14-20-21-22-23-24-30

Is there a way to adjust the formula so that counting in base 5 would appear as I initially had thought it should appear:
1-2-3-4-5-11-12-13-14-15-21-22-23-24-25-31

Basically am looking to "bump" everything to the right one place and skip the "zeros"
Granted this isn't "textbook" but if someone thinks this can be done I'd greatly appreciate it.

Best Regards,
Greg

[Jay Petrulis]

On 2002-04-17 15:33, youbet7469 wrote:
Hello,
First want to thank all of you who worked on the counting in bases functions. Your assistance is greatly appreciated.

In our discussion it was deteremined that the correct way to count in bases is
For example base 5:
0-1-2-3-4-10-11-12-13-14-20-21-22-23-24-30

Is there a way to adjust the formula so that counting in base 5 would appear as I initially had thought it should appear:
1-2-3-4-5-11-12-13-14-15-21-22-23-24-25-31

Basically am looking to "bump" everything to the right one place and skip the "zeros"
Granted this isn't "textbook" but if someone thinks this can be done I'd greatly appreciate it.

Best Regards,
Greg

Unless you are working with the bases with alpha characters, would adding one work? Find the base conversion with the UDF and add one to it.

Most important: Don't mess with Damon's function.

As an aside, why do you want to do this, anyway?

Bye,
Jay

[youbet7469]

Hey Jay,

Thanks for the reply... I didn't realize earlier that you were the one who answered my other question as well.

I've tried adding one to a number of places in the formula you guys gave me along with adding one to each cell in excel and neither have provided me with satisfactory results.

You asked my why I'm looking to do this. I'm doing some research on Egyptian Counting and the below paragraph should give you an idea of why I'm looking to count in this way

"The Egyptians, though, had no concept for zero. The zero was invented independently both by the Indians (thanks to Ranjeev Ravi for pointing this out) and the Maya. The Indians used a space for zero, and the Maya used a symbol for zero in their calendars in the 3rd century AD. Eventually, the Indians came to use a dot for zero, which was picked up by the Arabs. Through the Arabs, the number zero reached European civilisation after 800 AD. The ancient Egyptians, as with the ancient Greeks and Romans, had no use for zero."

Counting in base three with no concept for zeros would go as follows:
1,2,3,11,12,13,21,22,23,31,32,33,111,112,113,121,122,123,131,132,133,211,212,213,221,222,223,231,232,233,311,312,313,321 ,322,323,331,332,333,1111 etc....

I think the difficulty in attempting to do this is going to be getting rid of the zeros.
Is there a way to do this? Let me know what you think

Thanks again for all your help!
Best Regards,
Greg

[Al Chara]

Basically you want something that would act like a binary code, but instead of the binary being 1,0 you want it to be 1,2,3,4,5.

So it would look something like:
1,2,3,4,5,11,12,13,14,15,21,22,23,24,25,31,32,33,34,35,41,42,43,44,45,51,52,53,54,55,111,112,113,114,115,...

Is this what you are looking to try and do?

[youbet7469]

Al, yes that is exactly what I am looking for. I'd definetly like to do it for all bases 3 thru 9 if we could go do even higher bases that would be great too.