HELP BUILD EXCEL BASED HVY EQUIPMENT EMPLOYMENT MODELING SYSTEM

MINIMUM QUALIFICATIONS

>5 years of experience building complex Excel workbooks involving multiple worksheets, VBA programming, pivot chart development, and custom UI development

PROJECT

> This is phase 1 of a multi-phase project

> See the attached workbook containing the system's component map for phase 1

> The referenced data source worksheets are functional and linked to the calculation template which calculates the required results FOR 1 MACHINE RECORD

> All other worksheets are prototyped

WORK

> Collaborate and build VBA macros to loop through up to 3,000 machine records in the data source worksheets and load the calculation template with machine-specific calculation variables found there, then copy the end results to the datapoint database and to the employment summary worksheet

>Collaborate and define the best way to specify in the formulas in the calculation template the cell addresses of the values in the data source worksheets in order to optimize the above-described VBA macro's performance and stability

> Collaborate and build large dataset pivot charts for examination of results

> Collaborate and build a bulletproof UI

> Collaborate and build an installation/licensing routine

> Collaborate and secure the workbook with a licensing dongle