Forum Discussion
Microsoft Forms: Ranking question type calculation methodology
Kimberly_Huffman i dont know the official name, but i like to think of it as points. Eg you have 5 items to rank. And 3 people do the ranking:
A, B, C, D, E
A, C, D, E, B
C, A, B, D, E
Position 1 gets 5 points, position 5 gets 1 point. So add it up
A=14 points
B = 8
C = 12
D = 7
E = 4
So the ordering in the results page should show A as the winner, C as 2nd place, etc etc
While we order by total points, the bars are colored appropriately so you can see the breakdown within that score
Hope this makes sense!
Jon_Kay Yes that seems to be the case. 
I was able to find a RCV tabulator. So for my purposes, I'm using the MS Forms Ranking question type to collect votes. When the voting is over, I will open the results in Excel, convert the ranked candidate cells to columns, save, and then use the RCV tabulator. It's going to be interesting to see if the results will be the same.
Thanks!
Kimberly_Huffman can you share the RCV tabulator you used? How did it turn out?
mrdlo Sure 🙂 I found a lot of great information and the tabulator at https://www.rcvresources.org/. We used the https://www.rcvresources.org/types-of-rcv-lib/single-winner-rcv. I downloaded and installed the https://www.rcvresources.org/rcv-universal-tabulator. It worked great. The tabulator is actually stored in https://github.com/BrightSpots/rcv/releases/ along with documentation. Good Luck!
~Kimberly
Kimberly_Huffman how did the results compare to the Forms ranking methodology?
Kendra_Perry In the screenshot, you can see how the Forms ranked compared to using the RCV Universal Tabulator. I collected the votes using Forms, opened the results in Excel, and uploaded those results to the RCV tabulator. Hope this helps.
