Transferring calculation data into a table format

Forum|Forum|13 years ago
August 7, 2012
3 replies
10728 views

Hi Everyone,

We currently use MathCAD 14 and I am having difficulty trying to get my data results into a table (i.e. Excel) format. Currently, we perform the calculations within MathCAD and then manually enter the data into an Excel spreadsheet/table which is part of the final report we provide our customers.

I have been able to figure out how to do the following:

1) Transfer the data into a matrix format...my thinking was that I could then "easily" transpose the matrix into a tabular form.

2) Insert an Excel table (but then I still end up manually transferring the calculation results into the table).

3) I tried the Insert -> Component -> Scriptable Object feature, but again, cannot figure out how to get the data into the cells.

I feel as if I have hit a brick wall on this...I just can't seem to figure out that one final step/process to get the data to populate in a tabular form.

Can anyone help me with this issue?

Thanks,

Jenny

Statistics_Analysis

F

Fred_Kohlhepp

23-Emerald I

The short simple way (if you don't have to do tons and tons) is to format your output as a table (Format\Result\Display Options\Matrix Display style = table). Then right-click on the table. In to menu that pops up chose "select all," then "copy selection." You can then paste this entire data set into and EXCEL spreadsheet.

If you have a lot to do you can write a file and read it using EXCEL, but keeping track can be a challenge.

P

ptc-1973553

Author

1-Visitor

Fred,

Ultimately, we would rather skip the Excel spreadsheet step...in essence, we are only inputing it into an (external) Excel spreadsheet to get it into the tabular format, but the final data actually goes into an AutoCAD file. If I could create the tabular format of my calculation results within MathCAD, I can skip Excel (and possible AutoCAD) altogether.

R

RichardJ

19-Tanzanite

If you want the table in Mathcad:

Insert, Component, Microsoft Excel, Create an Empty Excel worksheet, set for one input, no outputs. Put the name of your matrix in the empty placeholder at the bottom left.

If you want to create an Excel file:

Insert, Data, File Output, type in a path and filename. Put the name of your matrix in the empty placeholder at the bottom left.

P

ptc-1973553

Author

1-Visitor

Richard,

I tried your suggestion and was delighted that the table did indeed populate...but I have no idea what numbers are being used as they are not the ones from my matrix. Any idea as to what may have gone wrong?