Automatic batch calculation method and system for pile foundation bearing capacity

Abstract

The invention relates to the technical field of foundation engineering, in particular to an automatic batch calculation method and system for pile foundation bearing capacity, and the method comprises the steps: inputting geological and pile foundation parameters in batches, and storing the geological and pile foundation parameters as structured data after automatic verification and formatting; original load data are integrated, and the most unfavorable load combination working condition of each pile is automatically generated; data and working conditions are read, a calculation model is automatically selected, single pile bearing capacity calculation and additional checking calculation are executed, and calculation of all pile foundations is completed through batch processing; and generating a visual chart and a standardized report. The system comprises a data input module, a database module, a multi-working-condition analysis module, a calculation engine module and a result output and visualization module. According to the method, automatic batch calculation can be achieved, the calculation time of thousands of piles is shortened to several minutes to hours, efficiency and design safety are improved, and the method is suitable for large-scale projects such as wind power projects and photovoltaic projects.

Description

Technical Field

[0001] This invention belongs to the field of basic engineering technology, specifically relating to an automated batch calculation method and system for pile foundation bearing capacity. Background Technology

[0002] Cast-in-place piles and precast piles are widely used pile foundations in foundation engineering. The scientific determination of their bearing capacity is a core element in ensuring the safety and stability of the engineering structure and achieving a balance between project economics and safety. Currently, in domestic and international industry practice, the determination of pile foundation bearing capacity mainly relies on two technical approaches: field testing methods and theoretical calculation methods. Both methods have their own characteristics and significant limitations.

[0003] Among field testing methods, static load testing is the most representative technique. It involves directly applying loads to a prototype pile and measuring the relationship between pile top settlement and load values ​​to determine the ultimate bearing capacity of the pile foundation. Due to its directness and reliability, this method is often regarded by the industry as the benchmark for determining pile foundation bearing capacity. However, the inherent limitations of static load testing are also prominent: from a cost and efficiency perspective, prototype pile static load testing is time-consuming, labor-intensive, and expensive, making it difficult to conduct comprehensive testing on all pile foundations in large-scale engineering projects; from an adaptability perspective, static load testing faces technical feasibility obstacles in special engineering scenarios such as large-diameter piles, pile tops near water surfaces, or pile locations where excavation is impossible; furthermore, while non-destructive testing techniques such as low-strain reflected wave methods can be used for pile integrity assessment, they cannot directly calculate bearing capacity, and these methods also have additional limitations such as significant differences in applicability under different engineering conditions and difficulty in interpreting test results.

[0004] Compared to field testing methods, theoretical calculation methods rely on national and industry standards such as the "Technical Code for Building Pile Foundations." They combine pile foundation geometric parameters (such as pile diameter d and pile length L) with geotechnical physical and mechanical parameters provided in geological survey reports (such as soil cohesion c, internal friction angle φ, and soil weight γ) to calculate bearing capacity using empirical or semi-empirical formulas. While this method offers advantages such as lower cost and ease of operation, its technical limitations are also significant: Firstly, most bearing capacity calculation formulas are empirical and regionally specific, lacking universality and leading to deviations in calculation results across different regions and standard systems. Secondly, theoretical calculations require engineers to manually process massive amounts of geological survey data, analyze complex load combinations, and perform segmented calculations of the physical and mechanical parameters of different soil layers. In engineering scenarios involving hundreds or thousands of pile foundations, such as large wind farms, photovoltaic power stations, and long-distance transmission lines, this manual operation mode is not only inefficient but also faces a high risk of calculation errors, making it difficult to meet the needs of engineering practice.

[0005] The aforementioned traditional methods are essentially single-point, localized verification modes for individual or a few pile foundations. Under the demands of modern engineering for large-scale and multi-condition bearing capacity analysis, the drawbacks of this paradigm, such as inefficiency, high cost, and inability to iterate quickly, have been dramatically amplified.

[0006] Taking offshore wind power projects as an example, the project needs to simultaneously consider the most unfavorable combination of various loads such as foundation self-weight, wind turbine operating load, wave force, water flow force, and seismic action. Moreover, such loads have dynamic changes in the time dimension and need to act on thousands of pile foundations in the spatial dimension. The traditional single calculation mode can no longer cope with this engineering challenge of complexity and scale, and the need for upgrading the technical paradigm is becoming increasingly urgent.

[0007] In view of this, the present invention is hereby proposed. Summary of the Invention

[0008] In order to solve the above-mentioned technical problems in the prior art, the present invention provides an automated batch calculation method and system for pile foundation bearing capacity, which solves the technical defects of existing pile foundation bearing capacity calculation methods, such as low efficiency, cumbersome manual operation, difficulty in performing batch analysis of multiple working conditions, and susceptibility of calculation results to human error.

