Allocate a single cable item across multiple connections with per-connection length

Problem

In the Connection View, a single cable line item (for example, a 1000ft Cat6 spool) can only be assigned to one connection. On real projects a single spool typically feeds many connections (e.g., one Cat6 spool runs to 7 different terminations). Today the workaround is creating a separate cable item per connection, which fights the natural way the bill of material is built.

Required capability

• Assign a single cable / spool item to multiple connections in the Connection View.

• Specify a per-connection length (e.g., 80ft on connection A, 200ft on connection B, 300ft on connection C).

• Roll up the per-connection lengths against the spool quantity to flag over-allocation.

• Reflect the allocation in the bill of material so the spool quantity is reconciled against actual consumption.

Why it matters

Cable spools are the canonical example of a "one item, many uses" line on a commercial AV / security bill of material. Without a many-to-one allocation between cables and connections, the Connection View can't represent the project the way it actually gets built, and the cable quantity on the BoM stops matching field reality.

Several competing platforms support this allocation pattern today; closing the gap matters for retention on commercial-heavy customers.

*************************************************************************************************************************************

*************************************************************************************************************************************

Shared Cable Spool Allocation & Consumption Tracking in Connection View

Feature Idea

Allow a single cable or spool item to be allocated across multiple connections in Connection View while tracking per-connection cable consumption and reconciling usage against the Bill of Materials.

Expanded Feature Description

Overview

In real-world commercial AV, security, networking, and structured cabling projects, cable materials are typically purchased and managed as bulk spools or reels rather than as individual cable runs.

For example:

• 1 × 1000ft Cat6 spool

• 1 × 500ft speaker cable reel

• 1 × 1000ft fiber spool

These materials are then distributed across many individual connections throughout the project.

However, the current Connection View model only allows:

“one cable item per connection.”

This creates a disconnect between:

• How materials are procured
  and

• How systems are physically installed.

As a result, users are forced into inefficient workarounds such as:

• Creating duplicate spool items

• Splitting cable inventory artificially

• Manually estimating remaining lengths

• Maintaining disconnected BoM calculations

This feature introduces:

A true many-to-one cable allocation model.

allowing:

• One spool

• Multiple cable runs

• Accurate consumption tracking

• Real-world material reconciliation

Core Capabilities

1. Many-to-One Cable Allocation

Capability

Allow a single cable/spool item to be assigned to multiple independent connections within Connection View.

Example

Instead of:

Cat6 Spool A → Connection 1 only

Users could create:

Cat6 Spool A
├── Connection A → 80ft
├── Connection B → 200ft
├── Connection C → 300ft
├── Connection D → 120ft
└── Connection E → 75ft

The spool behaves as:

• One inventory item

• Multiple physical cable runs

Benefits

• Matches real installation workflows

• Eliminates duplicate cable entries

• Simplifies project management

• Improves BoM accuracy

• Reduces engineering friction

2. Per-Connection Length Assignment

Capability

Allow users to define the exact cable length consumed by each individual connection.

Example

Each connection maintains:

• Its own length

• Its own routing

• Its own consumption allocation

while still referencing the same spool source.

Benefits

• Accurate cable estimation

• Better field planning

• More realistic infrastructure modeling

• Improved labor forecasting

Future Enhancements

• Auto-calculate length from floorplans

• Include slack/waste percentages

• Unit conversion (ft/m)

• Suggested standard run lengths

3. Real-Time Cable Consumption Rollup

Capability

Automatically total all allocated cable lengths against the spool’s available quantity.

Example

The system continuously tracks:

• Total allocated footage

• Remaining available length

• Percentage utilization

• Over-allocation conditions

Benefits

• Prevents underestimating cable needs

• Improves procurement accuracy

• Helps PMs manage material usage

• Reduces installation surprises

4. Over-Allocation Detection & Warnings

Capability

Flag situations where allocated cable lengths exceed available spool capacity.

Example

Warnings could include:

• Visual alerts

• Red status indicators

• BoM discrepancies

• Procurement recommendations

Benefits

• Prevents inaccurate purchasing

• Improves engineering validation

• Reduces field shortages

• Enhances project reliability

UX Ideas

• Progress bars

• Capacity meters

• Warning banners

• Threshold color coding

  • Green → Safe

  • Yellow → Near limit

  • Red → Exceeded

5. Bill of Materials Reconciliation

Capability

Synchronize cable consumption directly with the Bill of Materials.

Problem Today

Users often:

• Purchase cable by spool
  but

• Model connections individually

leading to mismatches between:

• BoM quantities
  and

