Bring your data together
Combine exported files, sort records, check for missing information and get your data into a useful shape.
Custom Excel & VBA programming
Still copying, sorting and putting the same reports together? I can automate those repetitive Excel jobs for you. Tell me what you do now and let’s see how much easier we can make it.
I'm Roger. Based in Adelaide, working with businesses across Australia.
From source data to something useful.
| Task | Action | Result |
|---|---|---|
| Source files | Combine | ✓ Imported |
| Data checks | Validate | ✓ Checked |
| Team schedules | Prepare | ✓ Created |
| Weekly reports | Format | ✓ Ready |
Excel projects for businesses including
A small time-saving tool or a much bigger challenge. I enjoy working out how to make it happen.
Combine exported files, sort records, check for missing information and get your data into a useful shape.
Build the reports, charts and summaries you need, with consistent formatting and a repeatable process.
Quoting calculators, work schedules, data-entry forms and other Excel tools built around the way your business works.
A project for Beach Energy
I developed an Excel VBA application to turn work-order exports into weekly schedules and reports. Users select the weeks and teams they need, and the application prepares a formatted output workbook.
It brings the data processing, scheduling rules and reporting together in one tool.
More businesses I've worked withWork-order exports provide the information to process.
Prepare the schedules needed for the selected period.
Including maintenance, operations, backlog and metrics.
Your programmer, Roger
I work with Excel macros, VBA and complex formulas to make repetitive jobs easier. My projects range from individual tools to substantial scheduling and reporting applications.
You'll deal directly with me, from our first chat through to testing your new tool. I work remotely by email and Microsoft Teams with clients around Australia.
Have a job you keep putting off because it takes forever in Excel? I'd like to hear about it.
Roger
You know the job you need to get done. I'll help work out how Excel can do it.
What do you start with? What do you need at the end? An example or a quick Teams chat is a good place to begin.
Once we've worked through what you need, I'll put together a fixed-price quote for your new Excel tool. I will charge an hourly rate if you need the project completed as soon as possible. Or we can negotiate within your budget as I work through your project withiin a suitable time period.
I'll develop the tool, work through testing with you and show you how to use it.