+ Reply to Thread
Results 1 to 8 of 8

Thread: Puzzle Four

  1. #1
    possum652's Avatar
    possum652 is offline Junior Twelever +1 TwelevePlus
    Silver
    possum652 is on a distinguished road
    Join Date
    Aug 2005
    Location
    Buffalo NY
    Posts
    237

    Default Puzzle Four

    Hey All,
    I am working on puzzle four and wondering if anyone has any good advice for this one. I see the space and guess that will be the ending point... but I never worked on a cryptogram where you get no letters ahead of time... I have plugged the numbers into an excel spreadsheet and played around with replacing randomly.. but nothing comes up sofar... how would you get frequency using excel? any help would be appreciated.

  2. #2
    bass021's Avatar
    bass021 is offline Expert Twelever TwelevePlus
    Amethyst
    bass021 is an unknown quantity at this point
    Join Date
    Feb 2005
    Location
    Centerville, OH
    Posts
    1,123

    Default

    To get frequency, I do a random find and replace on the puzzle, and it will return a number of changes made. Just make sure you don't have row and column numbers selected when you do it!

    Steve
    Steve (O.A.T.)

  3. #3
    chris_furby's Avatar
    chris_furby is offline Junior Twelever TwelevePlus
    Bronze
    chris_furby is an unknown quantity at this point
    Join Date
    Jan 2005
    Location
    Sunnyvale, CA
    Posts
    75

    Default

    I use Toolsata Analysis:Histogram to create a frequency table. A dialog box comes up to define the input parameters. For "Input Range", select the 32x32 grid of numbers. For "Bin Range", I create a list of all the unique numbers in the puzzle and hilite them. Check "Pareto" and press OK. Two frequency tables get created, one sorted from highest to lowest frequency.

  4. #4
    bass021's Avatar
    bass021 is offline Expert Twelever TwelevePlus
    Amethyst
    bass021 is an unknown quantity at this point
    Join Date
    Feb 2005
    Location
    Centerville, OH
    Posts
    1,123

    Default

    That sounds about 1000 times easier than the way I was doing it.

    For anyone who tries to do this, but you don't have the "Data Analysis" option under "Tools", I found the following in the Excel Help:

    - On the Tools menu, click Add-Ins.
    - In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.

    Steve
    Steve (O.A.T.)

  5. #5
    possum652's Avatar
    possum652 is offline Junior Twelever +1 TwelevePlus
    Silver
    possum652 is on a distinguished road
    Join Date
    Aug 2005
    Location
    Buffalo NY
    Posts
    237

    Default

    anyone else stuck on four?? i wouldnt mind working on it with someone cause I am not seeing this one... P.M me if interested... I just seem to work better when there is someone to bounce ideas off of... and of course I am wide open to any clues anyone might wanna pm me... I've swallowed my pride along time ago..lol.... I think that if i can get past the begining of this one, I will be able to finish it.. just cant get past figuring out where to start and getting atleast one letter right.... oh well.. give me a juicy riddle any day...

  6. #6
    possum652's Avatar
    possum652 is offline Junior Twelever +1 TwelevePlus
    Silver
    possum652 is on a distinguished road
    Join Date
    Aug 2005
    Location
    Buffalo NY
    Posts
    237

    Default

    finally got it last night.. that was pretty tough... on to five...

  7. #7
    CT_DAN is offline Getting the hang of it. Copper CT_DAN is an unknown quantity at this point
    Join Date
    May 2005
    Posts
    10

    Default

    Quote Originally Posted by chris_furby
    I use Toolsata Analysis:Histogram to create a frequency table. A dialog box comes up to define the input parameters. For "Input Range", select the 32x32 grid of numbers. For "Bin Range", I create a list of all the unique numbers in the puzzle and hilite them. Check "Pareto" and press OK. Two frequency tables get created, one sorted from highest to lowest frequency.
    Hello Ken,
    I'm probably going to buy the book soon but had a question. The quote above discusses a pretty excel-advanced method of solving a clue. I'm assuming the method is not a violation of the rules. Can we create macros in Excel to help solve puzzles? Or is this a violation?
    Thanks!

  8. #8
    kenbcpa is offline Junior Twelever Copper kenbcpa is an unknown quantity at this point
    Join Date
    Nov 2005
    Posts
    40

    Default

    CT_Dan

    Thank you for your question.

    We are getting ready to place a post that will address these exact issues in the next few days.

    As stated in the rules though, you may use excel or word for organizational purposes only.

    http://KenThePuzzleGuy.com

    Ken.
    winmywpbhome.com is a book comprised of 12 puzzles. The winner will receive a home located in West Palm Beach, Florida and up to $2.5 million. There are also smaller prizes that total over $2.0 million. Good Luck to everyone.

+ Reply to Thread

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