Ship loading calculation method based on Excel

Abstract

The invention relates to a ship loading calculation method based on Excel, the basic formula is F = W-B, M = summing F * d (x), the ship loading calculation method comprises the following steps: a, calculating the shearing force, and the formula is that the shearing force F = W-B; a1, calculating the weight W of the ship; a2, calculating the buoyancy B of the ship; a2.1, calculating draught; a2, referring to a formula: D < head > = D < horizontal floating > + delta < head >, and D < tail > = D < horizontal floating > + delta < tail >; a2.2, calculating the volume, namely buoyancy, according tothe final draft calculated in the step a2.1; a3, the shearing force of each rib station number is obtained through F = W-B; b, calculating bending moment, wherein the formula is M = summing F * d (x); c, which comprises water area density, cabin liquid density, allowable shearing force values under different working conditions and allowable bending moment values under different working conditions; d, stowage and automatic calculation, wherein stowage comprises stowage of a ballast compartment and stowage of other compartments; compiling a function to generate hydrostatic data; last-key automatic computation. The method guarantees that the ship strength does not exceed the allowable value, guarantees the safe navigation of the ship, saves the software and time cost, and greatly improves the 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