The limit lies in the pulse integration loss. Not all of them can be integrated by the radar, and thus integration loss occurred. This in radar range equation will actually increase the required signal energy for target detection.

Improvements time. Trimming down some variables and Provide pre-calculated one. The calculator basically remains the same BUT hopefully it’s more user friendly.

[ATTACH=CONFIG]255520[/ATTACH]
The cover page now feature less clutters and lesser amount of input. Unfortunately as i said previously, pulsewidth and PRF cannot really be “automated” as it depends on the radar mode. Eliminating them will essentially locks the functionality of the calculator to X-band. While we know Russian developed L-band leading edge radar. and we have AEW AESA radar such as APY-9 and Elta Phalcon.

For filling guide for PRF and pulsewidth however. One can consult to following table, genereously provided by Carlo Kopp in Radar Handbook 3rd Edition. For both A2A and A2G modes

A2A

A2G

The second page of the calculator contains the pre calculated variables. One may still edit them. However it could be left as is. The pre calculated variables are based on generic information provided by radar literature in my possession.

[ATTACH=CONFIG]255521[/ATTACH]

Hopefully it could be more useful and easier to use. However feedback and input are appreciated.

Download link for the Improved version :

https://www.mediafire.com/file/7wrkyslc1p4d36r/AESACalcTrial.xlsx

what do you mean @moonlight ?

Updates

Slight updates to the calculator. The Required SNR variable is now automatically calculated by the spreadsheet.

The Calculated SNR is for Swerling 1 or 2 target. Representative for maneuvering fighter aircraft, and basically the goal of any fighter/tracking radar designer (as making the target behaves in swerling 2 will reduce the required SNR)

As you see no more SNR variable.
[ATTACH=CONFIG]255484[/ATTACH]

Instead it’s become part of the calculated variable. The calculated SNR is for 90% probability of target detection. Which allows lock on. Thus the R90 in the bold coloumn is the range where target could be locked on by the radar and later fired upon by the radar platform.

[ATTACH=CONFIG]255485[/ATTACH]

The range coloumn
[ATTACH=CONFIG]255486[/ATTACH]

The R50% is the range where target detection probability is 50%. Such range is where radar might detect and track the target But not having the confidence of locking it for weapon system employment. It may however be used to cue other fighter aircraft or higher resolution sensors to establish more confidence on what being detected, is it real target or just false alarm.