Excel sheet to estimate range for Indoor and Outdoor

Range Estimation for Indoor and Outdoor Rev1_17.xlsm

Hi,

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!

80 Replies

  • Guru 141015 points

    In reply to Sudeept Prusti:

    You can select absorbtion material 1 - 3 to something that gives what you think is the loss in sum.
  • In reply to Sudeept Prusti:

    For Non LOS cases, it is difficult to predict the attenuation of the radio signal for a specific object. Cars, trees and shops will not have a constant attenuation since each object is unique and the amount of attenuation will vary depending on the construction. In such scenarios, a range test with known kits such as the CC1310 launchpad will help to determine an expected range.

    For example, a wall can have attenuation of a few dBs to 30-50 dBs depending on the construction. 

    //Richard

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

  • Richard

    Thanks..this is really useful.. do you have a similar excel for CC1350 or the new Value line series?

    Thanks..Jarel

    plugintoiot.com

  • In reply to Jarel Smith:

    Hi Jarel,

    CC1310 and CC1350 are in the drop down list as "CC13x0"

    If there is a chip that is not in the list then select "Custom" and the sensitivity level can be entered.

    Regards,

       Richard

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

  • In reply to TER:

    Latest version (1.17) has been updated to include:

    CC2640R2F - 500 kbps (BLE)
    CC2640R2F - 125 kbps (BLE)

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

  • THIS FILE MAY HAVE BEEN HACKED.

    I just downloaded it (Feb, 2017) and there's a button near the graph labeled "R27, Kappstad 114" and goes to a URL shortener. It looked like it was a macro attack. What is that button for?

    fixituntilitsbroken.blogspot.com

    Latest Post: "BLE application development : Custom Hardware"

  • Guru 141015 points

    In reply to Derek9531:

    No hack, just a video of Richard showing > 100 km of range.
  • Hello,

    I want to do some LOS range tests comparing our device with TI development boards.
    The fist test is with two SmartRF06 with CC1310EM and the included Kit antenna whip antennas.
    Other test will be with the DN038 and DN024 antennas.


    I have an old version of the Excel sheet (v1.08) where you can select the Kit antenna with a gain of 2.1dB.
    I miss this one in the current version (v1.17).
    What setting should I use?




  • In reply to Marcel Bootsma:

    Hi,

    For the majority of wireless devices, specific antenna gain is not so interesting since the device will never be in a fixed position. It is more relevant to specify a "Mean Effective Gain" instead. For the earlier versions, the antenna was specified in gain and this is now specified as MEG.

    When the antenna was specified as MEG instead of gain, the link margin gain was also reduced with 4 dB compared to previous versions. So basically the range expectation will be the same as before when choosing a 100% efficient antenna (0 dB) and with link margin to "no antenna diversity" (16 dB; previously 20 dB). 

    Regards,   Richard

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

  • In reply to Richard Wallace:

    Thank you Richard, sorry for the late reply, I was away for some weeks. Your answer explains it.

    I had some trouble with the Devellopment Kit antennas but now I get near the theoretical value from your sheet.

    I read some things on this forum about the quality this antenna, do you think it can qualify as 100% effective?

    Another question, I measure on a long stretch of tarmac road between a a channel and some meadows. There are also trees next to the road.

    What kind of ground surface value would you suggest?