The Lockbox Data Collection Project

[kkhendy]

Amazing idea, submitted and will continue to submit.

[Captain Rimjaw]

posted my latest

[DeMoted]

That sucks I just bought like 20 T4 boxes and didn't see this till today.

[Victim Eyes]

so you're suggesting it's better off to purchase tier 3 in the long run? I've had a terrible string of luck with the past four or five tier 4 that I've purchased. No orange and maybe one or two purples total...

[Yokai]

According to the -validated- numbers earlier this morning, T4 pulled ahead of the pack for oranges, and T3 sits at the front of the pack for purples. See my sig block for a chart as of 9am CST this morning.

[Rat2man]

So just to clarify... for data to be counted as validated can I still do multiple boxes per entry? (Ie 6 items for 2 T3, or 8 items for 4 T2) or do I need to be doing each box seperate?

[Avenger]

I'm hard at it already...

CHANGELOG
Moved Validated Results to it's own tab, where they will grow their own charts, based on the Validated data.

Thanks for your input on this.
Not wanting to jump on errors as you said the page is still work in progress, but a couple of the calculated figures seem odd.

"Calculated total items rec'd per box"
I understand what the formula is doing - divide the number of validated items found by the number of submissions - yet somehow it is reporting back 3.36 items for both Tier 2 and Tier 3 boxes, which should only be able to drop a maximum of 2 or 3 items respectively.

I think that "Number of Submissions" is just looking at the raw data - not the validated data. But since we know the validated total MUST be lower than the submitted total (because there are bogus entries) then that would make the "Calculated total items rec'd per box" stat increase which puts it further from the in game text stating 2 for Tier 2, 3 for Tier 3, 4 for Tier 4.

This would suggest that the validated data is letting more data through than it should. Just looking at Tier 2 Green - it gives what should be an impossible figure - 768 Green drops from 298 submissions. If Tier 2 can only create 2 items there should be a max of 596 across all colours, while the validation formula should be excluding entries that don't total 2 (if I've read the array formula correctly).

[Avenger]

So just to clarify... for data to be counted as validated can I still do multiple boxes per entry? (Ie 6 items for 2 T3, or 8 items for 4 T2) or do I need to be doing each box seperate?

Do each box seperately. The validation as it stands will only count entries that have a valid number of items for 1 box of the selected Tier. So if you input data for 4 Tier 2 boxes as one entry it will show in the raw data, but will not be validated as it is impossible for 1 Tier 2 box to generate 8 items.

[Mogren]

Do each box seperately. The validation as it stands will only count entries that have a valid number of items for 1 box of the selected Tier. So if you input data for 4 Tier 2 boxes as one entry it will show in the raw data, but will not be validated as it is impossible for 1 Tier 2 box to generate 8 items.

Noupoi's post on the previous page seems to say that the validated results allow entering multiple lock boxes at once, as long as the number is a multiple of the type of box being entered. Unless I'm reading that wrong. That would also explain your previous post about number of submissions vs number of items.

[Rat2man]

Do each box seperately. The validation as it stands will only count entries that have a valid number of items for 1 box of the selected Tier. So if you input data for 4 Tier 2 boxes as one entry it will show in the raw data, but will not be validated as it is impossible for 1 Tier 2 box to generate 8 items.

Hehe, between you and Mogr, thats why Im asking, guess Ill follow the 1 box rule for the time being...

*side note* Fing hate *******es that add false data b/c its somehow lolz funny

Edit: and are we tracking snergy mod caches in another post by chance?