RF Calculator for Microsoft Excel spreadsheet program

RF Calculator for Microsoft Excel
spreadsheet program



General Use Section (See Signal Booster section below)      
      
1. Find Free Space (clear line of sight) Path Loss      
Enter 800.00 MHz    
Enter 10.00 miles, Path length    
Answer 114.66 dB, Path Loss    
      
2. Convert watts to dBm and dBW      
Enter 18.000 watt    
Answer 42.55 dBm    
Answer 12.55 dBW    
      
3. Convert dBm to watts and milliwatts      
Enter 37.00 dBm    
Answer 5.011872 watts    
Answer  5011.872336 milliwatts    
      
4. Convert uV to dBm (50 ohm impedance)      
Enter 10.00 uV    
Answer -86.99 dBm    
      
5. Convert dBm to uV (50 ohm impedance)      
Enter -60.00 dBm    
Answer 223.61 uV    
      
6. Convert dBW to uV (50 ohm impedance)      
Enter -120.00 dBW    
Answer 7.07 uV    
      
7. Convert dBu and Freq. to dBm and uV      
Enter  65.59 dBu    
Enter 850 MHz    
Answer -68.00 dBm    
Answer 89.04 uV    
      
8. Convert dBm and Freq. to Field Strength in dBu and mV/meter (relative to a dipole)       
Enter  850.00 MHz    
Enter  -70.00 dBm    
Answer 63.59 dBu (dB above 1 uV/meter)    
Answer 1.512 mV/meter    
      
9. Calculate Return Loss and VSWR from Power out and Power reflected      
Use the same base (w or mW) in both power level entries      
Enter Power Forward  17 w or mw   
Enter Power Reflected  0.05 w or mw   
Return Loss =  25.31 dBRL   
VSWR =  1.11 :1 ratio   
      
10. Calculate Vertical Ant to Ant Isolation (Based on Dipoles)      
Enter 0.00 dB: Top antenna gain toward bottom antenna    
Enter 0.00 dB: Bottom antenna gain toward top antenna    
Enter 30.00 feet (Vertical separation)    
Enter  850.00 MHz    
Answer 84.54 dB Isolation    
      
11. Calculate Horizontal Ant to Ant Isolation (Based on Dipoles)      
Enter  0.00 dB: Left antenna gain toward Right antenna    
Enter  0.00 dB: Right antenna gain toward Left antenna    
Enter  100.00 feet (Horizontal separation)    
Enter  850.00 MHz    
Answer 60.73 dB Isolation    
      
12. Calculate distance to horizon (smooth earth)      
Enter 100.00 feet, antenna height    
Answer 14.14 miles    
      
13. Calculate Radio Horizon, Center of Vertical Beam horizon and       
      3 dB point beam horizons. Allows Beam Downtilt.  FLAT EARTH!      
Enter 100.00 feet, Antenna Ht. HAAT    
Enter 10.00 degrees; Vertical -3 dB beamwidth    
Enter  4.00 degrees; Downtilt below horizon    
Answer 14.14 mi.: Radio Horizon    
Answer 0.12 mi.: Lower 3 dB beamwidth horizon    
Answer 0.27 mi.: Center of beamwidth horizon    
Answer > Horizon mi.: Upper 3 dB beamwidth horizon    
      
14. Calculate unobstructed signal levels using data from calculations above      
Enter 500.00 MHz, center frequency    
Enter 45.00 dBm: ERP at antenna    
Level at 0.12 miles = -30 dBm  
Level at 0.27 miles = -34 dBm  
Level at 14.14 miles = -72 dBm, worse case  
      
15. Convert Degree-Minute.decimal coordinate format to other formats      
  (Note: If you enter an incorrect value you will get an incorrect answer)      
 Degrees Minutes Seconds   
Enter 30 30.25    (dna)  D/M 
Answer 30 30 15.0000  D/M/S 
Answer 30.50416667 (dna) (dna)  D 
      
16. Convert Degree-Minute-Second coordinate format to other formats      
 Degrees Minutes Seconds   
