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!

32 Replies

  • Hey,

    This is cool stuff!! Once I did a test with two CC2540EM (using dipole antennas) and I got a range about 260m outdoors on an open field. Your tool approximates 104m, am I missing something or did I just got lucky when doing the measurement? :) Picture attached.

    Edit: After looking more closely on the graph and knowing that CC2540 has -93dBm in sensitivity (High-Gain mode), I see that my measurement is backed up by Friis equation. Really useful tool here!!

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

  • In reply to Joakim Lindh:

    Hi Joakim,

    Thanks for the feedback.

    Good to hear that the LOS results correlate.

    This tool helps a lot especially when discussing indoor range and the impact of having a "dry wall" or "concrete" wall between the Tx and Rx units.  

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

  • In reply to Richard Wallace:

    Hello Joakim,

    I appreciate your work..

    but can you tell me is your tool support cc2538 chip also ? becoz i am using cc2538 and zstack HA 1.20 so how can i use your tool ?

     

    thanks & regards,

    Maneesh

  • In reply to maneesh singh:

    CC2538 is included in the Rev1_03 version.

    Regards, Richard

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

  • In reply to Richard Wallace:

    How does this work? I tried entering the same inputs as Joakim, but I got #N/A as a result in the write protected cells

    Edit: I got it working by using "." as a decimal point instead of ",".

    What is the typical gain for iOS devices and how could I enter in such a value? How do I select different absorbtion materials?

  • In reply to Peter Borenstein:

    There is no typical gain value for an iOS device since this depends on the specific design of the antenna. For a typical gain value, I would keep this at 0 dB for 2.4 GHz.

    Regards, Richard

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

  • Richard,

    Your spreadsheet is very, very helpful.  Would you mind sharing the source of your wall energy absorption numbers?

    Thank you,

    --Jamie

  • In reply to Jamie Nichol:

    Hi Jamie,

    The source of the energy absorption numbers is from a report from the U.S. National Institute of Standards and Technology (NIST).

    Regards, Richard

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

  • In reply to Richard Wallace:

    Ver 1.07 supports CC13xx and CC26xx.


    Regards, Richard

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

  • In reply to Richard Wallace:

    Documentation on how to use this excel range calculation can be found at: www.ti.com/.../swra479

    Regards, Richard

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