| T O P I C R E V I E W |
| piotrmax1 |
Posted - 06/07/2011 : 08:58:08 AM
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:
At the beginning samy sorry for my English.
I have a question.
I have a table consisting of 320 columns and 255 rows.
I would like to convert these values
The minimum value is -2000 and the maximum 14000th
I also have 50 points on a separate chart.
I know that 14000 => 600,
13500 => 660 .....
How to transform these values? |
| 5 L A T E S T R E P L I E S (Newest First) |
| piotrmax1 |
Posted - 06/15/2011 : 1:28:56 PM
Thank you very much |
| ricaluanna |
Posted - 06/12/2011 : 9:43:47 PM
This is great! I have learned a lot from this.
rica g luanna |
| Hideo Fujii |
Posted - 06/09/2011 : 11:23:37 AM
Hi,
Okay, I think now understand what you wanted... I suppose you want to apply the polynomial function which had been obtained by fitting in separate task previously. If so, here is one possible procedure:
1) Convert your matrix to a XYZ worksheet ("Matrix: Convert to Worlsheet" menu, then choose Method="XYZ Columns" option. ==>You get a XYZ worksheet.
2) Retry the polynomial fitting if you didn't select "Find Y from X" option at Find X/Y branch. (You could revise this option to retry, you can left-click the Green Lock icon on the graph, and choose "Change Parameters" fly-out.) ==?You get an extra sheet (tab) "FitPolynomialFindYfromX" in your data workbook. Select it.
3) Copy Z column in the XYZ worksheet in 1), and paste to the X column in the "FitPolynomialFindYfromX" worksheet in 2). ==>You get the converted result in Y column. Copy it.
4) Go back to your XYZ worksheet, and paste the converted result of 3) into the Z column.
5) Convert back the XYZ worksheet to a matrix form by choosing Z column, choose "Worksheet: Convert to Matrix: XYZ Gridding" menu. Choose "Regular" method at the "Gridding Settings: Gridding Method and Parameters" branch in the dialog. ==> You get the converted matrix.
I hope this works.
--Hideo Fujii
OriginLab
|
| piotrmax1 |
Posted - 06/09/2011 : 08:04:50 AM
The matrices of all the values we may call X
all values of x
I want to convert to Y using the graph
how best to do?? |
| Hideo Fujii |
Posted - 06/07/2011 : 2:13:31 PM
Hi,
From your post, it is not clear for me which kind of conversion you want to perform. Generally speaking, if you have the formula to convert a column data to other, you can use the Set Column Value tool ("Column: Set Column Values" menu). So, please clarify the conversion you want to run.
--Hideo Fujii
OriginLab |
