Race serie Manager software

[azidahaka]

I was wondering if there's any around... Managing points, driver's and team standings is annoying and time consuming. There's lots of similar programs for soccer football, basket etc etc Is there one for Virtual racing series?

 

[rallymorten]

You mean a nice and easy way to make driver and team championship standings? Well, there's always Excel or Google Drive spreadsheets, but perhaps you're looking for a "Driver X finished <insert position>" and it would then automatically correct the data and update the sheet?

Long time no see by the way

 

[azidahaka]

Yeah, something like that for super lazy guys like i am lol!

Btw Wally why don't you take a look at my signature links and join us?

 

[rallymorten]

Some people just never grow from a certain point..

I might be able to come up with a solution for Google Drive (all it would require is that you fill in a form, nice and easy), potentially something for Excel too. I'll start a conversation once I'm making progress

Time and stuff seems about right-ish, but I'm not sure my internet connection agrees

 

[azidahaka]

Thanks mate, i had tought of using visual basic but it would have taken me ages now that i stopped programming in the last 4 years lol

Just jump in mate and we'll see wheter connection holds or not!

 

[srefre]

I was also thinking about doing something similar, so if you guys need any help etc... let me know.

 

[rallymorten]

Alright, because there's now more interest than just the two of us, I thought I'd share this to the public.

I've made a basic outline of how it could work as easily as possible. Surely there's a lot of functions that could be added, but remember, it's still basic

This one uses only three drivers, and only counts five events, but it works well as a demo.

What you do:

Enter the finishing positions of a driver in this form. Witchcraft happens and you'll be able to see the final results, sorting the drivers standings after most total points, here.

Try it out and see it work

 

[azidahaka]

Contact wally i'm sure he'll appreciate!

How would you tell the spreadsheet how many rounds, or how much points per position, pole and fast lap, or dropped scores?

I might have had ideas on VB but excel is dark magic to me lol

 

[rallymorten]

That's adjustments that would have to be made manually. But it's not too hard and only takes a few minutes

 

[srefre]

Obviously I'm interested to hear what Wally says, but in my mind, you'd use an Excel spreadsheet, with some VBA code to manage the items you speak of.

So, the sheet holds all the data, but when you want to set up a new championship, you click a button, and a pop up window appears, you enter the details, click ok, and it sets up the rounds and points system etc...

Same for each race, click a button, enter the round number and results and click OK, and the sheet does it's magic.

EDIT - Posts crossed.

 

[rallymorten]

That could work if you're more familiar with Excel (I'm not an alien at Excel).

I will try to evolve on this one though, see what I can do to make it even better 👍

 

[azidahaka]

I love u rally i'll look at it when i get home!

Can't help much with coding it but i can help with user interface lol

 

[rallymorten]

Sure, feel free to give feedback 👍

By the way, it's currently down for updates, adding a team demo. Not sure if it can deal with more than one drop-round nor multi-race weeks (e.g. series with a 2-race format), but let's see.

 

[azidahaka]

In season 2 i plan just 1 drop score and ny serie format is just one race per week, so fine by me lol

 

[rallymorten]

Small update:

I haven't been able to do much work on this project recently. Turns out the "fill-form-see-results" way makes the "solver" screw up the points.. It would though be possible if the numbers are just edited in by a series manager. That's not hard either

And I figured out how to make GDrive spreadsheets find not just the lowest, but also the second-lowest, third-lowest, heck, even the 1.000.000-lowest value!

 

[srefre]

I've made a little progress on my version also, I will do a bit more over the next day or two and then I will send to you guys if you're interested.

I'm making it basic at first, then if you guys think it's ok, tell me what features you want in, I will update.

 

[azidahaka]

@rallymorten @srefre

updates?

 

[rallymorten]

Not any recently. It's quite difficult to make it update when you enter data in the form, mainly because the data you enter is put on a previously non-esisting line. At least that's my experience.

