{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Neutral Plane Method","Figures"],"not_rendered":{"charts":2,"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":"Neutral Plane Method","index":0,"n_rows":265,"n_cols":63,"rows_kept":265,"cut":false,"hidden":false,"merged":[[0,8,1,26],[51,62,51,72],[3,43,3,50],[2,52,3,59],[30,1,30,2],[28,3,28,4],[3,8,3,13],[3,5,3,6],[3,30,3,41],[3,18,3,26],[3,14,3,17],[29,52,30,59],[3,62,3,72],[24,62,24,72]]}
[null,"Created by Amin Rahmani, Ph.D., P.E. - February 22, 2018",null,null,null,null,null,null,"Downdrag Calculations Based on Neutral Plane Method - Driven Piles (ultimate pile capacities per AASHTO LRFD Bridge Design)"]
[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,null,null,null,null,null,null,null,null,"delta/phi for cohessionless soils - for calculation of friction"]
[null,null,null,null,null,"Input FF settlement ",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,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)","FreeField Settlement (inch)",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)","Max. Friction t_max (psf)","FreeField Settlement along the pile shaft (inch)","Pile Total Settlement (inch)","t/tmax (per t-z curve)","Total Force on Column (kips)","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,3.94,3.964212309252853,null,0,"No",null,0,30,95,0,1,1,0.5,0,0,3.964212309252853]
[null,"2.This spreadsheet should be used for driven piles, only.",null,null,null,4.0999999999999996,3.964212309252853,null,0.5,"No",null,0,30,95,0,1,1,0.5,47.5,13.094768798021336,3.964212309252853]
[null,"3. The formulations are based Neutral Plane Method.",null,null,null,4.2699999999999996,3.964212309252853,null,1,"No",null,0,30,95,0,1,1,0.5,95,26.189537596042673,3.964212309252853]
[null,"4. Ultimate end bearing and skin friction are calculated per AASHTO LRFD Bridge",null,null,null,4.43,3.964212309252853,null,1.5,"No",null,0,30,95,0,1,1,0.5,142.5,39.284306394064011,3.964212309252853]
[null,"    Design provisions.",null,null,null,4.59,3.964212309252853,null,2,"No",null,0,30,95,0,1,1,0.5,190,52.379075192085345,3.964212309252853]
[null,"5. Determine factors alpha, k_delta, C_F, delta, alpha_T, N'q, and q_L ",null,null,null,4.76,3.964212309252853,null,2.5,"No",null,0,30,95,0,1,1,0.5,237.5,65.473843990106673,3.964212309252853]
[null,"     from the graphs presented in this spreadsheet on the right side of the table",null,null,null,4.92,3.964212309252853,null,3,"No",null,500,0,100,0.55000000000000004,null,null,null,287.5,275,3.964212309252853]
[null,"6. You need to input zero values for Su and N60 in sands and clays, repsectively.",null,null,null,5.09,3.964212309252853,null,3.5,"No",null,500,0,100,0.55000000000000004,null,null,null,337.5,275,3.964212309252853]
[null,"    The code will NOT work properly if you input nonzero values for both parametes in a layer.",null,null,null,5.25,3.964212309252853,null,4,"No",null,500,0,100,0.55000000000000004,null,null,null,387.5,275,3.964212309252853]
[null,"7. nits are all Imperial. The macro must be modified for metric units.",null,null,null,5.41,3.964212309252853,null,4.5,"No",null,500,0,100,0.55000000000000004,null,null,null,437.5,275,3.964212309252853]
[null,"8. Do not add/delete any row or column to this spreadsheet.",null,null,null,5.58,3.964212309252853,null,5,"No",null,500,0,100,0.55000000000000004,null,null,null,487.5,275,3.964212309252853]
[null,"9. The spreadsheet is formulated up to row No. 6000.",null,null,null,5.74,3.964212309252853,null,5.5,"No",null,500,0,100,0.55000000000000004,null,null,null,537.5,275,3.964212309252853]
[null,"Input Parameters",null,null,null,5.91,3.964212309252853,null,6,"No",null,500,0,100,0.55000000000000004,null,null,null,587.5,275,3.964212309252853]
[null,"Pile Diameter = ",2,"ft",null,6.07,3.964212309252853,null,6.5,"No",null,500,0,100,0.55000000000000004,null,null,null,637.5,275,3.964212309252853]
[null,"Wall thickness",0.5,"inch","Use D/2 to simulate full pile",6.23,3.964212309252853,null,7,"No",null,500,0,100,0.55000000000000004,null,null,null,687.5,275,3.964212309252853]
[null,"Angle of pile taper from vertical",1,"deg","cross-section (e.g. concrete pile)",6.4,3.964212309252853,null,7.5,"No",null,500,0,100,0.55000000000000004,null,null,null,737.5,275,3.964212309252853]
[null,"Elastic Young's Modulus =",{"$f":"29000*144","v":4176000},"ksf",null,6.56,3.964212309252853,null,8,"No",null,500,0,100,0.55000000000000004,null,null,null,787.5,275,3.964212309252853]
[null,"Sustained Axial Load at Pile Head =",100,"kips",null,6.73,3.964212309252853,null,8.5,"No",null,500,0,100,0.55000000000000004,null,null,null,837.5,275,3.964212309252853]
[null,"Column Depth  =",52,"ft",null,6.89,3.964212309252853,null,9,"No",null,500,0,100,0.55000000000000004,null,null,null,887.5,275,3.964212309252853]
[null,"Ground Water Table Depth  =",10,"ft",null,7.05,3.964212309252853,null,9.5,"No",null,500,0,100,0.55000000000000004,null,null,null,937.5,275,3.964212309252853,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,7.22,3.964212309252853,null,10,"No",null,500,0,100,0.55000000000000004,null,null,null,987.5,275,3.964212309252853]
[null,"N'q=",30,"coefficient for end bearing capacity",null,7.38,3.964212309252853,null,10.5,"No",null,500,0,100,0.55000000000000004,null,null,null,1006.3,275,3.964212309252853]
[null,"q_L=",50,"limiting unit tip resistance",null,7.55,3.964212309252853,null,11,"No",null,500,0,100,0.55000000000000004,null,null,null,1025.0999999999999,275,3.964212309252853]
[null,null,null,"*See the figures on the right hand side",null,7.71,3.964212309252853,null,11.5,"No",null,500,0,100,0.55000000000000004,null,null,null,1043.8999999999999,275,3.964212309252853]
[null,null,null,"of the table.",null,7.87,3.964212309252853,null,12,"Yes",0.1,0,33,100,0,1,1,0.5,1062.6999999999998,106.26999999999998,3.9338408885287066,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,8.0399999999999991,3.964212309252853,null,12.5,"Yes",0.1,0,33,100,0,1,1,0.5,1081.4999999999998,108.14999999999998,3.8140459480149929]
[null,null,null,null,null,8.1999999999999993,3.964212309252853,null,13,"Yes",0.1,0,33,105,0,1,1,0.5,1102.7999999999997,110.27999999999997,3.8140459480149929]
[null,null,null,null,null,8.3699999999999992,3.964212309252853,null,13.5,"Yes",0.1,0,33,105,0,1,1,0.5,1124.0999999999997,112.40999999999997,3.8140459480149929]
[null,null,null,null,null,8.5299999999999994,3.964212309252853,null,14,"Yes",0.1,0,33,105,0,1,1,0.5,1145.3999999999996,114.53999999999996,3.7860101392374039]
[null,null,null,null,null,8.69,3.964212309252853,null,14.5,"Yes",0.1,0,33,105,0,1,1,0.5,1166.6999999999996,116.66999999999996,3.6003867387135164]
[null,null,null,null,null,8.86,3.964212309252853,null,15,"Yes",0.1,0,33,105,0,1,1,0.5,1187.9999999999995,118.79999999999995,3.3813436356127178]
[null,null,null,null,null,9.02,3.964212309252853,null,15.5,"Yes",0.1,0,33,110,0,1,1,0.5,1211.7999999999995,121.17999999999995,3.2295774273347497]
[null,null,null,null,null,9.19,3.964212309252853,null,16,"Yes",0.1,0,33,110,0,1,1,0.5,1235.5999999999995,123.55999999999995,3.0008752994784382]
[null,"Outputs",null,null,null,9.35,3.964212309252853,null,16.5,"Yes",0.1,0,33,110,0,1,1,0.5,1259.3999999999994,125.93999999999994,2.8158604997465861]
[null,"Negative Friction (Downdrag) = ",{"$f":"MAX(Y6:Y6000)","v":0},"kips",null,9.51,3.964212309252853,null,17,"Yes",0.1,0,33,110,0,1,1,0.5,1283.1999999999994,128.31999999999994,2.6389909597011472]
[null,"Pile Total Settlement (Post-EQ)= ",{"$f":"MAX(V6:V6000)","v":0},"inch",null,9.68,3.964212309252853,null,17.5,"Yes",0.1,0,33,110,0,1,1,0.5,1306.9999999999993,130.69999999999993,2.4924740317916374]
[null,"Depth of Neutral Plane from Plie Head =",20,"ft",null,9.84,3.964212309252853,null,18,"Yes",0.1,0,33,110,0,1,1,0.5,1330.7999999999993,133.07999999999993,2.3840528704384978]
[null,null,null,null,null,10.01,3.964212309252853,null,18.5,"Yes",0.1,0,33,110,0,1,1,0.5,1354.5999999999992,135.45999999999992,2.3411719141494904]
[null,null,null,null,null,10.17,3.964212309252853,null,19,"Yes",0.1,0,33,110,0,1,1,0.5,1378.3999999999992,137.83999999999992,2.2289446550680125]
[null,"Note: In case the analysis fails, please change the input parameters below",null,null,null,10.33,3.964212309252853,null,19.5,"Yes",0.1,0,33,110,0,1,1,0.5,1402.1999999999991,140.21999999999991,2.0885617934021719]
[null,"Difference between computed pile head load and sustained load=",null,10,null,10.5,3.964212309252853,null,20,"Yes",0.1,0,33,110,0,1,1,0.5,1425.9999999999991,142.59999999999991,1.9585188653534367]
[null,"*The load at pile head is calculated iteratively by varying pile toe displacement. The computed load ",null,null,null,10.66,3.964212309252853,null,20.5,"Yes",0.1,0,33,110,0,1,1,0.5,1449.799999999999,144.9799999999999,1.8348153195530754]
[null,"is compared to sustained load and if the difference becomes less than the value in cell \"D46\". Clearly this value should be ",null,null,null,10.83,3.964212309252853,null,21,"Yes",0.1,0,33,110,0,1,1,0.5,1473.599999999999,147.3599999999999,1.603376627665503]
[null,"as low as possible. I believe value of up to 10 kips is acceptable.",null,null,null,10.99,3.964212309252853,null,21.5,"Yes",0.1,0,33,115,0,1,1,0.5,1499.899999999999,149.9899999999999,1.3941135773330231]
[null,null,null,null,null,11.15,3.964212309252853,null,22,"Yes",0.1,0,33,115,0,1,1,0.5,1526.1999999999989,152.61999999999989,1.1464497279647721]
[null,null,null,null,null,11.32,3.964212309252853,null,22.5,"Yes",0.1,0,33,115,0,1,1,0.5,1552.4999999999989,155.24999999999989,0.90835806930021024]
[null,null,null,null,null,11.48,3.964212309252853,null,23,"Yes",0.1,0,33,115,0,1,1,0.5,1578.7999999999988,157.87999999999988,0.74031811022629279,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,11.65,3.964212309252853,null,23.5,"Yes",0.1,0,33,115,0,1,1,0.5,1605.0999999999988,160.50999999999988,0.60450439952711488]
[null,null,null,null,null,11.81,3.964212309252853,null,24,"Yes",0.1,0,33,115,0,1,1,0.5,1631.3999999999987,163.13999999999987,0.4881322782276456]
[null,null,null,null,null,11.98,3.9338408885287066,null,24.5,"Yes",0.1,0,33,115,0,1,1,0.5,1657.6999999999987,165.76999999999987,0.4881322782276456]
[null,null,null,null,null,12.14,3.8754731406750698,null,25,"Yes",0.1,0,33,115,0,1,1,0.5,1683.9999999999986,168.39999999999986,0.4881322782276456]
[null,null,null,null,null,12.47,3.8140459480149929,null,25.5,"Yes",0.1,0,33,115,0,1,1,0.5,1710.2999999999986,171.02999999999986,0.41721754425066626]
[null,null,null,null,null,12.63,3.8140459480149929,null,26,"Yes",0.1,0,33,115,0,1,1,0.5,1736.5999999999985,173.65999999999985,0.35000246415320513]
[null,null,null,null,null,12.8,3.8140459480149929,null,26.5,"Yes",0.1,0,33,115,0,1,1,0.5,1762.8999999999985,176.28999999999985,0.35000246415320513]
[null,null,null,null,null,12.96,3.8140459480149929,null,27,"No",null,1000,0,115,0.55000000000000004,null,null,null,1789.1999999999985,550,0.35000246415320513]
[null,null,null,null,null,13.12,3.8140459480149929,null,27.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,1815.4999999999984,550,0.35000246415320513]
[null,null,null,null,null,13.29,3.8140459480149929,null,28,"No",null,1000,0,115,0.55000000000000004,null,null,null,1841.7999999999984,550,0.35000246415320513]
[null,null,null,null,null,13.45,3.8140459480149929,null,28.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,1868.0999999999983,550,0.35000246415320513]
[null,null,null,null,null,13.62,3.8140459480149929,null,29,"No",null,1000,0,115,0.55000000000000004,null,null,null,1894.3999999999983,550,0.35000246415320513]
[null,null,null,null,null,13.78,3.8140459480149929,null,29.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,1920.6999999999982,550,0.35000246415320513]
[null,null,null,null,null,13.94,3.7860101392374039,null,30,"No",null,1000,0,115,0.55000000000000004,null,null,null,1946.9999999999982,550,0.35000246415320513]
[null,null,null,null,null,14.11,3.7293767288360753,null,30.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,1973.2999999999981,550,0.35000246415320513]
[null,null,null,null,null,14.27,3.6779801588471055,null,31,"No",null,1000,0,115,0.55000000000000004,null,null,null,1999.5999999999981,550,0.35000246415320513]
[null,null,null,null,null,14.44,3.6003867387135164,null,31.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,2025.899999999998,550,0.35000246415320513]
[null,null,null,null,null,14.6,3.5066483017462717,null,32,"No",null,1000,0,115,0.55000000000000004,null,null,null,2052.199999999998,550,0.35000246415320513]
[null,null,null,null,null,14.76,3.4336632423758053,null,32.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,2078.4999999999982,550,0.35000246415320513]
[null,null,null,null,null,14.93,3.3813436356127178,null,33,"No",null,1000,0,115,0.55000000000000004,null,null,null,2104.7999999999984,550,0.35000246415320513]
[null,null,null,null,null,15.09,3.3351412801646405,null,33.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,2131.0999999999985,550,0.35000246415320513]
[null,null,null,null,null,15.26,3.2837271343980161,null,34,"No",null,1000,0,115,0.55000000000000004,null,null,null,2157.3999999999987,550,0.35000246415320513]
[null,null,null,null,null,15.42,3.2295774273347497,null,34.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,2183.6999999999989,550,0.35000246415320513]
[null,null,null,null,null,15.58,3.1407607408092724,null,35,"No",null,1000,0,115,0.55000000000000004,null,null,null,2209.9999999999991,550,0.35000246415320513]
[null,null,null,null,null,15.75,3.050033679797433,null,35.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,2236.2999999999993,550,0.35000246415320513]
[null,null,null,null,null,15.91,3.0008752994784382,null,36,"No",null,1000,0,115,0.55000000000000004,null,null,null,2262.5999999999995,550,0.35000246415320513]
[null,null,null,null,null,16.079999999999998,2.9302189456635452,null,36.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,2288.8999999999996,550,0.35000246415320513]
[null,null,null,null,null,16.239999999999998,2.8665055979761975,null,37,"No",null,1000,0,115,0.55000000000000004,null,null,null,2315.1999999999998,550,0.35000246415320513]
[null,null,null,null,null,16.399999999999999,2.8158604997465861,null,37.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,2341.5,550,0.35000246415320513]
[null,null,null,null,null,16.57,2.7534013462788751,null,38,"No",null,1000,0,115,0.55000000000000004,null,null,null,2367.8000000000002,550,0.35000246415320513]
[null,null,null,null,null,16.73,2.698400923431536,null,38.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,2394.1000000000004,550,0.35000246415320513]
[null,null,null,null,null,16.899999999999999,2.6389909597011472,null,39,"No",null,1000,0,115,0.55000000000000004,null,null,null,2420.4000000000005,550,0.35000246415320513]
[null,null,null,null,null,17.059999999999999,2.5887273831407271,null,39.5,"No",null,1000,0,115,0.55000000000000004,null,null,null,2446.7000000000007,550,0.31332639585532762]
[null,null,null,null,null,17.22,2.5438671432305808,null,40,"Yes",0.1,0,35,115,0,1,1,0.5,2473.0000000000009,247.3000000000001,0.25283375762707383]
[null,null,null,null,null,17.39,2.4924740317916374,null,40.5,"Yes",0.1,0,35,115,0,1,1,0.5,2499.3000000000011,249.93000000000012,0.20849548330497258]
[null,null,null,null,null,17.55,2.4452348762002849,null,41,"Yes",0.1,0,35,115,0,1,1,0.5,2525.6000000000013,252.56000000000014,0.16396685184860704]
[null,null,null,null,null,17.72,2.4093851422091044,null,41.5,"Yes",0.1,0,35,115,0,1,1,0.5,2551.9000000000015,255.19000000000017,0.13381638642612304]
[null,null,null,null,null,17.88,2.3840528704384978,null,42,"Yes",0.1,0,35,115,0,1,1,0.5,2578.2000000000016,257.82000000000016,9.1794697134135461E-2]
[null,null,null,null,null,18.04,2.3690084004801495,null,42.5,"Yes",0.1,0,35,115,0,1,1,0.5,2604.5000000000018,260.45000000000022,9.1794697134135461E-2]
[null,null,null,null,null,18.21,2.3623953432855682,null,43,"Yes",0.1,0,35,115,0,1,1,0.5,2630.800000000002,263.08000000000021,8.2437889567817724E-2]
[null,null,null,null,null,18.37,2.3411719141494904,null,43.5,"Yes",0.1,0,35,115,0,1,1,0.5,2657.1000000000022,265.71000000000021,7.363148244657669E-2]
[null,null,null,null,null,18.54,2.3073713192087713,null,44,"Yes",0.1,0,35,115,0,1,1,0.5,2683.4000000000024,268.34000000000026,7.363148244657669E-2]
[null,null,null,null,null,18.7,2.2695220670523315,null,44.5,"Yes",0.1,0,35,115,0,1,1,0.5,2709.7000000000025,270.97000000000025,7.363148244657669E-2]
[null,null,null,null,null,18.86,2.2289446550680125,null,45,"Yes",0.1,0,35,115,0,1,1,0.5,2736.0000000000027,273.60000000000031,6.5558699594995939E-2]
[null,null,null,null,null,19.03,2.1837360445724148,null,45.5,"No",null,0,40,120,0,1,1,0.5,2764.8000000000029,990.96663592135269,2.129280032403269E-2]
[null,null,null,null,null,19.190000000000001,2.1375623772807475,null,46,"No",null,0,40,120,0,1,1,0.5,2793.6000000000031,1001.2892050455335,0]
[null,null,null,null,null,19.36,2.0885617934021719,null,46.5,"No",null,0,40,120,0,1,1,0.5,2822.4000000000033,1011.6117741697144,0]
[null,null,null,null,null,19.52,2.0433574322111836,null,47,"No",null,0,40,120,0,1,1,0.5,2851.2000000000035,1021.9343432938952,0]
[null,null,null,null,null,19.690000000000001,1.9972082684475299,null,47.5,"No",null,0,40,120,0,1,1,0.5,2880.0000000000036,1032.2569124180759,0]
[null,null,null,null,null,19.850000000000001,1.9585188653534367,null,48,"No",null,0,40,120,0,1,1,0.5,2908.8000000000038,1042.5794815422566,0]
[null,null,null,null,null,20.010000000000002,1.9207794825198161,null,48.5,"No",null,0,40,120,0,1,1,0.5,2937.600000000004,1052.9020506664376,0]
[null,null,null,null,null,20.18,1.8774093823294171,null,49,"No",null,0,40,120,0,1,1,0.5,2966.4000000000042,1063.2246197906184,0]
[null,null,null,null,null,20.34,1.8348153195530754,null,49.5,"No",null,0,40,120,0,1,1,0.5,2995.2000000000044,1073.5471889147991,0]
[null,null,null,null,null,20.51,1.7850823040057167,null,50,"No",null,0,40,120,0,1,1,0.5,3024.0000000000045,1083.8697580389799,0]
[null,null,null,null,null,20.67,1.7312981617184664,null,50.5,"No",null,0,40,120,0,1,1,0.5,3052.8000000000047,1094.1923271631608,0]
[null,null,null,null,null,20.83,1.6719821066339584,null,51,"No",null,0,40,120,0,1,1,0.5,3081.6000000000049,1104.5148962873416,0]
[null,null,null,null,null,21,1.603376627665503,null,51.5,"No",null,0,40,120,0,1,1,0.5,3110.4000000000051,1114.8374654115223,0]
[null,null,null,null,null,21.16,1.5318598669141528,null,52,"No",null,0,40,120,0,1,1,0.5,3139.2000000000053,1125.1600345357033,0]
[null,null,null,null,null,21.33,1.4682073777529179,null,52.5,"No",null,0,40,120,0,1,1,0.5,3168.0000000000055,1135.482603659884,0]
[null,null,null,null,null,21.49,1.3941135773330231]
[null,null,null,null,null,21.65,1.2824055679410504]
[null,null,null,null,null,21.82,1.1935748368426378]
[null,null,null,null,null,21.98,1.1464497279647721]
[null,null,null,null,null,22.15,1.0647557494555482]
[null,null,null,null,null,22.31,0.98774318140828976]
[null,null,null,null,null,22.47,0.90835806930021024]
[null,null,null,null,null,22.64,0.82597022425537237]
[null,null,null,null,null,22.8,0.78331554364892453]
[null,null,null,null,null,22.97,0.74031811022629279]
[null,null,null,null,null,23.13,0.69767460387935909]
[null,null,null,null,null,23.29,0.6528148182404947]
[null,null,null,null,null,23.46,0.60450439952711488]
[null,null,null,null,null,23.62,0.55794307983080849]
[null,null,null,null,null,23.79,0.51004556173106641]
[null,null,null,null,null,23.95,0.4881322782276456]
[null,null,null,null,null,24.11,0.4881322782276456]
[null,null,null,null,null,24.28,0.4881322782276456]
[null,null,null,null,null,24.44,0.4881322782276456]
[null,null,null,null,null,24.61,0.4881322782276456]
[null,null,null,null,null,24.77,0.4881322782276456]
[null,null,null,null,null,24.93,0.4881322782276456]
[null,null,null,null,null,25.1,0.47169446477409327]
[null,null,null,null,null,25.26,0.44341888148396436]
[null,null,null,null,null,25.43,0.41721754425066626]
[null,null,null,null,null,25.59,0.39332558131109385]
[null,null,null,null,null,25.75,0.36611977072195634]
[null,null,null,null,null,25.92,0.35000246415320513]
[null,null,null,null,null,26.08,0.35000246415320513]
[null,null,null,null,null,26.25,0.35000246415320513]
[null,null,null,null,null,26.41,0.35000246415320513]
[null,null,null,null,null,26.57,0.35000246415320513]
[null,null,null,null,null,26.74,0.35000246415320513]
[null,null,null,null,null,26.9,0.35000246415320513]
[null,null,null,null,null,27.07,0.35000246415320513]
[null,null,null,null,null,27.23,0.35000246415320513]
[null,null,null,null,null,27.4,0.35000246415320513]
[null,null,null,null,null,27.56,0.35000246415320513]
[null,null,null,null,null,27.72,0.35000246415320513]
[null,null,null,null,null,27.89,0.35000246415320513]
[null,null,null,null,null,28.05,0.35000246415320513]
[null,null,null,null,null,28.22,0.35000246415320513]
[null,null,null,null,null,28.38,0.35000246415320513]
[null,null,null,null,null,28.54,0.35000246415320513]
[null,null,null,null,null,28.71,0.35000246415320513]
[null,null,null,null,null,28.87,0.35000246415320513]
[null,null,null,null,null,29.04,0.35000246415320513]
[null,null,null,null,null,29.2,0.35000246415320513]
[null,null,null,null,null,29.36,0.35000246415320513]
[null,null,null,null,null,29.53,0.35000246415320513]
[null,null,null,null,null,29.69,0.35000246415320513]
[null,null,null,null,null,29.86,0.35000246415320513]
[null,null,null,null,null,30.02,0.35000246415320513]
[null,null,null,null,null,30.18,0.35000246415320513]
[null,null,null,null,null,30.35,0.35000246415320513]
[null,null,null,null,null,30.51,0.35000246415320513]
[null,null,null,null,null,30.68,0.35000246415320513]
[null,null,null,null,null,30.84,0.35000246415320513]
[null,null,null,null,null,31,0.35000246415320513]
[null,null,null,null,null,31.17,0.35000246415320513]
[null,null,null,null,null,31.33,0.35000246415320513]
[null,null,null,null,null,31.5,0.35000246415320513]
[null,null,null,null,null,31.66,0.35000246415320513]
[null,null,null,null,null,31.82,0.35000246415320513]
[null,null,null,null,null,31.99,0.35000246415320513]
[null,null,null,null,null,32.15,0.35000246415320513]
[null,null,null,null,null,32.32,0.35000246415320513]
[null,null,null,null,null,32.479999999999997,0.35000246415320513]
[null,null,null,null,null,32.64,0.35000246415320513]
[null,null,null,null,null,32.81,0.35000246415320513]
[null,null,null,null,null,32.97,0.35000246415320513]
[null,null,null,null,null,33.14,0.35000246415320513]
[null,null,null,null,null,33.299999999999997,0.35000246415320513]
[null,null,null,null,null,33.46,0.35000246415320513]
[null,null,null,null,null,33.630000000000003,0.35000246415320513]
[null,null,null,null,null,33.79,0.35000246415320513]
[null,null,null,null,null,33.96,0.35000246415320513]
[null,null,null,null,null,34.119999999999997,0.35000246415320513]
[null,null,null,null,null,34.28,0.35000246415320513]
[null,null,null,null,null,34.450000000000003,0.35000246415320513]
[null,null,null,null,null,34.61,0.35000246415320513]
[null,null,null,null,null,34.78,0.35000246415320513]
[null,null,null,null,null,34.94,0.35000246415320513]
[null,null,null,null,null,35.1,0.35000246415320513]
[null,null,null,null,null,35.270000000000003,0.35000246415320513]
[null,null,null,null,null,35.43,0.35000246415320513]
[null,null,null,null,null,35.6,0.35000246415320513]
[null,null,null,null,null,35.76,0.35000246415320513]
[null,null,null,null,null,35.93,0.35000246415320513]
[null,null,null,null,null,36.090000000000003,0.35000246415320513]
[null,null,null,null,null,36.25,0.35000246415320513]
[null,null,null,null,null,36.42,0.35000246415320513]
[null,null,null,null,null,36.58,0.35000246415320513]
[null,null,null,null,null,36.75,0.35000246415320513]
[null,null,null,null,null,36.909999999999997,0.35000246415320513]
[null,null,null,null,null,37.07,0.35000246415320513]
[null,null,null,null,null,37.24,0.35000246415320513]
[null,null,null,null,null,37.4,0.35000246415320513]
[null,null,null,null,null,37.57,0.35000246415320513]
[null,null,null,null,null,37.729999999999997,0.35000246415320513]
[null,null,null,null,null,37.89,0.35000246415320513]
[null,null,null,null,null,38.06,0.35000246415320513]
[null,null,null,null,null,38.22,0.35000246415320513]
[null,null,null,null,null,38.39,0.35000246415320513]
[null,null,null,null,null,38.549999999999997,0.35000246415320513]
[null,null,null,null,null,38.71,0.35000246415320513]
[null,null,null,null,null,38.880000000000003,0.35000246415320513]
[null,null,null,null,null,39.04,0.33745013943903368]
[null,null,null,null,null,39.21,0.32411329443022607]
[null,null,null,null,null,39.369999999999997,0.31332639585532762]
[null,null,null,null,null,39.53,0.29207111303157252]
[null,null,null,null,null,39.700000000000003,0.27073065496466553]
[null,null,null,null,null,39.86,0.25283375762707383]
[null,null,null,null,null,40.03,0.23645713371432731]
[null,null,null,null,null,40.19,0.22253031541016721]
[null,null,null,null,null,40.35,0.20849548330497258]
[null,null,null,null,null,40.520000000000003,0.19217896784388833]
[null,null,null,null,null,40.68,0.17431962408693602]
[null,null,null,null,null,40.85,0.16396685184860704]
[null,null,null,null,null,41.01,0.16396685184860704]
[null,null,null,null,null,41.17,0.15345961081661397]
[null,null,null,null,null,41.34,0.14229566722012121]
[null,null,null,null,null,41.5,0.13381638642612304]
[null,null,null,null,null,41.67,0.11633743036812438]
[null,null,null,null,null,41.83,0.10008031306201248]
[null,null,null,null,null,41.99,9.1794697134135461E-2]
[null,null,null,null,null,42.16,9.1794697134135461E-2]
[null,null,null,null,null,42.32,9.1794697134135461E-2]
[null,null,null,null,null,42.49,9.1794697134135461E-2]
[null,null,null,null,null,42.65,9.1794697134135461E-2]
[null,null,null,null,null,42.81,9.1794697134135461E-2]
[null,null,null,null,null,42.98,8.2437889567817724E-2]
[null,null,null,null,null,43.14,7.363148244657669E-2]
[null,null,null,null,null,43.31,7.363148244657669E-2]
[null,null,null,null,null,43.47,7.363148244657669E-2]
[null,null,null,null,null,43.64,7.363148244657669E-2]
[null,null,null,null,null,43.8,7.363148244657669E-2]
[null,null,null,null,null,43.96,7.363148244657669E-2]
[null,null,null,null,null,44.13,7.363148244657669E-2]
[null,null,null,null,null,44.29,7.363148244657669E-2]
[null,null,null,null,null,44.46,7.363148244657669E-2]
[null,null,null,null,null,44.62,7.363148244657669E-2]
[null,null,null,null,null,44.78,7.363148244657669E-2]
[null,null,null,null,null,44.95,6.5558699594995939E-2]
[null,null,null,null,null,45.11,5.0624366341880833E-2]
[null,null,null,null,null,45.28,3.5320459413787031E-2]
[null,null,null,null,null,45.44,2.129280032403269E-2]
[null,null,null,null,null,45.6,7.3833567319558924E-3]
[null,null,null,null,null,45.77,0]
[null,null,null,null,null,45.93,0]
[null,null,null,null,null,46.1,0]
[null,null,null,null,null,46.26,0]
[null,null,null,null,null,46.42,0]
[null,null,null,null,null,46.59,0]

{"sheet":"Figures","index":1,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,1,0,15]]}
[null,"Downdrag Analysis Results Using Neutral Plane Method"]