Spreadsheet: 64493d1265327666-generating-new-table-from-system-report-716841-generating-new-table-from-system-report
Sheet: Sheet1

 |  |  | Existing structure |  |  |  |  | Wanted structure
Claim # | Coverage | Date | Loss/reserve | Amount | Quarter |  |  | Claim # | Coverage | Loss/reserve | Q4 | Q3 | Q2
CLOK-9000020 | PD | 2009-07-01 00:00:00 | Reserve | 1000 | 3 |  |  | CLOK-9000020 | PD | Reserve | 343 | 893
CLOK-9000020 | PD | 2009-07-15 00:00:00 | Paid Loss | -893.08 | 3 |  |  | CLOK-9000020 | PD | Paid Loss | -343 | -893
CLOK-9000020 | PD | 2009-07-29 00:00:00 | Reserve | -106.92 | 3 |  |  | CLAR-9000143 | COLL | Reserve | 3600
CLOK-9000020 | PD | 2009-10-05 00:00:00 | Paid Loss | -342.99 | 4 |  |  | CLAR-9000143 | COLL | Paid Loss | -3600
CLOK-9000020 | PD | 2009-10-05 00:00:00 | Reserve | 342.99 | 4 |  |  | CLAR-9000143 | PD | Reserve | 800
CLAR-9000143 | COLL | 2009-10-22 00:00:00 | Reserve | 3600 | 4 |  |  | CLAR-9000143 | PD | Paid Loss | -800
CLAR-9000143 | PD | 2009-10-26 00:00:00 | Paid Loss | -780.76 | 4
CLAR-9000143 | PD | 2009-10-26 00:00:00 | Reserve | 800 | 4
CLAR-9000143 | PD | 2009-10-26 00:00:00 | Reserve | -19.24 | 4
CLAR-9000143 | COLL | 2009-11-16 00:00:00 | Paid Loss | -2616.5 | 4 |  |  | Sum of Amount |  |  | Quarter
CLAR-9000143 | COLL | 2009-11-16 00:00:00 | Reserve | -983.5 | 4 |  |  | Claim # | Coverage | Loss/reserve | 3 | 4
CLAR-9000171 | PD | 2009-11-03 00:00:00 | Reserve | 2100 | 4 |  |  | CLAR-9000143 | COLL | Paid Loss |  | -2616.5
CLAR-9000171 | BI | 2009-11-03 00:00:00 | Reserve | 4000 | 4 |  |  |  |  | Reserve |  | 2616.5
CLAR-9000171 | PD | 2009-11-05 00:00:00 | Paid Loss | -2283.88 | 4 |  |  |  | PD | Paid Loss |  | -780.76
CLAR-9000171 | PD | 2009-11-05 00:00:00 | Reserve | 183.88 | 4 |  |  |  |  | Reserve |  | 780.76
CLAR-9000183 | COLL | 2009-11-10 00:00:00 | Reserve | 2400 | 4 |  |  | CLAR-9000171 | BI | Reserve |  | 4000
CLAR-9000183 | PD | 2009-11-10 00:00:00 | Reserve | 2100 | 4 |  |  |  | PD | Paid Loss |  | -2283.88
CLAR-9000183 | PD | 2009-11-19 00:00:00 | Paid Loss | -3427.08 | 4 |  |  |  |  | Reserve |  | 2283.88
CLAR-9000183 | PD | 2009-11-19 00:00:00 | Reserve | 1327.08 | 4 |  |  | CLAR-9000183 | COLL | Paid Loss |  | -5148.75
CLAR-9000183 | PD | 2009-12-10 00:00:00 | Reserve | 1472.92 | 4 |  |  |  |  | Reserve |  | 5148.75
CLAR-9000183 | COLL | 2009-12-16 00:00:00 | Paid Loss | -5068.75 | 4 |  |  |  | PD | Paid Loss |  | -5333.82
CLAR-9000183 | COLL | 2009-12-16 00:00:00 | Paid Loss | -80 | 4 |  |  |  |  | Reserve |  | 5333.82
CLAR-9000183 | COLL | 2009-12-16 00:00:00 | Reserve | 2668.75 | 4 |  |  | CLAR-9000188 | BI | Reserve |  | 4000
CLAR-9000183 | COLL | 2009-12-16 00:00:00 | Reserve | 80 | 4 |  |  |  | COLL | Reserve |  | 2400
CLAR-9000183 | PD | 2009-12-30 00:00:00 | Paid Loss | -1906.74 | 4 |  |  |  | PD | Reserve |  | 2100
CLAR-9000183 | PD | 2009-12-30 00:00:00 | Reserve | 433.82 | 4 |  |  | CLOK-9000020 | PD | Paid Loss | -893.08 | -342.99
CLAR-9000188 | COLL | 2009-11-10 00:00:00 | Reserve | 2400 | 4 |  |  |  |  | Reserve | 893.08 | 342.99
CLAR-9000188 | PD | 2009-11-10 00:00:00 | Reserve | 2100 | 4 |  |  | Grand Total |  |  | 0 | 12500
CLAR-9000188 | BI | 2009-11-20 00:00:00 | Reserve | 4000 | 4