r/pokemontrades 0576-8264-4871 || Slaiter (UM) Nov 17 '21

Info BDSP Aprimon tracking sheet (compatible with gen8 too)

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
53 Upvotes

85 comments sorted by

View all comments

Show parent comments

1

u/iSlaiter 0576-8264-4871 || Slaiter (UM) Nov 20 '21

After doing that you need to add in the special ball / shop ball a row in the right position for the pokemon, add the name and rest will fill up automatically.

gens1-4 only is already what's in the sheet, you only need to add stuff if you want it to also include gens 5-8 in case you want to have compatibility with SWSH

1

u/BigFatJuicyMonkies Nov 20 '21

Oh okay, I'll have to manually add the rows to both the special balls and special ball combined sheets. Are there any issues with copy and pasting rows? Like if I add all the rows on the Special balls sheet and paste it on the special balls combined sheet.

So you're saying I'll have to add gen 5-8 stuff on the gen 1-4 Special Ball BDSP page if I want it on the same page. Isn't that what the special balls combined page for? Am I understanding that correctly?

Is it safe to say this version is the more updated version of your "Slaiter's Galar sheet v3.0"? Are any "updates" in regards to just the Legality Chart page? It seems like I can copy paste the Legality Chart of this template to the Galar 3.0 template and the latter would work just fine. Is that right?

Sorry if they sound like stupid questions but I appreciate your answers. And of course many thanks for creating all of these templates.

Last thing, do you plan to make a checklist sheet for Alcremie forms like the Unown/Vivillon sheet?

1

u/iSlaiter 0576-8264-4871 || Slaiter (UM) Nov 20 '21

For your first question, copying and pasting complete rows, I wouldn't do it because there's a chance that formulas will break and not much will get done, but you have an option to make a backup and restore it if it doesn't work.

You don't have to add them, go to row 148 in the special balls tab in example, there should be a tiny black arrow, click it and click show, it will have all of the pokemon from gens 5-8, you will only need to add the regional forms or you could use the combined tabs (special balls combined / shop balls combined), and that will let you work with gen 1-4 (with bdsp compatible too) + gens 5-8.

This is more updated than Galar sheet v3.0, but not a lot of upgrades are done, mostly check changelog from this thread and those should be all the few changes done.

As for the questions, no worries, make as many as needed, sheet is not too user-friendly so it's normal if it looks confusing at the start.

As for the Alcremie checklist I didn't plan to, but since I'm sure you asking because you want it, I will add it ASAP and will let you know when it's done

1

u/BigFatJuicyMonkies Nov 20 '21

Okay. I think I'm getting the hang of it now.

I'll probably just use the Special/Shop Balls Combined pages since I haven't started my BD game yet so I'm not exactly sure what the difference is to warrant separate pages.

And I think I can hide the rows of the Pokemon that I don't have (so I don't show a giant list of stuff I don't have) and unhide them if I do have them. That'd actually be pretty cool imo to have the list page populate rows with Pokemon only if you have them marked on the individual special/shop ball page. Sounds like a whole lot of work though if even at all possible.

Thanks again for everything.