Hi again! The function that yields Pascal's triangle is f(x) = 1
Sorry for that mistake, I don't have all my notates here! Best regards Lars Harald Øvstetun 2017-10-01 20:12 GMT+02:00 Onkel Svart <[email protected]>: > > 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> > <#m_4358133994041891722_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > > 2017-10-01 17:15 GMT+02:00 Johnny Rosenberg <[email protected]>: > >> 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 <[email protected]>: >> >> > 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> >> > >> > >
