void t_CompareRpt_Funding_Funding2008_UpdateSolvency(string sOutputFunding_Funding2008_UpdateSolvency)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("CA004DNT", sOutputFunding_Funding2008_UpdateSolvency_Prod, sOutputFunding_Funding2008_UpdateSolvency);
_compareReportsLib._Report(_PassFailStep.Description, "", "Funding_Funding2008_UpdateSolvency");
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_Windup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenarioByPlanDef_Windup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenarioByPlanDef_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenarioByPlanDef_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FundingCalculatorScenario.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection_Wind-Up.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_Windup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_Windup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsByPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FundingCalculator.xlsx", 0, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("SpecialPaymentCalculation.xlsx", 0, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_PlanTerminationSetup_ForBaseline(string sPlanTerminationSetup_ForBaseline)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US012DNT", sPlanTerminationSetup_ForBaseline_Prod, sPlanTerminationSetup_ForBaseline);
_compareReportsLib._Report(_PassFailStep.Description, "", "Funding_sPlanTerminationSetup_ForBaseline");
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_FAS35PVAB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_FAS35PVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PBGCNARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselineByPlanDef_FAS35PVAB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselineByPlanDef_FAS35PVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselineByPlanDef_PBGCNARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselineByPlanDef_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselineByPlanDef_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselineByPlanDef_PPANARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Valuation2014_Baseline(string sOutputFunding_Valuation2014_Baseline)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("UK003CN", sOutputFunding_Valuation2014_Baseline_Prod, sOutputFunding_Valuation2014_Baseline);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_Valuation2014_Baseline");
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_Funding.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPFS179.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_AltFund1.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_AltFund2.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_AltFund3.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultswithBenTypesplits.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_MovementAndRollforward.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_OutlierSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_CheckingGroupStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-BenefitCashflows.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-OtherInfo.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Funding_Funding2008_Baseline(string sOutputFunding_Funding2008_Baseline)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("CA004DNT", sOutputFunding_Funding2008_Baseline_Prod, sOutputFunding_Funding2008_Baseline);
_compareReportsLib._Report(_PassFailStep.Description, "", "Funding_Funding2008_Baseline");
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DecrementAge.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossParticipantListing.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection_GoingConcern.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void t_CompareRpt_Stichtag2011_Teriferhoehung(string sOutputPension_Stichtag2011_Teriferhoehung)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("DE007DNT", sOutputPension_Stichtag2011_Teriferhoehung_Prod, sOutputPension_Stichtag2011_Teriferhoehung);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputPension_Stichtag2011_Teriferhoehung");
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] {
}, new string[1] {
"Tabellenblatt2"
});
_compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] {
}, new string[1] {
"Tabellenblatt3"
});
_compareReportsLib.CompareExcel_Exact("ValuationSummary_DirectPromise.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection_ReportBreak.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport_ALL.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts_ALL.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Funding_US004(string sOutputUS004)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US001Cloud", sOutputUS004_Cloud, sOutputUS004);
_compareReportsLib._Report(_PassFailStep.Description, "", "US004");
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_FAS35PVAB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_FAS35PVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PBGCNARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_FAS35PVAB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_FAS35PVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PBGCNARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPANARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void t_CompareRpt_Fnd2012RF_FndChld1(string sOutputFunding_Fnd2012RF_FndChld1)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("NL001DNT", sOutputFunding_Fnd2012RF_FndChld1_Prod, sOutputFunding_Fnd2012RF_FndChld1);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_Fnd2012RF_FndChld1");
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariowithBreaks_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariowithBreaks_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDefwithBreaks_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDefwithBreaks_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinewithBreaks_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinewithBreaks_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDefwithBreaks_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDefwithBreaks_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultswithBreaks.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDefwithBreaks.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void t_CompareRpt_Fnd2012RF_Baseline(string sOutputFunding_Fnd2012RF_Baseline)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("NL001DNT", sOutputFunding_Fnd2012RF_Baseline_Prod, sOutputFunding_Fnd2012RF_Baseline);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_Fnd2012RF_Baseline");
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearwithBreaks_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearwithBreaks_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDefwithBreaks_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDefwithBreaks_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultswithBreaks.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDefwithBreaks.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_CheckingGroupStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_MovementAndRollforward.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_OutlierSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
////////// _compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Jubilee_Valuation2012_V67Enhancements(string sOutputJubilee_Valuation2012_V67Enhancements)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("DE010DNT_2", sOutputJubilee_Valuation2012_V67Enhancements_Prod, sOutputJubilee_Valuation2012_V67Enhancements);
_compareReportsLib._Report(_PassFailStep.Description, "", "sJubileeValuation201_V67Enhancements");
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary_Sub1_F.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary_Sub1_M.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary_Sub2_F.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary_Sub2_M.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary_Sub3_F.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary_Sub3_M.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsByPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport_Sub1_F.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport_Sub1_M.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport_Sub2_F.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport_Sub2_M.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport_Sub3_F.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport_Sub3_M.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Accounting2017(string sAccounting2017)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US019DNT", sAccounting2017_Prod, sAccounting2017);
_compareReportsLib._Report(_PassFailStep.Description, "", "sAccounting2017");
_compareReportsLib.CompareExcel_Exact("FutureValuationPopulationProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2017.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2018.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2019.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2020.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2021.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2022.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2023.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2024.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2025.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2026.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2027.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2032.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2037.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyGroup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Funding2018_FutureValRun(string sFunding2018_FutureValRun)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US019CN", sFunding2018_FutureValRun_Prod, sFunding2018_FutureValRun);
_compareReportsLib._Report(_PassFailStep.Description, "", "sFunding2018_FutureValRun");
_compareReportsLib.CompareExcel_Exact("FutureValuationPopulationProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2018.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2019.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2020.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2021.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2022.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2023.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2024.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2025.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2026.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2027.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2028.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2033.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2038.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyGroup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void t_CompareRpt_Valuation2009_WithAltFunding(string sOutputFunding_Valuation2009_WithAltFunding)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("UK006DNT", sOutputFunding_Valuation2009_WithAltFunding_Prod, sOutputFunding_Valuation2009_WithAltFunding);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_Valuation2009_WithAltFunding");
_compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_Funding.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_AltFund1.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_AltFund2.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_AltFund3.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_PPFS179.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-BenefitCashflows.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-OtherInfo.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_Funding.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_AltFund1.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_AltFund2.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_AltFund3.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultswithBenTypesplits.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Accounting_July2006FASVal(string sOutputAccounting_July2006FASVal)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US010DNT", sOutputAccounting_July2006FASVal_Prod, sOutputAccounting_July2006FASVal);
_compareReportsLib._Report(_PassFailStep.Description, "", "Accounting_July2006FASVal");
_compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySummary_ActiveMembers.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySummary_DeferredMembers.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySummary_Pensioners.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByNone.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByStatusCodes.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByCustom_Gender.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("TestCaseList.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Funding_Funding2011_NewValuation(string sOutputFunding_Funding2011_NewValuation)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("CA001DNT", sOutputFunding_Funding2011_NewValuation_Prod, sOutputFunding_Funding2011_NewValuation);
_compareReportsLib._Report(_PassFailStep.Description, "", "Funding_Funding2011_NewValuation");
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_Windup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenarioByPlanDef_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenarioByPlanDef_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenarioByPlanDef_Windup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection_Wind-Up.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToBaseline_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToBaseline_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToBaseline_Windup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToBaselineByPlanDef_Windup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void t_CompareRpt_Valuation2009_Baseline(string sOutputFunding_Valuation2009_Baseline)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("UK006DNT", sOutputFunding_Valuation2009_Baseline_Prod, sOutputFunding_Valuation2009_Baseline);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_Valuation2009_Baseline");
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_Funding.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPFS179.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultswithBenTypesplits.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_MovementAndRollforward.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_OutlierSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_CheckingGroupStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_Funding.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_Funding.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DecrementAge.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossParticipantListing.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-BenefitCashflows.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-OtherInfo.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void t_CompareRpt_Conversion2010(string sOutputPension_Conversion2010)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("DE007DNT", sOutputPension_Conversion2010_Prod, sOutputPension_Conversion2010);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputPension_Conversion2010");
_compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics_DriectPromise.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] {
}, new string[1] {
"Tabellenblatt2"
});
_compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] {
}, new string[1] {
"Tabellenblatt3"
});
_compareReportsLib.CompareExcel_Exact("ValuationSummary_DriectPromise.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
//////////_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection_ReportBreak.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void t_CompareRpt_Conversion2009(string sOutputPension_Conversion2009)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("DE008DNT", sOutputPension_Conversion2009_Prod, sOutputPension_Conversion2009);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputPension_Conversion2009");
_compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics_IDEXEuropeGmbH_KugelfischerPlan.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics_LukasHydraulikGmbH_KugelfischerPlan.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics_LukasHydraulikGmbH_VersorgungskapitalPlan.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] {
}, new string[1] {
"Tabellenblatt2"
});
_compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] {
}, new string[1] {
"Tabellenblatt3"
});
_compareReportsLib.CompareExcel_Exact("ValuationSummary_IDEXEuropeGmbH_KugelfischerPlan.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary_LukasHydraulikGmbH_KugelfischerPlan.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary_LukasHydraulikGmbH_VersorgungskapitalPlan.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
//////////_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection_ReportBreak.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void t_CompareRpt_FASValuation2010_Baseline(string sOutputAccounting_FASValuation2010_Baseline)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("IR001DNT", sOutputAccounting_FASValuation2010_Baseline_Prod, sOutputAccounting_FASValuation2010_Baseline);
_compareReportsLib._Report(_PassFailStep.Description, "", "Accounting_Accounting2010_Baseline");
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PBO.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_ABO.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PBO.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_ABO.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Funding_valJuly2019_UpdateProvisions(string sOutputFunding_valJuly2019_UpdateProvisions)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US011DNT", sOutputFunding_valJuly2019_UpdateProvisions_Prod, sOutputFunding_valJuly2019_UpdateProvisions);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_valJuly2019_UpdateProvisions");
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_FAS35PVAB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_FAS35PVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PBGCARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PBGCNARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPAARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPAARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPAARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_PPANARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_FAS35PVAB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_FAS35PVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PBGCARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PBGCNARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPAARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPAARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPAARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_PPANARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_FAS35PVAB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_FAS35PVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_PBGCNARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_PPANARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_PBGCARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_PPAARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_PPAARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenario_PPAARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_FAS35PVAB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_FAS35PVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_PBGCNARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_PPANARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_PBGCARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_PPAARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_PPAARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilityScenariobyPlanDef_PPAARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ASC960Reconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FundingCalculatorScenario.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void test_UK004_DNT()
{
this.GenerateReportOuputDir();
pMain._EnterpriseRun("Group Job Successfully Complete", true);
pMain._SelectTab("Valuation June 2008");
dic.Clear();
dic.Add("iMaxRowNum", "");
dic.Add("iMaxColNum", "");
dic.Add("iSelectRowNum", "1");
dic.Add("iSelectColNum", "1");
dic.Add("MenuItem_1", "View Output");
pMain._FlowTreeRightSelect(dic);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_ValuationJune2008, "Parameter Print", "Conversion", true, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_ValuationJune2008, "Test Cases", "Conversion", true, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_ValuationJune2008, "Liability Summary", "Conversion", false, true);
pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_ValuationJune2008, "Member Statistics", "Conversion", false, true);
pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputFunding_ValuationJune2008, "Conversion Diagnostic", "Conversion", false, true, 0);
pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_ValuationJune2008, "Detailed Results", "Conversion", false, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_ValuationJune2008, "Detailed Results with Ben Type splits", "Conversion", false, true);
pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_ValuationJune2008, "Valuation Summary", "Conversion", false, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_ValuationJune2008, "Individual Output", "Conversion", false, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_ValuationJune2008, "IOE", "Conversion", false, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_ValuationJune2008, "Payout Projection - Benefit Cashflows", "Conversion", false, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_ValuationJune2008, "Payout Projection - Other Info", "Conversion", false, true);
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("UK004DNT", sOutputFunding_ValuationJune2008_Prod, sOutputFunding_ValuationJune2008);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_ValuationJune2008");
_compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByNone.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByStatusCodes.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByCustom_Gender.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("DetailedResultswithBenTypesplits.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-BenefitCashflows.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-OtherInfo.xlsx", 4, 0, 0, 0, true);
}
pMain._SelectTab("Valuation June 2008");
pMain._Home_ToolbarClick_Top(true);
pMain._Home_ToolbarClick_Top(false);
_gLib._MsgBox("Congratulations!", "Finished!");
}
public void t_CompareRpt_Valuation2011_Baseline(string sOutputFunding_Valuation2011_Baseline)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US015CN", sOutputFunding_Valuation2011_Baseline_Prod, sOutputFunding_Valuation2011_Baseline);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_Valuation2011_Baseline");
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationToPriorYearByPlanDef_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_MovementAndRollforward.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_OutlierSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_CheckingGroupStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DecrementAge.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossParticipantListing_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPopulationProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 12, new string[1] {
"Sheet2"
});
_compareReportsLib.CompareExcel_Exact("FutureValuationSummary.xlsx", 4, new string[1] {
"Sheet1"
});
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2011.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2012.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2013.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2014.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2015.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2016.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2021.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationPayouts_2031.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyGroup.xlsx", 12, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 12, new string[1] {
"Sheet2"
});
_compareReportsLib.CompareExcel_Exact("FutureValuationLiabilitiesbyYear.xlsx", 4, new string[1] {
"Sheet1"
});
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Plan2_conversion2016_CopyofPFVS(string sOutputPlan2_conversion2016_CopyofPFVS)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US017DNT", sOutputPlan2_conversion2016_CopyofPFVS_Prod, sOutputPlan2_conversion2016_CopyofPFVS);
_compareReportsLib._Report(_PassFailStep.Description, "", "Plan2_conversion2016_CopyofPFV");
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_PlanTerminationSetup_PBGC_4044(string sPlanTerminationSetup_PBGC_4044)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US012DNT", sPlanTerminationSetup_PBGC_4044_Prod, sPlanTerminationSetup_PBGC_4044);
_compareReportsLib._Report(_PassFailStep.Description, "", "sPlanTerminationSetup_PBGC_4044");
_compareReportsLib.CompareExcel_Exact("PBGC4044LiabilitiesbyPlanDef.xlsx", 7, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Funding_Val2014_Baseline(string sFunding_Val2014_Baseline)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US016DNT", sOutputFunding_Val2014_Baseline_Prod, sOutputFunding_Val2014_Baseline);
_compareReportsLib._Report(_PassFailStep.Description, "", "sFunding_Val2014_Baseline");
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_FAS35PVAB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_FAS35PVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PBGCARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PBGCNARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPAARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPAARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPAARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_PPANARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_FAS35PVAB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_FAS35PVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PBGCARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PBGCNARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PPAARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PPAARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PPAARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_PPANARPVVB.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultsByPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_CheckingGroupStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_MovementAndRollforward.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_OutlierSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("AgeServiceMatrix.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DataMatchingSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("CombinedStatusCodeSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossSummaryofLiabilityReconciliation_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ActiveDecrementGainLossDetail_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DecrementAge.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossParticipantListing_PPANARMax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossParticipantListing_PPANARMin.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GainLossStatusReconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void t_CompareRpt_Jubilee2009_Baseline(string sOutputJubilee_Jubilee2009_Baseline)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("DE001DNT", sOutputJubilee_Jubilee2009_Baseline_Prod, sOutputJubilee_Jubilee2009_Baseline);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputJubilee_Jubilee2009_Baseline");
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_Tax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_Trade.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_IntlAccountingPBO.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYear_IntlAccountingABO.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_Tax.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_Trade.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_IntlAccountingPBO.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoPriorYearbyPlanDef_IntlAccountingABO.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics_LargerGroup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics_SmallerGroup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("StatusReconciliation.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_MovementAndRollforward_Jub1.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_OutlierSummary_Jub1.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualCheckingTemplate_CheckingGroupStatistics_Jub1.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] {
}, new string[1] {
"Tabellenblatt2"
});
_compareReportsLib.CompareExcel_Exact("ValuationSummaryforExcelExport.xlsx", 0, new int[0, 0] {
}, new string[1] {
"Tabellenblatt3"
});
_compareReportsLib.CompareExcel_Exact("ValuationSummary_LargerGroup.xlsx", 16, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary_SmallerGroup.xlsx", 16, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
//////////_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection_ReportBreak.xlsx", 4, 0, 0, 0);
//////////////_compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts.xlsx", 4, 0, 0, 0);
//////////////_compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts_LargerGroup.xlsx", 4, 0, 0, 0);
//////////////_compareReportsLib.CompareExcel_Exact("FASExpectedBenefitPmts_SmallerGroup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport_LargerGroup.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitySetforGlobeExport_SmallerGroup.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
void t_CompareRpt_Plan1_NDT2017_DCOnly(string sOutputPlan1_NDT2017_DCOnly)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US017_DNT", sOutputPlan1_NDT2017_DCOnly_Prod, sOutputPlan1_NDT2017_DCOnly);
_compareReportsLib._Report(_PassFailStep.Description, "", "Plan1_NDT2017_DCOnly");
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 0, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("CoverageTest.xlsx", 0, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GeneralTest_GeneralTestSummary.xlsx", 0, 0, 0, 0, false);
_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentTestingforEachHCE.xlsx", 0, 0, 0, 0, false);
_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentTestingAccrualRates.xlsx", 0, 0, 0, 0, false);
Config.bThreadFinsihed = true;
}
}
public void test_UK001_DNT()
{
this.GenerateReportOuputDir();
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBM001, "Parameter Print", "Conversion", true, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBM001, "Test Cases", "Conversion", true, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBM001, "Liability Summary", "Conversion", false, true);
pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBM001, "Member Statistics", "Conversion", false, true);
pOutputManager._ExportReport_DrillDown_PDF_EXCEL(sOutputFunding_QAUKBM001, "Conversion Diagnostic", "Conversion", false, true, 0);
pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBM001, "Detailed Results", "Conversion", false, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBM001, "Detailed Results with Ben Type splits", "Conversion", false, true);
pOutputManager._ExportReport_Common_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBM001, "Valuation Summary", "Conversion", false, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBM001, "Individual Output", "Conversion", false, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBM001, "IOE", "Conversion", false, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBM001, "Payout Projection - Benefit Cashflows", "Conversion", false, true);
pOutputManager._ExportReport_Others_PDF_EXCEL(Config.eCountry, sOutputFunding_QAUKBM001, "Payout Projection - Other Info", "Conversion", false, true);
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("UK001DNT", sOutputFunding_QAUKBM001_Prod, sOutputFunding_QAUKBM001);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_QAUKBM001");
_compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByNone.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByStatusCodes.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByCustom_Gender.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("DetailedResultswithBenTypesplits.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-BenefitCashflows.xlsx", 4, 0, 0, 0, true);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-OtherInfo.xlsx", 4, 0, 0, 0, true);
}
pMain._SelectTab("QA UK BM 001");
pMain._Home_ToolbarClick_Top(true);
pMain._Home_ToolbarClick_Top(false);
_gLib._MsgBox("Congratulations!", "Finished!");
}
void t_CompareRpt_Plan2_update2016_NDT(string sOutputPlan2_update2016_NDT)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("US017DNT", sOutputPlan2_update2016_NDT_Prod, sOutputPlan2_update2016_NDT);
_compareReportsLib._Report(_PassFailStep.Description, "", "Plan2_update2016_NDT");
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 0, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("CoverageTest.xlsx", 0, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GeneralTest_GeneralTestSummary.xlsx", 0, 0, 0, 0);
////_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentTestingforEachHCE.xlsx", 0, 0, 0, 0);
////_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentAndPriorTestingforEachHCE.xlsx", 0, 0, 0, 0);
////_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentPriorAndFutureTestingforEachHCE.xlsx", 0, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentTestingAccrualRates.xlsx", 0, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentAndPriorTestingAccrualRates.xlsx", 0, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("GeneralTest_CurrentPriorAndFutureTestingAccrualRates.xlsx", 0, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void t_CompareRpt_Valuation2009_AttainedAge(string sOutputFunding_Valuation2009_AttainedAge)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("IR001DNT", sOutputFunding_Valuation2009_AttainedAge_Prod, sOutputFunding_Valuation2009_AttainedAge);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_Valuation2009_AttainedAge");
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IOE.xlsx", 7, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaseline_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_GoingConcern.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ReconciliationtoBaselinebyPlanDef_Solvency.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("LiabilitiesDetailedResultsbyPlanDef.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
public void t_CompareRpt_Valuation2011_Baseline(string sOutputFunding_Valuation2011_Baseline)
{
if (Config.bCompareReports)
{
CompareReportsLib _compareReportsLib = new CompareReportsLib("UK003DNT", sOutputFunding_Valuation2011_Baseline_Prod, sOutputFunding_Valuation2011_Baseline);
_compareReportsLib._Report(_PassFailStep.Description, "", "sOutputFunding_Valuation2011_Baseline");
_compareReportsLib.CompareExcel_Exact("LiabilitySummary.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("MemberStatistics.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByNone.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByStatusCodes.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ConversionDiagnostic_GroupByCustom_Gender.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResults.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("DetailedResultswithBenTypesplits.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("ValuationSummary.xlsx", 11, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("IndividualOutput.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-BenefitCashflows.xlsx", 4, 0, 0, 0);
_compareReportsLib.CompareExcel_Exact("PayoutProjection-OtherInfo.xlsx", 4, 0, 0, 0);
Config.bThreadFinsihed = true;
}
}