[0009] To achieve the above objectives, the technical solution of the present invention is as follows: Firstly, an automated batch calculation method for pile foundation bearing capacity includes: S1. Input geological parameters and pile foundation parameters in batches, perform automatic verification and formatting on the parameters, and store the unstructured data after converting it into structured data. S2. Integrate the original load data and automatically generate the most unfavorable load combination for each pile according to the preset engineering specifications. S3. Read the structured data and the most unfavorable load combination, automatically select the bearing capacity calculation model, perform single pile bearing capacity calculation and additional verification, and use batch processing to complete batch calculation for all pile foundations. S4. Read the results of the batch calculation and generate visualization charts and standardized reports.

[0010] Furthermore, the pile foundation parameters include at least the unique identifier of each pile, the pile diameter, the pile length, and for piles with enlarged bases, the enlarged base diameter; The geological parameters include at least the cohesion, internal friction angle, soil weight, and effective overburden pressure of each soil layer within the pile foundation engineering area.

[0011] Furthermore, the original load data includes at least vertical loads and horizontal loads. Vertical loads include the structural self-weight and equipment loads, while horizontal loads include wind loads and seismic forces.

[0012] Furthermore, the most unfavorable load combination includes at least three load conditions: Condition 1, Condition 2, and Condition 3, and the maximum pressure and maximum pull-out force at the pile top are calculated for each load condition.

[0013] Furthermore, the calculation of the single pile bearing capacity includes: The formula for calculating the standard value of vertical ultimate bearing capacity is as follows:

[0014] in, This represents the standard value of the ultimate lateral resistance of a single pile (kN). The standard value of the ultimate end resistance of a single pile (kN); Ultimate side drag calculation: The formula for calculating the pile friction resistance of sandy soil is obtained by summing the lateral resistance of each soil layer around the pile:

[0015] in, The lateral pressure coefficient of the soil layer. The effective overburden pressure (kPa) is the soil layer. It is the friction angle between the pile and the soil.

[0016] Furthermore, it also includes: Ultimate end resistance calculation: For piles with equal diameter, empirical formulas are used to calculate the resistance based on the nature of the bearing stratum at the pile tip; for piles with enlarged base, standard formulas related to the enlarged base diameter D are used for calculation.

[0017] Furthermore, the additional verification includes verification of the pile reinforcement ratio, pile buckling, and bearing capacity of the underlying soft layer below the pile tip plane.

[0018] Furthermore, the visualization charts include a bearing capacity distribution chart and a reinforcement ratio chart; The standardized report includes a structured data report in Excel format and a PDF document that meets engineering design requirements. The report automatically includes calculation parameters, core results, and verification conclusions.

[0019] Furthermore, step S3 also includes a reverse computation mode: Given the preset bearing capacity requirements, the minimum pile length that simultaneously meets both compressive and tensile bearing capacity is automatically found by iteratively calculating the pile bearing capacity layer by layer.

[0020] Secondly, an automated batch calculation system for pile foundation bearing capacity includes: The data input module is used to read pile foundation parameters, geological parameters and load data in batches, and to automatically verify and format the data, converting unstructured data into structured data. A database module, connected to the data input module, is used to centrally store the structured data output by the data input module, intermediate calculation results, and final report data. The multi-condition analysis module is connected to the data input module and the database module respectively, and is used to receive raw load data and automatically generate the most unfavorable load combination conditions for each pile according to the preset engineering specifications. The calculation engine module is connected to the database module and the multi-condition analysis module respectively. It is used to read structured data and the most unfavorable load combination conditions, automatically select the bearing capacity calculation model, perform single pile bearing capacity calculation and additional verification, and complete the calculation of all pile foundations in batch processing mode. The results output and visualization module is connected to the database module and the computing engine module to read the calculation results and generate visualization charts and standardized reports.

[0021] Compared with existing technologies, the present invention provides an automated batch calculation method and system for pile foundation bearing capacity. The method includes: batch inputting geological and pile foundation parameters, automatically verifying and formatting them, and storing them as structured data; integrating original load data and automatically generating the most unfavorable load combination for each pile; reading the data and load conditions, automatically selecting a calculation model, performing single-pile bearing capacity calculations and additional verifications, and completing all pile foundation calculations in batch processing; generating visual charts and standardized reports. The system includes a data input module, a database module, a multi-load condition analysis module, a calculation engine module, and a result output and visualization module. This invention enables automated batch calculations, reducing the calculation time for thousands of piles to minutes to hours, improving efficiency and design safety, and is suitable for large-scale projects such as wind power and photovoltaic projects. Attached Figure Description

[0022] Figure 1 A flowchart of an automated batch calculation method for pile foundation bearing capacity provided in an embodiment of the present invention; Figure 2 This is an architecture diagram of an automated batch calculation system for pile foundation bearing capacity provided in an embodiment of the present invention. Figure 3 A flowchart illustrating the integration and combination of multi-condition load data provided in this embodiment of the invention; Figure 4 A flowchart illustrating data processing and visualization provided for embodiments of the present invention. Detailed Implementation

