Forum Discussion

Seasoned Newcomer

Re: F1 23 gap calculation

Hi, in second part when you enter sector 2. Your current laptime is the moment of entry in sector 2. But last laptime looks like time at the end of sector 2. That is why you get minus value. There are some better ways to calculate, but first thing that comes to mind is that you need to have sort of lookup table for previous lap, where each lapdistance has assigned laptime. So then, during new lap you compare current laptime with previous laptime that coresponds to lapdisstance (from lookup table) closest to currentLapDistance.

3 Replies

adaoduque

2 years ago

Hi @XanderSjx, i appreciate your answer, thank you.

I have a lookup table, but the "checkpoint" (time or distance) is not the same every lap.

First data in my lookup table:

Lap2-lapTime	Lap2-speed	Lap2-lapDistance	Lap3-lapTime	Lap3-speed	Lap3-lapDistance	Lap4-lapTime	Lap4-speed	Lap4-lapDistance
13	329	2	13	312	1	14	337	2
40	329	4	40	312	4	31	337	4
53	329	6	53	312	5	68	337	7
66	329	7	80	312	7	86	338	9
93	329	9	93	312	8	120	338	12
106	330	11	120	312	11	208	338	20
133	329	13	133	312	12	222	338	21
146	329	14	146	312	13	249	338	24

Full lookup table: https://docs.google.com/spreadsheets/d/1u-mcqNITrFZPVUao7WcgWlv4kEmUvILVeQ23bbg8FY0/edit?usp=sharing

Thanks in advance.

XanderSjx
Seasoned Newcomer
2 years ago
Okay, I haven't done this, so I am just talking from how I would try it first time. And I am aware that it introduces considerable error. I'll use examples from your table lap2 and lap3, at lap3 distance of 8.
Values that are used are lap3time=93, lap3distance=8, lap2time=(66+93)/2=79.5 (as they are closest to lapdistance of 8 on lap2) and this is where error is introduced. So, lap3 would be +0.013 compared to lap2
Another example for laps 2 and 3, from your full table, at lap3distance=100. Values are: lap3time=1148, lap2time=1081. So lap3 would be -0.067.
lap3distance=1002, Values are: lap3time=16019, lap2time=(16565+16591)/2=16578. So lap3 is -0.559
There are for sure better and more precise ways to do it and I am not sure how big is error without comparing it during lap with what game shows. Looking at speed in these laps it should be correct that lap3 is faster, but even with speed in first meters I would expect it to be faster, which it is not as seen in first example.
adaoduque
2 years ago
You're right.
Finding the distance of the current lap (lap 3) in the lookup table for the previous lap (lap 2) worked perfectly.

Now I have the gap without absurd distortions.

You helped me a lot, thank you very much.