Adding integrity to an Excel based quote process


We have a client who needed to track sales quotes, who did them, how much, the status, etc. They were using Excel and emailing the files to each other. They liked the layout they were using, it was just too hard to keep track of all the quotes.

Because everyone connected to the network through a VPN, we proposed a SQL Server database and modifying their existing Excel workbook to transmit data to/from the database. We created a separate Excel workbook to summarize the quotes.

We also made the Excel workbook query their existing ERP system to retrieve the latest product lists. Adding dropdown lists and formatting to prompt the user to enter all required data. We added a feature to save the data in Excel for the times they may not be connected to the VPN. The next time they connect, the data is saved to the database.

During this project, the client’s team requested other enhancements (like hierarchical product list, Alternative Product Names, revised formulas to track distance to customer, etc.) which we made.

By automating the quote process, we saved our client time when the quotes were created, quality of the quotes because we used the latest pricing and accurately tracking the quotes for follow up.

Recent News

Analyze PDF Files in Excel

In today’s data-driven landscape, extracting valuable information from PDF files is a common challenge. We often encounter PDFs that contain structured data we would love to analyze in Excel. Our client had a 60-page PDF that he needed answers from the data to run his...

read more

Supporting your growing business

Here’s a situation we run into with our client. Someone builds a model in Excel and it works great. Time goes by and the business grows. That single workbook gets copied for the new customer/division/business unit. Quite a bit of manual work is needed to make it work...

read more

Will Excel go away?

I was recently asked whether Excel was going away. Now, I’m not a Microsoft mind reader but… here’s why I think Excel is here for a long while. Excel is too easy to use for it to go away. Most people can create a spreadsheet that reflects their business needs. That’s...

read more