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.
PASSWORDS:
Sheet "Calculations" : Password "link"
Sheet "Antenna Heights": Password "antennae"
Sheet "Report": Password "report"
Sheet "DB_Ant1(18Ghz)": Password "antennae"
Sheet "DB_Ant2(15Ghz)": Password "antennae"
Sheet "DB_RadioEqpt": Password "radio"
Sheet "PassiveRepeater": Password "passive"
Above Passwords are activated into the file attached to this mail.
Please be careful while making any change to Sheet "Calculations" for it contains the most important formulae.
The "Calculation" sheet looks up for the required data :
a. For Antennae (of 18 GHz band) from the sheet:
"DB_Ant1 (18GHz).Using the Password sizes and gains can be modified.
Note that only FOUR sizes are permissible to provide into this sheet.
b. For Antennae (of 15 GHz band) and Frequency of
Operation from the sheet:"DB_Ant2 (15GHz). Using
Password sizes and gains can be modified. Note that only FOUR antennae sizes EIGHT Frequencies in TWO separate bands can be used. Also do not change the frequency named F1,F2,....F6,G1,G2.Only their respective values can be changed.
c. For Radio Specific Data form the Sheet :DB_RadioEqpt.
Using Password we can also modify the Radio Names,
their signature data and Radio Parameters. Here THREE different type of Radios can be used.
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.
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.
Passive Repeater worksheet
Back-to-back coupled Passive Repeater calculations. Use: 'passive' to unlock the worksheet to edit values.
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.
Graphical Link Analysis
Provision to view/analyse the link graphically ( Addition of : Path Profile) over a approximated Terrain.
