This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
reference:tinycad [2015/03/01 19:18] – [Object Libraries] Alan Shea | reference:tinycad [2015/11/23 18:23] – move bill of materials creation to [[tinycad-bom]] page Alan Shea | ||
---|---|---|---|
Line 3: | Line 3: | ||
TinyCAD is our preferred tool for creating electrical circuit diagrams and schematics. Download it from http:// | TinyCAD is our preferred tool for creating electrical circuit diagrams and schematics. Download it from http:// | ||
- | " | + | " |
=====Object Libraries=== | =====Object Libraries=== | ||
Line 24: | Line 24: | ||
- | =====Creating Bill of Materials=== | + | ====Creating Bill of Materials |
- | Creating a useful bill of materials in a repeatable process for many drawings requires a bit of discipline and planning. Here is the process we have worked out. | + | Creating a useful bill of materials in a repeatable process for many drawings requires a bit of discipline and planning. |
- | * Each object in the drawing must have its own unique reference (" | + | [[reference:tinycad-bom|Creating |
- | * Use reference letter prefixes based on [[part_numbers# | + | |
- | * In multi-page drawings, each object must have its own reference | + | |
- | * 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 | + | |
- | * Items like switches often need additional parts linked | + | |
- | * Once the drawings are complete and the design has been saved, open the menu **//Special -> Create Parts List...// | + | |
- | * Set **//Output file//** to "// | + | |
- | * Normally you will check "// | + | |
- | * Click **// | + | |
- | * Right-click and click on **//Select All//**. | + | |
- | * Right-click again and select **// | + | |
- | * Open a new spreadsheet in **Microsoft Excel**. | + | |
- | * Name the worksheets "// | + | |
- | * Click on "Parts List". | + | |
- | * Paste the copied text into Excel. | + | |
- | * Open the **Excel** menu **//Data -> Text to Columns...// | + | |
- | * Select the button for "// | + | |
- | * Uncheck everything but "// | + | |
- | * If you want to adjust column numeric formats click **// | + | |
- | * Delete unneeded columns -- | + | |
- | * Required columns are: **Reference, | + | |
- | * Copy **Quantity** & **PARTID** columns to columns //B// & //C// on //Sheet1//. | + | |
- | * .... (tbc) | + | |
- | ====Updating Bill of Materials=== | ||
- | * step 1 | ||
- | * step 2 | ||
- | * | ||
- | |||
- |