Case studies

One process, measured before and after

Approved results from IT-TIDY deployments across finance, real estate, quantitative risk, industrial operations and media. More case studies are added as new pilots complete.

Have a question about your workflow or formulas?

Ask Tidy Advisor about use cases, the pilot, or how pricing and licensing work for a team like yours.

Tidy Advisor

Ask about pricing factors, the pilot, or which plan fits your team — e.g. "What's the implementation timeline?" or "Which plan fits a team of 15 controllers?"

Suggested:

Global Procurement & Supply Chain

From 39% to 97% of data correct on first submission

A group with roughly 100 foreign subsidiaries ran cross-border procurement planning through spreadsheets submitted by each entity every cycle. Before IT-TIDY, only 39% of submissions were correct on first pass, and the central team spent days on corrections every cycle.

IT-TIDY connected each subsidiary's existing, bilingual Excel template to a governed central database, aligned with the group's SAP ERP. Blocking validation rules, defined field by field, caught out-of-range and inconsistent entries the moment they were typed, before the file ever left the subsidiary.

Data correct on first submission rose from 39% to 97%, and central corrections fell by 85%. The method followed was Lean Six Sigma (DMAIC), a certified path.

  • 39% → 97% correct on first submission
  • -85% central correction time
  • ~100 subsidiaries, one SAP-aligned standard

Finance & Controlling

One hub for budget and forecast collection from ~100 managers

A finance and controlling team had to coordinate periodic budget and forecast submissions — headcount, capex and opex by project — from roughly 100 managers. Dozens of spreadsheets circulating by email produced entry errors, broken formulas, and weeks of manual reconciliation.

The team's existing Excel templates moved into one multi-access environment: permissions segregated per manager, validation checked against business rules before submission, and consolidation running centrally in real time.

  • ~100 managers on one hub, zero email attachments
  • Validation before submission, not after
  • Real-time consolidation for the CFO

Real Estate & Asset Management

Faster, auditable reviews for real-estate fund planning

Performance monitoring and plan updates for a portfolio of real-estate funds had no structured flow between analysts and management, making manual reviews slow and operationally risky.

A governed, collaborative Excel environment replaced it: segregated access by role, binding approval stages, and formal freezing of approved plans before they reach the investment committee.

  • Staged draft-to-resolution workflow
  • -75% fund-review closing time
  • Full traceability for auditors

Quantitative Finance & Risk Management

Black-Scholes pricing and Monte Carlo simulations without the wait

Pricing complex derivatives, options and volatility curves across multiple scenarios regularly froze local Excel files, forcing a choice between hours of waiting or costly external infrastructure.

Black-Scholes pricing and Monte Carlo simulations now run remotely at high performance, called directly from an Excel formula, with results returned instantly and no local slowdown.

  • Large simulations with no wait
  • Analyst's machine stays free during computation
  • The same pricing logic runs every time

Industrial & Board Governance

32 KPIs, 80 plant managers, one monthly freeze for the board

A monthly roll-up of 32 weighted strategic KPIs — HSE, environmental emissions, refining margins, finance — from 80 plant managers had no formal freeze mechanism before board presentation.

One unified scorecard replaced it, with a formal monthly freeze workflow that locks cells and produces an auditable record for each KPI area before the board sees it.

  • 80 plant managers, one standard
  • Formal monthly freeze, locked cells
  • Board-ready reporting in 48 hours

Media & Broadcasting

Zero channel-assignment errors in daily TV scheduling

Organizing and updating daily TV programme schedules required every show or event to be correctly assigned to its channel, platform and time slot — with overlaps or content swaps a constant risk.

A structured, IT-TIDY-governed sheet automatically checks that times, content and destination channel are consistent, blocking entry errors and handling last-minute changes in an orderly way.

  • Every item matched to the right channel
  • Last-minute changes handled without rebuilding the sheet
  • A clear, traceable history of every change

Energy & Utility

In-house electricity-consumption forecasting, with zero outsourcing

A utility needed to process zonal electricity-consumption curves in real time — using grid-operator billing feeds, distributor data, temperatures and customer counts — without depending on outsourced services or external portals.

An Excel-driven platform now lets the operator set the inputs, choose the forecasting algorithm and the time horizon, with the calculation running immediately and a built-in audit trail recording how each forecast was produced.

  • 100% of processing moved in-house
  • Multiple algorithms and horizons, chosen from Excel
  • Audit trail on every forecast

Company names withheld. [PLACEHOLDER: add named references once written permission is on file in CLAUDE.md]

See what a 30-day pilot could show for your process

See how the pilot works →