Skip to main content
V
ValeryOchkov24-Ruby IV
24-Ruby IV
February 20, 2015
Question

Copy values from Excel into Mathcad - one Error?

  • February 20, 2015
  • 3 replies
  • 1123 views

I have copied values from Excel into Mathcad 15 and see one error:

E17.png

The Mathcad 15 sheet in attach

Same in Prime

E17-MP.png

3 replies

Werner_E
Werner_E25-Diamond I
25-Diamond I
February 20, 2015

Valery Ochkov wrote:

I have copied values from Excel into Mathcad 15 and see one error:

Thats not an error but just a side effect where you can see that under the hood Mathcad is not dealing with integers (like Derive and other exact math progs) but is using IEEE floats with all their drawbacks. Whenever you perform calculations or conversions with that kind of numbers (and you obviously do when you copy from Excel and excpect Mathcad to convert the 1E-28 notation) you can see those effects. At the level of precision provided by the program 10^-44 IS zero.

V
ValeryOchkov24-Ruby IVAuthor
24-Ruby IV
February 20, 2015

Werner Exinger wrote:

Valery Ochkov wrote:

I have copied values from Excel into Mathcad 15 and see one error:

Thats not an error

but I have created one Mathcad sheet with copy coeffs from Excel I have this error

Werner_E
Werner_E25-Diamond I
25-Diamond I
February 20, 2015

Valery Ochkov wrote:

Werner Exinger wrote:

Valery Ochkov wrote:

I have copied values from Excel into Mathcad 15 and see one error:

Thats not an error

but I have created one Mathcad sheet with copy coeffs from Excel I have this error

OK, to be more precise - it is indeed an error. What I meant is that its not a bug but just some kind of roundoff/convesion error. Dealing with float numbers you never should ask if two numbers are (exactly) equal but always if those two numbers are sufficently close by looking if the absolute value of their difference is smaller than a small threshold epsilon. And I guess that 10^-44 qualifies.

Terms & ConditionsAccessibility statement