Property Valuation Firm Saves 12,000 Hours Annually
%
Software Crashes eliminated
Hours saved annually
Impacted Users
The Bottom Line
A custom C#/Excel tool was slowing work, crashing often, and costing the team hours. We diagnosed the root causes across VBA, Excel, and C#, then rebuilt stability with targeted fixes and stronger error handling—eliminating crashes and unlocking an estimated 12,000 hours saved per year.
Situation
A leading U.S. property valuation firm (250+ employees) hit a major software bottleneck. Their custom tool—built to speed up work—started doing the opposite. Slowdowns turned minutes into hours, and frequent crashes erased work, frustrated employees, and put deadlines at risk.
Even with an in-house development team, the issues persisted. The tool had grown into a complex hybrid of C#, Excel, and VBA, and it needed to run on both Macs and PCs. That cross-platform complexity, along with limited access to core C# components, made troubleshooting difficult. Prior fixes helped briefly, but never solved the underlying problems. The firm needed an outside perspective to pinpoint what was really happening and chart a path forward.
Solution
ProsperSpark began with a deep review of the full toolset—VBA macros, Excel infrastructure, and the connected C# components—to identify defects, failure points, and error-prone processes. From that discovery, the team built a targeted improvement plan focused on debugging, improving stability, and adding stronger error tracing and handling.
ProsperSpark worked closely with the client to review findings and choose the right level of changes, from small adjustments to larger updates. After implementation, the revised toolset was tested with a pilot group before rolling out company-wide. The client estimates that eliminating crashes and improving performance will save roughly 12,000 hours per year, and the engagement set the foundation for ongoing support and continued refinement.
Let's make your tech work for you, not the other way around. Schedule a FREE no-pressure chat with us today.
At a Glance
Client
An industry leader in the US property appraisal market.
Industry
Real Estate
Organization
- 250+ Employees
- In-house development team responsible for creating tools using C# and Excel
Business Challange
- Crashes and slowdowns drove lost work and inefficiency.
- Internal fixes stalled, especially across Mac & PC.
Services
Tools
-
- Excel, Power Query, VBA (Visual Basic for Applications)
Market Considerations
- Compliance and ethics demand accurate, auditable valuations.
- Strong data access is essential for defensible decisions.
- Rapid market shifts require fast, current updates.
- Modern tools (software + AI/ML) improve speed and accuracy.
Key Takeaways
- Stabilized the tool to save time and reduce frustration.
- Found root causes and delivered durable results.
- Partnered closely to improve efficiency and lower costs.