Transmission planning Excel Macro

**phunghm** · 2011-08-09, 11:25 PM

Let's use Direct module in Aircom Enterprise Suite.
It's much much more detail than what you need, even node transmission dimensioning base on site/node RF configuration or updated by calculation from actual RAN user traffic.

Originally Posted by hakimgsm

Hi,

Many thanks for sharing, good tool, I needed more advanced tools.
BR

**ruedeberry** · 2011-08-11, 06:48 PM

Dear mayank_shah,

Please can you share the description which fields are required for this Macro to run and which command in Excel 2007?, I have office 2007 and tried to run TX utilization Macro but I am not able to run it . Your help is required to solve this issue.

Thanks

BR//

Originally Posted by mayank_shah

Hi All,

Please find attached Macro for calculating Link Capacity.

**parash** · 2012-02-05, 03:21 PM

how to use it i could not run it

**mayank_shah** · 2012-02-22, 04:20 PM

Hi,

Please find attached Macro for 2007.

Regards,
Mayank Shah
LinkCapacityCalculator.zip

**ruedeberry** · 2012-08-21, 01:56 AM

Dear Mayanak_shah,
Could you please put some long chain example in this macro, like 10 or more MW hops. as you know the sites far from the POP have less utilization than the sites closer to the POP location.

I have tried to put a mw chain , but utilization for all the Hops is coming equal value. could you please help with such example of 10 or more(2G+3G) sites in a MW chain...

Thanks in advance

BR//

Originally Posted by mayank_shah

Hi,

Please find attached Macro for 2007.

Regards,
Mayank Shah
LinkCapacityCalculator.zip