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.
 

You can use ExpressionScript to generate scores and tailor one of the admin notification emails.

- www.limesurvey.org/manual/Notifications_..._Notifications_Email

Thanks, Tony!

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

@Tony
Are you interested in this?
Or may I give a further explanation?

Joffm

@Joffm, please help as you see fit.

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] www.limesurvey.org/manual/ExpressionScri...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] www.limesurvey.org/manual/ExpressionScri...#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



 

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.

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] www.limesurvey.org/manual/ExpressionScript_sample_surveys/en [/url]
The first example is useful for your question.

 

Thanks, Joffm

LSS file attached. 

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

 

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

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

Hello again. Would you like me to go through and try to remove the scoring that someone added and then upload a 'clean' file?