El Cid GHIN Handicap Manager

El Cid 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.

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 Gold, Mixed, White, Red or Orange.
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.
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. Add a new player

1. After importing, look at New Names Found in GHIN Report on the Members & Tees page.
2. Find the new player and select their tee: Gold, Mixed, White, Red or Orange.
3. Click Add Member. The player is added to the master member list.
4. The player will now be included in the playing handicap calculations and printable sheet.

A name in the GHIN report is not automatically added to the member list. You must assign a tee and add the player.

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.

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.

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, matching the workbook's HCAPS formulas.

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.