Engineering Delivery

Equipment List Generator

Build a deliverable equipment list for a cabinet, comms hut or rack in a fast inline grid — type straight in or paste from Excel — with auto-generated client tag numbers, a reusable equipment library that fills part numbers and ratings in one pick, per-location rack-unit and power roll-ups, and CSV / BOM / JSON export.

Free forever on a Standard account. No credit card.

Overview

An equipment list is the register a systems integrator hands over so the client knows exactly what was installed in a cabinet, comms hut or rack — the equipment, its client tag number, the quantities, part numbers, descriptions and the manufacturer and supplier behind each item. On most projects it lives in a hand-kept spreadsheet, and a tool only earns its place if it is genuinely faster than that spreadsheet and bends to each client’s standard instead of forcing a generic one. The Equipment List Generator is built around exactly those two things.

It is a grid, not a form. You type straight into a spreadsheet-style table — Tab moves across, Enter moves down and adds a row at the bottom, and a block copied from Excel pastes straight in across the right columns. There is no pop-up between you and the data. The layout is defined per client: add, rename, reorder and hide columns and set each column’s type, starting from the standard set — tag number, quantity, category, manufacturer, model, part number, description, supplier, location, rack units, power and status — and save the result as a reusable client template.

Two pieces of automation make it quicker than a blank sheet. First, client tag numbers build themselves: pick the equipment category on a row and the tag is generated from a per-client pattern of tokens — {cat} for the category prefix, {loc} for the location code, and a padded {seq} — so {cat}{seq:3} gives SW001 counting per category, while {loc}-{cat}{seq:2} gives CAB-A-SW01. Second, a reusable equipment library: catalogue a piece of kit once with its manufacturer, part number, description, rack units and power, and choosing that model on a row fills the rest in. Register your cabinets and comms huts with rack-unit and power capacities, and the summary rolls the list up per location — flagging any cabinet that is over its RU or power budget — and consolidates identical kit into a procurement BOM. Export the list or the BOM to CSV, clipboard or JSON. It is a documentation and scheduling tool — it does not size power supplies or compute heat dissipation.

Capabilities

A grid, not a form

The equipment list is an inline editable grid. Tab moves across cells, Enter moves down and adds a row when you reach the bottom, and a block copied from Excel pastes straight in, creating rows as needed. No pop-up stands between the engineer and the data, so building and editing the list is faster than maintaining it by hand.

Columns tailored to each client

Every column is customisable — add, rename, reorder and hide them, and set each one’s type (text, number, dropdown, or the auto tag-number). The standard layout ships ready to use: tag number, quantity, category, manufacturer, model, part number, description, supplier, location, rack units, power and status. Columns carry an optional role that ties them to the automation, so they can be renamed to a client’s wording without breaking it.

Client tag numbers that build themselves

Pick the equipment category on a row and its client tag number is generated from a per-client pattern of tokens — {cat} for the category prefix, {loc} for the location code, and {seq:n} for a zero-padded sequence. {cat}{seq:3} gives SW001; {loc}-{cat}{seq:2} gives CAB-A-SW01. The sequence counts per category, per location, per location-and-category, or as a single running counter. Override any tag by typing over it, or Auto-tag the blanks.

A reusable equipment library

Catalogue the kit you fit regularly — manufacturer, model, part number, description, rack units and power. In the grid, choosing a model auto-fills the rest of that row, so a repeated piece of equipment is entered once and stays consistent across every job. The model dropdown is filtered to the row’s category. The library is optional: you can always type or paste the columns directly.

Cabinets and huts with a capacity check

Register your locations — cabinets, comms huts and racks — each with an optional rack-unit and power capacity. The summary rolls the equipment up per location, quantity-weighted, and flags any location whose equipment exceeds its rack-unit or power budget before you commit the design.

Consolidated BOM and roll-ups

The summary totals the line items, the total quantity, the rack units and the nominal power, then rolls up by location, by category and by manufacturer. It also consolidates the list into a procurement BOM — identical kit (matched on part number, else manufacturer and model, else description) collapsed to one order line with the quantities summed.

Reusable client templates and export

Save a column layout, category list and tag-number format as a named client template and reapply it to the next project. Export the equipment list to CSV (project-headed, formula-injection safe), export the consolidated BOM, copy either to the clipboard for an Excel template, or save the whole project to JSON; everything auto-saves to the browser.

