May 15, 2024 | Project spotlight
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...
Aug 17, 2023 | Project Spotlights
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...
May 2, 2023 | Project Spotlights
Our client had a 15 year old program that uses Excel for the user interface and Access to store the data. The company is expanding and the program was running slow and running out the space. We migrated the data from Access to SQL Server. This effectively removes the...
Dec 1, 2022 | Core Values
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...
Jul 26, 2022 | Core Values
For the want of an audited formula the report was inaccurate,For the want of an accurate report money was lost,For the want of money the company was lost,For the want of a company the jobs were lost,For the want of jobs the economy was lost,And all for the want of an...
Jul 1, 2022 | Project Spotlights
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...
May 31, 2022 | Project Spotlights
The Client’s Quarterly Management meeting uses the same PowerPoint slide, just with updated numbers. There are many slides and, depending on the data, some new ones need to be inserted. We created an Excel workbook that is connected to the Sales database and has the...
Sep 27, 2021 | Project Spotlights
Here’s how we resolved a recent customer’s project. Customer’s Current Situation – The client receives updated inventory lists from a variety of customers. They need to be reviewed and validated before uploading into the client ‘system. They had to first move...
