SCB Posted March 12, 2014 Report Share Posted March 12, 2014 (edited) I was amazed this winter that a few people asked me if I was going to be updating the racecard I made years ago to reflect the new heat format. So I did. Its HERE should anyone want a copy. Simple put the names of the riders up the top in the grids and it fills in the heads for you. Add the riders scores in each heat and it;ll put the scores up the top for you. If theres a a reserve/sub/rr then put the riders name, spelt as above in the substitute column and it'll do all the calculating for you. Put an ! after any TR rides so it can calculate a team mates bonus point correctly Useful if you're sat in front of the tele watching a meeting and too lazy to do any maths! Edited May 15, 2014 by SCB Quote Link to comment Share on other sites More sharing options...
SCB Posted March 12, 2014 Author Report Share Posted March 12, 2014 Me personally, I'm amazed anyone was still using mine and it's going to have been download many times less as the user can update it themselves, they don't need me to do it - Proper IT, automation/letting the end user do it not the highly skilled, greater cost IT expert LOL Quote Link to comment Share on other sites More sharing options...
Parsloes 1928 nearly Posted March 12, 2014 Report Share Posted March 12, 2014 Well personally I'm astonished you, SCB, of all people should be bothered with such a thing - considering you're always telling us you never complete one because you can remember all the heat results and therefore progressive score in your head!!! Quote Link to comment Share on other sites More sharing options...
daveallan81 Posted March 12, 2014 Report Share Posted March 12, 2014 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 Quote Link to comment Share on other sites More sharing options...
Parsloes 1928 nearly Posted March 12, 2014 Report Share Posted March 12, 2014 Swap out the green helmet colour by the way Ah ha, so SCB's not so clever after all!!! Quote Link to comment Share on other sites More sharing options...
waiheke1 Posted March 12, 2014 Report Share Posted March 12, 2014 What I really want to know scb is whether your racecard is "truly innovative?" 1 Quote Link to comment Share on other sites More sharing options...
SCB Posted March 12, 2014 Author Report Share Posted March 12, 2014 (edited) Swap out the green helmet colour by the way Thats the first mistake, now for the rest! What I really want to know scb is whether your racecard is "truly innovative?" Well its about 10 years old now, so probably not.But then we all know things were better in the good old days, so sod innovation I say! Edited March 12, 2014 by SCB Quote Link to comment Share on other sites More sharing options...
The White Knight Posted March 13, 2014 Report Share Posted March 13, 2014 Thats the first mistake, now for the rest! Well its about 10 years old now, so probably not.But then we all know things were better in the good old days, so sod innovation I say! What a STAR you are SCB. With comments like this - you may overtake jacques in my affections as favourite Poster. :approve: 1 Quote Link to comment Share on other sites More sharing options...
lucifer sam Posted March 13, 2014 Report Share Posted March 13, 2014 (edited) What a STAR you are SCB. With comments like this - you may overtake jacques in my affections as favourite Poster. :approve: TWK, I thought Tsunami was your favourite poster, or have you had another tiff over him using the last of the milk, leaving you none for your cornflakes at breakfast. All the best Rob Edited March 13, 2014 by lucifer sam 2 Quote Link to comment Share on other sites More sharing options...
Mimmo Posted March 13, 2014 Report Share Posted March 13, 2014 I was amazed this winter that a few people asked me if I was going to be updating the racecard I made years ago to reflect the new heat format. So I did. Its HERE should anyone want a copy. Simple put the names of the riders up the top in the grids and it fills in the heads for you. Add the riders scores in each heat and it;ll put the scores up the top for you. If theres a a reserve/sub/rr then put the riders name, spelt as above in the substitute column and it'll do all the calculating for you. Useful if you're sat in front of the tele watching a meeting and too lazy to do any maths! When I attempt to write a riders name in the score-chart, a message comes up telling me that the 'Protected cells can not be modified', is there a way round that please? Quote Link to comment Share on other sites More sharing options...
The White Knight Posted March 13, 2014 Report Share Posted March 13, 2014 When I attempt to write a riders name in the score-chart, a message comes up telling me that the 'Protected cells can not be modified', is there a way round that please? Same here SCB - I have tried to alter a Name I entered and I cannot - it asks for a Password. I have tried to alter it to Unprotected Sheet in the 'Review' Section but that doesn't work either. Can you help please? Quote Link to comment Share on other sites More sharing options...
daveallan81 Posted March 13, 2014 Report Share Posted March 13, 2014 Thats the first mistake, now for the rest! 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 Quote Link to comment Share on other sites More sharing options...
SteveLyric2 Posted March 13, 2014 Report Share Posted March 13, 2014 I was amazed this winter that a few people asked me if I was going to be updating the racecard I made years ago to reflect the new heat format. So I did. Its HERE should anyone want a copy. Simple put the names of the riders up the top in the grids and it fills in the heads for you. Add the riders scores in each heat and it;ll put the scores up the top for you. If theres a a reserve/sub/rr then put the riders name, spelt as above in the substitute column and it'll do all the calculating for you. Useful if you're sat in front of the tele watching a meeting and too lazy to do any maths! .....or to actually attend a meeting!! Quote Link to comment Share on other sites More sharing options...
Penny Cross Posted March 13, 2014 Report Share Posted March 13, 2014 When I attempt to write a riders name in the score-chart, a message comes up telling me that the 'Protected cells can not be modified', is there a way round that please? I had the same problem. I then worked out that all I had to do was click on the H1,H2,A1,A2 etc,etc. NOT the middle of the box. Hey presto, it works! Simples! Quote Link to comment Share on other sites More sharing options...
Dornier Posted March 13, 2014 Report Share Posted March 13, 2014 Thanks SCB.....Was wondering what we would do without the SKY programmes Quote Link to comment Share on other sites More sharing options...
Mimmo Posted March 13, 2014 Report Share Posted March 13, 2014 I had the same problem. I then worked out that all I had to do was click on the H1,H2,A1,A2 etc,etc. NOT the middle of the box. Hey presto, it works! Simples! Thanks for that. Quote Link to comment Share on other sites More sharing options...
TonyE Posted March 13, 2014 Report Share Posted March 13, 2014 Any chance of the 'password' so we can tinker with it SCB? Quote Link to comment Share on other sites More sharing options...
manchesterpaul Posted March 13, 2014 Report Share Posted March 13, 2014 (edited) In response to emails i should state that (like Carlsberg lol)* i don't do domestic league racecards as i feel the clubs need every penny they can get from league fixtures and i wouldn't wish to deprive them of even a single programme sale in the event supporters should print out ahead of actually attending a meeting. Having said that Sky themselves used to produce a printable racecard on their website for the televised matches, not sure but it may be a blank one though in which case for television viewers the SCB one is needed. *(i'll refrain from saying but if i did like Carlsberg they'd be.... LOL noooooo i so not going there) JOKE! Edited March 13, 2014 by manchesterpaul 1 Quote Link to comment Share on other sites More sharing options...
SCB Posted March 14, 2014 Author Report Share Posted March 14, 2014 I'll be fixing it later with all the feedback. I'll also remove the password - It's just habit to do it at work as I don't trust the minions Quote Link to comment Share on other sites More sharing options...
The White Knight Posted March 14, 2014 Report Share Posted March 14, 2014 I'll be fixing it later with all the feedback. I'll also remove the password - It's just habit to do it at work as I don't trust the minions THANK YOU SCB!!! That would be great. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.