Spreadsheet: 327712d1403653045-if-and-lookup-example-rankings-ans-1-
Sheet: Registrations

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Slam Silver
Age | FirstName | LastName | DOB | Member # | Gender | Finish | Points |  |  |  |  |  |  |  |  |  |  | Level | Grand Slam Gold |  |  |  |  | Grand Slam Silver |  |  |  |  | Open Gold |  |  |  |  | Open Silver |  |  |  |  | Region Events/Local Promoters Open/Gold |  |  |  |  | Region Events/Local Promoters Club/Silver
 | Player | 1 | 2003-05-26 00:00:00 |  | Female | 1 |  |  |  |  |  |  | Event Type: | Grand Slam Gold |  |  |  | Teams | 41 | 31 | 21 | 11 | 0 | 41 | 31 | 21 | 11 | 0 | 41 | 31 | 21 | 11 | 0 | 41 | 31 | 21 | 11 | 0 | 41 | 31 | 21 | 11 | 0 | 41 | 31 | 21 | 11 | 0
 | Player | 2 | 1998-07-24 00:00:00 |  | Female | 1 |  |  |  |  |  |  |  |  |  |  |  | Base | 400 | 300 | 200 | 100 | 50 | 200 | 150 | 100 | 50 | 25 | 350 | 250 | 150 | 100 | 30 | 175 | 125 | 75 | 25 | 15 | 300 | 200 | 100 | 50 | 20 | 150 | 100 | 50 | 15 | 10
 | Player | 3 | 2000-07-14 00:00:00 |  | Female | 3 |  |  |  |  |  |  |  |  |  |  |  | 1 | 400 | 300 | 200 | 100 | 50 | 200 | 150 | 100 | 50 | 25 | 350 | 250 | 150 | 100 | 30 | 175 | 125 | 75 | 25 | 15 | 300 | 200 | 100 | 50 | 20 | 150 | 100 | 50 | 15 | 10
 | Player | 4 | 1997-08-31 00:00:00 |  | Female | 13 |  |  |  |  |  |  | New formula in  P column |  |  |  |  | 2 | 360 | 270 | 180 | 90 | 45 | 180 | 135 | 90 | 45 | 22.5 | 315 | 225 | 135 | 90 | 27 | 157.5 | 112.5 | 67.5 | 22.5 | 13.5 | 270 | 180 | 90 | 45 | 18 | 135 | 90 | 45 | 13.5 | 9
 | Player | 5 | 1998-05-06 00:00:00 |  | Female | 17 |  |  | 18U | 1996-01-01 00:00:00 | 1997-12-31 00:00:00 |  | Event type can be changed |  |  |  |  | 3 | 320 | 240 | 160 | 80 | 40 | 160 | 120 | 80 | 40 | 20 | 280 | 200 | 120 | 80 | 24 | 140 | 100 | 60 | 20 | 12 | 240 | 160 | 80 | 40 | 16 | 120 | 80 | 40 | 12 | 8
 | Player | 6 | 1999-08-31 00:00:00 |  | Female | 4 |  |  | 16U | 1998-01-01 00:00:00 | 1999-12-31 00:00:00 |  | A small change is done in 3rd Row (S3:W3) |  |  |  |  | 4 | 280 | 210 | 140 | 70 | 35 | 140 | 105 | 70 | 35 | 17.5 | 245 | 175 | 105 | 70 | 21 | 122.5 | 87.5 | 52.5 | 17.5 | 10.5 | 210 | 140 | 70 | 35 | 14 | 105 | 70 | 35 | 10.5 | 7
 | Player | 7 | 2000-02-01 00:00:00 |  | Female | 5 |  |  | 14U | 2000-01-01 00:00:00 | 2001-12-31 00:00:00 |  |  |  |  |  |  | 5 | 240 | 180 | 120 | 60 | 30 | 120 | 90 | 60 | 30 | 15 | 210 | 150 | 90 | 60 | 18 | 105 | 75 | 45 | 15 | 9 | 180 | 120 | 60 | 30 | 12 | 90 | 60 | 30 | 9 | 6
 | Player | 8 | 1999-06-03 00:00:00 |  | Female | 7 |  |  | 12U | 2002-01-01 00:00:00 | 2005-12-31 00:00:00 |  |  |  |  |  |  | 7 | 200 | 150 | 100 | 50 | 25 | 100 | 75 | 50 | 25 | 12.5 | 175 | 125 | 75 | 50 | 15 | 87.5 | 62.5 | 37.5 | 12.5 | 7.5 | 150 | 100 | 50 | 25 | 10 | 75 | 50 | 25 | 7.5 | 5
 | Player | 9 | 1999-10-03 00:00:00 |  | Female | 5 |  |  |  |  |  |  |  |  |  |  |  | 9 | 160 | 120 | 80 | 40 | 20 | 80 | 60 | 40 | 20 | 10 | 140 | 100 | 60 | 40 | 12 | 70 | 50 | 30 | 10 | 6 | 120 | 80 | 40 | 20 | 8 | 60 | 40 | 20 | 6 | 4
 | Player | 10 | 1999-05-31 00:00:00 |  | Female | 9 |  |  | Gender Test | Group Test | # that pass |  |  |  |  |  |  | 13 | 120 | 90 | 60 | 30 |  | 60 | 45 | 30 | 15 |  | 105 | 75 | 45 | 30 |  | 52.5 | 37.5 | 22.5 | 7.5 |  | 90 | 60 | 30 | 15 |  | 45 | 30 | 15 | 4.5
 | Player | 11 | 2001-04-30 00:00:00 |  | Female | 25 |  |  | Female | 12U |  |  |  |  |  |  |  | 17 | 80 | 60 | 40 | 20 |  | 40 | 30 | 20 | 10 |  | 70 | 50 | 30 | 20 |  | 35 | 25 | 15 | 5 |  | 60 | 40 | 20 | 10 |  | 30 | 20 | 10 | 3
 |  |  | 1999-08-10 00:00:00 |  | Female |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 40 | 30 | 20 |  |  | 20 | 15 | 10 |  |  | 35 | 25 | 15 |  |  | 17.5 | 12.5 | 7.5 |  |  | 30 | 20 | 10 |  |  | 15 | 10 | 5
 |  |  | 2002-03-13 00:00:00 |  | Female |  |  |  | Gender Test | Group Test | # that pass |  |  |  |  |  |  | 33 | 20 | 15 |  |  |  | 10 | 7.5 |  |  |  | 17.5 | 12.5 |  |  |  | 8.8 | 6.3 |  |  |  | 15 | 10 |  |  |  | 7.5 | 5
 |  |  | 1997-11-22 00:00:00 |  | Female |  |  |  | Female | 14U |  |  |  |  |  |  |  | 37 | 16 | 12 |  |  |  | 8 | 6 |  |  |  | 14 | 10 |  |  |  | 7 | 5 |  |  |  | 12 | 8 |  |  |  | 6 | 4
 |  |  | 2000-11-24 00:00:00 |  | Female |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 12 |  |  |  |  | 6 |  |  |  |  | 10.5 |  |  |  |  | 5.3 |  |  |  |  | 9 |  |  |  |  | 4.5
 |  |  | 1999-02-03 00:00:00 |  | Female |  |  |  | Gender Test | Group Test | # that pass |  |  |  |  |  |  | 57 | 4 |  |  |  |  | 2 |  |  |  |  | 3.5 |  |  |  |  | 1.8
 |  |  | 1998-12-08 00:00:00 |  | Female |  |  |  | Female | 16U
 |  |  | 2000-11-14 00:00:00 |  | Female
 |  |  | 1998-06-13 00:00:00 |  | Female |  |  |  | Gender Test | Group Test | # that pass
 |  |  | 1996-12-23 00:00:00 |  | Female |  |  |  | Female | 18U
 |  |  | 2000-05-15 00:00:00 |  | Female
 |  |  | 2000-05-12 00:00:00 |  | Female
 |  |  | 1996-03-18 00:00:00 |  | Female |  |  |  | Gender Test | Group Test | # that pass
 |  |  | 1996-09-28 00:00:00 |  | Female |  |  |  | Male | 12U
 |  |  | 2003-12-05 00:00:00 |  | Female
 |  |  | 1999-05-23 00:00:00 |  | Female |  |  |  | Gender Test | Group Test | # that pass
 |  |  | 1996-10-03 00:00:00 |  | Female |  |  |  | Male | 14U
 |  |  | 1999-12-28 00:00:00 |  | Female
 |  |  | 1997-01-19 00:00:00 |  | Female |  |  |  | Gender Test | Group Test | # that pass
 |  |  | 1995-09-27 00:00:00 |  | Female |  |  |  | Male | 16U
 |  |  | 1996-12-20 00:00:00 |  | Female
 |  |  | 1997-10-01 00:00:00 |  | Female |  |  |  | Gender Test | Group Test | # that pass
 |  |  | 1996-12-26 00:00:00 |  | Female |  |  |  | Male | 18U
 |  |  | 1998-11-11 00:00:00 |  | Female
 |  |  | 1996-09-19 00:00:00 |  | Female
 |  |  | 1997-03-03 00:00:00 |  | Female
 |  |  | 1998-06-07 00:00:00 |  | Female
 |  |  | 2002-05-10 00:00:00 |  | Female
 |  |  | 1996-09-18 00:00:00 |  | Female
 |  |  | 1998-04-07 00:00:00 |  | Female
 |  |  | 1998-07-17 00:00:00 |  | Female
 |  |  | 1998-03-20 00:00:00 |  | Female
 |  |  | 2002-01-13 00:00:00 |  | Female
 |  |  | 1997-06-19 00:00:00 |  | Female
 |  |  | 2000-10-09 00:00:00 |  | Female
 |  |  | 1970-05-21 00:00:00 |  | Female
 |  |  | 2004-06-25 00:00:00 |  | Female
 |  |  | 1998-04-13 00:00:00 |  | Female
 |  |  | 2000-09-21 00:00:00 |  | Female
 |  |  | 1998-05-14 00:00:00 |  | Female
 |  |  | 1998-02-13 00:00:00 |  | Female
 |  |  | 1999-02-16 00:00:00 |  | Female
 |  |  | 2000-02-01 00:00:00 |  | Female
 |  |  | 1998-05-07 00:00:00 |  | Female
 |  |  | 2000-04-07 00:00:00 |  | Female
 |  |  | 1999-11-18 00:00:00 |  | Female
 |  |  | 2001-05-17 00:00:00 |  | Female
 |  |  | 1998-10-18 00:00:00 |  | Female
 |  |  | 2002-07-12 00:00:00 |  | Female
 |  |  | 1998-09-19 00:00:00 |  | Female
 |  |  | 2000-05-17 00:00:00 |  | Female
 |  |  | 1999-02-11 00:00:00 |  | Female
 |  |  | 1999-04-08 00:00:00 |  | Female
 |  |  | 2000-12-12 00:00:00 |  | Female
 |  |  | 1997-09-27 00:00:00 |  | Female
 |  |  | 1996-06-19 00:00:00 |  | Female
 |  |  | 2000-04-22 00:00:00 |  | Female
 |  |  | 1999-11-01 00:00:00 |  | Female
 |  |  | 1996-07-09 00:00:00 |  | Female
 |  |  | 1996-10-27 00:00:00 |  | Female
 |  |  | 2004-01-09 00:00:00 |  | Female
 |  |  | 1998-08-27 00:00:00 |  | Female
 |  |  | 1997-06-16 00:00:00 |  | Female
 |  |  | 2000-03-02 00:00:00 |  | Female
 |  |  | 1998-07-08 00:00:00 |  | Female
 |  |  | 1996-04-04 00:00:00 |  | Female
 |  |  | 1996-06-19 00:00:00 |  | Female
 |  |  | 1998-04-06 00:00:00 |  | Female
 |  |  | 1996-02-25 00:00:00 |  | Female
 |  |  | 2000-07-26 00:00:00 |  | Female
 |  |  | 1996-12-24 00:00:00 |  | Female
 |  |  | 1997-09-24 00:00:00 |  | Female
 |  |  | 1999-02-22 00:00:00 |  | Female
 |  |  | 2004-04-14 00:00:00 |  | Female
 |  |  | 1997-02-27 00:00:00 |  | Female
 |  |  | 1998-10-18 00:00:00 |  | Female
 |  |  | 1997-12-11 00:00:00 |  | Female
 |  |  | 1996-05-20 00:00:00 |  | Female
 |  |  | 1998-05-17 00:00:00 |  | Female
 |  |  | 2003-05-21 00:00:00 |  | Female
 |  |  | 1996-05-28 00:00:00 |  | Female
 |  |  | 2000-09-21 00:00:00 |  | Female
 |  |  | 1970-05-21 00:00:00 |  | Female
 |  |  | 2004-05-15 00:00:00 |  | Female
 |  |  | 2004-05-16 00:00:00 |  | Female
 |  |  | 2004-05-17 00:00:00 |  | Female
 |  |  | 2004-05-18 00:00:00 |  | Female
 |  |  | 2004-05-19 00:00:00 |  | Female
 |  |  | 2004-05-20 00:00:00 |  | Female
 |  |  | 2004-05-21 00:00:00 |  | Female
 |  |  | 2004-05-22 00:00:00 |  | Female
 |  |  | 2004-05-23 00:00:00 |  | Female
 |  |  | 2004-05-24 00:00:00 |  | Female
 |  |  | 2004-05-25 00:00:00 |  | Female
 |  |  | 2004-05-26 00:00:00 |  | Female
 |  |  | 2004-05-27 00:00:00 |  | Female
 |  |  | 2004-05-28 00:00:00 |  | Female
 |  |  | 2004-05-29 00:00:00 |  | Female
 |  |  | 2004-05-30 00:00:00 |  | Female
 |  |  | 2004-05-31 00:00:00 |  | Female
 |  |  | 2004-06-01 00:00:00 |  | Female
 |  |  | 2004-06-02 00:00:00 |  | Female
 |  |  | 2004-06-03 00:00:00 |  | Female
 |  |  | 2004-06-04 00:00:00 |  | Female
 |  |  | 2004-06-05 00:00:00 |  | Female
 |  |  | 2004-06-06 00:00:00 |  | Female
 |  |  | 2004-06-07 00:00:00 |  | Female
 |  |  | 2004-06-08 00:00:00 |  | Female
 |  |  | 2004-06-09 00:00:00 |  | Female
 |  |  | 2004-06-10 00:00:00 |  | Female
 |  |  | 2004-06-11 00:00:00 |  | Female
 |  |  | 2004-06-12 00:00:00 |  | Female
 |  |  | 2004-06-13 00:00:00 |  | Female
 |  |  | 2004-06-14 00:00:00 |  | Female
 |  |  | 2004-06-15 00:00:00 |  | Female
 |  |  | 2004-06-16 00:00:00 |  | Female
 |  |  | 2004-06-17 00:00:00 |  | Female