ABCDEFGHIJKLMNOPQRST
1
2
3
4
5
Shortlinks to this spreadsheet:
6
http://bit.ly/LRRMansData2020
7
8
9
10
11
12
13
14
15
16
17
18
19
(Times of last edit)
20
Current Moonbase Time (PDT):11/20/2020 11:11 AMDrivers
Laps Driven
Driving Time
Fastest Lap
Average Lap
Slowest Lap
Pit Stops
Average Laps/Hood
21
Current Le Mans Time (CEST):11/20/2020 08:11 PMIan15118:04:126:18.2007:11.51619:47.26018N/A
22
Time Offset from Reality:0:01:01Cori295:21:376:34.85010:57.16232:22.6504N/A
23
Current In-Game Time (CEST'):9/20/2020 02:25 PM00:00:000:00.0000:00.0000:00.0000N/A
24
Time Elapsed:23:25:4900:00:000:00.0000:00.0000:00.0000N/A
25
Approx. Time Remaining:0:34:1100:00:000:00.0000:00.0000:00.0000N/A
26
Percent of Race Completed:97.63%00:00:000:00.0000:00.0000:00.0000N/A
27
Race Start Time (PDT)
9/19/2020 5:00:0000:00:000:00.0000:00.0000:00.0000N/A
28
Time Until Stream Start:0:00.00
29
Approx. Distance Driven:2453.22 kmIan15118:04:126:18.2007:11.51619:47.26018
30
Average Lap Time:7:48.607Cori295:21:376:34.85010:57.16232:22.6504
31
Laps Driven:18000:00:000:00.0000:00.0000:00.0000
32
Estimated Total Laps:18400:00:000:00.0000:00.0000:00.0000
33
Time since Sunset (In-Game):0:19:5100:00:000:00.0000:00.0000:00.0000
34
Time since Sunrise (In-Game):0:19:5000:00:000:00.0000:00.0000:00.0000
35
00:00:000:00.0000:00.0000:00.0000
36
Richter Laps Completed271
37
Richter Average Lap Estimate5:11.25
38
Richter Laps Expected278
39
Richter Laps Expected / 28896.53%
40
Richter 288 Lap Estimate24:54:01
41
42
43
25D 17:48:53
44
45
46
47
48
This is where the chat chats about this spreadsheet
49
๐Ÿš—๐Ÿš™๐Ÿš“๐Ÿš•๐Ÿš˜๐Ÿš”๐Ÿš–๐Ÿšฅ๐Ÿ- DigitalSeahorse
50
Intersting thing this year, looks like BIG CHEATS doesn't exist
51
Well, so far
52
53
Hi! In 'Time to Seconds', I have added a column that shows the RANK of each lap against all other laps
54
Notes in the 'Notes' column in the sheet 'Graph Power' will show up on the graph!
55
Honk Honk
56
Remember, this year there is but one scant Gant, so we can't Gant Gant. Recant one Gant, one Gant adamant.
57
58
Welcome to this year's spreadsheet, everyone
59
Would it be possible to add R_bar, โˆ†X=, Standard Dev, UCL and LCL for โˆ†X and R? to the Graph Power Sheet?
60
Feel free to! Google Sheets can be a bit tetchy
61
There may me something wrong with the in-game lap time, it showed the same data for the Lap 2 and 3 (8:19.30 +98.2, VOD time 59:25 and 1:06:46)
62
63
Thanks for all your good work y'all
64
65
66
Going through the VOD to get Lap 1 - 3 lap times now, Start at 0:39:26, Lap 1 @ 50:36 (Pit didn't show time), Lap 2 @59:25, Lap 3 @1:06:46, Lap 4 @1:14:18
67
Thanks a bunch
68
Got best estimates I could for Lap 1-3 times
69
Something's not adding up with Lap 4, VOD shows lap between 1:06:46 and 1:14:18 (7 min 32 s) but in-game hud shows 6:26.95
70
Google Sheets remains to be a pain in the butt
71
Fixed the time format to match what we had before. Pretty much have to copy the format from cell to cell
72
They really need to support our super-janky use-case better :P
73
Pretty sure AC suffers from the same issues as PC2 does; when the game slows down due to cpu strain the clock won't- that might affect VOD lap times
74
I'm using BIG CHEATS to mark laps that aren't counted. Turns out when the lap times are the same, it means the corners have been cut, but it's REALLY subtle.
75
I missed lap 21 because I was too busy looking at the pit lane retirees
76
Alright goodnight guys have fun
77
I've added a column at the end of the Data entry Sheet with the VOD timestamp, turns out the the lap time only flashes when it's a valid lap
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100