[SBU Board] Trophy Standings

[JC Chupack]

Hi all,

I pulled together the trophy standings:
2020_trophystandings.xlsx
<https://1drv.ms/x/s!AumeGvC5TMn5htxdVS3AvDICWZcNUg?e=JjV3TY>

Details are below. Please feel free to look over and let me know of any
questions or concerns.  *Otherwise, I'll publish the below leaderboards
(not the full spreadsheet) to the trophy area of the website later this
weekend and reference it when we send out the email about the trophy qual
club games.*

Given the low number of folks for the Jabon, I was thinking of sending a
special email notice to Jabon qualifiers in our unit about the virtual
points games over Thanksgiving, to hopefully help bring more competition
into that group (and maybe activate some of our newer players on BBO
clubs). *Does anyone object to Jabon qualifiers getting a special notice of
the trophy qual club games in addition to the mass email blast?*

Leaderboard for Microsoft:

   1. 45.47 Jeffrey Ford
   2. 40.45 Eric Sieg
   3. 39.45 Gregory Herman
   4. 38.40 Kim Eng
   5. 38.04 Ray Miller
   6. 26.48 Michael Christensen
   7. 24.91 Stanford Christie
   8. 24.48 Harry Steiner
   9. 23.97 Jim Aitken
   10. 23.97 Sun-O Ho
   11. 23.79 Rex Tu
   12. 21.61 Jim Chen
   13. 19.86 Cynthia Glad
   14. 18.45 Ray Loftis
   15. 18.33 Tim White
   16. 18.33 Renae White
   17. 18.25 Yong Cao
   18. 18.20 Dave Grubbs
   19. 17.95 Ken Scholes
   20. 15.55 Patrick Dunn

Leaderboard for Jabon (has not changed since Sweetheart except due to
players leaving the unit -- either not renewing or moving away):

   1. 2.58 Christopher Hyland
   2. 2.04 Harold Hal Bomgardner
   3. 2.04 Lisa Lambert-Davis
   4. 2.04 Dane Shaffer
   5. 1.82 Sheila Dahl
   6. 0.99 Betsy Bohnert
   7. 0.77 John Walsh
   8. 0.68 Mary Watts
   9. 0.64 Christopher Brown
   10. 0.64 Aaron Brown
   11. 0.59 Cathy Kay
   12. 0.26 Kendall Aberg
   13. 0.13 Karen Bartlett

(We only have 13 qualifying folks who have earned points for Jabon.)

Methodology:

   - I retrieved all players who earned points in the Sweetheart Sectional.
   - I looked up the points won on Saturday (grass roots day) and
   determined how much each player would lose due to the adjustment. That is
   then added to their total as a negative value in the grass roots adjustment
   column.
      - I checked this against the totals Mike and Sharon had previously
      put together to make sure it came out correctly for the adjustment.
      - I put in a column for virtual trophy points earned at the KO event.
   - I summed the three columns.
   - I looked up ACBL numbers for everyone listed in our roster.
      - If they weren't listed in our unit's roster, I marked them as not
      being in our unit in the ACBL number column.
      - The Jabon/Unit column does a lookup to confirm the ACBL number
   appears in the unit roster as a current member of the unit.
      - I manually double-checked any "n/a"s in my lookup formula and
      adjusted if the issue was the life master letter. In most cases,
the person
      has moved away. In a few cases, their membership has been cancelled or
      expired.
      - To determine Jabon qualification, I looked at YTD points vs. total
   points. Anyone in the unit whose starting total at beginning of year (i.e.,
   total-YTD) was under 20 is considered qualified.


-- 
JC Chupack
* Seattle ACBL Unit 446 <http://www.bridgeinseattle.org> President,
Web/Email Admin, & Publicity Chair
* Lead Technical Product Manager, Zulily <http://www.zulily.com>, Inc.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/mailman/private/sbuboard/attachments/20201016/83d02b92/attachment.html>