CN110414926A - Account management method, device and computer readable storage medium - Google Patents
Account management method, device and computer readable storage medium Download PDFInfo
- Publication number
- CN110414926A CN110414926A CN201910598348.8A CN201910598348A CN110414926A CN 110414926 A CN110414926 A CN 110414926A CN 201910598348 A CN201910598348 A CN 201910598348A CN 110414926 A CN110414926 A CN 110414926A
- Authority
- CN
- China
- Prior art keywords
- data
- computational chart
- account management
- initial data
- split
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Quality & Reliability (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of account management methods, this method comprises: constructing computational chart in account management client, carry out Functional Design to the computational chart according to preset formula, wherein the computational chart includes holding position to split computational chart；Initial data is screened from presetting database, and the initial data filtered out is imported into the computational chart；Each pen initial data is split according to preset algorithm to obtain more fractionation data, and calculates the exponent data of each fractionation data after splitting.Method proposed by the present invention simplifies the process of account data craft logging data, can split data of holding position automatically, it is ensured that the safe and efficient operation of machine account management system effectively reduces error rate.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of account management method, device and computer-readable deposit
Storage media.
Background technique
When transaction Excel account system holds position and trades at calculating one, needs to hold position to this pen and transaction data is torn open
Point, the different types of transaction record under this holds position is matched with this, traditional mode depends on greatly related service person's progress, leads to
The business manual review of mistake holds position record and transaction record is split, and there is following shortcomings: it is large number of due to holding position,
And split that scene is very flexible, and it is huge to be related to related data amount, all observation and split, related service personnel item by item by hand
Workload it is very big, time cost is very high；Hoard situation is all dynamic change daily, needs to register in real time and update by hand,
Manual operation is cumbersome, error rate is high, and registers link and be easy to cause data inaccurate, greatly reduces data and splits and update
Efficiency and accuracy.
Summary of the invention
The present invention provides a kind of account management method, device and computer readable storage medium, main purpose and is letter
Change manual work, promotes working efficiency.
To achieve the above object, the present invention also provides a kind of account management methods, this method comprises:
Computational chart is constructed in account management client, Functional Design is carried out to the computational chart according to preset formula, wherein
The computational chart includes holding position to split computational chart；
Initial data is screened from presetting database, and the initial data filtered out is imported into the computational chart；
Each pen initial data is split according to preset algorithm to obtain more fractionation data, and after calculating fractionation
Each fractionation data exponent data.
Optionally, the step of Functional Design being carried out to the computational chart according to preset formula, comprising:
It is for statistical analysis according to data of the VBA function to the computational chart；
Statistic analysis result is stored in the designated position of the computational chart according to VBA function；
Classified according to data column of the VBA function to the computational chart；
Handle multi-column data column simultaneously according to VBA function.
Optionally, initial data is screened from presetting database, and the initial data filtered out is imported into the computational chart
Step, comprising:
Initial data is screened from presetting database, and the initial data of screening is imported in specified folder；
Obtain the path of the specified folder；
The content of the initial data is written to the computational chart according to the path of the specified folder.
Optionally, initial data is screened from presetting database, and the initial data filtered out is imported into the computational chart
After step, comprising:
Data cleansing and arrangement rule are set, using VBA function according to the data cleansing and arrangement rule to the meter
The initial data for calculating table carries out data cleansing and arranges.
Optionally, the data cleansing includes: with arrangement rule
Data summarization is carried out to the initial data of the computational chart；
Lacuna mark is carried out to the initial data of the computational chart；
Similar terms merging is carried out to the initial data of the computational chart.
Optionally, each pen initial data is split according to preset algorithm to obtain more fractionation data, and is counted
The step of calculating the exponent data of each fractionation data after splitting, comprising:
Macro recording is carried out to the preset algorithm in the computational chart；
Fractionation calculating is carried out according to the macro cell to the computational chart recorded, obtains the finger of each fractionation data
Number data.
Optionally, the preset algorithm includes:
Splitting condition is set, judges whether the initial data meets the splitting condition；
If meeting the splitting condition, the initial data is split according to strategy is split, in multiple fractionation plans
The initial data is split as more fractionation data under slightly.
Optionally, the fractionation strategy includes type of transaction, and the type of transaction includes buying in type and selling type.
In addition, to achieve the above object, the present invention also provides a kind of account managing device, which includes memory and place
Device is managed, is stored with the account management program that can be run on the processor, the account management program quilt in the memory
The step of above method is realized when the processor executes.
In addition, to achieve the above object, it is described computer-readable the present invention also provides a kind of computer readable storage medium
Account management program is stored on storage medium, described program can be executed by one or more processor, to realize institute as above
The step of method stated.
Account management method, device and computer readable storage medium proposed by the present invention, can be by automatically from data
Library imports to hold position and data and split automatically to data of holding position, and simplifies manual typing and splits the process for data of holding position, really
The safe and efficient operation of machine account management system is protected, error rate is effectively reduced.
Detailed description of the invention
Fig. 1 is the flow diagram for the account management method that one embodiment of the invention provides；
Fig. 2 is the schematic diagram of internal structure for the account managing device that one embodiment of the invention provides；
The module diagram of program in the account managing device that Fig. 3 provides for one embodiment of the invention.
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific embodiment
It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not intended to limit the present invention.
The present invention provides a kind of account management method.It is the account management that one embodiment of the invention provides shown in referring to Fig.1
The flow diagram of method.This method can be executed by a device, which can be by software and or hardware realization.
In the present embodiment, account management method includes:
Step S10 constructs computational chart in account management client, carries out function to the computational chart according to preset formula and set
Meter.
To make model that there is versatility, account intelligence, modern management, the calculating based on Excel are preferably served
Function establishes computation sheet and relative program.The embodiment of the present invention is using the formula function of Excel in account management client structure
Build one for splits sheet the page of data of holding position-holding position splits computational chart, more easily progress data management and analyze.
Preferably, as needed, described hold position can also be split computational chart and replaced with by other of the invention preferred embodiments
Other computational charts, such as swap index computational chart, hold position computational chart or swap interest rate computational chart.Below the present invention only with
It is illustrated for building computational chart.In the step of account management client constructs computational chart, specifically include:
Define the corresponding field attribute of each cell in computational chart；
Data organization is carried out in the cell of computational chart；
Define the calculation formula between computational chart cell.
By defining the corresponding field attribute of each cell, number of holding position in transaction account database can be directly transferred
According to；Data organization is directly carried out in the cell of computational chart, the data worked out are newly-increased data information, it can be ensured that transaction
Established sheet pages when account data library relevant information updates-holding position splits related data in computational chart and can also carry out reality
Shi Gengxin；Calculation formula between cell includes the operation held position between data, and operation result also will be as income of holding position
Data supporting.The step effectively prevents a large amount of duplication paste operation by hand and the operation of data Format adjusting, greatly reduces
The workload of operator, while data inputting mistake caused by avoiding because of operator's fatigue, situations such as omission, occur, have
The accuracy for improving data of effect.
After sheet page of building-holds position and splits computational chart, need by Excel progress Functional Design to realize its function.
Specifically, due to realizing that the classification fractionation that hold position calculates that there are many duplicate under the sequence for not changing data record of holding position
Complicated operation, therefore then need that following functions can be fast implemented in Excel, i.e., corresponding Functional Design includes:
It is for statistical analysis according to data of the VBA function to the computational chart；
Statistic analysis result is stored in the designated position of the computational chart according to VBA function；
Classified according to data column of the VBA function to the computational chart；
Handle multi-column data column simultaneously according to VBA function.
In addition, improving the safety of system data, and guarantee that all users extract data phase of holding position to prevent maloperation
Close the consistency of data format, it is necessary to protect to Excel cell formats and formula.The step effectively prevents largely
Format adjusting operation, greatly reduce the workload of operator, at the same avoid because operator fatigue caused by data
Situations such as typing mistake, omission, occurs.
Step S20 screens initial data, such as original data of holding position, and the data of holding position that will be filtered out from presetting database
Import the computational chart；
The presetting database of the present embodiment is transaction account database.The data of holding position include bond transaction data and/
Or buy-back deal data and/or swap transaction data.
Step S20 further include:
Original data of holding position are screened from presetting database, and the data of holding position of screening are imported in specified folder；
Obtain the path of the specified folder；
The content for data of holding position is written to the computational chart according to the path of the specified folder.
All are held position after being automatically imported the data of holding position gathered using VBA is macro as present pre-ferred embodiments
Data are put under a file.Established sheet pages-hold position split computational chart worksheet the first row input rower
Topic, the row headers are bought in, sell including at least bond, MTM, MTM change, face amount cost currency exchange, investment return, swap
One kind that information, one's own reserves investment amount, the outer finance costs of repurchase and profit are taken in, and it is inserted into button in row headers, in button
Place's insertion is for collecting the VBA macrodoce for data of holding position.In the case where enabling macrodoce, click button can execute macro generation
Code, all data of holding position can be imported into sheet pages-holding position splits in computational chart.
First by obtaining the filename comprising fullpath of original exponents data file, and it is assigned to variable；Then
Content in data file of holding position is written since the second row first cell of target operation table.It is achieved in whole
Data of holding position imported into odd-job table, remaining Format adjusting can according to need using record macro method generate generation
Code, then modifies to code reusable to achieve the purpose that.
The step simplifies screening by hand and imports data procedures, dramatically reduces the burden of technical staff, and reduce
The probability that human factor mistake occurs, embodies modernization, intelligent information technology in account management work well
Practicability.
After step S20, present pre-ferred embodiments further include:
Data cleansing and arrangement rule are set, using VBA function according to the data cleansing and arrangement rule to the meter
The data of holding position of calculation table carry out data cleansing and arrange.
The cleaning of the partial data mainly includes carrying out data summarization, computational chart to the data of holding position in computational chart with arrangement
Hold position data carry out lacuna mark, to computational chart hold position data carry out similar terms merge three parts.
The step of summarizing to data of holding position specifically includes that
(1) definition procedure variable, initialization；
(2) judge whether the document format of computational chart belongs to default processing format, if being judged as YES, exit data cleansing
Step executes following operation if being judged as NO:
(3) redundancy ranks in computational chart are deleted；
(4) by alternative that the symbol in computational chart is unified, such as " X " is unified for " * " etc.；
(5) computational chart data are ranked up according to key field, for example, according to words such as keywords " price " " time "
Section is ranked up；
Sequencer procedure used VBA from tape function, str1 and str2 are respectively cell where both keyword data
Range, str3 is the range of cells that be ranked up processing,
(6) merge similar terms；
Similar terms only need to stay data line after merging, remaining row needs to delete, and according to Excel characteristic, this work need to be from last
Row inverted order carries out.
(7) document after summarizing is saved.
The step of carrying out report lacuna mark to data of holding position specifically includes that
(1) definition procedure variable, initialization；
(2) judge whether this document format meets the processing format of this module, displayed the prompt box if not meeting, and exit
Program；
(3) line number that data of holding position described in judgement occupy in computational chart；
(4) column data where the serial number of computational chart is emptied, serial number mark is re-started according to process；
(5) by cell span where the serial number, and retain serial number numerical value in cell after merging；
(6) it is " normal " that matched data remarks of holding position, which will be completed, and not matched data remarks are " lacuna "；
(7) document after saving lacuna mark.
This module needs to generate new statement form, is mainly the place of cell formats involved in code realization process
Reason.
The step of carrying out similar terms merging to data of holding position specifically includes that
This functions of modules predominantly sorts and merges similar terms, and the keyword of sort by has one or two, and its
The position at place is indefinite, it is therefore desirable to introduce combobox selection.
(1) definition procedure variable, initialization.
(2) keyword is selected.
(3) it is handled in two kinds of situation according to the number of selection keyword.
(4) it after selecting keyword, is ranked up according to keyword；Symbol in data is unified, such as " X " is unified for
" * " etc. merges similar terms.
(5) document is saved.
The step of above data cleaning and arrangement, is cleared up and has been corrected to data of holding position comprehensively, and importing is effectively increased
The accuracy for data of holding position.
Step S30, according to preset algorithm, such as holding position splits algorithm each pen data of holding position is split to obtain more and held
Storehouse data, and calculate each pen after splitting and hold position the exponent datas of data, income of such as holding position.
Further, the step S30 can also include splitting the macro record of algorithm progress to holding position in the computational chart
System；
Fractionation calculating is carried out according to the macro cell to the computational chart recorded, each pen is obtained and holds position the holding of data
Storehouse income.
Described hold position splits algorithm and includes:
Splitting condition of holding position is set, whether data of holding position described in judgement meet splitting condition；
If meeting splitting condition, the data of holding position are split according to strategy is split, it is multiple to split holding under strategy
Storehouse data are split as more data of holding position.
The fractionation strategy includes type of transaction, and the type of transaction includes buying in type and selling type.
Specifically, a bond or repurchase or swap buy in the case where selling, hold position split algorithm can be according to each
Pen, which is bought in, sells the income of holding position that artificial situation dynamic calculates each.Such as 10,000,000 are issued in timing node and buys in debt
Certificate, another timing node later issue 2,000,000 bond of selling, just need this when to hold position 10,000,000 transaction
2,000,000 and 8,000,000 two transaction of holding position are split into, and calculate separately 2,000,000 and 8,000,000 incomes held position.In this primitive rule
Lower fractionation scene is enough to cover all business scenarios, will so that hold position calculate work more automate, easy, effectively increase
Efficiency is split, statistical error is reduced, there is good practical value.
It splits algorithm to holding position using macro record and records, so that macro VBA code can be calculated with automatic cycle, reach
Gradually tentative calculation approach to obtain every data of holding position hold position income final result purpose.
Using VBA code hold position fractionation calculate when, recall the CodeWindow of VBA first.Concrete operations are as follows: selection
[visual basic] under [developing instrument] tabs recalls [the microsoft visual basic of dependent work worksheet
For application] window, select [view]/[engineering resource manager], [CodeWindow], recalled VBA code volume
Collect the window (engineering -- VBAProject) of window and engineering resource manager.
To hold position split calculation formula carry out record macro include:
" view "-" macro "-" record macro " in Excel menu is selected, starts to carry out accordingly after executing " determination " function
" stopping recording " is clicked in goal seek operation after recording.
If any the formula of update, more new formula can be edited using macro editor, using Excel VBA to macro
VBA code carries out editor
By " view "-" macro "-" checking macro "-" editor " in Excel menu after macro recording, into the editor of VBA
The macrodoce recorded is edited at interface.
The characteristics of Excel itself plus the powerful function of VBA make it be used to hold position data management and analysis it is especially square
Just.Cell can merge, split in Excel, have modification property well.It is gone to complete a large amount of hand with the program that VBA writes
Work operation, saves the time, and ensure that the accurate of operation.Click [Microsoft below [engineering -- VBAProject]
Excel object] under we to calculate the worksheet where data, be the worksheet of entitled [sheet1] in this example, then point
Dropdown arrow in the CodeWindow object box of right side is hit, attentional selection [worksheet] will be recalled automatically in right frame
【selectionchange】。
Present pre-ferred embodiments, which will specify to hold position, splits the cell of calculated result, as long as selecting corresponding region, knot
Fruit will automatically compute and be placed in corresponding position.
The step is more intuitive easy using excel built-in function, and the speed of service also faster, while passing through Excel work
The input that transaction can be effectively ensured in table defencive function is normative.The macro standard that can not only guarantee transaction initial data of establishment VBA
True property can also improve data importing and computational efficiency.
This design method has stronger practicability, and easy to operate, when hoard situation changes, as long as opening table
Lattice can be automatically imported correlation and hold position data, and automatically data of holding position are split and calculated with the income of holding position after splitting.It is logical
The automatic method is crossed, execution task and workflow can be made to become faster, is more efficient, have higher workload, effectively
The turnaround time is reduced, the lean of information flow is advantageously implemented.
The method that the embodiment provides simplifies manual Input Process, can be real-time by the truth for data of holding position, high
It imitates ground typing and is updated to machine account management system, it is ensured that the safe and efficient operation of system effectively reduces error rate.
The present invention also provides a kind of account managing devices.It is the account pipe that one embodiment of the invention provides referring to shown in Fig. 2
Manage the schematic diagram of internal structure of device.
In the present embodiment, device 1 can be PC (Personal Computer, PC), be also possible to intelligent hand
The terminal devices such as machine, tablet computer, portable computer.The account managing device 1 includes at least memory 11, processor 12, leads to
Believe bus 13 and network interface 14.
Wherein, memory 11 include at least a type of readable storage medium storing program for executing, the readable storage medium storing program for executing include flash memory,
Hard disk, multimedia card, card-type memory (for example, SD or DX memory etc.), magnetic storage, disk, CD etc..Memory 11
It can be the internal storage unit of account managing device 1, such as the hard disk of the account managing device 1 in some embodiments.It deposits
Reservoir 11 is also possible in further embodiments on the External memory equipment of account managing device 1, such as account managing device 1
The plug-in type hard disk of outfit, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD)
Card, flash card (Flash Card) etc..Further, memory 11 can also both include the storage inside of account managing device 1
Unit also includes External memory equipment.Memory 11 can be not only used for the application software that storage is installed on account managing device 1
And Various types of data, such as the code of account management program 01 etc., it can be also used for temporarily storing and exported or will be defeated
Data out.
Processor 12 can be in some embodiments a central processing unit (Central Processing Unit,
CPU), controller, microcontroller, microprocessor or other data processing chips, the program for being stored in run memory 11
Code or processing data, such as execute account management program 01 etc..
Communication bus 13 is for realizing the connection communication between these components.
Network interface 14 optionally may include standard wireline interface and wireless interface (such as WI-FI interface), be commonly used in
Communication connection is established between the device 1 and other electronic equipments.
Optionally, which can also include user interface, and user interface may include display (Display), input
Unit such as keyboard (Keyboard), optional user interface can also include standard wireline interface and wireless interface.It is optional
Ground, in some embodiments, display can be light-emitting diode display, liquid crystal display, touch-control liquid crystal display and OLED
(Organic Light-Emitting Diode, Organic Light Emitting Diode) touches device etc..Wherein, display can also be appropriate
Referred to as display screen or display unit, for being shown in the information handled in account managing device 1 and for showing visually
User interface.
Fig. 2 illustrates only the account managing device 1 with component 11-14 and account management program 01, art technology
Personnel may include than illustrating more it is understood that structure shown in fig. 1 does not constitute the restriction to account managing device 1
Perhaps more component perhaps combines certain components or different component layouts less.
In 1 embodiment of device shown in Fig. 2, account management program 01 is stored in memory 11；Processor 12 executes
Following steps are realized when the account management program 01 stored in memory 11:
Step S10 constructs computational chart in account management client, carries out function to the computational chart according to preset formula and set
Meter.
To make model that there is versatility, account intelligence, modern management, the calculating based on Excel are preferably served
Function establishes computation sheet and relative program.The embodiment of the present invention is using the formula function of Excel in account management client structure
Build one for splits sheet the page of data of holding position-holding position splits computational chart, more easily progress data management and analyze.
Preferably, as needed, described hold position can also be split computational chart and replaced with by other of the invention preferred embodiments
Other computational charts, such as swap index computational chart, hold position computational chart or swap interest rate computational chart.Below the present invention only with
It is illustrated for building computational chart.In the step of account management client constructs computational chart, specifically include:
Define the corresponding field attribute of each cell in computational chart；
Data organization is carried out in the cell of computational chart；
Define the calculation formula between computational chart cell.
By defining the corresponding field attribute of each cell, number of holding position in transaction account database can be directly transferred
According to；Data organization is directly carried out in the cell of computational chart, the data worked out are newly-increased data information, it can be ensured that transaction
Established sheet pages when account data library relevant information updates-holding position splits related data in computational chart and can also carry out reality
Shi Gengxin；Calculation formula between cell includes the operation held position between data, and operation result also will be as income of holding position
Data supporting.The step effectively prevents a large amount of duplication paste operation by hand and the operation of data Format adjusting, greatly reduces
The workload of operator, while data inputting mistake caused by avoiding because of operator's fatigue, situations such as omission, occur, have
The accuracy for improving data of effect.
After sheet page of building-holds position and splits computational chart, need by Excel progress Functional Design to realize its function.
Specifically, due to realizing that the classification fractionation that hold position calculates that there are many duplicate under the sequence for not changing data record of holding position
Complicated operation, therefore then need that following functions can be fast implemented in Excel, i.e., corresponding Functional Design includes:
It is for statistical analysis according to data of the VBA function to the computational chart；
Statistic analysis result is stored in the designated position of the computational chart according to VBA function；
Classified according to data column of the VBA function to the computational chart；
Handle multi-column data column simultaneously according to VBA function.
In addition, improving the safety of system data, and guarantee that all users extract data phase of holding position to prevent maloperation
Close the consistency of data format, it is necessary to protect to Excel cell formats and formula.The step effectively prevents largely
Format adjusting operation, greatly reduce the workload of operator, at the same avoid because operator fatigue caused by data
Situations such as typing mistake, omission, occurs.
Step S20 screens initial data, such as original data of holding position, and the data of holding position that will be filtered out from presetting database
Import the computational chart；
The presetting database of the present embodiment is transaction account database.The data of holding position include bond transaction data and/
Or buy-back deal data and/or swap transaction data.
Step S20 further include:
Original data of holding position are screened from presetting database, and the data of holding position of screening are imported in specified folder；
Obtain the path of the specified folder；
The content for data of holding position is written to the computational chart according to the path of the specified folder.
All are held position after being automatically imported the data of holding position gathered using VBA is macro as present pre-ferred embodiments
Data are put under a file.Established sheet pages-hold position split computational chart worksheet the first row input rower
Topic, the row headers are bought in, sell including at least bond, MTM, MTM change, face amount cost currency exchange, investment return, swap
One kind that information, one's own reserves investment amount, the outer finance costs of repurchase and profit are taken in, and it is inserted into button in row headers, in button
Place's insertion is for collecting the VBA macrodoce for data of holding position.In the case where enabling macrodoce, click button can execute macro generation
Code, all data of holding position can be imported into sheet pages-holding position splits in computational chart.
First by obtaining the filename comprising fullpath of original exponents data file, and it is assigned to variable；Then
Content in data file of holding position is written since the second row first cell of target operation table.It is achieved in whole
Data of holding position imported into odd-job table, remaining Format adjusting can according to need using record macro method generate generation
Code, then modifies to code reusable to achieve the purpose that.
The step simplifies screening by hand and imports data procedures, dramatically reduces the burden of technical staff, and reduce
The probability that human factor mistake occurs, embodies modernization, intelligent information technology in account management work well
Practicability.
After step S20, present pre-ferred embodiments further include:
Data cleansing and arrangement rule are set, using VBA function according to the data cleansing and arrangement rule to the meter
The data of holding position of calculation table carry out data cleansing and arrange.
The cleaning of the partial data mainly includes carrying out data summarization, computational chart to the data of holding position in computational chart with arrangement
Hold position data carry out lacuna mark, to computational chart hold position data carry out similar terms merge three parts.
The step of summarizing to data of holding position specifically includes that
(1) definition procedure variable, initialization；
(2) judge whether the document format of computational chart belongs to default processing format, if being judged as YES, exit data cleansing
Step executes following operation if being judged as NO:
(3) redundancy ranks in computational chart are deleted；
(4) by alternative that the symbol in computational chart is unified, such as " X " is unified for " * " etc.；
(5) computational chart data are ranked up according to key field, for example, according to words such as keywords " price " " time "
Section is ranked up；
Sequencer procedure used VBA from tape function, str1 and str2 are respectively cell where both keyword data
Range, str3 is the range of cells that be ranked up processing,
(6) merge similar terms；
Similar terms only need to stay data line after merging, remaining row needs to delete, and according to Excel characteristic, this work need to be from last
Row inverted order carries out.
(7) document after summarizing is saved.
The step of carrying out report lacuna mark to data of holding position specifically includes that
(1) definition procedure variable, initialization；
(2) judge whether this document format meets the processing format of this module, displayed the prompt box if not meeting, and exit
Program；
(3) line number that data of holding position described in judgement occupy in computational chart；
(4) column data where the serial number of computational chart is emptied, serial number mark is re-started according to process；
(5) by cell span where the serial number, and retain serial number numerical value in cell after merging；
(6) it is " normal " that matched data remarks of holding position, which will be completed, and not matched data remarks are " lacuna "；
(7) document after saving lacuna mark.
This module needs to generate new statement form, is mainly the place of cell formats involved in code realization process
Reason.
The step of carrying out similar terms merging to data of holding position specifically includes that
This functions of modules predominantly sorts and merges similar terms, and the keyword of sort by has one or two, and its
The position at place is indefinite, it is therefore desirable to introduce combobox selection.
(1) definition procedure variable, initialization.
(2) keyword is selected.
(3) it is handled in two kinds of situation according to the number of selection keyword.
(4) it after selecting keyword, is ranked up according to keyword；Symbol in data is unified, such as " X " is unified for
" * " etc. merges similar terms.
(5) document is saved.
The step of above data cleaning and arrangement, is cleared up and has been corrected to data of holding position comprehensively, and importing is effectively increased
The accuracy for data of holding position.
Step S30 splits algorithm and is split to obtain more data of holding position to each pen data of holding position, and counts according to holding position
It calculates each pen after splitting to hold position the exponent datas of data, income of such as holding position.
Further, the step S30 can also include splitting the macro record of algorithm progress to holding position in the computational chart
System；
Fractionation calculating is carried out according to the macro cell to the computational chart recorded, each pen is obtained and holds position the holding of data
Storehouse income.
Described hold position splits algorithm and includes:
Splitting condition of holding position is set, whether data of holding position described in judgement meet splitting condition；
If meeting splitting condition, the data of holding position are split according to strategy is split, it is multiple to split holding under strategy
Storehouse data are split as more data of holding position.
The fractionation strategy includes type of transaction, and the type of transaction includes buying in type and selling type.
Specifically, a bond or repurchase or swap buy in the case where selling, hold position split algorithm can be according to each
Pen, which is bought in, sells the income of holding position that artificial situation dynamic calculates each.Such as 10,000,000 are issued in timing node and buys in debt
Certificate, another timing node later issue 2,000,000 bond of selling, just need this when to hold position 10,000,000 transaction
2,000,000 and 8,000,000 two transaction of holding position are split into, and calculate separately 2,000,000 and 8,000,000 incomes held position.In this primitive rule
Lower fractionation scene is enough to cover all business scenarios, will so that hold position calculate work more automate, easy, effectively increase
Efficiency is split, statistical error is reduced, there is good practical value.
It splits algorithm to holding position using macro record and records, so that macro VBA code can be calculated with automatic cycle, reach
Gradually tentative calculation approach to obtain every data of holding position hold position income final result purpose.
Using VBA code hold position fractionation calculate when, recall the CodeWindow of VBA first.Concrete operations are as follows: selection
[visual basic] under [developing instrument] tabs recalls [the microsoft visual basic of dependent work worksheet
For application] window, select [view]/[engineering resource manager], [CodeWindow], recalled VBA code volume
Collect the window (engineering -- VBAProject) of window and engineering resource manager.
To hold position split calculation formula carry out record macro include:
" view "-" macro "-" record macro " in Excel menu is selected, starts to carry out accordingly after executing " determination " function
" stopping recording " is clicked in goal seek operation after recording.
If any the formula of update, more new formula can be edited using macro editor, using Excel VBA to macro
VBA code carries out editor
By " view "-" macro "-" checking macro "-" editor " in Excel menu after macro recording, into the editor of VBA
The macrodoce recorded is edited at interface.
The characteristics of Excel itself plus the powerful function of VBA make it be used to hold position data management and analysis it is especially square
Just.Cell can merge, split in Excel, have modification property well.It is gone to complete a large amount of hand with the program that VBA writes
Work operation, saves the time, and ensure that the accurate of operation.Click [Microsoft below [engineering -- VBAProject]
Excel object] under we to calculate the worksheet where data, be the worksheet of entitled [sheet1] in this example, then point
Dropdown arrow in the CodeWindow object box of right side is hit, attentional selection [worksheet] will be recalled automatically in right frame
[selectionchange] (can also click dropdown arrow in right frame and recall selection change).
We, which will specify to hold position, in this example splits the cell of calculated result, as long as selecting corresponding region, as a result will
It automatically computes and is placed in corresponding position.
The step is more intuitive easy using excel built-in function, and the speed of service also faster, while passing through Excel work
The input that transaction can be effectively ensured in table defencive function is normative.The macro standard that can not only guarantee transaction initial data of establishment VBA
True property can also improve data importing and computational efficiency.
This design method has stronger practicability, and easy to operate, when hoard situation changes, as long as opening table
Lattice can be automatically imported correlation and hold position data, and automatically data of holding position are split and calculated with the income of holding position after splitting.It is logical
The automatic method is crossed, execution task and workflow can be made to become faster, is more efficient, have higher workload, effectively
The turnaround time is reduced, the lean of information flow is advantageously implemented.
The method that the embodiment provides simplifies manual Input Process, can be real-time by the truth for data of holding position, high
It imitates ground typing and is updated to machine account management system, it is ensured that the safe and efficient operation of system effectively reduces error rate.
Optionally, in other embodiments, account management program can also be divided into one or more module, and one
Or multiple modules are stored in memory 11, and performed by one or more processors (the present embodiment is processor 12)
To complete the present invention, the so-called module of the present invention is the series of computation machine program instruction section for referring to complete specific function, is used
In implementation procedure of the description account management program in account managing device.
It is the program mould of the account management program in one embodiment of account managing device of the present invention for example, referring to shown in Fig. 3
Block schematic diagram, in the embodiment, account management program can be divided into computational chart building module 10, data screening module of holding position
20, account management module 30 is illustratively:
Computational chart building module 10 is used for: computational chart is constructed in account management client, according to preset formula to the meter
It calculates table and carries out Functional Design；
Data screening module 20 of holding position is used for: being screened original data of holding position from presetting database, and is held position what is filtered out
Data import the computational chart；
Hold position and split computing module 30 and be used for: according to hold position split algorithm to each pen hold position data split to obtain it is more
Pen is held position data, and is calculated each pen after splitting and held position the incomes of holding position of data.
Above-mentioned computational chart, which constructs module 10, data screening module 20 of holding position and holds position, splits the program modules such as computing module 30
It is performed realized functions or operations step to be substantially the same with above-described embodiment, details are not described herein.
In addition, the embodiment of the present invention also proposes a kind of computer readable storage medium, the computer readable storage medium
On be stored with account management program, the account management program can be executed by one or more processors, to realize following operation:
Computational chart is constructed in account management client, Functional Design is carried out to the computational chart according to preset formula；
Original data of holding position are screened from presetting database, and the data of holding position filtered out are imported into the computational chart；
It splits algorithm according to holding position each pen data of holding position is split to obtain more data of holding position, and after calculating fractionation
Each pen hold position the incomes of holding position of data.
Computer readable storage medium specific embodiment of the present invention and above-mentioned account managing device and each embodiment of method
It is essentially identical, do not make tired state herein.
It should be noted that the serial number of the above embodiments of the invention is only for description, do not represent the advantages or disadvantages of the embodiments.And
The terms "include", "comprise" herein or any other variant thereof is intended to cover non-exclusive inclusion, so that packet
Process, device, article or the method for including a series of elements not only include those elements, but also including being not explicitly listed
Other element, or further include for this process, device, article or the intrinsic element of method.Do not limiting more
In the case where, the element that is limited by sentence "including a ...", it is not excluded that including process, device, the article of the element
Or there is also other identical elements in method.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.Based on this understanding, technical solution of the present invention substantially in other words does the prior art
The part contributed out can be embodied in the form of software products, which is stored in one as described above
In storage medium (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that terminal device (it can be mobile phone,
Computer, server or network equipment etc.) execute method described in each embodiment of the present invention.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of account management method, which is characterized in that the described method includes:
Computational chart is constructed in account management client, Functional Design is carried out to the computational chart according to preset formula, wherein described
Computational chart includes holding position to split computational chart；
Initial data is screened from presetting database, and the initial data filtered out is imported in the computational chart；
Each pen initial data is split according to preset algorithm to obtain more fractionation data, and is calculated every after splitting
The exponent data of one fractionation data.
2. account management method according to claim 1, which is characterized in that carried out according to preset formula to the computational chart
The step of Functional Design, comprising:
It is for statistical analysis according to data of the VBA function to the computational chart；
Statistic analysis result is stored in the designated position of the computational chart according to VBA function；
Classified according to data column of the VBA function to the computational chart；
Handle multi-column data column simultaneously according to VBA function.
3. account management method according to claim 2, which is characterized in that initial data is screened from presetting database, and
The step of initial data filtered out is imported into the computational chart, comprising:
Initial data is screened from presetting database, and the initial data of screening is imported in specified folder；
Obtain the path of the specified folder；
The content of the initial data is written to the computational chart according to the path of the specified folder.
4. account management method according to claim 1-3, which is characterized in that screened from presetting database original
Data, and after the step of initial data filtered out is imported the computational chart, further includes:
Data cleansing and arrangement rule are set, using VBA function according to the data cleansing and arrangement rule to the computational chart
Initial data carry out data cleansing and arrange.
5. account management method according to claim 4, which is characterized in that the data cleansing includes: with arrangement rule
Data summarization is carried out to the initial data of the computational chart；
Lacuna mark is carried out to the initial data of the computational chart；
Similar terms merging is carried out to the initial data of the computational chart.
6. account management method according to claim 1-3, which is characterized in that according to preset algorithm to each pen
The initial data is split to obtain more fractionation data, and calculate the exponent data of each fractionation data after splitting
Step, comprising:
Macro recording is carried out to the preset algorithm in the computational chart；
Fractionation calculating is carried out according to the macro cell to the computational chart recorded, obtains the index number of each fractionation data
According to.
7. account management method according to claim 6, which is characterized in that the preset algorithm includes:
Splitting condition is set, judges whether the initial data meets the splitting condition；
If meeting the splitting condition, the initial data is split according to strategy is split, under multiple fractionation strategies
The initial data is split as more fractionation data.
8. account management method according to claim 7, which is characterized in that the fractionation strategy includes type of transaction, institute
Stating type of transaction includes buying in type and selling type.
9. a kind of account managing device, which is characterized in that described device includes memory and processor, is stored on the memory
There is the account management program that can be run on the processor, power is realized when the account management program is executed by the processor
Benefit requires the step of 1 to 8 described in any item methods.
10. a kind of computer readable storage medium, which is characterized in that be stored with account pipe on the computer readable storage medium
Program is managed, described program can be executed by one or more processor, to realize side as claimed in any one of claims 1 to 8
The step of method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910598348.8A CN110414926A (en) | 2019-07-03 | 2019-07-03 | Account management method, device and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910598348.8A CN110414926A (en) | 2019-07-03 | 2019-07-03 | Account management method, device and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110414926A true CN110414926A (en) | 2019-11-05 |
Family
ID=68360225
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910598348.8A Pending CN110414926A (en) | 2019-07-03 | 2019-07-03 | Account management method, device and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110414926A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111325017A (en) * | 2019-11-25 | 2020-06-23 | 国网福建省电力有限公司晋江市供电公司 | Method and device for screening equipment name ledger in distribution network |
| CN111507077A (en) * | 2020-03-17 | 2020-08-07 | 唐山钢铁集团高强汽车板有限公司 | Method for automatically generating production records of galvanized outlet |
| CN111651968A (en) * | 2020-04-29 | 2020-09-11 | 天津钢铁集团有限公司 | Automatic EXCEL report generation method and system and information data processing terminal |
| CN113362171A (en) * | 2021-05-28 | 2021-09-07 | 富途网络科技(深圳)有限公司 | Data processing method, device and storage medium |
| CN114564622A (en) * | 2022-03-03 | 2022-05-31 | 苏州良医汇网络科技有限公司 | Method, device and equipment for TNM (trinitrotoluene) staging table entry system |
| CN119066084A (en) * | 2024-11-07 | 2024-12-03 | 天津金城银行股份有限公司 | A data calculation method, system, intelligent terminal and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109658215A (en) * | 2018-12-10 | 2019-04-19 | 平安科技（深圳）有限公司 | Transaction account calculation method, device and computer readable storage medium |
| CN109669933A (en) * | 2018-12-10 | 2019-04-23 | 平安科技（深圳）有限公司 | Transaction data intelligent processing method, device and computer readable storage medium |
-
2019
- 2019-07-03 CN CN201910598348.8A patent/CN110414926A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109658215A (en) * | 2018-12-10 | 2019-04-19 | 平安科技（深圳）有限公司 | Transaction account calculation method, device and computer readable storage medium |
| CN109669933A (en) * | 2018-12-10 | 2019-04-23 | 平安科技（深圳）有限公司 | Transaction data intelligent processing method, device and computer readable storage medium |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111325017A (en) * | 2019-11-25 | 2020-06-23 | 国网福建省电力有限公司晋江市供电公司 | Method and device for screening equipment name ledger in distribution network |
| CN111325017B (en) * | 2019-11-25 | 2023-03-28 | 国网福建省电力有限公司晋江市供电公司 | Power distribution network equipment name standing book screening method and device |
| CN111507077A (en) * | 2020-03-17 | 2020-08-07 | 唐山钢铁集团高强汽车板有限公司 | Method for automatically generating production records of galvanized outlet |
| CN111651968A (en) * | 2020-04-29 | 2020-09-11 | 天津钢铁集团有限公司 | Automatic EXCEL report generation method and system and information data processing terminal |
| CN113362171A (en) * | 2021-05-28 | 2021-09-07 | 富途网络科技(深圳)有限公司 | Data processing method, device and storage medium |
| CN114564622A (en) * | 2022-03-03 | 2022-05-31 | 苏州良医汇网络科技有限公司 | Method, device and equipment for TNM (trinitrotoluene) staging table entry system |
| CN119066084A (en) * | 2024-11-07 | 2024-12-03 | 天津金城银行股份有限公司 | A data calculation method, system, intelligent terminal and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP7486250B2 (en) | Domain-specific language interpreter and interactive visual interface for rapid screening | |
| CN110414926A (en) | Account management method, device and computer readable storage medium | |
| CN106796578B (en) | Knowledge automation system and method and memory | |
| CN113342976B (en) | Method, device, storage medium and equipment for automatically acquiring and processing data | |
| US8340995B2 (en) | Method and system of using artifacts to identify elements of a component business model | |
| CN102426582B (en) | Data manipulation management devices and data manipulation management method | |
| CN109658215A (en) | Transaction account calculation method, device and computer readable storage medium | |
| CN107644286A (en) | Workflow processing method and device | |
| CN109669933A (en) | Transaction data intelligent processing method, device and computer readable storage medium | |
| CN114004542B (en) | Enterprise task management method, system, computer equipment and storage medium | |
| CN110457333A (en) | Data real time updating method, device and computer readable storage medium | |
| WO2024125673A2 (en) | Data processing and visualization method, apparatus, medium and device | |
| WO2021240370A1 (en) | Domain-specific language interpreter and interactive visual interface for rapid screening | |
| CN113312410B (en) | Data map construction method, data query method and terminal equipment | |
| CN108875048A (en) | Report form generation method, device, electronic equipment and readable storage medium storing program for executing | |
| US20140149186A1 (en) | Method and system of using artifacts to identify elements of a component business model | |
| TW201519071A (en) | Technical documents capturing and patents analysis system and method | |
| US7167873B2 (en) | Visual-modeling technique for use in implementing a database system | |
| CN119669203A (en) | Multimodal data management system, method, device and medium | |
| US20100145748A1 (en) | Information technology planning based on enterprise architecture | |
| CN114722789B (en) | Data report integrating method, device, electronic equipment and storage medium | |
| Dunlop | Beginning Big Data with Power BI and Excel 2013: Big Data Processing and Analysis Using PowerBI in Excel 2013 | |
| CN116860311A (en) | Script analysis method, script analysis device, computer equipment and storage medium | |
| CN116228402A (en) | A Technical Support System for Financial Credit Information Feature Warehouse | |
| CN111061778B (en) | Data analysis method, system and electronic equipment |
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: 20191105 |