Component Eligiblity based on Worksheet Columns

Summary:

We are currently deriving the Eligilibility of Merit / Bonus based on the the columns in the Worksheet.

However when we do this the standard reports such as Allocation statistics are not providing right values as they treat all the employees are eligible and derives the averages based on the total employee count on the worksheet.

We wanted this to be taken from the Worksheet or based on the people the Merit/ Bonus is allocated.

Any ideas on how to do this?