Item Search
     
BG-Wiki Search
+ Reply to Thread
Page 4 of 47 FirstFirst ... 2 3 4 5 6 14 ... LastLast
Results 61 to 80 of 930

Thread: DPS Spreadsheets     submit to reddit submit to twitter

  1. #61
    CoP Dynamis
    Join Date
    Jun 2010
    Posts
    252
    BG Level
    4
    FFXI Server
    Siren

    How exactly do the spreadsheets calculate hits on Occasionally Attacks X-times weapons compared to double/triple/quadruple attack? I was messing around with OA2-4 stuff and I wasn't sure I was getting accurate results so I downloaded the WHM spreadsheet, set my offhand to Kraken Club, and messed with Brutal Earring's DA rate. As it went up (I went all the way to max) my DPS went up, but shouldn't it be going down since DA is calculated before KC's OA2-8 (and all I would be doing is attacking twice)?

  2. #62
    D. Ring
    Join Date
    Jul 2008
    Posts
    4,529
    BG Level
    7
    FFXI Server
    Phoenix

    Something to do with the probability of the higher multi hits and the DA boosting your mainhand weapon swings. Pretty sure it actually does come out to a very small dps increase.

  3. #63
    CoP Dynamis
    Join Date
    Jun 2010
    Posts
    252
    BG Level
    4
    FFXI Server
    Siren

    Yeah you must be right... I didn't expect it to come out that way. Just to test the theory I put on dual Kraken Clubs and as my double attack rate went up my DPS went down.

    I can't figure out how to single wield without getting an error.... is there a way to single wield? >.>

  4. #64
    Chram
    Join Date
    Sep 2007
    Posts
    2,526
    BG Level
    7
    FFXI Server
    Fenrir

    To the left of the weapons are cells that say "Weapon". The second of those is changeable (TP set only; WS set copies TP set). Set it to "Shield" and put in a proper shield and it should work that way.

  5. #65
    CoP Dynamis
    Join Date
    Jun 2010
    Posts
    252
    BG Level
    4
    FFXI Server
    Siren

    Thanks!

    Is there any way to manually change weapon skill level? For example changing dagger skill grades from A+ to B-, or from level 400 to 300...

    Also the WHM club skill merits don't appear to be working

  6. #66
    Chram
    Join Date
    Sep 2007
    Posts
    2,526
    BG Level
    7
    FFXI Server
    Fenrir

    Sorry, no easy way to change skill level. You can manually tweak it in cells K9/L9 of the Data page.

    Fixed the club merit issue. New version uploaded.

  7. #67
    An exploitable mess of a card game
    Join Date
    Sep 2008
    Posts
    13,258
    BG Level
    9
    FFXIV Character
    Gouka Mekkyaku
    FFXIV Server
    Gilgamesh
    FFXI Server
    Diabolos

    I see ODD and Melee Multiplier. ODD seems to only affect jump damage. What is melee multiplier used for?

  8. #68
    Chram
    Join Date
    Sep 2007
    Posts
    2,526
    BG Level
    7
    FFXI Server
    Fenrir

    Eh, those shouldn't be there. I've been removing Melee Multiplier as a superfluous value, but apparently hadn't gotten drg yet. Also had the basic melee calculations not getting ODD O.o

    Fixed and new version uploaded.

  9. #69
    An exploitable mess of a card game
    Join Date
    Sep 2008
    Posts
    13,258
    BG Level
    9
    FFXIV Character
    Gouka Mekkyaku
    FFXIV Server
    Gilgamesh
    FFXI Server
    Diabolos

    Hot, thanks.

  10. #70
    Special at 11:30 or w/e
    Sweaty Dick Punching Enthusiast

    Join Date
    Feb 2012
    Posts
    10,267
    BG Level
    9
    FFXIV Character
    Kalmado Espiritu
    FFXIV Server
    Gilgamesh
    FFXI Server
    Sylph
    Blog Entries
    4

    Whenever I try to open the Thf doc, I get this error: Sorry, an error occurred while exporting your document. Details: The formulas on this sheet could not be calculated. Try removing some formulas or modifying complex formulas, like VLOOKUP and HLOOKUP, and recalculate.

    How can I fix this?

  11. #71
    Chram
    Join Date
    Sep 2007
    Posts
    2,526
    BG Level
    7
    FFXI Server
    Fenrir

    Which program are you using to open them?

  12. #72
    Special at 11:30 or w/e
    Sweaty Dick Punching Enthusiast

    Join Date
    Feb 2012
    Posts
    10,267
    BG Level
    9
    FFXIV Character
    Kalmado Espiritu
    FFXIV Server
    Gilgamesh
    FFXI Server
    Sylph
    Blog Entries
    4

    I'm just exporting to google spreadsheet and I use firefox. I tried the Dnc and Bst files and those seem to be fine for me.

  13. #73

    Could anyone with a spare few mins please bang together a spreadsheet that would compare a DRK with Ragna/Reso and KC SE BW please? I think I could fill in the relevant stats from there. Thank you!

  14. #74

    Looking at monk's spreadsheet, it seems that you count +1% crit dmg/hit during impetus even if you don't equip tantra body +2 ?

  15. #75
    Chram
    Join Date
    Sep 2007
    Posts
    2,526
    BG Level
    7
    FFXI Server
    Fenrir

    Quote Originally Posted by Kalmado View Post
    I'm just exporting to google spreadsheet and I use firefox. I tried the Dnc and Bst files and those seem to be fine for me.
    Hmm. Most likely to do with the slightly longer calculations needed for SA/TA weaponskills, then. I do know that Google Doc's native spreadsheet capabilities are more limited than a standalone program like Excel or Calc, which is why I don't use that for normal distribution (though somewhat recent changes have made that more of an automatic thing, with the download as a secondary step). I'd suggest downloading a copy to use intstead.

    Quote Originally Posted by pchan View Post
    Looking at monk's spreadsheet, it seems that you count +1% crit dmg/hit during impetus even if you don't equip tantra body +2 ?
    No, it should only get added in if Tantra body is included in the relevant gear set (line 63 of Data page). However it's wrong in considering Tantra+1 body there; that was from before the accuracy bonus was known, and I just assumed it was the same bonus as the +2 augment. Will fix that.

  16. #76

    Quote Originally Posted by Motenten View Post
    No, it should only get added in if Tantra body is included in the relevant gear set (line 63 of Data page). However it's wrong in considering Tantra+1 body there; that was from before the accuracy bonus was known, and I just assumed it was the same bonus as the +2 augment. Will fix that.
    Ok it's correctly accounted, but I was mistaken by the impetus page. Manually changing crit dmg to 0% in "set 2" was affecting the DPS. Still it seems weird that the spreadsheet is using melee crit dmg for the WS crit dmg. (seems weird to consideer them different in the first place).

  17. #77
    Chram
    Join Date
    Sep 2007
    Posts
    2,526
    BG Level
    7
    FFXI Server
    Fenrir

    Updated mnk. Had to hack things a bit to get the acc bonus in for Impetus without causing a circular reference (which Excel handles horribly), so it'll end up a tiny bit lower than what it really should be, but should be close enough.

  18. #78
    Chram
    Join Date
    Sep 2007
    Posts
    2,526
    BG Level
    7
    FFXI Server
    Fenrir

    Quote Originally Posted by pchan View Post
    Ok it's correctly accounted, but I was mistaken by the impetus page. Manually changing crit dmg to 0% in "set 2" was affecting the DPS. Still it seems weird that the spreadsheet is using melee crit dmg for the WS crit dmg. (seems weird to consideer them different in the first place).
    It's more that it's considering melee accuracy to limit the value of the possible bonus during weaponskills. If you have an 80% melee hit rate and a 95% weaponskill hit rate, the average expected bonus you'd get during the weaponskill is not the same as it would be if your melee hit rate was 95%.

  19. #79
    Special at 11:30 or w/e
    Sweaty Dick Punching Enthusiast

    Join Date
    Feb 2012
    Posts
    10,267
    BG Level
    9
    FFXIV Character
    Kalmado Espiritu
    FFXIV Server
    Gilgamesh
    FFXI Server
    Sylph
    Blog Entries
    4

    Thanks for the suggestion Mot and also thanks for the time in creating this. I've never been largely involved in getting every last .001% of damage, but I figure with this available I can at least play with it for fun.

    On a side note, while playing with the Dnc sheet I wanted to see the difference between dex/str/agi Thokcha's using Evisceration. The only thing I changed was the 2nd dagger, leaving Aluh as main hand. Everyone always says Str is the best dagger, but when I ran the different daggers, it seemed dex dagger was coming out ahead, at least in WS damage. Is Str the dominant dagger for all content?

  20. #80
    BG Content
    Join Date
    Jul 2007
    Posts
    21,104
    BG Level
    10
    FFXI Server
    Lakshmi
    Blog Entries
    1

    Quote Originally Posted by Kalmado View Post
    Is Str the dominant dagger for all content?
    Nope, if you have capped or near-capped Attack for the monster you're fighting, the STR dagger is only going to contribute fSTR (until you cap) on WS, which is about a 25% mod. 30% DEX with alpha is also about a 25% mod, but it doesn't cap. That's how the DEX dagger comes out ahead.

    Well, that or you're running uncapped Acc which is pretty unlikely against those targets.

+ Reply to Thread
Page 4 of 47 FirstFirst ... 2 3 4 5 6 14 ... LastLast