Millworker Help Printable version
Help / Materials

Push to MatFin

Assembly

Set up the project's references in its MatFin workbook: the assembly's materials come in to match to INNERGY, rows are changed, layups made, then one Save.

Where

This is where the project's references are set up: the materials, finishes and layups the reference document (Reference Tables) shows. The Materials panel runs left to right: assign materials and finishes from the Material Manager (that's just the preset), set the project's references here, then put the layups on parts with Tag Layups. INNERGY is used only when Use INNERGY is ticked in Millworker Settings, References tab (with your email and API key); the Vault steps only when I use Vault is ticked there.

  1. Click Push to MatFin. A workbook that's checked in (read-only) is caught when you save a row: check it out in Vault, then save again.
  2. The window shows the workbook a tab per group (General notes, Client Ref Mapping, Finishes, Materials, Layups, Hardware…), the workbook's full path above. The assembly's materials come in by themselves: every material (or PLAM), veneer, finish and edgeband its parts use that the workbook hasn't got (by INNERGY SKU, else type and description) is added as a row marked New · from the assembly, with the next free code of its kind. With INNERGY on, one INNERGY has takes INNERGY's name; one it hasn't got is marked Not in INNERGY: look it up. Edit it: the lookup is turned to INNERGY with its name typed in; double-click the match and its SKU and name go on the row.
  3. See a row: click it. Row info on the right shows it, only the fields its type has (a layup's core and faces spelled out by name), with Edit and Remove row under it. Changing tab clears it.
  4. Change a row: Edit, on the row (or under Row info), opens it in a window of its own with the fields its type has: sub type (pick from the usual ones or type), EWC code, client code, description, the INNERGY SKU (only with Use INNERGY ticked), and a lookup in the Material Manager or INNERGY. OK keeps the change in the window (nothing goes to Excel yet); Cancel puts it back as it was.
  5. Add a row: + New row, under the list, opens the same window, empty, for the tab you're on. The next free code of its kind is filled in. OK adds it to the list, marked new.
  6. Make a layup: on the Layups tab, + New row, then the Core (a material) and Face 1 and Face 2 (finishes): type a code, or press … beside the box (or double-click it) for a window listing them with their code, description, sub type and SKU; search it, then double-click one or press Use it. A finish that isn't in the workbook yet: + New finish… in that window adds it to the list and puts it in the box. OK on the layup keeps it; Cancel drops it (the new finish stays). Then put it on parts with Tag Layups.
  7. Save, at the bottom right, writes every change to the workbook in one go, one trip through Excel: rows added, changed and removed, and the rows brought in from the assembly. It shows how many are waiting, Save (3). Closing with some waiting asks whether to save them.
  8. Update part codes gives the assembly's parts this project's codes after the workbook changes. Check the workbook back in to Vault when you're done.
The workbook goes into Vault with the project's files. Every part, assembly and drawing saved in a project folder is linked to that project's MatFin workbook (you'll see it in the file's model browser). Vault counts it as one of the file's references: check in a file and the workbook goes in with it; get or check out a file and the workbook comes back with it. The link is added as the file is saved, so an opened file isn't changed; an older file picks it up the next time it's saved. With no workbook in the project folder, nothing is linked. A link to another project's workbook (a copied project) is replaced by this project's.

Checks on Save: every row needs a description, every row but a note an EWC code, and no code may be on two rows. An EWC code you type that another row has goes red at once. The workbook is read again as it's written, so a code someone else added meanwhile, or a row they removed, stops the save and nothing is written. Add rows from… copies rows from your template or another project's workbook (it saves your changes first).

There are no tick boxes here: they belong to Reference Tables in a drawing, where they pick the rows the front page's tables show.