I’ve been playing an online F1 manager game for a couple of weeks. F1Time is a manager simulation game with great depth and the right level of complexity. I like it.
I wrote a small tool to extract laptime data from the race reports so it can be easily analyzed in MS Excel. I wrote it as a Sinatra webapp. Sinatra is a Ruby DSL for writing small webapps with a minimum amount of code. This tool was written in 35 lines of code.
It’s open source, so you can view (or fork) the sourcecode on github.
F1Time managers: You can simply copy & paste the html code of your race report HERE, and it will generate a table that you can copy/paste into Excel. (to get the html code from the race report: right click and click “View page source”)
Finally managed to get it to work, had to ‘View source’, copy and paste that. The instructions didn’t make that clear!
Nice job, just need to work on the documentation!!!!!!
Thanks for pointing that out Dean, i’ve added a note to the post. I have to tell you, I’m not an expert on documentation
Some more documentation: the extra column called “delta median” is the difference of each laptime with the laptime median. I use median as a measurement for a ‘normal’ laptime. So the delta median column shows how much faster/slower that lap was compared to a ‘normal’ lap (in seconds).
Cheers!
Hi,
I’m trying to use your parser but everytime I get the error “Incorrect race report html”
I open the race report and right click ‘view source’ I then c/p it in your parser and submit it.
I have tried IE 8 and the latest FF.
What is going wrong
Hmm, strange.
Could you post the html somewhere so I can check what’s wrong.
The “Incorrect race report html” error means that the script couldn’t find the GP name or the lap data.
I keep using it every race, so it should work (i use FireFox 3 and Safari 4)
Hi
Nice application. I try undertsand some of the F1Time dinamics and hope this will help me a bit. With reference to calculating one’s Weighted average I cannot find the hot spot when doing the calculations. Some advice and direction will be appreciated. For understanding I kicked off using 50 for my fromt wing but try to use msexcel to calculate the 62.92 W.Avg is not close to what I try to get.
Any guidance what are the array values you using and how you go about it.
Learning is a challenge for me but hit a brick wall and no solution in sight yet..
Much apprecated for any help.
Kind Regards
Chtis