You have chosen to sponsor your bid up to a maximum amount of .
I need help in developing an excel application which need to be able to populate and calculate huge data source of 270 fields wide and up to 5000 records long.
The main report will be an interactive Gantt chart with tools to reload the source file, refresh and navigate the chart viewing timelines of 3 milestones of baseline, forecast, and actual dates. This report should be able to show dynamic data in 3 lines which will be controlled by a horizontal and vertical scroll bar. There’re also 2 categories with each 17 buttons to present each report popping up as another tabs by filtering selected fields based on specific conditions of another fields.
The excel app should have a Config Sheet in order to set many ranges of fields and values to filter the source data which need to be shown in the chart as desire.
This is only for those who called themselves an Excel Expert and the chosen will need to be able to give his/her available time to improve this app in the future (of course with another deal). I myself have a high knowledge for excel features, formulas and designs, so I know what I want and what I am doing, however will need help from an expert vba coder. Don’t waste your bid quota!
Finally, this app will need to be wrapped up with a restricted access when it reaches predefined expiry date in order to make sure the users are using the latest update of it.