Auction Draft Helper (original)

	A	B	C	D	E	F	G	H	J	K	M	N	O
1	Name	Position	Age	ADP	Trend	Value	Fair-value price	Amount paid

2	Odell Beckham	WR	24	1.17	0.7	10216	$46.78		You should mess with this part		You shouldn't need to mess with this part
3	Mike Evans	WR	23	2.92	-1	9806	$44.90		League size	12	Total auction money	2400
4	Antonio Brown	WR	29	4.08	0.8	9543	$43.70		Team budget	200	Total rostered players	180
5	David Johnson	RB	25	4.92	-1.3	9358	$42.85		Roster size	15	Sum of player value (for projected rostered players)	524107
6	Julio Jones	WR	28	5.17	1.2	9303	$42.60				Initial dollar to value ratio	0.004579217603
7	Ezekiel Elliott	RB	22	5.33	-1.3	9268	$42.44				Sum of remaining player value (for projected rostered players)	524107
8	Amari Cooper	WR	23	6.92	0.1	8930	$40.89				Remaining auction money	2400
9	Le'Veon Bell	RB	25	7.17	-0.1	8878	$40.65				Dollar to value ratio for remaining players	0.004579217603
10	AJ Green	WR	28	9.67	0	8373	$38.34
11	DeAndre Hopkins	WR	25	10.33	1	8245	$37.76				Instructions
12	Michael Thomas	WR	24	10.75	1.3	8164	$37.38				Instructions
13	Allen Robinson	WR	23	13.5	-2	7655	$35.05				1. Make a copy of the worksheet so that you can edit it.
14	TY Hilton	WR	27	13.75	0.1	7611	$34.85				Click File > Make a copy... Give the new sheet a name if you like. Hit the Okay button. The window will refresh and you'll have an identical sheet that you can edit and use.
15	Sammy Watkins	WR	24	14.42	1.6	7492	$34.31
16	Brandin Cooks	WR	23	18.33	-0.9	6837	$31.31
17	Melvin Gordon	RB	24	18.33	1.4	6837	$31.31
18	Todd Gurley	RB	22	18.75	-1.4	6770	$31.00
19	Dez Bryant	WR	28	19.67	-2.6	6626	$30.34				2. Update the player values (if desired).		Last update was 25 July 2017.
20	Devonta Freeman	RB	25	21	-5.5	6423	$29.41				I copy and pasted the values directly from www.dynastyfftools.com/players. If you want player values from somewhere else, you'll probably need to edit the data. The important part is that the player value ends up in column F.
21	2017 Pick 1	PICK		21	-1	6423	$29.41
22	Corey Davis	WR	22	21	7	6423	$29.41
23	2017 Pick 2	PICK		24	-4	5988	$27.42				3. Update your league settings.
24	Leonard Fournette	RB	22	24	-2	5988	$27.42				This is up above in column J. Set your league size, auction budget and total roster size. Rankings aren't going to include kickers, but don't sweat it--one or two slots one way or the other won't really make a difference.
25	Alshon Jeffery	WR	27	24.08	0.7	5976	$27.37
26	Rob Gronkowski	TE	28	24.17	-1.4	5964	$27.31
27	Jordan Howard	RB	22	25.83	-0.2	5737	$26.27				4. Draft!
28	2017 Early 1st	PICK		27	-2	5647	$25.86				When a player is drafted, type in the amount that was paid in column H in the same row. The "fair value price" of all the other players will adjust accordingly. If players are going for more-than-expected, the prices of the remaining players will drop because there is less money available to spend on them. If players are going for less than expected, prices will rise because owners will have the money for bidding wars.
29	Keenan Allen	WR	25	26.67	-6.2	5625	$25.76
30	Jarvis Landry	WR	24	27	-0.6	5582	$25.56
31	Doug Baldwin	WR	28	30	3.2	5203	$23.83
32	Joe Mixon	RB	21	30.42	17.7	5152	$23.59
33	2017 Pick 3	PICK		30.42	-2	5152	$23.59
34	2018 Pick 1	PICK		25.2	-1	5138	$23.53				About
35	Stefon Diggs	WR	23	30.92	3	5092	$23.32				This sheet is based on the work of /u/big4dawg in Excel. You can report any issues to /u/slodanslodan on reddit.
36	Demaryius Thomas	WR	29	31.17	0.7	5063	$23.18
37	Jay Ajayi	RB	24	31.25	4.5	5053	$23.14
38	2017 Pick 4	PICK		31.5	0	5024	$23.01
39	Christian McCaffrey	RB	21	31.5	12.9	5024	$23.01				Possible enhancements
40	Andrew Luck	QB	27	31.58	0.1	5014	$22.96				Feeling motivated? This sheet currently does nothing with value over replacement, age, or player position. There are probably cool things that could be done with those inputs.
41	2018 Pick 2	PICK		28.8	-5	4790	$21.93
42	Aaron Rodgers	QB	33	34.25	-3.6	4711	$21.57
43	Travis Kelce	TE	27	35.75	3.6	4548	$20.83
44	2018 Early 1st	PICK		32.4	-2	4518	$20.69				Testimonial
45	Jordy Nelson	WR	32	38.58	-8.1	4257	$19.49				This spreadsheet allowed me to get 53% more value in my most recent auction startup draft. The league was composed of owners experienced with dynasty and auctions. The difference between winging it with a good feel for player values and using a calculator like this tool is 50 cents on each dollar.
46	2017 Pick 5	PICK		39.33	-1	4183	$19.15
47	Dalvin Cook	RB	21	39.33	-14.2	4183	$19.15
48	Corey Coleman	WR	23	39.92	-0.5	4125	$18.89
49	2018 Pick 3	PICK		36.5	-2	4122	$18.88
50	Davante Adams	WR	24	40.58	-13.2	4062	$18.60
51	2018 Pick 4	PICK		37.8	0	4019	$18.40
52	LeSean McCoy	RB	29	41.17	-2.9	4006	$18.34
53	Donte Moncrief	WR	23	41.42	-2.4	3983	$18.24
54	DeVante Parker	WR	24	43	6.6	3838	$17.58
55	Lamar Miller	RB	26	44.58	-8.3	3699	$16.94
56	Mike Williams	WR	22	44.67	-0.8	3691	$16.90
57	2017 Pick 6	PICK		44.67	-1	3691	$16.90
58	2019 Early 1st	PICK		38.9	-2	3614	$16.55
59	Derrick Henry	RB	23	47.42	-1.1	3461	$15.85
60	2018 Pick 5	PICK		47.2	-1	3346	$15.32
61	Russell Wilson	QB	28	49.33	4.2	3310	$15.16
62	Carlos Hyde	RB	25	49.58	-8.7	3291	$15.07
63	2017 1st	PICK		59	4	3248	$14.87
64	DeMarco Murray	RB	29	51.33	-0.3	3158	$14.46
65	Terrelle Pryor	WR	28	52.75	-1.1	3055	$13.99
66	Tyler Eifert	TE	26	53.75	17.4	2985	$13.67
67	Jordan Reed	TE	27	54.08	0.6	2962	$13.56
68	2018 Pick 6	PICK		53.6	-1	2953	$13.52
69	2017 Mid 1st	PICK		58	5	2899	$13.28
70	2020 Early 1st	PICK		46.7	-3	2891	$13.24
71	Jamison Crowder	WR	24	56.58	-6.4	2793	$12.79
72	Martavis Bryant	WR	25	58.42	14.6	2676	$12.25
73	2018 1st	PICK		70.8	4	2598	$11.90
74	Josh Doctson	WR	24	59.92	-0.4	2583	$11.83
75	Cam Newton	QB	28	60	-4	2578	$11.81
76	Tevin Coleman	RB	24	61.58	-4.7	2485	$11.38
77	Golden Tate	WR	28	61.92	-0.2	2465	$11.29
78	Tyreek Hill	WR	23	62.75	-0.5	2418	$11.07
79	Jameis Winston	QB	23	63.17	6.4	2394	$10.96
80	Isaiah Crowell	RB	24	64.5	7	2321	$10.63
81	2018 Mid 1st	PICK		69.6	6	2319	$10.62
82	Emmanuel Sanders	WR	30	64.58	2.3	2316	$10.61
83	2021 Early 1st	PICK		56	-4	2313	$10.59
84	Mark Ingram	RB	27	65.5	-11.2	2267	$10.38
85	Randall Cobb	WR	26	65.83	6	2250	$10.30
86	Kelvin Benjamin	WR	26	66.58	-14.2	2210	$10.12
87	Hunter Henry	TE	22	66.67	-7.3	2206	$10.10
88	2019 1st	PICK		85	5	2078	$9.52
89	Jordan Matthews	WR	25	69.67	-12	2056	$9.41
90	Ameer Abdullah	RB	24	69.75	15.4	2052	$9.40
91	Michael Crabtree	WR	29	70.42	-15.2	2020	$9.25
92	Marcus Mariota	QB	23	72	5.8	1947	$8.92
93	Sterling Shepard	WR	24	72	-9.6	1947	$8.92
94	2017 Pick 7	PICK		72.5	8	1924	$8.81
95	OJ Howard	TE	22	72.5	13.2	1924	$8.81
96	2019 Mid 1st	PICK		83.5	7	1855	$8.49
97	CJ Anderson	RB	26	74.25	-15.4	1847	$8.46
98	Kenneth Dixon	RB	23	75	11.9	1815	$8.31
99	2017 Pick 8	PICK		75.42	12	1797	$8.23
100	John Ross	WR	47	75.42	-3.8	1797	$8.23