Slicing data in SW:TOR

So I got nerdy and decided to do more detailed slicing analysis. 

 

I was inspired by the other popular spreadsheet floating around

https://docs.google.com/spreadsheet/ccc?key=0ArCSGLnwZLADdGxYdlhEejBFclBjR3l1N29OaW1kYUE&hl=en_US#gid=0

 

I wanted to improve the spreadsheet in 3 areas:

1. The analysis was done by credits per mission, rather than breaking out credit box data.  This misses a huge opportunity and loses a lot of information
2. The sampling data is unreliable.  The numbers felt way off, and my suspicion was that the results weren’t being recorded accurately, which is going to happen when it’s done by hand but publicly editable. 
3. The recording of schematic drops is not included, but is vitally  important when calculating your rate of reward.

 

Anyways, here is the results of my data.  Breaking the data down this way makes it way more accurate.  Results from different lockboxes on different missions can be aggregated to get more accurate results.

 

My results

https://docs.google.com/spreadsheet/ccc?key=0Arma03Fq861hdEVidlRpcWtDQXJXdFJ6X0dmX2kxTHc#gid=0 

Conclusions:

• Every mission is divided into two possible missions results.  Result A and Result B
• Every mission has the probability of Result A and Result B set differently.

 

Tier		Result A	Result B
5	Off the Grid	42-48 White	42-48 Green + Mission
5	His Home is His Castle	42-48 White	42-48 Green + Mission
5	The Fly on the Wall	42-48 Green	42-48 Blue + Mission
5	Taking Back Control	42-48 Green	42-48 Blue + Mission
5	Delivery Failure	42-48 White	42-48 White + Mission
6	Data Race	50 White	50 Green + Mission
6	Plug the Leak	50 White	50 White + Mission

 

• From a design standpoint, this is interesting in that they are making Result B the “jackpot” result, and they accentuate the impact of the result by removing the results that are only slightly good.  For example, Off the Grid can never yield a White + Mission, nor can it give a Green without a mission.  You either get a “normal” result (white), or a “jackpot” result (green + Mission)
• The probabily of each box within each category appears to be weighted flat.  For example, if you drop a 42-48 lockbox, it seems to be an even distribution
• 42 – 25%
• 44 – 25%
• 46 – 25%
• 48 – 25%