Summary

A3 — Cable Schedule, Audit View
ProjectKingsford Hotel Bacolod — BMS
Canonical sourceA3-cable-schedule.yaml
How to record correctionsEdit the canonical YAML directly — add a verification: block to the affected row(s)
Totals
Total cables44
Total length (m)1,107
Field cables29
Trunk cables2
Panel power feeds13
Verification status
StatusCount% of total
verified00%
needs_correction00%
uncertain00%
unverified44100%
⚠ Known weak points
Cable lengths are estimates based on assumption A-001 (30 m average panel-to-device run, 80 m trunk per floor). Field-verified lengths typically vary by ±20% per cable. THIS IS THE SYSTEM'S WEAKEST AUTO-GENERATED QUANTITY — please verify before issuing the BOQ to the customer.
How corrections flow
1. Open A3-cable-schedule.yaml in any text editor.
2. Find the affected row by ID (column A in the Detail sheet).
3. Add a verification: block — see the 'Verification schema' sheet for the template.
4. Re-run: python3 _playbook/tools/generate-deliverables.py <project>
5. Corrections flow through B4 manhours, BOQ material costs, and final deliverables automatically.

By Panel

PanelCable countTotal length (m)
BMS-PNL-CASINO-2F378
BMS-PNL-AHU-RD456
BMS-PNL-CHWPLANT-2F556
BMS-PNL-PLUMBING-LG336
BMS-PNL-VENT-GF135
BMS-PNL-VENT-2F135
BMS-PNL-VENT-3F135
BMS-PNL-CT-RD234
BMS-PNL-BOHAHU-2F224
BMS-PNL-PLUMBING-RD224
BMS-PNL-AHU-2F224
BMS-PNL-BOILER-LG222
BMS-PNL-VENT-RD114
TOTAL (field cables)29473

By Floor

FloorCable countTotal length (m)
2nd Floor13217
RD9128
LG558
GF135
3F135
TOTAL29473

By Cable Type

Cable typeCountTotal length (m)
4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)17305
4C × 1.5 mm² shielded FRLS (BMS sensor signal)12168

Detail (cables)

