With Wanda coming and many hoards breaking soon, I thought I’d share something I’ve been tinkering with. I made the first basic version a while ago to help judge if I had enough pulls to break for BRB, and enjoyed the challenge of making it robust enough to handle huge amounts of pulls and other different factors. I think most people will find it pretty straight forward, but I’ll detail some of the features below.
Hopefully there are a few people out there who will find this useful or interesting!
Here is the link: mpq lt odds - Google Sheets
You have to make a copy to be able to use it.
The top left box is how many pulls you want to take. If you want to see the odds for taking 200 pulls, put in 200. If you’re not sure how many pulls you should be trying, you can fill out the target covers and characters (more on these below) and the sheet will give you the expected number of pulls as a good place to start. I thought a good limit would be 5000 which is double the amount currently used as a target to 550 any given set of three. Depending on what type of device you are using, be careful playing around with bigger numbers. It takes a bit of processing power doing these big calculations for thousands of possibilities at a time.
The box below that is what you want odds for. This was primarily created for Latest 5* and Special Legendary stores, but if you want a good laugh at the dilution in the game you can also calculate odds for getting classic 5* or getting 4* out of LTs. If you’re interested in seeing 4* odds out of other tokens, please see: Google Image Result
Moving up and right, this box is the number of target covers you want from the pulls you are going to take.
The box below that is how many characters you are targeting in the current set.
The box next to that is how many unwanted colors. So for example, if you wanted to pull for Thor covers but you already have his green at 5, you can put in 1 unwanted color and it will show odds for the remaining 2 colors only.
The two red shaded boxes are the counts for number of 5* in classics and number of 4*. This has no affect on latest/special store odds but will affect if you are going to use the classic 5* or 4* calculator. I think these numbers are accurate as of today but make sure you double check the current counts if you going to use those modes.
And then underneath that is a pulls calculator. Putting in your hoarded tokens and CP will spit out your total number of pulls. If the sheet is set to latest/special, it will total your LTs and 25 CP/pull. If you are looking at a special store, remember to take out your LTs and use CP only. If the sheet is set to classic mode, it will automatically ignore LTs and only calculate at 20 CP/pull.
So for example, if you had no covers already of Kitty and Okoye, and there was a store with Kitty, Okoye, and Wasp, and you wanted to see what it would take to get Kitty and Okoye champed, you would put 26 covers (13 for each) and 2 target characters. And you can see what it would do.
If you wanted to see how many pulls you would need to champ all three Latests but you already have one at 5/1/2 build, you would put 31 covers, 3 target characters, and 1 unwanted color.
If you wanted to see how many classic pulls it would take to get your 5/0/5 Okoye champed, set to classic, 3 covers, 1 target character, 2 unwanted colors. And then hold on to something… (seriously, never EVER try to champ a 5* using classics)
Remember this is just odds and probabilities. There’s always a chance you end up in the bottom 0.15%.
If you have any issues, just post and I can try to help.