Please use this identifier to cite or link to this item:
http://repository.futminna.edu.ng:8080/jspui/handle/123456789/6029
Title: | Simulation of Electric Power Plant Performance Using Excel-VBA |
Authors: | Abisoye, Blessing Olatunde Abisoye, Opeyemi Aderiike |
Keywords: | Simulation Excel® - VBA Random Number Turbo Alternator Reliability Power Station |
Issue Date: | May-2018 |
Publisher: | I.J. Information Engineering and Electronic Business |
Citation: | 2 |
Abstract: | This paper presents the failure and repair simulation for electric power house with N Turbo-alternator, where N may be up to 32. The program employs a pseudo-random number generator for individual power plant that can be described by exponential probability density functions. The resulting sequences of failure and repair events are then combined for the plants to give scenarios for different time horizons. The implementation in Excel®-VBA includes an appropriately designed userform containing the macro Active-X control for input of relevant information. The result shows that as the number of samples increased the behavior of the random events better represented the desired form with a correlation of almost 99% for 25 trials. This corresponds to a confidence interval of better than 95% and hence should be used as the median for practical applications. The results were tested and the distributions of the events were found to be close approximation of the target exponential distributions. |
Description: | I.J. Information Engineering and Electronic Business, 2018, 3, 8-14 Published Online May 2018 in MECS (http://www.mecs-press.org/) DOI: 10.5815/ijieeb.2018.03.02 |
URI: | http://repository.futminna.edu.ng:8080/jspui/handle/123456789/6029 |
Appears in Collections: | Computer Engineering |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
Simulation of Electric Power Plant Performance Using Excel®-VBA.pdf | Journal | 1.07 MB | Adobe PDF | View/Open |
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.