RF Planning & Optimization

Tools that turn
hours into minutes.

KPI analytics, GIS and automation, built by an RF engineer for the work RF engineers actually do.

Scroll

Flagship · Desktop app

Tofreq.

Hourly KPI, the cell map and Timing Advance, linked in one workspace.

Query-first engineDuckDB aggregates before anything reaches the UI, so large hourly datasets stay responsive.
Cross-filteringPick a cell on a chart and its sector lights up. Click a sector and every chart follows.
Built for RFPer-band sector radius and colour, TA distribution per cell, and measure / select / draw on the map.
PythonPyQt6DuckDBApache ArrowEChartsLeafletSpotfire SBDF

QGIS · Team tool

Neighbor Planner.

Neighbor relations for a whole cluster, without the spreadsheet.

  1. 01Load the site database.
  2. 02Auto-suggest candidate neighbors, one site at a time.
  3. 03Review on the map: add, keep or remove.
  4. 04Walk the whole cluster through your target list and export.

A small helper I put together for my team's everyday planning work.

Python · LINE Messaging API

The weekly KPI report,
now a chat message.

Drop the weekly files in the team chat. The bot checks them, runs the processing and posts the finished report link.

10–15 minevery week, by hand

Before

  1. Receive files in LINE
  2. Download & save
  3. Run the KNIME workflow
  4. Upload manually

After

  1. Files arrive in LINE
  2. Type “run”
  3. Report link posted back
Weekly KPI · Team
LTE_WK2611.csv
KPI Bot✅ LTE file received · WK2611
Header and week checked
NR_WK2611.csv
KPI Bot✅ NR file received · WK2611
All inputs ready. Type “run WK2611”
run WK2611
KPI Bot⚙️ Processing WK2611…
KPI Bot✅ Done. Reports uploaded
📁 drive.google.com/…/WK2611
  • Validates by contentRecognises LTE vs NR from the CSV header, not the filename, and reads the week from the dates inside.
  • Rejects bad input earlyWrong format, mixed weeks or empty KPI columns get a clear reason back in the chat.
  • Survives restartsJob state is saved atomically, so a reboot never loses which files already arrived.
PythonFlaskLINE Messaging APIpandasGoogle Drive APIAPScheduler

Free · plugins.qgis.org

QuickSite & QuickSector.

Public QGIS plugins for drawing RF networks: from one CSV to multi-band sector layers and a clean KML.

Free · Runs in your browser

RF Tools.

The small calculators I reach for every day: power and gain, antenna tilt, EARFCN / NR-ARFCN, Timing Advance, path loss, and CSV to KML.

Made on the job.

About

I plan, optimize and troubleshoot LTE / 5G networks: RF predictions, drive-test analysis and KPI investigations.

Every tool on this page started as a repetitive task on my own desk. I build them in my spare time, then share them with my team or the wider QGIS community.

LTE5G NRRF PlanningOptimizationDrive TestKPI Analytics Mentum PlanetQGISKNIMESpotfirePython

Contact