Method, system and application for writing mix proportion information in quality certificate

Abstract

The invention discloses a method, system and application for writing mix proportion information in a quality certificate, and the method comprises the steps: iteratively writing the mix proportion information of a certain date quality certificate, and executing the following steps in a for date cycle; creating a temps table; introducing a mix proportion and a quality guarantee book; searching a line index of the warranty book; iteratively writing the mix proportion information of the quality certificate of a certain day, and executing the following steps in a for task single cycle; constructing j3 which is equal to the number of strength grades containing'fine 'characters; j4 is equal to the number of strength grades containing'water 'characters; j5 = strength grade number > = 45; ; classifying and writing in a mix proportion; and assigning other mix proportion information to cells of the temps table, and then writing the information into a quality certificate. According to the scheme of writing the mix proportion information of the quality certificate in a zero-intervention, zero-duty and second-level manner, the processing efficiency is improved by 8 times, manpower is released, higher value is created, manual operation errors and health risks are eliminated, expert experience is encoded into a traceable intelligent rule engine, and accurate and automatic matching is realized.

Description

Technical Field

[0001] This invention belongs to the fields of building materials technology and computer technology, and specifically relates to a method, system and application for writing mix proportion information in a quality certificate. Background Technology

[0002] A quality certificate is a certificate issued by a concrete company to a construction unit to ensure the quality of the concrete. It includes a project overview, mix design information, and quality details. The concrete company's internal laboratory staff writes these certificates based on production logs, raw material quality assurance ledgers, strength registration ledgers, chloride ion registration ledgers, impermeability registration ledgers, and mix design grade databases. Typically, a single quality certificate requires 46 parameters, and with 14 certificates issued daily, the manual writing of these certificates is extremely labor-intensive, severely reducing the actual testing time for testing personnel, who spend a significant amount of time on documentation. In addition, manually entering the mix proportion information into the quality certificate has the following problems: the positions of the cells in the mix proportion are different from those in the quality certificate. When copying the raw material usage, the mouse keeps clicking on the cells in the mix proportion and the quality certificate, switching back and forth, which is noisy. Searching for parameters in the five mix proportion tables (structure, foundation, fine stone, underwater, C525) and entering them into the quality certificate, whether by flipping through paper documents after printing the tables or by repeatedly switching between electronic interfaces, is essentially inefficient and counterintuitive, and is very prone to errors. Sometimes when copying, the dialog window shows that the cell format is inconsistent and cannot be copied, so the usage can only be entered manually. It takes 2 minutes to copy the usage of 8 kinds of raw materials, during which the mouse is clicked 16 times between the quality certificate and the quality assurance certificate, that is, 320 mouse clicks in 40 minutes, which can easily lead to finger fatigue and tendonitis. Summary of the Invention

[0003] The purpose of this invention is to overcome the shortcomings of the prior art and provide a method, system and application for writing mixing ratio information in a quality certificate. This invention first uses the principle of unity of materials to create an electronic ledger of raw material quality assurance certificates and generate a hypothetical temps table. Then, based on the characteristics of the mixing ratio, a jj formula is constructed to transform the computer's 0 and 1 judgments into 3, 4 and 5 judgments, and automatically writes the mixing ratio information in the quality certificate, achieving the purpose of saving time, effort and accuracy.

[0004] To achieve the above-mentioned objective, a first aspect of the present invention provides a method for writing mixing ratio information in a quality certificate, comprising the following steps: S1, construct a for date loop structure, iterate through the mix proportion information of the quality certificates for a total of m days from the start date to the end date, and within the for date loop structure, execute the subsequent operation steps for the quality certificates of the current day; S2. Create a hypothetical temps table with 46 columns using the table function. Set the column type to string and the column names to {cement type... impermeability number}, a total of 46; S3. Import mix ratios and raw material quality assurance certificates using the detectImportOptions function. The mix ratios include the following five tables: foundation, structure, underwater, fine aggregate, and C525; S4. Use the find function to find the row index w of the raw materials that were purchased one day before the concrete supply date in the raw material quality assurance certificate; S5. Construct a for task list loop structure to iteratively write the mix ratio information from the 1st quality certificate to the nth quality certificate on the day of the loop value of the iteration date. Inside the for task list loop structure, for the ith quality certificate, read the strength grade and project location and perform the subsequent operation steps; S6. Classify the mix ratios. Construct j3 = the number of strength grades containing the word "fine"; j4 = the number of strength grades containing the word "water"; j5 = strength grade ≥ C45; ; S7. Use the switch - case - otherwise structure to classify and write the mix ratio, admixture variety, admixture quality assurance certificate number, and admixture re - test number. First, judge whether the strength grade contains "water" or "fine". If it contains "fine", use the fine aggregate mix ratio; if it contains "water", use the underwater mix ratio; in the case of not containing "water" or "fine", for grades C25 and below, use the foundation mix ratio, for C30 - C40, use both the structure and foundation mix ratios, and for grades C45 and above, use the structure mix ratio; S8. Use the if structure to classify and write the cement variety, cement manufacturer, cement quality assurance certificate number, and cement re - test number. If the strength grade ≥ C45, use P·II52.5 cement; if the strength grade < C45, use P·O42.5 cement; S9. Use the if structure to classify and write the quality assurance certificate number, re - test number, and dosage of 5 - 25 mm aggregate. All strength grades use 5 - 16 mm aggregate; when the strength grade contains "fine", only use 5 - 16 mm aggregate; when the strength grade does not contain "fine", use 5 - 16 mm aggregate and 5 - 25 mm aggregate, and the dosage of 5 - 25 mm aggregate is 700, and the dosage of 5 - 16 mm aggregate is the total aggregate dosage - 700; [[ID=

[0005] Furthermore, the specific steps of step S4 are as follows: The row index of the line where w = (the date of the warranty certificate is equal to one day before the date loop value), where the date of the warranty certificate is obtained through a try-catch-end structure, specifically: Determine the date on the warranty certificate. If it is in character format, change it to date format; if it is in number format, add 69390.

[0006] Further, in step S6, the strength level is configured as a single cell, meaning the number of strength levels is 0 or 1; when the strength level contains "fine," j3=1; when the strength level does not contain "fine," j3=0; when the strength level contains "water," j4=1; when the strength level does not contain "water," j4=0; when the number of strength levels is ≥45, j5=1; when the number of strength levels is <45, j5=0; that is, when the strength level contains "fine," When the strength rating contains "water", When the strength grade is ≥C45 and does not contain "water", When the strength grade contains "water" and the strength grade is ≥C45, The method for obtaining the intensity level number is as follows: use the find function to find the position index of C in the intensity level, assign this index to temp, and the intensity level number = the temp+1 and temp+2 characters in the intensity level.

[0007] Furthermore, the specific steps of step S7 are as follows: When jj=3, i.e. the strength grade contains "fine", retrieve the amount of each raw material in row z of the fine aggregate mix proportion and assign it to the corresponding cell in row i of the temps table. z = strength grade number / 5 - 2. At this time, the admixture type in column 4 of row i of the temps table is "THJ-16". Retrieve the THJ-16 admixture quality certificate number and retest number in columns 6-7 of row w of the raw material quality certificate and assign them to columns 23-24 of row i of the temps table. Row w is the row where "raw material purchase date is equal to the day before concrete supply date". Note that the mix proportion and quality certificate are databases, temps is the precursor to the final quality certificate, and the quality certificate is the final report presented to the customer. Retrieve the data in the mix proportion and quality certificate, assign it to temps, and then write it directly from temps to the quality certificate. When jj=4, that is, when the strength grade contains "water" and the strength grade number is <45, retrieve the amount of each raw material in row z of the underwater mix proportion and assign it to the corresponding cell in row i of the temps table. z=strength grade number / 5-4. At this time, the admixture type in column 4 of row i of the temps table is "THJ-28". Retrieve the quality assurance certificate number and retest number of admixture THJ-28 in columns 8-9 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table. When jj=9, that is, when the strength grade contains "water" and the strength grade number is ≥45, at this time, retrieve the amount of each raw material in the z-th row of the underwater mix proportion and assign it to the corresponding cell in the i-th row of the temps table. z=strength grade number / 5-4. The admixture type obtained in the 4th column of the i-th row of the temps table is "THJ-28". Retrieve the quality assurance certificate number and retest number of the THJ-28 admixture in the 8th to 9th columns of the w-th row of the raw material quality assurance certificate and assign them to the 23rd to 24th columns of the i-th row of the temps table. When jj=5, that is, when the strength grade does not contain "water" and the strength grade number is ≥45, retrieve the amount of each raw material in row z of C525 mix proportion and assign it to the corresponding cell in row i of temps table. z=strength grade number / 5-8. At this time, the admixture type in column 4 of row i of temps table is "THJ-28". Retrieve the quality assurance certificate number and retest number of admixture THJ-28 in columns 8-9 of row w of raw material quality assurance certificate and assign them to columns 23-24 of row i of temps table. In other cases, i.e., the strength grade does not contain "fine" or "water" and is C40 or below, the contains function is used to determine whether the engineering part belongs to the structure or the foundation: If it belongs to the structural category, then determine whether the strength grade is greater than C25: If the strength grade > C25, retrieve the amount of each raw material in row z of the structural mix design and assign it to the corresponding cell in row i of the temps table, where z = strength grade number / 5 - 5. At this point, the admixture type in column 4 of row i of the temps table is "THJ-28". Retrieve the THJ-28 admixture quality assurance certificate number and retest number from columns 8-9 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table; If the strength grade ≤ C25, retrieve the amount of each raw material in row z of the basic mix design. Assign the value to the corresponding cell in row i of the temps table, z = strength grade number / 5 - 2. At this time, the admixture type in column 4 of row i of the temps table is "THJ-16". Retrieve the quality assurance certificate number and retest number of the THJ-16 admixture in columns 6 and 7 of row w of the raw material quality assurance certificate and assign them to columns 23 and 24 of row i of the temps table. Note that it is not enough to call the structural mix proportion if the part only contains keywords such as beam and column. The strength grade must also be above C25, such as C30 or C35. For C25 and below, regardless of whether it contains keywords such as beam and column, the basic mix proportion is used. If it belongs to the basic, retrieve the amount of each raw material in row z of the basic mix proportion and assign it to the corresponding cell in row i of the temps table. z = strength grade number / 5 - 2. At this time, the admixture type in column 4 of row i of the temps table is "THJ-16". Retrieve the THJ-16 admixture quality assurance certificate number and retest number in row w of the raw material quality assurance certificate and assign them to columns 23 and 24 of row i of the temps table. The xlswrite function is used to write the admixture type, slump, water consumption, cement consumption, mineral powder consumption, fly ash consumption, sand consumption, admixture quality assurance certificate number, and admixture retest number from temps(i,4), temps(i,8) to temps(i,13), temps(i,23), and temps(i,24) into the corresponding positions on the quality certificate. temps(i,4) represents the 4th column of the i-th row of the temps table.

[0008] Furthermore, in step S7, under other circumstances, the contains function is used to determine whether the engineering part belongs to the structure or the foundation. The specific steps are as follows: if the part contains "beam, column, shaft, brace, tower, bearing, wall, frame, slab, structure, frame, joint, staircase, bridge abutment, pier" but does not contain "raft slab, bottom slab, parapet wall, guide wall, crash barrier, retaining wall, water retaining wall, pergola", then it is a structure; otherwise, it is a foundation, that is, it contains a wall but cannot be a parapet wall, while continuous walls and wall panels belong to the structure.

[0009] Further, the specific steps of step S8 are as follows: If the strength grade ≥ C45, the cement type in the first column of the i-th row of the temps table is "P·II52.5", and the cement manufacturer in the fifth column of the i-th row of the temps table is "Designated Manufacturer 1". Retrieve the quality assurance certificate number and retest number of P·II52.5 cement in the fourth to fifth columns of the w-th row of the raw material quality assurance certificate and assign them to the 21st to 22nd columns of the i-th row of the temps table. If the strength grade < C45, the cement type in the first column of the i-th row of the temps table is "P·O42.5", and the cement manufacturer in the fifth column of the i-th row of the temps table is "Designated Manufacturer 2". Retrieve the quality assurance certificate number and retest number of P·O42.5 cement in the second to third columns of the w-th row of the raw material quality assurance certificate and assign them to the 21st to 22nd columns of the i-th row of the temps table. Use the xlswrite function to write the cement type, cement manufacturer, cement quality assurance certificate number, and cement retest number of temps(i,1), temps(i,5), temps(i,21), and temps(i,22) into the corresponding positions of the quality certificate respectively, that is, P·II52.5 cement is used for grades C45 and above and the corresponding manufacturer is changed, and P·O42.5 cement is used for grades below C45 and the corresponding manufacturer is changed.

[0010] Further, the specific steps of step S9 are as follows: If jj = 3, the amount of 5-25mm aggregate in the second column of the i-th row of temps = "-", the amount of 5-16mm aggregate in the third column of the i-th row of temps = the total amount of aggregate in the 14th column of the i-th row of temps, and the quality assurance certificate number and retest number of 5-25mm aggregate in the 25th to 26th columns of the i-th row of temps = {"-","-"}, that is, the quality certificate of fine aggregate does not use 5-25mm aggregate and is crossed out with "-"; If jj ≠ 3, the amount of 5-25mm aggregate in the second column of the i-th row of temps = 700, the amount of 5-16mm aggregate in the third column of the i-th row of temps = the total amount of aggregate in the 14th column of the i-th row of temps - 700, and the quality assurance certificate number and retest number of 5-25mm aggregate in the 25th to 26th columns of the i-th row of temps = the 16th to 17th columns of the w-th row of the raw material quality assurance certificate; Use the xlswrite function to write the quality assurance certificate number, retest number, and amount of 5-25mm aggregate of temps(i,25), temps(i,26), and temps(i,2) into the corresponding positions of the quality certificate.

[0011] In the second aspect of the present invention, a system for writing mix ratio information into a quality certificate is provided, including a hardware system and a software system. The hardware system includes an input device, a processor, a memory, and an output device. The processor includes an arithmetic logic unit (ALU) and a control unit. The ALU is used to execute the program in each small box, and the control unit is used to determine the execution order. The memory is used to store the quality certificate template, the mixing ratio, the quality assurance certificate, and the code for writing the quality certificate, which are to be written with the mixing ratio information. The software system includes programming software, an import and read module, a generation and write module, and document software. The programming software is used to input the folder path of the quality certificate and the supply date. The document software is used to output the quality certificate as an Excel document. The import and read module is used to import the mixing ratio, quality assurance certificate, and read the parameters of the imported file. The generation and write module is used to generate and write the various parameters of the mixing ratio information in the quality certificate.

[0012] A third aspect of the present invention provides an application of a system for writing mixing ratio information in a quality certificate, comprising the following steps: Download Matlab software; Copy the electronic versions of the quality certificate template, structural proportions, basic proportions, underwater proportions, C525 proportions, fine aggregate proportions, and quality assurance certificate to the quality certificate folder; Update the quality assurance certificate. The quality assurance certificate is entered into the computer based on the corresponding paper version. The quality assurance certificate form has 19 columns, with two columns for each type of raw material: quality assurance certificate number and retest number. There are a total of 9 types of raw materials, including P·O42.5 cement, P·II52.5 cement, THJ-16 admixture, THJ-28 admixture, mineral powder, manufactured sand, 5-16mm aggregate, 5-25mm aggregate, and fly ash. The purchase date is in a separate column. The purchase date is set to date format in Excel. If there are multiple batches in a day, enter the first batch. If there is no purchase on a certain day, enter the quality assurance certificate number of the most recent purchase. The quality assurance certificate number and retest number must be filled in for 365 days a year. If there is no purchase record for a day, copy the number information from the previous day to this day. Fill in the quality certificate template for the mix proportion information to be written. Among the six major raw materials, cement, sand, stone, admixtures, fly ash and mineral powder, only the cement and admixtures should be left blank. The other raw material types should be written in advance. Only the cement manufacturer's name should be left blank. The manufacturer's name of the other raw materials should be written in advance. Open Matlab, enter the start date, end date, and the folder path where the quality certificate is located, start the program, and the quality certificate will be generated automatically. To check the quality certificates, do not open each certificate individually. Click on a quality certificate in the folder list; a preview will appear on the right. Check if the strength grade and location match the mix proportions. If the strength grade includes "underwater," it is an underwater mix proportion; if it includes "fine aggregate," it is a fine aggregate mix proportion; if the strength grade is C45 or higher, it is a C525 mix proportion; if the strength grade is C30-C40, the mix proportion is structural if the location is structural, and basic if the location is foundation; if the strength grade is C25 or lower, it is a basic mix proportion. The admixture type for foundation and fine aggregate mix proportions is THJ-16; the admixture type for C525, underwater, and structural mix proportions is THJ-28; the cement type for the C525 mix proportion is P·II 52.5, and the cement plant name is designated manufacturer 1; the cement type for other mix proportions is P·O. 42.5 The cement plant name is designated manufacturer 2, the strength grade contains fine aggregate, and the quality certificate number, retest number, and dosage of 5-25 aggregate are all "-". If any of the above parameters are not met, the corresponding quality certificate shall be deleted. Print, sign, and stamp.

[0013] Furthermore, for various parameters that Matlab software cannot directly read, data conversion functions are required. Specifically, this is achieved through independent data conversion function calls or multi-level nested data conversion functions to convert and integrate the data formats for reading. The start date, end date, and folder path of the quality certificate input in the Matlab programming interface; the date, quality certificate number, and retest number from the quality assurance certificate Excel file; and the strength grade, slump, and raw material usage from basic Excel, structural Excel, fine stone Excel, underwater Excel, and C525 Excel files, are all parameters that Matlab cannot directly read. Instead, the num2str, datenum, datestr, table2cell, str2double, cell2mat, char, double, and string data conversion functions are required. This involves independent function calls or multi-level nested function conversion to convert and integrate the data formats. The multi-function nested conversion command for the quality assurance certificate date is as follows: date_zhibaoshu = datenum((string(table2cell(zhibaoshu(:,1))))). Note that the parameters in the Excel spreadsheet cannot be directly read by the Matlab software.

[0014] Based on the above technical solution, the technical solution of the present invention has achieved the following technical advantages through practical application: 1. The system can input the mix proportion (raw material quantity, type, and manufacturer) according to the strength grade and engineering part without manual searching and copying, and input the quality assurance certificate (raw material quality assurance certificate number and retest number) according to the supply date. It completes the manual process that used to take tens of minutes in seconds, and ensures that the information is absolutely accurate and traceable throughout the process.

[0015] 2. Constructing a dynamic dual-anchor adaptive matching system enables the system to have unlimited expansion potential. Through the two anchors, date anchor w and strength grade anchor z, the system can automatically locate the corresponding date row (row w) in the quality assurance certificate ledger and accurately match the corresponding strength grade row (row z) in the mix proportion database, thereby completing the automatic writing of the quality certificate for the day. (1) Adaptive formula of anchor z in mix proportion database. Structural mix proportion (C30~C40): z = strength grade number / 5 - 5, for example, C30 automatically matches row 30 / 5 - 5 = 1. When adding C45, only one row needs to be added in the Excel database, and the formula automatically adapts to row 45 / 5 - 5 = 4, without modifying the program. Fine stone mix proportion (C15~C40): z = strength grade number / 5 - 2, for example, C15 automatically matches row 15 / 5 - 2 = 1. This design converts the strength grade into a continuous row index through mathematical mapping, enabling the mix proportion database to have autonomous expansion capability. The program only needs to maintain a unified formula, rather than enumerating all grades. (2) Dynamic positioning of the anchor point w in the quality assurance certificate ledger. The date anchor point w is defined as the row index of "the date of the quality assurance certificate is equal to the day before the date cycle value". This dynamic mechanism enables the system to automatically adapt to the continuous updating of the ledger. Even if the ledger is extended to April 5, 2042, the system can still automatically locate the correct row through the date cycle value April 6, 2042, without the need for program adjustment. (3) Comparison of design advantages. The hard-coding method has inherent defects: (a) Strong coupling matching mechanism. For example, in the structural matching ratio, the fixed rule is that C30 reads the first row, C35 reads the second row, and C40 reads the third row. Once a new level is added to the matching ratio library (such as C45), the program code must be manually modified, forming a maintenance dilemma of "one change and multiple changes". (b) Dependence on static row index. If the quality assurance certificate ledger is divided by weekdays and a fixed mapping of "reading the first row on Monday, reading the second row on Tuesday, ... reading the seventh row on Sunday" is used. This not only fails to support continuous generation across cycles, but also prevents the ledger from being infinitely expanded, violating the natural need for continuous accumulation of engineering data. (c) The system is fragile and has high maintenance costs. The program and data format are deeply bound. When modifying it again after a long time, developers often find themselves in the predicament of finding minor bugs, and the time cost often exceeds that of rewriting the program. This seriously restricts the scalability and sustainability of the system. (4) Provides structural support for the system. The dual anchor points constitute the structural support of the system. No matter how complex the mix proportion decision tree (jj) is in the later stage, it can achieve accurate matching by relying only on the two dynamic parameters w and z, so that the core logic remains simple and stable. The mix proportion library adds strength levels and the quality assurance ledger is continuously expanded to any future date without modifying or re-debugging the program, realizing the design concept of data-driven and program self-adaptation. Breaking through the limitations of one file per week and line number as date, it can generate tens of thousands of quality certificates spanning several years with one click, meeting the full-cycle document automation needs of large-scale engineering projects.(5) The inherent model of strong coupling between data and program in traditional hard coding is transformed into an intelligent model of data autonomous expansion and program automatic adaptation. This not only solves the practical problem of large-scale automated generation of concrete quality certificates, but also provides a flexible architecture design methodology that can be extended to other engineering document generation fields, with significant innovation and industrial application value. (6) Sadly, even hard coding systems have not yet emerged. Many enterprises are still stuck in the primitive stage of manually searching for forms and manually filling out quality certificates. This situation leads to the professional capabilities of technical personnel being consumed by a large amount of low-value, repetitive labor, making it impossible to focus on the basic work of engineering crack analysis and ensuring concrete stability due to raw material fluctuations, further exacerbating the stagnation of industry productivity and innovation. (7) Even more serious is that industries like concrete with meager profits face a structural contradiction. Directly hiring professional development teams to program massive amounts of engineering data one by one is far more costly than the industry can afford, and systems that rely on external development are often detached from actual production and become a formalized management burden. This solution proposes a sustainable transformation path, transforming the cost of repetitive labor of traditional data clerks into an investment in cultivating technical + programming composite talents. Enterprises can avoid the burden of high outsourcing costs by empowering their internal workforce, enabling skilled technicians with both expertise and technical expertise to independently develop intelligent tools that truly meet their business needs. This not only addresses the industry's pain points of unaffordable systems and teams but also responds to the dual societal challenges of finding employment for highly educated technical talent and upgrading traditional industries. In the long run, this model can systematically improve the technological content and management efficiency of China's concrete industry, thereby building a genuine core competitiveness in the international market with high quality and competitive pricing. This application represents an effective practice for fundamentally improving engineering quality and upholding the industry's technological dignity.

[0016] 3. In the process of automatic data processing, traditional methods are difficult to be compatible with multi-source heterogeneous data formats. Especially when processing Excel ledgers entered by different people, the problem of mixed text / numerical formats in date fields often leads to program interruption. This application adopts the following innovative technical solutions to achieve a date processing scheme with high fault tolerance and strong compatibility. (1) Design an intelligent date format compatibility mechanism. By constructing a try-catch-end exception handling structure nested with data format conversion logic, the system can automatically identify and uniformly process date data with mixed formats: when the date is detected to be in text format (such as "December 31, 2024"), the format conversion function is automatically called to standardize it into a calculable date; when the date is detected to be in numeric format (such as "2024 / 12 / 31"), the calling function is first called to convert it into a number, and then the "+69390" benchmark correction algorithm is used to accurately compensate for the date system differences between Excel and Matlab. (2) Achieve seamless cross-platform date system integration. The +69390 correction value is not a simple offset, but a cross-system benchmark conversion parameter that has been rigorously mathematically verified. This innovative method solves the 46-year date benchmark difference between the Excel (based on 1900-1-1) and Matlab (based on 0000-1-1) dual systems, avoids the inefficient operation of manual format identification and batch processing required by traditional methods, and ensures that the program can obtain accurate Matlab-processable date values ​​under any mixed format input. (3) Establish a balance between program compatibility and data traceability. Through the above technical solutions, the system achieves 100% format compatibility while accurately maintaining the original temporal relationship of date data. With the precise positioning of the w index (w = warranty date equal to 1 day before the target date), a complete technical chain of format adaptation → data standardization → precise indexing is formed, which overcomes the automation bottleneck problem caused by manual input differences in manufacturing data fusion.

[0017] 4. A novel method for automatically generating quality certification documents based on an intermediate structured data layer (temps table) is proposed. By designing a standardized temps table (similar data in the same column, no merged cells, etc.) as the data hub, the parameter sets required for all outputs are clearly defined. A data-first, then-file-writing logic is adopted, first writing standardized data into the temps table, and then mapping it as a whole to the quality certification template, avoiding logical confusion and location errors caused by directly manipulating the template. Row and column indices (i, j) are used instead of traditional variable naming, and data is called in a unified coordinate manner, eliminating the tedious process of naming numerous discrete parameters individually, significantly improving the system's scalability and coding efficiency.

[0018] 5. This invention provides an application for writing the mix proportion in the quality certificate. Through the structured transformation of the data source and the hierarchical mapping of the writing process, the fully automatic, high-precision, and compliant writing of the mix proportion information in the quality certificate is realized. (1) The two admixtures THJ-16 and THJ-28 are stored separately (traditional paper ledgers record the two types of admixtures mixed in one column), which can realize: direct and accurate calling of the target quality certificate data. The system intelligently matches one of five preset mix proportion tables with the strength grade and the engineering part. Each table uses a single admixture (THJ-16 or THJ-28). Once the target mix proportion table is identified, the required admixture type is determined simultaneously, and then the corresponding THJ-16 or THJ-28 independent data column in the electronic ledger is directly and accurately called. By performing structured preprocessing on the quality certificate electronic ledger, a foundation is provided for directly and accurately calling the target data through clear column identifiers (such as zhibaoshu(i,j)) during programming. (2) By constructing a two-layer calling mechanism of "dynamic variable layer (temps table)" and "static data layer (quality assurance certificate ledger)", the automatic writing of the mix proportion information is realized. The temps table serves as the carrier of dynamic variables: its column structure is fixed, and its content is generated in real time with the task. All writing parameters are managed uniformly through row and column coordinates (i,j). The quality assurance certificate ledger serves as the static compliance data source: its column structure is also fixed, but its content is pre-approved standardized data. The system dynamically adjusts the column index of the quality assurance certificate ledger so that the corresponding variable unit (temps(i,j)) in the temps table is accurately mapped to the independent data column of the target admixture in the ledger (such as the THJ-16 or THJ-28 column). This mechanism retains the flexible calculation capability of the temps table and ensures that the raw material information called is fully compliant with the quality assurance specifications, thereby maintaining the accuracy and compliance of the data throughout the dynamic generation process. Specifically, when writing the mixing ratio information, the column indices of the hypothetical temps table remain unchanged, while the column indices of the zhibaoshu (quality assurance certificate) are changed. temps(i,j) is used as a variable, and zhibaoshu(i,j) is used as a database. The content in the temps table changes dynamically, while the content in the zhibaoshu table remains unchanged. The dynamism of the temps table and the compliance of the zhibaoshu table ensure the automatic writing of the mixing ratio information.

[0019] 6. In the automated quality certificate writing system, the collaborative use of Excel and Matlab faces a key data processing challenge: if the purchase date in Excel is in a left-aligned text format (such as "December 31, 2023"), Matlab cannot directly recognize it, leading to program errors; attempting to programmatically parse such non-standard date text within Matlab is extremely cumbersome and difficult to implement. This solution innovatively solves the cross-platform data parsing barrier by implementing standardized preprocessing on the Excel side, forcing the date field to be unified into a standard date format that can be accurately recognized by Matlab, thus ensuring the stability and efficiency of the automated process.

[0020] 7. By introducing multi-valued state variables (jj) and constructing a complete and hierarchical conditional decision tree, the most complex and experience-dependent mix design problem in concrete production is transformed into a stable, reliable, and traceable automated program logic. This method not only significantly improves the accuracy and efficiency of mix design input, but also provides an innovative solution for the standardization and intelligentization of construction quality control through regularization and coding. Specifically: (1) Construct a multi-state decision formula to realize the coding of complex logic. Traditional methods rely on binary judgment of yes / no, which is difficult to handle complex scenarios with multiple conditions and priorities that are common in engineering. This invention innovatively defines the jj decision state variable, whose value is not limited to simple 0 or 1, but is extended to five states with clear engineering semantics, such as 3, 4, 5, 9 and others, corresponding to "fine stone", "underwater", "high strength (C45 and above)", "C45 underwater" and other conventional situations. This design transforms fuzzy human experience judgment into clear and programmable discrete states, providing a logical basis for the system to realize automatic decision-making. (2) Establish multi-level conditional rules to ensure the accuracy and comprehensiveness of decision-making. When reading the i-th task order, the system performs state judgment and mix ratio matching based on key parameters such as strength grade and engineering location through the following hierarchical rules: (a) First level (special working conditions priority): If the strength grade contains "fine", then jj=3, and the system automatically matches the fine stone mix ratio (specifying admixture as THJ-16); (b) Second level (environmental condition judgment): If the strength grade contains "water", then jj=4, and the system automatically matches the underwater mix ratio (specifying admixture as THJ-28); (c) Third level (cross-judgment of strength and environment): Based on the underwater condition, if the strength grade is simultaneously C45 or above... If the state is upgraded to jj=9, the system still matches the underwater mix ratio (THJ-28); (d) Fourth level (high strength special judgment): if the strength grade is C45 or above (and does not include "water"), then jj=5, and the system automatically matches the C525 high strength mix ratio (specifying the admixture as THJ-28); (e) Fifth level (normal part judgment): for other cases where jj is not equal to 3, 4, 5, or 9, the system further judges whether the engineering part belongs to "structure" and has a strength grade greater than C25; if so, the structural mix ratio (THJ-28) is used; if not, the basic mix ratio (THJ-16) is used. (3) Achieve synchronous deterministic matching of admixture and mix ratio. This method determines the required admixture type (THJ-16 or THJ-28) and the corresponding mix ratio table at the same time as determining the jj state through the above rules. This strong correlation design of "state-mixing ratio-additive" ensures full automation and ambiguity from logical judgment to data retrieval, fundamentally eliminating errors that may be caused by manual selection.

[0021] 8. The automatic writing of the mixing ratio information in this invention achieves the following innovative breakthroughs: (1) Efficiency breakthrough. The system achieves fully automatic writing, processing 98 quality certificates for one week in just 28 minutes, and processing the workload for the whole year in just 28 minutes. Using traditional manual methods, processing a week's worth of quality certificates takes 224 minutes, and a yearly processing time would be... In contrast, the system can save technicians 22.4-2.8=19.6 working days per year. These 19.6 working days can be used to calm down and study a technical problem, or read a technical book, and think deeply about how to solve the stability of concrete quality when raw materials fluctuate greatly, instead of getting bogged down in meaningless copying and pasting to complete data. This not only fundamentally eliminates errors caused by human fatigue, but also improves information processing efficiency to more than 8 times that of manual labor. More importantly, it reconstructs the value creation model of technicians. The system can automatically process the annual workload in only about 2.8 working days, completely freeing up manpower. Operators do not need to be on duty, and only need to ensure that the computer is running, so that other work tasks can be processed in parallel during this period. (2) Process optimization. It completely solves the inefficient links and dual physical and cognitive loads of manual operation, such as repeatedly switching between multiple interfaces, frequent mouse clicks, manual copying and pasting, and manual input caused by format conflicts. It also eliminates three problems caused by this: first, operation noise; second, occupational health risks such as tenosynovitis; and third, manual input errors caused by inconsistent formats (for example, when copying, the dialog window prompts that the cell format is inconsistent and cannot be pasted, so the unit dosage can only be manually entered, which is usually due to the existence of merged cells). This system realizes true "zero intervention" writing and one-click automatic generation. (3) Intelligent decision-making. The system constructs a decision rule engine with multiple feature inputs and multiple state outputs. The engine receives multi-dimensional feature vectors such as raw material parameters (such as cement type, admixture type), design indicators (strength grade, aggregate requirements), and engineering context (foundation, structure, underwater) in real time, and performs automatic matching and classification through predefined discrimination rule trees (such as: IF strength grade ≥ C45 AND application location = "underwater" THEN type = "underwater concrete"). This model not only achieves a near 100% accuracy rate in judgment, but also solidifies expert experience into executable, optimizable, and traceable digital rules, laying a technical foundation for the standardization and intelligentization of mix proportion selection.

[0022] 9. The creative contribution of this application lies in the use of deep learning to creatively apply existing technical tools to design a complete and efficient systematic solution to stubborn technical problems in specific industrial fields. (1) This application addresses the long-standing industry pain point of data compilation in the field of concrete quality control. Instead of focusing on tools, it creatively integrates the complex data processing environment of Matlab with the specific industrial process of concrete mix proportion decision-making and quality certificate generation. (2) The use of Matlab language and data conversion functions is not obvious or routine in this field. The difficulty lies in: (a) logical complexity. It is necessary to accurately design the data flow logic between the database, intermediate variable layer and output template to ensure type matching and format compatibility. (b) high debugging difficulty. The selection of functions, nesting order and parameter settings require a lot of creative debugging to achieve stable and accurate data reading and writing. It is not a simple application. If the program is not designed properly, it will directly lead to the interruption of the process, and it will be impossible to read the database or write to the target file. (c) integration of domain knowledge. Applicants need a deep understanding of both concrete materials (such as strength grade and admixture type) and information technology (such as structured data and function calls) in order to translate industry rules (such as mix design logic) into executable program code. Attached Figure Description

[0023] Figure 1 This is a flowchart of the process of the present invention.

[0024] Figure 2(a) shows columns 1 to 23 of the temps table style diagram generated by the present invention.

[0025] Figure 2(b) shows columns 24 to 37 of the temps table style diagram generated by the present invention.

[0026] Figure 2(c) shows columns 38 to 46 of the temps table style diagram generated by the present invention.

[0027] Figure 3 This is a schematic diagram of the structural framework of the hardware system in this invention.

[0028] Figure 4 This is a schematic diagram of the structural framework of the software system in this invention.

[0029] Figure 5 This is a schematic diagram of the system of the present invention checking the quality certificate in preview mode.

[0030] Figure 6(a) is a table of structural proportions in Embodiment 1 of the present invention.

[0031] Figure 6(b) is a schematic diagram of the quality certificate generated according to the structural mix proportion in Figure 6(a) of the present invention.

[0032] Figure 7(a) shows the paper ledger of cement quality assurance certificate in the prior art.

[0033] Figure 7(b) shows the paper ledger of sand quality assurance certificate in the prior art.

[0034] Figure 7(c) shows the paper ledger of the quality guarantee certificate in the prior art.

[0035] Figure 7(d) shows the paper ledger of admixture warranty in the prior art.

[0036] Figure 7(e) shows the paper ledger of fly ash quality assurance certificate in the prior art.

[0037] Figure 7(f) shows the paper ledger of mineral powder quality assurance certificate in the prior art.

[0038] Figure 7(g) shows the quality certificate generated in the prior art after filling in the data selected in Figures 7(a) to 7(e).

[0039] Figure 8 The electronic ledger of raw material quality assurance certificates generated for this invention. Detailed Implementation

[0040] To make the objectives, technical solutions, and advantages of this invention clearer, the invention is described below with reference to the accompanying drawings and specific examples. However, it should be understood that these descriptions are merely exemplary and not intended to limit the scope of the invention. Furthermore, descriptions of well-known structures and techniques are omitted in the following description to avoid unnecessarily obscuring the concept of the invention.

[0041] The quality assurance certificate described in this invention is not the factory quality assurance certificate for raw materials, but rather a registration ledger listing the type of raw materials, manufacturer's name, quality assurance certificate number, and retesting number. The quality assurance certificate number represents the number of the quality assurance certificate provided by the raw material supplier at the time of shipment, and the retesting number represents the test report number obtained by the concrete company's internal laboratory after retesting the purchased raw materials. Note that different mix proportions have different strength grades: the strength grade number for fine aggregate mix proportions is C15-C40; for underwater mix proportions, it is C25-C45; for C525 mix proportions, it is C45-C60, C80; for structural mix proportions, it is C30-C40; and for foundation mix proportions, it is C15-C40. The quality certificate to be used to record mix proportion information should have all blanks pre-filled except for the raw material usage, type, manufacturer, quality assurance certificate number, and retesting number. The raw material usage is the cubic meter usage in the quality certificate (see cell B16 of the quality certificate).

[0042] Example 1: This example provides a method for writing mixing ratio information into a quality certificate. See [link to example]. Figure 1 As shown, it includes the following steps: S1. Construct a for loop structure for dates, iteratively write the mix ratio information of the quality certificates for m days from the start date to the end date. Within the for loop structure for dates, for the quality certificate on the date loop value, perform the following steps; S2. (In Matlab) Use the table function to create a hypothetical table temps with 46 columns, (the table temps existing in the Matlab background is displayed in an excel table) as shown in Figure 2. Set the column type to string, and the column names are {cement type, stone 5 - 25, stone 5 - 16, admixture... impermeability number} for a total of 46; S3. Use the detectImportOptions function to import the mix ratio and raw material quality certificates; the mix ratio includes the following five tables: foundation, structure, underwater, fine aggregate, C525; S4. Use the find function to find the row index w of the raw materials that were purchased one day before the concrete supply date in the raw material quality certificates; S5. Construct a for loop structure for work orders, iteratively write the mix ratio information of the 1st quality certificate to the nth quality certificate on the date loop value. Within the for loop structure for work orders, for the ith quality certificate, read the strength grade and project location, and perform the following steps; S6. Classify the mix ratio, construct j3 = the number of strength grades containing the word 'fine'; j4 = the number of strength grades containing the word 'water'; j5 = the strength grade number ≥ 45; ; S7. Use the switch - case - otherwise structure to classify and write the mix ratio, admixture variety, admixture quality certificate number, and admixture retest number. First, judge whether the strength grade contains 'water' or 'fine'. If it contains 'fine', use the fine aggregate mix ratio. If it contains 'water', use the underwater mix ratio. Then, in the case of not containing 'water' or 'fine', for grades C25 and below, use the foundation mix ratio. For grades C30 - C40, use the structure and foundation mix ratios. For grades C45 and above, use the structure mix ratio; S8. Use the if structure to classify and write the cement variety, cement manufacturer, cement quality certificate number, and cement retest number. If the strength grade ≥ C45, use P·II52.5 cement. If the strength grade < C45, use P·O42.5 cement; S9. Use the if structure to classify and write the 5 - 25 stone quality certificate number, 5 - 25 stone retest number, and 5 - 25 stone dosage. All strength grades use 5 - 16 stone. For the fine aggregate strength grade, only use 5 - 16 stone and not 5 - 25 stone. For non - fine aggregate strength grades, both 5 - 16 stone and 5 - 25 stone are used, and the 5 - 25 stone dosage is 700, and the 5 - 16 stone dosage is the total stone dosage - 700; S10, retrieve the quality assurance certificate number and retest number of fly ash, mineral powder, manufactured sand, and 5-16 aggregate from row w of the raw material quality assurance certificate, assign them to the corresponding cell in row i of the temps table, and use the xlswrite function to write the quality assurance certificate number and retest number of fly ash, mineral powder, manufactured sand, and 5-16 aggregate, as well as the dosage of 5-16 aggregate and the dosage of admixtures into the corresponding position of the quality certificate. Row w is the row containing "raw material purchase date equal to the day before concrete supply date"; Furthermore, the specific steps of step S4 are as follows: The row index of the line where w = (the date of the warranty certificate is equal to one day before the date loop value), where the date of the warranty certificate is obtained through a try-catch-end structure, specifically: Determine the date on the warranty certificate. If it is in character format, change it to date format; if it is in number format, add 69390.

[0043] Further, in step S6, the intensity level = the second cell in the (i+3)th row of the production log. Since the intensity level corresponds to a single cell in the second cell of the (i+3)th row of the production log, there is only one intensity level. Therefore, the number of intensity levels containing the word "fine" can only be 0 or 1. If the intensity level contains "fine," then j3 = 1; if the intensity level does not contain "fine," then j3 = 0. If the intensity level contains "water," then j4 = 1; if the intensity level does not contain "water," then j4 = 0. When the number of intensity levels is ≥ 45, then j5 = 1; when the number of intensity levels is < 45, then j5 = 0. Because... Therefore, when the strength grade contains "fine", When the strength rating contains "water", When the strength grade is ≥C45 (and does not contain "water"), When the strength grade contains "water" and the strength grade is ≥C45, The method for obtaining the intensity level number is as follows: use the find function to find the position index of C in the intensity level (for example, "C20 fine stone", where C is at the beginning, that is, the position index of C is 1), assign this index to temp (that is, temp=1), and the intensity level number is the (temp+1)th and (temp+2)th characters in the intensity level (that is, the intensity level number is the 2nd and 3rd characters in the intensity level, i.e., 20).

[0044] Furthermore, the specific steps of step S7 are as follows: When jj=3, retrieve the amount of each raw material in row z of the fine aggregate mix design and assign it to the corresponding cell in row i of the temps table. z = strength grade number / 5 - 2. At this time, the admixture type in column 4 of row i of the temps table is "THJ-16". Retrieve the THJ-16 admixture quality assurance certificate number and retest number in columns 6-7 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table. w is the position index of the row where "the raw material purchase date is equal to the day before the concrete supply date". Note that the mix design and quality assurance certificate are databases, temps is the precursor to the final quality certificate, and the quality certificate is the final report presented to the customer. Retrieve the data in the mix design and quality assurance certificate, assign it to temps, and then write it directly from temps to the quality certificate. When jj=4, retrieve the amount of each raw material in row z of the underwater mix proportion and assign it to the corresponding cell in row i of the temps table. z=strength grade number / 5-4. At this time, the admixture type in column 4 of row i of the temps table is "THJ-28". Retrieve the quality assurance certificate number and retest number of admixture THJ-28 in columns 8-9 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table. When jj=9, retrieve the amount of each raw material in row z of the underwater mix proportion and assign it to the corresponding cell in row i of the temps table. z=strength grade number / 5-4. At this time, the admixture type in column 4 of row i of the temps table is "THJ-28". Retrieve the quality assurance certificate number and retest number of admixture THJ-28 in columns 8-9 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table. When jj=5, retrieve the amount of each raw material in row z of the C525 mix proportion and assign it to the corresponding cell in row i of the temps table. z=strength grade number / 5-8. At this time, the admixture type in column 4 of row i of the temps table is "THJ-28". Retrieve the quality assurance certificate number and retest number of admixture THJ-28 in columns 8-9 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table. In other cases, i.e., the strength grade does not contain "fine" or "water" and is C40 or below, the contains function is used to determine whether the engineering part belongs to the structure or the foundation: If it belongs to the structural category, then determine whether the strength grade is greater than C25: If the strength grade > C25, retrieve the amount of each raw material in row z of the structural mix design and assign it to the corresponding cell in row i of the temps table, where z = strength grade number / 5 - 5. At this point, the admixture type in column 4 of row i of the temps table is "THJ-28". Retrieve the THJ-28 admixture quality assurance certificate number and retest number from columns 8-9 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table; If the strength grade ≤ C25, retrieve the amount of each raw material in row z of the basic mix design. Assign the value to the corresponding cell in row i of the temps table, z = strength grade number / 5 - 2. At this time, the admixture type in column 4 of row i of the temps table is "THJ-16". Retrieve the quality assurance certificate number and retest number of admixture THJ-16 in columns 6 and 7 of row w of the raw material quality assurance certificate and assign them to columns 23 and 24 of row i of the temps table. Because the location only contains keywords such as beam and column, it is not enough to call the structural mix proportion. The strength grade must be above C25, such as C30 or C35. C25 and below, regardless of whether they contain keywords such as beam and column, all use the basic mix proportion. If it belongs to the basic, retrieve the amount of each raw material in row z of the basic mix proportion and assign it to the corresponding cell in row i of the temps table. z = strength grade number / 5 - 2. At this time, the admixture type in column 4 of row i of the temps table is "THJ-16". Retrieve the THJ-16 admixture quality assurance certificate number and retest number in row w of the raw material quality assurance certificate and assign them to columns 23 and 24 of row i of the temps table. The xlswrite function is used to write the admixture type, slump, water consumption, cement consumption, mineral powder consumption, fly ash consumption, sand consumption, admixture quality assurance certificate number, and admixture retest number from temps(i,4), temps(i,8) to temps(i,13), temps(i,23), and temps(i,24) into the corresponding positions on the quality certificate. temps(i,4) represents the 4th column of the i-th row of the temps table.

[0045] Furthermore, in step S7, under other circumstances, the contains function is used to determine whether the engineering part belongs to the structure or the foundation. The specific steps are as follows: if the part contains "beam, column, shaft, brace, tower, bearing, wall, frame, slab, structure, frame, joint, staircase, bridge abutment, pier" but does not contain "raft slab, bottom slab, parapet wall, guide wall, crash barrier, retaining wall, water retaining wall, pergola", then it is a structure; otherwise, it is a foundation. This means that it contains a wall but cannot be a parapet wall, while continuous walls and wall panels belong to the structure.

[0046] Further, the specific steps of step S8 are as follows: If the strength grade ≥ C45, the cement type in the first column of the i-th row of the temps table is "P·II52.5", and the cement manufacturer in the fifth column of the i-th row of the temps table is "Designated Manufacturer 1". Retrieve the quality assurance certificate number and re-inspection number of P·II52.5 cement in the 4th to 5th columns of the w-th row of the raw material quality assurance certificate and assign them to the 21st to 22nd columns of the i-th row of the temps table. If the strength grade < C45, the cement type in the first column of the i-th row of the temps table is "P·O42.5", and the cement manufacturer in the fifth column of the i-th row of the temps table is "Designated Manufacturer 2". Retrieve the quality assurance certificate number and re-inspection number of P·O42.5 cement in the 2nd to 3rd columns of the w-th row of the raw material quality assurance certificate and assign them to the 21st to 22nd columns of the i-th row of the temps table. Use the xlswrite function to write the cement type, cement manufacturer, cement quality assurance certificate number, and cement re-inspection number of temps(i,1), temps(i,5), temps(i,21), and temps(i,22) into the corresponding positions of the quality certificate respectively, which means that P·II52.5 cement is used for grades C45 and above and the corresponding manufacturer is changed, and P·O42.5 cement is used for grades below C45 and the corresponding manufacturer is changed.

[0047] Further, the specific steps of step S9 are as follows: If jj = 3, the quantity of 5-25 mm stones in the second column of the i-th row of temps = "-", the quantity of 5-16 mm stones in the third column of the i-th row of temps = the total quantity of stones in the 14th column of the i-th row of temps, and the quality assurance certificate number and re-inspection number of 5-25 mm stones in the 25th to 26th columns of the i-th row of temps = {"-", "-"}, which means that 5-25 mm stones are not used in the fine aggregate quality certificate and are crossed out with "-". If jj ≠ 3, the quantity of 5-25 mm stones in the second column of the i-th row of temps = 700, the quantity of 5-16 mm stones in the third column of the i-th row of temps = the total quantity of stones in the 14th column of the i-th row of temps - 700, and the quality assurance certificate number and re-inspection number of 5-25 mm stones in the 25th to 26th columns of the i-th row of temps = the 16th to 17th columns of the w-th row of the raw material quality assurance certificate. Use the xlswrite function to write the quality assurance certificate number, re-inspection number, and quantity of 5-25 mm stones of temps(i,25), temps(i,26), and temps(i,2) into the corresponding positions of the quality certificate respectively.

[0048] The writing example is shown in Table 1. The jj value can be calculated based on the strength grade and location, and based on the jj value, it can be determined which one of the five mix ratios of structure, C525, fine aggregate, underwater, and foundation to retrieve.

[0049]

[0050] Note: In Example 1, z=1 means that C30 is the first row of the mix proportions in the structure mix proportions Excel table; in Example 6, z=5 means that C35 is the fifth row of the basic mix proportions Excel table.

[0051] The following conclusions can be drawn from Example 1: Conclusion 1: At the beginning of program development, an Excel spreadsheet named "test" was manually created. Each row in the spreadsheet represented a quality certificate. The 46 cells required for the quality certificates were used as the 46 column headers of the "test" spreadsheet, clearly defining which parameters each quality certificate needed to generate. This ensured the uniformity of the "test" spreadsheet: similar data were in the same column, there were no merged cells, column headers were single headers, there were no empty rows or columns, no totals, the column data was atomic, all data was one-dimensional (one row, n columns), the number format was correct, it was editable, and it could be called; in other words, "test" could be used as a data source. The quality certificates, on the other hand, contained merged cells, and the data was not in the same row; they served as a report presentation. Therefore, a program in Matlab was written to generate a hypothetical "temps" spreadsheet (with content identical to the manually created "test" spreadsheet). Each time a parameter was generated for a quality certificate, it was assigned to a cell in "temps." Finally, the value or text of each cell in "temps" was written into the quality certificate's Excel cells to avoid confusion. When the i-th row and columns 1 to 46 of "temps" were filled, the quality certificate's cells were filled with empty spaces.

[0052] Conclusion 2: Setting the purchase date in the raw material quality assurance certificate electronic ledger Excel to a date format facilitates Matlab reading. If the purchase date in the raw material quality assurance certificate electronic ledger Excel is "December 31, 2023" and is in text format, positioned to the left of the cell, Matlab cannot read the quality assurance certificate date, resulting in a program error. Setting the date to date format in Excel is as simple as selecting the cell, right-clicking, and choosing "Format Cells," then "Date." If the date is not set to date format in Excel, even writing very complex code in Matlab will make it difficult to read the date. Only by using Excel and Matlab together can the automatic generation of quality certificates be finally completed.

[0053] Conclusion 3: Based on different mix proportions, the keywords or number of strength grades contained in the strength grades are different. Construct the jj formula, let j3 = strength grade containing "fine"; j4 = strength grade containing "water"; j5 = number of strength grades greater than or equal to 45; ; Change the 0-1 judgment of the computer to a 3-4-5 judgment. According to jj = 3, 4, 5, 9 and other five cases in total, allocate the mix ratio. When reading the i-th task sheet, call different types of mix ratios according to the strength grade. When the strength grade contains "fine" (jj = 3), use the fine aggregate mix ratio (the admixture is THJ-16); when it contains "water" (jj = 4), use the underwater mix ratio (the admixture is THJ-28); for C45 and above and without "water" (jj = 5), use the C525 mix ratio (the admixture is THJ-28); when jj≠3, 4, 5, 9 (in other cases), judge whether the part belongs to the structure and C25 < strength grade < C45. If yes, use the structural mix ratio (the admixture is THJ-28); if no, use the foundation mix ratio (the admixture is THJ-16). The mix ratio is discussed in different cases as shown in Table 2. For the strength grades in the three tables of fine aggregate, underwater, and C525, except for C45 underwater, other grades do not interfere; for foundation and structure, there is interference at C30~C40; therefore, using the switch-case-otherwise structure, first judge the keywords "fine", "water", and strength grade number ≥ 45, and then discuss the structure and foundation. The structure is divided into below C30 and above C30, which can achieve full coverage of the mix ratio and no interference with each other. For C25 and below, use the foundation mix ratio. The following program cannot be constructed: j6 = the strength grade number is less than or equal to 25; ; For C25 and below (jj = 6), use the foundation mix ratio. Because both the foundation mix ratio and the fine aggregate mix ratio have C25 and below. For example, for C25 fine aggregate, j3 = 1; j4 = 0; j5 = 0; j6 = 1; jj = 9. For C45 and above, use the C525 mix ratio. The following program can be constructed: j5 = the strength grade number is greater than or equal to 45; ; For C45 and above (jj = 5), use the C525 mix ratio. Because the C525 mix ratio is for C45 and above, and the fine aggregate mix ratio is for C40 and below, and the two just avoid each other. For example, for C45, j3 = 0; j4 = 0; j5 = 1; jj = 5. For C45 underwater, j3 = 0; j4 = 1; j5 = 1; jj = 9. Since both the C525 mix ratio and the underwater mix ratio have C45, when allocating the mix ratio according to the strength grade, consider the case of jj = 9 to make the program more precise. Note that there are five mix ratios of C45~C60 and C80 in C525; there are six mix ratios of C15~C40 in the foundation; there are three mix ratios of C30~C40 in the structure; there are five mix ratios of C25~C45 in the underwater; there are six mix ratios of C15~C40 in the fine aggregate.

[0054]

[0055] Conclusion 4: Using the principle of singletons to generate a hypothetical temps has several advantages. First, it allows us to determine which parameters need to be generated at the beginning of programming. Second, assigning values ​​to the cells in temps first, and then writing the quality certificate from temps, avoids confusion. Third, the i-th row and j-th column of temps can act as a variable, eliminating the need to think of 46 unique variable names from scratch.

[0056] Conclusion 5: The certificate of quality assurance date and the strength grade number are two anchor points. A specific line (line w) can be found in the certificate of quality assurance and entered into the quality certificate for that day; similarly, a specific line (line z) can be found in the mix proportion library (foundation, structure, underwater, fine aggregate, C525) and entered into the quality certificate for that day. For structural mix proportions of C30~C40, to make C30 the first line, z = 30 / 5 - ? = 1, so ? = 5. Therefore, the anchor point between the structural mix proportion and the quality certificate is z = 30 / 5 - 5 = strength grade number / 5 - 5. For fine aggregate mix proportions of C15~C40, to make C15 the first line, z = 15 / 5 - ? = 1, so ? = 2. Therefore, the anchor point between the fine aggregate mix proportion and the quality certificate is z = 15 / 5 - 2 = strength grade number / 5 - 2. If C45 is to be added to the structural mix proportion in the future, it can be added directly to the structural mix proportion. Simply add the C45 mix proportion to a new row in the Excel spreadsheet. No changes to the Matlab program are needed. This method allows the mix proportion database to expand automatically without requiring Matlab debugging. The row index of the row where w = (the date on the quality assurance certificate equals one day before the date cycle value) is used. Because the date cycle value is dynamic, the electronic ledger of quality assurance certificates can be expanded indefinitely. For example, updating to April 5, 2042, requires no Matlab debugging; the system can automatically find the row for April 5, 2042 in the electronic ledger using the date cycle value April 6, 2042. No matter how sophisticated the later mix proportion decision tree (jj) becomes, it still requires the two dynamic anchor points w and z as structural support. These two anchor points are cleverly designed to capture the core concepts. If the program were written so that when calculating the mix proportions, if the quality certificate shows C30, it reads the line below the mix proportion; if it shows C35, it reads the line below; and if it shows C40, it reads the line below. Later, when the mix proportion database changes, the program would also need to be modified. Each program is a self-contained, complete language, and making changes after a long time often results in errors. Finding even minor bugs can sometimes be more time-consuming than rewriting the program. Similarly, if a separate electronic ledger of quality assurance certificates is created each week, and the quality certificate for the first day of a week reads the first line, the second day reads the second line, and so on, up to the seventh day, it would be too rigid. It wouldn't be able to generate tens of thousands of quality certificates with a single click, and the quality assurance certificate database could only be updated to a limited extent, not expanded indefinitely.

[0057] Example 2: This example provides a system for writing mixing ratio information into a quality certificate. The system for writing mixing ratio information into a quality certificate includes a hardware system (see below). Figure 3 As shown, the software system is... Figure 4 As shown.

[0058] Hardware System It includes input devices, a processor, memory, and output devices. The processor includes an arithmetic logic unit (ALU) and a control unit. The ALU is used to execute the program in each small box, and the control unit is used to determine the execution order. The memory is used to store the quality certificate template, mixing ratio, quality assurance certificate, and code for writing the quality certificate, which are to be written with the mixing ratio information. Software System It includes programming software, import and read modules, generation and write modules, and document software; the programming software is used to input the folder path of the quality certificate and the supply date; the document software is used to output the quality certificate as an Excel document; the import and read modules are used to import the mixing ratio, quality assurance certificate, and read the parameters of the imported files; the generation and write modules are used to generate and write the various parameters of the mixing ratio information in the quality certificate.

[0059] Example 3: This example provides an application of a system for writing mix proportion information in a quality certificate, including: Download Matlab software; Copy the electronic versions of the quality certificate template, structural proportions, basic proportions, underwater proportions, C525 proportions, fine aggregate proportions, and quality assurance certificate (to be written with the mix proportion information) to the quality certificate folder; Update the quality assurance certificate. The quality assurance certificate is entered into the computer based on the corresponding paper version. The quality assurance certificate form has 19 columns, with two columns for each type of raw material: quality assurance certificate number and retest number. There are a total of 9 types of raw materials, including P·O42.5 cement, P·II52.5 cement, THJ-16 admixture, THJ-28 admixture, mineral powder, manufactured sand, 5-16mm aggregate, 5-25mm aggregate, and fly ash. The purchase date is in a separate column. The purchase date is set to date format in Excel. If there are multiple batches in a day, enter the first batch. If there is no purchase on a certain day, enter the quality assurance certificate number of the most recent purchase. The quality assurance certificate number and retest number must be filled in for 365 days a year. If there is no purchase record for a day, copy the number information from the previous day to this day. Fill in the quality certificate template for the mix proportion information to be written. Among the six major raw materials, cement, sand, stone, admixtures, fly ash and mineral powder, only the cement and admixtures should be left blank. The other raw material types should be written in advance. Only the cement manufacturer's name (abbreviated as factory name) should be left blank. The factory names of the other raw materials should be written in advance. Open Matlab, enter the start date, end date, and the folder path where the quality certificate is located, start the program, and the quality certificate will be generated automatically. To check quality certificates, you don't need to open each one individually. Simply click on a quality certificate in the folder list, and a preview will appear on the right (see...). Figure 5 As shown), check whether the strength grade and location are matched (only after matching can it be determined whether it belongs to the structural mix proportion, the basic mix proportion, or just the underwater, fine aggregate, and C525 mix proportions). If the strength grade contains "underwater," it is an underwater mix proportion; if the strength grade contains "fine aggregate," it is a fine aggregate mix proportion; if the strength grade is C45 or above, it is a C525 mix proportion; if the strength grade is C30-C40, depending on whether the location belongs to the structural mix proportion, it is a structural mix proportion; if the location belongs to the basic mix proportion, it is a basic mix proportion; if the strength grade is C25 or below, it is a basic mix proportion. The admixture type for the basic and fine aggregate mix proportions is THJ-16; the admixture type for the C525, underwater, and structural mix proportions is THJ-28; the cement type for the C525 mix proportion is P·II 52.5, and the cement plant name is designated manufacturer 1; the cement type for other mix proportions is P·O. 42.5 The cement plant name is designated manufacturer 2, the strength grade contains fine aggregate, and the quality certificate number, retest number, and dosage of 5-25 aggregate are all "-". If any of the above parameters are not met, the corresponding quality certificate shall be deleted. Print, sign, and stamp.

[0060] Furthermore, for various parameters that Matlab software cannot directly read, data conversion functions are required. Specifically, this is achieved through independent data conversion function calls or multi-level nested data conversion functions to convert and integrate the data formats for reading. The start date, end date, and folder path of the quality certificate input in the Matlab programming interface; the date, quality certificate number, and retest number from the quality assurance certificate Excel file; and the strength grade, slump, and raw material usage from basic Excel, structural Excel, fine stone Excel, underwater Excel, and C525 Excel files, are all parameters that Matlab cannot directly read. Instead, the num2str, datenum, datestr, table2cell, str2double, cell2mat, char, double, and string data conversion functions are required. This involves independent function calls or multi-level nested function conversion to convert and integrate the data formats. The multi-function nested conversion command for the quality assurance certificate date is as follows: date_zhibaoshu = datenum((string(table2cell(zhibaoshu(:,1))))). Note that the parameters in the Excel spreadsheet cannot be directly read by the Matlab software.

[0061] The following conclusions can be drawn from Example 3: The application of data conversion functions is a challenge in MATLAB. All parameters in an Excel spreadsheet cannot be read directly and require complex conversion functions, which is prone to errors. MATLAB has over ten data type functions and over ten text type functions; knowing which to convert to is also difficult. For example, `date_zhibaoshu=datenum((string(table2cell(zhibaoshu(:,1)))))` must be converted strictly in this order. If it becomes `date_zhibaoshu=datenum((table2cell(string(zhibaoshu(:,1)))))`, the program will fail and be very difficult to debug. This can cause the program to fail because it cannot read the database and cannot write to the target file. Therefore, it requires technical personnel to engage in deep cross-industry learning, deeply integrating information technology with traditional manufacturing, breaking down professional barriers, and thus realizing new applications of MATLAB software in the concrete industry.

[0062] Comparative Example 1 This comparative example is used to verify that automatically writing the mixing ratio information into the quality certificate is more time-saving and labor-saving than manually writing it.

[0063] The method for writing mix proportion information in the quality certificate is as follows: Taking the quality certificate of task order number 182 as an example, its strength grade is C35P6 and the project part is the exterior wall. Therefore, it belongs to the structural mix proportion. According to the structural mix proportion, the slump, mix proportion, cement type and manufacturer, and admixture type are written, as shown in Figure 6.

[0064] Then, according to the paper ledgers of the 6 raw material quality assurance certificates, write down the quality assurance certificate number and retest number, as shown in Figure 7. Note that the paper quality assurance certificate ledgers group P·O42.5 cement and P·II52.5 cement together, THJ-16 admixture and THJ-28 admixture together, and 5-16mm aggregate and 5-25mm aggregate together, so there are 6 paper ledgers.

[0065] As a result, it took 32 minutes to handwrite the mixing ratio information for 14 quality certificates in one day (2 minutes for each certificate, and 4 minutes for the first one because the quality certificate number for that day needed to be updated). Therefore, it took 224 minutes (3 hours and 44 minutes) to write 98 quality certificates for a week (usually 14 per day).

[0066] Example 1 can automatically write the mixing ratio information into the quality certificates. As a result, it automatically writes the mixing ratio information for 10 quality certificates per minute, so automatically writing the mixing ratio information for 98 quality certificates for one week takes 10 minutes. Manually updating the electronic ledger of raw material quality assurance certificates (referred to as quality assurance certificates, which include the quality assurance certificate numbers and retest numbers of 9 raw materials) for one week takes 18 minutes. Therefore, automatically writing the mixing ratio information for 98 quality certificates for one week takes a total of 28 minutes. Automatic writing takes one-eighth of the time required for manual writing.

[0067] In addition, automatic writing solves the following problems associated with handwritten mix proportion information: the positions of cells in the mix proportion are different from those in the quality certificate; when copying raw material usage, the mouse is constantly clicking on cells in both the mix proportion and the quality certificate, switching back and forth, which is noisy; and one must also select one of the five mix proportion tables (structure, foundation, fine stone, underwater, and C525); sometimes when copying, the dialog window shows that the cell format is inconsistent and cannot be copied, so the usage can only be entered manually (because there are merged cells); it can copy the usage of 8 kinds of raw materials in 2 minutes, during which the mouse is clicked 16 times between the quality certificate and the quality assurance certificate (one click for copying and one click for pasting), that is, 320 clicks in 40 minutes, which can easily lead to finger fatigue and tendonitis.

[0068] Comparative Example 2 This comparative example illustrates that the electronic ledger of raw material quality assurance certificates is accessible, while the data in the paper ledger cannot be easily accessed.

[0069] This is because the electronic ledger of raw material quality assurance certificates has a total of 19 columns, see Figure 8 As shown, each raw material is listed in two columns: quality assurance certificate number and retest number. There are a total of nine raw materials, including P·O42.5 cement, P·II52.5 cement, THJ-16 admixture, THJ-28 admixture, mineral powder, manufactured sand, 5-16mm aggregate, 5-25mm aggregate, and fly ash. The delivery date is listed in a separate column. THJ-16 admixture and THJ-28 admixture are listed in separate columns; these two admixtures are not mixed in one column to ensure quality. When calculating the strength grade of fine aggregate, temps(i,23:24)=zhibaoshu(w,6:7); note that columns 6 and 7 of the quality assurance certificate are for THJ-16 admixture. When determining the underwater strength rating, temps(i,23:24)=zhibaoshu(w,8:9); note that columns eight and nine of the quality assurance certificate are for THJ-28 admixture. Note that a(i,j) represents a single cell in row i and column j of table a.

[0070] The column indices of the hypothetical `temps` table remain unchanged, while the column indices of the `zhibaoshu` (quality assurance certificate) are changed. `temps(i,j)` is a variable, and `zhibaoshu(i,j)` is the database. The intelligence of the `temps` table (`temps(i,23:24)` has different values ​​depending on the intensity level) and the compliance of the `zhibaoshu` table ensure the automatic writing of the mix proportion information.

[0071] However, in the paper ledger of raw material quality assurance certificates, THJ-16 admixture and THJ-28 admixture are mixed in one column, as shown in Figure 7(d), and the quality assurance certificate number cannot be directly written into the quality certificate using the position index.

[0072] In summary, this application achieves fully automated generation of concrete quality certificates by constructing an adaptive matching system based on dynamic dual anchor points (date index w and strength grade mapping z), combined with a data preprocessing layer (temps table), a multi-state decision engine (jj), and a cross-platform format compatibility mechanism. This achieves the following technical effects: efficiency improvement of over 8 times, saving over 19 working days annually; enabling unlimited data expansion and zero-maintenance adaptation; resolving the contradiction of traditional industries being unable to afford customized systems; and freeing technical personnel from repetitive tasks to high-value work.

[0073] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and not to limit them; although the present invention has been described in detail with reference to preferred embodiments, those skilled in the art should understand that modifications can still be made to the specific implementation of the invention or equivalent substitutions can be made to some technical features without departing from the spirit of the technical solutions of the present invention, and all such modifications and substitutions should be covered within the scope of the technical solutions claimed in the present invention.

Claims

1. A method for writing mixing ratio information in a quality certificate, characterized in that, It includes the following steps: S1. Construct a for-date loop structure to iteratively write the mix ratio information of the quality certificates for a total of m days from the start date to the end date. Within the for-date loop structure, for the quality certificate on the date of the date loop value (the date loop value is the concrete supply date), perform the subsequent operation steps; S2. Use the table function to create a hypothetical temps table with 46 columns, set the column type to string, and the column names are {cement type... impermeability number}, a total of 46; S3. Use the detectImportOptions function to import the mix ratio and raw material quality certificates. The mix ratio includes the following five tables: foundation, structure, underwater, fine aggregate, C525; S4. Use the find function to find the row index w of the raw materials purchased one day before the concrete supply date in the raw material quality certificate; S5. Construct a for-work order loop structure to iteratively write the mix ratio information of the first quality certificate to the nth quality certificate on the date of the date loop value. Within the for-work order loop structure, for the ith quality certificate, read the strength grade and engineering location, and perform the subsequent operation steps; S6, classify the mix proportions to construct j3 = the number of strength grades containing the word "fine"; j4 = the number of strength grades containing the word "water"; j5 = strength grade ≥ C45; ; S7. Use the switch-case-otherwise structure to classify and write the mix ratio, admixture variety, admixture quality certificate number, and admixture re-inspection number. First, judge whether the strength grade contains "water" or "fine". If it contains "fine", use the fine aggregate mix ratio; if it contains "water", use the underwater mix ratio; in the case of not containing "water" or "fine", for grades C25 and below, use the foundation mix ratio, for grades C30 - C40, use the structure and foundation mix ratios, and for grades C45 and above, use the structure mix ratio; S8. Use the if structure to classify and write the cement variety, cement manufacturer, cement quality certificate number, and cement re-inspection number. If the strength grade ≥ C45, use P·II52.5 cement; if the strength grade < C45, use P·O42.5 cement; S9. Use the if structure to classify and write the quality certificate number, re-inspection number, and dosage of 5 - 25 mm aggregate. All strength grades use 5 - 16 mm aggregate; when the strength grade contains "fine", only use 5 - 16 mm aggregate. When the strength grade does not contain "fine", use 5 - 16 mm aggregate and 5 - 25 mm aggregate, and the dosage of 5 - 25 mm aggregate is 700, and the dosage of 5 - 16 mm aggregate is the total aggregate dosage - 700; S10. Retrieve the quality certificate numbers and re-inspection numbers of fly ash, slag, manufactured sand, and 5 - 16 mm aggregate in the wth row of the raw material quality certificate, assign them to the corresponding cells in the ith row of the temps table, and use the xlswrite function to write the quality certificate numbers and re-inspection numbers of fly ash, slag, manufactured sand, and 5 - 16 mm aggregate, the dosage of 5 - 16 mm aggregate, and the dosage of admixture to the corresponding positions of the quality certificate.

2. The method for writing mixing ratio information in a quality certificate according to claim 1, characterized in that, The specific steps of step S4 are as follows: The date of the quality certificate is obtained through the try-catch-end structure, specifically: Judge the date of the quality certificate. If it is in character format, change it to date format; if it is in numeric format, add 69390.

3. The method for writing mixing ratio information in a quality certificate according to claim 1, characterized in that, In step S6, the strength grade is configured as a single cell, meaning the number of strength grades is either 0 or 1. When the strength grade contains "fine," j3=1; when the strength grade does not contain "fine," j3=0. When the strength grade contains "water," j4=1; when the strength grade does not contain "water," j4=0. When the number of strength grades is ≥45, j5=1; when the number of strength grades is <45, j5=0. In other words, when the strength grade contains "fine," When the strength rating contains "water", When the strength grade is ≥C45 and does not contain "water", When the strength grade contains "water" and the strength grade is ≥C45, The method for obtaining the intensity level number is as follows: use the find function to find the position index of C in the intensity level, assign this index to temp, and the intensity level number = the temp+1 and temp+2 characters in the intensity level.

4. The method for writing mixing ratio information in a quality certificate according to claim 1, characterized in that, The specific steps of step S7 are as follows: When jj=3, retrieve the amount of each raw material in row z of the fine stone mix proportion and assign it to the corresponding cell in row i of the temps table. z=strength grade number / 5-2. At this time, the admixture type in column 4 of row i of the temps table is "THJ-16". Retrieve the quality assurance certificate number and retest number of admixture THJ-16 in columns 6-7 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table. Retrieve the data in the mix proportion and quality assurance certificate and assign them to temps. Then write the quality certificate directly from temps. When jj=4, retrieve the amount of each raw material in row z of the underwater mix proportion and assign it to the corresponding cell in row i of the temps table. z=strength grade number / 5-4. At this time, the admixture type in column 4 of row i of the temps table is "THJ-28". Retrieve the quality assurance certificate number and retest number of admixture THJ-28 in columns 8-9 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table. When jj=9, retrieve the amount of each raw material in row z of the underwater mix design and assign it to the corresponding cell in row i of the temps table. z=strength grade number / 5-4. At this time, the admixture type in column 4 of row i of the temps table is "THJ-28". Retrieve the quality assurance certificate number and retest number of admixture THJ-28 in columns 8-9 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table. When jj=5, retrieve the amount of each raw material in row z of the C525 mix proportion and assign it to the corresponding cell in row i of the temps table. z=strength grade number / 5-8. At this time, the admixture type in column 4 of row i of the temps table is "THJ-28". Retrieve the quality assurance certificate number and retest number of admixture THJ-28 in columns 8-9 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table. In other cases, where the strength grade does not contain "fine" or "water" and is C40 or below, the contains function is used to determine whether the engineering part belongs to the structure or the foundation: If it belongs to the structure, then determine whether the strength grade is greater than C25: If the strength grade > C25, retrieve the amount of each raw material in row z of the structural mix proportion and assign it to the corresponding cell in row i of the temps table, z = strength grade number / 5 - 5. At this time, the admixture type in column 4 of row i of the temps table is "THJ-28". Retrieve the quality assurance certificate number and retest number of admixture THJ-28 in columns 8-9 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table; If the strength grade ≤ C25, retrieve the amount of each raw material in row z of the basic mix proportion and assign it to the corresponding cell in row i of the temps table, z = strength grade number / 5 - 2. At this time, the admixture type in column 4 of row i of the temps table is "THJ-16". Retrieve the quality assurance certificate number and retest number of admixture THJ-16 in columns 6-7 of row w of the raw material quality assurance certificate and assign them to columns 23-24 of row i of the temps table; If it belongs to the basic, retrieve the amount of each raw material in row z of the basic mix proportion and assign it to the corresponding cell in row i of the temps table. z = strength grade number / 5 - 2. At this time, the admixture type in column 4 of row i of the temps table is "THJ-16". Retrieve the THJ-16 admixture quality assurance certificate number and retest number in row w of the raw material quality assurance certificate and assign them to columns 23 to 24 of row i of the temps table. The xlswrite function is used to write the admixture type, slump, water consumption, cement consumption, mineral powder consumption, fly ash consumption, sand consumption, admixture quality assurance certificate number, and admixture retest number from temps(i,4), temps(i,8) to temps(i,13), temps(i,23), and temps(i,24) into the corresponding positions on the quality certificate. temps(i,4) represents the 4th column of the i-th row of the temps table.

5. A method for writing mixing ratio information in a quality certificate according to claim 4, characterized in that, In step S7, under other circumstances, the contains function is used to determine whether the engineering part belongs to the structure or the foundation. The specific steps are as follows: if the part contains "beam, column, shaft, brace, tower, bearing, wall, frame, slab, structure, frame, joint, staircase, bridge abutment, pier" but does not contain "raft slab, bottom slab, parapet wall, guide wall, crash barrier, retaining wall, water retaining wall, pergola", and the strength grade is C25 or above, then it is a structure; otherwise, it is a foundation.

6. The method for writing mixing ratio information in a quality certificate according to claim 1, characterized in that, The specific steps of step S8 are as follows: If the strength grade ≥ C45, the cement type in the first column of the i-th row of the temps table is "P·II52.5", and the cement manufacturer in the fifth column of the i-th row of the temps table is "Designated Manufacturer 1". Retrieve the quality certificate number and retest number of P·II52.5 cement in the fourth and fifth columns of the w-th row of the raw material quality certificate and assign them to the 21st and 22nd columns of the i-th row of the temps table. If the strength grade < C45, the cement type in the first column of the i-th row of the temps table is "P·O42.5", and the cement manufacturer in the fifth column of the i-th row of the temps table is "Designated Manufacturer 2". Retrieve the quality certificate number and retest number of P·O42.5 cement in the second and third columns of the w-th row of the raw material quality certificate and assign them to the 21st and 22nd columns of the i-th row of the temps table. Use the xlswrite function to write the cement type, cement manufacturer, cement quality certificate number, and cement retest number of temps(i,1), temps(i,5), temps(i,21), and temps(i,22) into the corresponding positions of the quality certificate respectively, that is, P·II52.5 cement is used for grades C45 and above and the corresponding manufacturer is changed, and P·O42.5 cement is used for grades below C45 and the corresponding manufacturer is changed.

7. A method for writing mixing ratio information in a quality certificate according to claim 1, characterized in that, The specific steps of step S9 are as follows: If jj = 3, the amount of 5-25mm aggregate in the second column of the i-th row of temps is "-", the amount of 5-16mm aggregate in the third column of the i-th row of temps is the total amount of aggregate in the 14th column of the i-th row of temps, and the quality certificate number and retest number of 5-25mm aggregate in the 25th and 26th columns of the i-th row of temps = {"-","-"}, that is, 5-25mm aggregate is not used in the quality certificate at this time; If jj ≠ 3, the amount of 5-25mm aggregate in the second column of the i-th row of temps is 700, the amount of 5-16mm aggregate in the third column of the i-th row of temps is the total amount of aggregate in the 14th column of the i-th row of temps - 700, and the quality certificate number and retest number of 5-25mm aggregate in the 25th and 26th columns of the i-th row of temps = the 16th and 17th columns of the w-th row of the raw material quality certificate; Use the xlswrite function to write the quality certificate number, retest number, and amount of 5-25mm aggregate of temps(i,25), temps(i,26), and temps(i,2) into the corresponding positions of the quality certificate respectively.

8. A system for writing mixing ratio information in a quality certificate, characterized in that, It includes a hardware system and a software system. The hardware system 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 programs in each small box, and the controller is used to determine the execution order. The memory is used to store the quality certificate template for writing mix ratio information, the mix ratio, the quality certificate, and the code for writing the quality certificate. The software system includes programming software, an import and read module, a generation and write module, and document software. The programming software is used to input the folder path and supply date of the quality certificate; the document software is used to output the quality certificate as an Excel document; the import and read module is used to import the mixing ratio, quality assurance certificate, and read the parameters of the imported file; the generation and writing module is used to generate and write the various parameters of the mixing ratio information in the quality certificate.

9. The application of the system for writing mixing ratio information in a quality certificate according to claim 8, characterized in that, Includes the following steps, Download Matlab software; Copy the electronic versions of the quality certificate template, structural proportions, basic proportions, underwater proportions, C525 proportions, fine aggregate proportions, and quality assurance certificate to the quality certificate folder; Update the quality assurance certificate. The quality assurance certificate is entered into the computer according to the corresponding paper version. The quality assurance certificate form has 19 columns. Each raw material has two columns: quality assurance certificate number and retest number. There are a total of 9 raw materials, including P·O42.5 cement, P·II52.5 cement, THJ-16 admixture, THJ-28 admixture, mineral powder, manufactured sand, 5-16mm stone, 5-25mm stone, and fly ash. The purchase date is in a separate column. The purchase date is set to date format in Excel. If there are multiple batches in one day, the first batch is entered. If there is no purchase on a certain day, the quality assurance certificate number of the most recent purchase is entered. Fill in the quality certificate template for the mix proportion information to be written. Among the six major raw materials, cement, sand, stone, admixtures, fly ash and mineral powder, only the cement and admixtures should be left blank. The other raw material types should be written in advance. Only the cement manufacturer's name should be left blank. The manufacturer's name of the other raw materials should be written in advance. Open Matlab, enter the start date, end date, and the folder path where the quality certificate is located, start the program, and the quality certificate will be generated automatically. For manual inspection of quality certificates, do not open each certificate individually. Click on a quality certificate in the folder list; a preview will appear on the right. Check if the strength grade and location match the mix proportions. If the strength grade includes "underwater," it is an underwater mix proportion; if it includes "fine aggregate," it is a fine aggregate mix proportion; if the strength grade is C45 or higher, it is a C525 mix proportion; if the strength grade is C30-C40, the mix proportion is structural if the location is structural, and basic if the location is foundation; if the strength grade is C25 or lower, it is a basic mix proportion. The admixture type for foundation and fine aggregate mix proportions is THJ-16; the admixture type for C525, underwater, and structural mix proportions is THJ-28; the cement type for the C525 mix proportion is P·II 52.5, and the cement plant name is designated manufacturer 1; the cement type for other mix proportions is P·O. 42.5 The cement plant name is designated manufacturer 2, the strength grade contains fine aggregate, and the quality certificate number, retest number, and dosage of 5-25 aggregate are all "-". If any of the above parameters do not meet the requirements, the corresponding quality certificate shall be deleted. Print, sign, and stamp.

10. The application of the system for writing mixing ratio information in a quality certificate according to claim 9, characterized in that, For various parameters that MATLAB software cannot directly read, data conversion functions are required. Specifically, this is achieved by calling independent data conversion functions or by nesting multiple layers of data conversion functions to convert and integrate the data format for reading.

Images