Spreadsheet: 841407d1693580317-made-a-clculator-for-sawing-would-like-lengths-to-go-into-worksheet-when-entered-asawtest
Sheet: Sheet1

THIS CALC GROUPS AND COUNTS SAWED PARTS OF THE SAME SIZE IF LISTED MULTIPLE TIMES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DROP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PART#
 |  |  |  |  |  |  | TOTAL PART COUNT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STICK LENGTH | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239 | 239
 | ENTER LENGTHS & NUMBER OF PCS |  |  | LENGTH ORDER LONGEST TO SHORTEST |  |  | CALCULATED |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1 | 40 | 40 | 40 | 30
LINE # | LENGTH (IN) | NUMBER OF PCS |  | LENGTH | NUMBER OF PCS |  | LENGTH DESCENDING | PARTS | PARTS |  |  |  |  |  |  | LENGTH | APPERANCES | TOTAL COUNT | UNIQUE |  | TESTING | T2 |  |  |  |  | REMAINING |  | P2 | 40 | 40 | 40 | 30
1 | 10 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 11 |  |  |  |  |  |  | P3 | 40 | 40 | 40 | 30
2 | 30 | 5 |  |  |  |  | 30 |  |  |  |  |  |  | 30 |  |  |  |  |  |  | 99 | 9 |  |  |  |  |  |  | P4 | 40 | 40 | 40 | 30
3 | 40 | 5 |  |  |  |  | 10 |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 54 | 5 |  |  |  |  |  |  | P5 | 40 | 40 | 40 | 30
4 | 40 | 5 |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 75 | 1 |  |  |  |  |  |  | P6 | 30 | 30 | 30 | 30
5 | 30 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89 | 7 |  |  |  |  |  |  | P7 | 0 | 0 |  | 10
6 | 40 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 | 5 |  |  |  |  |  |  | P8 |  |  |  | 10
7 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101 | 3 |  |  |  |  |  |  | P9 |  |  |  | 10
8 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 132 | 8 |  |  |  |  |  |  | P10 |  |  |  | 10
9 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 | 5 |  |  |  |  |  |  | P11 |  |  |  | 10
10 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 | 2 |  |  |  |  |  |  | P12
11 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67 | 7 |  |  |  |  |  |  | P13
12 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5 | 4 |  |  |  |  |  |  | P14
13 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | 1 |  |  |  |  |  |  | P15
14 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 | 9 |  |  |  |  |  |  | P16
15 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 84 | 6 |  |  |  |  |  |  | P17
16 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 3 |  |  |  |  |  |  | P18
17 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 | 1 |  |  |  |  |  |  | P19
18 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 132 | 5 |  |  |  |  |  |  | P20
19 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 | 9 |  |  |  |  |  |  | P21
20 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52 | 8 |  |  |  |  |  |  | P22
21 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 | 5 |  |  |  |  |  |  | P23
22 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 181 | 2 |  |  |  |  |  |  | P24
23 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125 | 1 |  |  |  |  |  |  | P25
24 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 | 4 |  |  |  |  |  |  | P26
25 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72 | 7 |  |  |  |  |  |  | P27
26 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 8 |  |  |  |  |  |  | P28
27 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 | 9 |  |  |  |  |  |  | P29
28 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 3 |  |  |  |  |  |  | P30
29 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71 | 2 |  |  |  |  |  |  | P31
30 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 4 |  |  |  |  |  |  | P32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DROP