Match Scoring With Practiscore

From Wiki
Jump to: navigation, search

Overview

This page is intended to explain how River Bend Gun Club Practical Shooters (RBGC/GA23) and Cherokee IPSC (CGC/GA03) run their matches, starting from setting up Shoot'n Score It for online competitor registration to ending with posting classifier results to USPSA. It it currently a work in progress and subject to changes.

At first glance, this may look intimidating, but it's actually not. The problem is that Shoot'n Score It, EzWinScore and Practiscore are not seamlessly integrated. Several utilities have been provided to make the conversion between the various packages as effortless as possible. After using this procedure once or twice, the entire process will make sense and flow without issue.

We'll start by listing the web sites and software components necessary, following by a more detail explanation of each, and how they're used in the scoring process.

Terminology

First, let's define some terms that will be used through out the document.

  1. Import
    The process of bringing in data from an external application (such as #Shoot'n Score It) into the application currently being used (typically #EzWinScore or #Practiscore).
  2. Export
    The process of extracting data from the current application (such as #EzWinScore) for importing into an external application (such as #Practiscore).
  3. #Practiscore match database
    This is a data file that is created from the #EzWinScore database, and contains all the information relevant to the match (competitors, stages, scores, etc) in a format that #Practiscore can use.
  4. #EzWinScore match database
    This is a data file on a Windows-based machine that contains all the information relevant to the match (competitors, stages, scores, etc) in a format that #EzWinScore can use.
  5. #EzWinScore masternames database
    This is a file that contains all the competitors that have been entered directly into #EzWinScore. Unfortunately, competitors that have been imported through the competitor import process are not entered into the masternames database. This is a limitation of #EzWinScore.
  6. Master Device
    A match may use one more devices for scoring. When multiple devices are used for scoring, one device (which is generally not used as a scoring device) is a 'master' that will contain the initial #Practiscore database to distribute to the scoring devices, and used for collecting scores from the scoring devices. This device will also be used to post the results to the Practiscore website, and (if necessary) transfer the match results back to #EzWinScore.
  7. Scoring Device
    These are one or more devices either left at the stage or carried by the squad to enter scores on. Scores will subsequently be collect by a master device via syncing.
  8. Syncing
    The process of moving the scores accumulated on the scoring devices to a master device, or using the master device to distribute the #Practiscore database to the scoring devices.

Component Description

These are the web sites and utilities used in the match management process:

Shoot'n Score It

Shoot'n Score It is a web site that allows a match director (MD) to define a match. A match is defined with the following major parameters:
  • Match start time ('first shot')
  • Registration ending date and time (the last point which competitors may register or make changes)
  • Stages definitions (these are optional, but should be provided if available)
  • Squad definitions (number of squads and number of competitors per squad)
  • Competitor registration (people who want to participate in the match)
There are additional fields that can be defined, which will be discussed later.
Generally speaking, for local matches, 'self-squadding' is done. The competitor puts him/herself in any squad with an open slot, may move themselves around as desired, may remove themselves from the match, etc.
The MD may subsequently remove competitors from the match completely (no-shows, problem children, whatever), define squads that are 'locked' (where only the MD can put people into that squad) and change various competitor's parameters (for example, those shooters that have trouble with the digital era, or unwittingly specified minor factor instead of major, did not squad themselves, etc).
Once the match is created and registration opened, the MD should periodically monitor the match to make sure no gross problems are occurring, but usually there are no issues to resolve until after registration is closed, any final squadding changes made, adjustments to stages, and other minor things.

EzWinScore

EzWinScore is a Windows-base application available to clubs from the USPSA. EzWinScore is a comprehensive match management program, providing a database of competitors, stage creation, competitor squadding (integrated with the USPSA's online squadding services), reporting, score entry, match results and classifier uploading, and a number of other functions.
While EzWinScore works quite well for traditional paper scoring, for all it's functionality, it has very limited support for electronic scoring devices. Support is provided for the old Palm-based scoring devices, but the interface for the Palms is rather antiquated and limited, and does not support the full range of data needing to be transferred by Practiscore. Although competitor registration may be exported from EzWinScore to #Practiscore, only the most basic information is transferred, and stage designs cannot be exported at all. When importing stages from Practiscore, a stage designated as a classifier in Practiscore loses that status when imported into EzWinScore. To work around this issue, the ezws2ps (#EzWinScore To #Practiscore) conversion utility has been provided.
EzWinScore is used two times in the match management process. The first is after the #Shoot'n Score It registration has closed, and the match information is ready to be be imported into EzWinScore (usually referred to as a 'match database'). The second is after the match has completed. All the scores are collected from the stage scoring devices are imported into EzWinScore for final results, and to produce the match results and activity files to be uploaded to the USPSA website.
As of 2012/12/10, the most recent version is 4.10. The latest update can be found on the EzWinScore Maintenance Releases page.

ssi2ezws

ssi2ezws (#Shoot'n Score It To #EzWinScore) is a web-based utility written by JC Wren for converting an SSI match to a format that EZWinScore can import.
SSI claims the ability to export the registration and stage definitions (if defined) in a format that EZWinScore can use, but it is seriously broken. Problems include:
  1. Mal-formed telephone number that prevent EZWinScore from importing the registration data
  2. Changing from a division with major power factor to Production does not reset the power factor to minor
  3. Certain HTML entities, such as the '&' character, will appear as '&' in stage names
  4. Single-stack and Limited-10 divisions are incorrectly formatted and prevent EZWinScore from importing the registration data
  5. Competitor's names that are entered in all lower-case or all upper-case are not adjusted to correct capitalization
  6. Squadding information file is not produced
  7. No concept of multi-string stages
The ssi2ezws utility takes the EZWinScore zip file downloaded from SSI and massages it for import into EZWS, fixing all the issues above, except for #7.
Using ssi2ezws is remarkably simple: The match is downloaded from SSI in the 'EZWinScore' format, a web browser is opened to http://tinymicros.com/ssi2ezws, click 'Choose File' to select the downloaded SSI match, click 'Convert!', and when complete, click 'Download!'. The resulting downloaded match file now contains a match correctly formatted for import into EZWinScore.
In addition, all non-approved competitors are removed from the match to avoid polluting the #EzWinScore match file with people who are known not to be attending.

Practiscore

Practiscore is a free match scoring application written by Nifty Bytes that runs on both iOS (Apple) and Android devices. Besides simply scoring, it handles many of the aspects of match management, such as:
  • Competitor registration
  • Stage definitions
  • Scores reports, including uploading to the Practiscore website
  • Exporting data back to #EZWinScore
  • Syncing of multiple scoring devices
  • "Pull-only" data access for match scores data integrity
Practiscore supports the following scoring methods:
  • USPSA Pistol
  • Time Plus
  • Time Plus w/ Points
  • IDPA
A match may be scored with a single device running Practiscore (for a match with sequential stages in one bay), or multiple devices running Practiscore (multiple squads shooting simultaneously in different bays). For matches with multiple devices, a single device is used to define the competitors and stages, and the other devices are synchronized to that device. After (and often during) the match, the devices are synced back to the 'master' device, which now contains the scores from all the competitors on all the stages. Scores can be posted within minutes of the match being completed, and competitors can be offered the opportunity to sync personal devices to the master so they can review their scores and argue amongst themselves.
Practiscore contains quite a bit of functionality, but is still undergoing development, with new features being added. For all it's capabilities, there are a couple features that are not yet supported:
  • Ability to upload match and classifier results to the USPSA website (requires acceptance by the USPSA before this will be allowed)
  • Squad balancing
  • Missing score sheet verification
  • Label printing
  • Email address extraction
  • Support for IPSC "classic" targets (Classic)
With the exception of the last item, the missing items are managed easily in #EzWinScore. Managing small matches (roughly 40 people or less) using only Practiscore is practical. While larger matches have been done using solely Practiscore, match management is greatly simplified when combined with #EzWinScore (this is primarily due to the squadding 'views' in #EzWinScore, and navigating in #EzWinScore is generally faster).

ezws2ps

ezws2ps (#EzWinScore To #Practiscore) is a Windows-based utility for converting an #EzWinScore match database directly to a #Practiscore match database.
Without ezws2ps, the following steps would be required:
  1. Create match in #Practiscore
  2. Create stages in #Practiscore (If the stages were created in #Shoot'n Score It or #EzWinScore, reproducing them leads to potential differences)
  3. Import registration file from #EzWinScore
Using ezws2ps, an #EzWinScore match database is specified, the name for the #Practiscore match database is specified, and the 'Convert' is clicked. Now the complete match can be sent to the iOS device using any of the usual methods (Email, Dropbox, web browser, or iTunes).
If scores exist in the #EzWinScore match database, no provision exists in #EzWinScore to export them to #Practiscore (admittedly, it's an unusual request, but nonetheless, the potential exists). ezws2ps will convert and export any scores present, if the appropriate checkbox is set.
ezws2ps also remembers the last-used settings, so it the match needs to be converted multiple times, only the 'Convert' button need be clicked.
The ezws2ps web page is located at http://www.tinymicros.com/wiki/ezws2ps.

Basic Workflow

At first glance, the workflow appears somewhat complicated. In reality, it's pretty much just clicking through a handful of steps. Detailed instructions on each step (including the "why") are in the #Detailed Workflow section. There are 4 major workflow steps, broken down below.

Prior To Match (Basic)

  1. Define match in #Shoot'n Score It
  2. Competitors register and squad themselves
  3. The registration period closes
  4. Verify the #Shoot'n Score It registration information
  5. Download the match database in #EzWinScore format
  6. Convert to an #EzWinScore match database, using #ssi2ezws
  7. Import match into #EzWinScore

Day Of The Match (Basic)

  1. Registration opens
  2. Competitors check-in, verify information
  3. Registration closes
  4. Convert the #EzWinScore match database to a #Practiscore match database using #ezws2ssi
  5. Export converted match to 'master' iOS or Android device
  6. Sync all stage devices against master device
  7. Disperse stage devices to bays
  8. Go shoot with your squad
  9. Periodically sync stage devices to master device

Match Completion (Basic)

  1. Gather all stage devices
  2. Sync each stage device to the master device
  3. Verify match results look reasonable
  4. Upload final match results to Practiscore

Match Finalization (Basic)

  1. Export scores from master #Practiscore device to #EzWinScore match database
  2. Mark any DQ and DNF's (#Practiscore does not transfer this information)
  3. Create activity report for upload to the USPSA
  4. Create #EzWinScore reports for emailing (if still using that antiquated method)
  5. Relax. You're done!

Detailed Workflow

Prior To Match (Detailed)

  1. Define match in #Shoot'n Score It
    Defining the match in Shoot'n Score It is required so that shooters may register on-line, squad themselves, review the stages (if entered), and optionally pay their match fees (if allowed by the Match Directory). To create a match, the following steps are required:
    1. Log in to the Shoot'n Score It website, creating an account if necessary
    2. Under the "-- create USPSA --" drop-down box, select "handgun match"
    3. Select the "Administered by:" drop-down box, and if you're a member of an administration group, you'll see the group name(s) you're a member of. Select the appropriate group, or leave set to 'itself'
    4. Enter a name for the match, typically the abbreviation of the club and the date in YYYY/MM/DD format, or "CGC USPSA December" or some-such
    5. Adjust the "Max competitors" value as necessary
    6. Select the correct state for the match
    7. Fill in the "Web link (http://...):" field with the link to the club's website or Facebook page
    8. Fill in the "Web link text" with the text the link above should be shown as (20 character limit)
    9. Click in the "Start date:" box and select the day of the match
    10. Click in the "Start time:" box and select the hour and 10-minute time the match starts at (typically the time when competitor check-in closes)
    11. Optionally do the same for the "Ends date" and "Ends time", although this typically only used by multi-day matches
    12. Click in the "Registration starts date:" box with the date that on-line registration for the match opens
    13. Click in the "Registration starts time:" box with the time that on-line registration for the match opens
    14. Click in the "Registration closes date:" box with the date that on-line registration for the match closes (day prior to match is recommended)
    15. Click in the "Registration closes time:" box with the time that on-line registration for the match closes (late evening, 7pm to 8pm is recommended)
    16. Click 'Submit' to create the match
    If the stage definitions are available, you may choose to enter them at this point, or later. In either case, the process is the same. To add a non-classifier stage:
    1. Click 'add own stage'
    2. Click in the 'Name:' box and give the stage a name
    3. Click the 'Scoring' drop-down box and select a scoring method if not Comstock
    4. Click in the 'Paper targets:' box and enter the total number of not-penalty scoring targets
    5. Click in the 'Poppers:' box and enter the total number of poppers
    6. Click in the 'Plates:' box and enter the total number of plates
    7. Ignore the 'Frangibles' box
    8. If the stage has no-shoots, click in the 'No-Shoots:' box and enter '1' (the actual number is irrelevant)
    9. Ignore the 'Bonus Paper targets:' box
    10. Click in the 'Minimum Rounds:' box and enter the minimum number of rounds for the stage.
    If this is the last stage to be created, click 'Submit this only'. If additional non-classifier stages are to be entered, click 'Submit and add another stage'. To add a classifier stage, click 'Submit and add another classifier stage'
    To define a classifier stage:
    1. From the match page, click 'add classifier stage'
    2. Click the 'Classifier stage:' drop-down box and select the appropriate classifier
    3. Click the appropriate 'Submit' box depending on if additional stages are to be added or not
    At this point, the match is defined, and if the current date/time is between the registration start and stop periods, competitors may register on-line.
    1. Announce the match via social media (FaceBook, Twitter, etc)
    2. Remind competitors to enter their correct division and power factor, and providing/verifying their USPSA number
  2. Competitors register and squad themselves
    1. Competitors must register first with #Shoot'n Score It before they are able to register for a match
  3. The registration period closes
    1. After the match registration stop time, competitors will no longer be able to register or make changes to their registration
  4. The Match Director verifies the #Shoot'n Score It registration information
    1. Any pending competitors are changed to approved (competitors don't always do things correctly). (Note that this step is not necessary for matches set up for matches where the registration is set to 'open, competitors approved directly')
      1. From the match management page, click 'competitors'
      2. Click the down arrow to the right of the word 'Reg' in the table header to sort by status
      3. Click the 'P' character in the Reg column for the desired competitor
      4. The page will refresh, and the 'P' (Pending) will change to 'A' (Approved)
      5. Repeated clicking of the character will cycle the competitor between Pending, Approved, Declined, and Waiting
    2. Any known non-attending competitors are changed to declined (competitors removing themselves from a match should set themselves to declined, but don't always do that)
      1. From the match management page, click 'competitors'
      2. Click the down arrow to the right of the word 'Last' in the table header to sort by last name
      3. Click the 'P' character in the Reg column for the desired competitor
      4. The page will refresh, and the 'P' (Pending) will change to 'A' (Approved)
      5. Repeated clicking of the character will cycle the competitor between Pending, Approved, Declined, and Waiting
    3. Verify that squadding looks reasonable, re-arrange as necessary (recommended so that competitors can see they've been moved prior to the day of the match)
      As a general rule, squads should have an equal number of people as possible. If a squad has a several new shooters, it may be desirable to make that a smaller squad as the new shooters tend to take longer to complete a stage. Unbalanced squads will result in back-ups at the longer stages. Moving a competitor from one squad to another can be done from two places, either the 'competitors' page or the 'squads' page. In either case, the procedure is the same.
      1. From the match management page, click 'competitors' or 'squads'
      2. Click the word 'edit' to the far right of the competitor who is to be moved
      3. Click the 'Squad:' drop-down box, and select the new squad
      4. Click the 'Update' button. (Unfortunately, the 'competitors' page is always displayed after clicking update 'Update')
      5. Click 'squads' to return to the squadding page, or select another competitor for editing from the 'competitors' page.
    4. Print competitor list (sorted by last name)
      This list is important because #EzWinScore does not have a facility for marking competitors who have checked in as being present. As there will ALWAYS at least a couple people who register for the match and then don't show up, these competitors will be shown in the squad they have signed up for, using squad slots that might be necessary for walk-up registrations.
      1. From the match management page, click 'reports & score sheets'
      2. In the 'Get:' drop-down box, select 'competitor list (sorted on last name)'
      3. Click 'Generate report'
      4. Open the downloaded PDF file and print 2 copies
  5. Download the match database in #EzWinScore format
    The match database contains the competitors and squadding information for the match, along with the stage definitions (if provided).
    1. From the match management page, click 'reports & score sheets'
    2. Click 'EzWinScore (upper left side of screen)
    3. Click 'Download EzWinScore zip file'
    4. If the browser offers a select to 'open' or 'save', select 'save'
    5. Note the location the zip file was downloaded to
  6. Using #ssi2ezws, convert the match database
    The database that is downloaded from #Shoot'n Score It will not work directly with #EzWinScore (perhaps it did with an older version, but it does not work with version 4.10 of #EzWinScore, which is the only version currently supported by the [1]. #ssi2ezws fixes all the issues it can with the #Shoot'n Score It database. Two issues require human intervention once the match is imported into #EzWinScore, and are detailed later.
    1. Open a browser window, and go to http://tinymicros.com/ssi2ezws
    2. Click 'Choose File'
    3. Navigate to the directory where the zip file from #Shoot'n Score It was downloaded to
    4. Click 'Convert!'
    5. After the conversion completes, click 'Download!'
      Depending on the browser being used, a warning may appear that the existing file will be overwritten. Selecting 'Yes' or 'OK' is safe, as the #Shoot'n Score It zip file is no longer needed. If using Chrome, the file will be stored with '(1)' as the last part of it's name.
    6. Open the zip file downloaded from #ssi2ezws
    7. Extract this to the directory 'C:\Practiscore'
    8. If asked to create the directory, select 'Yes' or 'OK'
    9. If warned about overwriting existing files, select 'Yes' or 'Overwrite'
  7. Create a new match in #EzWinScore
    The match creation process in #EzWinScore primarily involves importing the competitor and squadding information, importing or defining the stages, and verifying a few pieces of information. The first step is creating the actual match database.
    1. Start #EzWinScore
    2. Click File->New Match
    3. Change directories as necessary to where the database is to be stored (we usually use 'My Documents\USPSA\<club abbreviation>' to segregate match files. Note the directory has to already exist, as the outmoded dialog box does not allow a new directory to be created)
    4. Click 'OK' once the directory has been selected
    5. Enter a match name (recommended format is club abbreviation, and the date in YYYY-MM-DD format. For example, CGC_2012-11-08. This format allows matches by clubs to display together, and the date format allows easy sorting by date).
    The next steps configure the match name, club name, etc
    1. Click Setup->Match Info
    2. Enter the match name (for weekly matches, we typically use the same name as the database, or 'Cherokee Gun Club Monthly Level I Match' or somesuch)
    3. Enter the match date
    4. Enter the club name (this must be the same club name that is on file with the USPSA)
    5. Enter the club code (GA03 for Cherokee Gun Club, GA23 for River Bend Gun Club, etc)
    6. Click 'Select' to the right of 'Location to save output files'
    7. Select a directory where match results, etc should be stored (we usually use 'My Documents\USPSA'. Note the directory has to already exist, as the outmoded dialog box does not allow a new directory to be created)
    8. Click 'OK' once the directory has been selected
    9. Click 'Handheld' to the right of 'Location of handheld transfer directory'
    10. Click the 'Practiscore' directory
    11. Click 'OK'
    12. Click 'OK' to the warning box that pops up
    13. Click 'Save'
    14. Click 'Close'
    Now that the basic match information is configured, competitor and squadding information can be imported.
    1. Click Setup->Registration
    2. Click the 'Registration Import' tab
    3. Click the 'TSV' radio button in the 'Input File Format' box
    4. Click the 'Yes' radio button in the 'Allow Reentries' box
    5. Click 'Import Registration'
    6. Enter 'C:\Practiscore' in the 'File name' box
    7. Click 'EZWS_Registration.txt'
    8. Click 'Open'
      The number of competitors imported should be displayed (any other message is probably an error, and you're on your own at this point)
    9. Click the 'On Line Squadding' tab
    10. Click 'Import Squadding'
    11. Click 'EZWS_Squad.txt' (the correct directory should already be selected from the registration import)
    12. Click 'Open'
    13. Click 'Yes' to dismiss the warning box that pops up
      If the number of squadding assignments at the bottom is different from the number of competitors imported, it most likely indicates that one or more competitors has not been assigned to a squad
    To import the stages defined in #Shoot'n Score It, the following steps are required:
    1. Click Setup->Handheld
    2. Click 'Import Stages'
      A list of the stages that were defined in #Shoot'n Score It should be displayed.
    If any of the stages are classifiers or have more than one string, they will need to be manually edited in #EzWinScore. If the stage is a classifier:
    1. Click Setup->Stages
    2. Click on a stage name in the list
    3. Click on the 'Classifer' drop-down box and select 'Yes'
    4. Click on the 'CM' drop-down box and select the appropriate classifier
    5. Click 'Save'
    6. Click 'Yes' on the warning box that pops up
    If the stage is more than one string:
    1. Click Setup->Stages
    2. Click on a stage name in the list
    3. Click the 'up' arrow to the right of the 'Number of strings' box to increment the number of strings in the stage
    4. Click 'Save'
    To manually define stages in #EzWinScore:
    1. To define a non-classifier stage
      1. Click Setup->Stages
      2. Click 'New'
      3. Enter a stage name
      4. Click on the 'Scoring Type' drop-down box and select the appropriate scoring type
      5. Click on the 'Target Type' drop-down box and select the appropriate target type (Metric or IPSC, Classic)
      6. Click on the 'No Shoots' box and select 'No' if there are not any no-shoot targets on the stage
      7. Click in the 'Paper Targets' box and enter the number of paper targets on the stage
      8. Click in the 'Poppers/Plates' box and enter the number of poppers and/or plates on the stage
      9. Click in the 'Minimum Rounds' box and enter the minimum number of rounds for the stage
      10. Click the 'up' arrow to the right of the 'Number of strings' box to increment the number of string in the stage
      11. Click 'Save'
      12. Repeat starting at step 2 as necessary to define additional stages
    2. To define a classifier stage in #EzWinScore:
      1. Click Setup->Stages
      2. Click 'New'
      3. Enter a stage name
      4. If the stage is a classifier
      5. Click on the 'Classifer' drop-down box and select 'Yes'
      6. Click on the 'CM' drop-down box and select the appropriate classifier
      7. Click 'Save'
      8. Repeat starting at step 2 as necessary to define additional classifiers
    Obtain and install the most recent classification update file. This process gets the information necessary to assure that competitors with USPSA numbers have theier most recent classifications for the match.
    1. Click Match->Update Classifications
    2. Click 'Get File' (this will open a browser window)
    3. Click 'EZWINSCORE Classification Update File'
    4. RIGHT-click on 'EZWINSCORE Classification Update File'
    5. Click 'Save link as...' (Chrome) or 'Save target as...' (Internet Exploder)
    6. Navigate to the directory specified in the 'Location to save output files' box from the Match->Setup step above
    7. Click 'Save'
    8. Close the browser window
    9. Click 'Import'
    10. Navigate to the directory where the 'ez_class_update.txt' file was saved
    11. Click on the 'ez_class_update.txt' file
    12. Click 'Open' (the mouse cursor will change to an hour-glass for several seconds)
    13. Click 'OK' on the box that indicates how many classification records were imported (should be in excess of 32,000)
    14. Click 'Update match' (the window will update with competitors that have been updated)
    15. Click 'Update master'
    16. Click either 'OK' (if no updates occurred) or 'No' to dismiss the pop-up
    17. Click 'Close'
    Close #EzWinScore
    1. Click File->Exit EzWinScore
    At this point, the match is fully created, and the both the match and #EzWinScore master database has the most recent classifications for competitors that exist in the match or master database.
  8. Print out sufficient #Practiscore back-up sheets. The back-up sheets are double-sided forms that have the back-up entries for up to 15 shooters per page, and 3 "old school" score sheets on the back. The score sheets on the back are useful when delivery of the scoring devices to the stages is late, and shooters want to get started, and also handy for competitors shooting additional classifiers. If a duplexing printer is unavailable, you may choose to print only as many of each side as necessary. A good rule of thumb for the number of back-up sheets is 'number of stages X (number of squads + 2)' (e.g. for 6 stages, with 6 squads, print 48 sheets). We use the double-sided ones because we can get them printed at no cost, and it's less trouble to keep up one type of sheet instead of two.
    1. Open a browser window and go to https://dl.dropbox.com/u/12548441/PS%20Score%20Backup%20V2.pdf
    2. If the PDF opens in the browser window
      1. Right-click and select 'Print'
      2. Follow the standard print process, being sure to enable double-sided printing if your printer supports it.
    3. If the PDF is downloaded
      1. Open the PDF file (may require Adobe Reader, if not installed)
      2. Click the printer icon in Adobe Reader
      3. Follow the standard print process, being sure to enable double-sided printing if your printer supports it.
  9. Done! Checklist:
    1. #Shoot'n Score It competitor list sorted by last name printed?
    2. #Practiscore back-up sheets printed?
    3. #EzWinScore match database created?
    4. #Shoot'n Score It competitor and squadding information imported?
    5. Any classifier and multi-string stages corrected as necessary in #EzWinScore?
    6. Classification updates downloaded and applied to match and master database?
    7. Scoring devices plugged in and charging?
    8. Rain protection for scoring devices?
    9. High-lighter, pens, etc?
    10. Extension cord, power strip, mouse, etc for laptop?
    11. Escape plan in case everything goes to hell?

Day Of The Match (Detailed)

This is the process flow for the day of the match. The items from step 9 in the previous section should all be present.

  1. Pre-Registration
    1. If present, the range-wide WiFi should be verified to be working
    2. Plug the laptop into a power outlet and boot it
    3. Start #EzWinScore
    4. Click Setup->Registration
    5. Disperse the #Practiscore back-up sheets to each stage (number of squads expected + 2 extra)
    6. Have any required waiver and/or registration forms available
    7. Have printed competitor list and a marker are available
    8. Have money box with sufficient 1's, 5's and 10's is available
  2. Registration opens.
    Wait for competitors, drink coffee
  3. Competitors arrive to check-in.
    When competitors start arriving, having a consistent set of steps is important. Don't let competitors jump the gun by handing money before they've signed, wander off before being verified in #EzWinScore, etc.
    1. Have competitor sign waiver and/or sign-up sheet
    2. Ask competitor if they're active law enforcement or military, range members or anything that would affect their match fee
    3. Competitor pays any necessary fees
    4. Ask competitor if they've pre-registered
    5. If they've pre-registered:
      1. Mark them off on the competitor list print-out
      2. In #EzWinScore, click on the 'Already Registered' tab
      3. Locate competitor in list and double-click
      4. Verify division, power factor and squad with competitor, correct in #EzWinScore as necessary (check against #EzWinScore, NOT print-out!)
      5. Thank competitor, send them on their way
    6. If they've NOT pre-registered:
      1. In #EzWinScore, click on the 'Select from Master' tab
      2. Click on the letter tab corresponding to their last name
      3. Determine if competitor is already in the #EzWinScore database
      4. If they are:
        1. Click on their name
        2. If a division is shown in the 'Division' box, ask competitor what division they're shooting
        3. If the division is shown, click on the division
        4. Click 'Register'
        5. If no USPSA number is present, ask if they've got one, and enter it.
        6. If the division was not available on the previous screen, click in the 'Division' box and select the appropriate division
        7. If other than Production division, ask competitor what power factor they're shooting, and adjust if necessary by clicking in the 'Power Factor' box
        8. Click in the 'Squad' box and assign them to a squad
        9. Verify information with competitor
        10. Click 'Save'
        11. Thank competitor, send them on their way
      5. If competitor is NOT in #EzWinScore database
        1. Click on the 'Competitor Info' tab
        2. Click 'New'
        3. Click in the 'First Name' box and enter competitor's first name
        4. Click in the 'Last Name' box and enter competitor's last name
        5. If competitor has a USPSA number, click in the first 'USPSA' box and enter the alpha portion (A, TY, FY, etc)
        6. If competitor has a USPSA number, click in the next 'USPSA' box and enter the numeric portion (33578, etc)
        7. Click in the 'Division' box and enter the competitor's division
        8. Click in the 'Power Factor' box and enter the competitor's power factor
        9. Click in the 'Squad' box and assign them to a squad
        10. If female, click in the 'Female' box and select 'Yes'
        11. If competitor is a junior, senior or super-senior, click in the 'Age' box and select the appropriate age (leave blank for ages 18 to 54)
        12. If competitor is law enforcement, click in the 'Law' box and select 'Yes'
        13. If competitor is active military, click in the 'Military' box and select 'Yes'
        14. Verify information with competitor
        15. Click 'Save'
        16. Thank competitor, send them on their way
  4. Registration closes
    This is where the fun starts, and any problems will delay getting the scoring devices to the stages :) There are two ways to handle no-show competitors. The first is to simply delete them from the match. The alternative is to move them to a special squad (typically #98) so in case they show up, they can be moved to the squad they end up on. Which course of actions depends on the match director's philosophy. Personally, my view is "If you're late, you're late, and you don't get to shoot, sorry if you drove two hours, but maybe you should have left earlier, better luck next time." In the latter case, the no-shows will have to be deleted before the final match results are posted.
    1. At the start of the shooter briefing, verify with everyone that any un-marked-out competitors on the competitor print-out are indeed not there
    2. If deleting shooters immediately:
      1. In #EzWinScore, click on the 'Already Registered' tab
      2. Double-click on the no-show competitor's name
      3. Click in the 'Deleted from pistol match' box and select 'Yes'
      4. Click 'Save'
      5. Repeat steps 1 through 4 for each no-show competitor
    3. If moving competitors to the 'special' (short bus) squad:
      1. In #EzWinScore, click on the 'Already Registered' tab
      2. Double-click on the no-show competitor's name
      3. Click in the 'Squad No' box and enter '98'
      4. Click 'Save'
      5. Repeat steps 1 through 4 for each no-show competitor
    4. At this point, we need to verify the squads are reasonable balanced
      1. Click the 'Squad Reassignment' tab
      2. Click 'Refresh All'
      3. Verify squads are relatively balanced, move competitors as necessary (make SURE they know they've been moved)
    5. Close #EzWinScore by clicking File->Exit EzWinScore
    6. Start #ezws2ps (program icon should be on the desktop)
      Here it really helps to have done this the night before. #ezws2ps remembers your last selections, so if this database has already been converted, you can skip to the 'Convert' step.
      1. Click the top 'Browse' box
      2. Navigate to the directory where the #EzWinScore database is located (refer to #Prior To Match (Detailed), step 7)
      3. Double-click on the appropriate database name
      4. Click the lower 'Browse' box
        Which directory the .PSC file will be stored in is dependent on what method you're using to transfer it to the iOS or Android device). Refer to #xxx, step y.
      5. Navigate to the directory where the #Practiscore .PSC file is to be stored
      6. If necessary, rename the file by clicking in the 'File name' box and entering a new name
      7. Click 'Save'
      8. Click 'Convert'
      9. After a few seconds the 'Converting...' status line should be replaced with the number of competitors and stages converted
      10. Click the 'X' in the upper right-hand corner to close #ezws2ps
    7. Transfer the .PSC file from the laptop to the #Practiscore device
      There are several different ways to transfer the .PSC file from the laptop to a scoring device:
      1. Web server running on laptop (my preferred method)
      2. Email (requires internet access)
  5. Export converted match to 'master' iOS or Android device
  6. Sync all stage devices against master device
  7. Disperse stage devices to bays
  8. Go shoot with your squad
  9. Periodically sync stage devices to master device

Match Completion (Detailed)

  1. Gather all stage devices
  2. Sync each stage device to the master device
  3. Review combined results on each stage, verify times are present and scores complete
    • Should a problem be found, check against the back-up slips (the most common error is score keeper failing to save the last shooter's score in the squad)
  4. If applicable, update classifications in #Practiscore (beware caveat in detailed section!)
  5. Upload final match results to Practiscore

Match Finalization (Detailed)

  1. From #Practiscore, export scores from master device to machine with #EzWinScore match database
  2. In #EzWinScore, import match scores
  3. DQ any competitors as necessary (#Practiscore does not transfer this information)
  4. Mark any competitors un-shot stages as DNF as necessary (#Practiscore does not transfer this information)
  5. Verify scores in #EzWinScore against #Practiscore results
  6. Create activity report for upload to the USPSA
  7. Create #EzWinScore reports for emailing (if still using that antiquated method)
  8. Relax. You're done.

Distributing Match File

After a match has been converted from #EzWinScore to #Practiscore using #ezws2ps, the resulting #Practiscore match database has to be transferred from the laptop to the an iOS or Android device running #Practiscore.

Depending on the platform, there are several methods to accomplish this. These are listed in order of what I believe are the easiest to more complicated.


iOS (iPad/iPhone/iTouch)
Method Pros Cons
Local web server Very easy to use First-time installation of web server may be confusing
Email Very easy to use Requires internet access
Dropbox Very easy to use Requires internet access
iTunes Does not require internet access Slow, cumbersome


Android (NSTs, phone, etc)
Method Pros Cons
USB connection Does not require internet access Initial learning curve slightly intimidating
Local web server Very easy to use First-time installation of web server may be confusing, MAY NOT WORK FOR NST's
Email Very easy to use Requires internet access, MAY NOT WORK FOR NST's
Dropbox Very easy to use Requires internet access

Local Web Server

Running a web server on the laptop is one of the quickest methods for distributing a #Practiscore match file. As there is (presumably) already WiFi service available at the match (otherwise, how were you planning on syncing the scoring devices during the match?), using an iOS device or most Android devices, a web browser page is opened to the web server, touch the PSC file, and it downloads it to the scoring device.
While we've used #nginix with good success, any web server would work (click here for a list of possibilities). #nginix was chosen because it is free, and is very lightweight (requires very little in the way of system resources). Using #ezws2ps to convert the #EzWinScore database to a #Practiscore database, the #nginix directory is selected as the output location for the #Practiscore database, and the file is placed there as part of the conversion process.
Pros:
  • No internet service is required
  • Most scoring devices (with the exception of the NOOKs) have a web browser available
  • Very fast to distribute #Practiscore database
  • No cables required
Cons:
  • Web server may difficult to set up the first time

Email

Emailing yourself the #Practiscore match file is very simple. On the laptop, open an email client, send an email to the whatever account was is on the master scoring device, attach the #Practiscore database, and send it. On the master scoring device, open the email client, open the message containing the #Practiscore database, then download or view the #Practiscore database. Either the file will automatically open in #Practiscore, or a prompt will appear asking what application to open the file in (select #Practiscore).
Although one of the simplest methods, it's one of the most problematic, due to it's reliance on internet service for both the laptop and the scoring devices.
Pros:
  • This is perhaps one of the simplest methods to use
  • Most users already know how to email files with attachments
Cons:
  • Requires internet service on both laptop and master scoring device (many ranges have little to no reliable cellular coverage or WiFi with internet service. Most NOOKs do not have an email account available)

Dropbox

Dropbox is as easy to use as email, and perhaps even a little easier. The #Practiscore match database is placed in the Dropbox folder on the laptop.
For iOS master devices:
  1. Open Dropbox
  2. Touch the #Practiscore match database name
  3. Touch the box with the downwards pointing arrow in the upper right-hand corner
  4. Touch 'Open in Practiscore'
For Android master devices:
  1. Open Dropbox
  2. Touch and hold the #Practiscore match database name
  3. Touch 'Export'
  4. Touch 'Save to SD card'
  5. Touch 'Export'
  6. Touch the 'Home' button
  7. Open #Practiscore
  8. Touch 'Sync'
  9. Touch 'Import Match'
  10. Touch the #Practiscore match database name
  11. Touch 'Select'
  12. Touch 'Close'
Pros:
  • Very easy to use (especially on iOS)
  • Dropbox accounts are free
Cons:
  • Requires internet service on both laptop and master scoring device (many ranges have little to no reliable cellular coverage or WiFi with internet service)
  • Dropbox can be difficult to install on a NOOK

USB Connection

iTunes

Future Plans

  • ps2ezws
  • psbs