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: [email protected]
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
