Hi,
Approach regarding your project: 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. It will use drop downs to collect user inputs.
2) Processing/Calculation logic: Logic will be needed to perform data processing/calculations over formatted data.
In my estimation, whole process may take 5-7 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.
My background: 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).
Regards!
Vikas