All Forums  Origin Forum  Origin Forum  Accessing and treating data in analysis template

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

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by LennartR[/i] [br]Dear all, 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 [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.