Lantern Control Datasheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This spreadsheet is a compilation of a long period of work towards Lantern.  Below is a brief overview of what can be seen at various tabs of the sheet.
2
Overall Matchup Win %Lists each matchup and historical win % against them.
3
Community NotesThis tab is made available for members of the community to note suggestions, corrections, and point out trends that might not otherwise be noticed.
4
Weighted Data TrendsLooks at changes in correlating win %'s with various numbers of individual cards in the opening hand, but gives the data weight according to how much data there is feeding the numbers. Thus, small sample sizes don't skew data. The function used for adding weight to data to compensate for sample size doesn't use an exponent.
5
Recent Weighted Data TrendsThis is a link to another external spreadsheet that weighs and ranks only recent data.
6
Not sure what...This tab lists each matchup and provides data on win % when on the play or on the draw.
7
Most of the other tabsThese are (mostly) all pivot chart tabs that are used to calculate data for the Data Trends tabs.
8
Opening Hand DataThis is where I enter all data from the videos from my Youtube Channel. This data is then put into pivot charts which are linked for the Data Trends/Copy of Data Trends tabs.
9
Recent Matchup Win %Sheet that lists each matchup and only calculates win % against those matchups in the past 90 days.
10
Sideboarding Tool SheetThis can be used to help figure out sideboard techniques. For any deck that we wish to have a sideboard plan, we enter the card names and how they stack up against the cards in the Lantern deck. We then adjust the numbers in the list below the main chart to try to get the highest scores possible for pre- and postboard. If you are going to use this sheet, please make a copy for yourself rather than editing this one, that way many people can edit it as necessary without messing up whatever data you enter.
11
Recency Check (Matches) TableCreated to show how matchups have changed. All data in the "TRUE" section is from matches played in the past three months. All data in the "FALSE" section is from matches played prior to the past three months.
12
Recency Check (Games) TableCreated to show how matchups have changed, in individual games.
13
Pilot Trends (Games)Created to track how various pilots perform against each matchup. This is also sorted to reflect whether the match was played in the past three months, to ensure that the data is relevant to current metagame trends.
14
Pilot Trends (Matches)Same as Pilot Trends (Games), but for complete matches.
15
Mulligan TrendsShows winrates as they correlate to how many cards we have in the opening hand.
16
Source DataThis tab shows the sources for the Opening Hand Data tab. It lists the pilots and the platform they played on.
17
Platform Match Win %This shows average match win percentages across platforms, for comparison. It should be noted that this does not take into account when those games were played.
18
Platform Game Win %This shows average game win percentages across platforms, for comparison. It should be noted that this does not take into account when those games were played.
19
Notes on data accumulation:This data is compiled from videos on Youtube.  Most of them are my own videos, but they also include other Lantern contributors and pro players.  The reason that I try to strictly use data from videos is so that anyone viewing the spreadsheet can verify the quality of the data themselves (quality of play of the opponents and the Lantern pilot, that the games aren't just made up, etc.)  I try to be as transparent about the data and the compilation of the data as I can, to ensure that the data can be trusted.  Each individual game is tracked so that it can be individually verified.  Backups are made on a weekly basis.  If anyone, at any point, sees a problem with the data, please do not hesitate to point out the error for it to be fixed.
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...