CN109872446A - A kind of method of banknote Information Statistics - Google Patents
A kind of method of banknote Information Statistics Download PDFInfo
- Publication number
- CN109872446A CN109872446A CN201811542253.6A CN201811542253A CN109872446A CN 109872446 A CN109872446 A CN 109872446A CN 201811542253 A CN201811542253 A CN 201811542253A CN 109872446 A CN109872446 A CN 109872446A
- Authority
- CN
- China
- Prior art keywords
- banknote
- information
- information table
- denomination
- statistics
- 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 13
- 230000008859 change Effects 0.000 claims description 12
- 238000000926 separation method Methods 0.000 claims description 3
- 238000004458 analytical method Methods 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000013479 data entry Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
Landscapes
- Inspection Of Paper Currency And Valuable Securities (AREA)
Abstract
A kind of method that the present invention discloses banknote Information Statistics, step is, make several information tables Z1-Zk, differentiate the banknote denomination in single information table, the information table of identical denomination is summarized into the same excel, the information table D1-Dk of several different denominations is obtained, and marks the date in the information table D1-Dk of different denominations；It carries out counting scheduled banknote information using Excel formula, obtain in the statistics of banknote information in the information table D1-Dk of different denominations, and the information table D1-Dk of different denominations according to denomination, the banknote Information Statistics on date.The present invention realizes banknote information programming count, and can analyze each denomination refuses paper money rate, the variation of each sensor banknote width, the variation of each sensor banknote spacing, the variation of each sensor banknote slope and width, spacing, slope with the date variation.
Description
Technical field
The present invention relates to banknote technical field of data processing, more particularly to a kind of method of banknote Information Statistics.
Background technique
Enterprise is manufactured in finance device, in order to guarantee the accurate motion of equipment, needs the processing banknote to equipment
Information is counted, and with the validity of detection device, and the data entries for needing to be grasped and counting are more, and inner capacities is big, and current
Traditional follows banknote information statistical method inefficiency, and the plenty of time is needed to handle, very cumbersome, complicated, it is therefore desirable to a kind of
Quick data processing method keeps processing more efficient, convenient.
Summary of the invention
In view of the technical drawbacks of the prior art, it is an object of the present invention to provide a kind of sides of banknote Information Statistics
Method.
The technical solution adopted to achieve the purpose of the present invention is:
A kind of method of banknote Information Statistics, comprising steps of
S1, several information tables Z1-Zk is made, differentiates the banknote denomination in single information table, by the information of identical denomination
Table summarizes the information table D1-Dk that several different denominations are obtained into the same excel；
It on date in S2, resolution information table Z1-Zk in single information table, is marked in the information table D1-Dk of different denominations
Date；
S3, it carries out counting scheduled banknote information using Excel formula, counts the total number of banknote, benefit including the use of COUNT
Banknote width, spacing maximum are counted with MAX, counts banknote width, spacing minimum value using MIN, counts banknote using STDEV
Width, separation criteria are poor, count banknote width, spacing mean value using AVERAGE, using COUNTIF statistics banknote slope at certain
Total number in one section refuses paper money number, and according to paper money number and total number is refused, calculating refuses paper money rate, counts certain using SUMPRODUCT
Paper money rate, maximum value, minimum value, standard deviation, mean value are refused in one date section；
S4, by step S1, S3, obtain the statistics of banknote information in the information table D1-Dk of different denominations, with realize analysis
Each denomination banknotes refuse paper money rate, the change information of each sensor banknote width, the change information of each sensor banknote spacing, and
The change information of each sensor banknote slope；
S5, it obtains uniting in the information table D1-Dk of different denominations according to the banknote information on denomination, date by step S1-S3
Meter, with realize analyze each denomination banknotes width, spacing, slope according to the date change information.
The information for including in each information table of the information table Z1-Zk have banknote serial number, banknote width, banknote spacing,
Banknote slope, authenticity of banknotes, banknote denomination, each sensor width, each sensor spacing and each sensor slope；The information
Table Z1-Zk is that the banknote of predetermined quantity and denomination is obtained after machine recognition several times.
In step S1, if multiple banknote denominations occurs in an information table, the banknote number of identical denomination, number are counted
More banknote denominations is the denomination of information table.
The present invention is able to achieve express statistic and processing to banknote information, grasps banknote information.
Specific embodiment
Below in conjunction with specific embodiment, invention is further described in detail.It should be appreciated that described herein specific
Embodiment is only used to explain the present invention, is not intended to limit the present invention.
The method of banknote Information Statistics of the invention, comprising steps of
S1, several information tables Z1-Zk is made, differentiates the banknote denomination in single information table, by the information of identical denomination
Table summarizes the information table D1-Dk that several different denominations are obtained into the same excel；
It on date in S2, resolution information table Z1-Zk in single information table, is marked in the information table D1-Dk of different denominations
Date；
S3, it carries out counting scheduled banknote information using Excel formula, counts the total number of banknote, benefit including the use of COUNT
Banknote width, spacing maximum are counted with MAX, counts banknote width, spacing minimum value using MIN, counts banknote using STDEV
Width, separation criteria are poor, count banknote width, spacing mean value using AVERAGE, using COUNTIF statistics banknote slope at certain
Total number in one section refuses paper money number, and according to paper money number and total number is refused, calculating refuses paper money rate, counts certain using SUMPRODUCT
Paper money rate, maximum value, minimum value, standard deviation, mean value are refused in one date section；
S4, by step S1, S3, obtain the statistics of banknote information in the information table D1-Dk of different denominations, with realize analysis
Each denomination banknotes refuse paper money rate, the change information of each sensor banknote width, the change information of each sensor banknote spacing, and
The change information of each sensor banknote slope；
S5, it obtains uniting in the information table D1-Dk of different denominations according to the banknote information on denomination, date by step S1-S3
Meter, with realize analyze each denomination banknotes width, spacing, slope according to the date change information.
The information for including in each information table of the information table Z1-Zk have banknote serial number, banknote width, banknote spacing,
Banknote slope, authenticity of banknotes, banknote denomination, each sensor width, each sensor spacing and each sensor slope；The information
Table Z1-Zk is that the banknote of predetermined quantity and denomination is obtained after machine recognition several times.
In step S1, if multiple banknote denominations occurs in an information table, the banknote number of identical denomination, number are counted
More banknote denominations is the denomination of information table.
Above-mentioned statistic processes and method of the invention, can be realized by computer programming.
The above is only a preferred embodiment of the present invention, it is noted that for the common skill of the art
For art personnel, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications
Also it should be regarded as protection scope of the present invention.
Claims (3)
1. a kind of method of banknote Information Statistics, which is characterized in that comprising steps of
S1, several information tables Z1-Zk is made, differentiates the banknote denomination in single information table, the information table of identical denomination is converged
Always into the same excel, the information table D1-Dk of several different denominations is obtained；
On date in S2, resolution information table Z1-Zk in single information table, the date is marked in the information table D1-Dk of different denominations；
S3, it carries out counting scheduled banknote information using Excel formula, counts the total number of banknote including the use of COUNT, utilize
MAX counts banknote width, spacing maximum, counts banknote width, spacing minimum value using MIN, wide using STDEV statistics banknote
Degree, separation criteria are poor, count banknote width, spacing mean value using AVERAGE, using COUNTIF statistics banknote slope a certain
Total number in section refuses paper money number, and according to paper money number and total number is refused, paper money rate is refused in calculating, counts a certain using SUMPRODUCT
Paper money rate, maximum value, minimum value, standard deviation, mean value are refused in date section；
S4, by step S1, S3, obtain the statistics of banknote information in the information table D1-Dk of different denominations, analyze each face to realize
Volume banknote refuses paper money rate, the change information of each sensor banknote width, the change information of each sensor banknote spacing, and each biography
The change information of sensor banknote slope；
S5, it obtains in the information table D1-Dk of different denominations by step S1-S3 according to denomination, the banknote Information Statistics on date, with
Realize analyze each denomination banknotes width, spacing, slope according to the date change information.
2. the method for banknote Information Statistics as described in claim 1, which is characterized in that each information of the information table Z1-Zk
The information for including in table has banknote serial number, banknote width, banknote spacing, banknote slope, authenticity of banknotes, banknote denomination, each sensing
Device width, each sensor spacing and each sensor slope；The information table Z1-Zk is the banknote warp of predetermined quantity and denomination
It is obtained after machine recognition several times.
3. the method for banknote Information Statistics as described in claim 1, which is characterized in that in step S1, if an information table goes out
Existing multiple banknote denominations, then count the banknote number of identical denomination, and the banknote denomination more than number is the denomination of information table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811542253.6A CN109872446A (en) | 2018-12-17 | 2018-12-17 | A kind of method of banknote Information Statistics |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811542253.6A CN109872446A (en) | 2018-12-17 | 2018-12-17 | A kind of method of banknote Information Statistics |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109872446A true CN109872446A (en) | 2019-06-11 |
Family
ID=66917069
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811542253.6A Pending CN109872446A (en) | 2018-12-17 | 2018-12-17 | A kind of method of banknote Information Statistics |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109872446A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR101492406B1 (en) * | 2013-09-06 | 2015-02-16 | 기산전자 주식회사 | System for analyzing and forecasting status of banknote processing device and hierarchy structure thereof |
| JP2016012183A (en) * | 2014-06-27 | 2016-01-21 | 沖電気工業株式会社 | Medium transaction device |
| CN107885710A (en) * | 2017-11-10 | 2018-04-06 | 中国银行股份有限公司 | A kind of generation method and device of bank's parameter report |
-
2018
- 2018-12-17 CN CN201811542253.6A patent/CN109872446A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR101492406B1 (en) * | 2013-09-06 | 2015-02-16 | 기산전자 주식회사 | System for analyzing and forecasting status of banknote processing device and hierarchy structure thereof |
| US20150071522A1 (en) * | 2013-09-06 | 2015-03-12 | Kisan Electronics Co., Ltd. | System and method for analyzing and/or estimating state of banknote processing apparatus |
| JP2016012183A (en) * | 2014-06-27 | 2016-01-21 | 沖電気工業株式会社 | Medium transaction device |
| CN107885710A (en) * | 2017-11-10 | 2018-04-06 | 中国银行股份有限公司 | A kind of generation method and device of bank's parameter report |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102576480A (en) | Method for processing banknotes | |
| CN103198553B (en) | Coin automatic depositing-withdrawing changer | |
| EP3226215B1 (en) | Money processing system | |
| CN101377868B (en) | Equipment capable of sorting, ironing, disinfecting stored banknote in a bank counter to be fetched by drawing person | |
| CN109872446A (en) | A kind of method of banknote Information Statistics | |
| CN206097283U (en) | Multi -functional bus coin box | |
| US9666007B2 (en) | Method and apparatus for handling value documents | |
| CN104574630A (en) | Novel slot machine for bus | |
| CN103996240B (en) | A kind of bank note turnover money system | |
| CN106384421A (en) | Multifunctional coin box suitable to bus | |
| RU2015127990A (en) | PAPER SHEET MANAGEMENT DEVICE, PAPER SHEET PROCESSING SYSTEM AND PAPER SHEET MANAGEMENT METHOD | |
| US20190012870A1 (en) | Money handling apparatus, fee calculating apparatus, money handling method, and fee calculation method | |
| JP6460863B2 (en) | Paper sheet information processing system and paper sheet information processing method | |
| CN103456084A (en) | Multi-batch paper currency handling method | |
| CN108446739A (en) | A kind of data inputting monitoring method and device | |
| CN105205945B (en) | Automatic trading apparatus and server and method for predicting customer's cash demand amount | |
| CN104085722A (en) | Paper processing device | |
| CN207148895U (en) | A kind of note output press-note mechanism of paper money counter | |
| CN108154282B (en) | Method and device for acquiring workload of judge staff | |
| KR101385840B1 (en) | Bill counting device and method for providing a counting and log data | |
| CN205644752U (en) | Coin classification adding machine of many slides | |
| CN105469495B (en) | It is a kind of to be used to detect method of the paper money counter to paper money number discrimination | |
| CN113012337B (en) | Paper currency sorting method | |
| CN208834381U (en) | A kind of Horizontal paper banknote classifying machine with measuring thickness device | |
| CN203882387U (en) | Self-help printing terminator coin inserting device |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190611 |