AutoCAD Structural Detailing General

Reply
Distinguished Contributor
StefanoPasquini6790
Posts: 118
Registered: ‎07-06-2011
Message 1 of 9 (675 Views)
Accepted Solution

Personalized bill of material

675 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 (643 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.

Distinguished Contributor
StefanoPasquini6790
Posts: 118
Registered: ‎07-06-2011
Message 3 of 9 (624 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
Distinguished Contributor
StefanoPasquini6790
Posts: 118
Registered: ‎07-06-2011
Message 4 of 9 (522 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
Posts: 7
Registered: ‎01-22-2013
Message 5 of 9 (420 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?

Distinguished Contributor
StefanoPasquini6790
Posts: 118
Registered: ‎07-06-2011
Message 6 of 9 (410 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
Posts: 7
Registered: ‎01-22-2013
Message 7 of 9 (400 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

Distinguished Contributor
StefanoPasquini6790
Posts: 118
Registered: ‎07-06-2011
Message 8 of 9 (397 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
Posts: 7
Registered: ‎01-22-2013
Message 9 of 9 (391 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
Welcome to the new Autodesk Community!
If this is your first visit, click here to get started and make the most of the Community. Let us know what you think of the new experience in the Community Feedback Forum.

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