northtwister
New Member
- Joined
- Feb 9, 2016
- Messages
- 2
There are multiple threads of Ranking based on multiple columns but still I am posting new.
Please try to help me.
<tbody>
</tbody>
As you can see the table there is availability for each circle and their number of links.
Core has weightage of 50%
Collector has weightage of 25%
Metro has weightage of 25%
Few states link Kerala & Punjab has all 3 populated.
Few state link Karnataka & Delhi dont have Metro and Core links respectively
And Kashmir & Assam just have 1 & 3 links of collector.
So based on these details I have to rank Circles. Highest number of links and Highest AVL% state to be declared as 1st.
Thanks in Advance.
Please try to help me.
Circle | Core | Core | Collector | Collector | Metro | Metro |
AVL | # of Links | AVL | # of Links | AVL | # of Links | |
Kerala | 97.85% | 12 | 97.15% | 20 | 99.42% | 47 |
Punjab | 99.89% | 3 | 96.68% | 1 | 99.82% | 73 |
Karnatak | 95.21% | 9 | 95.85% | 20 | 0 | 0 |
Delhi | 0 | 0 | 99.14% | 19 | 99.89% | 14 |
Kashmir | 0 | 0 | 99.4 | 1 | 0 | 0 |
Assam | 0 | 0 | 55.23 | 3 | 0 | 0 |
<tbody>
</tbody>
As you can see the table there is availability for each circle and their number of links.
Core has weightage of 50%
Collector has weightage of 25%
Metro has weightage of 25%
Few states link Kerala & Punjab has all 3 populated.
Few state link Karnataka & Delhi dont have Metro and Core links respectively
And Kashmir & Assam just have 1 & 3 links of collector.
So based on these details I have to rank Circles. Highest number of links and Highest AVL% state to be declared as 1st.
Thanks in Advance.