MW Link Planning Test

16
MICROWAVE LINK PLANNING Basic Information: 0 GHz Speed of Light, c 0 MHz Plank's Constant, h 0 Hz #DIV/0! #DIV/0! ft #DIV/0! in #DIV/0! cm #DIV/0! #DIV/0! eV Highest Tower Latitude, Lath Highest Tower Longitude, Lonh Lowest Tower Latitude, LatL Lowest Tower Longitude, LonL 0 miles (statute) 1/2 distance 0.000 meters 0.000 feet 0.000 km 0 feet 0.000 meters 0 feet 0.000 meters 0 feet 0.000 meter 0 feet 0.000 meter Radio Capacity 155 Mbps ANTENNA Dish Diameter Gain, Low ft dB dBm Specifications 2.6 52 36.9 Operating Frequency Band 10.700 to 11.700 EQUIPMENT Speed (Mbps) Channel (MHz) Rx Threshold (dBm)* Radio Specifications QPSK 0 0 0 16QAM 154 40 0 32QAM 155 40 -73 Planned Frequency, f meters, λ mm (or μm) Hop/Tower Distance, d Highest Elevation, H1 With Antenna 1, he Lowest Elevation, H2 With Antenna 2, hL 1st Antenna Height (AGL), T1 Antenna Height Differ 2nd Antenna Height (AGL), T2 Front to Back ratio

description

This is a work in progress for a spreadsheet that will provide some fairly helpful and comprehensive link planning tools for people just needing some generic / free info for microwave point to point link planning

Transcript of MW Link Planning Test

Page 1: MW Link Planning Test

MICROWAVE LINK PLANNING

Basic Information:0 GHz Speed of Light, c0 MHz Plank's Constant, h0 Hz

#DIV/0!#DIV/0! ft#DIV/0! in#DIV/0! cm#DIV/0!#DIV/0! eV

Highest Tower Latitude, LathHighest Tower Longitude, LonhLowest Tower Latitude, LatLLowest Tower Longitude, LonL

0 miles (statute) 1/2 distance0.000 meters0.000 feet0.000 km

0 feet0.000 meters

0 feet0.000 meters

0 feet0.000 meter

0 feet0.000 meter

Radio Capacity 155 Mbps

ANTENNA Dish Diameter Front to Back ratio Gain, Low ft dB dBm

Specifications 2.6 52 36.9Operating Frequency Band 10.700 to 11.700

EQUIPMENT Speed (Mbps) Channel (MHz) Rx Threshold (dBm)*Radio SpecificationsQPSK 0 0 016QAM 154 40 032QAM 155 40 -7364QAM 0 0 0128QAM 160 30 -68256QAM 0 0 0Other Equipment Specifications Channel (MHz) Loss (dBm)

Planned Frequency, f

meters, λ

mm (or μm)

Hop/Tower Distance, d

Highest Elevation, H1 With Antenna 1, he

Lowest Elevation, H2 With Antenna 2, hL

1st Antenna Height (AGL), T1 Antenna Height Difference, Δh

2nd Antenna Height (AGL), T2

Page 2: MW Link Planning Test

[Equipment Name] 0 0

TRANSMISSION CABLE Tx Rx

Cable Type Copper CopperCable Size 0.50 0.50 inCable Length 60.00 60.00 ft

18.288 18.288 mCable Loss per 100 ft, dB 0.6465 0.6465 dBTotal Loss per Cable 0.388 0.388 dBBranching LossConnector LossTotal Cable Loss 0.388 0.388Total Losses 0.776 dB

ELLIPTICAL WAVEGUIDE Tx Rx

Waveguide TypeWaveguide Size 0.50 0.50 inWaveguide Length 60.00 60.00 ft

18.288 18.288 mWG Loss per 100 ft, dB 2.71 2.71 dBTotal Loss per WG 1.626 1.626 dBBranching LossConnector LossTotal WG Loss 1.626 1.626Total Losses 3.252 dB

LINK ESTIMATIONSITU-R P.525 Total ReceiverFree Space Loss, FSL Err:502 dB Err:502(Highest Value will be used) Err:502 dB Err:502

#DIV/0!Err:502 dB Err:502Err:502 dB Err:502

QPSK 16QAM 32QAMErr:502 Err:502 Err:502

