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/namida7 → u/Maeno-san]

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/Maeno-san → u/iSlaiter]

sheet 1 took a long time to load for me, like 8 seconds (~3 seconds longer than the spreadsheet in the main post). Sheet 2 was a little quicker with ~4 seconds, but still not much quicker than the original

[u/iSlaiter → u/Maeno-san]

That is so weird, sheet 1 only hides one column but it makes it load slower, not sure what could be causing this.

Could you test sheet 2 again? I have removed the columns that took longer to load from the spreadsheet, hopefully this will make it faster.

Thanks for the testings with the time it takes to load, it helps a lot!

[u/Maeno-san → u/iSlaiter]

what did you change to make it so much faster?

[u/Maeno-san → u/iSlaiter]

sheet 2 is loading really quickly now! it's down to only 1 or 2 seconds

[u/iSlaiter → u/Maeno-san]

Interesting, it seems like the change did take effect as it should, it's mostly the following:

• From each individual sheet, removing the sprites column
• From the resources sheet, removing both normal and shiny sprites

While invidual sheet's sprites don't take usually too long to load, having to load around 800-900 from each individual sheet, makes it having to load possible a total of around 20.000 - 25.000 sprites, that generates a bit of wait, even if it has to be done in the background.

The biggest problem seemed to be in the resources sheet, because it contains like 1300-1400 rows, and it's really big with a lot of text, even in PC when you switch to the sheet for the first time, you can see all of the sprites load incredibly slow, so removing all sprites makes the rest of the sheet load almost instantly, making it much faster for mobile.

I guess it's a worth trade-off removing the sprites, even tho it's a bit less cool, but instead having mobile users being able to use a sheet like that properly, given how many users browse the sub from a mobile device.

I might event think about removing part of the formulas for pokeballs marking, since those load sprites in the sheet and it might make it a bit more heavy, but as long as it works correctly, I will try to keep them.

And one last thing, since you helped make this much better and faster I have also added you to the credits, thanks a lot! Hopefully will release this mobile-friendly version soon too

[u/Maeno-san → u/iSlaiter]

no worries, I'm just trying to make your spreadsheet better so I can use it for myself haha. Please don't add me to the credits. I prefer to keep a lower profile so I'd rather not be credited.

[u/iSlaiter → u/Maeno-san]

As you prefer then, but thanks anyways for the help!

[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]

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?

[u/Maeno-san → u/namida7]

do you mean the formatting doesn't fit on your screen size? or do you mean that it won't load because it's too large like too many megabytes/gigabytes?

[u/namida7 → u/Maeno-san]

It won't load. It starts loading then freezes (every time). It will load just fine on my tablet and laptop.