Hi :) By f_(x) I meant f(x)! I try to figure out how to automate the calculation of these numbers:
Row 1: f(x) Row 2: Numbers that when summed will yield f(x) (Row 1) Row 3: Numbers that when summed will yield Row 2 Row 4: etc.... Many thanks for your answer! I'll try to implement that triangle tomorrow! Best regards Lars Harald Øvstetun <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free. www.avg.com <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> 2017-10-01 17:15 GMT+02:00 Johnny Rosenberg <gurus.knu...@gmail.com>: > I don't understand much of what you are trying to say here, but I'll try to > reply anyway: > > 2017-10-01 12:11 GMT+02:00 Onkel Svart <larsharaldogg...@gmail.com>: > > > Hi! I have a technical question regarding Openoffice Spreadsheet. > > > > > > Take for example f_ (x) = x. Print list. > > > > What numbers must one sum in order to get f_ (x) = x? > > > > Any numbers. Pick a number of x, and f(x) will be the same number. I'm not > sure what that ”_” is doing there, though. > > > > > > Calculate a new row as summed up will be = (to) the function over. > > Repeat. > > > > Pascal's triangle will appear in the underlying sums > > to the function f_ (x) = x. (after about 10 row extensions.) > > Ok, suddenly we are involving Pascals triangle for no obvious reason, but > sure. we can talk about that… :P > > > > > > How to solve: > > Best Strategy: > > > > Automate the sums in a spreadsheet. > > > > Suggestion: > > > > The difference of the next vertical polynomial is the previous vertical > > polynomial's function. (See hypothesis.) > > > > Hypothesis: > > The sum of the vertical functions goes to the right, and is a > (n-1)-degree > > polynomial - without a defined constant number. > > E.g. (Sigma 2 = -2x+3), (Sigma -2x+3 = x^2-4x+5)...etc. > > > > > > Thus: What operators do you think I could implement, for this task, in > > Openoffice Spreadsheet? > > > > > If you just want to do Pascal's triangle in a spreadsheet you need the + > operator, but since that's too abvious I guess you are asking for something > completely different. What is that? > > Anyway, here's one way to illustrate the triangle in Apache OpenOffice > Calc: > Enter 1 in a few cells in row 1, for instance in A1 thorough P1. > Do the same thing from A1 through A16. > In B2, enter: > =A2+B1 > Fill to the right until O2. > Highlight B2 through N2. > Fill downwards until row 15. > Clear the cells C15, D14:D15, E13:E15 and so on, until it looks like a > triangle. > Now the ”floor” of the triangle looks like this: > 1 15 105 455 1365 3003 5005 6435 6435 5005 3003 1362 455 105 15 1. > > But this is probably not what you were asking for at all, so if you could > explain a little more what you are looking for, it would be nice. > > > Kind regards > > Johnny Rosenberg > > > > > Best regards > > > > Lars Harald Øvstetun > > Statsråd Evensens veg 5 > > 6885 Årdalstangen > > > > > > > > > > <http://www.avg.com/email-signature?utm_medium=email& > > utm_source=link&utm_campaign=sig-email&utm_content=webmail> > > Virus-free. > > www.avg.com > > <http://www.avg.com/email-signature?utm_medium=email& > > utm_source=link&utm_campaign=sig-email&utm_content=webmail> > > <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > >