topic Re: Semiconductor CSV files adding wafer run order in Discussions

Semiconductor CSV files adding wafer run order

IANDO — Mon, 22 Apr 2024 11:09:49 GMT

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

Re: Semiconductor CSV files adding wafer run order

jthi — Mon, 22 Apr 2024 11:27:10 GMT

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>)

Re: Semiconductor CSV files adding wafer run order

txnelson — Mon, 22 Apr 2024 11:29:43 GMT

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

Re: Semiconductor CSV files adding wafer run order

IANDO — Mon, 22 Apr 2024 11:38:16 GMT

So attached a file where ive manually added wafer run order

Re: Semiconductor CSV files adding wafer run order

jthi — Mon, 22 Apr 2024 11:43:58 GMT

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.