Spreadsheet: 760362d1640179237-golf-skins-and-count-by-color-paint-creek-excel-golf
Sheet: Data Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Places Paid |  |  | Quota |  |  |  |  | Paint Creek Country Club
 |  |  | Rating-par |  | Type of Game |  |  |  |  |  | Used to cal total pos pts |  |  |  |  |  |  | Tot Pool |  |  |  |  | [NAME] Golf Course
Tee's | RATING | SLOPE | CR-PAR |  | Game Type |  |  |  |  |  | From Main cell AE5 |  |  |  | 0 |  |  |  |  |  |  |  | Oak Hurst Country Club
BLUE | 71.8 | 139 | 0.8 |  | Skins |  |  | None |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | Indianwood Country Club
BLUE/WH | 70 | 131 | -1 |  | Stableford |  |  | Half HDCP |  |  |  |  | Skin Value |  | 2 |  |  | TOT Quota Pts
WHITE | 68.3 | 126 | -2.7 |  | Skins & Stableford |  |  | Full HDCP |  | Point of Place |  |  |  |  | 3
RED/WH | 66.3 | 118 | -4.7 |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 1st
RED | 64 | 109 | -7 |  |  |  |  |  |  | Place |  |  |  |  | 5 |  |  | Pt Value
 |  |  |  |  |  |  |  |  |  | Point |  |  |  |  | 6 |  |  |  |  |  |  |  | 1
[NAME] | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 0.9
[NAME] | 1 |  | [NAME] to get hdcp from index |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 0.8
Par | 2 |  | index times slope, divided by 113, + (course rating minus par) |  |  |  |  |  |  | YES |  |  |  |  | 9 |  |  | Skin Value |  |  |  |  | 0.7
[NAME] | 3 |  |  |  |  |  |  |  |  | NO |  |  |  |  | 10 |  |  |  |  |  |  |  | 0.6
Eagle | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
Dbl Eagle | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | IN | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | OUT | TOTAL | 0.2
Blue Tees | yards | 569 | 142 | 398 | 400 | 170 | 372 | 383 | 378 | 432 |  | 506 | 170 | 351 | 353 | 361 | 378 | 544 | 377 | 192 |  |  | 0.1
 | hdcp | 5 | 17 | 1 | 9 | 15 | 11 | 7 | 13 | 3 |  | 6 | 16 | 18 | 12 | 8 | 2 | 10 | 4 | 14
 | Par
bl/wh | yards | 526 | 142 | 377 | 376 | 170 | 372 | 354 | 378 | 396 |  | 506 | 138 | 351 | 353 | 330 | 378 | 477 | 377 | 145
 | hdcp | 7 | 17 | 1 | 5 | 15 | 9 | 13 | 11 | 3 |  | 6 | 16 | 18 | 12 | 8 | 2 | 10 | 4 | 14
 | Par |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CF to highlight skins
white | yards | 526 | 128 | 377 | 376 | 144 | 360 | 354 | 342 | 396 |  | 456 | 138 | 315 | 317 | 330 | 318 | 477 | 328 | 145
 | hdcp | 7 | 17 | 1 | 5 | 15 | 9 | 13 | 11 | 3 |  | 6 | 16 | 18 | 12 | 8 | 2 | 10 | 4 | 14
 | Par |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula for .5 skin
Red/Wh | yards | 418 | 128 | 323 | 311 | 144 | 360 | 312 | 342 | 364 |  | 456 | 138 | 315 | 317 | 300 | 318 | 392 | 328 | 102
 | hdcp | 7 | 17 | 3 | 11 | 15 | 5 | 9 | 13 | 1 |  | 8 | 18 | 6 | 2 | 10 | 14 | 4 | 16 | 2 |  |  |  |  |  | IF(C16>=E3,E16-0.5,E16)
 | Par
Red | yards | 418 | 120 | 323 | 311 | 139 | 333 | 312 | 284 | 364 |  | 389 | 91 | 293 | 283 | 300 | 260 | 392 | 240 | 102
 | hdcp | 7 | 17 | 3 | 11 | 15 | 5 | 9 | 13 | 1 |  | 8 | 18 | 6 | 2 | 10 | 14 | 4 | 16 | 2
 | Par
SKINS
[NAME] FULL HDCP SKINS
STABLEFORD - WITH HALF HDCP SKINS
STABLEFORD - WITHOUT SKINS