Spreadsheet: 583380d1532418956-maximise-player-score-but-limit-team-cost-football-analysis
Sheet: Sheet1

Player ID | Position | Cost Today | Total Points |  |  | Players | Position | Cost | Points |  | Max Team Value | 87
253 | MID | 13 | 303 |  |  | 400 | GK | 4.5 | 157
270 | MID | 11 | 229 |  |  | 113 | DEF | 6.5 | 175
372 | FWD | 12.5 | 217 |  |  | 356 | DEF | 6 | 143
273 | MID | 10 | 209 |  |  | 4 | DEF | 5.5 | 132
364 | MID | 9.5 | 199 |  |  | 223 | MID | 9 | 195
223 | MID | 9 | 195 |  |  | 367 | MID | 8.5 | 178
234 | FWD | 9 | 183 |  |  | 365 | MID | 9 | 175
257 | FWD | 9.5 | 181 |  |  | 271 | MID | 8.5 | 169
275 | MID | 9.5 | 179 |  |  | 234 | FWD | 9 | 183
367 | MID | 8.5 | 178 |  |  | 257 | FWD | 9.5 | 181
365 | MID | 9 | 175 |  |  | 306 | FWD | 11 | 162
113 | DEF | 6.5 | 175
122 | MID | 10.5 | 173
282 | GK | 6 | 172
271 | MID | 8.5 | 169
280 | FWD | 11 | 169
115 | DEF | 6.5 | 165
59 | MID | 7 | 164
306 | FWD | 11 | 162
260 | GK | 5.5 | 158
400 | GK | 4.5 | 157
264 | DEF | 6.5 | 156
462 | MID | 7.5 | 155
295 | MID | 10.5 | 152
68 | GK | 5 | 152
251 | MID | 9.5 | 147
288 | DEF | 6.5 | 146
47 | GK | 4.5 | 146
154 | GK | 5 | 145
417 | FWD | 7 | 144
150 | MID | 6.5 | 144
351 | GK | 5.5 | 144
356 | DEF | 6 | 143
302 | MID | 8 | 138
265 | DEF | 6.5 | 138
22 | FWD | 9.5 | 138
355 | DEF | 6 | 138
151 | FWD | 7 | 136
390 | MID | 6 | 136
111 | GK | 5.5 | 136
191 | GK | 4.5 | 135
4 | DEF | 5.5 | 132
117 | DEF | 6 | 131
14 | MID | 7.5 | 130
124 | MID | 7.5 | 130
5 | DEF | 5.5 | 130
300 | MID | 7 | 128
281 | FWD | 10.5 | 126
393 | MID | 6.5 | 125
301 | MID | 7.5 | 125
326 | FWD | 6.5 | 124
1 | GK | 5 | 124
284 | DEF | 6 | 123
213 | GK | 5 | 123
445 | GK | 4.5 | 123
134 | FWD | 9 | 122
149 | MID | 6 | 121
272 | MID | 5.5 | 120
402 | DEF | 5.5 | 118
76 | MID | 6 | 117
220 | DEF | 5.5 | 117
317 | MID | 6 | 116
312 | DEF | 5 | 116
285 | DEF | 5.5 | 116
118 | DEF | 6 | 115
357 | DEF | 6 | 113
199 | MID | 5.5 | 113
13 | MID | 8.5 | 112
276 | MID | 7.5 | 112
24 | GK | 4.5 | 112
247 | DEF | 6 | 111
62 | FWD | 6.5 | 111
45 | FWD | 6.5 | 110
239 | DEF | 5 | 110
17 | MID | 5.5 | 109
7 | DEF | 5.5 | 109
8 | DEF | 5 | 108
18 | MID | 7 | 107
224 | MID | 5.5 | 107
195 | DEF | 4.5 | 107
359 | DEF | 6 | 107
414 | MID | 6.5 | 106
305 | FWD | 7 | 104
87 | FWD | 6.5 | 104
330 | DEF | 5 | 103
31 | DEF | 5 | 102
43 | FWD | 6 | 102
192 | DEF | 4.5 | 102
71 | DEF | 5 | 102
61 | MID | 6 | 101
126 | MID | 5 | 101
147 | MID | 5 | 101
72 | DEF | 5 | 101
297 | MID | 6.5 | 100
266 | DEF | 5.5 | 100
49 | DEF | 4.5 | 100
82 | MID | 5 | 100
3 | DEF | 5.5 | 100
138 | DEF | 4.5 | 99
135 | GK | 4.5 | 99
293 | DEF | 6 | 98
40 | MID | 5.5 | 97
48 | DEF | 4.5 | 97
172 | MID | 7.5 | 96
142 | DEF | 5.5 | 95
248 | MID | 6.5 | 94
28 | DEF | 4.5 | 94
325 | FWD | 6 | 94
210 | FWD | 5.5 | 94
419 | FWD | 6.5 | 93
211 | FWD | 6 | 92
85 | FWD | 6 | 92
296 | MID | 5 | 91
405 | DEF | 4.5 | 90
70 | DEF | 5 | 90
15 | MID | 5.5 | 89
123 | MID | 6.5 | 89
69 | DEF | 5 | 89
175 | FWD | 5.5 | 88
310 | DEF | 4.5 | 88
55 | MID | 5.5 | 88
238 | GK | 5 | 88
23 | FWD | 11 | 87
60 | MID | 5 | 87
56 | MID | 4.5 | 87
168 | MID | 5 | 87
412 | MID | 5 | 86
242 | DEF | 5 | 86
38 | MID | 5.5 | 85
332 | DEF | 4.5 | 85
361 | MID | 5 | 85
252 | MID | 5.5 | 85
78 | MID | 5.5 | 85
152 | FWD | 6.5 | 84
338 | MID | 5.5 | 84
411 | MID | 5 | 84
50 | DEF | 4.5 | 84
176 | FWD | 5.5 | 83
245 | DEF | 5 | 83
27 | DEF | 4.5 | 83
35 | MID | 5 | 82
156 | DEF | 5.5 | 82
274 | MID | 5.5 | 82
203 | MID | 5 | 82
391 | MID | 6 | 81
143 | DEF | 5 | 81
125 | MID | 6.5 | 81
162 | DEF | 5 | 81
243 | DEF | 5 | 81
225 | MID | 5.5 | 80
395 | FWD | 6 | 79
119 | DEF | 5.5 | 79
320 | MID | 5.5 | 78
227 | MID | 5 | 78
222 | DEF | 5 | 78
244 | DEF | 4.5 | 78
246 | DEF | 6 | 78
132 | MID | 5.5 | 77
254 | MID | 5.5 | 77
360 | DEF | 6 | 77
129 | MID | 5 | 77
133 | FWD | 8 | 77
403 | DEF | 4.5 | 77
235 | FWD | 5.5 | 76
331 | DEF | 4.5 | 76
36 | MID | 6 | 75
249 | MID | 5.5 | 75
58 | MID | 5 | 74
336 | DEF | 4.5 | 74
200 | MID | 5 | 74
114 | DEF | 5.5 | 74
318 | MID | 5.5 | 73
324 | MID | 5 | 73
396 | FWD | 6 | 73
329 | GK | 4.5 | 73
378 | DEF | 4.5 | 72
343 | MID | 5.5 | 72
348 | FWD | 6 | 72
399 | GK | 4.5 | 72
337 | MID | 5 | 71
21 | FWD | 6.5 | 70
319 | MID | 5 | 70
262 | DEF | 5.5 | 70
327 | FWD | 5 | 69
410 | MID | 4.5 | 68
380 | DEF | 4.5 | 68
339 | MID | 4.5 | 68
237 | GK | 5 | 67
314 | DEF | 4.5 | 66
169 | MID | 5.5 | 66
349 | FWD | 6 | 66
83 | MID | 5 | 65
219 | DEF | 5 | 65
383 | DEF | 4.5 | 65
311 | DEF | 4.5 | 64
373 | GK | 4.5 | 64
84 | FWD | 5.5 | 63
51 | DEF | 4.5 | 63
164 | MID | 6.5 | 62
415 | MID | 7 | 62
77 | MID | 5.5 | 62
215 | DEF | 4.5 | 61
46 | FWD | 6 | 60
263 | DEF | 5.5 | 60
158 | DEF | 4.5 | 60
193 | DEF | 4.5 | 60
381 | DEF | 5 | 59
37 | MID | 5 | 59
388 | MID | 5 | 58
39 | MID | 5 | 58
120 | DEF | 5.5 | 58
344 | MID | 5 | 58
369 | MID | 5 | 58
333 | DEF | 4.5 | 58
228 | MID | 5 | 58
382 | DEF | 4.5 | 58
73 | DEF | 4.5 | 57
216 | DEF | 4.5 | 57
307 | GK | 4.5 | 57
79 | MID | 5.5 | 56
29 | DEF | 4.5 | 56
26 | DEF | 4.5 | 56
159 | DEF | 4.5 | 56
363 | MID | 6.5 | 55
269 | DEF | 5.5 | 55
341 | MID | 5.5 | 55
163 | DEF | 4.5 | 55
177 | FWD | 7 | 55
291 | DEF | 5.5 | 55
217 | DEF | 4.5 | 55
236 | FWD | 6 | 54
413 | MID | 4.5 | 54
392 | MID | 5 | 53
347 | FWD | 5 | 53
309 | GK | 5 | 53
201 | MID | 4.5 | 53
240 | DEF | 4.5 | 52
362 | MID | 5 | 52
328 | GK | 4.5 | 52
167 | MID | 4.5 | 52
313 | DEF | 4.5 | 52
458 | MID | 5 | 51
321 | MID | 5 | 51
197 | DEF | 4.5 | 51
207 | MID | 5 | 51
161 | DEF | 4.5 | 50
141 | DEF | 4.5 | 50
194 | DEF | 4.5 | 50
322 | MID | 5 | 49
315 | DEF | 4.5 | 49
389 | MID | 5 | 48
286 | DEF | 5 | 48
298 | MID | 5 | 47
292 | DEF | 5 | 47
447 | MID | 5 | 46
212 | FWD | 5 | 46
209 | FWD | 4.5 | 44
299 | MID | 5 | 44
63 | FWD | 5 | 43
353 | DEF | 6 | 43
401 | DEF | 4.5 | 42
377 | DEF | 4.5 | 42
196 | DEF | 4 | 41
441 | DEF | 4.5 | 41
323 | MID | 4.5 | 41
406 | DEF | 4.5 | 41
206 | MID | 5 | 40
157 | DEF | 5.5 | 39
340 | MID | 4.5 | 39
259 | FWD | 5 | 38
52 | DEF | 4 | 38
160 | DEF | 4.5 | 37
418 | FWD | 5.5 | 36
44 | FWD | 5 | 36
136 | GK | 4 | 36
148 | MID | 5 | 36
80 | MID | 4.5 | 35
165 | MID | 6 | 35
268 | DEF | 5.5 | 35
140 | DEF | 4 | 34
308 | GK | 4.5 | 33
75 | DEF | 4.5 | 33
116 | DEF | 5.5 | 32
139 | DEF | 4.5 | 32
366 | MID | 5 | 32
34 | MID | 4.5 | 32
368 | MID | 5.5 | 31
198 | DEF | 4.5 | 30
416 | MID | 4.5 | 29
384 | DEF | 4.5 | 28
290 | DEF | 5 | 28
204 | MID | 4.5 | 28
6 | DEF | 4.5 | 27
289 | DEF | 5 | 27
33 | MID | 5 | 27
229 | MID | 4.5 | 26
394 | MID | 5.5 | 25
20 | MID | 4.5 | 25
57 | MID | 4.5 | 25
354 | DEF | 6 | 24
397 | FWD | 5 | 24
128 | MID | 5 | 24
231 | MID | 5 | 23
287 | DEF | 5 | 23
9 | DEF | 4.5 | 23
74 | DEF | 4.5 | 23
144 | DEF | 4.5 | 23
16 | MID | 4.5 | 22
379 | DEF | 4.5 | 22
335 | DEF | 4 | 22
371 | FWD | 6 | 22
202 | MID | 4.5 | 22
232 | MID | 5 | 21
303 | MID | 4.5 | 21
267 | DEF | 6 | 20
316 | DEF | 4 | 20
53 | DEF | 4 | 20
258 | FWD | 5.5 | 18
173 | MID | 5 | 18
65 | FWD | 5.5 | 16
279 | MID | 5 | 16
350 | FWD | 5.5 | 15
145 | DEF | 4 | 15
121 | DEF | 5.5 | 14
334 | DEF | 4 | 14
376 | DEF | 4.5 | 14
358 | DEF | 4.5 | 13
230 | MID | 4.5 | 13
387 | MID | 4.5 | 13
250 | MID | 7 | 13
226 | MID | 4.5 | 13
370 | MID | 7 | 11
146 | MID | 4.5 | 11
112 | GK | 5 | 11
205 | MID | 4.5 | 10
170 | MID | 5.5 | 10
261 | GK | 5 | 10
190 | GK | 4 | 9
86 | FWD | 4.5 | 9
277 | MID | 5 | 8
342 | MID | 4.5 | 8
153 | FWD | 5 | 8
67 | GK | 5 | 8
241 | DEF | 5 | 7
171 | MID | 6 | 7
375 | DEF | 4.5 | 7
283 | GK | 5 | 7
174 | MID | 4.5 | 7
166 | MID | 4.5 | 6
404 | DEF | 4.5 | 5
278 | MID | 5 | 5
19 | MID | 4.5 | 5
214 | GK | 4.5 | 4
10 | DEF | 5 | 4
398 | FWD | 4.5 | 4
127 | MID | 6 | 3
30 | DEF | 4.5 | 3
352 | GK | 5 | 3
81 | MID | 5 | 3
420 | FWD | 5 | 3
131 | MID | 4.5 | 2
64 | FWD | 4.5 | 2
218 | DEF | 4 | 1
41 | MID | 4.5 | 1
130 | MID | 4.5 | 1
32 | DEF | 4 | 1
407 | DEF | 4.5 | 1
443 | DEF | 4.5 | 1
256 | MID | 7.5 | 0
453 | MID | 7 | 0
465 | MID | 7 | 0
184 | MID | 6.5 | 0
233 | MID | 6.5 | 0
346 | MID | 6.5 | 0
432 | MID | 6.5 | 0
255 | MID | 6 | 0
304 | MID | 6 | 0
12 | DEF | 5.5 | 0
99 | MID | 5.5 | 0
101 | MID | 5.5 | 0
110 | FWD | 5.5 | 0
185 | MID | 5.5 | 0
456 | MID | 5.5 | 0
468 | GK | 5.5 | 0
294 | DEF | 5.5 | 0
345 | MID | 5.5 | 0
434 | MID | 5.5 | 0
437 | FWD | 5.5 | 0
2 | GK | 5 | 0
11 | DEF | 5 | 0
450 | MID | 5 | 0
42 | MID | 5 | 0
66 | FWD | 5 | 0
466 | MID | 5 | 0
90 | DEF | 5 | 0
98 | MID | 5 | 0
100 | MID | 5 | 0
106 | MID | 5 | 0
107 | FWD | 5 | 0
459 | MID | 5 | 0
444 | FWD | 5 | 0
182 | MID | 5 | 0
221 | DEF | 5 | 0
463 | DEF | 5 | 0
446 | MID | 5 | 0
408 | DEF | 5 | 0
424 | DEF | 5 | 0
433 | MID | 5 | 0
435 | MID | 5 | 0
438 | FWD | 5 | 0
451 | MID | 4.5 | 0
54 | DEF | 4.5 | 0
440 | DEF | 4.5 | 0
88 | GK | 4.5 | 0
89 | GK | 4.5 | 0
91 | DEF | 4.5 | 0
92 | DEF | 4.5 | 0
94 | DEF | 4.5 | 0
102 | MID | 4.5 | 0
103 | MID | 4.5 | 0
104 | MID | 4.5 | 0
105 | MID | 4.5 | 0
108 | FWD | 4.5 | 0
109 | FWD | 4.5 | 0
467 | DEF | 4.5 | 0
137 | GK | 4.5 | 0
178 | GK | 4.5 | 0
180 | DEF | 4.5 | 0
181 | DEF | 4.5 | 0
183 | MID | 4.5 | 0
186 | MID | 4.5 | 0
187 | MID | 4.5 | 0
188 | MID | 4.5 | 0
189 | FWD | 4.5 | 0
455 | DEF | 4.5 | 0
460 | DEF | 4.5 | 0
208 | MID | 4.5 | 0
461 | DEF | 4.5 | 0
457 | GK | 4.5 | 0
452 | GK | 4.5 | 0
374 | GK | 4.5 | 0
385 | DEF | 4.5 | 0
386 | DEF | 4.5 | 0
409 | DEF | 4.5 | 0
464 | DEF | 4.5 | 0
421 | GK | 4.5 | 0
423 | DEF | 4.5 | 0
425 | DEF | 4.5 | 0
426 | DEF | 4.5 | 0
430 | DEF | 4.5 | 0
431 | DEF | 4.5 | 0
436 | MID | 4.5 | 0
448 | MID | 4.5 | 0
449 | FWD | 4.5 | 0
454 | GK | 4.5 | 0
25 | GK | 4 | 0
179 | GK | 4 | 0
439 | GK | 4 | 0
93 | DEF | 4 | 0
95 | DEF | 4 | 0
96 | DEF | 4 | 0
97 | DEF | 4 | 0
442 | DEF | 4 | 0
155 | GK | 4 | 0
422 | GK | 4 | 0
427 | DEF | 4 | 0
428 | DEF | 4 | 0
429 | DEF | 4 | 0