TOPIC: Google Doc for 2016-2017 Season Treasure Pulls

jedibcg wrote: I added two new calculation columns percent of MB and percent of other. I also highlighted the highest of each of these categories by percent (so you know who to ask to pull for you) in green. And the lowest of each category red. I did the second lowest in orange, because 0% is just because they didn't have many pulls. I would recommend pulling after the orange folks.

Thanks for not putting me in Orange, but it does feel like Lodestone and I are in another zip code in terms of low Other percentages with greater than 100 pulls. I'm hoping the overall average percentages hold for GHC and I get a chance to redeem myself. My friend will be there and he had 3 Others out of 20 pulls this year, so I may try 10 pulls and if things look bad have him do the rest.

jedibcg wrote: I added two new calculation columns percent of MB and percent of other. I also highlighted the highest of each of these categories by percent (so you know who to ask to pull for you) in green. And the lowest of each category red. I did the second lowest in orange, because 0% is just because they didn't have many pulls. I would recommend pulling after the orange folks.

Woohoo! rockin the Other percentage with my 8 pulls.

MetaphoricDragon wrote:

jedibcg wrote: I added two new calculation columns percent of MB and percent of other. I also highlighted the highest of each of these categories by percent (so you know who to ask to pull for you) in green. And the lowest of each category red. I did the second lowest in orange, because 0% is just because they didn't have many pulls. I would recommend pulling after the orange folks.

Woohoo! rockin the Other percentage with my 8 pulls.

Actually you got a red 0% and a green....lol.

Added my pulls but don't have rare/uncommon count as they were mixed in with our 10packs.

FiannaTiger wrote: Added my pulls but don't have rare/uncommon count as they were mixed in with our 10packs.

All good I will just do a 50/50 with your remaining tokens. Had to do that with a few. Maybe next year now that we know what we are going to track we all (myself included) will track it better.

Yeah I will track Rare vs UC next time too.

Looks like I'm the outlier for monster bits this year, that is interesting.

I'll have to add my sad draws.

FiannaTiger wrote: Added my pulls but don't have rare/uncommon count as they were mixed in with our 10packs.

Yeah, that's a problem I had in years past. I actually brought two bags for gear that I got this year. No chance of mixing them up this time...

I really tracked things this year even which Trade category the pulls would ultimately fall into. But I didn't track my others, or at least what they were. I had a number count but didn't have a clue what they were. I actually started putting them away before the document, which is why I had to edit my counts when I realize I actually pulled something but had already put it away. I still think we all did better this year than we have in the past, so it is progress. We hopefully learn something and we move on.

Also I actually did not open a single starter pack until I got home (this was around 50 packs).

Given what is in the sheet, it looks like the secondary market value of a treasure pull was around $5.50, given the following values on individual tokens:

Rare 0.5
Uncommon 0.25
Monster Bits 8
25,000 Bar 437.5
10,000 Bar 175
5,000 Bar 87.5
2,500 Bar 43
1,000 Bar 17.5
500 Bar 8.75
Legendary (Orange) 1100
Relic (5 point star) 250
Tooth of Cavadar 150
Ultra Rare 75
Golden Fleece 80
Exalted (4 point) 45
Enhanced (3 point) 5
Trade Item 8

Matthew Hayward wrote: Given what is in the sheet, it looks like the secondary market value of a treasure pull was around $5.50, given the following values on individual tokens:

Rare 0.5
Uncommon 0.25
Monster Bits 8
25,000 Bar 437.5
10,000 Bar 175
5,000 Bar 87.5
2,500 Bar 43
1,000 Bar 17.5
500 Bar 8.75
Legendary (Orange) 1100
Relic (5 point star) 250
Tooth of Cavadar 150
Ultra Rare 75
Golden Fleece 80
Exalted (4 point) 45
Enhanced (3 point) 5
Trade Item 8

I have a Second tooth for $125 if anyone is buying at $150. I also don't know about 250 for Relics. Even if there were equal numbers of plates and mails (which I find suspect) there were also Earcuffs and maybe RoH's. Still it is interesting to see.

Even if we think it at $5. If you could sell all your pulls at $5 on a full run with CoA's you are (as Brad feared) making more thank you are putting in so to speak, that doesn't include, completion tokens and starter bags. Just saying.

jedibcg wrote:

Matthew Hayward wrote: Given what is in the sheet, it looks like the secondary market value of a treasure pull was around $5.50, given the following values on individual tokens:

Rare 0.5
Uncommon 0.25
Monster Bits 8
25,000 Bar 437.5
10,000 Bar 175
5,000 Bar 87.5
2,500 Bar 43
1,000 Bar 17.5
500 Bar 8.75
Legendary (Orange) 1100
Relic (5 point star) 250
Tooth of Cavadar 150
Ultra Rare 75
Golden Fleece 80
Exalted (4 point) 45
Enhanced (3 point) 5
Trade Item 8

I have a Second tooth for $125 if anyone is buying at $150. I also don't know about 250 for Relics. Even if there were equal numbers of plates and mails (which I find suspect) there were also Earcuffs and maybe RoH's. Still it is interesting to see.

Even if we think it at $5. If you could sell all your pulls at $5 on a full run with CoA's you are (as Brad feared) making more thank you are putting in so to speak, that doesn't include, completion tokens and starter bags. Just saying.

Well - there is also downside risk - according to the prices above my pulls were worth about 3.50, and I had nearly 400. Also I got a lower value relic.

I think you'd need to be doing thousands of pulls before the luck can be expected to wash out.

The variance is quite high.