📦 Resource excel

Small-Signal Stability Modal Analysis Template

The Small-Signal Stability Modal Analysis Template is an Excel-based computational and visualization tool designed to perform eigenvalue-based modal analysis of power system linearized dynamic models. It processes system state matrices (A-matrix) derived from load flow and linearized differential-algebraic equations to compute eigenvalues, damping ratios, mode shapes, and participation factors. The template supports engineers in identifying poorly damped or unstable electromechanical oscillation modes and assessing controller impacts.

📖 Overview

Small-signal stability refers to a power system's ability to maintain synchronism under small disturbances—such as minor load changes or generator perturbations—through inherent damping of rotor angle oscillations. Modal analysis decomposes the linearized system dynamics into decoupled oscillatory modes via eigenanalysis of the state matrix A; each eigenvalue λ_i = σ_i + jω_i encodes mode frequency (ω_i), damping (σ_i), and stability (Re(λ_i) < 0 for stable modes). The Excel template automates key post-processing steps: computing damping ratio ζ_i = −σ_i / |λ_i|, natural frequency f_n,i = ω_i / (2π), mode shape vectors (eigenvectors), and participation factors that quantify how strongly each state variable (e.g., rotor angle, speed, exciter voltage) contributes to a given mode. It typically integrates with industry-standard simulation outputs (e.g., PSS/E .raw + .dyr files or MATLAB/Simulink linearization exports) and includes built-in validation checks (e.g., matrix rank, controllability observability flags) and interactive dashboards for mode clustering, time-domain validation links, and sensitivity tagging. This resource bridges theoretical modal analysis with practical engineering workflows—enabling rapid screening of inter-area vs. local modes, tuning of Power System Stabilizers (PSS), and compliance assessment against grid codes (e.g., NERC MOD-025, ENTSO-E RfG Annex 4).

📑 Key Components

1 State Matrix (A-matrix) Import & Validation
2 Eigenvalue Solver & Modal Metrics Dashboard
3 Participation Factor Matrix & Mode Shape Visualization

🎯 Applications

  • Identifying low-damping inter-area oscillation modes (0.1–0.7 Hz)
  • Evaluating PSS tuning effectiveness and placement
  • Assessing impact of renewable integration (e.g., inverter-based resources) on system damping

📐 Key Formulas

Damping Ratio

ζ = −σ / √(σ² + ω²)

Quantifies relative damping of an oscillatory mode; ζ < 0.03–0.05 indicates poor damping requiring mitigation.

Electromechanical Oscillation Frequency

f_n = ω / (2π)

Natural frequency (Hz) of a mode, critical for distinguishing local (0.8–2.0 Hz) from inter-area (0.1–0.7 Hz) oscillations.

Participation Factor

P_{ij} = |φ_{i,j} × ψ_{j,i}|²

Measures contribution of state variable i to mode j, where φ and ψ are right and left eigenvectors of A.

🔗 Related Concepts

Power System Linearization Eigenvalue Sensitivity Analysis Power System Stabilizer (PSS) Design

📚 References

#power-systems #modal-analysis #excel-tool