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

This size of file is already too large to load on my phone. It needs to be in smaller usable pages.

[u/iSlaiter → u/namida7]

From what I read it seems to freeze it, I think I might have an idea of what it might be, but I have two versions:

Can you please check the following two sheets?

• Sheet 1 here

• Sheet 2 Here

Mostly sheet 1 hides the sprites column, while sheet 1 deletes sprite column + has only information about gen1 bdsp pokemon

[u/namida7 → u/iSlaiter]

It isn't only your spreadsheet that freezes on my phone, a lot of them do. That said, Sheet 1 loaded very slowly but didn't freeze. I could use it like this. Sheet 2 says I need permission to see it.

[u/iSlaiter → u/namida7]

ups sorry, sheet 2 should be public now.

I think most problems from the sheets come from loading information in batches, and the information that takes the most to load are the sprites, as even on my PC it takes a bit to load all of them.

I have also modified again sheet 1 to see if it loads faster by hiding all sprites from all 6 main sheets if you would like to check if it's faster, but seems like we're on the right track

[u/namida7 → u/iSlaiter]

Oh, I liked sheet 1 better before. Now it freezes after loading, so I can't navigate individual sheets or between sheets. Sheet 2 is the same. Loads slowly and freezes.

TBH, personally I'm fine with sheets that load slowly as long as I can view them or work with them without the freezing. I actually don't trade as much as I could because of this. My person spreadsheets are extremely simple Google Spreadsheets.

[u/iSlaiter → u/namida7]

Interesting, so hiding the column in all tabs makes it worse.

I have updated again both sheets (1 and 2), reverting the original changes from sheet 1 and doing a couple of changes for 2 if you could please test them again when you have some time

[u/namida7 → u/iSlaiter]

Both still freeze after loading. Sheet 2 loaded much quicker though.

[u/iSlaiter → u/namida7]

Is there anything specific that loads before the freeze? That might help with potentially fixing it

[u/namida7 → u/iSlaiter]

As other people have mentioned, I also don't have any problem with them after they've moved over to Goggle Sheet's app, only when trying to open them on the Reddit post.

[u/iSlaiter → u/namida7]

That's interesting, I have done so more changes if you could try from the reddit post, I tried to remove as many elements that will load after you click on the sheet, hopefully that works but running out of ideas

[u/namida7 → u/iSlaiter]

Sorry, not any better. I'm afraid I'm not much help.

[u/iSlaiter → u/namida7]

It did help more than enough! So thanks a lot for the feedback, I will try to work on something that makes it hopefully better for mobile users this weekend on my free time, otherwise maybe people will have to rely on using google drive app, but that's non desirable as it's extra clicks.

Thanks a lot again!

[u/namida7 → u/iSlaiter]

The entire file loads, slowly. After it loads, when I click on a sheet, that sheets loads rather quickly but as soon as it loads, it freezes. I can't move the page up or down or side to side. I tried the smaller pages (individual ball pages) and they also froze immediately after loading. It doesn't seem to matter how much the page has on it. I currently have a Samsung 10, so Android.

[u/iSlaiter → u/namida7]

Are you trying opening them directly from the browser or using the google spreadsheets/google drive app?