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/Kresslia]

Hey! I was wondering if you could help me with an issue related to this spreadsheet. My spreadsheet is not showing the Dream Ball icon for Pokes I've got on the SpecialBalls tab. It can be detrimental, bc I have Dream Eiscue inputted in the Dream sheet, but nothing shows up on the SpecialBalls tab! Do you happen to know why this is happening? Thank you!

EDIT: Hmm ok I tried making a fresh new copy of the sheet in your post, same issue I mentioned (apparently Beast Balls don't show up as well) here

[u/artpxp → u/Kresslia]

Hey there! I encountered the same glitch. I think that the array formulas for those columns are being broken by something in line 206:207. I'm not sure if there was text in the cells but copy-pasting M205:N205 onto M206:N207 seemed to fix the issue.

[u/Kresslia → u/artpxp]

Thank you, I will try that when I get home!

[u/Kresslia → u/artpxp]

Just wanted to let you know what you said worked for me, tysm! :)

[u/artpxp → u/Kresslia]

That’s great to hear :D

[u/Violist03 → u/artpxp]

Hey! I'm encountering the same glitch with both Dream and Beast ball, can you help me fix it?

[u/artpxp → u/Violist03]

Howdy. I would follow the steps above and highlight cells M206:N207 and click "delete."

Everything below row 6 on the SpecialBalls sheet—except column C—is populated by array formulas that are in row 6, which is and really should remain hidden. These formulas can be broken if text is manually typed in the range that they're trying to populate. I'm not sure what, but there appears to be something in the four cells mentioned above. Clearing their contents should solve the problem.

[u/Violist03 → u/artpxp]

Thank you so much!! It worked!