A calculation method of ship loading based on excel

Abstract

A kind of Excel-based ship loading calculation method that the present invention relates to, the basic formula is F=W-B, M=∫F*d(x), and it includes the following content: a calculates shear force, formula: shear force F=W ‑B; a1 calculate ship weight W: a2 calculate ship buoyancy B: a2.1 calculate draft, refer to the formula: D head = D level float + δ bow, D tail = D level float + δ tail; a2.2 pass step a2 .1 The calculated volume of the final draft is the buoyancy; a3 Get the shear force at each rib station number through F=W‑B; b Calculate the bending moment, the formula: M=∫F*d(x); cSet Parameters: density of water area, density of cabin liquid, allowable value of shear force under different working conditions, allowable value of bending moment under different working conditions; Stowage; then compile the function to generate hydrostatic data; the last key automatically calculates. The invention ensures that the strength of the ship does not exceed the allowable value, ensures the safe navigation of the ship, saves software and time costs, and greatly improves efficiency.

Description

technical field [0001] The invention relates to the technical field of software development, in particular to an Excel-based ship loading calculation method. Background technique [0002] Ships need to be stowed during construction, docking and sea trial to achieve the required draft and displacement, and to ensure that the strength of the ship does not exceed the allowable value to ensure safe navigation of the ship. [0003] The ship is stowed with the help of the professional NAPA software of the design institute during the process of floating out of dock and trial voyage. During the trial voyage, it needs to be stowed by the loading computer software provided by the loading computer manufacturer (the software is based on the loading manual). The above two softwares are expensive and costly, and the manufacturer of the computer software loaded during the trial voyage does not provide it to the shipyard. The working conditions pre-configured by the design institute using ...

AI Technical Summary

Problems solved by technology

The above two software are expensive and costly, and the computer software manufacturer does not provide it to the shipyard during the sea trial

The working conditions pre-configured by the design institute using NAPA before the trial voyage often cannot meet the actual needs, and the actual stowage will change with time, so it needs to be re-stowed, especially for large oil tankers, which reduces the loading efficiency and increases cost

Images