Excel showing computation of SSRSRP and SSRSRQ

Hi All,
Anyone having Excel showing computation of SSRSRP and SSRSRQ?
Please share…

Isn’t thsi related to IE ss-PBCH-BlockPower : 16 ?

It’s for ssb rsrp and ssb rsrq value calculation, how ue compute it.

I think is well explained here:

SS-RSRQ: SS-RSRQ stands for Secondary synchronization Signal Reference Signal Received Quality. It is defined as the ratio of N×SS-RSRP /NR carrier RSSI, where N is the number of resource blocks in the NR carrier RSSI measurement bandwidth. The measurements in the numerator and denominator shall be made over the same set of resource blocks.

SS-RSRP: SS-RSRP stands for Synchronization Signal reference signal received power. It is defined as the linear average over the power contributions (in Watt) of the resource elements that carry SSS. The measurement time resource(s) for SS-RSRP are confined within SS/PBCH Block Measurement Time Configuration (SMTC) window duration.

Both are measured on SSS: