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

Thanks to all for the previous help,

Also, sorry if you have addressed this already, Brian. But, I know only 
basic functions within the spreadsheet and will request a more 
explanatory example.
The file was delivered in xlsx format. I would like to maintain the 
format (using LibreOffice!), but I may have to look to other software.

Here is an example of my first two rows of data, cells F2&3 through 
S2&3, with F1-S1 containing variable names

*F*     *G*     *H*     *I*     *J*     *K*     *L*     *M*     *N*     *O*     *P*     *Q*     *R* 
    *S*
0       1       0       1       0       0       1       0       0       0       0       0       0   
    0
1       0       1       1       0       0       1       0       0       0       1       0       0   
    0


Using a simple example with only two cells (F2&L2), I want T2 to equal a 
'score' based on a weighted index, like this:

IF F2=0 then T2=0; else T2=T2+1;
(Where F2 can only take on a value of 0 or 1)
AND
IF L2=0 OR L2=1 OR L2=2 then T2=T2+0; else T2=T2+3
(Where L2 can take on a value of 0,1,2,or 3)

So that:

T2 = 0 (if F2=0 and L2=0,1,or 2)
OR
T2 = 4 (if F2=1 and L2=3)

I haven't been able to create the proper syntax for this simple two cell 
scoring.
How can I not only score an individual cell but also link it with 
another cell in the same row?
A simple demonstration will be adequate so that I can create my specific 
and more complicated function.

I hope I have stated my needs in a clearer fashion this time around, and 
thanks to everyone for the previous help.

Regards,
-Paul

On 9/19/2012 11:58 AM, Jean-Francois Nifenecker wrote:
> Le 19/09/2012 07:03, Paul Anderson a écrit :
> > 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)
>
> All this makes me think of binary data, hence to have columns F..R 
> (except I, L & S) set to hold either 0 or a power of 2.
> F would hold 0 or 1
> G            0 or 2
> H            0 or 4
> J            0 or 8
> and so forth.
>
> Then, adding any group of columns would then give a unique meaningful 
> value:
> -- if you add F+G+H and get 3, you know that only F and G are set
> -- if you AND F+G+H with, say, 2, you may check if G (value 2) is set 
> : if G AND 2 = 2 then G is set (in Calc use the BITAND function)
>
> As I don't know exactly what you're looking to achieve, perhaps my 
> idea is useless.
>
> Anyway, just my two euro-cents,





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