ScoreSheets

scoresheetsScoresheets
for use with RCPennantSubmitter.


Fixtures can be copied from RCPennantSubmitter into the spreadsheet allowing drop down menus to select the fixture match and players for score entry for that match. The match data can then be copied from the spreadsheet in the format required for pasting into RCPennantSubmitter.
This allows results managers to distribute spreadsheets to scorers who enter the scores and send the spreadsheets back to the results manager for use in RCPennantSubmitter.

Usage:
  1. Each spreadsheet has its own inbuilt Instructions sheet with details for both Scorers and for RCPennantSubmitter users.
  2. Three copy and paste actions are needed from RCPennantSubmitter to the spreadsheet: the fixture, the teams with players for the grade and the players list.
  3. In the spreadsheet, drop down menus (blue shaded cells) are used to choose the fixture match, the home and away team player order and the doubles players.
  4. In the spreadsheet, the scores are entered.
  5. To transfer the match data to RCPennantSubmitter, the blue region on the RatingsCentral sheet has to be copied first.
    Having selected the matching grade and round and fixture match, use Paste to paste the scores into RCPennantSubmitter: Pennant: MatchScores.
Summary:
Scoresheet Players on each team
Singles Doubles Best of
4S_1D_AX_bestof5 2  4  1  5
4S_1D_AX_bestof7 2  4  1  7
4S_1D_AXalt_bestof5 2  4  1  5
4S_1D_AXalt_bestof7 2  4  1  7
4S_1D_AXsubs_bestof5 2  4  1  5
4S_1D_AXsubs_bestof7 2  4  1  7
4S_1D_AY_bestof5 2  4  1  5
4S_1D_AY_bestof7 2  4  1  7
4S_1D3_AX_bestof5 2  4  1  5
4S_1D3_AX_bestof7 2  4  1  7
6S_3D_bestof5  3  6  3  5
6S_3D_Dbls_bestof5  3  6  3  5
9S_0D_bestof5  3  9  0  5
9S_0D_bestof7  3  9  0  7
9S_1D_bestof5  3  9  1  5
9S_1D7_bestof5  3  9  1  5
9S_2D_bestof3  3  9  2  3
9S_2D_bestof5  3  9  2  5
9S_3D_bestof5  3  9 3  5