Methods, systems, devices and methods of use for generating quality certificate blank table and writing project profile

Abstract

The invention discloses a method for generating a quality certificate empty list and writing in a project general situation, which comprises the following steps: setting and correspondingly inputting a starting date, an ending date and variables of a path where a folder is located of a quality certificate, and iteratively generating an m-day quality certificate; a production log is imported, if the production log exists on the current day, a quality certificate of the current day is made, and if the production log does not exist on the current day, a quality certificate of the next day is made; judging whether a production log exists on the day or not, and if yes, reading the single-line number n of the task; importing an intensity record, and reading a task order number; iteratively generating quality certificates from the first row to the nth row of the task order, and judging whether the ith row of task order generates the quality certificate or not; and correspondingly writing the information of the (i + 3) th row of the production log into the corresponding position of the quality certificate. The invention further discloses a system, equipment and a using method for generating the quality certificate empty list and writing the quality certificate empty list into the project general situation. According to the method, the labor cost can be effectively saved, and the quality certificate empty table generation efficiency and the project general situation writing efficiency are improved.

Description

Technical Field

[0001] The present application relates to the technical field of building materials, and in particular to a method, system, device and use method for generating a blank form of a quality certificate and writing a project profile. Background Art

[0002] The quality certificate issued by the concrete mixing plant is a factory quality certificate for concrete. It records the relevant technical parameters and quality test results of the concrete to ensure that the concrete meets the predetermined quality standards. The use and production of this certificate follows technical standards such as "Ready-mixed Concrete" (GB14902-2012), which ensure the quality and safety of concrete, thereby ensuring the stability and durability of the building structure.

[0003] Generally, each construction unit-project name-project part-strength grade corresponds to a task list, and this task list must produce a quality certificate. A medium to small concrete production enterprise will produce about 14 quality certificates a day and about 98 quality certificates a week, which is a heavy workload; referring to the production log, the project profile is written in the quality certificate, there is a lot of repetitive work, and the work efficiency is low. The above reasons cause the internal laboratory testers of concrete production enterprises to spend a lot of time preparing materials, which seriously compresses the actual testing time and increases the human cost of the enterprise. Summary of the invention

[0004] The purpose of the present invention is to overcome the deficiencies in the above-mentioned prior art and provide a method, system, device and use method for generating a blank form of a quality certificate and writing an engineering profile. By programming in Matlab software, the blank form of the quality certificate can be automatically generated and the engineering profile can be written, thereby improving the efficiency of generating the blank form of the quality certificate and saving labor costs.

[0005] Based on the above invention objectives, the present invention provides the following technical solutions:

[0006] The method for generating a blank form of a quality certificate and writing a project profile is characterized in that the method comprises the following steps:

[0007] Step S1. Set the variables of the start date, end date, and folder path of the quality certificate in Matlab software, and input the start date, end date, and folder path of the quality certificate accordingly, and then use the for date loop structure to iteratively generate a quality certificate for a total of m days from the start date to the end date;

[0008] Step S2. In the for date loop structure, use the try-catch structure to import the production log. If the program for importing the production log of the day runs normally, that is, there is a production log on that day, then make a quality certificate for that day. If an error occurs in the program for importing the production log of the day, that is, there is no production log on that day, then make a quality certificate for the next day.

[0009] Step S3. In the for date loop structure, after the try-catch structure ends, use the if structure to determine whether there is a production log on that day. If there is a production log on that day, read out the number of task orders n on that day;

[0010] Step S4. In the judgment structure of if there is a production log, after reading the number of task orders for the day n, use the detectImportOptions function to import the intensity record and read the task order number;

[0011] Step S5. In the judgment structure of if there is a production log, after reading the task order number, the for task order loop structure is used to iteratively generate the quality certificate of the task order from the first row to the nth row. In the for task order loop structure, the if structure is used to determine whether the quality certificate is generated for the task order in the i-th row;

[0012] Step S6. In the if structure that determines whether a quality certificate is generated for the task order in the i-th row, use the xlswrite function to write the task order number, construction unit, project name, project location, supply quantity, supply date, and strength grade of the (i+3)th row of the production log into the corresponding cells of the quality certificate Excel table one by one.

[0013] Furthermore, in the step S3, the method for reading out the number of task order rows n of the day is: in the while loop structure, use the if structure to determine in turn whether each row of the intensity level column of the production log is empty. If it is not empty, n is accumulated by 1, and the initial value of n is 0. If it is empty, the while loop ends, and the number of task order rows n of the production log of the day can be determined; specifically: set the intensity level column to a matrix variable bb, set the initial judgment criterion judge to 1, set the initial cumulative sum value to 0, and use judge=1 as the condition of the while loop. In the while loop structure, use the n+4th element of bb=empty as the criterion to construct an if structure. If it is empty, judge=0, and if it is not empty, n is accumulated by 1.

[0014] Further, in the step S5, the method for determining whether the task order in the i-th row generates a quality certificate is as follows: construct tt1=the specimen number in the (i+3)th row of the production log is empty, tt2=the number of the task order number in the (i+3)th row of the production log that is the same as that in the strength report is 0, tt3=the task order number in the (i+3)th row of the production log is empty, tt4=the number in the (i+3)th row of the production log has 'not done', ttj=tt1 or tt2 or tt3 or tt4, if ttj=0, then set the variable of the quality certificate equal to the path plus the name of the quality certificate to generate a quality certificate, and name it in the format of 'quality certificate yyyy-mm-dd_task order number_i', and use the copyfile function to copy the 'quality certificate template' to 'quality certificate yyyy-mm-dd_task order number_i', if ttj≠0, then do not generate a quality certificate, that is, as long as one of the four situations occurs, do not generate a quality certificate.

[0015] The present invention also provides a system for generating a blank form of a quality certificate and writing the project profile, which is used to execute a method for generating a blank form of a quality certificate and writing the project profile. The system comprises an input module, an import and read module, a generation and write module and an output module;

[0016] The input module is used to input the folder path and supply date of the quality certificate;

[0017] The import and read module is used to import production logs;

[0018] The generating and writing module is used to generate a blank form of the quality certificate and write the engineering overview;

[0019] The output module is used to output the quality certificate Excel document.

[0020] The present invention also provides a computer device, which includes an input device, a processor, a memory and an output device, wherein the memory stores a computer program that can be loaded by the processor and execute a method for generating a blank form of a quality certificate and writing an engineering overview.

[0021] The present invention also provides a method for using the system for generating a blank quality certificate table and writing a project profile, the method comprising the following steps: Step T1: copying the quality certificate template, production log, and strength record into the quality certificate folder;

[0022] Step T2: Update production log and strength record;

[0023] Step T3: Set the quality certificate template, issue date = supply date + 28;

[0024] Step T4: Open Matlab, input the start date, end date, and the folder path where the quality certificate is located, start the system, and automatically generate the quality certificate; manually write the mix ratio and quality assurance certificate, strength value, test piece number, report number, chloride ion content, and impermeability number in the quality certificate;

[0025] Step T5: Print, sign and stamp.

[0026] Based on the above technical solution, the present invention has the following advantages compared with the prior art:

[0027] 1. In Matlab software, users can input the start date, end date, and folder path of the quality certificate. Visual and interactive programming is helpful for users to generate quality certificates of any date. The background automatically outputs m days and z quality certificates, saving the time of opening each Excel document one by one when manually making quality certificates.

[0028] 2. For the date loop value = start date to end date, iteratively generate the quality certificate for m days, which can ensure that the quality certificate is generated in an orderly and efficient manner. When the start date and end date are the same day, a quality certificate for any day can be generated. Determine whether an exception occurs when importing production logs, which can ensure that if there is no production log on a certain day, the quality certificate for the subsequent date is automatically generated instead of the program pausing.

[0029] 3. For i=1 to n, iteratively generate n quality certificates for a certain day. You can also input, for example, for i=3:3 to generate a quality certificate for the third task order on a certain day.

[0030] 4. "M-day cycle, if there is a production log, n-task order cycle, i-th task order" forms four layers of nesting, which is the overall idea of ​​generating quality certificates, clear and efficient. And only two parameters, start date and end date, are input to quickly obtain a large number of quality certificates; by changing the start date, end date, and the task order sequence number i of the day, a quality certificate for any order on any day can be generated.

[0031] 5. While (loop) nests if (judgment) to judge whether the strength level of the first line of the production log is empty, until the strength level of the nth line is empty, and the loop ends. While contains if, and the conclusion generated by the if structure is used as the condition of the while loop in turn, which can automatically count the number of task orders for the day. First use the while loop to determine n, and then use the for loop to define the variable i to generate quality certificates from 1 to n, instead of using the traditional method to generate quality certificates from the initial value of n (0) to the final cumulative value of n (total number of task orders) in the while loop. The program is simple and less prone to exceptions, because the writing procedure for each quality certificate is very complicated.

[0032] 6. Use the logic of not, or, and not, double negation, to determine whether the quality certificate is generated. When generating an empty table of quality certificates, determine whether to generate the quality certificate. There are four situations in which the certificate is not generated: the test piece number is empty, the number of the same task order number in the production log and the strength report is 0, the task order number is empty, and the quantity has "not done". Use the logic of not, or, and not to determine whether the quality certificate is generated. (Negation) First list the four situations in which the certificate is not generated: tt1 = ... is empty, tt2 = ... the same number is 0, tt3 = ... is empty, tt4 = ... contains "not done"; (or) Then use the logic of or to calculate ttj: ttj = tt1 or tt2 or tt3 or tt4; (Negation) Finally, use ttj = 0 (not ttj) to judge, if yes, generate, otherwise not generate. Combined with double negation judgment and logical operation of or, the judgment that as long as one of the situations occurs, it will not be generated, thereby intelligently judging whether the quality certificate is generated. The difference between the present application and the traditional method is that the formula ttj is constructed, and a quality certificate is generated when ttj=0; the traditional method is a direct translation of "if one of the four situations occurs, a quality certificate will not be generated, and if none of the four situations occurs, a quality certificate will be generated", and the steps are cumbersome.

[0033] 7. First determine whether there is a production log (import the production log of a certain day. If the program is abnormal, there will be no production log on this day). If so, determine how many lines of task orders there are in the production log of this day (determine according to the strength level number of the 4th to nth lines), and finally determine whether to generate a quality certificate (list four situations in which it is not generated, or the logical calculation ttj, use ttj=0 to judge, if yes, generate it), triple judgment, automatically generate a blank table of quality certificates.

[0034] 8. The traditional method can manually generate 4 blank quality certificate forms in 1 minute, and it takes 25 minutes to make 98 quality certificates in a week. The present invention can automatically generate 600 blank quality certificate forms in 1 minute, and it takes 10 seconds to generate 98 blank quality certificate forms in a week.

[0035] 9. The traditional method takes 2 minutes to manually copy the engineering profile of one quality certificate, and it takes 3 hours and 16 minutes to make 98 quality certificates in a week. The present invention automatically writes the engineering profile of 30 quality certificates in 1 minute, and it takes 3 minutes and 4 seconds to write the engineering profile of 98 quality certificates in a week. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] Figure 1 It is a schematic diagram of the workflow of the present invention.

[0037] Figure 2 Logic diagram for counting the number of task orders n for the day

[0038] Figure 3It is a schematic diagram of the structure of the system of the present invention.

[0039] Figure 4 It is a schematic diagram of the structure of the computer device of the present invention.

[0040] Figure 5 It is a schematic diagram of the system usage interface in the present invention. DETAILED DESCRIPTION

[0041] In order to make the purpose, technical scheme and advantages of the present invention clearer, the present invention is described below by means of the accompanying drawings and the specific examples shown. However, it should be understood that these descriptions are only exemplary and are not intended to limit the scope of the present invention. In addition, in the following description, the description of well-known structures and technologies is omitted to avoid unnecessary confusion of the concept of the present invention.

[0042] The strength record described in the present invention is not the original record of strength detection, but an electronic version of the strength registration ledger summary table, the column headings of which are the concrete task order number, test piece number, sample delivery date, construction unit, project name, construction location, strength grade, strength report number, and strength. The one prepared manually in advance is called a strength record, and the one imported into the matlab background is called a strength report, and the contents of the two are exactly the same.

[0043] Example 1

[0044] This embodiment provides a method for generating a blank quality certificate table and writing the project profile. Figure 1 As shown, the following steps are included:

[0045] S1, assign the start date, end date, and folder path of the quality certificate to the corresponding variables, and use the for loop structure to iteratively generate the quality certificate from the start date to the end date, for a total of m days;

[0046] S2, in the for date loop structure, use the try-catch structure to import the production log. If the program for importing the production log of the day runs normally, that is, there is a production log on that day, then the quality certificate for that day is produced. If the program for importing the production log of the day fails, that is, there is no production log on that day, then the quality certificate for the next day is produced.

[0047] S3, under the try-catch structure, use the if structure to determine whether there is a production log on that day. In the "if there is a production log on that day" judgment structure, read out the number of task orders n on that day. In the while loop structure, use the if structure to determine whether each row of the strength level column of the production log is empty. If not, n is accumulated by 1, and the initial value of n is 0. If it is empty, the while loop ends, that is, it is determined how many rows of task orders there are in the production log on that day (based on the strength level numbers of the 4th to nth rows). Specifically, set the strength level column to a matrix variable bb, set the initial criterion judge to 1, set the initial cumulative sum value to 0, and use judge = 1 as the condition of the while loop. In the while loop structure, use the n+4th element of bb = empty as the criterion to construct an if structure. If it is empty, judge = 0. If it is not empty, n is accumulated by 1. Note that each quality certificate is a factory warranty generated based on a production task order (referred to as task order);

[0048] S4, in the judgment structure of if there is a production log, after reading the number of task orders of the day n, use the detectImportOptions function to import the intensity record and read the task order number;

[0049] S5, in the judgment structure of if there is a production log, after reading the task order number, use the for task order loop structure to iteratively generate the quality certificates of the 1st task order to the nth task order, and in the for task order loop structure, use the if structure to judge whether the i-th task order generates a quality certificate, and construct tt1 = the specimen number of the (i+3)th line of the production log is empty, tt2 = the number of the same task order number in the (i+3)th line of the production log as in the strength report is 0, tt3 = the task order number of the (i+3)th line of the production log is empty, tt4 = the (i+3)th line of the production log ) The number of rows is 'not done', ttj = tt1 or tt2 or tt3 or tt4, if ttj = 0, then set the variable of the quality certificate equal to the path plus the name of the quality certificate to generate the quality certificate, named in the format of 'quality certificate yyyy-mm-dd_task order number_i', use the copyfile function to copy the 'quality certificate template' to 'quality certificate yyyy-mm-dd_task order number_i', if ttj≠0, then do not generate the quality certificate, that is, if any of the four situations occurs, do not generate the quality certificate;

[0050] S6, in the if structure that determines whether a quality certificate is generated for the task order in the i-th row, use the xlswrite function to write the task order number, construction unit, project name, project location, supply quantity, supply date, and strength grade in the (i+3)th row of the production log into the corresponding cells of the quality certificate Excel table one by one.

[0051] The nested structure of the steps in Example 1 is:

[0052]

[0053] The following conclusions can be obtained from Example 1:

[0054] Conclusion 1: In Matlab software, users can input the start date, end date, and folder path of the quality certificate. Visual and interactive programming is conducive to users generating quality certificates of any date. The background automatically outputs m days and z quality certificates, saving the time of opening each Excel document one by one when manually making quality certificates.

[0055] Conclusion 2: For date cycle value = start date to end date, iteratively generate quality certificates for m days, which can ensure that quality certificates are generated in an orderly and efficient manner. Determine whether an exception occurs when importing production logs, and ensure that there is no production log on a certain day, and automatically generate quality certificates for the following dates instead of pausing the program. You can also enter for datenumcycly = 2024-1-1:2024-1-1 to generate a quality certificate for 2024-1-1.

[0056] Conclusion 3: "m-day loop, if there is a production log, n-task order loop, if none of the four conditions, the i-th task order" forms a four-layer nesting, which is the overall idea of ​​generating quality certificates, clear and efficient. And only two parameters, the start date and the end date, are input to quickly obtain a large number of quality certificates; by changing the start date, the end date, and i, a quality certificate for any order on any day can be generated. The four-layer nesting structure is:

[0057]

[0058] Conclusion 4: while (loop) nests if (judgment) to judge whether the first row of strength level is empty, until the nth row of strength level is empty, the loop ends, while nests if, and the conclusion of the if structure is used as the condition of the while structure. First use while to determine n, and then use for to generate quality certificates from 1 to n. The program is simple and not prone to exceptions. Figure 2The right side of the negative and n = n + 1 steps add a step between the two steps to generate the quality certificate of the i-th task order, and the program is complicated. Note that since the intensity level column of the production log is continuous, when reading the number of task orders for the day n, there will be no situation where the middle is empty and the next row has an intensity level. The structure of while (loop) nested if (judgment) is:

[0059] The logic diagram of while nested if to count the number of task orders n for the day is as follows Figure 2 shown.

[0060] Conclusion 5: Take a production log from m days, and then take a row from a production log, and then start reading the engineering overview of a specific quality certificate. Note that one row of the production log corresponds to the engineering overview of a quality certificate. Note that when generating an empty table of quality certificates, judge whether to generate the quality certificate. There are four situations in which it is not generated: the specimen number is empty, the number of the same task order number in the production log and the strength report is 0, the task order number is empty, and the quantity has "not done". Use the logic of not, or, and not to judge whether the quality certificate is generated. (Negation) First, list the four situations in which it is not generated: tt1 = ... is empty (meaning ... is empty tt1 = 1), tt2 = ... is the same number is 0, tt3 = ... is empty, tt4 = ... contains "not done"; (or) Then use the logic of or to calculate ttj: ttj = tt1 or tt2 or tt3 or tt4; (Negation) Finally, use ttj = 0 (not ttj) to judge, if it is generated, it will be generated, otherwise it will not be generated. Combined with double negative judgment and logical operation of OR, the judgment that if any one of the situations occurs, the certificate will not be generated is completed, thereby intelligently judging whether the quality certificate is generated. The difference between this application and the traditional method is to construct the formula ttj, and to generate the quality certificate when ttj=0; the traditional method is a direct translation of "if any of the four situations occurs, the certificate will not be generated, and if none of the four situations occurs, the certificate will be generated", and the steps are cumbersome, as shown in Table 1.

[0061] Table 1 Differences between the traditional method and this application in determining whether a quality certificate is generated

[0062]

[0063]

[0064]

[0065] Conclusion six: First determine whether there is a production log (import the production log of a certain day. If the program is abnormal, there will be no production log on that day). If so, then determine how many lines of task orders there are in the production log of that day (determine according to the strength level number of the 4th to nth lines). Finally, determine whether to generate a quality certificate (list four situations in which it is not generated, or the logical calculation ttj, use ttj=0 to judge, if yes, generate it), triple judgment, automatically generate a blank table of quality certificates.

[0066] like Figure 3 As shown, the present invention also provides a system for generating a blank form of a quality certificate and writing a project profile, which is used to execute a method for generating a blank form of a quality certificate and writing a project profile. The system includes an input module, an import and read module, a generation and write module, and an output module;

[0067] The input module is used to input the folder path and supply date of the quality certificate;

[0068] The import and read module is used to import production logs;

[0069] The generating and writing module is used to generate a blank form of the quality certificate and write the engineering overview;

[0070] The output module is used to output the quality certificate Excel document.

[0071] like Figure 4 As shown, the present invention also provides a computer device, which includes an input device, a processor, a memory and an output device. The processor includes an arithmetic unit and a controller. The arithmetic unit is used to execute the program in each small box, and the controller is used to determine the execution order. The memory stores a computer program that can be loaded by the processor and executes a method for generating a blank table of a quality certificate and writing an engineering overview.

[0072] The present invention also provides a method for using the system for generating a blank quality certificate table and writing a project profile, the method comprising the following steps: Step T1: copying the quality certificate template, production log, and strength record into the quality certificate folder;

[0073] Step T2: Update the production log;

[0074] Step T3: Set the quality certificate template, issue date = supply date + 28;

[0075] Step T4: Open Matlab, input the start date, end date, and the folder path where the quality certificate is located, start the system, and automatically generate the quality certificate; manually input the mix ratio and quality assurance certificate, strength value, specimen number, report number, chloride ion content, and impermeability number;

[0076] Step T5: Print, sign and stamp.

[0077] Comparative Example 1

[0078] This comparative example provides a method for manually generating a blank quality certificate table. The method for manually generating a blank quality certificate table includes: based on the previous quality certificate Excel, click File, Save As, select the folder location to save, and enter the file name as 'Quality Certificate yyyymmdd_XXXX_i'. As a result, 4 blank quality certificate tables can be manually generated in 1 minute, so it takes 25 minutes to make 98 quality certificates a week (generally 14 a day).

[0079] In the first embodiment, steps S1 to S6 can automatically generate a blank quality certificate list. As a result, 10 blank quality certificate lists can be automatically generated in 1 second, and 600 blank quality certificate lists can be automatically generated in 1 minute. Therefore, it takes 10 seconds to generate 98 blank quality certificate lists in one week.

[0080] Comparative Example 2

[0081] This comparative example provides a method for manually writing the project overview in the quality certificate. When manually writing the project overview in the quality certificate, write the number, purchasing unit, project name and location, supply quantity, supply date, strength grade and variety, and mix ratio number according to the production log. The issuance date is automatically generated. As a result, it takes 2 minutes to manually copy the project overview of one quality certificate, so it takes 3 hours and 16 minutes to make 98 quality certificates in a week.

[0082] In the embodiment 1, step S6 can automatically write the engineering profile in the quality certificate. As a result, the engineering profiles of 30 quality certificates are automatically written in 1 minute, so it takes 3 minutes and 4 seconds to write the engineering profiles of 98 quality certificates in one week.

[0083] Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the preferred embodiments, ordinary technicians in the field should understand that the specific implementation methods of the invention can still be modified or some technical features can be replaced by equivalents without departing from the spirit of the technical solution of the present invention, which should be included in the scope of the technical solution for protection of the present invention.

Claims

1. A method for generating a blank quality certificate table and writing a project profile, characterized in that: The method comprises the following steps: Step S1. Set the variables of the start date, end date, and folder path of the quality certificate in Matlab software, and input the start date, end date, and folder path of the quality certificate accordingly, and then use the for date loop structure to iteratively generate a quality certificate for a total of m days from the start date to the end date; Step S2. In the for date loop structure, use the try-catch structure to import the production log. If the program for importing the production log of the day runs normally, that is, there is a production log on that day, then make a quality certificate for that day. If an error occurs in the program for importing the production log of the day, that is, there is no production log on that day, then make a quality certificate for the next day. Step S3. In the for date loop structure, after the try-catch structure ends, use the if structure to determine whether there is a production log on that day. If there is a production log on that day, read out the number of task orders n on that day; Step S4. In the judgment structure of if there is a production log, after reading the number of task orders for the day n, use the detectImportOptions function to import the intensity record and read the task order number; Step S5. In the judgment structure of if there is a production log, after reading the task order number, the for task order loop structure is used to iteratively generate the quality certificate of the task order from the first row to the nth row. In the for task order loop structure, the if structure is used to determine whether the quality certificate is generated for the task order in the i-th row; Step S6. In the if structure that determines whether a quality certificate is generated for the task order in the i-th row, use the xlswrite function to write the task order number, construction unit, project name, project location, supply quantity, supply date, and strength grade of the (i+3)th row of the production log into the corresponding cells of the quality certificate Excel table one by one.

2. A method for generating a blank form of a quality certificate and writing a project overview according to claim 1, characterized in that: In step S3, the method of reading out the number of task order rows n for the day is: in the while loop structure, use the if structure to sequentially determine whether each row of the intensity level column of the production log is empty. If it is not empty, n is accumulated by 1, and the initial value of n is 0. If it is empty, the while loop ends, and the number of task order rows n of the production log for the day can be determined. Specifically, the intensity level column is set as a matrix variable bb, the initial criterion judge is set to 1, the initial cumulative sum value is set to 0, and judge=1 is used as the condition of the while loop. In the while loop structure, the if structure is constructed with the n+4th element of bb=empty as the criterion. If it is empty, judge=0, and if it is not empty, n is accumulated by 1.

3. A method for generating a blank form of a quality certificate and writing a project overview according to claim 1, characterized in that: In the step S5, the method for judging whether the task order in the i-th row generates a quality certificate is as follows: construct tt1=the specimen number in the (i+3)th row of the production log is empty, tt2=the number of the task order number in the (i+3)th row of the production log that is the same as that in the strength report is 0, tt3=the task order number in the (i+3)th row of the production log is empty, tt4=the number in the (i+3)th row of the production log has 'not done', ttj=tt1 or tt2 or tt3 or tt4, if ttj=0, then set the variable of the quality certificate equal to the path plus the name of the quality certificate to generate a quality certificate, and name it in the format of 'quality certificate yyyy-mm-dd_task order number_i', and use the copyfile function to copy the 'quality certificate template' to 'quality certificate yyyy-mm-dd_task order number_i', if ttj≠0, then do not generate a quality certificate, that is, as long as one of the four situations occurs, do not generate a quality certificate.

4. A system for generating a blank form for a quality certificate and writing a project profile, characterized in that: The method for generating a blank quality certificate table and writing the engineering profile as described in any one of claims 1 to 3 is used, the system comprising an input module, an import and read module, a generation and write module and an output module; The input module is used to input the folder path and supply date of the quality certificate; The import and read module is used to import production logs; The generating and writing module is used to generate a blank form of the quality certificate and write the engineering overview; The output module is used to output the quality certificate Excel document.

5. A computer device, characterized in that: The device comprises an input device, a processor, a memory and an output device, wherein the memory stores a computer program which can be loaded by the processor and execute the method according to any one of claims 1 to 3.

6. A method for using the system for generating a blank quality certificate form and writing a project overview as claimed in claim 4, characterized in that: The method comprises the following steps: Step T1: Copy the quality certificate template, production log, and strength record to the quality certificate folder; Step T2: Update production log and strength record; Step T3: Set the quality certificate template, issue date = supply date + 28; Step T4: Open Matlab, input the start date, end date, and the folder path where the quality certificate is located, start the system, and automatically generate the quality certificate; manually write the mix ratio and quality assurance certificate, strength value, test piece number, report number, chloride ion content, and impermeability number in the quality certificate; Step T5: Print, sign and stamp.

Images