Macro² Case Studies:

Automated spreadsheet production for Philips Global

A 3rd party data team needed to produce hundreds of custom weighted Excel tables and summary tables based on client specifications. The work was projected to take thousands of hours per wave across three contract waves.

We built a VBA-driven automation that ingests tabular input data and generates all required tables at the click of a button.

Estimated savings: £100k+ across the engagement. The success of this project led to a further contract with the client.

Custom JSON production software for a public market research company

Built a bespoke tool to generate JSON files in the exact structure required by internal systems and downstream dashboards.

Designed for repeat use, with projected savings of thousands of hours over its lifetime.

Social media automation for an ecommerce brand

Implemented automation to generate content variations and schedule posts to social platforms, reducing manual effort and improving consistency of output.

Custom data-checking software (Python)

For the same public market research company, we developed Python-based tools to validate incoming data, apply custom business rules, and flag anomalies before client delivery.

Spreadsheet automations for Amazon, Renault and others

Built and maintained a range of smaller spreadsheet automation tools used to produce client deliverables for Amazon, Renault, and other companies, reducing manual reporting and data manipulation time.

LLM agents for translation and content checking

Implemented focused LLM agents for specific translation tasks and long-form content checking, incorporating chain-of-thought and tree-of-thought techniques to reduce hallucinations and improve consistency.