Item Search
     
BG-Wiki Search
+ Reply to Thread
Page 11 of 47 FirstFirst ... 9 10 11 12 13 21 ... LastLast
Results 201 to 220 of 930

Thread: DPS Spreadsheets     submit to reddit submit to twitter

  1. #201
    New Spam Forum
    Join Date
    Jun 2010
    Posts
    183
    BG Level
    3
    FFXI Server
    Quetzalcoatl

    That page you pulled stats from, http://www7b.biglobe.ne.jp/~fit/memo/st.htm) has a different formula for the effect of AGI on monster TP gain. They use:

    ΔAGI = 自AGI - 敵AGI

    AGI枠モクシャ = 15 + int( ΔAGI / 2 )
    ΔAGI = +70のとき、モクシャ50(上限)
    ΔAGI = +00のとき、モクシャ15
    ΔAGI = -30のとき、モクシャ0?(下限

    dAGI= Player AGI- Monster AGI

    AGI subtle blow effect= 15 + floor( dAGI / 2 )
    dAGI= +70 when mob TP gain is 50%(50% subtle blow)
    dAGI= +00 when mob TP gain is 85%(15% subtle blow)
    dAGI= -30 when mob TP gain is 100%?(0% subtle blow?)

    They test AGI by casting a spell 10 times and charming, which obviously only works for charmable monsters.

  2. #202
    Banned.

    Join Date
    Jun 2007
    Posts
    2,590
    BG Level
    7

    War spreadsheet doesn't give the 30% bonus to king's justice when using conqueror >_<.

  3. #203
    Old Merits
    Join Date
    Sep 2010
    Posts
    1,094
    BG Level
    6
    FFXI Server
    Ragnarok

    I'm sure motenten will fix it at some point, but...

    based on the DRG spread sheet, adding this for set one:

    IF(OR(Gear!B3="Conqueror (90)", Gear!B3="Conqueror (95)"), 15%, IF(Gear!B3="Conqueror (99)", 30%, 0)))

    to the relic bonus cell in the data tab(D98 in the DRG sheet(set one)), might fix it. This one for set two:

    IF(OR(Gear!W3="Conqueror (90)", Gear!W3="Conqueror (95)"), 15%, IF(Gear!W3="Conqueror (99)", 30%, 0)))

    May or may not work, depending on differences in the sheets.

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

    Quote Originally Posted by pchan View Post
    War spreadsheet doesn't give the 30% bonus to king's justice when using conqueror >_<.
    Fixed.

  5. #205
    Salvage Bans
    Join Date
    Sep 2008
    Posts
    991
    BG Level
    5
    FFXI Server
    Asura

    Did some Ig-alima testing on test server with Yugi, here are the data we got:

    My Stat:


    THF/War no food

    str: 106+24 => 130
    Dex: 103+49 => 152 dex

    vajra 99 dmg: 53
    twasthar 95 dmg: 52




    dagger skill 433

    Accuracy from gear: 12 +6 +12+9+14 = 53acc gear


    564 base attack (w/o stalwart)
    705 with stalwart


    Parse result:

    TEST 1

    (1 fight) stalwart drink champions drink fanatic drink mythic am 3 up
    Ccl hit/miss 77/55 acc 58,33 % low/high 0/19

    Crit 20 low/high 41/74 57,65 25,97 %

    (3fights) stalwart drink champions drink fanatic drink mythic am 3 up

    Ccl hit/miss 147/96 acc 60,49 % low/high 0/19

    crit 54 low/high38/72 57,35 36,73 %




    Pretty sure I had a 75 crit but failed to record that one for some failderp after 1st fight parse.


    TEST 2
    same stat but food+zerk

    attack = 1000
    (1fight)
    Ccl hit/miss 35/21 acc 62,50 % low/high0/45 av: 24,55

    crit 13 62/108 86,15 37,14 %



    TEST 3

    1090- 1145 attack (chaos roll variation)(dia II)


    3fight

    ccl hit/miss 106/88 acc 54,64 % low/high7/57 av :39,45

    crit 23 low/high 64/129 av: 98,74 21,70 %

    TEST 4

    1 fight zerk/brava/chaos roll/minuet/minuet/mad/mad (soul voice) food dia (1500+ attack) (was like 1506ish)


    Ccl hit/miss 168/12 acc 93,33 % low/high 0/75 av: 56,75

    crit 37 low/high 103/151 av: 125,59 22,02 %

  6. #206
    Banned.

    Join Date
    Jun 2007
    Posts
    2,590
    BG Level
    7

    Can you give the full list of melee hit & crits is /spoiler because it's easier and more precise to reverse the pdif formula with average hit values. Assuming my model works correctly that is.

    Edit : nvm you gave the averages too.

    Well test 4 gives almost certainly the value of total damage : ~57. You are likely capped pdif and then average melee pdif would be ~0.98 on average (21 level correction) (using my own pdif formula found on normal wiki, bottom of pdif page).

    That makes it 3 or 4 fstr. this put dstr between 5 and 10. So it has between120 and 125 vit.

    the other tests are matching ~750 defense. using my model :

    For test 3
    if 700 def you'd average ~ 45.42
    if 720 def you'd average ~ 43.18
    if 750 def you'd average ~ 39.76
    if 770 def you'd average ~ 37.46
    if 800 def you'd average ~ 33.99

    750 ish def seems accurate

    For test 2 (24.55) avg
    750 def gives 22.04
    770 def gives 20.5
    730 def gives 23.79

    Here you guess 730 ish def

    With 750 def, on crits, test4 would give 113.6 (you got 125.. 37 crits only though )
    With 750 def test 3 would give 95.8 (you find 98)
    With 750 def test 2 would give 85.47 (vs 86.15)

    I'm guessing that if it really has 21 level correction it has

    ~ 120 vit
    ~ 750 def

  7. #207
    Salvage Bans
    Join Date
    Sep 2008
    Posts
    991
    BG Level
    5
    FFXI Server
    Asura

    okay, thank you.

    I'd like to do Legion too but 0 chance to see wave 2 on Test server, and Provenance Watcher seems annoying to do and not really worth doing since everyone does it with enough buff to be pretty to cap accuracy/att anyway.

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

    In test 1, you have (1 fight) and (3 fights). Is the (3 fights) entry the sum of three fights? or is it the info for the third fight you tried? or is it the results of fights 2 and 3 (since total hits is about twice the amount as the (1 fight) entry)?

    Assuming all the data is independent (ie: (3 fights) does not include (1 fight) data), and including test 2 and 3:

    Total hits: 365
    Total miss: 260
    Total swings: 365+260 = 625
    Overall hit rate: 58%

    Margin of error is +/-4% or so, so we can figure that our estimate will be within about 8 of its actual evasion.

    433 skill = 409 acc
    152 dex = 76 acc
    gear = 53 acc
    Stalwart's = 50 acc
    21 levels of level correction: -84 acc

    Net acc: 504

    75% - 58% = 17% = 34 evasion

    Estimated evasion: 504 + 34 = 538
    With margin of error, figure somewhere between 530 and 546. Will just use 540 as a round value. Note that that value includes agi.

    If Ig-alima is a war-type mob with C evasion, and assuming the evasion formula has remained static since level 50 (no idea if anyone has even checked on whether that's the case), that would imply a 478 evasion without Agi. Using the 540 value above, that's 62 evasion from Agi, or 124 Agi.

    Looks like you didn't use Champion's Drink in tests 3 and 4. You had a 22% crit rate in each of those (and 37% crit rate when using Champion's Drink, for +15% from the drink). Were you using any gear that enhanced crit rate?

    dDex should be in the neighborhood of +30, which is +3% to +4%. Adding base and merits, that's 13%-14%. If you didn't have +crit rate in gear, that means dDex needs to increase by about 18 points, putting it at +47. That means an Agi of 105.

    If that's the case, it would put its Eva rating at a B, giving 490 + 105/2 = 542 evasion.


    So all together with pchan's analysis, we have the following stats (unless corrected due to gear used):

    Lvl: 120
    Def: 750
    Vit: 120
    Eva: 540
    Agi: 105

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

    Additional data from ccl:

    1500 att melee detail:
    Spoiler: show

    Melee
    41: 1
    42: 1
    43: 1
    44: 4
    45: 5
    46: 3
    47: 4
    48: 4
    49: 4
    50: 3
    51: 4
    52: 4
    53: 2
    54: 2
    55: 10
    ^ 56: 16
    + 57: 18
    58: 9
    59: 3
    60: 2
    61: 1
    62: 2
    63: 1
    64: 1
    65: 4
    66: 1
    67: 2
    68: 1
    69: 1
    70: 4
    71: 5
    72: 5
    73: 1
    74: 1
    75: 1



    That gives us the exact base damage. Given the weapons' base damage of 52 and 53, we can consider that 55 is the 52, and 56 is the 53, particularly as the 56 value is more common (due to AM3). Thus we know for sure that fStr is +3. dStr is between +5 and +9, giving Ig-alima a vit between 121 and 125; same as pchan's range, basically, but wanted a more certain confirmation. Will probably use 123, though, instead of 120.

    If you wanted to narrow it down a bit, you could drop 2 str merits and re-run the 1500 attack test. If base damage drops, its vit is at the upper end of the range; if it doesn't, it's at the lower end.

  10. #210
    Salvage Bans
    Join Date
    Sep 2008
    Posts
    991
    BG Level
    5
    FFXI Server
    Asura

    I used Rancor collar and have 5 crit merit.

    Test 1 and 2 I was alone so I used champion's for haste, didn't use on 3-4 since Yugi joined me and casted haste on me.

    Test 1 has one parse of 1 fight and one parse of 3 fight, wanted to do all 6 fight in a single parse but some fail on my part made it not happen.
    (was my 1st time on test server, and I used windower trick and for some reason my mouse refused to work so I had to use mainly keyboard to tab/start/close parse and I'm not used to)

    The difference in number of hit might be due that in some of the fight it had shock spike/ice spike on or opened/spamed that en-stun move.

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

    Ok, correction on the Agi due to Rancor Collar:

    22% with base, merits and collar means 7% from dDex, which means dDex = 42. 152 dex means 110 Agi.

    Both B and C evasion rating are still possible. B would total 545, C would total 533. Staying with 540 as an estimate.

  12. #212
    Banned.

    Join Date
    Jun 2007
    Posts
    2,590
    BG Level
    7

    SAM spread sheet : the str calculation refers to a wrong cell when checking for hasso. Only 15% is applied to tachi :rana with koga 99.

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

    Quote Originally Posted by pchan View Post
    SAM spread sheet : the str calculation refers to a wrong cell when checking for hasso. Only 15% is applied to tachi :rana with koga 99.
    Fixed.

    Also:

    Revised mobs for the currently updated spreadsheets (dnc/drg/sam/war), adding in crit defense bonus and crit rate mods, and adding new mobs. Used Seaboard Vulture stats, but kept it named 'Fodder'; didn't want people expecting piercing damage bonus or something like that.

    Made sure cRatio couldn't fall below 0 due to level correction.

    Will try to get another spreadsheet upgraded today.

  14. #214
    TSwiftie
    Join Date
    Oct 2005
    Posts
    1,920
    BG Level
    6
    FFXI Server
    Fenrir

    Was playing with the DRK spreadsheet a bit, and I noticed Apoc (99) doesn't have the 40% relic bonus, easy fix at least:

    =100%+IF(Setup!B27="Catastrophe",IF(OR(Gear!B3="Ap ocalypse (90)",Gear!B3="Apocalypse (95)"),25%,IF(Gear!B3="Apocalypse (99)",40%,0)),0)

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

    Fixed that (but not uploaded yet), and will go ahead and work on drk next.

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

    Upgraded version of Drk uploaded.

    Also fixed a bug in Abyssea results for war and sam.

  17. #217
    New Spam Forum
    Join Date
    Dec 2007
    Posts
    186
    BG Level
    3
    FFXI Server
    Quetzalcoatl

    If you feel like jumping into NIN next I know I'd appreciate it.

    Love your speadsheets Mot!

  18. #218
    Salvage Bans
    Join Date
    Oct 2010
    Posts
    792
    BG Level
    5
    FFXI Server
    Sylph

    Do the thf/dnc spreadsheets account for the special effects on coruscanti and asteria?

  19. #219
    Theory Fighter
    Join Date
    Jan 2011
    Posts
    1,420
    BG Level
    6
    FFXIV Character
    Frejan Schultz
    FFXIV Server
    Ragnarok
    FFXI Server
    Ragnarok

    Was the special effect of Coruscanti fixed in the first place?

  20. #220
    New Spam Forum
    Join Date
    Jun 2010
    Posts
    183
    BG Level
    3
    FFXI Server
    Quetzalcoatl

    Quote Originally Posted by Langly View Post
    If you feel like jumping into NIN next I know I'd appreciate it.

    Love your speadsheets Mot!
    Don't give him any ideas, he hasn't even done MNK yet!

Quick Reply Quick Reply

  • Decrease Size
    Increase Size
  • Remove Text Formatting
  • Insert Link Insert Image Insert Video
  • Wrap [QUOTE] tags around selected text
  • Insert NSFW Tag
  • Insert Spoiler Tag