Custom Excel & VBA programming

Less time on spreadsheets.
More time for
everything else.

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.

A simpler Monday morning
Your weekly reports

From source data to something useful.

✓ Prepared
Illustrative automation workflow
TaskActionResult
Source filesCombine✓ Imported
Data checksValidate✓ Checked
Team schedulesPrepare✓ Created
Weekly reportsFormat✓ Ready
OverviewSchedulesReports
An illustration of what a custom Excel tool can do.

Excel projects for businesses including

Beach EnergyCODANAntelcoEyre Peninsular AgronomistNDIS Physitherapist

What would you like
Excel to do for you?

A small time-saving tool or a much bigger challenge. I enjoy working out how to make it happen.

Bring your data together

Combine exported files, sort records, check for missing information and get your data into a useful shape.

Make reporting easier

Build the reports, charts and summaries you need, with consistent formatting and a repeatable process.

Build a tool of your own

Quoting calculators, work schedules, data-entry forms and other Excel tools built around the way your business works.

A project for Beach Energy

Work-order data in.
Weekly schedules out.

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 with
Start with the source data

Work-order exports provide the information to process.

Choose the weeks and teams

Prepare the schedules needed for the selected period.

Produce schedules and reports

Including maintenance, operations, backlog and metrics.

Your programmer, Roger

I like a good
Excel challenge.

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

It starts with a conversation.

You know the job you need to get done. I'll help work out how Excel can do it.

Tell me about the job

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.

Agree on the work and price

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.

Build it and try it out

I'll develop the tool, work through testing with you and show you how to use it.

Got an Excel job
in mind?

Let's have a chat about it. Small project or big idea, you're welcome to get in touch.