The invention provides a ship water gauge measuring method and system based on Excel auxiliary calculation. The method comprises the steps that ship loading and unloading basic parameters are input into an Excel calculation interface, ship average draft and ship draft correction coefficients are calculated according to the ship loading and unloading basic parameters, and then ship waterline correction draft and ship six-face average draft are obtained through calculation; calculating to obtain ship sag corrected draft according to the ship waterline corrected draft and the average draft of six surfaces of the ship, searching corresponding displacement, draft tonnage per centimeter and center-of-drift distance in the ship loading and unloading basic parameters according to the ship sag corrected draft, and calculating to obtain ship density corrected displacement; and finally, calculating the weight of the ship before and after loading and unloading through the ship density correction displacement. According to the invention, a crew can obtain the final ship loading and unloading quantity only by inputting related measurement parameters and basic parameters into the system without carrying out a large amount of calculation work when carrying out water gauge detection work, so that the working efficiency is greatly improved.
本发明提供一种基于Excel辅助计算的船舶水尺检量方法及系统。本发明包括:将船舶装卸货基本参数输入到Excel计算界面中,根据船舶装卸货基本参数计算船舶平均吃水和船舶吃水修正系数,再计算得到船舶水线修正的吃水和船舶六面平均吃水;通过船舶水线修正的吃水和船舶六面平均吃水计算得到船舶拱垂修正吃水,根据船舶拱垂修正吃水查找所述船舶装卸货基本参数中对应的排水量、每厘米吃水吨数及漂心距,计算得到船舶密度修正排水量;最后通过船舶密度修正排水量计算得到船舶装卸货前后的重量。本发明能够使得船员在进行水尺检量工作时,无需进行大量的计算工作,仅需将相关测量参数和基本参数输入系统中,便可得到最终的船舶装卸货量,极大的提高工作效率。
Ship water gauge measuring method and system based on Excel auxiliary calculation
一种基于Excel辅助计算的船舶水尺检量方法及系统
2022-04-19
Patent
Electronic Resource
Chinese
Water gauge calculation method based on simulated ship shape
European Patent Office | 2020
|