"Top Pokemon of each type across all gens with Bulk/DPS/TDO/Effectiveness and Raid Score calculations"

#PokemonGO: Wanting to know how the current Pokemon pair up against their peers, I decided to create this spreadsheet. Little did I know how much work this will actually require. But it's finally done and I'm happy to share it with everybody.What this spreadsheet accomplishes: it compares the stats of all Pokemon, of each type, across all generations.In my calculations, I paired up all the types in separate spreadsheets vs a "Target Dummy" Pokemon. Basically, a made up Pokemon with 150 attack, 200 stamina and 200 defense. I set this target Mons type to be weak vs the attacker, in order for them to be SE (didn't add 2x SE). The "Target Dummy's" move set was equivalent to Waterfall and Hydro Pump, but without Type Effectiveness.Weather bonus was set to Extreme and Dodge settings were set to None.I didn't add a final top category for each type, because I considered that everyone can decide for themselves how to view the stats. Some people prefer glass cannons and thus would consider DPS%/TDO% a higher factor than let's say Bulk, and vice versa. If I would really have to make a ranking, I would base it on the Raid Score category for overall usefulness and Total Eff for best Dps.If you see ** next to some Pokemon's names, it means that their stats have been nerfed. I nerfed all of the Legendary Pokemon, which would have had their CP above 4K, just like Niantic did.I included all of the Pokemon of each type, above 2000 CP.If they have only one *, it means that their quick move can not be learned by them in the main series games, but since Niantic added moves that some Pokemon can't learn (eg. Rhydon with Mud Slap), I decided I would add moves to some Pokemon that would not get STAB otherwise.Three *** means that their stats were nerfed and they have a move set that they can not learn in the main series games.Clicking a Pokemon's name will take you to their respective Bulbapedia page.I'm not sure how to handle Pokemon that have several forms, with different stats yet, so I guess we need to wait and see how Niantic implements them.Please let me know if everything loads correctly, since I used a Function that links up several spreadsheets, it might error out sometimes. And also let me know your thoughts.I don't really know how to use a photo editor, so I can't really make a picture version, but if anybody can, feel free to use this sheet.Shout out to /u/Zyxwgh for letting me use his calculations.So here is the spreadsheetRemember, most of this is speculation, since we don't know how Niantic will change things up and add other moves, or change stats, or change formulas etc.Here is a spreadsheet I quickly put together with Mega Evolutions and all the different forms of Pokemon. I'll probably try to make a "just for fun" sheet which includes them. via /r/pokemongo http://ift.tt/2HsWJ7f