Design and Assessment of an Electrical Load Schedule Template using Microsoft Excel

• Author(s): Jan Christian D. Guanlao ; Ceejay S. Balingit ; John Paulo L. Carreon ; Rhey Mark O. Castro; Muriel Andreah C. Ocampo ; Louie G. Serrano; Freneil R. Pampo
• Paper ID: 1703599
• Page: 126-137
• Published Date: 06-07-2022
• Published In: Iconic Research And Engineering Journals
• Publisher: IRE Journals
• e-ISSN: 2456-8880
• Volume/Issue: Volume 6 Issue 1 July-2022

Abstract

This study aimed to develop an electrical load schedule template using Microsoft excel which produces faster and more precise results in generating Electrical load schedules. The research has come up with a template for establishment application using standards of the Philippine Electrical Code. In addition, this study will consider manual computations and compare them with the template calculation output that would address the effectiveness of the template. The medium that is used in creating the template is the software so called Microsoft excel. This software was chosen due to the fact that it is widely used and is best in storing data and can form calculations. To develop this template the researchers made an in-depth review with regards to the standards of the Philippine Electrical Code to gather all the necessary data. Then after all the data were gathered the template was programmed. The developed template is assessed by licensed electrical practitioners to know its effectiveness of the template. The data in the assessment showed that the developed template is recommendable to other electrical practitioners since the template can use practically and it can lessen the working time of the user. In addition, the researchers also concluded that this tool allows you to calculate the electrical load schedule, and display parallel computation results. Add-Ins (software extensions) give you more power and open up new possibilities

Keywords

Philippine Electrical Code, Template, Electrical load schedule, Microsoft Excel

Citations

IRE Journals:
Jan Christian D. Guanlao , Ceejay S. Balingit , John Paulo L. Carreon , Rhey Mark O. Castro; Muriel Andreah C. Ocampo , Louie G. Serrano; Freneil R. Pampo "Design and Assessment of an Electrical Load Schedule Template using Microsoft Excel" Iconic Research And Engineering Journals Volume 6 Issue 1 2022 Page 126-137

IEEE:
Jan Christian D. Guanlao , Ceejay S. Balingit , John Paulo L. Carreon , Rhey Mark O. Castro; Muriel Andreah C. Ocampo , Louie G. Serrano; Freneil R. Pampo "Design and Assessment of an Electrical Load Schedule Template using Microsoft Excel" Iconic Research And Engineering Journals, 6(1)