[0023] The technical solution of the present invention will be clearly described below with reference to the accompanying drawings. Obviously, the described embodiments are not all embodiments of the present invention. All other embodiments obtained by those skilled in the art without creative effort are within the protection scope of the present invention.

[0024] It should be noted that, unless otherwise specifically stated, the relative arrangement and numerical expressions of the components and steps described in these embodiments should not be construed as limiting the scope of the invention.

[0025] The following description of exemplary embodiments is merely illustrative and is not intended to limit the invention or its application or use in any way. Techniques, methods, and apparatus known to those skilled in the art may not be discussed in detail herein, but where applicable, such techniques, methods, and apparatus should be considered part of this specification.

[0026] Example 1 See Figure 1 , Figure 1 This invention provides a flowchart for automated batch calculation of pile foundation bearing capacity, and the specific steps may include: S1. Batch input and preprocessing of geological parameters and pile foundation parameters: Batch input of geological parameters and pile foundation parameters, automatic verification and formatting of the parameters, conversion of unstructured data into structured data and storage; conversion of unstructured data in traditional geological exploration reports into structured data that can be automatically processed by the program.

[0027] Users can organize data into electronic files in preset formats (such as Excel and CSV). The program automatically reads and parses these files, and stores the structured data in the database; the data includes: Pile foundation parameters: unique identifier for each pile, pile diameter d, pile length L, depth of bearing stratum at pile tip, and geometrical dimensions such as enlarged base diameter D for enlarged base piles.

[0028] Geological parameters: Geographic coordinates of each exploration borehole within the pile foundation engineering area, stratigraphic distribution, and physical and mechanical parameters of each soil layer, such as soil cohesion. internal friction angle Soil weight Effective soil pressure wait.

[0029] Other parameters: For example, the empirical index m, determined based on experience, and the correction factor for side resistance due to pile diameter effect. wait.

[0030] This step is the starting point of the entire automation process, aiming to transform unstructured data and engineering design data from traditional geological survey reports into structured data that can be processed automatically by the program. Specifically, it includes: S11. Batch Data Reading: Users organize data into preset format electronic files (such as Excel and CSV). The data input module automatically reads and parses these files, including pile foundation parameters (unique identifier for each pile, pile diameter d, pile length L, etc.) and geological parameters (geographic coordinates of each exploration borehole, stratigraphic distribution, soil cohesion c, internal friction angle). (Soil weight γ, effective overburden pressure P′, etc.). The initial intention of this design was to significantly reduce the amount of manual data entry and lower the human error rate.

[0031] S12. Data Validation and Formatting: The program automatically validates and formats the read data. For example, it automatically maps textual descriptions (such as "dense sand") to predefined ranges of mechanical parameters. S13. Data storage: The formatted data is automatically stored in the database module as a unified and accurate data source for subsequent computing tasks.

[0032] This step involves the standardization and automated mapping of data formats. The program can automatically map textual descriptions in geological reports (such as "dense sandy soil") to corresponding mechanical parameter ranges. This significantly reduces manual data entry and lowers the human error rate, providing an accurate and consistent data foundation for subsequent batch calculations.

[0033] S2, see reference Figure 3 Integration and combination of multi-condition load data: Integrating raw load data and automatically generating the most unfavorable load combination for each pile based on preset engineering specifications; specifically including: Working condition 1: Considering the structural self-weight and equipment load.

[0034] Condition 2: According to the "Code for Design of Building Structures" and other standards, wind load and dead load are combined in a standard manner.

[0035] Working condition 3: Consider the combination of horizontal seismic action and vertical load.

[0036] This step integrates load data from different sources and forms a complete, most unfavorable calculation case according to design specifications. It receives various load data from engineering design models or external data sources, including vertical loads (structural self-weight, equipment loads, etc.), horizontal loads (wind loads, seismic forces, etc.), and other special loads (such as negative skin friction). Based on relevant regulations such as the "Code for Design of Building Pile Foundations," it automatically combines the effects of different loads to form multiple most unfavorable design cases, which are then passed as input to the calculation engine module. This ensures that the design scheme comprehensively and accurately considers all possible stress conditions, thereby improving design safety and avoiding omissions or errors that may occur with manual combinations.

[0037] S3, Core Calculation Engine and Automated Batch Processing: Reads the structured data and the most unfavorable load combination, automatically selects the bearing capacity calculation model, performs single pile bearing capacity calculation and additional verification, and completes batch calculations for all pile foundations using a batch processing method; specifically including: S31. Parameter Acquisition and Model Selection: For each pile, the calculation engine first retrieves its pile foundation parameters and corresponding geological parameters from the database. Then, based on the pile type (e.g., enlarged-base pile) and geological conditions, it automatically selects the appropriate calculation model and standard formula, such as the formula for the ultimate vertical bearing capacity of a single pile in the "Technical Code for Building Pile Foundations".

