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; } string s = "A1:HA" + (Common.POSN + 100).ToString(); mySheet.Range[s].Clear(); ew.printLine(); ew.printLine("MID4_2_Table (Count MX/MN Table) Print ------------------------------------"); string [] h = new string [] { "POSN", "MX+A%SP", "MX-A%SP", "MN+A%SP", "MN-A%SP" }; for (int i = 0; i < h.Length; i++) { ew.print(h[i]); } ew.printLine(); for (int i = 0; i < rd.Rows; i++) { ew.print((i + 1).ToString("####0")); for (int j = 0; j < 4; j++) { ew.print(Count_MxMn[i, j].ToString("####0")); } ew.printLine(); } ew.printLine(); //ew.printLine("MID4_2_Table sum ------------------------------------"); ew.print("SUM"); for (int j = 0; j < 4; j++) { ew.print(Sumval[j].ToString("####0")); } ew.printLine(); //ew.printLine("MID4_2_Table AVERAGE ------------------------------------"); ew.print("Average"); for (int j = 0; j < 4; j++) { ew.print(Avg[j].ToString("##0.00")); } ew.printLine(); //ew.printLine("MID4_2_Table DIGITs ------------------------------------"); ew.print("DIGITs"); for (int j = 0; j < 4; j++) { ew.print(digit[j].ToString("##0")); } ew.printLine(); ew.printLine(); ew.Save(); ew.Close(); }
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:HA500"].Clear(); ew.printLine(); ew.printListPercent(rlist); ew.printLine(); ew.printArrayPercent("MID3-4 : %SP values (this means how many times does each %SP appear in the List)", temp); ew.printLine(); ew.printLine("max %SP value : " + maxSpcCount.ToString()); ew.printLine(); ew.printArrayPercent("MID3-4 :(Choose %SPs' that have max %SP value) ", perTemp); ew.printLine(); for (int i = 0; i < perTemp.Length; i++) { if (perTemp[i] > 0) { // get interval double intmin, intmax; intmax = (i + 1) * Common.GpspInterval; intmin = intmax - Common.GpspInterval; string pns = ""; pns = "Interval(%SP): " + (intmin).ToString("###0.0") + "% ~ " + intmax.ToString("###0.0") + "% , "; pns += " PN's : "; // get PNs between intmax and intmin for (int j = 0; j < rd.Cols; j++) { double persp = rd.PerSP[j]; if (persp > intmin && persp <= intmax) { pns += ((j + 1).ToString()) + " "; } } ew.printLine(pns); } } ew.printLine(); ew.printArray("MID3_4: Result:", mid3_4); ew.printLine(); ew.printLine(); ew.printArray("MID3_4: RANK:", rank3_4); ew.printLine(); ew.Save(); ew.Close(); }
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:HA200"].Clear(); /* * ew.printLine("MID3_2_Table Print ------------------------------------"); * for (int i = 0; i < t.Rows; i++) * { * for (int j = 0; j < t.Cols; j++) * { * ew.print(t.table[i, j].ToString("##0.0")); * } * ew.printLine(); * } * ew.printLine(); */ ew.printLine("MID3_2_Table AVERAGE ------------------------------------"); for (int j = 0; j < t.Cols; j++) { ew.print(t.avg[j].ToString("##0.00")); } ew.printLine(); ew.printLine(); // sw.WriteLine("MID3_2_Table: MaxIndex : "+maxindex.ToString()); ew.printLine("MID3_2_Table: MaxAVG : " + t.maxavg.ToString("####0.00")); ew.printLine("MID3_2_Table: interval lower : " + intmin.ToString()); ew.printLine("MID3_2_Table: interval upper : " + intmax.ToString()); ew.printLine(); ew.printArray("MID3_2: Result:", mid3_2); ew.printLine(); ew.Save(); ew.Close(); }
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:HA200"].Clear(); ew.printLine(); int[] temp = new int[rd.Cols]; if (mid3_1_Count == 1) { for (int i = 0; i < rd.Cols; i++) { temp[i] = mid3_1[0, i]; } ew.printArray("Mid-3-1: Result: ", temp); } else { for (int k = 0; k < mid3_1_Count; k++) { for (int i = 0; i < rd.Cols; i++) { temp[i] = mid3_1[k, i]; } ew.printArray("Mid-3-1-" + (k + 1).ToString() + ": Result: ", temp); } } ew.printLine(); ew.printLine("MID3 RANK:"); ew.printLine(); ew.printArray("RANK:", rank); ew.printLine(); ew.Save(); ew.Close(); }
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:HA200"].Clear(); ew.printLine(); ew.printArray("MID4_1 :Rawdata %SP ", rd.PerSP); ew.printLine("MID4_1: Average %SP : " + rd.APerSP.ToString("#####0.00")); ew.printLine(); ew.printArray("MID4_1 :MX/MN", mx_mn); ew.printLine(); // pn list string[] header = new string[] { "MX+A%SP PN's List", "MX-A%SP PN's List", "MN+A%SP PN's List", "MN-A%SP PN's List" }; int index = 0; foreach (R1pn r1 in rlist.rList) { ew.printLine(header[index] + " : " + r1.getString()); index++; if (index == 4) { break; } } ew.printLine(); ew.printArray("MID4_1: Result:", mid4_1); ew.printLine(); ew.Save(); ew.Close(); }
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:HA200"].Clear(); ew.printLine(); ew.printArray("MID4_3: Result:", mid4_3); ew.printLine(); ew.Save(); ew.Close(); }
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:HA200"].Clear(); ew.printLine(); ew.printLine("MID3_3_Table SPC ------------------------------------"); ew.print(" PN "); for (int j = 0; j < mid3_3_table.Cols; j++) { ew.print(((j + 1) * Common.GpspInterval).ToString("##0")); } ew.printLine(); ew.print("SPC"); for (int j = 0; j < mid3_3_table.Cols; j++) { ew.print(mid3_3_table.spc[j].ToString("##0")); } ew.printLine(); ew.printLine(); ew.printLine("MID3_3_Table spcIndex : " + mid3_3_table.spcindex.ToString() + ", max PN : " + ((mid3_3_table.spcindex + 1) * Common.GpspInterval).ToString()); ew.printLine("MID3_3_Table spcmax value : " + mid3_3_table.spcmax.ToString()); ew.printLine(); ew.Save(); ew.Close(); }
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:AZ40"].Clear(); int[] temp = new int[Cols]; for (int i = 0; i < Cols; i++) { temp[i] = i + 1; } ew.printArrayLine("PN", temp); ew.printArrayLine("MID-1 ", form.md1.mid1); ew.printArrayLine("MID-2 ", form.md2.mid2); for (int k = 0; k < form.md3_1.mid3_1_Count; k++) { for (int i = 0; i < Cols; i++) { temp[i] = form.md3_1.mid3_1[k, i]; } if (form.md3_1.mid3_1_Count == 1) { ew.printArrayLine("MID3-1", temp); } else { ew.printArrayLine("MID3-1-" + (k + 1).ToString(), temp); } } ew.printArrayLine("MID3-2 ", form.md3_2.mid3_2); ew.printArrayLine("MID3-4 ", form.md3_4.mid3_4); ew.printArrayLine("MID4-1 ", form.md4_1.mid4_1); ew.printArrayLine("MID4-3 ", form.md4_3.mid4_3); ew.printArrayLine("SUM ", rsum, 1); ew.printLine(""); string biggiest = (form.rd.tpsn + 2).ToString() + "th biggist value is " + ThreshVal.ToString(); for (int i = 0; i < Cols; i++) { temp[i] = 0; } int k1 = 0; for (int i = 0; i < Cols; i++) { if (rsum[i] >= ThreshVal) { temp[k1++] = (i + 1); } } ew.printArrayLine(biggiest, temp); ew.printLine(); // print : pn list temp = new int[Cols]; for (int i = 0; i < Cols; i++) { temp[i] = i + 1; } ew.printArrayLine("PN", temp); // print rank of totalsum rankSum = new int[rsum.Length]; Common.makeRankArray(ref rsum, ref rankSum); ew.printArrayLine("Total_Sum", rankSum); // Rank Print // Mid 1 //ew.print("MID 1"); //ew.printRankArray("MID1:Rank", form.rd.spc,1); //ew.printLine(); int[] mid1Rank = new int[Cols]; Common.makeRankArray(ref form.rd.spc, ref mid1Rank); ew.printArrayLine("MID-1", mid1Rank); // MID 3-1 ew.printArrayLine("MID3-1", form.md3_1.rank); int[] mid1_mid3_1 = new int[Cols]; for (int i = 0; i < Cols; i++) { mid1_mid3_1[i] = mid1Rank[i] + form.md3_1.rank[i]; } ew.printArrayLine("MID-1 & MID3-1", mid1_mid3_1); ew.printLine(); // Mid 2 //ew.print("MID 2"); //ew.printRankArray("MID2:Rank (sort by PN's count in the List)", form.md2.temp, 1); //ew.printLine(); int[] mid2Rank = new int[Cols]; Common.makeRankArray(ref form.md2.temp, ref mid2Rank); ew.printArrayLine("MID-2", mid2Rank); // Mid3-4 ew.printArrayLine("MID3-4", form.md3_4.rank3_4); int[] mid2_mid3_4 = new int[Cols]; for (int i = 0; i < Cols; i++) { mid2_mid3_4[i] = mid2Rank[i] + form.md3_4.rank3_4[i]; } ew.printArrayLine("MID-2 & MID3-4", mid2_mid3_4); ew.printLine(); ew.printArrayLine("MID3-2 ", form.md3_2.mid3_2); ew.printArrayLine("MID4-1 ", form.md4_1.mid4_1); ew.printArrayLine("MID4-3 ", form.md4_3.mid4_3); int[] mid3_2mid4_1mid4_3 = new int[Cols]; for (int i = 0; i < Cols; i++) { mid3_2mid4_1mid4_3[i] = form.md3_2.mid3_2[i] + form.md4_1.mid4_1[i] + form.md4_3.mid4_3[i]; } ew.printArrayLine("MID3-2,Mid4-2 & Mid4-3", mid3_2mid4_1mid4_3, 1); ew.printLine(); //print final result int[] finalresult = new int[Cols]; for (int i = 0; i < Cols; i++) { finalresult[i] = rankSum[i] + mid1_mid3_1[i] + mid2_mid3_4[i] + mid3_2mid4_1mid4_3[i]; } ew.printArrayLine("FINAL RESULT", finalresult, 1); // print pn for (int i = 0; i < Cols; i++) { temp[i] = i + 1; } ew.printArrayLine("PN", temp); // Final Sort int [] finalsort = new int[Cols]; int[] finalorder = new int[Cols]; Array.Copy(finalresult, temp, Cols); Array.Sort(temp); Array.Clear(finalorder, 0, Cols); int prank = 1, rank = 1, cur = 0; for (int i = 0; i < Cols; i++) { if (i > 0) { if (temp[i] == temp[i - 1]) { continue; } } prank = rank; for (int j = 0; j < Cols; j++) { if (finalresult[j] == temp[i]) { finalsort[j] = prank; finalorder[cur++] = j + 1; rank++; } } } ew.printArrayLine("Final Rank", finalsort, 1); ew.printLine(); ew.printArrayLine("Final PN's Order", finalorder, 1); ew.Save(); ew.Close(); }
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:HA200"].Clear(); mySheet.Range["A1:AZ4000"].Clear(); ew.printLine(); ew.printLine("Mid_1(RawData.SPC) Print ------------------------------------"); ew.printArray("MID1 :(SPC, sum of 1's ) ", rd.spc); ew.printLine("Mid_1(Max SPC value) : " + maxSPC); ew.printLine("Mid_1(sum of SPC) : " + sumofSPC); string pns = ""; for (int i = 0; i < rd.spc.Length; i++) { if (rd.spc[i] >= maxSPC) { pns = pns + (i + 1).ToString() + " "; } } ew.print("Mid_1(Max PN's) : " + pns); ew.printLine(); ew.printLine("Mid_1(RawData %SPC) Print ------------------------------------"); ew.printArray("MID1 :(%SP) ", rd.PerSP); ew.printLine("MID1 :(A%SP):" + rd.APerSP.ToString("######0.00")); ew.printLine(); ew.printRankArray("MID1 : Rank ", rd.spc); ew.printLine(); ew.printArray("MID1 :(Mid_1) ", mid1); ew.printLine(); // Print Raw Data /* * ew.printLine(); * ew.printLine("Mid_1(RawData Print) ------------------------------------"); * ew.print("POSN"); * for (int i = 0; i < rd.Cols; i++) * ew.print((i + 1).ToString()); * ew.printLine(); * * for (int i = 0; i < rd.Rows; i++) * { * ew.print((i + 1).ToString()); * for (int j = 0; j < rd.Cols; j++) * { * if (rd.rawdata[i, j]==0) * ew.print(" "); * else * ew.print(rd.rawdata[i, j].ToString()); * } * ew.printLine(); * if (i % 100 == 0) * Console.WriteLine(" MID1: Print Line: " + i.ToString()); * } * ew.printLine(); */ ew.Save(); ew.Close(); }
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(); }