League System Manual (Complete)

Table of Contents


Create a New Team Scorecard

  1. Go to the South Saint Paul League Scorecard Directory and select the appropriate league folder
  2. Right click on ‘0 – xxx Team Template’
    • Note: xxx in this example = the league you are editing (i.e. 5-stand, skeet, sporting clays, etc.)
  3. Select “Make a Copy”
  4. You should now have a new scorecard named ‘copy of 0 – xxx Team Template’. Right click this copied form and select ‘Rename’
    • Note: xxx in this example = the league you are editing (i.e. 5-stand, skeet, sporting clays, etc.)
  5. Rename the form to the team’s name (i.e. ‘Claybusters’)
  6. Double click on the newly renamed form to update the team

Back to Table of Contents


Updating Team Scorecard Information

  1. Go to the appropriate league scorecard directory: 5-Stand, Skeet, Sporting Clays, Trap – 16 yard, Trap – Back ’em Up, Tri-Combo, Tri-Combo Sub Gauge
  2. Double click on the team you wish to edit
  3. Edit the following values
    1. Team Name (2 places)
    2. Password
    3. Update Shooter Names (5 minimum, 10 maximum)
    4. Delete excess shooter slots (click on trash can icon)
    5. Click on ‘Responses’ tab and then ‘…’
    6. Click on ‘Select response destination’ 
    7. Click ‘Select existing spreadsheet’  then click ‘Select’
    8. Click on the ‘League Results – xxx’ workbook then click ‘Select’
      • Note: xxx in this example = the league you are editing (i.e. 5-stand, skeet, sporting clays, etc.)
    9. The recording spreadsheet will automatically open, or click ‘Open’ in the spreadsheet linked dialog box (see blue image to right) and the spreadsheet will open to a tab called ‘Form Response #’.  Rename this tab to the team’s nameRight Click on the Bottom Tab
      1. Right Click Tab
      2. Click on ‘Rename…’

Step by step visual guide…

Step 1: Change Team Name (in 2 places) Step 2: Set Team Password Step 3 & 4: Setup Shooters
Step 5: Set Response Destination Step 6: Set Response Destination
Step 7 : Set Response Destination
Step 8: Select League Spreadsheet Step 9: Open Results Spreadsheet
Step 9: Rename Team Tab

Back to Table of Contents


Add a New Shooter to an Existing Team

Note:  Teams must have between 5-10 shooters.  Be sure not to add more than 10 shooters. 

  1. Go to the appropriate league scorecard directory: 5-Stand, Skeet, Sporting Clays, Trap – 16 yard, Trap – Back ’em Up, Tri-Combo, Tri-Combo Sub Gauge
  2. Double click on the team you wish to edit
  3. Select an existing shooter’s name
  4. Click the “Duplicate” button (See picture to right)
  5. Rename the duplicate field to your new shooter’s name

Back to Table of Contents


Delete a Shooter from an Existing Team

  1. Go to the appropriate league scorecard directory: 5-Stand, Skeet, Sporting Clays, Trap – 16 yard, Trap – Back ’em Up, Tri-Combo, Tri-Combo Sub Gauge
  2. Double click on the team you wish to edit
  3. Click on the shooter’s name you wish to delete and click on the ‘Delete’ icon (looks like a trash can)
  4. Click on the ‘Responses’ tab
  5. Click on the ‘View Responses in Sheets’ button
  6. Right Click the column letter of the shooter you wish to delete and select “Delete Column”

Back to Table of Contents


