{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Per AASHTO"],"not_rendered":{"charts":0,"images":0,"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":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,5,3,11],[3,12,3,19],[26,1,26,2],[0,5,1,19]]}
[null,"Created by Amin Rahmani, Ph.D., P.E. - February 19, 2018",null,null,null,"Downdrag Calculations per AASHTO LRFD Bridge Design (2012) - Drilled Shafts"]
[null,"Copyright © 2018 Amin Rahmani. All rights reserved."]
[]
[null,null,null,null,null,"Input Parameters",null,null,null,null,null,null,"Calculation Results"]
[null,"Notes:",null,null,null,"Depth (ft)","Liquefiable?","(Su_liq)/sigma'","Cohesive Material- Su (psf)","Cohesionless Material - N60 (blows/ft)","Is the soil gravelly sand or gravel?","Unit Weight (pcf)","Sigma_v' (psf)","alpha","Beta","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,0,"No",115]
[null,"2.This spreadsheet should be used for drilled shafts, only.",null,null,null,{"$f":"F6+1","v":1},"No",null,0,15,"No",115]
[null,"3.The formulations are based on povisions of AASHTO LRFD",null,null,null,{"$f":"F7+1","v":2},"No",null,0,15,"No",115]
[null,"     Bridge Design, 2012 - Section 10.8.",null,null,null,3,"No",null,0,15,"No",115]
[null,"4. Per section 10.8.3.5.2, Beta method is used for cohesionless",null,null,null,4,"No",null,0,15,"Yes",115]
[null,"      material , where N60 is average SPT blow count corrected only for ",null,null,null,5,"No",null,0,15,"Yes",115]
[null,"      hammer efficiency.",null,null,null,6,"No",null,390,0,"No",105]
[null,"5. Put zero values for Su and N60 if not applicable.",null,null,null,7,"No",null,390,0,"No",105]
[null,"6. Units are all Imperial. The macro must be modified for metric units.",null,null,null,8,"No",null,390,0,"No",105]
[null,"7. Do not add any row or column to this spreadsheet.",null,null,null,9,"No",null,390,0,"No",105]
[null,"8. The spreadsheet is formulated up to row No. 6000.",null,null,null,10,"No",null,390,0,"No",105]
[null,null,null,null,null,11,"No",null,850,0,"No",105]
[null,"Input Parameters",null,null,null,12,"No",null,850,0,"No",105]
[null,"Pile Diameter = ",4,"ft",null,13,"No",null,850,0,"No",105]
[null,"Wall thickness",24,"inch","Use D/2 for concrete piles",14,"No",null,850,0,"No",105]
[null,"Elastic Young's Modulus =",4000,"ksf",null,15,"No",null,850,0,"No",110]
[null,"Depth where FF settlement is 0.4\" =",24,"ft",null,16,"No",null,850,0,"No",110]
[null,"Column Depth  =",35,"ft",null,17,"No",null,850,0,"No",110]
[null,"Ground Water Table Depth  =",10,"ft",null,18,"No",null,850,0,"No",110]
[null,null,null,null,null,19,"No",null,850,0,"No",110]
[null,null,null,null,null,20,"No",null,850,0,"No",110]
[null,"Click below to run analysis",null,null,null,21,"Yes",0.1,1100,0,"No",110]
[null,null,null,null,null,22,"Yes",0.1,1100,0,"No",110]
[null,null,null,null,null,23,"Yes",0.1,1100,0,"No",110]
[null,null,null,null,null,24,"Yes",0.1,1100,0,"No",110]
[null,null,null,null,null,25,"Yes",0.1,1100,0,"No",110]
[null,null,null,null,null,26,"No",null,2000,0,"No",110]
[null,null,null,null,null,27,"No",null,2000,0,"No",110]
[null,"Outputs",null,null,null,28,"No",null,2000,0,"No",110]
[null,"Negative Friction (Downdrag) = ",{"$f":"MAX(R6:R6000)","v":0},"kips",null,29,"No",null,2000,0,"No",110]
[null,"Pile Elastic Compression= ",{"$f":"MAX(T6:T6000)","v":0},"inch",null,30,"No",null,2000,0,"No",110]
[null,"Ultimate Positive Friction =",{"$f":"MAX(S6:S6000)","v":0},"kips",null,31,"Yes",0.2,2000,0,"No",110]
[null,"Ultimate End Bearing =",null,"kips",null,32,"Yes",0.2,2000,0,"No",110]
[null,null,null,null,null,33,"Yes",0.2,2000,0,"No",110]
[null,null,null,null,null,34,"Yes",0.2,2000,0,"No",110]
[null,null,null,null,null,35,"Yes",0.2,2000,0,"No",110]
[null,null,null,null,null,36,"No",null,1500,0,"No",120]