Readexcel not transferring correct values for scientific notation. Below are example of change in the exponent from before to after;
Before After
| -4.30E-07 | -4,30E-05 |
| -4.26E-07 | -4.26E-05 |
| -4.13E-07 | -4.13E-05 |
| -3.92E-07 | -3.92E-05 |
| -3.62E-07 | -3.62E-05 |
| -3.23E-07 | -3.23E-05 |
| -2.77E-07 | -2.77E-05 |
| -2.22E-07 | -2.22E-05 |
| -1.58E-07 | -1.58E-05 |
| -8.67E-07 | -8.67E-04 |
| -6.96E-07 | -6.96E-05 |
| 8.08E-07 | 8.08E-04 |
This results in a curve like this: I have found no way to correct the exponents on the two extreme points. The curve should be smooth.
I'm sorry, but that's a completely incomprehensible question!
Not only do you fail to specify whether you are using Mathcad or Prime (judging by the image, it's probably Prime—which version?), you also don't say anything about what you are actually doing and what the problem is.
You just mention “READEXCEL” and cryptically add ‘Before’ and “After.” 'Before' and 'After' what process? What are your doing? The data you show is probably copied from two columns in Excel, with the values in the second column being exactly 100 times larger, and two values even 1000 times larger.
How did this second column with the changed values appear in Excel? What did you do? It couldn't have been READEXCEL, because this command doesn't change anything in the Excel file! So what exactly do you want to show with this modified values??
When I copy your “Before” data into an Excel file in column A, read it into Prime 11, and then write it back to column B with WRITEEXCEL, the data does not change at all. Neither in Prime nor in Excel!
Prime:
Excel:
So what's your problem?? What process does your cryptic “before” and “after” refer to, and what does this all have to do with the graph shown and the peaks you mentioned?
