Tool or Excel Macro to Visualize RB Interference in NR / LTE

Hi everyone,

Does anyone have a tool, Excel macro, or any other solution that can help visualize RB (Resource Block) interference in NR (5G)?

I’m looking for something that can make it easier to identify and analyze interference at the RB level.

Thanks!

Hi @mharris ,

Do you mean UL interference per PRB measured at the gNB side, or DL interference based on UE logs?

Also, which vendor and log format are you working with? That information would help narrow down the appropriate tool or solution.

I mean on the gNB side.

We’re using ZTE, and we have interference counters for each RB from 0 to 272.

So basically, I’m looking for a simple way to plot it and get a visual view of the interference across the RBs.

Got it.

I think a PRB heatmap would probably be the clearest way to visualize it - PRB 0–272 on the X-axis, time on the Y-axis, and the interference level represented by color.

That would make it pretty easy to spot interference peaks and see which PRBs are being affected over time.

Yeah, I already did that.

The problem is that to view all the PRBs, I have to keep scrolling the Excel sheet from left to right every time I change the cell.

It’s not very practical for quickly checking the interference pattern. :frowning:

Like this:

But I’m not able to see all the PRBs in one view. I have to scroll left and right, which makes it difficult to get the overall interference pattern at a glance.

Maybe you could use a heatmap like this, with the PRBs on the Y-axis and time on the X-axis. That way, all 273 PRBs can be displayed in a single view, so you don’t have to keep scrolling horizontally.

You could ask Claude, ChatGPT, or any other AI to generate the script for whatever tool you prefer (Python, VBA, etc.). Just attach your raw data format along with this image as a reference for the target visualization.

This is from an old project I worked on. Nowadays, you can build a pretty comprehensive interference dashboard with Claude or Gemini just by giving it a good prompt and your raw data.

You could include things like a waterfall plot, mean/min/max plots, and cascade plots to get a much better view of the interference behavior over time and across the PRBs.

How can you help me with this, please? It looks amazing! :hugs:

That was 6 years ago, back when we were doing this in Excel. Pretty much useless now :joy:

LTE Uplink Interference Analytics Dashboard.zip (347.3 KB)

Just feed the data to any LLM and ask it to build the plots I mentioned earlier.

I just tried it with Gemini — I included the prompt, the dashboard requirements, and some sample data, and it generated it.

You can select the site, cells, legend range, colors, and even reorient the plots — all with just a prompt!!!

Data analytics has become that easy. No need to spend hours writing Python/Java scripts or Excel macros. Just use a local LLM or one of the online ones, feed it your data, and ask it to build what you need.

Get insights from your data without wasting time. :rocket:

Agree the plotting is the easy part now, an LLM or a short script draws the heatmap fine. What decides whether the picture is useful is the input and how you read it, and that is where most of these go wrong.

For a real per-RB view you need the per-PRB uplink received interference power, one value per PRB across the band, per cell, per ROP, not cell-level UL RSSI or a single interference KPI, which hide exactly what you are trying to see. The exact counter is vendor and release specific, on Ericsson it is the per-PRB PUSCH received interference power measurement, on Huawei the per-RB UL interference counter, so pull that from your MOM rather than an averaged cell metric.

Then the plot is a heatmap, PRB index on one axis, time or ROP on the other, colour as interference power in dBm, one per cell. The read is the value, not the colours: a narrow band of hot PRBs that stays fixed is an external interferer, a repeater, or PIM on specific frequencies, while a flat raised floor across all PRBs is broadband noise or receiver desense. Same heatmap, two different root causes. Feed the LLM per-PRB interference power, not cell-average RSSI, and fix the colour scale so a 3 dB local rise does not read the same as a 20 dB interferer.

Hi everyone, I released a free vendor-neutral PRB interference visualizer. It accepts CSV and XLSX, supports wide and long counter formats, and generates a heatmap plus PRB and time statistics. Files stay in the browser.