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