Skip to main content
Werner_E
Werner_EAnswer
25-Diamond I
Mar 9, 2023 10:24 AM UTC

I could open the sheet you posted here and now I found the offending position.

Looking closer at the function you are looking for its zeros and plotting it sure helps!

Maybe this is of help to you:

Werner_E_0-1678357434329.png

 

View in thread

5 replies

Werner_E
Werner_E25-Diamond I
25-Diamond I
Mar 8, 2023 6:50 PM UTC

Looks like you attached the wrong file 😉

I could not open the file you sent via PM - I still use P6 and use a trick to be able to open files created with newer versions, as long as they don't use features like drop downs, etc.

When you use root as root(f(x),x,x1,x2), then f(x1) and f(x2) must have different sign. This is obviously not the case in your file.

So either change x1 and/or x2 accordingly, or use the root function with a guess value.

First define a (more or less accurate) guess value like x:=2 and then try root(f(x),x) = ...

The calculation may be sensitive wrt the guess value.

Translate
ksk_1059423212-AmethystAuthor
12-Amethyst
Mar 9, 2023 6:57 AM UTC

Nope, it should be the right one 🙂 It's the same worksheet as for my previous query, but with a new problem 🙂

ksk_10594232_0-1678344638310.png

ksk_10594232_1-1678344668224.png

Ok, thanks. I have made a try but can unfortunately not get around the problem. Since you have opened my worksheets before, I can't see why this couldn't be opened. 

 

Thanks for taking time. 

 

 

Translate
Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
Mar 9, 2023 10:24 AM UTC

I could open the sheet you posted here and now I found the offending position.

Looking closer at the function you are looking for its zeros and plotting it sure helps!

Maybe this is of help to you:

Werner_E_0-1678357434329.png

 

Translate
    MartinHanak24-Ruby III
    24-Ruby III
    Mar 9, 2023 8:43 AM UTC

    Hi,

    if I open Error - Function values.mcdx in Prime 9.0 and run Calculate from Calculation tab then your error appears immediately. From my layman's point of view, there are errors in the file that you have to fix.

    Translate
    Terms & ConditionsAccessibility statement