Semiconductor CSV files adding wafer run order

[#1]

Hi

A lot of semiconductor equipment produces .csv files for data recorded during processing: a processed batch number containing 1 to  X silicon wafers,

The tool will run same process steps repeating on up to X wafers. CSV file  shows processed steps repeating but no assignment of  the wafer run order.  So if we have mutiple csv files imported to JMP then want a formula in the column to auto assign wafer run order; wafer run order will not always be same number of wafers that will vary...

Ideally a formula would be useful.....so we have batch number and process steps in CSV file.

Anyone done this...?. 

BATCH NUMBER        WAFER RUN ORDER        PROCESS STEPS 

[#2]

Could you provide small example of data to see what type of replicates there can possibly be (if there are none, simple Col Rank( <groups>) might be enough or Col Cumulative Sum(1, <groups>)

[#3]

If it would be possible to attach a sample of the excel file it would be very helpful in understanding your problem.

[#4]

So attached a file where ive manually added wafer run order

[#5]

One option could be something like this

Col Cumulative Sum(:Process Step == 1, :Batch Number)

but it does make some assumptions such as that your data is always in specific order and that new run order starts when Process Step changes to 1.