Zoom IN Zoom OUT
MENU CHART DES
(CLICK BELOW)
The Essex YTD Chart illustrates the cumulative Child KSI
1. Essex Year To Date Chart
1. Essex Year To Date Chart The chart also displays the current LTP2 Adjusted targ
The Essex Historic Chart illustrates the longer-term Child KSI
2. Essex Historic Chart
2. Essex Historic Chart The Chart illustrates the end of year f
The Essex Rolling 12 Monthly Chart illustrates the cumulati
3. Essex Rolling 12 Monthly Chart
3. Essex Rolling 12 Monthly Chart Thurrock). The Chart identifies the figures before an
The District YTD Chart is interactive. Cumulative Child KSI
4. DISTRICT Year to Date Chart
4. DISTRICT Year to Date Chart
District (inc. Southend+Thurrock). Provisonal progress is
The District Historic Chart is interactive. The longer-term Ch
5. DISTRICT Historic Chart
5. DISTRICT Historic Chart (inc. Southend+Thurrock). The Chart illust
The District Comparison Chart is interactive. The Child KSI
6. DISTRICT Comparison Chart
6. DISTRICT Comparison Chart viewed simultaneously for a chosen Year and Quarter wi
These charts show the year to date C
7. District Child KSI Chart
7. District Child KSI Chart with comparisons with the sa
CHILD KSI Workbook Killed or seriously injured road
DECEMBER Version This workbook includes finalised da
CHART DESCRIPTION
sex YTD Chart illustrates the cumulative Child KSI Casualties for Essex (excluding Southend and Thurrock).
chart also displays the current LTP2 Adjusted target, provisional forecast and data from previous years.
Historic Chart illustrates the longer-term Child KSI casualty trend for Essex (excluding Southend and Thurrock).
The Chart illustrates the end of year figures and target line(s) back to 1999.
ex Rolling 12 Monthly Chart illustrates the cumulative Child KSI Casualties for Essex (excluding Southend and
hurrock). The Chart identifies the figures before and after the intervention of a key partnership strategy.
ct YTD Chart is interactive. Cumulative Child KSI Casualties can be displayed for a chosen Year, Quarter and
t (inc. Southend+Thurrock). Provisonal progress is shown for the year to date with data from previous years.
t Historic Chart is interactive. The longer-term Child KSI casualty trend can be displayed for a chosen District
(inc. Southend+Thurrock). The Chart illustrates the end of year figures back to 1999.
ct Comparison Chart is interactive. The Child KSI Casualties for all Districts (inc. Southend+Thurrock) can be
imultaneously for a chosen Year and Quarter with an option to show or hide the District Target Indicators.
These charts show the year to date Child KSI Casualties for each District
with comparisons with the same period in 2008 and 2009
d or seriously injured road users (aged 0 - 15 inclusive).
book includes finalised data up to the end of December 2010.
Return To Menu Screen
Return To Menu Screen
Essex CHILD KSI Cumulative Progress
Zoom IN Zoom OUT
In Yr Target 2010 In Yr Total 2009
70
60
50
KSI Casualties
40
30
20
10
0
Jan-10 Feb-10 Mar-10 Apr-10 May-10 Jun-10 Jul-10
Jan Feb Mar Apr May Jun
2008 2 9 15 22 23 29
2009 0 2 7 11 16 20
2010 1 6 9 13 19 23
10 Target 2 9 15 21 25 30
Forecast 0 0 0 0 0 0
x CHILD KSI Cumulative Progress
DO NOT EDIT THESE C
2009 In Yr Total 2008 In Yr Total
Jan-10
Feb-10
Mar-10
Apr-10
60 May-10
56 Jun-10
Jul-10
Aug-10
44 Sep-10
46 Oct-10
Nov-10
Dec-10
Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10
(Formula)
Jul Aug Sep Oct Nov Dec
32 32 35 38 42 44
26 30 34 41 51 56
29 33 38 45 46 46
35 38 44 49 55 60
0 0 0 0 0 0
DO NOT EDIT THESE CELLS (AUTOMATIC)
2008 2009 2010 10 Target Forecast
2 0 1 2 0
9 2 6 9 0
15 7 9 15 0
22 11 13 21 0
23 16 19 25 0
29 20 23 30 0
32 26 29 35 0
32 30 33 38 0
35 34 38 44 0
38 41 45 49 0
42 51 46 55 0
44 56 46 60 0
AUTOMATIC
Forecast
Jan-10
Feb-10
Mar-10
Apr-10
May-10
Jun-10
Jul-10
Aug-10
Sep-10
Oct-10
Nov-10
2 3 4 5 6 7 8 9 10
11 12 13
Essex Historic CHILD KSI Casualties
DFT target (to 2010) KSI Casualty data PSA Adjusted Target Line
160
144
137
140
144 131
124
117
120 111
124
120 119 104
111 98
100 108
91
KSI Casualties
85
81
78
80 89 75
70 72
78 65
74 74 60
60
56
40 46
44
20
0
Baseline 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010
Years
Rolling 12 monthly CHILD KSI Casualties from July 2005 to date
Pre intervention Post intervention (From July 2007) 2010 DfT Target LTP2 Adjusted Target
120
100
Cumulative KSI Casualties
85 78
80
70
65
72 74 62
(July 2007)
60
December
40 44 2009
(December 2008)
20
0
Month
Return To
Return To
Menu Screen
Menu Screen ? Zoom IN Zoom OUT Epping Forest
8
2009 2010
RETURN LABELS
RETURN LABELS
DISTRICT 7
6
5
KSI Casulaties
4
3
2
YEAR
1
MONTH
0
Jan Feb Mar Apr May
Jan Feb Mar Apr
2008 1 1 2 2
2009 0 0 0 0
2010 0 1 1 1
2010 Target
Indicator
1 1 2 2
Epping Forest 2010 Cumulative CHILD KSI Progress
2010 Target Indicator 2008
7
4
May Jun Jul Aug Sep Oct Nov Dec
May Jun Jul Aug Sep Oct Nov Dec
2 4 4 4 4 4 4 4
2 2 2 3 4 4 6 6
1 1 2 2 3 4 4 4
3 3 4 4 5 6 6 7
456 456 456 456 456
Epping Forest
Epping Forest Epping Forest
Epping Forest Epping Forest
1 2007 2008 2009 2010 2009 Target Indicator
2 Jan 1 1 0 0 1
3 Feb 2 0 0 1 1
4 Mar 0 1 0 0 2
5 Apr 1 0 0 0 2
6 May 1 0 2 0 3
7 Jun 0 2 0 0 4
8 Jul 0 0 0 1 4
9 Aug 0 0 1 0 5
10 Sep 2 0 1 1 5
11 Oct 2 0 0 1 6
12 Nov 0 0 2 0 7
13 Dec 1 0 0 0 7
Check
9
Epping Forest
Epping Forest Epping Forest
Epping Forest
1 2008 2009 2010
2010 Target Indicator
2 Jan 1 0 0 1
3 Feb 1 0 1 1
4 Mar 2 0 1 2
5 Apr 2 0 1 2
6 May 2 2 1 3
7 Jun 4 2 1 3
8 Jul 4 2 2 4
9 Aug 4 3 2 4
10 Sep 4 4 3 5
11 Oct 4 4 4 6
12 Nov 4 6 4 6
13 Dec 4 6 4 7
Epping Forest
LINKED CELL TITLE Epping Forest 2010 Cumulative CHILD KSI Progress
450 Basildon 2009
451 Braintree 2010
452 Brentwood
453 Castle Point Legend
454 Chelmsford
455 Colchester
456 Epping Forest
457 Harlow
458 Maldon
459 Rochford
460 Southend
461 Tendring
462 Thurrock
463 Uttlesford
Formula 2 3 4 5
456 January
Epping Forest February
2010 Target Indicator March
1 April
1 May
2 June
2 July
3 August
3 September
4 October
4 November
5 December
6
6
7
Check
8
ng Forest 2010 Cumulative CHILD KSI Progress
2010
6 7 8 9 10 11 12 13
Zoom IN Zoom OUT Chelmsford Historic CHILD
Return To Menu
Return To Menu
Screen
Screen 20
18
18
?
16
DISTRICT 14
KSI Casualties 14
12
10
10
8
6
6
4
2
DFT target Indicator (to 2010
0
Chelmsford Historic CHILD KSI Casualites
10
11 9
9
9
7 8
7 7
7
5
4
2010) KSI Casualty data Baseline
Years
454 454
Chelmsford Chelmsford
KSI Target
7 Baseline 16
8 1999 14 16
9 2000 6 15
10 2001 18 14
11 2002 10 13
12 2003 7 13
13 2004 7 12
14 2005 11 11
15 2006 9 11
16 2007 7 10
17 2008 5 9
18 2009 4 9
19 2010 7 8
450 Basildon
451 Braintree
452 Brentwood
453 Castle Point
454 Chelmsford
455 Colchester
456.2 Epping Forest
457 Harlow
458 Maldon
459 Rochford
460 Southend
461 Tendring
462 Thurrock
463 Uttlesford
LINKED CELL Chelmsford
TITLE Chelmsford Historic CHILD KSI Casualites
14 2010 CHILD KSI Casualties (to 4th Quarter)
Return To Menu
Return To Menu
Screen
Screen
12
?
10
Zoom IN Zoom OUT 9
YEAR
KSI Casualties
8
7
7 7
6 6
6
QUARTER 4 4 4
4
3
2
2
0
HIDE Target
HIDE Target
Indicators
Indicators
2010 450 451 452 453 454 455
4th Quarter Basildon Braintree Brentwood Castle Point Chelmsford Colchester
1st Quarter 2 0 0 1 3 1
2nd Quarter 0 3 3 0 2 1
3rd Quarter 1 2 0 2 2 2
4th Quarter 1 1 1 0 0 2
Total 4 6 4 3 7 6
4th Qtr Target
Indicator
9 7 2 4 7 7
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 4th Qtr Target Indicator
13
11
9
8
7 7
6 6 6
4
4
4
3
2 2 2
1
0
456 457 458 459 460 461 462
Epping Forest Harlow Maldon Rochford Southend Tendring Thurrock
1 1 0 0 2 0 4
0 2 0 1 1 1 3
2 0 0 0 6 4 2
1 0 0 0 4 1 2
4 3 0 1 13 6 11
7 4 2 4 8 6 9
hid-->
9 4 8 17 13 19 5
9 4 8 16 12 18 4
8 4 7 15 12 18 4
8 4 7 14 11 17 4
7 3 7 13 10 16 4
7 3 6 12 10 15 4
6 3 6 12 9 14 3
6 3 5 11 9 13 3
6 3 5 10 8 12 3
5 2 5 9 7 11 3 92
Target calculations: DFT Baseline = 143.6
Calculated Baseline = 143.6
Baseline to 2010 = Baseline 143.6 Slope -6.52727
1 1999 143.6 144 Intersect 150.1273
2 2000 137
3 2001 131
4 2002 124
5 2003 117
6 2004 111
7 2005 104
8 2006 98
9 2007 91
10 2008 85
11 2009 78
12 2010 71.8 72
2005 to 2007 1 2004 1075 1075 Slope -77.6667
(PSA Target) = 2 2005 997 Intercept 1152.667
3 2006 920
4 2007 842 842
New Essex
NewEssex
165
157
148
138
110
143.6 (NOT DfT RECOGNISED BASELINE / TARGETS)
143.6
72 (NOT DfT RECOGNISED BASELINE / TARGETS)
LTP2 Target Basildon Braintree
450 451
2006 12 9
LTP2 targets ---> 2007 11 8
2008 11 8
2009 10 7
2010 9 7
72 (NOT DfT RECOGNISED BASELINE / TARGETS)
Slope = -5.25
Intercept = 86.25
LTP2 Target used % of baseline
1 2006 81 81 81 56%
2 2007 76 75 52%
3 2008 71 70 49%
4 2009 65 65 45%
5 2010 60 60 60 42%
Brentwood Castle Point Chelmsford Colchester Epping Harlow Maldon Rochford Southend Tendring
452 453 454 455 456 457 458 459 460 461
3 5 9 9 9 6 3 5 10 8
3 5 8 8 8 5 2 5 10 8
3 4 8 8 8 5 2 4 9 7
2 4 7 7 7 5 2 4 8 7
2 4 7 7 7 4 2 4 8 6
Thurrock Uttlesford
462 463
12 3
11 3
10 3
10 2
9 2
2