Transmission Link Planning Tool for Excel™
(Version 7a - January 9, 2015)
Mr. Alok K. Tiwari, of Idea Cellular Ltd., has graciously made this "Transmission Link Planning Tool" workbook available. Says Mr. Tiwari, "Based on users feedback regarding some of the buttons not working properly, I have just gone through the sheet to make those necessary corrections in the macro used. Almost no change has been made in formulas." Please also see the UMTS Link Planning Tool as well.
Here is the description for using the utility:
DISCLAIMER: Use of this UTILITY is not intended for any commercial set-up. The author is not responsible for any type of damage occurred due to implementation of the results obtained from this utility to any commercial set-up.
The "Calculation" sheet looks up for the required data :
3. The Sheet "Report" is just the
This is to bring to your kind notice that formulae used into this workbook are as per ITU-T.As I'm using the Tool like Nokia's NETACT PLANNER and CTE's PATHLOSS, I've observed the similar results at least for Link Design parameters.
NEW (v7a): "Technical Information"
1. Back-to-back coupled Passive Repeater calculations.
NEW (v7): "Technical Information"
Added the provision to use this utility globally and it can be done just by selecting the appropriate part of the globe. Additionally, the facility to explore different type of geographic clutter has also been introduced.
NEW (v6): "Technical Information"
Select any one of the THREE frequency bands, namely 15 GHz, 18 GHz and 7 GHz. Each band is provided with 6 frequency spots. The same provision is there for Radio selection too.
NEW (v5): "Technical Information"
A "Technical Information" page has been added in order to have easy understanding of the principles involved in a Microwave Link Designing. Also, more automated buttons have been added.
NEW (v4): Graphical Link Analysis
Provision to view/analyse the link graphically ( Addition of : Path Profile) over a approximated Terrain.
NEW (v3): Selection Buttons
To make this spreadsheet more useful I have made this spreadsheet more user friendly by putting some "buttons" so that one can select the values by using these buttons without typing or looking for the other sheets.
NEW (v2): Passive Repeater worksheet
Back-to-back coupled Passive Repeater calculations. Use: 'passive' to unlock the worksheet to edit values.
Hope this will suffice. For further clarification/suggestion feel free to contact under signed.
Thanks and with warm regards,