atomant Posted June 14, 2005 Author Report Share Posted June 14, 2005 (edited) If you have entered the section scores as 3-1-0 rather than just the total 4 then your spreadsheet should be able to do a scond sort on cleans flowing down to 1's 2's and 3's to sort tie breaks. Yes I agree ! But to do that, I would have to enter 2280 bits of information instead of 570. There were only 4 clashes which need a cleans count and it took just a few minutes to check them out. It would of taken much longer to put the other 1710 numbers into the spreadsheet and do it automatically. I could make it do that for peeps who want to do it like that. it would be no problem! regards Edited June 14, 2005 by Webmonkey Quote Link to comment Share on other sites More sharing options...
bigfoot Posted June 14, 2005 Report Share Posted June 14, 2005 Webmonkey I run or help to run the Bon Accord MC in Aberdeenshire. I've played about with various spreadsheets in the past but your one does look good. I'd be interested in a copy when ready or I'll help beta test it if you like. Quote Link to comment Share on other sites More sharing options...
perce Posted June 14, 2005 Report Share Posted June 14, 2005 If you have entered the section scores as 3-1-0 rather than just the total 4 then your spreadsheet should be able to do a scond sort on cleans flowing down to 1's 2's and 3's to sort tie breaks. Yes I agree ! But to do that, I would have to enter 2280 bits of information instead of 570. There were only 4 clashes which need a cleans count and it took just a few minutes to check them out. If would of taken much longer to put the other 1710 numbers into the spreadsheet and do it automatically. I could make it do that for peeps who want to do it like that. it would be no problem! regards Most sets of results I see in the North of England carry full section results, ours have done for quite some time. Last years 3 Day results:- http://www.richmondmotorclub.com/cms/showa...hp?articleID=39 The programe used for the Scott allows for 200+ riders doing a single lap of 80 sections & includes time. It also works out all the awards, there are dozens. All entrants are sent out a section by section set of results. Quote Link to comment Share on other sites More sharing options...
atomant Posted June 14, 2005 Author Report Share Posted June 14, 2005 (edited) The programe used for the Scott allows for 200+ riders doing a single lap of 80 sections & includes time. It also works out all the awards, there are dozens. All entrants are sent out a section by section set of results. Thats a lot of data would be nice if it was formatted in nice clean rows I made this purely for the average club which has just a few hard working souls keeping it going to lighten the workload a bit. Its not meant to be for the big scale stuff. (although I could make it do all the stuff that you mentioned) If peeps want the 40 section scores then thats ok to do. I could give them the option in the same workbook In fact, I will do just that Edited June 14, 2005 by Webmonkey Quote Link to comment Share on other sites More sharing options...
chris Posted July 23, 2005 Report Share Posted July 23, 2005 Webmonkey I know it probably to short notice but if you still want me to try your scoring system I will quite happly try it out tomorrow after our trial. Cheers Chris Quote Link to comment Share on other sites More sharing options...
atomant Posted July 24, 2005 Author Report Share Posted July 24, 2005 Theres a bit of work to do setting up the program on your comp like producing the custom sort lists and creating the custom Macro buttons and then building the database of your clubs riders names & details ( although you can do this as you go along ) I can provide details on how to do this with the spreadsheet.. But its best that I talk you through it using MSN Messenger.. My MSN is viciouss@mods-r-us.net . If your currently typing in all the data and doing manual sorts and stuff like that. This will save you loads of time and when set up, is easy to use. feel free to contact me Quote Link to comment Share on other sites More sharing options...
atomant Posted August 19, 2005 Author Report Share Posted August 19, 2005 Update: Kirsty (South Shropshire MCC )has kindly been testing the 10 section version for her last 2 trials and overall it has performed well however, a few things have popped up during its use mainly due to the strict configuration of the worksheets. i.e. you cant cut and paste stuff and add/delete columns and rows without upsetting its configuration. So I have been working on putting controls to either stop or warn the user if they are likely to do something that they shouldnt. The other problem comes from the use of Macros. At the moment, to get the buttons up on the control bar at the top to run the macros means I have to do it myself ( or the user can do it if they have a very good understanding of excel) so I am working on producing a set-up macro that you run just the once when you first use the program and it does it for you. I am also working on a complex 40 column scoring system for the SHEFFIELD & HALLAMSHIRE MOTOR CLUB. This version uses just three classes hard/clubman/easy and they type in all scores from the 40 sections. Does anyone else do this? When they are fully tested, I will release copies on here under a shareware license and see how it goes. Quote Link to comment Share on other sites More sharing options...
chris Posted September 2, 2005 Report Share Posted September 2, 2005 Webmonkey We've got another trial on this sunday if your scoring system is ready for testing. Cheers Chris Quote Link to comment Share on other sites More sharing options...
atomant Posted September 2, 2005 Author Report Share Posted September 2, 2005 Chris, I am inundated with stuff to do at the moment plus im in the middle of building Ross Danby's website . I havent finished completely your spreadsheet as its quite complex . its about 85% done. I'll drop you a mail asap as soon as its ready.. probally be another week i reckon. Quote Link to comment Share on other sites More sharing options...
chris Posted September 3, 2005 Report Share Posted September 3, 2005 No problem 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.