Ship loading calculation method based on Excel

A calculation method, excel technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems of lower loading efficiency, high price, high cost, etc., to improve efficiency, ensure safe navigation, save software and time cost effect

Active Publication Date: 2020-09-08
江苏新扬子造船有限公司
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 b...

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Ship loading calculation method based on Excel
  • Ship loading calculation method based on Excel

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0034] see figure 1 , an Excel-based ship loading calculation method involved in the present invention, the basic formula is F=W-B, M=∫F*d(x) (wherein: F shear force W ship weight B buoyancy M bending moment) The specific method steps are as follows :

[0035] The first part is to calculate the shear force. According to the shear force F=W-B, it is necessary to know the weight of the W ship and the buoyancy of the B ship;

[0036] 1.1. Calculate the ship's weight W:

[0037] The weight W of the ship can be divided into two parts for calculation, the first part is the weight of the empty ship, and the second part is the weight brought by the loading of the cabin;

[0038] The weight of the light ship and its distribution along the length of the ship are compiled according to the loading manual; the weight brought by loading can be obtained from the sounding table. This step requires the preparation of functions (offset\trend\match\) to generate the corresponding weight and C...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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 ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F30/15
CPCG06F30/15G06F2119/14
Inventor 束方银张冠东陈剑常月军严金灿
Owner 江苏新扬子造船有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap