Runs per any Remaining Grailer spreadsheet

[Luhkoh]

Hey all, I made this sheet a while back and cleaned it up so it looked acceptable. Thought this is useful for seeing how many runs you should expect with whatever grailers you have remaining. Also note the inputs that are in there are NOT for my own grail (I'm at like -41 ).

LINK: D2 Grail Remaining by Luhkoh

 

[Fabian]

Looks cool, nicely done!

Cell H510 should be "chance to find one or more" rather than just "one", just a quick thing I noticed when looking at it.

Calculating the probability of exactly one item found in a setup like this isn't super trivial, but here's a link with some discussion about it if you definitely want to include that number: https://stats.stackexchange.com/questions/9510/probability-distribution-for-different-probabilities

 

[Luhkoh]

@Fabian ah yes great point, thanks! I was just being sloppy with the naming. Changed to "at least one remaining grailer".

That link is some cool stuff for sure, thanks for posting it.

 

[T72on1]

I think that at a certain point in your grail, you don't want to know how many runs you'll still need to find those few remaining items .