private void AddDetailsForNonNHSCountAndArea(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, int totalBridgeCountOrDeckAreaStartRow, int nHSBridgeCountOrDeckAreaStartRow, bool isDeckArea) { int startRow, startColumn, row, column; bridgeWorkSummaryCommon.InitializeLabelCells(worksheet, currentCell, out startRow, out startColumn, out row, out column); for (var index = 0; index <= simulationYears.Count; index++) { var bridgeGood = Convert.ToDouble(worksheet.Cells[totalBridgeCountOrDeckAreaStartRow + 1, column].Value); var bridgeFair = Convert.ToDouble(worksheet.Cells[totalBridgeCountOrDeckAreaStartRow + 2, column].Value); var bridgePoor = Convert.ToDouble(worksheet.Cells[totalBridgeCountOrDeckAreaStartRow + 3, column].Value); var NHSGood = Convert.ToDouble(worksheet.Cells[nHSBridgeCountOrDeckAreaStartRow + 1, column].Value); var NHSFair = Convert.ToDouble(worksheet.Cells[nHSBridgeCountOrDeckAreaStartRow + 2, column].Value); var NHSPoor = Convert.ToDouble(worksheet.Cells[nHSBridgeCountOrDeckAreaStartRow + 3, column].Value); var nonNHSGood = bridgeGood - NHSGood; var nonNHSFair = bridgeFair - NHSFair; var nonNHSPoor = bridgePoor - NHSPoor; worksheet.Cells[startRow, column].Value = nonNHSGood; worksheet.Cells[startRow + 1, column].Value = nonNHSFair; worksheet.Cells[startRow + 2, column].Value = nonNHSPoor; column++; } excelHelper.ApplyBorder(worksheet.Cells[startRow, startColumn, row, column - 1]); excelHelper.SetCustomFormat(worksheet.Cells[startRow, startColumn + 1, row, column - 1], "Number"); //if (isDeckArea) //{ // excelHelper.ApplyColor(worksheet.Cells[row - 1, startColumn + 1, row - 1, column - 1], Color.Khaki); //} bridgeWorkSummaryCommon.UpdateCurrentCell(currentCell, row + 1, column); }
private void AddDetailsForTotalDeckArea(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, List <SimulationDataModel> simulationDataModels) { int startRow, startColumn, row, column; bridgeWorkSummaryCommon.InitializeLabelCells(worksheet, currentCell, out startRow, out startColumn, out row, out column); AddTotalDeckArea(worksheet, simulationDataModels, startRow, column, 0); foreach (var year in simulationYears) { row = startRow; column = ++column; AddTotalDeckArea(worksheet, simulationDataModels, row, column, year); } excelHelper.ApplyBorder(worksheet.Cells[startRow, startColumn, row + 2, column]); excelHelper.SetCustomFormat(worksheet.Cells[startRow, startColumn + 1, row + 2, column], "Number"); excelHelper.ApplyColor(worksheet.Cells[row + 2, startColumn + 1, row + 2, column], Color.Khaki); bridgeWorkSummaryCommon.UpdateCurrentCell(currentCell, row + 3, column); }
private void AddDetailsForTotalBridgeAndDeckPercent(ExcelWorksheet worksheet, CurrentCell currentCell, List <int> simulationYears, int dataStartRow) { int startRow, startColumn, row, column; bridgeWorkSummaryCommon.InitializeLabelCells(worksheet, currentCell, out startRow, out startColumn, out row, out column); for (var index = 0; index <= simulationYears.Count; index++) { var sumFormula = "SUM(" + worksheet.Cells[dataStartRow, column, dataStartRow + 2, column] + ")"; worksheet.Cells[startRow, column].Formula = worksheet.Cells[dataStartRow, column] + "/" + sumFormula; worksheet.Cells[startRow + 1, column].Formula = worksheet.Cells[dataStartRow + 1, column] + "/" + sumFormula; worksheet.Cells[startRow + 2, column].Formula = worksheet.Cells[dataStartRow + 2, column] + "/" + sumFormula; column++; } excelHelper.ApplyBorder(worksheet.Cells[startRow, startColumn, startRow + 2, column - 1]); excelHelper.SetCustomFormat(worksheet.Cells[startRow, startColumn + 1, startRow + 2, column], "Percentage"); bridgeWorkSummaryCommon.UpdateCurrentCell(currentCell, row, column - 1); }