Mission Tracker for PT 23

IRockThs · 06-07-2022, 01:10 AM

Google Drive Link because it's too large to host on the forums directly.

This is the first copy of my Mission Tracker for PT 23. It is current as of the June live update (June 12) with all cards in the game and all missions.

Known Issues

Name Game Alex, Daniel/Danny/Dan and Mathew/Matt - I'm not sure on the actual card numbers required cause I've already submitted on all accounts.
It may not show a mission as complete that you have completed, or completed that you have not. This is probably due to live updates changing ratings/teams. The game won't uncomplete submitted missions. There's no easy way to fix this issue, just have to track manually.
The Conditional Formatting only highlights a completed mission when it is EXACTLY 100% complete. I swear I fixed this like 15 times tonight. It should be fixed on my next update.SHOULD BE FIXED AS OF VERSION 2.
The sheet is not the best at remembering cards you used to have. I am looking to make a solution that's more automatic than what I have to for mine currently (manually add the cards in), but with the CIDs not just adding onto the end every time that makes things a bit more complicated. For example, BALs added their Gold card before the CID of the Silver and Bronze cards. The export always exports in reverse alphabetical order from the card shop, so I can't sort by most recently added.

To use this tracker, download a copy and save it wherever you want to use it (it won't work correctly in Google Sheets online). Any character you want to use in the "Owned" column on the Cardlist sheet will update the missions on Mission Tracker. Mission Tracker doesn't update the card list with the fact that you own the card after finishing the mission (there's a few reasons that doesn't make sense so I didn't add it).

Right now, the main thing I wanted to get released was the tracker itself. However, I would like to add quite a few things that are not implemented currently.

The PP value of the Cards/Packs earned from finishing a mission.
The future earnings potential/value of a card, especially on new accounts (so people starting accounts partway through the cycle can get the best return on early PP gains). This will require a decent amount of work, as it would require calculating how likely a player is to earn achievements + how much WAR that player would be worth at varying levels.
Overview of all Mission Edition cards, mainly for newer players, similar to the one that existed for 21 and I'm not sure returned in 22 (could be wrong).

This will obviously involve working with the community and building on other community work. No guarantees that the bigger features will be added because they would be a ton of work and not necessarily be accurate, but I'll see what I can do with it. I think at least a review of the Live Rewards will be helpful.

If you have any questions or issues reach out to me on Discord (IRockThs #5658) as I'm much more active there than I am here.

Version history:
Version 2: Fixed some issues with formatting and missing cards in version 1. Added BAL Mission set 2 and Brooks Mission set 2.
Version 1: Initial version.

IRockThs · 06-07-2022, 01:31 AM

Apparently it's NOT actually updated for 6/6 as there's a lot of cards I'm finding that are not in my tracker. It looks like mostly the new live cards that were added. I will try and get this updated with all of those cards tomorrow, but it's too late to get that done tonight.

IRockThs · 06-13-2022, 01:55 AM

Update: Added the BAL Gold + Brooks Diamond missions as well as updating cards through 6/12. The live missions should have accurate required cards, but let me know if you see a discrepancy.

Supposedly this week's release is going to be a LOT of cards which could be fun. In theory the future updates should go faster, but the main issue with updating the tracker is missions. If it's a lot of cards with few missions it should be fine (should).

06-07-2022, 01:10 AM	#1
IRockThs Minors (Rookie Ball) Join Date: Mar 2019 Posts: 33	Mission Tracker for PT 23 Google Drive Link because it's too large to host on the forums directly. This is the first copy of my Mission Tracker for PT 23. It is current as of the June live update (June 12) with all cards in the game and all missions. Known Issues Name Game Alex, Daniel/Danny/Dan and Mathew/Matt - I'm not sure on the actual card numbers required cause I've already submitted on all accounts. It may not show a mission as complete that you have completed, or completed that you have not. This is probably due to live updates changing ratings/teams. The game won't uncomplete submitted missions. There's no easy way to fix this issue, just have to track manually. The Conditional Formatting only highlights a completed mission when it is EXACTLY 100% complete. I swear I fixed this like 15 times tonight. It should be fixed on my next update.SHOULD BE FIXED AS OF VERSION 2. The sheet is not the best at remembering cards you used to have. I am looking to make a solution that's more automatic than what I have to for mine currently (manually add the cards in), but with the CIDs not just adding onto the end every time that makes things a bit more complicated. For example, BALs added their Gold card before the CID of the Silver and Bronze cards. The export always exports in reverse alphabetical order from the card shop, so I can't sort by most recently added. To use this tracker, download a copy and save it wherever you want to use it (it won't work correctly in Google Sheets online). Any character you want to use in the "Owned" column on the Cardlist sheet will update the missions on Mission Tracker. Mission Tracker doesn't update the card list with the fact that you own the card after finishing the mission (there's a few reasons that doesn't make sense so I didn't add it). Right now, the main thing I wanted to get released was the tracker itself. However, I would like to add quite a few things that are not implemented currently. The PP value of the Cards/Packs earned from finishing a mission. The future earnings potential/value of a card, especially on new accounts (so people starting accounts partway through the cycle can get the best return on early PP gains). This will require a decent amount of work, as it would require calculating how likely a player is to earn achievements + how much WAR that player would be worth at varying levels. Overview of all Mission Edition cards, mainly for newer players, similar to the one that existed for 21 and I'm not sure returned in 22 (could be wrong). This will obviously involve working with the community and building on other community work. No guarantees that the bigger features will be added because they would be a ton of work and not necessarily be accurate, but I'll see what I can do with it. I think at least a review of the Live Rewards will be helpful. If you have any questions or issues reach out to me on Discord (IRockThs #5658) as I'm much more active there than I am here. Version history: Version 2: Fixed some issues with formatting and missing cards in version 1. Added BAL Mission set 2 and Brooks Mission set 2. Version 1: Initial version. Last edited by IRockThs; 06-13-2022 at 02:02 AM. Reason: Updating for new version

06-07-2022, 01:31 AM	#2
IRockThs Minors (Rookie Ball) Join Date: Mar 2019 Posts: 33	Apparently it's NOT actually updated for 6/6 as there's a lot of cards I'm finding that are not in my tracker. It looks like mostly the new live cards that were added. I will try and get this updated with all of those cards tomorrow, but it's too late to get that done tonight.

06-13-2022, 01:55 AM	#3
IRockThs Minors (Rookie Ball) Join Date: Mar 2019 Posts: 33	Update: Added the BAL Gold + Brooks Diamond missions as well as updating cards through 6/12. The live missions should have accurate required cards, but let me know if you see a discrepancy. Supposedly this week's release is going to be a LOT of cards which could be fun. In theory the future updates should go faster, but the main issue with updating the tracker is missions. If it's a lot of cards with few missions it should be fine (should).