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)