Voting: 6 candidates, 5 votes per voter. How do I count each name individually

So we will be running a vote for COTA. 

There are a few positions, one of which as 5 seats with 6 people available. 

We need to pull an individual count for each of the names. 

( each voter we have 5 votes for these 6 names) 

Thanks!

I am not sure if I understand your query correctly. Do you mean to say that you have 6 candidates for 5 seats and you want to let the users to vote for the seats out of these 6 candidates? Please provide us with more information on your requirement with an example so that we can guide you in the right direction.

We will wait for your response. Thank you! 

Thank Kiran, 

Yes 6 candidates and 5 seats. 

Yes voter should vote on the 5 seats. 

This was last years election: https://form.jotform.com/81138762984165

Here is how the data looked: 

It was easy enough last year to manually count, This year, however, we need to count each of the name choices individually as there is more people than seats, and the most votes goes to long positions ( term length is 3years, to 1 year, for the different 5 positions) 

This year though, I need each name choice to go to a separate column, for counting in google sheets. 

Could you provide us with more information on the positions and how the voting will be counted? This would help us in providing you with a possible solution.

We will wait for your response. Thank you! 

We have 3 chapter positions that have one candidate ( and write in) available. 

( That is simple enough, and I can sort that out) 

Then we have 1 general position with 6 candidates and 5 seats available. 

This mean. Those seats have different term limits, with the highest votes equalling the longest terms. 

We need results for this 1 general position with 5 seats to apply the names in individual rows, so I can then run a coutif in google sheets (or pivot table). 

This should result in having a counter in google sheets that returns: 

person #1: 97 (votes) 

Person #2: 97 (votes) 

Person #3: 47 (votes) 

etc...

I don't understand how that should work. I mean the workflow.

What should be the vote? Is that submitted through a form, like information that is submitted by the user?

If you could present some mock workflow so we can have a better understanding?

Thank you!

Here is an example form made in google sheets It should explain the workflow.

: https://docs.google.com/forms/d/e/1FAIpQLSeKpcc1OgbhlvjacwjEy_qpBeewZ_-cmtpB59VkRGC6CZJLVA/viewform?usp=sf_link

I want to limit the number of choices one can make to 5. 

I want each of the names choices by the user to be added to their own column so I can have them counted in sheets. 

@ Nik 

Yes, this is a public vote for positions on a board of directors. The vote is done by the members. 

One of the positions up for a vote, has 6 candidates and 5 open positions for that position. 

So there are 5 general board positions, and 6 candidates for those positions, meaning everyone but one person will be elected. Thats why we need a count on the names. 

Thank you for the detailed explanation. Please allow me some time to check on this and get back to you with a possible solution. 

Thank you for your patience. 

It looks like the form provided has no sufficient rights to view.

https://docs.google.com/forms/d/e/1FAIpQLSeKpcc1OgbhlvjacwjEy_qpBeewZ_-cmtpB59VkRGC6CZJLVA/viewform?usp=sf_link

Could you check that again and share the link to get back to you with a solution or workaround?

We will wait for your response. Thank you!