ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAV
1
Welcome to the MechWarrior 5 Quick Reference Guide!
2
This is a workbook of MW5 mechs built around its "Search" feature and organized to make browsing mechs easy.
3
To use all features, please save a copy to your own Drive
4
Many title cells and selection cells include a note to help with using this sheet, including explanations for advanced features
5
This sheet contains mech data for the base (unmodded) game + DLCs 1 - 8, using the in-game mech lab and sarna.net
6
7
Feel free to send suggestions/feedback to my email "HarrowedEarth@pm.me". Have fun!
8
To do:
Update all slots numbers after June patch (CR Slots: 6 -> 8?)
Review all mechs, check EHSs
Custom "Weight class" sort + space?
HIDE LISTS TAB
Rebuild Light sheet from new copy of Dark mode
9
10
Notes about Use
11
While the default search types should be fine in most use cases, row 1 contains lists of options which modify how the searches are performed + notes for how each term impacts that search option
12
If a mech is available as a reward, look at the Fame column of that variant's entry (not the Search tab) for a note with some details
13
Some other details are saved to various cell's notes and will not be available via Search. These usually say if the equipment is clan tech.
14
Do not try to add or edit mech data from the Search tab - use the other tabs for this. When adding mechs, enter the Mech (chassis) name first.
15
16
17
Trivia
18
This sheet contains 553 variants of 91 mechs from 9 sources: MW5, HotIS, LotKL, CtA, RoR, tDG, SS, SoK, and CR
19
There are mechs with 9 levels of fame: 138 Clan, 93 Hero, 63 Reward, 57 Rare, 11 Gladiator, 10 C-Tech, 6 Clanbuster, 5 Otomo, and 2 Exclusive
20
The most adjustable mech is the Annihilator with 59 tons free for tinkering
21
The fastest mech is the Dasher (Fire Moth) with a maximum walking speed of 162 kph
22
These mechs span 57 years, from 3015 to 3072
23
24
25
Technical notes
26
The Search tab is powered by a single function located in cell A6
27
If the topmost rows of a mech tab (e.g. Lights) aren't showing up in Search, check the top lines of the formula in A6 to verify that all ranges begin at row 3. If not, change ~34 items for that tab
28
Using click + drag to move entries will break conditional formatting rules. Just delete/insert rows and copy/paste values (not cut)
29
The dropdown menus and the Trivia are updated from a hidden "Lists" tab. Go to View > Hidden Sheets to unhide
30
If you want to add a mech with 2 or more fame values (e.g. Clan + Hero), list each fame separated by 1 comma and 1 space (example: "Clan, Hero"). The order does not matter
31
If you want to add 1 mech which is identical in 2 or more references, list each reference in "Ref" separated by 1 comma and 1 space (example: "Ref1, Ref2"). The order does not matter
32
If you want a new copy of the original sheet, to check for updates, or to see my other projects: https://drive.google.com/drive/folders/1skMKzNepCrVWjIWhF4lpJDadPoRaEcfI?usp=sharing
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