[beaglebrain]

Note that this is copied spreadsheet and that some of locations of elements are not aligned. I can send the actual spreadsheet if you send me your email addr


Tee times are assigned through the T time system from requests made 4 to 7 days before the target play date. The Championship and Executive assigning systems are independent of each other – playing executive courses does not affect championship course play.
The order of the course and time reserved uses a two level selection process - Placement points first then Reservation points.
Priority members and priority guests are considered to be resident members and resident guests for Executive courses. Placement points are assigned according to the following table noting that being a priority member does not affect executive placement points only championship placement points.


Champ Exec
Priority Member Placement Points 1 6
Priority Guest Placement Points 2 7
Resident Member Placement Points 6 6
Resident Guest Placement Points 7 7
Reservation points are assigned when a reservation is granted – one point per player per reservation. Each reservation point lasts one week from the reservation date.
Extra reservation points are assigned when the reservation is skipped or changed for various reasons.
Deleting or substituting for a player after a reservation is made but before the reservation date adds one reservation point for that player for a total of two reservation points for that reservation. The player substituting in receives one reservation point.
No changes to the reservation can be made on the reservation date. If a player does not play on the reservation date, two reservation points are added for a total of three reservation points.
However, for executive courses, if a player reports to the reserved course starter shack on the reservation date prior to the scheduled T time but does not play, no extra reservation points are assigned. This assumes the player pays any trail fee or green fee if owed.

Once the order is determined, the reservation of a course depends on the day selected, the time or course selected and finally on the availability of the course and time for the number of players.

If the process determines that the time window cannot be satisfied but there is availability outside the time window, a reservation may be made and the players will receive a fraction of one reservation point.

An example of using AVERAGE Placement points and AVERAGE Reservation points on Championship courses follows – note there are some ties – unsure how they are resolved
# Priority Members # Priority Guests # Resident Members # Resident Guests Placement Points Placement Point Avg Placement Sequence Reservation Point Avg Assigned
4


4 1.00 1 0.50 1st
4


4 1.00 1 1.00 2nd
4


4 1.00 1 2.50 3rd
3 1

5 1.25 2 1.00 4th
3 1

5 1.25 2 1.50 5th
2 2

6 1.50 3 0.00 6th
2 2

6 1.50 3 1.00 7th
1 1

3 1.50 3 2.00 8th
2 2

6 1.50 3 2.00 8th
1 1

3 1.50 3 3.00 9th
1 1

3 1.50 3 4.00 10th
1 3

7 1.75 4 1.00 11th
3
1
9 2.25 5 4.00 12th
2
1
8 2.67 6 1.00 13th
2
2
14 3.50 7 0.50 14th
2
1 1 15 3.75 8 1.50 15th
1 1 1 1 16 4.00 9 2.50 16th


4
24 6.00 10 1.00 17th


2 2 26 6.50 11 0.50 18th


An example of using AVERAGE Placement points and AVERAGE Reservation points on Executive courses follows – note there are some ties – unsure how they are resolved
# Priority Members # Priority Guests # Resident Members # Resident Guests Placement Points Placement Point Avg Placement Sequence Reservation Point Avg Assigned
4


24 6.0 1 0 1st
4
1
30 6.0 1 1 2nd
2
1
18 6.0 1 2 3rd


4
24 6.0 1 4 4th
4 1

31 6.2 2 0 5th
3
1 1 31 6.2 2 2 6th
2
2 1 31 6.2 2 2 6th
3 1

25 6.3 3 2 7th
3 1

25 6.3 3 2 7th
2
1 1 25 6.3 3 2 7th
2 2 1
32 6.4 4 4 8th
2 2

26 6.5 5 3 9th
1 1 1 1 26 6.5 5 3 9th
1 1

13 6.5 5 4 10th
1 1

13 6.5 5 5 11th
1 1

13 6.5 5 5 11th


2 2 26 6.5 5 6 12th
2 2
1 33 6.6 6 5 13th


2 4 40 6.7 7 2 14th
1 3

27 6.8 8 1 15th


2 6 54 6.8 8 2 16th

--
Best Regards
Matt