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

dustin1280
N2

Posts: 70 Likes: 175

I made a MP tracker for those that might be interested. Apr 20, 2017 1:07:20 GMT Pearl, SalMasRac, and 35 more like this

Quote

Post by dustin1280 on Apr 20, 2017 1:07:20 GMT

If you happen to be interested in tracking your progress and/or looking at the insane numbers required to max everything (including n7s), I made a tracker that could prove useful.

It's on Google Docs and if you want to use it, just make a copy to do so.

It does NOT error check for ranks above whatever the maximum in slot is, so don't don't be 20 in weapons or 30 in characters etc..

1.0: Original Public Release
1.1: Added remaining items left and estimated cost to acquire each.
1.2: Added estimated missions of each difficulty to complete collection
1.3: Added Ultra Rare Estimates assuming 400k per ultra rare, will change as more data opens up
1.4: Updated sheet to reflect 10 expert pack pity timer maximum theoretical cost.
1.5: Added X5 Ghost Rare Assault Rifle and Turian Agent Rare Character
1.6: Since rare packs no longer have a pity timer, updated the theoretical maximum assuming WORST luck
1.7: Added "S" variants of common weapons
2.0: 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 suggestion
2.1: Angara Exemplar (UR Character) and Reegar Carbine (Rare shotgun) added
2.2: Updated for patch 1.09. Platinum difficulty calculations, all variant weapons, batarian scrapper, and kishock harpoon gun have all been added. Coding was basically revamped to account for XX rank characters and only X rank weapons.
2.3: Added Batarian Vanguard, Shorty Shotgun+Variants
2.4: Fixed missing fields for Zalkin/Soned/Ushior (still calculated correctly, but weren't filled out originally), removed concussive variants of M-37 Falcon, Scorpion, Reegar Carbine and Venom (they don't exist), removed "Pistol Recon Scope" (doesn't exist.)
2.5: Added Human Juggernaut and Silhesh+Variants

I am going to see if I can make this more user friendly and less obtrusive to fill out, I will kick around some ideas and once I have one I like I will redesign it.
At the moment I am thinking of making a sheet that just has all the calculations, and making the other sheet data entry only. This would allow me to stack both vertically and horizontally for item ranks as opposed to ONLY vertically.

Last Edit: Sept 2, 2017 5:00:53 GMT by dustin1280

s0ulbearer N3 Posts: 475 Likes: 598 s0ulbearer inherit Male 2166 0 Jul 5, 2017 12:46:16 GMT 598 s0ulbearer 475 N3 Nov 22, 2016 23:21:46 GMT November 2016 s0ulbearer	I made a MP tracker for those that might be interested. Apr 20, 2017 1:09:28 GMT via mobile Liaras Stuffed Bra likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by s0ulbearer on Apr 20, 2017 1:09:28 GMT Don't worry I will find it myself.

Pearl
N5

optics cuck

Games: Mass Effect Trilogy, KOTOR, Mass Effect Andromeda
Origin: FatherOfPearl
PSN: FatherOfPearl
Prime Posts: 7,305
Prime Likes: 3,002
Posts: 3,898 Likes: 13,409

I made a MP tracker for those that might be interested. Apr 20, 2017 1:15:11 GMT SalMasRac and riviet like this

Quote

Post by Pearl on Apr 20, 2017 1:15:11 GMT

Nice job, way more user-friendly than the barebones "tracker" I threw together the day the game came out.

SPOILER: Click to show

i want to shoot myself

i.gyazo.com/d5c898b6d90597d09bcf0dcdf4a1c03b.png

Last Edit: Apr 20, 2017 1:26:58 GMT by Pearl

“The story so far: In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move.” ― Douglas Adams, 1980

dustin1280 N2 Posts: 70 Likes: 175 dustin1280 inherit Male 7800 0 Nov 13, 2017 18:03:53 GMT 175 dustin1280 70 N2 Apr 18, 2017 18:36:05 GMT April 2017 dustin1280	I made a MP tracker for those that might be interested. Apr 20, 2017 1:55:44 GMT SalMasRac, riviet, and 1 more like this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by dustin1280 on Apr 20, 2017 1:55:44 GMT Ouch! yeah the grind is pretty huge...

riviet
N3

Games: Mass Effect Trilogy, Dragon Age: Origins, Dragon Age 2, Dragon Age Inquistion, Neverwinter Nights, Mass Effect Andromeda
XBL Gamertag: Riviet
Posts: 256 Likes: 517

I made a MP tracker for those that might be interested. Apr 20, 2017 2:22:40 GMT SalMasRac and OneWomanArmy like this

Quote

Post by riviet on Apr 20, 2017 2:22:40 GMT

Apr 20, 2017 1:07:20 GMT dustin1280 said:

If you happen to be interested in tracking your progress and/or looking at the insane numbers required to max everything (including n7s), I made a tracker that could prove useful.

It's on Google Docs and if you want to use it, just make a copy to do so.

It does NOT error check for ranks above 10 so don't put ranks above 10.

This is awesome dude, thank you for posting this. :thumbsup:

May 10, 2017 19:18:30 GMT PATPATPATlol said:

They buffed the asari's butt right? That's all I care about.

riviet
N3

Games: Mass Effect Trilogy, Dragon Age: Origins, Dragon Age 2, Dragon Age Inquistion, Neverwinter Nights, Mass Effect Andromeda
XBL Gamertag: Riviet
Posts: 256 Likes: 517

I made a MP tracker for those that might be interested. Apr 20, 2017 4:56:04 GMT SalMasRac likes this

Quote

Post by riviet on Apr 20, 2017 4:56:04 GMT

Apr 20, 2017 1:07:20 GMT dustin1280 said:

If you happen to be interested in tracking your progress and/or looking at the insane numbers required to max everything (including n7s), I made a tracker that could prove useful.

It's on Google Docs and if you want to use it, just make a copy to do so.

Just wondering, do you plan to update this as new content comes out?

May 10, 2017 19:18:30 GMT PATPATPATlol said:

They buffed the asari's butt right? That's all I care about.

dustin1280
N2

Posts: 70 Likes: 175

I made a MP tracker for those that might be interested. May 1, 2017 14:26:46 GMT SalMasRac and Sparkz like this

Quote

Post by dustin1280 on May 1, 2017 14:26:46 GMT

Oh yeah, going to keep it 100% updated, using that same link...

I personally use the tracker as well so anytime something new comes out it should be added within 48 hours tops (probably day of release)

I put this into the sheet, it is as good as proven at this point:
bsn.boards.net/thread/9603/saving-inherently-programed-probability-pattern

Last Edit: May 1, 2017 19:00:40 GMT by dustin1280

Bzilla024
N3

Atheism is a non-prophet organization. -George Carlin

Games: Mass Effect Trilogy, Dragon Age: Origins, Dragon Age 2, Mass Effect Andromeda
Origin: Bzilla024
Posts: 734 Likes: 2,602

I made a MP tracker for those that might be interested. May 1, 2017 14:46:49 GMT SalMasRac likes this

Quote

Post by Bzilla024 on May 1, 2017 14:46:49 GMT

Thanks, OP. You sure are swell for doing this. :gentleman:

edit: Wow, 1105 estimated Golds to max my manifest.

Last Edit: May 1, 2017 15:01:13 GMT by Bzilla024

gib N2 Posts: 235 Likes: 269 gib inherit Male 6671 0 Aug 4, 2019 12:13:29 GMT 269 gib 235 N2 Mar 30, 2017 21:25:23 GMT March 2017 gib	I made a MP tracker for those that might be interested. May 1, 2017 14:58:04 GMT via mobile SalMasRac likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by gib on May 1, 2017 14:58:04 GMT That's cool, thanks for this.

Sparkz
N2

Games: Mass Effect Trilogy, Dragon Age: Origins, Dragon Age 2, Dragon Age Inquistion, Baldur's Gate, Neverwinter Nights, Jade Empire, Mass Effect Andromeda
Origin: sparkz699
Posts: 94 Likes: 286

I made a MP tracker for those that might be interested. May 2, 2017 17:07:25 GMT SalMasRac, riviet, and 1 more like this

Quote

Post by Sparkz on May 2, 2017 17:07:25 GMT

Thanks! (also for the v1.4 update)

Only 1636 more gold games till max manifest. Should be able to wrap that up by supper. :why:

Last Edit: May 2, 2017 17:37:45 GMT by Sparkz

perseusnz N1 Posts: 6 Likes: 9 perseusnz inherit Male 7996 0 Nov 27, 2017 8:59:58 GMT 9 perseusnz 6 N1 Apr 25, 2017 5:05:51 GMT April 2017 perseusnz	I made a MP tracker for those that might be interested. May 2, 2017 19:59:31 GMT SalMasRac likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by perseusnz on May 2, 2017 19:59:31 GMT Nice work on the tracker, though it is depressing that I probably need $65.1m credits to complete my manifest (or 1,170.91 Gold runs).

SalMasRac N5 Salarian Master Pimp Games: Mass Effect Trilogy, KOTOR Origin: SalMasRac XBL Gamertag: PurpGuy Posts: 2,932 Likes: 16,068 SalMasRac inherit Male 10 0 Aug 30, 2019 23:02:33 GMT 16,068 SalMasRac Salarian Master Pimp 2,932 N5 Aug 1, 2016 4:33:50 GMT August 2016 salmasrac Mass Effect Trilogy, KOTOR SalMasRac PurpGuy	I made a MP tracker for those that might be interested. May 2, 2017 20:17:08 GMT Sparkz, luckystarr, and 1 more like this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by SalMasRac on May 2, 2017 20:17:08 GMT Worst Case Scenario: $69,000,000 Credits and 1255 Gold Extractions Projected Scenario: $55,200,000 Credits and 1004 Gold Extractions Beat that, scurbs
	It holds the line, or else it gets the hose again Banner made by howyummy! Let your inner peace destroy the behavior of others

dustin1280
N2

Posts: 70 Likes: 175

I made a MP tracker for those that might be interested. May 2, 2017 20:33:06 GMT SalMasRac likes this

Quote

Post by dustin1280 on May 2, 2017 20:33:06 GMT

You beat me, though I have put it down for awhile, waiting till they release ANYTHING new patch or otherwise for it.

projected: $58,400,000 credits 1062 gold extractions
worst case: $73,000,000 credits 1328 gold extractions

Last Edit: May 2, 2017 20:33:33 GMT by dustin1280

theghostoftimmy N2 Posts: 63 Likes: 113 theghostoftimmy inherit Male 7193 0 Dec 1, 2017 22:37:17 GMT 113 theghostoftimmy 63 N2 Apr 6, 2017 18:23:35 GMT April 2017 theghostoftimmy	I made a MP tracker for those that might be interested. May 2, 2017 23:42:38 GMT SalMasRac likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by theghostoftimmy on May 2, 2017 23:42:38 GMT Thanks for this. Is it weird I actually feel motivated by my weaksauce numbers?

SalMasRac
N5

Salarian Master Pimp

Games: Mass Effect Trilogy, KOTOR
Origin: SalMasRac
XBL Gamertag: PurpGuy
Posts: 2,932 Likes: 16,068

I made a MP tracker for those that might be interested. May 3, 2017 2:13:39 GMT luckystarr likes this

Quote

Post by SalMasRac on May 3, 2017 2:13:39 GMT

May 2, 2017 23:42:38 GMT theghostoftimmy said:

Thanks for this. Is it weird I actually feel motivated by my weaksauce numbers?

Every time I get a Black Card I am going to OCD update my tracker

It holds the line, or else it gets the hose again

Banner made by howyummy!
Let your inner peace destroy the behavior of others

luckystarr N2 Games: Mass Effect Trilogy, Mass Effect Andromeda Origin: l-LuckyStarr-l Posts: 217 Likes: 251 luckystarr inherit Male 5213 0 Nov 20, 2023 21:40:45 GMT 251 luckystarr 217 N2 Mar 20, 2017 14:48:48 GMT March 2017 luckystarr Mass Effect Trilogy, Mass Effect Andromeda l-LuckyStarr-l	I made a MP tracker for those that might be interested. May 3, 2017 9:39:48 GMT SalMasRac likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by luckystarr on May 3, 2017 9:39:48 GMT Apr 20, 2017 1:07:20 GMT dustin1280 said: 1.4: Updated sheet to reflect 10 expert pack pity timer maximum theoretical cost. What pity timer?

SalMasRac
N5

Salarian Master Pimp

Games: Mass Effect Trilogy, KOTOR
Origin: SalMasRac
XBL Gamertag: PurpGuy
Posts: 2,932 Likes: 16,068

I made a MP tracker for those that might be interested. May 3, 2017 9:42:02 GMT luckystarr and dustin1280 like this

Quote

Post by SalMasRac on May 3, 2017 9:42:02 GMT

May 3, 2017 9:39:48 GMT luckystarr said:

Apr 20, 2017 1:07:20 GMT dustin1280 said:

1.4: Updated sheet to reflect 10 expert pack pity timer maximum theoretical cost.

What pity timer?

Drasca opened 300 Expert Packs and noticed a trend. There's a built-in failsafe where if you open 10 packs in a row without getting a UR, the 10th pack will contain one, and the pity counter resets.

bsn.boards.net/thread/9603/saving-inherently-programed-probability-pattern

It holds the line, or else it gets the hose again

Banner made by howyummy!
Let your inner peace destroy the behavior of others

luckystarr
N2

Games: Mass Effect Trilogy, Mass Effect Andromeda
Origin: l-LuckyStarr-l
Posts: 217 Likes: 251

I made a MP tracker for those that might be interested. May 3, 2017 9:45:34 GMT SalMasRac likes this

Quote

Post by luckystarr on May 3, 2017 9:45:34 GMT

May 3, 2017 9:42:02 GMT SalMasRac said:

Drasca opened 300 Expert Packs and noticed a trend. There's a built-in failsafe where if you open 10 packs in a row without getting a UR, the 10th pack will contain one, and the pity counter resets.

bsn.boards.net/thread/9603/saving-inherently-programed-probability-pattern

Wow. Thanks.
So the best approach is to save up credits and open the packs in batches of 10? Or it doesn't matter if you open them in a row as long as you don't open anything else in between?
Also, does it make expert packs better than premium packs? Or is there a similar mechanism for premium packs? If there is, I'd imagine it to be set to 5.

Last Edit: May 3, 2017 9:49:42 GMT by luckystarr

SalMasRac
N5

Salarian Master Pimp

Games: Mass Effect Trilogy, KOTOR
Origin: SalMasRac
XBL Gamertag: PurpGuy
Posts: 2,932 Likes: 16,068

I made a MP tracker for those that might be interested. May 3, 2017 9:49:20 GMT luckystarr likes this

Quote

Post by SalMasRac on May 3, 2017 9:49:20 GMT

May 3, 2017 9:45:34 GMT luckystarr said:

May 3, 2017 9:42:02 GMT SalMasRac said:

Drasca opened 300 Expert Packs and noticed a trend. There's a built-in failsafe where if you open 10 packs in a row without getting a UR, the 10th pack will contain one, and the pity counter resets.

bsn.boards.net/thread/9603/saving-inherently-programed-probability-pattern

Wow. Thanks.
So the best approach is to save up credits and open the packs in batches of 10? Or it doesn't matter if you open them in a row as long as you don't open anything else in between?

I've just been buying batches of 10, and stopping whenever I do get a UR, regardless of which pack drops it. I dunno if it carries over if you quit or buy a different pack.

Last Edit: May 3, 2017 9:49:30 GMT by SalMasRac

It holds the line, or else it gets the hose again

Banner made by howyummy!
Let your inner peace destroy the behavior of others

JRandall0308 N5 Asker of Questions Games: Mass Effect Trilogy, Mass Effect Andromeda XBL Gamertag: JRandall0308 Posts: 4,276 Likes: 11,041 JRandall0308 inherit Asker of Questions Male 833 0 Aug 27, 2024 17:27:08 GMT 11,041 JRandall0308 4,276 N5 Aug 9, 2016 15:11:11 GMT August 2016 Twitter jrandall0308 Mass Effect Trilogy, Mass Effect Andromeda JRandall0308	I made a MP tracker for those that might be interested. May 3, 2017 14:59:02 GMT SalMasRac likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by JRandall0308 on May 3, 2017 14:59:02 GMT It carries over. I have proof but for some reason XBL decided not to upload my clips from last night so the proof will have to wait.
	Yes, I still play ME3MP. No, I don’t know why.

dustin1280 N2 Posts: 70 Likes: 175 dustin1280 inherit Male 7800 0 Nov 13, 2017 18:03:53 GMT 175 dustin1280 70 N2 Apr 18, 2017 18:36:05 GMT April 2017 dustin1280	I made a MP tracker for those that might be interested. May 9, 2017 14:35:17 GMT SalMasRac likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by dustin1280 on May 9, 2017 14:35:17 GMT You don't necessarily need to open in batches of 10. Just don't buy premiums, only purchase experts...

JRandall0308 N5 Asker of Questions Games: Mass Effect Trilogy, Mass Effect Andromeda XBL Gamertag: JRandall0308 Posts: 4,276 Likes: 11,041 JRandall0308 inherit Asker of Questions Male 833 0 Aug 27, 2024 17:27:08 GMT 11,041 JRandall0308 4,276 N5 Aug 9, 2016 15:11:11 GMT August 2016 Twitter jrandall0308 Mass Effect Trilogy, Mass Effect Andromeda JRandall0308	I made a MP tracker for those that might be interested. May 9, 2017 14:53:59 GMT SalMasRac likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by JRandall0308 on May 9, 2017 14:53:59 GMT Oh yeah I posted the proof in other threads, see: bsn.boards.net/post/649076/thread
	Yes, I still play ME3MP. No, I don’t know why.

unclemonster
N3

Games: Mass Effect Trilogy, Mass Effect Andromeda
PSN: unclemonster
Posts: 652 Likes: 1,029

I made a MP tracker for those that might be interested. May 9, 2017 16:07:00 GMT SalMasRac likes this

Quote

Post by unclemonster on May 9, 2017 16:07:00 GMT

Apr 20, 2017 1:07:20 GMT dustin1280 said:

If you happen to be interested in tracking your progress and/or looking at the insane numbers required to max everything (including n7s), I made a tracker that could prove useful.

It's on Google Docs and if you want to use it, just make a copy to do so.

It does NOT error check for ranks above 10 so don't put ranks above 10

1.0: Original Public Release
1.1: Added remaining items left and estimated cost to acquire each.
1.2: Added estimated missions of each difficulty to complete collection
1.3: Added Ultra Rare Estimates assuming 400k per ultra rare, will change as more data opens up
1.4: Updated sheet to reflect 10 expert pack pity timer maximum theoretical cost.

Thanks! This is awesome!

JRandall0308 N5 Asker of Questions Games: Mass Effect Trilogy, Mass Effect Andromeda XBL Gamertag: JRandall0308 Posts: 4,276 Likes: 11,041 JRandall0308 inherit Asker of Questions Male 833 0 Aug 27, 2024 17:27:08 GMT 11,041 JRandall0308 4,276 N5 Aug 9, 2016 15:11:11 GMT August 2016 Twitter jrandall0308 Mass Effect Trilogy, Mass Effect Andromeda JRandall0308	I made a MP tracker for those that might be interested. May 9, 2017 16:08:40 GMT SalMasRac likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by JRandall0308 on May 9, 2017 16:08:40 GMT Pity RNG confirmed to exist for Premiums also (and for any mix of Experts/Premiums), if you care to update your formulae again....
	Yes, I still play ME3MP. No, I don’t know why.

buffharrier N2 Posts: 85 Likes: 228 buffharrier inherit Male 7812 0 Nov 25, 2017 4:25:31 GMT 228 buffharrier 85 N2 Apr 19, 2017 3:36:40 GMT April 2017 buffharrier	I made a MP tracker for those that might be interested. May 9, 2017 16:46:55 GMT SalMasRac likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by buffharrier on May 9, 2017 16:46:55 GMT If it makes you guys feel any better as they add DLC and the item pools expand it'll require even more time to unlock everything

Announcements

Recent Threads

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

Post by dustin1280 on Apr 20, 2017 1:07:20 GMT

Post by s0ulbearer on Apr 20, 2017 1:09:28 GMT

Post by Pearl on Apr 20, 2017 1:15:11 GMT

Post by dustin1280 on Apr 20, 2017 1:55:44 GMT

Post by riviet on Apr 20, 2017 2:22:40 GMT

Post by riviet on Apr 20, 2017 4:56:04 GMT

Post by dustin1280 on May 1, 2017 14:26:46 GMT

Post by Bzilla024 on May 1, 2017 14:46:49 GMT

Post by gib on May 1, 2017 14:58:04 GMT

Post by Sparkz on May 2, 2017 17:07:25 GMT

Post by perseusnz on May 2, 2017 19:59:31 GMT

Post by SalMasRac on May 2, 2017 20:17:08 GMT

Post by dustin1280 on May 2, 2017 20:33:06 GMT

Post by theghostoftimmy on May 2, 2017 23:42:38 GMT

Post by SalMasRac on May 3, 2017 2:13:39 GMT

Post by luckystarr on May 3, 2017 9:39:48 GMT

Post by SalMasRac on May 3, 2017 9:42:02 GMT

Post by luckystarr on May 3, 2017 9:45:34 GMT

Post by SalMasRac on May 3, 2017 9:49:20 GMT

Post by JRandall0308 on May 3, 2017 14:59:02 GMT

Post by dustin1280 on May 9, 2017 14:35:17 GMT

Post by JRandall0308 on May 9, 2017 14:53:59 GMT

Post by unclemonster on May 9, 2017 16:07:00 GMT

Post by JRandall0308 on May 9, 2017 16:08:40 GMT

Post by buffharrier on May 9, 2017 16:46:55 GMT