CN111382952B - Elevator quality inspection and extraction method based on comprehensive coverage principle - Google Patents

Elevator quality inspection and extraction method based on comprehensive coverage principle Download PDF

Info

Publication number
CN111382952B
CN111382952B CN202010206941.6A CN202010206941A CN111382952B CN 111382952 B CN111382952 B CN 111382952B CN 202010206941 A CN202010206941 A CN 202010206941A CN 111382952 B CN111382952 B CN 111382952B
Authority
CN
China
Prior art keywords
elevator
extracted
brand
supervision
maintenance unit
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
Application number
CN202010206941.6A
Other languages
Chinese (zh)
Other versions
CN111382952A (en
Inventor
潘健鸿
邹山青
张莉君
李伟程
吴璟超
王金銮
孙良艳
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fujian Special Equipment Inspection and Research Institute
Original Assignee
Fujian Special Equipment Inspection and Research Institute
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Fujian Special Equipment Inspection and Research Institute filed Critical Fujian Special Equipment Inspection and Research Institute
Priority to CN202010206941.6A priority Critical patent/CN111382952B/en
Publication of CN111382952A publication Critical patent/CN111382952A/en
Application granted granted Critical
Publication of CN111382952B publication Critical patent/CN111382952B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063—Operations research, analysis or management
    • G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
    • G06Q10/06395—Quality analysis or management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR 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/20—Administration of product repair or maintenance

Landscapes

  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Economics (AREA)
  • Physics & Mathematics (AREA)
  • Development Economics (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Educational Administration (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Game Theory and Decision Science (AREA)
  • Maintenance And Inspection Apparatuses For Elevators (AREA)

Abstract

The invention provides an elevator quality inspection extraction method based on a comprehensive coverage principle, which is used for determining factors influencing the elevator quality, wherein the factors comprise an elevator brand, an elevator supervision area and an elevator maintenance unit; constructing an information body from an elevator equipment data ledger library by using elevator brands, elevator supervision areas and elevator maintenance unit grouped fields, extracting elevator quality data in a brand full-coverage, maintenance full-coverage and county full-coverage mode, and storing the extracted data into a supervision JG table; the quality inspection of all the elevator data in the account library of the elevator equipment data table can be completed by performing the elevator quality inspection on the data in the monitoring JG table, so that support is provided for the safety monitoring of the elevator.

Description

Elevator quality inspection extraction method based on comprehensive coverage principle
Technical Field
The invention relates to the technical field of special equipment elevator detection, in particular to an elevator quality inspection extraction method based on a comprehensive coverage principle.
Background
The elevator is more and more common as a modern vertical transportation means in people's daily life, people's requirements for taking the elevator also change from initial convenient operation, safety concern to taking comfort, intelligence and rapidness, and the change also puts higher requirements on elevator inspection and detection. Regular elevator quality inspection is an important index for improving the elevator safety, and whether the elevator quality is safe or not comprises a plurality of factors such as: elevator brand, elevator supervision area, elevator maintenance unit, magnitude of elevator noise, straightness of guide rails of elevator, vibration frequency of elevator, and the like. The existing elevator quality inspection is to extract data from an elevator equipment data ledger library for detection, conditions influencing elevator quality factors are more, and thus, the condition of extracting the data in the elevator equipment data ledger library becomes a problem. In addition, the elevator quality spot check cannot be completed under the condition of random drawing because the coverage rate of the spot check is low and the number of missed data of the elevator is large.
Disclosure of Invention
In order to overcome the problems, the invention aims to provide an elevator quality inspection and extraction method based on a comprehensive coverage principle, which can inspect the comprehensive coverage of an elevator and has high inspection efficiency.
The invention is realized by adopting the following scheme: an elevator quality inspection extraction method based on a full coverage principle, comprising the following steps:
step S1, determining factors influencing the quality of the elevator, wherein the factors comprise the brand of the elevator, the supervision area of the elevator and the maintenance unit of the elevator;
s2, acquiring data from an elevator equipment data station account library to form an elevator brand configuration table to be extracted as a table A by taking an elevator brand as a grouping field, acquiring data from an elevator equipment data station account library to form an elevator installation county area configuration table to be extracted as a table B by taking an elevator supervision area as a grouping field, and acquiring data from an elevator equipment data station account library to form a one-dimensional enterprise elevator extraction record table as a table C by taking an elevator maintenance unit as a grouping field;
step S3, inputting an elevator quality inspection extraction ratio, and multiplying the installation number of the elevators in the table A by the extraction ratio to form an elevator brand ratio to-be-extracted table A1;
Step S4, using the key word of the brand of the elevator in the table A1 as an index to be associated with the table B, traversing the table B, using the elevator supervision area in the table B as a condition to extract data and store the data into a supervision JG table, using the key word of the brand of the elevator in the table A1 as an index to be associated with the table C, traversing the table C, using the elevator maintenance unit in the table C as a condition to extract data and store the data into the supervision JG table;
and S5, performing elevator quality inspection on the data in the monitoring JG table to complete quality inspection on all the elevator data in the elevator equipment data base and provide support for safety monitoring of the elevator.
Further, the step S2 further specifically includes the following steps: step S21: establishing a many-to-one relationship between elevator manufacturing enterprises and elevator brands, namely, corresponding a plurality of elevator manufacturing enterprises of the same brand to one brand;
step S22: taking the elevator brand as a grouping field, establishing an elevator brand to-be-extracted configuration table in an elevator equipment data base in a reverse order according to the conditions of whether the elevator is registered and used and the installation number of the elevator, and recording the configuration table as a table A;
step S23: taking the county and district names corresponding to the first 6 administrative district codes as grouping fields, establishing an elevator installation county and district to-be-extracted configuration table, which is recorded as a table B, from an elevator equipment data base on the condition that whether the elevator is registered and used and in reverse order of the installation number of the elevator;
Step S24: and (3) establishing a maintenance enterprise elevator extraction record table from an elevator equipment data base by taking the elevator maintenance unit as a grouping field and taking whether the elevator is registered or not and using whether the elevator is used or not, storing the elevator maintenance unit, the maintenance elevator quantity and the extracted elevator quantity, sorting in a reverse order of the maintenance elevator quantity, and recording as a table C.
Further, the step S3 is further specifically: inputting an elevator quality inspection extraction ratio, multiplying the installation number of the elevators in the table A by the extraction ratio to form an elevator brand ratio to-be-extracted configuration table A1, recording an extraction value and a value to be extracted, and if the installation number multiplied by the extraction ratio is less than 1, determining that the extraction value and the value to be extracted are both 1.
Further, the step S4 further specifically includes the following steps: step S41, the brand of the elevator with the value larger than 0 to be extracted currently in the partial order relation calendar A1 is recorded as the brand TP of the elevatorxWherein subscript x is a natural number;
step S42, selecting TP from elevator equipment data ledger libraryxBrand installed in Table B unmarked extracted Elevator supervision area TQxThe random function is used for extracting 1 elevator which is not in the extracted supervision JG table and writing the elevator into the supervision JG table;
Step S43, modifying Elevator brand TP in Table A1xSubtracting 1 from the corresponding value to be extracted, modifying the corresponding extracted value, adding 1 and storing;
step S44, corresponding elevator supervision area TQ in the table BxSetting the value as extracted, adding 1 to the corresponding extracted value and storing;
step S45, adding 1 to the extracted numerical value of the corresponding elevator maintenance unit in the table C and storing the numerical value;
step S46, if step S42 is executed, TPxIf the brand is not already installed in the unretracted elevator monitoring area in the table B, the elevator brand TP is read from the elevator equipment data ledgerxCorresponding elevator maintenance unit TPWBxTaking out TPWB from Table CxThe first record with the value of 0 is extracted currently, and the brand maintained by the elevator maintenance unit is taken out as TPxThe first county TPWBQ with the smallest proportion is taken out from the extracted numerical value/total county installation number of the table BxThe brand maintained by the elevator maintenance unit is TPxThe mounting area is TPWBQxRandomly extracts 1 elevators not in the supervision JG table among all elevators in use in the elevator book, writes the supervision JG table, and repeats steps S42 to S45.
Further, the step S46 is followed by: step S47, if the step is executed TPWB at S46xIf there is no record with the extracted value of 0, traverse TPWB in table CxCorresponding to the maintenance unit of the elevator, the extracted value/maintenance elevator number of the meter C is TPWBPxTaking TPWBPxThe first maintenance unit in the minimum value is taken out, and the brand maintained by the elevator maintenance unit is TPxTaking out all the installed counties, further taking out all the installed counties, taking out the history table B, taking out the numerical value/total installed county from the table B, and taking out the TPWBQ of the first county with the minimum proportionxThe brand maintained by the elevator maintenance unit is TPxThe mounting area is TPWBQxRandomly extracting 1 elevators which are not in the supervision JG table from all the elevators in the elevator book, writing the elevators in the supervision JG table, and repeating the steps S42 to S45; until there are no brands in Table A1 for which the value is greater than 0.
Further, the step S47 is followed by: step S48, if there is still record of unmarked extracted elevator monitoring area in the table B, then the record unmarked extracted elevator monitoring area in the sequence history table B is marked as TQyWherein subscript y is a natural number; take out the installation area as TQyRandomly extracting 1 elevator which is not in the supervision JG table in all elevators in the elevator book, writing the elevator into the supervision JG table, and repeating the steps S42 to S45; until there are no records in table B that indicate the supervision zones of the extracted elevator are unmarked.
Further, the step S48 is followed by: step S49, if there is still an elevator maintenance unit record with the currently extracted numerical value of 0 in the table C, then the elevator maintenance unit with the currently extracted numerical value of 0 in the history table C is taken out, all the elevators in use maintained by the elevator maintenance unit are taken out, all the installation counties are taken out, the history table B is taken out, the extracted numerical value/total installation number of counties in the table B is taken out, and the first county BC with the minimum proportion is taken outzWherein the subscript z is a natural number; the installation area maintained by the elevator maintenance unit is BCzRandomly extracting 1 elevator which is not in the supervision JG table from all the elevators in the elevator book, writing the elevator into the supervision JG table, and repeating the steps S42 to S45; until there is no elevator maintenance unit record in table C for which the currently extracted value is 0.
The invention has the beneficial effects that: the elevator quality data extraction method and the elevator quality data extraction system construct the information body from the elevator equipment data ledger library by using the elevator brand, the elevator supervision area and the elevator maintenance unit grouping field, extract the elevator quality data in the modes of brand full coverage, maintenance full coverage and county full coverage, have random representativeness in the extraction result, achieve full coverage, have controllable operation time, can perform full coverage inspection on the elevator, and have high inspection efficiency.
Drawings
FIG. 1 is a schematic flow diagram of the process of the present invention.
Detailed Description
The invention is further described below with reference to the accompanying drawings.
Referring to fig. 1, the elevator quality inspection extraction method based on the comprehensive coverage principle of the present invention extracts elevator quality data in a manner of full coverage of elevator brands, full coverage of elevator maintenance units, and full coverage of elevator supervision areas, and includes the following steps:
step S1, determining factors influencing the quality of the elevator, wherein the factors comprise the brand of the elevator, the supervision area of the elevator and the maintenance unit of the elevator;
s2, acquiring data from an elevator equipment data station account library to form an elevator brand configuration table to be extracted as a table A by taking an elevator brand as a grouping field, acquiring data from an elevator equipment data station account library to form an elevator installation county area configuration table to be extracted as a table B by taking an elevator supervision area as a grouping field, and acquiring data from an elevator equipment data station account library to form a one-dimensional enterprise elevator extraction record table as a table C by taking an elevator maintenance unit as a grouping field;
step S3, inputting an elevator quality inspection extraction ratio, and multiplying the installation number of the elevators in the table A by the extraction ratio to form an elevator brand ratio to-be-extracted table A1;
Step S4, using the key word of the brand of the elevator in the table A1 as an index to be associated with the table B, traversing the table B, using the elevator supervision area in the table B as a condition to extract data and store the data into a supervision JG table, using the key word of the brand of the elevator in the table A1 as an index to be associated with the table C, traversing the table C, using the elevator maintenance unit in the table C as a condition to extract data and store the data into the supervision JG table;
and S5, performing elevator quality inspection on the data in the monitoring JG table to complete quality inspection on all the elevator data in the elevator equipment data base and provide support for safety monitoring of the elevator.
The invention is further illustrated below with reference to a specific embodiment:
step S1, determining factors influencing the quality of the elevator, wherein the factors comprise the brand of the elevator, the supervision area of the elevator and the maintenance unit of the elevator;
step S21: establishing a many-to-one relationship between elevator manufacturing enterprises and elevator brands, namely, corresponding a plurality of elevator manufacturing enterprises of the same brand to one brand; such as: the three manufacturers of sie elevator limited, sie electromechanical elevator limited, and sie elevator limited, hangzhou sie ao are all referred to as "sie elevator of sie.
Step S22: taking the elevator brand as a grouping field, establishing an elevator brand to-be-extracted configuration table in an elevator equipment data base in a reverse order according to the conditions of whether the elevator is registered and used and the installation number of the elevator, and recording the configuration table as a table A;
Step S23: taking the county and district names corresponding to the first 6 administrative district codes as grouping fields, establishing an elevator installation county and district to-be-extracted configuration table, which is recorded as a table B, from an elevator equipment data base on the condition that whether the elevator is registered and used and in reverse order of the installation number of the elevator;
step S24: and (3) establishing a maintenance enterprise elevator extraction record table by taking the elevator maintenance unit as a grouping field and taking whether the elevator is registered or not and whether the elevator is used or not from an elevator equipment data table account, storing the elevator maintenance unit, the number of maintenance elevators and the number of extracted elevators, and sequencing in the reverse order of the number of maintenance elevators, wherein the list is recorded as a table C.
The step S3 specifically includes: inputting an elevator quality inspection extraction ratio (such as a ratio of 30%), forming an elevator brand ratio (four-shed six-in-five compact couple) to-be-extracted configuration table A1 by multiplying the installation number of the elevators in the table A by the extraction ratio, recording an extraction value and a value to be extracted, and if the installation number is multiplied by the extraction ratio and is less than 1, both the extraction value and the value to be extracted are 1.
The step S4 specifically includes the following steps: step S41, recording the brand of the elevator with the value larger than 0 to be extracted currently in the constructed partial order relation passing list A1 as the brand TP of the elevator xWherein subscript x is a natural number; such as: elevator brand TP1For Olympus elevators, Elevator brand TP2Is Shanghai Mitsubishi elevator, elevator brand TP3To express, elevator brand TP4Is a Hitachi elevator.
Step S42, selecting TP from elevator equipment data ledger libraryxBrand installed in Table B unmarked extracted Elevator supervision area TQxThe random function is used for extracting 1 elevator which is not in the extracted supervision JG table and writing the elevator into the supervision JG table; such as: elevator supervision area TQ1For the elevator supervision area TQ2For Miner region, elevator supervision region TQ3For defining area and elevator supervision area TQ4Is a Jinshan area;
step S43, modifying Elevator brand TP in Table A1xSubtracting 1 from the corresponding value to be extracted, modifying the corresponding extracted value and adding 1 and storing;
step S44, corresponding elevator supervision area TQ in the table BxSetting the value as extracted, adding 1 to the corresponding extracted value and storing;
step S45, adding 1 to the extracted numerical value of the corresponding elevator maintenance unit in the table C and storing the numerical value; the fields of 'value to be extracted' and 'value to be extracted' are set in the tables A1, B and C;
step S46, if step S42 is executed, TP xIf the brand is not already installed in the unretracted elevator monitoring area in the table B (i.e., TP 42xBrand installation all shows marked extracted Elevator supervision area TQ in Table BxAll in-use elevators) is read from the elevator installation data ledger store the elevator brand TPxCorresponding elevator maintenance unit TPWBx(e.g. elevator maintenance unit TPWB)1Is TPWB of elevator maintenance unit of Fujian Xunda Elevator Co Ltd2Is the elevator maintenance unit TPWB of the Olympus Elevator Co., Ltd., Guangzhou Olympic3Mitsubishi Elevator, Fujian division, Shanghai, etc.), the TPWBs were taken out of Table CxThe first record with the value of 0 is extracted currently, and the brand maintained by the elevator maintenance unit is taken out as TPxThe first county TPWBQ with the smallest proportion is taken out from the extracted numerical value/total county installation number of the table BxThe brand maintained by the elevator maintenance unit is TPxThe mounting area is TPWBQxRandomly extracts 1 elevators not in the supervision JG table among all elevators in use in the elevator book, writes the supervision JG table, and repeats steps S42 to S45.
Step S47, if step S46 is executed, TPWBxIf there is no record with the extracted value of 0, traverse TPWB in table C xCorresponding to the maintenance unit of the elevator, the extracted value of the meter C/the number of maintenance elevators is TPWBPxTaking TPWBPxThe first maintenance unit in the minimum value is taken out, and the brand maintained by the elevator maintenance unit is TPxTaking out all the installed counties, further taking out all the installed counties, taking out the history table B, taking out the numerical value/total installed county from the table B, and taking out the TPWBQ of the first county with the minimum proportionxThe brand maintained by the elevator maintenance unit is TPxThe mounting area is TPWBQxRandomly extracting 1 elevator which is not in the supervision JG table from all the elevators in the elevator book, writing the elevator into the supervision JG table, and repeating the steps S42 to S45; and traversing other elevator brands in the table A1 until no brand with a value larger than 0 to be extracted currently exists in the table A1.
Step S48, if there is still record of unmarked extracted elevator monitoring area in the table B, then the record unmarked extracted elevator monitoring area in the sequence history table B is marked as TQyWherein subscript y is a natural number; take out the installation area as TQyRandomly extracting 1 elevator which is not in the supervision JG table in all elevators in the elevator book, writing the elevator into the supervision JG table, and repeating the steps S42 to S45; go through other elevator supervision areas in table BAnd (4) going through until no record of the unmarked extracted elevator supervision area exists in the table B.
Step S49, if there is still an elevator maintenance unit record with the currently extracted numerical value of 0 in the table C, then the elevator maintenance unit with the currently extracted numerical value of 0 in the history table C is taken out, all the elevators in use maintained by the elevator maintenance unit are taken out, all the installation counties are taken out, the history table B is taken out, the extracted numerical value/total installation number of counties in the table B is taken out, and the first county BC with the minimum proportion is taken outzWherein the subscript z is a natural number; the installation area maintained by the elevator maintenance unit is BCzRandomly extracting 1 elevator which is not in the supervision JG table from all the elevators in the elevator book, writing the elevator into the supervision JG table, and repeating the steps S42 to S45; and traversing other elevator maintenance units in the table C until no elevator maintenance unit with the currently extracted numerical value of 0 is recorded in the table C.
And S5, performing elevator quality inspection on the data in the monitoring JG table to complete quality inspection on all elevator data in the elevator equipment data table account library and provide support for safety monitoring of the elevator.
In a word, the elevator quality data is extracted in a brand full-coverage, maintenance full-coverage and county-area full-coverage mode by constructing the information body from the elevator equipment data ledger library by using the elevator brand, the elevator supervision area and the elevator maintenance unit grouping field, the extracted result has random representativeness, the elevator quality data is fully covered, the operation time is controllable, the elevator can be inspected in the full-coverage mode, and the inspection efficiency is high.
The above description is only a preferred embodiment of the present invention, and all the equivalent changes and modifications made according to the claims of the present invention should be covered by the present invention.

Claims (4)

1. An elevator quality inspection extraction method based on a comprehensive coverage principle is characterized in that: the extraction method comprises the following steps:
step S1, determining factors influencing the quality of the elevator, wherein the factors comprise the brand of the elevator, the supervision area of the elevator and the maintenance unit of the elevator;
s2, acquiring data from an elevator equipment data station account library to form an elevator brand configuration table to be extracted as a table A by taking an elevator brand as a grouping field, acquiring data from an elevator equipment data station account library to form an elevator installation county area configuration table to be extracted as a table B by taking an elevator supervision area as a grouping field, and acquiring data from an elevator equipment data station account library to form a one-dimensional enterprise elevator extraction record table as a table C by taking an elevator maintenance unit as a grouping field;
step S3, inputting an elevator quality inspection extraction ratio, and multiplying the installation number of the elevators in the table A by the extraction ratio to form an elevator brand ratio to-be-extracted table A1;
step S4, using the elevator brand key in the table A1 as an index to be associated with the table B, conducting data extraction and storing on the table B and taking the elevator supervision area in the table B as a condition to be stored in a supervision JG table, using the elevator brand key in the table A1 as an index to be associated with the table C, conducting data extraction and storing on the table C and taking the elevator maintenance unit in the table C as a condition to be stored in the supervision JG table;
S5, performing elevator quality inspection on the data in the monitoring JG table to complete the quality inspection on all the elevator data in the elevator equipment data table account;
the step S2 further includes the following steps:
step S21: establishing a many-to-one relationship between elevator manufacturing enterprises and elevator brands, namely, corresponding a plurality of elevator manufacturing enterprises of the same brand to one brand;
step S22: taking the elevator brand as a grouping field, establishing an elevator brand to-be-extracted configuration table in an elevator equipment data base in a reverse order according to the conditions of whether the elevator is registered and used and the installation number of the elevator, and recording the configuration table as a table A;
step S23: taking the county and district names corresponding to the first 6 administrative district codes as grouping fields, establishing an elevator installation county and district to-be-extracted configuration table, which is recorded as a table B, from an elevator equipment data base on the condition that whether the elevator is registered and used and in reverse order of the installation number of the elevator;
step S24: establishing a maintenance enterprise elevator extraction record table by taking an elevator maintenance unit as a grouping field and taking whether an elevator is registered or not and whether the elevator is used or not from an elevator equipment data table account, storing the elevator maintenance unit, the number of maintenance elevators and the number of extracted elevators, and sequencing the elevator maintenance units, the number of maintenance elevators and the number of extracted elevators in a reverse order, and recording the elevator maintenance units, the number of maintenance elevators and the number of extracted elevators as a table C;
The step S4 further includes the following steps:
step S41, the brand of the elevator with the value larger than 0 to be extracted currently in the partial order relation calendar A1 is recorded as the brand TP of the elevatorxWherein subscript x is a natural number;
step S42, selecting TP from elevator equipment data ledger libraryxBrand installed in Table B unmarked extracted Elevator supervision area TQxThe random function is used for extracting 1 elevator which is not in the extracted supervision JG table and writing the elevator into the supervision JG table;
step S43, modifying Elevator brand TP in Table A1xSubtracting 1 from the corresponding value to be extracted, modifying the corresponding extracted value and adding 1 and storing;
step S44, corresponding elevator supervision area TQ in the table BxSetting the value as extracted, adding 1 to the corresponding extracted value and storing;
step S45, adding 1 to the extracted numerical value of the corresponding elevator maintenance unit in the table C and storing the numerical value;
step S46, if step S42 is executed, TPxIf the brand is not already installed in the unretracted elevator monitoring area in the table B, the elevator brand TP is read from the elevator equipment data ledgerxCorresponding elevator maintenance unit TPWBxTaking out TPWB from Table CxThe first record with the value of 0 is extracted currently, and the brand maintained by the elevator maintenance unit is taken out as TP xThe elevator in the first county area TPWBQ with the minimum ratio is extracted by extracting all installation counties, passing through the table B, using the extracted values of the table B/total installation number of countiesxThe brand of maintenance from the elevator maintenance unit is TPxThe mounting area is TPWBQxRandomly extracts 1 elevators not in the supervision JG table among all the elevators in use in the elevator book, writes the supervision JG table,repeating steps S42 to S45;
the step S46 is followed by: step S47, TPWB if step S46 is executedxIf there is no record with the extracted value of 0, traverse TPWB in table CxCorresponding to the maintenance unit of the elevator, the extracted value/maintenance elevator number of the meter C is TPWBPxTaking TPWBPxThe first maintenance unit in the minimum value is taken out, and the brand maintained by the maintenance unit is TPxTaking out all the installed counties, further taking out all the installed counties, taking out the history table B, taking out the numerical value/total installed county from the table B, and taking out the TPWBQ of the first county with the minimum proportionxThe brand maintained by the maintenance unit is TPxThe mounting area is TPWBQxRandomly extracting 1 elevator which is not in the supervision JG table from all the elevators in the elevator book, writing the elevator into the supervision JG table, and repeating the steps S42 to S45; until there are no brands in Table A1 for which the value is greater than 0.
2. The elevator quality inspection extraction method based on the full coverage principle as claimed in claim 1, wherein: the step S3 further includes: inputting an elevator quality inspection extraction ratio, multiplying the installation number of the elevators in the table A by the extraction ratio to form an elevator brand ratio to-be-extracted configuration table A1, recording an extraction value and a value to be extracted, and if the installation number multiplied by the extraction ratio is less than 1, both the extraction value and the value to be extracted are 1.
3. The elevator quality inspection extraction method based on the full coverage principle as recited in claim 1, wherein: the step S47 is followed by: step S48, if there is still record of unmarked extracted elevator monitoring area in the table B, then the record unmarked extracted elevator monitoring area in the sequence history table B is marked as TQyWherein subscript y is a natural number; take out the installation area as TQyRandomly extracting 1 elevator which is not in the supervision JG table in all elevators in the elevator book, writing the elevator into the supervision JG table, and repeating the steps S42 to S45; until there are no records in table B that indicate the supervision zones of the extracted elevator are unmarked.
4. The elevator quality inspection extraction method based on the full coverage principle as claimed in claim 3, characterized in that: the step S48 is followed by: step S49, if there is still an elevator maintenance unit record with the currently extracted numerical value of 0 in the table C, then the elevator maintenance unit with the currently extracted numerical value of 0 in the history table C is taken out, all the elevators in use maintained by the elevator maintenance unit are taken out, all the installation counties are taken out, the history table B is taken out, the extracted numerical value/total installation number of counties in the table B is taken out, and the first county BC with the minimum proportion is taken out zWherein subscript z is a natural number; the installation area maintained by the elevator maintenance unit is BCzRandomly extracting 1 elevators which are not in the supervision JG table from all the elevators in the elevator book, writing the elevators in the supervision JG table, and repeating the steps S42 to S45; until there is no elevator maintenance unit record with the currently extracted value of 0 in the table C.
CN202010206941.6A 2020-03-23 2020-03-23 Elevator quality inspection and extraction method based on comprehensive coverage principle Active CN111382952B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010206941.6A CN111382952B (en) 2020-03-23 2020-03-23 Elevator quality inspection and extraction method based on comprehensive coverage principle

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010206941.6A CN111382952B (en) 2020-03-23 2020-03-23 Elevator quality inspection and extraction method based on comprehensive coverage principle

Publications (2)

Publication Number Publication Date
CN111382952A CN111382952A (en) 2020-07-07
CN111382952B true CN111382952B (en) 2022-06-28

Family

ID=71220002

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010206941.6A Active CN111382952B (en) 2020-03-23 2020-03-23 Elevator quality inspection and extraction method based on comprehensive coverage principle

Country Status (1)

Country Link
CN (1) CN111382952B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113269399A (en) * 2021-04-27 2021-08-17 重庆千跬科技有限公司 Automatic checking method and system for elevator quality safety
CN113666217A (en) * 2021-09-08 2021-11-19 苏州洛翌鑫珂智能科技有限公司 Comprehensive operation and maintenance monitoring method for elevators with different control systems

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104973475A (en) * 2015-05-19 2015-10-14 绍兴市特种设备检测院 Method for monitoring elevator quality safety index
WO2017213281A1 (en) * 2016-06-09 2017-12-14 주식회사 그리즐리 Method for de-identifying big data
WO2018083764A1 (en) * 2016-11-02 2018-05-11 三菱電機株式会社 Device for maintenance/inspection of elevator main rope, and method for maintenance/inspection of elevator main rope
CN108460161A (en) * 2018-03-30 2018-08-28 腾讯科技（深圳）有限公司 Layered sampling method, device and computer equipment
CN110329862A (en) * 2019-07-17 2019-10-15 舒东 A kind of elevator intelligent total management system based on cloud platform

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104973475A (en) * 2015-05-19 2015-10-14 绍兴市特种设备检测院 Method for monitoring elevator quality safety index
WO2017213281A1 (en) * 2016-06-09 2017-12-14 주식회사 그리즐리 Method for de-identifying big data
WO2018083764A1 (en) * 2016-11-02 2018-05-11 三菱電機株式会社 Device for maintenance/inspection of elevator main rope, and method for maintenance/inspection of elevator main rope
CN108460161A (en) * 2018-03-30 2018-08-28 腾讯科技（深圳）有限公司 Layered sampling method, device and computer equipment
CN110329862A (en) * 2019-07-17 2019-10-15 舒东 A kind of elevator intelligent total management system based on cloud platform

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
分层抽样在电梯检验报告抽查中的应用;黄鹏辉 等;《中国特种设备安全》;20170831;第33卷(第08期);第13-15,44页 *
基于R软件应用的天津市电梯安全状况抽样分析;赵翠林 等;《中国特种设备安全》;20180930;第34卷(第09期);第51-55,73页 *
基于大样本电梯抽查数据的风险评估Logistic模型;熊健 等;《数理统计与管理》;20170731;第36卷(第04期);第599-607页 *
电梯质量安全指数设计初探及应用举例;姚国平;《中国特种设备安全》;20160531;第32卷(第05期);第38-41页 *

Also Published As

Publication number Publication date
CN111382952A (en) 2020-07-07

Similar Documents

Publication Publication Date Title
CN111382952B (en) Elevator quality inspection and extraction method based on comprehensive coverage principle
CN104978627B (en) A kind of method of electric power acquisition terminal update internal electric energy table archives
CN104424087B (en) A kind of method of Web page surface element positioning, apparatus and system
CN104702800B (en) A kind of recognition methods for harassing number, device and system
CN104714984A (en) Database optimization method and device
CN107506467A (en) A kind of method and system of charging pile maintenance
CN110471938A (en) A method of Stream Processing and real-time retrieval towards magnanimity track data
CN102508919A (en) Data processing method and system
CN107635080A (en) Report processing method and equipment for repairment
CN101161527A (en) Method and apparatus for security controlling railway station train reception and departure
CN108924371A (en) The method that family number is identified by incoming number during electric power customer service
CN101599078B (en) Method and device for text retrieval
CN106844497A (en) The check device and method of a kind of database code
CN101436316A (en) Method and system for filtering work attendance data
Szyliowicz et al. Energy crisis and US foreign policy
CN103489068A (en) Steel cylinder circulating state monitoring system and method
CN103136187A (en) Method and system for extraction of patent rejection information
CN106789248A (en) Power utility check distribution method and device
CN106446237A (en) Method for automatically screening and modifying examination questions according to updated knowledge content
CN103268353A (en) Power grid alarming automatic response system and power grid alarming automatic response method
CN103838765B (en) Associated person information storage method and device, electronic equipment
CN109143878B (en) Remote signaling message and SOE message processing method for multi-channel acquisition channel
CN111143155A (en) Method for realizing alarm synchronization and clearing mechanism applied to communication industry
CN112346898A (en) Test method and system for rail transit system
CN107463353A (en) A kind of sort method and equipment based on pointer address skew

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
GR01 Patent grant