EAA-webinar - From Excel Tariff Calculators to Python – Agentic Edition

The feedback was encouraging, and the field has moved forward quickly since then. Tools have matured, reasoning quality has improved, and, most importantly, the working practice has shifted from a single actuary prompting an LLM into an orchestrated collaboration between actuary and AI agents.

This second edition takes that step forward. Instead of a craftsmanship-style workflow, we present an industrial, agent-based pipeline for calculator porting: structured extraction from Excel and VBA, preparation of actuarial context, LLM-driven code and test generation, and built-in quality assurance, all orchestrated so that the actuary keeps the lead and the LLM handles bounded subtasks autonomously. The pipeline itself has been built inside our DAV working-group context on AI-assisted calculation-engine development.

Participants will see the framework in action on a real-life insurance tariff calculator, from raw Excel input to a ported Python module with a matching test harness. We will not only show the happy path, but also the places where quality control hooks in, how disagreements between LLM-generated output and reference values are resolved, and how the actuary stays firmly accountable for what the pipeline produces.

This web session closes with a hands-on exercise in which each participant uses the pipeline to build a test comparison layer for a given piece of ported code. Because the pipeline is already in place, the LLM focuses narrowly on generating the test framework and the reference calculations needed to validate the port. A well-scoped task that gives participants an immediate, tangible experience of what agentic actuarial work feels like in practice.