AutoCAD Structural Detailing General

Reply
Mentor
StefanoPasquini6790
Posts: 191
Registered: ‎07-06-2011
Message 1 of 9 (724 Views)
Accepted Solution

Personalized bill of material

724 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

PasProStudio
Structural + Detailing engineers
Distinguished Contributor
CristianLANCULESCU1367
Posts: 103
Registered: ‎11-02-2011
Message 2 of 9 (692 Views)

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.

Mentor
StefanoPasquini6790
Posts: 191
Registered: ‎07-06-2011
Message 3 of 9 (673 Views)

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.

PasProStudio
Structural + Detailing engineers
Mentor
StefanoPasquini6790
Posts: 191
Registered: ‎07-06-2011
Message 4 of 9 (571 Views)

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

PasProStudio
Structural + Detailing engineers
Active Member
silvionogueira
Posts: 7
Registered: ‎01-22-2013
Message 5 of 9 (469 Views)

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?

Mentor
StefanoPasquini6790
Posts: 191
Registered: ‎07-06-2011
Message 6 of 9 (459 Views)

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

PasProStudio
Structural + Detailing engineers
Active Member
silvionogueira
Posts: 7
Registered: ‎01-22-2013
Message 7 of 9 (449 Views)

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

Mentor
StefanoPasquini6790
Posts: 191
Registered: ‎07-06-2011
Message 8 of 9 (446 Views)

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!

PasProStudio
Structural + Detailing engineers
Active Member
silvionogueira
Posts: 7
Registered: ‎01-22-2013
Message 9 of 9 (440 Views)

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
 
 
 

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Structural Detailing Category!

The AutoCAD Structural Detailing forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Ask the Community