[libreoffice-users] Help with Scoring Bi-nominal Responses

Hello all,

I have a simple question for which I cannot find the answer.

I have a LibreCalc spreadsheet containing binomial data for which I 
would like to create a final summed "score" (in Column T) based upon a 
manually specified score index.

Columns F, G, H, J, K, M, N, O, P, O, and R contain pure binomial 
information (0 or 1)
Columns I, L, and S contain multiple numbered responses:
I = 0,1,3
L = 0,1,2,3
S = 0,1,2

I want to create a final score (Column T) based upon numerical responses 
(in Columns F-S)

Generally, scoring should happen like this for binomial answers, though 
some responses are weighted more than others:
if F*=0 then T*=T*+0; else if F*=1 then T*=T*+1;

Generally, scoring should happen like this for the columns containing 
multiple answers, though again, some responses are weighted more than 
others:
if I*=0 then T*=T*+0; if I*=3 then T*=T*+2;

I'm sure this function is straightforward, but I have not even been able 
to get the first column (F) to create a proper score for the final 
column (T).

Total scoring of columns F-S is more complicated than the examples 
provided above. However, if someone could provide the proper syntax, I 
will be able to insert the rest.

Thanks,
-Paul





--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted