All Forums  Origin Forum  Origin Forum  problem with batch processing

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 zorglub[/i] [br]Hello, I am trying to do data manipulation, then fitting these data, and batch process all of these operations but I failed. I have xls files made of 2 columns in a directory. I have import one file and rename the sheet " Raw data ". I create then a column and set its value ( a non linear function f applied on col(B)) with automatic recalculation. Then I extract the mean and standard deviation of this new column using "statistics on column" menu. Then I create a new sheet "Results" where I copy/paste as a link the mean and standard deviation extracted. I save my book as a template and use it on several xls files but it doesn't work ! I though it was because of the creation of a new column with automatic set values so I tried to creat a new sheet ( " manipulated data ") and then run the statistic from this new sheet but it failed again. So my question is : how can I create a new column set with manipulated data from an imported file, then extract statistics form theses manipulated data, and then batch process these operations ? Cordially Laurent [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.