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