| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Match Number | Red 1 | Red 2 | Red 3 | Blue 1 | Blue 2 | Blue 3 | Red Strength | Blue Strength | Relative Strgth Diff | Predicted Winner | Actual Winner | Match | |||||||
2 | 1 | 4814 | 907 | 772 | 1547 | 3117 | 4659 | 0.6386855753 | 0.788656274 | 0.23087 | BLUE | BLUE | 1 | |||||||
3 | 2 | 2185 | 1310 | 4783 | 854 | 3560 | 3705 | 0.794196402 | 0.5569407866 | 0.36525 | RED | RED | 1 | |||||||
4 | 3 | 4825 | 3683 | 2013 | 2935 | 1325 | 4039 | 0.9543058961 | 0.7920407967 | 0.2498 | RED | RED | 1 | |||||||
5 | 4 | 1305 | 3161 | 4754 | 1503 | 4817 | 4518 | 0.7021869431 | 0.518912008 | 0.28215 | RED | RED | 1 | |||||||
6 | 5 | 4595 | 4083 | 1815 | 1241 | 4069 | 4688 | 0.4771282095 | 0.7653528058 | 0.44371 | BLUE | BLUE | 1 | |||||||
7 | 6 | 3756 | 4704 | 190 | 1075 | 4732 | 3571 | 0.748452029 | 0.6432970394 | 0.16188 | RED | BLUE | 0 | |||||||
8 | 7 | 2634 | 1114 | 1334 | 771 | 4716 | 4343 | 0.9966187998 | 0.6199238838 | 0.57991 | RED | RED | 1 | |||||||
9 | 8 | 2994 | 4783 | 4814 | 2056 | 3161 | 2013 | 0.6513927624 | 1.06592878 | 0.63816 | BLUE | BLUE | 1 | |||||||
10 | 9 | 3756 | 3117 | 1075 | 4595 | 4688 | 854 | 0.8082765943 | 0.4086812657 | 0.61516 | RED | RED | 1 | |||||||
11 | 10 | 4518 | 4069 | 4716 | 907 | 1325 | 4732 | 0.6588957561 | 0.6348317135 | 0.03705 | RED | BLUE | 0 | |||||||
12 | 11 | 1503 | 3571 | 1241 | 4039 | 1310 | 2634 | 0.8548856677 | 0.8828451609 | 0.04304 | BLUE | BLUE | 1 | |||||||
13 | 12 | 4754 | 3683 | 4704 | 3560 | 2056 | 2994 | 0.6852319701 | 0.882272533 | 0.30334 | BLUE | BLUE | 1 | |||||||
14 | 13 | 4343 | 1114 | 2935 | 1547 | 4817 | 772 | 0.9902753759 | 0.5753957281 | 0.63869 | RED | RED | 1 | |||||||
15 | 14 | 4659 | 1334 | 4083 | 190 | 2185 | 4825 | 0.6259369936 | 0.745858476 | 0.18461 | BLUE | RED | 0 | |||||||
16 | 15 | 1305 | 3705 | 4704 | 771 | 1815 | 4039 | 0.7077730101 | 0.6833798436 | 0.03755 | RED | BLUE | 0 | |||||||
17 | 16 | 772 | 2994 | 4688 | 4754 | 4069 | 1310 | 0.5807967232 | 0.8745995158 | 0.4523 | BLUE | BLUE | 1 | |||||||
18 | 17 | 2056 | 3571 | 4716 | 4825 | 4814 | 854 | 0.8439554688 | 0.5759437645 | 0.41259 | RED | RED | 1 | |||||||
19 | 18 | 4083 | 4783 | 4817 | 1114 | 3117 | 1503 | 0.4723644785 | 1.121941202 | 1 | BLUE | BLUE | 1 | |||||||
20 | 19 | 4518 | 3705 | 4343 | 3683 | 1334 | 190 | 0.5896509911 | 0.8907308438 | 0.4635 | BLUE | BLUE | 1 | |||||||
21 | 20 | 907 | 2935 | 771 | 1815 | 3560 | 1075 | 0.7614155863 | 0.5804324555 | 0.27862 | RED | RED | 1 | |||||||
22 | 21 | 1547 | 1241 | 2185 | 3756 | 1325 | 4595 | 0.7749986954 | 0.6125412976 | 0.2501 | RED | RED | 1 | |||||||
23 | 22 | 4659 | 2634 | 3161 | 1305 | 4732 | 2013 | 0.6319686883 | 0.8185061856 | 0.28717 | BLUE | BLUE | 1 | |||||||
24 | 23 | 2935 | 1334 | 4783 | 4083 | 4688 | 4754 | 0.827563907 | 0.4307568469 | 0.61087 | RED | RED | 1 | |||||||
25 | 24 | 4716 | 4817 | 1815 | 3756 | 4518 | 2994 | 0.4108724345 | 0.6438570169 | 0.35867 | BLUE | BLUE | 1 | |||||||
26 | 25 | 4814 | 1503 | 1305 | 1075 | 4343 | 4825 | 0.7187736843 | 0.715692479 | 0.00474 | RED | RED | 1 | |||||||
27 | 26 | 854 | 772 | 2634 | 3161 | 1325 | 190 | 0.5425695043 | 0.7581768098 | 0.33192 | BLUE | BLUE | 1 | |||||||
28 | 27 | 907 | 2013 | 3560 | 1547 | 3571 | 3705 | 0.8486695276 | 0.7479117732 | 0.15511 | RED | RED | 1 | |||||||
29 | 28 | 4659 | 2185 | 4595 | 4069 | 1114 | 4704 | 0.5093532221 | 1.047115022 | 0.82786 | BLUE | BLUE | 1 | |||||||
30 | 29 | 3683 | 4732 | 771 | 1310 | 1241 | 3117 | 0.6956004185 | 1.045987664 | 0.53941 | BLUE | BLUE | 1 | |||||||
31 | 30 | 4039 | 3705 | 1503 | 2056 | 1547 | 3756 | 0.80226622 | 0.9319070065 | 0.19958 | BLUE | BLUE | 1 | |||||||
32 | 31 | 2994 | 1325 | 4716 | 4688 | 4659 | 3571 | 0.6265754895 | 0.5297009332 | 0.14913 | RED | RED | 1 | |||||||
33 | 32 | 3560 | 4754 | 190 | 1241 | 3161 | 4704 | 0.6555694303 | 0.8150816902 | 0.24556 | BLUE | BLUE | 1 | |||||||
34 | 33 | 854 | 907 | 1334 | 4083 | 1114 | 1305 | 0.6972346593 | 0.9045857452 | 0.31921 | BLUE | BLUE | 1 | |||||||
35 | 34 | 2634 | 1075 | 4817 | 4783 | 4069 | 3683 | 0.4957957324 | 0.8666822602 | 0.57097 | BLUE | BLUE | 1 | |||||||
36 | 35 | 2056 | 4825 | 771 | 1815 | 772 | 4518 | 0.917537382 | 0.5192527465 | 0.61314 | RED | RED | 1 | |||||||
37 | 36 | 3117 | 4343 | 4595 | 2013 | 1310 | 2935 | 0.7494898601 | 1.03548379 | 0.44028 | BLUE | BLUE | 1 | |||||||
38 | 37 | 4039 | 2185 | 854 | 4732 | 4814 | 4659 | 0.619546332 | 0.4995230379 | 0.18477 | RED | RED | 1 | |||||||
39 | 38 | 1815 | 3571 | 4783 | 4716 | 772 | 3683 | 0.6447242113 | 0.6826904192 | 0.05845 | BLUE | BLUE | 1 | |||||||
40 | 39 | 907 | 1305 | 4817 | 190 | 2056 | 4595 | 0.6082554114 | 0.8601020578 | 0.38771 | BLUE | BLUE | 1 | |||||||
41 | 40 | 1503 | 3560 | 4069 | 4732 | 3705 | 4688 | 0.8374140124 | 0.5029958841 | 0.51482 | RED | RED | 1 | |||||||
42 | 41 | 1241 | 4039 | 1075 | 1334 | 4343 | 2994 | 0.8278254395 | 0.7917913294 | 0.05547 | RED | RED | 1 | |||||||
43 | 42 | 2013 | 4083 | 1547 | 771 | 4518 | 1310 | 0.8081067481 | 0.7497388235 | 0.08986 | RED | RED | 1 | |||||||
44 | 43 | 2185 | 4814 | 3756 | 4754 | 2634 | 2935 | 0.5969738641 | 0.6435271322 | 0.07167 | BLUE | RED | 0 | |||||||
45 | 44 | 3161 | 4825 | 1114 | 1325 | 3117 | 4704 | 1.036841275 | 0.7882857442 | 0.38264 | RED | RED | 1 | |||||||
46 | 45 | 4083 | 1075 | 4716 | 4595 | 772 | 3705 | 0.5361243367 | 0.5943213351 | 0.08959 | BLUE | BLUE | 1 | |||||||
47 | 46 | 4754 | 1503 | 4659 | 4518 | 854 | 3683 | 0.5997044544 | 0.5751788855 | 0.03776 | RED | RED | 1 | |||||||
48 | 47 | 4825 | 3117 | 3560 | 190 | 2634 | 2994 | 0.8530944069 | 0.7317788894 | 0.18676 | RED | RED | 1 | |||||||
49 | 48 | 2185 | 2935 | 2056 | 3571 | 1305 | 1310 | 0.8833820672 | 0.9022634378 | 0.02907 | BLUE | BLUE | 1 | |||||||
50 | 49 | 1325 | 4688 | 4817 | 4814 | 4704 | 771 | 0.4041469745 | 0.6189760592 | 0.33072 | BLUE | BLUE | 1 | |||||||
51 | 50 | 4732 | 1241 | 1815 | 1114 | 4783 | 2013 | 0.6423380404 | 1.089567953 | 0.68849 | BLUE | BLUE | 1 | |||||||
52 | 51 | 4069 | 1547 | 907 | 4039 | 3161 | 1334 | 0.8694797853 | 0.8944963259 | 0.03851 | BLUE | BLUE | 1 | |||||||
53 | 52 | 4343 | 1325 | 772 | 3756 | 3560 | 4083 | 0.6444397716 | 0.6138750989 | 0.04705 | RED | RED | 1 | |||||||
54 | 53 | 3117 | 3705 | 2056 | 1241 | 1305 | 4659 | 0.9845716732 | 0.7358523898 | 0.38289 | RED | RED | 1 | |||||||
55 | 54 | 2994 | 4069 | 2013 | 854 | 1503 | 771 | 0.9663119392 | 0.6338019215 | 0.51189 | RED | RED | 1 | |||||||
56 | 55 | 190 | 1310 | 1114 | 4814 | 4754 | 4039 | 1.137380451 | 0.6342712218 | 0.77452 | RED | RED | 1 | |||||||
57 | 56 | 1334 | 3571 | 4825 | 4732 | 4817 | 4595 | 0.8529128337 | 0.4268903111 | 0.65585 | RED | RED | 1 | |||||||
58 | 57 | 3756 | 1815 | 2935 | 1075 | 2185 | 3161 | 0.6790410672 | 0.6711184453 | 0.0122 | RED | RED | 1 | |||||||
59 | 58 | 4704 | 4518 | 907 | 4343 | 2634 | 4783 | 0.6334804807 | 0.6580704444 | 0.03786 | BLUE | PENDING | PENDING | |||||||
60 | 59 | 4688 | 3683 | 1305 | 1547 | 4716 | 854 | 0.6792817773 | 0.573814927 | 0.16236 | RED | PENDING | PENDING | |||||||
61 | 60 | 2013 | 1325 | 3705 | 772 | 2056 | 1334 | 0.7940647847 | 0.9426500991 | 0.22874 | BLUE | PENDING | PENDING | |||||||
62 | 61 | 4814 | 4083 | 2634 | 1503 | 4704 | 1815 | 0.5251439825 | 0.6654310705 | 0.21597 | BLUE | PENDING | PENDING | |||||||
63 | 62 | 4518 | 1241 | 1114 | 4069 | 2935 | 3571 | 0.9447115979 | 0.8792096605 | 0.10084 | RED | PENDING | PENDING | |||||||
64 | 63 | 1310 | 4688 | 3756 | 4783 | 907 | 4825 | 0.7330268227 | 0.7671270399 | 0.0525 | BLUE | PENDING | PENDING | |||||||
65 | 64 | 4817 | 3117 | 4039 | 3560 | 4716 | 2185 | 0.7477870853 | 0.5735389696 | 0.26825 | RED | PENDING | PENDING | |||||||
66 | 65 | 190 | 4732 | 1547 | 1075 | 2994 | 4754 | 0.7297334762 | 0.6215475857 | 0.16655 | RED | PENDING | PENDING | |||||||
67 | 66 | 4595 | 3161 | 771 | 4343 | 4659 | 3683 | 0.6646657631 | 0.6797993348 | 0.0233 | BLUE | PENDING | PENDING | |||||||
68 | 67 | 4704 | 1310 | 3560 | 1334 | 4716 | 3756 | 0.8199967409 | 0.7266303151 | 0.14373 | RED | PENDING | PENDING | |||||||
69 | 68 | 4069 | 4825 | 1325 | 1547 | 1305 | 4783 | 0.8220700184 | 0.7738128113 | 0.07429 | RED | PENDING | PENDING | |||||||
70 | 69 | 4659 | 2994 | 3705 | 2935 | 4817 | 4814 | 0.6213012216 | 0.5362972487 | 0.13086 | RED | PENDING | PENDING | |||||||
71 | 70 | 1241 | 190 | 772 | 4688 | 1503 | 2185 | 0.8062142607 | 0.5846272228 | 0.34113 | RED | PENDING | PENDING | |||||||
72 | 71 | 4732 | 854 | 4754 | 1815 | 907 | 4343 | 0.4625210869 | 0.6366524549 | 0.26807 | BLUE | PENDING | PENDING | |||||||
73 | 72 | 3571 | 3683 | 4039 | 3117 | 3161 | 4083 | 0.8620019653 | 0.787614564 | 0.11452 | RED | PENDING | PENDING | |||||||
74 | 73 | 2634 | 2056 | 4518 | 4595 | 1114 | 1075 | 0.7654028813 | 0.8579324059 | 0.14245 | BLUE | PENDING | PENDING | |||||||
75 | 74 | 771 | 3756 | 4069 | 2013 | 4716 | 190 | 0.8029267754 | 0.8265464891 | 0.03636 | BLUE | PENDING | PENDING | |||||||
76 | 75 | 3161 | 3571 | 4343 | 4825 | 4754 | 3705 | 0.7598688386 | 0.653720572 | 0.16341 | RED | PENDING | PENDING | |||||||
77 | 76 | 3560 | 4688 | 4814 | 1305 | 4595 | 4518 | 0.499345288 | 0.5837841353 | 0.12999 | BLUE | PENDING | PENDING | |||||||
78 | 77 | 4732 | 4704 | 2056 | 772 | 2935 | 4083 | 0.8166417649 | 0.6525778029 | 0.25257 | RED | PENDING | PENDING | |||||||
79 | 78 | 1503 | 3683 | 2994 | 1114 | 2185 | 907 | 0.8326721868 | 0.9242750609 | 0.14102 | BLUE | PENDING | PENDING | |||||||
80 | 79 | 1310 | 854 | 1075 | 1241 | 2013 | 4817 | 0.7133586456 | 0.7747341871 | 0.09449 | BLUE | PENDING | PENDING | |||||||
81 | 80 | 1547 | 1325 | 1334 | 3117 | 1815 | 2634 | 0.7936967863 | 0.7124100142 | 0.12514 | RED | PENDING | PENDING | |||||||
82 | 81 | 4659 | 4039 | 772 | 771 | 4783 | 4754 | 0.6760390889 | 0.6145024106 | 0.09473 | RED | PENDING | PENDING | |||||||
83 | Highest Diff Is 1. Everything is normalized to that | Prediction Accuracy | 91.23% | |||||||||||||||||
84 | There is another sheet to the right that has the final simulated rankings. | |||||||||||||||||||
85 | ||||||||||||||||||||
86 | Calculations are based on just simple statistical magic (heuristics? probably not really "correct"). The source is not yet available. | |||||||||||||||||||
87 | Warning: These calculations are based on a "heuristic", also known as a wild-ass guess (WAG). You have been warned | |||||||||||||||||||
88 | I'm still evolving my heuristics function.. so this spreadsheet will change over the course of the night. | |||||||||||||||||||
89 | ||||||||||||||||||||
90 | ||||||||||||||||||||
91 | ||||||||||||||||||||
92 | ||||||||||||||||||||
93 | ||||||||||||||||||||
94 | ||||||||||||||||||||
95 | ||||||||||||||||||||
96 | ||||||||||||||||||||
97 | ||||||||||||||||||||
98 | ||||||||||||||||||||
99 | ||||||||||||||||||||
100 | ||||||||||||||||||||