| Author |
 Topic  |
|
|
DanHunter
Austria
4 Posts |
 Posted - 10/20/2020 : 06:44:09 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): Origin 2020b
Operating System: Windows 10
Hello everyone!
I have a small problem with my attempt to create an automatic data processing template for a given excel data file. The excel file is always the same and contains data that I want to process in origin.
However, there need to be made some calculations in order to process the data. Within the excel file, I record data of an experiment which also contains the time for example. Due to the experimental setup and conditions, the time recording does not always start directly when the experiment starts. So the zero point for the time is always shifted to a different position for each new excel file. I have one fixed excel cell where the exact time stamp of the experiment starting is saved. What I want now, is to import the excel file in such a way to origin, that the time stamp can be imported as variable or any value that origin can use to recalculate the time data points (which is just a simple substraction of X value minus the time stamp value).
is there a way to automatise this with the correct import template and analysis template? If yes how can I do that?
I managed to import the time stamp as variable, but I cannot use the variable during anaylsis (I tried to use simple mathematics, i think its the vmathtool) to recalculate my x values. Can someone suggest a solution to this?
Daniel |
|
|
YimingChen
1651 Posts |
Posted - 10/20/2020 : 09:36:18 AM
|
Not sure how your data looks like once imported into Origin worksheet. But you can subtract a column by a cell value by setting formula in F(x) column header. See below:
James |
 |
|
|
DanHunter
Austria
4 Posts |
Posted - 10/21/2020 : 09:03:18 AM
|
Well that is the problem. The way the excel looks and how I import it into origin, the variable is located in the header part of the workbook:
And with the arrow I marked the value or rather the "cell" i want to use as basis for recalculating my time values for each experiment automatically. Can I extract the value in this part of the workbook in some way?
Daniel |
|
|
|
YimingChen
1651 Posts |
Posted - 10/21/2020 : 09:21:34 AM
|
Yes, you can get access to column metadata. See below:
James |
|
|
|
DanHunter
Austria
4 Posts |
Posted - 10/22/2020 : 07:27:20 AM
|
Thanks for the tip, that should work! However, it seems my calculations don't work properly, can you maybe explain what the function of the % and the $ sign are in the formula?
Daniel |
|
|
|
YimingChen
1651 Posts |
|
|
DanHunter
Austria
4 Posts |
Posted - 12/07/2020 : 04:22:59 AM
|
Thanks for the input, it works right now!
I have one additional question about the whole topic, the analysis template works in order to batch process some excel files like I intended. However, how can you influence the way the batch processing tool is importing the data from the excel files? There is no option to select an import filter as of my understanding. What filter does the program use? Or where can I adjust the filter for the batch processing?
Daniel |
|
|
| |
Topic |
|
Excel Import Automatisation Help