[0038] S32. Bearing capacity calculation, specifically including: S321. Vertical bearing capacity calculation: The calculation engine calculates the standard value of the vertical ultimate bearing capacity of a single pile according to the following formula. :

[0039] in, This represents the standard value of the ultimate lateral resistance of a single pile (kN). This is the standard value of the ultimate end resistance of a single pile (kN).

[0040] S322, Calculation of ultimate side resistance: The frictional resistance of the pile body is calculated by summing the lateral resistance of each soil layer around the pile. For sandy soil, the frictional resistance of the pile body is... The calculation can be performed using the following formula:

[0041] in, The lateral pressure coefficient of the soil layer. The effective overburden pressure (kPa) is the soil layer. It is the friction angle between the pile and the soil.

[0042] For large-diameter piles, the program will also automatically introduce the side resistance size effect coefficient. A correction is made to reflect the reduction in lateral resistance caused by the increase in pile diameter. Its expression is:

[0043] in, The diameter of the pile (m) is the diameter of the pile body. It is an experience index.

[0044] S323, Calculation of Limiting End Resistance: The calculation is performed based on the soil properties and geometric parameters of the bearing stratum at the pile tip. For expanded-base piles, the corresponding standard formulas are used for calculation.

[0045] S33. Batch Processing: Drawing on automation experience from other fields, the computing engine employs parallel or serial batch processing to perform a single calculation on all pile foundations in the entire project. This mechanism is significantly different from the traditional single-point manual calculation mode. Its initial intention is to completely solve the problem of low computing efficiency in large-scale projects, and its technical effect is to reduce the calculation time for thousands of piles from weeks to minutes.

[0046] S34. Additional verification calculations: In addition to basic bearing capacity calculations, the calculation engine can automatically perform a variety of important safety and stability checks to ensure the overall reliability of the design scheme; specifically including: pile reinforcement ratio verification, pile buckling verification, and bearing capacity verification of the weak underlying layer below the pile tip plane.

[0047] S35, Reverse Calculation Mode: Knowing the preset bearing capacity requirement (maximum pressure at the pile top) Maximum pulling force By iteratively calculating the pile bearing capacity layer by layer, it automatically finds piles that simultaneously meet the compressive bearing capacity requirements. Pull-out bearing capacity The minimum pile length.

[0048] S4. Read the results of the batch calculations and generate visual charts and standardized reports. Specifically, this includes: S41. Result Extraction: After the calculation engine completes the calculation, all results are stored in the database module. The result output module extracts data from the database in batches.

[0049] S42. Report Generation and Visualization: Based on preset templates and logic, the module automatically converts data into various output formats, including structured data reports output in batches in tabular form, as well as automatically generated visualization charts such as bearing capacity distribution diagrams and reinforcement ratio diagrams.

[0050] S43. Standardized Output: The module can automatically generate standardized report files that meet engineering design requirements, greatly reducing the work of manual report writing and formatting.

[0051] This step simplifies the review and delivery of design results, significantly improves the efficiency and quality of the later stages of the design work, and reduces the risk of design errors.

[0052] Example 2 See Figure 2 , Figure 2This is an architecture diagram of an automated batch calculation system for pile foundation bearing capacity proposed in this invention. For a mountain photovoltaic power station project, the project requires bearing capacity calculations for hundreds or thousands of pile foundations (including cast-in-place piles and precast piles), involving complex strata (such as dense sand and stiff plastic clay) and multiple load conditions (structural self-weight, photovoltaic equipment load, mountain wind load, and regional seismic load). Traditional manual calculations require processing each pile individually, resulting in low efficiency and a high risk of errors. This system, through modular integration and automated processes, achieves batch calculations, significantly shortening the calculation cycle. The results meet the requirements of the "Technical Code for Building Pile Foundations," and the entire data is traceable. Specifically, it includes: M1, Data Input Module, used for batch reading of pile foundation parameters, geological parameters, and load data, and automatically verifying and formatting the data to convert unstructured data into structured data; specifically including: The system is developed based on Python and automatically loads the core libraries mentioned in the handover document upon startup: tkinter (GUI construction), pandas (data processing), openpyxl (Excel read / write), and sqlalchemy (database connection). Users can select and import two preset electronic file formats through the M1's GUI interface: "Stratigraphic Parameter Table.xlsx": Borehole number, soil layer name, top / bottom elevation of soil layer, soil cohesion (c), angle of internal friction. , soil weight γ; "Drilling Columnar Section Thickness Information Table.xlsx" (including pile foundation parameters): Pile number, pile top elevation, pile length L, pile diameter d, and enlarged base diameter D (when applicable).

[0053] M11, Batch Data Reading Unit: Used for users to organize data into electronic files (such as Excel, CSV) in preset formats.

