Safe Speed Forums

http://www.dft.gov.uk/stellent/groups/d ... =17621&l=2

Help! I need help getting all this entered into a spreadsheet ASAFP!

_________________
Paul Smith
Our scrap speed cameras petition got over 28,000 sigs
The Safe Speed campaign demands a return to intelligent road safety

Paul

Don't hold your breath but I am trying to use OCR on this.

I will let you know how it works.

Regards

Malc

Sorry OCR no good - lack of quality in images. Working in morning so cannot offer time to type them Sorry!!!!

Blimey! has it been a year already?

I've been working on Dorset's.
I'm not quite sure how to put in the formula for the percentages though. I might have to actually type them in!

Is OpenDocument Spreadsheet format ok?

Edit...

My summary:
Template: OpenDocument XLS

Cumbria: OpenDocument XLS
Devon and Cornwall: OpenDocument XLS
Dorset: OpenDocument XLS
Hampshire and Isle of Wight: OpenDocument XLS
North Wales: OpenDocument XLS
Sussex: OpenDocument XLS

_________________
Andrew.

Looked at Leicester....

79% of NIPs were converted to FPNs

and only 74% of FPNs were ever paid.

If I am reading this correct 26,000 NIPs never resulted in a conviction.

Only 58% of detections resulted in a conviction..........

_________________
Speed camera policy Kills

Leicester are obviously laggin behind then, Dorset had 101% of their FPNs paid in Qtr 2 and 119% in Qtr 4.

_________________
Andrew.

I've rushed out a quick PR to get the ball rolling at 22:56. We're missed tomorrow's papers, which is OK.

PR433: Speed camera plans wildly optimistic

news: for immediate release

Figures released today by Department for Transport showing latest accounts of
the various speed camera partnerships reveal that most partnerships issued far
fewer fines than expected.

Difference between 'operational case' and 'actual' figures for each partnership:

Avon and Somerset -36%
West Midlands -30%
Greater Manchester -26%
Derbyshire -25%
Cleveland -24%
Cambridgeshire -22%
Wiltshire and Swindon -17%
London -16%
Hampshire -16%
Norfolk -14%
Cheshire -14%
Suffolk -13%
Warwickshire -12%
Nottinghamshire -12%
Kent and medway -12%
Hertfordshire -11%
Bedfordshire and Luton -10%
Devon and Cornwall -10%
Dorset -9%
Mid and South Wales -8%
West Mercia -5%
Surrey -4%
Thames Valley -3%
Northamptonshire -3%
Cumbria -3%
Gloucestershire -2%
North Wales -1%
West Yorkshire 0%
Merseyside 1%
Humberside 1%
South Yorks 2%
Northumbria 3%
Lincolnhire 7%
Essex 9%
Staffordshire 10%
Sussex 10%
Leicestershire 11%
Lancashire 15%


* 27 out of 38 partnerships issued fewer fines than expected.

* In 18 partnerships the shortfall was 10% or greater

* In 6 partnerships the shortfall was greater than 20%


Paul Smith, founder of the Safe Speed road safety campaign
(www.safespeed.org.uk) said: "If there's one thing that has characterised the
speed camera programme from start to finish it's wild optimism. Every
single new set of real world figures makes speed cameras look worse. The beauty
is fading, and not before time. Speed cameras are a failed road safety policy.
They have made road safety worse; cost over £1 billion since 1993 and issued
over 16 million fixed penalty notices."

"The reputation of speed cameras sinks further with every day that passes. How
much longer do we have to wait for the inevitable admission of failure and the
final scrapping of all the infernal devices?"

"Speed cameras are entirely founded on false assumptions, dodgy science and
wishful thinking."

<ends>

Notes for editors
=================

Note that these figures have been available since around September 2006. The
choice of publication date is probably intended to coincide with VERY BAD NEWS
for the speed camera programme expected from Hull Crown Court on Thursday.

DfT partnership accounts for year 2005/6:
http://www.dft.gov.uk/stellent/groups/d ... rvertempla
te/dft_index.hcst?n=17621&l=2

