one more question regarding counting in different bases
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: one more question regarding counting in different bases

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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



  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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



  4. #4
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com