+ Reply to Thread
Results 1 to 7 of 7

Create a cutting list for a variable sized list of doors, each door consists of 5 parts.

  1. #1
    Registered User
    Join Date
    09-17-2014
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Create a cutting list for a variable sized list of doors, each door consists of 5 parts.

    Hi, I set about yesterday trying to make an excel spreadsheet that would work out a total list of parts that would require cutting to make a batch of doors for a kitchen. I thought it would be relatively easy, but I was sadly mistaken. Lets say the doors in question consist of 2 x 90mm wide stiles (the vertical bits of the doors) of which their lengths are variable. The cross rails (of which there are also x 2 ) would be the door width (eg 596mm) minus 115mm, again variable. The centre panels door height minus 122mm and door width minus 122mm.
    I need to create formulas that will allow me to type in a list of door sizes required and for it to work out the total number of parts at their specific sizes that will be required. I'm not interested in optimisation of waste, all I need is a total list of parts.
    I think this will probably involve the =IF command of which I'm not at all familiar with.

    I'd appreciate it if someone could give me some pointers to get me started.

    Thankyou

    Warren

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,935

    Re: Create a cutting list for a variable sized list of doors, each door consists of 5 part

    Would the doors in a batch all be the same height and width? Is there just one centre panel per door? How wide are the cross rails?
    Last edited by AliGW; 05-01-2016 at 03:37 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,935

    Re: Create a cutting list for a variable sized list of doors, each door consists of 5 part

    Does the attached help at all?

    EDIT: Sorry - struggling to get the file attached at the moment. The forum keeps crashing! I will persevere ...
    Attached Files Attached Files
    Last edited by AliGW; 05-01-2016 at 03:56 AM.

  4. #4
    Registered User
    Join Date
    09-17-2014
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Create a cutting list for a variable sized list of doors, each door consists of 5 part

    All widths and heights are variable and also variable quantities. The sample sheet is great for just one door multiple quantities. However a kitchen door lot will have over 15 different sized doors. I could repeat the formula you have done for each door but would then need to add the common parts together into a single cutting list.
    I've adjusted the sheet and reattached. Well I will in a minute when I figure out how to do it.

    Thanks

    Warren

    I cant figure out how to reattach the excel file, when I click on the attach clip a line appears below but doesn't let me do anything else.
    Last edited by WarrenD; 05-01-2016 at 04:34 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,935

    Re: Create a cutting list for a variable sized list of doors, each door consists of 5 part

    Yes, I understand that, Warren, but if there are lots of different possible dimensions, then you are going to need to enter them somewhere. The cutting list section can be made to compile the results easily enough.

  6. #6
    Registered User
    Join Date
    09-17-2014
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Create a cutting list for a variable sized list of doors, each door consists of 5 part

    This is true, I'll work on that. Thanks for your help.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    50,935

    Re: Create a cutting list for a variable sized list of doors, each door consists of 5 part

    You're welcome! Let us know how you get on and come back if you get stuck.

+ 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. Insert columns based on a variable sized list
    By NickiP in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-09-2014, 12:03 AM
  2. Scan parts OUT to Sheet1, parts IN to Sheet2 and list in Sheet3
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 11:40 AM
  3. How to create a parts number list
    By RangerRSA in forum Excel General
    Replies: 2
    Last Post: 09-21-2011, 07:57 AM
  4. Compiling a cutting list of parts
    By Tommy10 in forum Excel General
    Replies: 0
    Last Post: 05-26-2011, 02:51 PM
  5. Using multi-select for variable list of parts
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-26-2011, 09:03 AM
  6. [SOLVED] Finding the value from the list parts and insert extra part in the list
    By PRADEEPB270 in forum Excel General
    Replies: 3
    Last Post: 10-15-2010, 01:29 PM
  7. [SOLVED] Trying to generate a quantity from a list of doors with varying at
    By JDEllis in forum Excel General
    Replies: 0
    Last Post: 12-09-2005, 06:10 PM

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