• Actual installation consumption.

Feature Enhancement

The system should:

• Roll up total cable usage

• Reconcile against spool quantities

• Recommend spool counts automatically

Example

Total Cat6 usage:

2,450ft

System recommendation:

3 × 1000ft spools

Benefits

• Better procurement planning

• Accurate material forecasting

• Reduced waste

• Improved financial accuracy

6. Real-World Installation Modeling

Capability

Model cable infrastructure the way projects are physically built in the field.

Current Limitation

The current one-cable-per-connection model creates artificial project structures that do not reflect:

• Actual spool usage

• Real installation practices

• Physical inventory handling

Feature Enhancement

This feature creates:

A physically accurate infrastructure representation.

where:

• Bulk cable inventory

• Distributed cable runs

• Real consumption patterns

all coexist naturally.

Benefits

• Better installer trust

• More realistic documentation

• Improved engineering workflows

• Reduced modeling workarounds

7. Shared Cable Management Interface

Capability

Provide a centralized UI for managing spool allocations and cable usage.

Possible Interface Features

• Allocation table/grid

• Connected run list

• Remaining spool visualization

• Connection search/filtering

• Drag-and-drop assignment

Example

Cat6 Spool A
Used: 820ft / 1000ft

Connections:
✔ Camera 01 → 80ft
✔ Camera 02 → 95ft
✔ Rack Uplink → 220ft
✔ Conference Table → 145ft

Benefits

• Easier management

• Better visibility

• Faster engineering workflows

• Cleaner project organization

8. Intelligent Procurement Recommendations

Capability

Automatically recommend optimal spool quantities and packaging combinations.

Example

Required cable:

2,350ft

Suggested procurement:

2 × 1000ft spools
1 × 500ft spool

instead of:

3 × 1000ft spools

Benefits

• Reduced waste

• Better purchasing efficiency

• Lower project costs

• Smarter inventory planning

Future Enhancements

• Vendor-specific spool sizes

• Cost optimization

• Warehouse inventory awareness

• Leftover reel tracking

9. Connection View Scalability Improvements

Capability

Improve Connection View usability for commercial-scale projects with many cable runs.

Problem

Large projects may contain:

• Hundreds of cable runs

• Shared spools

• Multiple rack rooms

• Distributed infrastructure

Without shared spool allocation:

• BoMs become bloated

• Connection View becomes inaccurate

• Cable management becomes difficult

Feature Enhancement

This capability allows:

• Cleaner diagrams

• Shared cable relationships

• Reduced duplicate items

• Better scalability

Benefits

• Enterprise readiness

• Cleaner infrastructure modeling

• Easier maintenance

10. Competitive Workflow Parity

Capability

Close a competitive gap with platforms already supporting shared cable allocation workflows.

Industry Context

Many competing commercial AV and security platforms already support:

• Shared cable inventory

• Many-to-one cable allocation

• Cable consumption rollups

Without this capability:

• Integrators experience workflow friction

• Engineering feels disconnected from field reality

• Customers may migrate to competing tools

Strategic Value

This feature significantly improves:

• Commercial AV competitiveness

• Enterprise infrastructure usability

• Customer retention

• Workflow credibility

11. Foundation for Future Inventory Management

Capability

Use shared spool allocation as the foundation for future inventory-aware workflows.

Future Possibilities

Once spool tracking exists, the platform could support:

• Warehouse inventory

• Partial spool tracking

• Reel leftovers

• Serialized spool IDs

• Install status tracking

• ERP synchronization

Example

Strategic Potential

Creates a pathway toward:

“true infrastructure inventory lifecycle management.”

12. Intelligent Cable Infrastructure Modeling

Capability

Transform Connection View into a smarter infrastructure-aware engineering environment.

Strategic Evolution

This feature shifts the system from:

“logical connection mapping”

toward:

“real-world infrastructure consumption modeling.”

The platform begins understanding:

• Shared resources

• Physical material usage

• Infrastructure allocation relationships

• Procurement dependencies

Strategic Value

This creates a more intelligent and operationally accurate engineering platform.

Summary of Core Product Value

These capabilities collectively create:

A real-world cable allocation and infrastructure consumption management system integrated directly into Connection View.

The feature set enables:

• Shared spool allocation

• Per-connection cable lengths

• Real-time consumption tracking

• Over-allocation warnings

• BoM reconciliation

• Procurement optimization

• Cleaner infrastructure modeling

• Commercial-scale project support

Most importantly, it closes the workflow gap between:

“how cable inventory is purchased”
and
“How cable infrastructure is actually installed in the field.”