[0054] Specifically, through The function automatically reads the above file and extracts pile foundation parameters (such as pile number, pile diameter d, pile length L) and geological parameters (such as soil layer c, ...). (γ), eliminating the need for manual line-by-line entry, reducing workload and error rate.

[0055] M12, Data Validation and Formatting Unit: Used by the program to automatically validate and format the read data. For example, it automatically maps textual descriptions (such as "dense sand") to a predefined range of mechanical parameters.

[0056] Specifically, the data verification passed. Remove rows with empty values ​​for key parameters. If "" is detected (Minimum limit specified), pop up Error message box; The `replace` method and string operations: Replace illegal characters such as "--" and whitespace characters with standard numeric values ​​or empty values. The parameter list is converted to floating point type; at the same time, the textual descriptions of dense sand, stiff plastic clay, etc. are automatically mapped to the system's pre-stored soil mechanical parameter library.

[0057] M13, Data Storage Unit: Used to automatically store formatted data into the database module, serving as a unified and accurate data source for subsequent computing tasks.

[0058] Specifically, verified structured data, through The interface is automatically synchronized to the M2 database and stored according to the data type of the project.

[0059] M2, a database module connected to the data input module, is used to centrally store the structured data output by the data input module, intermediate calculation results, and final report data. This module integrates load data from different sources and forms a complete, most unfavorable calculation case according to design specifications. This module receives various load data from engineering design models or external data sources, including vertical loads (structural self-weight, equipment loads, etc.), horizontal loads (wind loads, seismic forces, etc.), and other special loads (such as negative skin friction).

[0060] According to relevant regulations such as the "Technical Code for Building Pile Foundations," the system automatically combines the effects of different loads to form multiple most unfavorable design conditions, which are then passed as input to the calculation engine module. The initial intention of this design is to ensure that the design scheme can comprehensively and accurately consider all possible stress conditions. The corresponding technical effect is to improve the safety of the design and avoid omissions or errors that may be caused by manual combination.

[0061] M3, the multi-condition analysis module, is connected to the data input module and the database module respectively, and is used to receive raw load data and automatically generate the most unfavorable load combination conditions for each pile according to the preset engineering specifications. M4 and the calculation engine module are connected to the database module and the multi-condition analysis module, respectively. They are used to read structured data and the most unfavorable load combination conditions, automatically select the bearing capacity calculation model, perform single pile bearing capacity calculation and additional verification, and complete the calculation of all pile foundations in batch processing mode. M5, the results output and visualization module, is connected to the database module and the computing engine module to read the calculation results and generate visualization charts and standardized reports.

[0062] Example 3 This invention uses a complete software system as its implementation carrier. This embodiment will explain in detail the specific implementation of the automated batch calculation method of this invention in practice through the execution flow of its internal code logic. (See also...) Figure 4 Specifically, it includes: B1. Software Environment and Dependency Library Initialization: Developed using the Python language, the system first performs initialization operations during program startup, loading the core software packages required to implement various functions, providing basic support for subsequent function calls. These core software packages include: B11 Used to build cross-platform graphical user interfaces (GUIs), providing the windows and controls needed for user interaction; B12 As a data processing library, it is used to read, clean, format, and structure data files. Its core data structure is... ; B13 Provides efficient numerical calculation functions, applicable to matrix and array operations involving pile geometry parameters, bearing capacity formulas, etc. B14 Specifically designed for reading and writing .xlsx format files, it supports fine-grained control over cell styles (such as color fill). B15 As a Python SQL toolkit and object-relational mapping (ORM) library, it is used to implement connections and data interaction with MySQL databases; B16, requests: Used to send HTTP requests to achieve network communication with remote servers. Its core purpose is online verification of user identity and permissions. B17, PIL (Pillow): An image processing library used to load and adapt background images for the interface.

[0063] B18 These are all Python standard libraries used to obtain system environment information when the software starts, specifically including IP address, MAC address, operating system type, username, and current time.

[0064] B2. Database connection initialization: After the program starts, the system calls... The method establishes a persistent connection to a remote MySQL database using a provided connection string. This database is primarily used to record the software's usage status and user logs, ensuring compliance and traceability in its use.

[0065] The database has a predefined table structure containing fields such as time (usage time), ip (device IP address), mac (device MAC address), userName (username), osInfo (operating system information), and status (computation status). This table is used to accurately record software usage time, user identity, and device information, and serves as a security audit log for software usage.

