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 ?
I am not sure whether this problem is related to your template. But use Batch Processing for the external Excel file, the files should be CSV file. You can save the excel file as .csv, and then try again.
problem with batch processing
Posted - 07/09/2014 : 09:40:33 AM
