lrobbo314
Well-known Member
- Joined
- Jul 14, 2008
- Messages
- 3,963
- Office Version
- 365
- Platform
- Windows
FSPL calculates the 'Free Space Path Loss' for a given frequency, distance, transmitter gain, and receiver gain.
Excel Formula:
=LAMBDA(distance,frequency,tx_gain,rx_gain,
20*LOG10(distance)+20*LOG10(frequency)+20*LOG10((4*PI())/300)-tx_gain-rx_gain
)| FREQ FUNCS.xlsm | ||||
|---|---|---|---|---|
| J | K | |||
| 18 | 59.98419728 | 59.98419728 | ||
Sheet1 | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| J18 | J18 | =LAMBDA(distance,frequency,tx_gain,rx_gain,20*LOG10(distance)+20*LOG10(frequency)+20*LOG10((4*PI())/300)-tx_gain-rx_gain)(1000,300,10,12) |
| K18 | K18 | =FSPL(1000,300,10,12) |
Upvote
0