[0066] B3. User Login and Permission Verification: Before the GUI main interface loads, the system verifies user login and permissions. The method sends an HTTP GET request to a pre-defined remote server, including the username, password, and locally obtained hardware information (such as the device's MAC address) entered by the user. The remote server verifies the validity of this information. If the verification passes, the main functional module of the software is activated; if the verification fails, the user is prompted with a login failure message, thus ensuring that only authorized users can use this software system.

[0067] B4. GUI Interface Construction: System Usage The software's core window is constructed, its title and initial size are set, and a background image is loaded via PIL, while the image is scaled to fit the window size. Within the core window, various user input controls are arranged, specifically including: B41, Entry: Used to input numerical parameters such as pile diameter and maximum pressure.

[0068] B42 This allows users to select the pile type (precast pile, cast-in-place pile) and calculation mode (forward calculation, reverse calculation).

[0069] B43, Button: Used to trigger operations such as starting calculations and selecting a working directory.

[0070] B5. Input Parameter Settings: Through various controls in the GUI interface, the system acquires the design parameters input by the user in real time and stores them as internal program variables. These parameters are the basis for all subsequent calculations, including: pile diameter (…). ), the bearing layer entry multiple ( ), maximum pressure ( ), maximum pull-out force ( ) and its magnification factor, usage mode ( ), Pile type ( ), whether to output detailed results ( ) and working directory path ( ).

[0071] Among them, the use of patterns ( ) is an option for forward or reverse calculation; pile type ( The options are precast piles or cast-in-place piles; B6. Data File Reading and Verification: The program reads and verifies data files. The function reads two core data files from the user-specified working directory: B61, Stratigraphic Parameter Table.xlsx: This file is a digital representation of the geological exploration report, containing key geological parameters such as stratigraphic number, standard values ​​of ultimate lateral resistance / end resistance, liquefaction reduction factor, and pull-out coefficient.

[0072] B62, Borehole Columnar Layer Thickness Information Table.xlsx: This file contains detailed stratigraphic information for each borehole, including borehole number, stratigraphic number, layer thickness, elevation, depth, etc.

[0073] B7. Data Cleaning and Formatting: After the data is read, the system uses pandas to perform automated preprocessing operations to ensure data quality and computational reliability. Specific preprocessing operations include: B71 Remove empty rows from key columns (such as stratigraphic number and layer thickness) to avoid interruptions in the calculation process.

[0074] B72, the replace method and string operations: replace illegal characters such as "-", whitespace characters, etc., with standard numerical values ​​or empty values.

[0075] B73 : Force all numeric columns to float type to prevent calculation errors due to data type mismatch.

[0076] B8. Data Association and Merging: The system uses the stratigraphic number expansion key as the association key, through... The process merges the formation parameter table with the borehole columnar section thickness information table to form a unified data table containing all geological and pile information. This step achieves precise matching between pile location and formation parameters, providing a complete data view for subsequent bearing capacity calculations.

[0077] B9. Calculation Mode Determination: The program checks the results obtained in step five. The parameters determine which computational process to execute: Forward calculation: Given the pile length, calculate the bearing capacity corresponding to that pile length.

[0078] Reverse calculation: Under the condition of known bearing capacity requirements, find the minimum pile length that meets the bearing capacity requirements through an iterative method.

[0079] B10. Calculation of pile geometry parameters: For each pile, the system utilizes... The pile's perimeter and cross-sectional area are calculated based on its diameter. The specific calculation formula is as follows:

[0080]

[0081] The calculated pile perimeter and cross-sectional area are the direct input parameters for subsequent calculations of pile side resistance and end resistance.

[0082] B11. Calculation of Size Effect Coefficient: Following the provisions of the "Technical Code for Building Pile Foundations" JGJ94-2008, the program determines whether size effect correction is required by judging the condition "diameter>0.8". If the pile diameter > 0.8 (i.e., a large-diameter pile), the system will call... The formulas for calculating the side drag size effect coefficient and the end drag size effect coefficient are as follows:

[0083]

[0084] The indices of 0.2 and 0.25 are set based on empirical values ​​from the "Technical Specification for Building Pile Foundations" JGJ94-2008.

[0085] B12. Hole-by-Hole Cyclic Processing: The system uses the borehole number as the grouping key to start the main loop, processing the calculation tasks for each borehole (i.e., each pile location) one by one. This grouping processing mode ensures the independence of the calculation for each borehole while guaranteeing the clarity of the calculation results.

[0086] B13. Bearing Layer Judgment and Pile Length Calculation (Forward Mode): In forward calculation mode, the system traverses the stratum data of each borehole and automatically determines the bearing layer where the pile tip is located based on the pile length input by the user. Subsequently, the program adds up the lengths of all soil layers that the pile body passes through to obtain the total pile length, and performs subsequent bearing capacity calculations based on this total pile length.

[0087] B14. Calculation of Side Resistance and End Resistance: Within the loop of step B12, the system again traverses each soil layer traversed by each pile shaft and performs the following operations on each soil layer: B141. The program obtains the ultimate lateral resistance and ultimate end resistance values ​​of the soil layer.

[0088] B142. If the soil layer is located in the liquefaction zone, the system will obtain and apply the liquefaction reduction factor to correct the side resistance.

[0089] B143. If the pile type is an uplift pile, the corresponding uplift coefficient should be used to correct the side resistance.

[0090] B144. If the conditions of step eleven are met, the system will apply the size effect coefficient for correction.

[0091] B145. Multiply the corrected side resistance of each layer by the perimeter and thickness of the pile in that layer to obtain the ultimate side resistance of that layer.

[0092] B146. The ultimate lateral resistance of all soil layers is summed to obtain the ultimate lateral resistance of the pile.

[0093] B147. For the bearing stratum at the pile tip, calculate its end resistance.

[0094] B15. Bearing Capacity Calculation: The system uses the side resistance and end resistance calculated in step B14 to calculate the ultimate bearing capacity of a single pile according to the following formula. and tensile bearing capacity The specific formula is as follows:

[0095]

[0096] After the calculation is complete, the program will automatically determine... and Does it meet the user's settings? and Require.

[0097] B16. Calculation of Weak Underlying Layer: This step enhances the rigor of the calculation. The program automatically determines whether a weak underlying layer exists below the bearing stratum at the pile tip (the criterion is that the bearing capacity of this layer is less than one-third of the bearing capacity of the bearing stratum). If the aforementioned weak underlying layer exists, the system calculates the additional stress acting on the top surface of the weak layer. .

[0098] The calculated The load-bearing capacity characteristic value of the weak layer is compared with the value of the load-bearing capacity characteristic value to determine whether it meets the code requirements, and the verification result is output.

[0099] B17. Pile Length Iteration in Reverse Calculation Mode: In reverse calculation mode, the system calculates the bearing capacity layer by layer, starting from the shallowest layer. The calculated pile length is continuously increased until a pile that simultaneously meets the compressive bearing capacity requirement is found. and tensile bearing capacity The shortest pile length is determined and used as the optimal design value. This iterative process is fully automated and requires no manual calculation.

[0100] B18. Summary of Results and Construction: After completing the calculations for each borehole, the system will store all calculation results (including pile length, bearing stratum, etc.) , A summary of factors such as whether the design requirements are met is compiled and stored in a new file. In the data structure, preparation is made for subsequent batch output.

[0101] B19. Result Output Report Generation: System uses... The method is to generate the product from step eighteen. The results are batch-output to a .xlsx file containing the pile foundation calculation results. Then, the COM interface of Excel is called via win32com.client to automatically adjust the width of each column, ensuring a neat and aesthetically pleasing report format.

[0102] B20. Reverse Calculation Result Write-back and Coloring: In reverse calculation mode, the system will use the minimum pile length value obtained in step seventeen to... The library writes back to the "Pile Length of This Layer" column in the original borehole column layer thickness information table.xlsx file. Simultaneously, the system will use the calculation results... Fill the strata cells in Excel with color, for example, color the bearing strata that meet the bearing capacity requirements, to enhance the intuitiveness and readability of the results.

[0103] B21. Usage information uploaded to the database: As part of software compliance management, the system automatically retrieves local system information (such as...) after the computation task is completed. This includes information such as time, IP address, MAC address, username, and operating system, and transmits this information through... The method is uploaded to the MySQL database established in step two to record software usage logs.

[0104] B22. Progress Bar Simulation and Interface Update: To provide a better user experience, the system uses a progress bar simulation and interface update when performing background computation tasks. of The program uses controls to simulate the calculation progress in real time. The method forces an update to the GUI interface, ensuring smooth progress bar movement so that users can intuitively see the task's execution status.

[0105] B23. Calculation Completion Prompt and Directory Opening: When all calculation tasks are completed, the system will pop up a notification. A notification box informs the user that the calculation is complete. Then, the following is called... The method automatically opens the target directory where the results files are stored, allowing users to access them quickly.

[0106] B24. Exception Handling and User Prompts: This system employs a robust try-except structure to handle errors during critical steps where exceptions may occur, such as file non-existence, incorrect data format, or network connection interruption. If an exception is caught, the program... A user-friendly error message box will pop up to inform the user of the specific error information; at the same time, an exception log will be recorded to prevent the program from crashing.

[0107] B25. Output redirection to GUI text control: To allow users to view the background calculation process and log output in real time, the system will... Redirect to a custom This class appends the print output, which is originally printed to the console, to a text box control in the GUI interface in real time, thus providing real-time feedback on the logs.

[0108] In summary, the present invention has the following advantages: 1. By adopting automated mapping and input of geological parameters, the technical effect of reducing manual data processing and lowering the human error rate was achieved. When handling large-scale projects, this technique reduces data preparation time from several days to several hours, significantly improving work efficiency; 2. By employing a multi-condition combined analysis method, this invention achieves the technical effect of rapidly and comprehensively evaluating the bearing capacity of pile foundations and ensuring design safety under complex stress environments (such as wind power and photovoltaic power). This invention can automatically generate internal force combinations under different working conditions, making the design results closer to the actual stress conditions and avoiding safety hazards caused by omissions or simplifications in the calculations. 3. By adopting automated batch calculation methods, the calculation time for the bearing capacity of thousands of pile foundations has been reduced from weeks using traditional methods to minutes. This allows engineers to compare and optimize multiple schemes in a short time, such as quickly adjusting pile length, pile diameter, or reinforcement to find the most economical and safest design scheme, thereby greatly improving design flexibility and iteration speed. 4. By employing intelligent output and visualization of calculation results, the technology achieves the effects of facilitating rapid review by engineers, reducing misjudgments, and improving design quality. Intuitive charts and structured reports clearly present complex data, making the design review process more efficient and reliable.

[0109] The above specific embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit it. Although the present invention has been described in detail with reference to examples, those skilled in the art should understand that modifications or equivalent substitutions can be made to the technical solutions of the present invention without departing from the scope of the technical solutions of the present invention, and all such modifications or substitutions should be covered within the scope of the claims of the present invention.

Claims

1. A method for automated batch computation of pile foundation bearing capacity, characterized in that, Comprise: S1, batch input geological parameters and pile foundation parameters, automatically check and format the parameters, store the unstructured data into structured data; S2, integrate the original load data, and automatically generate the most unfavorable load combination working condition for each pile according to the preset engineering specification; S3, read the structured data and the most unfavorable load combination working condition, automatically select the bearing capacity calculation model, execute single pile bearing capacity calculation and additional checking, and complete batch calculation of all pile foundations in batch processing mode; S4, read the results of the batch calculation, generate visual charts and standardized reports.

2. The method according to claim 1, wherein, The pile foundation parameters at least include the unique identification of each pile, the pile diameter, the pile length, the expanded pile and the expanded pile diameter; The geological parameters at least include the cohesion, internal friction angle, soil bulk density and effective overburden pressure of each soil layer in the pile foundation engineering area.

3. The method according to claim 1, wherein, The original load data at least includes vertical load and horizontal load, vertical load includes structural weight and equipment load, horizontal load includes wind load and seismic force.

4. The method according to claim 1, wherein, The most unfavorable load combination working condition at least includes working condition 1, working condition 2 and working condition 3, and the maximum pressure and maximum pull force of the pile top under each working condition are calculated.

5. The method according to claim 1, wherein, The single pile bearing capacity calculation includes: The vertical ultimate bearing capacity standard value calculation, the specific formula is: wherein, is the standard value of the ultimate side resistance of the single pile (kN), is the standard value of the ultimate tip resistance of the single pile (kN); Limit side resistance calculation: The formula for calculating the frictional resistance of the pile body in sand is obtained by adding the side resistance of each soil layer around the pile: wherein, Ks is the lateral earth pressure coefficient of the soil layer, Ks is the lateral earth pressure coefficient of the soil layer, Ks is the lateral earth pressure coefficient of the soil layer, 6. The pile capacity automated batch calculation method according to claim 5, wherein, Also include: The limit end resistance calculation: the equal diameter pile is calculated according to the properties of the pile end bearing layer by using the empirical formula, and the expanded pile is calculated by using the specification formula related to the expanded pile diameter D.

7. The method according to claim 1, wherein, The additional checking includes pile reinforcement ratio checking, pile compression checking, and pile end plane below soft underlying layer bearing capacity checking.

8. The method according to claim 1, wherein, The visual chart includes bearing capacity distribution chart and reinforcement ratio chart; The standardized report includes Excel format structured data report and PDF document conforming to engineering design requirements, and the report automatically includes calculation parameters, core results and checking conclusions.

9. The pile capacity automated batch calculation method according to claim 1, wherein, Step S3 also includes reverse calculation mode: Given the preset bearing capacity requirement, the pile bearing capacity is calculated by layer iteration, and the minimum pile length that meets the compression bearing capacity and the pull bearing capacity is automatically found.

10. A system for automated batch computation of pile foundation bearing capacity, characterized in that, Comprise: Data input module, for batch reading pile foundation parameters, geological parameters and load data, automatically checking and formatting the data, and converting unstructured data into structured data; Database module, connected with the data input module, for storing the structured data output by the data input module, the calculation intermediate results and the final report data; Multi-working condition analysis module, connected with the data input module and the database module respectively, for receiving original load data, and automatically generating the most unfavorable load combination working condition for each pile according to the preset engineering specification; Calculation engine module, connected with the database module and the multi-working condition analysis module respectively, for reading the structured data and the most unfavorable load combination working condition, automatically selecting the bearing capacity calculation model, executing single pile bearing capacity calculation and additional checking, and completing the calculation of all pile foundations in batch processing mode; Result output and visualization module, connected with the database module and the calculation engine module, for reading the calculation results, generating visual charts and standardized reports.

Images