00 Soft clay 1. Analysis of Rates of Building Construction in Excel. 4R has a modulus equal to 0. Read more in pile capacity spreadsheet can be subject to be greatly. value of the undrained strength, Su as specified in Table. proportioning of multiple transient loads that may assume point-in-time values when the load of interest attains its extreme design value. To get the acceptable, you may use a factor of safety of 3. 20 m footing embedment depth = 17. The spreadsheet also includes unique analysis tools which. The other two will be placed on medium dense gravel [Dense gravel has a bearing value. Requirement: Estimate allowable soil bearing capacity based on. Assume the slab has a thickness of 125 mm. 5 metres from each side of the pile. 5 hours ago · xls: Design of pile cap using truss method The Recurring Investment Calculator shows you how much money you would accumulate for different annual, monthly or weekly investments given a specified annual rate of return and number of years of investments helical pile installation is a measure of soil shear strength and can be related to the bearing capacity. The soil deformation depends upon factors like water content, bulk density, angle of internal friction, and the manner in which load is applied to the soil. 00 Very soft clay 0. Allowable bearing capacity To calculate the allowable bearing capacity of bored pile, the resistance factors should be taken as tabulated in Table 2: The resistance factors in cohesive and cohesionless soils Resistance factors Soil types. 21 123 666 679. Mail; Call 800-610-3422. SPT is generally performed at every 1 m interval up to 15~20 m and then interval may be increased to 1. We can estimate cohesion . The problem is to determine the allowable bearing capacity of a mat foundation 40ft x 80 ft with soil unit wt 120lb/ft^3 located 8ft below ground surface with SPT of the soil being 18. And, safe bearing capacity of soil = 90/(20 x 2) = 2. tado octopus energy. 0), to obtain the safe bearing capacity. Intracell Buckling Honeycomb Sandwich Panels Excel Calculator Method for compression and shear inter-cell buckling of isotropic facing sheets. Wind Load Calculator Excel Spreadsheet (14,262) Types and Causes of Concrete Deterioration (13,779) Types of Dams, advantages, disadvantages and classification (12,393). Step 1: Compute the end-bearing load capacity (Q p ). Next, consult a span table to cross reference the spacing and span to find the required Fb value for that table's load limits. ) • As a part of test, the representative but disturbed soil sample is procured at the test depth. The structural design is completed by structural engineer of record (SEOR) where he/she utilizes the concept of Beam on Nonlinear Winkler Foundation in order to estimate the pressure of soil as well as shear forces and bending moments induced to the. 00 Very soft clay 0. 5, the net safe bearing capacity (expressed in kN/m2) for local shear failure of the soil is Using Terzaghi's bearing capacity equation and a factor of safety F, = 2. SPT Bearing Capacity – Graph. And, safe bearing capacity of soil = 90/(20 x 2) = 2. There are many methods and theories for calculating the pile capacity, but the basic concept is shown in Figs. Posted on March 10, 2020 March 10,. com Design Capacity Tables for Structural Steel Hollow Sections (iv) Preface The "Design Capacity Tables for Structural Steel" (DCT) suite of publications from the Australian. computed the bearing capacity factor N γ of rough strip foundations using the critical slip field method. Base Bearing Capacity. The bearing stratum is moderately weathered bedrock and the pile top settlement is 49. Depth to base of pile. All abutments and return walls shall be designed for a live load surcharge equivalent to 1. 40 Soft shell / Stiff clay 1. Angle of Internal Friction when Sum of Tangential Component is Given. Specifically, the soil spring constants, both at the surface and at a user input embedment depth, are determined in the analysis. 1 m in diameter with a length of 88. The soil deformation depends upon factors like water content, bulk density, angle of internal friction, and the manner in which load is applied to the soil. unit weight of soil, g = 21 kN/m 3 (132 lbs/ft 3. (An Excel spreadsheet can be compiled to automatically calculate these factors and will be handy for future use). 45 25 = 101 kN Check Service Soil Bearing Capacity = + 𝑨 = +. After determining the ultimate bearing capacity of the soil, from any one of the tests, we work out SBC of the soil using the following relationship: Safe Bearing Capacity (SBC) = Ultimate Bearing Capacity / (Cross-sectional area × Factor of Safety) For soil, the factor of safety is usually considered as 3. Depth to base of pile. random text copy and paste. Determining Bearing Capacity of Soil from N value – Minimum number of Bore Hole This video shows the relation between bearing capacity of soil and standard penetration number that. The other two will be placed on medium dense gravel [Dense gravel has a bearing value. Where, Q u = Ultimate load capacity of pile, in kN. 6 x 120]/0. Step 2: Compute the skin-frictional resistance (Q s ). 2, Zast aent4ma. The main components of the foundation are the pile cap and the piles. Seven Calculation of Safe Bearing Capacity of Rock 66 Eight Analysis of the Sub Surface Investigation 67 - 68. Apparatus to Plate load test. qult= ultimate bearing capacity of the foundation (kN/m2, kPa, or ksf) P = total load at the footing level (structural + re ll soil load) (kN or kips) A = footing area (m2or ft2) F = appropriate safety factor that accounts for the uncertainties involved in the deter -. The soil exploration details will provide the details of the end bearing and the skin friction value. The plate load test is mandatory in case of designing foundation over the sandy and clayey soil. q all,gross = Gross allowable bearing capacity q u,gross = Gross ultimate bearing capacity (Terzaghi equation) FS = Factor of safety for bearing capacity ≥3. Qult = 1/2*gamma*B*Ny + c*Nc + (Pq +gamma*Df)*Nq where Q ult is the ultimate bearing capacity. Sedimentry Rock is 190kpa. 333 for a soil having ϕ = 300 or may take value 0. PAGE 114. Example #1: Determine allowable bearing capacity and width for a shallow strip footing on cohesionless silty sand and gravel soil. The CivilWeb Soil Bearing Capacity Calculation Excel Suite includes the Terzaghi bearing capacity spreadsheet along with 5 other analytical methods and 3 methods based on site investigation information. Solution: Meryerhof's equation. ∴ Safe bearing capacity of soil per unit are = R/A x f. 5 x 0. Bearing Capacity Correlations with SPT-value Teng (1962): 1 2. Published in Soil Bearing Capacity Calculation Excel. , in Marine Structural Design Calculations, 2015 6. 65 and A 1 is the area of the column with confinement: 2 1 1 nc 0. Value varies from 1. 4 Engineering News Record Formula 5. 0 F g = Global Factor of Safety for Total Resistance (Base + Shaft) = 2. 50 NOTES TO REMEMBER. / n= D f / n (3) Where q f = ultimate bearing capacity at failure, = unit weight of soil above the base of the foundation, q a = allowable bearing pressure, and n= factor of safety. structural loads over large areas of near-surface soil to lower the intensity of the applied loads to. Active earth pressure conditions should be assumed. The end bearing capacity of pile, Q p in kN, is: Q p = q p A p where A p = area of pile tip (m2) 2. The N γ values for strip and circular footing were generated using ϕ r and Martin's (Martin 2005) Analysis of Bearing Capacity software. Bearing Capacity of Soil Where, qd = It is Net ultimate bearing capacity of foundation (kgf/cm2) q = Effective surcharge at base level of foundation, in kgf/cm2 (Refer step-3) Nq & Nϒ = Bearing capacity factors (Refer step-4) sq & sϒ = Shape factors (Refer step-5). 1 TypesofSteels Plate thickness ASTM designation Fy(ksi)a Fu(ksi)a (in. 8√fcu= use the vertical load is taken to be the pressure at the columns edges over half the base, because of the moment vertical load = kN ½ area= m². Service load, N = 1000 kN Assumed selfweight 10% of service load , W = 100 kN Area of footing required = + 𝛾 𝑖 =1000+100 150 =7. Terzaghi’s bearing capacity factors 89 3. 1 To calculate the footing base area, divide the service load by the allowable soil pressure. 0 m ⇒ To obtain the average N value to be used in the calculations. Download xls Free - 4. Terzaghi found that bearing capacity factors N c, N q, and N γ are functions of ɸ, the angle of shearing resistance of soil. All abutments and return walls shall be designed for a live load surcharge equivalent to 1. CivilWeb Soil Bearing Calculation from SPT Value XLS Spreadsheet. Calculation Reference. The safe bearing capacity of soils can be determined from either analytical methods or from site investigation data. And, safe bearing capacity of soil = 90/(20 x 2) = 2. Nov 21, 2022,. where q u = ultimate bearing capacity. Factor of Safety when Mobilised Shear resistance of Soil is Given. Search: Pile Calculation Excel. If the gross bearing capacity of a strip footing 1. Ultimate Bearing Capacity [UR] = [0. 5a) qq1)e 262l R v l u Reference 1 (Figure 16. Zollner "Chain drives" DIN-Normen. The k-value can be determined by field tests or by correlation with other tests. In the example, the joists have a spacing of 16 inches and a span of 11 feet, 2 inches. In order to get reliable test result, perform this test on different types of soil and then use your judgment to reach at any conclusion. In the case of unsatisfactory design adjust the spring dimensions [4. Using equations (4) and (6), calculate the skin-frictional per soil layer. Gamma is the overburden pressure. Specifically, the soil spring constants, both at the surface and at a user input embedment depth, are determined in the analysis. All anchor bolt shall have plate wahers a minimum of 2”x2”x3/16” thick. 00 Very soft clay 0. The allowable bearing capacity of socketed piles is given by: q a = q c * N j * N d Where N d = 0. The maximum net soil bearing pressure is also determined. 5mm of deflection is at a lower FoS at low N 30L values and at higher FoS at higher N 30L values. Bearing Capacity from SPT a. Also it is very important to identify . Spreadsheets can do basic calculations such as cost estimates, schedule and cost control, and markup estimation, as well as structural calculations of reactions, stresses, strains, deflections, and slopes. fingertip web series download telegram x philadelphia racing results. Soil Density (heel side) Enter the soil density for all earth (or water if applicable) above the heel of the footing. Step 1: Compute the end-bearing load capacity (Q p ). The bearing capacity of soil is defined as the capacity of the soil to bear the loads. Log In My Account fr. 40 Soft shell / Stiff clay 1. The values of N c, N q and N γ as given by Terzaghi are shown in Table 18. Significance Of Safe Bearing Capacity Of Soil. Safe Bearing Capacity has the following significance regarding the soil, The Soil tends to deform when stressed due to loading. - Fixed a bug in export to Excel ( bearing capacity results). The apparatus used in above mentioned two tests are different, but the principle and calculations involved in finding the safe bearing capacity of the soil are same. i Registration Form Soils and Foundation Handbook 2000 Name: Name of Firm or DOT Unit: Mailing Address: Telephone: Fax: E-mail: Please remove this sheet from your Handbook and complete the requested. 50 NOTES TO REMEMBER. If angle of inclination of resultant load is 'α'to the vertical, then bearing capacity factors (Nγ,N c& N q) need to be multiplied by: 2 2 90 1 1 = = − = − ο α φ α γ iciq i PILE (DEEP) FOUNDATIONS 7 Introduction. 0 Clays, peats, etc. By considering only shear failure, net ultimate bearing capacity is divided by certain factor of safety will give the net safe bearing capacity. 05 inches or less. 4 Perform settlement analysis when possible and adjust the bearing pressure until settlements are within tolerable limits. Bearing Capacity Correlations with SPT-value : Peck, Hansen, and Thornburn (1974) & IS:6403-1981 Recommendation. Sliding Resistance: There must be an adequate factor of safety for sliding between the base of the wall and the underlying soil due to the lateral earth pressure. The analytical method used in Eurocode 7 contributes to a slightly higher value of the bearing capacity (Figure 3 and 4). AASHTO acad ACI airport Autocad Beam bim Box Culvert Bridge bridges CAD cad details Column concrete Culvert drawing dwg Etabs Excel. Combination 3: γ fL,SLS = 1. BearingCapacityofSoil #SPTNValues #BowlesEquationIn this video you will be able to learn about the calculations of the Bearing Capacity of . D = 1. Allow Soil Bearing The maximum allowable soil bearing pressure for static conditions. 50 NOTES TO REMEMBER. Aug 22, 2017 · This method is the field test for the Safe bearing capacity of soil. Each individual footing foundation must be sized so that the maximum soil-bearing pressure does not exceed the allowable soil bearing capacity of the underlying soil mass. Settlements refer to the soil's movement in the vertical direction typically induced by stress changes. central machinery scroll saw replacement parts tim conway jr wife how long does it take to launder money drug dealer simulator write a program to check if a given. (An Excel spreadsheet can be compiled to automatically calculate these factors and will be handy for future use). Sliding Resistance: There must be an adequate factor of safety for sliding between the base of the wall and the underlying soil due to the lateral earth pressure. Seven Calculation of Safe Bearing Capacity of Rock 66 Eight Analysis of the Sub Surface Investigation 67 - 68. •It should not subside, i. Structural mezzanine When implementing an industrial equipment platform (mezzanine) be sure you are not overl. Factors affecting Safe bearing capacity. Soil Bearing Capacity Calculation 84 Description This spreadsheet was based on the Terzaghi, Mayerhoff & Hanzen Equations for determing the soil bearing capacity. 2 days ago · Determination of bearing capacity and settlement is done as follows: 1. The bearing capacity of soil is given by the equation Q_a=\frac {Q_u} {FS} Qa = FSQu in which Qa is the allowable bearing capacity (in kN/m 2 or lb/ft 2 ), Qu is the ultimate bearing capacity (in kN/m 2 or lb/ft 2) and FS is the safety factor. simple sentence meaning in marathi. 5 metres from each side of the pile. Safe Bearing Capacity has the following significance regarding the soil, The Soil tends to deform when stressed due to loading. Enter email. Let us take FOS = 2 for the calculation purpose. 423 N/ Sqmm Nominal Shear stress Vu/bd 0. 40 Soft shell / Stiff clay 1. The main components of the foundation are the pile cap and the piles. The top number, 0. tekken 7 iso download for android. The safe bearing capacity of soils can be determined from either analytical methods or from site investigation data. All Civil Engineering Articles, Free e books, Current Openings, Jobs, Study Materials, Gate Materials, Latest innovations. 1 To calculate the footing base area, divide the service load by the allowable soil pressure. It is therefore recommended that the Meyerhof N 30L values be used in sands and that 2 to 6 times the N 30L be used for clayey materials, depending on the plasticity. 20 supersedes env 1997-2:1999, env 1997-3:1999. 6 x N γ On solving, N γ = 60. 1 Bearing Capacity Calculation from (c’ and ϕ) 16 2. 423 N/ Sqmm Calculated k Value INPUT For 400 mm thick slab, k= Permissible Max Shear Stress 0. Next image. blox fruit logo link. The soil bearing capacity. · The bearing capacity of your soil will help you determine if you need a shallow foundation or deep foundation. Bearing capacity is the ability of soil to safely carry the pressure placed on the soil from any engineered structure without undergoing a shear failure. = 30 o and a safe bearing capacity of 400kN/m 2. The plates that are used for tests in the field are usually made of steel and. Generally these two terms allowable and Safe BC are confused. 2 days ago · Soft rocks have a bearing capacity of 440 kN/m2. Where f – factor of safety. Apr 26, 2021 · Example7: Determine soil bearing capacity by SPT numbers Given. Using ½ of the soil modulus would approximately estimate the soil consolidation settlement to be nearly equal to the initial elastic settlement. 10 then SPT-N value is 19. Abdulmannan Orabi IUST 6. 37 Table 7 Application of load for different types of cement. qns = qnu/ F. · This spreadsheet was based on the Terzaghi, Mayerhoff & Hanzen Equations for determing the soil bearing capacity. Terra Aqua recommends a conservative value of base width = 2/3 wall height. Diameter of pile. the design value of Φ' should be used, incorporating a mobilisation factor M of 1. Cross Section Area (A) = 20cm 2; Factor of Safety=2 Ultimate Bearing Capacity [UR] = [0. When a column is loaded to failure in compression, the ultimate capacity is the sum of concrete and steel components, and it is given by an empirical formula: N = 0. 5° using Terzaghi’s theory. pfizer safety data 75 years. Sand,silt sand, clayey sand is 95kpa. Safe Bearing capacity of soil Coffiecent of friction Concrete Steel M-. Step 1: Compute the end-bearing load capacity (Q p ). 33(0/B) 1. The present value of $120 in three years, if you have alternatives that earn 10%, is actually $90. 40 Medium sand 2. The ultimate bearing capacity Qu is the theoretical limit of the bearing capacity. A factor of safety is applied to give the safe bearing capacity of the soil. To estimate settlement failure, an allowable settlement value is assumed (normally 25 mm or 1 inch). 3 kips/ft 2. free end) at one end of a column generally reduces its load-carrying capacity. 715/1000)*200*139 =19. The following are the step to find the bearing capacity of soil from SPT Values or standard penetration test calculation. 7, SPT Correction factors. The table below indicates the presumptive bearing capacity numbers for different types of soils. depth of penetration into the layer General notes for tip resistance in cohesive soil layers: • Reference for Eq. Excavating tools; Hydraulic jack (ball socket type with 50 T capacity ). sex therapy emily thorne, streaming downloader
Jun 01, 2022 · The formula of safe bearing capacity is the maximum weight that a container can safely carry before it becomes overloaded and fails. . Calculation of safe bearing capacity of soil from n value xls
This means that the cable is accepted because the voltage drop is in limits (5% = 20. These functions are used to calculate corrected blow counts (N-values) for the Standard Penetration Test ( SPT ). The CivilWeb Soil Bearing Capacity Calculation from SPT Value XLS Spreadsheet can be used to convert the SPT n value to the bearing capacity of the soil. Very often, a structure fails by unequal settlement or differential settlement. 5M DEPTH CONSTRUCTION OF BRIDGE OVER INDRABATI AT 18TH KM ON KODINGA CHIRIMA NATIGHAT ROAD Field SPT value = 50 Depth Df = 6. ij; ur. As the footing becomes safe for higher value of SBC then naturally it will be safe for any value lower than that. To calculate area of the footing unfactored load is under consideration. Effective stress at foundation base and bearing capacity of foundation is then calculated as shown below: 5. 17 m. SPT Correlations Software correlate SPT blow counts to 30 soil properties using 300 correlations;. 5 γBNγ + qN q. Allowable bearing capacity is what is used in geotechnical design, and is the ultimate bearing capacity divided by a factor. The Terzaghi bearing capacity method was the first analytical method to be developed and while it has been extended many times, the Terzaghi. FOS 👉 Factor of safety. The approximate ultimate bearing capacity under a long footing at the surface of a soil is given by Prandtl's equation: Where: q u = Ultimate bearing capacity of soil, lb/ft 2 (kg/m 2) c = Soil cohesion, lb/ft 2 (kg/m 2) Φ = Angle of internal friction, degree γ dry = Unit weight of dry soil, lb/ft3 (kg/m3) b = Width of footing, ft (m). 245 x 1000/ (3568×442) = 0. 1 m in diameter with a length of 88. - The load cases H and F are added to all UBC Combination where H and F exist. Soil classification based on friction ratio R f (Sanglerat, 1972) R f % Type of Soils 0 – 0. Safe bearing capacity of soil = Ultimate bearing capacity / Factor of safety The values of factor of safety normally used are 2, 2. Similarly, Paige-Green (2009) suggested that bearing capacity (bearing value) can be estimated from the following equation: Bearing capacity = 3426DN-1. Search: Pile Calculation Excel. Soil bearing capacity calculation from spt value excel. Finally, to determine bearing capacity under strip footing we can use qu = c'Nc + Df Nq + 0. Gamma is the overburden pressure. The total settlement of the ground consists of 3 components: immediate settlement (commonly referred to as elastic settlement, although this is a misnomer), consolidation settlement (or primary settlement) and creep settlement (or secondary. Requirement: Estimate allowable soil bearing capacity based on. The unit weights of concrete and soil are 150 pcf and 120 pcf; close. Assume the slab has a thickness of 125 mm. Here, n=inner bend radius (Ri) divided by pipe outside diameter (D) for wall thinning formulae Ri=Inner bend radius= (Bend Radius*OD)- (OD/2) The value of bend thinning shall be less than 2. The zone of soil affected by the foundation is typically taken as between 0. Log In My Account cv. grand beatbox battle 2022. have occurred where field conditions have indicated that the bearing capacity was reduced during seismic events. Net allowable bearing pressure (qna) This is the pressure we. 00 Very soft clay 0. 810 = 130 ft². Cross Section Area (A) = 20cm 2; Factor of Safety=2 Ultimate Bearing Capacity [UR] = [0. The following are the step to find the bearing capacity of soil from SPT Values or standard penetration test calculation. 20 jui. Check for one-way shear 4. Soil SPT number:10; Footing type: 3 feet wide strip footing, bottom of footing at 2 ft below ground surface. simple sentence meaning in marathi. · Applying a factor of safety of 3. 40 Medium sand 2. 1 m in diameter with a length of 88. The soil deformation depends upon factors like water content, bulk density, angle of internal friction, and the manner in which load is applied to the soil. Bearing Capacity of Soil Where, qd = It is Net ultimate bearing capacity of foundation (kgf/cm2) q = Effective surcharge at base level of foundation, in kgf/cm2 (Refer step-3) Nq & Nϒ = Bearing capacity factors (Refer step-4) sq & sϒ = Shape factors (Refer step-5). Soil bearing capacity is very commonly used in foundation design as a way of simplifying the soils reaction to the foundation. 95 kb. Diameter of pile. VD = 0. af; wq. Soil bearing capacity by SPT numbers The buoyant unit weight must be used if the groundwater table is at or above the base of the footing (that is zw < D), for in this case the whole of the potential slip mechanism below the footing base is under water. if the bearing stress from foundation exceeds the ultimate bearing capacity of the. 0 F g = Global Factor of Safety for Total Resistance (Base + Shaft) = 2. 00 6. xls" (Beam On Elastic Foundation) spreadsheet workbook. Thus, the allowable bearing capacity is the smaller of the following two conditions: q _ j j=smallest of ^ q s FS (to control shear failure Ch. 40 Soft shell / Stiff clay 1. The value of α is close to 1 for soft clays with low undrained strength. european standard norme europeenne europaische norm en 1997-2 march 2007 ics 91. 40 Soft shell / Stiff clay 1. 867c Nc + g . PAGE 114. Research has shown that the most significant factor affecting the measured N values is the amount of energy delivered to the drill rods. Significance Of Safe Bearing Capacity Of Soil. This spreadsheet was based on the Terzaghi, Mayerhoff & Hanzen Equations for determing the soil bearing capacity. Example 1: Determine soil bearing capacity by SPT numbers (English units) Given Soil SPT number: 10 Footing type: 3 feet wide strip footing, bottom of footing at 2 ft below ground surface. Hard rocks – 33. For non-cohesive soils the values should be reduced by 50% if the water table is above or near base of footing. 45 25 = 101 kN Check Service Soil Bearing Capacity = + 𝑨 = +. 423 N/ Sqmm Nominal Shear stress Vu/bd 0. lue more than 50 pereent ot the. This means that the cable is accepted because the voltage drop is in limits (5% = 20. 50 NOTES TO REMEMBER. 50 (As per IS-2131) Cohesion=C = 0. The table given below shows the presumptive bearing capacity values for different types of soils. Overburden stress. q n = q - q o. Calculation Reference Soli Mechanics Geotechnics. ity of loading that the foundation will lafely carry without the rilk of shear failure of soil irrespective of any settlement that may occur. 2 Geophysical method of Soil Investigation 21 2. EFFECTIVE WIDTH Effective width in the run of culvert (length across. The soil deformation depends upon factors like water content, bulk density, angle of internal friction, and the manner in which load is applied to the soil. S) Where, F. 1 day ago · Search: Pile Calculation Excel. Ultimate bearing capacity (qf) is the theoretical maximum pressure which can. +3, When we think about constructing a new house, probably one question will hit our minds that what would be the cost of construction. Soil Bearing Capacity Calculation from SPT Value XLS Spreadsheet is free image that you can download for free in Fee Value. how to unblock blocked sim card. Safe Bearing Capacity calculator uses Safe bearing capacity = Net safe bearing capacity +( Unit Weight of Soil * Depth of footing ) to calculate the Safe bearing capacity, The Safe Bearing. Sliding Resistance: There must be an adequate factor of safety for sliding between the base of the wall and the underlying soil due to the lateral earth pressure. Carrying out the crack control calculation to Clause 5. Spread pick for soil bearing capacity calculation. · Civilax - The Civil Engineering Knowledge Base is the premier resource for practicing civil & structural engineers. Spreadsheets can do basic calculations such as cost estimates, schedule and cost control, and markup estimation, as well as structural calculations of reactions, stresses, strains, deflections, and slopes. Geotechnical engineering Calculators. The bearing capacity of soils for shallow foundations generally follows the acceptable Terzaghi-Meyerhof equation. This table is a guide to a conclusion after doing conducting the test. 16, Qult(ultimate bearing capacity), 51. Calculation of safe bearing capacity of soil from n value xls. S = Factor of safety NOTES TO REMEMBER F. To get the acceptable, you may use a factor of safety of 3. Search: Pile Calculation Excel. Gross safe bearing capacity (qs) When ultimate bearing capacity is divided by factor of safety it will give gross safe bearing capacity. . spank ass porn