1.08, 1.09, 1.10 Premium / Arsenal / Reserves Pack research

I'm looking through your album to check on the whether it was character or weapon unlocks, and the images aren't matching up to the spreadsheet data. Do you have a video of the 200+ packs?

Bottom line it's only probability and statistics. I'm wondering whether analyzing total drop rate until maxing out a manifest wouldn't reveal the same average for all of us.
With the single events of "being unlucky" and "being lucky" only within the variation of same process (XmR) chart.

I feel with you but in the end it will turn out equally well for all of us.

I can help but it will have to wait until tomorrow.

I stole lennybusker 's sheet idea. Hope it helps.

Link

I would suggest to make seperate colums for the number of UR and what you actually got. Then you have a colum which you can slap a formula over.
Else you could make a formula that says "If there is any input present add+1, then form sum", but I have no Idea how to do that in google spreadsheets.

Just asking for the sake of better understanding, why does it matter to you if you note in your data which specific UR you got?

Also for sake of having a simplified and easy to use spreadsheet, wouldnt it be the the easiest to work with 3 colums, at least for that part. One colum for the exact kind of UR, one where you put the number in if it is a weapon and one if it is a character. In the end you can use formulas to add those every way you want.

We are thinking roughly in the same direction, but I dont understand yet how it creates a parsing nightmare if you have seperate colums for each kind of UR. You put the number in as usual.

I like how organized yours is and that it allows the collection of further and deeper data.

This is how I am currently doing it, aka how the one linked in my first post looks like after I corrected my brain fart.



There are things I maybe want to add, like formulas for drop rates an such. For now it is just for keeping track of my purchases. I made one sheet of those for every kind of Premium pack there is now and I can add more if there will be more kinds of packs in the future.

Just something that crosses my mind while I type this, maybe we can work together to come up with a sheet where everybody interested can take a copy and fill it with his/her own data?

This sounds VERY familiar...

After 2 million dry(pity pull),

last night I pulled 4 URs using reserve pack and 700000 credits.

...now I expect another 2 - 3 pity pulls again.. lol