Mike,
I think, in the spreadsheet screenshot where you show the organisation of data in the three indexes, you have the first two index names in the wrong order (the first index should be ix_....SalepersonIDStatusModifiedDate and vice versa with the second index). Or did I misread the screenshot?