Solved: Converting mathcad 15 array to Prime Table

AndyWesterman · ‎Dec 04, 2015

I am starting to convert calculations from MC15 to MCP (only version 2 at the moment).

One of the (many) problems that I have encountered is transferring data currently stored in an array & would like to re-format this as a table (attached is an example that I have started).

is there any way to programmatically do the transfer?
Once the table is created, how easy is it to edit?

I have tried copy & paste by row but it didn't seem to work for me. Am I missing a trick some where?

It could be a help if I want to re-order the data , Absolute nightmare is each element has to be copied separately.

Many thanks

Andy

MagnusEklund · ‎Dec 04, 2015

You can try this:

Open the Excel file. Copy the cell region. Click on an empty space in Mathcad and paste. This works in Prime 3. Hopefully also in Prime 2.

View solution in original post

ValeryOchkov · ‎Dec 04, 2015

I have done this work manual (by students help)

AndyWesterman · ‎Dec 04, 2015

Knowing my luck , I would get a 'work experience' body & spend 3X longer checking.

RichardJ · ‎Dec 04, 2015

Tables are only for input, not output, so I don't think there's any way to programmatically create one from an array.

MagnusEklund · ‎Dec 04, 2015

You can try this:

Open the Excel file. Copy the cell region. Click on an empty space in Mathcad and paste. This works in Prime 3. Hopefully also in Prime 2.

AndyWesterman · ‎Dec 07, 2015

Thanks Magnus,

I have a lot of these data tables & it will save me significant amount of time re-typing & then fixing the errors that would inevitably creep in.

Andy