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计算界面中,根据船舶装卸货基本参数计算船舶平均吃水和船舶吃水修正系数,再计算得到船舶水线修正的吃水和船舶六面平均吃水;通过船舶水线修正的吃水和船舶六面平均吃水计算得到船舶拱垂修正吃水,根据船舶拱垂修正吃水查找所述船舶装卸货基本参数中对应的排水量、每厘米吃水吨数及漂心距,计算得到船舶密度修正排水量;最后通过船舶密度修正排水量计算得到船舶装卸货前后的重量。本发明能够使得船员在进行水尺检量工作时,无需进行大量的计算工作,仅需将相关测量参数和基本参数输入系统中,便可得到最终的船舶装卸货量,极大的提高工作效率。


    Access

    Download


    Export, share and cite



    Title :

    Ship water gauge measuring method and system based on Excel auxiliary calculation


    Additional title:

    一种基于Excel辅助计算的船舶水尺检量方法及系统


    Contributors:
    LIU HUAYUN (author) / WANG SONGDA (author) / CHEN HONGBO (author)

    Publication date :

    2022-04-19


    Type of media :

    Patent


    Type of material :

    Electronic Resource


    Language :

    Chinese


    Classification :

    IPC:    B63B Schiffe oder sonstige Wasserfahrzeuge , SHIPS OR OTHER WATERBORNE VESSELS / G06F ELECTRIC DIGITAL DATA PROCESSING , Elektrische digitale Datenverarbeitung



    Ship loading calculation method based on Excel

    TANG YONGJUN | European Patent Office | 2022

    Free access

    Ship water gauge measuring method

    SUN CHENGMENG / LIN HAIHUA / ZHANG YANG et al. | European Patent Office | 2021

    Free access

    Ship electronic water gauge measuring method and system

    XIAO NING / WU HAIZHONG / SANG ZEFANG et al. | European Patent Office | 2021

    Free access

    Water gauge calculation method based on simulated ship shape

    LIU CHONGWEI / WANG GUOXUN / WANG DONG et al. | European Patent Office | 2020

    Free access

    Port ship water gauge automatic measuring device

    FENG CHENG / DUO YIMIN / CUI XIAOLIANG et al. | European Patent Office | 2020

    Free access