Skip to main content
K
kskatun10-Marble
10-Marble
October 16, 2024
Question

Display result as a table in Mathcad Prime

  • October 16, 2024
  • 1 reply
  • 2023 views

I have an input matrix from actual test data, where I have taken out 5 test dataset(Speed and 5 pressures), showing first line below

kskatun_0-1729069983351.png


I now want to do some calculations, get all the differntial pressures for example :

kskatun_1-1729070128946.png

 

I know i can do like this:

kskatun_2-1729070158301.png

 but it would be much nicer to display the result as a table with proper colum headers and units, how can i achieve this?

kskatun_3-1729070365206.png

 

 

1 reply

W
Werner_E25-Diamond I
25-Diamond I
October 16, 2024

The so called tables in Prime are for data input only. Of course, you could manually copy the results into a newly created table, but this is sure not an acceptable option and PTC does not provide for automatic creation of a table based on existing data.

The best you can achieve is a matrix in which you insert column headers as text in the first (or first two) rows. This doesn't look quite as nice, but could perhaps be a display alternative to evaluating each variable individually.

Werner_E_0-1729077238150.png

 

    K
    kskatun10-MarbleAuthor
    10-Marble
    October 16, 2024

    Thanks for the answer, maybe it will be available in the next version of prime 😉  I kinda like the version in table 3, it makes it easier if you have different units.

    Could one solution be to use the excel component in some clever manner?

    W
    Werner_E25-Diamond I
    25-Diamond I
    October 16, 2024
    @kskatun wrote:

    Thanks for the answer, maybe it will be available in the next version of prime 😉  I kinda like the version in table 3, it makes it easier if you have different units.

    Could one solution be to use the excel component in some clever manner?

    You sure can use the Excel component to display the results. Because Excel does not support units, you would have to export the unit-less values (similar as shown before). Excel has the advantage that text can be displayed without the quotes and you can take advantage of the full power of Excels formatting capabilities.

    But using the Excel component blows up the worksheet significantly and may also slow it down. So to just display a few results it may be like using a sledgehammer to crack a nut. But of course that's your decision.

     

    Here is what it looks like when we export table3 to an Excel component  scale it and hide the input and output area.

    I haven't bothered to use Excel's formatting options, but of course you could use them to make the output much prettier.

    Werner_E_0-1729092019470.png

    The same with expanded in-/output areas. The index used is the matrix index which you get by typing an opening square  bracket [

    Werner_E_1-1729092148451.png

    Remark: The comma is used instead of the decimal point because that's the way we write numbers here and Excel is localized.

     

    You may also export the numbers only and add the text in Excel (double click the component to do so) as otherwise you are limited to the text exported from Prime.

     

     

     

    Terms & ConditionsAccessibility statement