Spreadsheet: 691150d1597512337-excel-non-vba-code-balance-and-create-6-flights-based-on-player-handicap-sample-round-1-flights-all-plaayers
Sheet: Flight and Handicap

General Notes and Additional Instructions: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flights and Handicaps (used for Roster- Web Specific and INDIVIDUAL Score sheets
1. Depending on the selected Handicap Deciminal Places (cell G16) that appear in column G (Report Handicap), the user may wish to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DO NOT Remove or Adjust Position
alter the Number format from General to a specific Decimal format.  If the format is changed, PLEASE revert to General before saving the Master file.
2. If a Player will not be playing in the Mid Season or Year End Scramble (4 Flight play only), enter a capital X in column E (adjacent to Player's Name) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Highlighted cell (Col B) = Duplicate Names     Highlighted cell (Col M) = Duplicate Ranking     Highlighted cell (Col C/D) = No Hcp (N or *)
3. Designated Flights are changed using the "Drop Down" list (cell F15) Handicap Decimal Places may be changed using the "Drop Down" list (cell F16)
4. League Tournament only: Create 2 copies of the Flight Adjustment worksheet; each worksheet should be named for specific the Group and edited to only contain the Group data.  Import Flights to the Hcp System.
5. League Tournament only: Following Data Import from System, copy each Roster to column A - Use Copy > Paste Special > Values - verify that column N contains no "NO" value (except for those players without a Hcp).
Player's Handicap and Flight Re-assignment |  |  |  |  |  |  |  |  |  |  |  |  |  | Values for Drop Down List  (Do Not Remove) |  |  |  |  | Mid Season and Year End Scramble Pairings - 4 Flights
Workbook Revision: |  | Group Catagories: | BLUE | GOLD |  |  |  |  |  |  |  |  |  | Designated Flights |  |  |  |  | List is Developed by Flight - Each Flight is [NAME] from Low to High/High to Low Handicaps
2020-08-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 5 | 6 |  |  | Below Matrix is Designed for 60 Foursomes |  |  |  |  |  |  |  |  |  |  |  | Lowest Team Average Handicap:
 |  |  |  |  |  | Players Represented by Group Designation |  |  |  |  |  |  |  | Handicap Deciminal Places |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Highest Team Average Handicap:
Roster Downloaded: |  |  |  |  |  | GOLD |  | BLUE |  |  | Player Total: |  |  | 0 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tolerance w/o Adjustment (manual input entry): | 2.5
 |  |  |  |  |  |  |  |  |  |  | Player's W/O a Hcp: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group Variance (Average Max to Average Min):
Event: |  |  |  |  |  |  |  |  |  |  | Players excluded from Mid/Year End Scramble or League Tournament: |  |  | 6 Flights Handicap Range (All Groups) |  |  |  |  | (insert Group by formula) - 4 Flights Handicap Range -
 |  |  |  | Number of Flights: | 6 | A | B | C | D | E | F | Roster Total |  | Flights | From | To | Player Count
 |  |  |  | Hcp Decimal Places: | 2 |  |  |  |  |  |  |  |  | A | 0 |  |  |  | A | Rank | Hdcp | B | Rank | Hdcp | C | Rank | Hdcp | D | Rank | Hdcp | Aggregate | Average
 |  |  |  | Handicap Range: | From | 0 |  |  |  |  |  |  |  | B
 |  |  |  |  | To |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 |  |  |  | Flight |  |  | Flight Assignment (all Groups) |  |  |  |  | Flight Rank w/Duplicates | Flights Agree Sys : Adj Flight | E
 |  |  |  | Play | [NAME] | Adj Flight | 6 Flights | 5 Flights | 4 Flights | Hcp | Rank |  |  | F
ANZIA, RONALD | BLUE | B | 23
BAIL, PHIL | BLUE | F | 38.19 |  |  |  |  |  |  |  |  |  |  | 5 Flights Handicap Range (All Groups)
BARTHOLOMEW, BOB | BLUE | C | 26.04 |  |  |  |  |  |  |  |  |  |  | Flights | From | To | Player Count
BAUZENBERGER, RICHARD | BLUE | B | 22.15 |  |  |  |  |  |  |  |  |  |  | A | 0
BEWALDA, BOB | BLUE | B | 21.95 |  |  |  |  |  |  |  |  |  |  | B
BOESELAGER, JEROME | BLUE | A | 18.39 |  |  |  |  |  |  |  |  |  |  | C
BOWMAN, SCOTT | BLUE | C | 23.8 |  |  |  |  |  |  |  |  |  |  | D
BRANDSTATTER, RON | BLUE | C | 26.34 |  |  |  |  |  |  |  |  |  |  | E
BURGHARDT, CHIP | BLUE | E | 35.07
BUTH, BILL | BLUE | F | 45 |  |  |  |  |  |  |  |  |  |  | 4 Flights Handicap Range (All Groups)
CALVELLI, RICK | BLUE | F | 37.93 |  |  |  |  |  |  |  |  |  |  | Flights | From | To | Player Count
CAMPBELL, [NAME] | BLUE | C | 26.08 |  |  |  |  |  |  |  |  |  |  | A | 0
CASHIN, PAT | BLUE | E | 34.02 |  |  |  |  |  |  |  |  |  |  | B
CHRISTENSON, ERIK | BLUE | F | 45 |  |  |  |  |  |  |  |  |  |  | C
COOK, RON | BLUE | B | 23.1 |  |  |  |  |  |  |  |  |  |  | D
COVERT, JACK | BLUE | F | 40.76
COVERT, [NAME] | BLUE | D | 29.03
DAVIS, JULIUS | BLUE | D | 28.31
D'CRUZE, [NAME] | BLUE | E | 34.39
DEVEREY, PETER | BLUE | B | 23.3
DINESEN, NIEL | BLUE | F | 39.58
DIVINE, [NAME] | BLUE | E | 30.8
EBEL, JERRY | BLUE | F | 40.26
EDWARDS, DON | BLUE | B | 19.5
EDWARDS, [NAME] | BLUE | F | 43.42
FOX, [NAME] | BLUE | F | 41.75
GILROY, BOB | BLUE | B | 23.48
GIULIANI, [NAME] | BLUE | C | 26.04
GOLDSTEIN, PAUL | BLUE | E | 33.14
GROMACKI, CHUCK | BLUE | F | 38.33
GUELLER, JON | BLUE | C | 25.07
HACKL, DICK | BLUE | C | 24.95
HAEBIG, JIM | BLUE | E | 35.37
HAGERUP, [NAME] | BLUE | E | 31.85
HANNEMANN, [NAME] | BLUE | A | 15.81
HASS, DAVE | BLUE | A | 17.99
HEATWOLE, SCOTT | BLUE | D | 30
HERRO, [NAME] | BLUE | D | 30.22
[NAME], PETER | BLUE | C | 24.39
HOCKINSON, JACK | BLUE | E | 31.29
HOMAN, MARK | BLUE | D | 28.65
HUSSIN, GERALD | BLUE | F | 37.3
INMAN, STEVE | BLUE | F | 36.54
[NAME], [NAME] | BLUE | F | 37.4
JARR, RON | BLUE | C | 23.56
[NAME], J.J | BLUE | F | 41.23
JORGENSEN, JAY | BLUE | C | 26.18
KANIA, SCOTT | BLUE | D | 26.88
KEEN, JOHN | BLUE | C | 26.32
KING, RICK | BLUE | A | 17.18
KLEIN, [NAME] | BLUE | D | 30.22
KOESTER, KIPP | BLUE | D | 28.97
LANGE, REINER | BLUE | E | 31.67
LANGE, [NAME] | BLUE | D | 26.62
LANGENFELD, [NAME] | BLUE | F | 40.66
LILYQUIST, [NAME] | BLUE | A | 17.16
LOHR, CHUCK | BLUE | A | 17.61
[NAME], [NAME] | BLUE | C | 24.25
LULLO, JON | BLUE | D | 29.36
LUSK, DON | BLUE | F | 38.37
MADRITSCH, BOB | BLUE | A | 16.58
[NAME], [NAME] | BLUE | D | 29.98
MALECKI, RON | BLUE | F | 45
MEDTLIE, PEDER | BLUE | C | 24.89
[NAME], GARY | BLUE | E | 33.18
MICHAUD, [NAME] | BLUE | B | 20.7
MOLTER, KENT | BLUE | E | 31.47
MOYER, JACK | BLUE | B | 22.47
O'MALLEY, TOM | BLUE | D | 29.6
OTOOLE, [NAME] | BLUE | A | 14.99
OTTO, BILL | BLUE | D | 30.16
PATRICK, TERRENCE | BLUE | A | 17.59
PETERKA, PATRICK | BLUE | F | 39.15
PETERMAN, STEVE | BLUE | E | 30.7
PLAMBECK, KEITH | BLUE | F | 45
POSSLEY, ROBERT | BLUE | D | 29.09
REILLY, [NAME] | BLUE | F | 36.32
RITT, DON | BLUE | B | 20.12
ROGAHN, GARY | BLUE | B | 23.46
SCHLAEFER, STEVE | BLUE | B | 21.13
SCHLEICHER, BILL | BLUE | F | 37.02
SCHWENSOHN, HERB | BLUE | A | 17.38
SCHWULST, [NAME] | BLUE | F | 41.63
SHAVER, DEAN | BLUE | D | 30.22
SHEEHAN, BOB | BLUE | E | 31.27
SHIRLEY, BILL | BLUE | F | 45
SMITH, DAVE | BLUE | F | 36.24
STERKENBURG, LARRY | BLUE | D | 28.07
STERN, JIM | BLUE | F | 37.02
STUMPF, GLEN | BLUE | D | 27.04
SWANSON, CLINT | BLUE | C | 26.46
SWISHER, ROY | BLUE | D | 30.08
THEVENET, TED | BLUE | D | 28.53
TONELLI, JIM | BLUE | B | 19.52
UNGERMAN, RICK | BLUE | B | 22.88
VOLLMER, [NAME] | BLUE | C | 25.92
WAGNER, JIM | BLUE | D | 30.46
WHAM, ROBERT | BLUE | E | 30.76
WILLEMS, JULE | BLUE | B | 21.91
WITHAM, [NAME] | BLUE | C | 24.45
ZELLNER, MARK | BLUE | C | 24.29
ZICKUHR, ROBERT | BLUE | A | 14.85
ZITO, BILL | BLUE | F | 41.33
ZOELLER, LEO | BLUE | F | 39.05
[NAME], NORM | GOLD | B | 18.79
[NAME], [NAME] | GOLD | B | 22.96
BALOG, JOHN | GOLD | E | 36
BERGER, DAVE | GOLD | D | 30.28
BEVERUNG, BUD | GOLD | E | 33.32
BLANK, DARREL | GOLD | E | 32.25
BLATNAK, STEVE | GOLD | A | 14.29
BLAZICH, BOB | GOLD | C | 25.9
BORCHERT, [NAME] | GOLD | E | 35.25
BORKENHAGEN, ED | GOLD | B | 21.73
BREMER, THOMAS | GOLD | D | 28.37
BRODIE, [NAME] | GOLD | B | 20.93
CARLTON, JOHN | GOLD | A | 9.68
[NAME], [NAME] | GOLD | A | 17.97
CORRIGAN, [NAME] | GOLD | D | 28.07
DAMM, TOM | GOLD | E | 36
DORR, [NAME] | GOLD | B | 22.56
DOWNEY, ED | GOLD | C | 24.27
DUDEK, RALPH | GOLD | E | 36
DUNCOMBE, DICK | GOLD | B | 21.33
DYER, JIM | GOLD | B | 21.61
EBERT, TOM | GOLD | E | 31.33
EMERICH, DICK | GOLD | A | 17.36
END, [NAME] | GOLD | A | 11.27
[NAME], [NAME] | GOLD | A | 10.48
EWALD, RON | GOLD | C | 24.69
FROMMELL, GEORGE | GOLD | C | 24.95
FUNK, [NAME] | GOLD | E | 34.24
GEIS, BOB | GOLD | E | 31.19
GILES, TOM | GOLD | C | 25.94
GONZALEZ, FERNANDO | GOLD | A | 7.89
GRAFF, DAVE | GOLD | A | 7.87
HAISCHER, TED | GOLD | D | 29.88
HANSEN, GUY | GOLD | E | 36
[NAME], [NAME] | GOLD | E | 36
HOLLOWAY, WILLIAM | GOLD | A | 14.79
HOSKING, CARLYLE | GOLD | B | 21.53
HUGHES, [NAME] | GOLD | C | 25.53
IANNARELLI, DON | GOLD | E | 36
[NAME], RICHARD | GOLD | B | 19.96
[NAME], ED | GOLD | E | 34.22
JOSE, [NAME] | GOLD | A | 11.07
JUNG, TOM | GOLD | B | 20.16
KELLEY, [NAME] | GOLD | A | 12.66
KENDALL, [NAME] | GOLD | E | 30.74
KLEMANN, RON | GOLD | A | 15.05
KNORR, [NAME] | GOLD | A | 18.17
KNORR, JIM | GOLD | C | 24.95
KOEHLER, DARREL | GOLD | N
KOEPPEN, WILLIAM | GOLD | E | 36
KOLLMAN, HARRY | GOLD | D | 28.51
KOPECKO, [NAME] | GOLD | B | 21.73
KOROL, [NAME] | GOLD | B | 18.83
KOROL, [NAME] | GOLD | B | 22.37
KRAIER, STEVE | GOLD | N
KRENKE, GARY | GOLD | D | 27.34
KUOPUS, MARK | GOLD | A | 10.66
LAINE, DON | GOLD | A | 17.22
LANGE, [NAME] | GOLD | D | 27.71
LANGE, WALLY | GOLD | C | 23.78
[NAME], [NAME] | GOLD | A | 15.43
LECEY, BOB | GOLD | A | 9.68
LEMKE, [NAME] | GOLD | C | 23.6
LORGE, AL | GOLD | C | 24.77
MACK, BOB | GOLD | D | 28.13
MADOLE, JOHN | GOLD | C | 24.95
MARTELL, CRAIG | GOLD | E | 31.96
MCGRATH, ROGER | GOLD | C | 24.77
MCINTYRE, [NAME] | GOLD | D | 30.28
MCKEOWN, PATRICK | GOLD | E | 32.17
MEUNIER, CHUCK | GOLD | A | 17.79
MICHA, DAN | GOLD | C | 23.54
MILLER, AL | GOLD | B | 20.36
MIXDORF, ED | GOLD | A | 13.86
MOATS, [NAME] | GOLD | D | 26.76
MONT MARQUETTE, TOM | GOLD | A | 12.43
MUELLER, DALE | GOLD | D | 29.94
MULARSKI, [NAME] | GOLD | E | 30.68
NELSON, AL | GOLD | E | 35.11
NEWELL, [NAME] | GOLD | C | 26.18
OLSEN, PETE | GOLD | C | 25.35
PAREZ, [NAME] | GOLD | B | 21.69
PEGELOW, KEITH | GOLD | B | 20.16
PETERSON, [NAME] | GOLD | E | 36
POWERS, HANK | GOLD | E | 36
RATER, [NAME] | GOLD | E | 36
REFINSKI, [NAME] | GOLD | A | 7.22
RIBICH, STAN | GOLD | D | 30.46
ROBINSON, [NAME] | GOLD | C | 23.54
SAVADIL, CLARENCE | GOLD | B | 18.95
SCHROEDER, RAY | GOLD | E | 34.71
SCHUELLER, ALLEN | GOLD | C | 24.35
SINGLEY, BILL | GOLD | D | 29.96
SLAASTED, BOB | GOLD | A | 16.8
SMITH, DEAN (G.D.) | GOLD | E | 32.07
SNYDER, PHIL | GOLD | E | 30.66
SORENSON, [NAME] | GOLD | B | 20.99
SPITZ, KEN | GOLD | D | 26.8
STEARNS, [NAME] | GOLD | A | 18.39
STOCK, LEE | GOLD | E | 36
STOECKER, [NAME] | GOLD | E | 33.46
STROM, JUSTIN | GOLD | E | 32.96
WATT, [NAME] | GOLD | E | 36
WILTERDINK, ROD | GOLD | C | 25.15
YENOR, BRUCE | GOLD | B | 20.72
YOUNG, PETER | GOLD | D | 26.74
YOUNG, TERRY | GOLD | A | 17.02
Last Row of Data - Above Line