Spreadsheet: 116352d1311780861-excel-claim-sorting-claims-sorting-tracker-cst-
Sheet: Summary

 |  | Employers Liability Claims Summery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Renewal Date Period |  | Starting Year
 |  | Five Years Period |  |  |  |  | Paid No of  Claims | Paid Total  Amount | Outstanding  No of Claims | Outstanding  Total Amount | Total Number of Claims | Total Amount |  |  |  |  | Start Date |  | End Date |  |  | 2011-08-01 00:00:00 | 2012-08-01 00:00:00 | 2011
EL |  | 2011-08-01 00:00:00 | 2011 | To | 2012-07-31 00:00:00 | 2012 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2011-08-01 00:00:00 |  | 2012-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2010 | To | 2012-07-31 00:00:00 | 2011 | 1 | 0 | 0 | 0 | 1 | 0 |  |  |  |  | 2010-08-01 00:00:00 |  | 2011-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2009 | To | 2012-07-31 00:00:00 | 2010 | 1 | 0 | 1 | 0 | 2 | 0 |  |  |  |  | 2009-08-01 00:00:00 |  | 2010-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2008 | To | 2012-07-31 00:00:00 | 2009 | 1 | 0 | 1 | 1000 | 2 | 1000 |  |  |  |  | 2008-08-01 00:00:00 |  | 2009-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2007 | To | 2012-07-31 00:00:00 | 2008 | 1 | 100 | 0 | 500 | 1 | 600 |  |  |  |  | 2007-08-01 00:00:00 |  | 2008-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2006 | To | 2012-07-31 00:00:00 | 2007 | 1 | 100 | 0 | 0 | 1 | 100 |  |  |  |  | 2006-08-01 00:00:00 |  | 2007-07-31 00:00:00
 |  | Total Summary |  |  |  |  | 5 | 200 | 2 | 1500 | 7 | 1700
 |  |  |  |  |  |  | Note: Zero is counted as paid and excluded from outstanding.
 |  | Public Liability Claims Summery
 |  | Five Years Period |  |  |  |  | Paid No of  Claims | Paid Total  Amount | Outstanding  No of Claims | Outstanding  Total Amount | Total Number of Claims | Total Amount |  |  |  |  | Start Date |  | End Date
PL |  | 2011-08-01 00:00:00 | 2011 | To | 2012-07-31 00:00:00 | 2012 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2011-08-01 00:00:00 |  | 2012-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2010 | To | 2012-07-31 00:00:00 | 2011 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2010-08-01 00:00:00 |  | 2011-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2009 | To | 2012-07-31 00:00:00 | 2010 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2009-08-01 00:00:00 |  | 2010-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2008 | To | 2012-07-31 00:00:00 | 2009 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2008-08-01 00:00:00 |  | 2009-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2007 | To | 2012-07-31 00:00:00 | 2008 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2007-08-01 00:00:00 |  | 2008-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2006 | To | 2012-07-31 00:00:00 | 2007 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2006-08-01 00:00:00 |  | 2007-07-31 00:00:00
 |  | Total Summary |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | Property/BI Claims Summery
 |  | Five Years Period |  |  |  |  | Paid No of  Claims | Paid Total  Amount | Outstanding  No of Claims | Outstanding  Total Amount | Total Number of Claims | Total Amount |  |  |  |  | Start Date |  | End Date
MD |  | 2011-08-01 00:00:00 | 2011 | To | 2012-07-31 00:00:00 | 2012 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2011-08-01 00:00:00 |  | 2012-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2010 | To | 2012-07-31 00:00:00 | 2011 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2010-08-01 00:00:00 |  | 2011-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2009 | To | 2012-07-31 00:00:00 | 2010 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2009-08-01 00:00:00 |  | 2010-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2008 | To | 2012-07-31 00:00:00 | 2009 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2008-08-01 00:00:00 |  | 2009-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2007 | To | 2012-07-31 00:00:00 | 2008 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2007-08-01 00:00:00 |  | 2008-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2006 | To | 2012-07-31 00:00:00 | 2007 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2006-08-01 00:00:00 |  | 2007-07-31 00:00:00
 |  | Total Summary |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | THEFT Claims Summery
 |  | Five Years Period |  |  |  |  | Paid No of  Claims | Paid Total  Amount | Outstanding  No of Claims | Outstanding  Total Amount | Total Number of Claims | Total Amount |  |  |  |  | Start Date |  | End Date
TH |  | 2011-08-01 00:00:00 | 2011 | To | 2012-07-31 00:00:00 | 2012 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2011-08-01 00:00:00 |  | 2012-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2010 | To | 2012-07-31 00:00:00 | 2011 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2010-08-01 00:00:00 |  | 2011-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2009 | To | 2012-07-31 00:00:00 | 2010 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2009-08-01 00:00:00 |  | 2010-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2008 | To | 2012-07-31 00:00:00 | 2009 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2008-08-01 00:00:00 |  | 2009-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2007 | To | 2012-07-31 00:00:00 | 2008 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2007-08-01 00:00:00 |  | 2008-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2006 | To | 2012-07-31 00:00:00 | 2007 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2006-08-01 00:00:00 |  | 2007-07-31 00:00:00
 |  | Total Summary |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | MONEY Claims Summery
 |  | Five Years Period |  |  |  |  | Paid No of  Claims | Paid Total  Amount | Outstanding  No of Claims | Outstanding  Total Amount | Total Number of Claims | Total Amount |  |  |  |  | Start Date |  | End Date
MNY |  | 2011-08-01 00:00:00 | 2011 | To | 2012-07-31 00:00:00 | 2012 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2011-08-01 00:00:00 |  | 2012-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2010 | To | 2012-07-31 00:00:00 | 2011 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2010-08-01 00:00:00 |  | 2011-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2009 | To | 2012-07-31 00:00:00 | 2010 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2009-08-01 00:00:00 |  | 2010-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2008 | To | 2012-07-31 00:00:00 | 2009 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2008-08-01 00:00:00 |  | 2009-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2007 | To | 2012-07-31 00:00:00 | 2008 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2007-08-01 00:00:00 |  | 2008-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2006 | To | 2012-07-31 00:00:00 | 2007 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2006-08-01 00:00:00 |  | 2007-07-31 00:00:00
 |  | Total Summary |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | CAR Claims Summery
 |  | Five Years Period |  |  |  |  | Paid No of  Claims | Paid Total  Amount | Outstanding  No of Claims | Outstanding  Total Amount | Total Number of Claims | Total Amount |  |  |  |  | Start Date |  | End Date
CAR |  | 2011-08-01 00:00:00 | 2011 | To | 2012-07-31 00:00:00 | 2012 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2011-08-01 00:00:00 |  | 2012-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2010 | To | 2012-07-31 00:00:00 | 2011 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2010-08-01 00:00:00 |  | 2011-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2009 | To | 2012-07-31 00:00:00 | 2010 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2009-08-01 00:00:00 |  | 2010-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2008 | To | 2012-07-31 00:00:00 | 2009 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2008-08-01 00:00:00 |  | 2009-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2007 | To | 2012-07-31 00:00:00 | 2008 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2007-08-01 00:00:00 |  | 2008-07-31 00:00:00
 |  | 2011-08-01 00:00:00 | 2006 | To | 2012-07-31 00:00:00 | 2007 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 2006-08-01 00:00:00 |  | 2007-07-31 00:00:00
 |  | Total Summary |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0