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

  • Profile Image
    Brennan Morrow
    Asked on May 09, 2019 at 08:23 PM

    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!

  • Profile Image
    Kiran
    Answered on May 10, 2019 at 01:40 AM

    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! 

  • Profile Image
    brennanmorrow
    Answered on May 10, 2019 at 10:51 AM

    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: 

    1557499796JotForm · Submissions 2018 C

    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. 



  • Profile Image
    Kiran
    Answered on May 10, 2019 at 12:33 PM

    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! 

  • Profile Image
    brennanmorrow
    Answered on May 15, 2019 at 02:34 PM

    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...




  • Profile Image
    Nik_C
    Answered on May 15, 2019 at 05:18 PM

    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!

  • Profile Image
    brennanmorrow
    Answered on May 16, 2019 at 10:23 AM

    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. 

  • Profile Image
    brennanmorrow
    Answered on May 16, 2019 at 10:27 AM

    @ 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. 


  • Profile Image
    Kiran
    Answered on May 16, 2019 at 11:58 AM

    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. 

  • Profile Image
    Kiran
    Answered on May 19, 2019 at 11:16 AM

    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!