Differences

This shows you the differences between two versions of the page.

Link to this comparison view

reference:tinycad-bom [2018/05/28 22:29] (current)
Line 1: Line 1:
 +====Creating Bill of Materials with TinyCAD===
 +Creating a useful bill of materials in a repeatable process for many drawings requires a bit of discipline and planning. ​
 +
 +This is the process we have worked out. 
 +
 +  * Each object in the drawing must have its own unique reference ("​Ref"​ in the TinyCAD Tool Options when selecting an object in a drawing).
 +    * Use reference letter prefixes based on [[part_numbers#​part-number-functions]]. ​
 +    * In multi-page drawings, each object must have its own reference number. Using the same reference number on two different objects means that the same object is used in two places, which may be the case at times. ​
 +    * For multi-page drawings which iterations of the same drawing, it is often useful to have all the parts on page one start with 1x or 1xx, and all the part references on page two start with 2x or 2xx, etc. 
 +  * Each object needing listing in the Bill of Materials should have an additional parameter of "//​PARTID//",​ where the value is the //MT-Yxxx// MetaTek part number. //PARTID// should only appear //once// in each ojbect'​s parameter list. 
 +    * Items like switches often need additional parts linked with a single object; in that case parameters "//​OPERATOR//"​ and "//​LABEL//"​ with //MT-// part numbers can also be used. 
 +  - Ordered List Item Once the drawings are complete and the design has been saved, open the menu **//Special -> Create Parts List...//​**.
 +    - Set **//Output file//** to "//​Spreadsheet compatible CSV file//"​. The default output name will be the drawing name with //​.csv//​. ​
 +    - Normally you will check "//​Include all sheets//"​ and "//​Include all attribute information//"​. ​
 +    - Click **//​Export//​**. TinyCAD will save the .csv file and also display it on-screen. ​
 +    - Right-click and click on **//Select All//​**. ​
 +    - Right-click again and select **//​Copy//​**. ​
 +  - Open a new spreadsheet in **Microsoft Excel**. ​
 +  - Name the worksheets "//​BOM//",​ "//​Parts List//"​ and "//​MTParts//"​. (Or use reference file: __MT-BOM.xls__))
 +  - Click on "Parts List"​. ​
 +    - Paste the copied text into Excel. ​
 +    - Open the **Excel** menu **//Data -> Text to Columns...//​**. (The column that was pasted should still be selected. If not you need to select the entire column first.) ​
 +      - Select the button for "//​Delimited//"​ data. Click **//​Next//​**. ​
 +      - Uncheck everything but "//​Semicolon//"​. "//​Text Qualifier//"​ should be **"** (the default). \\  The //Data Preview// should show everything in correct columns. If not, adjust parameters until they are. (Reference numbers should be grouped in one column.) ​
 +      - If you want to adjust column numeric formats click **//​Next//​**,​ otherwise click **//​Finish//​**. ((Note that Excel will preserve these settings until you close the program. If you paste similar data into a new sheet or workbook ("​file"​) Excel will automatically format the text into columns for you. This can be confusing later when its unclear how to get that "​magic"​ to work again. Selecting the data and formatting it from the **//Data -> Text to Columns...//​** menu will re-enable it.)) 
 +    - Delete unneeded columns --
 +      - Required columns are: **Reference,​ Quantity, Description,​ PARTID** optionally also: **LABEL, OPERATOR, COLOR**, others as needed. ​
 +    - Copy **Quantity** & **PARTID** columns to columns //B// & //C// on //​Sheet1//​. ​
 +    - .... (tbc)
  
reference/tinycad-bom.txt · Last modified: 2018/05/28 22:29 (external edit)
 
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
Recent changes RSS feed Donate Powered by PHP Driven by DokuWiki