Spreadsheet: 328822d1404104917-inventory-disqualifiers-inventory-disqualifier
Sheet: Sample & Expected Output

*** Sample Worksheet ***
Balance | 2427.043182580531 | (manually assigned base amount or running balance)
Amount to distribute | 13136.797 | (manually assigned amount will be divided to all who are eligible)
Eligible | 7 | (computed count from list of associates below who are qualified)
 | (incentive will only be given if 0 (or no) aged inventory greater than 7 days, depending on # of eligible)
Aged Inventory | Disqualifier | (to add to or deduct from B1 (balance) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aged Inventory |  | Instances
8-20 days | -0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Below 10 days | 1 to 9 days | 0
21-30 days | -0.15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Above 10 days | 10 to 29 days | >0<=3
31-60 days | -0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Above 30 days | 10 to 29 days | >3
61-99 days | -0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Above 60 days | 30 to 59 days | >0<=3
100 days | -0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Above 100 days | 30 to 59 days | >3
 | (instances of aged inventories may not matter for now; can be either yes or no or with or without)
 | Aged Groups |  |  |  |  | (disqualifier is the accumulation of presence of inventories in any/all aged groups)
Associate | 8-20 days | 21-30 days | 31-60 days | 61-99 days | > 100 days | Disqualifier | Incentive | Remark
Associate 1 | 1 | 2 | 3 | 4 | 5 |  |  | disqualified due to aged inventories in other age groups; with accumulated deduction)
Associate 2 | 1 | 8 |  | 1 | 1
Associate 3 |  |  |  |  |  |  |  | qualified for now having any inventory above 7 days
Associate 4
Associate 5 |  |  | 1 |  |  | -0.2
Associate 6 |  |  |  |  | 1 | -0.3
Associate 7 |  |  |  | 1 |  | -0.25
Associate 8 | 5 |  |  |  |  | -0.1
Associate 9 |  | 7 | 6
Associate 10
Associate 11 | 6 |  |  | 1
Associate 12 |  | 3 | 4
Associate 13
Associate 14 |  |  |  | 2 | 1
Associate 15 |  |  | 2 | 3
Associate 16
Associate 17 |  | 2 |  |  |  | -0.15
Associate 18
Associate 19 | 7 | 10
Associate 20
 | (all columns may be a separate table in another sheet)
 | (final table will only show column A (Associate), column G (Disqualifier), H (Incentive)
*** Expected Output ***
Balance | 2427.043182580531
Amount to distribute | 13136.797
Eligible | 7
Aged Inventory | Disqualifier
8-20 days | -0.1
21-30 days | -0.15
31-60 days | -0.2
61-99 days | -0.25
> 100 days | -0.3
Associate | Disqualifier | Incentive
Associate 1 | -1 | -2427.043182580531
Associate 2 | -0.8 | -1941.634546064425
Associate 3 |  | 1876.685285714286
Associate 4 |  | 1876.685285714286
Associate 5 | -0.2 | -485.4086365161063
Associate 6 | -0.3 | -728.1129547741593
Associate 7 | -0.25 | -606.7607956451328
Associate 8 | -0.1 | -242.7043182580531
Associate 9 | -0.35 | -849.4651139031859
Associate 10 |  | 1876.685285714286
Associate 11 | -0.35 | -849.4651139031859
Associate 12 | -0.35 | -849.4651139031859
Associate 13 |  | 1876.685285714286
Associate 14 | -0.55 | -1334.873750419292
Associate 15 | -0.45 | -1092.169432161239
Associate 16 |  | 1876.685285714286
Associate 17 | -0.15 | -364.0564773870797
Associate 18 |  | 1876.685285714286
Associate 19 | -0.25 | -606.7607956451328
Associate 20 |  | 1876.685285714286