Equipment List & Bill of Materials Generator

Also known as Equipment List Generator

An equipment list you type or paste into like a spreadsheet, with tag numbers, cabinet totals and a bill of materials.

Free ● Live

Free to use. Sign up free to save, download and print.

Loading the Equipment List & Bill of Materials Generator…

What it produces

Equipment list template and bill of materials

An equipment list records what is installed in each cabinet, comms hut or rack, with a tag number, quantity, part number, description, location, rack units and power for every item. This one is a grid you type or paste into, with columns you can match to the client's template, and an optional library of the kit you fit often, so choosing a model fills in its manufacturer, part number, description, rack units and power.

Tag numbers follow your convention, built from the category prefix, the location code and a running sequence. Each location's rack units and power are totalled, allowing for quantities, and checked against the capacity you give it, and identical items are combined into a bill of materials (BOM) with their quantities summed. The list and the BOM export to CSV or copy into Excel.

Sample

Sample: two cabinets tagged by location

Five lines of equipment in two cabinets, filled in from a small library and tagged by the location code, the category prefix and a two-digit sequence for each location and category.

Tag NumberQtyDescriptionLocationRUPower (W)
CAB-A-SW01124-port PoE access switchComms Cabinet A1400
CAB-A-SW02124-port PoE access switchComms Cabinet A1400
CAB-A-PP01224-port Cat6A patch panelComms Cabinet A10
FC-1-SW01124-port PoE access switchField Cabinet 11400
FC-1-RAD011Point-to-point radioField Cabinet 1130

With a 400 W power budget on Field Cabinet 1, its 430 W of equipment is flagged. Comms Cabinet A totals 4 RU and 800 W, counting both patch panels, and the BOM combines the three switches into one line with a quantity of 3.

FAQ

Frequently asked questions

Not here? Ask us

What goes in an equipment list template?

A line for each item, with its tag number, quantity, category, manufacturer, model, part number, description, supplier, location, rack units, power, status and comments. The list starts with those columns, and you can rename, reorder, hide or add columns to match the client's template and save the layout as that client's template for the next job.

What is the difference between an equipment list and a bill of materials?

The equipment list has a line for each item where it is installed, with its tag number and location. The bill of materials (BOM) is for ordering: identical items anywhere on the list are combined into one line with the quantities summed, matched on the part number, or failing that the manufacturer and model, or the description. It exports to CSV or copies to the clipboard separately from the full tagged list.

How do the tag numbers work?

You build a pattern from the category prefix, the location code and a padded sequence number. Each category has its own editable prefix, and the sequence can count per category, per location, per location and category, or run as one counter. Choosing the category on a row, and the location if the pattern uses it, fills in the tag, and you can always type over it.

Can it tell me whether everything fits in the cabinet?

Yes, as a check on the figures you enter. Give each location a rack unit and power capacity, and the summary totals the equipment in each one, allowing for quantities, and flags any location over its budget. It does not model heat or airflow.

Where is my work stored?

Signed in, each list saves to your account as you work, and client templates and your equipment library are saved separately from each project, so they are available on every new job. Without an account the tool still works but saves nothing. Downloading a CSV asks you to create a free account, and what you have entered comes with you if you sign up from that prompt; copying the list or the BOM to the clipboard needs no account.

Does it size power supplies or model heat?

No. It is a documentation and scheduling tool that totals the nominal power and rack units you enter. It does not size power supplies, calculate heat dissipation or model airflow. For rack heat load, use the Rack Heat Load Designer.

Sign up free to keep your work.

Free to use. Saving, downloading and printing need a free account.