Materials exports two kinds of file: the material list from Counts, and a supplier file from Order. Exporting a file never places an order.

Export the material list

  1. Open Counts and click Export ▾

    Choose one Excel sheet, or a UTF-8 CSV.

  2. Answer the question, if asked

    With left-out devices or a scope that couldn’t all be read, it asks first, with Export anyway.

  3. Save

    The file is written beside the target and moved over it, so a failure leaves the old file unchanged.

Columns
EL number, name, quantity and unit, nothing else
Codes
Text, with leading zeros kept
Quantities
Numbers; metres rounded up

Review the order

Order reads products, cables and paths again together; save any unsaved edits first. Each product, size and lifecycle stage needs a purchase rule you review, with a reason: Purchase, Retain, Reuse or Exclude. An element’s status, such as existing, new or demolished, never chooses it for you.

  1. Open the Order tab

    Each row shows the product description and project stage, the required quantity, the purchase quantity and what needs doing, if anything.

  2. Set the purchase rules

    A row without one says Purchase rule not set, with Review the purchase rule. Give each rule a reason.

  3. Click Apply review

    A refused review keeps what you typed and shows why. Back changes nothing.

  4. Click Export order

    Export as draft is under More.

The supplier file

A CSV, or an Excel Order sheet, with Code, Description, Quantity and Unit: one row per code and unit, Purchase lines only, rounded to whole packs, lengths or drums before summing. The Audit CSV or sheet keeps the scope, evidence, assumptions and subtotals behind it.

  • Stock lengths need an allocation that works; otherwise the order exports only as a draft.
  • The same code and unit on two different products blocks the export.
  • A type that isn’t mapped yet makes the order a draft until you map it.