Enter 30 30 15.0000  D/M/S 
Answer 30 30.2500 (dna)  D/M 
Answer 30.50416667 (dna) (dna)  D 
      
17. Convert Degree.decimal coordinate format to other formats      
 Degrees Minutes Seconds   
Enter 30.5504167 (dna) (dna) D  
Answer 30 33 1.5001 D/M/S  
Answer 30 33.025002 (dna) D/M  
      
18. Distance between coordinates: FCC distance method: Valid up to ~250 miles      
     (DD = Degrees, MM = Minutes, SS = Seconds)      
Enter  Latitude    Longitude
Coord.s: DD MM SS  DDD MM SS
Site A 34 30 0  116 30 0
Site B 33 45 0  116 45 30
Answer 53.77 miles between Site A and Site B.    
Answer 195.99 degrees; Site A to Site B    
Answer 15.99 degrees; Site B to Site A    
      
Signal Booster Calculation Section      
      
A. Calculate Free Space Loss for distances in feet.      
NOT ACCURATE LESS THAN 20 FEET or 10 Wavelengths!      
Enter 850 MHz    
Enter 3000 Feet    
Answer 90.28 dB    
      
B. Calculate Composite Power of multiple carriers.      
(Enter -200 dBm for unused carrier entry)      
(For more than 4, Calculate 4 then use the answer as #1 input then enter others)      
Enter Carrier 1 level  -30 dBm   
Enter Carrier 2 level  -30 dBm   
Enter Carrier 3 level  -200 dBm   
Enter Carrier 4 level  -200 dBm   
Composite Power Level  -26.99 dBm   
      
C. Calculate Amplifier Input/Output Noise levels using N.F. , BW and 3rd OIP      
Enter Noise Figure   6.00 dB  
Enter BW in MHz   0.030000 MHz  
Enter Amplifier gain   80.00 dB  
Enter 3rd OIP   2.00 dBm   
Input Noise "floor" =   -123.23 dBm   
Output Noise for Entered BW     =   -43.23 dBm   
Output Noise: 25 KHz window   =   -44.02 dBm   
Output Noise:12.5 KHz window =   -47.03 dBm   
      
D. Calculate 3rd order IM product in Class A RF Amps:      
Enter Amplifier Gain   15.0 dB  
Enter 3rd Order Output IP   26.0 dBm  
Enter carrier input level   -40.0 dBm  
Approx. 1 dB compression level   16.0 dBm (at output)  
Carrier output level   -25.0 dBm  
3rd IM output level   -127.0 dBm  
3rd IM to carrier difference   -102.0 dB  
      
E. Calculate 2nd & 3rd Order IM using 3rd OIP and Output level      
Enter 3rd OIP (Output Intercept Point)   44.0 dBm  
Enter Output Level   10.0 dBm  
2nd Order IM below Output   -24.0 dBm  
2nd Order IM Output Level   -14.0 dB  
3rd Order IM below Output   -58.0 dBm  
3rd Order IM Output level   -48.0 dB  
      
F. Calculate maximum Output power per carrier for multiple carriers.      
Note: Uses EIA PN2009 method: Based on equal input levels for all carriers AND      
IM's attenuated by at least 43 + 10 log(output power per carrier )      
Enter 3rd Order Output IP   45.0 dBm  
Enter Number of input carriers   2 carriers (minimum = 2)  
Output power per carrier   25.4 dBm  
Output power per carrier   346.1 milliwatts  
      
Metric Conversions (For FCC forms, etc.)      
      
Convert Inches to Centimeters and meters      
Enter 6 inches    
Answer 15.24 cm    
Answer 0.15 meters    
      
Convert Feet to Meters/Kilometers      
Enter 6 feet    
Answer 1.83 meters    
Answer 0.0018 kilometers    
      
Convert Miles to Meters and Kilometers      
Enter  6 miles    
Answer 9655.80 meters    
Answer 9.66 kilometers    
      
Convert Meters to inches, feet, yards and miles      
Enter 6 meters    
Answer 236.232 inches    
Answer 19.686 feet    
Answer 6.56 yards (feet/3)    
Answer 0.0037284 miles