Hey guys,

I was working on a very long custom function that I will need to use in short 9 hours (in the morning after I will wake up) and got this error at the end "result is above max. positive number".

Error shows itself if for function input I use larger matrix (see workbook for details).

Could you help please?

Thank you!


Error.sm (75 КиБ) скачан 162 раз(а).

Got it working. I added eval() over pretty much all the operations of that huge function. I don't think they all required it, but it would've taken time to sort that out. Might want to double check I didn't accidentally change a line.

Good luck.


Error.sm (77 КиБ) скачан 163 раз(а).

Wrote

Got it working. I added eval() over pretty much all the operations of that huge function. I don't think they all required it, but it would've taken time to sort that out. Might want to double check I didn't accidentally change a line.

Good luck.


Error.sm (77 КиБ) скачан 163 раз(а).

Thank you very much, Ernesto. I had no clue eval() would make such a huge difference. I'm all set for tomorrow (or should I say for today).

Wrote

Thank you very much, Ernesto. I had no clue eval() would make such a huge difference. I'm all set for tomorrow (or should I say for today).

_________________________

I visited both work sheets. The first one didn't show any error message.
The Sigma is always suspicious. In one of my applications it is limited
to N = 11. In another application [Ksmooth] it did correct up to N = 24.
Same "Ksmooth", I tried on longer data set and failed. "Ksmooth" consumes
enormous amout of computing power, even Mathcad 11 pedals !
My understanding of "Result is above of max allowed positive number"
the execution stack is full, like in the older HP calculator. My next
understanding is that eval(,) computes intermediate results, thus reducing
the length of the stack. That's what my "finger meter" tells me.

Cheers, Jean