Origin Ver. and Service Release (Select Help-->About Origin): Operating System: Windows 7
I just want to preface this by saying my normal use of Origin is produce graphs for publication not data analysis so I'm pretty new to the other functions in origin.
I produce microscope images, these images are then analysed in IDL with .csv files as the output. Once these files are produced I would normally load them into Excel and histogram the data there. I would go through a round of data removal based on specific criteria where I might delete up to 90% of my data.
I then combine all my data from different time points and dates into 1 single waterfall histogram graph.
What I would like to do is to import the data into origin (I know how to do this with the wizard), plot the histogram for (example) the D column in multiple sheets. And then, after deleting the sheets which don't make the grade, I want to produce the cumulative data for that histogram (i.e. if bin 1 has 2, 3, 2 for each sheet I want the data to output that bin 1 has 7 in it).
So far I have been able to do all of this step by step apart from producing a single histogram output. When I do it manually I get 3 outputs for 3 sheets in new sheets.
Is there a way to partly automate this process? I'm now analysing 30-50 images a day which is taking me more time to analyse than it does to collect the data.
Just in case the above doesn't make much sense:
Step 1 - import
Step 2 - produce diagrams and remove data if needed
Step 3 - Export data into a single sheet not many sheets
Step 4 - combine data with other and produce waterfall graphs
Since my 1st post I've been playing around with the import template so I now have (for each workbook imported) a Raw data worksheet and a frequency count worksheet containing x (bin) and y (count) data.
Is it possible to add a few lines of script to the batch processing process to plot the generated xy data on the same chart?
Maybe something along the lines of:
= for all workbook plotxy (A,B) plot:=203 ogl:=[<new template:=MyTemplate>]
Multiple data sheets multiple histograms
Posted - 06/20/2011 : 08:37:59 AM
