{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Per AASHTO"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Per AASHTO","index":0,"n_rows":53,"n_cols":55,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,15,3,20],[0,5,1,20],[3,11,3,14],[30,1,30,2],[28,3,28,4],[3,5,3,10],[29,44,30,51],[3,54,3,64],[24,54,24,64],[51,54,51,64],[3,22,3,33],[3,35,3,42],[2,44,3,51]]}
[null,"Created by Amin Rahmani, Ph.D., P.E. - February 19, 2018",null,null,null,"Downdrag Calculations per AASHTO LRFD Bridge Design (2012) - Driven Piles"]
[null,"Copyright © 2018 Amin Rahmani. All rights reserved."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"delta/phi for cohessionless soils - for calculation of friction"]
[null,null,null,null,null,"Input Soil Parameters",null,null,null,null,null,"Input parameters for friction calculations (see the figures on the right)",null,null,null,"Calculation Results",null,null,null,null,null,null,"Alpha factor for cohesive soils for calculation of friction",null,null,null,null,null,null,null,null,null,null,null,null,"k_delta for cohessionless soils - for calculation of friction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"alpha_t for cohesionless soils - for calculation of end bearing capacity"]
[null,"Notes:",null,null,null,"Depth (ft)","Liquefiable?","(Su_liq)/sigma'","Cohesive soils- Su (psf)","Cohessionless soils - Phi (deg)","Unit Weight (pcf)","Cohesive soils alpha","Cohessionless soils k_delta","Cohessionless soils C_F","Cohessionless soils  delta/phi ","Sigma_v' (psf)","Moblized Friction (psf)","Average Mob. Friction (psf)","Negative Friction, i.e., downdrag (kips)","Positive Friction (kips)","Cumulative Comp. due to downdrag load (inch)"]
[null,"1. Please enter the required inputs shown in blue.",null,null,null,0,"No",null,0,30,115,0,1,1,0.5]
[null,"2.This spreadsheet should be used for driven piles, only.",null,null,null,{"$f":"F6+1","v":1},"No",null,0,30,115,0,1,1,0.5]
[null,"3.The formulations are based on povisions of AASHTO LRFD",null,null,null,{"$f":"F7+1","v":2},"No",null,0,30,115,0,1,1,0.5]
[null,"     Bridge Design, 2012 - Section 10.7.",null,null,null,3,"No",null,0,30,115,0,1,1,0.5]
[null,"4. Determine factors alpha, k_delta, C_F, delta, alpha_T, N'q, and q_L ",null,null,null,4,"No",null,0,30,115,0,1,1,0.5]
[null,"     from the graphs presented in this spreadsheet on the right side of the table",null,null,null,5,"No",null,0,30,115,0,1,1,0.5]
[null,"5. Put zero values for Su and friction angle if not applicable.",null,null,null,6,"No",null,390,0,105,0.55000000000000004]
[null,"6. Units are all Imperial. The macro must be modified for metric units.",null,null,null,7,"No",null,390,0,105,0.55000000000000004]
[null,"7. Do not add/delete any row or column to this spreadsheet.",null,null,null,8,"No",null,390,0,105,0.55000000000000004]
[null,"8. The spreadsheet is formulated up to row No. 6000.",null,null,null,9,"No",null,390,0,105,0.55000000000000004]
[null,null,null,null,null,10,"No",null,390,0,105,0.55000000000000004]
[null,null,null,null,null,11,"No",null,850,0,105,0.55000000000000004]
[null,"Input Parameters",null,null,null,12,"No",null,850,0,105,0.55000000000000004]
[null,"Pile Diameter = ",4,"ft",null,13,"No",null,850,0,105,0.55000000000000004]
[null,"Wall thickness",24,"inch","Use D/2 for concrete piles",14,"No",null,850,0,105,0.55000000000000004]
[null,"Angle of pile taper from vertical",1,"deg","to neglect wall thickness",15,"No",null,850,0,110,0.55000000000000004]
[null,"Elastic Young's Modulus =",4000,"ksf",null,16,"No",null,850,0,110,0.55000000000000004]
[null,"Depth where FF settlement is 0.4\" =",24,"ft",null,17,"No",null,850,0,110,0.55000000000000004]
[null,"Column Depth  =",32,"ft",null,18,"No",null,850,0,110,0.55000000000000004]
[null,"Ground Water Table Depth  =",10,"ft",null,19,"No",null,850,0,110,0.55000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N'q for cohesionless soils - for calculation of end bearing capacity"]
[null,"alpha_t=",0.6,"coefficient for end bearing capacity",null,20,"No",null,850,0,110,0.55000000000000004]
[null,"N'q=",30,"coefficient for end bearing capacity",null,21,"Yes",0.1,1100,0,110,0.55000000000000004]
[null,"q_L=",50,"limiting unit tip resistance",null,22,"Yes",0.1,1100,0,110,0.55000000000000004]
[null,null,null,"*See the figures on the right hand side",null,23,"Yes",0.1,1100,0,110,0.55000000000000004]
[null,null,null,"of the table.",null,24,"Yes",0.1,1100,0,110,0.55000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C_F for cohessionless soils - for calculation of friction"]
[null,"Click below to run analysis",null,null,null,25,"Yes",0.1,1100,0,110,0.55000000000000004]
[null,null,null,null,null,26,"No",null,2000,0,110,0.55000000000000004]
[null,null,null,null,null,27,"No",null,2000,0,110,0.55000000000000004]
[null,null,null,null,null,28,"No",null,2000,0,110,0.55000000000000004]
[null,null,null,null,null,29,"No",null,2000,0,110,0.55000000000000004]
[null,null,null,null,null,30,"No",null,2000,0,110,0.55000000000000004]
[null,null,null,null,null,31,"Yes",0.2,2000,0,110,0.55000000000000004]
[null,null,null,null,null,32,"Yes",0.2,2000,0,110,0.55000000000000004]
[null,"Outputs",null,null,null,33,"Yes",0.2,2000,0,110,0.55000000000000004]
[null,"Negative Friction (Downdrag) = ",{"$f":"MAX(S6:S6000)","v":0},"kips",null,34,"Yes",0.2,2000,0,110,0.55000000000000004]
[null,"Pile Elastic Compression= ",{"$f":"MAX(U6:U6000)","v":0},"inch",null,35,"Yes",0.2,2000,0,110,0.55000000000000004]
[null,"Ultimate Positive Friction =",{"$f":"MAX(T6:T6000)","v":0},"kips",null,36,"No",null,1500,0,120,0.55000000000000004]
[null,"Ultimate End Bearing =",null,"kips",null,{"$f":"F42+1","v":37},"No",null,1500,0,120,0.55000000000000004]
[null,null,null,null,null,{"$f":"F43+1","v":38},"No",null,1500,0,120,0.55000000000000004]
[null,null,null,null,null,39,"No",null,1500,0,120,0.55000000000000004]
[null,null,null,null,null,40,"No",null,1500,0,120,0.55000000000000004]
[null,null,null,null,null,41,"No",null,1500,0,120,0.55000000000000004]
[null,null,null,null,null,42,"No",null,1500,0,120,0.55000000000000004]
[null,null,null,null,null,43,"No",null,1500,0,120,0.55000000000000004]
[null,null,null,null,null,44,"No",null,1500,0,120,0.55000000000000004]
[null,null,null,null,null,45,"No",null,1500,0,120,0.55000000000000004]
[null,null,null,null,null,46,"No",null,1500,0,120,0.55000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"q_L for cohesionless soils - for calculation of end bearing capacity"]
[null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004]