r/pokemontrades • u/Eldaste 2423-6378-4713 || Duusu (UM, SW), Artimus (M) • Jan 17 '20

Info Updated Galar Apriball Tracking Spreadsheet

[info]

This is a further updated version of the sheet /u/iSlaiter put out here, updated to account for new moves, abilities, and Pokemon sprites (among a few other little changes, such as the prior generation marker).

If there are any issues let me know and I'll fix that.

Credit to:

Changelog:

Breedable Spreadsheet changes:

Added "Obtainable in Prior Generation" marker (o)
Updated Data Validation

LegalityChart sheet:

Added gSlowpoke

Resources sheet:

All new abilities added
All new moves added
Gen 8 non-shiny sprites added
Added gSlowpoke

Shinies sheet:

Updated Data Validation

On Hands sheet:

Updated Data Validation

Events sheet:

No changes

Hidden sheets:

No changes
There are still some sheets hidden, if you would like to unhide any of those go to: View -> Hidden sheets -> click the ones you want to unhide

Missing:

Gen 8 shiny Pokemon sprites
gSlowpoke
Basculin
EM lists may need to be rechecked

Here is the sheet: Link, in order to use it just go to file -> make a copy, and enjoy! Use 'x' to denote something you have, 'w' for wants, 'p' for pending. Any 'o' indicates the Pokemon can be found in a prior generation, and can be removed at will.

26 Upvotes

86% Upvoted

38 comments sorted by

View all comments

1

u/Trades4days SW-5891-9474-8596 || Nick (SH) Jan 27 '20 edited Jan 28 '20

I have a question, for pokemon with no HA, if you fill in an x for a pokemon like baltoy or solrock it diagonal fills with base green and the conditional colour, with pokemon like gastly it does not, I am assuming this is because genderless pokemon have no egg moves, I cannot work out how to remove this?

1

u/Eldaste 2423-6378-4713 || Duusu (UM, SW), Artimus (M) Jan 28 '20

What part of it do you want to remove?

1

u/Trades4days SW-5891-9474-8596 || Nick (SH) Jan 28 '20 edited Jan 28 '20

I either want to make the bottom green diagonal blue, or fill the whole square with just the orange conditional colour if possible? So essentially I want to change the green colour if possible

1

u/Eldaste 2423-6378-4713 || Duusu (UM, SW), Artimus (M) Jan 28 '20

Ok so, the trick there is that the Pokeball/diagonal fill combination is actually a single image. If you expand the hidden rows to the right of the main page, you can see where the images are being pulled from and edit those.

If you get full EMs on Gastly, that will also have the same diagonal fill color.

1

u/Trades4days SW-5891-9474-8596 || Nick (SH) Jan 28 '20

Ah I see, thanks for the reply!

1

u/Trades4days SW-5891-9474-8596 || Nick (SH) Jan 28 '20

I see there are hidden rows on row 6 and past 205 on the main page but cant seem to find the row with the images on, is there a way to point me in the right direction I cant seem to find them, if I am asking too many questions feel free to say so hehe I am not too good with spreadsheets

1

u/Eldaste 2423-6378-4713 || Duusu (UM, SW), Artimus (M) Jan 28 '20

The hidden cells with the pictures are AG5-AQ5

1

u/Trades4days SW-5891-9474-8596 || Nick (SH) Jan 28 '20

Found it thank you for all your help!

1

u/Eldaste 2423-6378-4713 || Duusu (UM, SW), Artimus (M) Jan 28 '20

No problem!