public Mid_4_3_new1(ref RawData r, ref Mid_4_1 md41, ref Mid_4_2 m42) { rd = r; md42 = m42; mid4_3 = new int[rd.Cols]; Array.Clear(mid4_3, 0, mid4_3.Length); sw = new StreamWriter(Common.debugpath + "\\" + "MID4_3.txt"); MXPlus = new double[rd.Cols]; MXMinus = new double[rd.Cols]; MXPlusPN = new int[rd.Cols]; MXMinusPN = new int[rd.Cols]; MXPlusCount = 0; MXMinusCount = 0; MXavg = 0; MNAvg = 0; for (int i = 0; i < md41.mx_mn.Length; i++) { if (md41.mx_mn[i] > 0) { MXPlusPN[MXPlusCount] = i; MXPlus[MXPlusCount++] = md41.mx_mn[i]; MXavg += md41.mx_mn[i]; } else if (md41.mx_mn[i] < 0) { MXMinusPN[MXMinusCount] = i; MXMinus[MXMinusCount++] = Math.Abs(md41.mx_mn[i]); MNAvg += Math.Abs(md41.mx_mn[i]); } } MXavg = MXavg / MXPlusCount; MNAvg = MNAvg / MXMinusCount; MXselectCount = 0; MNselectCount = 0; MXselectPN = new int[MXPlusCount]; MNselectPN = new int[MXMinusCount]; MXPlusDiff = new double[MXPlusCount]; MXMinusDiff = new double[MXMinusCount]; for (int i = 0; i < MXPlusCount; i++) { MXPlusDiff[i] = Math.Abs(MXPlus[i] - MXavg); } for (int i = 0; i < MXMinusCount; i++) { MXMinusDiff[i] = Math.Abs(MXMinus[i] - MNAvg); } double min1 = Double.MaxValue, min2 = Double.MaxValue; for (int i = 0; i < MXPlusCount; i++) { if (MXPlusDiff[i] < min1) { min1 = MXPlusDiff[i]; } } for (int i = 0; i < MXMinusCount; i++) { if (MXMinusDiff[i] < min2) { min2 = MXMinusDiff[i]; } } for (int i = 0; i < MXPlusCount; i++) { if (MXPlusDiff[i] == min1) { MXselectPN[MXselectCount] = MXPlusPN[i]; MXselectCount++; mid4_3[MXPlusPN[i]] = 1; } } for (int i = 0; i < MXMinusCount; i++) { if (MXMinusDiff[i] == min2) { MNselectPN[MNselectCount] = MXMinusPN[i]; MNselectCount++; mid4_3[MXMinusPN[i]] = 1; } } /* * // MX%SP * lower1 = MXavg * (1 - variation); * upper1 = MXavg * (1 + variation); * for (int i = 0; i < MXPlusCount; i++) * { * if (MXPlus[i] >= lower1 && MXPlus[i] <= upper1) * { * MXselectPN[MXselectCount] = MXPlusPN[i]; MXselectCount++; * mid4_3[MXPlusPN[i]] = 1; * } * } * // MN%SP * lower2 = MNAvg * (1 - variation); * upper2 = MNAvg * (1 + variation); * for (int i = 0; i < MXMinusCount; i++) * { * if (MXMinus[i] >= lower2 && MXMinus[i] <= upper2) * { * MNselectPN[MNselectCount] = MXMinusPN[i]; MNselectCount++; * mid4_3[MXMinusPN[i]] = 1; * } * } */ // Print Data // MX List string one = ""; sw.WriteLine("MX PN List : (PN, %SP) , Count: " + MXPlusCount.ToString()); for (int i = 0; i < MXPlusCount; i++) { one = one + "(" + (MXPlusPN[i] + 1).ToString() + ":" + MXPlus[i].ToString("#####0.00") + ") "; if (i > 0 && i % 5 == 0) { sw.WriteLine(one); one = ""; } } if (one != "") { sw.WriteLine(one); } // MN List sw.WriteLine(); one = ""; sw.WriteLine("MN PN List : (PN, %SP), Count: " + MXMinusCount.ToString()); for (int i = 0; i < MXMinusCount; i++) { one = one + "(" + (MXMinusPN[i] + 1).ToString() + ":" + (MXMinus[i] * -1).ToString("#####0.00") + ") "; if (i > 0 && i % 5 == 0) { sw.WriteLine(one); one = ""; } } if (one != "") { sw.WriteLine(one); } sw.WriteLine(); // average //sw.WriteLine("AveMX%SP =" + MXavg.ToString("#######0.00") + " Range:+/-" + (variation*100).ToString() + "% (" + lower1.ToString("######0.00") + "~" + upper1.ToString("######0.00") + ")"); //sw.WriteLine("AveMN%SP =" + (MNAvg * -1).ToString("#######0.00") + " Range:+/-" + (variation * 100).ToString() + "% (" + (lower2*-1).ToString("######0.00") + "~" + (upper2*-1).ToString("######0.00") + ")"); sw.WriteLine("AveMX%SP =" + MXavg.ToString("#######0.00")); sw.WriteLine("AveMN%SP =" + (MNAvg * -1).ToString("#######0.00")); sw.WriteLine(); // Difference table one = ""; sw.WriteLine("MX PN List : Difference Table , Count: " + MXPlusCount.ToString()); for (int i = 0; i < MXPlusCount; i++) { one = one + "(" + (MXPlusPN[i] + 1).ToString() + ":" + (MXPlus[i] - MXavg).ToString("#####0.00") + ") "; if (Math.Abs(MXPlus[i] - MXavg) == min1) { one = one + "** "; } if (i > 0 && i % 5 == 0) { sw.WriteLine(one); one = ""; } } if (one != "") { sw.WriteLine(one); } // MN List sw.WriteLine(); one = ""; sw.WriteLine("MN PN List : Difference Table , Count: " + MXMinusCount.ToString()); for (int i = 0; i < MXMinusCount; i++) { one = one + "(" + (MXMinusPN[i] + 1).ToString() + ":" + (MXMinus[i] - MNAvg).ToString("#####0.00") + ") "; if (Math.Abs(MXMinus[i] - MNAvg) == min2) { one = one + "** "; } if (i > 0 && i % 5 == 0) { sw.WriteLine(one); one = ""; } } if (one != "") { sw.WriteLine(one); } sw.WriteLine(); // pn list sw.WriteLine(); sw.Write("MX%SP Selected PNs' List : "); one = ""; for (int i = 0; i < MXselectCount; i++) { one = one + (MXselectPN[i] + 1).ToString() + " "; } sw.WriteLine(one); sw.Write("MN%SP Selected PNs' List : "); one = ""; for (int i = 0; i < MNselectCount; i++) { one = one + (MNselectPN[i] + 1).ToString() + " "; } sw.WriteLine(one); sw.WriteLine(); Common.printArray("MID4_3 :MID4_3", mid4_3, ref sw); }
public void printToExcel(string path1, string sheetname) { ExcelWrapper ew = new ExcelWrapper(); if (ew.Open(path1) == false) { return; } Excel.Worksheet mySheet; mySheet = ew.CreateSheet(sheetname); if (mySheet == null) { ew.Close(); return; } mySheet.Range["A1:AZ400"].Clear(); ew.printLine(); // Print Data // MX List string one = ""; ew.printLine("MX PN List : (PN, %SP) , Count: " + MXPlusCount.ToString()); for (int i = 0; i < MXPlusCount; i++) { one = one + "(" + (MXPlusPN[i] + 1).ToString() + ":" + MXPlus[i].ToString("#####0.00") + ") "; if (i > 0 && i % 5 == 0) { ew.printLine(one); one = ""; } } if (one != "") { ew.printLine(one); } // MN List ew.printLine(); one = ""; ew.printLine("MN PN List : (PN, %SP), Count: " + MXMinusCount.ToString()); for (int i = 0; i < MXMinusCount; i++) { one = one + "(" + (MXMinusPN[i] + 1).ToString() + ":" + (MXMinus[i] * -1).ToString("#####0.00") + ") "; if (i > 0 && i % 5 == 0) { ew.printLine(one); one = ""; } } if (one != "") { ew.printLine(one); } ew.printLine(); // average //ew.printLine("AveMX%SP = " + MXavg.ToString("#######0.00") + " Range:+/-" + (variation * 100).ToString() + "% (" + lower1.ToString("######0.00") + "~" + upper1.ToString("######0.00") + ")"); //ew.printLine("AveMN%SP = " + (MNAvg * -1).ToString("#######0.00") + " Range:+/-" + (variation * 100).ToString() + "% (" + (lower2 * -1).ToString("######0.00") + "~" + (upper2 * -1).ToString("######0.00") + ")"); ew.printLine("AveMX%SP = " + MXavg.ToString("#######0.00")); ew.printLine("AveMN%SP = " + (MNAvg * -1).ToString("#######0.00")); // pn list ew.printLine(); one = "MX%SP Selected PNs' List : "; for (int i = 0; i < MXselectCount; i++) { one = one + (MXselectPN[i] + 1).ToString() + " "; } ew.printLine(one); one = "MN%SP Selected PNs' List : "; for (int i = 0; i < MNselectCount; i++) { one = one + (MNselectPN[i] + 1).ToString() + " "; } ew.printLine(one); ew.printLine(); ew.printArray("MID4_3: Result:", mid4_3); ew.printLine(); ew.Save(); ew.Close(); }