4.X BLM Relative Damage Calc

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	S	T	U	V	W	X	Y
1			Stats (with food, no party)						GCD		LL GCD		Crit (no party)		DH	Det	Expected average DPS		Gain Over Base Set		Ticks cut short	Skipped F4s/3 min	Downgraded F4s/3 min
2	Gear Description	Link	WD	Int	DH	Crit	Det	SS	2.5s	2.8s	2.5s	2.8s	Rate	Damage	Rate	Damage	Sharp Fire	Sharp Thunder	Sharp Fire	Sharp Thunder	0	0	0

3	No Melds, Tome Set	http://ffxiv.ariyala.com/175GD	147	3237	1336	1595	1337	1375	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?			<- Base Set	Party Buffs
4	No Melds, Omega Set	http://ffxiv.ariyala.com/175GJ	147	3237	1351	1788	1399	1105	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				BRD
5																						DRG
6	SMN/RDM-friendly	http://ffxiv.ariyala.com/17MP3	147	3222	1525	2668	978	1389	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				SCH
7	Max Crit	http://ffxiv.ariyala.com/179S5	147	3237	1375	2681	994	1450	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?			<- best 4.4 crit	DNC
8	1917 w/ Ema Datshi	http://ffxiv.ariyala.com/17NAI	147	3237	1154	2328	1094	1921	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?			<- best 4.4 sps set
9																						Party Comp
10	Max Crit Eureka	http://ffxiv.ariyala.com/18MG7	147	3207	1766	2614	967	1485	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				Different Roles	5
11	1689 Sps Eureka	http://ffxiv.ariyala.com/18MG4	147	3189	2091	2419	740	1689	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
12	fast Eureka Set	http://ffxiv.ariyala.com/18MFX	147	3171	1718	2311	1053	1948	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
13	full Eureka	http://ffxiv.ariyala.com/18U0I	147	3171	1632	2535	1053	1803	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
14
15	1k crit relic + full eureka	http://ffxiv.ariyala.com/18MLT	147	3171	1632	3165	1053	1487	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	S	T	U	V	W	X	Y
1			Stats (with food, no party)						GCD		LL GCD		Crit (no party)		DH	Det	Expected average DPS		Gain Over Base Set		Ticks cut short	Skipped F4s/3 min	Downgraded F4s/3 min
2	Gear Description	Link	WD	Int	DH	Crit	Det	SS	2.5s	2.8s	2.5s	2.8s	Rate	Damage	Rate	Damage	Sharp Fire	Sharp Thunder	Sharp Fire	Sharp Thunder	0	0	0

3	No Melds, Tome Set	http://ffxiv.ariyala.com/175GD	147	3237	1336	1595	1337	1375	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?			<- Base Set	Party Buffs
4	No Melds, Omega Set	http://ffxiv.ariyala.com/175GJ	147	3237	1351	1788	1399	1105	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				BRD
5																						DRG
6	Max Crit, Low SS	http://ffxiv.ariyala.com/175GW	147	3237	1865	2681	1104	860	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				SCH
7	Max Crit, Low SS	http://ffxiv.ariyala.com/17S64	147	3237	1824	2681	954	1050	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				DNC
8	SMN/RDM-friendly	http://ffxiv.ariyala.com/17MP3	147	3222	1525	2668	978	1389	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
9	High Crit	http://ffxiv.ariyala.com/175YE	147	3237	1641	2416	1049	1400	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				Party Comp
10	Max Crit	http://ffxiv.ariyala.com/179S5	147	3237	1375	2681	994	1450	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				Different Roles	5
11	RDM-BiS Friendly	http://ffxiv.ariyala.com/17S5Y	147	3237	1416	2581	1054	1450	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
12	SMN-BiS Friendly	http://ffxiv.ariyala.com/17S8Q	147	3237	1375	2581	1094	1450	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
13	High Crit	http://ffxiv.ariyala.com/175AD	147	3237	1579	2561	774	1590	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
14	High Crit	http://ffxiv.ariyala.com/175A1	147	3237	1375	2561	914	1650	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
15	High Crit	http://ffxiv.ariyala.com/1761H	147	3237	1131	2461	1094	1810	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
16	1917 w/ Shakshouka	http://ffxiv.ariyala.com/17BM4	147	3237	1421	2194	959	1920	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
17	1917 w/ Ema Datshi	http://ffxiv.ariyala.com/17NAI	147	3237	1154	2328	1094	1921	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
18	High SS	http://ffxiv.ariyala.com/175HT	147	3237	1217	2152	1099	2020	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
19	Max SS	http://ffxiv.ariyala.com/1758O	147	3237	1194	2050	1120	2121	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
20
21	1k crit Pyros Weapon		143	3206	1131	3122	1094	1454	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
22
23	390 Crafted Belt	http://ffxiv.ariyala.com/189GY	147	3229	1309	2672	914	1594	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
24	390 Crafted Belt/Ear	http://ffxiv.ariyala.com/189HB	147	3221	1084	2383	949	2061	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
25
26
27
28
29
30

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	S	T	U	V	W	X	Y
1			Stats (with food, no party)						GCD		LL GCD		Crit (no party)		DH	Det	Average DPS		Gain Over Base Set		Ticks cut short	Skipped F4s/3 min	Downgraded F4s/3 min
2	Gear Description	Link	WD	Int	DH	Crit	Det	SS	2.5s	2.8s	2.5s	2.8s	Rate	Damage	Rate	Damage	Sharp Fire	Sharp Thunder	Sharp Fire	Sharp Thunder	0	0	0

