Buff AR Calculator v1.4.5

	A	B	C	D	E	F	G	H	K	L	M	N
1		bAR=(bMod∙(bFlat+wScale∙eBNS+wBase∙wMod)) + MatchBNS

2
3		buff AR =	(0(50+0.6103+240*1.4))+25
4		Buff AR =						25	Fire
5		bMod is the Buff Damage Multiplier						0
6		bFlat is the Flat eAR the applied buff gives						50
7		wScale is the weapon’s elemental scaling						0.6	Weapon		Aldia Hammer
8		eBNS is the character’s elemental bonus						103	Infusion		Fire	(Used Level)
9		wBase is the weapon’s base damage						240	Upgrade Level		10	10
10		wMod is the weapon’s Base Damage Multiplier						1.4	Buff		Possesed Armor Sword
11		MatchBNS Buff Element Matching Bonus						25	Int Level		16
12									Fth Level		18
13				Using clutch ring?
14
15	Calculator by the_guiding_qui		My resources	Link to this sheet				Join Orange Arena			^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
16	Make a copy of this file to use it										INPUTS
17		My Character Planner / Damage Calculator / General DS2 Utilities Sheet									vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
18
19		buff AR =	(0.7(10+0.4155+170*1))+10
20		Buff AR =						179.4	Magic
21		bMod is the Buff Damage Multiplier						0.7	Weapon		Aged Smelter Sword
22		bFlat is the Flat eAR the applied buff gives						10	Infusion		Basic	(Used Level)
23		wScale is the weapon’s elemental scaling						0.4	Upgrade Level		9	5
24		eBNS is the character’s elemental bonus						155	Buff		Watcher Greatsword
25		wBase is the weapon’s base damage						170	Int Level		50
26		wMod is the weapon’s Base Damage Multiplier						1	Fth Level		50
27		MatchBNS Buff Element Matching Bonus						10
28				Using clutch ring?
29
30
31
32
33	Bewitched Alonne Sword multiplies your scaling AR (Scaling numbers in the menu, all of them) by 1.6, includes RoB but not Flyn's or Sacred Oath
34
35
36	Link to the original file			Based off Radai's Damage Findings
37										Patch Notes:
38										1.1: Fixed Matching buff bonues values
39	Current Buff AR formula									1.2: Added Clutch Rings option
40	Buff AR is the AR added to a weapon via temporary effects of spells or a few weapon special moves									1.3: Fixed the indexing for Fire and Lightning Scaling BNS (from int/fth)
41	buffAr:X = bMod * (bFlat + wScale:X * eBns:X + wBase * BaseDamageMultiplier) + MatchBNS									1.3.2: Fixed the index to include all weapons
42	X refers to any given element									1.4 Remade the calc to coincide with the newer damage formulas, data is way more precise now
43	bMod is the Buff Damage Multiplier									1.4.1 Fixed Clutch ring bonuses
44	bFlat is the Flat eAR the applied buff gives									1.4.2 fixed second weapon upgrade level
45	wScale is the weapon’s elemental scaling									1.4.3 Added Possesed Armor Sword
46	eBNS is the character’s elemental bonus									1.4.4 Fixed a lookup issue
47	wBase is the base damage added by infusion level of the weapon, equal to Dmg:X + (MaxDamage:X - Dmg:X) * upgradeLvl / MaxReinforcementLevel									1.4.5 Added a visualizer for the formula and changedthe clutch ring input to a checkbox
48	Dmg is the referenced base damage, before upgrades (not the actual damage per se)
49	MaxDamage is the referenced damage reached at max upgrade level
50	upgrade level is the current level of the weapon
51	MaxReinforcementLevel is the highest level the weapon can be
52	BaseDamageMultiplier is a value dependent on the infusion of the weapon
53	MatchBNS is the matching element bonus, equal to infMod * bFlat
54	infMod is a result of the inherent damages and the ones added by infusion
55		If the Infusion is the element, the formula for infMod is
56		infMod:X = Damage%:X + InfusionMod:X }
57		(elements are magic, lightning, fire, dark, bleed and poison)
58		If the infusion is not the element, the formula for infMod is
59		infMod:X = Damage%:X - InfusionMod:X / elementCount
60		elementCount is the amount of elements the weapon has post infusion
61		Damage% is 100 if the weapon has damage for that element innately or 0 if not
62		InfusionMod is a percentage added by the infusion
63
64
65
66
67			bFlat	#REF!
68	BUFF FORMULA		bMod	Max Upgrade Level	Upgrade Level
69			bFlat	10
70	WeaponReinforceParam	113	wScale		<Base Damage Multiplier
71	WeaponStatsAffect	139	eBns
72	3		Damage	120
73	(index)^ elemental confirmation>	1	(WeaponReinforceParam->MaxDamage:X - WeaponReinforceParam->Damage:X)	120	damage%
74	17		upgradeLvl / MaxReinforcementLevel	1	0		2
75	^(index) type>	3	BaseDamageMult		InfusionMult
76			bFlat * infMod		50
77	8	1	2	3	4	5	6
78	100	0	0	100	0	0	0
79
80
81
82
83
84	BUFF FORMULA		bMod	Max Upgrade Level	Upgrade Level
85			bFlat	5
86	WeaponReinforceParam	243	wScale		<Base Damage Multiplier
87	WeaponStatsAffect	1760	eBns
88	0		Damage	100
89	(index)^ elemental confirmation>	no	(WeaponReinforceParam->MaxDamage:X - WeaponReinforceParam->Damage:X)	70	damage%
90	12		upgradeLvl / MaxReinforcementLevel	1	100		2
91	^(index) type>	1	BaseDamageMult		InfusionMult
92			bFlat * infMod		0
93	8	1	2	3	4	5	6
94	100	100	0	0	0	0	0
95
96
97
98
99
100