xlsEXPERTS
All case studies

Waste Management

Price Increase Modelling & ERP Integration

UKWSL

Problem

UKWSL needed to model pricing scenarios using data from their Oracle ERP system and produce dashboard outputs ready for final processing — without developing a custom utility inside the ERP.

Solution

Excel connected directly to Oracle DB to pull and process pricing data. VBA automated the creation of pricing scenarios in a management dashboard, with outputs formatted for direct upload back into the ERP system.

Outcome

Pricing modelling cycle reduced from days to hours, with a clean handoff process between Excel analysis and ERP finalisation.

Technologies

  • Excel
  • VBA
  • Oracle DB
  • SQL DB
  • ERP Integration

Want something similar?

Tell us what you are doing manually and we will scope a practical Excel or spreadsheet solution.

Send an enquiry

Related reading

From the blog

Start a conversation

Let's talk about what you need

Big or small, we are happy to discuss it. Send us a message or book a free discovery call — we typically respond same business day.

What happens next

  1. 1

    We review your enquiry carefully and reach out personally — usually same business day. No obligation, no hard sell.

  2. 2

    We clarify scope, then provide a clear fixed-price quote and realistic delivery timeframe so you know exactly where you stand.

  3. 3

    Once agreed, we build in stages, keep you updated, and hand over a solution your team can rely on — with support if you need it.

Contact directly

+64 21 783 967WhatsApp us
NZAuckland, New Zealand — serving clients nationwide

Our brands

Excel Experts NZExcel Experts InternationalExcel Experts UK
What does your task concern? (select all that apply)

How would you like to proceed?

Fields marked * are required. A phone number is required to book a discovery call.