Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts

    Excel2013 - trihexadecimal numbers

    Hi all,

    While recovering from injury on my first day here in the Caribbean, I was able to think about trihexadecimal numbers with primes and exponents while lazing under a palm tree on the beach.
    So I came up with some simple formulas, which require Excel2013 or later:

    The shortest one (no surprise here) is for rory:
    =LOWER(BASE((13+1)*53*1741,6^2))

    This one is for Maud:
    =PROPER(BASE(44865889*(2^2^2^2*2^2+59-1),6^2))

    ..and of course, the greatest one is for RG:
    =PROPER(BASE(15377*3880421,6^2)&" "&BASE(3^3^3*3*13-2473,6^2))

    zeddy

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,638
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Zeddy,

    If you looked up "fun date" in the dictionary, I doubt your picture would be there!

    A most fond welcome back.

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi Maud

    ..now I know you have the latest Excel versions, so, did you get the results of my formulas?????


    zeddy

  4. #4
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,725
    Thanks
    147
    Thanked 156 Times in 149 Posts
    zeddy, you're too clever by half

    what about my name....?

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    ..for you, it is simply
    =LOWER(BASE(9197003*(2^2^2*2^2+2^2),6^2)&"-"&BASE(53*547,6^2))

    (I liked that big prime number 9197003)

    zeddy

  6. #6
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 Posts
    Works nicely in LibreOffice 5.

    cheers, Paul

  7. #7
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,638
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Yes, very cool! But under a palm tree in the Caribbean?

    Zeddy.png

  8. #8
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Zeddy,

    Glad you're enjoying the Sun & Waves! Now first you need more of those drinks with the umbrellas in them! Should do a lot to get your head out of the Excel!

    I wish I had 2013 so I could see what fun you had in store for me. I guess I'll have to install Libre Office just to check it out.

    Enjoy!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  9. #9
    WS Lounge VIP access-mdb's Avatar
    Join Date
    Dec 2009
    Location
    Oxfordshire, UK
    Posts
    1,725
    Thanks
    147
    Thanked 156 Times in 149 Posts
    RG, Maud's screenshot should give you a clue - it's Rory, Maudibe, RetiredGeek and access-mdb in trihexawatchmacallit

  10. #10
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Access,

    Figured as much but I'd still like to see it happen!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  11. #11
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 985 Times in 915 Posts
    To many of those umbrella thingies might result in another injury.

    cheers, Paul

  12. #12
    WS Lounge VIP Browni's Avatar
    Join Date
    Dec 2009
    Location
    Rochdale, UK
    Posts
    1,652
    Thanks
    38
    Thanked 161 Times in 139 Posts
    Did a Google search on trihexadecimal and only found this thread!

  13. #13
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    ..after too many of those umbrella thingies, some people might prefer to call them hexatridecimal numbers.

    (it's BASE36, so I think tri-hex is better)

    zeddy

  14. #14
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi RG

    ..do you really want me to create a BASE function equivalent for Excel2010?

    zeddy

  15. #15
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Quote Originally Posted by zeddy View Post
    Hi RG

    ..do you really want me to create a BASE function equivalent for Excel2010?

    zeddy
    Zeddy,

    Thanks for the offer but I'd rather you just enjoy your vacation!
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Page 1 of 2 12 LastLast

Posting Permissions

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