Skip to main content
M
MA_132826913-Newcomer
3-Newcomer
April 17, 2025
Solved

Exporting plot data to excel

  • April 17, 2025
  • 2 replies
  • 796 views

Hello,

I tried doing all the tips written in these posts (1 , 2 , 3 ) but nothing seems to work for me. I am using Mathcad Prime 10. I tried converting the range into a vector and making the data unitless but I am getting an error.

MA_13282691_0-1744867353878.png

 



Looks like this problem has been asked a lot of times but there is no simplier way to do it

Best answer by terryhendicott

Hi,

Like This see enclosed.

2 replies

T
21-Topaz II
terryhendicott21-Topaz IIAnswer
21-Topaz II
April 17, 2025

Hi,

Like This see enclosed.

    ttokoro
    21-Topaz I
    ttokoro21-Topaz I
    21-Topaz I
    April 17, 2025

    Prime 11

    image.png

    t.t.
      W
      Werner_E25-Diamond I
      25-Diamond I
      April 17, 2025
      @MA_13282691 wrote:

      Hello,

       I tried converting the range into a vector

      And that's exactly what needs to be done.

       

      But the undocumented trick of converting a range into a vector by simply using an inline evaluation (the equal sign after the definition) which I had used in two of the threads you refer to, does not work starting with version 10 of Prime. This was disabled intentionally by PTC because it is irritating (actually it may be called a bug) that a simple evaluation changes the data type. Unfortunately, PTC waited until version 11 to offer an alternative.

      So in Prime 10 you need to use one of the various posted versions of a program which converts a range into a vector like the basic function "range2vec" which Terry had used in his sheet. Starting with Prime 11 you may use the new built-in function "vec" to do the job as ttokoro already wrote.

       

        Terms & ConditionsCookie settingsAccessibility statement