This paper discussed the method of easily calculating the optical distribution ratio and the power of optical transmitter by agilely using the excel sheet and its function.

• 灵活运用EXCEL电子表格及其函数 ,能方便、快捷地计算出分光比、光发射功率。