Hi, I have a program that generates a cut list of materials depending on size and type of unit. Now the guys just take the files and manually aggregate it. I would like to do this programatically. I want to sum the quantity where the width, length, thick, and Matl. match. Red totals 20 parts. I would send the file but it seems I can't attach one.
Thank You!
<tbody>
</tbody>
Thank You!
ITEM | QTY | WIDTH | LENGTH | THICK | MATL |
1 | 4 | 23 | 42 | 13/16 | Solid Ash |
2 | 2 | 26 3/8 | 32 7/8 | 3/4 | Oak Ply |
3 | 2 | 16 3/4 | 32 7/8 | 3/4 | Oak Ply |
4 | 2 | 3 | 32 3/8 | 3/4 | Solid Ash |
5 | 2 | 2 3/4 | 32 3/8 | 3/4 | Solid Ash |
6 | 2 | 1 1/2 | 32 3/8 | 3/4 | Birch Ply |
7 | 4 | 1 3/4 | 32 3/8 | 3/4 | Birch Ply |
8 | 4 | 2 | 9 1/2 | 1 1/4 | Hardwood |
9 | 4 | 1 1/2 | 19 1/2 | 3/4 | Birch Ply |
10 | 2 | 14 1/2 | 29 3/8 | 1/2 | CDX Plywood |
1 | 4 | 23 | 42 | 13/16 | Solid Ash |
2 | 2 | 26 3/8 | 46 7/8 | 3/4 | Oak Ply |
3 | 2 | 16 3/4 | 46 7/8 | 3/4 | Oak Ply |
4 | 2 | 3 | 46 3/8 | 3/4 | Solid Ash |
5 | 2 | 2 3/4 | 46 3/8 | 3/4 | Solid Ash |
6 | 2 | 1 1/2 | 46 3/8 | 3/4 | Birch Ply |
7 | 4 | 1 3/4 | 46 3/8 | 3/4 | Birch Ply |
8 | 4 | 2 | 9 1/2 | 1 1/4 | Hardwood |
9 | 4 | 1 1/2 | 19 1/2 | 3/4 | Birch Ply |
10 | 2 | 14 1/2 | 43 3/8 | 1/2 | CDX Plywood |
1 | 8 | 23 | 42 | 13/16 | Solid Ash |
2 | 4 | 26 3/8 | 52 7/8 | 3/4 | Oak Ply |
3 | 4 | 16 3/4 | 52 7/8 | 3/4 | Oak Ply |
4 | 4 | 3 | 52 3/8 | 3/4 | Solid Ash |
5 | 4 | 2 3/4 | 52 3/8 | 3/4 | Solid Ash |
6 | 4 | 1 1/2 | 52 3/8 | 3/4 | Birch Ply |
7 | 8 | 1 3/4 | 52 3/8 | 3/4 | Birch Ply |
8 | 8 | 2 | 9 1/2 | 1 1/4 | Hardwood |
9 | 8 | 1 1/2 | 19 1/2 | 3/4 | Birch Ply |
10 | 4 | 14 1/2 | 49 3/8 | 1/2 | CDX Plywood |
1 | 8 | 23 | 42 | 13/16 | Solid Ash |
2 | 4 | 26 3/8 | 64 7/8 | 3/4 | Oak Ply |
3 | 4 | 16 3/4 | 64 7/8 | 3/4 | Oak Ply |
4 | 4 | 3 | 64 3/8 | 3/4 | Solid Ash |
5 | 4 | 2 3/4 | 64 3/8 | 3/4 | Solid Ash |
6 | 4 | 1 1/2 | 64 3/8 | 3/4 | Birch Ply |
7 | 8 | 1 3/4 | 64 3/8 | 3/4 | Birch Ply |
8 | 8 | 2 | 9 1/2 | 1 1/4 | Hardwood |
9 | 8 | 1 1/2 | 19 1/2 | 3/4 | Birch Ply |
10 | 4 | 14 1/2 | 61 3/8 | 1/2 | CDX Plywood |
<tbody>
</tbody>
Last edited by a moderator: