Th e ultim ate pile load test is for to verify the ultim ate bearing capacity that is evaluated by the pile design work. N for N < 20 q 0. 99$) pile cap with 04 piles design with strut-and-tie model (1. This spreadsheet is to be used as a tool for design engineers to design pump station and force main systems to connect to the Brunswick County Collection System. Both shallow (e. Product Type: Paid. This design example is for end bearing piles that are driven through cohesive soil and tipped out in rock. Laterally Loaded Pile Design. Boring is executed to the design depth with the use of a crane mounted or a track mounted. txt) or read online for free. 4(1)P states that the design of piles shall be based on one of the following approaches: (1) The results of static load tests, which have been demonstrated by means of calculations or other-wise, to be consistent with other relevant experi-ence,. Design Load ( Vertical) P= 70. This Spread sheet makes you calculate easily Cantilevered Pipe Connection Click here to Download More. Its value ranges commonly from 0. DEPARTMENT/COURSE: Civil Engineering. In fact, implementation of the CPT technology in pile design will reduce the level of uncertainties associated with traditional design methods. xls), PDF File (. 4 Design and construction considerations (6) §6. 1 Pre-cast concrete piles 5. Metric: OD(Outside diameter) in m x 3. The design of deep single-helix Helical Anchors under tension in sands is essentially the same as for compression loading of Screw-Piles in sands. Considering the condition of the layer of the soil, the average friction angle is assumed in this calculation. 99$) Offer full package of Concrete structures design calculation spreadsheet (Eurocode 2) with only 39. (2008), the tensile force to be resisted within the pile cap is given by;. 1Objectives FigureB1. 70 was used for end bearing in rock based on successful past practice with WEAP analysis and the general direction of Iowa LRFD pile testing and research. In case the analysis failed to converge, please try either of the followings: increase the allowable load difference in cell “D41” in Drilled shaft spreadsheet and “D46” in driven pile spreadsheet. In the past years, the market has given priority to hot-rolled steel sheet pile of which the processing method and information can be found everywhere that has been widely recognized. There are two methods/steps to design a pile. Fountain Valley, CA, USA. PILE CAPACITY CALCULATION EXCEL-https:. Wind Load Calculation Excel Program as Per BNBC 2020. 8, respectively. Pile in To start the solution of the problem, ‘‘pile design sand has four subsections namely, geotechnical and in clay’’ section is called from the main page (Fig. 5 + L s = 21 m Design Approach 3 As the R3 recommended partial resistance factors used in DA3 are equal to 1. To find more books about bored pile design calculation, you can use related keywords : Bored Pile Design Calculation, Bored Pile Design Calculation Examples, Jkr Bored Pile Design, Retaining Bored Pile Design, Bored Pile Design And Construction, worked example pile cap design calculation, Contiguous Bored Pile, Secant Pile Pile Cap Design, Pile Calculation Excel, Pile Capacity Calculation. Design of H-Piles at the Abutments • A primary component of integral bridge design is the design of the H-piles supporting the abutment • For longer bridges, the abutments can be subjected to relatively large thermal displacements, which in turn induces large stresses in the H-piles • The PennDOT design procedure employs two primary. It is known in some countries as the Allowable Stress Design (ASD) for the sheet piles. 5" wide x 2" high with. This Spread sheet makes you calculate easily Cantilevered Pipe Connection Click here to Download More. To design the pile itself, since the driving stresses can be determined. , square in plan) with two rows of piles on all 4 sides of the column. 99$) pile cap with 04 piles design with strut-and-tie model (1. Seamless pipe can withstand greater pressures and is commonly used where a perfectly smooth surface is required on the inside of the pipe for transporting of fluids and materials. Further reading shall be done before carrying out design. SECURITY CLASSIF. Design Considerations using Piles. The performance requirements of the 10T Flake Pile Roller Stand were initially determined through Excel spreadsheet calculations. Pile design. LEAP RC-PIER is an integrated application for the analysis and design of reinforced concrete bridge substructures and foundations. As you know, there are so many ways to copy Autodesk® AutoCAD® object(s) to Excel. Pile caps can have any arrangement of piles, automatic placement or user defined. SE::Pile is a computer program for prestressed concrete pile design. Example Calculations forPile Resistance Analysis andVerifications Note: Some of thefollowing examples weretakenfrom[58]. xls: Calculation of axial loaded compression H-piles: 87 kb: Pilecap. Spreadsheet calculations using Florida Department of Transportation (FDOT) FB-Deep and FB-MultiPier computations for skin friction, end bearing and pile tip movement are presented to illustrate the effect of soil settlement on pile settlement, structural integrity and bearing capacity in numerical and graphical formats. Design Load ( Horizontal) Qg = 3. 0 PILE CAP DESIGN. Jan 12, 2021 - Modulus of Sub Grade Reaction for Piles Spreadsheet Download Link. PILE TOE/PILE TIP: The bottom end of a pile. Capacity of pile group is the sum of the individual capacities of piles, but it is influenced by the spacing between the piles. When wind forces are strong enough to influence the foundation design, the crane will have been closed of long ago. Design of Pile Cap Excel Sheet. This application offers an easy and accurate solution for determining the settlement of a rectangular shaped pile-raft foundation. 00 Nominal capacity VNominal capacity , V = 24736 m³ M i d i li id l l HLMaximum design liquid level, HLgq , = 20 70020,700, mm 1. 2007: V-notch weir rating table and design. Pile capacity Meyerhof Method DESIGN CALCULATION FOR PILE LENGTH USING MEYERHOFF FORMULAE. In this example, uplift does not occur. Download CAD block in XLS. Seamless pipe can withstand greater pressures and is commonly used where a perfectly smooth surface is required on the inside of the pipe for transporting of fluids and materials. This spreadsheet was designed to produce flexible pavement design thickness' in accordance with FAA Advisory Circular AC 150/5320-6D, Airport Pavement Design and Evaluation. Cold-bent steel sheet pile is formed by cold-bending machine. : DESIGN OF BORED PILE I. Feb 16, 2021 - Micropile Design Spreadsheet - I came across a spreadsheet for the design of micropiles based on standard penetrometer values. storage pile information 2. View WINKLER-SPRING_BP-1. 4(541 kip) = 757 kip 2 q = 5. In case the analysis failed to converge, please try either of the followings: increase the allowable load difference in cell “D41” in Drilled shaft spreadsheet and “D46” in driven pile spreadsheet. Scribd is the world's largest social reading and publishing site. 18 >2 => OK. It enables users to design abutments, multi-column piers, and ham-. 99$) pile cap with 04 piles design with strut-and-tie model (1. 3) Top of piers embedded min. 15-11-16_Settlement Calculations for Spread Footings and Pile Downdrag (Schmertmann Method) Spreadsheet 15-10-02_Estimated Driven Pile Axial Resistance Table 14-05-05_LRFD Driven Pile Foundation Design Policy (6th Update). Design Load ( Horizontal) Qg = 3. DWG to XLS will solve this problem. 126 × 150 / 251 × 300 / 768 × 916 / 858 × 1024 / 220 × 162 / 220 × 162 / 620 × 315 / 140 × 100 / 60 × 57 / 900 × 1074. If used for the design of a nongravity cantilever wall, the geometry of the slope stability model extends from the ground surface to the bottom or toe of the sheet pile or secant pile wall. These values are not applicable for soils subject to liquefaction or scour where unbraced lengths may alter. Calculate pile length for loads Determine number of piles Determine most cost-effective pile type ( $ / ton) Calculate foundation settlement Calculate performance under uplift & lateral loads Static analysis methods and computer solutions are used to:. There are different methods available for designing piles. resistance of sheet piling and piles. The yellow color cell are input pile data in the excel sheet. We would like to show you a description here but the site won’t allow us. Design of H-Piles at the Abutments • A primary component of integral bridge design is the design of the H-piles supporting the abutment • For longer bridges, the abutments can be subjected to relatively large thermal displacements, which in turn induces large stresses in the H-piles • The PennDOT design procedure employs two primary. PILE CAPACITY CALCULATION EXCEL-https:. Generally, vertical loads applied on piles are carried by the end-bearing of the pile, and the skin-frictional resistance developed along its length. txt) or read online for free. Alternatively the Soldier Pile Wall Design Spreadsheet is can be purchased along with all our other retaining wall design spreadsheets with the full CivilWeb Retaining Wall Design Calculations Excel Suite. Example for 30 inch pipe piles with a 1/2 wall thickness: 30 -. 4D 757 kip Load Case II: U = 1. 8, respectively. Estimate or determine the design value of friction angle, φ’, from appropriate lab or field tests; 2. PILE CAPACITY CALCULATION EXCEL-https:. Calculation of negative skin friction and normal skin friction of soil is not considered in this post. 2 – Geotechnical Pile Design. Excel, for example, is a powerful spreadsheet with VBA robust programming capabilities that can be a powerful tool for teaching civil engineering concepts. Spreadsheet to calculate pile bearing capacity of drilled shaft foundation - bore pile according to BS 8004. 4 Design and construction considerations (6) §6. , square in plan) with two rows of piles on all 4 sides of the column. sipilpedia - Maret. 8, respectively. A MoreVision Venture. Since the pile cap is like a slab (but on the ground) we can use the SAFE program by CSI to design a pile cap. 1 - Pile Design Spreadsheet Ledge Design of Beam to take TT Slab Lintel Design Load Analysis of Building LRFD Composite Beam Design. Spreadsheets and structural engineering calculators including structural engineering calculation for reinforced concrete, steel, stability, loads, retaining walls. SECURITY CLASSIF. Please use the template design attached and add the headshot and information below: Mailyn Mesa Real Estate Associate 786-704-7247 [email protected] [login to view URL] instagram logo @mailyn_mesal 6343 SW 40th Street Miami , FL 33155 Please submit high resolution files Editable AI, PDF, and JPG 3. Need For: E-tabs Software, SAP2000, Softweres, Stadd PRO. Report EUR 26227 EN, 2013 Authors: Andrew J. 612 C#EC$ED 17-06-2007 S#EET DC >. Orr Editors: Silvia Dimova, Borislava Nikolova, Artur V. Pile capacity analysis tool for both driven piles and bored piles based on LCPC method as proposed by Bustamante and Gianeselli (1982). Sandy Gravel, the equations below are used for the range of N values indicated: q. 15-11-16_Settlement Calculations for Spread Footings and Pile Downdrag (Schmertmann Method) Spreadsheet 15-10-02_Estimated Driven Pile Axial Resistance Table 14-05-05_LRFD Driven Pile Foundation Design Policy (6th Update). 07) (1) (0)=10. 785 m2 Factor of Safety (FoS) = 2. pile cap with 02 piles design with strut-and-tie model (1. 3 Actions and design situations (3) §6. This Spread sheet makes you calculate easily Cantilevered Pipe Connection Click here to Download More. Pile Foundations: Design and Construction of Driven Pile Foundations Soil Nailing Field Inspectors Manual-Soil Nail Walls 1993 : FHWA-SA-93-068 : PB94 CBP and Secant Pile Wall Design : Soil Cover Stability : Spreadsheet to check and verify RC wall manual calculations based on the confirmed design approaches : For a secant pile wall: 1. 2 Pile Design. Skills: Photoshop, Excel, Data Entry, Graphic Design, Logo Design. Design-of-Pile-Foundation. The green hornet 1975 trailer. txt) or read online for free. It enables users to design abutments, multi-column piers, and ham-. Sandy Gravel, the equations below are used for the range of N values indicated: q. PILE CAPACITY CALCULATION EXCEL-https:. Silage Pile Sizing Calculator w/ English, English-metric, Spanish, French and Portuguese (10-15-19) Documentation This spreadsheet, originally developed by Ken Barnett, UW Extension Farm Management Specialist, and updated by Brian J. For the purpose of design, the curve bO'c is replaced by a straight line dc. 1 General (2 paragraphs) §6. 142 Base Area, Ab = 0. P6 = P/n+ (Mx*dy6/Ix)+ (My*dx6/Iy) = 123. The structural load is applied to the pile cap that distributes the load to individual piles. 25" inches of bleed for printing Thank you and good luck to all!. We would like to show you a description here but the site won’t allow us. Sheet Pile Design Spreadsheet This spreadsheet calculates the capacity of a cantilever sheet pile in English units and using common US sheeting sections. continuous emission monitoring information 4. Designs can be reviewed in the ‘on-screen’ viewer before printing onto the user’s chosen calculation-sheet. An EXCEL spreadsheet calculator for the depth of embedment of cantilevered sheet pile walls in sand excel spreadsheet, xls, xlsx, cantilever sheet pile wall, cantilevered, sand, calculator, download civil engineering sheetsfree, free download, 2017,civil engineering, courses, articles. xls: Pile capacity for cohesionless soil using SPT N value: 31 kb: Spt_phi. xls from CVE 101 at Mindanao State University - General Santos. 5 Ultimate limit state design (32) §6. The pile cap has normal-weight concrete with a compressive strength of 4000 psi and Grade 60 reinforcement. 1 Simplified method of predicting the bearing capacity of timber piles Chapter 6 Design of Pile Group 6. 2021 Grand Design Imagine XLS 21BHE. Concrete photos, articles, info, design ideas, plus local concrete contractors for colored, stamped and textured concrete patios, driveways, pool decks, interior stained floors, concrete countertops and many more decorative concrete applications. The pile cap has normal-weight concrete with a compressive strength of 4000 psi and Grade 60 reinforcement. Settle number of pile Placement of pile cap and plane dimension Pile cap elementary depth Verify forces. The free-standing height of soil is d = 2C/ The lateral earth pressure at bottom of excavation, pa = h – 2C, where is unit weight of soil. Fountain Valley, CA, USA. Pile Foundations: Design and Construction of Driven Pile Foundations Soil Nailing Field Inspectors Manual-Soil Nail Walls 1993 : FHWA-SA-93-068 : PB94 CBP and Secant Pile Wall Design : Soil Cover Stability : Spreadsheet to check and verify RC wall manual calculations based on the confirmed design approaches : For a secant pile wall: 1. (Design) = 1. The load-settlement curve is also estimated based on Fleming's approach (1992) for axially loaded single piles. This design example presents the procedures to calculate pile. A Bored Pile stands for a nondisplacement form of foundation and bored piling is a system that is applied for boring a spherical hole into the ground as well as setting up steel reinforcement and filling the bore hole by concrete to develop a pile. DESIGN OF PILE CAP As per IS 2911 (Part I/ Sec 3) -2010 the pile cap may be designed by assuming that the load from column is dispersed at 45 from the top of the cap up to the mid depth of the pile cap from the base of the column or pedestal. appendix a spreadsheet for calculation of design loads 110 appendix b spreadsheet for design of pile group 117 appendix c spreadsheet for design of piled-raft 127 appendix d previous work-i (design and analysis of retaining walls backfilled with shredded tire subjected. 00 mbarg: Lower Pl: Lower , Pl = 0000. The cast concrete pile cap distributes the load of the building into the piles. 19 785500 Ultimate Axial Load, 17933637 N 17933. Seamless pipe can withstand greater pressures and is commonly used where a perfectly smooth surface is required on the inside of the pipe for transporting of fluids and materials. Pile Design. Pile capacity analysis tool for both driven piles and bored piles based on LCPC method as proposed by Bustamante and Gianeselli (1982). Helicap™ Engineering Software is a user-friendly design program that enables engineers to calculate theoretical tension and/or compression capacities for CHANCE® Helical products. To calculate the quantity of steel spirals ( or spiral ties) in steel cage (or sometimes rebar cage) for piles ( reinforced concrete or bored pile), you have to have the following informations ( check the details in the drawings) : a) diameter of. xls), PDF File (. Arshad, in Offshore Wind Farms, 2016 20. • MDOT Bridge Design Manual also list allowable bond stresses. The green hornet 1975 trailer. In most cases, the result is image only (vector or bitmap). The design is given in a systematic manner so that it is useful for one and all. We have two main Pile Types (Classification of Piles): 1. , square in plan) with two rows of piles on all 4 sides of the column. Us a depth, design report calculation spreadsheet calculates the materials of circular culverts based recruitment news site that the monitoring. An EXCEL spreadsheet calculator for the depth of embedment of cantilevered sheet pile walls in sand. 25" inches of bleed for printing Thank you and good luck to all!. 540 OD, (1/4 NPS) Schedule 40, 304/304L Stainless Steel Pipe, Welded Formulas for Calculating Conduit & Pipe Bends. The regular features of the spreadsheet are clearly discussed here which is effective used for making the design (according to BS 8110-1:1997) of rectangular pile caps with 4 or more piles. 12) “Fixity” • Pile Fixity • Point of Fixity • “Geotechnical Fixity” • Determining the Minimum Pile Penetration by reaching the “Pile Fixity” should be based upon result of soil-structure interaction. In all the methods, skin friction and end bearing calculations are done in the design of piles. Avoid using 16” CIP and HP 14 piles or larger because of limited flexibility. Its value ranges commonly from 0. Boring is executed to the design depth with the use of a crane mounted or a track mounted. The class will receive handouts detailing the examples and spreadsheet entry along with hand calculations. Laterally Loaded Pile Design. 75 m Design Water Table Depth: Factor of Safety : as per IS 1904-1986 3. com, scribd. Example for 30 inch pipe piles with a 1/2 wall thickness: 30 -. DeepEX is the premier software program for sheet pile walls design. Project Management Templates. 21 kip/ft 2. This capacity is also called as bearing capacity of piles. Download CAD block in XLS. Where, Q u = Ultimate load capacity of pile, in kN. Create a Named Range in the Excel sheet that contains the data you want to Join. Axial and Lateral Load Piles (FEM) Product Size: 255 KB. We hope you can find what you need here. Calculation of negative skin friction and normal skin friction of soil is not considered in this post. (It assumes each Processing recipe will yield an average of 2. 9D + E The load combinations includes the seismic uplift force. It usually forms part of the foundation of a building, typically a multi-story building, structure or support base for heavy equipment. pile displacements; the other shows resulting earth pressures; the third diagram shows bending moment in pile. Furtherexam-ples canbefound in [64]. For example, tensile cracking of pre stressed concrete piles, and the buckling of pipe piles are but two examples of driving failures which have been corrected by use of the wave equation. EXCEL spreadsheet calculator of cantilevered sheet-pile wall penetrating sandy soils excel spreadsheet, xls, xlsx, cantilever sheet pile wall, cantilevered, sand, calculator, download civil engineering sheets. The geotechnical worksheet computes earth pressures and embedment. Dutch installation specialist GBM Works is developing a new method to reduce the noise pollution caused by driving foundation piles for wind turbines into the seabed, it has been revealed. • Required Strength Before Dewatering(706. Jan 12, 2021 - Modulus of Sub Grade Reaction for Piles Spreadsheet Download Link. Specifically, the properties of the pile group are calculated, and then based upon the applied vertical and horizontal loadings, the vertical and horizontal pile reactions are calculated. "PILEGRP" is a spreadsheet program written in MS-Excel for the purpose of analysis of pile groups with rigid caps using the "elastic method". The structural load is applied to the pile cap that distributes the load to individual piles. Pile cap design calculation xls. This is part-13 of Course for 10 Storied Building Design. xls: Correlation worksheet for SPT N value and friction angle: not ready: H-piles. If piles […]. Sheet Pile Design Spreadsheet Shareware Junction. Calculation of lateral earth pressure by calculating relevant parameters and the evaluation of the length of the sheet pile is done in this Section. 5" wide x 2" high with. Generally, the diameter of the under reamed pile is standardized to 20cm-50cm, and length to 3-8m along with the spacing of each piles 2-4m. Pile Capacity Considering Slenderness Effects In many cases, prestressed concrete piles are fairly slender. 5 Be aware that this file only works in Excel 2010 due to limitations of matrix. Internal load due to formation pressure (Pf for the next hole section) 3. Seismic Design of Pile Foundations: Structural and Geotechnical Issues. If you have a LINE in DWG, you will have one Line (SHAPE. design of footing under bi-axial loads as per is: 456 - 2000: 91: bar bending schedule as per british code: 92: make your own bar shape: 93: design of pile caps as per british code: 94: make simple plan sketch in excel: 95: calculation of wind loads as per british standard: 96: sphygmic software spread sheet excel-compatible spreadsheet program. 5 + L s = 21 m Design Approach 3 As the R3 recommended partial resistance factors used in DA3 are equal to 1. PILE HEAD/PILE TOP: The upper small length of a pile. If you subtract that from the total length and add both ends, you end up with a cone that has a diameter that is equal to length B. Design-of-Pile-Foundation. The Structural worksheet uses BEAMANAL spreadsheet by Alex Tomanovich, P. Design Concept. In-situ pile retaining walls also called column piles are rows of concrete piles either cast-in situ pile method or precast pile method. You can Download free sheet pile design calculation 900x1074 px or full size click the link download below. 1 Pre-cast concrete piles 5. Design of structures. diameter piles and a service load capacity of 50 tons each. Working drawings shall. eurocode pile cap design spreadsheet 3 group pile cap design structural engineering other. com] - Free download as Excel Spreadsheet (. 712 m /m length 1. Here, Pile Cap of Two Piles and Pile Cap of Three Piles: Pile value of 18 in diameter, 55 ft long, pile load is 80 kips, and 105 kips on column. 25" inches of bleed for printing Thank you and good luck to all!. Demo provided below regarding creating of design for rectangular pile cap with the help of spreadsheet given below. pile spring values spreadsheet Offline Kartik Malik Tue, May 3 2016 8:43 AM if anyone has the excel spreadsheet for calculating spring values of pile to be input in staad in fixed butt support option, please send it across. Posted in Uncategorized | Tagged retaining wall design calculation example | Leave a comment. A MoreVision Venture. 6 Timber piles (wood piles) 5. The load-transfermethod,firstproposedbyCoyleandReese(1966),isbased on the simple idea that the load-settlement response recorded at the pile head is a direct result of how the reaction forces along. Tumay and Fakhroo (1982) method was foundto be the best performerfor H-piles, and the modified De Ruiter and Beringen (1979) method was foundto be the best performerfor pipe and precast prestressed concrete piles. The design steps are: 1. Open navigation menu. Based on this information the design is started for main reinforcement at top and bottom of the pile cap. Related Topics: How junction of raft and lift reinforcement made Building Bye Law for Civil Engineers Calculation of Cost of Construction per Square. 5 Concrete piles 5. The App will convert AutoCAD object(s) to Excel object(s), one by one. Merits of column piles are less noise or vibration than produced by the installation of solider piles or sheet piles. 2 Limit states (1) §6. B = Diameter or width of pile, in m. where N r = average SPT (N 60) value within depth of one-half of the raft width, N s = SPT value along pile shaft, N b = average SPT value close to pile tip, K 1, K 2 = factors shown in Table 4, a = 1 for displacement piles in all soils and non-displacement piles in clays, a = 0. com website. This is a procedure to design a sheet pile cantilever in sand and covers all the details you need to design them. Search for jobs related to Excel spreadsheet pile cap design bs8110 example or hire on the world's largest freelancing marketplace with 18m+ jobs. Assume a pile cap of 3'6" depth, the top of pile is at 6" above bottom of pile cap and the reinforcement is at 2" above top of pile, the effective depth is d = 34 in. 00 Nominal capacity VNominal capacity , V = 24736 m³ M i d i li id l l HLMaximum design liquid level, HLgq , = 20 70020,700, mm 1. Foundation design has been expanded in Tekla Structural Designer 2016i release last month. Pile Analysis and Design based on Soil Data from Borehole Log. This is part-13 of Course for 10 Storied Building Design. Further reading shall be done before carrying out design. In most cases, the result is image only (vector or bitmap). The difference of these two are regarded as the differential settlement. You can also read Design of Pile Cap According to Eurocode 2. Design of Pile Cap Excel Sheet. Current pile design methodology based on p–y curves, as described in API (2010) and DNV (2011) recommended practice, has gained broad recognition on account of the low failure rate for piles in service over many decades. The performance requirements of the 10T Flake Pile Roller Stand were initially determined through Excel spreadsheet calculations. Download CAD block in XLS. This factor reduces the passive pressure resistance. AMRetain™ is a design software developed solely for the design of steel sheet piling structures using ArcelorMittal's range. 5 ft , eqn = 4Angle of internal friction (above dredge line) = 33 degAngle of internal friction (below dredge line) = 36 degDia of pile = 20 inchSpacing of pile = 2. Sheet Pile Design Spreadsheet This spreadsheet calculates the capacity of a cantilever sheet pile in English units and using common US sheeting sections. "PILEGRP" is a spreadsheet program written in MS-Excel for the purpose of analysis of pile groups with rigid caps using the "elastic method". The green hornet 1975 trailer. Project: Reinforced Pile Cap Design, in accordance with (BS8110:Part1:1997) Job Ref. Pile capacity analysis tool for both driven piles and bored piles based on LCPC method as proposed by Bustamante and Gianeselli (1982). In the formula given below the 1 st term gives the end bearing resistance of pile and the 2 nd term gives the skin friction resistance of pile. COMSOL is the developer of COMSOL Multiphysics® software, an interactive environment for modeling and simulating scientific and engineering problems. Other jobs related to soldier pile wall design calculations anchor bolt design calculations , kitchen wall design vector graphics , deaeration tower design calculations , design calculations power factor capacitor bank , graphics wall design india , hvmv substation design calculations , wall design vector , trailer chasis design calculations. The geotechnical worksheet computes earth pressures and embedment. ) so that Mathcad treated him as their own expression. The auger is then screwed back down to the original pile tip elevation. If you have a LINE in DWG, you will have one Line (SHAPE. For an Anchored wall see Anchored Soldier Pile Design. Pile in To start the solution of the problem, ‘‘pile design sand has four subsections namely, geotechnical and in clay’’ section is called from the main page (Fig. 2 Limit states (1) §6. Shoring Design Spreadsheet. DESIGN PARAMETERS (i) Shape of pile cap. The yellow color cell are input pile data in the excel sheet. We would like to show you a description here but the site won’t allow us. Most if not all spreadsheets contain macros. STRUCTURAL DESIGN OF WORKING PILE (FIXED HEAD) 1. 8 Consider overburden pressure to i. New Reporter, ACI 318-14 & CSA A23. Metric: OD(Outside diameter) in m x 3. design for lightly loaded structures, and Chapter 18 covers foundation design for marine structures. 18 >2 => OK. FEM Pile Calculation in Excel YouTube. The design of the footing in-cludes calculation of pile forces and soil pressures, flexure design, checks for one-way/two-way shear and cracking. pdf), Text File (. DESIGN METHOD. Pile Capacity Considering Slenderness Effects In many cases, prestressed concrete piles are fairly slender. 142 Base Area, Ab = 0. STRUCTURAL DESIGN OF WORKING PILE (FIXED HEAD) 1. The choice of pile. design of footing under bi-axial loads as per is: 456 - 2000: 91: bar bending schedule as per british code: 92: make your own bar shape: 93: design of pile caps as per british code: 94: make simple plan sketch in excel: 95: calculation of wind loads as per british standard: 96: sphygmic software spread sheet excel-compatible spreadsheet program. 540 OD, (1/4 NPS) Schedule 40, 304/304L Stainless Steel Pipe, Welded Formulas for Calculating Conduit & Pipe Bends. Minimum pile penetration into abutment stem is 2’-6”. 4 Steel piles 5. The piles installed can be a single pile or group piles. We hope you can find what you need here. xls - Free download as Excel Spreadsheet (. The calculation can be downloaded from. Considering the condition of the layer of the soil, the average friction angle is assumed in this calculation. and the geotechnical analsyis worksheet to compute stresses and deflections. P6 = P/n+ (Mx*dy6/Ix)+ (My*dx6/Iy) = 123. This Spread sheet makes you calculate easily Cantilevered Pipe Connection Click here to Download More. Design of Micropile GEOPROFOUND ENGINEERING SDN BHD (707134-T) 04/27/2019 Micropile Structural Capacity Calculation 1000 mm 35 cement grout (w/c ratio = 0. The yellow color cell are input pile data in the excel sheet. This suite includes all 8 of our retaining wall design spreadsheets and can be purchased at the bottom of this page for a discounted price of £50, a saving of over 65%. The ultimate load carrying capacity (QU) shall be represented by equation (1). Report EUR 26227 EN, 2013 Authors: Andrew J. com and etc. 00 Nominal capacity VNominal capacity , V = 24736 m³ M i d i li id l l HLMaximum design liquid level, HLgq , = 20 70020,700, mm 1. pdf), Text File (. 4(541 kip) = 757 kip 2 q = 5. Pile Analysis and Design based on Soil Data from Borehole Log. Load Case I: U = 1. (of this report) 20. The geotechnical reduction factor is a risk-based calculation for the ultimate design which takes into account different factors, such as site conditions, pile design, and installation factors. At Structville Integrated Services Limited, we have developed an EXCEL SPREADSHEET that can take care of the following calculations; (1) Design of floor slabs (2) Calculation of neutral axis (both for singly and doubly reinforced sections) (3) Calculation of minimum area of reinforcement (4) Calculation of early and long term thermal cracking. Turan Babacan presents great solution for pile design using finite element techniques encoded in an Excel document. 5 Ultimate limit state design (32) §6. This is why we allow the books compilations in this website. Design Load ( Horizontal) Qg = 3. For the purpose of design, the curve bO'c is replaced by a straight line dc. For example, tensile cracking of pre stressed concrete piles, and the buckling of pipe piles are but two examples of driving failures which have been corrected by use of the wave equation. SoilStructure DRIVEN PILE PROFESSIONAL is a comprehensive pile design software. com] - Free download as Excel Spreadsheet (. Equation development, spreadsheet, and. Specific gravity of operating liquid , S. Sheet Pile Design Spreadsheet shareware, freeware, demos: ANKHOR FlowSheet by ankhorcom, MonoReport FREE Edition by FogSoft LLC, Gridraw for Class diagram by Gridraw Inc etc. xls - Free download as Excel Spreadsheet (. Design limits prevent it to deliver as much energy as single acting, but greater speed, used mostly for sheet piles. 70 was used for end bearing in rock based on successful past practice with WEAP analysis and the general direction of Iowa LRFD pile testing and research. The Structural worksheet uses BEAMANAL spreadsheet by Alex Tomanovich, P. รายละเอียดของโปรแกรม. Boring is executed to the design depth with the use of a crane mounted or a track mounted. 2) Then start up Excel and go to File->Open. Foundation design has been expanded in Tekla Structural Designer 2016i release last month. DESIGN PARAMETERS (i) Shape of pile cap. Pile Caps and Matt foundation Design in Tekla Structural Designer. Example for 30 inch pipe piles with a 1/2 wall thickness: 30 -. 1 Pre-cast concrete piles 5. 00 Nominal capacity VNominal capacity , V = 24736 m³ M i d i li id l l HLMaximum design liquid level, HLgq , = 20 70020,700, mm 1. Example: Pile cap design. [ Download Original Resolution ] Just click download link in many Resolutions at the end of this sentence and you will be redirected on direct image file, and then you must right click on image and select "Save image as". Ignatius Po Lam. The CivilWeb Soldier Pile Wall Design Spreadsheet can be purchased below for just £20. Sheet Pile Wall Design Spreadsheet software free downloads. foundation design and construction. stack test information 3. Generally, vertical loads applied on piles are carried by the end-bearing of the pile, and the skin-frictional resistance developed along its length. Finite element analysis was used to determine the structural stresses induced by the belt tension during operation within the pulley shell, the pulley shaft and the stand. The software can be used for the design of any sheet pile wall system (anchored sheet pile walls, deadman sheet pile walls, cofferdams and more. The free-standing height of soil is d = 2C/ The lateral earth pressure at bottom of excavation, pa = h – 2C, where is unit weight of soil. Spreadsheet calculations using Florida Department of Transportation (FDOT) FB-Deep and FB-MultiPier computations for skin friction, end bearing and pile tip movement are presented to illustrate the effect of soil settlement on pile settlement, structural integrity and bearing capacity in numerical and graphical formats. Helicap™ Engineering Software is a user-friendly design program that enables engineers to calculate theoretical tension and/or compression capacities for CHANCE® Helical products. It is commonly assumed that the soil immediately below the pile caps provides no direct support to the pile cap. The piles are inserted in alternative order of spacing 10-20m so that during the pile insertion process, the other installed pile might not get affected due to instability of soil. 540 OD, (1/4 NPS) Schedule 40, 304/304L Stainless Steel Pipe, Welded Formulas for Calculating Conduit & Pipe Bends. Spreadsheet to calculate pile bearing capacity of drilled shaft foundation - bore pile according to BS 8004. FS (bearing capacity)=q u /q toe =10. Download excel sheet for designing a pile cap On October 26, 2016 October 26, 2016 By arka48 In Uncategorized A pile cap stands for a compact concrete material that is supported with concrete or timber piles driven into soft or unsettled ground to build up a perfect durable foundation. Summary of Bill of Quantities (Civil Works) Bar Bending Schedule. Concrete Design-24 Spread sheets 7. In general it is designed like a footing on soil but with the difference that instead of uniform reaction from the soil, the reactions in this case are concentrated either point loads or distributed. pdf), Text File (. Introduction The hull of a ship is a complex 3D geometry, and finding out its simple properties like volume, centroid, etc. Each spreadsheet contains formulas, reference code sections, and graphic drawings. List of recommended structural excel engineering design spreadsheets. An EXCEL spreadsheet calculator for the depth of embedment of cantilevered sheet pile walls in sand excel spreadsheet, xls, xlsx, cantilever sheet pile wall, cantilevered, sand, calculator, download civil engineering sheetsfree, free download, 2017,civil engineering, courses, articles. I incorporated these procedures into Excel VBA macro to facilitate the implementation of the required procedures. The shed solid pile cap disperses the burden of the structure into the pyramids. The story is closely linked with Tryggve Larssen, government building surveyor in Bremen, who invented the sheet pile wall. Materials & Design for Epheria Sailboat: NOTE: The base amounts listed in the recipe below, is only if you have Processing of Artisan 2 or more. Chapter 5 Single Pile Design 5. observations of deformation and settlement, the main use of these is to calculate the loads in the pile. The geotechnical worksheet computes earth pressures and embedment. A Bored Pile stands for a nondisplacement form of foundation and bored piling is a system that is applied for boring a spherical hole into the ground as well as setting up steel reinforcement and filling the bore hole by concrete to develop a pile. XLS welcomes even more of today's medium-duty trucks and SUVs, without the compromise that other manufacturers feel forced to in pursuit of lighter weight. TO EN-1997 EN 1997-1 §7. Thank you for visiting Pile Design Excel Spreadsheet And Single Pile Cap Design Spreadsheet. Concrete Box Culvert analysis and Design Spreadsheet (53,121) Box Culvert Design Spreadsheet (40,496) Russia-Japan railway bridge would let you travel from London to Tokyo (36,750) Top 10 Civil Engineering Blogs (22,644). Pile Foundations: Design and Construction of Driven Pile Foundations Soil Nailing Field Inspectors Manual-Soil Nail Walls 1993 : FHWA-SA-93-068 : PB94 CBP and Secant Pile Wall Design : Soil Cover Stability : Spreadsheet to check and verify RC wall manual calculations based on the confirmed design approaches : For a secant pile wall: 1. 126 × 150 / 251 × 300 / 768 × 916 / 858 × 1024 / 220 × 162 / 220 × 162 / 620 × 315 / 140 × 100 / 60 × 57 / 900 × 1074. This capacity is also called as bearing capacity of piles. caisson design spreadsheet, active) is represented by abO'c in Fig. When the consequence of the negative skin friction for design are included, these are discussed in terms of reduction of pile bearing capacity of allowable load. Keywords for design of bridges excel sheets RELATED ARTICLES To provide a passage over an obstacle like a water body, a valley, canal or a road structure is built across that obstacle to span a space and allow the easy movement of the concerned bodies over those obstacles, such a structure is named as bridge. Sheet Pile Design Spreadsheet shareware, freeware, demos: ANKHOR FlowSheet by ankhorcom, MonoReport FREE Edition by FogSoft LLC, Gridraw for Class diagram by Gridraw Inc etc. The working drawings shall include all information required for the construction and quality control of the piling. 6 Serviceability limit state design. 2) Then start up Excel and go to File->Open. Civil Engineering. Ap = = Pile end bearing area n Pile Cross section : Circle Pile cut-off Level (COL) : 2. diameter piles and a service load capacity of 50 tons each. Il paraît toutes les six à huit semaines et est distribué dans les écoles aux 217 000 élèves du CP au CM2 de l'académie de Grenoble (Isère, Savoie, Haute-Savoie, Drôme et Ardèche) et à leurs professeurs. Tumay and Fakhroo (1982) method was foundto be the best performerfor H-piles, and the modified De Ruiter and Beringen (1979) method was foundto be the best performerfor pipe and precast prestressed concrete piles. Sheet Pile Wall Design Spreadsheet shareware, freeware, demos: QuickRWall by IES, Sheet Lightning Demo by REVCAD LTD, Recover Excel Sheet Protection Password by Recover Excel Sheet protection password etc. com, excelcalcs. Considering the condition of the layer of the soil, the average friction angle is assumed in this calculation. Finite element analysis was used to determine the structural stresses induced by the belt tension during operation within the pulley shell, the pulley shaft and the stand. Design pile length Hence the DA2 design pile length L = 16. 00 Nominal capacity VNominal capacity , V = 24736 m³ M i d i li id l l HLMaximum design liquid level, HLgq , = 20 70020,700, mm 1. pdf), Text File (. Seamless pipe can withstand greater pressures and is commonly used where a perfectly smooth surface is required on the inside of the pipe for transporting of fluids and materials. Related Topics: How junction of raft and lift reinforcement made Building Bye Law for Civil Engineers Calculation of Cost of Construction per Square. Pile Settlement Analysis. 00 Nominal capacity VNominal capacity , V = 24736 m³ M i d i li id l l HLMaximum design liquid level, HLgq , = 20 70020,700, mm 1. Design limits prevent it to deliver as much energy as single acting, but greater speed, used mostly for sheet piles. This spreadsheet was designed to produce flexible pavement design thickness' in accordance with FAA Advisory Circular AC 150/5320-6D, Airport Pavement Design and Evaluation. 1 Simplified method of predicting the bearing capacity of timber piles Chapter 6 Design of Pile Group 6. In this video lecture, I covered all the important things which you must know in the drawing reading. The class will receive handouts detailing the examples and spreadsheet entry along with hand calculations. In order to facilitate the implementation process, a computer program, Louisiana Pile Design by Cone Penetration Test (LPD-CPT), was developed for the design/analysis of square PPC driven piles from CPT. • MDOT Bridge Design Manual also list allowable bond stresses. Pile capacity analysis tool for both driven piles and bored piles based on LCPC method as proposed by Bustamante and Gianeselli (1982). 07) (1) (0)=10. If used for the design of a nongravity cantilever wall, the geometry of the slope stability model extends from the ground surface to the bottom or toe of the sheet pile or secant pile wall. This design example presents the procedures to calculate pile. 2 Pile Design. Axial and Lateral Load Piles (FEM) Product Size: 255 KB. The software can be used for the design of any sheet pile wall system (anchored sheet pile walls, deadman sheet pile walls, cofferdams and more. xls: Design of pile cap using truss method. 1 also states how to estimate its value as shown in equation (3). 2 Pile Design. = 4 Area = 0. Open navigation menu. Arshad, in Offshore Wind Farms, 2016 20. Date : Project : Page No. Foundation Design and Analysis: Deep Foundations, Driven Pile Bearing Capacity PILES CARRYING CAPACITY ANALYSIS in Excel ¦ Load Carrying Capacity of Piles for Pile Cap Design How To Calculate Length Of Pile in Clay ¦ Engineering Network Pile Foundation in detail Designing Piles \u0026 Pile Caps in RISAFoundation Design of Pile Foundation. This suite includes all 8 of our retaining wall design spreadsheets and can be purchased at the bottom of this page for a discounted price of £50, a saving of over 65%. Calculate pile length for loads Determine number of piles Determine most cost-effective pile type ( $ / ton) Calculate foundation settlement Calculate performance under uplift & lateral loads Static analysis methods and computer solutions are used to:. 2007: High viscosity flow modeling of impact absorbing crash cushion. The story is closely linked with Tryggve Larssen, government building surveyor in Bremen, who invented the sheet pile wall. This is a procedure to design a sheet pile cantilever in sand and covers all the details you need to design them. Pile Cap of Three Piles: Pile value of 18 in diameter, 55 ft long, pile load is 80 kips and 220 kips on column. pdf), Text File (. Jan 12, 2021 - Modulus of Sub Grade Reaction for Piles Spreadsheet Download Link. The settlement is calculated at the centre and the corner of the raft. The piles are inserted in alternative order of spacing 10-20m so that during the pile insertion process, the other installed pile might not get affected due to instability of soil. FREE Software for Engineers Excel Spreadsheets for. DESIGN OF PILE CAP As per IS 2911 (Part I/ Sec 3) -2010 the pile cap may be designed by assuming that the load from column is dispersed at 45 from the top of the cap up to the mid depth of the pile cap from the base of the column or pedestal. It enables users to design abutments, multi-column piers, and ham-. 5" wide x 2" high with. s2k” file with Notepad copy all contents into Excel Data split data using Text to Columns. : Designed by : Checked by : Description : Drawing No. And the piles are embedded 4 in. 63658 kN Taking Factor of Safety (FoS) = 2 8966. gemseducation. 1 Bearing capacity of pile groups. 5 (1) structural design of pile, negative 51 Lectures. Search for jobs related to Excel spreadsheet pile cap design bs8110 example or hire on the world's largest freelancing marketplace with 18m+ jobs. In fact, implementation of the CPT technology in pile design will reduce the level of uncertainties associated with traditional design methods. Finite element analysis was used to determine the structural stresses induced by the belt tension during operation within the pulley shell, the pulley shaft and the stand. Pile design. 612 Critical Sections for ending / Shear @distances from the C of pile capA a1 (or +endin' a+o)t F a*is =4 //;at the pedestal (a%e1 +1 (or +endin' a+o)t G a*is =4 //;at the pedestal (a%e1. File Category: Design Excel Sheets. ASDIP RETAIN is a retaining wall design software specially utilized by engineers for piled / unpiled cantilever, basement, and counterfort retaining walls. It will entirely ease you to see guide sheet pile design spreadsheet as you such as. Materials & Design for Epheria Sailboat: NOTE: The base amounts listed in the recipe below, is only if you have Processing of Artisan 2 or more. Design pile length Hence the DA2 design pile length L = 16. EXCEL spreadsheet calculator of cantilevered sheet-pile wall penetrating sandy soils Meyerhof bearing capacity calculator. Both shallow (e. an email, Excel spreadsheet, etc. You can plot multiple interaction diagrams with different slenderness on a single chart and you can view how pile capacity changes based on slenderness change. From Table 3. A pile cap is required to transfer the load from a 400 mm × 400 mm column to four 600 mm diameter piles, as shown in Fig. xls: Design of pile cap using truss method. If you subtract that from the total length and add both ends, you end up with a cone that has a diameter that is equal to length B. Current pile design methodology based on p–y curves, as described in API (2010) and DNV (2011) recommended practice, has gained broad recognition on account of the low failure rate for piles in service over many decades. short-term pile load capacity calculations. In case the analysis failed to converge, please try either of the followings: increase the allowable load difference in cell “D41” in Drilled shaft spreadsheet and “D46” in driven pile spreadsheet. 540 OD, (1/4 NPS) Schedule 40, 304/304L Stainless Steel Pipe, Welded Formulas for Calculating Conduit & Pipe Bends. Flexible Pavement Design Calculation Spreadsheet according to AASHTO. txt) or read online for free. Pile Foundations: Design and Construction of Driven Pile Foundations Soil Nailing Field Inspectors Manual-Soil Nail Walls 1993 : FHWA-SA-93-068 : PB94 CBP and Secant Pile Wall Design : Soil Cover Stability : Spreadsheet to check and verify RC wall manual calculations based on the confirmed design approaches : For a secant pile wall: 1. emission source information 2. There is no need to modify the data. and grout is pumped under pressure to expel the plug at the base of the internal pipe and commence the flow. Based on this information the design is started for main reinforcement at top and bottom of the pile cap. Product Format: Compressed Zip File. In professional field proper lighting design is very important because an under lighting arrangement will decrease the efficiency of the task for which the lightings were designed and an over lighting arrangement will result in over expenditure of the company. 142 Base Area, Ab = 0. 42 for N > 50. APPROACHES OF PILE DESIGN ACC. If you have a LINE in DWG, you will have one Line (SHAPE. N = Average ‘N’ value at pile tip. Chapter 15 provides direction for the calculation of demands and includes detailing requirements. DESIGN METHOD. We would like to show you a description here but the site won’t allow us. Design of sheet pile in cohesive soil Calculating active earth pressure Calculation of active earth pressure above excavation is the same as that of cantilever sheet pile in cohesive soil. 5 - Pile head beams accounts and details - report - Some improvements Be aware that this file only works in Excel 2010 due to limitations of matrix functions in Excel 2003. FREE Software for Engineers Excel Spreadsheets for. This design example presents the procedures to calculate pile. Jan 12, 2021 - Modulus of Sub Grade Reaction for Piles Spreadsheet Download Link. Pile Cap of Three Piles: Pile value of 18 in diameter, 55 ft long, pile load is 80 kips and 220 kips on column. Design limits prevent it to deliver as much energy as single acting, but greater speed, used mostly for sheet piles. xls), PDF File (. Download CAD block in XLS. Scribd is the world's largest social reading and publishing site. 6 Serviceability limit state design. We will see how to pile estimating with the spreadsheet. 153 square inches per strand Pull = 75% (initial). Prev Next. Minimum pile penetration into abutment stem is 2’-6”. com] - Free download as Excel Spreadsheet (. other factors affecting emission rates 4. Open navigation menu. If you look at the second image, the footprint, length A is not the overall length. Project: Reinforced Pile Cap Design, in accordance with (BS8110:Part1:1997) Job Ref. 3 Allowable Stress Design and Strength Design Traditionally the geometry of a footing or a pile cap is selected using unfactored loads. xls - Free download as Excel Spreadsheet (. 91 s = N − N + for 20 < N < 40 q. 540 OD, (1/4 NPS) Schedule 40, 304/304L Stainless Steel Pipe, Welded Formulas for Calculating Conduit & Pipe Bends. design of footing under bi-axial loads as per is: 456 - 2000: 91: bar bending schedule as per british code: 92: make your own bar shape: 93: design of pile caps as per british code: 94: make simple plan sketch in excel: 95: calculation of wind loads as per british standard: 96: sphygmic software spread sheet excel-compatible spreadsheet program. LEAP RC-PIER is an integrated application for the analysis and design of reinforced concrete bridge substructures and foundations. For preliminary design purposes,. All-Pile is a Windows-based analysis program that handles virtually all types of piles, including steel pipes, H-piles, pre-cast concrete piles, auger-cast piles, drilled shafts, timber piles, jetted piles, tapered piles, piers with bell, micropile (minipile), and uplift anchors. The design is given in a systematic manner so that it is useful for one and all. For a complete design of pile foundations, the settlement criterion has to be incorporated. xls from CVE 101 at Mindanao State University - General Santos. Where, Q u = Ultimate load capacity of pile, in kN. Seamless pipe can withstand greater pressures and is commonly used where a perfectly smooth surface is required on the inside of the pipe for transporting of fluids and materials. File Format: Document File, Excel File. Design of Pile Cap Excel Sheet. txt) or read online for free. However, it and most other older methods are based upon assumptions of linear behavior in soil. Low pile service loads are used in the example. I incorporated these procedures into Excel VBA macro to facilitate the implementation of the required procedures. xls: Design of pile cap using truss method. - ACPA K-value calculator: For use with BCOA-ME MnPAVE Flexible: flexible (HMA) pavement design MnPAVE Rigid 3. other factors affecting emission rates 4. observations of deformation and settlement, the main use of these is to calculate the loads in the pile. O'Kelly, M. Related Topics: How junction of raft and lift reinforcement made Building Bye Law for Civil Engineers Calculation of Cost of Construction per Square. Generally, vertical loads applied on piles are carried by the end-bearing of the pile, and the skin-frictional resistance developed along its length. Ap = = Pile end bearing area n Pile Cross section : Circle Pile cut-off Level (COL) : 2. In general, the load and resistance factor design approach (LRFD) as prescribed in the AASHTO LRFD Bridge Design. Turan Babacan's amazing general solution for pile design using finite element techniques encoded in an Excel document. 612 Critical Sections for ending / Shear @distances from the C of pile capA a1 (or +endin' a+o)t F a*is =4 //;at the pedestal (a%e1 +1 (or +endin' a+o)t G a*is =4 //;at the pedestal (a%e1. Design limits prevent it to deliver as much energy as single acting, but greater speed, used mostly for sheet piles. The theoretical critical load is obtained directly from the elastic buckling theory. Pile Design from Geotechnical Info. One reference that has long been used for laterally loaded piles is the Navy Design Manual 7. Draw the rest of the fucking owl. We would like to show you a description here but the site won’t allow us. One and Two Way Slab Quantity. 2007: V-notch weir rating table and design. 00 mbarg: Lower Pl: Lower , Pl = 0000. It usually forms part of the foundation of a building, typically a multi-story building, structure or support base for heavy equipment. 3 ksf 144 ft u. You can use the spreadsheet or App to evaluate the effects of different feedstock mixtures on C:N ratio and moisture content of the initial pile. If you subtract that from the total length and add both ends, you end up with a cone that has a diameter that is equal to length B. Flexible Pavement Design Calculation Spreadsheet according to AASHTO. Seamless pipe can withstand greater pressures and is commonly used where a perfectly smooth surface is required on the inside of the pipe for transporting of fluids and materials. List of recommended structural excel engineering design spreadsheets. other factors affecting emission rates 4. DESIGN OF PILE CAP As per IS 2911 (Part I/ Sec 3) -2010 the pile cap may be designed by assuming that the load from column is dispersed at 45 from the top of the cap up to the mid depth of the pile cap from the base of the column or pedestal. short-term pile load capacity calculations. Suited to geotechnical design calculation spreadsheet with design of driving or the area.