Skip to main content
T
tietjee15-Moonstone
15-Moonstone
May 18, 2018
Solved

Nested Matrix and Performance

  • May 18, 2018
  • 1 reply
  • 1136 views

I have been a long user of Mathcad, back when it was a DOS program.  Currently I am using v15 but am planning on moving to Prime 5.  On some of my project I have to load six or more spreadsheets.  The multiple spreadsheets are loaded at the same time, via nested matrix.  Each cell has a READEXCEL for each case.  The individual matrix is accessed using the indexes.  I have two questions:

 

1. Will Prime support a similar method of reading multiple spreadsheets?

2. What is the change in performance?

 

I had been holding off on making the change because I have to have 2-D plotting for data checking and presentation.

Best answer by DJF

I think you'll be ok.  I have an example where I load 8 csv files, each 70k rows long and it works very well.  However, if you ever try to paste even a few hundred rows (appears as a table) Prime does not like that and bogs down quickly.  Anyway it shouldn't take long to try - the converter isn't perfect but should get you close.  Worse case (or best case as others will argue) you just stick with 15.  2018-05-18_16-31-09.jpg

1 reply

D
DJF16-PearlAnswer
16-Pearl
May 18, 2018

I think you'll be ok.  I have an example where I load 8 csv files, each 70k rows long and it works very well.  However, if you ever try to paste even a few hundred rows (appears as a table) Prime does not like that and bogs down quickly.  Anyway it shouldn't take long to try - the converter isn't perfect but should get you close.  Worse case (or best case as others will argue) you just stick with 15.  2018-05-18_16-31-09.jpg

    Terms & ConditionsAccessibility statement