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

 | MUST ENABLE ITERATIVE CALCULATIONS |  | Portfolio |  |  | Test |  |  | Use only in case of ties, otherwise leave blank. |  |  | Judged Events                                             Enter "O" for Orange Ribbons when there's a DQ. |  |  |  |  |  | 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 | County | [NAME] | [NAME] | Portfolio Points | Correct Number of Test Questions (Add 0.00XXX to break ties) | 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 | Bareback Equitation on the Rail Ribbon | Bareback Equitation on the Rail Points | Keyhole Time | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Barrel Time | [NAME] | Barrel Points
5 | Destiny Zarate | S-W | 0 |  |  | 39 |  | 3 |  |  |  | R |  | R |  | R |  | 9.395 |  |  | 27.937 |  |  | 18.636
9 | [NAME] | B.E. | 1 |  |  | 40 |  | 1 |  |  |  | R |  | R |  | R |  | 0 |  |  | 30.244 |  |  | 31.16
13 | Dustee Buhl | Cache | 82 |  |  | 38 |  | 1 |  |  |  | B |  | R |  | R |  | 10.926 |  |  | 31.43 |  |  | 24.052
17 | [NAME] | [NAME] | 83 |  |  | 36 |  | 1 |  |  |  | B |  | B |  | B |  | 11.108 |  |  | 32.83 |  |  | 23.725
21 | [NAME] | Weber | 84 |  |  | 37 |  | 1 |  |  |  | W |  | R |  | B |  | 8.743 |  |  | 28.591 |  |  | 23.578
25 | [NAME] | S-W | 100 |  |  | 35 |  | 5 | y | y |  | B |  | B |  | B |  | 13.071 |  |  |  |  |  | 28.759
29 | [NAME] | B.E. | 101 |  |  | 35 |  | 5 | y | y |  | R |  | R |  | R |  | 22.715 |  |  | 47.066 |  |  | 29.354
33 | [NAME] | Cache | 102 |  |  | 35 |  | 5 | y | n |  | W |  | W |  | W |  | 24.042 |  |  | 0 |  |  | 36.723
4 | [NAME] | [NAME] | 103 |  |  | 35 |  | 5 | n | y |  | R |  | B |  | R |  | 10.083 |  |  | 28.412 |  |  | 20.871
8 | [NAME] | Weber | 104 |  |  | 35 |  | 5 | n | n |  | B |  | R |  | B |  | 26.412 |  |  | 27.54 |  |  | 20.564
12 | [NAME] | S-W | 119 |  |  | 35 |  | 4 | y |  |  | R |  | B |  | B |  | 11.89 |  |  | 30.376 |  |  | 22.764
16 | Ryleigh Merrill | B.E. | 120 |  |  | 35.0001 |  | 4 | n |  |  | R |  | B |  | R |  | 13.518 |  |  |  |  |  | 17.576
20 | [NAME] | Cache | 121 |  |  | 35 |  | 3 |  |  |  | W |  | B |  | R |  | 13.459 |  |  | 36.52 |  |  | 31.319
24 | [NAME] | [NAME] | 122 |  |  | 35 |  | 2 |  |  |  | B |  | R |  | B |  | 12.094 |  |  | 38.193 |  |  | 26.481
28 | [NAME] | Weber | 123 |  |  | 35 |  | 1 |  |  |  | R |  | B |  | R |  | 9.766 |  |  | 25.01 |  |  | 20.265
32 | [NAME] | S-W | 124 |  |  | 35 |  | 0 | y |  |  | W |  | R |  | R |  | 15.422 |  |  | 37.281 |  |  | 29.364
3 | [NAME] | B.E. | 145 |  |  | 35.001 |  | 0 | n |  |  | W |  | B |  | R |  | 18.251 |  |  | 33.016 |  |  | 25.892
7 | [NAME] | Cache | 146 |  |  | 23 |  |  |  |  |  | R |  | W |  | R |  | 15.607 |  |  | 33.812 |  |  | 27.703
11 | [NAME] | [NAME] | 147 |  |  | 22 |  | 1 | y |  |  | W |  | R |  | R |  | 12.08 |  |  | 31.272 |  |  | 22.715
15 | [NAME] | Weber | 148 |  |  | 21 |  | 1 |  |  |  | W |  | R |  | W |  | 16.58 |  |  | 44.651 |  |  | 26.993
19 | [NAME] | S-W | 149 |  |  | 0 |  | 0
23 | [NAME] | B.E. | 150 |  |  | 20 |  |  | y |  |  | W |  | W |  | W |  | 11.0189 |  |  | 34.439 |  |  | 25.204
27 | [NAME] | Cache | 151 |  |  | 19 |  |  | n |  |  | W |  | W |  | W |  | 15.028 |  |  | 41.319 |  |  | 28.84
31 | [NAME] | [NAME] | 152 |  |  | 18 |  |  |  |  |  | R |  | R |  | R |  | 10.967 |  |  | 54.057 |  |  | 21.073
2 | Brooklyn Fowers | Weber | 153 |  |  | 17 |  |  |  |  |  | R |  | B |  | B |  | 8.976 |  |  | 23.171 |  |  | 17.103
6 | Gabriella Flint | S-W | 175 |  |  | 16 |  | 1 |  |  |  | B |  | B |  | R |  | 11.03 |  |  | 25.668 |  |  | 17.851
10 | Sydney Opeikens | B.E. | 176 |  |  | 15 |  | 1 |  |  |  | W |  | R |  | R |  | 20.1 |  |  | 25.525 |  |  | 19.116
14 | [NAME] | Cache | 178 |  |  | 14 |  |  |  |  |  | R |  | B |  | W |  | 28.85 |  |  | 24.584 |  |  | 25.055
18 | Briar King | [NAME] | 179 |  |  | 13 |  | 1 |  |  |  | R |  | R |  | R |  | 10.8 |  |  | 30.596 |  |  | 20.1
22 | [NAME] | Weber | 180 |  |  | 12 |  | 1 |  |  |  | W |  | B |  | R |  | 21.196 |  |  | 0 |  |  | 17.207
26 | [NAME] | S-W | 195 |  |  | 11 |  |  |  |  |  | B |  | B |  | B |  | 12.526 |  |  | 31.442 |  |  | 23.359
34 | [NAME] | B.E. | 196 |  |  | 10 |  | 1 |  |  |  | R |  | B |  | R |  | 11.685 |  |  | 31.575 |  |  | 21.267
35 | [NAME] | Cache | 197 |  |  | 9 |  | 1 |  |  |  | W |  | R |  | R |  | 11.686 |  |  | 31.576 |  |  | 21.268
36 | [NAME] Who | [NAME] | 198 |  |  | 8 |  | 1 |  |  |  | B |  | W |  | R |  | 11.687 |  |  | 31.577 |  |  | 21.269
37 | [NAME] | Weber | 200 |  |  | 7 |  | 1 |  |  |  | R |  | B |  | W |  | 11.688 |  |  | 31.578 |  |  | 21.26
38 | [NAME] | S-W | 201 |  |  | 6 |  | 1 |  |  |  | W |  | R |  | R |  | 11.689 |  |  | 31.579 |  |  | 21.261
39 | [NAME] | B.E. | 300 |  |  | 5 |  | 1 |  |  |  | B |  | W |  | B |  | 11.68 |  |  | 31.57 |  |  | 21.262
40 | [NAME] | Cache | 174 |  |  | 4 |  | 1 |  |  |  | R |  | B |  | B |  | 11.681 |  |  | 31.571 |  |  | 21.263
41 | [NAME] | [NAME] |  |  |  | 3 |  | 1 |  |  |  | W |  | R |  | R |  | 11.682 |  |  | 31.572 |  |  | 21.264
42 | [NAME] | Weber | Y |  |  | 2 |  | 1 |  |  |  | R |  | W |  | W |  | 11.683 |  |  | 31.573 |  |  | 21.265
 | Summit-Wasatch County = |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bottom 3rd [NAME] |  |  | Bottom 3rd [NAME] |  |  | Bottom 3rd [NAME]
 | [NAME] = |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle 3rd Max |  |  | Middle 3rd Max |  |  | Middle 3rd Max
 | Cache County =
 | [NAME] = |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Runs |  |  | Total Runs |  |  | Total Runs
 | Weber County =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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