+ Reply to Thread
Results 1 to 3 of 3

Sheldon TV why is 73 a cool number

  1. #1
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Sheldon TV why is 73 a cool number

    On an episode of Sheldon he claims 73 is the best number. See it at:
    https://www.bing.com/videos/search?q...E824&FORM=VIRE

    Here is a spreadsheet showing first 1000 prime numbers and their Mirrored values. Then taken to Decimal and finally marked in yellow those that are palindromes.
    Primes Mirrored and Binaried to Palindrome.xlsm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Sheldon TV why is 73 a cool number

    .
    Ok ... but the REAL QUESTION ...

    How many people who watched that short clip pulled out their calculator ?


  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Sheldon TV why is 73 a cool number

    So the real problem here is:

    Find a prime number whose binary equivalent is a palindrome AND whose Mirror decimal number converted to binary is also a palindrome. Is there such a number? What is the first one? (The first one is 3 and the second is 5 while 7 also fits the rules) Now can you find the next one greater than 7?

    I also wonder why my Dec2Bin() function (in the attached workbook above) doesn't work on larger numbers.

    I've discovered a better Dec2Bin UDF but now wonder if 313 is a possible answer to my problem? Can you test it? If 313 works can you find the next one?

    Primes Mirrored and Binaried to Palindrome Wrong.xlsm
    Last edited by MarvinP; 03-05-2020 at 12:38 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Very cool stuff I learned
    By DarthVader68 in forum The Water Cooler
    Replies: 9
    Last Post: 04-24-2014, 12:21 AM
  2. Replies: 8
    Last Post: 12-16-2013, 07:10 PM
  3. Cool Dashboards - Tricks
    By abousetta in forum The Water Cooler
    Replies: 19
    Last Post: 06-09-2013, 11:03 AM
  4. Multiplication table - really cool one
    By Tortus in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-09-2008, 03:24 PM
  5. COOL Combobox PROBLEM
    By Alvein in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-19-2008, 12:03 PM
  6. [SOLVED] Cool Feature - How do I do it?
    By mnt in forum Excel General
    Replies: 3
    Last Post: 03-24-2006, 02:30 PM
  7. [SOLVED] Can anyone tell me something really cool that Excel can do?
    By Kevin in forum Excel General
    Replies: 4
    Last Post: 03-06-2006, 11:20 PM
  8. [SOLVED] I found this cool link
    By Gogogo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-13-2006, 12:15 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1