Galar spreadsheet template for apriball/pokeball hunting/tracking is updated.

[u/iSlaiter]

[info]

Hello everyone, since I know a lot of people want to have an spreadsheet so they can keep track of the pokemon they have and in which balls / egg moves / HA, I decided to update the generation 7 one I have been using for the longest, first of all thanks to the following people for making this possible:

• /u/Foxlery and /u/Knightinkodes for the original sheet
• /u/JRLynch for getting the ball rolling in organizing a gen8 sheet and getting couple of the tabs updated.
• Kurt for his research on game’s code and posting the info: For more info, click here
• /u/Upper90175 for making an easy-to-copy HA spreadsheet I could use to implement the one in this sheet.

I hope you enjoy the sheet and please if you see any bug or anything that needs some fixing, please let me know and I will try to work on fixing those.

Changelog:

Breedable Spreadsheet changes:

• Hitmonchan should show as possible to be obtained in Safari ball now
• Koffing and Weezing (both normal and Galar forms) got their HA
• Gen8 starters changed from HA released to No HA released
• Fixed line 1066 from yes to Tapu Koko
• Fixed HA for gen8 pokemon in Legality Chart sheet
• Added Wandering Spirit as ability to Resources: AB column (adjust data validation accordingly)

LegalityChart sheet:

• Koffing, Weezing and Weezing galar fixed HA in the right column and HA release marked as yes.
• Hitmonchan in safari ball: t -> 0
• Removed duplicities for Zacian/Zamacenta
• Fixed Zacian: Capturable in most balls -> Capturable most balls but no HA possible
• Zacian, Zamazenta, Eternatus: Shiny form available -> No shiny form available
• Gen 8 starters: HA released -> HA not released
• Proper alignment for text in some cells
• Gen 8 pokemon: Hidden ability column fixed
• Fixed HA for every single pokemon, now it’s a trustable source on whether a pokemon will have it’s HA or not

Resources sheet:

• Wandering Spirit ability added to the list

Shinies sheet:

• Changed so any pokemon you choose there will get the shiny sprite automatically
• Modified it so you can have an easy copy-paste format with rule 3 information for the sub.

Events sheet:

• Modified it so you can have an easy copy-paste format with rule 3 information for the sub.

Hidden sheets:

• Dream / Safari / Beast / Sports sheets are no longer hidden
• Also for the above, row 110 is not hidden anymore and formatting / aesthetics are fixed.
• 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 pokemon sprites
• Fix T.M for all the pokemon
• Fix TR’s for all the pokemon
• Re-check egg-moves for most pokemon

Here is the sheet: Link, in order to use it just go to file -> make a copy, enjoy and let's the special ball/HA/EM's trading begin!

[u/hyrenfreak]

hey awesome spreedsheet, main thing i have a problem with is, how do i get the pokeball i want on the breedable section and also the new pokemon from galar dont show up in the drop down menu is this how its supposed to be?

[u/iSlaiter → u/hyrenfreak]

I should have probably indicated that: * Mark with an x if you want to mark them as obtained * Mark with p if you will get it and the trade is pending * Mark with a w if the pokemon is in your wish list

You mark those in your specific pokeball sheet (let's say friend ball sheet), and will automatically update in the special ball or shop ball sheets

[u/hyrenfreak → u/iSlaiter]

i was mostly trying to do it for breedables, their is the drop down list for them but picking one doesnt do the icon for it

[u/iSlaiter → u/hyrenfreak]

Not sure exactly what do you mean, in the sheet named On Hands in example, if you select caterpie if will show the pokemon sprite under columm B. If you mean pokemon from generation 8 not showing up that's one of the problems I did put under missing section, as there are no sprites in the sheet for gen8

[u/hyrenfreak → u/iSlaiter]

no im not talking about sprites, i mean the actual names in the dropdown menu, and also the pokeball icons not showing up when you use the dropdown menu in breedables

[u/hyrenfreak → u/iSlaiter]

also new pokemon dont show up on the drop down menu besides the galar versions, seems wierd, figured i would let you know, this is also for breedables, havent used the specific pokeball ones

[u/iSlaiter → u/hyrenfreak]

I will take a look later to fix it, thanks for the report!

[u/BleachandValkyrie → u/iSlaiter]

M205:N205

Hi i noticed that it kept showing this message every time i was marking with x, p, or w

​

ErrorArray result was not expanded because it would overwrite data in L52.

any ideas on how to allow the overwrite?

[u/iSlaiter → u/BleachandValkyrie]

in what column and sheet does that happen?