Hi
I am trying to build an Access database, where I can force rank a number of choices using the Schultze method.
In the attached database I have created a table with respondents, who has ranked 5 choices. The ranking data can be found in the Data table.
Schultze method: en.wikipedia.org/wiki/Schulze_method
Using the above Schultze method, I have been able to come some part of the way. Currently I am stuck with Pairwise preferences (see query "PairwisePreferences").
My challenge is that I need to also take the next steps.
I believe that I first need to use the Floyd-Warshall algoritm to find the shorts paths in a directed weighted graph (which I believe is what I have in the query PairwisePreferences".
Link to Floyd-Warshall algoritm can be found here: en.wikipedia.org/wiki/Floyd%E2%80%93Warshall_algorithm
When I have figures this out, I need some way to calculate the final result, so that I have the final Schultze ranking of the options.
Can someone possibly help me take the final steps in the attached database?
Kind regards
Søren Peter
I am trying to build an Access database, where I can force rank a number of choices using the Schultze method.
In the attached database I have created a table with respondents, who has ranked 5 choices. The ranking data can be found in the Data table.
Schultze method: en.wikipedia.org/wiki/Schulze_method
Using the above Schultze method, I have been able to come some part of the way. Currently I am stuck with Pairwise preferences (see query "PairwisePreferences").
My challenge is that I need to also take the next steps.
I believe that I first need to use the Floyd-Warshall algoritm to find the shorts paths in a directed weighted graph (which I believe is what I have in the query PairwisePreferences".
Link to Floyd-Warshall algoritm can be found here: en.wikipedia.org/wiki/Floyd%E2%80%93Warshall_algorithm
When I have figures this out, I need some way to calculate the final result, so that I have the final Schultze ranking of the options.
Can someone possibly help me take the final steps in the attached database?
Kind regards
Søren Peter