[Google Sheet] Collection Mission Index

[Goliathus]

I don't even know why I did it nor do I know how useful it is, but I have compiled the data from every collection mission besides the LIVEs on a google sheet. I have also made a collection tracker sheet so you can track your missions out of the game if you want. Just make a copy of it and do what you want with it: color it, destroy it, have fun with it.

https://docs.google.com/spreadsheets/d/1ZVEQwZw1QWxw7NBHGwIk9yKVPZEvW6qA4r9QMqCcQJw/

Notes:

- You cannot copy and paste the player column directly because I did not write it in the same format as the in-game auction house demanded. Also, I am not rewriting them.
- LIVE missions are not included. I refuse to write every LIVE card down like a maniac. Those missions are also easily solvable, just search LIVE card by a team name and buy them until everything's red on your page.
- Cards are in ascending orders based on their OVR. LIVE cards have no OVR rating due to their inconsistent OVR but I positioned them according to their OVR in the week of June 23 - June 29.
- The number in the details are how many stars and then X/Y. X is how many cards you need to complete the mission and claim the reward. Y is the total cards of the mission. For instance, "6/10" means you need to collect 6 cards out of the available 10 to complete the mission.


Mission tracker:
- I have made some examples on the sheet.
- Just make a copy of it for every team you want to track.
- Type anything to the respective E bracket to light up the row. This indicates that you have collected that card.
- After enough cards are collected and you reach 100%, the J bracket will light up.
- Everything is manually tracked though, so you have to record finishing the "Chicago White Sox Collection" yourself instead of having the sheet helping you on that.
- Again, I am not sure how useful this is, but I figured you can track the missions you plan to finish, especially the group mission, and have an easy visualization as to how close you are to completing all of them. If you are bored at work, you can check the tracker and figure out what cards and how many cards you need from the AH to finish the whole package.

HELP: There are some cards with unknown OVR ratings like 7X because my resolution is horribly small and the game isn't friendly to me. If the reward are two cards, I can't see the one behind the first. If you know the ratings of those cards, please tell me here or leave a comment on the sheet so I can update them to the correct numbers. Thanks.

[STLRS95]

This is awesome! I have been thinking of doing this forever, thanks for doing this. I am pretty new to google sheets and drive. I saved it on my drive, but cannot edit it, only comment. It says to ask permission to edit. My question is if I edit it, will it change your original document? I think it is all linked.

[Goliathus]

Originally Posted by STLRS95

This is awesome! I have been thinking of doing this forever, thanks for doing this. I am pretty new to google sheets and drive. I saved it on my drive, but cannot edit it, only comment. It says to ask permission to edit. My question is if I edit it, will it change your original document? I think it is all linked.

Asking permission will allow you to edit the original document, which is not really what you should be doing. Instead, all you need to do is to make a copy of it. Top left corner, File > Make a copy. Then it will make a copy of the sheet with you as the owner and you can do whatever you want with it.

[STLRS95]

Originally Posted by Goliathus

Asking permission will allow you to edit the original document, which is not really what you should be doing. Instead, all you need to do is to make a copy of it. Top left corner, File > Make a copy. Then it will make a copy of the sheet with you as the owner and you can do whatever you want with it.

Worked like a charm. Just ignore my edit request. HaHa

Thanks again for doing this, it is so much easier than clicking back and forth in PT.

[BigRed75]

One thing I noticed - as it was relevant to me - two of the five Reds missions are missing.

[Goliathus]

Originally Posted by BigRed75

One thing I noticed - as it was relevant to me - two of the five Reds missions are missing.

Added and Red missions rearranged according to the timeline. Be sure to remake a copy if you need the new collection sheet.

[Ty Cobb]

A quality contribution to the community! Thanks a ton.

[Charlatan]

I started using this over the weekend (thanks!) and noticed two other missing missions in addition to the two Cincy ones mentioned above:

Do Broken Hearts Ever Heal (the 1994 Collection)
Marlins

Thanks again for the sheet. I'm still trying to figure out exactly how best to use it, but I AM using it!

[Goliathus]

I believe those are part of the new missions? 24 missions are going to take me some time to update.

[Dogberry99]

Originally Posted by Goliathus

I believe those are part of the new missions? 24 missions are going to take me some time to update.

Both the Marlins historical and the 1994 mission were in the original batch.

[Goliathus]

The two missing missions are up and so are all the new ones. Hopefully I did not miss any this time.

Edit: There are some cards with unknown OVR ratings like 7X because my resolution is horribly small and the game isn't friendly to me. If the reward are two cards, I can't see the one behind the first. If you know the ratings of those cards, please tell me here so I can update them to the proper numbers. Thanks.

[Charlatan]

FYI, for the 1988 World Champion Dodgers mission, the Mickey Hatcher card is a 60 OVR.