This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Floating point issue from Excel or Clipboard to Ple4Win
25-01-2016, 03:02 PM, (This post was last modified: 25-01-2016, 03:02 PM by shaswin.)
#1
Floating point issue from Excel or Clipboard to Ple4Win
Affected version: Ple4Win v4.3.1 build 15032

When one imports data from Excel to Ple4Win, Ple4Win doesn't imports the whole double digit value. The floating point value is trimmed at the 5th digit. I have attached an example Excel file with maximum 9 digits.

Value of Cell C3 of the POLYDIF sheet is 94833.25568275
In Ple4Win the first DX_N value is 94833.25568.
Somehow the values after the 94833.25568 are cleared. This means that my calculated values in Excel doesn't match with Ple4Win, which means that points are not in the same location as calculated in Excel.

This issue also happens when copy manually with (Ctr+C) from cell C3 value and paste (Ctrl+V) it into Ple4Win. So the values are also trimmed when the Clipboard is used.

This is a small issue, but at disconituity points this can be issue because it is not exactly on the node/AX-L/AX-LP as calculated in Excel due to this isconsistency which can give stress peak points in the calculations for example when one uses slack points.


Attached Files
.xlsx   Ple4Win import_BC4_ambiënt_lang_SOILRB.xlsx (Size: 11.39 KB / Downloads: 2)


Messages In This Thread
Floating point issue from Excel or Clipboard to Ple4Win - by shaswin - 25-01-2016, 03:02 PM
RE: Floating point issue from Excel or Clipboard to Ple4Win - by P Herwig MSc - 28-01-2016, 10:42 AM
RE: Floating point issue from Excel or Clipboard to Ple4Win - by P Herwig MSc - 02-02-2016, 11:40 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)