CN106326650A - EXCEL-based draft survey method and EXCEL-based draft survey system - Google Patents
EXCEL-based draft survey method and EXCEL-based draft survey system Download PDFInfo
- Publication number
- CN106326650A CN106326650A CN201610701735.6A CN201610701735A CN106326650A CN 106326650 A CN106326650 A CN 106326650A CN 201610701735 A CN201610701735 A CN 201610701735A CN 106326650 A CN106326650 A CN 106326650A
- Authority
- CN
- China
- Prior art keywords
- data
- revision
- convention
- water
- excel
- 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
- 238000000034 method Methods 0.000 title claims abstract description 52
- 230000008569 process Effects 0.000 claims abstract description 23
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims description 56
- XECAHXYUAAWDEL-UHFFFAOYSA-N acrylonitrile butadiene styrene Chemical compound C=CC=C.C=CC#N.C=CC1=CC=CC=C1 XECAHXYUAAWDEL-UHFFFAOYSA-N 0.000 claims description 15
- 239000013505 freshwater Substances 0.000 claims description 11
- 239000000295 fuel oil Substances 0.000 claims description 10
- 238000000151 deposition Methods 0.000 claims description 5
- 238000012545 processing Methods 0.000 abstract description 6
- 238000004364 calculation method Methods 0.000 abstract description 5
- 238000012937 correction Methods 0.000 description 20
- 238000006073 displacement reaction Methods 0.000 description 18
- 230000006870 function Effects 0.000 description 13
- 238000004590 computer program Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 7
- 230000008859 change Effects 0.000 description 6
- 150000003839 salts Chemical class 0.000 description 6
- 239000003651 drinking water Substances 0.000 description 5
- 235000020188 drinking water Nutrition 0.000 description 5
- 238000005259 measurement Methods 0.000 description 5
- 239000013535 sea water Substances 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 238000009966 trimming Methods 0.000 description 3
- 238000003556 assay Methods 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000002485 combustion reaction Methods 0.000 description 1
- 238000007599 discharging Methods 0.000 description 1
- 238000005194 fractionation Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 239000003921 oil Substances 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000000638 solvent extraction Methods 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
- 238000005303 weighing Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16Z—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS, NOT OTHERWISE PROVIDED FOR
- G16Z99/00—Subject matter not provided for in other main groups of this subclass
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an EXCEL-based draft survey method and an EXCEL-based draft survey system and relates to the technical field of data processing. The method comprises the following steps of after obtaining data input by a user and automatically collected, calculating cargo weight data according to a preset calculation formula, and performing round-off treatment on the cargo weight data by use of a set round-off formula. Since a ROUND function is used in the round-off formula, the floating-point calculation problem of a calculator is fundamentally solved, the round-off result is accurate and reliable, and the operation process is shortened.
Description
Technical field
The present invention relates to technical field of data processing, particularly to a kind of Weight by Draft method and system based on EXCEL.
Background technology
CCIC is as fair, just third party inspection mechanism, when large amount bulk cargo Weight by Draft, no
Can simply provide one page and only have the water gauge report certificate of goods weight, need water ballast meter in the initial data to the process of calculating
Calculate the volume of compartment in desired data, Guan Gao, the actual measurement water ballast degree of depth etc. and displacement calculate during water gauge, the centre of floatation, trim
Correction, actual measurement density of sea water and beginning Weight by Draft time, weather, dress port of discharge etc. carry out itemized record, in case check.Always
Page totally tens charting.Desired data is more, and reusable data are the most more, and during reusing, one is easy
Makeing mistakes, two is to lose time.
Water gauge is reported as making assay more scientific, needs to advise result of calculation according to the GB/T 8170-2008 numerical value revision of the convention
Then expression and the judgement with limiting figure carries out " four houses six enter five Dan Shuan " revision of the convention.EXCEL can only carry out " four houses five from tape function
Enter " automatic rounding, Weight by Draft personnel need logarithm value result to carry out the manual revision of the convention, and result of calculation consumes during the revision of the convention
Time relatively big, error rate is higher.Looking through a great amount of information, the numerical value revision of the convention formula for " four houses six enter five Dan Shuan " is a lot, but pin
The revision of the convention formula of Weight by Draft process is not had, it is often more important that most of revision of the convention formula do not account for the floating-point of computer itself
Computational problem, the most often makes mistakes.
Summary of the invention
Embodiments provide a kind of Weight by Draft method and system based on EXCEL, in order to solve prior art
Present in problem.
A kind of Weight by Draft method based on EXCEL, including:
Obtaining the input data of user input, described input data include the hexahedro water gauge of boats and ships, the water ballast degree of depth, combustion
The oil degree of depth and the fresh water degree of depth；
Data acquisition is carried out, it is thus achieved that gathering data, described collection data include light weight and ship by the way of link
Oceangoing ship constant；
Goods weight is calculated, it is thus achieved that goods weight data according to described input data and collection data；
According to following revision of the convention formula, described goods weight data are carried out revision of the convention process, it is thus achieved that revision of the convention data:
A=IF (AND (ROUND (ABS (B27) * 10^ (n+1)-INT (ABS (B27) * 10^n) * 10^n, n)=5, MOD
(INT (ABS (B27) * 10^n), 2)=0), and ROUNDDOWN (B27, n), ROUND (B27, n))；
Wherein, a is described revision of the convention data, and B27 is the numbering of the cell depositing described goods weight data, and n is for needing to protect
The decimal digits stayed, IF, AND, ROUND, ABS, INT, MOD, ROUNDDOWN are the function in EXCEL.
Preferably, described method also includes: use the certificate format set and described revision of the convention data genaration to demonstrate,prove accordingly
Book.
Preferably, while carrying out data acquisition, if desired data are set to different forms, use conditional formats
Obtain the expression format of each data in certificate with user-defined format, and described collection data are set to corresponding form.
Preferably, the water gauge that described boats and ships are hexahedro estimated by survey crew or use readout instrument read the bow of boats and ships, midship,
The water gauge of stern both sides obtains；The ballasting water tank that the described water ballast degree of depth is entered boats and ships by survey crew uses ribbon measurement to obtain
?；The fuel oil tank that the described fuel oil degree of depth is entered boats and ships by survey crew uses ribbon to measure acquisition；The described fresh water degree of depth is by surveying
Amount personnel enter the fresh-water tank of boats and ships and use ribbon to measure acquisition.
Present invention also offers a kind of Weight by Draft system based on EXCEL, including:
Input module, for obtaining the input data of user input, described input data include the hexahedro water gauge of boats and ships,
The water ballast degree of depth, the fuel oil degree of depth and the fresh water degree of depth；
Data acquisition module, for carrying out data acquisition, it is thus achieved that gather data, described collection data by the way of link
Including light weight and ship's constant；
Computing module, for calculating goods weight according to described input data and collection data, it is thus achieved that goods weight data；
Data revision of the convention module, for carrying out revision of the convention process according to following revision of the convention formula by described goods weight data, it is thus achieved that
Revision of the convention data:
A=IF (AND (ROUND (ABS (B27) * 10^ (n+1)-INT (ABS (B27) * 10^n) * 10^n, n)=5, MOD
(INT (ABS (B27) * 10^n), 2)=0), and ROUNDDOWN (B27, n), ROUND (B27, n))；
Wherein, a is described revision of the convention data, and B27 is the numbering of the cell depositing described goods weight data, and n is for needing to protect
The decimal digits stayed, IF, AND, ROUND, ABS, INT, MOD, ROUNDDOWN are the function in EXCEL.
Preferably, described system also includes: certificates constructing module, for using the certificate format of setting and the described revision of the convention
The corresponding certificate of data genaration.
Preferably, data, while carrying out data acquisition, are if desired set to different by described data acquisition module
Form, uses conditional formats and user-defined format to obtain the expression format of each data in certificate, and described collection data is arranged
For corresponding form.
A kind of Weight by Draft method and system based on EXCEL in the embodiment of the present invention, obtain user input with
And after the data automatically gathered, calculate goods weight data according to default computing formula, and use the revision of the convention formula pair of setting
Goods weight data carry out revision of the convention process, owing to employing ROUND function in revision of the convention formula, fundamentally solve computer and float
Point computational problem, makes revision of the convention result accurately reliable, shortens operating process.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
In having technology to describe, the required accompanying drawing used is briefly described, it should be apparent that, the accompanying drawing in describing below is only this
Some embodiments of invention invention, for those of ordinary skill in the art, on the premise of not paying creative work, also
Other accompanying drawing can be obtained according to these accompanying drawings.
The steps flow chart schematic diagram of a kind of based on EXCEL Weight by Draft method that Fig. 1 provides for the embodiment of the present invention.
Detailed description of the invention
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Describe, it is clear that described embodiment is only a part of embodiment of the present invention rather than whole embodiments wholely.Based on
Embodiment in the present invention, it is every other that those of ordinary skill in the art are obtained under not making creative work premise
Embodiment, broadly falls into the scope of protection of the invention.
With reference to Fig. 1, the invention provides a kind of Weight by Draft method based on EXCEL, the method includes:
Step 100, the input operation of response user obtains input data；
Owing in Weight by Draft, major part data are for reusing, the most constant data, only fraction data are actual
The data of the change gathered, it is therefore desirable to user is by the data input Microsoft Excel of change.Use during Weight by Draft
To data include water gauge, the water ballast degree of depth, the fuel oil degree of depth and the fresh water degree of depth that boats and ships are hexahedro, data above is both needed to survey crew
Input to Microsoft Excel after measurement.The hexahedro water gauge of boats and ships includes left bow water gauge, right bow water gauge, left midship water gauge, right midship water
Chi, left stern water gauge and right stern water gauge, taken advantage of canoe to the bow of boats and ships, midship, stern two by survey crew when measuring the hexahedro water gauge of boats and ships
Sidelong glance is surveyed and is read water gauge reading, or is read water gauge reading by the bow of little boat-carrying readout instrument to boats and ships, midship, stern both sides；Water ballast
Depth survey by survey crew enter ballasting water tank use ribbon measure the water ballast degree of depth；The fuel oil degree of depth and the fresh water degree of depth
Measure identical with the metering system of the water ballast degree of depth, i.e. entered fuel oil tank or the fresh-water tank use ribbon of boats and ships by survey crew
Measure and obtain.
Step 110, carries out data acquisition by the way of link in Microsoft Excel automatically, it is thus achieved that gather data；
The data gathered in this step are reusable constant data, and those data are stored in advance in the list specified
In unit's lattice, only need during use to obtain, by link, the data formulated in cell, it is to avoid manually repeatedly input data.Carry out
While data acquisition, if desired data are set to different forms, it is possible to use conditional formats and user-defined format obtain
The expression format of each data in certificate, and described collection data are set to corresponding form, meet the call format of certificate, keep away
Exempt from format error.Wherein, described collection data include light weight and ship's constant.
Step 120, calculates goods weight according to computing formula set in advance and described input data and collection data,
Obtain corresponding goods weight data；
In this step, by the function of EXCEL self-defining function, needing to deposit the cell of described goods weight data
Defined in described computing formula, then by calculate obtain described goods weight data leave in the cell specified.
Wherein, the step calculating described goods weight includes the displacement after calculating salt water density correction, and according to institute
State the displacement after salt water density correction and calculate described goods weight.
Specifically, the displacement after calculating salt water density correction specifically includes:
FORE DRAFT correction value under Ship ' trimming condition:
Wherein, FcAbsorbing water trim correction value for ship bow, T is before boats and ships trim correction about stern left and right Mean Draught and bow
The difference of Mean Draught, LBPFor the distance between ship bow after perpendicular, DfThe distance being tagged between FP for bow water gauge, DaFor stern water
Chi is tagged to the distance between after perpendicular.
Aft draft correction value under Ship ' trimming condition:
Wherein, AcTrim correction value is absorbed water for ship stern.
Midship drinking water correction value under Ship ' trimming condition:
Wherein, McTrim correction value, D is absorbed water for boats and ships midshipmThe distance of ship midship it is tagged to for midship water gauge.
Calculate revised bow Mean Draught:
Fm=Fps+Fc
Wherein, FmFor ship bow Mean Draught, FpsAbsorb water for bow left and right average observed.
Calculate revised stern Mean Draught:
Am=Aps±Ac
Wherein, AmFor ship stern Mean Draught, ApsAbsorb water for stern left and right average observed.
Calculating bow, stern Mean Draught:
Mpc=Mp±Mc
Wherein, MpcFor ship bow, stern Mean Draught, MpFor ship bow Mean Draught.
Calculate revised right midship to absorb water:
Msc=Ms±Mc
Wherein, MscAbsorb water for revised right midship, MsFor the observation drinking water of right midship.
Calculating midship Mean Draught:
Mm=(Mpc+Msc)/2
Wherein, MmFor the left and right Mean Draught of midship.
Calculate arch, fall into Mean of Mean after correction:
D/M=(Fm+Am+6Mm)/8
Wherein, D/M is boats and ships arch, falls into Mean of Mean after correction.
Calculating displacement trim corrected value:
Wherein, Δ W is displacement trim corrected value, and TPC is every centimetre of drinking water ton of D/M corresponding position, XfAt D/M drinking water
The centre of floatation is away from ship midship distance, TcBow, the trim of aft draft after correcting for trim, dm/dz is upper and lower 50cm trim at D/M drinking water
The change residual quantity of moment MTC.
Displacement after calculating trim correction:
Δ3=Δ2+ΔW
Wherein, Δ3Displacement after correcting for trim, Δ2For the respective row water yield.
Displacement after calculating water density correction:
Δ4=Δ3·ρ1/ρ2
Wherein, Δ4For displacement after salt water density correction, ρ1For actual measurement density of sea water, ρ2For sea water tabulation density.
The step calculating described goods weight includes:
Calculate weight loaded, make the weight loaded calculated using the following method be described goods weight in loading process:
WL=(B-b)-(A-a)
Wherein, WLFor weight loaded, B is actual displacement after the loading using above method to calculate, i.e. sea water after loading
Displacement after density correction, b is the weight such as Ship's Elements and other goods after loading, and A is the dress using above method to calculate
Displacement after the front salt water density correction of actual displacement before goods, i.e. loading, a is the weight such as Ship's Elements and other goods before loading
Amount.
Calculate landing weight, make the landing weight calculated using the following method be described goods weight in Discharging Process:
WD=(Al-al)-(Bl-bl)
Wherein, WDFor landing weight, Al is actual displacement before the unloading using above method to calculate, i.e. sea water before unloading
Displacement after density correction, al is the weight such as Ship's Elements and other goods before unloading, and Bl is to use above method to calculate
Actual displacement after unloading, i.e. displacement after salt water density correction after unloading, bl is Ship's Elements and other goods after unloading
Etc. weight.
Described goods weight data are carried out revision of the convention process according to revision of the convention formula set in advance by step 130, it is thus achieved that corresponding
Revision of the convention data, described revision of the convention formula is:
A=IF (AND (ROUND (ABS (B27) * 10^ (n+1)-INT (ABS (B27) * 10^n) * 10^n, n)=5, MOD
(INT (ABS (B27) * 10^n), 2)=0), and ROUNDDOWN (B27, n), ROUND (B27, n))；
Wherein, a is described revision of the convention data, and B27 is the numbering of the cell depositing described goods weight data, and n is for needing to protect
The decimal digits stayed, IF, AND, ROUND, ABS, INT, MOD and ROUNDDOWN are in EXCEL conventional function, at this not
Elaborate.Owing to described revision of the convention formula employing ROUND function, fundamentally solve asking of computer floating-point operation
Topic.
Step 140, uses the certificate format and the described corresponding certificate of revision of the convention data genaration set.
Based on same inventive concept, embodiments provide a kind of Weight by Draft system based on EXCEL, due to this
The principle that system solves technical problem is similar with a kind of Weight by Draft method based on EXCEL, and therefore the enforcement of this system can be joined
According to the enforcement of method, repeat no more in place of repetition.
Input module 200, obtains input data for responding the input operation of user；
Data acquisition module 210, for automatically carrying out data acquisition by the way of link in Microsoft Excel, it is thus achieved that
Gather data；
Computing module 220, for calculating according to computing formula set in advance and described input data and collection data
Goods weight, it is thus achieved that corresponding goods weight data；
Data revision of the convention module 230, for carrying out the revision of the convention according to revision of the convention formula set in advance to described goods weight data
Process, it is thus achieved that corresponding revision of the convention data；
Certificates constructing module 240, for using the certificate format of setting and the described corresponding certificate of revision of the convention data genaration.
Should be appreciated that this system realizes according to module that one of the above Weight by Draft based on EXCEL system includes is only
The logical partitioning that carries out of function, in actual application, superposition or the fractionation of above-mentioned module can be carried out.And this embodiment provides
A kind of based on EXCEL water of providing with above-described embodiment of the function that realized of a kind of based on EXCEL Weight by Draft system
Chi meter weighing method one_to_one corresponding, the more detailed handling process realized for this system, in said method embodiment one
It is described in detail, is not described in detail herein.
Those skilled in the art are it should be appreciated that embodiments of the invention can be provided as method, system or computer program
Product.Therefore, the reality in terms of the present invention can use complete hardware embodiment, complete software implementation or combine software and hardware
Execute the form of example.And, the present invention can use at one or more computers wherein including computer usable program code
The upper computer program product implemented of usable storage medium (including but not limited to disk memory, CD-ROM, optical memory etc.)
The form of product.
The present invention is with reference to method, equipment (system) and the flow process of computer program according to embodiments of the present invention
Figure and/or block diagram describe.It should be understood that can the most first-class by computer program instructions flowchart and/or block diagram
Flow process in journey and/or square frame and flow chart and/or block diagram and/or the combination of square frame.These computer programs can be provided
Instruction arrives the processor of general purpose computer, special-purpose computer, Embedded Processor or other programmable data processing device to produce
A raw machine so that the instruction performed by the processor of computer or other programmable data processing device is produced for real
The device of the function specified in one flow process of flow chart or multiple flow process and/or one square frame of block diagram or multiple square frame now.
These computer program instructions may be alternatively stored in and computer or other programmable data processing device can be guided with spy
Determine in the computer-readable memory that mode works so that the instruction being stored in this computer-readable memory produces and includes referring to
Make the manufacture of device, this command device realize at one flow process of flow chart or multiple flow process and/or one square frame of block diagram or
The function specified in multiple square frames.
These computer program instructions also can be loaded in computer or other programmable data processing device so that at meter
Perform sequence of operations step on calculation machine or other programmable devices to produce computer implemented process, thus at computer or
The instruction performed on other programmable devices provides for realizing at one flow process of flow chart or multiple flow process and/or block diagram one
The step of the function specified in individual square frame or multiple square frame.
Although preferred embodiments of the present invention have been described, but those skilled in the art once know basic creation
Property concept, then can make other change and amendment to these embodiments.So, claims are intended to be construed to include excellent
Select embodiment and fall into all changes and the amendment of the scope of the invention.
Obviously, those skilled in the art can carry out various change and the modification essence without deviating from the present invention to the present invention
God and scope.So, if these amendments of the present invention and modification belong to the scope of the claims in the present invention and equivalent technologies thereof
Within, then the present invention is also intended to comprise these change and modification.
Claims (7)
1. a Weight by Draft method based on EXCEL, it is characterised in that including:
Obtaining the input data of user input, described input data include that the hexahedro water gauge of boats and ships, the water ballast degree of depth, fuel oil are deep
Degree and the fresh water degree of depth；
Data acquisition is carried out, it is thus achieved that gathering data, described collection data include that light weight and boats and ships are normal by the way of link
Number；
Goods weight is calculated, it is thus achieved that goods weight data according to described input data and collection data；
According to following revision of the convention formula, described goods weight data are carried out revision of the convention process, it is thus achieved that revision of the convention data:
A=IF (AND (ROUND (ABS (B27) * 10^ (n+1)-INT (ABS (B27) * 10^n) * 10^n, n)=5, MOD (INT
(ABS (B27) * 10^n), 2)=0), ROUNDDOWN (B27, n), ROUND (B27, n))；
Wherein, a is described revision of the convention data, and B27 is the numbering of the cell depositing described goods weight data, and n is need to retain
Decimal digits, IF, AND, ROUND, ABS, INT, MOD, ROUNDDOWN are the function in EXCEL.
2. the method for claim 1, it is characterised in that described method also includes: use set certificate format and
The described corresponding certificate of revision of the convention data genaration.
3. data are if desired arranged by the method for claim 1, it is characterised in that while carrying out data acquisition
For different forms, conditional formats and user-defined format is used to obtain the expression format of each data in certificate, and by described collection
Data are set to corresponding form.
4. the method for claim 1, it is characterised in that the hexahedro water gauge of described boats and ships is estimated by survey crew or makes
The water gauge acquisition of the bow of boats and ships, midship, stern both sides is read with readout instrument；The described water ballast degree of depth is entered the pressure of boats and ships by survey crew
Cabin water tank uses ribbon to measure and obtains；The fuel oil tank that the described fuel oil degree of depth is entered boats and ships by survey crew uses ribbon to measure
Obtain；The fresh-water tank that the described fresh water degree of depth is entered boats and ships by survey crew uses ribbon to measure acquisition.
5. a Weight by Draft system based on EXCEL, it is characterised in that including:
Input module, for obtaining the input data of user input, described input data include the hexahedro water gauge of boats and ships, ballasting
Water depth, the fuel oil degree of depth and the fresh water degree of depth；
Data acquisition module, for carrying out data acquisition, it is thus achieved that gathering data, described collection data include by the way of link
Light weight and ship's constant；
Computing module, for calculating goods weight according to described input data and collection data, it is thus achieved that goods weight data；
Data revision of the convention module, for carrying out revision of the convention process according to following revision of the convention formula by described goods weight data, it is thus achieved that the revision of the convention
Data:
A=IF (AND (ROUND (ABS (B27) * 10^ (n+1)-INT (ABS (B27) * 10^n) * 10^n, n)=5, MOD (INT
(ABS (B27) * 10^n), 2)=0), ROUNDDOWN (B27, n), ROUND (B27, n))；
Wherein, a is described revision of the convention data, and B27 is the numbering of the cell depositing described goods weight data, and n is need to retain
Decimal digits, IF, AND, ROUND, ABS, INT, MOD, ROUNDDOWN are the function in EXCEL.
6. system as claimed in claim 5, it is characterised in that described system also includes: certificates constructing module, sets for employing
Fixed certificate format and the described corresponding certificate of revision of the convention data genaration.
7. system as claimed in claim 5, it is characterised in that described data acquisition module while carrying out data acquisition,
If desired data are set to different forms, use conditional formats and user-defined format to obtain the expression lattice of each data in certificate
Formula, and described collection data are set to corresponding form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610701735.6A CN106326650A (en) | 2016-08-22 | 2016-08-22 | EXCEL-based draft survey method and EXCEL-based draft survey system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610701735.6A CN106326650A (en) | 2016-08-22 | 2016-08-22 | EXCEL-based draft survey method and EXCEL-based draft survey system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106326650A true CN106326650A (en) | 2017-01-11 |
Family
ID=57742762
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610701735.6A Pending CN106326650A (en) | 2016-08-22 | 2016-08-22 | EXCEL-based draft survey method and EXCEL-based draft survey system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106326650A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109131770A (en) * | 2018-08-30 | 2019-01-04 | 广船国际有限公司 | A method of measurement vessel displacement |
| CN113291436A (en) * | 2021-06-23 | 2021-08-24 | 芜湖造船厂有限公司 | Method for selecting moving weight and weight moving distance of ship inclination test |
| CN114368458A (en) * | 2022-02-16 | 2022-04-19 | 宁波市恒兴船务有限公司 | Ship water level measurement method and system based on Excel auxiliary calculation |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101905740A (en) * | 2010-09-08 | 2010-12-08 | 南通航运职业技术学院 | Water gauge metering method |
| CN104462038A (en) * | 2014-11-17 | 2015-03-25 | 无锡市产品质量监督检验中心 | Batch data processing method for quality detecting system based on EXCEL |
-
2016
- 2016-08-22 CN CN201610701735.6A patent/CN106326650A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101905740A (en) * | 2010-09-08 | 2010-12-08 | 南通航运职业技术学院 | Water gauge metering method |
| CN104462038A (en) * | 2014-11-17 | 2015-03-25 | 无锡市产品质量监督检验中心 | Batch data processing method for quality detecting system based on EXCEL |
Non-Patent Citations (4)
| Title |
|---|
| PM5GKXM6PB: "中华人民共和国山东出入境检验检疫局文件", 《WWW.DOC88.COM/P-9925713659325.HTML》 * |
| 叶晓路: "一种基于Excel的计量测量数据修约方法", 《科技展望》 * |
| 孙家庆等: "《外轮理货业务 第二版》", 31 March 2015, 中国财富出版社 * |
| 王润峰: "运用Excel在水准计算中自动实现"奇进偶舍"", 《测绘通报》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109131770A (en) * | 2018-08-30 | 2019-01-04 | 广船国际有限公司 | A method of measurement vessel displacement |
| CN109131770B (en) * | 2018-08-30 | 2020-08-07 | 广船国际有限公司 | Method for measuring displacement of ship |
| CN113291436A (en) * | 2021-06-23 | 2021-08-24 | 芜湖造船厂有限公司 | Method for selecting moving weight and weight moving distance of ship inclination test |
| CN114368458A (en) * | 2022-02-16 | 2022-04-19 | 宁波市恒兴船务有限公司 | Ship water level measurement method and system based on Excel auxiliary calculation |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103299308B (en) | Solid modelling is utilized to calculate the liquid level in arbitrary shape hermetic container | |
| CN101750030B (en) | Curved surface detecting system and method | |
| Van de Wiel et al. | An oil outflow model for tanker collisions and groundings | |
| CN106326650A (en) | EXCEL-based draft survey method and EXCEL-based draft survey system | |
| EP3825651A1 (en) | Apparatus for predicting a power consumption of a maritime vessel | |
| CN101195405A (en) | Electric immergence monitoring system for watercraft | |
| CN108801387A (en) | A kind of fuel tanker Fuel Oil Remaining measuring system and method based on learning model | |
| CN101793521A (en) | Method for measuring swaying and surging information of ship based on optical fiber gyroscope inertial measurement system | |
| CN107860434A (en) | A kind of fuel tank for automobile calibration system and scaling method | |
| CN109284848A (en) | The long-range casting planing method of interior row's opencut and computing system | |
| CN113804271A (en) | Ship water gauge metering system and method based on portable differential positioning instrument | |
| CN204855510U (en) | Precise measurement system of oil quality in large -scale oil storage tank | |
| CN115165027B (en) | Water gauge monitoring method and system based on unmanned aerial vehicle, electronic equipment and medium | |
| JP5397811B2 (en) | Wind pressure coefficient estimation program, wind pressure coefficient estimation apparatus, and structure operation control method | |
| CN201914428U (en) | Novel intelligent load measuring instrument for ship | |
| CN108711203B (en) | Damaged hull wave load rapid forecasting method based on proxy model | |
| Gaggero et al. | Effects of uncertainties in loading conditions of bulk carriers on hull girder still water loads | |
| Malenica et al. | On the EU FP7 project: tools for ultra large container ships–TULCS | |
| CN102033997A (en) | Method for reproducing accident of containers dropping into sea | |
| Schartmüller et al. | A simulation-based decision support tool for arctic transit transport | |
| CN117922773B (en) | Cargo loading and unloading weighing method for cargo ship | |
| Ruggeri et al. | The development of Redraft® system in Brazilian ports for safe underkeel clearance computation | |
| George | Stability and Trim for the Ship's Officer | |
| CN107817332A (en) | A kind of method for characterizing potential hydrocarbon source rock later stage preservation efficiency | |
| CN107016153A (en) | Manned spacecraft system weight control method based on matching system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB03 | Change of inventor or designer information |
Inventor after: Zhu Mingwei Inventor after: Chen Xiaochuan Inventor before: Zhu Mingwei |
|
| CB03 | Change of inventor or designer information | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20170523 Address after: 350015 Fujian province Fuzhou Mawei Kuaian Jiangbin East Avenue No. 75 Applicant after: China Certification & inspection group Fujian Co., Ltd. Address before: 350015 Fujian province Fuzhou Mawei Kuaian Jiangbin East Avenue No. 75 Applicant before: Zhu Mingwei Applicant before: Chen Xiaochuan |
|
| TA01 | Transfer of patent application right | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170111 |
|
| RJ01 | Rejection of invention patent application after publication |