A
sheet for testing strategies. It's currently sorted in pure special-order. To use it for a different order:
1) Make a copy for yourself
2) Copy and paste your shot choice from the bottom over where the resource shot is in the top row
3) Adjust the 'Sort Priority' column to whatever formula or numbering you want (say 1st, 2nd, 3rd choice etc) to sort by and then select the range of the players table and sort range by column A from the data menu (either direction).
4) The Occurence column will be recalculated depending how it's sorted and your totals at the bottom will reflect your own priority list now. 7k drinks line is based on an approximation of how many you'll get for free playing the event completely. 2k diamonds line is based on buying 1200 drinks with the diamonds.
If you want to tweak it :
It uses the "Quality" Column to calculate the occurence chances, that one cannot be changed for it to work right. If you feel the distances are wrong (expressed as % of the way to a goal), they should be able to be adjusted in this version without breaking things (in a previous version i used the distance instead of the quality column for calculating occurences - i think i fixed that everywhere).
It's simple to add extra columns that it's calculating for you if you're interested in other chest contents. Just add in the chest percentages for each player/shot and copy/paste the 4 calculation cells at the bottom (Average Pass through Expected Value of 2k diamonds) - they are anchored appropriately to copy correctly.
Things this does not account for :
Near the time when you take your shot you may have to pick a shooter further down the list for the last bit of progress.