Hello everybody, I am building a spreadsheet to analyze and predict my pokemons’ performances in PvP. I had a look at the comprehensive spreadsheet by gamepress and the formula, but I find some results that are completely different. Can you please help me to correct my calculations?

For exemple Lugia ES/SA is given with 16,50 dps and 620,3 tdo, in ML.

According to formulas explained here:

and here

I try to calculate dps with the following formula:

DPS=Fdps+Feps x Cdpe

So, for the fast move I calculate:

ST=TDO/DPS (in spreadsheet)

=620,3/16,5=37,6

Fdmg=0,5 x Fpwr x (A+15)/200 x stab x 1,3+0,5

=0,58x208/200x1,2x1,3+0,5=6,99

Fdps=Fdmg/Fdur=6,99/1,5=4,66

Mod Feps=Feng/Fdur-0,5 x Ceng/ST

=10/1,5-0,5 x 45/37,6=6,07

For the charged move I calculate:

Cdmg=0,5 x Cpwr x (A+15)/200 x stab x 1,3+0,5

=0,5x80x208/200x1,2x1,3+0,5=65,4

n=(3 x ST x Feps-3 x 0,5 x Ceng)/Ceng

=(3x37,6x10/1,5-3x0,5x45)/45=15,21

Mod Cdmg=Cdmg x (n-2)/n

=65,4 x 13,21/15,21=56,8

Cdpe=Mod Cdmg/Ceng=56,8/45=1,26

So finally I have

DPS=Fdps+Feps x Cdpe

=4,66+6,07x1,26=12,32

But this result is quite different than the 16,5 dps shown in the gamepress’ spreadsheet.

Please can someone explain me where I am wrong? Thank you in advance and sorry for may bad english