Create-A-Pokemon_SwSh_Base_Stat_Ratings_Calculator_8-12-20.xlsx

	A	B	C	D	E	F	G	I	J	L	M	N	O	Q	S	T
1
2		Hello, and welcome to CAP's Base Stat Rating Calculator! This calculator will perform all the time-consuming mathematics for you, and rate your Pokemon's stat spread relative to all other Pokemon in the game, so that you don't have to. To get started, here's what to do:
3
4		1. Enter your stat spread into the table below under any of the rows - there are twenty in total, so you can compare different stat spreads. This is all you need to add - the calculator will do everything else for you.
5
6		2. If you prefer, you can copy and paste the data of an existing Pokemon in to see its stat ratings (look under the "BSR of All Pokemon" tab at the bottom of the screen).
7		3. Copy and paste your calculated stat ratings anywhere you want to. If you enter an official CAP stat spread competition, you'll need to include these values for your submission to be legal.
8
9		Oh, and one last thing - don't mess about with the formulae if you don't know what they do! These are quite complicated, so we'd recommend reading up on them if you want to fiddle with them.
10
11
12		HP	Atk	Def	SpA	SpD	Spe	SF	BST	PT	ST	PS	SS	BSR	PT / ST / PS / SS Range	Description
13															x < 25	Horrible
14	1	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	25 < x < 50	Bad
15	2	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	50 < x < 75	Poor
16	3	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	75 < x < 100	Below Average
17	4	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	100 < x < 125	Above Average
18	5	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	125 < x < 150	Good
19	6	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	150 < x < 175	Very Good
20	7	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	175 < x < 200	Excellent
21	8	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	200 < x < 225	Fantastic
22	9	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	225 < x	Amazing
23	10	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025
24	11	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	BSR Range	Description
25	12	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	x < 50	Horrible
26	13	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	50 < x < 100	Bad
27	14	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	100 < x < 150	Poor
28	15	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	150 < x < 200	Below Average
29	16	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	200 < x < 250	Above Average
30	17	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	250 < x < 300	Good
31	18	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	300 < x < 350	Very Good
32	19	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	350 < x < 400	Excellent
33	20	100	100	100	100	100	100	572	600	170.861	173.41902	166.85047	176.88386	391.19025	400 < x < 450	Fantastic
34															450 < x	Amazing
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