Skip to main content
A
AndyWesterman12-Amethyst
12-Amethyst
December 4, 2015
Solved

Converting mathcad 15 array to Prime Table

  • December 4, 2015
  • 3 replies
  • 2569 views

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).

  1. is there any way to programmatically do the transfer?

  2. 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

Best answer by MagnusEklund

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.

3 replies

V
ValeryOchkov24-Ruby IV
24-Ruby IV
December 4, 2015

I have done this work manual (by students help)

A
AndyWesterman12-AmethystAuthor
12-Amethyst
December 4, 2015

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

R
RichardJ19-Tanzanite
19-Tanzanite
December 4, 2015

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

M
MagnusEklund12-AmethystAnswer
12-Amethyst
December 4, 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.

    A
    AndyWesterman12-AmethystAuthor
    12-Amethyst
    December 7, 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

    Terms & ConditionsAccessibility statement