+ Reply to Thread
Results 1 to 1 of 1

Get total Cut Yield from table of set Qtys, Lengths and materiel lengths?

  1. #1
    Registered User
    Join Date
    02-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    42

    Get total Cut Yield from table of set Qtys, Lengths and materiel lengths?

    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
    Last edited by TomToms; 09-08-2014 at 04:29 PM. Reason: Wrong Title

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Best yield from table
    By sleazyfish in forum Excel General
    Replies: 9
    Last Post: 09-08-2010, 09:37 AM
  2. Bond Yield to Maturity using the Yield function in Excel
    By rahulk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2009, 03:32 PM
  3. Crate a Cross Table with only Total numbers
    By Mido in forum Excel General
    Replies: 9
    Last Post: 08-24-2009, 11:46 PM
  4. Calculating the total various lengths.
    By ldavison10 in forum Excel General
    Replies: 5
    Last Post: 03-18-2008, 09:34 AM
  5. [SOLVED] Finding duplicate entries with matching lengths, total the quantities, delete the extras
    By RShow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2005, 06:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1