Hi! I'm back with an updated spreadsheet for Revelation MogTomes. This is basically the same as the prior versions, but I put the MGP rewards on their own tab and added another one for the various card packs.
Check off what ones you have/want in each pack and the sheet will calculate roughly how many packs you'd need to buy to have a 50% chance of hitting all cards. (this isn't exactly accurate because something something approximate independent results ... mutually exclusive ... blah blah sparse-event reasoning ..... joint distribution .. multinomial distribution ) The "Binomial Odds" section is the odds of getting a specific card within a certain number of packs. While the left hand side calculations takes into account needing multiple cards within one pack.
TLDR for gamba packs: Third Tab, Check off cards you want, and the bottom of the Second Tab will show you how many packs and how much MGP you need to have a ~50% chance of hitting those draws.
===
https://docs.google.com/spreadsheets...8DooubjO18ZJA/
Click the big [Copy Button] to make your own version that you can edit.
As always, feel free to share on discord/reddit/bsky/twitter/etc and if there's an error somewhere then let me know somehow.
Previous thread: https://forum.square-enix.com/ffxiv/...-Sheet-Tracker
Continue reading...
Check off what ones you have/want in each pack and the sheet will calculate roughly how many packs you'd need to buy to have a 50% chance of hitting all cards. (this isn't exactly accurate because something something approximate independent results ... mutually exclusive ... blah blah sparse-event reasoning ..... joint distribution .. multinomial distribution ) The "Binomial Odds" section is the odds of getting a specific card within a certain number of packs. While the left hand side calculations takes into account needing multiple cards within one pack.
TLDR for gamba packs: Third Tab, Check off cards you want, and the bottom of the Second Tab will show you how many packs and how much MGP you need to have a ~50% chance of hitting those draws.
===
https://docs.google.com/spreadsheets...8DooubjO18ZJA/
Click the big [Copy Button] to make your own version that you can edit.
As always, feel free to share on discord/reddit/bsky/twitter/etc and if there's an error somewhere then let me know somehow.
Previous thread: https://forum.square-enix.com/ffxiv/...-Sheet-Tracker
Continue reading...