ABCDEFGHIJKLMNO
1
Trainer Level:NamePokémonCPHPDust PricePowered Up?LevelIndividual Values% PerfectPerfect CPPowered Up CPMaxed CP
2
40ATKDEFSTA
3
To use this sheet: File > Make a Copy or go to this URL:Magmar6845913006 combinations22% to 75%
4
Dragonair4735510008 combinations64% to 73%
5
https://docs.google.com/spreadsheets/d/1wbtIc33K45iU1ScUnkB0PlslJ-eLaJlSZY47sPME2Uk/copyOmanyte45841190015 combinations44% to 84%
6
Spreadsheet by /u/aggixxEevee320491300111515271.1%33810262768
7
Pinsir4555380010 combinations62% to 77%
8
LEGENDExampleDratini1012440017 combinations91% to 95%
9
Yellow cells are input cells. Hover over the column's header for more info.Example 1Dratini11626400TRUE6 combinations93% to 95%
10
Example 2Dratini13028600TRUE2 combinations93% to 95%
11
Blue cells are automatically calculated when you change yellow cells.Example 3Dratini14529600TRUE2 combinations93% to 95%
12
Example 4Dratini16031600TRUE613151595.6%1629763498
13
Light gray cells are some helpful analytics.
14
15
16
HOW TO
17
Not sure what to do? Try this:
18
1) Pick a pokemon whose IVs you'd like to calculate, and enter its species, CP, HP, and Dust Price in a new row.
19
20
2) If you're sure the pokemon hasn't been Powered Up before, then you can leave "Powered Up?" blank. If you have, then select TRUE.
21
22
3) The sheet will make some calculations and you'll get one of two outputs:
23
24
3a) If there's only one possible configuration of IVs it will display them. All done! See the statistics in the light gray columns.
25
26
3b) There's multiple possible combinations of IV, and the sheet needs more info to narrow it down for you. You can see the different combinations in the dropdown, as well as the min and max perfect %. If the max % is below 80% you probably want to transfer it and stop here. If its got good IVs and you may be interested in leveling it then continue.
27
28
29
30
31
4) Give the pokemon a unique name in the Name column, then make a new row below it with the same name but " 1" appended (without quotes). Enter the pokemon's new stats after you've powered it up one time. Make sure to set "Powered Up?" to TRUE. The sheet will narrow the list of IV combinations.
32
33
34
35
5) Repeat step 4, increasing the number after the unique name by 1 each time until you either know the exact IVs, or the perfect% range is too low to continue.
36
37
38
WHAT IS THIS
39
IVs, or Individual Values, are the hidden stats that determine the power of a pokemon. The pokemon's level and its IVs combine together to determine how strong the pokemon is. By knowing its IVs, you know how powerful it will be at higher level or when evolved. Furthermore, since you can level any Pokemon to max with enough dust, if a Pokemon has perfect IVs then you also know that Pokemon is as good as it can possibly be.
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
Error
Google logo

Google Docs encountered an error. Please try reloading this page, or coming back to it in a few minutes.

To learn more about the Google Docs editors, please visit our help center.


We're sorry for the inconvenience.
- The Google Docs Team