Application of EXCEL commonly used in navigation data processing

2019 2nd International Conference on Advanced Materials, Intelligent Manufacturing and Automation

Dai, Xiuliang^1 ; Ji, Chao^1 ; Wang, Hongzhi^1

Department of Navigation, Navy Submarine Academy, Qingdao, Shandong

266071, China^1

关键词: Calculation process;    Data processing methods;    Electronic storage;    Flexible use;    Large amounts;    Navigation data;   

Others  :  https://iopscience.iop.org/article/10.1088/1757-899X/569/5/052094/pdf
DOI  :  10.1088/1757-899X/569/5/052094

来源: IOP

【 摘 要 】

Aiming at the problem of large amount of data calculation and collation in navigation work, several EXCEL data processing methods of commonly used nautical tables are presented based on the advantages of EXCEL with its flexible use, strong expansibility and easy storage. All the calculation processes involved in common nautical tables can be realized by manually inputting corresponding parameters through formula input and logical setting. This method not only reduces the amount of manual calculation, but also improves the accuracy and accuracy of data calculation and realizes the electronic storage of data, which is of great benefit to improve the efficiency of navigation.