Communty Project: For all your Lootboxenendeavors, please take your time to add them to this google sheets
Editwhateverasmuch: Everything works again. Thank you for your patience!
As the title suggests I want to make a whole list of different lootboxes being unboxed. I do not differentiate between new year, magical and etc.
If you wish to participate I would love to see that, here is the link to the google Form!
The results will be soon aviable on this sheet page.
Edit: I'll try to use a different form now made by u/SquawksExistentially all credits go to him for his excellent work on the form and table.
The old table is here.
This is an opensource project so I really do count on you not putting in fake date. I would really appreciate it and the other people which want to see what they can get.
Why am I doing this? I want to make later during the day / week a comprehensive list of the boxes and calculate the probability how possible it is to get the boxes. To that I know people like u/The13Disciple which would love to see that stuff too!
How can you help? Just put in your Name beside the others and start to put in what you got. The rest should all be calculated by the sheet itself :)
As an example ( thansk for showmustgoon for pointing it out in the suggestions tab) If you buy 25 boxes and you got 5 times 500 gold in those boxes, then you write 5 in the question about how many times you got 500 gold.
Thank you so much for your collaboration and help!
Edit: This is my first time using google sheets like this, so if there is any suggestions and tips I can use, I am more then happy to use them and know em!
Edit2: Now everybody with the link can change stuff. Again please refrain to change others stuff and be truthful as this can help others! And added the changing link to the sheets hyperlink
Edit 3: So far we got 319 Boxes unboxed which are legit. Around 150 I put into the table through pictures and videos from you guys and the other 150 are from u/ThatGreatAtuin Thank you alot for that! 319 Boxes are great so far as a beginning, I am going to add to that safe sheet 75 from myself! So we would have almost 400 Boxes which are a good starting point!
Edit 4: I now made a google form to make it a bit more convenient and to stop people trolling with others data! The sheet will stay and I will change it up so it shows the last few datas all added up!
Edit 5: Short little Explanation on how to do it.
Posted Dec 13, 2018, 8:58 AM UTC · edited
I think it being public, means some troll may definitely vandalise this. Can you maybe set up a google form, so that even if someone tries to troll, they cannot affect others data.
This definitely needs to happen, and you could then hide the raw data sheet and stick a summary sheet on the front visible to everyone. Also I would recommend a valid Yes/No flag so you can easily remove malicious submissions from the data set.
I am really sorry, but I don't kno whow to do that :/
Edit: If it is possible to say that every new person going to the spreadsheet he can only get one collumn to vandalize, if that is possible that would be great, if not, I have no clue how to do that :C
Hi mate, I'm drafting up a new Sheet/Form right now. I'll link it here when I'm done and possibly create a new thread as well
Sure, if you got an solution to that so every new user has a seperate column they can only write in to I am happy.
What I am doing so far is I am just protecting data which I put in and is finished. This is at the momen the only way I can do it.