POV-Ray : Newsgroups : povray.binaries.utilities : Polynomial Spreadsheet Server Time: 17 Jan 2019 02:13:58 GMT
  Polynomial Spreadsheet (Message 1 to 10 of 12)  
Goto Latest 10 Messages Next 2 Messages >>>
From: Bald Eagle
Subject: Polynomial Spreadsheet
Date: 19 Oct 2017 19:35:01
Message: <web.59e8fd04c28e2cfdc437ac910@news.povray.org>
Version 1.0

Enter your data in the orange cells.

Seems to be functional, and tolerates sanity checks for blank cells, 0, variable
names, negative values, and orders not between 2 & 7.

I'm not home, so I haven't pasted the output into POV-Ray to test if the syntax
is properly formatted, and the values result in the expected polynomial shape.

Haven't figured out how to get the output cells to automatically resize to the
output data (yet).

Please test extensively and give feedback.
(post test renders with output string used (text object, screen.inc) in pbi)

Enjoy   :)


Post a reply to this message


Attachments:
Download 'polynomial 1.0.ods.dat' (51 KB)

From: Stephen
Subject: Re: Polynomial Spreadsheet
Date: 19 Oct 2017 21:53:21
Message: <59e91ed1$1@news.povray.org>
On 19/10/2017 20:31, Bald Eagle wrote:
> Please test extensively and give feedback.

When trying to open it in Excel I get:

The file is corrupt and cannot be opened.

:-(

-- 

Regards
     Stephen


Post a reply to this message

From: Alain
Subject: Re: Polynomial Spreadsheet
Date: 19 Oct 2017 22:42:58
Message: <59e92a72@news.povray.org>
Le 17-10-19 à 17:53, Stephen a écrit :
> On 19/10/2017 20:31, Bald Eagle wrote:
>> Please test extensively and give feedback.
> 
> When trying to open it in Excel I get:
> 
> The file is corrupt and cannot be opened.
> 
> :-(
> 
No problem using Libre Office 5

Maybe Exel have problems using ODS files.


Post a reply to this message

From: Alain
Subject: Re: Polynomial Spreadsheet
Date: 19 Oct 2017 22:45:30
Message: <59e92b0a$1@news.povray.org>
Le 17-10-19 à 17:53, Stephen a écrit :
> On 19/10/2017 20:31, Bald Eagle wrote:
>> Please test extensively and give feedback.
> 
> When trying to open it in Excel I get:
> 
> The file is corrupt and cannot be opened.
> 
> :-(
> 
Excuse me, but don't work here.
It opens without error, but it endlessly refresh itself.


Post a reply to this message

From: Stephen
Subject: Re: Polynomial Spreadsheet
Date: 19 Oct 2017 23:20:45
Message: <59e9334d$1@news.povray.org>
On 19/10/2017 23:43, Alain wrote:
> Le 17-10-19 à 17:53, Stephen a écrit :
>> On 19/10/2017 20:31, Bald Eagle wrote:
>>> Please test extensively and give feedback.
>>
>> When trying to open it in Excel I get:
>>
>> The file is corrupt and cannot be opened.
>>
>> :-(
>>
> No problem using Libre Office 5
> 
> Maybe Exel have problems using ODS files.

It is new install of Office 2013 and I've not set up many preferences 
and options. So problems are most likely at my end.

-- 

Regards
     Stephen


Post a reply to this message

From: Bald Eagle
Subject: Re: Polynomial Spreadsheet
Date: 20 Oct 2017 00:05:00
Message: <web.59e93cb563d226a55cafe28e0@news.povray.org>
Converted to Excel format.
Had to change my fancy exponent code because Excel still sucks.

Should at least work, even if the equation cell isn't as pretty  ;)


Post a reply to this message


Attachments:
Download 'polynomial 1.0.xls.dat' (197 KB)

From: Thomas de Groot
Subject: Re: Polynomial Spreadsheet
Date: 20 Oct 2017 06:59:01
Message: <59e99eb5$1@news.povray.org>
On 19-10-2017 21:31, Bald Eagle wrote:
> 
> Version 1.0
> 
> 

Just for the sake of completeness: It opened without a glitch in 
OpenOffice 4.1.3

Otherwise, I shall leave this alone. I do not have a mathematical mind :-)


-- 
Thomas


Post a reply to this message

From: jr
Subject: Re: Polynomial Spreadsheet
Date: 20 Oct 2017 09:36:58
Message: <59e9c3ba$1@news.povray.org>
hi,

On 20/10/2017 07:58, Thomas de Groot wrote:
> On 19-10-2017 21:31, Bald Eagle wrote:
>> Version 1.0
> Just for the sake of completeness: It opened without a glitch in
> OpenOffice 4.1.3

also appears ok in v 4.0.0.3.

> Otherwise, I shall leave this alone. I do not have a mathematical mind :-)

ibid.


regards, jr.


Post a reply to this message

From: B  Gimeno
Subject: Re: Polynomial Spreadsheet
Date: 23 Oct 2017 13:45:00
Message: <web.59edf1a863d226a5c95fc4120@news.povray.org>
"Bald Eagle" <cre### [at] netscapenet> wrote:
> Converted to Excel format.
> Had to change my fancy exponent code because Excel still sucks.
>
> Should at least work, even if the equation cell isn't as pretty  ;)

Open without problems with libreoffice 5.3.
When it comes to getting the results to Pov-Ray, that's when the trouble starts.
Is Kevin Bacon a universal constant now? According to the documentation, the
polynomial version of the syntax lacks the "command" parameter at first so that
the program starts processing. From the "function" version I lack experience to
know why it also gets stuck in the calculation. Greetings, and thank you for
sharing.

B. Gimeno


Post a reply to this message

From: Bald Eagle
Subject: Re: Polynomial Spreadsheet
Date: 23 Oct 2017 14:15:00
Message: <web.59edf89463d226a5c437ac910@news.povray.org>
"B. Gimeno" <nomail@nomail> wrote:


> Open without problems with libreoffice 5.3.
> When it comes to getting the results to Pov-Ray, that's when the trouble starts.

Good to hear.

> Is Kevin Bacon a universal constant now?

Well, sort of.  ;)
but only for 6th-degree polynomials   :D
https://www.youtube.com/watch?v=n9u-TITxwoM
http://www.sixdegrees.org/

>According to the documentation, the
> polynomial version of the syntax lacks the "command" parameter at first so that
> the program starts processing.

I'm not really sure what you mean by that.
it ought to be poly {
then a list of xyx (PowerX, PowerY, PowerZ):multiplier terms
}

From the "function" version I lack experience to
> know why it also gets stuck in the calculation. Greetings, and thank you for
> sharing.

It's certainly possible that there's a small typo or something in there.

I've had my hands full with a number of other things, but perhaps tomorrow I
will be able to review the spreadsheet and do some testing with scenes in
POV-Ray.


It would be easier for me debug anything or explain where your problems are if
you could post a short scene with the results of the spreadsheet that you copied
into the scene.

Thanks!


Post a reply to this message

Goto Latest 10 Messages Next 2 Messages >>>

Copyright 2003-2008 Persistence of Vision Raytracer Pty. Ltd.