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? 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.) 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? 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> |
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 <[hidden email]>: > 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? > > 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> > |
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 <[hidden email]>: > 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 <[hidden email]>: > > > 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> > > > |
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 <[hidden email]>: > > 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 <[hidden email]>: > >> 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 <[hidden email]>: >> >> > 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> >> > >> > > |
Free forum by Nabble | Edit this page |