Insurance
Summarize a loss run and flag anomalies
The loss summary reconciles claim counts and totals, highlights severity and frequency patterns, and identifies data anomalies without inferring fraud.
UnderwritingRiskBrokers
Prompt
Read the supplied loss run, normalize policy periods and claim fields, reconcile counts and paid, reserved, and incurred totals, then summarize frequency, severity, open claims, concentration, and notable development. Flag missing or inconsistent data as anomalies without inferring fraud, and write the analysis to a new sheet.
Works with
Google DocsGoogle Sheets