0.0 23.0 26.036.9 36.9 36.9

EIRP 34.9 57.9 60.93.1 614.6 1226.3

17.7 17.7 17.7Err:502 Err:502 Err:502Err:502 Err:502 Err:502

Nominal Rx Signal Level, RSL (EOL) Err:502 Err:502 Err:5020.0 0.0 73.00.0 23.0 -47.0

PATH AVAILABILITY 99.99% 99.999% 99.9999%Availability % 99999.95% #NAME?Terrain Factor, a 1 1 1

Lbf

Received Signal Level, PR

Transmitted Signal Level, PTx

Transmitting Antenna Gain, GTx

Return Loss, GRxloss

Recieving Antenna Gain, GRx

Adj. Recieving Antenna Gain, Grxadj

Rx Sensitivity, Ps

System Gain, SG

Page 3: MW Link Planning Test

Climatic Factor, b 0.125 0.125 0.125

FADE MARGINInitial Selected Modulation 32QAM

99.99% 99.999% 99.9999%#DIV/0! #DIV/0! #DIV/0!

Fade Margin, A Err:502 Err:502 Err:502Err:502 Err:502 Err:502Err:502 Err:502 Err:502

ATTENUATIONVegetation Loss, L 0 dBMax Protruding Vegetation Height 0 feet

0 metersRecommendation P.341-5

RAIN ATTENUATION, Rec. ITU-RPN.837-1 or 838-3Rain Zone: DRain Rate 19 mm/hr

99.90% 99.99%8 19

Constants for Specific Frequency Leffective0.017720.01731

1.2141.1617

0 kmHorizontal Attenuation (dB/km) 0.221 0.632Vertical Attenuation (dB/km) 0.194 0.529Total Horizontal Attenuation (dB) 0.000 0.000Total Vertical Attenuation (dB) 0.000 0.000

% of Time Fade Depth is Exceeded #DIV/0!Fade Occurrence Factor #DIV/0!

#DIV/0!Attenuation Factor A Above 30 deg North or South -0.374Attenuation Factor B Below 30 deg North or South -0.2990

Total Attenuation, h above 30 #DIV/0!Total Attenuation, v above 30 #DIV/0!Total Attenuation, h below 30 #DIV/0!Total Attenuation, v below 30 #DIV/0!

MULTIPATH FADING0.0000

#DIV/0!Magnitude of Path Inclination, |εP| #DIV/0! mradGeo Climactic Factor, k #DIV/0!

#DIV/0!#DIV/0!

3.54392891542E-07

Minimum Fade Margin, Amin

Test Pr>Ps

1% Rain Rate, R0.1

Specific Attenuation, γR0.01=kh,v * R0.01αh,v

kh

kv

αh

αv

Effective Path Length, Leff

Probability of Outtage, PO=Kd3.2(1+|εP|)-0.97×100.032f-0.00085hL-A/10

Worst Month Probability (One Way), OWM

Fade Margin A factor 1, AF1

Fade Margin A factor 1, AF2

Page 4: MW Link Planning Test

Temperature, T 15.55 celsius15355.66668 k

Atmospheric Pressure, P 80833.7477 hpaWater Vapor Pressure, e 0.001765863880551 hpaConstant, C 8

20408.494

relative humidity %, H 1%-8.520

0dN1 #DIV/0!

Finalized kd #DIV/0! #DIV/0!

99.90% 99.99%Fade Depth, A, (dBm) #DIV/0! #DIV/0!Minimum Fade Margin to Suppress Multipath Fading #DIV/0! #DIV/0!

#DIV/0! meters#DIV/0! feet#DIV/0! feet

0.000 feet#DIV/0! feet#DIV/0! km

60% First Fresnel Zone #DIV/0!Earth Bulge, B1 0Height #DIV/0!Midpoint Clearance 11.3333333333333K 1.33333333333333Midpoint Earth Curvature, B 0

Nth Fresnel Zone Depth 1st 2nd 3rdDistance to First Zone, d1 0.099 2.400 3.150

0.159 3.862 5.069Zone Depth #NUM! #NUM! #NUM!

2676.000 2670.000 2646.250815.645 813.816 806.577

0.816 0.814 0.807C, B1 + f 0 0 0Slope #DIV/0! #DIV/0! #DIV/0!OHTower Height, TH #DIV/0! #DIV/0! #DIV/0!

