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