Using spreadsheet software as a platform for power system analysis

Author

Xu, W. ; Liu, Y. ; Koval, D. ; Lipsett, M.A.

Author_Institution

Alberta Univ., Edmonton, Alta., Canada

Volume

12

Issue

1

fYear

1999

fDate

1/1/1999 12:00:00 AM

Firstpage

41

Lastpage

45

Abstract

This article presents an Excel add-on program for power system load flow, fault and harmonic analysis that has been used to solve real engineering problems as well as to teach university students. The objective is to share the authors´ experiences on using spreadsheet-based power system analysis programs. The article discusses the user-interface design of the program, integration of network analysis engines with the spreadsheet, experiences on utilizing various spreadsheet features to facilitate case studies and the pros and cons of spreadsheet-based power system analysis software

Keywords

harmonic distortion; load flow; power system analysis computing; power system faults; power system harmonics; spreadsheet programs; user interfaces; Excel add-on program; case studies; computer simulation; engineering problems; fault analysis; harmonic analysis; load flow analysis; power system analysis platform; spreadsheet software; user-interface design; Data engineering; Load flow; Power engineering and energy; Power system analysis computing; Power system faults; Power system harmonics; Power system management; Power system simulation; Spreadsheet programs; Voltage;

fLanguage

English

Journal_Title

Computer Applications in Power, IEEE

Publisher

ieee

ISSN

0895-0156

Type

jour

DOI

10.1109/67.738318

Filename

738318