Millworker Help Printable version
Help / Drawings

Reference Tables

Drawing

The project's MatFin workbook as front page tables: general notes, client refs, finishes, materials, layups, hardware.

Where

Each project keeps one MatFin workbook (for example 261234_MatFin.xlsx) in its project folder, the first folder under the projects root (C:\$Vaults\$EdgeVault\Engineering Data\PROJECT). Its MATFIN sheet is one list, a row per item: EWC CODE, CLIENT CODE, DESCRIPTION, TYPE, SUB TYPE (wood, glass, metal...), INNERGY SKU, and for layups CORE, FACE 1, FACE 2. General notes are the top rows (a description only); everything else is added at the bottom. TYPE is the filter: GENERAL NOTE, FINISH, MATERIAL, LAYUP, HARDWARE, PURCHASED.

The drawings only call out the EWC code. Finishes (paint, laminate...) and materials (core, metal, glass, lumber, edgebands, and veneers: sub type VENEER, numbered VEN01...) are kept apart; a layup puts them together, for example PAN01 = WUD03 + VEN01 + VEN02 (a core and two veneer faces). The client's codes are mapped to ours in the CLIENT CODE column, never used directly.

  1. Pick a group at the top: General notes, Client Ref Mapping, Finishes, Materials, Layups, Hardware, and Panels, Metal, Glass (materials by sub type) and Purchased when they're turned on with Optional tables (beside the groups; also in Settings, References tab): Panels takes sheet goods (a sub type with panel, sheet, MDF, HDF, ply, particleboard, melamine or OSB in it).
  2. Tick a row's box to show it on the front page. The rows the front page's tables already show start ticked; nothing else does. Rows whose code is used by a part in the drawing are marked In drawing. Client Ref Mapping lists every row (those with a client code first) to search and pick from. Untick Use table to leave a group's table off the front page: its rows stay ticked (kept with the drawing) for when you turn it back on.
  3. Click a row (anywhere but its tick box or Edit) to see it in Row info on the right, only the fields its type has. Edit, on the row or under Row info, opens it in a window of its own; + New row, under the list, opens that window empty for the tab you are on (the next free code of its kind filled in). Save in that window writes that row, and only it, to the workbook at once (a note goes after the other notes, everything else at the bottom); Cancel leaves it as it was. To take a row out (a layup too), click it and press Remove row: it says first which layups are made from it and whether the drawing uses it; Save, at the bottom right, then deletes it from the workbook.
  4. Press Update tables: on sheet 1 (the front page) each group with ticked rows gets its table, a group with none ticked (or with Use table off) loses its table, and all of them are stacked down from the top right of the border, in group order.

Layups are made in the assembly (Push to MatFin, Layups tab) and put on parts with Tag Layups: here they're listed and placed in the Layups table, but not added or changed.

Which workbook: the one in the drawing's project folder (the first folder under the projects root), found again each time you open the window, so moving to another project's drawing finds that project's workbook. One picked with Browse is kept only for drawings in its own project. New workbook starts one in the project folder from your template: a MatFin workbook with the general notes and the codes every job uses (set in Settings, References tab, or with Choose… the first time). Its rows are listed ticked; untick any you don't want, or start from another project's workbook, the Material Manager, or an empty one. Vault users are warned to check Vault first, so a project never ends up with two. Add rows from… copies more rows in later, from the template or another workbook: rows it has already (the same code, or a note with the same words) are shown but not added again.

Checks: an EWC code can only be used once. One typed in Row info that another row has already goes red, and the status line says whose it is; Save refuses it, and the sheet is checked again as it's written, so a code someone else added meanwhile is caught too (then nothing is saved). Codes used twice in the sheet itself (typed in Excel) are flagged when the workbook is read. A row needs a description, and every row but a note an EWC code.

Look up: for finishes (PLAM and the like), materials, hardware and purchased items, Row info has a lookup under the description. Material Manager lists its materials, PLAMs, veneers, finishes and edgebands: double-click one to fill the type, sub type, description and INNERGY code. INNERGY shows only when Use INNERGY is ticked in Millworker Settings, References tab, with your email and API key: double-click a result and the SKU goes in its column and INNERGY's name is added to the description. With it unticked, everything works from the Material Manager.

Codes and the Material Manager: each project numbers its own codes (Black Mel 2S can be WUD01 on one job, WUD04 on another). The INNERGY SKU links them: a Material Manager material, PLAM or finish whose INNERGY code is a row's SKU takes that row's code in this project; one with no INNERGY code links by name (the row's description is the material's name, as rows added from the Material Manager are). Assigning it puts that code on the parts, the Material and Finish callouts show it, and Push to MatFin lists it for layups. The Material Manager's Default code is never used: it shows in the DEFAULT CODE column for reference, and a material with no row here has no code until it gets one. To add rows for the materials a job uses, press Add rows from… and pick Material Manager: tick them, and each gets the next free code of its kind with its SKU. Update part codes (at the bottom) gives the drawing's parts this project's codes (their material, and the finishes on their faces) after the workbook changes: it lists each change to confirm, the parts that are read-only, and the materials not in the workbook yet. Then save the parts.

Vault: for Vault users (Settings, References tab, I use Vault; on by default). A checked-in workbook is read-only. It's read as it is, but before anything is written you're asked to check it out in Vault (then Retry). Check it back in when you're done. If someone has it open, you're told to close it there first. Without Vault the same checks are plain file checks: read-only, or not there.

No workbook, or the old one: when the project folder has none, you can make a new one there. A workbook in the old layout (sections headed ###) can be copied into a new one beside it: laminates, veneers, edgebanding, paint and upholstery become finishes, panels, metal, glass and lumber materials, the old TYPE the sub type, and M-numbers the INNERGY SKU. The old workbook is left as it is. A new workbook is a new file: add it to Vault.

Table styles: the schedules keep the eight column positions the EWC styles are made for (CODE, TYPE, NUMBER, DESCRIPTION...), with the sub type as TYPE and the INNERGY SKU as NUMBER. By default General notes uses EWC - 0. GENERAL TABLE, Finishes 1. FINISH TABLE, Materials and Panels 2. MATERIAL TABLE, Hardware 3. HARDWARE TABLE, Purchased 4. ELECTRICAL TABLE, Glass 5. GLASS TABLE and Metal 6. METAL TABLE. Client Ref Mapping (CLIENT CODE, EWC CODE, DESCRIPTION) and Layups (EWC CODE, CORE, FACE 1, FACE 2, DESCRIPTION) keep their own columns whatever the style. Pick others in Settings, References tab.