Jump to content
British Speedway Forum

Recommended Posts

 

At the risk of being pedantic, the riders totals and heat totals won't show half points :D 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 :t:

Do you still have these spreadsheets as the links no longer work

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy