+ Reply to Thread
Results 1 to 4 of 4

Multi level BOM

  1. #1
    Registered User
    Join Date
    07-06-2008
    Location
    dubai
    Posts
    38

    Thumbs up Multi level BOM

    Dear All,
    I have already started with this thread

    http://www.excelforum.com/excel-gene...-material.html

    And we realized that it is better create it with VBA codes because it is complicated.
    It’s a multi product bill of material that will help me to calculate some properties of my recipe, such as pigment %, solid %, cost price…
    What I need is a kind of form that I can use to enter:
    Raw material: ready to use material with fixed price and solid content.
    Assembly: it is an assembly item with a formula that I must enter and that may include items and assemblies.(here is the problem: assembly in assembly in assembly..)
    So, I should start by a form in which I can enter raw materials (item list sheet)
    Than another form to enter defined assemblies (formulas sheet)
    Than a display page (sheet detailed formulas) which will disintegrate the assembly and make a raw materials formula that I can view and analyze.

    NB; the attached file is the result of the previous thread
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186

    Re: Multi level BOM

    Neorez,

    I have done this in Excel but it is a long and complicated process. Especially when you consider all the things you are likely to want to do in the future. I would make a suggestion that Access would be a better route for you. You will probably find good sample BoM databases for Access.

    Regards


    click on the * Add Reputation if this was useful or entertaining.

  3. #3
    Registered User
    Join Date
    07-06-2008
    Location
    dubai
    Posts
    38

    Re: Multi level BOM

    i dont know nothing about access, do you have any template?

    thanks

  4. #4
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,186

    Re: Multi level BOM

    I don't but a google will show up several

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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