24 Hours of LRRmans 2018: Electric Boogaloo
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTU
1
2
3
4
5
Shortlinks to this spreadsheet:
6
http://bit.ly/LRRMans2018Log
7
Command to link it in chat
8
!lrrmansheet
9
10
11
12
13
14
15
16
17
18
19
(Times of last edit)
20
Current Moonbase Time (PDT):12/5/2018 04:32 PMDrivers
Laps Driven
Driving Time
Fastest Lap
Average Lap
Slowest Lap
Pit StopsHoods Lost
Average Laps/Hood
21
Current Le Mans Time (CEST):12/6/2018 12:32 AMIan17112:14:473:48.4534:19.8475:23.066241710.06
22
Time Offset from Reality:30465:44:11Cori473:43:514:04.2424:45.2855:44.173985.88
23
Current In-Game Time (CEST'):6/15/2015 02:48 PMPaul343:20:254:39.8675:53.6908:59.453496:00:008.50
24
Time Elapsed:23:48:08Beej241:53:364:18.1024:44.0036:10.980372:00:008.00
25
Approx. Time Remaining:0:11:52Kathleen181:55:355:17.3836:25.2969:05.84810:00:00N/A
26
Percent of Race Completed:98.54%Graham90:39:535:01.5085:01.5085:01.508024:00:009.00
27
Time Until Stream Start:4124:32:1900:00:000:00.0000:00.0000:00.00000:00:00N/A
28
Approx. Distance Driven:3516.282 km
29
Ian17112:14:473:48.4534:19.8475:23.0662417
30
Average Lap Time:4:42.798Cori473:43:514:04.2424:45.2855:44.17398
31
Laps Driven:303Paul343:20:254:39.8675:53.6908:59.453496:00:00
32
Estimated Total Laps:306Beej241:53:364:18.1024:44.0036:10.980372:00:00
33
Time since Sunset (In-Game):17599:12:52Kathleen181:55:355:17.3836:25.2969:05.84810:00:00
34
Time since Sunrise (In-Game):17607:10:52Graham90:39:535:01.5085:01.5085:01.508024:00:00
35
00:00:000:00.0000:00.0000:00.00000:00:00
36
37
38
39
40
41
42
43
44
This is where the chat chats about this spreadsheet
45
Count position where lap time goes to zero
46
Cells using a checkbox default to blank, not false. We should probably modify our formulas to look for TRUE or NOT TRUE rather than false
47
Did we ever get the graphs to behave properly
48
The graphs work properly when we have proper data, we just need to make sure the time is formatted properly... and it should be now
49
I like this idea -- should we test with last year's data if we still have it
50
I literally cloned last year's spreadsheet to make this so it should be working
51
https://docs.google.com/spreadsheets/d/1ZP53nSbYFZ4fQ9t5-koosK_vRDTnGPOk-lP9Q-HCQ-4/edit?usp=sharing
52
Can someone look at fixing these graphs?
53
I think we will have to convert the times to straight number-of-seconds or something
54
Okay conversion sort of done
55
GETTING THERE -Tant
56
I think we got there?
57
We need to apply the format [m]":"ss"."000
58
so the key is making it think it's a time of day
59
and not an elapsed time
60
the kludge i put in sort of works, feel free to improve it
61
We just need to fix the rest of the automation we had last year, reference the last year's spreadsheet for formulas
62
okay, we got there, just remember to put 0 hours at the start
63
good work everyone!
64
is there a procedure for entering the times?
65
enter it as 0:min:second.millis
66
or just copy another time and replace what you need to
67
If you mess up format and it thinks its a time, select the cell, go to format > number and then choose the one starting with [m] at the bottom
68
...I will never understand Google Sheets
69
added ability to add Annotations to graphs, see 'Notes' column under the 'Graph Power' sheet
70
‘twould be great if the number formatting stuck huh?
71
can we define our own custom format and apply it to the column?
72
that's what we're doing, it just keeps coming unstuck
73
oh
74
I blame Google Sheets
75
thanks, Google Sheets
76
Theets.
77
I blame Beej.
78
Since we are now on a second session we need to make sure to update the ingame lap number on each lap completed
79
good work everyone!
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu