Electrical Installation Design with Excel

Learn load profile calculation, cable sizing, voltage drop, and MCB selection using Excel with BS 7671 standards

What you'll learn
- Understand the concept of a Load Profile and its role in electrical system design.
- Calculate Load Profiles accurately using Excel with real project examples.
- Learn the fundamentals of cable selection based on current, voltage drop, and derating factors
- Design complete electrical circuits following BS 7671 wiring regulations
- Perform voltage drop and current carrying capacity calculations using Excel formulas
- Choose suitable MCB and protective devices for different electrical loads
- Build your own Excel-based electrical design tool for professional projects
- Apply learned concepts to real-world electrical installation designs

Requirements
- Basic understanding of electrical concepts such as three-phase current, voltage, and power calculations.
- No prior Excel knowledge required, all necessary Excel skills will be taught step by step in the course.

Description
Master one of the most essential skills for any electrical professional: correct cable sizing and selection according to Standards.

This course is designed to take you from theoretical knowledge to practical design mastery. You'll learn the complete, step-by-step process forselecting and sizing cables, not just for simple circuits, but for complex installations requiring detailed calculations.

We move beyond the textbook and dive into real-world examples and Excel-based calculations. You will learn to think like an engineer, balancing safety, compliance, and cost.

This course bridges the gap between university theory and on-the-job requirements. We will demystify the IET Wiring Regulations and show you how to:

Start with the Load: Correctly determine theoperating current (Ib)andmaximum demandbyanalyzing load profiles.

Select Protection: Choose the right protective device(MCB) and its rating (In).

Calculate Cable Size: Determine the required cable size based on your protection and installation method.

Derate Like a Pro: This is where most errors are made. We will deeply cover applying correction factors for grouping, temperature, and thermal insulation (Ca, Cg, Ci).

Verify Your Design: Ensure your cable is protected against both overload (Ib ≤ In ≤ Iz) and short-circuits, and confirm your voltage drop is within regulatory limits.

By the end of this course, you’ll have the confidence and skills to tackle any cable selection challenge, armed with practical tools and a thorough understanding ofBS 7671 Standards.

Who this course is for:
- Electrical Engineering undergraduates who want to learn practical design methods
- Technical officers and technicians involved in electrical installations and maintenance.
- Engineering diploma or NVQ students preparing for industry-level electrical design work
- Instructors or trainers who want ready-to-use Excel tools for teaching electrical design
- Anyone interested in electrical design and looking to apply BS 7671 standards practically
More Info