Palo Alto AYSO plays games with many different venues, depending on the Program and the division. There must be a game scheduler for each of those venues, and for the large divisions. This page is to address the game scheduling for the teams that play exclusively in Palo Alto, such as U6, U8, and U10 Instructional Program teams.
The process consists of two steps;
- preparing a spreadsheet with the games
- importing the spreadsheet into our system.
Building the Game Schedule
The game schedule can be built in just a few minutes using the online system at http://www.hometeamsonline.com/sportswebsites/?scheduler Enter the number of teams, enter a 1 for the number of locations, this will be calculated separately. Enter the number of times each team will play each other to ensure enough games in the schedule. For example, if it is a 12 game season and there are 4 teams, then each team will play each other 3 times. If when dividing the number of weeks by the number of teams you get a fraction, round up. Enter the number of daily games that are played. If there are 8 teams, then 4 games are played each Saturday. If you have a fraction, round down. Enter your name and email address, and click the button to go to the next step.
On the second page, click the radio button for "Type team names below". Enter the teams names such as 26-U12B-1, meaning Region 26, division U12B and team 1. Simplest method is to enter the first team as shown, copy and paste it to each of the team names, and then go through and amend the team number in sequence, such as 1,2,3,4, etc. If there are Elite teams skip them, and start at the first actual Instructional team number.
Note that if you have a large number of teams the Time Slot table may show entries that have the word Hour. If you do not see any, you can skip to the next paragraph. Otherwise, we need to set a time for all the Time Slots. It does not matter what time you set, as long as there are no repeats.
Now click the Download link and you will get the schedule in CSV format. Open the CSV in your spreadsheet program.
Using Pre-Prepared Temaplates
There are game schedules already prepared for different division on the G-drive. You access them by going to http://docs.ayso26.org and logging in using the firstname.lastname@example.org account.
These templates can be used with the instructions to the right.
Preparing the Game Spreadsheet
The spreadsheet may be prepared in any standard program you prefer, such as Numbers, Excel, OpenOffice, or even a Google spreadsheet. Create a new spreadsheet. The spreadsheet will have rows of information, where one row is one game. The row states the game date, start time, the game slot stop time, the field, the home team, and the away team.
All date formats must be in the form dd/mm/yyyy, and all time formats must be in the form hh:mm using a 24-hour clock. 14:30 means 2:30 pm
The header line of the spreadsheet must contain the following labels; Date, Start, End, Field, Home, Away. Every row and column must be fully populated with data. Delete any rows and columns not used after the spreadsheet is prepared.
Determining Game Slots
Set the Header: The header starts in A1 and contains the words, Date, Start, Stop, Field, Home, Away in the 6 columns.
Set Date: Enter the date of the first game into cell A2. Copy that cell into succeeding rows for the number of games on that day. In the next cell down, enter =7+A2. That cell will be copied down for the rest of the column later.
Set Stop time: Each division has a game slot time. You can look up the information on the page, http://curriculum.ayso26.org in the table near the bottom. In your spreadsheet, set the formula in the C1 cell to be ="slot duration"/1440+B1. You will copy that cell to all cells in the column later.
Set Start time: For each field and the number of slots you will use for that field, do the following. For the first slot, enter the start time. For succeeding slots, enter a formula that picks up the prior slot's end time. So for example, if there are going to be 4 slots used on a field, and it is the first field you are entering, then put "8:30" into cell B2 if the first game starts at 8:30. Then in cell B3, put the formula, "=C2". Then copy this formula to the other slots for the same field. If you are using additional fields, repeat this in the rows after the first field. You should end up with the number of game rows equal to the total number of games for the day.
After entering your game data, export the file as a csv.
Use a text editor, such as Notepad or Textedit to