Ever wanted to track your progress on REQ cards and see how close you are to collecting them all? Well I’m not sure if this has been done before but I was bored today and decided to make a spreadsheet that helps track your REQ cards and certifications. It gives estimates of how many bronze/silver/gold packs you have left before completing your collection as well as cost in $USD and REQ Points. It also gives you progress in each category in each rarity of card.
All that needs to be done is to input your stats from the site into the spreadsheet and numbers are calculated automatically. Instructions are also on the document for reference.
Some interesting stats that showed:
If you were to get all commons from bronze before moving to silver/gold you would get approximately 185 bronze packs at around 231,250 RP.
If you got all commons from bronze, and uncommons/rares from silver you would have about 238 silver packs at about 1,190,000 RP or $473.62.
Getting gold last after unlocking all rares and below would net you 168 gold packs at 1,680,000 RP or $502.32.
And a total of 3,101,250 RP or $975.94.
Here’s an example of a spreadsheet with my REQ stats on it for reference:
I’m aware of the site’s collection. That’s why I have it so you input your stats and it shows you things like how many packs you have left to open and calculates how much they are.
Just to give you a heads up, there are a lot of exceptions to the rules when it comes to these packs. For instance, many of the energy bayonet loadouts are unavailable in the REQ pack their rarity would suggest. Or there’s the Nadir emblem, a rare that is obtainable from a Bronze pack after you’ve exhausted the commons from Bronzes. Or the majority of the Rare and above emblems, which are earned through commendations and promotions.
I have my own spreadsheet, similar to yours. Except it requires each REQ item to be checked off manually, and it handles the calculations from there. Which is a royal pain in the -Yoink- to program.
> 2793974233127597;5:
> Just to give you a heads up, there are a lot of exceptions to the rules when it comes to these packs. For instance, many of the energy bayonet loadouts are unavailable in the REQ pack their rarity would suggest. Or there’s the Nadir emblem, a rare that is obtainable from a Bronze pack after you’ve exhausted the commons from Bronzes. Or the majority of the Rare and above emblems, which are earned through commendations and promotions.
>
> I have my own spreadsheet, similar to yours. Except it requires each REQ item to be checked off manually, and it handles the calculations from there. Which is a royal pain in the -Yoink- to program.
Yea I noticed the Common Energy Bayonet AR card under the Rare category when I was making the spreadsheet. Though I hadn’t even thought about the emblems unlocked from progress and not RNG. I may have to adjust some formulas someday to accommodate for those extras. I was trying to make it so you could always track how many packs you had left to buy at any time. The whole checking off each REQ item definitely seems like a pain to handle lol. Thanks for pointing this out to me though, btw.
But for whatever reason, you removed the credits to myself (the creator of that spreadsheet) and to the other people that helped keep it updated. You all can find the updated version of the spreadsheet here:
i can’t believe I need 205 silver packs and then 326 gold… Although if I got all the silver I probebly would need less gold. But it is a lot of money if you wanted to buy all of them!