I did not see an attachment, but I can provide the skills required to meet your project description. From standard formulas or array formulas, to pivot tables, all the way to the custom functionality and automation VBA scripts provide, I am sure we can develop a solution to meet your needs. If you'd like, feel free to send me the sample spreadsheet so I can take a look and better asses your needs. Thanks for your consideration and hope to talk to you soon!
Cristian R
BS BME Engineering