Skip to main content
12-Amethyst
February 25, 2023
Solved

How to speed up Mathcad Prime for large data sets?

  • February 25, 2023
  • 1 reply
  • 1388 views

Does anyone know how to speed up MCP for processing large data sets?

 

I am working with a 50832x14 size data set that is output in Excel from another program. I would prefer to filter, sort, and manipulate the data in MCP vs Excel. However, trying to execute a simple filter step in MCP on a data set this large has proven impossible. I can't get the function to complete (endless spinning wheel). Whereas I can complete this one step in Excel in about 1sec.

 

Does anyone know how to speed this up? Or any other tricks for processing large data sets in MCP? I would really, really prefer to avoid Excel but at this point I have to use it.

 

Andy_C_2-1677345875120.pngAndy_C_3-1677345878840.png

Andy_C_0-1677345838487.pngAndy_C_1-1677345843528.png

Thanks!

 

Best answer by Andy_C
Hi VladimirN, thanks for responding. Werner_E provided a solution!
Mathcad Prime 8.0, Excel via Windows 10 Pro.

 

1 reply

24-Ruby III
February 26, 2023
Andy_C12-AmethystAuthorAnswer
12-Amethyst
February 26, 2023
Hi VladimirN, thanks for responding. Werner_E provided a solution!
Mathcad Prime 8.0, Excel via Windows 10 Pro.