Common errors and how to avoid them
Cable Sizing · Lesson 27 · Advanced
Purpose
Detect common cable-design errors with independent unit, basis, boundary and reasonableness checks.
Learning objectives
- Identify the governing function
- Select evidence on the correct basis
- Coordinate the complete installed system
- Record limitations
Most dangerous spreadsheet errors look plausible. Prevention needs explicit units, cited tables, controlled inputs and independent checks, not confidence in a template.
Core theory
Typical failures include wrong method/column, conductor-count mismatch, incompatible or duplicate factors, doubled length, single/three-phase confusion, premature rounding and omitted upstream drop.
Protection failures include using device rating as design current without reason, unverified Zs or fault level, wrong k/material, ignored reactance, armour assumed as CPC and equipment breaking/terminal limits omitted.
Use input validation, dimensional checks, source/revision fields, peer review, boundary cases and independent hand calculations. A green spreadsheet cell is evidence only when its logic and inputs are verified.
| Term | Meaning | Symbol | Unit |
|---|---|---|---|
| Basis error | Mixing values derived under incompatible assumptions | Not applicable | Not applicable |
| Boundary check | Test at limiting or extreme valid conditions | Not applicable | Not applicable |
| Independent check | Verification by a separate method or reviewer | Not applicable | Not applicable |
Assumptions: Only the stated fictional project data apply.
- Pause: The direction/magnitude is suspicious and may reveal a column or √3 error.
- Trace: Check coefficient heading, formula, voltage/current basis and length convention.
- Recompute: Use a hand calculation and controlled test case before relying on the sheet.
Treat the unexpected change as a defect signal until the full basis is proven.
Reasonableness check: The conclusion follows the declared function and evidence rather than a cable nickname.
- Selecting by trade name or sheath colour
- Confusing low smoke with circuit integrity
- Ignoring supports, joints, routes or terminations
Where this appears in practice
Competent designers coordinate electrical design with the building fire strategy, system standard, product certification and maintainable records.
Knowledge check
Does a spreadsheet's green pass cell prove compliance?
No. Inputs, formulas, source editions and omitted gates must be verified.
Answer: No. Inputs, formulas, source editions and omitted gates must be verified.
Practical exercise
Seed a supplied worksheet with ten errors, then find them using a written audit checklist.
Summary
- Function determines evidence
- The tested installed system matters
- Document every assumption
Sources and review
- BS 5839-1:2025: Fire detection and fire alarm systems for non-domestic premises: BSI; 2025; United Kingdom
- Approved Document B: Fire safety: UK Government; Current applicable edition and transition must be confirmed; England
- Amendment 4:2026 impact on BS 7671: IET; 2026; United Kingdom
Editorial review date: 2026-08-22. Professional electrical review is pending.