AustinMajorData.xlsx

	A	B	C
1	Data Name	Data Type	Description
2	PlayerID	KEY	Unique identifier of each player across StageData and PlayoffsData.
3	Player	TEXT	The in-game alias of each player.
4	TeamID	KEY	Unique identifier of each team across TeamData; foreign key across StageData and PlayoffsData.
5	Team	TEXT	The name of each team qualified to the Major.
6	Nationality	TEXT	The home country of each player.
7	AvgKills	INTEGER	The average number of kills obtained by each player per-map, rounded up to the nearest whole number.
8	AvgDeaths	INTEGER	The average number of deaths received by each player per-map, rounded up to the nearest whole number.
9	AvgADR	DECIMAL	The average health points (HP) of damage a player inflicts on the enemy team each round per-map, rounded up to the nearest tenth.
10	AvgKAST	DECIMAL	The average percentage of rounds per-map that a player is "useful"--if they get a kill, assist in a kill, survive the round, or are "traded" (killed by an opponent in such a way that allows their team to quickly kill that opponent in exchange)--rounded up to the nearest tenth.
11	AvgHLTV	DECIMAL	The average rating of a player's performance per-map by HLTV.com, one of the biggest sites for CS2 news and match information, rounded to the nearest hundreth. Per HLTV, 0 to 0.85 is Poor, 0.86 to 1.14 is Average, and 1.15+ is Good.
12	Position	TEXT	The specialized role a player fills in the team--these are not hard-coded into the game and can vary drastically from team to team.
13	PositionMultiplier	DECIMAL	The added or reduced weight to individual statistics based on the role of the player. For instance, AWPers are expected to produce better numbers on average, while IGLs (In-Game Leaders) tend to be some of the worst statistical players on the team, purely due to their role as the team captain and in-game strategist. You wouldn't want Tom Brady or Aaron Rodgers as your star receiver or running back in American football.
14	MapRoundsWon	INTEGER	The number of maps won by a team for each stage of the major.
15	MapRoundsPlayed	INTEGER	The number of maps a team plays in each stage of the major.
16	RoundWinPct	FLOAT	The percentage of rounds a team wins within a given stage, rounded to the nearest thousandth. Generally speaking, a win percentage of 0 to 0.5 indicates a team that was eliminated in a given stage, while a percentage of 0.501 to 1 indicates a team that advanced to the next stage (not foolproof; can produce false positives and false negatives).
17	Region	TEXT	The home region of each team, and the region whose qualifier they played through to reach the major. Broken down by N. America, S. America, Europe, Asia and Oceania.
18	WorldRank	INTEGER	The official ranking of each team at the start of the major. This is based most prevalently on the strength of each player in their roles and the team's versatility on the maps in the competitive map pool.
19	AvgOppStr	INTEGER	The average strength of opponent, based on the average WorldRank of each opposing team, that a team faced at each stage
20	RoundsPlayed	INTEGER	The number of rounds that each team played in the Swiss stage(s) they participated in. Each stage saw the teams needing to win 3 games in 5 rounds to advance, so no team can have less than 3 or more than 5 rounds played.
21	AvgMapRounds	INTEGER	The average number of rounds it took to complete a map, whether won or lost. A decent measure of positive or negative efficiency. Any averages above 24 represents a considerably inefficient team.
22	StartingStage	INTEGER	The stage a given team starts at in the tournament.
23	EndingStage	INTEGER	The stage a given team finishes at in the tournament.
24	DistanceValue	INTEGER	An integer that gives relative value to how deep of a run the team makes in the major. Each Swiss stage represents the corresponding digits 1, 2 and 3; each segment of the playoffs (quarters, semis, finals) represents digits 4, 5 and 6. To get the DistanceValue, use additive arithmetic progression on the stages a given team participated in (i.e. if a team started in Stage 2 and was elimitated in the Quarters, their DV would be 2+3+4=9).
25	SwissStagesPlayed	INTEGER	The number of individual Swiss stages a team played in throughout the major, regardless of which specific ones they played in.
26	Substitute	BOOLEAN	Boolean statement on if a team played in the major with a stand-in (a player not signed on an official, long-term contract with their team).
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