Skip to main content
Best answer by ppal_255687

Will this work?

 

ppal_0-1727392955986.png

 

3 replies

S
StuartBruff23-Emerald V
23-Emerald V
September 26, 2024

Your worksheet doesn't show your problem, but I'm guessing you're trying to assign units to alpha?

 

If so, then the problem is the string header.

 

2024 09 26 C.png

 

Stuart

    C
    cadtelsim10-MarbleAuthor
    10-Marble
    September 26, 2024

    That was my initial attempt but I couldn't get the submatrix arguments right 

    To extract the numbers from matrix X, call the submatrix function. The arguments for submatrix are as follows: the name of the matrix, the indices of the first and of the last rows to extract, the indices of the first and of the last columns to extract

    a: = submatrix (name of matrix, the indices of the first and last rows to extract, indices of the first and last columns to extract)

    a = submatrix( x, row 1, to row last(of matrix X), column 0, to column 0 , column 0)

    cadtelsim_0-1727390609947.png

     

    ttokoro
    21-Topaz I
    ttokoro21-Topaz I
    21-Topaz I
    September 26, 2024

    image.pngimage.pngimage.pngimage.png

     

    Readexcel for "Sheet1!A2:C92" is more easy to get values only.

    t.t.
      P
      ppal_25568718-Opal
      18-Opal
      September 26, 2024

      Solved: How to assign units to output of an excel componen... - PTC Community

      S
      StuartBruff23-Emerald V
      23-Emerald V
      September 26, 2024

      How does that help?  From my quick read of the Excel Component Help.  You've got to read an external Excel worksheet into a Mathcad variable before you pass it to an Excel Component via the Input section, then manipulate the data within the Excel Component, adding units to the data in the Output section before it gets passed back to the Mathcad worksheet.

       

      It seems like a lot of work - and space on the Mathcad worksheet - for doing a task that can be done directly on the Excel data variable in the Mathcad workbook.

       

      Or is there some advantage that I'm not seeing? (HIghly likely, as I don't think I've ever used an Excel Component)

       

      Stuart

      C
      cadtelsim10-MarbleAuthor
      10-Marble
      September 26, 2024

      The advantage is that I don't want to see this equation in Excel. 

      cadtelsim_0-1727391011416.png

      Is that considered compelling enough?

      P
      ppal_25568718-OpalAnswer
      18-Opal
      September 26, 2024

      Will this work?

       

      ppal_0-1727392955986.png

       

        C
        cadtelsim10-MarbleAuthor
        10-Marble
        September 26, 2024

        Yes, this is what I was hoping to learn to do. Thank you very much for your help.

        Terms & ConditionsCookie settingsAccessibility statement