Map every circuit to a numbered port before ordering: record cable category, shielding, module type and rack position, then choose loaded, blank, angled or 10-inch frames that match the documented plan.

Why the worksheet comes before the purchase order

A port count alone does not tell a supplier which circuits need shielded termination, which positions must stay empty for future links, or which rack row each frame serves. Patch Panel Port Mapping Worksheet: Documenting Circuits Before You Order Frames turns the connection plan into a line-by-line record that buyer, installer and integrator can read the same way.

The worksheet does not replace the project design or the manufacturer's installation instructions. It is a procurement control document: it records what to buy, in what quantity, and what each opening is reserved for.

Columns to capture for every port

Keep one row per physical port position, not one row per cable bundle. A workable minimum set of columns is:

ColumnWhat to recordWhy it matters at ordering
Frame IDRack, U position, panel referencePrevents double-counting ports across rows
Port numberSilkscreen or label position on the frameLinks the record to the physical panel
Circuit / link IDProject naming conventionConnects the port to drawings and test records
Cable categoryCat5e, Cat6 or Cat6A as designedCategory must match the module or panel family
ShieldingSTP or UTP as designedShielded and unshielded parts are not interchangeable
Module typeKeystone or panel-specific module referenceBlank frames need a confirmed module fit
StatusActive, spare, reserved, futureSets how many loaded versus empty positions you need

Add a free-text notes column for anything the design engineer must confirm, such as a cable whose overall diameter has not yet been checked against the module drawing.

Separate the four compatibility checks

Buyers often collapse several independent questions into one. Keep them apart on the worksheet:

  1. Category. The panel or module family must be specified for the cable category in the design. A Cat6A panel and a Cat6 cable are not automatically a matched pair just because both terminate.
  2. Shielding. STP and UTP are separate build items. If the design calls for shielded links, the frame, modules and bonding arrangement must be specified together, and the bonding method must follow the manufacturer's instructions and the project design.
  3. Mechanical fit. Bare conductor size, insulation diameter and overall cable diameter are three different dimensions. A catalogue bore figure means little without the drawing that defines it, and a larger bore is not automatically more compatible.
  4. Rack and clearance. Rack width, U height, termination angle and rear cable support are separate attributes. An angled front profile does not by itself prove rear clearance in a shallow cabinet.

Matching the worksheet to a frame format

Once the rows are filled, the totals per category and shielding type narrow the frame options. Patch Panel Port Mapping Worksheet: Documenting Circuits Before You Order Frames is most useful at this stage, because the counts point to a product family rather than a guess.

Blank and angled frames shift responsibility to the module choice. Record the exact module reference on the worksheet and confirm fit against the module drawing before committing the order. Treat every catalogue figure above as a starting point to verify against the current datasheet, not as a fit guarantee.

What the worksheet does not decide

It does not certify performance, set test limits or confirm grounding adequacy; those belong to the project design, the manufacturer's instructions and the commissioning process. It also does not fix quantities that depend on future growth. Where growth is uncertain, mark positions as reserved and order frames with empty openings rather than assuming spare loaded ports.

Used this way, Patch Panel Port Mapping Worksheet: Documenting Circuits Before You Order Frames keeps the front of the rack tied to a clear connection plan, and keeps the purchase order tied to documented rows instead of a remembered conversation.

Qixiang product catalogues; confirm current model drawings and installation requirements before ordering.