BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//AKTUARVEREINIGUNG ÖSTERREICHS (AVÖ) - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:AKTUARVEREINIGUNG ÖSTERREICHS (AVÖ)
X-ORIGINAL-URL:https://avoe.at
X-WR-CALDESC:Veranstaltungen für AKTUARVEREINIGUNG ÖSTERREICHS (AVÖ)
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Europe/Vienna
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:CEST
DTSTART:20250330T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
DTSTART:20251026T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:CEST
DTSTART:20260329T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
DTSTART:20261025T010000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:CEST
DTSTART:20270328T010000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
DTSTART:20271031T010000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Europe/Vienna:20260209T093000
DTEND;TZID=Europe/Vienna:20260209T120500
DTSTAMP:20260424T155652
CREATED:20251023T114122Z
LAST-MODIFIED:20251023T114122Z
UID:10000569-1770629400-1770638700@avoe.at
SUMMARY:EAA Web Session From Excel Tariff Calculators to LLM-Powered Python Code
DESCRIPTION:Excel-based tariff calculators remain a cornerstone of actuarial work in life insurance\, but they come with well-known limitations: complex formulas and embedded VBA code\, a lack of transparency\, and difficulties in scaling or integrating with modern IT environments. For actuarial migrations and product validations\, these tools are still widely used – yet they are also one of the main bottlenecks when it comes to efficiency and reproducibility.\nRecent advances in Large Language Models (LLMs) provide new opportunities to overcome these challenges. Instead of manually rewriting legacy Excel logic\, actuaries can now use LLMs to automatically port existing tariff calculators into structured\, well-tested Python code. This enables reproducibility\, improves maintainability\, and opens the door for automation in future\nactuarial workflows.\nIn this web session\, we will showcase two complementary approaches to this task. The first approach is a “crafted” workflow\, where actuaries interact directly with the LLM using screenshots\, formulas\, and VBA modules to achieve a working Python prototype within a short time. The second approach is an “industrial” workflow\, designed for repeatability and automation\, where Excel structures are systematically exported into text formats and processed end-to-end by the LLM. Both approaches will be illustrated with a real-life life insurance example\, highlighting their strengths\, limitations\, and practical implications.\nParticipants will not only see how LLMs can handle complex actuarial logic\, but also how such methods can reduce manual effort\, accelerate migration projects\, and prepare actuarial teams for a future where AI becomes a natural part of actuarial toolchains. The session bridges the gap between everyday actuarial work in Excel and modern coding environments\, showing how actuaries can leverage LLMs to make the transition both approachable and scalable.
URL:https://avoe.at/event/eaa-web-session-from-excel-tariff-calculators-to-llm-powered-python-code/
LOCATION:Online/Streaming
CATEGORIES:European Actuarial Academy (EAA)
END:VEVENT
END:VCALENDAR