3	No Melds, Diamond Set	http://ffxiv.ariyala.com/14Y87	141	2873	1177	1371	1099	1623	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?			<- Base Set	Party Buffs
4	No Melds, Tome Set	http://ffxiv.ariyala.com/14Y88	141	2873	1222	1286	1308	1450	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				BRD
5	Max Crit, 1392 SS	http://ffxiv.ariyala.com/15GNA	141	2873	1354	2545	728	1392	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?			<- Max Crit Set	DRG
6	Max Crit, 1472 SS	http://ffxiv.ariyala.com/14WQ4	141	2873	1272	2545	728	1472	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				SCH
7	Max Crit, 1592 SS	http://ffxiv.ariyala.com/14V9D	141	2873	1148	2545	728	1592	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				DNC
8	High Crit, 1650 SS	http://ffxiv.ariyala.com/154H1	141	2873	1359	2460	550	1650	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
9	Max SS, High Crit	http://ffxiv.ariyala.com/14XPW	141	2873	787	1670	1033	2520	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				Party Comp
10	Max SS Lower Crit	http://ffxiv.ariyala.com/1568B	141	2873	1067	1390	1033	2520	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?				Different Roles	5
11	1930 SS	http://ffxiv.ariyala.com/14Z0Y	141	2873	1277	2260	550	1930	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
12	Low Crit	http://ffxiv.ariyala.com/15GLN	141	2873	1524	680	1758	2063	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
13	High Crit, 1788 SS	http://ffxiv.ariyala.com/15UY7	141	2873	1447	2362	425	1788	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
14	High Crit, 1868 SS	http://ffxiv.ariyala.com/15UZ6	141	2873	1364	2322	465	1868	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
15	High Crit, 1988 SS	http://ffxiv.ariyala.com/15WV9	141	2873	1364	2202	465	1988	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
16
17	Using new food	http://ffxiv.ariyala.com/16PNI	141	2873	1115	2545	728	1638	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
18	Using new food	http://ffxiv.ariyala.com/16O39	141	2873	1235	2545	728	1516	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
19
20	UwU Sets:
21	UwU example set	https://ffxiv.ariyala.com/1AQXW	141	2915	1802	1500	945	1958	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
22
23
24
25
26
27
28
29
30

	A	B	C
1	Last Updated		Master Sheet Last Updated
2	September 7, 2019		September 7, 2019
3
4	About This
5	This sheet uses the average pps from Dialace's Thunder model and puts it into Orinx's average damage formula to determine relative value of different BLM gearsets
6	It accounts for SS buffing GCD speed and dots, but not direct damage
7	It uses the average of a 3 min convert cycle with sharpcast used on F1 or T3, as well as Ley Lines uptime
8	It adjusts Foul if the average Rotation length becomes less than 30s
9	It accounts for Crit/DH buffs as averaged over the duration
10	To create statistics of a specific gear set page, use the Menu option "Gear Calculator > Create Statistics". It will be output into its own sheet.
11
12	About BiS
13	BLM has no dead stats, so comfort matters a lot
14	More SS helps if unfamiliar with a fight, for movement issues, etc
15	It's also worth mentioning that crit gains value the more crit buffs your party has
16	Battle Litany, Chain Stratagem, Battle Voice and DNC benefit higher crit sets more
17
18	Usage
19	File -> Make a Copy to have an editable version
20	Fill in stats for a gearset. Rest of the columns will autofill
21	Change the BRD, DRG, SCH, DNC dropdowns based on your expected party comp
22	Gains are given in percent terms relative to the gearset in the first row and differ between Sharp Fire and Sharp Thunder
23	Adjust "Ticks Cut Short", "Skipped F4s/3 min" and "Downgraded F4s/3 min" based on your own general play
24	If you want to clear out all of the sets go to the menu "Gear Calculator > Clear Data". It will delete every set on the active spreadsheet
25	If you want to reset the calculations because the sheet is stuck go to "Gear Calculator > Reset Calculations" and reset it.
26
27	Links and Stuff
28	DialaceStarvy's Thunder Model
29	Damage Formula from Orinx's Gear Sheet
30	GCD Formula from Stats Interval Sheet
31	Big thanks to DialaceStarvy for his model
32	Thanks Nemekh and Fryte for formula things and thoughts
33	Thanks Haru and Fürst for testing and improving things
34	Thanks Xenitan, Laferlia, Emiya for sets and help
35	Thanks Laqi for the orginal sheet and layout and making everything pretty
36
37	Contact
38	🐍
39	or ᶘ ᵒᴥᵒᶅ
40
41	Updates
42	February 16, 2018	Updated damage formula for SS on dots
43	February 16, 2018	Added crit/dh buff averaging to estimates
44	March 21, 2018	Added columns for Crit, DH, Det rates/multipliers. Formatting cleanup
45	June 6, 2018	Changed dot tick value to 7%
46	June 19, 2018	Added estimation for caster tax (0.1s added to hardcasts where cast>=recast)
47	September 17, 2018	Messing with 4.4 sets
48	September 29, 2018	Clean up sheet, tag BiS
49	October 22, 2018	Updated to Dialace's model, the most accurate that we have so far
50	October 23, 2018	Clean up scripts
51	October 25, 2018	New functions to calc F3Ps from downgraded F4s properly
52	November 3, 2018	Fix Det scalar display to use Det instead of DH
53	November 5, 2018	Fixed Chain Strategem's and Battle Litany's duration
54	February 14, 2019	Added Eureka sets
55	March 3, 2019	Fixed a bug with the sps scalar to not undervalue ticks like crazy
56	March 19, 2019	Added a little menu to reset values and calculations
57	March 20, 2019	Statistics are now live
58	June 23, 2019	Statistics are now correct...
59	September 7, 2019	5.X updates of the model

	A	B	C	D	E	F	G
1		Expected average DPS		Standard Deviation		Total Spread
2	Gear Description	sharp Fire	sharp Thunder	sharp Fire	sharp Thunder	sharp Fire	sharp Thunder
3	No Melds, Tome Set	8118.63	8162.64	74.05	74.23	-222 +246	-224 +247
4	No Melds, Omega Set	8121.76	8163.66	74.29	74.49	-222 +246	-224 +247
5
6	SMN/RDM-friendly	8633.16	8680.53	80.60	80.81	-236 +262	-237 +263
7	Max Crit	8652.81	8697.70	79.97	80.18	-237 +262	-238 +264
8	1917 w/ Ema Datshi	8653.70	8680.62	78.46	78.57	-237 +262	-238 +263
9
10	Max Crit Eureka	8709.54	8753.60	82.08	82.31	-238 +264	-239 +266
11	1689 Sps Eureka	8712.89	8758.53	82.82	83.04	-237 +265	-239 +266
12	fast Eureka Set	8726.67	8750.90	82.44	82.56	-238 +265	-239 +266
13	full Eureka	8742.99	8790.36	82.33	82.56	-239 +265	-240 +267
14
15	1k crit relic + full eureka	8945.01	8993.15	83.47	83.69	-244 +271	-246 +273
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30