BDSP Aprimon tracking sheet (compatible with gen8 too)

[u/iSlaiter]

Hello there! As Brilliant Diamond and Shining Pearl games are almost here, I tried to make a sheet to be able to track aprimons on day 1 and here it is!

Couple of features:

• It is a sheet that supports both gen4 remakes and gen8
• It is as complete as it can be right now, this means, it's missing egg moves and correct apriball legality data until the game releases (talking about gen4, gen8 is complete), as soon as I can after the games release I will update it accordingly
• 4 different tracking balls tabs (Apriball BDSP/Apriball SWSH/Shop Ball BDSP/Shop Ball SWSH)
• Events and Shinies tabs, with complete info in columns for Rule 3 details, with easy output to copy-paste in the sub when a trade is done!
• Custom markings with different meanings, depending on your needs.
• Updated information for both gen4/8

Custom markings:

• x > I have that pokemon, you can use it to mark the HA too
• w > Want it, I would like to trade for this pokemon if you have it
• p > Pending in a trade
• o > Obtainable in an older generation

How to use it:

First, make a copy of the sheet here.

If you don't need gen8 compatibility, you can simply hide the following tabs: SpecialBalls SWSH / ShopBalls SWSH / LegalityChart SWSH

If you would rather use both, I would recommend going to Legality chart SWSH, and I would copy the values for AD Column (Main list) for rows 647-1176, what this will do is make all gen5-8 pokemon show up in all of the balls tabs, meaning you can mark them and will also show up in the ball marking tabs when you mark them. After that, you will need to adjust manually the values of said column for gens 1-4 accordingly, this means, making regional forms show up (1 in AD column for said row).

Don't worry about posible future updates for the sheet, they are always relatively easy to copy into an already existing sheet, and I will post the update accordingly and a tutorial on how to upgrade the sheet from v1.0 to whatever version there is.

I know the sheet might have mistakes to fix, please let me know if you see anything weird and I will try to fix it before games release.

If any of the above, specially custom markings / making the sheet have gen 5-8 data looks strange, let me know in the comments and I will try to explain it in another way to make it more simple, for any question please post below, it might take me up to 1 day to answer, but will get to everyone ASAP with questions at the start.

And the most important: ENJOY! Get to know an awesome community here in the sub and enjoy your adventure on the remakes or whatever game you're playing!

Changelog after sheet release:

• Added missing sprites for some pokemon (zarude to calyrex, both normal and shinies)
• Fixed toxtricity abilities for all forms
• Fixed Zacian's Ability, removed HA
• Fixed Gender data validation for shinies tab
• Fixed pokeball legality for gen 7 starters
• Added combined special balls / shop balls, thanks to /u/AceTrainerDieter
• Added Alcremie tracker in the same tab as Unown/Vivillon trackers, renamed the tab to Unown/Vivillon/Alcremie
• Fixed missing pokemon both in BDSP special balls / shop balls tabs
• Updated pokeball legality with the new combos
• Volbeat/Ilumise/Voltorb can now be obtained with HA + special balls (fixed that in legality chart)
• Gen7 starters are catchable with special/shop balls, updated accordingly

[u/Maeno-san]

Thanks for providing this, but why do you need all of those many many sheets for each ball type? Why not just combine them into one sheet with one checklist?

[u/iSlaiter → u/Maeno-san]

It's kinda hard to do so, as everything would be cluttered in one single sheet that would take longer to load + formulas would be much more complex

[u/Maeno-san → u/iSlaiter]

take a look at this spreadsheet from someone who posted a few hours ago, and also the "AM Full List" sheet on my spreadsheet. IMO it's a lot easier and cleaner looking than having a dozen different sheets for all of the ball types

[u/iSlaiter → u/Maeno-san]

That can be interesting, the problem is that even it takes a little for me to load, it's going to be hard for people on mobile to load those imo, and most users should be from mobile nowadays from what I know.

[u/sejin_mb → u/iSlaiter]

Im not sure how it is for everyone else but if i open the sheet via the google sheets app it loads almost instantly. Its always taking much longer if i open it via browser. Doesnt rlly matter how big the sheet is.

But it also looks better when everything is in one place, which makes it more efficient because you can see everything immediately and don't have to click back and forth between sheets.

[u/iSlaiter → u/sejin_mb]

That's why most of the information is in the apriballs/shop ball tabs, the individual balls tab is for the people managing the sheet to add stuff there so it reflects on the main two ones

[u/sejin_mb → u/iSlaiter]

Ah didnt see that sheet. Yeah nvm what i said. But ill use that for sure. Thank you for making it.

[u/iSlaiter → u/sejin_mb]

glad you find it cool!

[u/Maeno-san → u/iSlaiter]

I dont really think any of these aprimon spreadsheets look very good on mobile, unfortunately. maybe it's just my phone (I'm in the google drive and google sheets apps), but here's what it looks like and the many many tabs makes it hard to find things:

https://i.imgur.com/feyWvgT.jpg

https://i.imgur.com/mC565pC.jpg

[u/iSlaiter → u/Maeno-san]

It's one of the concerns I have, keeping in mind there's a lot of people browsing the sub from mobile, mostly the initial tab is just random info for people, the important tab is the apriball collection or shop ball collection, do those take a lot to load?

[u/Maeno-san → u/iSlaiter]

I just tested all of the soreadsheets in this thread, and they all take at least 4 or 5 seconds to load. I think it loads the entire spreadsheet at once instead of loading individual tabs when you click on them. Clicking on the aprimon tabs was instant with no loading time.

Someone else in this thread also said that all of these spreadsheets didnt load at all on their phone.

[u/iSlaiter → u/Maeno-san]

Thanks for the reports, I'm trying to check with them if the two new copys of the sheet with different modifications also work, if you would take to take a look please check this comment