Transmission Link Planning Tool for Excelâ„¢

(Version 7b - February 13, 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.

Click to download compressed fileClick to download


Important: If the file name is changed from the supplied "Link Planning Tool.xls," some of the macros will not function properly. It would be best to save the completed workbook under a new name, then start on new systems with the original file.

Here is the description for using the utility:

  1. We mainly enter the parameter value into the

      sheet "Calculations".

        a. Entries shown in YELLOW cells are

            mandatory.

        b. Entries shown in GREY cells are to play with in order to

            get the desired result wrt Standard Link Design Criteria.

        c. Entries shown in SEA GREEN are ONE-TIME entries like

            temperature, pressure etc.


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.


Link Planner v7b Calculations Worksheet, by Mr. Alok K. TiwariPlease be careful while making any change to Sheet "Calculations" for it contains the most important formulae. Passwords can be provided if needed (aktiwari@hotmail.com).

     The "Calculation" sheet looks up for the required data :

        a. For Antennae (of 18 GHz band) from the sheet:

               "DB_Ant1 (18GHz).

        b. For Antennae (of 15 GHz band) and Frequency of

               Operation from the sheet:"DB_Ant2 (15GHz).

               Note that only FOUR antennae sizes EIGHT Frequencies in TWO

               separate bands can be used.

       c. For Radio Specific Data form the sheet:

              DB_RadioEqpt. Here THREE different type of Radios can be used.

Link Planner v7b Antenna Heights Worksheet, by Mr. Alok K. Tiwari   2. The Sheet "Antenna Heights"

      is to calculate the antennae

      heights based on LOS survey

      feedback data.

3.  The Sheet "Report" is just the

     compilation of information used

     in link implementation.

Link Planner v7b Passive Repeater Worksheet, by Mr. Alok K. Tiwari  

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.

  2. 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.

  3. Provision to view/analyse the link graphically ( Addition of : Path Profile) over a approximated Terrain.

  4. 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.

  5. Now you can 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.

  6. 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.

      Passwords can be furnished on request.

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,

Alok K. Tiwari Head

Network Planning

Idea Cellular Ltd

Delhi (INDIA)

alok.tiwari@idea.adityabirla.com

aktiwari@hotmail.com

Mobile # +91 9990009370