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
 The problem for conversion from worksheet to matri

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
dashliu Posted - 10/13/2011 : 07:55:44 AM
Hi guys,

I am facing a problem to convert the uniformly spaced data to matrix. I read this topic:
"convert not uniformly spaced data to the matrix" on the page: http://www.originlab.com/forum/topic.asp?TOPIC_ID=6736

Per the suggestion of Laurie, I completed the conversion from worksheet to XYZ successfully with the help of script. Afterward, I tried to use ¡°Convert worksheet to matrix ¨C XYZ gridding ¨C Random (Renka Cline)¡±.

The problem is the data shown on the converted matrix looks very weird. For instance, all the data in my worksheet were positive, but some of data shown on the matrix were negative values. I think there were something wrong during the conversion but I don¡¯t know what happened.

I also tried the method of Random (Thin Plate Spline), but it said ¡°The method is not suitable for large dataset¡±.

Another question is: for the color filled contour, is that possible to change the scale type of axis from linear to log?

Thank you very much
Dash
3   L A T E S T    R E P L I E S    (Newest First)
Hideo Fujii Posted - 10/13/2011 : 4:51:07 PM
Hi Dash,

I thought if your data is truly equally spaced, you can apply the "Direct Worksheet to Matrix Conversion" method to the data body (excluding 1st row and 1st column), then remap; However, it your X data (6.04, 6.98, 8.06,...) is really not equi-spaced. So, sorry, but I don't have much to say. Also, regarding the log scale for contour plots, it seems your old Origin version has the limitation before improved later.

--Hideo Fujii
OriginLab
dashliu Posted - 10/13/2011 : 12:29:35 PM
Thanks, Hideo

However, I use Origin 8.0, does it possible to do that.

Regarding of the axis scale, I found the selection for the change from linear to log10 is unavailable (It is grey). That is why I don't know how to do that.

I appreciate that.
Dash
Hideo Fujii Posted - 10/13/2011 : 11:08:55 AM
Hi Dash,

Since Origin version 8.5, Origin can make a contour plot from such "virtual matrix" directly.
See http://www.originlab.com/index.aspx?go=Products/Origin/DataManagement/WorkbooksAndWorksheets&pid=1713 .

To do this, you can highlight all worksheet cells (left-click the corner cell between "Long Name" and "A(X)"), then choose the Plot menu.

--Hideo Fujii
OriginLab

P.S. You can change the axis scale of the contour plot to Log10 scale from the Axis dialog box ("Format: Axis" menu).

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