RF budget analysis docs and references

[Mazz]

Hi croud
does someone have advanced informations on spreadsheet's budget analysis?
I'm dealing with a budget made by some competitors, that I would like to understand better, I would like to have links, documents on this item.
For example is interesting to see how non-linearities and noise advance in the RX chain to understand which block is limiting the performances and what can be optimized.
I need some reference on classical approach of this argument, it will be an help.
I know how to use simple software like appcad, I would like to see something more advanced.
Thanks
Mazz

 

[khouly]

check these

http://tools.rfdude.com/rfsyscalc/cascade.html
**broken link removed**
i wish they help

khouly

 

[RFDave]

I've written dozen's of these. Spreadsheet's work out OK for gain and NF, but things rapidly get more complicated if you try to add non-linearities to the system. The best reference that I've seen for this is

William Egan
Practical RF System Design

**broken link removed**

Dave

 

[Mazz]

RF Dave, I agree
but that's how things go!
Real receivers work in noisy environment.
And people are still using, most of time, spreadsheets.
The way is faster than behavioural simulations (@DS...), both to build up the bench and to simulate it. The classical way.
There are ways (using spreadsheets) to see, in a budget with non-linearities and interferers, which block is contributing to a certain degradation of performances.
The book is interesting. Thanks
Mazz

 

[plasma]

Hi Mazz

Maybe you can find here something

**broken link removed**

PL

 

[RFDave]

Hi Mazz:

The Egan book is the only one that I've seen that talks in depth about spreadsheet analysis, for that reason alone it's a good book. The last couple of rounds of receiver spreadsheet work that I did, I ended up putting a bunch of stuff in VBA (I was using Excel) and that made the calculation's much easier. Unfortunatly, I can't share what I did.

Dave

 

[toonafishy]

I have written countless link budget spreadsheets in Excel and I have to agree that Egan's book covers some of the details I've never seen documented anywhere else. I just started using VBA last year to handle the complex calculations and it is the best thing to turbocharge your link budgets.

 

[Mazz]

So I need to study VBA...
Thanks
Mazz