TeamWARcalculatorExcel

	A	B	C	D	E	F	G	H	I	J	K	L
1
2				Replacement Level of Wins	Pitcher WAR	Position Player WAR	Total WAR Wins	Total WAR Losses
3				48.6	9.315820733	10.93886936	68.85469009	93.14530991
4
5
6
7			Projected Team OBP	Projected Total PA	Calculated Total PA
8			0.338	6317.496285	6317
9	Batting Order
10
11		Name	OBP	% of PA
12	1st	Gregor Blanco	0.360	12.23%	772.896641
13	2nd	Mike Aviles	0.320	11.94%	754.6049643
14	3rd	David DeJesus	0.365	11.66%	736.7305454
15	4th	Billy Butler	0.360	11.40%	720.2545037
16	5th	Wilson Betemit	0.340	11.13%	703.2709864
17	6th	Kila Ka'aihue	0.330	10.85%	685.7348846
18	7th	Alex Gordon	0.340	10.56%	667.2627721
19	8th	Brayan Pena	0.320	10.26%	648.4523426
20	9th	Yuniesky Betancourt	0.300	9.95%	628.2886448
21
22
23
24	OBP multiplier	League Average wOBA	conversion of wOBA to runs	Run to Wins Conversion
25	1.715	0.338	1.15	10.5
26		Name	OBP	SLG	wOBA	Games	PA	Batting WAR	UZR/150	Position Adjustment	Total WAR
27	1B	Billy Butler	0.360	0.475	0.364	109	520	2.858743961	-4.2	-1.25	1.470210628
28		Kila Ka'aihue	0.330	0.400	0.322	53	220	0.4415182885	1	-1.25	0.01851828847
29					0.000			0			0
30					0.000			0			0
31	2B	Mike Aviles	0.320	0.410	0.320	162	754	1.364380952	0	0.25	1.678547619
32					0.000			0			0
33					0.000			0			0
34					0.000			0			0
35	3B	Wilson Betemit	0.340	0.400	0.328	162	703	1.743672878	-12	0.25	0.7405895445
36					0.000			0			0
37					0.000			0			0
38					0.000			0			0
39	SS	Yuniesky Betancourt	0.300	0.400	0.305	162	628	0.3683919945	-8	0.75	0.2893919945
40					0.000			0			0
41					0.000			0			0
42					0.000			0			0
43	LF	Alex Gordon	0.340	0.400	0.328	162	667	1.654380952	3	-0.75	1.144630952
44					0.000			0			0
45					0.000			0			0
46					0.000			0			0
47	CF	Gregor Blanco	0.360	0.360	0.326	162	772	1.793341615	-2	0.25	1.899008282
48					0.000			0			0
49					0.000			0			0
50					0.000			0			0
51	RF	David DeJesus	0.365	0.430	0.352	162	736	3.30615873	4	-0.75	2.81815873
52					0.000			0			0
53					0.000			0			0
54					0.000			0			0
55	C	Brayan Pena	0.320	0.380	0.310	100	448	0.4396521739	0	1.25	1.372985507
56		Lucas May	0.300	0.350	0.288	62	200	-0.1587301587			-0.1587301587
57					0.000			0			0
58					0.000			0			0
59	DH	Kila Ka'aihue	0.330	0.400	0.322	100	442	0.8870503796	0	-1.75	-0.4021162871
60		Billy Butler	0.360	0.475	0.364	53	200	1.099516908	0	-1.75	0.5161835749
61					0.000			0			0
62					0.000			0			0
63	P	All Pitchers	0.100	0.120	0.097	9	27	-0.4485093168	0	0	-0.4485093168
64					0.000			0			0
65					0.000			0			0
66					0.000			0			0
67							6317			Total Hitter WAR =	10.93886936
68
69
70			NL number									NL number
71	Pitcher		0.540									0.58
72	Total Innings Need	Actual Innings	League Win %	League ERA								Reliever Win %
73	1444	1421	0.46	4.46								0.56
74
75	Name	IP	(E)RA/FIPS/xFIPs/SIERA	Win %	WAR	LI	LI total	LI WAR	Total WAR
76	Starters
77	Zack Greinke	210	3.000	0.6709549829	4.922282935	1	210	0	4.922282935
78	Luke Hochevar	210	4.400	0.5063839786	1.082292833	1	210	0	1.082292833
79	Kyle Davies	197	5.340	0.4135634733	-1.016443973	1	197	0	-1.016443973
80	Brian Bannister	210	4.830	0.4620045534	0.0467729128	0.9	189	-0.6970875127	-0.6503145999
81	Sean O'Sullivan	200	4.300	0.5171594811	1.270210691	1	200	0	1.270210691
82		0	0.460	0.9742380429	0	1	0	0	0
83		0	0.460	0.9742380429	0	1	0	0	0
84		0	0.460	0.9742380429	0	1	0	0	0
85	Relievers
86	Joakim Soria	60	2.750	0.7027857485	1.618571656	2	120	0.9519049898	2.570476646
87	Robinson Tejeda	60	3.500	0.609094788	0.9939652532	1.3	78	0.3272985865	1.32126384
88	Gil Meche	60	3.500	0.609094788	0.9939652532	1	60	0.3272985865	1.32126384
89	Blake Wood	60	4.800	0.4649964016	0.03330934416	0.95	57	-0.6333573225	-0.6000479784
90	Kanekoa Texeira	60	4.800	0.4649964016	0.03330934416	0.9	54	-0.6333573225	-0.6000479784
91	Dusty Hughes	60	3.800	0.5734848711	0.7565658076	0.85	51	0.08989914089	0.8464649484
92	Bryan Bullington	34	6.000	0.3575849376	-0.3869013469	0.7	23.8	-0.7646791247	-1.151580472
93		0	0.460	0.9742380429	0	1	0	0	0
94		0	0.460	0.9742380429	0	1	0	0	0
95		0	0.460	0.9742380429	0	1	0	0	0
96		0	0.460	0.9742380429	0	1	0	0	0
97	Total IP	1421				Total LI =	1449.8
98								Total Pitcher WAR =	9.315820733