#DIV/0! #DIV/0! #DIV/0!

Fresnel Zone, Fz, 60%

height los to path blockage, hdiffraction loss, Asubd

Antenna 1, he

Ducting, pl

N1 & N2

N2 - N1

D2 - D1

Fresnel Zone Max Radius, FZRmax

Tower Height for Fresnel Zone Clearance, H1

Tower Height for Earth Bulge Clearance, H2

Total Combined Additional Height, H3

First Fresnel Zone, F1

Peak Critical Obstruction Height, Ep

Page 5: MW Link Planning Test

From Barnett/Vigantsmodel 0.9999MFM = -10LOG[(1-PR)/(2.5x10-6abfD3 #DIV/0!a 1 1 1b 0.25 0.25 0.25

Page 6: MW Link Planning Test

299792458 m/s6.626068E-34

0 miles (statute) normalized length, X0.000 meters max deflection, asub-10 db (deg)0.000 feet antenna, d 2.60.000 km

0.000 feet normalized antenna height, y10.000 meter normalized antenna height, y20.000 feet near field distance, RFF= 2D2/λ0.000 meter

0.000 feet (Right Angle Opposite)

Gain, Mid Gain, High Return Loss VSWRdBm dBm dB 1 to ____37.4 38.3 17.7 30

GHz

Tx Power (dBm)155

0 QPSK23 16QAM26 32QAM

0 64QAM25 128QAM

0 256QAM

m2kg/s

Down Tilt Angle, θe

Up Tilt Angle, θL

Antenna Height Difference, Δh

*BER=10-6 dBm)

Page 7: MW Link Planning Test

QPSK

dBdB

dBdB

64QAM 128QAM 256QAMErr:502 Err:502 Err:502 dBm

0.0 25.0 0.0 dBm *or Output Power36.9 36.9 36.9 dBi34.9 59.9 34.9 dBm

3.1 974.1 3.1 watts17.7 17.7 17.7 dBi

Err:502 Err:502 Err:502 dBi *Assumed 60% EfficiencyErr:502 Err:502 Err:502 dBiErr:502 Err:502 Err:502 dBi

0.0 68.0 0.0 dBm0.0 -43.0 0.0 Linear path loss, PL

99.99999%#NAME? eq. = (1-(2.5*a*b*(f in MHz)*((d in km)^3)*(10-(d in km)/10)*(10^-6)))*(1000.9995)-1

1

eq. = 34.22 + 20logf + 20logd, d in km, f in MHzeq. = 36.6 + 20logf + 20logd, d in miles, f in MHzeq. = 20 * log * ((4*pi()*d)/λ)eq. = 96.60 + 20logf + 20logd, d in miles, f in GHzeq. = 92.44 + 20logf + 20logd, d in km, f in GHz

eq. = PT + GT + GR - FSL

Effective isotropic radiated power eq = GTx + (Radio Power, PTx)- Transmission Cable Losses

eq. = GRX - GRXloss

EOL, End of Line, eq. = Adjusted Rx Level GRxadj - All cable losses

Page 8: MW Link Planning Test

0.125

99.99999%#DIV/0! dB *Largest Value of Margins CalculatedErr:502 dB

Err:502Err:502

*Chart Lookup Only

99.999% 99.9999% 99.99999%42 77 124 <--Enter Zero for Frequencies below 10 GHz

*Chart Lookup Onlyeq. for sin^2(x) = SIN(x)^2; with x in radians eq. for sin^2(x) = SIN(A1*PI()/180)^2; with x in degrees

1.656 3.457 6.164 dB/km1.331 2.691 4.680 dB/km0.000 0.000 0.000 dB0.000 0.000 0.000 dB

#DIV/0! #DIV/0! #DIV/0!#DIV/0! #DIV/0! #DIV/0!#DIV/0! #DIV/0! #DIV/0!

-0.331 -0.288 -0.245-0.1600 -0.0210 0.1180#DIV/0! #DIV/0! #DIV/0!#DIV/0! #DIV/0! #DIV/0!#DIV/0! #DIV/0! #DIV/0!#DIV/0! #DIV/0! #DIV/0!

eq. = 0.032f - 0.00085hL

eq. = Ps - PR (or SOM/System Operating Margin)

eq. = 0.2 * f0.3 * R0.6 ; f in MHz, R = max vegetation height in meters

eq. = kh,v * R0.01αh,v

eq. = d/(1 + d/d0); d0 = 35e-0.015R0.01

eq. = Kd3.2 * (1+|εP|)-0.97 * 100.032f - 0.00085hL - A/10

eq. = Kd3.2 * (1+|εP|)-0.97

eq. = (he - hL) / deq. = 10-4.2 - 0.0029dN1

eq. = 10-4.6 - 0.0027dN1

eq. = 10-3.9 - 0.0028dN1 * ((10 + sa)-0.46)eq. = 5 * 10-7 * 10-0.1 * C * (pL

-0.5)

Page 9: MW Link Planning Test

15.55 celsius15355.66668 k

79147.814 hpa0.001765864 hpa

*Chart Lookup

399.9741%

99.999% 99.9999% 99.99999%#DIV/0! #DIV/0! #DIV/0!#DIV/0! #DIV/0! #DIV/0!

eq. = sqrt((d1*d2)/(f*(d1+d2)))

Halfway0.000 miles0.000 km

#NUM! eq. = N * 17.3 * ((d1*d2)/(f * d)^(-1/2))2646.25 feet806.577 meter

0.807 km0

#DIV/0!

#DIV/0! meters#DIV/0! feet

2.5 -2.5 0.991 -0.9914.023368 -4.023368 1.5948630752 -1.5948630752 temp

#DIV/0! meters #DIV/0! #DIV/0!

-2.0816316 meters -1.2192#DIV/0! db #DIV/0!

Antenna 2, hL

eq. = Δd = (N2-N1)/(D2-D1)

eq. = AF1 - (10*LOG((1-%)/AF2)); % = Uptime Reliability % Required

eq. = 8.657*SQRT(d/f); d in km, f in GHz

Page 10: MW Link Planning Test

#DIV/0! #DIV/0!0.99999 0.999999 0.9999999#DIV/0! #DIV/0! #DIV/0! db

10.25

Page 11: MW Link Planning Test

0#DIV/0!0.79248

00

#DIV/0!#DIV/0! degrees #DIV/0! radians#DIV/0! degrees #DIV/0! radians

Page 12: MW Link Planning Test

0.7758 db

Err:502 0 db

eq. = (1-(2.5*a*b*(f in MHz)*((d in km)^3)*(10-(d in km)/10)*(10^-6)))*(1000.9995)-1

eq. = 34.22 + 20logf + 20logd, d in km, f in MHzeq. = 36.6 + 20logf + 20logd, d in miles, f in MHz

eq. = 96.60 + 20logf + 20logd, d in miles, f in GHzeq. = 92.44 + 20logf + 20logd, d in km, f in GHz

Effective isotropic radiated power eq = GTx + (Radio Power, PTx)- Transmission Cable Losses

EOL, End of Line, eq. = Adjusted Rx Level GRxadj - All cable losses

Page 13: MW Link Planning Test

*Largest Value of Margins Calculated

eq. for sin^2(x) = SIN(x)^2; with x in radians eq. for sin^2(x) = SIN(A1*PI()/180)^2; with x in degrees

(or SOM/System Operating Margin)

; f in MHz, R = max vegetation height in meters

); d0 = 35e-0.015R0.01

(1+|εP|)-0.97 * 100.032f - 0.00085hL - A/10

* ((10 + sa)-0.46)

Page 14: MW Link Planning Test

eq. = N * 17.3 * ((d1*d2)/(f * d)^(-1/2))

- (10*LOG((1-%)/AF2)); % = Uptime Reliability % Required

eq. = 8.657*SQRT(d/f); d in km, f in GHz

Page 15: MW Link Planning Test

Rain Zone Amount of Precipitation, mm/h SESR Bit Error RateA 8B 12 Path Type Bit RateC 15 STM-1 155D 19E 22F 28G 30H 32J 35K 42L 60M 63N 95O 115P 145

Max Transmitted PowerFrequency,Max Transmitted Power, dBm

4.5 337 278 27

10.5 2711 2713 2015 2018 1923 1923 1932 1638 14

Page 16: MW Link Planning Test

BERses Block per Bits/Block2.3 x 10-5a 8000 199401.3 x 10-5a + 2.2 192000 801