TOPIC: 2024 Treasure Pull Tracking Sheet

bpsymington wrote: We are supposed to get a shipping notification when they ship our treasure, yes? I'm in LA, and have sometimes received my treasure draws the Friday after the VTD run, but it's Saturday and no notice.

Did you get anything yet? I've not yet had shipping notification either.

Looks like treasure is starting to arrive! Thanks again to everyone who filled out the sheet last month; we had great participation. Remember, it doesn't matter how much treasure you got; every data point helps!

For those who need the sheet again:
docs.google.com/spreadsheets/d/1k9QxmpnSR57RtdrhXnL2hiNd43Rh1N7MrhO2B8olsZ4/edit#gid=1327998478

Can folks post which trade goods they receive instead of bonus starter packs so we can get an idea on their distribution.

edwin wrote: Can folks post which trade goods they receive instead of bonus starter packs so we can get an idea on their distribution.

Do you mean the separation of TG from multi ticket holders and the TG inside the treasure rolls ?

Let me think on that one a bit. I like the idea, but I'm a bit worried that it will lead to confusion if people mix in their bonus TGs with their treasure pulls.

I suppose that cuts both ways though as people may start entering those into the sheet. I'm open to ideas on the best solve.

Maybe a separate thread and separate Google sheet?

Seems like fewer people will care about this overall. But still useful for those that care, if after a couple events it looks like a fairly equal distribution we can stop keeping track.

Mine from V20 was 3 Ink, 1 Parchment, 3 Munitions, and 1 Hide

If someone else wants to administer it, be my guest. I strongly suspect that it will be an equal distribution.

That's my feeling as well, but if someone did take it on, I would gladly enter my data points.

I don’t have access to excel but maybe it’s super simple, mark 3/4 rows “‘Extra TG 1, Extra TG 2 etc. we already know the reasoning as to why and how many come per multi ticket households so we don’t need a % based on quantity based drop rate. Just one where we can enter how many of each good type, and one more for the formula to go where it takes the numbers from said columns and breaks it into a % base for the pull rate of each good type. Not quantity. Thoughts ?

It's probably best to just have something like the current sheet, but with all the Trade 1s across the top. Sum in the next row and a % under that.

I think the summary of % drop rate is useful just to see if numbers are relatively aligned.

I'm not sure if you all need to do this per event. I'm hoping the mix is a fire and forget kinda thing.

I can work on something. With a smaller pool, I'm not sure we need a separate tab for each event. I can just add a column for event so that it can be filtered. If we run any database forumulas off of it, I might need help with that. Should have something available later today that can always be modified.

My mix for V20 was 5 enchanter's munition, 5 alchemist parchment, 2 alchemist ink, 2 dwarven steel, 2 minotaur hide

It does feel like they aren't including mystic silk, darkwood plank or philosopher's stone, which is nice.

If it’s a less general audience a column for event makes sense. Can run a pivot off that.