Excel sheet to estimate range for Indoor and Outdoor

Range Estimation for Indoor and Outdoor Rev1_17.xlsm 


The attached excel sheet helps to estimate a practical range estimation for indoor and outdoor radio links.

The outdoor is based upon Line-of-Sight (LOS). For the indoor estimation, construction materials can be selected that are between the Tx and Rx unit. The greater the attenuation of the combined material between the Tx and Rx unit, the shorter the distance.

This has been used a lot in TI seminars and is a helpful tool for calculating a realistic and conservative range expectation.

Latest version (1.17) has been updated to include:

Any feedback is welcomed.

Regards, Richard



PS. Thank you for clicking  Verify Answer below if this answered your question!

32 Replies

  • In reply to Richard Falk:

    I really agree with you. The range of ble is the important issue. Because it will be shorter when it is used in home with wall, door...
    Vy Luu| Project Manager
    52 Dong Du St., Ben Nghe Ward
    District 1, Ho Chi Minh City
  • Genius 9325 points


    great to find this updated tool - thank you.

    Regards, Bernd