daveallan81

There's an Excel racecard for tonight's match here https://www.dropbox....il 2013).xlsx?m Best viewed 'full screen' on Excel 'view' options. Looking forward to this one and on the subject of guests think on this - in my first 8 seasons of watching NL racing in the 80's I saw 5 guest riders, and not one for an injured rider. How times have changed...

Anyone fancy trying these out? Excel workbooks for todays fare, one to complete on your PC and one for printing out if you prefer. https://www.dropbox.com/sh/nvqnqf4sbz9750z/avrR1qWMGQ?m Blank templates are also in the folder. Please note this is a one-off, I've no plans to upload meeting-ready sheets every week. Use the Sportowefakty links kindly provided by other posters for line-ups etc, or just take them from the broadcast if you're a fast typer

I thought I'd give the programme a couple of meetings to settle in before passing any comment. The Inside Track feature is as good an idea as any for filler between heats or stoppages. Does Chris pick out the subjects to analyse himself, or is he directed? Just curious. The Round The Tracks is a welcome addition, and should come into it's own towards the business end of the season. Co-ordinating the updates with the beginning of live races looks pretty slick, I'd be keeping that in. Not so much an addition as an improvement, but credit where it's due to Nigel and Kelvin who have undoubtedly worked on their co-commentating roles over the winter. Far less talking over each other, and a tad more constraint during the 'exciting' moments is making for a better, dare I say more professional, production. Chris Louis looks a bit more confident in front of the camera considering he is practically guaranteed to be hung out to dry by non-compliant technology one evening (or is his slot delayed to cover this?). Sam and Charlie - ach, if they're reliable, presentable and turn up sober when they're meant to that's half the battle in showbiz and if anyone fancies their chances of doing better I'm sure Sky would love to hear from you.

Call me fickle but is the main point of a pairs meeting not that teams compete as a 'pair'? Is this merely the Ice Speedway WTC on shale, or a glimpse into the future of the conventional WTC?

To be fair to Edinburgh they have always tried to put their best foot forward when it comes to the Open. I'm not sure you'd get a lot of mileage out of billing it as Britain's Oldest/Longest Running speedway event but it certainly warrants a mention I'd say. This year will be it's 85th birthday, there's a nice round number to stick on the publicity...

1 2 1 2 3 4 3 4 2 7 2 7 1 3 1 3 5 6 5 6 1 2 3 4 3 4 5 6 5 6 1 2 4 7 4 7 1 2 5 6 5 6 3 4 3 4 1 2 5 6 5 6 1 3 2 4 2 6 3 6 4 5 1 5 Shown as R / B / W / YB

Thanks for that. Yes it was an added heat, I've got a note of it on a seperate slip of paper. Thanks again.

In the 2nd half of Exeter v Glasgow 1/7/85, I've got a rider by the name of Marvyn Cross. I can't find any reference to him for the 85 season, and I'm wondering if it was in fact Matthew Cross who was part of the Swindon junior set-up. Can anyone enlighten me?

Yeh I know that now...ignore me I'm old...

It came as news to me and knackered my sheet a bit into the bargain. Another wee change I spotted was that a zero points return now ranks higher than a disqualification in rider ties. Which I take to mean if rider A scored 3 2 1 1 R and Rider B scored 3 2 1 1 X, Rider A would rank higher. Last season they would have been deemed as equal and gone to head-to-head. I think the change to 3-2-1-0 is for the better,

Completely ludicrous notion! Monopoly is all about one person building an empire and stripping everyone else of their cash. What's that got to do with speedway? Building houses and hotels on tracks is pretty realistic I grant you...

Thanks R 'n' R.

Can anyone confirm the following from the Speedway FAQ website is true: "The actual gate sequence used during the match is determined by the team captain winning the toss of a coin prior to the start." So same gate column all the way through as opposed to UK with our choice for first or last heat?

Fair enough...however...bonus points are only used for the Heat 15 calculations and in the pay packets. So will a rider still be credited with say 5+2 on the scorechart when he's only actually paid for 5+1?

SGP 2013 Excel Workbook & Tutorial https://www.dropbox.com/sh/3ygjvzibe0infyn/tJ3OcuJZy9?m SWC 2013 Excel Workbook & Tutorial https://www.dropbox.com/sh/qyguy0tkpiayk3s/6T6h5i9QP6?m

15.9.3 In a Team Competition, a Rider shall be awarded a Bonus Point if s/he finishes in 2nd or 3rd place immediately behind his/her partner, this shall not count towards the Meeting score. Was there a change of plan re. not paying 3rd place bonus in the PL? No clarification offered anywhere in the regs I can find.

I was given results lists from 1928-2007 a while ago. I can't vouch for the validity of the results but the chap I got them from was a major speedway statto so they'll be 99.9% accurate I'd bet. https://www.dropbox.com/sh/cqm1esjaw6ev7vd/zyPpMz-VVh?m

Losthammer, thanks for all that information. I'll post a note on my Dropbox page shortly to bring it to folks attention. Thanks for your comments and very much appreciate your input Edit: You may want to re-download a fresh EL file - it was pointed out to me that the Coin Toss cell was locked out so have upped fresh file

From the quickfire reading I've done this seems to be an Excel/Mac/iPad conflict. I'm seeing an app called 'Numbers' being touted as the closest thing to MS Excel.

Interesting. There should be no password required to open and use the files. I've just downloaded both and haven't received any password request. Can I just confirm that this is as you are double-clicking the file to open?

Thanks - yes missed a bit of the coding. Should be sorted now. Appreciate the testing, anything looks wrong at all keep letting me know (although hopeful that's it sorted). Started on a SWC workbook as well, thought it might come in handy.

He's Chris's evil twin... Thanks Kiwi, I'll fix that ASAP. Edit: Fixed

The 2013 workbook is now available along with a tutorial for completing it. Enjoy

I've been working on a full series Excel workbook for the GP and to check it all works I ran it for the 2012 season. All the rounds are on YouTube so I was able to fill the results in 'real-time' and after not a little jiggery-pokery everything seems in order so I should have the 2013 one ready shortly. In the meantime if you'd like to take a look via the link in my signature, then navigate to the Speedway Grand Prix folder, you'll find the completed Excel workbook and a PDF file compiled from the finished workbook pages. The Excel sheet is read-only just to show the layout and formatting. All comments/opinions welcomed although I will add that the layout of the sheets are directly related to producing the PDF file or printout so the sizes have to remain as they are. And it's best viewed in 'full-screen' mode especially if you have a widescreen monitor.

Sorry, I'd add that to the top of the naff list along with the aggregate bonus point system that it replaced.