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

On Wed, 2012-09-19 at 00:03 -0500, Paul Anderson wrote:
> 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).

The if statement is documented in the help file.  "if (logic
conditional,true action, false action)"

Regards,
LesH



-- 
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