Galar Dex Analysis - PokéCommunityDaily
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Repurposed spreadsheet of the below. Edits by bobandbill of PokéCommunity.
2
See https://daily.pokecommunity.com/2019/08/26/analysis-of-the-galar-dex-generation-popularity-and-more/ for more details.
3
4
ddrox13's Fangame Dex Type Balancer Alpha 1.2
5
6
7
Basic Instructions:
8
1. Make a copy into your own Google Drive. That way you don't edit the master and ruin someone else's chart
9
2. Go into the sheet labelled "Dex Entry". It's on the bottom right of your screen.
10
3. Type a Pokemon's name into the column labeled "Pokémon Name".
11
4. Watch Excel (or GSheets) do Excel things
12
5.The Pokemon's type(s) and stats appear in the appropriate columns and get counted in the Type Balance and Stat Balance sheets
13
6. Click on either of those sheets to see a fancy table and also some numbers
14
7. ???
15
8. Profit.
16
17
Notes:
18
Spelling is important. Capatilization isn't.
19
Alolan Forms are designated as [Pokemon's name]-A. No space, and not "Alolan" written out. It won't work.
20
You can use those fancy arrows on top of the main table to sort the whole table by type or alphabetically
21
The tab "Form(e) List" in the bottom left has a list of relevant form differences. It also has a list of every alternate form NOT currently supported because I'm lazy.
22
Pokemon with multiple forms that you don't designate a form for will appear as their "base" form. (Exception: Nidoran just won't work unless you tell it which one)
23
Megas aren't implemented yet as far as I know,
24
The Type Balance Sheet will yell at you by turning red if you completely forgot about a type
25
The Pokemon Entry area will yell at you by turning red if you have a duplicate
26
To add a Fakemon, go into the "Ref" chart and add it's name and types to the bottom of the list
27
That said, don't touch the "Ref" chart if you don't have to.
28
The formulas, especially those underneath the dex entry section, are very fragile. Try not to break them.
29
The average stats WILL break if you leave a row blank or have an invalid entry (typo).
30
31
32
It'd be nice if you threw a link to this somewhere in your thread if you use it, but I really don't care that much.
33
And remember, a good regional dex has NO STINKY FIRE TYPES (except Fletchinder, who is cute)
34
35
Common Errors:
36
"Did not find value in VLOOKUP evaluation" - The sheet can't find what you told it to look for in the database. You either misspelled something or the row is blank.
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...