Home / Current Issue / Paper 1703599
Design and Assessment of an Electrical Load Schedule Template using Microsoft Excel
Subject area: Science,Engineering and Technology · Area of research: Electrical Design
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
References
[1] Innovation by (and beyond) the numbers: A history of research collaborations in Excel (2021). Microsoft. Retrieved October 22, 2021, Website: microsoft.com/en-us/research/blog/innovation- by-and-beyond-the-numbers-a-history-of- researchcollaborations-in excel/?fbclid=IwAR00VwopwmvbBxsc9D9_vO KEOnr0eoiUV1VmwhqOQhsDAgBB Ta4qkt287cE
[2] ADEBISI, J. (2013). Microsoft Excel. Retrieved October 22,2021, Website : https://www.researchgate.net/publication/258339 298_MICROSOFT_EXCEL
[3] Institute of Integrated Electrical Engineers of the Philippines (2017). Philippine Electrical Code Part 1 (2017 Edition). Publication Manual of the Institute of Integrated Electrical Engineers of the Philippines, Inc. (2017 ed., p. 1).
[4] The Guidelines Project (2017). Development Research. Retrieved October 28, 2021, Website: http://www.guidelines.kaowarsom.be/annex_dev elopment_research
[5] Richey, R., & Klein, J. (2014). Design and Development Research. In M. Spector, D. Merrill, J. Elen & M. Bishop, Handbook of Research on Educational Communications and Technology (4th ed., pp. 141-150). London: Springer.
[6] Stange J. et.al (2011). Tourism Destination Management (Achieving sustainable and competitive results.) Retrieved December 10, 2017, Website: file:///C:/Users/DELL/Pictures/Camera%20Roll/ New%20folder/DMOworkbook_130318.
How to cite this paper
@article{1703599,
author = {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},
title = {Design and Assessment of an Electrical Load Schedule Template using Microsoft Excel},
journal = {Iconic Research And Engineering Journals},
year = {2022},
volume = {6},
number = {1},
pages = {126-137},
issn = {2456-8880},
url = {https://www.irejournals.com/formatedpaper/1703599.pdf},
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},
month = {July},
}