| A | B | C | D | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Variable | Value | Description | Expected Range | |||||||||||||||
2 | r | 15 | Categories | 15 - 25 | # projects | 15 | |||||||||||||
3 | m | 1.50% | Min % | 0.5% - 1.5% | Min % | 1.50% | |||||||||||||
4 | v | 3 | Varience | 0.5 - 8 | Variance | 3 | |||||||||||||
5 | h | 122% | Handicap | 20-100% | |||||||||||||||
6 | σ | 4 | Sigma | 3 - 7 | |||||||||||||||
7 | λ | 1.95 | Llamda | 1.7-1.98 | |||||||||||||||
8 | δ | 10 | Delta | 0.1 - 10 | |||||||||||||||
9 | |||||||||||||||||||
10 | Test Voter votes on 4 categories & is a Gold OP Holder (10 Votes) | ||||||||||||||||||
11 | Normal Distribution | Custom Distribution | |||||||||||||||||
46 | Category Ranking | ||||||||||||||||||
47 | Rank | Category | Result | Category | Result | Our Formula | As a % | Min% | Variance | ||||||||||
48 | 1 | 4 | 21.48% | 4 | 27.23% | 1.3891 | 22.49% | 22.49% | 0.1606639464 | ||||||||||
49 | 2 | 5 | 19.56% | 5 | 20.80% | 1.2128 | 19.64% | 19.64% | 0.1227363951 | ||||||||||
50 | 3 | 2 | 16.73% | 2 | 15.80% | 1.0365 | 16.78% | 16.78% | 0.0932371885 | ||||||||||
51 | 4 | 3 | 13.44% | 3 | 11.80% | 0.8601 | 13.93% | 13.93% | 0.06963782322 | ||||||||||
52 | |||||||||||||||||||
53 | Category 3 | 17 | Projects ranked | 27 | |||||||||||||||
54 | Rank | Project | Result | Project | Result | Our Formula | As a % | Min% | Variance | ||||||||||
55 | 1 | 3.07 | 21.48% | 3.07 | 32.38% | 2.4175 | 13.58% | 13.58% | 0.111127776 | ||||||||||
56 | 2 | 3.24 | 19.55% | 3.24 | 27.51% | 2.2411 | 12.59% | 12.59% | 0.0944370204 | ||||||||||
57 | 3 | 3.23 | 16.72% | 3.23 | 23.40% | 2.0648 | 11.60% | 11.60% | 0.08031407335 | ||||||||||
58 | 4 | 3.01 | 13.44% | 3.01 | 19.87% | 1.8885 | 10.61% | 10.61% | 0.06820869016 | ||||||||||
59 | 5 | 3.16 | 10.14% | 3.16 | 16.82% | 1.7121 | 9.62% | 9.62% | 0.05771735807 | ||||||||||
60 | 6 | 3.04 | 7.19% | 3.04 | 14.14% | 1.5358 | 8.63% | 8.63% | 0.04853744248 | ||||||||||
61 | 7 | 3.02 | 4.79% | 3.02 | 11.78% | 1.3595 | 7.64% | 7.64% | 0.04043751697 | ||||||||||
62 | 8 | 3.21 | 3.00% | 3.21 | 9.68% | 1.1832 | 6.65% | 6.65% | 0.03323758318 | ||||||||||
63 | 9 | 3.17 | 1.76% | 3.17 | 7.81% | 1.0068 | 5.66% | 5.66% | 0.02679553716 | ||||||||||
64 | 10 | 3.14 | 0.97% | 3.14 | 6.12% | 0.8305 | 4.67% | 4.67% | 0.02099769574 | ||||||||||
65 | 11 | 3.19 | 0.51% | 3.19 | 4.59% | 0.6542 | 3.68% | 3.68% | 0.01575202969 | ||||||||||
66 | 12 | 3.09 | 0.25% | 3.09 | 3.20% | 0.4779 | 2.68% | 2.68% | 0.01098324237 | ||||||||||
67 | 13 | 3.15 | 0.11% | 3.15 | 1.93% | 0.3015 | 1.69% | 1.69% | 0.006629132216 | ||||||||||
68 | 14 | 3.13 | 0.05% | 3.13 | 1.64% | 0.1252 | 0.70% | 1.50% | 0.005625 | ||||||||||
69 | 15 | 3.27 | 0.02% | 3.27 | 1.57% | 0.0000 | 0.00% | 1.50% | 0.0054 | ||||||||||
70 | 16 | 3.18 | 0.01% | 3.18 | 1.51% | 0.0000 | 0.00% | 1.50% | 0.005192307692 | ||||||||||
71 | 17 | 3.10 | 0.00% | 3.10 | 1.46% | 0.0000 | 0.00% | 1.50% | 0.005 | ||||||||||
72 | 18 | 3.11 | 0.00% | 3.11 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.004821428571 | ||||||||||
73 | 19 | 3.05 | 0.00% | 3.05 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.004655172414 | ||||||||||
74 | 20 | 3.06 | 0.00% | 3.06 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.0045 | ||||||||||
75 | 21 | 3.03 | 0.00% | 3.03 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.00435483871 | ||||||||||
76 | 22 | 3.22 | 0.00% | 3.22 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.00421875 | ||||||||||
77 | 23 | 3.20 | 0.00% | 3.20 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.004090909091 | ||||||||||
78 | 24 | 3.25 | 0.00% | 3.25 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.003970588235 | ||||||||||
79 | 25 | 3.08 | 0.00% | 3.08 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.003857142857 | ||||||||||
80 | 26 | 3.12 | 0.00% | 3.12 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.00375 | ||||||||||
81 | 27 | 3.26 | 0.00% | 3.26 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.003648648649 | ||||||||||
82 | |||||||||||||||||||
83 | |||||||||||||||||||
84 | |||||||||||||||||||
85 | Category 4 | 15 | Projects ranked | 19 | |||||||||||||||
86 | Rank | Project | Result | Project | Result | Our Formula | As a % | Min% | Variance | 27 | Projects | 43.06% | #DIV/0! | ||||||
87 | 1 | 4.05 | 21.48% | 4.05 | 29.79% | 1.7277 | 18.49% | 18.49% | 0.1405467097 | 2 | 27.51% | 8.27% | 8.27% | ||||||
88 | 2 | 4.15 | 19.55% | 4.15 | 23.88% | 1.5514 | 16.61% | 16.61% | 0.1126812468 | 4 | 19.87% | 20.18% | 20.18% | ||||||
89 | 3 | 4.02 | 16.72% | 4.02 | 19.12% | 1.3751 | 14.72% | 14.72% | 0.09020909932 | 6 | 14.14% | 35.21% | 35.21% | ||||||
90 | 4 | 4.03 | 13.44% | 4.03 | 15.20% | 1.1988 | 12.83% | 12.83% | 0.07170262492 | 8 | 9.68% | 56.94% | 56.94% | ||||||
91 | 5 | 4.19 | 10.14% | 4.19 | 11.91% | 1.0224 | 10.94% | 10.94% | 0.05619720043 | 10 | 6.12% | 94.70% | 94.70% | ||||||
92 | 6 | 4.01 | 7.19% | 4.01 | 9.12% | 0.8461 | 9.06% | 9.06% | 0.04301758961 | 12 | 3.20% | 184.93% | 184.93% | ||||||
93 | 7 | 4.18 | 4.79% | 4.18 | 6.71% | 0.6698 | 7.17% | 7.17% | 0.03167699425 | 14 | 1.64% | 309.69% | 309.69% | ||||||
94 | 8 | 4.04 | 3.00% | 4.04 | 4.62% | 0.4934 | 5.28% | 5.28% | 0.02181560698 | 16 | 1.51% | 205.66% | 205.66% | ||||||
95 | 9 | 4.07 | 1.76% | 4.07 | 2.79% | 0.3171 | 3.39% | 3.39% | 0.01316173652 | 18 | 0.00% | #DIV/0! | #DIV/0! | ||||||
96 | 10 | 4.06 | 0.97% | 4.06 | 1.17% | 0.1408 | 1.51% | 1.51% | 0.00550638958 | 20 | 0.00% | #DIV/0! | #DIV/0! | ||||||
97 | 11 | 4.16 | 0.51% | 4.16 | 1.10% | 0.0000 | 0.00% | 1.50% | 0.005181818182 | 22 | 0.00% | #DIV/0! | #DIV/0! | ||||||
98 | 12 | 4.12 | 0.25% | 4.12 | 1.04% | 0.0000 | 0.00% | 1.50% | 0.004913793103 | 24 | 0.00% | #DIV/0! | #DIV/0! | ||||||
99 | 13 | 4.10 | 0.11% | 4.10 | 0.99% | 0.0000 | 0.00% | 1.50% | 0.004672131148 | 26 | 0.00% | #DIV/0! | #DIV/0! | ||||||
100 | 14 | 4.09 | 0.05% | 4.09 | 0.94% | 0.0000 | 0.00% | 1.50% | 0.004453125 | 28 | #N/A | #N/A | #N/A | ||||||
101 | 15 | 4.08 | 0.02% | 4.08 | 0.90% | 0.0000 | 0.00% | 1.50% | 0.004253731343 | 30 | #N/A | #N/A | #N/A | ||||||
102 | 16 | 4.11 | 0.00% | 4.11 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.004071428571 | 32 | #N/A | #N/A | #N/A | ||||||
103 | 17 | 4.17 | 0.00% | 4.17 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.003904109589 | 34 | #N/A | #N/A | #N/A | ||||||
104 | 18 | 4.14 | 0.00% | 4.14 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.00375 | 36 | #N/A | #N/A | #N/A | ||||||
105 | 19 | 4.13 | 0.00% | 4.13 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.003607594937 | 38 | #N/A | #N/A | #N/A | ||||||
106 | |||||||||||||||||||
107 | |||||||||||||||||||
108 | Category 5 | 18 | Projects ranked | 24 | |||||||||||||||
109 | Rank | Project | Result | Project | Result | Our Formula | As a % | Min% | Variance | ||||||||||
110 | 1 | 5.05 | 21.48% | 5.05 | 31.67% | 2.1576 | 15.09% | 15.09% | 0.1207451333 | ||||||||||
111 | 2 | 5.01 | 19.55% | 5.01 | 26.43% | 1.9813 | 13.86% | 13.86% | 0.1007975952 | ||||||||||
112 | 3 | 5.16 | 16.72% | 5.16 | 22.08% | 1.8049 | 12.63% | 12.63% | 0.08417464673 | ||||||||||
113 | 4 | 5.14 | 13.44% | 5.14 | 18.39% | 1.6286 | 11.39% | 11.39% | 0.07010907496 | ||||||||||
114 | 5 | 5.02 | 10.14% | 5.02 | 15.22% | 1.4523 | 10.16% | 10.16% | 0.05805287058 | ||||||||||
115 | 6 | 5.18 | 7.19% | 5.18 | 12.48% | 1.2760 | 8.93% | 8.93% | 0.04760416012 | ||||||||||
116 | 7 | 5.11 | 4.79% | 5.11 | 10.09% | 1.0996 | 7.69% | 7.69% | 0.03846153846 | ||||||||||
117 | 8 | 5.03 | 3.00% | 5.03 | 7.97% | 0.9233 | 6.46% | 6.46% | 0.03039451936 | ||||||||||
118 | 9 | 5.13 | 1.76% | 5.13 | 6.09% | 0.7470 | 5.23% | 5.23% | 0.02322383571 | ||||||||||
119 | 10 | 5.22 | 0.97% | 5.22 | 4.41% | 0.5706 | 3.99% | 3.99% | 0.01680796086 | ||||||||||
120 | 11 | 5.15 | 0.51% | 5.15 | 2.89% | 0.3943 | 2.76% | 2.76% | 0.0110336735 | ||||||||||
121 | 12 | 5.06 | 0.25% | 5.06 | 1.52% | 0.2180 | 1.52% | 1.52% | 0.00580931827 | ||||||||||
122 | 13 | 5.04 | 0.11% | 5.04 | 1.43% | 0.0417 | 0.29% | 1.50% | 0.005454545455 | ||||||||||
123 | 14 | 5.21 | 0.05% | 5.21 | 1.37% | 0.0000 | 0.00% | 1.50% | 0.005217391304 | ||||||||||
124 | 15 | 5.23 | 0.02% | 5.23 | 1.31% | 0.0000 | 0.00% | 1.50% | 0.005 | ||||||||||
125 | 16 | 5.08 | 0.01% | 5.08 | 1.26% | 0.0000 | 0.00% | 1.50% | 0.0048 | ||||||||||
126 | 17 | 5.10 | 0.00% | 5.10 | 1.21% | 0.0000 | 0.00% | 1.50% | 0.004615384615 | ||||||||||
127 | 18 | 5.09 | 0.00% | 5.09 | 1.17% | 0.0000 | 0.00% | 1.50% | 0.004444444444 | ||||||||||
128 | 19 | 5.07 | 0.00% | 5.07 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.004285714286 | ||||||||||
129 | 20 | 5.24 | 0.00% | 5.24 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.004137931034 | ||||||||||
130 | 21 | 5.17 | 0.00% | 5.17 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.004 | ||||||||||
131 | 22 | 5.19 | 0.00% | 5.19 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.003870967742 | ||||||||||
132 | 23 | 5.20 | 0.00% | 5.20 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.00375 | ||||||||||
133 | 24 | 5.12 | 0.00% | 5.12 | 0.00% | 0.0000 | 0.00% | 1.50% | 0.003636363636 | ||||||||||
134 |