private static void createSafetyColumns(Excel.Worksheet xlWorksheet, TbiComponent c, int index)
{
if (c.energy && c.is_hot)
{
xlWorksheet.Range[$"H{index}"].Value = "Hot surface";
}
c.reports.Where(r => !r.energy)
.ToList()
.ForEach(r =>
{
var spacer = string.IsNullOrEmpty(xlWorksheet.Range[$"H{index}"].Value) ? "" : "\n";
xlWorksheet.Range[$"H{index}"].Value += $"{spacer}{r.name}";
});
}
private static void createEnergyColumns(Excel.Worksheet xlWorksheet, TbiComponent component, int index)
{
if (!component.energy)
{
xlWorksheet.Range[$"B{index}:G{index + 2}"].Merge();
xlWorksheet.Range[$"B{index}"].Value = "Not considered >";
xlWorksheet.Range[$"B{index}"].HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
}
else
{
var sufix = component.fields.unknow_surface ? "/m2" : "";
xlWorksheet.Range[$"B{index}"].Value = component.result.headLost.power / 100;
xlWorksheet.Range[$"B{index + 1}"].Value = component.result.headLost.money;
xlWorksheet.Range[$"B{index + 1}"].NumberFormat = "0";
xlWorksheet.Range[$"B{index + 2}"].Value = component.result.co2[0];
//xlWorksheet.Range[$"C{index}"].Value = $"MWh{sufix}";
//xlWorksheet.Range[$"C{index + 1}"].Value = $"{component.project.currency}{sufix}";
//xlWorksheet.Range[$"C{index + 2}"].Value = $"tn CO2{sufix}";
xlWorksheet.Range[$"D{index}"].Value = component.result.savingPotentialMin.power / 100;
xlWorksheet.Range[$"D{index + 1}"].Value = component.result.savingPotentialMin.money;
xlWorksheet.Range[$"D{index + 1}"].NumberFormat = "0";
xlWorksheet.Range[$"D{index + 2}"].Value = component.result.co2[1];
xlWorksheet.Range[$"E{index}"].Value = xlWorksheet.Range[$"E{index + 1}"].Value = xlWorksheet.Range[$"E{index + 2}"].Value = "-";
xlWorksheet.Range[$"F{index}"].Value = component.result.savingPotentialMax.power / 100;
xlWorksheet.Range[$"F{index + 1}"].Value = component.result.savingPotentialMax.money;
xlWorksheet.Range[$"F{index + 1}"].NumberFormat = "0";
xlWorksheet.Range[$"F{index + 2}"].Value = component.result.co2[2];
xlWorksheet.Range[$"G{index}"].Value = $"MWh{sufix}";
xlWorksheet.Range[$"G{index + 1}"].Value = $"{component.project.currency}{sufix}";
xlWorksheet.Range[$"G{index + 2}"].Value = $"tn CO2{sufix}";
xlWorksheet.Range[$"B{index}:G{index}"].Interior.Color = xlWorksheet.Range[$"B{index + 2}:G{index + 2}"].Interior.Color = Color.FromArgb(242, 242, 242);
xlWorksheet.Range[$"B{index}:G{index + 2}"].Font.Color = component.fields.unknow_surface ? Color.Gray : Color.Black;
}
}
