Willkommen, Gast Benutzername: Passwort: Angemeldet bleiben:

## Re: how do I integrate this calculation? 3 Jahre 2 Tage her #80889

 TMSWhite OFFLINE LimeSurvey Team Beiträge: 759 Dank erhalten: 82 Karma: 36 Please paste the Excel equation(s) you use. Also, it's "LimeSurvey". LimeWire is an outlawed peer-to-peer file sharing software which is totally unrelated to LimeSurvey. If you depend upon LimeSurvey or the support team, please give generously to our 2012 fundraiser. Expression Manager (EM): Documentation | Sample Surveys | How Tos | Show Logic File | Upgrading to 1.92+ Excel Style for Survey Structure Import/Export Der Administrator hat öffentliche Schreibrechte deaktiviert.

## Re: how do I integrate this calculation? 3 Jahre 2 Tage her #80929

 obiwancupcoffee OFFLINE Fresh Lemon Beiträge: 10 Karma: 0 thank you for the reply TMSWhite I'm sorry for the typo CALCULATION basic elements : M = Male F = Female A = Apple O = Orange G = Grape then the answer conversions: (these can be done using some SUBSTITUTE formulas, but are even easier using a LOOKUP formula and a conversion table, because of the limited amount of options) in Question 1: A = M B = F in Question 2, 3 & 4: ABC = AOG = AAO = AAO ACB = AGO = AAG = AAO BAC = OAG = OOA = AOO BCA = OGA = OOG = OOG CAB = GAO = GGA = AGG CBA = GOA = GGO = OGG in Question 5: A = AAAA B = OOOO C = GGGG D = AAOO E = OOGG F = AAGG then lineup the answers to all questions, e.g.: (B +) ABC + BAC + CBA + E = (F +) AAO + AOO + OGG + OOGG = (F)AAOAOOOGGOOGG = (F)AAAOOOOOOGGGG = (F)OOG (A +) CBA + CAB + CAB + C = (M +) OGG + AGG + AGG + GGGG = (M)OGGAGGAGGGGGG = (M)AAOGGGGGGGGGG = (M)GGG so because of the gender digit, there are actually 2*9=18 possible outcomes (instead of the just 9 mentioned before), but the gender digit is best left out until just before finishing off that last reduction calculation cannot be done using a conversion table, because of the extreme amount of options, but it can be done using a formula like this: IF(LEN(SUBSTITUTE(X2;"A";""))<5;"AAA";IF(LEN(SUBSTITUTE(X2;"O";""))<5;"OOO";IF(LEN(SUBSTITUTE(X2;"G";""))<5;"GGG"; IF(AND((LEN(SUBSTITUTE(X2;"A";""))<(LEN(SUBSTITUTE(X2;"O";"")));(LEN(SUBSTITUTE(X2;"O";""))<(LEN(SUBSTITUTE(X2;"G";"")));"AAO"; IF(AND((LEN(SUBSTITUTE(X2;"A";""))>(LEN(SUBSTITUTE(X2;"O";"")));(LEN(SUBSTITUTE(X2;"O";""))>(LEN(SUBSTITUTE(X2;"G";"")));"OGG"; IF(AND((LEN(SUBSTITUTE(X2;"A";""))<(LEN(SUBSTITUTE(X2;"G";"")));(LEN(SUBSTITUTE(X2;"G";""))<(LEN(SUBSTITUTE(X2;"O";"")));"AAG"; IF(AND((LEN(SUBSTITUTE(X2;"A";""))>(LEN(SUBSTITUTE(X2;"G";"")));(LEN(SUBSTITUTE(X2;"G";""))>(LEN(SUBSTITUTE(X2;"O";"")));"OOG"; IF(AND((LEN(SUBSTITUTE(X2;"O";""))<(LEN(SUBSTITUTE(X2;"A";"")));(LEN(SUBSTITUTE(X2;"A";""))<(LEN(SUBSTITUTE(X2;"G";"")));"AOO"; "AGG" with X2 being the cell number of the unreduced calculation outcome and a few spaces put in for readability and than add the gender digit and do a LOOKUP formula using a conversion table to convert the reduced code back into text Der Administrator hat öffentliche Schreibrechte deaktiviert.