IDFromToCable typeLength (m)StatusCorrected (m)Verified byDateDrawing refNotes
C0001BMS-PNL-BOHAHU-2FAHU-2/B.2/B.3/PP/CL/FRE/FRD (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)12unverified
C0002BMS-PNL-BOHAHU-2FAHU-2/B.2/B.3/PP/CL/FRE/FRD (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)12unverified
C0003BMS-PNL-AHU-RDAHU-RD (with CHW mod valve) (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)16unverified
C0004BMS-PNL-AHU-RDAHU-RD (with CHW mod valve) (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)14unverified
C0005BMS-PNL-CHWPLANT-2FCDWP-1 to CDWP-3 (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)12unverified
C0006BMS-PNL-CHWPLANT-2FCH-1 to CH-3 (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)14unverified
C0007BMS-PNL-CHWPLANT-2FCH-1 to CH-3 (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)12unverified
C0008BMS-PNL-CHWPLANT-2FCHW Supply & Return Main Header (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)8unverified
C0009BMS-PNL-CHWPLANT-2FCHWP-1 to CHWP-3 (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)10unverified
C0010BMS-PNL-CT-RDCT-1 to CT-3 (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)18unverified
C0011BMS-PNL-CT-RDCT-1 to CT-3 (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)16unverified
C0012BMS-PNL-CASINO-2FDOAS (Casino) — 2 units (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)26unverified
C0013BMS-PNL-CASINO-2FDOAS (Casino) — 2 units (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)24unverified
C0014BMS-PNL-VENT-RDEF-RD.1/RD.2, EF-1 (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)14unverified
C0015BMS-PNL-PLUMBING-LGHW Supply & Return Header (LG) (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)10unverified
C0016BMS-PNL-PLUMBING-RDHWT-HZ (×3) (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)12unverified
C0017BMS-PNL-PLUMBING-LGHWT-LZ (×3) (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)14unverified
C0018BMS-PNL-AHU-2FPAHU-0.1 (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)12unverified
C0019BMS-PNL-AHU-2FPAHU-0.1 (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)12unverified
C0020BMS-PNL-AHU-RDPAHU-RD (×2) (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)14unverified
C0021BMS-PNL-AHU-RDPAHU-RD (×2) (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)12unverified
C0022BMS-PNL-PLUMBING-RDRP-HZ (×3) (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)12unverified
C0023BMS-PNL-PLUMBING-LGRP-LZ (×3) (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)12unverified
C0024BMS-PNL-BOILER-LGSB-1 & SB-2 (BMS Contractor)4C × 1.5 mm² shielded FRLS (BMS sensor signal)12unverified
C0025BMS-PNL-BOILER-LGSB-1 & SB-2 (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)10unverified
C0026BMS-PNL-CASINO-2FSanitizer for AHU-2M.1/2M.2 (Equipment Supplier)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)28unverified
C0027BMS-PNL-VENT-GFTEF-1.1 to 1.4 + EF-1.2A/LPG.1/1MR.1/1STO.1/MRF.1 (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)35unverified
C0028BMS-PNL-VENT-2FTEF-2.1/2.3/2B.3 + EF-2B.1/2B.2/GS.1&GS.2 + EF-2.1 to 2.4 + EF-CHRx2 (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)35unverified
C0029BMS-PNL-VENT-3FTEF-3Ax2/3B/3Cx2/3Dx20 + others (ME Contractor)4C × 1.5 mm² FRLS (equipment aux contacts — status / H-O-A / trip)35unverified
T0030BMS Server Room (head-end)All BMS panels at 2nd FloorCat6 4P × 23 AWG U/UTP, FRLS jacket (BACnet/IP) — riser fiber + Cat6 trunk80unverified
T0031BMS Server Room (head-end)BMS panel controllers (per topology id mstp_main_backbone)BACnet MS/TP shielded twisted-pair trunk, 1pr × 22 AWG low-cap320unverified
P0032Local panelboard / EE-supplied feederBMS-PNL-AHU-2F — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0033Local panelboard / EE-supplied feederBMS-PNL-AHU-RD — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0034Local panelboard / EE-supplied feederBMS-PNL-BOHAHU-2F — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0035Local panelboard / EE-supplied feederBMS-PNL-BOILER-LG — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0036Local panelboard / EE-supplied feederBMS-PNL-CASINO-2F — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0037Local panelboard / EE-supplied feederBMS-PNL-CHWPLANT-2F — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0038Local panelboard / EE-supplied feederBMS-PNL-CT-RD — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0039Local panelboard / EE-supplied feederBMS-PNL-PLUMBING-LG — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0040Local panelboard / EE-supplied feederBMS-PNL-PLUMBING-RD — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0041Local panelboard / EE-supplied feederBMS-PNL-VENT-2F — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0042Local panelboard / EE-supplied feederBMS-PNL-VENT-3F — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0043Local panelboard / EE-supplied feederBMS-PNL-VENT-GF — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified
P0044Local panelboard / EE-supplied feederBMS-PNL-VENT-RD — BMS panel 240V power feed3C × 2.5 mm² FRLS (240V single-phase BMS panel power feed)18unverified

Verification schema

How to record verification / corrections in A3-cable-schedule.yaml
Find the affected row in the YAML by ID (Detail sheet column A) and add a verification: block:
- id: C0001
from: PNL-CH-PLANT-GND
to: CH-1 (BMS Contractor)
cable_type: 4C × 1.5 mm² shielded FRLS
length_m: 30
verification: # ADDED by team
status: needs_correction # unverified | verified | needs_correction | uncertain
corrected_length_m: 42 # team's measured / confirmed value
verified_by: J. Cruz
verified_date: 2026-05-10
drawing_ref: "EE-09 grid B-2"
notes: ""
After saving, re-run: python3 _playbook/tools/generate-deliverables.py <project>
Corrections propagate to B4 manhours, BOQ, and final deliverables automatically.
Recommended verification methods (priority order):
1. Site walkthrough with measurement (most accurate; for cable lengths, after structural completion).
2. Properly-scaled architectural drawings.
3. Mechanical contractor's tray layout combined with BMS panel locations.
4. A-001 default with ±20% contingency in BOQ — last resort.