I used your sheet to create weighted averages to determine the best weapons in Destiny. Time to kill was weighted heavily as the best stat, but users can take the sheet and weight the stats however they like. It looks pretty balanced and correct to me.
Edit: Updated 4/25 with new sorted tables. I have also moved the chaperone to the shotguns tab. Tables have been sorted according to statistically best stats when TTK is weighted heavily.
English
-
-
Nicely done... tips hat
-
Thank you!
-
Edited by dayovin: 4/23/2016 4:50:37 AMIs time-to-kill the same as damage over time? That seems like a better stat.
-
No, it's the time to kill a guardian at 200hp in the crucible. Damage over time is a better stay for PvE, TtK is better for PvP.
-
[url]https://drive.google.com/open?id=0B9gBayfId54mc0lsRDVoUUk5clE[/url] I have adjusted your spreadsheet so the guns are now in descending order by "statistical best"
-
cannot get this to open from the link, just shows blank spreadsheet.
-
Tried the link in my phone. It worked however I'll look into providing a different link. It'll be up by tomorrow evening.
-
excellent, managed to get it to DL, thank you :) Will be grinding for Soulstealer's Claw
-
Very awesome, thank you!
-
This is spreadsheet-ception
-
-
Great work
-
nice.
-
These look pretty close to what I thought of the weapons. Although for handcannons I like the devil you know archetype better than the word of crota seeing as you only need that one crit shot. Two crit shots with a faster pace of fire is a little more tricky to pull off consistently
-
Neat. How can I change the weights (I think you wieghted range way too low)?
-
Download the spreadsheet and change the values that are listed above the stat field descriptions. You will see them listed as Relative Calculation Weight, 1-100. A zero will remove the stat from the calculation.
-
I've updated the values to what I believe are the final ones, you might want to take a look again to see if yours still match up.
-
Chaperone is not a sniper
-
See the notes below the sniper table. I agree with you.
-
Bump Great work!
-
That's pretty cool, I like it. Well done.
-
Bump for later
-
For later
-
And this, is awesome. I might be bad at Crucible but can still have a blast testing weapons! Thank you for putting this together.