Spreadsheet: 90656d1290445270-excel-2007-average-returns-value-if-a-cell-is-empty-scoresheet-3
Sheet: ScoreSheet

 |  |  |  | Ranch Rodeo Score Sheet
 |  |  |  | © 2010 Dixon Stables
 |  |  |  | Duplication Prohibited
 |  |  |  | Data Entry |  |  | Only enter under the "Time" category
 |  |  |  | Sorting |  |  |  |  |  | Branding |  |  |  | Milking |  |  |  | Loading |  |  |  | Mugging |  |  |  | Total Final Score
 |  |  |  | Team | Cows | Time | Rank |  |  | Team | Time | Rank |  | Team | Time | Rank |  | Team | Time | Rank |  | Team | Time | Rank |  | Team | Total Score | Rank
 |  |  |  | 1 | 8 | 02:00:00 | 2 | 18.5 |  | 1 | 00:10:00 | 1 | 19 | 1 | 00:10:00 | 1 | 19 | 1 | 02:00:00 | 14 | 4.5 | 1 | 02:00:00 | 14 | 4.5 | 1 | 61 | 2 |  | 65.5
 |  |  |  | 2 | 6 | 02:00:00 | 5 | 15.5 |  | 2 | 00:45:00 | 6 | 15 | 2 | 00:45:00 | 6 | 15 | 2 | 01:50:00 | 12 | 8.5 | 2 | 01:50:00 | 12 | 8.5 | 2 | 54 | 4 |  | 62.5
 |  |  |  | 3 | 3 | 00:50:00 | 12 | 7.5 |  | 3 | 01:00:00 | 8 | 13 | 3 | 01:00:00 | 8 | 13 | 3 | 01:50:00 | 12 | 8.5 | 3 | 01:50:00 | 12 | 9 | 3 | 42 | 8 |  | 51
 |  |  |  | 4 | 4 | 01:23:00 | 8 | 11.5 |  | 4 | 00:20:00 | 4 | 16.5 | 4 | 00:20:00 | 4 | 16.5 | 4 | 02:00:00 | 14 | 4.5 | 4 | 02:00:00 | 14 | 5 | 4 | 49 | 5 |  | 54
 |  |  |  | 5 | 4 | 01:30:00 | 8 | 11.5 |  | 5 | 00:20:00 | 4 | 16.5 | 5 | 00:20:00 | 4 | 16.5 | 5 | 02:00:00 | 14 | 4.5 | 5 | 02:00:00 | 14 | 5.5 | 5 | 49 | 5 |  | 54.5
 |  |  |  | 6 | 3 | 01:24:00 | 12 | 7.5 |  | 6 | 01:38:00 | 12 | 9 | 6 | 01:38:00 | 12 | 9 | 6 | 02:00:00 | 14 | 4.5 | 6 | 02:00:00 | 14 | 6 | 6 | 30 | 19 |  | 36
 |  |  |  | 7 | 3 | 02:00:00 | 12 | 7.5 |  | 7 | 00:50:00 | 7 | 14 | 7 | 00:50:00 | 7 | 14 | 7 | 02:00:00 | 14 | 4.5 | 7 | 02:00:00 | 14 | 6.5 | 7 | 40 | 9 |  | 46.5
 |  |  |  | 8 | 2 | 00:45:00 | 16 | 4 |  | 8 | 01:24:00 | 10 | 11 | 8 | 01:24:00 | 10 | 11 | 8 | 01:00:00 | 7 | 13.5 | 8 | 01:00:00 | 7 | 13.5 | 8 | 39.5 | 10 |  | 53
 |  |  |  | 9 | 6 | 01:50:00 | 5 | 15.5 |  | 9 | 02:00:00 | 15 | 3.5 | 9 | 02:00:00 | 15 | 3.5 | 9 | 01:23:00 | 9 | 12 | 9 | 01:23:00 | 9 | 12 | 9 | 34.5 | 13 |  | 46.5
 |  |  |  | 10 | 5 | 02:00:00 | 7 | 14 |  | 10 | 02:00:00 | 15 | 3.5 | 10 | 02:00:00 | 15 | 3.5 | 10 | 01:30:00 | 10 | 11 | 10 | 01:30:00 | 10 | 11 | 10 | 32 | 17 |  | 43
 |  |  |  | 11 | 8 | 02:00:00 | 2 | 18.5 |  | 11 | 02:00:00 | 15 | 3.5 | 11 | 02:00:00 | 15 | 3.5 | 11 | 01:38:00 | 11 | 10 | 11 | 01:38:00 | 11 | 10 | 11 | 35.5 | 12 |  | 45.5
 |  |  |  | 12 | 4 | 01:38:00 | 8 | 11.5 |  | 12 | 02:00:00 | 15 | 3.5 | 12 | 02:00:00 | 15 | 3.5 | 12 | 00:50:00 | 6 | 15 | 12 | 00:50:00 | 6 | 15 | 12 | 33.5 | 14 |  | 48.5
 |  |  |  | 13 | 7 | 01:50:00 | 4 | 17 |  | 13 | 00:10:00 | 1 | 19 | 13 | 00:10:00 | 1 | 19 | 13 | 00:24:00 | 3 | 18 | 13 | 00:24:00 | 3 | 18 | 13 | 73 | 1 |  | 91
 |  |  |  | 14 | 2 | 00:30:00 | 16 | 4 |  | 14 | 01:23:00 | 9 | 12 | 14 | 01:23:00 | 9 | 12 | 14 | 00:10:00 | 2 | 19 | 14 | 00:10:00 | 2 | 19 | 14 | 47 | 7 |  | 66
 |  |  |  | 15 | 3 | 02:00:00 | 12 | 7.5 |  | 15 | 01:30:00 | 11 | 10 | 15 | 01:30:00 | 11 | 10 | 15 | 02:00:00 | 14 | 4.5 | 15 | 02:00:00 | 14 | 7 | 15 | 32 | 17 |  | 39
 |  |  |  | 16 | 0 | 1900-01-01 00:00:00 | 19 | 1.5 |  | 16 | 02:00:00 | 15 | 3.5 | 16 | 02:00:00 | 15 | 3.5 | 16 | 00:30:00 | 4 | 17 | 16 | 00:30:00 | 4 | 17 | 16 | 25.5 | 20 |  | 42.5
 |  |  |  | 17 | 0 | 1900-01-01 00:00:00 | 19 | 1.5 |  | 17 | 01:50:00 | 13 | 7.5 | 17 | 01:50:00 | 13 | 7.5 | 17 | 00:45:00 | 5 | 16 | 17 | 00:45:00 | 5 | 16 | 17 | 32.5 | 15 |  | 48.5
 |  |  |  | 18 | 2 | 01:00:00 | 16 | 4 |  | 18 | 01:50:00 | 13 | 7.5 | 18 | 01:50:00 | 13 | 7.5 | 18 | 01:00:00 | 7 | 13.5 | 18 | 01:00:00 | 7 | 14 | 18 | 32.5 | 15 |  | 46.5
 |  |  |  | 19 | 4 | 01:00:00 | 8 | 11.5 |  | 19 | 02:00:00 | 15 | 3.5 | 19 | 02:00:00 | 15 | 3.5 | 19 | 1900-01-01 00:00:00 | 1 | 20 | 19 | 1900-01-01 00:00:00 | 1 | 20 | 19 | 38.5 | 11 |  | 58.5
 |  |  |  | 20 | 11 | 00:01:00 | 1 | 20 |  | 20 | 00:10:00 | 1 | 19 | 20 | 00:10:00 | 1 | 19 | 20 | 05:00:00 | 20 | 1 | 20 | 05:00:00 | 20 | 1 | 20 | 59 | 3 |  | 60
 |  |  |  | Event Standings |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Results
 |  |  |  | Sorting |  |  |  |  |  | Branding |  |  |  | Milking |  |  |  | Loading |  |  |  | Mugging
 |  |  |  | Team | Cows | Time | Rank | Points |  | Team | Rank | Points |  | Team | Rank | Points |  | Team | Rank | Points |  | Team | Rank | Points |  | Rank | Team | Points |  |  |  |  |  |  |  |  |  |  | Rank | Points
 |  |  |  | 20 | 11 | 00:01:00 | 1 | 20 |  | 1 | 1 | 19 |  | 1 | 1 | 19 |  | 1 | 14 | 7 |  | 1 |  | #N/A |  | 1st | 13 | 73 |  |  |  |  |  |  |  |  |  |  | 1 | 20
 |  |  |  | 1 | 8 | 02:00:00 | 2 | 18.5 |  | 13 | 1 | 19 |  | 13 | 1 | 19 |  | 19 | 1 | 20 |  | 2 |  | #N/A |  | 2nd | 1 | 61 |  |  |  |  |  |  |  |  |  |  | 2 | 19
 |  |  |  | 11 | 8 | 02:00:00 | 2 | 18.5 |  | 20 | 1 | 19 |  | 20 | 1 | 19 |  | 20 | 2 | 19 |  | 3 |  | #N/A |  | 3rd | 20 | 59 |  |  |  |  |  |  |  |  |  |  | 3 | 18
 |  |  |  | 13 | 7 | 01:50:00 | 4 | 17 |  | 4 | 4 | 16.5 |  | 4 | 4 | 16.5 |  | 13 | 3 | 18 |  | 4 |  | #N/A |  | 4th | 2 | 54 |  |  |  |  |  |  |  |  |  |  | 4 | 17
 |  |  |  | 9 | 6 | 01:50:00 | 5 | 15.5 |  | 5 | 4 | 16.5 |  | 5 | 4 | 16.5 |  | 16 | 4 | 17 |  | 5 |  | #N/A |  | 5th | 4 | 49 |  |  |  |  |  |  |  |  |  |  | 5 | 16
 |  |  |  | 2 | 6 | 02:00:00 | 5 | 15.5 |  | 2 | 6 | 15 |  | 2 | 6 | 15 |  | 17 | 5 | 16 |  | 6 |  | #N/A |  | 6th | 5 | 49 |  |  |  |  |  |  |  |  |  |  | 6 | 15
 |  |  |  | 10 | 5 | 02:00:00 | 7 | 14 |  | 7 | 7 | 14 |  | 7 | 7 | 14 |  | 12 | 6 | 15 |  | 7 |  | #N/A |  | 7th | 14 | 47 |  |  |  |  |  |  |  |  |  |  | 7 | 14
 |  |  |  | 19 | 4 | 01:00:00 | 8 | 12 |  | 3 | 8 | 13 |  | 3 | 8 | 13 |  | 8 | 7 | 13.5 |  | 8 |  | #N/A |  | 8th | 3 | 42 |  |  |  |  |  |  |  |  |  |  | 8 | 13
 |  |  |  | 4 | 4 | 01:23:00 | 8 | 12 |  | 14 | 9 | 12 |  | 14 | 9 | 12 |  | 18 | 7 | 13.5 |  | 9 |  | #N/A |  | 9th | 7 | 40 |  |  |  |  |  |  |  |  |  |  | 9 | 12
 |  |  |  | 5 | 4 | 01:30:00 | 8 | 12 |  | 8 | 10 | 11 |  | 8 | 10 | 11 |  | 9 | 9 | 12 |  | 10 |  | #N/A |  | 10th | 8 | 39.5 |  |  |  |  |  |  |  |  |  |  | 10 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0