public void ApplyAnalysisToSingleLaunch(IExcelSheet sheet, int currentRow,
int operationNumber)
{
string normalizedFormula = ManualFormulaProvider.Normalize(
$"$A{currentRow.ToString()}", "$M$6", "$M$7"
);
sheet[ExcelColumnIndex.B, currentRow].SetFormula(normalizedFormula);
}
public void ApplyAnalysisToSingleLaunch(IExcelSheet sheet, ExcelColumnIndex currentColumn,
int currentRow, int operationNumber)
{
string dataAddress = sheet[currentColumn, currentRow].Address;
int theoreticalDataRow = currentColumn.AsInt32().UseOneBasedIndexing().SkipHeader();
string theoreticalMinAddress = sheet[_theoreticalMinColumn, theoreticalDataRow].Address;
string theoreticalMaxAddress = sheet[_theoreticalMaxColumn, theoreticalDataRow].Address;
string normalizedFormula = ManualFormulaProvider.Normalize(
dataAddress, theoreticalMinAddress, theoreticalMaxAddress
);
int normalizedDataRowIndex = ExcelWrapperForPhaseTwo.GetNormalizedDataRowIndex(
_args, currentRow
);
sheet[currentColumn, normalizedDataRowIndex].SetFormula(normalizedFormula);
}