Need formula to selecting coaxial cable type and GSM antenna
I'm using a GSM modem for my application which is often installed at a basement where there is no GSM signal so I will need to attach it to an external antenna that is placed outside of the building.
Since low loss coaxial cables are very expensive, I'm trying to find a rough formula that will allow me to calculate the maximum loss/attenuation in dB per 100 feet of the coaxial cable that I can use, given my Antenna gain (DBi), cabling distance (in feet) required and GSM signal strength (RSSI ASU) obtained by the modem placed at the antenna location, and the minimum GSM signal strength which I can tolerate after cable loss.
For example, I'm using a 5DBi Antenna which has to be connected to the GSM modem 100 feet away in the building. If the GSM modem were to be placed at at the antenna, it could achieve a RSSI of 23 ASU which translates to -67dBm. I can tolerate a minimum GSM signal strength of 15 ASU (-83dBm). The formula should allow me to calculate the maximum loss/attenuation in dB per 100 feet of the coaxial cable that I can use.
Grateful for any thoughs. Thanks.