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

Hi :)  
Don't self referencing equations usually tend towards chaos and have fractal dimensions?  It's a 
bit beyond the scope of a spreadsheet!  Is there a way of limiting the number of iterations or does 
Calc just protect it self (and the cpu) from calculations running away towards chaos?  
Regards from
Tom :)  


--- On Fri, 21/9/12, Tim Deaton <tim@timdeaton.org> wrote:

From: Tim Deaton <tim@timdeaton.org>
Subject: Re: [libreoffice-users] Help with Scoring Bi-nominal Responses
To: "Paul Anderson" <pandersonh@gmail.com>, "users@global.libreoffice.org" 
<users@global.libreoffice.org>
Date: Friday, 21 September, 2012, 21:26

As others have stated, "T2=T2+..." will fail, because it references its own result.

For this example, you might put this in T2:
=IF(OR(F2=0,L2<3),0,F2+L2)
Translation:
  1. If F2=0, then T2=0
  2. If L2 is less than 3, then T2=0
  3. If F2 is greater than 0 and L2 is greater than 2, then T2=(F2+L2)

But (also as others have said) you do need to plot out all the scenarios and what their answers 
should be.  What my suggestion above assumes is:
  If F=0 then T=0 regardless of what L is
  If L<3 then T=0 regardless of what F is
  If F>0 and L>2, then T=F+L

-- Tim
===========================

On 9/21/2012 1:34 AM, Paul Anderson wrote:
> 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


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