Untitled spreadsheet

	A	B	C	D	E	F	G	H	I	J	L	M	N	O	P	Q	R	S	T
1
2	Number of Elites	Total MF	USED http://d3mf.webs.com/ FOR MF NUMBERS					Edit boxes this color			DPS Calculator						(2 = Yes, 1 = No)
3	50	300														Dual wielding?	2	<-Still workin on it
4				iLvl 63								Original		New		Weapon Stats		Weapon 1	Weapon 2
5	Total Rares w/MF	60.5		w/MF	w/o MF	NV + MF	NV + no MF				Weapon DPS*	839		839		Min Damage	354.5	347	362
6	Total Rares w/o MF	18.5	Act 1	6.9	0.9	5.8	3.8				Main Stat	1859		2086		Max Damage	807.5	865	750
7	NV Rares w/MF	121.0	Act 2	5.6	1.7	11.3	7.3				IAS/ASI	15		21		Total +x-+x Damage*	37
8	NV Rares w/o MF	79.0	Act 3	9.9	3.0	19.7	12.9				Crit Chance	25		32.5		Total +x-+x Damage*	37
9											Crit Damage	208		231		Weapon APS	1.4	1.4	1.4
10											Mods*	0		0
11	* 1 MF gives an extra 0.0028 rare, per elite
12	Base formula used is:										DPS* =	28,740
13		Number of Elites * ( [ Magic Find .0028]) + (Elites .37)									New DPS =	38,867				-So, three "+6-12" damage rings/jewerly would be "54"
14			*Add number of elites (A3) to account for NV buff (1 guarenteed per elite)								Percent Change =	35.23	DPS Change=		10,126		1.61
15			*The .37 in the formula is for base drop rate with 0 MF
16											If you add...	10 wDPS	10 Stat	1 IAS	1 Crit %	10 Crit Dmg	1% Mod
17											New DPS =	29,083	28,887	28,990	29,134	29,213	29,028
18	Efficiency		MF				MF			MF	Percent Change =	1.19	0.51	0.87	1.37	1.64	1.00
19	Act 1		270	Act 2			0	Act 3		0	DPS Change =	342	147	250	393	473	287
20	Time per run (min)	Avg. # Elites	Elites/hr	Time per run (min)		Avg. # Elites	Elites/hr	Time per run (min)	Avg. 3 Elites	Elites/hr
21	40	20	30	2		1	30	30	10	20	*Mods are things like passive DPS increases, such as steady aim and glass cannon; active increases such as magic weapon or WotB (insanity); or things like '7% increased damage to elites".
22
23	Rares per Hour	33.8		Rares per Hour	11.1			Rares per Hour	7.4
24	iLvl 63 per hour	1.6		iLvl 63 per hour	1.0			iLvl 63 per hour	1.2		DPS = Weapon DPS (1 + ( Stat / 100)) * (1 + (Crit% * Crit Dmg) * (1 + IAS) * (1 + Mod)
25	RpH w/NV	70.1		RpH w/NV	47.4			RpH w/NV	31.6
26	iLvl 63 p/h w/NV	3.4		iLvl 63 p/h w/NV	4.4			iLvl 63 p/h w/NV	5.2		*For Weapon DPS, use weapon stats box on the right. This accounts for +X-+X damage found on rings, ammys, etc.
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100