How to add reference lines from a reference line table into a control charts or variability charts?

bharathu

Hello,

 

I am trying to create a table that holds the reference lines for each model. Each reference line is the yield expectation for each model. I intend to have a script that can import the reference lines from the central table and plot the reference line on the control charts or the variability charts when trending yields of each model. 

Here is a my dummy data for the yield table

Model	WaferID	Yield
IC1	A	50
IC1	B	60
IC1	C	70
IC2	E	30
IC2	F	40
IC2	G	50
IC2	H	60
IC3	R	80
IC3	S	90
IC3	T	70
IC3	Z	65

 

Here is my dummy reference line table that needs to be imported into the control charts

Model	Reference line for Yield expectation
IC1	50
IC2	45
IC3	70

 

The control chart or the variablility chart I am trying to plot has "Yield" in y axis & "WaferID" as the x-axis. Hence I cannot use the "column property" function in the "Yield" column to set the reference lines. I have more than 60 ICs to look at and I looking fdor some help where it could be automated than manually entered. Here is a sample snap shot of what I am trying to achieve. Any help would be greatly appreciated.

ian_jmp

The code below will produce:

and should get you started. You can use 'Help > Books > Scripting Guide' and 'Help  > Scripting Index' to figure out what it's doing. Note that using the titles of the outline nodes is not currently very robust, but this could be improved, or done differently.

NamesDefaultToHere(1);

// Yield table
dt1 = 
New Table( "Yield",
	Add Rows( 11 ),
	New Column( "Model",
		Character,
		"Nominal",
		Set Values(
			{"IC1", "IC1", "IC1", "IC2", "IC2", "IC2", "IC2", "IC3", "IC3", "IC3",
			"IC3"}
		)
	),
	New Column( "WaferID",
		Character( 16 ),
		"Nominal",
		Set Values( {"A", "B", "C", "E", "F", "G", "H", "R", "S", "T", "Z"} )
	),
	New Column( "Yield",
		Numeric,
		"Nominal",
		Format( "Best", 12 ),
		Set Values( [50, 60, 70, 30, 40, 50, 60, 80, 90, 70, 65] )
	)
);

// Reference table
dt2 = 
New Table( "Reference",
	Add Rows( 3 ),
	New Column( "Model", Character, "Nominal", Set Values( {"IC1", "IC2", "IC3"} ) ),
	New Column( "Value",
		Numeric,
		"Nominal",
		Format( "Best", 12 ),
		Set Values( [50, 40, 70] )
	)
);

// Start here . . .
// Get the values in dt2 into lists for later
modelVal = Column(dt2, "Model") << getValues;
refVal = Column(dt2, "Value") << getValues;

// Control Charts
cc = dt1 << Control Chart(
						Sample Label( :WaferID ),
						Chart Col( :Yield, Individual Measurement ),
						By( :Model )
					);

// Loop over the control chart reports
for(r=1, r<=NItems(cc), r++,
	ccRep = Report(cc[r]);
	// Extract the level of 'Model' from the title of the outline node
	title = ccRep[OutlineBox(1)] << getTitle;
	delimPos = Munger(title, 1, "=");
	level = Substr(title, delimPos+1, Length(title)-delimPos);
	// Get the reference value and plot it using a graphics script
	ref = refVal[Loc(modelVal, level)];
	Eval(
		Substitute(
				Expr(ccRep[FrameBox(1)] << addGraphicsScript(PenColor("Blue"); HLine(TBD))),
				Expr(TBD),
				ref[1]
				);
			);
	);