|
Go to Games Umpired to generate a report showing the games umpired by each umpire. You can specify the date range for the report. The report will use the umpire payment table (See Set Umpire Pay) to determine the payment for each game and the total for the period specified. If the No-Show checkbox is checked, then the payment for that game is not included.
MySoftballLeague.com provides an Excel template to track payments to individual umpires. Once you have created the desired report you can generate umpire payment reports using the template by following this procedure:
1. Click on Export Games Umpired
2. A page will be created with the report data. Save this data as a file using the ".txt" extension for file type.
3. Using Excel open the file. The excel program will take you through some steps first. Be sure to specify a tab-delimited file.
For each umpire:
4. Highlight the data for that umpire starting with the cell listing the umpire's name.
5. Open the Ref Payments TEMPLATE, click on the PASTE HERE cell, and paste the data.
6. Click on the Payment Records tab to see the report. The report is formatted for printing. Save As, changing the name of the file to something unique, like the umpire's name.
To download the Umpire Payments Template, click here. Below is a example of an umpire payment report. Of course you can customize the template to suit your needs.
|