I am trying to import data from excel into mathematica. It works fine except that the values of all the variables after the import into mathematica change at 6th decimal point. For example, variable QEF is 15.51110000000 in excel but in mathematic after the import it becomes 15.5110999999. Similarly all other variables are also changed. These are small changes but after solving the model there is discrepancy between initial values and the solution. Anyone aware of this issue? Thanks.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Increase precision of numbers when importing data from an Excel sheet? | 3 | 8593 | May 25, 2016 | |
| Import large Excel sheets? | 12 | 14563 | October 9, 2018 | |
| [?] Import a number from Excel? | 2 | 4409 | August 1, 2019 | |
| A tired topic: importing from Excel into Mathematica | 5 | 12085 | October 30, 2019 | |
| Import Matrix from Excel file | 1 | 7322 | April 30, 2014 |