Previous 1 2 Next 23 Replies Latest reply: Dec 13, 2012 7:02 PM by Wayne Contello Go to original post
  • Wayne Contello Level 6 (17,499 points)

    I would add the numbers "Dummy" players necessary to make the list a multiple of two (or four).  You can leave the Name column for those players empty

  • Rob_NL Level 1 (0 points)

    Hi Wayne,

     

    Euwh ... that I didn't come up with this myself .

    This simple solution makes my question sound a bit stupid ... but hey, I don't mind!

     

    Thanks again!

  • Rob_NL Level 1 (0 points)

    Hi Wayne,

     

    I have a Dutch version of iWorks so all functions you have used needs to be translated to the Dutch formula functions. Some I understand, but some unfortunately I don't recognize.

     

    I will work on it in the next few days, I should be able to get it right.

  • Wayne Contello Level 6 (17,499 points)

    Rob,

     

    sorry for calling you "Mark" in a different post.  I found a mistake in the web interface that didn't show all the cells so you would end up with merged cells in the Numbers file.  I updated the web interface so that cell that are empty will still paste intoa cell and will contain a dot (".").  In addition I realized that to properly import into Numbers each person id should be in a separate cell.

     

    I have updated the website correctly (the command line application was already correct).

  • Wayne Contello Level 6 (17,499 points)

    Rob,

     

    Here is a link to the document I made:

    https://www.dropbox.com/s/s5fzeg9sq9xcey4/Tennis.numbers

  • Wayne Contello Level 6 (17,499 points)

    I have updated the document and the website so that settings you make on the website can be automatically imported vis the copy operation from the web site-- see the "How To Use" sheet.

  • Rob_NL Level 1 (0 points)

    Hi Wayne,

     

    Sorry for my late reaction again, but the last (working) days were very hectic.

    I am looking forward to next week Monday because I will head to Gran Canary Islands (Spain) to spend 9 days of holidays overthere .


    First of all the tool works and I am able to set up the schedule showing the names of the different players. That's the good news. But I still have an issue when I have a list of 17 players instead of the 20 I need to create quartets for 5 courts. Now the final list shows some courts with only 3 players listed. The tool should always plan quartets on court 1, then on 2, then on 3, etc.. In this example court 5 should show only 1 name (with three blank spots).

     

    Is this something you can tweak to get this result?
    In case of any questions, please let me know.

     

    Thanks again!

     


    Rob

  • Wayne Contello Level 6 (17,499 points)

    Rob,

     

    This is a challenge because the tool that makes the ranomized list has no knowledge about the names and which ones are empty.  I will look into this

  • Wayne Contello Level 6 (17,499 points)

    I updated the web application.  I hope this resolves this problem for you.  The tool now allows non-multiples of the number of players per game

Previous 1 2 Next