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

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,
--
Jean-Francois Nifenecker, Bordeaux

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