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 <[email protected]> wrote: From: Tim Deaton <[email protected]> Subject: Re: [libreoffice-users] Help with Scoring Bi-nominal Responses To: "Paul Anderson" <[email protected]>, "[email protected]" <[email protected]> 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: [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 -- 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
