Results 1 to 12 of 12

Thread: Best Number

  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Best Number

    The rules for determining the central number is different for each of the three puzzles below (A, B & C). Once you have determined the rule (or formula), you should be able to solve for the last square in each sequence...

    A small hint if needed (but try solving first without the hint)... <span style="background-color: #FFFF00; color: #000000; font-weight: bold"><font color=yellow>The puzzle was made using Excel. The four small numbers on the outside of each bigger square were put in place first. Then a formula using those four numbers was written into the bigger square. The formula was then copied to each of the other big squares in the line. Except, the last square and that's for you to solve. So, if nothing is clicking, you might try using Excel.</font color=yellow></span hi>

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,212
    Thanks
    14
    Thanked 338 Times in 331 Posts

    Re: Best Number

    [img]/forums/images/smilies/cool.gif[/img] <span style="background-color: #FFFF00; color: #000000; font-weight: bold"><font color=yellow>0= (NE-NW) * (SW+SE)</font color=yellow></span hi>

    Steve

  4. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Number

    Steve, good job. You're exactly right! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  5. #4
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Number

    A: <span style="background-color: #FFFF00; color: #000000; font-weight: bold"><font color=yellow>9.5 = +a_a+c_c/2+d_d-b_b+(+c_c-b_[img]/forums/images/smilies/cool.gif[/img]*b_b*(d_d-d_d)/72*25.5

    where
    a_a is NE
    b_b is SE
    c_c is SW
    d_d is NW
    </font color=yellow></span hi>

    Its not pretty but it works.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  6. #5
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Number

    <span style="background-color: #FFFF00; color: #000000; font-weight: bold"><font color=yellow>Amazingly, I was able to make your formula work for the 1st, 3rd & 4th examples in Line A. Perhaps, the formula worked for you in the 2nd example also (I may not have applied your formula as you intended). In any event, if it worked for you all the way across, then your response is acceptable. I had a different but not necessarily better solution:</font color=yellow></span hi>

    <span style="background-color: #FFFF00; color: #000000; font-weight: bold"><font color=yellow>Using your notation: =+(((D*10)+A)-((B*10)+©))/2</font color=yellow></span hi>

    <span style="background-color: #FFFF00; color: #000000; font-weight: bold"><font color=yellow>Basically, the two numbers at the top of the box (2 & 8) become 28. The two numbers at the bottom of the box (4 & 4) become 44. Subtract 28 from 44 and divide by 2 will get you the number in the center: 8. This formula will work for each of the examples. So the other solution is 11.</font color=yellow></span hi>

  7. #6
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Number

    Line A Part 2 = <span style="background-color: #FFFF00; color: #000000; font-weight: bold"><font color=yellow> 1 + 7/2 + 3 - 7 + (7 - 9) * 9 * (3 - 7) / 72 * 25.5 = -1.5 + -2 * 9 * -4 / 72 * 25.5 = -1.5 + 72 / 72 * 25.5 = -1.5 + 25.5 = 24
    </font color=yellow></span hi>
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  8. #7
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Number

    I see <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    By the way, my apologies to the loungers who may have tried puzzle C. I had the decimal places set to zero, which results in a misleading number in the 4th example in that line. The puzzle becomes "solvable" when the number in the middle, in the 4th example, is changed to 11.5. Just change the '12' to 11.5, otherwise, the puzzle works fine. <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>

  9. #8
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Number

    Thank goodness for that! I thought it was just me. <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15>
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  10. #9
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Number

    So, I assume you got it?

  11. #10
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Number

    Actually Ricky, I didn't. I spent a long time trying to solve them on a number of occasions and finally gave up in a state of total admiration. Damn fine puzzle, Sir! Any more Tricky specials imminent?
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  12. #11
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Number

    Well, you didn't ask, but here's the solution to the final puzzle in the set...

    <span style="background-color: #FFFF00; color: #000000; font-weight: bold"><font color=yellow>Moving clockwise from the upper left position, simply add the first three numbers, take half that sum and add the remaining number from the bottom left position. That will give you the answer in the middle. So the solution is 20.5 or just 21.</font color=yellow></span hi>

    The more I look at it, the more I don't like it. Terrible puzzle, let's move on...

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  13. #12
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Best Number

    Don't be too harsh. It was a good puzzle since the ground rules for this one were well laid out. Congratulate yourself for taking the time to create it and providing hours of frustration (and pleasure) for us enigmatophiles. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

Posting Permissions

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