Skip to main content
Fred_KohlheppAnswer
23-Emerald I
Jan 12, 2023 1:43 PM UTC

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
Jan 10, 2023 6:15 PM UTC

Maybe the attached file can be of any help

Translate
    terryhendicott
    terryhendicott21-Topaz II
    21-Topaz II
    Jan 11, 2023 3:39 AM UTC

    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
      Jan 11, 2023 4:01 AM UTC

      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
        Jan 12, 2023 1:43 PM UTC

        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