{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["~#temp","Calc Sheet (1)","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":61,"macros":0,"external_links":1,"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":"~#temp","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Calc Sheet (1)","index":1,"n_rows":186,"n_cols":11,"rows_kept":186,"cut":false,"hidden":false,"merged":[[168,2,168,8]]}
[]
[]
[null,null,"Design Loads"]
[null,null,null,null,null,"(All loads acting at U/S of base plate)"]
[null,null,"T#=",0.33,"kN","ULS tension"]
[null,null,"N#=",22.92,"kN","ULS compression"]
[null,null,"H#=",16.03,"kN","ULS lateral load (shear)"]
[null,null,"M#=",23.15,"kNm","ULS bending moment"]
[]
[]
[null,null,"Pier Geometry"]
[]
[null,null,"D =",450,"mm","Diameter fo pile"]
[null,null,"Lp =",2,"m","Length of pile"]
[null,null,"ebp =",1,"m","Projection of pier above ground"]
[]
[]
[null,null,"Concrete Properties"]
[]
[null,null,"cover=",75,"mm","Cover to shear ligs"]
[null,null,"ds =",6,"mm","Shear lig diameter"]
[null,null,"db =",20,"mm","Bending reo diamter"]
[null,null,"nbars =",8,null,"# bending bars"]
[null,null,"f'c=",40,"MPa","Concrete strength"]
[null,null,"εc =",3.0000000000000001E-3,null,"Concrete strain"]
[null,null,"fsy =",500,"MPa","Steel yield strength"]
[null,null,"Es =",200000,"MPa","Young's Mod. Steel"]
[null,null,"εs =",2.5000000000000001E-2,null,"Steel strain"]
[null,null,"γc =",24,"kN/m³","Concrete unit weight"]
[]
[]
[]
[]
[]
[]
[null,null,"Soil Propoerties"]
[]
[null,null,"cu =",75,"kPa"]
[null,null,"qu =",0,"kPa"]
[null,null,"αcu =",0.7]
[null,null,"ϕg =",0.6]
[]
[]
[null,null,"Concrete Bending Capacity"]
[]
["Dist. Between bars",null,"d =",{"$f":"D13-2*D20-2*D21-D22","v":268},{"$f":"[1]!EQS(D46,\"Units= mm; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 0; EqnStyle= 1; Eqp$E$46_0\")","v":""}]
[]
[null,null,null,null,null,null,{"$f":"[1]!EQS(D46,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 1; EqnStyle= 1; Eqp$G$48_0\")","v":""}]
[]
["From C&CCA HB71",null,"gratio =",{"$f":"D46/D13","v":0.5955555555555555},{"$f":"[1]!EQS(D50,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$50_0\")","v":""},null,{"$f":"[1]!EQS(D50,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 1; EqnStyle= 1; Eqp$G$50_0\")","v":""}]
[]
["Area of rebar",null,"Ab =",{"$f":"[1]!OVD(PI())/[1]!UND(4)*D22^2","v":314.15926535897933},{"$f":"[1]!EQS(D52,\"Units= mm2; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$52_0\")","v":""},null,{"$f":"[1]!EQS(D52,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$52_0\")","v":""}]
[]
["Total steel area",null,"As =",{"$f":"D23*D52","v":2513.2741228718346},{"$f":"[1]!EQS(D54,\"Units= mm2; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$54_0\")","v":""},null,{"$f":"[1]!EQS(D54,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$54_0\")","v":""}]
[]
["Gross X-section area",null,"Ag =",{"$f":"[1]!OVD(PI())/[1]!UND(4)*D13^2","v":159043.12808798326},{"$f":"[1]!EQS(D56,\"Units= mm2; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$56_0\")","v":""},null,{"$f":"[1]!EQS(D56,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$56_0\")","v":""}]
[]
["Steel ratio",null,"pratio =",{"$f":"D54/D56","v":1.580246913580247E-2},{"$f":"[1]!EQS(D58,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$58_0\")","v":""},null,{"$f":"[1]!EQS(D58,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$58_0\")","v":""}]
[]
[]
[null,null,"Calculate values for rectangular stress block design model:"]
[null,null,"(refer AS 3600, Clause 8.1.3)"]
[]
[null,null,"α2 =",{"$f":"1-0.003*D24","v":0.88},{"$f":"[1]!EQS(D64,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$64_0\")","v":""},null,{"$f":"[1]!EQS(D64,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$64_0\")","v":""}]
[null,null,"Check:","0.67≤α2≤0.85"]
[null,null,"α2 =",{"$f":"MAX(0.67,MIN(D64,0.85))","v":0.85},{"$f":"[1]!EQS(D66,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$66_0\")","v":""}]
[]
[null,null,"γ2 =",{"$f":"1.05-0.007*D24","v":0.77},{"$f":"[1]!EQS(D68,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$68_0\")","v":""},null,{"$f":"[1]!EQS(D68,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$68_0\")","v":""}]
[null,null,"Check:","0.67≤α2≤0.85"]
[null,null,"γ2 =",{"$f":"MAX(0.67,MIN(D68,0.85))","v":0.77},{"$f":"[1]!EQS(D70,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$70_0\")","v":""}]
[]
[]
[]
[]
[null,null,"Muo =",166.9,"kNm"]
[null,null,"ϕbending =",0.8]
[null,null,"ϕMuo=",{"$f":"D76*D75","v":133.52000000000001}]
[]
[]
[]
[null,"Geotechnical Strength "]
[null,null,"Vertical Load (compression)"]
[]
[null,null,"N#=",{"$f":"D6","v":22.92},{"$f":"[1]!EQS(D84,\"Units= kN; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$84_0\")","v":""},null,"(defined previusly)"]
[]
[null,null,"LP.eff =",{"$f":"D14-1.5*[1]!OVD(D13)/[1]!UND(1000)","v":1.325},{"$f":"[1]!EQS(D86,\"Units= m; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$86_0\")","v":""},null,{"$f":"[1]!EQS(D86,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$86_0\")","v":""}]
[]
[null,null,"fs =",{"$f":"D40*D38","v":52.5},{"$f":"[1]!EQS(D88,\"Units= kPa; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$88_0\")","v":""},null,{"$f":"[1]!EQS(D88,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$88_0\")","v":""}]
[]
[null,null,"fb =",{"$f":"D39","v":0},{"$f":"[1]!EQS(D90,\"Units= kPa; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$90_0\")","v":""},null,"(ULS base bearing)"]
[]
[null,null,"Aps =",{"$f":"PI()*[1]!OVD(D13)/[1]!UND(1000)*D86","v":1.873174619702914},{"$f":"[1]!EQS(D92,\"Units= m2; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$92_0\")","v":""},null,{"$f":"[1]!EQS(D92,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$92_0\")","v":""}]
[]
[null,null,"Apb =",{"$f":"D56*10^-6","v":0.15904312808798327},{"$f":"[1]!EQS(D94,\"Units= m2; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$94_0\")","v":""},null,"(base area)"]
[]
[null,null,"Rug.c =",{"$f":"D90*D94+D88*D92","v":98.341667534402987},{"$f":"[1]!EQS(D96,\"Units= kN; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$96_0\")","v":""},null,{"$f":"[1]!EQS(D96,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$96_0\")","v":""}]
[]
[null,null,"ϕg =",0.6,null,null,"Geotech strength reduction fact."]
[]
[null,null,"ϕRug.c=",{"$f":"D98*D96","v":59.005000520641786},{"$f":"[1]!EQS(D100,\"Units= kN; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$100_0\")","v":""},null,{"$f":"[1]!EQS(D100,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$100_0\")","v":""}]
[]
[null,null,"LFcomp=",{"$f":"[1]!OVD(D100)/[1]!UND(D6)","v":2.574389202471282},{"$f":"[1]!EQS(D102,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$102_0\")","v":""},null,{"$f":"[1]!EQS(D102,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$102_0\")","v":""}]
[]
[null,null,"Checkcomp=",{"$f":"IF(D102>1,\"Pass\",\"Fail\")","v":"Pass"}]
[null,null,"Vertical Load (tension)"]
[]
[null,null,"T#=",{"$f":"D5","v":0.33},{"$f":"[1]!EQS(D107,\"Units= kN; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$107_0\")","v":""},null,"(defined previusly)"]
[]
[null,null,"Wp =",{"$f":"(D15+D14)*D29*D56*10^-6","v":11.451105222334794},{"$f":"[1]!EQS(D109,\"Units= kN; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$109_0\")","v":""}]
[null,null,null,null,null,null,{"$f":"[1]!EQS(D109,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$110_0\")","v":""}]
[]
[null,null,"Rug.t=",{"$f":"D109+D88*D92","v":109.79277275673778},{"$f":"[1]!EQS(D112,\"Units= kN; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$112_0\")","v":""},null,{"$f":"[1]!EQS(D112,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$112_0\")","v":""}]
[]
[null,null,"ϕRug.t=",{"$f":"D98*D112","v":65.875663654042668},{"$f":"[1]!EQS(D114,\"Units= kN; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$114_0\")","v":""},null,{"$f":"[1]!EQS(D114,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$114_0\")","v":""}]
[]
[null,null,"LFtens=",{"$f":"[1]!OVD(D114)/[1]!UND(D107)","v":199.62322319406869},{"$f":"[1]!EQS(D116,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$116_0\")","v":""},null,{"$f":"[1]!EQS(D116,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$116_0\")","v":""}]
[]
[null,null,"Checktens=",{"$f":"IF(D116>1,\"Pass\",\"Fail\")","v":"Pass"}]
[]
[]
[]
[null,null,"Lateral Load / Moment"]
[]
[null,null,"ep =",{"$f":"D15+D8/D7","v":2.4441671865252648},{"$f":"[1]!EQS(D124,\"Units= m; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$124_0\")","v":""}]
[]
[null,null,"D =",{"$f":"D13/1000","v":0.45},{"$f":"[1]!EQS(D126,\"Units= m; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$126_0\")","v":""},null,null,null,null,null,"FROM MATHCAD:"]
[]
[null,null,"λL =",{"$f":"9*(-([1]!OVD(D124)/[1]!UND(D126)+1.5)+\nSQRT(([1]!OVD(D124)/[1]!UND(D126)+1.5)^2  +\n[1]!OVD(2*D75)/[1]!UND(9*D38*D126^3)))","v":3.4289164605812914},{"$f":"[1]!EQS(D128,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$128_0\")","v":""}]
[]
[]
[]
[null,null,null,{"$f":"[1]!EQS(D128,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$D$132_0\")","v":""}]
[]
[]
[]
[]
[]
[null,null,"ap =",0.5]
[]
[null,null,"bp =",{"$f":"9*([1]!OVD(D14)/[1]!UND(D126)-1.5)+18*([1]!OVD(D124)/[1]!UND(D126)+1.5)","v":151.26668746101058},{"$f":"[1]!EQS(D140,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$140_0\")","v":""}]
[]
[null,null,null,null,{"$f":"[1]!EQS(D140,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$E$142_0\")","v":""}]
[]
[null,null,"cp =",{"$f":"-0.5*(9*([1]!OVD(D14)/[1]!UND(D126)-1.5))^2","v":-351.125},{"$f":"[1]!EQS(D144,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$144_0\")","v":""}]
[]
[null,null,null,null,{"$f":"[1]!EQS(D144,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$E$146_0\")","v":""}]
[]
[null,null,"λS =",{"$f":"[1]!OVD(-D140+SQRT(D140^2-4*D138*D144))/[1]!UND(2*D138)","v":2.303689680634335},{"$f":"[1]!EQS(D148,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$148_0\")","v":""}]
[]
[null,null,null,null,{"$f":"[1]!EQS(D148,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$E$150_0\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The strength reduction factor for a short pier will be based on the strength reduction factor provided by the user at the start of the calculation, however the strength reduction factor for a long pier will be taken as 0.75 since the capacity is largely governed by bending of the pier (Woolcock et al, 2003, Chapter 7.4.1)."]
[]
[]
[null,null,"ϕS =",{"$f":"D41","v":0.6},{"$f":"[1]!EQS(D172,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$172_0\")","v":""},null,"(defined previusly)"]
[]
[null,null,"ϕL =",0.75]
[]
[null,null,"ϕHS=",{"$f":"D172*D148*D38*D126^2","v":20.992372214780378},{"$f":"[1]!EQS(D176,\"Units= kN; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$176_0\")","v":""},null,{"$f":"[1]!EQS(D176,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$176_0\")","v":""}]
[]
[null,null,"ϕHL=",{"$f":"D174*D128*D38*D126^2","v":39.057501558808774},{"$f":"[1]!EQS(D178,\"Units= kN; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$178_0\")","v":""},null,{"$f":"[1]!EQS(D178,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 1; ShowWorking= 1; EqnStyle= 1; Eqp$G$178_0\")","v":""}]
[]
[null,null,"piertype=",{"$f":"IF(D176<D178,\"Short\",\"Long\")","v":"Short"},{"$f":"[1]!EQS(D180,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$180_0\")","v":""}]
[]
[null,null,"ϕHug=",{"$f":"MIN(D176,D178)","v":20.992372214780378},{"$f":"[1]!EQS(D182,\"Units= kN; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$182_0\")","v":""}]
[]
[null,null,"LFlat=",{"$f":"[1]!OVD(D182)/[1]!UND(D7)","v":1.3095678237542343},{"$f":"[1]!EQS(D184,\"Units= ; EqnPrefix=Eqn. ; EqnNo= 35; Multiplication= 0; ShowWorking= 0; EqnStyle= 1; Eqp$E$184_0\")","v":""}]
[]
[null,null,"Checklat=",{"$f":"IF(D184>1,\"Pass\",\"Fail\")","v":"Pass"}]

{"sheet":"Sheet2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}