Today the BOM Gather Spreadsheet hits the store! http://www.pdoteam.com/index.php/store/products/bom-gather-spreadsheet/ To answer your first question, here is what the spreadsheet can do for you. Automate the process of formatting your spreadsheet. Import a query from a database to the pre-formatted spreadsheet. Compare two published spreadsheets and list the differences. By the way, you may be […]
Back into CADWorx Plant today. It may seem that I talk a lot about the BOM in your models, but let’s be honest, the BOM is one of the most important things that is going to go out. Who all uses the BOM? Well, the designer themselves BETTER be looking over the BOM, checkers, maybe an engineer or two, purchasing, the shop will need those to fabricate. The BOM is a VITAL part of the drawing, and anything we can do to better convey the information needed, we should jump on it.
What I want to talk about today is a VERY underutilized column in the BOM called Flag. The Flag uses the BOM Item Type shown below in the bottom right of the CEdit dialog.
Now, I know we’ve all seen those, and wondered, what can I use them for? For those of us that have dug into ISOGEN, we can use these extensively. For the large majority of users however, these are tools that just AREN’T used. The Flag field will append the first 2 letters of whatever is in there to the Flag column of the BOM.
Let’s talk about how else we can use these. This came up during an ISOGEN demo, where the end user used the Erection column to change fittings into Revision items. Not a bad little trick. They had modified ISOGEN to take this to a separate part of the BOM, but the user had to know that Erection=Revision
Enter that English.dic file again. The text shown in this dialog box is contained in that file. I’ve listed below the lines that contain these. These can be dug out using the find command on the English.dic file.
Changes to this will directly relate to the dialog box. I’m going to change the first 3 to show items that are shop assembled, items that are shipped loose, and items that are client supplied.
F0051=SA Shop Assembled
E0224=SL Ship Loose
O0044=CS Client Supplied
After you make these changes, save the .dic file and restart CADWorx Plant.
You’re dialog will now look like this:
Since the flag field pulls the first two letters, by putting the letters that I want first, I get exactly what I want in the Flag Field now. You can also sort the BOM based off the flag field to get Client Supplied items at the bottom of the Bill for example.
Once again, it’s the little things that can mean the difference between a design that conveys exactly what we want, and something that leaves it open to speculation. This is one of those things.
Again, if anything looks confusing, PLEASE don’t hesitate to let me know and as always, I hope this can help you out in your day to day.
Most of what I do is focused around the COADE product line. A lot of what I post is going to be based on the CADWorx line of products.
This little change is a fun one. It’s not exactly for the faint of heart I guess, but it’s not THAT painful either. In CADWorx Plant, you can add weight to your BOM. The great thing about this is that you also get a TOTAL BOM Weight. The downside to this, and anyone who’s put out a Weight on a BOM will understand this, the weight that is figured off of a drawing is WRONG. Nothing against the way we do weight, but there are a lot of variables that aren’t taken into account, coating, weld (in some cases), shipping flanges, etc… It’s a universal habit to take the weight we come up with and add 10%. In CADWorx Plant, although we can’t do this, we can append what the BOM says to indicate that the end user should add 10%. Think of it as covering your tail. The steps are easy, but you have to modify a file that COADE prb doesn’t want you too, but that’s okay 🙂
In the support directory, under your install of CADWorx Plant (or Plant Professional) You’ll find a file called English.dic. Open this file up with Notepad and do a FIND on T0097 . This will take you to a line of text that looks like this:
T0097=TOTAL WEIGHT: %.2f
This is the line of text that get’s appended to bottom of a BOM when you add weight as one of the columns. The %.2f tells the software to append the total weight, to 2 decimal places. Let’s change that line to read:
T0097=TOTAL ESTIMATED WEIGHT +/- 10 PERCENT: %.2f
Now, save the file, restart CADWorx Plant and run a Bill of Materials with the weight column in there. You’ll notice that right there in the BOM is your text.