NEVER EDIT or CLEAR YELLOW COLUMNS-AWLAYS COPY YELLOW AND PASTE SPECIAL TO PINK
Copy (Total Points-B) and Paste Special-Values under Accumulated PTS-H)
Copy (Total Shows-I) and Paste Special-Values under Prior Shows
Then clear contents of all NM-D, Time-E, PTS-F and Payout-G
Now you are ready to enter new times and points
Once all new times, points and payouts are entered, select contents of Total Points-B through Prior Shows-K and sort in decending order by Total Points-B with a second sort of Time-E).
***If you need to enter additional lines do so at the bottom and just copy down the formulas in columns Total Points-B, Total Shows-I and Count Show-J***
***Indicate a Scratch by typing in the word SCRATCH in the TIME column and a no time will be 999.999***
COWBOY BARRELS
PLACE TOTAL POINTS CONTESTANT NON MBR TIME PTS PAYOUT ACCUMULATED PTS TOTAL SHOWS COUNT SHOW PRIOR SHOWS
1 82 Kyle Leleux 16.238 6 76 10 1 9
2 72 Clarence Broussard 16.049 7 $19 65 9 1 8
3 64 Jarrod Broussard 15.839 8 $29 56 10 1 9
4 49 Damon Trahan 22.944 2 47 10 1 9
5 48 Chaz Maturin 17.042 5 43 10 1 9
6 48 Brett Bourque 21.805 4 44 8 1 7
7 32 Clyde Covalt 22.851 3 29 8 1 7
8 25 Mark Tucker 25 6 0 6
9 12 Mike Soirez 12 4 0 4
10 10 CJ Covalt 24.718 1 9 6 1 5
11 9 Hunter Gaspard 9 6 0 6
12 5 Brandon Reaux 5 1 0 1
13 0 Dustin Angelle nm 0 0 0 0
14 0 Kyle Cartimigilia nm 0 0 0 0
15
16
17
18
19
20