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();
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("MID2 :(PN's Count) ", temp);
ew.printLine();
ew.printLine();
ew.printArray("MID2 :(Mid_2) ", mid2);
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();
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();
}
