[WiP] Teambuilder Excelsheet

[Eezeh]

Hello there!

Just wanted to share the excel sheet I made and am currently using to have a clean overview of my team.
I'm still working on the sheet, and have a lot of work to do. So don't expect it to be perfect by any means.

I'll look into all suggestions! I'm not perfect, let me know if I made a mistake or if you think I should change something.

 

The file contains 5 identical empty sheets, and 1 example sheet. (for preview, see screenshots)

Example is fully locked with a password, and can only be deleted not edited.

The other sheets only have essential values locked. In order to unlock these values go to Review > Unprotect Sheet. (see screenshots)

 

Download link: Dropbox (https://www.dropbox.com/s/jx463c6gbrwyajp/Pokemon%20Teambuilder.xlsx?dl=0)

What it currently offers:

Overview of following things:
- Role

- Pokemon Name
- Ability and Nature

- Placeholder for Image

- Moveset

- Items and EVs

- Weaknesses/Strengths for each individual pokemon

What I'm working on:

- Improving Strengths/Weaknesses overview

- Adding automated colors, conditional formatting

- Adding automated functions

- Suggestions

 

Screenshots:

Spoiler

Preview of Example sheet (https://i.imgur.com/QLAuCrp.jpg)

 

How to unlock all values (https://i.imgur.com/D0eH4qc.jpg)

 

Note:
I'm new to the forums so if you have any suggestions that will improve my post feel free to reply.

~ also not sure if this is the place to post this kind of post. (let me know if I have to move it)

Edited August 12, 2018 by Eezeh
Work in Progress

[Eezeh]

Reserved for future additions.

[Eggplant]

I think the most appropriate place for this would have been under "Client customization" and labeled as [Tool], but it's kinda subjective. As this app is quite limited in functionality at the moment.

[DeadGorilla]

https://play.pokemonshowdown.com/teambuilder

http://pokemonforever.com/teambuilder.php

[Eezeh]

21 hours ago, DeadGorilla said:

https://play.pokemonshowdown.com/teambuilder

http://pokemonforever.com/teambuilder.php

I guess these sites are a bit more automated, but I just prefer to use excel because it allows you to fully customize everything inside your own spreadsheet
(including notes, adding events on certain actions/values, etc)

All comes down to personal preference imo.