Exceltemplates.org – The main reason to calculate link budget when designing point-to-point or point-to-multi point wireless connection is to make sure that the established connection is reliable. For network operators, this should be a number one priority. How do you think each mobile phone base stations are connected? They are connected with Microwave radios. It is a fastest solutions to connect them. Usually fiber optic/cable connection is their number one choice, but it will take time in area where they are not available yet.
Because microwave radio link is the fastest solutions, radio engineers should design the connection carefully. As mobile phone users, you don’t want to get interrupted while communicating with your friends, right? Part of designing it, is to define type of Microwave antenna that will be used and its power requirement. They need to be Line of Sight or there must be no barriers between two point-to-point microwave antenna. That’s why you may see those microwave antenna on top of base station towers or on top of high rise buildings.
With the raise of internet, it is easy to find tools to help any engineers selecting the correct Microwave antenna and its power equipment. One of those simple tool is created in Microsoft Excel that you can download it below. Put required parameters, and then you can find microwave equipment that meet calculated criteria.
Parameters that you can put inside this spreadsheet are :
- Transmit power, its cable loss and antenna gain
- Line of Sight distance
- Receiver antenna gain, its cable loss, sensitivity and received power
- Receiver modulation
Above values can be taken from Microwave antenna specification that you can get it from internet. If I am not mistaken, Andrew is one of popular microwave antenna where their specification can be taken as your references. It should be easier if you already have installed equipment where you can see its characteristic while they are in operating modes.
Using Microsoft Excel to simplify your spreadsheet tasks is not as difficult as you think. I learned how to use it in less than 24 hours and rely on internet to find the solution if I got stuck. I am not an Excel expert, but here are all useful spreadsheets I have collected and created.