Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X
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).
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
Solved! Go to Solution.
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.
I have done this work manual (by students help)
Knowing my luck , I would get a 'work experience' body & spend 3X longer checking.
Tables are only for input, not output, so I don't think there's any way to programmatically create one from an array.
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.
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