Download Link:
http://www.mediafire.com/file/kukku9y96s9m2h8/Team_Builder_1.02.xlsx
Introduction:
I haven't seen a teambuilder around that had quite everything I was looking for, so I took the time and built one myself now that there's a fresh generation. The teambuilder sheet is built to work in Excel for full functionality, and has outputs both for individual pokemon as well as overall team statistics.
Features:
When opened using OpenOffice, the teambuilder loses some functionality. It retains most of the basic functionality, but there are some features that no longer work correctly, such as:
Current Version: 1.02
Not sure how progress on others' particular modifications to this have been going, but I've made a couple very minor changes. An overall column has been added to the team analysis, and placeholders for no pokemon and no attacks have been inserted so teams can be analyzed with fewer members than 6.
Download Link:
http://www.mediafire.com/file/kukku9y96s9m2h8/Team_Builder_1.02.xlsx
http://www.mediafire.com/file/kukku9y96s9m2h8/Team_Builder_1.02.xlsx
Introduction:
I haven't seen a teambuilder around that had quite everything I was looking for, so I took the time and built one myself now that there's a fresh generation. The teambuilder sheet is built to work in Excel for full functionality, and has outputs both for individual pokemon as well as overall team statistics.
Features:
- Automatic population of stats, offensive and defensive typings, attack capabilities, and utility.
- Generation of derived stats for offense and defense including items, abilities, STAB, and move BP.
- Implementation of abilities such as Filter, Adaptability, Liquid Voice, Multitype, etc.
- Pretty picture that automatically updates for each pokemon put into the team.
- A speed comparison block to check if your team outspeeds certain threats.
- Automatic generation of an export block to paste into Showdown.
- Physical Power: relative value for the most damage a pokemon can do with a single unresisted physical attack, including attack BP, STAB, and ability or item modifiers.
- Special Power: as physical power, except with a special attack.
- Physical Bulk: relative value derived from a combination of HP, physical defense, and modifiers from items and abilities.
- Special Bulk: as physical bulk, except with special defense.
- Team Defensive Typing: all of the defensive typings for your team multiplied together, with immunities replaced by a 1/4 resist for consistency.
- Team Offensive Coverage: all of the offensive coverage abilities for your team multiplied together, with "positive" (green) coverage coming at 5 pokemon hitting neutral STABs and one super effective and "negative" (red) coverage if all 6 pokemon cannot hit with at least a neutral STAB total.
When opened using OpenOffice, the teambuilder loses some functionality. It retains most of the basic functionality, but there are some features that no longer work correctly, such as:
- Pictures no longer update to the pokemon used in that team slot.
- Judgment and Multi-Attack no longer update to the correct type based on item.
Current Version: 1.02
Not sure how progress on others' particular modifications to this have been going, but I've made a couple very minor changes. An overall column has been added to the team analysis, and placeholders for no pokemon and no attacks have been inserted so teams can be analyzed with fewer members than 6.
Download Link:
http://www.mediafire.com/file/kukku9y96s9m2h8/Team_Builder_1.02.xlsx
Last edited: