I made a MP tracker for those that might be interested.

Since Bioware decided to say fuck the community and removed the expert pack pity timer, I went ahead and updated the theoretical maximum with Premium Pack pity timer assuming worst luck possible.

Added "S" variants of common weapons

Sorry about the delay, there was a death in the family, so my timeline was a little screwed up for awhile.

Expert Packs used to have a pity timer that guaranteed one N7 per 10 packs (500,000) This effectively gave us a theoretical maximum possible amount of gold required to max N7's.

Since that has been removed from expert packs, the old maximum no longer applies.

The pity timer now only exists for premium packs and still requires 10 to GUARANTEE a N7 item (1,000,000) The theoretical maximum assuming WORST possible luck has doubled because of it.

The estimated total should be fairly reliable to give you an accurate conclusion on how many credits would be required to Max N7's, the theoretical maximum is assuming worst possible luck and in actuality is less accurate because it's based on receiving one N7 per 10 premium packs.

2.0 update: Changed the design a bit to make the document look slightly more clean. Now the items are still alphabetical but are sorted by rarity. Also instead of being RED or GREEN the colors show progress a little bit better. 0 = Grey, 1-4=Red, 5-7=Orange 8-9=Yellow 10=Green Credit to r3v3l4t0r for the suggestions.

2.1: Added Angara Exemplar (UR Character) and Reegar Carbine (Rare shotgun)

And you'd assume wrong. I manually updated his sheet and including the MF mods it's more like 4k more games. Now that's not realistic since you can only buy those with MFs, but assume it's probably over 3k more games. My manifest was 90% complete before the update and with some packs last night I am up to a whopping 33% completion now. Woohoo.

I'm about to work on updating this sheet, but I am trying to decide if I should use tricky math to do so. Because technically the new variants (bulwark/siphon/concussive) have an exceedingly low chance to drop UNLESS you already have that weapon at level X.

So should I code it so that it only accounts for variants once level X weapons have been achieved or should I just mass update it with all the new cards and say f*** it.


Maybe I will go ahead and mass update the sheet, and if I get to it I will add the "tricky math." at a later time.

Expect an update in 24 hours, sorry for the delay but I am helping people move today so I won't be able to get to it till later tonight.


EDIT:  I'm putting platinum at 110k right now as far as per completion cost, I don't recall the exact number for full extraction so if anyone enlightens me I will fix that.

Here is my update. Just clear out my numbers.

docs.google.com/spreadsheets/d/1PcojithIPQwZYI4Z5Z4-5IsV6OviZX37e_Vx3ncVEiI

Kishock too for that matter. Thanks.

And just to make sure, it's not my sheet but rather my 1.09 updates to Dustin's sheet.

I'm finalizing a slightly new design as we speak. It will be ready in roughly 20 minutes or so. Just going over each formula for accuracy.

Formula's are accurate and fixed, now just adding all the new shit, another 10 minutes or so as of 10:24 CST

The formula's as they were were not prepared for the Rank XX characters, I basically had to re-code the entire sheet because the characters needed to be weighted differently from everything else.  That in particular is why this update took longer then I was hoping.

Opened the spreadsheet. Scrolled down. And down. And down. Closed spreadsheet. Going to bar...

That's depressing. I feel really bad for folks starting from scratch. Shit. I feel bad for veterans too.