Hi Guys....
Need to get gap between Rank 1 and Rank 2 and separate by groups....
Groups are "nRACE"
Ranks are "Rank"
ABL1 is where "gap" is
Edit:
Was thinking, maybe instead of a raw gap number...convert top to 100% and the rest a percentage from top...
Yes, this is a challenge.......you up to it?
Need to get gap between Rank 1 and Rank 2 and separate by groups....
Groups are "nRACE"
Ranks are "Rank"
ABL1 is where "gap" is
| tDATE | tTRK | nRACE | tPGM | tHOR | nMLO | nABL1 | nDS | nCLA | nAFIN | xWIN | ngoodies | nqpc | nrs | rhtr | rpac23 | rsys2 | ABL1 | rvel | RANK |
| 45200 | ALB | 6 | 1 | Mild Distraction | 20 | 3.5 | 1 | 4 | 6 | 0 | 0 | 0 | 0 | 7 | 0 | 9 | -0.118 | 0 | 3 |
| 45200 | ALB | 6 | 10 | King Bryce | 3 | 5.25 | 1 | 4 | 2 | 0 | 2 | 17 | 4 | 2 | 2 | 2 | -0.1033 | 2 | 2 |
| 45200 | ALB | 6 | 2 | Sleepy Eyes | 25 | 1 | 1 | 4 | 4 | 0 | 0 | 8 | 3 | 9 | 0 | 6 | -0.2049 | 9 | 5 |
| 45200 | ALB | 6 | 3 | Jr's Confidence | 15 | 5.75 | 1 | 4 | 10 | 0 | 0 | 8 | 4 | 4 | 3 | 8 | -0.2574 | 5 | 9 |
| 45200 | ALB | 6 | 4 | Dim the Lights | 6 | 0 | 1 | 4 | 1 | 13.4 | 2 | 33 | 3 | 1 | 1 | 1 | 0.067 | 6 | 1 |
| 45200 | ALB | 6 | 5 | Cash Cruzer | 4.5 | 2.5 | 1 | 4 | 3 | 0 | 0 | 8 | 4 | 6 | 7 | 4 | -0.253 | 3 | 7 |
| 45200 | ALB | 6 | 6 | Ethan | 8 | 5.25 | 1 | 4 | 5 | 0 | 0 | 0 | 4 | 7 | 6 | 9 | -0.3476 | 4 | 10 |
| 45200 | ALB | 6 | 7 | Sea of Indy | 10 | 5 | 1 | 4 | 7 | 0 | 1 | 0 | 4 | 3 | 5 | 3 | -0.2534 | 8 | 8 |
| 45200 | ALB | 6 | 8 | Don Hollywood | 3.5 | 5 | 1 | 4 | 9 | 0 | 0 | 17 | 3 | 4 | 4 | 5 | -0.129 | 1 | 4 |
| 45200 | ALB | 6 | 9 | Arbitro | 12 | 8 | 1 | 4 | 8 | 0 | 0 | 8 | 3 | 10 | 8 | 6 | -0.2475 | 6 | 6 |
| 45200 | ALB | 7 | 1 | Your Adorable | 15 | 6 | 1 | 1 | 10 | 0 | 0 | 8 | 2 | 9 | 9 | 9 | -0.2216 | 7 | 9 |
| 45200 | ALB | 7 | 10 | Bossy Baby | 5 | 1.5 | 1 | 1 | 3 | 0 | 1 | 10 | 3 | 4 | 8 | 5 | -0.1767 | 5 | 8 |
| 45200 | ALB | 7 | 2 | Rachie Rach | 8 | 2.5 | 1 | 1 | 7 | 0 | 0 | 14 | 2 | 8 | 1 | 4 | -0.0982 | 7 | 3 |
| 45200 | ALB | 7 | 3 | Lovely Lola | 6 | 3.5 | 1 | 1 | 1 | 12.6 | 5 | 8 | 3 | 1 | 2 | 1 | -0.0507 | 1 | 2 |
| 45200 | ALB | 7 | 4 | Ragtime Rythm | 8 | 1.5 | 1 | 1 | 8 | 0 | 2 | 10 | 2 | 5 | 6 | 6 | -0.1166 | 3 | 4 |
| 45200 | ALB | 7 | 5 | Bingos System | 15 | 3.75 | 1 | 1 | 4 | 0 | 0 | 6 | 3 | 10 | 10 | 9 | -0.2951 | 7 | 10 |
| 45200 | ALB | 7 | 6 | Olivian | 12 | 0 | 1 | 1 | 6 | 0 | 4 | 16 | 1 | 2 | 4 | 2 | 0.0623 | 6 | 1 |
| 45200 | ALB | 7 | 7 | Princess Jayleen | 4 | 6.25 | 1 | 1 | 9 | 0 | 0 | 8 | 3 | 6 | 3 | 2 | -0.1669 | 4 | 6 |
| 45200 | ALB | 7 | 8 | Miracle of Hope | 12 | 1 | 1 | 1 | 2 | 0 | 2 | 8 | 3 | 3 | 5 | 7 | -0.1721 | 2 | 7 |
| 45200 | ALB | 7 | 9 | She Hit a Homer | 2.5 | 5.25 | 1 | 1 | 5 | 0 | 0 | 10 | 2 | 6 | 7 | 7 | -0.1652 | 7 | 5 |
| 45200 | ALB | 8 | 1 | Las Tres Mariposas | 8 | 0 | 1 | 2 | 3 | 0 | 0 | 11 | 3 | 6 | 7 | 3 | -0.175 | 8 | 5 |
| 45200 | ALB | 8 | 10 | Jedi Jennie | 25 | 3.75 | 1 | 2 | 8 | 0 | 0 | 5 | 4 | 9 | 10 | 9 | -0.3461 | 7 | 10 |
| 45200 | ALB | 8 | 2 | Mamacita Cartier | 15 | 3.25 | 1 | 2 | 9 | 0 | 0 | 16 | 2 | 7 | 4 | 2 | -0.0764 | 5 | 2 |
| 45200 | ALB | 8 | 3 | Miss Tricky Indy | 6 | 9 | 1 | 2 | 10 | 0 | 3 | 14 | 2 | 3 | 1 | 1 | 0.001 | 1 | 1 |
| 45200 | ALB | 8 | 4 | Double Storm | 10 | 0.5 | 1 | 2 | 2 | 0 | 0 | 11 | 2 | 8 | 8 | 7 | -0.1751 | 8 | 6 |
| 45200 | ALB | 8 | 5 | Carolyn's Way | 12 | 3.75 | 1 | 2 | 7 | 0 | 0 | 7 | 4 | 10 | 5 | 8 | -0.3077 | 4 | 9 |
| 45200 | ALB | 8 | 6 | Premeditated Lily | 3 | 3 | 1 | 2 | 6 | 0 | 0 | 7 | 3 | 5 | 9 | 5 | -0.2208 | 8 | 7 |
| 45200 | ALB | 8 | 7 | Artful Rose | 3.5 | 4.25 | 1 | 2 | 5 | 0 | 1 | 14 | 3 | 2 | 2 | 3 | -0.0951 | 2 | 4 |
| 45200 | ALB | 8 | 8 | See You At the Top | 4.5 | 3 | 1 | 2 | 4 | 0 | 1 | 2 | 4 | 1 | 3 | 9 | -0.2716 | 3 | 8 |
| 45200 | ALB | 8 | 9 | Hear Me Roar | 20 | 1.5 | 1 | 2 | 1 | 14.6 | 1 | 14 | 2 | 4 | 6 | 5 | -0.0918 | 6 | 3 |
Edit:
Was thinking, maybe instead of a raw gap number...convert top to 100% and the rest a percentage from top...
Yes, this is a challenge.......you up to it?
Last edited by a moderator:
