Calculation of atmospheric infrared radiation transmittance rate.xlsx

1. Excel is used to calculate the atmospheric transmission rate of infrared radiation. The worksheet “Earth” is the calculation of the transmission rate on the Earth and the worksheet “Hesperus” is the calculation of the transmission rate on Hesperus. Both of the results are presented in the cell “N19” of the two worksheets. The worksheet “Sheet 7” is the function diagram of the energy distribution and wavelengths of Hesperus. The worksheet “Wavelength Transmittance” is a reduction process of the transmission rates corresponding to the wavelengths with the step length of 0.1μm of the obtained image of “Radiation Transmitted by the Atmosphere”. 2. Cell “B7” in the worksheet “Earth” corresponds to the Earth’s surface temperature, the initial value of which is 288K. If the temperature is changed to 210K and 350K, that is, the value in B7 is changed to 210 and 350, the results would be 16.04% and 29.55% in N19, which is basically the same as the original 15-30%, indicating that the data is well restored according to the figures, and the calculation result of transmittance is correct. 3. There are three Plantwo of which are functions of corresponding wavelengths, and the relatick laws, onship between the two functions is a constant. Transmittance rate is a ratio, and both the numerator and denominator can present the constant outside the sum function for approximate division, so there is no difference between the results of choosing either of the two functions. 4. The restoring process of the figure of “Radiation Transmitted by the Atmosphere” is as follows: a. Grid the picture; b. Obtain the function of the number of grids corresponding to the horizontal coordinates: file:///C:\Users\ADMINI~1\AppData\Local\Temp\ksohtml7364\wps1.png, where n is the number of squares in the horizontal coordinates; c. Calculate the corresponding wavelength 10n/36.5-1 at the step length of 0.1 (the result is displayed in column D); d. Find the 1.3, 1.4, 1.5, 1.6 ......, 13.9, 14 μm in the wavelength, and check the corresponding number of horizontal coordinate squares n; e. Use the number of squares n in the “Total Absorption and Scattering” to find the corresponding atmospheric absorption rate r for that wavelength; f. Organize the data and list the 1.3 to 14 μm at the step length of 0.1 μm, and list the corresponding absorption rate r; g. Find the atmospheric transmission rate 1-r for wavelengths from 1.3 to 14 μm at the step length of 0.1 μm. Then the calculation would be easier. 5. Main radiation bands of CO2: 2.68-2.8 μm, 4.25-4.45 μm, 13-17 μm. Main radiation bands of H2O: 2.55-2.84 μm, 5.6-7.6 μm, 12-30 μm, all in the “Total Absorption and Scattering” atmospheric absorption range of infrared radiation. The calculation of transmission rate is not affected by the infrared radiation of CO2 and H2O. 6. According to the figure of “Radiation Transmitted by the Atmosphere”, the wavelength range of CO2 absorption of infrared radiation is limited. Although the atmospheric pressure of Hesperus is 96 atmospheres and the concentration of CO2 is 96.5%, CO2 has limited ability to absorb infrared radiation. The high temperatures on the surface of Venus cannot be explained only by the greenhouse effect. When calculating the atmospheric transmission rate of infrared radiation of Hesperus, the effect of carbon dioxide on the spectral absorption can be excluded by removing the 13-14 μm band from the calculation. 7. There is no independent H2CO3 in nature, which is the reason for the assumption that H2O collides with CO2 molecules without additional absorption of infrared radiation.1. 本数据集采用Excel计算红外辐射的大气透射率。其中名为"Earth（地球）"的工作表用于计算地球的大气透射率，名为"Hesperus（昏星，即金星古称）"的工作表用于计算该天体的大气透射率，二者的计算结果均存放于各自工作表的单元格N19中。名为"Sheet 7"的工作表用于展示Hesperus的能量分布与波长关系的函数图。名为"Wavelength Transmittance（波长透射率）"的工作表则基于"Radiation Transmitted by the Atmosphere（大气透射辐射）"图像，对以0.1μm为步长的各波长对应的透射率进行降维处理。 2. "Earth"工作表中的单元格B7对应地球表面温度，其初始值为288K。若将该温度修改为210K与350K（即将B7单元格的值分别调整为210和350），则N19单元格的计算结果将分别为16.04%与29.55%，该结果与原15%~30%的范围基本吻合，表明数据已按图示完成有效还原，透射率的计算结果准确可靠。 3. 本数据集包含三个普朗克（Planck）函数，三者均为对应波长的函数，任意两个函数之间的相对关系为常数。透射率为比值形式，其分子与分母均可将求和函数外的常数提取出来进行近似除法运算，因此选用任意一个普朗克函数所得的计算结果并无差异。 4. "Radiation Transmitted by the Atmosphere（大气透射辐射）"图像的还原流程如下： a. 对该图像进行网格化处理； b. 获取横坐标对应的方格数函数：file:///C:UsersADMINI~1AppDataLocalTempksohtml7364wps1.png，其中n为横坐标方向的方格总数； c. 以0.1为步长计算对应波长：10n/36.5-1，计算结果将存放于D列中； d. 遍历步长为0.1μm的波长范围（1.3μm至14μm），查找各波长对应的横坐标方格数n； e. 基于"Total Absorption and Scattering（总吸收与散射）"工作表中的方格数n，获取该波长对应的大气吸收率r； f. 整理数据，列出步长为0.1μm的1.3μm至14μm波长区间内的所有波长及其对应的大气吸收率r； g. 计算1.3μm至14μm区间内各波长对应的大气透射率（1 - r），以简化后续计算。 5. 二氧化碳（CO₂）的主要辐射波段为：2.68μm~2.8μm、4.25μm~4.45μm以及13μm~17μm；水（H₂O）的主要辐射波段为：2.55μm~2.84μm、5.6μm~7.6μm以及12μm~30μm，上述波段均处于红外辐射的"总吸收与散射"大气吸收范围内。红外辐射的透射率计算不受CO₂与H₂O辐射的影响。 6. 根据"大气透射辐射"图像可知，CO₂对红外辐射的吸收波段范围有限。尽管Hesperus（昏星，即金星）的大气压强高达96个标准大气压，且CO₂浓度为96.5%，但其对红外辐射的吸收能力仍较为有限，仅靠温室效应无法解释金星表面的高温现象。在计算Hesperus的红外辐射大气透射率时，可通过移除13μm~14μm波段来排除CO₂对光谱吸收的影响。 7. 自然界中不存在独立的碳酸（H₂CO₃），这也是假设水分子（H₂O）与CO₂分子碰撞时不会额外吸收红外辐射的原因。