Alright, the spreadsheet is finally out of WIP condition - everything is working and now I'm bored out my tits so I'm going to write/narrate a quick walk through on how it works. I'd like to start off by asking if you notice anything that's broken, any mistakes, or anything plain fucking wrong because I'm an idiot either post here, PM, or add my battletag I've included and spam me. I'll be happy to help and accommodate any changes that are for the improvement of the spreadsheet as a whole. Any personal modifications you make for something I've not deemed worth cluttering the spreadsheet with are totally your problem, and it's completely down to whether I'm in a good mood or not if I help you with it
Now to get the spreadsheet actually operational for yourself, you will need to do this first;
Making a copy is an obligatory security feature so that you assholes out there can't fuck this up for others, I apologize for the 20 seconds or so of your life this wastes but you can blame people for it. You cannot download for excel, it makes gratuitous use of third party and custom google scripts made specifically for this sheet!
Once you have your own copy of the spreadsheet you'll notice there's more than one page to it, these are those pages;
Below you'll find a textual summary of what each sheet actually is and what it does and maybe a youtube video to accompany it if my shit internet decides to upload it some time this decade.
This is the engine of the spreadsheet, everything you input is used to generate the bare basic statistics the spreadsheet needs for calculations. I spent ages trying to create a script to import your character from the armory, so you don't have to go through the boring bullshit of typing all your stats in like you're some kind of animal. (You're welcome).
For people out there who don't get a lot from numbers past a>b, this sheet is here to help you visualize how haste interacts with Renewing Mist and how it can actually be detrimental to be at certain haste values.
A bunch of statistics about your spells, including options for AoE targets, Uplift targets, and emulation of the T15 2p set bonus.
Mastery: Gift of the Serpent
A sheet dedicated to valuing our mastery, you can input your "success rate" here which is basically a scale of 0 to 100 on how much drool your peers get on their keyboards while trying to pick up your orbs in a raid. I've included an inverse relationship with the new mastery proc in 5.2 when a ball isn't picked up, basically the more orbs your raid picks up the less will explode on them.
Suggestions for stat weighting, including a spell table so you can see a more detailed analysis instead of an average.
Measures your sick dps!!!!
Ranking of trinkets based on their MP5. Pretty straightforward.
Click header graphic for the spreadsheet!