+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 11 to 17 of 17
  1. #11
    Member r1p's Avatar
    Join Date
    Oct 2014
    I haven't looked at the spreadsheets but fire rate should be the number of bullets that the weapon can fire every second, so mag size divided by fire rate should equal the time it takes to empty the clip.

  2. #12
    Member Logain's Avatar
    Join Date
    Jun 2013
    Night Vale
    Quote Originally Posted by Tullman View Post
    Humm, I've done my best to absorb those calcs but when I look at the math portion on the sheet Ttot and Sustained DPS are being revised 3 times each. Are these variations that get used depending on the input values. My calculations thus far as not lining up to the Sheets (close though). I'm assuming that 'Time to empty clip' is a perceptual observation or is there a way to calc that based on fire rate and clip size. Cheers
    Math tab should be read like a mathematical proof. The important equation is the Sustained DPS result as well as Burst DPS (DMG*Fire Rate).

    Equations confirmed multiple times though the one that is still around and I trust is Tekrunner's weapons table found here: http://forums.defiance.com/showthrea...-Weapon-Tables.

  3. #13
    An Evo blast rifle with a fire rate of 15.8 and a mag of 113 does empty in about 7.6 seconds, as per mag/fire rate, so thats good lol.

  4. #14
    Duh, 'show formulas' in those spreadsheets lol. Which I've replicated, but somethings still off in my logan variations.

  5. #15
    Well its working correctly and you can add and load weapons your comparing 'Add button under weapon name'. They appear at the bottom of the form. I'll pluck at it later. The ones from the logan sheets are named accordingly.


  6. #16
    Member Verga DeFuego's Avatar
    Join Date
    Jun 2016
    A dystopian nightmare
    I've been using a spreadsheet to try and determine my "best" weapons based on DPS, and after looking at all the cool stuff posted in this thread, realized it is basically a DPS Calc.

    It is a little different in that it calculates not only base weapon damage, but also, crit, damage to shields, damage to health and damage to Armor Plates based on the weapon nano. It also allows you to sort on any column so it's easy to see which weapon has the highest crit dps or highest damage against shields. Here's a link and screen shot to an online version of the spread sheet:

    If you download or save the sheet and then fill out the Weapon Info and Weapon Stats sections, it will calculate the values in the DSP section:DPSCalc.jpg

  7. #17
    Member crasher's Avatar
    Join Date
    Apr 2013
    Outside the Beltway in Virginia, on an actual pc.
    I can still go down to Head First Crater near bug/chug, see multiple dozens of spiders in that crater, go in and kill every single one with a shotgun, rifle or pistol (all projectiles), and still be credited with under 30 kills.

    I can do the same thing counting raider kills or infected kills.

    The server or the base program can't keep an accurate count of kills half the time, so as far as I can tell, the numbers are 'ball park' in nature, sometime close to actual, but not to be trusted as 'actual' unless they randomly coincide.
    Mid E-5XXX main
    , but I play 26+ 'toons from E400 to E5500
    Just my opinion.
    I have lots of opinions.
    Some of them, on occasion, people have agreed with.
    I do not trust those people.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts