CN115796563B - Steel structure list checking and verifying management system based on big data - Google Patents
Steel structure list checking and verifying management system based on big data Download PDFInfo
- Publication number
- CN115796563B CN115796563B CN202310097078.9A CN202310097078A CN115796563B CN 115796563 B CN115796563 B CN 115796563B CN 202310097078 A CN202310097078 A CN 202310097078A CN 115796563 B CN115796563 B CN 115796563B
- Authority
- CN
- China
- Prior art keywords
- checking
- list
- steel structure
- unit
- checked
- 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
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The invention relates to the technical field of big data, in particular to a steel structure list checking and verifying management system based on big data, which comprises the following components: the system comprises a list checking and verifying module, a database, a checking information acquisition module, a checking information analysis module and a checking and verifying management module, wherein the steel structure list is checked through the list checking and verifying module, historical checking information is acquired through the checking information acquisition module, the acquired data is transmitted to the database, all the acquired data are stored through the database, the difficulty coefficient of the conventional checking of the steel structure list is analyzed through the checking information analysis module, whether the checking work needs to be adjusted or not is selected, and when the checking work needs to be adjusted, a proper number of list checking personnel are distributed through the checking and verifying management module, so that the list checking mode is optimized, the checking speed of the steel structure list is increased on the whole, and the waste of checking labor cost is reduced.
Description
Technical Field
The invention relates to the technical field of big data, in particular to a steel structure list checking and verifying management system based on the big data.
Background
The steel structure list reflects the actual consumption and the related cost of the project, is an important basis for adjusting project engineering quantity, project payment and settlement, accurately and meticulously checks and checks the steel structure list, and can ensure the accuracy of construction approximate calculation and be used as a basis for controlling construction budget;
however, the existing steel structure list checking method still has some problems: firstly, in the prior art, steel structure list data needs to be manually input, sum of sum functions of Excel is generally only used in the steel structure data statistical process, and a checker needs to judge the type of a steel structure to select a proper statistical calculation formula, so that the overall checking speed and accuracy cannot be effectively improved; secondly, the steel structure list checking workload is large, a plurality of persons are generally required to check together, in the checking management aspect, the prior art cannot utilize a big data technology to prejudge whether the number of checking persons distributed by default is proper or not, further cannot adjust the persons with proper number to carry out the steel structure list checking work, and the problems that the checking work cannot be completed in time or the checking labor cost is wasted exist.
Therefore, a steel structure list checking and verification management system based on big data is needed to solve the problems.
Disclosure of Invention
The invention aims to provide a steel structure list checking and verifying management system based on big data, so as to solve the problems in the background technology.
In order to solve the technical problems, the invention provides the following technical scheme: a steel structure list checking and verifying management system based on big data comprises: the system comprises a list checking and verifying module, a database, a checking information acquisition module, a checking information analysis module and a checking and verifying management module;
the output end of the list checking and verifying module is connected with the input end of the checking information acquisition module, the output end of the checking information acquisition module is connected with the input end of the database, the output end of the database is connected with the input ends of the checking information analysis module and the checking and verifying management module, and the output end of the checking information analysis module is connected with the input end of the checking and verifying management module;
checking the steel structure list through the list checking and verifying module;
historical checking information is collected through the checking information collection module, and collected data are transmitted to the database;
storing all collected data through the database;
the difficulty coefficient of the conventional steel structure list checking is analyzed through the checking information analysis module, and whether the checking work needs to be adjusted or not is selected;
and distributing a proper number of list checking personnel when the checking management module selects to adjust the checking work.
Further, the list checking and verifying module comprises a data entry unit, a steel structure identification unit and a list checking unit;
the output end of the data entry unit is connected with the input end of the steel structure identification unit, and the output end of the steel structure identification unit is connected with the input end of the list checking unit;
the data entry unit is used for extracting and entering a steel structure list needing to be checked by utilizing CAD quick view map software, and directly extracting the steel structure list by utilizing the 'extraction form' function of the CAD quick view map, so that the entry speed of the steel structure list is accelerated;
the steel structure identification unit is used for identifying the steel structure type appearing in the list by utilizing an ifs function in Excel software, and automatically identifying and judging the steel structure type by utilizing the ifs function, so that the problem of error in self-judgment of the steel structure type in the prior art is solved;
the list checking unit is used for counting the number and the weight of different types of steel structures in the list by using function combination nesting of Excel software, checking whether the data counted in the list is consistent with actual data or not, counting the number and the weight by using a sum function alone, counting the combination nesting of countif, offset, sum and if functions of Excel, and accelerating the checking speed of the steel structure list.
Further, the checking information acquisition module comprises a data volume acquisition unit, a checking person number acquisition unit and a checking time acquisition unit;
the input end of the data quantity acquisition unit is connected with the output end of the list checking unit, and the output ends of the data quantity acquisition unit, the checking person number acquisition unit and the checking time acquisition unit are connected with the input end of the database;
the data volume acquisition unit is used for acquiring the data volume to be checked when the steel structure list is checked;
the checking people number acquisition unit is used for acquiring the number of distributed checking steel structure list people;
the checking time acquisition unit is used for acquiring the time required by the distributed personnel for checking the steel structure list.
Further, the verification information analysis module comprises a verification difficulty analysis unit and a distribution model establishing unit;
the input end of the checking difficulty analysis unit is connected with the output end of the database, and the output end of the checking difficulty analysis unit is connected with the input end of the distribution model establishing unit;
the checking difficulty analysis unit is used for analyzing the difficulty coefficient of the conventional steel structure list to be checked and analyzing the difficulty coefficient of the current list to be checked;
the distribution model establishing unit is used for establishing a verifier distribution model.
Further, the checking and checking management module comprises a checking and adjusting selection unit and a personnel distribution and adjusting unit;
the input end of the checking, adjusting and selecting unit is connected with the output end of the distribution model establishing unit, and the output end of the checking, adjusting and selecting unit is connected with the input end of the personnel distribution adjusting unit;
the checking, adjusting and selecting unit is used for judging whether the number of checking personnel distributed by default at present is proper or not, and selecting and adjusting the checking work of the current steel structure list when the number is judged to be improper;
and the personnel distribution adjusting unit is used for distributing proper quantity of personnel to carry out steel structure list checking work.
The method comprises the steps of acquiring a steel structure list by using a data quantity acquisition unit, checking the quantity of the steel structures at one time, wherein the number of the steel structures is a = { A1, A2, \ 8230;, an }, the number checking function set is C = { C1, C2, \ 8230;, cn }, the number checking function set is B = { B1, B2, \ 8230;, bn }, the weight checking function set is D = { D1, D2, \ 8230, dn }, the number checking function set is N = { F1, F2, = { E1, gmE 2, \\\ 8230;, em the number checking function set is required when the quantity of the steel structures is checked at one time, the number checking function set is F =, F1, F2, =, the weight checking function set is M1, the weight checking function set is limited when the steel structures are checked at one time, and the steel structures are checked at one time.
Further, a difficulty coefficient Wi of checking the steel structure list at one time randomly in the past is calculated according to the following formula:
Wi=[∑ n j=1 (Aj*Cj+Bj*Dj)+t]/2；
the method comprises the steps that Aj represents the number of combination functions used when the number of random steel structures is checked when a steel structure list is checked at one time in the prior art, cj represents the number of checking times of the number of corresponding steel structures, bj represents the number of the combination functions used when the weight of the random steel structures is checked when the steel structure list is checked at one time in the prior art, dj represents the weight checking times of the corresponding steel structures, the difficulty coefficient set of the steel structure list checked at k times in the prior art is obtained in the same calculation mode and is W = { W1, W2, \ 8230;, wi, \8230, wk }, the checking work of the steel structure list is completed on time by distributing personnel at k times in the prior art, the difficulty coefficient of the historical checking work is calculated by collecting working data of the steel structure list on time through a big data collection history, the purpose of calculating the difficulty coefficient of the historical checking work is to be used as the basis of judging the rationality of the number of the checking personnel distributed at the current default, the more functions needing to be combined when the number and the weight are different types are different, the larger the checking work amount is calculated, the more functions are possible, the more functions needing to be combined, the larger the checking work amount is larger, the more difficulty coefficient of the different types of the different steel structure structural members is analyzed, and the difficulty coefficient of the function analysis difficulty is improved, and the accuracy of the difficulty coefficient of the analysis result of the difficulty coefficient of the steel structure analysis is improved.
Further, according to the formula Q = [. Sigma [) m v=1 (Ev*Fv+Gv*Hv)+T]And/2, calculating a difficulty coefficient Q of the current list to be checked, wherein the current list to be checked of steel structures has m steel structures in total, fv represents the number of combined functions required when the number of random steel structures is checked, ev represents the number of times of checking the number of current corresponding steel structures, hv represents the number of combined functions required when the weight of random steel structures is checked, gv represents the number of times of checking the weight of current corresponding steel structures, the number of times of checking the current list and combined function data are counted in advance, and the difficulty coefficient of the current list to be checked is calculated to accurately analyze whether the number of currently distributed personnel is proper or not according to the checking difficulty of the current list.
Further, the distribution model creating unit creates a collation scorePreparing a model: fitting data points { (W1, M1), (W2, M2), \8230; (Wk, mk) }, resulting in a check personnel assignment function: f (x) = a1 x + a2, where a1 and a2 represent fitting coefficients, and a1= [ k ∑ e k i=1 (Wi*Mi)-∑ k i=1 Wi∑ k i=1 Mi]/[k∑ k i=1 [(Wi) 2 ]-(∑ k i=1 Wi) 2 ]，a2=(∑ k i=1 Mi-a1∑ k i=1 Wi)/k, (Wi, mi) indicates the ith data point, let x = Q, Q is substituted into the distribution function to obtain the optimal number of people currently distributed as a1 × Q + a2, a1 × Q + a2 is rounded, a1 × Q + a2 is compared with N: if a1 × Q + a2= N, judging that the number of checking personnel which are distributed by default at present is the optimal number of the checking personnel, and selecting not to adjust the checking work; if a1 x Q + a2 is not equal to N, judging that the number of checking personnel which is distributed by default at present is not the optimal number of personnel, selecting adjustment checking work, checking the steel structure list to be checked at present by utilizing the personnel whose number is distributed by the personnel distribution adjusting unit as a1 x Q + a2, and establishing an optimal checking personnel distribution model by combining the difficulty coefficient and the number of the distributing personnel into data points.
Compared with the prior art, the invention has the following beneficial effects:
according to the invention, a steel structure list is directly extracted through a 'table extraction' function of a CAD quick view picture, the steel structure type is automatically identified and judged by using an ifs function, and the list is checked by using function combination nesting of Excel software, so that the checking speed of the steel structure list is increased on the whole; the method has the advantages that the working data of checking the steel structure list is completed on time through big data acquisition history, the difficulty coefficient of the historical checking work is calculated, the difficulty coefficient is analyzed by combining the analysis of the number of different types of steel structural members, the weight checking times and the number of functions needing to be combined, the accuracy of the difficulty coefficient analysis result is improved, the optimal checking personnel distribution model is established in a mode of combining the difficulty coefficient and the number of the distributing personnel into data points, the difficulty parameter of the list to be checked can be directly substituted into the distribution model before checking, the optimal checking personnel number is favorably adjusted, and the checking labor cost waste is reduced on the premise of guaranteeing that the checking work of the steel structure list is completed in time.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings:
fig. 1 is a structural diagram of a steel structure list checking and verification management system based on big data.
Detailed description of the preferred embodiments
The preferred embodiments of the present invention will be described in conjunction with the accompanying drawings, and it will be understood that they are described herein for the purpose of illustration and explanation and not limitation.
The invention will be further described with reference to fig. 1 and the specific examples.
DETAILED DESCRIPTION OF EMBODIMENT (S) OF INVENTION
As shown in fig. 1, the present embodiment provides a steel structure list verification and verification management system based on big data, and the system includes: the system comprises a list checking and verifying module, a database, a checking information acquisition module, a checking information analysis module and a checking and verifying management module;
the output end of the list checking and verifying module is connected with the input end of the checking information acquisition module, the output end of the checking information acquisition module is connected with the input end of the database, the output end of the database is connected with the input ends of the checking information analysis module and the checking and verifying management module, and the output end of the checking information analysis module is connected with the input end of the checking and verifying management module;
the steel structure list is checked through a list checking module;
historical checking information is collected through a checking information collection module, and collected data are transmitted to a database;
storing all the collected data through a database;
analyzing the difficulty coefficient of the conventional steel structure list checking through a checking information analysis module, and selecting whether the checking work needs to be adjusted or not;
and when the checking management module selects to adjust the checking work, a proper number of list checking personnel are distributed.
The list checking and verifying module comprises a data entry unit, a steel structure identification unit and a list checking unit;
the output end of the data input unit is connected with the input end of the steel structure identification unit, and the output end of the steel structure identification unit is connected with the input end of the list checking unit;
the data entry unit is used for extracting and entering a steel structure list needing to be checked by utilizing CAD quick view software;
the steel structure identification unit is used for identifying the type of the steel structure appearing in the list by utilizing an ifs function in Excel software;
the list checking unit is used for nesting and counting the number and the weight of steel structures of different types in the list by using function combination of Excel software, and checking whether the data counted in the list is consistent with actual data.
The checking information acquisition module comprises a data volume acquisition unit, a checking person number acquisition unit and a checking time acquisition unit;
the input end of the data quantity acquisition unit is connected with the output end of the list checking unit, and the output ends of the data quantity acquisition unit, the checking person number acquisition unit and the checking time acquisition unit are connected with the input end of the database;
the data volume acquisition unit is used for acquiring the data volume to be checked when the steel structure list is checked;
the checking person number acquisition unit is used for acquiring the number of distributed checking steel structure lists;
the checking time acquisition unit is used for acquiring the time required by the distributed personnel for checking the finished steel structure list.
The verification information analysis module comprises a verification difficulty analysis unit and a distribution model establishing unit;
the input end of the checking difficulty analysis unit is connected with the output end of the database, and the output end of the checking difficulty analysis unit is connected with the input end of the distribution model establishing unit;
the checking difficulty analysis unit is used for analyzing the difficulty coefficient of the conventional steel structure list to be checked and analyzing the difficulty coefficient of the current list to be checked;
the distribution model establishing unit is used for establishing a collation person distribution model.
The checking and checking management module comprises a checking and adjusting selection unit and a personnel distribution and adjusting unit;
the input end of the checking, adjusting and selecting unit is connected with the output end of the distribution model establishing unit, and the output end of the checking, adjusting and selecting unit is connected with the input end of the personnel distribution adjusting unit;
the checking, adjusting and selecting unit is used for judging whether the number of checking personnel distributed by default at present is proper or not, and selecting and adjusting the checking work of the current steel structure list when the number is judged to be improper;
and the personnel distribution adjusting unit is used for distributing proper quantity of personnel to carry out steel structure list checking work.
When a data quantity acquisition unit is used for acquiring that the number of steel structures in different types is checked at random once in the past, the number set of the used combination functions is A = { A1, A2, A3} = {2,3,4}, the number checking order set is C = { C1, C2, C3} = {20, 18, 16}, the number set of the used combination functions for checking the weight of the different types of structures is B = { B1, B2, B3} = {2, 4}, the weight checking order set is D = { D1, D2, D3} = {10,8,9}, wherein N =3 steel structures are identified in the corresponding checking time, and the number checking order set required for acquiring the list of the steel structures to be checked at present is E = { E1, E2, E3}, 15, 12, 10, = { E1 }, E2, E3}, 15, 12, 10, = the method comprises the following steps that a number set of combination functions required when the number of different types of steel structures is checked currently is F = { F1, F2, F3} = {4,2,3}, a number set of weight checking times required currently is G = { G1, G2, G3} = {8,9, 10}, a number set of combination functions required when the weight of different types of structures is checked currently is H = { H1, H2, H3} = {4,2,4}, a checking person number collection unit is used for collecting a number set of checking persons distributed for k =3 times in the past is M = { M1, M2, M3} = {3, 4}, N persons are distributed to check a list of steel structures to be checked currently, a check time collection unit is used for collecting the limiting time of the list of the previous random checking completion steel structures which is T =3, the limiting time of the list of the current checking completion steel structures is T =3, and the unit is: day;
according to the formula Wi = [. Sigma ] n j=1 (Aj*Cj+Bj*Dj)+t]The difficulty coefficient Wi =125 of the conventional random primary check steel structure list is calculated, wherein Aj represents the number of combined functions used for checking the number of random steel structures when the steel structure list is randomly checked in the prior art, cj represents the number of times of checking the number of corresponding steel structures, bj represents the number of combined functions used for checking the weight of random steel structures when the steel structure list is randomly checked in the prior art, dj represents the number of times of checking the weight of corresponding steel structures, the difficulty coefficient set of the conventional k =3 times of checking the steel structure list is obtained through the same calculation mode and is combined into W = { W1, W2, W3} = {125, 150, 100}, and all the persons distributed for the conventional k times complete the checking work of the steel structure list on time.
According to the formula Q = [. Sigma ] m v=1 (Ev*Fv+Gv*Hv)+T]And/2, calculating a difficulty coefficient Q =104 of the current list to be checked, wherein the current list to be checked has m =3 types of steel structures in total, fv represents the number of the combination functions required when the number of random steel structures is checked, ev represents the number of times of checking the number of the current corresponding type of steel structures, hv represents the number of the combination functions required when the weight of the random steel structures is checked, and Gv represents the number of times of checking the weight of the current corresponding type of steel structures.
A collation person assignment model is established by an assignment model establishment unit: fitting data points { (W1, M1), (W2, M2), (W3, M3) } { (125, 3), (150, 2), (100, 4) } to obtain a check personnel assignment function: f (x) = a1 × x + a2, where a1 and a2 represent fitting coefficients, a1= [ k ∑ e k i=1 (Wi*Mi)-∑ k i=1 Wi∑ k i=1 Mi]/[k∑ k i=1 [(Wi) 2 ]-(∑ k i= 1 Wi) 2 ]=0.04，a2=(∑ k i=1 Mi-a1∑ k i=1 Wi)/k = -2, (Wi, mi) denotes the ith data point, let x = Q =104, substituting Q into the distribution function, resulting in the optimal number of people currently distributed as a1 x Q + a2=2, rounding a1 x Q + a2, comparing a1 x Q + a2 with N: if a1 × Q + a2= N, judging that the number of checking personnel which are distributed by default at present is the optimal number of the checking personnel, and selecting not to adjust the checking work;
for example: currently, N =2 persons are allocated to check a steel structure list to be checked, a1 × Q + a2= N =2, the number of checking persons which are currently allocated in a default mode is judged to be the optimal number of persons, and checking work is selected not to be adjusted;
if a1 x Q + a2 is not equal to N, judging that the number of checking personnel which are allocated by default at present is not the optimal number of personnel, selecting adjustment checking work, and checking the list of the steel structure to be checked at present by utilizing the personnel whose number is a1 x Q + a2 and allocated by a personnel allocation adjusting unit;
for example: currently, N =1 persons are allocated to check a steel structure list to be checked, a1 × Q + a2 is not equal to N, the number of checking persons which are currently allocated in a default mode is judged to be the number of non-optimal persons, and the checking work is selected to be adjusted: and distributing two persons by using the personnel distribution and adjustment unit to check the current steel structure list to be checked.
Finally, it should be noted that: although the present invention has been described in detail with reference to the foregoing embodiments, it will be apparent to those skilled in the art that changes may be made in the embodiments and/or equivalents thereof without departing from the spirit and scope of the invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (3)
1. The utility model provides a steel construction manifest verification check management system based on big data which characterized in that: the system comprises: the system comprises a list checking and verifying module, a database, a checking information acquisition module, a checking information analysis module and a checking and verifying management module;
the output end of the list checking and verifying module is connected with the input end of the checking information acquisition module, the output end of the checking information acquisition module is connected with the input end of the database, the output end of the database is connected with the input ends of the checking information analysis module and the checking and verifying management module, and the output end of the checking information analysis module is connected with the input end of the checking and verifying management module;
checking the steel structure list through the list checking and verifying module;
historical checking information is collected through the checking information collection module, and collected data are transmitted to the database;
storing all collected data through the database;
the difficulty coefficient of the conventional steel structure list checking is analyzed through the checking information analysis module, and whether the checking work needs to be adjusted or not is selected;
when the checking and verifying management module selects the checking work needing to be adjusted, a proper number of list checking personnel are distributed;
the list checking and verifying module comprises a data entry unit, a steel structure identification unit and a list checking unit;
the output end of the data entry unit is connected with the input end of the steel structure identification unit, and the output end of the steel structure identification unit is connected with the input end of the list checking unit;
the data entry unit is used for extracting and entering a steel structure list needing checking by using quick view software;
the steel structure identification unit is used for identifying the type of the steel structure appearing in the list by utilizing an ifs function in Excel software;
the list checking unit is used for nesting and counting the number and the weight of steel structures of different types in the list by using function combination of Excel software, and checking whether the data counted in the list is consistent with actual data or not;
the checking information analysis module comprises a checking difficulty analysis unit and a distribution model establishing unit;
the input end of the checking difficulty analysis unit is connected with the output end of the database, and the output end of the checking difficulty analysis unit is connected with the input end of the distribution model establishing unit;
the checking difficulty analysis unit is used for analyzing the difficulty coefficient of the conventional steel structure list to be checked and analyzing the difficulty coefficient of the current list to be checked;
the distribution model establishing unit is used for establishing a verifier distribution model;
the method comprises the steps of utilizing a data quantity acquisition unit to acquire a combination function number set of A = { A1, A2, \8230;, an } which is utilized when the number of different types of steel structures is checked at one time randomly in the past, wherein the combination function number set of C = { C1, C2, \8230;, cn } which is utilized when the number of the different types of steel structures is checked, the combination function number set of B = { B1, B2, \8230;, bn } which is utilized when the weight of the different types of structures is checked, the weight checking number set of D = { D1, D2, \\ 8230;, dn }, wherein N types of steel structures are identified in total corresponding to checking, the number checking number set required in the list of the steel structures to be checked at present is acquired and is E = { E1, E2, \\ 8230;, em } which is required when the number of the steel structures is checked at present, and the number of the combination function set required in the number of the steel structures is checked at present is F = { F1' =, F2, \ 8230;, fm }, wherein the currently required number set of weight checking times is G = { G1, G2, \8230;, gm }, and the currently required number set of combination functions for checking the weights of different types of structures is H = { H1, H2, \8230;, hm }, wherein M represents the number of steel structure types in the currently to-be-checked steel structure list, the number set of checked people distributed k times in the past is acquired by using a checking number acquisition unit to be M = { M1, M2, \8230;, mk }, N people are currently distributed to check the to-be-checked steel structure list, the limiting time of the former random one-time checking completion steel structure list is acquired by using a checking time acquisition unit to be T, and the limiting time of the currently checking completion steel structure list is T;
calculating the difficulty coefficient Wi of the conventional random one-time check of the steel structure list according to the following formula:
Wi=[∑ n j=1 (Aj*Cj+Bj*Dj)+t]/2；
the method comprises the steps that Aj represents the number of combination functions used when the number of a random type of steel structures is checked when a steel structure list is checked at one time in the prior art, cj represents the number of checking times of the number of corresponding type of steel structures, bj represents the number of combination functions used when the weight of the random type of steel structures is checked when the steel structure list is checked at one time in the prior art, dj represents the weight checking times of the corresponding type of steel structures, and the difficulty coefficient set of the steel structure list checked at k times in the prior art is obtained in the same calculation mode and is W = { W1, W2, \ 8230;, wi, \8230, wk }, wherein the checking work of the steel structure list is completed by staff distributed at k times in the prior art;
according to the formula Q = [. Sigma ] m v=1 (Ev*Fv+Gv*Hv)+T]Calculating a difficulty coefficient Q of a current list to be checked, wherein m steel structures are shared in the current list to be checked, fv represents the number of combined functions required when the number of random steel structures is checked currently, ev represents the number of times of checking the number of current corresponding steel structures, hv represents the number of combined functions required when the weight of random steel structures is checked currently, and Gv represents the number of times of checking the weight of current corresponding steel structures;
establishing a collation staff allocation model by using the allocation model establishing unit: fitting data points { (W1, M1), (W2, M2), \8230; (Wk, mk) }, resulting in a check personnel assignment function: f (x) = a1 × x + a2, where a1 and a2 represent fitting coefficients, where:
a1=[k∑ k i=1 (Wi*Mi)-∑ k i=1 Wi∑ k i=1 Mi]/[k∑ k i=1 [(Wi) 2 ]-(∑ k i=1 Wi) 2 ]；
a2=(∑ k i=1 Mi-a1∑ k i=1 Wi)/k；
(Wi, mi) represents the ith data point, let x = Q, and substitute Q into the distribution function to get the best number of people currently distributed as a1 x Q + a2, round a1 x Q + a2, compare a1 x Q + a2 with N: if a1 × Q + a2= N, judging that the number of checking personnel which are distributed by default at present is the optimal number of the checking personnel, and selecting not to adjust the checking work; if a1 x Q + a2 is not equal to N, judging that the number of checking personnel which are allocated by default at present is not the optimal number of personnel, selecting adjustment checking work, and checking the list of the steel structures to be checked at present by utilizing the personnel whose number is a1 x Q + a2 and allocated by the personnel allocation adjusting unit.
2. The steel structure list checking and verification management system based on big data as claimed in claim 1, wherein: the checking information acquisition module comprises a data volume acquisition unit, a checking person number acquisition unit and a checking time acquisition unit;
the input end of the data quantity acquisition unit is connected with the output end of the list checking unit, and the output ends of the data quantity acquisition unit, the checking person number acquisition unit and the checking time acquisition unit are connected with the input end of the database;
the data volume acquisition unit is used for acquiring the data volume to be checked when the steel structure list is checked;
the checking people number acquisition unit is used for acquiring the number of distributed checking steel structure list people;
the checking time acquisition unit is used for acquiring the time required by the distributed personnel for checking the steel structure list.
3. The steel structure list checking and checking management system based on big data as claimed in claim 1, wherein: the checking and verifying management module comprises a checking and adjusting selection unit and a personnel distribution and adjusting unit;
the input end of the checking, adjusting and selecting unit is connected with the output end of the distribution model establishing unit, and the output end of the checking, adjusting and selecting unit is connected with the input end of the personnel distribution adjusting unit;
the checking, adjusting and selecting unit is used for judging whether the number of checking personnel distributed by default at present is proper or not, and selecting and adjusting the checking work of the current steel structure list when the number is judged to be improper;
and the personnel distribution and adjustment unit is used for distributing proper quantity of personnel to carry out steel structure list checking work.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310097078.9A CN115796563B (en) | 2023-02-10 | 2023-02-10 | Steel structure list checking and verifying management system based on big data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310097078.9A CN115796563B (en) | 2023-02-10 | 2023-02-10 | Steel structure list checking and verifying management system based on big data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115796563A CN115796563A (en) | 2023-03-14 |
| CN115796563B true CN115796563B (en) | 2023-04-11 |
Family
ID=85430834
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310097078.9A Active CN115796563B (en) | 2023-02-10 | 2023-02-10 | Steel structure list checking and verifying management system based on big data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115796563B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117350521B (en) * | 2023-12-05 | 2024-02-13 | 江苏臻云技术有限公司 | Operation and maintenance duty management system and method based on big data analysis |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2008287444A (en) * | 2007-05-16 | 2008-11-27 | Chugoku Electric Power Co Inc:The | Repair staff calling system, method and program |
| JP2014191390A (en) * | 2013-03-26 | 2014-10-06 | Hitachi Systems Ltd | System and method for automatically assigning worker |
| CN106682743A (en) * | 2016-12-15 | 2017-05-17 | 南京南瑞信息通信科技有限公司 | Operation and maintenance work order scheduling management method and system in electric power telecommunication field |
| CN107784424A (en) * | 2017-06-26 | 2018-03-09 | 平安科技（深圳）有限公司 | Task management method, device, computer equipment and storage medium |
| CN108228618A (en) * | 2016-12-14 | 2018-06-29 | 平安科技（深圳）有限公司 | The method and apparatus of document verification of data |
| CN110288220A (en) * | 2019-06-19 | 2019-09-27 | 徐州工业职业技术学院 | A kind of construction management platform based on BIM |
| CN111626033A (en) * | 2020-05-22 | 2020-09-04 | 广东电网有限责任公司 | Method, device, equipment and medium for checking fixed value |
| CN112101815A (en) * | 2020-09-25 | 2020-12-18 | 贵州电网有限责任公司 | Construction management visualization system for capital construction distribution network project |
| CN113537797A (en) * | 2021-07-23 | 2021-10-22 | 中信银行股份有限公司 | Method and device for intelligent test workload assessment based on historical data analysis, terminal equipment and storage medium |
| CN113947392A (en) * | 2021-12-22 | 2022-01-18 | 浙江力嘉电子科技有限公司 | Abnormity determining method and device in traffic data auditing task |
| CN114116182A (en) * | 2022-01-28 | 2022-03-01 | 南昌协达科技发展有限公司 | Disinfection task allocation method and device, storage medium and equipment |
| CN114331377A (en) * | 2021-12-30 | 2022-04-12 | 中铁二局集团电务工程有限公司 | Project management system for counting by point location engineering quantity list |
| CN114529149A (en) * | 2022-01-07 | 2022-05-24 | 南方电网深圳数字电网研究院有限公司 | Intelligent control method and device for work rhythm quantification |
| CN114782030A (en) * | 2022-06-24 | 2022-07-22 | 硕广达微电子(深圳)有限公司 | Intelligent management system and method based on big data project |
| CN115496362A (en) * | 2022-09-22 | 2022-12-20 | 中新华都国际工程咨询有限公司 | Engineering supervision project evaluation system and method based on big data |
-
2023
- 2023-02-10 CN CN202310097078.9A patent/CN115796563B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2008287444A (en) * | 2007-05-16 | 2008-11-27 | Chugoku Electric Power Co Inc:The | Repair staff calling system, method and program |
| JP2014191390A (en) * | 2013-03-26 | 2014-10-06 | Hitachi Systems Ltd | System and method for automatically assigning worker |
| CN108228618A (en) * | 2016-12-14 | 2018-06-29 | 平安科技（深圳）有限公司 | The method and apparatus of document verification of data |
| CN106682743A (en) * | 2016-12-15 | 2017-05-17 | 南京南瑞信息通信科技有限公司 | Operation and maintenance work order scheduling management method and system in electric power telecommunication field |
| CN107784424A (en) * | 2017-06-26 | 2018-03-09 | 平安科技（深圳）有限公司 | Task management method, device, computer equipment and storage medium |
| CN110288220A (en) * | 2019-06-19 | 2019-09-27 | 徐州工业职业技术学院 | A kind of construction management platform based on BIM |
| CN111626033A (en) * | 2020-05-22 | 2020-09-04 | 广东电网有限责任公司 | Method, device, equipment and medium for checking fixed value |
| CN112101815A (en) * | 2020-09-25 | 2020-12-18 | 贵州电网有限责任公司 | Construction management visualization system for capital construction distribution network project |
| CN113537797A (en) * | 2021-07-23 | 2021-10-22 | 中信银行股份有限公司 | Method and device for intelligent test workload assessment based on historical data analysis, terminal equipment and storage medium |
| CN113947392A (en) * | 2021-12-22 | 2022-01-18 | 浙江力嘉电子科技有限公司 | Abnormity determining method and device in traffic data auditing task |
| CN114331377A (en) * | 2021-12-30 | 2022-04-12 | 中铁二局集团电务工程有限公司 | Project management system for counting by point location engineering quantity list |
| CN114529149A (en) * | 2022-01-07 | 2022-05-24 | 南方电网深圳数字电网研究院有限公司 | Intelligent control method and device for work rhythm quantification |
| CN114116182A (en) * | 2022-01-28 | 2022-03-01 | 南昌协达科技发展有限公司 | Disinfection task allocation method and device, storage medium and equipment |
| CN114782030A (en) * | 2022-06-24 | 2022-07-22 | 硕广达微电子(深圳)有限公司 | Intelligent management system and method based on big data project |
| CN115496362A (en) * | 2022-09-22 | 2022-12-20 | 中新华都国际工程咨询有限公司 | Engineering supervision project evaluation system and method based on big data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115796563A (en) | 2023-03-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110610318B (en) | Engineering cost management system based on big data | |
| CN115796563B (en) | Steel structure list checking and verifying management system based on big data | |
| Navon et al. | Can labor inputs be measured and controlled automatically? | |
| CN113407651B (en) | Progress information feedback and deviation real-time display method | |
| CN105631600A (en) | Method and system for publishing auto insurance survey tasks | |
| CN115619134B (en) | Engineering service-based mechanic platform construction method and system | |
| CN113361816A (en) | One set of customer service staff scheduling system | |
| CN116579590B (en) | Demand response evaluation method and system in virtual power plant | |
| Thompson | Accounting for the multi-period impact of service when determining employee requirements for labor scheduling | |
| Allen et al. | Mitigating voter waiting times | |
| CN111898971A (en) | Wisdom building site peasant salary guarantee management platform | |
| US6353769B1 (en) | Method for allocating lot priority by ranking lots as a function of budget queue time in a manufacturing control system | |
| CN113656505A (en) | Digitalization of distributed project management system and method for synchronizing data thereof | |
| CN111028013A (en) | Method for evaluating construction cost of proposed construction of rail transit station | |
| CN111553633A (en) | Engineering cost management system and method | |
| CN115564257A (en) | Digital production process scheduling management system | |
| CN111260161A (en) | Method and device for issuing crowdsourcing tasks | |
| CN116757632B (en) | Project progress information monitoring method | |
| Armony et al. | Asymptotically optimal appointment schedules | |
| CN112200499A (en) | Power distribution network infrastructure project investment execution analysis method and system | |
| CN113344443B (en) | Project process analysis and evaluation system and method based on big data | |
| JPH10254962A (en) | Group-based work capability correction device and work allocation system | |
| CN113420960B (en) | Method, system and storage medium for dispatching working personnel of highway toll station | |
| CN114997532A (en) | Civil telephone delivery scheduling method under uncertain environment, terminal and storage medium | |
| Hadad et al. | How to correctly perform a work sampling |
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 |