Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

EXCEL-based draft survey method and EXCEL-based draft survey system

A water gauge weighing and water gauge technology, which is applied in the field of data processing, can solve the problems of not considering the computer floating point calculation, time-consuming, high error rate, etc., to solve the problem of computer floating point calculation, shorten the operation process, repair Accurate and reliable results about results

Inactive Publication Date: 2017-01-11
中国检验认证集团福建有限公司
View PDF2 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

EXCEL's built-in function can only perform automatic rounding of "rounding off", and the water gauge weighing personnel need to manually round off the numerical results. The calculation results are time-consuming and have a high error rate in the rounding process.
After reviewing a large amount of information, there are many rounding formulas for "rounding off to five odd and double", but there are no rounding formulas for the process of measuring the water gauge, and more importantly, most of the rounding formulas do not take into account the floating point of the computer itself Calculation problems, frequent errors during use

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
  • EXCEL-based draft survey method and EXCEL-based draft survey system
  • EXCEL-based draft survey method and EXCEL-based draft survey system
  • EXCEL-based draft survey method and EXCEL-based draft survey system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0028] refer to figure 1 , the present invention provides a kind of water gauge weighing method based on EXCEL, and this method comprises:

[0029] Step 100, obtaining input data in response to the user's input operation;

[0030] Since most of the data in water gauge weighing is reused, that is, unchanged data, only a small part of the data is actually collected and changed data, so the user needs to input the changed data into the EXCEL form. The data 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
Login to View More

PUM

No PUM Login to View More

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 [0001] The invention relates to the technical field of data processing, in particular to an EXCEL-based water gauge weighing method and system. Background technique [0002] As a fair and impartial third-party inspection agency, China Inspection and Certification Group cannot simply issue a one-page draft report certificate with only the weight of the cargo when bulk cargo is weighed by a draft gauge. Calculation of tank capacity, pipe height, measured ballast water depth, etc. in the required data, and water gauge, drift center, trim correction, measured seawater density, and start water gauge weighing time, weather, loading and unloading during the displacement calculation process Hong Kong, etc. to make detailed records for review. A total of more than ten pages of record forms. There are more data required and more data to be reused. In the process of repeated use, one is error-prone and the other is time-wasting. [0003] In order to make the test res...

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): G06F19/00
CPCG16Z99/00
Inventor 朱明伟
Owner 中国检验认证集团福建有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com