Spreadsheet: 36222d1234035363-creating-a-scoresheet-scoresheet-test2
Sheet: Race4

60 |  |  |  | Replace With Race Name |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 2 | 4
 |  | Ipoints |  |  |  |  | AC | MM | NM | SM | IS | Tplace | Tpoint | Tie | AC | MM | NM | SM | IS
Place | ID# | 1 | Time | Name | School | Bib | 0 | 0 | 0 | 0 | 0 |  | 60 | 0 | 229 | 201 | 204 | 174 | 0
1 | 1456 | 60 | 0.008609259259259275 | [NAME] | AC | 37 | 1 | 0 | 0 | 0 | 0 | 1 | 60 | 1 | 60 | 0 | 0 | 0 | 0
2 | 1428 | 59 | 0.008634606481481497 | [NAME] | MM | 85 | 0 | 1 | 0 | 0 | 0 | 1 | 59 | 1 | 0 | 59 | 0 | 0 | 0
3 | 1531 | 58 | 0.009082754629629652 | [NAME] | AC | 40 | 2 | 0 | 0 | 0 | 0 | 2 | 58 | 1 | 58 | 0 | 0 | 0 | 0
4 | 1422 | 57 | 0.009156134259259277 | [NAME] | NM | 552 | 0 | 0 | 1 | 0 | 0 | 1 | 57 | 1 | 0 | 0 | 57 | 0 | 0
5 | 1623 | 56 | 0.009184722222222247 | [NAME] | AC | 57 | 3 | 0 | 0 | 0 | 0 | 3 | 56 | 1 | 56 | 0 | 0 | 0 | 0
6 | 1627 | 55 | 0.009194444444444463 | [NAME] | AC | 61 | 4 | 0 | 0 | 0 | 0 | 4 | 55 | 1 | 55 | 0 | 0 | 0 | 0
7 | 1454 | 54 | 0.009479166666666677 | [NAME] | AC | 36 | 5 | 0 | 0 | 0 | 0 | 5 | 54 | 1 | 0 | 0 | 0 | 0 | 0
8 | 1462 | 53 | 0.009483796296296323 | [NAME] | AC | 39 | 6 | 0 | 0 | 0 | 0 | 6 | 53 | 1 | 0 | 0 | 0 | 0 | 0
9 | 1616 | 52 | 0.009505902777777797 | [NAME] | AC | 50 | 7 | 0 | 0 | 0 | 0 | 7 | 53 | 1 | 0 | 0 | 0 | 0 | 0
10 | 1622 | 51 | 0.009550000000000017 | [NAME] | AC | 55 | 8 | 0 | 0 | 0 | 0 | 8 | 53 | 1 | 0 | 0 | 0 | 0 | 0
11 | 1429 | 50 | 0.00989479166666668 | [NAME] | MM | 86 | 0 | 2 | 0 | 0 | 0 | 2 | 52 | 1 | 0 | 52 | 0 | 0 | 0
12 | 1635 | 49 | 0.009897916666666687 | [NAME] | MM | 87 | 0 | 3 | 0 | 0 | 0 | 3 | 51 | 1 | 0 | 51 | 0 | 0 | 0
13 | 1535 | 48 | 0.01015729166666668 | Madison Richey | AC | 44 | 9 | 0 | 0 | 0 | 0 | 9 | 51 | 1 | 0 | 0 | 0 | 0 | 0
14 | 1554 | 47 | 0.01022164351851852 | [NAME] | NM | 502 | 0 | 0 | 2 | 0 | 0 | 2 | 50 | 1 | 0 | 0 | 50 | 0 | 0
15 | 1652 | 46 | 0.01058009259259261 | [NAME] | NM | 514 | 0 | 0 | 3 | 0 | 0 | 3 | 49 | 1 | 0 | 0 | 49 | 0 | 0
16 | 1626 | 45 | 0.01061770833333335 | Eliza Mccullough | AC | 60 | 10 | 0 | 0 | 0 | 0 | 10 | 49 | 1 | 0 | 0 | 0 | 0 | 0
17 | 1560 | 44 | 0.01065497685185186 | [NAME] | NM | 508 | 0 | 0 | 4 | 0 | 0 | 4 | 48 | 1 | 0 | 0 | 48 | 0 | 0
18 | 1655 | 43 | 0.01065972222222224 | [NAME] | NM | 529 | 0 | 0 | 5 | 0 | 0 | 5 | 47 | 1 | 0 | 0 | 0 | 0 | 0
19 | 1566 | 42 | 0.01066400462962964 | Emily Pieper | NM | 511 | 0 | 0 | 6 | 0 | 0 | 6 | 46 | 1 | 0 | 0 | 0 | 0 | 0
20 | 1659 | 41 | 0.0107002314814815 | [NAME] | NM | 535 | 0 | 0 | 7 | 0 | 0 | 7 | 46 | 1 | 0 | 0 | 0 | 0 | 0
21 | 1618 | 40 | 0.01070416666666668 | [NAME] | AC | 51 | 11 | 0 | 0 | 0 | 0 | 11 | 46 | 1 | 0 | 0 | 0 | 0 | 0
22 | 1654 | 39 | 0.01072187500000002 | [NAME] | NM | 527 | 0 | 0 | 8 | 0 | 0 | 8 | 46 | 1 | 0 | 0 | 0 | 0 | 0
23 | 1461 | 38 | 0.01090312500000001 | [NAME] | AC | 38 | 12 | 0 | 0 | 0 | 0 | 12 | 46 | 1 | 0 | 0 | 0 | 0 | 0
24 | 1658 | 37 | 0.0109707175925926 | [NAME] | NM | 533 | 0 | 0 | 9 | 0 | 0 | 9 | 46 | 1 | 0 | 0 | 0 | 0 | 0
25 | 1562 | 36 | 0.01117615740740742 | [NAME] | NM | 510 | 0 | 0 | 10 | 0 | 0 | 10 | 46 | 1 | 0 | 0 | 0 | 0 | 0
26 | 1628 | 35 | 0.01118020833333336 | Annika Winans | AC | 62 | 13 | 0 | 0 | 0 | 0 | 13 | 46 | 1 | 0 | 0 | 0 | 0 | 0
27 | 1651 | 34 | 0.01136030092592594 | Riley Chador | NM | 512 | 0 | 0 | 11 | 0 | 0 | 11 | 46 | 1 | 0 | 0 | 0 | 0 | 0
28 | 1619 | 33 | 0.01161122685185187 | [NAME] | AC | 52 | 14 | 0 | 0 | 0 | 0 | 14 | 46 | 1 | 0 | 0 | 0 | 0 | 0
29 | 1665 | 32 | 0.01184270833333335 | [NAME] | NM | 550 | 0 | 0 | 12 | 0 | 0 | 12 | 46 | 1 | 0 | 0 | 0 | 0 | 0
30 | 1663 | 31 | 0.0118908564814815 | Ingrid Roske | NM | 547 | 0 | 0 | 13 | 0 | 0 | 13 | 46 | 1 | 0 | 0 | 0 | 0 | 0
31 | 1662 | 30 | 0.01190868055555558 | Abbi [NAME] | NM | 546 | 0 | 0 | 14 | 0 | 0 | 14 | 46 | 1 | 0 | 0 | 0 | 0 | 0
32 | 1656 | 29 | 0.01197118055555557 | Sage Chador | NM | 530 | 0 | 0 | 15 | 0 | 0 | 15 | 46 | 1 | 0 | 0 | 0 | 0 | 0
33 | 1615 | 28 | 0.01198344907407409 | [NAME] | AC | 49 | 15 | 0 | 0 | 0 | 0 | 15 | 46 | 1 | 0 | 0 | 0 | 0 | 0
34 | 1653 | 27 | 0.01206956018518521 | [NAME] | NM | 520 | 0 | 0 | 16 | 0 | 0 | 16 | 46 | 1 | 0 | 0 | 0 | 0 | 0
35 | 1420 | 26 | 0.01207604166666668 | [NAME] | SM | 572 | 0 | 0 | 0 | 1 | 0 | 1 | 45 | 1 | 0 | 0 | 0 | 45 | 0
36 | 1657 | 25 | 0.0121570601851852 | Isabelle Schenone | NM | 532 | 0 | 0 | 17 | 0 | 0 | 17 | 45 | 1 | 0 | 0 | 0 | 0 | 0
37 | 1674 | 24 | 0.01226122685185187 | [NAME] | SM | 582 | 0 | 0 | 0 | 2 | 0 | 2 | 44 | 1 | 0 | 0 | 0 | 44 | 0
38 | 1661 | 23 | 0.01226481481481483 | [NAME] | NM | 541 | 0 | 0 | 18 | 0 | 0 | 18 | 44 | 1 | 0 | 0 | 0 | 0 | 0
39 | 1532 | 22 | 0.0122746527777778 | Ysabel Riina | AC | 41 | 16 | 0 | 0 | 0 | 0 | 16 | 44 | 1 | 0 | 0 | 0 | 0 | 0
40 | 1681 | 21 | 0.01240266203703705 | [NAME] | SM | 591 | 0 | 0 | 0 | 3 | 0 | 3 | 43 | 1 | 0 | 0 | 0 | 43 | 0
41 | 1629 | 20 | 0.01256250000000002 | [NAME] | AC | 63 | 17 | 0 | 0 | 0 | 0 | 17 | 43 | 1 | 0 | 0 | 0 | 0 | 0
42 | 1624 | 19 | 0.01263703703703704 | [NAME] | AC | 58 | 18 | 0 | 0 | 0 | 0 | 18 | 43 | 1 | 0 | 0 | 0 | 0 | 0
43 | 1673 | 18 | 0.01269745370370372 | [NAME] | SM | 581 | 0 | 0 | 0 | 4 | 0 | 4 | 42 | 1 | 0 | 0 | 0 | 42 | 0
44 | 1672 | 17 | 0.01279212962962965 | [NAME] | SM | 580 | 0 | 0 | 0 | 5 | 0 | 5 | 41 | 1 | 0 | 0 | 0 | 0 | 0
45 | 1676 | 16 | 0.01282187500000002 | Molly Dant | SM | 584 | 0 | 0 | 0 | 6 | 0 | 6 | 40 | 1 | 0 | 0 | 0 | 0 | 0
46 | 1620 | 15 | 0.01292569444444445 | [NAME] | AC | 53 | 19 | 0 | 0 | 0 | 0 | 19 | 40 | 1 | 0 | 0 | 0 | 0 | 0
47 | 1559 | 14 | 0.01293182870370371 | [NAME] | NM | 504 | 0 | 0 | 19 | 0 | 0 | 19 | 40 | 1 | 0 | 0 | 0 | 0 | 0
48 | 1680 | 13 | 0.01299664351851855 | [NAME] | SM | 589 | 0 | 0 | 0 | 7 | 0 | 7 | 40 | 1 | 0 | 0 | 0 | 0 | 0
49 | 1637 | 12 | 0.01326134259259261 | [NAME] | MM | 89 | 0 | 4 | 0 | 0 | 0 | 4 | 39 | 1 | 0 | 39 | 0 | 0 | 0
50 | 1570 | 11 | 0.01333043981481484 | [NAME] | SM | 577 | 0 | 0 | 0 | 8 | 0 | 8 | 39 | 1 | 0 | 0 | 0 | 0 | 0
51 | 1567 | 10 | 0.01336770833333335 | [NAME] | SM | 573 | 0 | 0 | 0 | 9 | 0 | 9 | 39 | 1 | 0 | 0 | 0 | 0 | 0
52 | 1670 | 9 | 0.01337812500000002 | Lauren tang | SM | 578 | 0 | 0 | 0 | 10 | 0 | 10 | 39 | 1 | 0 | 0 | 0 | 0 | 0
53 | 1678 | 8 | 0.01346099537037038 | [NAME] | SM | 586 | 0 | 0 | 0 | 11 | 0 | 11 | 39 | 1 | 0 | 0 | 0 | 0 | 0
54 | 1671 | 7 | 0.0138027777777778 | [NAME] | SM | 579 | 0 | 0 | 0 | 12 | 0 | 12 | 39 | 1 | 0 | 0 | 0 | 0 | 0
55 | 1568 | 6 | 0.01381944444444447 | [NAME] | SM | 576 | 0 | 0 | 0 | 13 | 0 | 13 | 39 | 1 | 0 | 0 | 0 | 0 | 0
56 | 1636 | 5 | 0.01387222222222224 | [NAME] | MM | 88 | 0 | 5 | 0 | 0 | 0 | 5 | 38 | 1 | 0 | 0 | 0 | 0 | 0
57 | 1677 | 4 | 0.01522708333333335 | Jade Child | SM | 585 | 0 | 0 | 0 | 14 | 0 | 14 | 38 | 1 | 0 | 0 | 0 | 0 | 0
58 | 1679 | 3 | 0.01987581018518519 | [NAME] | SM | 588 | 0 | 0 | 0 | 15 | 0 | 15 | 38 | 1 | 0 | 0 | 0 | 0 | 0