Spreadsheet: 116318d1311751495-excel-claim-sorting-claims-sorting-tracker-cst-1-1-
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
 |  | 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 | 1 | 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 | 1 | 200 | 0 | 100 | 1 | 300 |  |  |  |  | 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 | 50 | 1 | 150 |  |  |  |  | 2006-08-01 00:00:00 |  | 2007-07-31 00:00:00
 |  | Total Summary |  |  |  |  | 3 | 300 | 0 | 150 | 2 | 450
 |  |  |  |  |  |  | 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
 |  | 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 | 2 | 6356 | 0 | 0 | 0 | 6356 |  |  |  |  | 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 | 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 | 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 |  |  |  |  | 2 | 6356 | 0 | 0 | 2 | 6356
 |  | Property 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
 |  | 2011-08-01 00:00:00 | 2011 | To | 2012-07-31 00:00:00 | 2012 | 1 | 15 | 0 | 0 | 1 | 15 |  |  |  |  | 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 | 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 | 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 | 1 | 100 | 0 | 0 | 0 | 100 |  |  |  |  | 2006-08-01 00:00:00 |  | 2007-07-31 00:00:00
 |  | Total Summary |  |  |  |  | 2 | 115 | 0 | 0 | 2 | 115
 |  | 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
 |  | 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 | 1 | 15 | 0 | 0 | 0 | 15 |  |  |  |  | 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 | 1 | 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 |  |  |  |  | 1 | 15 | 0 | 0 | 1 | 15
 |  | 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
 |  | 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 | 1 | 500 | 0 | 500 |  |  |  |  | 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 | 1 | 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 | 1 | 500 | 1 | 500
 |  | 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
 |  | 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 | 1 | 5000 | 0 | 0 | 0 | 5000 |  |  |  |  | 2006-08-01 00:00:00 |  | 2007-07-31 00:00:00
 |  | Total Summary |  |  |  |  | 1 | 5000 | 0 | 0 | 0 | 5000