///<summary>there are 10 items in the dataset and solve the summation items in the mean formula and calculate the intermediate value for standard deviation formula </summary>
///<param name="lstData">List Type as Integer 10 Item , passed by reference, that contains all the data as Type Integer >/param>
///<example>Author : THANAWAT PHORNPHOMSRI</example>
///<example>Date Start : 05/2/2017 11:00</example>
///<example>Date END : 25/2/2017 14:00</example>
///<example>Contact : [email protected]</example>
///
/// -------------------------------- BEGIN Main Program-------------------------
/// <summary>List Type as Integer 10 Item and average list </summary>
/// <param name="lstData">List Type as Integer 10 Item , passed by reference, that contains all the data as Type Integer >/param>
/// <param name="avg">Calculation function Average in List </param>
/// <param name="div">Calculation function Deviation in List </param>
///<returns>value divation type double </returns>
///<example>lstData[0] =10 ; </example>
///<permission cref="THANAWAT"/>
/// -------------------------------- End Main Program-------------------------
public static void Main(String[] args)
{
////////////////
DeivationList listDeviation = new DeivationList();
List <DeviationEntity> lstDeviation = getInput();
listDeviation.ListDeviationEntity = lstDeviation;
listDeviation.AvgX = getAverage(lstDeviation);
listDeviation.ListDeviationEntity = getDeviation(lstDeviation, listDeviation.AvgX);
listDeviation = SumDeviationCal(lstDeviation, listDeviation);
GenerateExcel(Output, listDeviation);
}
public static DeivationList SumDeviationCal(List <DeviationEntity> listDeviationEntity, DeivationList dList)
{
List <DeviationEntity> list = dList.ListDeviationEntity;
foreach (DeviationEntity dEntity in list)
{
dList.SumX += dEntity.NumX;
dList.SumDeviation += dEntity.NumDeviation;
}
double _deviat = Math.Sqrt(dList.SumDeviation / (list.Count - 1));
dList.DeviationPow1 = _deviat;
return(dList);
}
public static void GenerateExcel(String OutputFileName, DeivationList lstDeviation)
{
Workbook workbook = new Workbook();
workbook.ExcelWorkbook.ActiveSheetIndex = (3);
workbook.ExcelWorkbook.WindowTopX = (100);
workbook.ExcelWorkbook.WindowTopY = (200);
workbook.ExcelWorkbook.WindowHeight = (7000);
workbook.ExcelWorkbook.WindowWidth = (10000);
workbook.Properties.Author = ("CarlosAg");
workbook.Properties.Title = "DeviationApp";
workbook.Properties.Created = (DateTime.Now);
workbook.Styles.Add("HeaderStyle").Font.FontName = ("Cordia New");
WorksheetStyle worksheetStyle1 = workbook.Styles.Add("Default");
worksheetStyle1.Font.FontName = "Cordia New";
worksheetStyle1.Font.Size = 14;
worksheetStyle1.Font.Bold = (true);
worksheetStyle1.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
worksheetStyle1.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
worksheetStyle1.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
worksheetStyle1.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
Worksheet worksheet1 = workbook.Worksheets.Add("DeviationSheet");
worksheet1.Table.Columns.Add(new WorksheetColumn(120)); //1
worksheet1.Table.Columns.Add(new WorksheetColumn(120)); //2
worksheet1.Table.Columns.Add(new WorksheetColumn(120)); //3
/// Header
///
WorksheetRow worksheetRow1 = worksheet1.Table.Rows.Add();
worksheetRow1.Cells.Add("");
worksheetRow1 = worksheet1.Table.Rows.Add();
worksheetRow1.Cells.Add("N (seq)");
worksheetRow1.Cells.Add("X (input)");
worksheetRow1.Cells.Add("(Xi - Xavg)^2");
WorksheetStyle style33 = workbook.Styles.Add("s31");
style33.Font.FontName = "Cordia New";
style33.Font.Size = 14;
style33.Font.Bold = false;
style33.Interior.Pattern = StyleInteriorPattern.Solid;
style33.Borders.Add(StylePosition.Bottom, LineStyleOption.Continuous, 1);
style33.Borders.Add(StylePosition.Left, LineStyleOption.Continuous, 1);
style33.Borders.Add(StylePosition.Right, LineStyleOption.Continuous, 1);
style33.Borders.Add(StylePosition.Top, LineStyleOption.Continuous, 1);
WorksheetStyle style = workbook.Styles.Add("s32");
style.Font.FontName = "Cordia New";
style.Font.Size = 14;
style.Font.Bold = false;
style.NumberFormat = "#,###,##0";
WorksheetCell worksheetCell = null;
foreach (DeviationEntity dnEntity in lstDeviation.ListDeviationEntity)
{
worksheetRow1 = worksheet1.Table.Rows.Add();
worksheetCell = new WorksheetCell(dnEntity.NumSeq.ToString(), DataType.Number, "s31");
worksheetRow1.Cells.Add(worksheetCell);
worksheetCell = new WorksheetCell(dnEntity.NumX.ToString(), DataType.Number, "s31");
worksheetRow1.Cells.Add(worksheetCell);
worksheetCell = new WorksheetCell(dnEntity.NumDeviation.ToString(), DataType.Number, "s31");
worksheetRow1.Cells.Add(worksheetCell);
}
worksheetRow1 = worksheet1.Table.Rows.Add();
worksheetCell = new WorksheetCell("Result Summary", DataType.String, "s31");
worksheetRow1.Cells.Add(worksheetCell);
worksheetCell = new WorksheetCell("Sum (X) : " + lstDeviation.SumX, DataType.String, "s31");
worksheetRow1.Cells.Add(worksheetCell);
worksheetCell = new WorksheetCell("Sum (Deviation) : " + lstDeviation.SumDeviation, DataType.String, "s31");
worksheetRow1.Cells.Add(worksheetCell);
worksheetRow1 = worksheet1.Table.Rows.Add();
worksheetCell = new WorksheetCell("", DataType.String, "s31");
worksheetRow1.Cells.Add(worksheetCell);
worksheetCell = new WorksheetCell("Result Power Deviation", DataType.String, "s31");
worksheetRow1.Cells.Add(worksheetCell);
worksheetCell = new WorksheetCell(lstDeviation.DeviationPow1.ToString(), DataType.Number, "s31");
worksheetRow1.Cells.Add(worksheetCell);
workbook.Save(OutputFileName);
Process.Start(OutputFileName);
Console.WriteLine("Please Enter Finish Program (Y/N)");
Console.Read();
}
