Spreadsheet: 116337d1311766762-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 | 1 | 0 | 0 | 0 | 1 | 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 | 10000 | 0 | 8200 | 0 | 18200 |  |  |  |  | 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 | 1000 | 0 | 1000 | 0 | 2000 |  |  |  |  | 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 | 15434 | 0 | 0 | 0 | 15434 |  |  |  |  | 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 | 5643.95 | 0 | 152 | 1 | 5795.95 |  |  |  |  | 2006-08-01 00:00:00 |  | 2007-07-31 00:00:00
 |  | Total Summary |  |  |  |  | 2 | 32077.95 | 0 | 9352 | 2 | 41429.95
 |  |  |  |  |  |  | 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