daveallan81

Work continues on the project and there have been a few recent updates. Please read the opening post and get in touch if you can assist in any way. Collectors of junior results may be interested in these two new files, neither match was fully reported in Speedway Star. Heat details are taken from marked programmes: 10/05/78 Teesside Northern Junior Championship http://www.dropbox.com/s/psy8mja8zgchx4d/1978%2010%2005%20TNJC.pdf 29/09/83 Middlesbrough Tiger Cubs v Wimbledon Junior Chalfont Dons http://www.dropbox.com/s/1r0uuenrw5qrvdi/1983%2009%2029%20Midd%20v%20Wimb.pdf

Speedway Star reports this heat (13) as void. Do you recall what happened? The 1991 Coventry one, was that when the referee (Will Hunter?) excluded the only remaining rider (Rick Miller?) for not trying?

Thank you kindly.

Ghostwalker, can you confirm the referee for the Smederna meeting? Also, heat 12 - did Michelsen definitely complete the race? He seemed to grind to a complete halt on the last bend. Thanks.

I just dug out the programme for this and - it's blank. Programmed line-up any use to you in the interim period?

I imagined the feed would come in on a bigger screen, apart from that pretty much what I expected to see. Cramped and claustrophobic but so atmospheric when you put the lights down. Nice work if you can get it, what's the dough like? The time has come to fulfill my destiny as the Ted Lowe of speedway. For those of you watching on freebie internet feeds the white rider is directly behind the yellow. I missed the Aspegren change as well. That's a rarity - a rider replaced by a reserve in a rerun with no exclusion or fall to speak of. It came up on the titles pre-race so no excuses really. He did correct his error, and mine, as soon as he realised so fair play.

Was the result of Heat 7 amended? Official Svemo score gives Jedrezak third and Kasprzak fourth but it was the other way round on screen.

The original colours were for reference purposes only, just showing the competitors. Events 1 & 2 are the same, re-arrange the team names if necessary once the draw is revealed. Thanks for your PM - coding error now corrected across each round and the workbook, with qualifying round results completed, has been reloaded to http://www.dropbox.com/s/8z042fnfvqun2ra/SWC%202014%20Series%20Workbook.xlsx

What happens with the bonus point in the event of a tie? Looks to me like no-one gets it?

When the commentator loses track of what he's commentating on because he's watching wee lassies doing handstands at the bottom of his screen he is clearly not fit for purpose.

From tonights Bet365 broadcast of Swindon v Wolverhampton, here are the approximate times taken from two minutes being sounded until tapes were released for each heat (mins:secs): Ht 01: 2:11 Ht 02: 1:53 Ht 03: 2:01 Ht 04: 2.38 Ht 05: (RR) 1.52 (missed first attempt, making tea!) Ht 06: 2:04 (all 4 riders on track when 2 mins sounded) Ht 07: 1:57 Ht 08: Not Sounded Ht 09: 1:21 (3 riders at tapes when 2 mins sounded) Ht 10: 1:39 Ht 11: 1:33 Ht 12: 1:48 & (RR) 2:36 (Worrall arrived at tapes at 1:54) Ht 13: 2:08 Ht 14: 1:57 Ht 15: 2:19 I didn't time Ht 8 but there appeared to be no discernable delay in the race starting without the 2 minutes being sounded. Some leeway awarded to Worrall in the restart of Ht 12 otherwise the slower starts were all attributed to riders not obeying start marshall instructions to approach the tapes. The countdown clock would eradicate that and I'd implement it in the same way as Poland - miss the 2 mins and you're out, no replacement.

I was sent them around 2007 to sort out some formatting issues. I cannot for the life of me remember who the sender was but I do recall they were someone else's work again. I expect the author is a contributor to the Speedway Researcher website as I've seen some of the results replicated on there. It's an outstanding body of work. My contribution are the files post-2007, easily harvested from the internet and if I come across any errors on older sheets I correct them, otherwise the credit lies with the anonymous author.

I believe this is the clip you're on about. I don't use YouTube so if you can't get it to play, download it and watch on your preferred media player: https://www.dropbox.com/s/qfxvwcoappajlfm/1982PenhallvCarterNewAngle.mpg

Here's one for the ERC, or indeed any other individual meeting using the 1 semi-final and final formula. You can change the header and riders names if required. Helmet colours can be added as necessary for reserve rides and for the semi-final and final. Best viewed in full screen mode. For Excel 2007 and newer: https://www.dropbox.com/s/sdv0ubjg22tfm6z/UK2014ERC.xlsx For Excel 97-2003: https://www.dropbox.com/s/k0269z0jeibgrss/UK2014ERC97.xls Use N (not the new RS) to denote a reserve replacement.

That's some formula for the riders total scores

I'm still on XP I'm told http://www.dosbox.com is worth a look for playing old MS-DOS games.

Here you go https://www.dropbox.com/s/ry60a3slrhtvokw/1989BLRC.pdf I don't have heat details, sorry.

Is this what you're looking for? http://www.speedway-meeting.com/

At the risk of being pedantic, the riders totals and heat totals won't show half points Not that we seem to get any these days... I'm not having any of the problems you're describing Mimmo & TWK. Are you entering the name in the first cell and overwriting h1, h2 etc? Here's my effort for this season. Totally different concept, you will need to scroll the page but you can enter more information. While the racecard itself can be exported (saved) as an Adobe PDF, the purpose of said card is to produce the report, again for transferring to PDF. I've filled it out with an imaginary match showing what can be added and where. A lot of the information is prepared in dropdown boxes but these can be overwritten if need be. Have a poke around and you'll soon get the idea. Only cells that require user input are open, everything else is locked out, so you can't delete anything vital. Excel 2007 or newer is recommended, however it should run on 97-2003. For 2007 - users: https://www.dropbox.com/s/jvg8v5g6nb499nf/UK2014EL.xlsx 97-2003: https://www.dropbox.com/s/ycqs9b76xjxwywq/UK2014EL97.xls PDF report example: https://www.dropbox.com/s/08j25a1n67acool/UK2014ELexample.pdf I haven't tested it to destruction but am using the 'engine room' of the file elsewhere and it's going ok. Only other thing to note, enter rider names (if not using the dropdown choices) in what excel calls 'proper' type ie Tai Woffinden - this allows the TR rider to be shown correctly in the report. It is set up for my needs, namely to produce the Star-style report, but I've come to regard that as a better way to present the information, having initially preferred reproducing a racecard. Not to everyone's tastes but there you have it. And all that started with SCB's wee file

Good grief. I've had the old version of your racecard for ages, had no idea where I'd downloaded it from or who the creator was. What a useful man you are. That wee card got me interested in producing excel sheets for research purposes, and watching matches on the telly. I'll post my 2014 effort up later but it wasn't designed with anyone but me in mind, though I'm sure you clever types could work it out. Swap out the green helmet colour by the way

J. MacFarquhar is John.

No bonus point awarded. Similar example from 1981 at Glasgow, Cribb and McKinna tied for 2nd behind Lawson, McKinna didn't receive a bonus. I don't think bonus points are/were paid in any race with a dead heat.

William Freeland and Paul Terry are the only two I recall from that list. I think J.MacFarrahar may be J. MacFarquhar.

30th May 1970, Wembley v Hackney, British League Div. 1. Lions won 41-37. It was match 6 before the Dons rolled up, 4th July, the Lions again winning by the same scoreline. Wasn't there 70/71 footage on the History of Speedway/Wembley video from several years ago?

Resolved, thank you.