Further analysis to follow...

***

I'm going to get something to eat, then figure out how the hell I'm going to deal with the rest. It's also a spoiler story, so tomorrow should be very interesting indeed.

_________________
Paul Smith
Our scrap speed cameras petition got over 28,000 sigs
The Safe Speed campaign demands a return to intelligent road safety

Template - this doesn't have all the calculations and isn't as nice as the one somebody else made last year. But I don't know where to find that one... I was so tired...

Dorset

Edit: I'll give Hampshire & IoW a go next.
If you want these in a different file format then let me know.

_________________
Andrew.

Deaths seem to have gone up in a lot of areas. Are they going to say it is because the pratnerships haven't sent out enough fines?! The fact the travelling public couldn't possibly know that and deliberately drove more dangerously might be glossed over...

Ack. Hampshire & IoW...
Totals for 11-15 are ok. Totals in line 16 are ok except 2,400,126 which I have as 2,406,126. There's no way I can make this add up...?!

Total for 36 is wrong (theirs looks 1 out)

I made some spelling mistakes on the template and Dorset's one.

Eek! why am I running on battery power? Erk.....

_________________
Andrew.

Ok, simple problem, "not plugged in". duh. Except it was the extension lead under the desk which had become disconnected!

Hampshire & Isle of Wight
I have updated the previous two with spelling mistooks and a couple of extre summed fields.
Now I'm going home. Might work on some more there after food and stuff.

_________________
Andrew.

Back now. Plugged in a keyboard with a numeric keypad.
Is nobody else joining in the fun?

I'll do Cumbria then.

_________________
Andrew.

Cumbria: Total for 16 works out 1 less then in theirs.
Total for 21 is 1 less.
Total of 23 is 1 up on theirs.
Total for 27 - I have 1 less.

Wow, Cumbria are sure wasting paper:
Ratio of FPNs issued fo NIPs issued this period: 4227%
For every NIP they issued 42.27 FPNs? PAY UP! PAY UP! PAY UP!
Maybe they got the numbers in the wrong place...

Done Cumbria.

Doing: North Wales.

_________________
Andrew.

I've been taking 'slices'.

I've just got NIPS issued (total 3 million NIPS) and FPNs paid - total 1.9m paid.

Oh look - there's over a million who got away with it. (actually it's a bit more complicated , but it's a headline...)

Next I'm most interested in looking at speeding cuts below budget...

_________________
Paul Smith
Our scrap speed cameras petition got over 28,000 sigs
The Safe Speed campaign demands a return to intelligent road safety

Done: North Wales.
Doing: Sussex.

Are they ok so far?

_________________
Andrew.

Sussex:
I have 1 extra on the total for 29. (What software do they use? Can't it add up?)

Total in 34 is out by 1 also.

Done Sussex.
Doing: Devon and Cornwall.

_________________
Andrew.

What's a '.ods' file type? Open Office? I can't actually open them immediately.

_________________
Paul Smith
Our scrap speed cameras petition got over 28,000 sigs
The Safe Speed campaign demands a return to intelligent road safety

Yes. Open Document Spreadsheet, I believe it stands for.
I suppose I could save them all in 'another' format...

_________________
Andrew.

Ok, I have edited my first post to create a summary including loadsa links to both formats of the files.

_________________
Andrew.

Done: Devon and Cornwall.
Doing: Lancashire.

No, there really is no order in which I am doing them.

_________________
Andrew.

Oh my - what a lovely job! (finally got access; I mean excel )

But it's much more important to our immediate purpose to have the main figures for all the partnerships on a single spreadsheet. We don't need the quarterly figures either.

Journalists need answers to questions like: 'top spending partnership', 'fewest fines', 'lowest conversion rates', 'total expenditure' those sorts of things.

_________________
Paul Smith
Our scrap speed cameras petition got over 28,000 sigs
The Safe Speed campaign demands a return to intelligent road safety