- Posts: 10611
- Thank you received: 3690
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
assessment in muliple choice
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
8 years 3 days ago #133097
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic assessment in muliple choice
NAN means "not a number". I see no LSA file.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- mana
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 24
- Thank you received: 0
7 years 11 months ago #133936
by mana
Replied by mana on topic assessment in muliple choice
plz see my LSA file
Attachments:
The topic has been locked.
- mana
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 24
- Thank you received: 0
7 years 11 months ago #133938
by mana
Replied by mana on topic assessment in muliple choice
I search for my question , Not A Number .its appear when i write NAOK
but i use count()
plz help my about this question .
4 years ago this question is an bug , but now , i think have a way .....
but i use count()
plz help my about this question .
4 years ago this question is an bug , but now , i think have a way .....
Code:
(10 * sum(S51.value, S52.value, count(S53_1) * 9, count(S53_2) * 4, count(S53_3) * 4, count(S53_4) * 4, count(S53_5) * 5, count(S53_6) * 0, count(S53_7) * - 3, count(S54_1) * 4, count(S54_2) * 3, count(S54_3) * - 3, count(S54_4) * 1, count(S54_5) * 3, count(S54_6) * 4, count(S54_7) * 2, count(S54_8) * 3, count(S54_9) * 2, count(S54_10) * 4, count(S54_11) * 3, count(S54_12) * 4, count(S54_13) * 4, count(S54_14) * 3, count(S54_15) * 2, count(S54_16) * 2, count(S54_17) * 3, count(S54_18) * 3, count(S54_19) * 4, count(S54_20) * 3, count(S54_21) * 3, count(S54_22) * 3, count(S54_23) * 5, count(S54_24) * 5, count(S54_25) * 4, (sum((S55_1 == "0") * 0, (S55_1 == "1") * 3, (S55_1 == "2") * 5, (S55_1 == "3") * 6, (S55_1 == "4") * 6, (S55_1 == "5") * 6)), (sum((S55_2 == "0") * 0, (S55_2 == "1") * 0, (S55_2 == "2") * 2, (S55_2 == "3") * 3, (S55_2 == "4") * 4, (S55_2 == "5") * 5)), (sum((S55_3 == "0") * 0, (S55_3 == "1") * 1, (S55_3 == "2") * 4, (S55_3 == "3") * 5, (S55_3 == "4") * 5, (S55_3 == "5") * 5)), (sum((S55_4 == "0") * 0, (S55_4 == "1") * 3, (S55_4 == "2") * 5, (S55_4 == "3") * 7, (S55_4 == "4") * 7, (S55_4 == "5") * 7)), (sum((S55_5 == "0") * 0, (S55_5 == "1") * 4, (S55_5 == "2") * 8, (S55_5 == "3") * 8, (S55_5 == "4") * 8, (S55_5 == "5") * 8)), (sum((S55_6 == "0") * 0, (S55_6 == "1") * 4, (S55_6 == "2") * 7, (S55_6 == "3") * 7, (S55_6 == "4") * 7, (S55_6 == "5") * 7)), (sum((S55_7 == "0") * 0, (S55_7 == "1") * 2, (S55_7 == "2") * 5, (S55_7 == "3") * 5, (S55_7 == "4") * 5, (S55_7 == "5") * 5)), (sum((S55_8 == "0") * 0, (S55_8 == "1") * 4, (S55_8 == "2") * 7, (S55_8 == "3") * 7, (S55_8 == "4") * 7, (S55_8 == "5") * 7)), (sum((S55_9 == "0") * 0, (S55_9 == "1") * 4, (S55_9 == "2") * 8, (S55_9 == "3") * 8, (S55_9 == "4") * 8, (S55_9 == "5") * 8)), (sum((S55_10 == "0") * 0, (S55_10 == "1") * 4, (S55_10 == "2") * 9, (S55_10 == "3") * 9, (S55_10 == "4") * 9, (S55_10 == "5") * 9)), (sum((S55_11 == "0") * 0, (S55_11 == "1") * 3, (S55_11 == "2") * 5, (S55_11 == "3") * 5, (S55_11 == "4") * 5, (S55_11 == "5") * 5)), (sum((S55_12 == "0") * 0, (S55_12 == "1") * 3, (S55_12 == "2") * 5, (S55_12 == "3") * 6, (S55_12 == "4") * 6, (S55_12 == "5") * 6)), (sum((S55_13 == "0") * 0, (S55_13 == "1") * 0, (S55_13 == "2") * 1, (S55_13 == "3") * 2, (S55_13 == "4") * 3, (S55_13 == "5") * 4)), (sum((S55_13 == "0") * 0, (S55_14 == "1") * 2, (S55_14 == "2") * 3, (S55_14 == "3") * 4, (S55_14 == "4") * 4, (S55_14 == "5") * 4)), (sum((S55_15 == "0") * 0, (S55_15 == "1") * 3, (S55_15 == "2") * 5, (S55_15 == "3") * 5, (S55_15 == "4") * 5, (S55_15 == "5") * 5)), (sum((S55_16 == "0") * 0, (S55_16 == "1") * 0, (S55_16 == "2") * 0, (S55_16 == "3") * 0, (S55_16 == "4") * 0, (S55_16 == "5") * 0), count(S55a_1) * 0, count(S55a_2) * 2, count(S55a_3) * 4, count(S55a_4) * 4, count(S55a_5) * 6, count(S56_1) * 5, count(S56_2) * 0, count(S56_3) * 6, count(S56_4) * 0, count(S56_5) * 6, count(S56_7) * 10, count(S56_8) * 5, count(S56_9) * 0, count(S56_10) * 0)))
The topic has been locked.
- mana
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 24
- Thank you received: 0
7 years 11 months ago #133966
by mana
Replied by mana on topic assessment in muliple choice
i find a way for my problem and its work :woohoo:
use if for each state :
use if for each state :
Code:
sum :{(10*sum((if(S51.NAOK=="1",1,0)*1)+ (if(S51.NAOK=="2",1,0)*1)+ (if(S51.NAOK=="3",1,0)*1)+ (if(S51.NAOK=="4",1,0)*1)+ (if(S51.NAOK=="5",1,0)*3)+ (if(S51.NAOK=="6",1,0)*3)+ (if(S51.NAOK=="7",1,0)*4)+ (if(S51.NAOK=="8",1,0)*4)+ (if(S51.NAOK=="9",1,0)*5)+ (if(S51.NAOK=="10",1,0)*5)+ (if(S51.NAOK=="11",1,0)*5)+ (if(S51.NAOK=="12",1,0)*5)+ (if(S52.NAOK=="1",1,0)*2)+ (if(S52.NAOK=="2",1,0)*2)+ (if(S52.NAOK=="3",1,0)*3)+ (if(S52.NAOK=="4",1,0)*3)+ (if(S52.NAOK=="5",1,0)*4)+ (if(S52.NAOK=="6",1,0)*4)+ (if(S52.NAOK=="7",1,0)*5)+ (if(S52.NAOK=="8",1,0)*6)+ (if(S52.NAOK=="9",1,0)*7)+ (if(S52.NAOK=="10",1,0)*8)+ (if(S52.NAOK=="11",1,0)*8)+ (if(S52.NAOK=="12",1,0)*9)+(if(S53_1.NAOK=="Y",1,0)*9)+(if(S53_2.NAOK=="Y",1,0)*4)+(if(S53_3.NAOK=="Y",1,0)*4)+(if(S53_4.NAOK=="Y",1,0)*4)+(if(S53_5.NAOK=="Y",1,0)*5)+ (if(S53_6.NAOK=="Y",1,0)*0)+ (if(S53_7.NAOK=="Y",1,0)*-3)+ (if(S54_1.NAOK=="Y",1,0)*4)+ (if(S54_2.NAOK=="Y",1,0)*3)+ (if(S54_3.NAOK=="Y",1,0)*-3)+ (if(S54_4.NAOK=="Y",1,0)*1)+ (if(S54_5.NAOK=="Y",1,0)*3)+ (if(S54_6.NAOK=="Y",1,0)*4)+ (if(S54_7.NAOK=="Y",1,0)*2)+ (if(S54_8.NAOK=="Y",1,0)*3)+ (if(S54_9.NAOK=="Y",1,0)*2)+ (if(S54_10.NAOK=="Y",1,0)*4)+ (if(S54_11.NAOK=="Y",1,0)*3)+ (if(S54_12.NAOK=="Y",1,0)*4)+ (if(S54_13.NAOK=="Y",1,0)*4)+ (if(S54_14.NAOK=="Y",1,0)*3)+ (if(S54_15.NAOK=="Y",1,0)*2)+ (if(S54_16.NAOK=="Y",1,0)*2)+ (if(S54_17.NAOK=="Y",1,0)*3)+ (if(S54_18.NAOK=="Y",1,0)*3)+ (if(S54_19.NAOK=="Y",1,0)*4)+ (if(S54_20.NAOK=="Y",1,0)*3)+ (if(S54_21.NAOK=="Y",1,0)*3)+ (if(S54_22.NAOK=="Y",1,0)*3)+ (if(S54_23.NAOK=="Y",1,0)*5)+ (if(S54_24.NAOK=="Y",1,0)*5)+ (if(S54_25.NAOK=="Y",1,0)*4) + (if(S55_1=="0",1,0) * 0) + (if(S55_1=="1",1,0) * 3) + (if(S55_1=="2",1,0) * 5) + (if(S55_1=="3",1,0) * 6) + (if(S55_1=="4",1,0) * 6) + (if(S55_1=="5",1,0) * 6) + (if(S55_2=="0",1,0) * 0) + (if(S55_2=="1",1,0) * 0) + (if(S55_2=="2",1,0) * 2) + (if(S55_2=="3",1,0) * 3) + (if(S55_2=="4",1,0) * 4) + (if(S55_2=="5",1,0) * 5) + (if(S55_3=="0",1,0) * 0) + (if(S55_3=="1",1,0) * 1) + (if(S55_3=="2",1,0) * 4) + (if(S55_3=="3",1,0) * 5) + (if(S55_3=="4",1,0) * 5) + (if(S55_3=="5",1,0) * 5) + (if(S55_4=="0",1,0) * 0) + (if(S55_4=="1",1,0) * 3) + (if(S55_4=="2",1,0) * 5) + (if(S55_4=="3",1,0) * 7) + (if(S55_4=="4",1,0) * 7) + (if(S55_4=="5",1,0) * 7) + (if(S55_5=="0",1,0) * 0) + (if(S55_5=="1",1,0) * 4) + (if(S55_5=="2",1,0) * 8) + (if(S55_5=="3",1,0) * 8) + (if(S55_5=="4",1,0) * 8) + (if(S55_5=="5",1,0) * 8) + (if(S55_6=="0",1,0) * 0) + (if(S55_6=="1",1,0) * 4) + (if(S55_6=="2",1,0) * 7) + (if(S55_6=="3",1,0) * 7) + (if(S55_6=="4",1,0) * 7) + (if(S55_6=="5",1,0) * 7) + (if(S55_7=="0",1,0) * 0) + (if(S55_7=="1",1,0) * 2) + (if(S55_7=="2",1,0) * 5) + (if(S55_7=="3",1,0) * 5) + (if(S55_7=="4",1,0) * 5) + (if(S55_7=="5",1,0) * 5) + (if(S55_8=="0",1,0) * 0) + (if(S55_8=="1",1,0) * 4) + (if(S55_8=="2",1,0) * 7) + (if(S55_8=="3",1,0) * 7) + (if(S55_8=="4",1,0) * 7) + (if(S55_8=="5",1,0) * 7) + (if(S55_9=="0",1,0) * 0) + (if(S55_9=="1",1,0) * 4) + (if(S55_9=="2",1,0) * 8) + (if(S55_9=="3",1,0) * 8) + (if(S55_9=="4",1,0) * 8) + (if(S55_9=="5",1,0) * 8) + (if(S55_10=="0",1,0) * 0) + (if(S55_10=="1",1,0) * 4) + (if(S55_10=="2",1,0) * 9) + (if(S55_10=="3",1,0) * 9) + (if(S55_10=="4",1,0) * 9) + (if(S55_10=="5",1,0) *9) + (if(S55_11=="0",1,0) * 0) + (if(S55_11=="1",1,0) * 3) + (if(S55_11=="2",1,0) * 5) + (if(S55_11=="3",1,0) * 5) + (if(S55_11=="4",1,0) * 5) + (if(S55_11=="5",1,0) * 5) + (if(S55_12=="0",1,0) * 0) + (if(S55_12=="1",1,0) * 3) + (if(S55_12=="2",1,0) * 5) + (if(S55_12=="3",1,0) * 6) + (if(S55_12=="4",1,0) * 6) + (if(S55_12=="5",1,0) * 6) + (if(S55_13=="0",1,0) * 0) + (if(S55_13=="1",1,0) * 0) + (if(S55_13=="2",1,0) * 1) + (if(S55_13=="3",1,0) * 2) + (if(S55_13=="4",1,0) * 3) + (if(S55_13=="5",1,0) * 4) + (if(S55_13=="0",1,0) * 0) + (if(S55_14=="1",1,0) * 2) + (if(S55_14=="2",1,0) * 3) + (if(S55_14=="3",1,0) * 4) + (if(S55_14=="4",1,0) * 4) + (if(S55_14=="5",1,0) * 4) + (if(S55_15=="0",1,0) * 0) + (if(S55_15=="1",1,0) * 3) + (if(S55_15=="2",1,0) * 5) + (if(S55_15=="3",1,0) * 5) + (if(S55_15=="4",1,0) * 5) + (if(S55_15=="5",1,0) * 5) + (if(S55_16=="0",1,0) * 0) + (if(S55_16=="1",1,0) * 0) + (if(S55_16=="2",1,0) * 0) + (if(S55_16=="3",1,0) * 0) + (if(S55_16=="4",1,0) * 0) + (if(S55_16=="5",1,0)*0) + (if(S55a_1.NAOK=="Y",1,0)*0) + (if(S55a_2.NAOK=="Y",1,0)*2) + (if(S55a_3.NAOK=="Y",1,0)*4) + (if(S55a_4.NAOK=="Y",1,0)*4) + (if(S55a_5.NAOK=="Y",1,0)*6) + (if(S56_1.NAOK=="Y",1,0)*5) + (if(S56_2.NAOK=="Y",1,0)*0) + (if(S56_3.NAOK=="Y",1,0)*6) + (if(S56_4.NAOK=="Y",1,0)*0) + (if(S56_5.NAOK=="Y",1,0)*6) + (if(S56_6.NAOK=="Y",1,0)*15) + (if(S56_7.NAOK=="Y",1,0)*10) + (if(S56_8.NAOK=="Y",1,0)*5) + (if(S56_9.NAOK=="Y",1,0)*0) + (if(S56_10.NAOK=="Y",1,0)*0)))}
The topic has been locked.