Five ways to turn MS Office into the system you were about to buy.
Every service here is a generalized version of something Daniel has already built and delivered — in the field, under real deadlines, for real budgets.
Custom VBA & Office Automation Development
End-to-end automation built natively in Excel, Access, Word, PowerPoint, Project, and Visio — estimating workbooks, tracking systems, executive reporting, and document generation, engineered like software rather than duct-taped together with macros.
- Excel/Access application development & VBA architecture
- Automated proposal, submittal, and reporting workflows
- Word & PowerPoint automation for contracts and executive briefings
- Integration between SAP/ERP exports and Office tools (pivot-driven reconciliation, financial reporting)
Estimating & Project Controls Systems
Parametric estimating engines, auto-populating pricing workbooks, schedule-of-values tracking, and Earned Value Management reporting built for construction, material handling, and installation businesses. This is the oldest thread in Daniel's toolkit — his first estimating workbook was built in Lotus 123 in the early 1980s, and he's been refining the craft in Office ever since.
- Parametric ROM & detailed estimating workbooks (mechanical, electrical, ASRS, sortation)
- Schedule-of-values & billing tracking tied to project financials
- Earned Value Management (EVM) reporting
- Subcontractor and vendor databases with risk scoring
Process & Lean Engineering
Visio-based process design that does double duty: the diagram is both the documentation and the source that automatically generates configuration files, routing tables, functional specs, and test scripts.
- Logical flow-diagram-to-code generation (Visio → config/spec/test output)
- Lessons Learned databases & continuous improvement systems
- ISO document compliance automation
- Post-mortem & root-cause tracking workflows
Legacy Code & Document Parsing Tools
Parsing and code-generation engines written natively in VBA — functionally equivalent to AWK, LEX, and YACC — that read source code, drawings, or documents and produce structured output: indexed documentation, CRUD matrices, migration reports, and audit trails.
- Automated source-code documentation with indexed tables of contents
- CRUD matrix & dependency mapping from stored procedures or code
- API/version migration analysis and conversion tooling
- Cross-environment audit processes (dev/test/prod comparison)
Training & Ongoing Support
Every engagement ends with your team able to run and extend what was built — not locked out of it. Includes documentation, walkthroughs, and a support arrangement suited to how your team actually works.
- Hands-on VBA/Office training for internal teams
- Documentation standards & version control for Office-based applications
- Ongoing maintenance & enhancement support
- Migration support across Office versions (2003 through 365)
Licensed Components from the Code Library
Rather than build from scratch, license proven modules from Daniel's 70,000+ line personal VBA library — deployed as an Access repository, compiled COM DLLs, or standalone modules, classes, and forms.
- Pre-built estimating & parametric formula modules
- Document/code parsing engines
- Workflow & task automation components
- Reporting & dashboard generators
Not sure which service fits your problem?
Describe the process that's eating your team's time — there's a good chance it can live in Office instead of a new software budget line.