Spreadsheet: 841491d1693666295-made-a-clculator-for-sawing-would-like-lengths-to-go-into-worksheet-when-entered-asawtest-denotsy-
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
LINE # | LENGTH (IN) | NUMBER OF PCS |  | LENGTH | NUMBER OF PCS |  | LENGTH DESCENDING | PARTS | PARTS |  |  |  |  |  |  | LENGTH | APPERANCES | TOTAL COUNT | UNIQUE |  | TESTING | T2 |  |  |  |  | REMAINING |  | P1
1 | 10 | 5 |  |  |  |  | 40 |  | 15 |  |  |  |  |  |  |  |  |  |  |  | 48 | 11 |  |  |  |  |  |  | P2
2 | 30 | 5 |  |  |  |  | 30 |  | 9 |  |  |  |  |  |  |  |  |  |  |  | 99 | 9 |  |  |  |  |  |  | P3
3 | 40 | 5 |  |  |  |  | 10 |  | 5 |  |  |  |  |  |  |  |  |  |  |  | 54 | 5 |  |  |  |  |  |  | P4
4 | 40 | 5 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 | 1 |  |  |  |  |  |  | P5
5 | 30 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89 | 7 |  |  |  |  |  |  | P6
6 | 40 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 | 5 |  |  |  |  |  |  | P7
7 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101 | 3 |  |  |  |  |  |  | P8
8 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 132 | 8 |  |  |  |  |  |  | P9
9 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 | 5 |  |  |  |  |  |  | P10
10 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 | 2 |  |  |  |  |  |  | P11
11 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67 | 7 |  |  |  |  |  |  | P12
12 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5 | 4 |  |  |  |  |  |  | P13
13 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | 1 |  |  |  |  |  |  | P14
14 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 | 9 |  |  |  |  |  |  | P15
15 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 84 | 6 |  |  |  |  |  |  | P16
16 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 3 |  |  |  |  |  |  | P17
17 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 | 1 |  |  |  |  |  |  | P18
18 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 132 | 5 |  |  |  |  |  |  | P19
19 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 | 9 |  |  |  |  |  |  | P20
20 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52 | 8 |  |  |  |  |  |  | P21
21 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 | 5 |  |  |  |  |  |  | P22
22 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 181 | 2 |  |  |  |  |  |  | P23
23 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125 | 1 |  |  |  |  |  |  | P24
24 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 | 4 |  |  |  |  |  |  | P25
25 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72 | 7 |  |  |  |  |  |  | P26
26 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 8 |  |  |  |  |  |  | P27
27 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 | 9 |  |  |  |  |  |  | P28
28 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 3 |  |  |  |  |  |  | P29
29 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71 | 2 |  |  |  |  |  |  | P30
30 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 4 |  |  |  |  |  |  | P31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DROP