El Cid Ladies GHIN Handicap Manager

Manage members, tee assignments and playing handicaps for all three course combinations

Members0
GHIN records0
Missing GHIN0
New GHIN names0

Current status

How this works

  1. Your Master workbook's MEMBERS list and tee assignments were loaded into this app.
  2. Upload the new Playing Handicap Report whenever GHIN information changes.
  3. Existing members are matched by name. All new GHIN players are automatically added to the member list with the Combined tee.
  4. Handicaps recalculate immediately when a tee assignment or Handicap Index changes.

Your data is saved in this browser on this device. Use Export Backup periodically to keep a separate copy.

El Cid Ladies GHIN Handicap Manager — Instructions

This app replaces the linked Excel workflow for maintaining member tee assignments and updating playing handicaps. Your Members & Tees list is the master list. GHIN imports update Handicap Index information, not tee assignments.

Important: Importing a new GHIN report will not change existing member tee assignments. A tee changes only when you manually change it on the Members & Tees page.

1. Initial setup

  1. Review the Members & Tees page and confirm each player's name and assigned tee.
  2. Correct any names or tee assignments directly on that page. Use the tee choices Orange, Combined or Red.
  3. Those saved assignments are used for the handicap calculations for all three course combinations.

2. Import a new GHIN report

  1. Obtain the latest USGA/GHIN Playing Handicap Report.
  2. Open Import GHIN Report and choose the report file.
  3. Click Read report. The app will read the player names and Handicap Index values and show a preview.
  4. Review the number of matched players and new names. If the report looks correct, click Update GHIN data. All new players are added automatically with the Combined tee.
  5. Confirm the update. The new Handicap Index data replaces the previous imported GHIN data.

Your existing Members & Tees list and tee assignments are kept when a report is imported. The app matches names without regard to capitalization or extra spaces, but it is best to keep names exactly as shown in the GHIN report.

3. New players from GHIN

Every player in an imported GHIN report is automatically added to the member list if not already present. New players receive the Combined tee by default. You can change any tee assignment on the Members & Tees page. Existing members keep their saved tee assignments.

4. Change a tee assignment

  1. Go to Members & Tees.
  2. Find the player and choose the new tee from the Assigned Tee dropdown.
  3. The app saves the change and recalculates that player's playing handicaps.

New GHIN imports do not overwrite these assignments. They remain as saved until you change them yourself.

6. Backup your data

  1. Go to Import GHIN Report and choose Export app backup.
  2. Save the JSON backup file somewhere safe.
  3. To restore it later, choose the backup file under Backup & Restore and confirm.

How the app saves information

The app saves your member list, tee assignments and latest GHIN data in this browser on this computer. The information is not automatically shared with another computer or browser. Export a backup regularly, especially before replacing or updating the app.

Recommended routine: Check member names and tee assignments → import the latest GHIN report → add any new players and assign their tees → review the Playing Handicaps → print the Printable Sheet → export a backup.

New names found in GHIN report

These players are in the latest GHIN report but are not yet in your MEMBERS list. Add them here and assign a tee.

Members & tee assignments

Change a tee assignment using the dropdown. The handicap tables update automatically. Player names should match the GHIN report exactly.

Member nameAssigned teeHandicap Index (edit)GHIN match

Playing handicaps

Formula reproduced from the Master workbook: ROUND((Slope ÷ 113 × Handicap Index) + Course Rating − 72), maximum 36. Orange and Red values are shown only for members assigned to those tees; Combined values are calculated for all members.

MemberHIAssigned teeOrangeCombinedRed

Printable Playing Handicap Sheet

Spreadsheet-style layout showing all three course combinations and all three tee columns. Orange and Red handicaps are displayed only for members assigned to those tees; Combined is calculated for all members.

Import latest Playing Handicap Report

Choose the latest USGA/GHIN Excel report. The app reads golfer name and Handicap Index. It also accepts a CSV export with columns for Golfer Name and H.I.

Backup & restore

A backup contains your member list, tee assignments and latest GHIN Handicap Index data.