The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Fail to convert worksheet to matrix

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

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

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000