How To Scramble Numbers On These Tables?

Discussion in 'Off-Topic' started by hopestar, Apr 2, 2009.

  1. hopestar

    Thread Starter New Member

    Apr 2, 2009
    4
    0
    Hi to all of you guys here…
    May this thread fits on this section. A friend of mine gave me this enigma. It is written in Excel format. Since here I can’t attach .xls file, I don't know how to put the file, name Enigma.xls.
    There are infinite amount of tables, with ten rows (row 0,1,2,….9) each. Inside of each tables, there are numbers from 1 to 92, 93 to 184, 185 to 276, and 277 to 284, which lie on their certain rows. Here I gave the example tables that have been filled in for 40 tables. By finding the patterns/ formulas, my friend asked me to extend the tables to fill in the blank tables 41,42,43,etc as given beneath of Table 40. Just like SUDOKU, in each tables there will be no same numbers vertically, horizontally and diagonally. If these tables are using permutations from an ideal table that you can see beneath Table 40 (supposed the ideal table was right), then how to find the formulas of its permutations?
    Can somebody help me about this?
    Thx.
    Hope my English is good enough for explaining this.
     
  2. thatoneguy

    AAC Fanatic!

    Feb 19, 2009
    6,357
    718
    You can upload the XLS file in a ZIP archive. Somebody familiar with visual basic or excel formulas, or both, could work on it.

    I understand your question as this:
    A friend wrote a formula that filled out rows and columns of worksheets in "Sudoku Format", so no row has the same number repeated on any 45° Axis.

    The formula that fills out all the other worksheets is on worksheet number 40, along with a "master table" to build the other pages from.

    The limitation is the size of the "Ideal/master" table on worksheet 40. You want to increase the size of all the pages, so you require a formula to build a larger "master table" on page 40.

    Is the above correct?
     
  3. hopestar

    Thread Starter New Member

    Apr 2, 2009
    4
    0
  4. thatoneguy

    AAC Fanatic!

    Feb 19, 2009
    6,357
    718
    After seeing the sheet, I don't understand what the circled columns are for, solved puzzles?

    Either way, I've attached the exact file you sent me as a ZIP. Scanned virus/malware free.

    Another member here probably has MUCH better input than I can help with.
     
  5. hopestar

    Thread Starter New Member

    Apr 2, 2009
    4
    0
    Numbers in ovals/circles are numbers in one row that have difference=4. Honestly, I don't know how to scramble numbers to result like that. This is what I needed help for...
    Thx.
     
  6. hopestar

    Thread Starter New Member

    Apr 2, 2009
    4
    0
    Someone has made a program in Java like this:
    Code ( (Unknown Language)):
    1.  
    2. import java.util.*;
    3. public class Table {
    4. static Scanner console = new Scanner(System.in);
    5.     public static void main (String[] args)
    6.     {
    7.      
    8.        String list = "010509131741454953572125293337616569737702030406070810111214" +
    9.                      "151618192022232426272830313234353638394042434446474850515254" +
    10.                      "5556585960626364666768707172747576787980818283848586878889909192";
    11.        String number;
    12.        int counter = 0;
    13.        int randomNumber = 0;
    14.        int rowPlacement = 0;
    15.  
    16.        
    17.        Vector row_0 = new Vector();
    18.        Vector row_1 = new Vector();
    19.        Vector row_2 = new Vector();
    20.        Vector row_3 = new Vector();
    21.        Vector row_4 = new Vector();
    22.        Vector row_5 = new Vector();
    23.        Vector row_6 = new Vector();
    24.        Vector row_7 = new Vector();
    25.        Vector row_8 = new Vector();
    26.        Vector row_9 = new Vector();
    27.            
    28.        for (counter=0; counter<184; counter = counter + 2)
    29.        {
    30.            number = list.substring(counter, counter + 2);
    31.            
    32.            //-------------------------------------------------------------------          
    33.            if (counter == 10 || counter == 20 || counter == 30 || counter >= 40)
    34.            {
    35.                rowPlacement = 0;
    36.            }
    37.            //-------------------------------------------------------------------
    38.            do
    39.            {
    40.                 randomNumber = (int) ( 10 * Math.random() );  
    41.            }
    42.            while (rowPlacement > randomNumber);
    43.            //-------------------------------------------------------------------
    44.            
    45.            if (randomNumber == 0)
    46.            {
    47.                 row_0.addElement(number);
    48.                 rowPlacement = 0;
    49.            }
    50.        
    51.            else if (randomNumber == 1)
    52.            {
    53.                 row_1.addElement(number);
    54.                 rowPlacement = 1;
    55.            }
    56.        
    57.            else if (randomNumber == 2)
    58.            {
    59.                 row_2.addElement(number);
    60.                 rowPlacement = 2;
    61.            }    
    62.        
    63.            else if (randomNumber == 3)
    64.            {
    65.                 row_3.addElement(number);
    66.                 rowPlacement = 3;
    67.            }
    68.        
    69.            else if (randomNumber == 4)
    70.            {
    71.                 row_4.addElement(number);
    72.                 rowPlacement = 4;
    73.            }
    74.        
    75.            else if (randomNumber == 5)
    76.            {
    77.                 row_5.addElement(number);
    78.                 rowPlacement = 5;
    79.            }
    80.        
    81.            else if (randomNumber == 6)
    82.            {
    83.                 row_6.addElement(number);
    84.                 rowPlacement = 6;
    85.            }
    86.        
    87.            else if (randomNumber == 7)
    88.            {
    89.                 row_7.addElement(number);
    90.                 rowPlacement = 7;
    91.            }
    92.        
    93.            else if (randomNumber == 8)
    94.            {
    95.                 row_8.addElement(number);
    96.                 rowPlacement = 8;
    97.            }
    98.        
    99.            else if (randomNumber == 9)
    100.            {
    101.                 row_9.addElement(number);
    102.                 rowPlacement = 9;
    103.            }
    104.        
    105.         }
    106.         System.out.println(row_0);
    107.         System.out.println(row_1);
    108.         System.out.println(row_2);
    109.         System.out.println(row_3);
    110.         System.out.println(row_4);
    111.         System.out.println(row_5);
    112.         System.out.println(row_6);
    113.         System.out.println(row_7);
    114.         System.out.println(row_8);
    115.         System.out.println(row_9);
    116.      }
    117.   }
    118.  
    But it didn't work correctly yet :)
     
    Last edited: May 2, 2009
Loading...