I can help you with your spreadsheets, databases and business automation
Bring me the process, data problem or system you are trying to build. We will work through it together and find the most practical way forward.
Excel VBA, SQL, databases, LibreOffice Base, data migration and business-process automation.
There is nothing wrong with using a spreadsheet when a spreadsheet does the job
The problem begins when a useful spreadsheet quietly becomes a critical business system without being designed, controlled or maintained like one.
- One report has to be copied into another.
- Formulas link several workbooks together.
- Rows can be missed during copying or consolidation.
- Large files spend too much time recalculating.
- People repeatedly type, copy and clean the same data.
- Only one person understands how the process works.
At that point, adding more formulas may only make the problem worse. The answer might be to improve the spreadsheet, add VBA automation, clean the source data, introduce a database or rebuild the process properly.
The technology should fit your business problem—not the other way around.
Work across the whole problem
We do not have to decide on the technology before we understand the process. The right solution may involve a spreadsheet, VBA, SQL, a database, cleaner source data or a different workflow.
Spreadsheet and process automation
Reduce repetitive typing, copying, reformatting and manual consolidation.
Excel VBA applications
Build practical tools around software that you or your business already use.
SQL and database-backed systems
Store and process data in a structured system that is easier to query, control and maintain.
Data cleaning and migration
Prepare, restructure and move data from spreadsheets, CSV files, reports or existing systems.
Database and application design
Work out how the data, interface and business rules should fit together.
Technical guidance
Get unstuck, review an approach or work through a project while you build it.
Flexible access to my time and experience
Consulting credits let us use the time in whatever practical way best moves your work forward.
- Live working sessions
- Technical advice and solution design
- Reviewing spreadsheets, databases or code
- Data cleaning and migration work
- Troubleshooting and implementation
- Agreed work carried out between calls
A sensible place to start
Most new clients begin with enough credits for a focused working session.
Larger bundles are available for follow-up work, implementation and ongoing support.
Current options, pricing and savings are shown on the secure order page.
Buy Consulting CreditsConsulting credits do not currently expire.
A simple way to get started
1. Buy consulting credits
Choose the amount of time that makes sense from the secure order page.
2. Arrange the first session
I will contact you by email so that we can agree a suitable time and way to work.
3. Start solving the problem
We may diagnose the issue, choose a direction, review files, solve a contained problem or begin implementation.
You do not need a formal project specification before purchasing. A brief description is enough to begin arranging the work. Detailed investigation and technical work use consulting credits.
Use the simplest technology that reliably gets the job done
Sometimes a spreadsheet is all that is required. Sometimes the right answer is Excel VBA connected to a database. Sometimes the existing process needs to be rebuilt from the ground up.
The goal is not to use more technology. The goal is to create something reliable, understandable and useful.
Bring me the problem you’re trying to solve
We’ll work through the spreadsheet, data, process or application practically and decide on the best way forward.
Current credit options and pricing are shown on the secure order page.