Microcomputer spreadsheet calculations for application in power systems

Journal Article · Sat Sep 01 04:00:00 EDT 1984 · IEEE Trans. Power Appar. Syst.; (United States)

DOI:https://doi.org/10.1109/TPAS.1984.318408· OSTI ID:6317008

Rao, N D

This paper reports on the application of a popular spreadsheet program to the solution of selected problems in Power Systems with the IBM Personal Computer in the context of the Power Engineering Curriculum at The University of Calgary. The problems selected are inductance and capacitance calculations for overhead transmission lines and numerical integration associated with a typical transient stability study. These examples demonstrate how a spreadsheet harnesses the power of the microcomputer to automate many timeconsuming ''What if''- computational tasks by functioning as a visible processor, i.e. by providing an instantly changeable, ''scrollable'' on-line window on the machinestored version of the familiar worksheet used in business applications. The templates created for the application examples cited in the paper clearly highlight the fact that problem solving with a spreadsheet is data-oriented rather than program-oriented, unlike problem solving with computers using the conventional approach. Because of their versatility, visible numeric processors hold considerable promise as important high-tech tools for engineering and scientific applications as well.

• Research Organization: Department of Electrical Engineering, The University of Calgary, Calgary, Alberta
• OSTI ID: 6317008
• Journal Information: IEEE Trans. Power Appar. Syst.; (United States), Journal Name: IEEE Trans. Power Appar. Syst.; (United States) Vol. PAS-103:9; ISSN IEPSA
• Country of Publication: United States
• Language: English

Related Subjects

200300* -- Electric Power Engineering-- Power Transmission & Distribution-- (-1989)
24 POWER TRANSMISSION AND DISTRIBUTION
CAPACITANCE
COMPUTER CALCULATIONS
COMPUTERS
DATA FORMS
DATA PROCESSING
DOCUMENT TYPES
ELECTRICAL PROPERTIES
ELECTRICAL TRANSIENTS
ELECTRONIC CIRCUITS
ENERGY SYSTEMS
IBM COMPUTERS
INDUCTION
MICROELECTRONIC CIRCUITS
MICROPROCESSORS
OVERHEAD POWER TRANSMISSION
PHYSICAL PROPERTIES
POWER SYSTEMS
POWER TRANSMISSION
POWER TRANSMISSION LINES
PROCESSING
SYSTEMS ANALYSIS
TECHNOLOGY UTILIZATION
TRANSIENTS
VOLTAGE DROP