How to check PCI Mod 3 Conflicts with Excel

[Mustafa_Rawat]

To check PCI (Physical Cell Identity) Mod 3 conflict for two cells in LTE using an Excel formula, you can follow these steps:

1. Prepare your data: Create an Excel spreadsheet and organize your data in columns, with each cell represented by its corresponding PCI.

2. Use a formula in Excel: In a separate column, you can use the following formula to check for PCI Mod 3 conflicts between two cells:

=MOD(ABS(A1-B1), 3)

Here, A1 and B1 represent the cell references for the two PCI values you want to compare.

3. Interpret the results: The formula will output a result between 0 and 2. If the result is 0, it means there is a PCI conflict under Mod 3. If the result is 1 or 2, there is no conflict.

Using this formula, you can easily identify whether there is a PCI Mod 3 conflict between two cells in LTE. You can apply the formula to multiple pairs of cells by dragging it down the column or extending the formula horizontally.

[Hector_Avana]

Hello everybody.

Does someone here have Excel macro to check LTE PCI and 3G PSC conflict?

[HSN]

Here is the PCI / PSC conflict macro:

PCI Audit Macro.xlsm.zip (6.3 MB)

[Mohamed_Hassan]

You can also try Maestro tool, that canplot any Cell attribute (PCI/PSC/BCCH/TCH/LAC/TAC)

Use the KML section.

It has a well explained documentation - and it’s totally free and offline.

Cell Neighbor Planning Maestro

Dear RF Engineers, [Cell Neighbor Planning Maestro] Cell Neighbor Planning Maestro_UserManual.pdf (633.5 KB) It’s my utter pleasure to announce the completion of the development of my first Cell Neighbor Planning tool which is called [Cell Neighbor Planning Maestro]; it’s a free alternative to the licensed neighbor planning tools which sometimes we cannot afford. Yes, now you can save your money and still have great results. It’s a totally free-to-use tool, with some cool features: Cellula…

[pankaj_kulkarni]

@Mustafa_Rawat

=MOD(ABS(A1-B1), 3)

My query: even if above formula can work for LTE or 5G PCI Mod 3 conflict, but what is use case of this conflict?

E.g. in LTE, if PCI of 2 cells is 166 and 451, as per formula they have same phy layer cell Id within their respective phy layer Cell identity group(=1), but they belong to different phy layer Cell identity groups.

[Mohamed_Hassan]

We need to understand what is the effect of such thing - the PCI Mode 3 is used to calculate the position of the RS signal within the RB matrix and hence it guides to determine the signal strength and measurements of that cell.

If 2 cells pointing to each other had the same position of the RS, that what’s called the conflict.

*Collision if the 2 has the exact same PCI.

[pankaj_kulkarni]

As per snapshot above for 36.211 Spec, in the formula as per section 6.10.1.2, position of CRS, freq shift formula:–NcellId mod 6…

So accordingly, each frequency shift covers 84 different Cell identities.

So PCI mod 3 is not the right formula to decide conflict while choosing position of CRS in LTE.

[Mohamed_Hassan]

My explanation was for LTE 1st port.

Port 2 is mod6 for LTE.

[pankaj_kulkarni]

Freq shift formula is Always same, depends on PCI.