Spreadsheet: 732452d1620967450-trying-to-populate-cells-in-a-specific-order-on-a-sheet-with-data-from-an-unsorted-sheet-book-1
Sheet: Teams

MUST ENABLE ITERATIVE CALCULATIONS |  |  | B.E. Portfolio |  |  | Box Elder Test |  |  | Use only in case of ties, otherwise leave blank. |  |  | [NAME] Judged Events                                             Enter "O" for Orange Ribbons when there's a DQ. |  |  |  |  |  | [NAME] "0.000" for Orange Ribbons, don't leave blank. (Leaving it blank is used for kids that don't attempt to compete.)
 | Name | # | Was a Portfolio Turned In?          (If Yes, Enter Y) |  | Portfolio Bonus Point | Correct Number of Test Questions (Don't [NAME]) | TEST Score | Total # of Bonus Questions Correct  (Don't [NAME]) | Random Test Question Tie-Breaker (Enter Y or N) | Sudden Death Tie-Breaker (Enter Y or N) | Test Place | Show- manship [NAME] | Show- manship Points | Horse- manship Ribbon | Horse- manship Points | Ranch Riding Ribbon | Ranch Riding Points | Keyhole Time | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Barrel Time | [NAME] | Barrel Points
1 | Destiny Zarate | 5 | Y |  |  | 28 |  | 3 |  |  |  | R |  | R |  | R |  | 9.395 |  |  | 27.937 |  |  | 18.636
2 | [NAME] | 9 | Y |  |  | 40 |  | 1 |  |  |  | R |  | R |  | R |  | 0 |  |  | 30.244 |  |  | 31.16
3 | Dustee Buhl | 13 | Y |  |  | 23 |  | 1 |  |  |  | B |  | R |  | R |  | 10.926 |  |  | 31.43 |  |  | 24.052
4 | [NAME] | 17 | Y |  |  | 24 |  | 1 |  |  |  | B |  | B |  | B |  | 11.108 |  |  | 32.83 |  |  | 23.725
5 | [NAME] | 21 | Y |  |  | 18 |  | 1 |  |  |  | W |  | R |  | B |  | 8.743 |  |  | 28.591 |  |  | 23.578
6 | [NAME] | 25 | Y |  |  | 21 |  |  |  |  |  | B |  | B |  | B |  | 13.071 |  |  |  |  |  | 28.759
7 | [NAME] | 29 | Y |  |  | 12 |  |  |  |  |  | R |  | R |  | R |  | 22.715 |  |  | 47.066 |  |  | 29.354
8 | [NAME] | 33 | Y |  |  | 20 |  |  |  |  |  | W |  | W |  | W |  | 24.042 |  |  | 0 |  |  | 36.723
 | Event Top 5 Total Points
 | All 8 competitors Points Totals:
 | [NAME] TEAM TOTAL: |  |  |  |  |  |  | BOX ELDER JUNIOR TEAM
 | [NAME] RANK:
 |  |  | Cache Portfolio |  |  | Cache Test |  |  | Use only in case of ties, otherwise leave blank. |  |  | Cache Judged Events                                                                                         Enter "O" for Orange Ribbons when there's a DQ. |  |  |  |  |  | Cache Speed Events                                                                                                                                                                                                    Enter "0.000" for Orange Ribbons, don't leave blank. (Leaving it blank is used for kids that don't attempt to compete.)
 | Name | # | Was a Portfolio Turned In?          (If Yes, Enter Y) |  | Portfolio Bonus Point | Correct Number of Test Questions (Don't [NAME]) | TEST Score | Total # of Bonus Questions Correct  (Don't [NAME]) | Random Test Question Tie-Breaker (Enter Y or N) | Sudden Death Tie-Breaker (Enter Y or N) | Test Place | Show- manship [NAME] | Show- manship Points | Horse- manship Ribbon | Horse- manship Points | Ranch Riding Ribbon | Ranch Riding Points | Keyhole Time | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Barrel Time | [NAME] | Barrel Points
1 | [NAME] | 4 | Y |  |  | 23 |  |  |  |  |  | R |  | B |  | R |  | 10.083 |  |  | 28.412 |  |  | 20.871
2 | [NAME] | 8 | Y |  |  | 25 |  | 1 | n |  |  | B |  | R |  | B |  | 26.412 |  |  | 27.54 |  |  | 20.564
3 | [NAME] | 12 | Y |  |  | 15 |  |  |  |  |  | R |  | B |  | B |  | 11.89 |  |  | 30.376 |  |  | 22.764
4 | Ryleigh Merrill | 16 | Y |  |  | 24 |  | 1 |  |  |  | R |  | B |  | R |  | 13.518 |  |  |  |  |  | 17.576
5 | [NAME] | 20 | Y |  |  | 20 |  |  |  |  |  | W |  | B |  | R |  | 13.459 |  |  | 36.52 |  |  | 31.319
6 | [NAME] | 24 | Y |  |  | 25 |  | 1 | y |  |  | B |  | R |  | B |  | 12.094 |  |  | 38.193 |  |  | 26.481
7 | [NAME] | 28 | Y |  |  | 19 |  |  |  |  |  | R |  | B |  | R |  | 9.766 |  |  | 25.01 |  |  | 20.265
8 | [NAME] | 32 | Y |  |  | 16 |  |  |  |  |  | W |  | R |  | R |  | 15.422 |  |  | 37.281 |  |  | 29.364
 | Event Top 5 Total Points
 | All 8 competitors Points Totals:
 | Cache Juniors TEAM TOTAL: |  |  |  |  |  |  | CACHE JUNIOR TEAM
 | Cache Juniors RANK:
 |  |  | [NAME] |  |  | [NAME] |  |  | Use only in case of ties, otherwise leave blank. |  |  | [NAME] Judged Events                                                                       Enter "O" for Orange Ribbons when there's a DQ. |  |  |  |  |  | [NAME] "0.000" for Orange Ribbons, don't leave blank. (Leaving it blank is used for kids that don't attempt to compete.)
 | Name | # | Was a Portfolio Turned In?          (If Yes, Enter Y) |  | Portfolio Bonus Point | Correct Number of Test Questions (Don't [NAME]) | TEST Score | Total # of Bonus Questions Correct  (Don't [NAME]) | Random Test Question Tie-Breaker (Enter Y or N) | Sudden Death Tie-Breaker (Enter Y or N) | Test Place | Show- manship [NAME] | Show- manship Points | Horse- manship Ribbon | Horse- manship Points | Ranch Riding Ribbon | Ranch Riding Points | Keyhole Time | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Barrel Time | [NAME] | Barrel Points
1 | [NAME] | 3 | Y |  |  | 14 |  | 1 |  |  |  | W |  | B |  | R |  | 18.251 |  |  | 33.016 |  |  | 25.892
2 | [NAME] | 7 | Y |  |  | 17 |  |  |  |  |  | R |  | W |  | R |  | 15.607 |  |  | 33.812 |  |  | 27.703
3 | [NAME] | 11 | Y |  |  | 20 |  | 1 | y |  |  | W |  | R |  | R |  | 12.08 |  |  | 31.272 |  |  | 22.715
4 | [NAME] | 15 | Y |  |  | 22 |  | 1 |  |  |  | W |  | R |  | W |  | 16.58 |  |  | 44.651 |  |  | 26.993
5 | [NAME] | 19 | Y |  |  | 0 |  | 0
6 | [NAME] | 23 | Y |  |  | 20 |  |  | y |  |  | W |  | W |  | W |  | 11.0189 |  |  | 34.439 |  |  | 25.204
7 | [NAME] | 27 | Y |  |  | 20 |  |  | n |  |  | W |  | W |  | W |  | 15.028 |  |  | 41.319 |  |  | 28.84
8 | [NAME] | 31 | Y |  |  | 16 |  |  |  |  |  | R |  | R |  | R |  | 10.967 |  |  | 54.057 |  |  | 21.073
 | Event Top 5 Total Points
 | All 8 competitors Points Totals:
 | [NAME] TEAM TOTAL: |  |  |  |  |  |  | DAVIS JUNIOR TEAM
 | [NAME] RANK:
 |  |  | Weber Portfolio |  |  | Weber Test |  |  | Use only in case of ties, otherwise leave blank. |  |  | Weber Judged Events                                                                     Enter "O" for Orange Ribbons when there's a DQ. |  |  |  |  |  | Weber Speed Events                                                                                                                                                                                                    Enter "0.000" for Orange Ribbons, don't leave blank. (Leaving it blank is used for kids that don't attempt to compete.)
 | Name | # | Was a Portfolio Turned In?          (If Yes, Enter Y) |  | Portfolio Bonus Point | Correct Number of Test Questions (Don't [NAME]) | TEST Score | Total # of Bonus Questions Correct  (Don't [NAME]) | Random Test Question Tie-Breaker (Enter Y or N) | Sudden Death Tie-Breaker (Enter Y or N) | Test Place | Show- manship [NAME] | Show- manship Points | Horse- manship Ribbon | Horse- manship Points | Ranch Riding Ribbon | Ranch Riding Points | Keyhole Time | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Barrel Time | [NAME] | Barrel Points
1 | Brooklyn Fowers | 2 | Y |  |  | 25 |  |  |  |  |  | R |  | B |  | B |  | 8.976 |  |  | 23.171 |  |  | 17.103
2 | Gabriella Flint | 6 | Y |  |  | 29 |  | 1 |  |  |  | B |  | B |  | R |  | 11.03 |  |  | 25.668 |  |  | 17.851
3 | Sydney Opeikens | 10 | Y |  |  | 17 |  | 1 |  |  |  | W |  | R |  | R |  | 20.1 |  |  | 25.525 |  |  | 19.116
4 | [NAME] | 14 | Y |  |  | 12 |  |  |  |  |  | R |  | B |  | W |  | 28.85 |  |  | 24.584 |  |  | 25.055
5 | Briar King | 18 | Y |  |  | 24 |  | 1 |  |  |  | R |  | R |  | R |  | 10.8 |  |  | 30.596 |  |  | 20.1
6 | [NAME] | 22 | Y |  |  | 19 |  | 1 |  |  |  | W |  | B |  | R |  | 21.196 |  |  | 0 |  |  | 17.207
7 | [NAME] | 26 | Y |  |  | 16 |  |  |  |  |  | B |  | B |  | B |  | 12.526 |  |  | 31.442 |  |  | 23.359
8 | [NAME] | 30 | Y |  |  | 23 |  | 1 |  |  |  | R |  | B |  | R |  | 11.685 |  |  | 31.575 |  |  | 21.267
 | Event Top 5 Total Points
 | All 8 competitors Points Totals:
 | Weber Juniors TEAM TOTAL: |  |  |  |  |  |  | WEBER JUNIOR TEAM
 | Weber Juniors RANK:
 |  |  | Summit / Wasatch Portfolio |  |  | Summit / Wasatch                                        Test |  |  | Use only in case of ties, otherwise leave blank. |  |  | Summit / Wasatch               Judged Events                                                                                         Enter "O" for Orange Ribbons when there's a DQ. |  |  |  |  |  | Summit / Wasatch   Speed Events                                                                                                                                                                                                    Enter "0.000" for Orange Ribbons, don't leave blank. (Leaving it blank is used for kids that don't attempt to compete.)
 | Name | # | Was a Portfolio Turned In?          (If Yes, Enter Y) |  | Portfolio Bonus Point | Correct Number of Test Questions (Don't [NAME]) | TEST Score | Total # of Bonus Questions Correct  (Don't [NAME]) | Random Test Question Tie-Breaker (Enter Y or N) | Sudden Death Tie-Breaker (Enter Y or N) | Test Place | Show- manship [NAME] | Show- manship Points | Horse- manship Ribbon | Horse- manship Points | Ranch Riding Ribbon | Ranch Riding Points | Keyhole Time | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Barrel Time | [NAME] | Barrel Points
1 | [NAME] | 4 | Y |  |  | 23 |  |  |  |  |  | R |  | B |  | R |  | 10.084 |  |  | 28.413 |  |  | 20.872
2 | [NAME] | 8 | Y |  |  | 25 |  | 1 | n |  |  | B |  | R |  | B |  | 26.413 |  |  | 27.541 |  |  | 20.565
3 | [NAME] | 12 | Y |  |  | 15 |  |  |  |  |  | R |  | B |  | B |  | 11.891 |  |  | 30.377 |  |  | 22.765
4 | Ryleigh Merrill | 16 | Y |  |  | 24 |  | 1 |  |  |  | R |  | B |  | R |  | 13.519 |  |  |  |  |  | 17.577
5 | [NAME] | 20 | Y |  |  | 20 |  |  |  |  |  | W |  | B |  | R |  | 13.46 |  |  | 36.521 |  |  | 31.32
6 | [NAME] | 24 | Y |  |  | 25 |  | 1 | y |  |  | B |  | R |  | B |  | 12.095 |  |  | 38.194 |  |  | 26.482
7 | [NAME] | 28 | Y |  |  | 19 |  |  |  |  |  | R |  | B |  | R |  | 9.767 |  |  | 25.011 |  |  | 20.266
8 | [NAME] | 32 | Y |  |  | 16 |  |  |  |  |  | W |  | R |  | R |  | 15.423 |  |  | 37.282 |  |  | 29.365
 | Event Top 5 Total Points
 | All 8 competitors Points Totals:
 | Summit/Wasatch Juniors TEAM TOTAL: |  |  |  |  |  |  | SUMMIT / WASATCH          JUNIOR TEAM
 | Summit / Wasatch Juniors RANK:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bottom 3rd [NAME] |  |  | Bottom 3rd [NAME] |  |  | Bottom 3rd [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle 3rd Max |  |  | Middle 3rd Max |  |  | Middle 3rd Max
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Runs |  |  | Total Runs |  |  | Total Runs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blue Ribbons |  |  | Blue Ribbons |  |  | Blue Ribbons
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Red Ribbons |  |  | Red Ribbons |  |  | Red Ribbons
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | White Ribbons |  |  | White Ribbons |  |  | White Ribbons
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Orange Ribbons |  |  | Orange Ribbons |  |  | Orange Ribbons
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Ribbons |  |  | Total Ribbons |  |  | Total Ribbons