## Re: how do I integrate this calculation? 3 Jahre 1 Tag her #80947

 TMSWhite OFFLINE LimeSurvey Team Beiträge: 759 Dank erhalten: 82 Karma: 36 Most of the equations you show are not valid mathematical equations, so it isn't clear what you are trying to do. Similarly, although the Excel formula looks valid, it isn't clear what it is supposed to do. Please describe what you are trying to accomplish. Are you trying to control which options appear in question 6 and 7 based upon how the prior questions were answered (e.g. filtering question 6 and 7 to show a subset of the possible answers)? If you depend upon LimeSurvey or the support team, please give generously to our 2012 fundraiser. Expression Manager (EM): Documentation | Sample Surveys | How Tos | Show Logic File | Upgrading to 1.92+ Excel Style for Survey Structure Import/Export Der Administrator hat öffentliche Schreibrechte deaktiviert.

## Re: how do I integrate this calculation? 1 Jahr 7 Monate her #100718

 obiwancupcoffee OFFLINE Fresh Lemon Beiträge: 10 Karma: 0 Hi TMSWhite, Thanks again for your answer. It took me an entire year to come up with the properly working mathematical equation, but now I finally have it. I just upgraded to LimeSurvey version 2.00+ and found that I still don't know how to properly use this mathematical equation in the Expression Manager, since I'm using mostly Ranking-type questions/answers, and those can not be easily converted into a value using the assessment Mode... I did however find that I might be able to work with the "Set conditions For This Question"-option to solve my problem, if only I could add the Boolean "OR" and "NOT" operators to combine conditions in stead of just "AND"... Can you please help me to get either the Expression Manager or the Condition Setting to work in my case ? Thanks - I'm looking forward to hearing from you. ( I have the mathematical equation available as it works in Excel, if that's of any help... ) Der Administrator hat öffentliche Schreibrechte deaktiviert.

## Re: how do I integrate this calculation? 1 Jahr 7 Monate her #100736

 tpartner ONLINE LimeSurvey Team Beiträge: 4846 Dank erhalten: 989 Karma: 417 ORed conditions - manual.limesurvey.org/Setting_conditions..._the_use_of_scenario Cheers, Tony Partner Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise. LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project. Der Administrator hat öffentliche Schreibrechte deaktiviert.

## Re: how do I integrate this calculation? 1 Jahr 7 Monate her #100804

 obiwancupcoffee OFFLINE Fresh Lemon Beiträge: 10 Karma: 0 thanks for the tip TPartner using ORed conditions is going to be complex in this case, especially if I can only use "AND" and "OR" and not "NOT" and "ELSE"... especially since I have : 2 possible answers for the 1st question (gender) 6 possible answers for the 2nd question (ranking) 6 possible answers for the 3rd question (ranking) 6 possible answers for the 4th question (ranking) 6 possible answers for the 5th question (multiple choice) 6 possible answers for the 6th question (ranking) that would mean 2*6*6*6*6*6 = 15.552 individual scenario's to manually sort out... ...isn't it ? I'm afraid that's a little too complex... isn't there any way to use the Excel-formula ? Der Administrator hat öffentliche Schreibrechte deaktiviert.

## Re: how do I integrate this calculation? 1 Jahr 7 Monate her #100835

 obiwancupcoffee OFFLINE Fresh Lemon Beiträge: 10 Karma: 0 Hi TPartner and TMSWhite, I've been thinking about a solution, since I read that it would be possible to hide a 'question'... I would like to use such hidden questions to convert the entered ranking-answer to a question into a number-value that can be used as input for the Excel-equation... the conversion I would like to use in the hidden question is like this : values to be ranked (in the 2nd, 3rd, 4th & 6th question) : A, O, G 6 possible outcomes (to these 4 questions) : AOG => 2 AGO => 4 GAO => 6 OAG => 8 OGA => 10 GOA => 12 and when all initial questions (the initial 6 questions, including these 4, in this case) have been answered, another hidden question can be used to calculate the outcome of the 'circular math mean' answer (of the answer to question 2, 3, 4, 5 & 6) and the answer generated in that hidden question, combined with the answer to the 1st (gender) question, can be used create the (boolean) logic for the next 3 questions to be displayed so I'm thinking of using 'layer' of 2 automated and hidden steps (= 'questions') to do this... but I can't find the paragraph of the manual that outlines how to create these hidden conversion/calculation steps... can you point me towards the solution please ? Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.176 Sekunden