CN114056510A - Excel-based ship loading calculation method - Google Patents
Excel-based ship loading calculation method Download PDFInfo
- Publication number
- CN114056510A CN114056510A CN202111539805.XA CN202111539805A CN114056510A CN 114056510 A CN114056510 A CN 114056510A CN 202111539805 A CN202111539805 A CN 202111539805A CN 114056510 A CN114056510 A CN 114056510A
- Authority
- CN
- China
- Prior art keywords
- ship
- weight
- calculating
- excel
- buoyancy
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 31
- 238000005452 bending Methods 0.000 claims abstract description 24
- 238000010008 shearing Methods 0.000 claims abstract description 17
- 230000005484 gravity Effects 0.000 claims description 8
- 230000002706 hydrostatic effect Effects 0.000 claims description 6
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims description 5
- 239000007788 liquid Substances 0.000 claims description 3
- 238000000034 method Methods 0.000 abstract description 7
- 230000008859 change Effects 0.000 description 5
- 230000008569 process Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- RZVAJINKPMORJF-UHFFFAOYSA-N Acetaminophen Chemical compound CC(=O)NC1=CC=C(O)C=C1 RZVAJINKPMORJF-UHFFFAOYSA-N 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000009472 formulation Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
Images
Classifications
-
- B—PERFORMING OPERATIONS; TRANSPORTING
- B63—SHIPS OR OTHER WATERBORNE VESSELS; RELATED EQUIPMENT
- B63B—SHIPS OR OTHER WATERBORNE VESSELS; EQUIPMENT FOR SHIPPING
- B63B71/00—Designing vessels; Predicting their performance
- B63B71/10—Designing vessels; Predicting their performance using computer simulation, e.g. finite element method [FEM] or computational fluid dynamics [CFD]
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Fluid Mechanics (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Chemical & Material Sciences (AREA)
- Combustion & Propulsion (AREA)
- Mechanical Engineering (AREA)
- Ocean & Marine Engineering (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a calculation method for ship loading based on Excel, which is compiled and packaged to operate through VBA in Excel, and comprises the following steps: a. calculating the shearing force; b. calculating a bending moment; c. setting parameters; d. and (4) carrying and automatically calculating. The method realizes one-key automatic calculation of main characteristic data of the ship such as draft, buoyancy, shearing force, bending moment and the like based on the function and the VBA code in the Excel, the data can be updated in real time, the strength of the ship is not beyond an allowable value, the safe navigation of the ship is ensured, the ship loading requirement is independently completed without depending on professional software and a loading computer manufacturer, the software and time cost is saved, and the efficiency is greatly improved.
Description
Technical Field
The invention relates to the technical field of ship software, in particular to a ship loading calculation method based on Excel.
Background
In the prior art, the ship is loaded by means of professional NAPA software of a design institute in the floating undocking and pilot voyage processes. The two pieces of software are expensive and high in cost, and a manufacturer loading the computer software is not provided for a shipyard during the test-voyage. The working condition that lets the design institute use NAPA to join in marriage in advance before the pilot run often can not satisfy actual needs, and the actual stowage can change along with the time change, just needs the stowage again, especially large-scale oil tanker, has reduced loading efficiency, has increased the cost.
Disclosure of Invention
The invention provides a ship loading calculation method based on Excel, and aims to solve the problems of low loading efficiency and high cost in the prior art.
The invention provides a calculation method for ship loading based on Excel, which is compiled and packaged to operate through VBA in Excel, and comprises the following steps:
a. and (3) calculating the shearing force, which comprises the following specific steps:
step a 1: calculating the weight of the ship at each rib position station of the ship, specifically comprising the following steps: calculating the sum of the weight of the empty ship and the full load weight of the cabin; wherein the weight and the distribution along the length direction of the ship are compiled and obtained according to a loading manual; acquiring the full load weight of the cabin through a depth gauge;
step a 2: calculating the buoyancy of the ship, specifically: calculating the buoyancy of the ship through the draught at the head part of the ship and the draught at the tail part of the ship;
step a 3: and (3) calculating the shearing force of each rib station number of the ship according to the weight of the ship obtained in the step a1 and the buoyancy of the ship obtained in the step a2 by the following formula:
F=W-B；
b. calculating the bending moment as follows:
calculating the bending moment according to the shearing force obtained in the step 3 by the following formula:
M=∫F*d(x)；
c. setting parameters as follows:
setting parameters, including: density of a water area, density of cabin liquid, allowable shearing force values under different working conditions and allowable bending moment values under different working conditions;
d. the allocation and automatic calculation are as follows:
the stowage comprises stowage of ballast compartments and stowage of other compartments; then, compiling a function to generate hydrostatic data; and the last key is automatically calculated.
Further, the calculation of the cabin full weight in step a1 requires the formulation of functions to generate the corresponding weight and center of gravity for different loading conditions.
Further, in the step a2, firstly, a function is compiled, and a flat floating draft D is obtained according to the weight of the ship and a hydrostatic table; then, solving the draught difference t, and finally distributing the draught difference t to the head part and the tail part; the concrete formula is as follows:
δ head = t- δ tail;
δ tail = f t/L,
wherein f is floating center, L is length between head and tail vertical lines; t = M/MCT, M being the pitch moment and MCT being the pitch moment per centimeter.
Further, the calculation formula of the pitching moment is as follows:
M=W*（Xg-Xb）
wherein Xg is the longitudinal coordinate of the gravity center of the ship, and Xb is the longitudinal coordinate of the floating center of the ship.
Further, the shear equation in the calculated bending moment is an interval function, namely, the ship buoyancy and the ship weight function are calculated according to the same interval; integral calculation can be carried out along the ship length by the interval piecewise function of the ship weight and the ship buoyancy, and the bending moment numerical value of each position is obtained.
Further, when the density of the water area is set in the setting parameters, an INDEX function and a control selection density are compiled, and when allowable shearing force values under different working conditions and allowable bending moment values under different working conditions are set, the INDEX function and the control selection working condition are compiled.
The invention has the beneficial effects that:
the method realizes one-key automatic calculation of main characteristic data of the ship such as draft, buoyancy, shearing force, bending moment and the like based on the function and the VBA code in the Excel, the data can be updated in real time, the strength of the ship is not beyond an allowable value, the safe navigation of the ship is ensured, the ship loading requirement is independently completed without depending on professional software and a loading computer manufacturer, the software and time cost is saved, and the efficiency is greatly improved.
Drawings
The features and advantages of the present invention will be more clearly understood by reference to the accompanying drawings, which are illustrative and not to be construed as limiting the invention in any way, and in which:
FIG. 1 is a schematic flow chart of an embodiment of the present invention;
fig. 2 is a schematic diagram of a buoyancy calculation process of a ship in an embodiment of the invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, the invention relates to a method for calculating ship loading based on Excel, which has a basic formula of F = W-B, M = F ^ d (x) (wherein: F shear force W ship weight B buoyancy force M bending moment) and comprises the following specific steps: the method comprises the following steps of calculating the shear force, and according to the shear force F = W-B, knowing the weight of a W ship and the buoyancy borne by a B ship; 1.1, calculating the weight W of the ship: the weight W of the ship can be calculated by dividing the weight W into two parts, wherein the first part is the weight of an empty ship, and the second part is the weight brought by loading of a cabin; the weight and the distribution along the length direction of the ship are compiled according to a loading manual; the weight brought by the loading can be obtained through a depth measuring table, and the step needs to compile functions (offset \ trand \ match \) to generate the corresponding weight and gravity center under different loading conditions; combining the weight of the empty ship and the loading weight to obtain the weight W of the ship; 1.2, calculating the buoyancy B of the ship, wherein the calculation process is shown in a figure 2: 1.2.1, calculating the draught, and referring to the formula: d head = D horizontal floating + delta head and D tail = D horizontal floating + delta tail (1) to work out a horizontal floating draft D horizontal floating according to a ship weight and hydrostatic table; (2) solving the draught difference t, and finally distributing the draught difference t to the head part and the tail part; δ head = t- δ tail, δ tail = f t/L (f floating center, L head-tail vertical line length); t = M/MCT (M pitch moment, MCT per centimeter pitch moment); the calculation of M is: m = W (Xg-Xb) (Xg is the longitudinal coordinate of the center of gravity of the vessel, Xb is the longitudinal coordinate of the center of buoyancy of the vessel); under the condition of large loading, the MCT can change continuously along with the loading condition and change greatly, if initial unchanged MCT calculation is still used, a large error can be generated, the drift center can also change greatly, the distribution of head-tail draught difference is also greatly influenced, and finally, the bending moment shearing force error is large; therefore, under the condition of large trim, the calculation needs to be approached step by step, and the draft difference precision is finally adjusted to ensure that the ship reaches a balanced state; the balance in the trim state is W = B, t/L = tan theta = (Xg-Xb)/(Zg-Zb), (Xg is the ship center of gravity longitudinal coordinate, Zg is the ship center of gravity longitudinal coordinate, Xb is the ship center of buoyancy longitudinal coordinate, and Zb is the ship center of buoyancy vertical coordinate). Stopping when the precision of the ith t (i) and the t (i-1) meets the requirement, namely the state is the equilibrium state; the precision range can be adjusted, and controls are arranged in the table for convenient and quick observation; 1.2.2 calculating the final draft calculated by the step 1.2.1 to calculate the volume, namely the buoyancy; (1) the area below the waterline of each rib position station number is obtained through draft; (2) obtaining a corresponding function equation (ensuring that the precision applies a 6-time term equation) from the data in the step (1) through a function in the EXCEL, obtaining a function coefficient through a VBA code, and automatically distributing corresponding designated cells; (3) performing integral calculation on the result in the step (2) to obtain a final volume, including the volume from the stern to each rib position station number; 1.3 (integral from stern to bow), and the ship weight W and the ship buoyancy B corresponding to each rib station number up to this point are calculated respectively, and the shearing force at each rib station number can be obtained through F = W-B.
The second part is used for calculating the bending moment, and the basic idea of calculating the bending moment is as follows: m = F x d (x) (F is shear force; M is bending moment); 2.1, solving an equation of the shearing force F; subtracting the weight W function from the buoyancy function to obtain a shear equation, wherein the shear equation is an interval function for ensuring the precision, namely the buoyancy function and the weight function are calculated according to the same interval; 2.2, integral calculation can be carried out along the ship length by the section piecewise function of the weight and the buoyancy in the step 2.1, and the bending moment value of each position is obtained.
A third part, setting parameters; the parameter setting comprises the following aspects: 3.1, density of a water area (compiling an INDEX function and control selection density); 3.2, density of cabin liquid; 3.3, shearing force allowable values under different working conditions (compiling an INDEX function and a control selection working condition); and 3.4, allowable bending moment values under different working conditions (compiling an INDEX function and a control selection working condition).
Fourth, load allocation and automatic calculation; 4.1, the stowage here is the first step of obtaining draft, shear force and bending moment, and is divided into two aspects: the first aspect is ballast compartment stowage, the second aspect is stowage of other compartments; 4.2, in order to conveniently check the cabin position and the stowage condition of the ship, a distribution diagram of the cabin is compiled, the stowage of the ship can be quickly prepared to be checked, and targeted adjustment can be performed by combining the current bending moment shearing force condition; 4.3, compiling a function to generate hydrostatic data; 4.4, one-key automatic calculation.
Although the embodiments of the present invention have been described in conjunction with the accompanying drawings, those skilled in the art may make various modifications and variations without departing from the spirit and scope of the invention, and such modifications and variations fall within the scope defined by the appended claims.
Claims (6)
1. The Excel-based ship loading calculation method is characterized by being programmed and packaged to operate through a VBA in Excel and comprises the following steps:
a. and (3) calculating the shearing force, which comprises the following specific steps:
step a 1: calculating the weight of the ship at each rib position station of the ship, specifically comprising the following steps: calculating the sum of the weight of the empty ship and the full load weight of the cabin; wherein the weight and the distribution along the length direction of the ship are compiled and obtained according to a loading manual; acquiring the full load weight of the cabin through a depth gauge;
step a 2: calculating the buoyancy of the ship, specifically: calculating the buoyancy of the ship through the draught at the head part of the ship and the draught at the tail part of the ship;
step a 3: and (3) calculating the shearing force of each rib station number of the ship according to the weight of the ship obtained in the step a1 and the buoyancy of the ship obtained in the step a2 by the following formula:
F=W-B；
b. calculating the bending moment as follows:
calculating the bending moment according to the shearing force obtained in the step 3 by the following formula:
M=∫F*d(x)；
c. setting parameters as follows:
setting parameters, including: density of a water area, density of cabin liquid, allowable shearing force values under different working conditions and allowable bending moment values under different working conditions;
d. the allocation and automatic calculation are as follows:
the stowage comprises stowage of ballast compartments and stowage of other compartments; then, compiling a function to generate hydrostatic data; and the last key is automatically calculated.
2. An Excel-based vessel loading calculation method in accordance with claim 1 wherein said calculation of cabin full load weight in step a1 requires programming a function to generate corresponding weight and center of gravity for different loading situations.
3. The Excel-based vessel loading calculation method according to claim 1, wherein in step a2, a function is first programmed to obtain a horizontal buoyancy draft D horizontal buoyancy according to a vessel weight and hydrostatic table; then, solving the draught difference t, and finally distributing the draught difference t to the head part and the tail part; the concrete formula is as follows:
δ head = t- δ tail;
δ tail = f t/L,
wherein f is floating center, L is length between head and tail vertical lines; t = M/MCT, M being the pitch moment and MCT being the pitch moment per centimeter.
4. An Excel-based vessel loading calculation method in accordance with claim 3, characterized in that said pitching moment is calculated by the formula:
M=W*（Xg-Xb）
wherein Xg is the longitudinal coordinate of the gravity center of the ship, and Xb is the longitudinal coordinate of the floating center of the ship.
5. The Excel-based vessel loading calculation method according to claim 1, wherein the shear equation in the bending moment calculation is an interval function, that is, the vessel buoyancy and the vessel weight function are calculated in the same interval; integral calculation can be carried out along the ship length by the interval piecewise function of the ship weight and the ship buoyancy, and the bending moment numerical value of each position is obtained.
6. The Excel-based ship loading calculation method according to claim 1, wherein the INDEX function and the control selection density are programmed when the density of the water area is set in the setting parameters, and the INDEX function and the control selection condition are programmed when the shear allowable values under different working conditions and the bending moment allowable values under different working conditions are set.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111539805.XA CN114056510A (en) | 2021-12-16 | 2021-12-16 | Excel-based ship loading calculation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111539805.XA CN114056510A (en) | 2021-12-16 | 2021-12-16 | Excel-based ship loading calculation method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114056510A true CN114056510A (en) | 2022-02-18 |
Family
ID=80229596
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111539805.XA Pending CN114056510A (en) | 2021-12-16 | 2021-12-16 | Excel-based ship loading calculation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114056510A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPS59206291A (en) * | 1983-05-11 | 1984-11-22 | Mitsubishi Heavy Ind Ltd | Device for calculating optimum ship attitude |
| CN105224745A (en) * | 2015-09-30 | 2016-01-06 | 华中科技大学 | Ship loading performance optimization system |
| KR20160022695A (en) * | 2014-08-20 | 2016-03-02 | 대우조선해양 주식회사 | Real time automated analysis system for shipping stability |
| CN105608548A (en) * | 2016-01-20 | 2016-05-25 | 大连海事大学 | Automatic stowage method of bulk carrier stowage meter |
| CN107745785A (en) * | 2017-09-27 | 2018-03-02 | 中国船级社 | A kind of optimal Calculation of stowage on board method of the loading instrument of bulk freighter and oil carrier |
| CN111639396A (en) * | 2020-05-29 | 2020-09-08 | 江苏新扬子造船有限公司 | Excel-based ship loading calculation method |
| CN111859806A (en) * | 2020-07-22 | 2020-10-30 | 大连陆海科技股份有限公司 | Intelligent ship-oriented liquid tank stowage method and system |
-
2021
- 2021-12-16 CN CN202111539805.XA patent/CN114056510A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JPS59206291A (en) * | 1983-05-11 | 1984-11-22 | Mitsubishi Heavy Ind Ltd | Device for calculating optimum ship attitude |
| KR20160022695A (en) * | 2014-08-20 | 2016-03-02 | 대우조선해양 주식회사 | Real time automated analysis system for shipping stability |
| CN105224745A (en) * | 2015-09-30 | 2016-01-06 | 华中科技大学 | Ship loading performance optimization system |
| CN105608548A (en) * | 2016-01-20 | 2016-05-25 | 大连海事大学 | Automatic stowage method of bulk carrier stowage meter |
| CN107745785A (en) * | 2017-09-27 | 2018-03-02 | 中国船级社 | A kind of optimal Calculation of stowage on board method of the loading instrument of bulk freighter and oil carrier |
| CN111639396A (en) * | 2020-05-29 | 2020-09-08 | 江苏新扬子造船有限公司 | Excel-based ship loading calculation method |
| CN111859806A (en) * | 2020-07-22 | 2020-10-30 | 大连陆海科技股份有限公司 | Intelligent ship-oriented liquid tank stowage method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111639396B (en) | Excel-based ship loading calculation method | |
| CN105022882B (en) | A kind of ship still water shearing force and calculation of Bending Moment method | |
| CN105825061A (en) | Method for calculating random floating state of ship on basis of STL model | |
| CN105224745B (en) | Ship loading performance optimization system | |
| Fitriadhy et al. | Course stability of a ship towing system | |
| Biliotti et al. | Automatic parametric hull form optimization of fast naval vessels | |
| KR20140014975A (en) | A ship | |
| CN113581408A (en) | Ship block division method | |
| CN113353208A (en) | Method for judging initial floating state of ship inclination test | |
| CN114056510A (en) | Excel-based ship loading calculation method | |
| Jafaryeganeh et al. | Multi-objective optimization of internal compartment layout of oil tankers | |
| Pan et al. | Calculation on the uprighting process of a capsized Ship | |
| Coraddu et al. | Investigation about wave profile effects on ship stability | |
| Rodrigues et al. | Assessment of still water bending moments for damaged hull girders | |
| Ding et al. | Nonlinear optimization method of ship floating condition calculation in wave based on vector | |
| CN111674524B (en) | Bottom-up molded line layered design method for ballastless water ship | |
| CN105314078A (en) | A rapid calculation method of the draughts in hoisting work of a crane ship | |
| CN114670984A (en) | Method for calculating damage GZ curve of ship in liquid cargo ship ballast instrument | |
| Trincas et al. | Future outlook of artificial cavity application for reducing hydrodynamic resistance of containerships | |
| Braidotti et al. | A ballast allocation technique to minimize fuel consumption | |
| Sundaresan et al. | Naval architectural considerations in the design of floating dock | |
| CN117775221A (en) | Pitching optimization method and intelligent load method based on pitching optimization | |
| Kaup et al. | Design methodology of strength verification of platform during load out of the Arkutun Dagi SE-Topside 43.800 MT | |
| CN110502835A (en) | A kind of center of gravity calculation method of 10,000 tons load | |
| CN111563286B (en) | Method for calculating support reaction force of ship docking block |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |