!DOCTYPE html> APT Handicap Review Tool

Enter the access password to continue. Your device will remember the password for 30 days.

Handicap Review

— · —

How to use this tool

Phase 1 — Pre-Event Review
  1. Update your handicaps in your event to the 12-month low of GHIN. ⚠ Do this before pulling the query. Go to Players → Update Handicaps → Update Indexes. From USGA World Handicap System, set Lowest Date in Range → change the date to a 1-year range.
  2. Pull the Step 1 query. Go to Queries → 02_Handicap Review Step 1.
  3. Paste the data. Select the First Name of the first player, highlight everything in the query, and paste it into the tool below.
  4. Review every section and make your decisions. Send questionnaires to players who need them, then address Manual Review — both sub-sections: (a) Unvalidated Players and Division Floor — choose A) keep them at their division floor, or B) move them down a division using their 12-month low GHIN; and (b) Validated Players with T-Index Above Division — enter # of rounds posted and last round played (mm/yy) for each, then click Confirm & Apply. ⚠ Submit Review will be blocked until every flagged player in both sub-sections is addressed. Then review the reference sections: Division Floor, 12-Month Low, First Time Players, and Watch List.
  5. Update your handicaps in your event to Tournament Index. ⚠ Don't skip — this sets the playing handicaps. Go to Players → Update Handicaps → Update Indexes. From Tournament Index and select today's date.
  6. Make the updates to handicaps. Use either Handicaps to Update in the tool (changes only) or the Full Roster. Go to Players → Mass Edit → Player Info and update all handicaps.
  7. Submit your review. Click Submit Review to download the file. After you have downloaded that file click the green button that appears to send your email to the handicap committee. ⚠ Make sure you attach the file you just downloaded!
Phase 2 — Post-Event Double-Check
  1. Pull the Step 2 query. After the event, go to Queries → 02_Handicap Review Step 2.
  2. Run the Handicap Double-Check Tool. Paste the Step 2 query (or load your saved review JSON) into the verification section and click Run Verification. Review the Problems report for any red or yellow discrepancies, then confirm against the Full Roster Verification.

Provide handicap data

Coming back after the event? Scroll down to the Handicap Double-Check Tool and use 📂 Load a Saved Review to load your saved JSON.

Handicap Double-Check Tool

Verify against BlueGolf

BlueGolf Reconciliation

After the event, pull your 02_Handicap Review Step 2 query from BlueGolf and paste it below to verify every handicap was entered correctly. The tool matches players by email and compares each player's division, validated status, and handicap against your review.

Two ways to set the baseline: if you just ran a review above, it's used automatically. If you're coming back after the event, click Load a Saved Review to load the JSON you saved when you submitted.

Expected BlueGolf columns: First Name, Last Name, Email, Division, T-Index Validated, Handicap Index (tab or comma separated; headers optional).
Comparing against: current review (live)

Tournament Tee Check

Verify tee assignments

Tee Assignment Verification

Paste your tournament tee query below to verify every player's tee assignment is consistent with their division. The tool checks: the player's division falls within their tee group's range (D1, D2/3, D4/5), their tee type matches the group (Open, Forward, Ladies, or Super Senior), and that a male player isn't assigned a Ladies tee. Super Senior is exempt from the division check since it's net-only and open to any division.

Multiple rounds: most events are one round — just use Round 1. If your event has more, paste each round under its tab and run them separately. Results stack below by round, with a combined accuracy score across all rounds you've run.

Expected columns: First Name, Last Name, Division, Gender, Tee, Tee Assignment (the tournament tee sheet export; headers required, extra columns like Start Time and Age are ignored).
Apt

Admin Settings

Notification emails

Where automated alerts go when chapter owners flag issues or download PDFs. Comma-separate to send to multiple addresses.

Used when a chapter owner clicks "Alert Team" on a player whose Tournament Index is NH but events have been played.
When set, a confirmation email is generated each time a chapter owner downloads a PDF report — useful for tracking tool usage. Leave blank to disable.
Where the "Submit Review" button sends the saved review file for post-event reconciliation. Chapter owner attaches the downloaded file to a pre-filled email to this address.

The link sent to new players when they don't have a tee assignment.

Email template — handicap questionnaire

Sent to players who need to fill out the questionnaire. Available tokens: {{first_name}}, {{full_name}}, {{chapter}}, {{event}}, {{event_name}}, {{event_date}}, {{owner_name}}, {{owner_email}}, {{questionnaire_link}}

Email template — missing rounds alert

Sent to your admin when a chapter owner flags a player with the NH-but-events-played anomaly. Available tokens: {{full_name}}, {{events}}, {{chapter}}, {{event}}, {{event_name}}, {{event_date}}, {{owner_name}}, {{owner_email}}

Division floors (handicap assignment for new members)

When a new member has no rounds posted, this is the handicap they're assigned. Default values match the official APT division ranges.

Division 13.4 & below
Division 23.5 – 8.4
Division 38.5 – 13.4
Division 413.5 – 18.4
Division 518.5 & above

Relegation thresholds

A validated player is flagged as a relegation candidate when their Tournament Index is at or above this number. Default is 2 strokes above the division ceiling.

Division 1 → 2Default: 5.5 (ceiling 3.4 + 2.1)
Division 2 → 3Default: 10.5 (ceiling 8.4 + 2.1)
Division 3 → 4Default: 15.5 (ceiling 13.4 + 2.1)
Division 4 → 5Default: 20.5 (ceiling 18.4 + 2.1)

Chapter list override

By default the tool uses the hardcoded chapter list (or the dynamic ACF endpoint if configured). Override here only if you need to add/remove specific chapters without a code change. One chapter per line. Leave blank to use the default list.

Settings password

Required to access this page. Change it any time and share the new one with your admins.

Stored in this browser only. Each device that uses settings will need this password the first time.

Dynamic chapter endpoint (advanced)

If your dev has built the WordPress REST endpoint for chapters, paste the URL here. Leave blank to use the hardcoded list.

See the WordPress dev handoff doc for setup. The override list above takes precedence over this endpoint if both are set.