Click to view our Accessibility Statement or contact us with accessibility-related questions
ShoMinamimoto
7
Jul 9, 2014
Done! https://docs.google.com/spreadsheets/d/1Lu6kQ5kEOYiPFvHb_BLFsv5YxX2IrBnZ1sPFGa2nStM/edit?usp=sharing
Of course, the cards that are foil will skew certain prices up by a lot (I only did nonfoil prices because the foils are hard to see). I did an eyeball's glance to see the median on the first page, and mostly got all of the sets correct. Looks like a decent deal in every pack to me, and I love that you guys are giving a chance for international buyers to get in on MTG drops.
People have a negative view of resealed packs and it's understandable, but this is really the best way to do them. You get to see every pack you will have a chance to receive, not just some mystical promise to "Reach your hand in the unknown box, there's a foil Jace somewhere in there!!!". I think the Massdrop guys are trying to take as open an approach as possible with this, you guys should give them a chance!
mystery
3
Jul 9, 2014
ShoMinamimoto@ShoMinamimoto You didn't list all the cards, but I've put the name of the foreign cards in my previous msg, so now you can finish it :-)
Also, it would have been nice to put additional notes on the right side with a simple formula that would be a sum of the prices of the 6 cards per packs. So we can see directly the value of each pack.
Then, in the end, another simple formula (the sum of the prices of the 99 packs divided per 99) to calculate the average price of each pack.
I would have done it myself but I only can look at the gdoc, not modify it. Just some thoughts.
mitsu400
11
Jul 9, 2014
mysteryhttps://docs.google.com/spreadsheets/d/16HBj3VYKdy7f_b1hBiO3ZjPmSwt4TIS_uXlqSRsJy5g/edit?usp=sharing
This is a copy of his above. It has the formula on the side as well as an average below the column. It's looking pretty good actually.
EDIT: Added another sheet for the make money/lose money junk per pack.
EDIT2: Trash for Treasure was added.
mystery
3
Jul 9, 2014
mitsu400Nice job @mitsu400 ! You just have forget: Set 42 - Clockwork Dragon
So @SquallTiofae was almost right, It's not 20% but exactly 24.24% who would make their money back.
mitsu400
11
Jul 9, 2014
mysteryAlright, fixed that last one! Haha
ShoMinamimotoThanks @ShoMinamimoto and for the contributions from the other people who cleaned up your work. (Join the drop for 2 packs, set the payment mode to Bitcoin and I'll discount it to zero.)
Average value is $37.16 assuming no foils, and ignoring some of the promo-values since TCGplayer doesn't have their page/values up yet. Realistically it's a little higher when you factor those things in.
So it's clear that our listing price at $49.99 was too high. I'm happy with the $38.99 and we'll leave it there. Hopefully that pricing structure with these cards is a compelling (fair) deal and people will be interested in them. Thanks to the community for helping us out with this and making this work.
jester563
7
Jul 9, 2014
ShoMinamimotogood goin! I wanted to do it but you beat me. how long did it take you? meh. school's more important i suppose. let us know what you get eventually!
tsHunter
1
Jul 9, 2014
ShoMinamimotoI can't edit the doc, but it'd be useful and easy to set up a column to sum each of the packs :)
Nvm seen it was already done oops