Link Planning Tools using excell

View previous topic View next topic Go down

Link Planning Tools using excell

Post  anwar on Tue Feb 23, 2010 7:40 pm

R. Alok K. Tiwari, of Idea Cellular Ltd., has graciously made this "Transmission Link Planning" workbook available. The following text is provided by Mr. Tiwari:

[You must be registered and logged in to see this link.]

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.
[You must be registered and logged in to see this image.]
Link Planner v7 Calculations Worksheet, by Mr. Alok K. Tiwari

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.
[You must be registered and logged in to see this image.]
Link Planner v7 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.
[You must be registered and logged in to see this image.]
Link Planner v7 Passive Repeater Worksheet, by Mr. Alok K. Tiwari

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.
avatar
anwar
Admin

Posts : 16
Join date : 2010-02-23
Age : 31
Location : Jakarta

http://www.pathloss40.co.cc

Back to top Go down

Download Link

Post  anwar on Tue Feb 23, 2010 7:41 pm

[You must be registered and logged in to see this link.]
avatar
anwar
Admin

Posts : 16
Join date : 2010-02-23
Age : 31
Location : Jakarta

http://www.pathloss40.co.cc

Back to top Go down

Re: Link Planning Tools using excell

Post  anwar on Tue Feb 23, 2010 7:42 pm

lol!
avatar
anwar
Admin

Posts : 16
Join date : 2010-02-23
Age : 31
Location : Jakarta

http://www.pathloss40.co.cc

Back to top Go down

2.4/5.8ghz link

Post  ginola on Thu Nov 17, 2011 3:22 pm

can i use this program to plan a 2.4 or 5.8ghz link?

ginola
Junior Member
Junior Member

Posts : 2
Join date : 2011-11-17

Back to top Go down

Re: Link Planning Tools using excell

Post  Mumin Shareef on Sat Dec 29, 2012 4:40 pm

ginola wrote:can i use this program to plan a 2.4 or 5.8ghz link?

Good question.......

Mumin Shareef
Junior Member
Junior Member

Posts : 1
Join date : 2012-12-29

Back to top Go down

Re: Link Planning Tools using excell

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum