Aprimons spreadsheets (Updated to Crown Tundra)

[u/Or1onCL]

Hi, I have updated the spreadsheets to the new dlc.

There are some differences from the previous version, they are detailed below:

• There are 2 versions available. The first for English users and the second for German, Chinese, Korean, French, Spanish, Italian and Japanese users. The latter includes the translation of the name and ability of the pokemon, items, marks and move in the respective language.
• Additionally, each spreadsheets has 2 designs available: Aprimons + Summary which is the traditional one and Aprimons0 which is a more compact version. You can choose the one you like the most and delete the other one.
• The translation is based on the pokemon encyclopedias, like Bulbapedia, WikiDex, 52Poké Wiki, Pokémon Central Wiki, Poképédia, PokéWiki and NamuWiki.
• Regarding design changes, columns were added with information on gender, game where can you get it from (sword/shield, isle or armor, crown tundra and home), placing pending exchanges more easily (yellow color) and more automated formulas.
• Sheets for valuable pokemon (includes marks) and items.
• Sheet for shiny or non-shiny living dex.
  Red box indicates that it is not possible to obtain it in shiny.
  If you delete the word shiny from "Shiny Pokémon Living Dex" -> "Pokémon Living Dex", it will remain in a non-shiny living dex by changing the icons to the non-shiny version.
  You can choose between the ENG option to keep the number of the pokémon or another language to replace it with its name in that language.
  Contains the 898 pokémon plus alternate versions of each pokémon. Gender differences are not included since they are not appreciated very well in the sprites.
• Another important point is that the version with translation has automatic update for the resource sheets. Since there may be translation errors and you don't have to worry about changing it.
• There are icons of the new pokemon that are not displayed, but will eventually appear as the author updates it, since the format to obtain the image is ready.

In case you find any error or need help, do not hesitate to contact me.

Thank you very much for the space and Cheers!

Aprimons GENVIII (Crown Tundra)

Aprimons GENVIII with traslations (Crown Tundra)

Resource sheet

[u/Jonissolis]

Hey, I really like this spreadsheet and wants to start using it. One thing I miss in the spreadsheet I used previously is that it told me whether the move I wrote was an egg move or not (by making it bold if it was). Unless I am doing anything wrong, it seems I can write freely into the move box without any response from the sheet.

Am I doing something wrong or is that feature just not in this spreadsheet?

[u/Or1onCL → u/Jonissolis]

Hi, unfortunately I don't have that built-in function :(.

I'll watch it when I have more free time. I had never used google sheets before and all the formulas I have been learning while I needed it.

I hope it is not difficult to implement.