The Tools I Built Because Excel Wasn't Enough
Every sales manager has been there. You open your laptop Monday morning, download the weekly report from your CRM, paste it into a spreadsheet, spend 30 minutes formatting and cross referencing, then finally get to the part that actually matters: figuring out how your team is performing and where to focus your coaching.
I did this exact ritual for months before I snapped. Not dramatically. Just quietly, on a Thursday night, when I opened Excel and thought, "There has to be a better way."
The Performance Tracker
What started as a few VBA macros has evolved into a 38 sheet workbook that scores rep performance across three dimensions: activity (50%), funnel health (25%), and quota attainment (25%). Each rep gets a composite score with clear color coding: green means performing at 80 or above, yellow means watch at 60 to 79, and red means needs attention below 60.
The scoring system is not arbitrary. Activity matters most because that is what you can control. If your activity numbers are strong, funnel and attainment tend to follow. But funnel and attainment provide the leading and lagging indicators that tell you whether those activities are effective.
The Pipeline
The coolest part is the data pipeline. My team fills out a Microsoft Form each week with their activity numbers. Power Automate catches those submissions and drops them into a OneDrive Excel file. Then a single macro imports that data, validates it, and populates the entire workbook. What used to take 30 minutes of manual entry now takes about 3 minutes of automated processing.
The forecasting engine is another piece I am proud of. It tracks monthly quotas on a fiscal month cycle (29th to 28th) and projects attainment based on current pace. If a rep is at 40% of quota with 60% of the month gone, the system flags it. If someone is ahead of pace, that gets highlighted too so I can recognize the effort.
Seller Outreach Tool
The second tool I built was for the reps themselves. A batch email tool in Excel/VBA that lets them run targeted outreach campaigns without needing any external software. Template management, recipient lists, merge fields, send tracking, all in a single .xlsm file they can open on their corporate laptops.
The design constraint was important: it had to work on a locked down corporate Windows machine with nothing but Microsoft 365 installed. No Python, no Node.js, no browser extensions. Just Excel with macros enabled. That constraint is what pushed me toward VBA, and honestly, it was the right call. Zero IT involvement, zero setup, zero learning curve for non technical reps.
Why I Keep Building
Someone once asked me why I don not just buy a tool off the shelf. The honest answer is that off the shelf tools are built for the average case, and my team is not average. We have specific scoring weights, specific quota structures, specific reporting cadences. Building custom means every metric, every threshold, every automation is tuned to exactly how we operate.
Plus, there is something deeply satisfying about watching a process that used to take 30 minutes happen in 3. That is a 90% reduction in time spent on data entry and formatting, time that is now spent on coaching, strategy, and actually talking to customers.
The tools are not flashy. They do not have dark mode dashboards or AI powered anything. They are Excel workbooks with VBA macros, and they work. Sometimes the best tool is not the most sophisticated one. It is the one your team will actually use.