Weighted voting results

[PhoebeSophia]

Our office is voting on names for our conference rooms. My task is to declare the winners. People are asked to rate their top five choices from a list. Below is a sample of my data. Currently, the survey platform is telling me Siuslaw is the highest ranking choice--because it's using a weighted average, mathematically, it is. However, I think I need to find a way to take into account the number of votes each choice receives as well as where it is ranked. Anyone have any ideas? Thanks!
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]1st[/TD]
[TD]2nd[/TD]
[TD]3rd[/TD]
[TD]4th[/TD]
[TD]5th[/TD]
[/TR]
[TR]
[TD]Siuslaw[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Willamette[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Marionberry[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Filbert[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[mart37]

Are you looking for something like this?

Excel Workbook
	A	B	C	D	E	F	G	H
1	Choise	1st	2nd	3rd	4th	5th		score
2	Weight	5	4	3	2	1
3	Siuslaw	1	0	0	0	0		33%
4	Willamette	1	0	0	1	0		47%
5	Marionberry	1	0	1	0	1		60%
6	Filbert	0	2	0	0	0		53%
Sheet

 

[orchid9]

To do this computationally, you should look up the 0/1 Knapsack problem.