Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Scoring a ranking question

  • simonbs
  • simonbs's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 7 months ago #188220 by simonbs
Scoring a ranking question was created by simonbs
Hi,

I’m arranging a hackathon where people work on projects in teams. Teams can win prices in different categories.

The participants of the hackathon votes in order to determine the winners in each category. When voting, each participant picks their top 3 in a category. Point are assigned as:

Picked as #1: The team gets 5 point.
Picked as #2: The team gets 3 point.
Picked as #3: The team gets 1 point.

The team that gets the most point wins the category.

I’m thinking to have a ranking question for each category. The question should have a minimum and maximum of 3 answers.
Is there any way to assign a weight (the point) to the placements in the ranking and compute a total?
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 7 months ago #188233 by Joffm
Replied by Joffm on topic Scoring a ranking question
You can use an equation like
{scoreTeam1=sum(if(Q1_1=="T1",5,0),if(Q1_2=="T1",3,0),if(Q1_3=="T1",1,0))}
{scoreTeam2=sum(if(Q1_1=="T2",5,0),if(Q1_2=="T2",3,0),if(Q1_3=="T2",1,0))}
with Q1 as questioncode and "T1", "T2", ... answer codes, T1=Team1, T2=Team2,...

Meaning:
If T1 is on the first place of the question "Q1_1", add 5, if not, add 0
If T1 is on the secondt place of the question "Q1_2", add 3, if not, add 0
If T1 is on the third place of the question "Q1_3", add 1, if not, add 0
This you do for all teams.

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: tpartner
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 6 months ago #188240 by DenisChenu
Replied by DenisChenu on topic Scoring a ranking question
In my opinion : since you must do the total on a spreadsheet : maybe it's most easy to do whole directly in spreadsheet …

With jelo solution : you must create a Equation question for each team. Easy if you have less than 10, more complex if you have more than 50.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 6 months ago #188406 by Joffm
Replied by Joffm on topic Scoring a ranking question
You are right, Denis,

but he said "I am thinking of a raking question"
In this case I wouldn't think of more than 12-15 teams.

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • simonbs
  • simonbs's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 6 months ago #188421 by simonbs
Replied by simonbs on topic Scoring a ranking question
Thanks for your answers. I appreciate it. I'll look into using equations and if that doesn't work, I'll consider just doing it all in a spreadsheet.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose