private void Generate_Business_Case

private void Generate_Business_Case_Worksheet()

in src/Excel/ExportCoreReport.cs [135:233]
86 lines of code
3 McCabe index (conditional complexity)

        private void Generate_Business_Case_Worksheet()
        {
            var dataWs = CoreWb.Worksheets.Add(CoreReportConstants.Business_Case_TabName, 2);

            UtilityFunctions.AddColumnHeadersToWorksheet(dataWs, CoreReportConstants.Business_Case_Columns);
            for (int i = 0; i < CoreReportConstants.Business_Case_RowTypes.Count; i++)
                dataWs.Cell(i + 2, 1).Value = CoreReportConstants.Business_Case_RowTypes[i];

            if (Business_Case_Data == null)
                return;

            dataWs.Cell(2, 2).Value = Business_Case_Data.OnPremisesIaaSCost.ComputeLicenseCost;
            dataWs.Cell(3, 2).Value = Business_Case_Data.OnPremisesIaaSCost.EsuLicenseCost;
            dataWs.Cell(4, 2).Value = Business_Case_Data.OnPremisesIaaSCost.StorageCost;
            dataWs.Cell(5, 2).Value = Business_Case_Data.OnPremisesIaaSCost.NetworkCost;
            dataWs.Cell(6, 2).Value = Business_Case_Data.OnPremisesIaaSCost.SecurityCost;
            dataWs.Cell(7, 2).Value = Business_Case_Data.OnPremisesIaaSCost.ITStaffCost;
            dataWs.Cell(8, 2).Value = Business_Case_Data.OnPremisesIaaSCost.FacilitiesCost;

            dataWs.Cell(2, 3).Value = Business_Case_Data.OnPremisesPaaSCost.ComputeLicenseCost;
            dataWs.Cell(3, 3).Value = Business_Case_Data.OnPremisesPaaSCost.EsuLicenseCost;
            dataWs.Cell(4, 3).Value = Business_Case_Data.OnPremisesPaaSCost.StorageCost;
            dataWs.Cell(5, 3).Value = Business_Case_Data.OnPremisesPaaSCost.NetworkCost;
            dataWs.Cell(6, 3).Value = Business_Case_Data.OnPremisesPaaSCost.SecurityCost;
            dataWs.Cell(7, 3).Value = Business_Case_Data.OnPremisesPaaSCost.ITStaffCost;
            dataWs.Cell(8, 3).Value = Business_Case_Data.OnPremisesPaaSCost.FacilitiesCost;

            dataWs.Cell(2, 4).Value = Business_Case_Data.OnPremisesAvsCost.ComputeLicenseCost;
            dataWs.Cell(3, 4).Value = Business_Case_Data.OnPremisesAvsCost.EsuLicenseCost;
            dataWs.Cell(4, 4).Value = Business_Case_Data.OnPremisesAvsCost.StorageCost;
            dataWs.Cell(5, 4).Value = Business_Case_Data.OnPremisesAvsCost.NetworkCost;
            dataWs.Cell(6, 4).Value = Business_Case_Data.OnPremisesAvsCost.SecurityCost;
            dataWs.Cell(7, 4).Value = Business_Case_Data.OnPremisesAvsCost.ITStaffCost;
            dataWs.Cell(8, 4).Value = Business_Case_Data.OnPremisesAvsCost.FacilitiesCost;

            dataWs.Cell(2, 5).Value = Business_Case_Data.TotalOnPremisesCost.ComputeLicenseCost;
            dataWs.Cell(3, 5).Value = Business_Case_Data.TotalOnPremisesCost.EsuLicenseCost;
            dataWs.Cell(4, 5).Value = Business_Case_Data.TotalOnPremisesCost.StorageCost;
            dataWs.Cell(5, 5).Value = Business_Case_Data.TotalOnPremisesCost.NetworkCost;
            dataWs.Cell(6, 5).Value = Business_Case_Data.TotalOnPremisesCost.SecurityCost;
            dataWs.Cell(7, 5).Value = Business_Case_Data.TotalOnPremisesCost.ITStaffCost;
            dataWs.Cell(8, 5).Value = Business_Case_Data.TotalOnPremisesCost.FacilitiesCost;

            dataWs.Cell(2, 6).Value = Business_Case_Data.AzureIaaSCost.ComputeLicenseCost;
            dataWs.Cell(3, 6).Value = Business_Case_Data.AzureIaaSCost.EsuLicenseCost;
            dataWs.Cell(4, 6).Value = Business_Case_Data.AzureIaaSCost.StorageCost;
            dataWs.Cell(5, 6).Value = Business_Case_Data.AzureIaaSCost.NetworkCost;
            dataWs.Cell(6, 6).Value = Business_Case_Data.AzureIaaSCost.SecurityCost;
            dataWs.Cell(7, 6).Value = Business_Case_Data.AzureIaaSCost.ITStaffCost;
            dataWs.Cell(8, 6).Value = Business_Case_Data.AzureIaaSCost.FacilitiesCost;

            dataWs.Cell(2, 7).Value = Business_Case_Data.AzurePaaSCost.ComputeLicenseCost;
            dataWs.Cell(3, 7).Value = Business_Case_Data.AzurePaaSCost.EsuLicenseCost;
            dataWs.Cell(4, 7).Value = Business_Case_Data.AzurePaaSCost.StorageCost;
            dataWs.Cell(5, 7).Value = Business_Case_Data.AzurePaaSCost.NetworkCost;
            dataWs.Cell(6, 7).Value = Business_Case_Data.AzurePaaSCost.SecurityCost;
            dataWs.Cell(7, 7).Value = Business_Case_Data.AzurePaaSCost.ITStaffCost;
            dataWs.Cell(8, 7).Value = Business_Case_Data.AzurePaaSCost.FacilitiesCost;

            dataWs.Cell(2, 8).Value = Business_Case_Data.AzureAvsCost.ComputeLicenseCost;
            dataWs.Cell(3, 8).Value = Business_Case_Data.AzureAvsCost.EsuLicenseCost;
            dataWs.Cell(4, 8).Value = Business_Case_Data.AzureAvsCost.StorageCost;
            dataWs.Cell(5, 8).Value = Business_Case_Data.AzureAvsCost.NetworkCost;
            dataWs.Cell(6, 8).Value = Business_Case_Data.AzureAvsCost.SecurityCost;
            dataWs.Cell(7, 8).Value = Business_Case_Data.AzureAvsCost.ITStaffCost;
            dataWs.Cell(8, 8).Value = Business_Case_Data.AzureAvsCost.FacilitiesCost;

            dataWs.Cell(2, 9).Value = Business_Case_Data.TotalAzureCost.ComputeLicenseCost;
            dataWs.Cell(3, 9).Value = Business_Case_Data.TotalAzureCost.EsuLicenseCost;
            dataWs.Cell(4, 9).Value = Business_Case_Data.TotalAzureCost.StorageCost;
            dataWs.Cell(5, 9).Value = Business_Case_Data.TotalAzureCost.NetworkCost;
            dataWs.Cell(6, 9).Value = Business_Case_Data.TotalAzureCost.SecurityCost;
            dataWs.Cell(7, 9).Value = Business_Case_Data.TotalAzureCost.ITStaffCost;
            dataWs.Cell(8, 9).Value = Business_Case_Data.TotalAzureCost.FacilitiesCost;

            dataWs.Cell(2, 10).Value = Business_Case_Data.WindowsServerLicense.ComputeLicenseCost;
            dataWs.Cell(3, 10).Value = 0.00;
            dataWs.Cell(4, 10).Value = 0.00;
            dataWs.Cell(5, 10).Value = 0.00;
            dataWs.Cell(6, 10).Value = 0.00;
            dataWs.Cell(7, 10).Value = 0.00;
            dataWs.Cell(8, 10).Value = 0.00;

            dataWs.Cell(2, 11).Value = Business_Case_Data.SqlServerLicense.ComputeLicenseCost;
            dataWs.Cell(3, 11).Value = 0.00;
            dataWs.Cell(4, 11).Value = 0.00;
            dataWs.Cell(5, 11).Value = 0.00;
            dataWs.Cell(6, 11).Value = 0.00;
            dataWs.Cell(7, 11).Value = 0.00;
            dataWs.Cell(8, 11).Value = 0.00;

            dataWs.Cell(2, 12).Value = Business_Case_Data.EsuSavings.ComputeLicenseCost;
            dataWs.Cell(3, 12).Value = 0.00;
            dataWs.Cell(4, 12).Value = 0.00;
            dataWs.Cell(5, 12).Value = 0.00;
            dataWs.Cell(6, 12).Value = 0.00;
            dataWs.Cell(7, 12).Value = 0.00;
            dataWs.Cell(8, 12).Value = 0.00;
        }