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
I now want to do some calculations, get all the differntial pressures for example :
I know i can do like this:
but it would be much nicer to display the result as a table with proper colum headers and units, how can i achieve this?
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.
@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.
The same with expanded in-/output areas. The index used is the matrix index which you get by typing an opening square bracket [
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.
You can indeed do some very fancy formatting in an Excel component as an output table, with a little creativity using Excel's cell shading and border drawing tool. I do this all the time in my engineering reports to provide nicely formatted tables.
