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/11/23 18:20] – [Creating Bill of Materials] Alan Shea | reference:tinycad [2015/12/07 21:55] – merge Alan Shea | ||
---|---|---|---|
Line 1: | Line 1: | ||
======TinyCAD Schematic Editor==== | ======TinyCAD Schematic Editor==== | ||
- | TinyCAD is our preferred tool for creating electrical circuit diagrams and schematics. | + | TinyCAD is our preferred tool for creating electrical circuit diagrams and schematics. |
+ | |||
+ | TinyCAD is an open source " | ||
+ | |||
+ | It is also very easy to create your own symbol libraries to meet your needs. TinyCAD drawings are self-contained -- you do not need the source library to display a drawing with " | ||
+ | |||
+ | TinyCAD can also be used to create printed circuit boards, and can export "net list" information to applications such as [[http:// | ||
+ | |||
+ | * TinyCAD website -- [[http:// | ||
+ | * [[http:// | ||
+ | * Includes an excellent help file and printable PDF manual, as well as extensive symbol libraries, which you can easily edit or create your own libraries. | ||
" | " | ||
Line 27: | Line 37: | ||
Creating a useful bill of materials in a repeatable process for many drawings requires a bit of discipline and planning. | Creating a useful bill of materials in a repeatable process for many drawings requires a bit of discipline and planning. | ||
- | [[tinycad-bom|Creating | + | [[reference:tinycad-bom|Creating |
- | + | ||
- | * Each object in the drawing must have its own unique reference (" | + | |
- | * Use reference letter prefixes based on [[part_numbers# | + | |
- | * 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 "// | + | |
- | * Items like switches often need additional parts linked with a single object; in that case parameters "// | + | |
- | - 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 "// | + | |
- | - 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 | ||
- | * | ||
- |