// consulting tools
Tools
11 file-processing apps that run entirely in your browser. Drop in a CSV / JSON / waveform, get a cleaned XLSX, plot, or anonymised file out — nothing is uploaded anywhere. Pairs with the interactive labs: labs build the intuition, tools ship the deliverable.
Data wrangling
CSV/JSON parsing, cleaning, anonymising — the prep work before a study.
Bulk Per-Unit Converter
Paste or upload a list of values, choose direction (physical → pu or pu → physical), pick the quantity (V, I, Z, S), and set the system base. Downloads a CSV with one converted value per row.
Network Anonymiser
Upload a power-network JSON or CSV. Replaces bus / station / site names with deterministic codes (B01, B02, …) so the data can be shared with vendors, students, or in published material. Outputs the anonymised file plus a mapping table for de-anonymisation.
PowerFactory / Solver CSV Cleaner
Upload a solver-output CSV (PowerFactory, PSS/E, Python script). Drop blank rows, choose which columns to keep, set decimal precision, and download a clean XLSX (with column widths and number formats) or a clean CSV.
Power flow & per-unit
Bulk conversions and post-processing of load-flow results.
Fault analysis
Build fault-level tables and reports from solver output.
Harmonics
FFT, THD, G5/5 compliance plotting from time-series data.
Harmonic Spectrum Plot with G5/5 Limits (matplotlib)
Upload a per-order spectrum CSV (Order, Magnitude_pct, G5_5_Limit_pct, Status — the format exported by the harmonics lab and by the FFT tool). Get a PDF + PNG chart with bars colour-coded for compliance and dashed G5/5 limit markers — drop straight into a connection-study report.
Time-Series → Harmonic Spectrum (FFT)
Upload a measured or simulated waveform (CSV with time + voltage/current columns), run an FFT in the browser, and see the per-order spectrum compared to ENA G5/5 EHV planning levels. Heavier-duty cousin of the harmonics lab — works on real data.
Report generation
Word and Excel deliverables straight from a results dictionary.
Connection Study Report (python-docx)
Upload a results.json (project metadata, bus voltages, fault results, conclusions) and get a fully-formatted Word .docx with cover page, executive summary, voltage profile + fault-level tables, and conclusions section. Saves about an hour per study and prevents copy-paste errors.
Grid Code & Standards Viewer
Browse and cross-reference UK and EU grid codes, ENA EREC documents, and connection-process artefacts without juggling PDF tabs. Faceted filter (project type × study type × topic × jurisdiction), split-pane viewer with the PDF on the left and related clauses on the right, per-clause permalinks. Link-only for GB documents (NESO Grid Code, EREC G99, Distribution Code etc.) per publisher T&Cs; EU Network Codes can be hosted locally and full-text searched.
VBA macros
Excel macros for the daily grunt work that lives outside the browser.
VBA Macro: Format a Results Table
One-click conversion of a paste-special results dump into a presentation-ready table — borders, header style, frozen header row, autofit columns. Bound to Ctrl+Shift+F.
VBA Macro: Import & Clean a Solver CSV
Open a solver-output CSV (e.g. from PowerFactory or a Python script), parse it into a sheet, drop blank/duplicate rows, coerce numeric columns, and apply the standard table format.