Automating a quotation tool

Damen worked with an extensive Excel quotation tool that required a lot of manual actions and slowed down the preparation of quotations. We automated the tool with VBA and macros, so that calculations, input fields and output are generated automatically. The result is a faster way of working that fits better with day-to-day practice and is easy to scale up within the team.

Smart Consultant Damen Services

Challenge

Preparing quotations was a time-consuming process with many manual steps in Excel. Employees spent an unnecessary amount of time adjusting formulas, entering data and formatting documents. Damen wanted to speed up this process and align it better with the day-to-day practice of its sales team.

Approach

We analysed the entire tool and the team's most frequently used workflows. We then developed VBA scripts and dynamic macros that perform automatic calculations, fill in fields and generate output in the right format. The tool was also built in a modular way, so that it is easy to adapt to changes in products or prices.

Result

The time needed to prepare a quotation has been reduced considerably. Manual steps have been replaced by automated steps, which ensures more consistency in output. Employees can now focus on content and customer conversations, instead of on formatting and manual work.

In short

Client
Damen Services
Assignment
Automating a quotation tool

Get a proposal, no strings attached?

Request a free, no-obligation proposal. Within five working days you receive a concrete plan of approach showing how we would tackle your challenge, what investment it involves and the expected lead time.

The proposal is completely free and without obligation. You are not committed to anything, but you do get immediate insight into the possibilities, approach, planning and expected results.

A Smart Consultant consultant with a laptop
Within 5 working days a solution for your challenge in your inbox