Client: Global aerospace manufacturer / defense contractor
Users: Engineers, financial analysts, program managers
Project evaluation-investment analysis system based in Excel with data storage via ADO and Access:
- Tracks a gated project management process with separate workflows for the user and the administrator.
- Facilitates the capital budgeting process for the maintenance operations of a large jet engine fleet.
- Features project-level and dataset-level objects for chronological data capture and historical audit views.
- Accepts user input through an extensive MSForms UI and runs a detailed cash flow / NPV model to compute a score for each project.
- Supports decision-making with a global ranking function and division-level reporting.
- Main
- Add Project
- Project Properties 1
- Project Properties 2
- Project Properties 3
- Project Properties 4a
- Project Properties 4b
- Project Properties 5
- Select Project 1
- Select Project 2
- Find Project 1
- Find Project 2
- Add Project Note
- Edit DataSet 1
- Edit DataSet 2