淮阴师范学院学报（自然科学版）
淮陰師範學院學報（自然科學版）
회음사범학원학보（자연과학판）
Journal of Huaiyin Teachers College (Natural Science Edition)
2015年
3期
243-247
,共5页
Excel%夫琅和费衍射%光强分布%衍射图样%仿真
Excel%伕瑯和費衍射%光彊分佈%衍射圖樣%倣真
Excel%부랑화비연사%광강분포%연사도양%방진
excel%fraunhofer diffraction%light distribution%diffraction pattern%simulation
以夫琅和费衍射实验为例，运用Excel数据表格功能组件实现光学实验的计算机仿真。通过该软件的数据计算和分析功能建立表征光强分布的数据工作表，用其图表功能绘制夫琅和费单缝、矩孔衍射的光强分布以及衍射图样，并对结果进行简要分析。仿真过程较为简单、直观、便捷。
以伕瑯和費衍射實驗為例，運用Excel數據錶格功能組件實現光學實驗的計算機倣真。通過該軟件的數據計算和分析功能建立錶徵光彊分佈的數據工作錶，用其圖錶功能繪製伕瑯和費單縫、矩孔衍射的光彊分佈以及衍射圖樣，併對結果進行簡要分析。倣真過程較為簡單、直觀、便捷。
이부랑화비연사실험위례，운용Excel수거표격공능조건실현광학실험적계산궤방진。통과해연건적수거계산화분석공능건립표정광강분포적수거공작표，용기도표공능회제부랑화비단봉、구공연사적광강분포이급연사도양，병대결과진행간요분석。방진과정교위간단、직관、편첩。
Taking the Fraunhofer diffraction phenomenon experiment as an example, we realize the computer simulation of optical experiment by using Excel. Firstly, we create a data sheet for charactering the light inten-sity distribution by the function of data calculation and analysis in this software. Then, both the intensity dis-tribution and the diffraction pattern of the Fraunhofer single slit, rectangular aperture diffraction are plotted by using the chart function of Excel, and made a brief analysis of the results. The simulation process is simple, intuitive.