Linking SSPGunClub.com “League Scoring Entry Page”

  1. To get the link for the team scorecard:
    1. Go to the appropriate league scorecard directory: 5-Stand, Skeet, Sporting Clays, Trap – 16 yard, Trap – Back ’em Up, Tri-Combo, Tri-Combo Sub Gauge
    2. Double click on the team you wish to add
      • Note:  If the team form does not exist, please follow the “Create a New Team Scorecard”  instructions above
    3. Click on the ‘Send’ buttonUnder ‘Send Via‘ click on the ‘Link‘ icon
      1. Check ‘Shorten URL’
      2. Click ‘Copy’
  2. Add the team to SSPGunClub.com and Link
    • Go to http://sspgunclub.com/wp-admin/post.php?post=2765&action=edit
    • Go to the appropriate league and type in the team name (i.e. Blind Guyz) – Please add teams alphabetically!! 
      1. Highlight the team name and click the ‘link’ button
      2. Paste (ctrl + v) the copied short URL to link to the team form
      3. Click “update” button

Back to Table of Contents


Edit/Delete Submitted Scores

  1. Go to the League Results Directory
  2. Double click the appropriate league workbook (e.g. Sporting Clays, 5-Stand, etc)
  3. Select the tab of the team you wish to edit
  4. Edit the row containing incorrect data
  5. Click on the ‘sheets home’ button at the top left to save and exit

Back to Table of Contents


Adding Team to Scoreboard

  1. Go to the League Results Directory
  2. Double click the appropriate league results workbook (e.g. Sporting Clays, 5-Stand, etc)
  3. Click on the ‘Scoreboard’ Tab
  4. Since we are trying to keep the teams in alphabetical order, find the location for the new team and insert 15 Rows in the spot you would like to create the new team’s scorecard
    1. Select 15 rows (notice that you select the blank row above team name to the ‘League Score (Top 5)’ of an existing team)
    2. Right Click and select ‘Insert 15 above’
  5. Click on the ‘SB Template’ Tab
  6. Copy Rows 1 to 15
    1. Select Row 1 to 15
    2. Right Click and ‘Copy’
  7. Click on the ‘Scoreboard’ Tab and paste the copied rows into the space you created in step 4
  8. Change the ‘Team Name’ references
    1. Select the newly pasted table (It should be titled ‘Team Name’)
    2. Click Edit > Find and replace…
      1. In the ‘Find’ box enter Team Name
      2. In the ‘Replace’ box enter the name of the new team’s tab (ex. Claybusters II)
      3. Check the ‘Also search within formulas’ box
      4. Click the ‘Replace all’ button
      5. Click ‘Done’
    3. If the team has less than 10 shooters, the remaining rows will continue to display ‘Setup’ because data for the empty shooters does not exist.  You should hide these rows.
      1. Select the rows with no shooter data (i.e. displays ‘Setup’ in column D)
      2. Right click on a row number and select ‘Delete rows ## – ##’  (where xx and yy are rows you selected)

Publishing the Scoreboard, Rankings, and Detail to SSPGunClub.com

  1. Go to the League Results Directory
  2. Double click the appropriate league results workbook (e.g. Sporting Clays, 5-Stand, etc)
  3. Click on File > Publish to web…
  4. Click the ‘Embed Tab’
  5. Drop Down change ‘Entire Document’ to and select the tab you are trying to publish (i.e. ‘Scoreboard’, ‘Rankings’, or ‘Entire Document’ for the Detail view)
  6. Click ‘Publish’
  7. Copy the bit of code that pops up in the center box
  8. Go to the appropriate SSPGunClub.com
    1. Scoreboards: 5-stand, Sporting Clays, 16 Yard Trap, Back ’em Up Trap, Skeet, Tri-Combo, Tri-Combo Sub Gauge
    2. Rankings: 5-stand, Sporting Clays, 16 Yard Trap, Back ’em Up Trap, Skeet, Tri-Combo, Tri-Combo Sub Gauge
    3. Detail: 5-stand, Sporting Clays, 16 Yard Trap, Back ’em Up Trap, Skeet, Tri-Combo, Tri-Combo Sub Gauge
  9. Click on the ‘Text’ editor tab and at the bottom paste the iframe code from google
  10. add width=”100%” height=”2000″ to the iframe text (helps size it on computers and phones)
  11. Click Publish