It can be made relatively easy and "high-tech" if you can live with having to go to a "series manager's page" of the sheet. Then you'd only need to type in their position and it would do all the rest of it (including multiple drop-rounds)

 

[azidahaka]

a previously non existing line, but the cell is there already right?

or maybe i misunderstood?

 

[rallymorten]

It inserts a new line in the "collector" when you enter data. If, for example, I tell the sheet your score for round A is X1 on the collector page, and, through the form, enter data stating you finished in position B, that'll be put in a new line above X1, so that your results are now calculated from X2, etc.

I hope that makes any sense, I'm horrible at explaining things

 

[eran0004]

Ooh, I love Excel! Tell me if you need help with anything

 

[srefre]

I have something too. It is ugly and basic at the moment, but I will send it to you guys to have a look. If you like the concept, I will make it prettier and improve functionality.

Do you have a good way to share an Excel document?

 

[eran0004]

I have something too. It is ugly and basic at the moment, but I will send it to you guys to have a look. If you like the concept, I will make it prettier and improve functionality.

Do you have a good way to share an Excel document?

You can upload a file to GTPlanet, there's a button next to the "Post Reply" button

 

[Rod Carvalho]

I don't know if it helps, but I've made a program to read all the numbers from a GT5 replay (live timing mode) captured to a movie format from any direct feed hardware.

It calculates the number of position changes, real time gaps, and all important race info and exports everything to Excel spreadsheet.

I have to update it to GT6 format but I am waiting for a PD move on updating the online features before I do extra work. I am planning to release the next version to the public between May and June.

 

[srefre]

I'll upload later, didn't realise you could do that.

 

[eran0004]

Edit: Race Manager 1.0 is now ready for testing. See post #29 below.

 

[azidahaka]

I don't know if it helps, but I've made a program to read all the numbers from a GT5 replay (live timing mode) captured to a movie format from any direct feed hardware.

It calculates the number of position changes, real time gaps, and all important race info and exports everything to Excel spreadsheet.

I have to update it to GT6 format but I am waiting for a PD move on updating the online features before I do extra work. I am planning to release the next version to the public between May and June.

you mean from a capture card? like the one i use to make the videos in my signature?

if it take note of lap times, pits, position changes and such things it would be the definitive analyses and race review tool.

do you have a vie if it working in gt5? i'm very curious about seeing it in action!

 

[Rod Carvalho]

you mean from a capture card? like the one i use to make the videos in my signature?

if it take note of lap times, pits, position changes and such things it would be the definitive analyses and race review tool.

do you have a vie if it working in gt5? i'm very curious about seeing it in action!

The replay or live timing need to be recorded from this screen. It is the only way to access the numbers given by gt5.

 

[eran0004]

My Race Manager Excel file is ready for testing.

Edit: Version 1.01 is now available. Go to post #33 for info and download.

​

 

[srefre]

Ok, here is my partially complete effort - hey it's the PD spirit! . Its a macro enabled workbook Ive left it unlocked, because although my coding is a bit crappy there is nothing malicious there, so I have nothing to hide. According to my computer it's virus free, but please check for your own good, as I do not want to be responsible for any problems. To upload it here, i had to add the extension .txt as macro enable workbooks cannot be uploaded. Please remove the additional .txt extension and it should work fine.

Ok, warnings over with, to use:

Make sure macros are enabled for this spreadsheet.

On the first tab, enter the driver names (teams and numbers have no effect yet), enter the points system, enter the number of races.

Click "Set Up" button.

After a race, click "Enter Results" Button. Select corretc round. Input positions for all racers. Click "Update Results" button.


Limitations:
Only set up for 16 entrants, if you have less you have to assign positions to other runners anyway.
Not configured Teams yet.
Not done any formatting, so looks plain

In progress:
Will add points for pole, fastest lap
Will add drop races
Choose number of drivers rather than fixed to 16

Future ideas:
Graphing of results, championship etc..
Better display of current standings

Ideas, comments, feedback appreciated