Welcome to the LimeSurvey Community Forum

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

Scoring and Reporting

  • BITCNI
  • BITCNI's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 months 3 days ago #254747 by BITCNI
Scoring and Reporting was created by BITCNI
Please help us help you and fill where relevant:
Your LimeSurvey version: LimeSurvey Cloud Version 6.4.1

Own server or LimeSurvey hosting: Hosted
Survey theme/template: Vanilla
==================
Hello.

Our Survey is about a benchmarking tool, so we ask companies many questions about their current practices, and then we use Excel to do an analysis of their answers.  We would, however, like to get this done by LimeSurvey, if possible, even if it's done by a plugin.  Where is the best place to start?

Essentially, a question will have (eg) 3 answers, and each answer gets a score AND a comment.

For example:

Do you have this system in place?
Answer 1: Yes
Answer 2: Not yet, but we are in the process of implementing it
Answer 3: No

What we'd like is a report that scores and inserts a comment based on each Question.

Do you have this system in place?
Answer 1: Yes
Score: 10 points
Comment: Well done

Answer 2: Not yet, but we are in the process of implementing it
Score: 5 points
Comment: Well done on starting to implement this system.

Answer 3: No
Score: 0 points
Comment: Consider implementing this system, as it is vital for reporting.

Can anyone advise whether LimeSurvey can do this and then create a detailed Report for each Participant?
It would have a total score , and the Question, the Participant's Answer, and the Comment would appear in the report for each Question.

Thanks in adavance for any guidance.

Sorry if this should have been in the Development thread.
 

Please Log in to join the conversation.

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 months 3 days ago #254749 by tpartner
Replied by tpartner on topic Scoring and Reporting
You can use ExpressionScript to generate scores and tailor one of the admin notification emails.

- manual.limesurvey.org/Notifications_%26_..._Notifications_Email

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

  • BITCNI
  • BITCNI's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 months 3 days ago #254751 by BITCNI
Replied by BITCNI on topic Scoring and Reporting
Thanks, Tony!

This looks promising. Are you a Developer? We would like to retain someone to work on this for us :)

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 months 3 days ago #254752 by Joffm
Replied by Joffm on topic Scoring and Reporting
@Tony
Are you interested in this?
Or may I give a further explanation?

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 months 2 days ago - 3 months 2 days ago #254798 by tpartner
Replied by tpartner on topic Scoring and Reporting
@Joffm, please help as you see fit.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Last edit: 3 months 2 days ago by tpartner.

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 months 2 days ago #254803 by Joffm
Replied by Joffm on topic Scoring and Reporting
Hi,
the easiest way to is to code the answer options according to the weight.
10: Yes
5: Not yet, but we are in the process of implementing it
0: No

Then it is sufficient to write something like
{Q1.question}
Your answer: {Q1.shown}
Your score: {Q1}
Comment: {if(Q1==0,'Consider implementing this system, as it is vital for reporting.',if(Q1==5,'Well done on starting to implement this system.','Well done'))}


And to show the total score you sum all single ones
{sum(Q1.NAOK,Q2.NAOK,Q3.NAOK)}
[url] manual.limesurvey.org/ExpressionScript_-...mplemented_functions [/url]
and a similar nested if to show a comment


This works as long you do not use negative weights or equal weights of several answer options.
In this case you may use assessment values.
Set the values, like
 
and calculate the scores as above.
BUT: Now you do not use the code of the answer option, but the assessment values, which you access by the property ".value" resp. ".valueNAOK"
[url] manual.limesurvey.org/ExpressionScript_-...#Access_to_variables [/url]
So it can be like
{Q1.question}
Your answer: {Q1.shown}
Your score: {Q1.value}
Comment: {if(Q1.value==0,'Consider implementing this system, as it is vital for reporting.',if(Q1.value==5,'Well done on starting to implement this system.','Well done'))}


And to show the total score
{sum(Q1.valueNAOK,Q2.valueNAOK,Q3.valueNAOK)}
and a similar nested if to show a comment

It might be better to do some calculations before in some questions of type equation and use these results in your email notification.


Further questions?

Send the lss export of your survey.

Joffm



 

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: tpartner

Please Log in to join the conversation.

  • BITCNI
  • BITCNI's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 months 2 days ago #254806 by BITCNI
Replied by BITCNI on topic Scoring and Reporting
Thanks so much for the above.

Regarding, "Then it is sufficient to write something like..."
Where does this get written?

Is this something that can be done *easily*, or do you offer a development service? Not sure if this forum allows PMs, but if you would be willing to help us with the development of this, then perhaps you could PM me? Or I can provide an email address? If you are unable to help via email, then perhaps a little bit more guidance would be very helpful.

Either way, thanks so much.

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 months 2 days ago - 3 months 2 days ago #254807 by Joffm
Replied by Joffm on topic Scoring and Reporting

Where does this get written?

Anywhere where you want to display it.
In a question text of a different question.
In a text display question.
In the end message
And - I think this is what you want to do - in the email notification.
Just try and see!

As I wrote

Further questions?

Send the lss export of your survey.


Joffm

BTW:
Import ans satudy the saample surveys provided here.
[url] manual.limesurvey.org/ExpressionScript_sample_surveys/en [/url]
The first example is useful for your question.

 

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 3 months 2 days ago by Joffm.

Please Log in to join the conversation.

  • BITCNI
  • BITCNI's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 4 weeks ago #254913 by BITCNI
Replied by BITCNI on topic Scoring and Reporting
Thanks, Joffm

LSS file attached.  :)

Greatly appreciate your help with this!  If you'd like to message me, my email is bitcni@gmail.com

 

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 months 4 weeks ago #254927 by Joffm
Replied by Joffm on topic Scoring and Reporting
Hi,
sorry, but what can I answer, if you do not do what you are told?
I wrote

the easiest way to is to code the answer options according to the weight.
10: Yes
5: Not yet, but we are in the process of implementing it
0: No

and you code

B11: No
B12: Yes,  option 1
B13: Yes, option 2
B14:Yes,  option 3


How do you want to sum this?
And instead of "You reached {S1Q1} points", you have to write
You reached {if(S1Q1=="B11",0,if(S1Q1=="B12",2,if(S1Q1=="B13",5,10)))} points

And how do you want to handle the multipunch questions?

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

  • BITCNI
  • BITCNI's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 4 weeks ago - 2 months 4 weeks ago #254928 by BITCNI
Replied by BITCNI on topic Scoring and Reporting
I'm so sorry, but I didn't actually code anything. I think that someone tried to do this last year, but I didn't realize they did it in the survey I downloaded and attached. My apologies again.

The Survey is a little complicated, as you may have noticed. There is the option to skip some questions if you are a small business.

By multipunch questions, do you mean that if they answer Yes to something and another option appears, such as "Do you have X" and they say YES, then another question asks them how many, and they have to select one of those other options?  I work in LS so infrequently that I'm unfamiliar with the terms used :(
Last edit: 2 months 4 weeks ago by BITCNI. Reason: Clarity

Please Log in to join the conversation.

  • BITCNI
  • BITCNI's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 3 weeks ago #254977 by BITCNI
Replied by BITCNI on topic Scoring and Reporting
Hello again. Would you like me to go through and try to remove the scoring that someone added and then upload a 'clean' file?

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose