I created an analysing template in origin, where I import an multiple ASCII-files of the same structure. These files need to be analysed and data is plotted. Therefore, I created an additional workbook where I access colums of the imported data by defining a variable in such way: range var1 = [Book1]"Sheet1"!col("Example") It works fine so far with the expection that I have to adapt the book name (since its changing its name by duplicating) every single time I duplicate the folder to perform the analysis on a different data set. That requires quite some manual work. Is there a more handy way to perform that task?
Additionally, I'd like to perform average values + std. dev. of cells of multiple columns. I had only figured out to do this by applying teh formula e.g. 1/2*(var1+var2). Unfortunately, the number of ascii-files varies and I have to adapt the formula manually as well. Any tips on that?
Thank you very much for your help! Lennart
Origin Ver. and Service Release: OriginPro 2019b Operating System: Windows 10
Accessing and treating data in analysis template
Posted - 03/20/2020 : 04:32:33 AM
