STEP 1: Extracted Data

July 10, 2026

STEP 1 Complete: Extracted Data

Data extraction completed on Jan 03, 2026 17:20
AI Model Used: gpt-4o-mini
Project Information
Project Name: Helical Foundation Design – Roundhouse Addition
Boring Number: 1
Location: 1602 South 2nd Avenue, Marshalltown, IA
Groundwater Depth: 10.0 feet
Soil Layers with Calculated Parameters
Layer Depth (ft) Soil Type Description γ (pcf) Nfield σv (psf) σ'v (psf) N60 CN (N1)60 φ' (°) c (psf)
1 0.0-5.0 Lean Clay LEAN CLAY, Trace Sand 120.0 14 720 720 14.0 - 3500
2 5.0-10.0 Silty Sand FINE TO MEDIUM SAND, Trace Clay 110.0 29 550 550 29.0 1.50 43.5 37.5 -
3 10.0-15.0 Lean Clay LEAN CLAY, Trace Sand 120.0 15 720 720 15.0 - 3750
4 15.0-20.0 Sandy Lean Clay SANDY LEAN CLAY, Trace Gravel 120.0 18 720 720 18.0 - 4500
Recommended Design Parameters
Soil Layer Description Parameter Recommended Value Range
Lean Clay (0-5 ft) c (Cohesion) 3500.0 psf 3000-4000 psf
Silty Sand (5-10 ft) φ' (Friction Angle) 37.5 degrees 35-40 degrees
Lean Clay (10-15 ft) c (Cohesion) 3750.0 psf 3500-4000 psf
Sandy Lean Clay (15-20 ft) c (Cohesion) 4500.0 psf 4000-5000 psf
Plot Data Available
Plot data has been extracted with 5 depth points. This data can be used to generate depth vs. geotechnical parameter plots.
Raw Extracted Data (JSON)
{'project_info': {'boring_number': '1', 'location': 'Marshalltown, Iowa', 'date': '9-1-10', 'ground_surface_elevation': 936.5}, 'groundwater_depth': 10.0, 'soil_layers': [{'depth_from': 0.0, 'depth_to': 5.0, 'elevation_from': 936.5, 'elevation_to': 931.5, 'soil_type': 'Lean Clay', 'description': 'LEAN CLAY, Trace Sand', 'unit_weight': 120.0, 'spt_n_field': 14, 'sigma_v': 720.0, 'sigma_v_prime': 720.0, 'n60': 14.0, 'cn': None, 'n1_60': None, 'phi_prime': None, 'cohesion': 3500.0, 'moisture_content': None}, {'depth_from': 5.0, 'depth_to': 10.0, 'elevation_from': 931.5, 'elevation_to': 926.5, 'soil_type': 'Silty Sand', 'description': 'FINE TO MEDIUM SAND, Trace Clay', 'unit_weight': 110.0, 'spt_n_field': 29, 'sigma_v': 550.0, 'sigma_v_prime': 550.0, 'n60': 29.0, 'cn': 1.5, 'n1_60': 43.5, 'phi_prime': 37.5, 'cohesion': None, 'moisture_content': None}, {'depth_from': 10.0, 'depth_to': 15.0, 'elevation_from': 926.5, 'elevation_to': 921.5, 'soil_type': 'Lean Clay', 'description': 'LEAN CLAY, Trace Sand', 'unit_weight': 120.0, 'spt_n_field': 15, 'sigma_v': 720.0, 'sigma_v_prime': 720.0, 'n60': 15.0, 'cn': None, 'n1_60': None, 'phi_prime': None, 'cohesion': 3750.0, 'moisture_content': None}, {'depth_from': 15.0, 'depth_to': 20.0, 'elevation_from': 921.5, 'elevation_to': 916.5, 'soil_type': 'Sandy Lean Clay', 'description': 'SANDY LEAN CLAY, Trace Gravel', 'unit_weight': 120.0, 'spt_n_field': 18, 'sigma_v': 720.0, 'sigma_v_prime': 720.0, 'n60': 18.0, 'cn': None, 'n1_60': None, 'phi_prime': None, 'cohesion': 4500.0, 'moisture_content': None}], 'design_summary': [{'layer_description': 'Lean Clay (0-5 ft)', 'parameter_type': 'cohesion', 'recommended_value': 3500.0, 'unit': 'psf', 'range': '3000-4000 psf'}, {'layer_description': 'Silty Sand (5-10 ft)', 'parameter_type': 'phi_prime', 'recommended_value': 37.5, 'unit': 'degrees', 'range': '35-40 degrees'}, {'layer_description': 'Lean Clay (10-15 ft)', 'parameter_type': 'cohesion', 'recommended_value': 3750.0, 'unit': 'psf', 'range': '3500-4000 psf'}, {'layer_description': 'Sandy Lean Clay (15-20 ft)', 'parameter_type': 'cohesion', 'recommended_value': 4500.0, 'unit': 'psf', 'range': '4000-5000 psf'}], 'plot_data': {'depths': [0, 5, 10, 15, 20], 'phi_prime_values': [None, 37.5, None, None], 'cohesion_values': [3500, None, 3750, 4500]}, 'notes': 'The boring log indicates varying soil types with significant clay content and some sandy layers. The groundwater table was assumed to be at 10 ft.', 'designs': [{'timestamp': '2026-01-03T17:24:26.201002+00:00', 'design_load': 20.0, 'safety_factor': 2.0, 'shaft_system': None, 'use_ai': True, 'result': {'design_load': 20.0, 'safety_factor': 2.0, 'required_ultimate_capacity': 40.0, 'ai_recommendations': {'recommended_min_depth': 20.0, 'recommended_max_depth': 32.0, 'recommended_shaft_systems': ['SS175', 'SS150'], 'depth_rationale': 'Based on soil stratigraphy, the strongest bearing layers are below 15 ft, requiring deeper installation to engage these layers effectively.', 'shaft_rationale': 'SS175 is selected for its higher ultimate capacity and torque limit, meeting the 40 kips ultimate requirement. SS150 is considered for its cost-effectiveness in moderate load scenarios.', 'bearing_layer_analysis': 'Key bearing layers include the silty sand layer (5-10 ft) with a friction angle of 30°, and the underlying clay layers (10-20 ft) with high cohesion values.', 'design_alternatives': [{'name': 'Option 1: SS175 Triple Helix 10"-12"-14"', 'shaft_system': 'SS175', 'helix_configuration': [{'diameter': 10, 'depth': 15.0, 'soil_layer': 'Silty Sand'}, {'diameter': 12, 'depth': 18.5, 'soil_layer': 'Lean Clay'}, {'diameter': 14, 'depth': 22.0, 'soil_layer': 'Sandy Lean Clay'}], 'estimated_depth': 22.0, 'minimum_torque': 4000, 'torque_correlation_factor': 10, 'priority': 1, 'rationale': 'Meets 40-kip ultimate capacity requirement. Helices engage both silty sand and clay layers. Design controlled by SS175 mechanical limit.', 'advantages': ['High load capacity', 'Engages multiple strong soil layers'], 'considerations': ['Requires high torque installation', 'Deeper installation'], 'failure_analysis': 'Would fail if installation torque cannot reach 4000 ft-lb or if clay layers are weaker than expected', 'installation_specs': {'min_torque_ftlb': 4000, 'embedment_depth_ft': 22.0, 'termination_criteria': 'Achieve both 22 ft depth AND 4000 ft-lb torque', 'buckling_check': 'N > 10 in bearing strata - adequate'}}, {'name': 'Option 2: SS150 Double Helix 12"-14"', 'shaft_system': 'SS150', 'helix_configuration': [{'diameter': 12, 'depth': 15.0, 'soil_layer': 'Silty Sand'}, {'diameter': 14, 'depth': 18.5, 'soil_layer': 'Lean Clay'}], 'estimated_depth': 18.5, 'minimum_torque': 3500, 'torque_correlation_factor': 10, 'priority': 2, 'rationale': 'Economical option for moderate loads. Engages silty sand and clay layers.', 'advantages': ['Lower cost', 'Shallower installation'], 'considerations': ['May be capacity-limited', 'Less redundancy'], 'failure_analysis': 'Would fail if soil conditions are weaker than anticipated or if only one helix engages bearing layer', 'installation_specs': {'min_torque_ftlb': 3500, 'embedment_depth_ft': 18.5, 'termination_criteria': 'Achieve both 18.5 ft depth AND 3500 ft-lb torque', 'buckling_check': 'N > 10 in bearing strata - adequate'}}, {'name': 'Option 3: SS175 Single Helix 14"', 'shaft_system': 'SS175', 'helix_configuration': [{'diameter': 14, 'depth': 20.0, 'soil_layer': 'Sandy Lean Clay'}], 'estimated_depth': 20.0, 'minimum_torque': 5000, 'torque_correlation_factor': 10, 'priority': 3, 'rationale': 'Single helix design for simplicity and cost-effectiveness in strong soil.', 'advantages': ['Simpler installation', 'Cost-effective'], 'considerations': ['Limited redundancy', 'Relies on single bearing layer'], 'failure_analysis': 'Would fail if sandy lean clay layer is not encountered at expected depth or is weaker than anticipated', 'installation_specs': {'min_torque_ftlb': 5000, 'embedment_depth_ft': 20.0, 'termination_criteria': 'Achieve both 20 ft depth AND 5000 ft-lb torque', 'buckling_check': 'N > 10 in bearing strata - adequate'}}], 'soil_analysis': 'The soil stratigraphy includes layers of lean clay, silty sand, and sandy lean clay. The silty sand layer provides good frictional resistance, while the clay layers offer high cohesion, making them suitable for bearing.', 'recommendations_summary': 'Based on the A.B. Chance methodology, the SS175 system with a triple helix configuration is recommended for maximum capacity and redundancy. The SS150 system with a double helix offers a cost-effective alternative for moderate loads. Single helix designs are suitable for strong, uniform soil conditions.'}, 'design_parameters': {'min_depth': 20.0, 'max_depth': 32.0, 'shaft_system': 'SS175'}, 'calculated_designs': [{'name': 'Option 1: SS175 Triple Helix 10"-12"-14"', 'shaft_system': 'SS175', 'helix_configuration': [{'diameter': 10, 'depth': 15.0, 'soil_layer': 'Silty Sand'}, {'diameter': 12, 'depth': 18.5, 'soil_layer': 'Lean Clay'}, {'diameter': 14, 'depth': 22.0, 'soil_layer': 'Sandy Lean Clay'}], 'ultimate_capacity': 102.81670500000001, 'allowable_capacity': 51.40835250000001, 'design_load': 20.0, 'safety_factor': 2.0, 'passes': True, 'capacity_ratio': 2.570417625, 'priority': 1, 'rationale': 'Meets 40-kip ultimate capacity requirement. Helices engage both silty sand and clay layers. Design controlled by SS175 mechanical limit.', 'advantages': ['High load capacity', 'Engages multiple strong soil layers'], 'considerations': ['Requires high torque installation', 'Deeper installation'], 'capacity_details': {'shaft_system': 'SS175', 'num_helices': 3, 'helix_details': [{'helix_diameter': 10, 'depth': 15.0, 'helix_area': 0.531, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 1.75, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.125, 'cohesion_component': 40.5, 'friction_component': 2.625, 'capacity_soil': 22.899375000000003, 'capacity_mechanical': 100, 'capacity_ultimate': 22.899375000000003, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 10" helix', 'calculation': 'Ah = 0.531 sq.ft', 'result': 0.531, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 15.0 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 1.750 ksf (at depth 15.0 ft)', 'result': 1.75, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 1.750×1.50\nqult = 40.50 + 2.62\nqult = 43.12 ksf', 'result': 43.125, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 0.531 × 43.12\nQh = 22.90 kips', 'result': 22.899375000000003, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity', 'calculation': 'Qs = 100.00 kips', 'result': 100, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(22.90, 100.00)\nQult = 22.90 kips\nControlled by: Soil', 'result': 22.899375000000003, 'units': 'kips'}]}, {'helix_diameter': 12, 'depth': 18.5, 'helix_area': 0.771, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 2.17, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.755, 'cohesion_component': 40.5, 'friction_component': 3.255, 'capacity_soil': 33.735105000000004, 'capacity_mechanical': 100, 'capacity_ultimate': 33.735105000000004, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 12" helix', 'calculation': 'Ah = 0.771 sq.ft', 'result': 0.771, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 18.5 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 2.170 ksf (at depth 18.5 ft)', 'result': 2.17, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 2.170×1.50\nqult = 40.50 + 3.25\nqult = 43.76 ksf', 'result': 43.755, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 0.771 × 43.76\nQh = 33.74 kips', 'result': 33.735105000000004, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity', 'calculation': 'Qs = 100.00 kips', 'result': 100, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(33.74, 100.00)\nQult = 33.74 kips\nControlled by: Soil', 'result': 33.735105000000004, 'units': 'kips'}]}, {'helix_diameter': 14, 'depth': 22.0, 'helix_area': 1.049, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 2.35, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 44.025, 'cohesion_component': 40.5, 'friction_component': 3.5250000000000004, 'capacity_soil': 46.182224999999995, 'capacity_mechanical': 80.0, 'capacity_ultimate': 46.182224999999995, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 14" helix', 'calculation': 'Ah = 1.049 sq.ft', 'result': 1.049, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 22.0 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 2.350 ksf (at depth 22.0 ft)', 'result': 2.35, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 2.350×1.50\nqult = 40.50 + 3.53\nqult = 44.02 ksf', 'result': 44.025, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 1.049 × 44.02\nQh = 46.18 kips', 'result': 46.182224999999995, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity × 0.8 (14" helix reduction)', 'calculation': 'Qs = 100.0 × 0.8\nQs = 80.00 kips', 'result': 80.0, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(46.18, 80.00)\nQult = 46.18 kips\nControlled by: Soil', 'result': 46.182224999999995, 'units': 'kips'}]}], 'total_ultimate_capacity': 102.81670500000001, 'calculation_method': 'Chance Individual Bearing Method'}, 'installation_specifications': {'torque_correlation_factor': 10, 'min_installation_torque_ftlb': 10281, 'max_torque_rating_ftlb': 10000, 'torque_adequate': False, 'embedment_depth_ft': 22.0, 'termination_criteria': 'Achieve both 22.0 ft depth AND 10,281 ft-lb torque', 'buckling_check': {'min_n_value': 10, 'adequate': True, 'note': 'Adequate (N > 4)'}}}, {'name': 'Option 2: SS150 Double Helix 12"-14"', 'shaft_system': 'SS150', 'helix_configuration': [{'diameter': 12, 'depth': 15.0, 'soil_layer': 'Silty Sand'}, {'diameter': 14, 'depth': 18.5, 'soil_layer': 'Lean Clay'}], 'ultimate_capacity': 79.14837, 'allowable_capacity': 39.574185, 'design_load': 20.0, 'safety_factor': 2.0, 'passes': True, 'capacity_ratio': 1.97870925, 'priority': 2, 'rationale': 'Economical option for moderate loads. Engages silty sand and clay layers.', 'advantages': ['Lower cost', 'Shallower installation'], 'considerations': ['May be capacity-limited', 'Less redundancy'], 'capacity_details': {'shaft_system': 'SS150', 'num_helices': 2, 'helix_details': [{'helix_diameter': 12, 'depth': 15.0, 'helix_area': 0.771, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 1.75, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.125, 'cohesion_component': 40.5, 'friction_component': 2.625, 'capacity_soil': 33.249375, 'capacity_mechanical': 70, 'capacity_ultimate': 33.249375, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 12" helix', 'calculation': 'Ah = 0.771 sq.ft', 'result': 0.771, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 15.0 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 1.750 ksf (at depth 15.0 ft)', 'result': 1.75, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 1.750×1.50\nqult = 40.50 + 2.62\nqult = 43.12 ksf', 'result': 43.125, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 0.771 × 43.12\nQh = 33.25 kips', 'result': 33.249375, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS150 ultimate capacity', 'calculation': 'Qs = 70.00 kips', 'result': 70, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(33.25, 70.00)\nQult = 33.25 kips\nControlled by: Soil', 'result': 33.249375, 'units': 'kips'}]}, {'helix_diameter': 14, 'depth': 18.5, 'helix_area': 1.049, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 2.17, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.755, 'cohesion_component': 40.5, 'friction_component': 3.255, 'capacity_soil': 45.898995, 'capacity_mechanical': 56.0, 'capacity_ultimate': 45.898995, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 14" helix', 'calculation': 'Ah = 1.049 sq.ft', 'result': 1.049, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 18.5 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 2.170 ksf (at depth 18.5 ft)', 'result': 2.17, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 2.170×1.50\nqult = 40.50 + 3.25\nqult = 43.76 ksf', 'result': 43.755, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 1.049 × 43.76\nQh = 45.90 kips', 'result': 45.898995, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS150 ultimate capacity × 0.8 (14" helix reduction)', 'calculation': 'Qs = 70.0 × 0.8\nQs = 56.00 kips', 'result': 56.0, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(45.90, 56.00)\nQult = 45.90 kips\nControlled by: Soil', 'result': 45.898995, 'units': 'kips'}]}], 'total_ultimate_capacity': 79.14837, 'calculation_method': 'Chance Individual Bearing Method'}, 'installation_specifications': {'torque_correlation_factor': 10, 'min_installation_torque_ftlb': 7914, 'max_torque_rating_ftlb': 7000, 'torque_adequate': False, 'embedment_depth_ft': 18.5, 'termination_criteria': 'Achieve both 18.5 ft depth AND 7,914 ft-lb torque', 'buckling_check': {'min_n_value': 10, 'adequate': True, 'note': 'Adequate (N > 4)'}}}, {'name': 'Option 3: SS175 Single Helix 14"', 'shaft_system': 'SS175', 'helix_configuration': [{'diameter': 14, 'depth': 20.0, 'soil_layer': 'Sandy Lean Clay'}], 'ultimate_capacity': 46.182224999999995, 'allowable_capacity': 23.091112499999998, 'design_load': 20.0, 'safety_factor': 2.0, 'passes': True, 'capacity_ratio': 1.154555625, 'priority': 3, 'rationale': 'Single helix design for simplicity and cost-effectiveness in strong soil.', 'advantages': ['Simpler installation', 'Cost-effective'], 'considerations': ['Limited redundancy', 'Relies on single bearing layer'], 'capacity_details': {'shaft_system': 'SS175', 'num_helices': 1, 'helix_details': [{'helix_diameter': 14, 'depth': 20.0, 'helix_area': 1.049, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 2.35, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 44.025, 'cohesion_component': 40.5, 'friction_component': 3.5250000000000004, 'capacity_soil': 46.182224999999995, 'capacity_mechanical': 80.0, 'capacity_ultimate': 46.182224999999995, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 14" helix', 'calculation': 'Ah = 1.049 sq.ft', 'result': 1.049, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 20.0 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 2.350 ksf (at depth 20.0 ft)', 'result': 2.35, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 2.350×1.50\nqult = 40.50 + 3.53\nqult = 44.02 ksf', 'result': 44.025, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 1.049 × 44.02\nQh = 46.18 kips', 'result': 46.182224999999995, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity × 0.8 (14" helix reduction)', 'calculation': 'Qs = 100.0 × 0.8\nQs = 80.00 kips', 'result': 80.0, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(46.18, 80.00)\nQult = 46.18 kips\nControlled by: Soil', 'result': 46.182224999999995, 'units': 'kips'}]}], 'total_ultimate_capacity': 46.182224999999995, 'calculation_method': 'Chance Individual Bearing Method'}, 'installation_specifications': {'torque_correlation_factor': 10, 'min_installation_torque_ftlb': 4618, 'max_torque_rating_ftlb': 10000, 'torque_adequate': True, 'embedment_depth_ft': 20.0, 'termination_criteria': 'Achieve both 20.0 ft depth AND 4,618 ft-lb torque', 'buckling_check': {'min_n_value': 100, 'adequate': True, 'note': 'Adequate (N > 4)'}}}], 'best_design': {'name': 'Option 1: SS175 Triple Helix 10"-12"-14"', 'shaft_system': 'SS175', 'helix_configuration': [{'diameter': 10, 'depth': 15.0, 'soil_layer': 'Silty Sand'}, {'diameter': 12, 'depth': 18.5, 'soil_layer': 'Lean Clay'}, {'diameter': 14, 'depth': 22.0, 'soil_layer': 'Sandy Lean Clay'}], 'ultimate_capacity': 102.81670500000001, 'allowable_capacity': 51.40835250000001, 'design_load': 20.0, 'safety_factor': 2.0, 'passes': True, 'capacity_ratio': 2.570417625, 'priority': 1, 'rationale': 'Meets 40-kip ultimate capacity requirement. Helices engage both silty sand and clay layers. Design controlled by SS175 mechanical limit.', 'advantages': ['High load capacity', 'Engages multiple strong soil layers'], 'considerations': ['Requires high torque installation', 'Deeper installation'], 'capacity_details': {'shaft_system': 'SS175', 'num_helices': 3, 'helix_details': [{'helix_diameter': 10, 'depth': 15.0, 'helix_area': 0.531, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 1.75, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.125, 'cohesion_component': 40.5, 'friction_component': 2.625, 'capacity_soil': 22.899375000000003, 'capacity_mechanical': 100, 'capacity_ultimate': 22.899375000000003, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 10" helix', 'calculation': 'Ah = 0.531 sq.ft', 'result': 0.531, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 15.0 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 1.750 ksf (at depth 15.0 ft)', 'result': 1.75, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 1.750×1.50\nqult = 40.50 + 2.62\nqult = 43.12 ksf', 'result': 43.125, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 0.531 × 43.12\nQh = 22.90 kips', 'result': 22.899375000000003, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity', 'calculation': 'Qs = 100.00 kips', 'result': 100, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(22.90, 100.00)\nQult = 22.90 kips\nControlled by: Soil', 'result': 22.899375000000003, 'units': 'kips'}]}, {'helix_diameter': 12, 'depth': 18.5, 'helix_area': 0.771, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 2.17, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.755, 'cohesion_component': 40.5, 'friction_component': 3.255, 'capacity_soil': 33.735105000000004, 'capacity_mechanical': 100, 'capacity_ultimate': 33.735105000000004, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 12" helix', 'calculation': 'Ah = 0.771 sq.ft', 'result': 0.771, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 18.5 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 2.170 ksf (at depth 18.5 ft)', 'result': 2.17, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 2.170×1.50\nqult = 40.50 + 3.25\nqult = 43.76 ksf', 'result': 43.755, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 0.771 × 43.76\nQh = 33.74 kips', 'result': 33.735105000000004, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity', 'calculation': 'Qs = 100.00 kips', 'result': 100, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(33.74, 100.00)\nQult = 33.74 kips\nControlled by: Soil', 'result': 33.735105000000004, 'units': 'kips'}]}, {'helix_diameter': 14, 'depth': 22.0, 'helix_area': 1.049, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 2.35, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 44.025, 'cohesion_component': 40.5, 'friction_component': 3.5250000000000004, 'capacity_soil': 46.182224999999995, 'capacity_mechanical': 80.0, 'capacity_ultimate': 46.182224999999995, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 14" helix', 'calculation': 'Ah = 1.049 sq.ft', 'result': 1.049, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 22.0 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 2.350 ksf (at depth 22.0 ft)', 'result': 2.35, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 2.350×1.50\nqult = 40.50 + 3.53\nqult = 44.02 ksf', 'result': 44.025, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 1.049 × 44.02\nQh = 46.18 kips', 'result': 46.182224999999995, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity × 0.8 (14" helix reduction)', 'calculation': 'Qs = 100.0 × 0.8\nQs = 80.00 kips', 'result': 80.0, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(46.18, 80.00)\nQult = 46.18 kips\nControlled by: Soil', 'result': 46.182224999999995, 'units': 'kips'}]}], 'total_ultimate_capacity': 102.81670500000001, 'calculation_method': 'Chance Individual Bearing Method'}, 'installation_specifications': {'torque_correlation_factor': 10, 'min_installation_torque_ftlb': 10281, 'max_torque_rating_ftlb': 10000, 'torque_adequate': False, 'embedment_depth_ft': 22.0, 'termination_criteria': 'Achieve both 22.0 ft depth AND 10,281 ft-lb torque', 'buckling_check': {'min_n_value': 10, 'adequate': True, 'note': 'Adequate (N > 4)'}}}, 'num_passing_designs': 3}}, {'timestamp': '2026-04-09T21:18:45.082748+00:00', 'design_load': 20.0, 'safety_factor': 2.0, 'shaft_system': None, 'use_ai': True, 'result': {'design_load': 20.0, 'safety_factor': 2.0, 'required_ultimate_capacity': 40.0, 'ai_recommendations': {'recommended_min_depth': 15.0, 'recommended_max_depth': 20.0, 'recommended_shaft_systems': ['SS150', 'SS175'], 'depth_rationale': 'The minimum depth is determined by the need to engage the stronger soil layers below 10 ft, specifically the sandy lean clay layer with high cohesion.', 'shaft_rationale': 'SS150 and SS175 are selected based on their ability to meet the ultimate capacity requirement of 40 kips while considering torque limitations and cost-effectiveness.', 'bearing_layer_analysis': 'Key bearing layers include the silty sand (5-10 ft) with a friction angle of 30° and the sandy lean clay (15-20 ft) with high cohesion of 4500 ksf.', 'design_alternatives': [{'name': 'Option 1: SS175 Triple Helix 10"-12"-14"', 'shaft_system': 'SS175', 'helix_configuration': [{'diameter': 10, 'depth': 12.0, 'soil_layer': 'Silty Sand'}, {'diameter': 12, 'depth': 15.5, 'soil_layer': 'Lean Clay'}, {'diameter': 14, 'depth': 19.0, 'soil_layer': 'Sandy Lean Clay'}], 'estimated_depth': 19.0, 'minimum_torque': 8000, 'torque_correlation_factor': 10, 'priority': 1, 'rationale': 'This configuration ensures engagement with the strongest soil layers, achieving the required ultimate capacity with redundancy.', 'advantages': ['High capacity', 'Redundancy with triple helix', 'Engages multiple strong layers'], 'considerations': ['Higher cost due to deeper installation', 'Requires higher installation torque'], 'failure_analysis': 'Would fail if installation torque cannot reach required value due to hard layer', 'installation_specs': {'min_torque_ftlb': 8000, 'embedment_depth_ft': 19.0, 'termination_criteria': 'Achieve both 19 ft depth AND 8,000 ft-lb torque', 'buckling_check': 'N > 10 in bearing strata - adequate'}}, {'name': 'Option 2: SS150 Double Helix 12"-14"', 'shaft_system': 'SS150', 'helix_configuration': [{'diameter': 12, 'depth': 15.0, 'soil_layer': 'Lean Clay'}, {'diameter': 14, 'depth': 18.5, 'soil_layer': 'Sandy Lean Clay'}], 'estimated_depth': 18.5, 'minimum_torque': 7000, 'torque_correlation_factor': 10, 'priority': 2, 'rationale': 'Economical option for moderate loads, engaging the sandy lean clay layer for capacity.', 'advantages': ['Lower cost', 'Shallower installation', 'Adequate for moderate loads'], 'considerations': ['Less redundancy than triple helix', 'Capacity-limited'], 'failure_analysis': 'Would fail if soil conditions are weaker than anticipated', 'installation_specs': {'min_torque_ftlb': 7000, 'embedment_depth_ft': 18.5, 'termination_criteria': 'Achieve both 18.5 ft depth AND 7,000 ft-lb torque', 'buckling_check': 'N > 10 in bearing strata - adequate'}}, {'name': 'Option 3: SS175 Single Helix 14"', 'shaft_system': 'SS175', 'helix_configuration': [{'diameter': 14, 'depth': 17.0, 'soil_layer': 'Sandy Lean Clay'}], 'estimated_depth': 17.0, 'minimum_torque': 5000, 'torque_correlation_factor': 10, 'priority': 3, 'rationale': 'Single helix design for cost efficiency, engaging the strongest clay layer.', 'advantages': ['Most economical', 'Simple installation'], 'considerations': ['Limited capacity', 'Single point of failure'], 'failure_analysis': 'Would fail if bearing layer is not encountered at expected depth', 'installation_specs': {'min_torque_ftlb': 5000, 'embedment_depth_ft': 17.0, 'termination_criteria': 'Achieve both 17 ft depth AND 5,000 ft-lb torque', 'buckling_check': 'N > 10 in bearing strata - adequate'}}], 'soil_analysis': 'The soil stratigraphy includes lean clay, silty sand, and sandy lean clay. The key bearing layers are the silty sand and sandy lean clay, which provide the best friction and cohesion properties for bearing capacity.', 'recommendations_summary': 'The recommended designs engage the strongest soil layers while considering cost and installation constraints. SS175 with a triple helix is preferred for maximum capacity, while SS150 with a double helix offers a more economical solution. Single helix designs are suitable for cost-sensitive projects with moderate load requirements.'}, 'design_parameters': {'min_depth': 15.0, 'max_depth': 20.0, 'shaft_system': 'SS150'}, 'calculated_designs': [{'name': 'Option 1: SS175 Triple Helix 10"-12"-14"', 'shaft_system': 'SS175', 'helix_configuration': [{'diameter': 10, 'depth': 12.0, 'soil_layer': 'Silty Sand'}, {'diameter': 12, 'depth': 15.5, 'soil_layer': 'Lean Clay'}, {'diameter': 14, 'depth': 19.0, 'soil_layer': 'Sandy Lean Clay'}], 'ultimate_capacity': 98.340555, 'allowable_capacity': 49.1702775, 'design_load': 20.0, 'safety_factor': 2.0, 'passes': True, 'capacity_ratio': 2.458513875, 'priority': 1, 'rationale': 'This configuration ensures engagement with the strongest soil layers, achieving the required ultimate capacity with redundancy.', 'advantages': ['High capacity', 'Redundancy with triple helix', 'Engages multiple strong layers'], 'considerations': ['Higher cost due to deeper installation', 'Requires higher installation torque'], 'capacity_details': {'shaft_system': 'SS175', 'num_helices': 3, 'helix_details': [{'helix_diameter': 10, 'depth': 12.0, 'helix_area': 0.531, 'soil_type': 'Lean Clay', 'spt_n_value': 10, 'cohesion': 3.75, 'friction_angle': 0, 'overburden_pressure': 1.39, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 35.835, 'cohesion_component': 33.75, 'friction_component': 2.085, 'capacity_soil': 19.028385, 'capacity_mechanical': 100, 'capacity_ultimate': 19.028385, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 10" helix', 'calculation': 'Ah = 0.531 sq.ft', 'result': 0.531, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 12.0 ft', 'calculation': 'Soil Type: Lean Clay\nSPT N-value: 10\nCohesion (c): 3.75 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 3.75, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 1.390 ksf (at depth 12.0 ft)', 'result': 1.39, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×3.75 + 1.390×1.50\nqult = 33.75 + 2.08\nqult = 35.84 ksf', 'result': 35.835, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 0.531 × 35.84\nQh = 19.03 kips', 'result': 19.028385, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity', 'calculation': 'Qs = 100.00 kips', 'result': 100, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(19.03, 100.00)\nQult = 19.03 kips\nControlled by: Soil', 'result': 19.028385, 'units': 'kips'}]}, {'helix_diameter': 12, 'depth': 15.5, 'helix_area': 0.771, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 1.81, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.215, 'cohesion_component': 40.5, 'friction_component': 2.715, 'capacity_soil': 33.318765000000006, 'capacity_mechanical': 100, 'capacity_ultimate': 33.318765000000006, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 12" helix', 'calculation': 'Ah = 0.771 sq.ft', 'result': 0.771, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 15.5 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 1.810 ksf (at depth 15.5 ft)', 'result': 1.81, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 1.810×1.50\nqult = 40.50 + 2.71\nqult = 43.22 ksf', 'result': 43.215, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 0.771 × 43.22\nQh = 33.32 kips', 'result': 33.318765000000006, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity', 'calculation': 'Qs = 100.00 kips', 'result': 100, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(33.32, 100.00)\nQult = 33.32 kips\nControlled by: Soil', 'result': 33.318765000000006, 'units': 'kips'}]}, {'helix_diameter': 14, 'depth': 19.0, 'helix_area': 1.049, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 2.23, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.845, 'cohesion_component': 40.5, 'friction_component': 3.3449999999999998, 'capacity_soil': 45.993404999999996, 'capacity_mechanical': 80.0, 'capacity_ultimate': 45.993404999999996, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 14" helix', 'calculation': 'Ah = 1.049 sq.ft', 'result': 1.049, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 19.0 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 2.230 ksf (at depth 19.0 ft)', 'result': 2.23, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 2.230×1.50\nqult = 40.50 + 3.34\nqult = 43.84 ksf', 'result': 43.845, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 1.049 × 43.84\nQh = 45.99 kips', 'result': 45.993404999999996, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity × 0.8 (14" helix reduction)', 'calculation': 'Qs = 100.0 × 0.8\nQs = 80.00 kips', 'result': 80.0, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(45.99, 80.00)\nQult = 45.99 kips\nControlled by: Soil', 'result': 45.993404999999996, 'units': 'kips'}]}], 'total_ultimate_capacity': 98.340555, 'calculation_method': 'Chance Individual Bearing Method'}, 'installation_specifications': {'torque_correlation_factor': 10, 'min_installation_torque_ftlb': 9834, 'max_torque_rating_ftlb': 10000, 'torque_adequate': True, 'embedment_depth_ft': 19.0, 'termination_criteria': 'Achieve both 19.0 ft depth AND 9,834 ft-lb torque', 'buckling_check': {'min_n_value': 10, 'adequate': True, 'note': 'Adequate (N > 4)'}}}, {'name': 'Option 2: SS150 Double Helix 12"-14"', 'shaft_system': 'SS150', 'helix_configuration': [{'diameter': 12, 'depth': 15.0, 'soil_layer': 'Lean Clay'}, {'diameter': 14, 'depth': 18.5, 'soil_layer': 'Sandy Lean Clay'}], 'ultimate_capacity': 79.14837, 'allowable_capacity': 39.574185, 'design_load': 20.0, 'safety_factor': 2.0, 'passes': True, 'capacity_ratio': 1.97870925, 'priority': 2, 'rationale': 'Economical option for moderate loads, engaging the sandy lean clay layer for capacity.', 'advantages': ['Lower cost', 'Shallower installation', 'Adequate for moderate loads'], 'considerations': ['Less redundancy than triple helix', 'Capacity-limited'], 'capacity_details': {'shaft_system': 'SS150', 'num_helices': 2, 'helix_details': [{'helix_diameter': 12, 'depth': 15.0, 'helix_area': 0.771, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 1.75, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.125, 'cohesion_component': 40.5, 'friction_component': 2.625, 'capacity_soil': 33.249375, 'capacity_mechanical': 70, 'capacity_ultimate': 33.249375, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 12" helix', 'calculation': 'Ah = 0.771 sq.ft', 'result': 0.771, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 15.0 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 1.750 ksf (at depth 15.0 ft)', 'result': 1.75, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 1.750×1.50\nqult = 40.50 + 2.62\nqult = 43.12 ksf', 'result': 43.125, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 0.771 × 43.12\nQh = 33.25 kips', 'result': 33.249375, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS150 ultimate capacity', 'calculation': 'Qs = 70.00 kips', 'result': 70, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(33.25, 70.00)\nQult = 33.25 kips\nControlled by: Soil', 'result': 33.249375, 'units': 'kips'}]}, {'helix_diameter': 14, 'depth': 18.5, 'helix_area': 1.049, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 2.17, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.755, 'cohesion_component': 40.5, 'friction_component': 3.255, 'capacity_soil': 45.898995, 'capacity_mechanical': 56.0, 'capacity_ultimate': 45.898995, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 14" helix', 'calculation': 'Ah = 1.049 sq.ft', 'result': 1.049, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 18.5 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 2.170 ksf (at depth 18.5 ft)', 'result': 2.17, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 2.170×1.50\nqult = 40.50 + 3.25\nqult = 43.76 ksf', 'result': 43.755, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 1.049 × 43.76\nQh = 45.90 kips', 'result': 45.898995, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS150 ultimate capacity × 0.8 (14" helix reduction)', 'calculation': 'Qs = 70.0 × 0.8\nQs = 56.00 kips', 'result': 56.0, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(45.90, 56.00)\nQult = 45.90 kips\nControlled by: Soil', 'result': 45.898995, 'units': 'kips'}]}], 'total_ultimate_capacity': 79.14837, 'calculation_method': 'Chance Individual Bearing Method'}, 'installation_specifications': {'torque_correlation_factor': 10, 'min_installation_torque_ftlb': 7914, 'max_torque_rating_ftlb': 7000, 'torque_adequate': False, 'embedment_depth_ft': 18.5, 'termination_criteria': 'Achieve both 18.5 ft depth AND 7,914 ft-lb torque', 'buckling_check': {'min_n_value': 10, 'adequate': True, 'note': 'Adequate (N > 4)'}}}, {'name': 'Option 3: SS175 Single Helix 14"', 'shaft_system': 'SS175', 'helix_configuration': [{'diameter': 14, 'depth': 17.0, 'soil_layer': 'Sandy Lean Clay'}], 'ultimate_capacity': 45.615764999999996, 'allowable_capacity': 22.807882499999998, 'design_load': 20.0, 'safety_factor': 2.0, 'passes': True, 'capacity_ratio': 1.1403941249999998, 'priority': 3, 'rationale': 'Single helix design for cost efficiency, engaging the strongest clay layer.', 'advantages': ['Most economical', 'Simple installation'], 'considerations': ['Limited capacity', 'Single point of failure'], 'capacity_details': {'shaft_system': 'SS175', 'num_helices': 1, 'helix_details': [{'helix_diameter': 14, 'depth': 17.0, 'helix_area': 1.049, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 1.99, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.485, 'cohesion_component': 40.5, 'friction_component': 2.985, 'capacity_soil': 45.615764999999996, 'capacity_mechanical': 80.0, 'capacity_ultimate': 45.615764999999996, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 14" helix', 'calculation': 'Ah = 1.049 sq.ft', 'result': 1.049, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 17.0 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 1.990 ksf (at depth 17.0 ft)', 'result': 1.99, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 1.990×1.50\nqult = 40.50 + 2.98\nqult = 43.48 ksf', 'result': 43.485, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 1.049 × 43.48\nQh = 45.62 kips', 'result': 45.615764999999996, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity × 0.8 (14" helix reduction)', 'calculation': 'Qs = 100.0 × 0.8\nQs = 80.00 kips', 'result': 80.0, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(45.62, 80.00)\nQult = 45.62 kips\nControlled by: Soil', 'result': 45.615764999999996, 'units': 'kips'}]}], 'total_ultimate_capacity': 45.615764999999996, 'calculation_method': 'Chance Individual Bearing Method'}, 'installation_specifications': {'torque_correlation_factor': 10, 'min_installation_torque_ftlb': 4561, 'max_torque_rating_ftlb': 10000, 'torque_adequate': True, 'embedment_depth_ft': 17.0, 'termination_criteria': 'Achieve both 17.0 ft depth AND 4,561 ft-lb torque', 'buckling_check': {'min_n_value': 10, 'adequate': True, 'note': 'Adequate (N > 4)'}}}], 'best_design': {'name': 'Option 1: SS175 Triple Helix 10"-12"-14"', 'shaft_system': 'SS175', 'helix_configuration': [{'diameter': 10, 'depth': 12.0, 'soil_layer': 'Silty Sand'}, {'diameter': 12, 'depth': 15.5, 'soil_layer': 'Lean Clay'}, {'diameter': 14, 'depth': 19.0, 'soil_layer': 'Sandy Lean Clay'}], 'ultimate_capacity': 98.340555, 'allowable_capacity': 49.1702775, 'design_load': 20.0, 'safety_factor': 2.0, 'passes': True, 'capacity_ratio': 2.458513875, 'priority': 1, 'rationale': 'This configuration ensures engagement with the strongest soil layers, achieving the required ultimate capacity with redundancy.', 'advantages': ['High capacity', 'Redundancy with triple helix', 'Engages multiple strong layers'], 'considerations': ['Higher cost due to deeper installation', 'Requires higher installation torque'], 'capacity_details': {'shaft_system': 'SS175', 'num_helices': 3, 'helix_details': [{'helix_diameter': 10, 'depth': 12.0, 'helix_area': 0.531, 'soil_type': 'Lean Clay', 'spt_n_value': 10, 'cohesion': 3.75, 'friction_angle': 0, 'overburden_pressure': 1.39, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 35.835, 'cohesion_component': 33.75, 'friction_component': 2.085, 'capacity_soil': 19.028385, 'capacity_mechanical': 100, 'capacity_ultimate': 19.028385, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 10" helix', 'calculation': 'Ah = 0.531 sq.ft', 'result': 0.531, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 12.0 ft', 'calculation': 'Soil Type: Lean Clay\nSPT N-value: 10\nCohesion (c): 3.75 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 3.75, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 1.390 ksf (at depth 12.0 ft)', 'result': 1.39, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×3.75 + 1.390×1.50\nqult = 33.75 + 2.08\nqult = 35.84 ksf', 'result': 35.835, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 0.531 × 35.84\nQh = 19.03 kips', 'result': 19.028385, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity', 'calculation': 'Qs = 100.00 kips', 'result': 100, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(19.03, 100.00)\nQult = 19.03 kips\nControlled by: Soil', 'result': 19.028385, 'units': 'kips'}]}, {'helix_diameter': 12, 'depth': 15.5, 'helix_area': 0.771, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 1.81, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.215, 'cohesion_component': 40.5, 'friction_component': 2.715, 'capacity_soil': 33.318765000000006, 'capacity_mechanical': 100, 'capacity_ultimate': 33.318765000000006, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 12" helix', 'calculation': 'Ah = 0.771 sq.ft', 'result': 0.771, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 15.5 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 1.810 ksf (at depth 15.5 ft)', 'result': 1.81, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 1.810×1.50\nqult = 40.50 + 2.71\nqult = 43.22 ksf', 'result': 43.215, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 0.771 × 43.22\nQh = 33.32 kips', 'result': 33.318765000000006, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity', 'calculation': 'Qs = 100.00 kips', 'result': 100, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(33.32, 100.00)\nQult = 33.32 kips\nControlled by: Soil', 'result': 33.318765000000006, 'units': 'kips'}]}, {'helix_diameter': 14, 'depth': 19.0, 'helix_area': 1.049, 'soil_type': 'Sandy Lean Clay', 'spt_n_value': 10, 'cohesion': 4.5, 'friction_angle': 0, 'overburden_pressure': 2.23, 'bearing_factor_nq': 1.5, 'bearing_capacity_per_unit_area': 43.845, 'cohesion_component': 40.5, 'friction_component': 3.3449999999999998, 'capacity_soil': 45.993404999999996, 'capacity_mechanical': 80.0, 'capacity_ultimate': 45.993404999999996, 'controlling_factor': 'Soil', 'calculation_steps': [{'step': 1, 'description': 'Helix Area Lookup', 'formula': 'Ah = Area of 14" helix', 'calculation': 'Ah = 1.049 sq.ft', 'result': 1.049, 'units': 'sq.ft'}, {'step': 2, 'description': 'Soil Properties at Helix Depth', 'formula': 'At depth = 19.0 ft', 'calculation': 'Soil Type: Sandy Lean Clay\nSPT N-value: 10\nCohesion (c): 4.50 ksf\nFriction Angle (φ): 0.0°', 'result': {'cohesion': 4.5, 'friction_angle': 0}, 'units': 'various'}, {'step': 3, 'description': 'Effective Overburden Pressure', 'formula': 'q = Σ(γ × thickness) for each layer', 'calculation': 'q = 2.230 ksf (at depth 19.0 ft)', 'result': 2.23, 'units': 'ksf'}, {'step': 4, 'description': 'Bearing Capacity Factor (Nq)', 'formula': 'Nq = f(φ = 0.0°)', 'calculation': 'Nq = 1.50 (interpolated from bearing capacity tables)', 'result': 1.5, 'units': 'dimensionless'}, {'step': 5, 'description': 'Bearing Capacity per Unit Area', 'formula': 'qult = Nc×c + q×Nq (where Nc = 9.0 for deep foundations)', 'calculation': 'qult = 9.0×4.50 + 2.230×1.50\nqult = 40.50 + 3.34\nqult = 43.84 ksf', 'result': 43.845, 'units': 'ksf'}, {'step': 6, 'description': 'Total Soil Bearing Capacity', 'formula': 'Qh = Ah × qult', 'calculation': 'Qh = 1.049 × 43.84\nQh = 45.99 kips', 'result': 45.993404999999996, 'units': 'kips'}, {'step': 7, 'description': 'Mechanical Capacity Limit', 'formula': 'Qs = SS175 ultimate capacity × 0.8 (14" helix reduction)', 'calculation': 'Qs = 100.0 × 0.8\nQs = 80.00 kips', 'result': 80.0, 'units': 'kips'}, {'step': 8, 'description': 'Ultimate Capacity (Controlling)', 'formula': 'Qult = min(Qh, Qs)', 'calculation': 'Qult = min(45.99, 80.00)\nQult = 45.99 kips\nControlled by: Soil', 'result': 45.993404999999996, 'units': 'kips'}]}], 'total_ultimate_capacity': 98.340555, 'calculation_method': 'Chance Individual Bearing Method'}, 'installation_specifications': {'torque_correlation_factor': 10, 'min_installation_torque_ftlb': 9834, 'max_torque_rating_ftlb': 10000, 'torque_adequate': True, 'embedment_depth_ft': 19.0, 'termination_criteria': 'Achieve both 19.0 ft depth AND 9,834 ft-lb torque', 'buckling_check': {'min_n_value': 10, 'adequate': True, 'note': 'Adequate (N > 4)'}}}, 'num_passing_designs': 3}}]}