ABCDEFGHI
1
2
Welcome to the Mindcrack Ultra Hardcore Statistical Spreadsheet!
3
4
General information
5
This workbook is designed to provide an overall summary of all the Mindcrack Ultra Hardcore seasons in a statistical fashion. It displays data by-player for competitive comparison, rather than by-match.
6
Health and damage is displayed by points, not by hearts: Two points is one heart, one point is a half heart.
7
This workbook comprises of five sheets, which all display data in a different fashion. You can access the sheets using the tabs at the bottom left of the page.
8
by-match player statsThis displays data of players, split up in to the different seasons.
9
by-match attendanceThis displays who attended what season, and how many players attended which season.
10
by-player summaryThis displays summary data on the basis of players. It does not distinguish between different seasons.
11
by-player damageThis displays damage caused by players to other specific players.
12
by-player killsThis displays player kills in the form of a table.
13
14
By-match player stats
15
The by-match player stats is designed to show statistics of players by each match they play.
16
Explanation of columns
17
seasonThe number of the season, as provided by the Mindcrack let's players
18
typeThe format of the teams, such as free-for-all (FFA), or teams of x. Teams are displayed in groups, in order of the alphabet.
19
playerThe player that the statistics will be about.
20
deathHow the player died. Non-player deaths are not capitalized.
21
killsHow many kills the player achieved.
22
(who)Who they killed, and in what order. The parenthesis is the method of the final blow that killed the player. (m) means using melee (either directly, causing fall damage, or using fire/lava), (a) means using a bow and arrow (either directly or to cause fall damage), and (w) means using a wolf.
23
healedHow many health points the player recovered.
24
dmgHow much damage the player CAUSED to other players.
25
(who)Who that player was, and how much damage they caused to that specific player
26
player dmgHow much damage they received from players or player-causes.
27
env dmgHow much damage they received from the environment, such as fall damage, block damage, starving, and so on.
28
mob dmgHow much damage they received from mobs (NOT INCLUDING player-owned mobs)
29
positionTheir position on the roster. The victor is "1".
30
31
By-match attendance
32
The by-match attendance sheet provides information on who attended what match in the form of a table.
33
Matches are shown in the columns, and players are shown in the rows. A check (✓) means a player attended the corresponding match, whereas a cross (✗) means a player did not. The amount of players in a season is displayed at the bottom of the season's column, and the amount of seasons a player attended is displayed on the far right of the player's row.
34
35
By-player summary
36
The by-player summary provides summary data of specific players. That is, the cumulative statistics of all the seasons they have played. Some cells are not capable of being calculated because they are divided by 0. They are automatically blanked out, but a comment tooltip will appear if you hover over them. Please ignore this epic mathematical fail.
37
First section – overall
38
attendedThe amount of seasons the player has attended. This data is automatically taken from the "by-match attendance" sheet.
39
high posThe highest position the player has achieved.
40
low posThe lowest position the player has achieved.
41
mean posThe average position the player has achieved.
42
kills (k)How many overall kills the player has achieved.
43
deaths (d)How many deaths the player has achieved. This is practically: (amount of matches attended) - (victories)
44
kpdHow many kills the player has achieved per death. The higher the better.
45
kppdHow many kills the player has achieved per player-caused deaths. The higher the better. This is a better evaluation of the pvp skill of the player.
46
kp matchHow many kills the player has achieved per each season attended.
47
48
Second section – kills
49
The "⟵ %" means the last column, as a percentage of total kills. These sets of data have to be manually acquired.
50
k meleeHow many kills the player has achieved using melee (or lava/fire)
51
k arrowHow many kills the player has achieved using a bow and arrow.
52
k wolfHow many kills the player has achieved using wolves.
53
54
Third section – deaths
55
The "⟵ %" means the last column, as a percentage of total deaths. These sets of data are automatically calculated based on other cells.
56
d playerHow many deaths the player has had caused by a player. Acquired from the amount of deaths on the "by-player kills" sheet.
57
d otherHow many deaths the player has had caused by the environment. Acquired from: (amount of deaths) - (amount of deaths on the "by-player kills" sheet)
58
59
Fourth section – PvP
60
The "⟵ ratio" means how much damage a player has caused relative to how much player-damage they have received. These sets of data are automatically acquired from the "by-player damage" sheet
61
pvp doneHow much damage this player has caused to other players in all seasons.
62
pvp gotHow much damage this player has received from other players in all seasons.
63
64
Fifth section – damage taken
65
The "per game" column displays the average amount of damage (displayed to the left) taken per game. The "⟵ %" means as a percent of total damage taken.
66
dmg playrHow much damage a player has received from other players.
67
dmg env/mobHow much damage a player has received NOT from other players.
68
69
By-player damage
70
This sheet provides a table of player-damage. The columns "damaged" the rows; so, for instance, if the value "15" is in the cell where the COLUMN "BOO" intersects the ROW "Milbee", it means BdoubleO caused 15 damage (7.5 hearts) damage to Milbee.
71
72
By-player kills
73
This sheet provides a table of player-kills. Again, the columns "killed" the rows; so, for instance, if the value "2" is in the cell where the COLUMN "Guude" intersects the ROW "Doc", it means Guude has killed Doc two times.
74