CN114707475B - Month repair kilometer number monitoring and regulation daily report generating system - Google Patents
Month repair kilometer number monitoring and regulation daily report generating system Download PDFInfo
- Publication number
- CN114707475B CN114707475B CN202210195110.2A CN202210195110A CN114707475B CN 114707475 B CN114707475 B CN 114707475B CN 202210195110 A CN202210195110 A CN 202210195110A CN 114707475 B CN114707475 B CN 114707475B
- Authority
- CN
- China
- Prior art keywords
- train
- data
- information
- daily
- database
- 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.)
- Active
Links
- 230000008439 repair process Effects 0.000 title claims abstract description 89
- 238000012544 monitoring process Methods 0.000 title claims abstract description 43
- 230000001105 regulatory effect Effects 0.000 claims abstract description 20
- 230000001276 controlling effect Effects 0.000 claims abstract description 14
- 230000006870 function Effects 0.000 claims description 54
- 238000004519 manufacturing process Methods 0.000 claims description 41
- 238000012423 maintenance Methods 0.000 claims description 38
- 238000004364 calculation method Methods 0.000 claims description 18
- 230000008676 import Effects 0.000 claims description 9
- 238000004422 calculation algorithm Methods 0.000 claims description 8
- 230000010354 integration Effects 0.000 claims description 7
- 230000008859 change Effects 0.000 claims description 6
- 230000003993 interaction Effects 0.000 claims description 6
- 238000013523 data management Methods 0.000 claims description 4
- 238000000034 method Methods 0.000 abstract description 12
- 238000004891 communication Methods 0.000 abstract description 5
- 238000005516 engineering process Methods 0.000 abstract description 3
- 230000002354 daily effect Effects 0.000 description 75
- 238000007726 management method Methods 0.000 description 20
- 238000004458 analytical method Methods 0.000 description 5
- 238000013461 design Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 4
- 238000011160 research Methods 0.000 description 4
- 238000011217 control strategy Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000009826 distribution Methods 0.000 description 3
- 239000011159 matrix material Substances 0.000 description 3
- 238000013439 planning Methods 0.000 description 3
- 230000007547 defect Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000003203 everyday effect Effects 0.000 description 2
- 230000002452 interceptive effect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 238000005406 washing Methods 0.000 description 2
- PEDCQBHIVMGVHV-UHFFFAOYSA-N Glycerine Chemical compound OCC(O)CO PEDCQBHIVMGVHV-UHFFFAOYSA-N 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000000903 blocking effect Effects 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000012937 correction Methods 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000012821 model calculation Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 238000012549 training Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2474—Sequence data queries, e.g. querying versioned data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Probability & Statistics with Applications (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Fuzzy Systems (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Train Traffic Observation, Control, And Security (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a daily report generation system for monitoring and regulating the number of kilometers of monthly repair, which comprises a daily train information importing module, a daily train report exporting module, a manual changing module and a background monitoring module; the date-imported train information module is used for realizing a date data information grabbing function, a function of distributing the kilometers of the current train according to the table number, and a function of adding data into a database and reading the last effective data of the database. The invention greatly reduces the error rate and the operation intensity of the regulation staff caused by the traditional operation method and less mutual communication, plays a positive role in improving the management efficiency of the train and reducing the operation cost, and can meet the requirement of a maintenance center for regulating and controlling the daily schedule operation. Through modern information technology, various data are regulated and controlled to be convenient to manage and store, statistics and backtracking of information are realized, and the operation management level of a metro vehicle section is improved.
Description
Technical Field
The invention relates to the technical field of subway vehicle management, in particular to a daily statement generation system for monitoring and regulating the number of kilometers of a month.
Background
With the rapid development of the economic level of China, the urban level is continuously improved, the urban population is rapidly increased, the problem of traffic jam is a link which is faced in the urban development process, and the subway becomes a middle stream column of public transportation by the characteristics of relatively small occupied area, high safety, large carrying capacity, high speed and the like, so that the urban traffic pressure relieving effect is very obvious.
The subway signal system consists of a main line signal system and a vehicle section signal system according to the region, and the main line of the subway is matched with a relatively advanced mobile blocking signal system. The main line basically realizes full-automatic intelligent operation, but compared with the main line, the maintenance, the service and the material allocation managed by the operation company in the vehicle section have their own roles, and the maintenance, the control, the service operation and the information transfer between signal buildings can only exchange information in the modes of interviews, telephones, faxes and the like. The computer interlocking system and the ATS subsystem are matched in the section generally, but no independent system such as vehicle maintenance, vehicle management and the like is matched for the vehicle section. The systems are relatively independent, the information in the segments is not comprehensively managed, and in general, the vehicle segment information management level and the automation degree in the current stage are low.
The subway overhaul center vehicle section and the parking lot are an important component part of subway operation, and the main purpose of the subway overhaul center vehicle section and the parking lot is to complete tasks of parking, overhaul, maintenance, cleaning and the like of vehicles, and overhaul center regulation in the vehicle section is responsible for dispatching trains on the next day and maintenance and allocation of each group of trains. The vehicle section scheduling management mode of subway operation management at present carries out information transfer through traditional communication mode, and equipment is intensive in vehicle section, overhauls and regulates a lot of internal doors of office areas, still receives a large amount of external personnel, lacks a comprehensive information management system to overhauling and regulating work.
The current regulation and control operation method is that most traditional forms are filled manually, paper documents are filled or telephone communication and exchange are carried out, information interaction is carried out on a handover office by each regulation and control shift personnel, information among the regulation and control personnel cannot be shared in real time, and unified regulation and control regulations are not available, and each regulation and control is carried out by means of personal experience, so that the operation efficiency of train distribution is greatly influenced. The maintenance regulation personnel have the defects of insufficient real-time control of vehicle information, low daily statement establishment efficiency, no unified standard for appointed maintenance plans, numerous people receiving the service on weekdays and larger comprehensive information quantity needing to be controlled, so that the working pressure is higher and the error rate is high. The information exchange way of the regulating staff is manual modes such as writing, interview, telephone, radio station and the like, the data recording is completely dependent on manual input, the accuracy is low, and the labor intensity is high.
Aiming at the problems, the work efficiency of regulation and control is scientifically improved, the comprehensive management of the regulation and control information is realized, and the technical problem to be solved urgently is solved.
Disclosure of Invention
Aiming at the technical problems in the related art, the invention provides a daily report generation system for monitoring and controlling the number of kilometers per month, which can overcome the defects in the prior art.
In order to achieve the technical purpose, the technical scheme of the invention is realized as follows:
the month repair kilometer number monitoring and regulation daily report generating system comprises a daily train information importing module, a daily train report exporting module, a manual changing module and a background monitoring module;
The date-guiding train information module is used for realizing a date data information grabbing function, a function of distributing the running kilometers of the current date train according to the table number, and a function of adding data into a database and reading last valid data of the database; the system comprises a system main interface, an import day train information module, a data management module and a data management module, wherein the import day train information module is used for updating data provided on the system main interface and displaying the vehicle running condition of the current day and related data at the corresponding position of the main interface;
The daily train report deriving module is used for acquiring a monthly production plan function, a daily report generating function and a train running record storing function; the month production plan acquiring function is used for automatically searching a month production plan in the regulation computer according to the path, reading useful information in the production plan, acquiring a corresponding kilometer number value in a daily report after the target month repair time is different from the current time, and providing the time for entering the month repair for the daily report; the daily statement generating function is used for filling the acquired parameters into a daily statement template and obtaining the month-in and month-out kilometer repair parameters and the recommended schedule opinion of each group of trains according to the corresponding algorithm and production requirements; the train running record storing function is used for displaying the data checked by maintenance regulation and control and respectively filling the data information of each group of current trains into the mileage data and the train running data within seven days of train running;
The manual change module is used for placing information to be changed under a specified path file or directly inputting a place to import the information into a database through a database language according to a human-computer interaction interface;
the background monitoring module is used for inputting data into the database, recording the current system date and the output numerical value and storing the current system date and the output numerical value into an independent file for a manager to check and find the deviation.
Further, the current day data information grabbing function is used for grabbing regulation and control schedule data according to a specified path and storing the grabbed useful information in a local file.
Further, the current day data information grabbing function adopts a working mode of combining manual operation and computer operation.
And further, the function of distributing the running kilometers of the trains on the same day according to the train number is used for reading the data information of the kilometer information database corresponding to the train number of the train number, and the data information of each train on the same day is displayed on a main interface of the system through traversal.
And further, the function of adding data into the database and reading the last effective data of the database is used for filling the kilometers of the current driving information into the auxiliary record database of the train month repair kilometers, carrying out integration calculation in the database according to the field setting of the database, and returning the value of the corresponding requirement obtained after the integration calculation to the main interface.
Further characterized in that said parameters in said daily report generation function comprise parameters obtained from a database or a scheduling plan and fixed parameters given by the production scheduling room.
The invention has the beneficial effects that: the system for monitoring and regulating the number of the kilometers of the train repair and generating the daily statement can accelerate the construction of the digital subway, greatly reduce the error rate and the operation intensity of regulating staff caused by the tradition of the operation method and less mutual communication, play a positive role in improving the management efficiency of the train and reducing the operation cost, and can meet the requirement of a maintenance center for regulating the daily schedule operation. Through modern information technology, various data are regulated and controlled to be convenient to manage and store, statistics and backtracking of information are realized, and the operation management level of a metro vehicle section is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are needed in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a functional block diagram of a month repair kilometer number monitoring and regulation daily report generation system according to an embodiment of the invention;
FIG. 2 is a flowchart of an import train information module of a month repair kilometer monitoring and control daily report generation system according to an embodiment of the present invention;
FIG. 3 is a flowchart of an alternate closed-loop operation for data updating of a month repair kilometer number monitoring and control daily report generation system according to an embodiment of the invention;
FIG. 4 is a daily report generation flow chart of a daily report generation system for monitoring and controlling the number of kilometers per month according to an embodiment of the invention;
FIG. 5 is a flowchart of the manual operation modification data information of the month repair kilometer number monitoring and control daily report generation system according to the embodiment of the invention;
FIG. 6 is a flowchart of a kilometer-number background monitoring module for a system for monitoring and controlling daily report forms according to an embodiment of the present invention;
FIG. 7 is a system basic functional implementation of a month repair kilometer number monitoring and control daily report generation system according to an embodiment of the present invention;
FIG. 8 is a diagram of the data table structure of a system for monitoring and controlling daily report generation for the number of kilometers per month according to an embodiment of the invention;
Fig. 9 is a graph of the deviation of the number of kilometers travelled over seven days from the planned kilometers for a month repair kilometer monitoring and controlling daily report generating system according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which are derived by a person skilled in the art based on the embodiments of the invention, fall within the scope of protection of the invention.
The system has the main function of rapidly displaying the data required by regulation and control in the task allocation operation at the first time, so that a good production design is needed, and the aim of completing the operation is fulfilled by fewer operations as much as possible due to the fact that the training cost of operators is low. The basic functions of the system are shown in fig. 7. The number of mileage on the same day, total mileage, and mileage from month to month is the most basic and important information, and the control is performed in accordance with these data, and these data may be used repeatedly in normal operation. The control of the lunar repair data is a hard operation index for regulating and controlling operation, and if the lunar repair operation is carried out within the range which does not meet the requirement of the lunar repair kilometers, the lunar repair data is calculated as a production accident. The daily report is the most visual comprehensive information display icon required by maintenance operators and maintenance traffic class meeting, and is the best transmission medium for conveying the information of the maintenance operation on the same day.
The functional module classification of the system is shown in fig. 1. The system can be divided into three main parts and an auxiliary part according to the demand analysis, wherein the main parts comprise a daily train information importing module, a daily report generating module and a train kilometer number manually updating or changing module, and the auxiliary part is a mileage background monitoring module. The function of importing the daily train information module is mainly to update the data provided on the main interface of the system and display the running condition of the vehicle on the same day and related data on the corresponding position of the main interface; the main functions of the daily report module are to export information and generate daily reports required by the maintenance work of the same day; the manual updating or changing train mileage module is used for searching files according to a fixed path through personnel operation or a system so as to correct and change the files in the database, and mainly acts on the correction function after data deviation occurs; the mileage background monitoring module is a functional module which is supplemented after problems occur in the test operation stage, and the function of the mileage background monitoring module is mainly used for recording the record of filling values when personnel fill or change database information, so that writing errors caused by the fact that personnel input data are prevented.
1. Description of Module functionality
First, the information module design specification of the train is imported
The daily train information module is imported, is a functional module which does not need excessive man-machine interaction, and aims to simply enable maintenance and control one-key operation to be capable of seeing information on a main interface.
(1) Data information grabbing function of the day
The main function of the module is to grasp the schedule data which is regulated and controlled to be filled manually according to a specified path, grasp useful information from the regulated and controlled document which is filled and temporarily store the useful information into a local file, and because ideal operation is to judge and distribute the running schedule number completely by a computer in a self-service mode, the personnel interference is excessive at the present stage, the computer is operated in an auxiliary working mode with the personnel operation as a main mode, and the grasped useful information is stored in a local public array file for continuous use of the following operation.
(2) Distributing the kilometers of train running on the same day according to the table number
Reading data information of a train number table number corresponding to kilometer information database, matching the database corresponding information into the array information of the last step, and filling the table number of each train on the same day and the corresponding kilometer number into a main display interface of the system through traversal for overhauling, regulating, watching and confirming.
(3) Function of adding data into database and reading last valid data of database
Filling kilometers of the current driving information into a train month repair kilometer auxiliary record database, carrying out integration calculation in the database according to field setting of the database, and returning the value of the corresponding requirement obtained after the integration calculation to a main interface. The flow chart of this module is generally shown in fig. 2.
(II) exporting information and generating daily report module information description
The purpose of deriving information is to store the data and generate daily report form required daily after checking the information displayed on the main interface by overhauling, controlling and looking up, and the data is imported from the database from the previous day and integrated with the new parameters to generate new today's data, and the new data is returned to the database for use by the open day, so that a closed-loop operation flow with alternate data updating can be travelled, as shown in fig. 3.
(1) Acquiring month production plan function
The function of the module is more preferable to the importing function, and the main realization function is to automatically find a month production plan in a regulation computer according to the path, read useful information in the production plan, such as information of entering and exiting month repair arrangement, and the like, make a difference between the target month repair proceeding time and the current time, acquire a corresponding kilometer number value in a daily report, and provide the time for entering the month repair for the daily report.
(2) Daily report generating function
The operation and acquired parameters before integration are respectively filled in the corresponding positions of the daily report according to the daily report template, most of the parameters in the daily report are acquired from a database or a schedule and added to the appointed positions, and the parameters also comprise fixed parameters given by a production scheduling room.
(3) Preserving train travel record function
If the maintenance regulation clicks the daily report generation button, the data displayed on the main interface is the result that the maintenance regulation is audited and has no objection, and when the operation button is clicked, the system can automatically fill the data information of each group of trains into the mileage data and the train running data within seven days, the data information is used for the secondary check of the maintenance regulation, the expression situation is used, and the data information is reserved as the schedule record and the train kilometer total statistics.
(III) manually updating or changing train mileage module information description
According to the actual situation, the actual mileage of each group of trains cannot be accumulated with the numerical value obtained by accumulating kilometers corresponding to the table numbers actually given according to the production schedule numbers, deviation always occurs, and the deviation is generated in other non-operation lines and has no accurate numerical value, so that in order to obtain more accurate mileage of the trains, maintenance staff is required to regularly go to read the mileage of the trains and report the mileage to maintenance regulation, and the most accurate data is filled in a database by the maintenance regulation.
When the train is subjected to the monthly repair, the monthly repair staff can report the monthly repair mileage of the train during the monthly repair to the overhaul regulation and control, so that the regulation and control can accurately enter the monthly repair next time the train is subjected to the monthly repair. Considering that there are many situations that need to manually add information, the special module can change the information of the train database immediately, because the operation of the database is difficult, and the module is not suitable for maintenance and control with lower computer level, the function of the module is to put the information to be changed under a specified path file or directly input the place to import the information into the database through the database language according to a man-machine interaction interface, and because the operations can replace the previous data information, the operation can be performed again before the operations, the interactive popup window for secondary confirmation of maintenance and control is also provided, the situation that the original effective information is replaced because of the false clicking of personnel is prevented, and the operation flow is shown in figure 5.
(IV) description of the mileage background monitoring Module
The function is equivalent to a background supervision function, which is that when the overhaul regulation is manually updated to obtain the monthly repair mileage, the mileage is not found in time due to the filling errors of the mileage caused by the artificial factors, so that the error data participates in calculation in the database and can follow up with the lapse of time, the errors can not influence the monitoring of the monthly repair mileage in a short period, but the errors data can not be quantified under the long-time operation, finally, the causes of the data errors are difficult to find out when the errors occur, the function of the module is that the current system date and the output value are recorded and stored in a separate file while the data are input into the database, the file is checked by a manager, and the time and the error value of the errors are found out by checking the record file, and the flow of the module is shown in fig. 6.
2. Database design
The design of the database is a key ring for the implementation of the information management system. The reasonable database structure not only can improve the storage efficiency of the data, but also can ensure the integrity and consistency of the data.
The data table designed by the system comprises a train number table number corresponding mileage information database, train running mileage data within seven days, train month repair kilometer auxiliary record data and train running data record, wherein the train number table number corresponding mileage information database is a daily travel mileage corresponding to the current running table number given by a company production scheduling room, and can be manually changed according to the change of the mileage corresponding to the actual table number, and the data in the table is an essential parameter for carrying out train kilometer. The mileage data in seven days of train running is the kilometer statistics generated by each group of trains in seven days, the database is used for reference checking according to the 'average kilometer per day' value in the daily report, and the design of the database belongs to parameters which are not required to be acquired by a system for auxiliary viewing of engineering maintenance regulation personnel. The auxiliary record database of the number of kilometers of the lunar repair is mainly used for realizing the function of the system for monitoring the number of kilometers of the lunar repair. The train running data record, that is, the daily running data of each group of trains is a long-term statistical database.
(1) Information database for corresponding kilometers of train number table number
The number of kilometers corresponding to the number of the train number is written into the database by using the number of kilometers corresponding to the number of the train as a main key, and the number of kilometers corresponding to the number of the train can be automatically added into the running data of the train after the train obtains the number of the trip table of the current day each time. The field description is shown in table 3.1.
Table 3.1 number of train number table corresponds to kilometer table information
(2) Data of mileage in seven days of train running
The database is used for observing the record of the mileage generated by each group of trains in the near 7 days in the program, is convenient for observing whether the trains generate excessive deviation in the near one week of running, and can also be combined with 'average kilometers per day' in a daily report to carry out reference calculation. The train number is the primary key, one field per day of the week, one field for the total operating mileage in the near week and the sum of kilometers over the first 7 days, as shown in table 3.3.
Table 3.2 train travel week kilometer number table information
(3) Auxiliary record data for train month repair kilometers
The database is used for in-program auxiliary calculation, the train number is a main key, the daily mileage of each day of the train, the latest train mileage after updating, the total mileage of the train, the month repair route recorded after finishing month repair and the remaining mileage from the next month repair are fields, and a lot of data in the database can be used as key data in the program and are shown in table 3.3.
Table 3.3 train kilometer auxiliary recording table information
(4) Train travel data record
The database is used for recording kilometer numbers of each train daily journey as a main key, one field for each day, and continuously recording kilometer number data of each day since the program runs, and taking a single year as an example, the database information shown in table 3.4.
Table 3.4 annual kilometer number record database table information
In addition to the database information, the system can acquire some information through other form data, such as a full month production plan issued by the production scheduling room at the beginning of a month, a prototype form style of a generated daily report, a data operation record after the database information is manually changed and the like. The operation of the various data tables in the program and the service objects can be seen from the data table structure diagram of fig. 8. The train number table number corresponds to kilometer information database as basic data source, the auxiliary record data of train month repair kilometer is mainly data table participating in data calculation, and the train running data record is a historical data table and is only referred to as data record.
3. Algorithm model for month repair kilometer number monitoring and regulation daily report generation system
The daily schedule for monitoring and regulating kilometers of each train in and out month repair is an important ring of maintenance and regulation work and is also an important function of the system, the chapter completes model establishment and algorithm research of planning on the basis of the analysis of schedule work and kilometer monitoring flow, and the method solves and analyzes according to feedback values obtained by digital calculation of the mileage and provides decisions and support according to a logic judgment form. Take Beijing subway Changping line as an example.
Train auxiliary calculation management and control model and algorithm research
The auxiliary calculation control for the train schedule is to help control and finish daily train number allocation tasks so as to finish operation tasks according to a production running chart. When the manual regulation and control scheduling method of the current Changping line maintenance center is still remained on the basis of manual programming, programming is carried out according to current car group information, vehicle stock parking information, center leader comments and the like, the main viewing factors, the control factors and the actual running conditions of the train are large, and when the manual regulation and control programming is carried out, the standard regulation and control scheduling method is not available, so that the scheduling mode and the scheduling efficiency of each regulation and control are different, and the work is complicated. Aiming at the scheduling programming problem of regulation and control, the scheduling programming problem is classified into an assignment problem, reliable data are searched and solved by adopting the number of the train unit mileage and a model of the train operation list number, the function of generating the train daily report through one key is unified, the operation management efficiency is improved, and the labor burden of a dispatcher is further reduced.
1. Model building
The schedule problem of the train is summarized and stated that each group of trains is operated according to the schedule number assigned by the production scheduling room from the beginning of the day to the end of the day, and meanwhile, the tasks of overhauling, car washing and the like in a month production plan issued by the production scheduling room are also met, the trains are parked according to the proper stock track position, the proper schedule number is selected, and the day's front line operation plan is completed by combining the reasonable overhauling allocation task.
In the process of regulating and controlling the schedule, proper train sets are selected to match the schedule numbers, so that the operation cost is greatly reduced, the optimal allocation mode is that the total number of kilometers which are mutually different among each train set is not very large, the stable operation is most reasonable when each train set guarantees that the kilometer difference is relatively fixed, and as the early operation schedule is not unified and normative, and the intervention of two-stage vehicles and even later multi-stage vehicles occurs, the requirement that each train set guarantees that the mutually fixed kilometer difference is only an ideal state and the actual train kilometer total value is not fixed.
In such a real environment, we only need to collect data based on a simple digital collection manner, the list content needs to be manually operated, the total kilometer number of the train is calculated by summing the kilometers accumulated by the operation of the train in the last month, the time set of the train in one month is { N i, i=1, 2, …,31}, the total number of columns of the train is { M j, i=1, 2, …,32}, so the kilometer number of the train in the last 30 days is shown in formula 4.1:
Wherein, the total operating mileage of the train is M sum,M0 which is the actual mileage of the train before the system performs automatic summation calculation, if the daily schedule data is to be checked, the verification of the data can be performed by the formula 4.2:
Where Md refers to the sum of kilometers travelled by all trains throughout the day.
The model carries out kilometer sum calculation on the allocated trains through the kilometer number data of the table number mentioned in the previous chapter, checks the daily schedule once through the returned Md value, and if the matching value is correct, the operation of generating the daily report can be carried out according to the schedule flow.
2. Demand parameters obtained based on algorithm
The function is mainly used for simply calculating the kilometer number sum of the train as long as the function is used for realizing the auxiliary calculation of the mileage number of the train, and the acquired correct parameters are brought into a database to be stored and the latest reliable data are returned through the database language and the expression.
(1) The number of mileage per group of trains per day
The number of kilometers per day of the train is the number of kilometers per day according to the gauge number issued by the production scheduling room, namely the number of kilometers is a fixed number of kilometers, and a fixed constant item is objectively obtained, and an accurate daily kilometer number constant can be obtained only by traversing the program through each group of trains and each group of gauge numbers.
(2) Actual total kilometers of train
The actual total kilometers of the train are obtained by summing the newly added mileage of M n every day with the previous total mileage M sum again according to the data updating alternating closed-loop operation described in the previous chapter, and the parameter is only used as a reference parameter and does not participate in model calculation.
(3) Running mileage within seven days
Only the mileage number value of each group of trains in the nearest week of the day is taken, and the parameter mainly has two purposes, one purpose is to facilitate the observation of the running condition of each group of trains for seven days, and the regulation and control personnel judges whether the last seven days are carried out according to the schedule mode planned by the regulation and control personnel; secondly, in order to observe whether the schedule arrangement mode is reasonable in seven days of regulation and control, if the kilometers generated in seven days are beyond the range of the operation kilometers of regulation and control planning, whether the schedule arrangement mode needs to be changed needs to be discussed.
(4) Monthly driving mileage and monthly maintenance related mileage of train
The parameters concerning the number of mileage are important parameters involved in monitoring for the number of kilometers of the month repair, and an algorithm model thereof will be described below, and a brief explanation is given here by summing the number of mileage on a daily basis with the previous data.
3. Calculation case analysis
The number of mileage corresponding to the number of train number is shown in table 4.1, which contains the current daily highway values of weekdays and holidays for each number obtained from the production dispatcher, and it is easy to see from these numbers that the kilometers belong to large tables, meaning that trains may need to go early and late, the kilometers belong to small tables, and trains may go early and late.
TABLE 4.1 number of train number corresponds to the mileage (in km)
The current parking conditions of the vehicle are shown in table 4.2, which includes the mileage per group of trains and the current selectable status and the parking track at that time. Some trains are arranged with a designated gauge number because of production needs or special instruction arrangement.
TABLE 4.2 vehicle state information
/>
By combining the information of the two tables, a driving plan can be made by means of an auxiliary table tool for regulation and control, and the most suitable scheduling plan is written into the driving condition finally obtained by the driving plan except for the non-selectable trains, and the driving condition is shown in table 4.3.
TABLE 4.3 train operation schedules
/>
Therefore, the auxiliary schedule function can help to regulate and control all required parameters, so that the schedule work is conveniently carried out by overhauling and regulating operation, and under the condition of not being interfered by a production plan or other factors, the schedule number with higher total mileage can be arranged for a train needing to enter a latest repair, and the planning is optimized.
Second, management and control model and strategy research for kilometer number of moon repair
In order to better realize service operation indexes, the requirements of an operation company on the monthly repair of the train are improved, the production scheduling room is very strict on the requirement of the monthly repair of the train, if the monthly repair is not carried out within a specified range, the operation accident is calculated, but because the regulation and control work relates to a wider working content, the data are more monitored at ordinary times, the monthly repair is easy to follow in the running process of the train due to the switching of a plurality of people, and the actual mileage of the train in the non-running period is calculated, so that the statistics difficulty on the monthly repair mileage and the running mileage is increased.
1. Model building
The main monitoring mode of the monthly repair mileage and the actual kilometers is to regularly refresh the actual operation mileage, and the other is to feed back the result calculated by digital combination through an algorithm written in the system to overhaul regulation, average the feedback value through reading the time difference value in the production plan, and give a recommended value for overhaul regulation reference through logic judgment.
In order to meet the requirement that the train arrives to enter the monthly repair operation according to the actual production requirement, the train needs to at least meet the sufficient number of mileage operated daily, and in order to facilitate regulation and control of the schedule, the recommended daily number of mileage is displayed in a column of 'daily kilometers' in a daily report, and the data is obtained according to the formula 4.3:
Wherein 20000 mileage is the standard requirement of the operation of entering the month repair according to 20000 km planned by the production requirement, M sum is the total mileage of the train running, R m is the updated numerical value filled in the on-bullet window month repair train number text box and month repair kilometer number text box provided by the system for the vehicle-mounted record given by the month repair after the last month repair, and DeltaT is the time difference between the current day time and the month repair entering time in the production plan, and the obtaining method is shown as 4.4:
ΔT＝|T2-T1| (4.4)
The two formulae give the arrangement according to formula 4.1 to give formula 4.5:
The average value of the difference value between the mileage and the time difference value is used in the group of models, and is an important basis for the system to carry out logic judgment, and the system can monitor the mileage of each group of trains going out of the last month for maintenance and the running index of at least how many mileage are required to be carried out every day for entering the remaining days of the next month for maintenance at any time through the average value.
2. Management and control strategy research based on system feedback value regulation personnel
The feedback value obtained by the model is not a final determined value, but is only used for assisting in maintenance regulation and control, and the phenomenon that the mileage is not in conformity with the regulation when the month repair is caused by neglecting the month repair kilometer number in actual production operation because of neglecting the month repair kilometer number is possibly ignored finally caused by the fact that the other factors are too many when the daily schedule arrangement is carried out.
(1) Control strategy for running mileage within seven days
As already mentioned above, the system can count the expression situation of each train in seven days in a separate database, the system does not judge the allocation situation of the expression list in seven days and the total kilometers in seven days, but can see whether the expression situation in seven days is arranged according to the schedule or not through the display of the information, and the total mileage generated in seven days is not in the acceptable range of regulating the expression list. If the distance between the trip mileage of a certain group of trains on seven days and the planned kilometers is too large, as shown in fig. 9, the maintenance and control needs to be careful in the case that the trip mileage of the train is not influenced, so that the trip mileage of the train needs to be paid attention in real time.
(2) Management and control strategy for mileage from month to month and average mileage from day to day
The value of the formula 4.5 can be acquired by the system and stored in a program, and the daily report can fully show the month-out repair mileage, the month-in repair time and the daily kilometer when the daily report is generated. The service control refers to these values and should look at the production plan in time to specify a new schedule if it is found not to be within the schedule of the plan.
(3) Cray number background monitoring strategy
In the routine work of maintenance regulation, the monitoring strategy is not needed, but in the actual work, the situation that the numerical value is wrong when the overregulation staff inputs the latest mileage is occurred, and the input wrong numerical value is not found in time, so that the cause of the error cannot be inquired, and therefore, a statistical table recorded with time and the filled numerical value can be automatically stored in the appointed position of the computer after the mileage is input every time.
3. Calculation case analysis
The travel kilometer statistics of the near seven days of the trains are shown in table 4.4, and the table can be easily seen, the table number distribution condition of the trains is not carried out in the near seven days, and the train with the total mileage of 0 indicates that the group of trains have maintenance tasks with longer time periods, such as maintenance projects or large reconstruction projects, and the group of trains can possibly stay in a warehouse for a long time because of production needs, and whether vehicles are forgotten to be arranged in the table can be clearly found through the display of the data.
Table 4.4 train running cycle mileage (unit km)
The running mileage condition of a train in the last month is shown in table 4.5, the maintenance regulation and control inputs the month repair kilometer number at the last month repair to the 'month repair mileage' column of the database through the month repair kilometer number input module of the system, the running kilometer number of each train can be obtained by making a difference between the 'total mileage number' and the 'month repair mileage', two negative value points are easily found from the data in the table, and the CP005 negative value belongs to a normal phenomenon, so that the phenomenon is caused because the total kilometer number of the train is obtained by summing the number of the table according to the production scheduling room, the accurate number on the train is not updated in time, but the output month repair mileage is the most accurate number on the train just after the month repair, so that the deviation is generated. The problem with CP022 vehicles indicates that the group of vehicles does not acquire any kilometer data in the last month, because the vehicle is in the process of repairing, the kilometer data cannot be acquired from the vehicle temporarily, however, the train in the repairing state does not need to consider the schedule work and does not influence the control work.
Table 4.5 auxiliary recording table for train month repair kilometers (unit km)
As shown in Table 4.6, the table is a record file which is generated at a designated position of a computer after finishing the maintenance and control of the number of the months and the mileage is output each time, the record file is expanded and continued all the time, the aim is to acquire the input number of the vehicle, the input mileage and the input time each time after the month and the mileage is input each time, so that the system is convenient for searching the kilometer number statistics errors caused by personnel input errors in the future, the system can also acquire the total kilometer number of the train at the time, and if the difference of the two values is too large, the system can automatically perform marking red processing, thereby facilitating the maintenance and control to find problems in time when the monitoring and control records are consulted.
Table 4.6 month kilometer repair number output monitoring table
Matrix model analysis of train month repair kilometer number auxiliary record database
The auxiliary record database of the number of kilometers of train month repair is calculated by summing the data input by date and driving type in the popup window according to the data updated by the main interface of the basic information system, and the record principle type 4.6 is shown as follows:
Wherein the matrix established with reference to the sets { N i, i=1, 2, …,31} and { M j, i=1, 2, …,32} and the values are stored in the train month repair kilometer auxiliary record database.
The total mileage of each group of trains in the near month can be obtained through the matrix, the daily schedule distribution can be clearly seen, the monitoring of the mileage of each group of trains entering the month can be better supported, if the value of M i+M0 of a single group of trains in one month exceeds or is close to 20000, the system can timely feed back the condition of the group of trains into the daily schedule according to logic judgment, and timely remind the maintenance and control to pay attention to the group of trains, so that the condition of entering the month for over kilometers is prevented. If M i+M0 of a single train is too low in a month, the system can remind maintenance regulation in a daily statement, and if multiple allocation scheduling tasks are needed under the condition that no other production schedule exists, the set of modules is mainly used for assisting work at present, and the most main decision maker is the regulation person for scheduling work.
In order to facilitate understanding of the above technical solutions of the present invention, the following describes the above technical solutions of the present invention in detail by a specific usage manner.
When the system is specifically used, the program can be used by a computer with basic office software without connecting the Internet and installing special programs. The program enters the basic information reality interface by double clicking, the 'import day data' button is clicked, the content of the basic information reality interface is refreshed, the 'export day data' button is clicked after confirming that the refreshed kilometer content of the vehicle is correct, the kilometer number input window is popped up, the month input text box, the date input text box and the driving type pull-down menu in the first part of the mileage input window are filled, and the 'confirm' button is clicked to directly generate a daily report on the desktop of the computer, so that the daily operation of regulation and control is completed.
After the train is subjected to the monthly repair operation, the monthly repair staff can report the monthly repair mileage of the monthly repair vehicle to the maintenance regulation and control, the monthly repair vehicle group number text box at the second part of the mileage input window and the monthly repair vehicle kilometer number text box are input for filling, the monthly repair kilometer number interaction is led into the popup window to pop out after clicking the 'confirm' button, the 'yes' button of the popup window is clicked after confirming the input, the record of the database is completed, and the data is convenient for tracking and managing the management and control of the monthly repair of each group of vehicles 20000 kilometers.
Various special conditions (such as disconnection, rescue, meter disorder and the like) or non-positive line operation (such as car washing, pulling out line adjustment, debugging and the like) of the train can occur in normal operation, the actual mileage of the train is deviated from the operation mileage given by operation production, the deviation can not influence the management and control of the train in a short time, but the management and control of the mileage of the train can be influenced with the increase of time, in order to avoid the phenomenon, the program supports a data refreshing function, a 'lead-in kilometer' button is clicked on a basic information reality interface, a file selection popup window is popped up, a 'open' button is clicked after a target data file is selected, the 'train mileage' column of a basic information reality interface can be updated, a 'lead-out daily data' button is clicked after data updating is correct, the 'Yes' button is clicked on three parts of the window can lead in an interactive popup window, and the 'Yes' button is clicked on the window can complete the record of a database.
In summary, by means of the technical scheme, the error rate and the operation intensity of the control staff caused by the traditional operation method and less mutual communication are greatly reduced, the management efficiency of the train is improved, the operation cost is reduced, and the requirement of the maintenance center for controlling daily schedule operation can be met. Through modern information technology, various data are regulated and controlled to be convenient to manage and store, statistics and backtracking of information are realized, and the operation management level of a metro vehicle section is improved.
The foregoing description of the preferred embodiments of the invention is not intended to be limiting, but rather is intended to cover all modifications, equivalents, alternatives, and improvements that fall within the spirit and scope of the invention.
Claims (6)
1. The system is characterized by comprising a daily train information importing module, a daily train report exporting module, a manual changing module and a background monitoring module;
The date-guiding train information module is used for realizing a date data information grabbing function, a function of distributing the running kilometers of the current date train according to the table number, and a function of adding data into a database and reading last valid data of the database; the system comprises a system main interface, an import day train information module, a data management module and a data management module, wherein the import day train information module is used for updating data provided on the system main interface and displaying the vehicle running condition of the current day and related data at the corresponding position of the main interface;
The daily train report deriving module is used for acquiring a monthly production plan function, a daily report generating function and a train running record storing function; the month production plan acquiring function is used for automatically searching a month production plan in the regulation computer according to the path, reading useful information in the production plan, acquiring a corresponding kilometer number value in a daily report after the target month repair time is different from the current time, and providing the time for entering the month repair for the daily report; the daily statement generating function is used for filling the acquired parameters into a daily statement template and obtaining the month-in and month-out kilometer repair parameters and the recommended schedule opinion of each group of trains according to the corresponding algorithm and production requirements; the train running record storing function is used for displaying the data checked by maintenance regulation and control and respectively filling the data information of each group of current trains into the mileage data and the train running data within seven days of train running;
The manual change module is used for placing information to be changed under a specified path file or directly inputting a place to import the information into a database through a database language according to a human-computer interaction interface;
the background monitoring module is used for inputting data into the database, recording the current system date and the output numerical value and storing the current system date and the output numerical value into an independent file for a manager to check and find the deviation.
2. The system for monitoring and controlling daily statement generation of month repair kilometers according to claim 1, wherein the daily data information grabbing function is used for grabbing control schedule data according to a specified path and storing the grabbed useful information in a local file.
3. The system for monitoring and controlling daily report generation of month repair kilometers according to claim 2, wherein the daily data information capturing function adopts a working mode of combining manual operation and computer operation.
4. The system for monitoring, controlling and generating daily reports according to claim 1, wherein the function of allocating the number of kilometers of trains on the same day according to the number of the train number is used for reading the data information of the database of kilometers information corresponding to the number of the train number, and displaying the data information of each group of trains on the same day on a main interface of the system through traversal.
5. The system for monitoring and controlling daily report generation of monthly repair kilometers according to claim 1, wherein the functions of adding data into the database and reading the last effective data of the database are used for filling the kilometers of the current daily driving information into the auxiliary record database of the monthly repair kilometers of the train, carrying out integration calculation in the database according to the field setting of the database, and returning the value of the corresponding requirement obtained after the integration calculation to the main interface.
6. The system for monitoring and regulating daily statement generation of number of kilometers per month according to claim 1, wherein the parameters in the daily statement generation function comprise parameters obtained from a database or a schedule and fixed parameters given by a production scheduling room.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210195110.2A CN114707475B (en) | 2022-03-01 | 2022-03-01 | Month repair kilometer number monitoring and regulation daily report generating system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210195110.2A CN114707475B (en) | 2022-03-01 | 2022-03-01 | Month repair kilometer number monitoring and regulation daily report generating system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114707475A CN114707475A (en) | 2022-07-05 |
| CN114707475B true CN114707475B (en) | 2024-06-25 |
Family
ID=82167408
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210195110.2A Active CN114707475B (en) | 2022-03-01 | 2022-03-01 | Month repair kilometer number monitoring and regulation daily report generating system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114707475B (en) |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111353705A (en) * | 2020-02-28 | 2020-06-30 | 交控科技股份有限公司 | Urban rail transit multi-field route management unit and comprehensive management and control system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113780588A (en) * | 2021-07-13 | 2021-12-10 | 成都地铁运营有限公司 | Automatic scheduling method and system for rail transit vehicle maintenance |
-
2022
- 2022-03-01 CN CN202210195110.2A patent/CN114707475B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111353705A (en) * | 2020-02-28 | 2020-06-30 | 交控科技股份有限公司 | Urban rail transit multi-field route management unit and comprehensive management and control system |
Non-Patent Citations (1)
| Title |
|---|
| 信息化在北京地铁车辆检修中的创新与应用;王华东;华路捷;栾琳;王文君;;都市快轨交通;20180418(第02期);141-148 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114707475A (en) | 2022-07-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111353705B (en) | Urban rail transit multi-field route management system and comprehensive management and control system | |
| CN108528477B (en) | A kind of metro depot/parking lot complex automatic system | |
| CN109214690A (en) | A kind of multi-factor evaluation car inspection and repair plan balance scheduling system and method | |
| CN109278811A (en) | A kind of comprehensive automation realization system and method for railway passenger station Transportation Organization | |
| CN110751453B (en) | Method and system for identifying and resolving capacity bottleneck of railway channel | |
| CN112132443B (en) | Reliability distribution network power supply management and control system | |
| CN108416526A (en) | A kind of line duration relevant risk monitoring system and method for the nuclear power station production schedule | |
| CN112132327A (en) | Multi-source data fusion-oriented intelligent planning system for power distribution network | |
| CN113978515B (en) | Centralized dispatching command system for transportation production operation of railway vehicle service section | |
| CN113554193A (en) | Intelligent operation and maintenance management platform and method for full-automatic running train | |
| CN106845789A (en) | Based on the automatic pre- discharge method of Transit Equipment year repair schedule for repairing journey | |
| CN113822547A (en) | Refined demand side management comprehensive information platform system and management method | |
| CN111967658A (en) | Comprehensive power failure analysis method based on marketing and distribution information integration platform | |
| CN114707475B (en) | Month repair kilometer number monitoring and regulation daily report generating system | |
| CN114169867A (en) | Project management system | |
| CN114338741A (en) | Intelligent operation and maintenance management system for vehicle | |
| CN109190947A (en) | A kind of traffic control evaluation system | |
| CN113869627A (en) | Subway vehicle inspection and adjustment intelligent management system | |
| CN116187772A (en) | Group-level low-carbon transformation decision support system | |
| Chang et al. | Lean improvement of product P assembly line based on value stream map | |
| Ding et al. | Intelligent planning and arrangement of urban rail transit equipment resource occupation under maintenance mode | |
| Jia et al. | Decision Support System and Demonstration Application of High-Speed Railway Train Operation Under Emergency Conditions | |
| CN115409536B (en) | Campus personnel flow adaptive site scheduling method and system | |
| RU2773984C1 (en) | System for managing the route network of a large passenger company | |
| CN117541232A (en) | Intelligent planning method and system for subway train overhaul |
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 | ||
| GR01 | Patent grant |