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代码实现了一种一键自动计算出船舶的吃水、浮力、剪力、弯矩等主要特征数据,数据可以实时更新,保证船舶强度不超许用值,确保船舶安全航行,不再必须依赖专业软件和装载计算机厂家,独立自主完成船舶配载需求,节约软件和时间成本,大大提升效率。
Ship loading calculation method based on Excel
一种基于Excel的船舶装载计算方法
18.02.2022
Patent
Elektronische Ressource
Chinesisch
IPC: | B63B Schiffe oder sonstige Wasserfahrzeuge , SHIPS OR OTHER WATERBORNE VESSELS |
Ship water gauge measuring method and system based on Excel auxiliary calculation
Europäisches Patentamt | 2022
|Novel ship loading method for achieving 45-degree ship loading
Europäisches Patentamt | 2022
|