The Spirit of British SimRacing   

Read this first!    
 
March 28, 2024, 06:51:26 PM +0000 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
Series
Recent
Forthcoming
News: Upcoming Events are as follows: 1 - RRE/AC/ACC Sunday - No event ; 2 - GTL Monday - No event 3 - AC Wed - No event 4 - RRE Thursday - No event

RACE SERIES KEY A19=Assetto Corsa, E10=Raceroom Experience, L23=UKGTL GT Legends, LN2=Legacy NoGrip GT Legends, LNE1=Legacy NoGrip GT Legends Endurance races
 
  Start Here      Home   Help Search Calendar Login Register     LM2 Replays Rules Links Circuits Teams  
Pages: [1]
  Print  
Author Topic: British GT3 series - Error in finishing order Oulton Park  (Read 1051 times)
0 Members and 1 Guest are viewing this topic.
SRW
Sunday Supremo
SimRacing.org.uk Staff
Sr. Member
****
Posts: 2111


View Profile
« on: March 18, 2018, 02:44:39 PM +0000 »

It was recently brought to my attention that the results from Oulton park race did not import properly in to LM2. I have extracted the data into excel and re-arranged it:

Driver   Position   laps   race time
Chris …       1   31   3064.413
NFSW55…   2   31   3080.268
Jeffre…       3   31   3085.846
FLAVUS…   4   31   3092.645
Felix …       5   31   3102.715
MARK J…   6   31   3109.003
Albert…      7   31   3125.038
SPANNE…   8   31   3141.021
Stephe…      9   30   3078.052
PICNIC…   10   30   3087.943
Isaac …      11   30   3140.141
Larry …     12   30   3152.842
POSTAL…    13   29   3065.398
MattRo…    14   27   3125.487
ROG UK…    15   21   2337.125
Ewan B…   16   0   

1. If anyone disagrees with this finishing order could they pipe up?

2. The only option i can see for modifying the results on LM2 is to re-arrange the data manually.
If anyone knows of an automated method of doing this so that we can keep hold of the lap times etc then they are welcome to have a go or painstakingly re arrange it manually!

Otherwise i plan to delete all the current data (qually times/fastest lap times etc) for this event and replace with just the info above so that the championship points table is correct.

I will leave this thread open until next weekend for anyone to comment if they have any ideas.

Logged
Flavus Periculum
Newbie
*
Posts: 33


View Profile
« Reply #1 on: March 18, 2018, 09:25:15 PM +0000 »

I don't know what LM2 is or what way you are creating the results table but google sheets is very handy for this type of thing. You can import data from files and there are a lot of very useful commands to automate tables and you can also create scripts to automate things further. You can embed the google sheets results page into a thread, well you can on other sites but no sure what software you use for this site. I can help where possible. The good thing about google sheets is that you can give permissions to other users to edit data if you trust them  Grin
Logged
Wiltshire Tony
Director, UKGTL
SimRacing.org.uk Staff
Hero Member
****
Posts: 15109


"I'd rather be Sim-Racing" said Noddy


View Profile
« Reply #2 on: March 19, 2018, 04:52:42 AM +0000 »

Use this https://www.simracing.org.uk/lm2/index.php?action=refdata&refData=eve to fix results manually
Logged

The only UK based GTL community which races every Monday night. We are always looking for new drivers of all ages and abilities. GTL here since 2006.

picnic
Director, Servers
SimRacing.org.uk Staff
Hero Member
****
Posts: 8114



View Profile
« Reply #3 on: March 19, 2018, 07:53:21 AM +0000 »

I thought it was Ewan that complained to you the results were wrong in the first place. You've now got him last when I thought he had completed all 31 laps  Undecided
Logged

SRW
Sunday Supremo
SimRacing.org.uk Staff
Sr. Member
****
Posts: 2111


View Profile
« Reply #4 on: March 19, 2018, 04:16:18 PM +0000 »

I thought it was Ewan that complained to you the results were wrong in the first place. You've now got him last when I thought he had completed all 31 laps  Undecided
i was looking at the results on LM2 and rearranging based on laps completed and race time (in seconds). So are we saying this information is wrong as well as the finishing order? if so I could try looking at the replay in AC, cant see any other way of working it out?
Logged
picnic
Director, Servers
SimRacing.org.uk Staff
Hero Member
****
Posts: 8114



View Profile
« Reply #5 on: March 19, 2018, 04:28:08 PM +0000 »

Unless I'm looking at the wrong results

https://www.simracing.org.uk/smf/index.php?topic=14847#event5753

the # of laps completed for Ewan is 31 and he was 0 laps behind the leader (same as Spanner) I have no idea what order they finished or why the import reckons Ewan's best laptime was over 27 hours!
Logged

SRW
Sunday Supremo
SimRacing.org.uk Staff
Sr. Member
****
Posts: 2111


View Profile
« Reply #6 on: March 19, 2018, 04:43:51 PM +0000 »

Unless I'm looking at the wrong results

https://www.simracing.org.uk/smf/index.php?topic=14847#event5753

the # of laps completed for Ewan is 31 and he was 0 laps behind the leader (same as Spanner) I have no idea what order they finished or why the import reckons Ewan's best laptime was over 27 hours!

I think I see what has happened, the data in LM2 shows Ewan as doing 31 laps, but with a total race time of 0 seconds, when I sorted the race time column in excel it must have put him to the bottom. I will slot him in 8th place (which is where he says he finished)
Logged
spanner
Director, AC
SimRacing.org.uk Staff
Hero Member
****
Posts: 6106


Team Prodigy - UKGTR/UKAC


View Profile
« Reply #7 on: March 28, 2018, 07:01:17 AM +0100 »

So is there something wrong with either the result file structure or our importer? Its getting rather frequent now, rather than just being a one off. Its been a rather unique feature of this place holding our results on the site but if its now a manual process....
Logged

Learn to love the Pork Smiley

Team Prodigy - Just like Team Oldie only younger, faster, less grey hair and kinder to the environment!
Dave 'Gizmo' Gymer
Director General
SimRacing.org.uk Staff
Hero Member
****
Posts: 15100


Currum auriga quasi furtivum


View Profile WWW
« Reply #8 on: March 28, 2018, 07:06:54 AM +0100 »

The finishing order recorded in the import seems to disagree with the lap count and times quite a lot - I think something must've been borked inside the game.

You don't need to nuke the times to fix the results, though - the 'race_pos_sim' column in the event entries page allows the order to be changed without touching anything else - it's used for sims like AC which are supposed to reliably record finishing order regardless of other data. There's even a little explanatory note at the top of that page...
Logged

To finish first, first you must have fins.
SRW
Sunday Supremo
SimRacing.org.uk Staff
Sr. Member
****
Posts: 2111


View Profile
« Reply #9 on: March 28, 2018, 09:22:05 PM +0100 »

ok, I didn't realise that. I will try just changing that column next time
Logged
Dave 'Gizmo' Gymer
Director General
SimRacing.org.uk Staff
Hero Member
****
Posts: 15100


Currum auriga quasi furtivum


View Profile WWW
« Reply #10 on: March 29, 2018, 06:46:53 PM +0100 »

I've rejigged Silverstone and Oulton so that the cars and sim to forum driver mappings (as seen when hovering over the driver in the race results) should be correct.
Logged

To finish first, first you must have fins.
Pages: [1]
  Print  
 
Jump to:  

Hosted by DaveGymer.com
Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.269 seconds with 24 queries.