Spreadsheet: 76075d1276646761-picking-numbers-from-a-list-spacer-calculation
Sheet: Sheet1

TOTAL WIDTH | 1220 |  | TOTAL WIDTH |  |  | TOTAL WIDTH |  |  | TOTAL WIDTH |  |  | TOTAL WIDTH |  |  | TOTAL WIDTH |  |  | TOTAL WIDTH
SPACERS | Use? |  | SPACERS | Use? |  | SPACERS | Use? |  | SPACERS | Use? |  | SPACERS | Use? |  | SPACERS | Use? |  | SPACERS | Use?
76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 0 |  | 76.2 | 1
75.95 | 1 |  | 75.95 | 0 |  | 75.95 | 0 |  | 75.95 | 0 |  | 75.95 | 0 |  | 75.95 | 0 |  | 75.95 | 0
50.8 | 0 |  | 50.8 | 0 |  | 50.8 | 0 |  | 50.8 | 0 |  | 50.8 | 0 |  | 50.8 | 0 |  | 50.8 | 0
50.55 | 0 |  | 50.55 | 0 |  | 50.55 | 0 |  | 50.55 | 0 |  | 50.55 | 0 |  | 50.55 | 0 |  | 50.55 | 0
25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 1 |  | 25.15 | 0 |  | 25.15 | 1
18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0
18 | 0 |  | 18 | 0 |  | 18 | 0 |  | 18 | 0 |  | 18 | 0 |  | 18 | 0 |  | 18 | 0
17 | 0 |  | 17 | 0 |  | 17 | 0 |  | 17 | 0 |  | 17 | 0 |  | 17 | 0 |  | 17 | 0
16 | 0 |  | 16 | 0 |  | 16 | 0 |  | 16 | 0 |  | 16 | 0 |  | 16 | 0 |  | 16 | 0
15 | 0 |  | 15 | 0 |  | 15 | 0 |  | 15 | 0 |  | 15 | 0 |  | 15 | 0 |  | 15 | 0
14 | 0 |  | 14 | 0 |  | 14 | 0 |  | 14 | 0 |  | 14 | 0 |  | 14 | 0 |  | 14 | 0
13 | 0 |  | 13 | 0 |  | 13 | 0 |  | 13 | 0 |  | 13 | 1 |  | 13 | 0 |  | 13 | 0
12.44 | 0 |  | 12.44 | 0 |  | 12.44 | 0 |  | 12.44 | 0 |  | 12.44 | 0 |  | 12.44 | 0 |  | 12.44 | 0
11 | 0 |  | 11 | 0 |  | 11 | 0 |  | 11 | 0 |  | 11 | 0 |  | 11 | 0 |  | 11 | 0
6.09 | 1 |  | 6.09 | 0 |  | 6.09 | 0 |  | 6.09 | 0 |  | 6.09 | 0 |  | 6.09 | 0 |  | 6.09 | 0
5 | 0 |  | 5 | 0 |  | 5 | 0 |  | 5 | 0 |  | 5 | 0 |  | 5 | 0 |  | 5 | 0
4 | 0 |  | 4 | 0 |  | 4 | 0 |  | 4 | 0 |  | 4 | 0 |  | 4 | 1 |  | 4 | 1
3 | 0 |  | 3 | 1 |  | 3 | 0 |  | 3 | 0 |  | 3 | 0 |  | 3 | 0 |  | 3 | 0
2.91 | 0 |  | 2.91 | 0 |  | 2.91 | 0 |  | 2.91 | 0 |  | 2.91 | 0 |  | 2.91 | 0 |  | 2.91 | 0
2.79 | 0 |  | 2.79 | 1 |  | 2.79 | 0 |  | 2.79 | 1 |  | 2.79 | 0 |  | 2.79 | 1 |  | 2.79 | 0
2.76 | 0 |  | 2.76 | 1 |  | 2.76 | 0 |  | 2.76 | 0 |  | 2.76 | 0 |  | 2.76 | 0 |  | 2.76 | 1
2.74 | 0 |  | 2.74 | 1 |  | 2.74 | 1 |  | 2.74 | 1 |  | 2.74 | 1 |  | 2.74 | 0 |  | 2.74 | 1
2.71 | 0 |  | 2.71 | 0 |  | 2.71 | 1 |  | 2.71 | 0 |  | 2.71 | 0 |  | 2.71 | 0 |  | 2.71 | 1
2.69 |  |  | 2.69 |  |  | 2.69 |  |  | 2.69 |  |  | 2.69 |  |  | 2.69 |  |  | 2.69
2.66 |  |  | 2.66 |  |  | 2.66 |  |  | 2.66 |  |  | 2.66 |  |  | 2.66 |  |  | 2.66
2.64 |  |  | 2.64 |  |  | 2.64 |  |  | 2.64 |  |  | 2.64 |  |  | 2.64 |  |  | 2.64
2.62 |  |  | 2.62 |  |  | 2.62 |  |  | 2.62 |  |  | 2.62 |  |  | 2.62 |  |  | 2.62
2.58 |  |  | 2.58 |  |  | 2.58 |  |  | 2.58 |  |  | 2.58 |  |  | 2.58 |  |  | 2.58
2.56 |  |  | 2.56 |  |  | 2.56 |  |  | 2.56 |  |  | 2.56 |  |  | 2.56 |  |  | 2.56
2.03 |  |  | 2.03 |  |  | 2.03 |  |  | 2.03 |  |  | 2.03 |  |  | 2.03 |  |  | 2.03
2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2
1.27 |  |  | 1.27 |  |  | 1.27 |  |  | 1.27 |  |  | 1.27 |  |  | 1.27 |  |  | 1.27
1 | 0 |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
[NAME] | 180 |  | [NAME] | 100 |  | [NAME] | 80 |  | [NAME] | 85 |  | [NAME] | 180 |  | [NAME] | 25 |  | [NAME] | 180
Total |  |  | Total |  |  | Total |  |  | Total |  |  | Total |  |  | Total |  |  | Total
Remaining |  |  | Remaining |  |  | Remaining |  |  | Remaining |  |  | Remaining |  |  | Remaining |  |  | Remaining
MATERIAL REMAINING |  |  | MATERIAL REMAINING |  |  | MATERIAL REMAINING |  |  | MATERIAL REMAINING |  |  | MATERIAL REMAINING |  |  | MATERIAL REMAINING |  |  | MATERIAL REMAINING
NUMBER OF STEEL SHIMS AVAILABLE |  | Is it possible to pick from this list which shows the number of steel shims
 |  | available to use - as you go down and pick them it needs to deduct that from the total amount left to pick
76.2 | 12 | which will eliminate this shim being selected if it is no longer available thus moving down to the
75.95 | 8 | next one???
50.8 | 14
50.55 | 6
25.15 | 21
18.8 | 19
18 | 6
17 | 8
16 | 5
15 | 3
14 | 9
13 | 3
12.44 | 19
11 | 1
6.09 | 21
5 | 5
4 | 5
3 | 5
2.91 | 25
2.79 | 10
2.76 | 10
2.74 | 10
2.71 | 10
2.69 | 10
2.66 | 10
2.64 | 10
2.62 | 9
2.58 | 9
2.56 | 6
2.03 | 26
2 | 5
1.27 | 3
1 | 5
 |  |  | next one???