Skip to main content
bsonnier1-Visitor
1-Visitor
November 21, 2013
Solved

Large Tables - Mathcad Prime 2.0

  • November 21, 2013
  • 10 replies
  • 4592 views

Is there a way to split large tabels in MCPrime 2.0? I have a table with roughly 100+ data points for 2 variables that i need to reference from and having it all in a straight table it would take up two pages and look horrible. It would look a lot better if i could split the table into 3 sections and put it on one page.

EDIT:

To Clarify i have an imperical table that has a corection factor for a given temperature. It has 100+ data points. The temperature is calculated earlier in the document so i want the table put out the corection factor which i will use in further calculations

Best answer by Werner_E

I am not sure from your explanation what the goal of the splitting is.

Are you talking about the new table structure which was newly introduced with Prime where you can only type in the values manually or is the table you are talking of a normal matrix which is either calculated or read in (or also manually typed)?

Matrices can be resized so they do not show all the values and can be scrolled (in a very strange an cumbersome way), so the will not take up that much space.

As you write that you just want to hide the tables from view you may consider putting the table in a collapsible area and closing it.

I am absolutely unsure what you want to do with a programming if statement. I think you will have to clarify and better attach your sheet to show what you are trying to do.

EDIT: Can it be that you are looking for something like the lookup() functions to lookup a given temperature in your table and return the appropriate correction factor? You may lookup lookup() (pun intended ) in the help or online here: http://www.ptc.com/cs/help/mathcad_hc/prime2_hc/mprime_en/mprime/lookup_functions.html

10 replies

RogerYeh1-Visitor
1-Visitor
November 21, 2013

When you say "split" a table, I assume you want to do it mainly for display purposes?

To view portions of large matrices, click on the '...' portion, which then brings up the matrix navigator. You can then scroll up/down and/or left/right.

I suppose you could also use the 'submatrix' function to split up the matrix and show them side by side.

bsonnier1-VisitorAuthor
1-Visitor
November 21, 2013

I tried just hiding the table but all the answers tied to that variable show about 10 possiblities and then "...." Looks like i'm going to have to use some sort of if then statement.

Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
November 21, 2013

I am not sure from your explanation what the goal of the splitting is.

Are you talking about the new table structure which was newly introduced with Prime where you can only type in the values manually or is the table you are talking of a normal matrix which is either calculated or read in (or also manually typed)?

Matrices can be resized so they do not show all the values and can be scrolled (in a very strange an cumbersome way), so the will not take up that much space.

As you write that you just want to hide the tables from view you may consider putting the table in a collapsible area and closing it.

I am absolutely unsure what you want to do with a programming if statement. I think you will have to clarify and better attach your sheet to show what you are trying to do.

EDIT: Can it be that you are looking for something like the lookup() functions to lookup a given temperature in your table and return the appropriate correction factor? You may lookup lookup() (pun intended ) in the help or online here: http://www.ptc.com/cs/help/mathcad_hc/prime2_hc/mprime_en/mprime/lookup_functions.html

tietjee15-Moonstone
15-Moonstone
November 21, 2013

This is a common problem with large data sets. I had a data set that was hundreds of pages. I would recommend showing the first 10 or so lines and provide the complete data set in a seperate document, text file, excel spreadsheet, etc. I prefer excel, because I can label the columns. This has the added benefit of changing the data without changing the logic in your analysis. Takes some preplanning and practice.

Good luck

    Werner_E
    Werner_E25-Diamond I
    25-Diamond I
    November 21, 2013

    So if the goal is arranging the (two column, I guess) data for presentation, a small Mathcad program could be written to rearrange the data in a multi column matrix. Rudimentary labels would also be possible (text fields) but an Excel sheet sure would look prettier.

    But then as I understood Bryan he does not want to show the data but rather wants to hide it from view. But then, I may be wrong.

    bsonnier1-VisitorAuthor
    1-Visitor
    November 21, 2013

    Thank you all, i think the lookup() function is what i need. I need the lookup functionality but i would have liked to shown the table i was using for reference sake. In the document currently is an image file of the table and that was serving as a manual look up. I was hoping to add a bit of functionality so there would be one less step for the person inputting the data. Thank you all.

    P.S. By splitting the table i meant something like below:

    x y x y x y

    1 16 31

    2 17 32

    3 18 33

    4 19 34

    5 20 35

    . . .

    . . .

    . . .

    where as right now all i can get is

    x y

    1

    2

    3

    4

    5

    6

    7

    .

    .

    .

    as you can see the first table would present much better especially if as a single column it would go for several pages.

    Werner_E
    Werner_E25-Diamond I
    25-Diamond I
    November 21, 2013

    So you might find the attached splitTable routine useful.

    Furthermore, depending on your application and the data you have, a interpolating function might be useful instead of using lookup().

    Terms & ConditionsAccessibility statement