All templates

Automated Cabling Drop Count Material List

On demand after a takeoff, WebRun opens Conest IntelliBid, reads the SureCount drop counts and device symbols in the estimate, rolls them into a cable, jack, patch panel, and connector material list in a Google Sheet, and posts your project manager a Slack summary of quantities grouped by floor or area.

Runs on WebRun · Strict Lockdown policy
On demand, after a takeoff WebRunorchestrates each step
1 Conest IntelliBid read drop counts and symbols
2 Google Sheets build the material list
3 Slack summarise quantities by area
In short

How do I turn a SureCount drop count into a material list automatically?

On demand after a takeoff, WebRun opens Conest IntelliBid and reads the SureCount drop counts and device symbols in your estimate. It rolls them into a cable, jack, panel, and connector material list in a Google Sheet, totalled by area with your spare allowance, and posts your PM a Slack summary so the crew can stage material fast.

  • Material lists come straight off the takeoff, not a manual recount
  • Every cable and connector total carries your spare allowance for waste
  • The PM sees quantities by floor before the crew stages material

Built for cabling project managers · low-voltage contractors · datacom estimators · field procurement

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens conest.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Conest IntelliBid - read drop counts and symbols
    conest.com
    WebRun in Conest IntelliBid: read drop counts and symbols
    WebRun reads the SureCount drop counts and symbols in Conest IntelliBid.
    • Open the estimate in Conest IntelliBid and read the SureCount digital takeoff drop counts and device symbols
    • Capture each cabling type, jack, patch panel, and connector quantity by area or floor
    • Note any assembly kits already applied so quantities are not double counted

    Done when Every drop, device, and cable run in the takeoff is captured by area.

  3. 2
    Google Sheets - build the material list
    google.com
    WebRun in Google Sheets: build the material list
    WebRun builds the cable and hardware material list in a Google Sheet.
    • Build a material list with each cable type, jack, panel, and connector and its total quantity
    • Break the totals out by floor or area so the field crew can stage material
    • Add a spare and slack allowance percentage you set so orders account for waste

    Done when The material list sheet totals every item by area with your spare allowance applied.

  4. 3
    Slack - summarise quantities by area
    slack.com
    WebRun in Slack: summarise quantities by area
    WebRun posts the PM a material summary grouped by area in Slack.
    • Post the project manager a summary of headline quantities grouped by area
    • Call out the largest cable and connector counts and the total drop count
    • Keep it a scannable internal note the PM can check against the plan

    Done when The PM has the material summary by area in Slack.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
conest.com
ScheduleRuns automatically on this cadence
On demand, after a takeoff
DeliveryHow each run's result reaches you
Material summary · Slack
OutputWhat each run produces - A Google Sheet material list of cable, jacks, panels, and connectors totalled by area with a spare allowance, plus a Slack summary of headline quantities.
Text
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does it place a purchase order?

No. WebRun only builds a material list in a Google Sheet and posts a Slack summary. Ordering stays with your team, so nothing is bought or committed without a person placing the order.

How does it get the drop count?

It reads the SureCount digital takeoff quantities and device symbols already captured in your Conest IntelliBid estimate, so the material list matches the counts your estimator produced.

Can it add a spare allowance for waste?

Yes. WebRun applies the spare and slack percentage you set to each cable and connector total, so the material list already accounts for waste before anyone orders.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.