Skip to main content
Fred_KohlheppAnswer
23-Emerald I
January 12, 2023

If you (in the EXCEL file) select and copy only the numbers, then paste them into Mathcad, Prime will create a table with the numbers but with un-declared variable names and units.  You can then fill in the names and unit values and the table columns will work like vectors in Mathcad.  An example is attached (Prime 8).  Your example (with multiple columns with the same names would be challenging, and using the same calculations with a different set of data would be an issue.

View in thread

6 replies

Werner_E
Werner_E25-Diamond I
25-Diamond I
January 10, 2023

Maybe the attached file can be of any help

Translate
    terryhendicott21-Topaz II
    21-Topaz II
    January 11, 2023

    Hi,

    It is easy to multiply the excelread statement by the expected unit.

    Capture.JPG

    When augmenting and stacking matrices the rows of each augment and columns of each stack should match

    Capture2.JPG

    This gets the required matrix.  It is not an input table.

    Capture3.JPG

    Cheers

    Terry

    Translate
      Werner_E
      Werner_E25-Diamond I
      25-Diamond I
      January 11, 2023

      Yes, but is looks like the desired unit is mm, not m.

      And as can be seen in the sheet I posted above, you have to make a compromise - either a text header or the preferred unit showing or a table without units at all 😞

      Translate
        Fred_Kohlhepp23-Emerald IAnswer
        23-Emerald I
        January 12, 2023

        If you (in the EXCEL file) select and copy only the numbers, then paste them into Mathcad, Prime will create a table with the numbers but with un-declared variable names and units.  You can then fill in the names and unit values and the table columns will work like vectors in Mathcad.  An example is attached (Prime 8).  Your example (with multiple columns with the same names would be challenging, and using the same calculations with a different set of data would be an issue.

        Translate
          Terms & ConditionsAccessibility statement