AutoCAD Structural Detailing General DIscussion

AutoCAD Structural Detailing General DIscussion

Reply
*Expert Elite*
StefanoPasquini6790
Posts: 262
Registered: ‎07-06-2011
Message 1 of 9 (788 Views)
Accepted Solution

Personalized bill of material

788 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

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

Distinguished Contributor
CristianLANCULESCU1367
Posts: 103
Registered: ‎11-02-2011
Message 2 of 9 (756 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.

*Expert Elite*
StefanoPasquini6790
Posts: 262
Registered: ‎07-06-2011
Message 3 of 9 (737 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
*Expert Elite*
StefanoPasquini6790
Posts: 262
Registered: ‎07-06-2011
Message 4 of 9 (635 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 (533 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?

*Expert Elite*
StefanoPasquini6790
Posts: 262
Registered: ‎07-06-2011
Message 6 of 9 (523 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 (513 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

*Expert Elite*
StefanoPasquini6790
Posts: 262
Registered: ‎07-06-2011
Message 8 of 9 (510 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 (504 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
 
 
 
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
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.