Excel-Based Electrical Load Distribution & Demand Calculation Sheet

In this project, I present a professional Load Distribution Schedule, demonstrating advanced proficiency in Microsoft Excel. This work relies on precise data automation, showcasing my ability to utilize multiple complex Excel functions to handle detailed engineering and mathematical operations.

Key Features of This Work:

Conditional and Mathematical Functions: Programmed cells to automatically sort and aggregate loads based on different categories, such as Lighting, Sockets, and Heaters.

Complex Operations Automation: Dynamically calculated the Total Connected Load and Demand Load by multiplying the loads by their specific Demand Factors.

Precise Data Distribution: Accurately distributed and calculated the loads across the three electrical phases (R, Y, B) to extract error-free, automated totals.

Professional Formatting: Delivered a clearly structured layout that includes all technical specifications, such as CB types (MCB/ELCB) and Wire Sizes, making the sheet ready for official approval and printing.