Hello
I'm developing a spreadsheet to track race positions and in particular the time (seconds) or laps (L) relative to my position. The data input would be the Car number and the Gap.
The other two values are calculated and represent; Diff to the leader (Car 99) and AB the gap to my car (Car 44).
The table below (see attached) represents input after a number of laps (not important) where Car 99 is leading and my car 44 is in position 7. The Car and Gap data are manually input and Diff and AB are calculated.
How do I calculate Diff and AB? The calculation would need to account for lapped cars (indicated by 1L etc under Gap) in calculating Diff and AB. Obviously the position of any car may move up or down so being in Position 7 is not fixed, again the calculation will need to account for this.
Thanks for reading.
Position Car Gap Diff AB
1 99
2 14 10 10 43
3 22 4 14 33
4 01 12 26 29
5 66 5 31 17
6 11 12 43 12
7 44 20 63
8 77 2 65 2
9 653 3 68 5
10 666 8 76 13
11 172 24 100 37
12 171 1L 1L 1L
13 12 2L 3L 3L
14 67 3L 6L 4L
Bookmarks