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 ● Live 4 standards

Free on a Standard account, with no time limit. No credit card.

Overview

What the Equipment List Generator does

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.

Read the full overview

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 8

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.

Inputs and outputs

What goes in, what comes out

Inputs 8

  • Project details (name, client, project number, revision, date, integrator)
  • A column layout per client (or a saved template)
  • Equipment categories and their tag prefixes
  • A tag-number pattern and sequence scope
  • Locations — cabinets / comms huts / racks — with optional rack-unit and power capacities
  • A reusable equipment library (manufacturer, model, part number, description, RU, power)
  • Per-item data typed into the grid or pasted from Excel
  • Quantity, category, model, location and status per item

Outputs 8

  • An equipment list with auto-generated, client-formatted tag numbers
  • Library-filled manufacturer, part number, description, rack units and power
  • Live validation (duplicate tags, unidentified items, over-capacity locations)
  • Total line items, total quantity, rack units and nominal power
  • Per-location, per-category and per-manufacturer roll-ups with capacity flags
  • A consolidated procurement BOM with identical kit collapsed and quantities summed
  • CSV equipment list and CSV BOM (project-headed, formula-injection safe)
  • Clipboard export (tab-separated for Excel) and JSON project file, plus browser auto-save

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

Use cases

When to use this tool

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

FAQ

Frequently asked questions

Not here? Ask us

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.

Free on any account

Free on a Standard account, with no time limit. No credit card.