The invention discloses a ship loading calculation method based on Excel, the ship loading calculation method based on Excel is compiled, packaged and operated through a VBA in Excel, and comprises the following steps: a, calculating shearing force; b, calculating a bending moment; c, setting parameters; and d, carrying out stowage and automatic calculation. On the basis of functions and VBA codes in Excel, main characteristic data such as draft, buoyancy, shearing force and bending moment of the ship can be automatically calculated through one key, the data can be updated in real time, it is guaranteed that the ship strength does not exceed an allowable value, safe navigation of the ship is guaranteed, professional software and computer loading manufacturers do not need to be relied on any more, the ship stowage requirement is independently completed, the software and time cost is saved, and the efficiency is greatly improved.

    本发明公开了一种基于Excel的船舶装载计算方法,所述基于Excel的船舶装载计算方法通过Excel中的VBA进行编制、封装运行,包括:a.计算剪力;b.计算弯矩;c.设置参数;d.配载及自动计算。本发明基于Excel中的函数功能和VBA代码实现了一种一键自动计算出船舶的吃水、浮力、剪力、弯矩等主要特征数据,数据可以实时更新,保证船舶强度不超许用值,确保船舶安全航行,不再必须依赖专业软件和装载计算机厂家,独立自主完成船舶配载需求,节约软件和时间成本,大大提升效率。


    Zugriff

    Download


    Exportieren, teilen und zitieren



    Titel :

    Ship loading calculation method based on Excel


    Weitere Titelangaben:

    一种基于Excel的船舶装载计算方法


    Beteiligte:
    TANG YONGJUN (Autor:in)

    Erscheinungsdatum :

    18.02.2022


    Medientyp :

    Patent


    Format :

    Elektronische Ressource


    Sprache :

    Chinesisch


    Klassifikation :

    IPC:    B63B Schiffe oder sonstige Wasserfahrzeuge , SHIPS OR OTHER WATERBORNE VESSELS



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

    LIU HUAYUN / WANG SONGDA / CHEN HONGBO | Europäisches Patentamt | 2022

    Freier Zugriff

    Novel ship loading method for achieving 45-degree ship loading

    LI YONGCUI / LIU QIXIN / CHEN QIANG et al. | Europäisches Patentamt | 2022

    Freier Zugriff

    CARGO LOADING SHIP AND METHOD OF LOADING

    IM HONG IL / LEE DO HYUNG / LEE BYEONG ROK | Europäisches Patentamt | 2015

    Freier Zugriff

    CARGO LOADING SHIP AND METHOD OF LOADING

    IM HONG IL / LEE DO HYUNG / LEE BYEONG ROK | Europäisches Patentamt | 2015

    Freier Zugriff

    CARGO LOADING SHIP AND METHOD OF LOADING

    Europäisches Patentamt | 2016

    Freier Zugriff