Power System State Estimation using Microsoft Excel
This paper presents the design and development of a Microsoft Excel based tool for Power System Static State Estimation. This tool can be effectively used to understand the process of state estimation and its real-time application. The tool contains Newton-Raphson load flow that provides system meas...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
McMaster University
2014-01-01
|
| Series: | Spreadsheets in Education |
| Online Access: | https://sie.scholasticahq.com/article/4640-power-system-state-estimation-using-microsoft-excel |
| _version_ | 1827119432519909376 |
|---|---|
| author | K. S. Sastry Musti Balasubrahmanyam P.V. Rajesh Reddy Malireddy |
| author_facet | K. S. Sastry Musti Balasubrahmanyam P.V. Rajesh Reddy Malireddy |
| author_sort | K. S. Sastry Musti |
| collection | DOAJ |
| description | This paper presents the design and development of a Microsoft Excel based tool for Power System Static State Estimation. This tool can be effectively used to understand the process of state estimation and its real-time application. The tool contains Newton-Raphson load flow that provides system measurements, which are used as inputs to the state estimator that uses the popular weighted least square (WLS) algorithm. The spreadsheet has features for corrupting the data to simulate wide ranging scenarios of data errors. With the user-friendly screens, this can be a versatile desktop tool for learning and experimenting with the Power System State Estimation. Different system loading and operating configurations and wide range of corrupted measurements can be simulated for obtaining the reliable state estimator. All intermediate numerical results are made available for verification purposes. For illustration IEEE 14 bus system is considered. |
| first_indexed | 2024-04-11T03:22:35Z |
| format | Article |
| id | doaj.art-709adcb84ba34029b492575567b34680 |
| institution | Directory Open Access Journal |
| issn | 1448-6156 |
| language | English |
| last_indexed | 2025-03-20T13:21:15Z |
| publishDate | 2014-01-01 |
| publisher | McMaster University |
| record_format | Article |
| series | Spreadsheets in Education |
| spelling | doaj.art-709adcb84ba34029b492575567b346802024-09-12T22:46:25ZengMcMaster UniversitySpreadsheets in Education1448-61562014-01-0181Power System State Estimation using Microsoft ExcelK. S. Sastry MustiBalasubrahmanyam P.V.Rajesh Reddy MalireddyThis paper presents the design and development of a Microsoft Excel based tool for Power System Static State Estimation. This tool can be effectively used to understand the process of state estimation and its real-time application. The tool contains Newton-Raphson load flow that provides system measurements, which are used as inputs to the state estimator that uses the popular weighted least square (WLS) algorithm. The spreadsheet has features for corrupting the data to simulate wide ranging scenarios of data errors. With the user-friendly screens, this can be a versatile desktop tool for learning and experimenting with the Power System State Estimation. Different system loading and operating configurations and wide range of corrupted measurements can be simulated for obtaining the reliable state estimator. All intermediate numerical results are made available for verification purposes. For illustration IEEE 14 bus system is considered.https://sie.scholasticahq.com/article/4640-power-system-state-estimation-using-microsoft-excel |
| spellingShingle | K. S. Sastry Musti Balasubrahmanyam P.V. Rajesh Reddy Malireddy Power System State Estimation using Microsoft Excel Spreadsheets in Education |
| title | Power System State Estimation using Microsoft Excel |
| title_full | Power System State Estimation using Microsoft Excel |
| title_fullStr | Power System State Estimation using Microsoft Excel |
| title_full_unstemmed | Power System State Estimation using Microsoft Excel |
| title_short | Power System State Estimation using Microsoft Excel |
| title_sort | power system state estimation using microsoft excel |
| url | https://sie.scholasticahq.com/article/4640-power-system-state-estimation-using-microsoft-excel |
| work_keys_str_mv | AT kssastrymusti powersystemstateestimationusingmicrosoftexcel AT balasubrahmanyampv powersystemstateestimationusingmicrosoftexcel AT rajeshreddymalireddy powersystemstateestimationusingmicrosoftexcel |