Hello,
So far the people here have helped me so much with this it has been amazing. but I have another question. Please see the attached Excel file to understand what I am about to say.
CUTLIST MASTER COPY V2.xlsm
I am looking to add a column to the pivot table on the Material Summery Sheet. This column would be called yield. If you look at the CutList page you will see it is made up of different lengths and qty of different materials. On the material summery page it grabs all of the similar materials converts their lengths to feet, and than totals everything for me. Here's the problem, because of sizes and lengths I need more info than just the total length of material, i need to know how many lengths of said material I need.
Here's an example:
I have one material say: Steel I know that I can only buy steel in 24ft lengths.
On the CutList there are three entry's for steel:
1 qty at 228 in.
3 qty at 156 in.
15 qty at 36 ft.
So in total i have 1236 inches of Steel. Which is 103 ft. Which in theory tells me exactly how much Steel I would need to purchase. But that's where the fun comes in I can only buy steel in 24 ft lengths and those pieces of steel would need to be broken up in a different way to make sure I can cut all my pieces to the same length. In reality I would need more than 103ft of steel.
So I am looking to add a column to the pivot table or a brand new system to show totals that allows me to:
1. Beside each material on the totals list enter a length that it must be broken up into.
2. And than have the program calculate how to best divide said material into said sizes.
My math skills aren't the best but I am sure someone here knows a thing o two about how to do this.
Any help at ALL even suggestions of different ideas are very welcome.
Thankyou so much in advance
Bookmarks