T O P I C R E V I E W |
tlab |
Posted - 01/20/2005 : 11:57:58 AM Origin Version (Select Help-->About Origin): 7 Operating System: win2000
Days ago it worked well. Now by Random XYZ, any griding method, any parameters, it always says: ---- Error! Failed to sort and/or replace duplicates with mean value. ----
Even I use that sample file under \Origin70\Samples\Analysis\Worksheet to Matrx\Worksheet to Matrix.
"Sparse XYZ" works well.
Anything wrong with my "Random XYZ"?
Thanks.
tlab
|
6 L A T E S T R E P L I E S (Newest First) |
easwar |
Posted - 01/21/2005 : 2:50:39 PM Hi tlab,
I see that you have a worksheet with 6 columns of data and are trying to convert the last three columns to a matrix using random conversion.
Did you set the column type for the last three columns to be X, Y, Z? If you only changed the last column to Z and left the 4th and 5th columns as Y, then I get the same error as you get. This is because then the program is trying to take the X from the 1st column instead of the 4th columns.
Just wanted to make sure if this is the problem, before you end up reinstalling. If the above does not solve it, I still suggest you call your local tech support before resorting to re-installing the product.
Easwar OriginLab
|
tlab |
Posted - 01/21/2005 : 2:06:29 PM Thanks, Mike. the version is:
OriginPro 7 SR4 v7.0552(B552)
I check the data again. It does not have any missing data point. And the problem remains even if I use that sample file provided by Origin. I guess maybe I need to install it again...
Thanks.
tlab
|
Mike |
Posted - 01/21/2005 : 10:18:28 AM tlab, I spoke with someone who is more knowledgeable about the error message that you received and he believes that you have data sets of unequal sizes (i.e. either your X, Y, or Z data sets contains one or more values than the other data sets) and this is what is causing the gridding to fail. I tested this scenario and this will indeed produce the error message that you got.
Make sure that for every X value, there is a corresponding Y and Z value. This doesn't show up in the data that you posted, but perhaps the missing value is just tacked onto the end of one of your data sets and you ignored it when you posted your data?
Mike OriginLab
Edited by - Mike on 01/21/2005 10:32:39 AM |
Mike |
Posted - 01/21/2005 : 09:19:44 AM tlab, I don't have any problem creating a matrix (Random XYZ, Renka-Cline) with the data that you've posted.
One thing that we ought to check: Run Origin and select Help:About Origin. The "About" dialog should report something like...
OriginPro 7 SR4 v7.0552(B552)
Let us know which version (build) you are using. Thanks.
Mike OriginLab |
tlab |
Posted - 01/20/2005 : 6:17:44 PM Thanks, Mike. Actually it is same data which I used to ask you question at LabTalk forum. It is strange to find that convert function does not work any more. I did not change any setting or delete any files of Origin these days.
Here is data. first 3 columns is raw data, second 3 columns is sorted data. Please advice.
Thanks.
tlab
--- 0 120 0.515 -125 0 0.519 -65 90 0.516 -120 -25 0.518 -25 100 0.512 -120 25 0.518 25 100 0.508 -115 -40 0.519 65 90 0.51 -115 40 0.515 -90 65 0.515 -90 -65 0.518 -50 75 0.514 -90 65 0.515 0 75 0.51 -75 -50 0.517 50 75 0.512 -75 -25 0.517 90 65 0.507 -75 0 0.516 -115 40 0.515 -75 25 0.515 -75 50 0.513 -75 50 0.513 -25 50 0.512 -65 -90 0.517 25 50 0.508 -65 90 0.516 75 50 0.511 -50 -75 0.517 115 40 0.506 -50 75 0.514 -120 25 0.518 -25 -100 0.517 -75 25 0.515 -25 -50 0.515 -25 25 0.514 -25 -25 0.514 25 25 0.51 -25 0 0.515 75 25 0.511 -25 25 0.514 120 25 0.506 -25 50 0.512 -125 0 0.519 -25 100 0.512 -75 0 0.516 0 -120 0.513 -25 0 0.515 0 -75 0.513 25 0 0.509 0 75 0.51 75 0 0.512 0 120 0.515 125 0 0.508 25 -100 0.512 -120 -25 0.518 25 -50 0.511 -75 -25 0.517 25 -25 0.511 -25 -25 0.514 25 0 0.509 25 -25 0.511 25 25 0.51 75 -25 0.513 25 50 0.508 120 -25 0.507 25 100 0.508 -115 -40 0.519 50 -75 0.515 -75 -50 0.517 50 75 0.512 -25 -50 0.515 65 -90 0.514 25 -50 0.511 65 90 0.51 75 -50 0.514 75 -50 0.514 115 -50 0.509 75 -25 0.513 -90 -65 0.518 75 0 0.512 -50 -75 0.517 75 25 0.511 0 -75 0.513 75 50 0.511 50 -75 0.515 90 -75 0.511 90 -75 0.511 90 65 0.507 -65 -90 0.517 115 -50 0.509 -25 -100 0.517 115 40 0.506 25 -100 0.512 120 -25 0.507 65 -90 0.514 120 25 0.506 0 -120 0.513 125 0 0.508
|
Mike |
Posted - 01/20/2005 : 1:16:59 PM tlab,
Try sorting your worksheet before you attempt the worksheet to matrix conversion.
Mike OriginLab |