Honest, bounded scope

This is a documentation and scheduling tool. It builds, tags, validates and exports the equipment list and BOM; it does not size power supplies, compute heat dissipation or model airflow. The platform carries dedicated calculators — such as the rack heat-load designer — that the equipment list sits alongside.

Standards & methodology

  • Client-defined equipment tag-numbering conventions (category prefixes, location codes, tag composition)
  • Per-location rack-unit (RU) capacity checks against the standard 19-inch rack U
  • Per-location power-budget checks (nominal nameplate power)
  • CSV formula-injection neutralisation on export

When to use this tool

  • Producing the equipment-list / asset-register deliverable for a cabinet, comms hut or rack handover
  • Tailoring the column layout to each client’s equipment-schedule standard
  • Auto-generating client tag numbers from the equipment category and location
  • Building a reusable library of kit so part numbers and ratings fill themselves in
  • Pasting an existing equipment list in from Excel and tidying it up in the grid
  • Checking that a cabinet’s equipment fits its rack-unit and power budget
  • Consolidating the list into a procurement BOM with quantities summed per part
  • Tracking supply status from proposed through ordered, delivered and installed to commissioned
  • Saving a client layout as a template and reusing it across projects
  • Exporting a clean CSV equipment list or BOM, or copying it straight into an Excel template

Is this the right tool for you?

Reach for the Equipment List Generator in any of the following situations.

  • You are handing a comms cabinet over to the client and need a clean equipment list — tag numbers, quantities, part numbers, descriptions and suppliers — faster than the Excel sheet you keep by hand.
  • Your client has its own equipment-schedule layout and you need the columns to match theirs, saved so you can reuse it on the next job.
  • Your client tags equipment by location — CAB-A-SW01, HUT-1-RTR01 — and you need the tag to build itself from the location code and category.
  • You fit the same switches, UPS and patch panels on every job and want the manufacturer, part number and ratings to fill in from a single model pick.
  • You need to know a 42 RU cabinet has room for everything specced, and that its nominal power is within the UPS / PDU budget.
  • You need a consolidated BOM for procurement with identical kit collapsed to one line and the quantities summed.

Frequently asked questions

How is this faster than a spreadsheet?

It is an inline grid you type straight into — Tab moves across, Enter moves down and adds a new row at the bottom, and you can paste a block straight from Excel. There is no pop-up per item. On top of that, client tag numbers generate themselves from the category, and a model picked from your equipment library fills the manufacturer, part number, description, rack units and power — so the most repetitive parts of keeping the sheet are automated.

What is the equipment library and do I have to use it?

The library is your own catalogue of kit — manufacturer, model, part number, description, rack units and power. Once an item is in it, picking that model on a grid row fills the rest of the row in. It is entirely optional: you can type or paste the manufacturer, part number and description directly into the columns and never open the library. It just makes repeated equipment one pick instead of re-keying.

How do the client tag numbers work?

You define a pattern from tokens: {cat} for the category prefix, {loc} for the location code, and {seq:n} for a zero-padded sequence. {cat}{seq:3} gives SW001; {loc}-{cat}{seq:2} gives CAB-A-SW01. Each category carries its own editable prefix (SW, RTR, UPS, PP…), and you choose whether the sequence resets per category, per location, per location-and-category, or runs continuously. Picking the category on a row generates the tag; you can always type over it.

Can it tell me whether everything fits in the cabinet?

Yes. Register each location — cabinet, comms hut or rack — with an optional rack-unit and power capacity. The Summary tab rolls the equipment up per location, quantity-weighted, and flags any location whose rack units or nominal power exceed its budget. It is a planning-grade check on the figures you enter, not a thermal or airflow simulation.

What is the consolidated BOM?

The equipment list often has the same part in several cabinets. The BOM collapses identical kit into one procurement line — matched on part number, or failing that manufacturer and model, or failing that description — and sums the quantities. You can export the BOM to CSV or copy it to the clipboard, separately from the full tagged list.

Does it size power supplies or model heat?

No. This is a documentation and scheduling tool — it builds, tags, validates and exports the equipment list and BOM, and totals the nominal nameplate power and rack units you enter. It does not size power supplies, compute heat dissipation or model airflow. The platform carries dedicated calculators, such as the rack heat-load designer, for those questions.