Quote:
Originally Posted by ronhatch
I included that in my calculations.
Whether or not I did it correctly is certainly open to debate. Screenshot of my spreadsheet below... "Minimum" is the instant sell price and "Ratio" is the stated odds ratio of getting that type of card. "3,000 packs" is the expected number of cards of that type you're expected to average based on those odds. Note that the bronze cards average exactly two per pack, because of the guaranteed card plus a one-out-of-five chance with five random cards in the pack. Iron cards are simply the total number of cards (18,000) minus the expected cards for other tiers. The "Value" column is the expected number of cards multiplied by that minimum sale price and the average divides the total sales by the 3,000 packs that went into the calculations.
|
I made something very similar to your sheet and got the same #s. I also made an "expected" sheet but the expected values are obviously very much up for debate. Mine are higher than I've seen some people post, but you can enter whatever you like.
EDIT: Cell K1 is supposed to be a dropdown data validated to the Refs sheet, but it doesn't seem to show/work unless you're an editor/owner. Column F shows the total values for those packs, but I only entered the #s. I don't want to open up the access as someone might change something important, but you can copy the sheet and enter your own #s.
I'm also not sure of the more expensive packs' latest costs and, I'm not sure, but I think a historical pack guarantees a gold, correct?
One thing I might add to the expected sheet in time are expected values for live vs non-live as that might make a big difference and it'd allow for an expected value of a historical pack.
Interestingly enough, it seems that Bronze and Gold packs are close to the same value now that Gold packs have been decreased to 3000 PP. They're really the only types of packs I would consider. For example, to bring it more in line with the aforementioned 2, Silver should probably be priced at 1200 instead of its 2000. Perfect packs seem like a terrible deal, but maybe my expected value for them is way low?