This thread's really blown up- far bigger than I expected when starting it, but great to see... And the discussion has gotten much deeper than my understanding of statistics goes. :S
So from reading the responses, are these the changes you guys want to be made?
- Use validated frequency as basis for new calculations
- Add estimate for margin of error. (with forumla 1.96*sqrt(p*(1-p)/Number of Items for Tier) ?)
- Change 'Drop rate / Cost per try' to 'Expected drops / 100 keycodes'
Again, I wouldn't mind giving you guys access to modify the spreadsheet if you want to help, though I'll admit I don't really understand sure what the disagreement with calculations is about.
I opted to have the option to input more than 4 items of a type in one go as a compromise between saving time for actual users submitting data for multiple lockboxes, and preventing trolls from entering large amounts of false data easily. I'm open to suggestions for ways to do this better.