How to optimize sheet converted from MC15 to Prime

The very slow processing speed in Prime compared to that in Mathcad has often been criticized by users here in the forum. Even with more dramatic drops in performance than the one you describe (even if yours is bad enough).
It's hard to say which changes might bring the best speed gain - it's a case of trial and error, I guess.

PTC is obviously aware of the issue and there is a promise that improving speed would be a major focus in the development of the next Prime release. We will only be able to judge what this promise is worth next year...

Hi Johan,

here are my two pennies for your issue:

• Don't divide repeatedly. Create a variable once that is the inverse of INTERVALL and multiply with that instead.
• Try to use LOOKUP functions. I found them to be faster than comparisons.
• Try to split up your combined AND / OR statements into single ones checking first for one condition and the the other one. That way the second subset of variables to be checked is smaller. 

Hope this helps because Prime's speed is glacial 😉

Raiko

I'm suffering the same realization.  Recently converted approx 350 page worksheet from 15 to Prime10.  I ended up breaking it up into 10 worksheets and even then, each one is operating at "glacial" speed (I like that term-thanks Raiko!).  I have a ton of if..then statements, approx 2 or 3 on every page.  I also have many string equations although I chopped a lot of those away, which means I have to manually duplicate descriptions and manually update changes.  The subsequent worksheets have to reference back to the original and previous worksheets to carry through some of the needed information and about 20% of the time, one of these references just quite working properly.  It is abysmal what they've done and if the performance doesn't improve soon, I'll have no choice than to entertain alternatives like Smath.  Good luck and if you discover any sure-fire tips on speed improvements, let us know!

Jeff

Just wanted to reaffirm that i have been unable to improve speed by any significant amount. I tried putting in Time(t) variables at different stages of the program to see if one part or another is a specific time sink but unfortunately the "glacial" speed seems to be continuous throughout the worksheet.

The performance is unacceptable and i dont see us as a company continuing to subscribe to PTC/Mathcad unless we see significant improvements in performance in the near future.

Kind regards,

Johan