Within Arbiter, we offer a custom Excel spreadsheet specifically for your group that you can keep for yourself, or you can forward it to the Schools to fill out with their schedule. If used correctly, this can save you a lot of time. *We have updated the template to have an extra column. We recommend downloading the template again to avoid issues!*
This template is created specifically for your group. If you are part of multiple groups, you will need to download them individually since Sports, Levels, Teams, Sites, and Bill Tos are all unique.
- Go to ArbiterSports.com and Login as an Administrator
- Go to the Assigning tab and on the left-hand side under the Utilities section, select Import
- Under the Game Template section, click on the blue Download button to download the excel spreadsheet.
The excel file will automatically start to download to your computer.
If you do not see anything being downloaded, check your downloads or check to see if you have pop ups enabled. After it has finished downloading on your computer, save it on your hard drive or forward the excel file to the Schools
Before you can actually dive into putting in your games, there are a few things to know and do.
- After opening the file, make sure you click on Enable Editing in excel.
- **DO NOT** alter any of the contents that reside on Row 1. If you do, the import could become corrupted while trying to import it into ArbiterSports. You will have to undo the action that you did or close the file without saving and reopening it.
- In Row 1 of the excel worksheet, there will be headers specifying the type of information to be placed in each column. These headers are defined as follows:
Date: The date of the game that must use the format of mm/dd/yy (example: 01/14/17). Note that TBA dates are not allowed.
Time: The time of the game that must use the format of 12:00 AM. Note that TBA times are not allowed.
Game: A game number of your choosing. – (optional)
Custom-Game-ID: A custom option to look up specific games. – (optional)
Sport: The sport that applies to the game. Note that if the sport is not in the list of sports from the template drop-down list, then that game will not be imported.
Level: The level of the sport that applies to the game. Note that if the Level is not in the list of Levels from the template drop-down list, then that game will not be imported.
Home-Team: The Home Team on the game. – (optional) Leave this field blank if you intend for the Home-Team to be TBA. Note that if the Home-Team is not going to be TBA, then it will need to be in the list of Teams from the template drop-down list.
Home-Level: The Home Teams level – (optional) Only use this if the Home-Team level is different from the game level
Away-Team: The Away Team on the game. – (optional) Leave this field blank if you intend for the Away-Team to be TBA. Note that if the Away-Team is not going to be TBA, then it will need to be in the list of Teams from the template drop-down list.
Away- Level: The Away Teams level. – (optional) Only use this if the Away-Team level is different from the game level.
Site: The site where the game is played. Note that TBA sites are not allowed. If the site is not in the list of Sites from the template drop-down list, then the game will not be imported.
Sub-site: The sub-site within the Site where the game is played. – (optional) Only use this field when a sub-site needs to be specified. If the sub-site is not in the Sub-site drop down list then the game will not be imported.
Bill-To: The party that is responsible for paying fees (who is being invoiced for the fees). – (optional)
Officials: number of officials needed for the game. Generally leave this column BLANK. Enter a numeric value here if you want an abnormal number of officials on a game.
- If you are wondering what formats we accept on the import, or what cells are required to be able to import the games, you can hover your mouse on any of the cells that are in Row 1.
- For Columns D through L, a drop down arrow will appear next to the cells going down. This will have all of your groups information, based on the column. You can fill the cell to have the proper information by clicking on the drop down arrow and finding what you are looking for. If it is not there, you will have to add them to your Group on Arbiter, with the exception of any new team, and downloading the template again.
- The information needs to match EXACTLY how it is on Arbiter. If you have the sport of 'Baseball' in ArbiterSports, but on the import it's listed as 'BBall', the system will not recognize it and it will give you an error. There are two ways to avoid this error - typing the correct spelling for it or you can use the drop down menu next to the cell and selecting the correct information.
Now that we have all of this in mind, we can start to input games using the Excel file.
- Open the Excel file downloaded from ArbiterSports and click on Enable Editing.
- Start to fill out the cells using the information that you have about the games. Make sure that they match exactly how it is on your group in Arbiter.
- Rename it and save the excel file to your computer.
- Go back to ArbiterSports.com and click on Browse.
- Find the Excel file and double-click it, or select the file and click on Open. The file's name will appear next to the Browse button if done correctly. Under Browse, there is an option to Automatically Add New Teams. Select this option if have new teams that need to be added to your group before you click on Import.
- Click on Import.
- The system will display a report below with your games. You can determine here which games got imported and which ones have conflicts, missing information, or incorrect information.
A report of all of the games that you were trying to import will appear. On the far right, the Status column will let you know if it was able to import it or if it failed. If the import failed to put some games, the system will let you know why it failed and will give you the chance to resolved most of the issues without having to go back to the import, fixing the issue, and re-importing it.
What can be fixed within the Arbiter (Note: If you are going to resolve your games using this method, Solve all of the issue that were given and then hit the Submit button at the bottom or top of the page.):
- Resolve the Home Team
- Resolve the Away Team
- Resolve BillTo
- Resolve Site and/or Subsite
The following can only be fixed on the Excel file:
- Conflicts with another game that is already in the Arbiter.
If it is easier for you to export all of the issues and fix them to re-import them again, we offer a tool that lets you get a file of the games that came back with conflicts to resolve on the import. You can find this on the top right of the imported games, you will see a Print Preview button - click on it to get a file with all of the conflicted games.
Once the file has been fixed with the accurate information, go back through the same steps to import the file into your group.