Moogle Treasure Trove The Hunt for Revelation Google Sheet Tracker

[Lazzi]

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

[Shinku_Tachi]

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

Thank you so much! ❤️

[Carin-Eri]

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

Brilliant! Thank you for this!