I need to improve on my existing excel estimating solution

Job ID: 30975185

Budget: $30 – $250 USD

I have created an Excel workbook that connects to an Access DB. It pulls the labor and material and other information. The sales agent will review the plans and determine the SOW for the job and preselect the material for the estimator. After the estimator completes the takeoff and enters the quantities it will automatically calculate the labor and material cost, then add any taxes, commissions, markup etc. to determine a total job cost.

This should automatically create a material list and proposal to send to the customer. My office manager will manually enter the material list into QuickBooks and email to our supplier.

Phase I

- review existing spreadsheet and offer suggestions for improvement
- offer suggestions to make it more user friendly. I need this to walk them through the process and reduce the possibility for errors.
- I would like it to be as close to data entry as possible so it's easy for my sales agents to use and/or I can hire a low level person to complete the estimates. ie. walk them through the process of plan review and creating a SOW
- complete the material list and proposal portion

Phase II

- QuickBooks integration
- Add macros to automate certain processes ie. saving as PDF and emailing to the customer
- Save jobs with proposals and material lists for future use. We have customers who do the same job multiple times.

Phase III

- integration with CRM and Project Management software
- determine it should be web based
- Possible full VBA app.

I am open to suggestions
Related categories: Excel Microsoft Access Excel VBA