• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Structural Detailing

    Reply
    Valued Contributor
    StefanoPasquini6790
    Posts: 67
    Registered: ‎07-06-2011
    Accepted Solution

    Personalized bill of material

    557 Views, 8 Replies
    05-25-2012 10:37 AM

    Hello, I need to create a bill of material such as that found in the annex, I tried manytimes but I can not. Some of you can help me?

     

    Could you explain how to use an .xlt excel file as a basis for creating the list of materials?


    thanks a lot 

     

    Stefano Pasquini

    Please use plain text.
    Valued Contributor
    CristianLANCULESCU1367
    Posts: 84
    Registered: ‎11-02-2011

    Re: Personalized bill of material

    05-29-2012 06:45 AM in reply to: StefanoPasquini6790

    If you could translate thoose in English, maybe we can tell you what you can and what you cannot add in you table.

    Please use plain text.
    Valued Contributor
    StefanoPasquini6790
    Posts: 67
    Registered: ‎07-06-2011

    Re: Personalized bill of material

    06-04-2012 12:26 AM in reply to: CristianLANCULESCU1367

    HI,

     

    i'm sorry for my delay, but i had any problems in last days. Attached below the excel file with the english translation of the required property for my personalized bill of material.

     

    Regard and thank you.

    Please use plain text.
    Valued Contributor
    StefanoPasquini6790
    Posts: 67
    Registered: ‎07-06-2011

    Re: Personalized bill of material

    01-10-2013 02:39 AM in reply to: StefanoPasquini6790

    Hi everyone,

     

    I've resolved with a VBA Macro for Excel, that transform the original BOM in a required one. If someone is interested to resolve the same issue, or a similar one, I can help you, obviously for free!

     

    Greetings

    Please use plain text.
    Active Member
    Posts: 7
    Registered: ‎01-22-2013

    Re: Personalized bill of material

    01-22-2013 03:48 AM in reply to: StefanoPasquini6790

    Hello

    I have the same problem, how did you manage to solve?

    Please use plain text.
    Valued Contributor
    StefanoPasquini6790
    Posts: 67
    Registered: ‎07-06-2011

    Re: Personalized bill of material

    01-22-2013 05:40 AM in reply to: silvionogueira

    Hi,

     

    if you can better specify me what you really want to have in your BOM (cut list), I can tell you if I can help you.

     

    Greetings

    Please use plain text.
    Active Member
    Posts: 7
    Registered: ‎01-22-2013

    Re: Personalized bill of material

    01-22-2013 07:42 AM in reply to: StefanoPasquini6790

    What will I use most, is cut list of plates and profiles.

    The precise position, quantity, profile, length, weight and area

    In short, it's like I show in the appendix, the biggest problem that I am showing is that the table does not interrupt the Rhodope, and when it goes to the second sheet, there will be continued last position of the first sheet should be hidden behind the header

    Please use plain text.
    Valued Contributor
    StefanoPasquini6790
    Posts: 67
    Registered: ‎07-06-2011

    Re: Personalized bill of material

    01-22-2013 07:50 AM in reply to: silvionogueira

    You can't plot in excel the table? Only in this case I can help you!

    Please use plain text.
    Active Member
    Posts: 7
    Registered: ‎01-22-2013

    Re: Personalized bill of material

    01-22-2013 08:14 AM in reply to: StefanoPasquini6790

    I can export to the format "csv" but header is unformatted
    I do not know is to use the template.
    Can you explain to me how to use template, export or straight?
    When I export to "CSV" is thus, as I show in the Annex.

     
     
    Anular edições
    Alpha
     
     
     
    Please use plain text.