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);
}