Hi,
I have been working as Sr. pricing analyst since last 4+ years. During this stint, I have worked on projects involving price models, creating competitive information databases etc. In my projects, I work extensively on excel (with 100K rows of data from production sites).
For your project, I expect solution to be on following lines:
1) User form: This will be design on excel and will collect user inputs.
2) Processing/Calculation logic: Logic will be needed to perform data processing/calculations over formatted data.
3) Reports
In my estimation, whole process may take 3 - 5 days for completion. This estimation will also depend (and may vary) on how prepared you are with project draft and related details.
I guess I have understood your requirement and can help you in that. [I have worked on similar project before where PWA analysis was done, on data residing in Access, based on user inputs.]
Please revert back for any questions/clarifications.
Regards!
Vikas