Hello, I read the write up and saw the excel file. I would not claim that I understood everything. But got the gist of it. A few lines of example data in excel file would have been huge help. (As we excel experts read numbers better than words. :) )
Well, I am new to Freelancer.com but has 10+ years of experience working with excel. I very comfortably use mathematical, logical, lookup formulas along with VBA programming (Macros).
Please do see my profile and portfolio for my previous work examples with screenshots and demos.
Be assured that regardless of level of complexity, your requirements will be met.
Thanks for your time and consideration! I look forward to hear from you.
Regards,
Ravikiran Indore