Sapphire
Member
|
https://www.dropbox.com/scl/fi/ohqau8q6eesegjw0i15ox/AdventureQuest-BTH-Formulas.xlsx?dl=0&rlkey=b6dcsg2npx3gqh1wt0ciaznpt
Yellow boxes (except the bright yellow at the top) Are manual inputs. Blue boxes are values calculated based on the input yellow.
Hi, So I built a quick and dirty spreadsheet to try and figure out some things about blocking. I have experimented at great length with a variety of ideas, and have figured out that blocking leaning armors, shields, and builds are not actually always necessary to play a blocking style, as there are numerous ways to stack a variety of effects.
First off, I wanted to reference the following from the master formulae thread:
BTH Formula
Melee: STR*3/40 + DEX*3/40 + LUK/40
Ranged: DEX*3/20 + LUK/40
Magic: INT*3/40 + DEX*3/40 + LUK/40
Pets & Guests: CHA*3/40 + DEX*3/40 + LUK/40
Blocking Ability
DEX/8 + LUK/40
Hit or Miss (Accuracy Formulas)
Attacker Value (weapon) = Weapon BTH + Armor BTH + Stat BTH
Attacker Value (weapon special) = Weapon BTH + Weapon Special BtH
Attacker Value (spells) = Spell BTH + Stat BTH
Attacker Value (pet/guest) = Pet/Guest BtH + Stat BtH
Roll = Rolls a Random Float between 0 and 100.
Defender Value = Blocking Defense + 0.125*DEX + 0.025*LUK
If Attacker Value + Roll > Defender Value, then it hits. Otherwise it misses. Certain special actions, like healing spells, will always hit.
Chance to Hit
Chance to Hit = (100 + Attacker Value - Defender Value) / 100
Chance to Hit is in decimal form. It will always lie between 0 and 1 (inclusive).
I built my spreadsheet using these exact values. The thing that I have wondered about, are two things:
First, does monster BTH have any hidden modifiers outside of the normal LEAN system? If they DO, the rest of this post is null and void.
Second, how much blocking enhancers would one need to become "unhittable" outside of auto-hit?
There are some other potential things I may have overlooked, and there IS a variable in that, Level 150 Monsters can have 275 Mainstat. Also, I do NOT know what constitutes as "standard blocking" or "assumed blocking" when it comes to armor and shield.
In testing with the spreadsheet, I have come up with 59 combined. This results in a pure build 250/mainstat/dex/luk monster to hit at a 85.25% rate. And we all know 85% is the assumed standard.
So these values will assume the following:
1. Monster is pure build with 250/250/250 stat spread. BTW, 275 mainstat adds about 2% over 250.
2. Monster has a standard accuracy lean. So no + or -.
3. There are no hidden mods to monster BTH, and I will assume that standard bth is the same as player standard bth of Armor + Weapon.
4. Level 150 Monster and Player
5. This means 19 bth for weapon and armor, so 38 standard bth for the monster's "attack value"
6. 59 Player MRM
How much blocking enhancements is needed to lower hit rate to 0 or below?
Pure Build (250 mainstat/dex/luk)
~ Will be hit 85.25% of the time starting out
~ You will need 86 total MRM increase, blind, bth loss stacked to get to becoming un-hittable.
~If monster has 275 mainstat, this increases to 88.
No Luck, but with DEX Build (250 mainstat/dex, 0 luck)
~ Will be hit 93% of the time starting out
~You will need 92 total MRM increase, blind, bth loss stacked to get to becoming un-hittable
~ If monster has 275 mainstat, this increases to 94.
No Dex, but has luck build (250 mainstat/luck, 0 Dex)
~Will be hit 100% of the time starting out
~Will need 117 total MRM increase, blind, bth loss stacked to get to becoming un-hittable
~If monster has 275 mainstat, this increases to 119.
If the Monster has a +10 BTH lean, a Pure build would need 96 MRM buff to become un-hittable, or 98 if the monster has 275 mainstat.
So to make things easier, if you can garner 100 total help from MRM/Blocking buffs, blind, berserk, entangle, etc...probably nearly every monster in the game w/o an auto-hit attack will not hit you. Even the 250 dex, 0 luck build at 275 mainstat/+10 bth lean on the monster gives you only a 0.03% chance of being hit. So this same 100 total BUFF target likely holds true.
So in conclusion, if you have 250 dex, if you take 59 and then add whatever additional MRM from your armor and shield (For example, Necromancer armor wielding Titan's Fall is 67 Magic, so you're already +8) and add up all of your blocking buff spells, blinds, bth loss from things like entangle, the cold, berserk, etc or OTHER effects that essentially do the same, your target number is 100.
100 should be worst case scenario, since this number is versus a Pure Build Monster.
If someone thinks I am off with something, let me know and I'll adjust.
But so far, every monster I have encountered I can key in it's stats, assume no bth lean since this is always unknown, and cast a few things, give myself a buff or two, and key these into my spreadsheet and it spits out a number and tells me if I can be hit. And then test.
Against a Lvl 145 Shada Naga Baba Yaga, with 265 Int, 240 Dex, 220 Luck... I get celerity, cast Mandate twice, got me 57 blind, roots of daw got me 194 entangle for 14.55 bth loss, and dual bun barrets for another 19.69 and have 69 Magic MRM to start. The sheet says I cant be hit. So far, havnt been hit try after try after try. I think it should be very accurate, but let me know.
< Message edited by SapphireCatalyst2021 -- 12/8/2021 16:51:59 >
|
Printable Version
Icon Legend
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread
