BOM Template For Excel

[Anonymous]

I've been experimenting with the wd_template.xls file to establish a template when we export our BOM's, but the functionality from this spreadsheet seems pretty limited. I was wondering if anyone here had customized this spreadsheet (more than changing from portrait to landscape as suggested here). I'd like to put our company logo, import some descriptions from the title block and sheets and also apply some conditional formatting that shades every other row, concatenates the descriptions and bolds the titles. Any suggestions are appreciated.

[klonbeck]

Joethr,

My first question is why not use the Bill of Material report? (Reports ribbon > Schematic or Panel pane > Reports > Bill of Material)

In the report generator you can format the report.

As for customizing the spreadsheet (adding logo, row colors and title block descriptions) AutoCAD might be able to do this, but I dont know so instead I have created macros in excel to do the post-processing that I want.

[Anonymous]

I am using the panel bill of material report, the wd_template.xls is the standard spreadsheet that this feature exports ACADE's BOM to. I ended up writing a VBA script for Excel that is tied to this default spreadsheet so when I generate a bill of material in ACADE, export it to excel, we can just run the script and it automatically formats it to our standard (concatenating the descriptions, spacing the rows, bolding titles, applying the project name, etc.).

[Anonymous]

FYI...

This wd_template.xls spreadsheet is also the default spreadsheet used for all exported reports (at least for the wire numbers, cable labels and BOM's), so you can attach multiple scripts to this spreadsheet that can be ran once exported. For example, we have a script for wire numbers, cable labels and BOM's. The wire numbers and cable labels automatically format their spreadsheets to what the panel shop's software needs. Once ACADE exports the spreadsheet, you still have to open it and execute the script, but the 30 seconds it takes to do this is a lot better than 10 minutes it takes to manually format it.

Edit: Assuming you're running ACADE 2015 on Windows 7.

[dougmcalexander]

Can you not format the report the way you want and save as a report format file (.set) that you can recall as needed.  I take this a step further and next all my reports using the Automatic Reports function, so I save a Report Group.  I recall a report group and let the software produce all of my reports at once, whether exported as spreadsheet or added to the project as a drawing.

[Anonymous]

We do have .set files that format our BOM's. Even though all of the descriptions, misc and user fields are entered as a single cell with multiple rows when we place it on the drawing, they do not export in this format.

The only way I've been able to automate the formatting process on an exported report is through VBA scripts in excel.

Sent from my iPhone