We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
A solution to last week’s challenge can be found here.
The Input Data is a claims experience record for a group health insurance policy for 3 underwriting years. The data was converted from a PDF file - each page of the PDF is contained in a single cell of data.
Your goal is to extract the amounts shown next to each Accident Month (in the block of text under Period) and summarize them with regards to the Inception Date of the policy.