Spreadsheet: 75975d1276566241-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
76.2 | 1 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0
76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0
76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0
76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 1 |  | 76.2 | 0 |  | 76.2 | 1
76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0 |  | 76.2 | 0
75.95 | 0 |  | 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.8 | 0 |  | 50.8 | 0 |  | 50.8 | 0 |  | 50.8 | 0 |  | 50.8 | 0 |  | 50.8 | 0 |  | 50.8 | 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 | 0
25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0
25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0
25.15 | 1 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0
25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0
18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 1 |  | 18.8 | 1
12.45 | 0 |  | 12.45 | 1 |  | 12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0
12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0
6.1 | 0 |  | 6.1 | 1 |  | 6.1 | 0 |  | 6.1 | 1 |  | 6.1 | 0 |  | 6.1 | 1 |  | 6.1 | 0
2.9 | 0 |  | 2.9 | 1 |  | 2.9 | 0 |  | 2.9 | 0 |  | 2.9 | 0 |  | 2.9 | 0 |  | 2.9 | 1
2 | 0 |  | 2 | 1 |  | 2 | 1 |  | 2 | 1 |  | 2 | 1 |  | 2 | 0 |  | 2 | 1
1 | 0 |  | 1 | 0 |  | 1 | 1 |  | 1 | 0 |  | 1 | 0 |  | 1 | 0 |  | 1 | 1
 | 0
[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???