EXCEL利用贝塞尔函数模拟天线3D方向图
抛物面天线增益可以用下面的公式计算：
D：天线直径λ：波长φ：偏轴角J1()：1阶贝塞尔函数μ：天线效率1、先用EXCEL按照准备数据，偏轴角从-90到90，0.1度步进
生成平滑线散点图见下图：
2、截取±10度范围内的数据生成平滑线散点图如下：
3、3D方向图生成先计算平面上的偏轴角度分布数据
再次利用G(φ)计算增益分布数据
最后生成下面天线增益的三维曲面图
我们也可以修改相关参数，比如修改口径为0.6米
EXCEL源文件下载链接：-10-9.9-9.8-9.7-9.6-9.5-9.4-9.3-9.2-9.1-9-8.9-8.8-8.7-8.6-8.5-10-0.60-0.060.350.660.860.960.970.880.690.400.00-0.51-1.16-1.96-2.95-4.17-9.9-0.060.360.660.860.960.960.870.670.37-0.04-0.58-1.26-2.10-3.13-4.42-6.05-9.80.350.660.860.960.960.860.660.34-0.08-0.64-1.34-2.21-3.29-4.64-6.36-8.65-9.70.660.860.960.960.860.650.33-0.11-0.68-1.41-2.31-3.42-4.83-6.64-9.07-12.61-9.60.860.960.960.860.640.32-0.13-0.71-1.45-2.38-3.53-4.99-6.87-9.43-13.26-20.56-9.50.960.960.860.650.32-0.14-0.73-1.48-2.43-3.61-5.11-7.06-9.74-13.82-22.16-26.10-9.40.970.870.660.33-0.13-0.73-1.49-2.45-3.66-5.19-7.20-9.98-14.29-23.70-23.86-14.24-9.30.880.670.34-0.11-0.71-1.48-2.45-3.67-5.23-7.28-10.14-14.65-25.06-22.45-13.68-9.43-9.20.690.37-0.08-0.68-1.45-2.43-3.66-5.23-7.31-10.22-14.87-26.11-21.56-13.27-9.14-6.39-9.10.40-0.04-0.64-1.41-2.38-3.61-5.19-7.28-10.22-14.94-26.69-21.07-13.02-8.94-6.22-4.21-90.00-0.58-1.34-2.31-3.53-5.11-7.20-10.14-14.87-26.69-20.92-12.89-8.82-6.11-4.10-2.54-8.9-0.51-1.26-2.21-3.42-4.99-7.06-9.98-14.65-26.11-21.07-12.89-8.78-6.05-4.04-2.47-1.21-8.8-1.16-2.10-3.29-4.83-6.87-9.74-14.29-25.06-21.56-13.02-8.82-6.05-4.01-2.44-1.17-0.15-8.7-1.96-3.13-4.64-6.64-9.43-13.82-23.70-22.45-13.27-8.94-6.11-4.04-2.44-1.16-0.120.72-8.6-2.95-4.42-6.36-9.07-13.26-22.16-23.86-13.68-9.14-6.22-4.10-2.47-1.17-0.120.731.42-8.5-4.17-6.05-8.65-12.61-20.56-26.10-14.24-9.43-6.39-4.21-2.54-1.21-0.150.721.421.97-8.4-5.71-8.19-11.92-18.97-29.94-15.00-9.81-6.63-4.37-2.64-1.29-0.190.691.401.972.41-8.3-7.70-11.18-17.43-39.20-16.02-10.31-6.94-4.57-2.79-1.39-0.260.641.371.952.402.73-8.2-10.42-15.96-37.69-17.37-10.93-7.32-4.83-2.97-1.52-0.360.571.321.922.382.722.94-8.1-14.56-27.93-19.22-11.72-7.79-5.15-3.20-1.68-0.480.481.261.872.352.702.933.06-8-23.07-21.91-12.70-8.36-5.53-3.47-1.89-0.630.371.181.812.312.672.923.053.07-7.9-26.39-13.95-9.05-5.99-3.80-2.13-0.810.241.071.742.262.642.903.043.083.00-7.8-15.57-9.89-6.53-4.18-2.41-1.030.070.951.652.192.602.883.033.083.012.82-7.7-10.93-7.18-4.63-2.74-1.28-0.120.811.542.112.542.843.023.083.022.842.54-7.6-7.95-5.16-3.13-1.57-0.340.641.412.022.482.803.003.083.042.872.582.16