Excel Calculator Spreadsheets

Intermodulation Calculator for RF Devices Spreadsheet

Excel Spreadsheet that calculates 2T30, 2T50, and 3T30 IMD’s for up to 16 device frequencies.

Macros are also available to copy intermodulation frequencies for import into frequency coordination software.

Added For version 1.04

Fix bug in spacing acceptance criteria 

Preset buttons to verify spacing of User groups 

User Preset buttons for Frequency and spacing

Minimum channel and IMD spacing in the entered Device Frequencies

Added For version 1.05

Repaired user frequency Macros

Here are a few uses for this calculator

  • Check Channel to channel and IMD to channel spacing for up to 16 devices
  • Check conflicts and spacing for frequencies provided for you
  • Use to verify acceptance criteria for validation purposes.

Band Planing Spreadsheet

The first step in a RF coordination is to develop a Band Plan. This often neglected step is very important. Developing a Band plan before you begin selecting equipment and coordinating frequencies will greatly increase your chance for success.

This spreadsheet allows you to easily organize the available spectrum and determine which devices frequency bands are available for this available frequency bands. This spreadsheet includes the UHF, VHF, ISM, DECT, 2.4 Ghz, and the licensed 900 mHz STL bands. Also included are the spectral bands of most major brands wireless devices.

RF Calculators Spreadsheet

Excel Spreadsheet with four tabbed calculator sheets

1- Path Loss Calculator

2 - Antenna Placement Calculator (New)

3 - Third Order Intercept Calculator

4 - Wavelength Calculator

5 - VSWR Calculator

NYC CVS Scan files featured on this site