You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Onkel Svart <la...@gmail.com> on 2017/10/01 10:11:06 UTC
Technical question regarding Openoffice Spreadsheet
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>
Re: Technical question regarding Openoffice Spreadsheet
Posted by Onkel Svart <la...@gmail.com>.
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 <la...@gmail.com>:
>
> 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 <gu...@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 <la...@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>
>> >
>>
>
>
Re: Technical question regarding Openoffice Spreadsheet
Posted by Onkel Svart <la...@gmail.com>.
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 <gu...@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 <la...@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>
> >
>
Re: Technical question regarding Openoffice Spreadsheet
Posted by Johnny Rosenberg <gu...@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 <la...@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>
>