{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Neutral Plane Method","Figures"],"not_rendered":{"charts":2,"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":"Neutral Plane Method","index":0,"n_rows":316,"n_cols":26,"rows_kept":316,"cut":false,"hidden":false,"merged":[[3,8,3,14],[3,15,3,25],[26,1,26,2],[0,8,1,25],[3,5,3,6]]}
[null,"Created by Amin Rahmani, Ph.D., P.E. - February 22, 2018 (last updated March 09, 2018)",null,null,null,null,null,null,"Downdrag Calculations Based on Neutral Plane Method - Drilled Shafts (ultimate pile capacities per AASHTO LRFD Bridge Design)"]
[null,"Copyright © 2018 Amin Rahmani. All rights reserved."]
[]
[null,null,null,null,null,"Input FF settlement ",null,null,"Input Parameters",null,null,null,null,null,null,"Calculation Results"]
[null,"Notes:",null,null,null,"Depth (ft)","FreeField Settlement (inch)",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","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,0,"No",95]
[null,"2. This spreadsheet should be used for drilled shafts, only.",null,null,null,4.0999999999999996,3.964212309252853,null,0.5,"No",null,0,15,"No",95]
[null,"3. The formulations are based Neutral Plane Method.",null,null,null,4.2699999999999996,3.964212309252853,null,1,"No",null,0,15,"No",95]
[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,15,"No",95]
[null,"    Design provisions.",null,null,null,4.59,3.964212309252853,null,2,"No",null,0,15,"No",95]
[null,"5. N60 is average SPT blow count corrected only for hammer efficiency. ",null,null,null,4.76,3.964212309252853,null,2.5,"No",null,0,15,"No",95]
[null,"6. You need to input zero values for Su and N60 in sands and clays, repsectively.",null,null,null,4.92,3.964212309252853,null,3,"No",null,500,0,"No",100]
[null,"    The code will NOT work properly if you input nonzero values for both parametes in a layer.",null,null,null,5.09,3.964212309252853,null,3.5,"No",null,500,0,"No",100]
[null,"7. Units are all Imperial. The macro must be modified for metric units.",null,null,null,5.25,3.964212309252853,null,4,"No",null,500,0,"No",100]
[null,"8. Do not add any row or column to this spreadsheet.",null,null,null,5.41,3.964212309252853,null,4.5,"No",null,500,0,"No",100]
[null,"9. The spreadsheet is formulated up to row No. 6000.",null,null,null,5.58,3.964212309252853,null,5,"No",null,500,0,"No",100]
[null,"10. The code will stop iteration when load difference at pile head is less than the value in cell \"D41\".",null,null,null,5.74,3.964212309252853,null,5.5,"No",null,500,0,"No",100]
[null,"Input Parameters",null,null,null,5.91,3.964212309252853,null,6,"No",null,500,0,"No",100]
[null,"Pile Diameter (D) = ",2,"ft",null,6.07,3.964212309252853,null,6.5,"No",null,500,0,"No",100]
[null,"Wall thickness",12,"inch","Use D/2 to simulate full pile",6.23,3.964212309252853,null,7,"No",null,500,0,"No",100]
[null,"Elastic Young's Modulus =",{"$f":"57000*SQRT(4000)*144/1000","v":519119.50069324119},"ksf","cross-section (e.g. concrete pile)",6.4,3.964212309252853,null,7.5,"No",null,500,0,"No",100]
[null,"Sustained Axial Load at Pile Head =",150,"kips",null,6.56,3.964212309252853,null,8,"No",null,500,0,"No",100]
[null,"Column Depth  =",48,"ft",null,6.73,3.964212309252853,null,8.5,"No",null,500,0,"No",100]
[null,"Ground Water Table Depth  =",10,"ft",null,6.89,3.964212309252853,null,9,"No",null,500,0,"No",100]
[null,null,null,null,null,7.05,3.964212309252853,null,9.5,"No",null,500,0,"No",100]
[null,null,null,null,null,7.22,3.964212309252853,null,10,"No",null,500,0,"No",100]
[null,"Click below to run analysis",null,null,null,7.38,3.964212309252853,null,10.5,"No",null,500,0,"No",100]
[null,null,null,null,null,7.55,3.964212309252853,null,11,"No",null,500,0,"No",100]
[null,null,null,null,null,7.71,3.964212309252853,null,11.5,"No",null,500,0,"No",100]
[null,null,null,null,null,7.87,3.964212309252853,null,12,"Yes",0.1,0,15,"No",100]
[null,null,null,null,null,8.0399999999999991,3.964212309252853,null,12.5,"Yes",0.1,0,15,"No",100]
[null,null,null,null,null,8.1999999999999993,3.964212309252853,null,13,"Yes",0.1,0,15,"No",105]
[null,null,null,null,null,8.3699999999999992,3.964212309252853,null,13.5,"Yes",0.1,0,15,"No",105]
[null,"Outputs",null,null,null,8.5299999999999994,3.964212309252853,null,14,"Yes",0.1,0,15,"No",105]
[null,"Negative Friction (Downdrag) = ",{"$f":"MAX(X6:X6000)","v":0},"kips",null,8.69,3.964212309252853,null,14.5,"Yes",0.1,0,15,"No",105]
[null,"Pile Total Settlement (Post-EQ)= ",{"$f":"MAX(U6:U6000)","v":0},"inch",null,8.86,3.964212309252853,null,15,"Yes",0.1,0,15,"No",105]
[null,"Depth of Neutral Plane from Pile Head =",null,"ft",null,9.02,3.964212309252853,null,15.5,"Yes",0.1,0,15,"No",110]
[null,null,null,null,null,9.19,3.964212309252853,null,16,"Yes",0.1,0,15,"No",110]
[null,null,null,null,null,9.35,3.964212309252853,null,16.5,"Yes",0.1,0,15,"No",110]
[null,"Note: In case the analysis fails, please change the input parameters below:",null,null,null,9.51,3.964212309252853,null,17,"Yes",0.1,0,15,"No",110]
[null,"1. Difference between computed pile head load and sustained load=",null,10,"kips",9.68,3.964212309252853,null,17.5,"Yes",0.1,0,15,"No",110]
[null,"*The load at pile head is calculated iteratively by varying pile toe displacement. The computed load ",null,null,null,9.84,3.964212309252853,null,18,"Yes",0.1,0,15,"No",110]
[null,"is compared to sustained load and if the difference becomes less than the value in cell \"D41\". The value should be ",null,null,null,10.01,3.964212309252853,null,18.5,"Yes",0.1,0,15,"No",110]
[null,"as low as possible. I believe a difference of up to 10 kips is acceptable.",null,null,null,10.17,3.964212309252853,null,19,"Yes",0.1,0,15,"No",110]
[null,null,null,null,null,10.33,3.964212309252853,null,19.5,"Yes",0.1,0,15,"No",110]
[null,null,null,null,null,10.5,3.964212309252853,null,20,"Yes",0.1,0,15,"No",110]
[null,null,null,null,null,10.66,3.964212309252853,null,20.5,"Yes",0.1,0,15,"No",110]
[null,null,null,null,null,10.83,3.964212309252853,null,21,"Yes",0.1,0,15,"No",110]
[null,null,null,null,null,10.99,3.964212309252853,null,21.5,"Yes",0.1,0,15,"No",115]
[null,null,null,null,null,11.15,3.964212309252853,null,22,"Yes",0.1,0,15,"No",115]
[null,null,{"$f":"4*144*0.25*PI()*1","v":452.38934211693021},null,null,11.32,3.964212309252853,null,22.5,"Yes",0.1,0,15,"No",115]
[null,null,null,null,null,11.48,3.964212309252853,null,23,"Yes",0.1,0,15,"No",115]
[null,null,null,null,null,11.65,3.964212309252853,null,23.5,"Yes",0.1,0,15,"No",115]
[null,null,null,null,null,11.81,3.964212309252853,null,24,"Yes",0.1,0,15,"No",115]
[null,null,null,null,null,11.98,3.9338408885287066,null,24.5,"Yes",0.1,0,15,"No",115]
[null,null,null,null,null,12.14,3.8754731406750698,null,25,"Yes",0.1,0,15,"No",115]
[null,null,null,null,null,12.47,3.8140459480149929,null,25.5,"Yes",0.1,0,15,"No",115]
[null,null,null,null,null,12.63,3.8140459480149929,null,26,"Yes",0.1,0,15,"No",115]
[null,null,null,null,null,12.8,3.8140459480149929,null,26.5,"Yes",0.1,0,15,"No",115]
[null,null,null,null,null,12.96,3.8140459480149929,null,27,"No",null,1000,0,"No",115]
[null,null,null,null,null,13.12,3.8140459480149929,null,27.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,13.29,3.8140459480149929,null,28,"No",null,1000,0,"No",115]
[null,null,null,null,null,13.45,3.8140459480149929,null,28.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,13.62,3.8140459480149929,null,29,"No",null,1000,0,"No",115]
[null,null,null,null,null,13.78,3.8140459480149929,null,29.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,13.94,3.7860101392374039,null,30,"No",null,1000,0,"No",115]
[null,null,null,null,null,14.11,3.7293767288360753,null,30.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,14.27,3.6779801588471055,null,31,"No",null,1000,0,"No",115]
[null,null,null,null,null,14.44,3.6003867387135164,null,31.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,14.6,3.5066483017462717,null,32,"No",null,1000,0,"No",115]
[null,null,null,null,null,14.76,3.4336632423758053,null,32.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,14.93,3.3813436356127178,null,33,"No",null,1000,0,"No",115]
[null,null,null,null,null,15.09,3.3351412801646405,null,33.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,15.26,3.2837271343980161,null,34,"No",null,1000,0,"No",115]
[null,null,null,null,null,15.42,3.2295774273347497,null,34.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,15.58,3.1407607408092724,null,35,"No",null,1000,0,"No",115]
[null,null,null,null,null,15.75,3.050033679797433,null,35.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,15.91,3.0008752994784382,null,36,"No",null,1000,0,"No",115]
[null,null,null,null,null,16.079999999999998,2.9302189456635452,null,36.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,16.239999999999998,2.8665055979761975,null,37,"No",null,1000,0,"No",115]
[null,null,null,null,null,16.399999999999999,2.8158604997465861,null,37.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,16.57,2.7534013462788751,null,38,"No",null,1000,0,"No",115]
[null,null,null,null,null,16.73,2.698400923431536,null,38.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,16.899999999999999,2.6389909597011472,null,39,"No",null,1000,0,"No",115]
[null,null,null,null,null,17.059999999999999,2.5887273831407271,null,39.5,"No",null,1000,0,"No",115]
[null,null,null,null,null,17.22,2.5438671432305808,null,40,"Yes",0.1,0,10,"No",115]
[null,null,null,null,null,17.39,2.4924740317916374,null,40.5,"Yes",0.1,0,10,"No",115]
[null,null,null,null,null,17.55,2.4452348762002849,null,41,"Yes",0.1,0,10,"No",115]
[null,null,null,null,null,17.72,2.4093851422091044,null,41.5,"Yes",0.1,0,10,"No",115]
[null,null,null,null,null,17.88,2.3840528704384978,null,42,"Yes",0.1,0,10,"No",115]
[null,null,null,null,null,18.04,2.3690084004801495,null,42.5,"Yes",0.1,0,10,"No",115]
[null,null,null,null,null,18.21,2.3623953432855682,null,43,"Yes",0.1,0,10,"No",115]
[null,null,null,null,null,18.37,2.3411719141494904,null,43.5,"Yes",0.1,0,10,"No",115]
[null,null,null,null,null,18.54,2.3073713192087713,null,44,"Yes",0.1,0,10,"No",115]
[null,null,null,null,null,18.7,2.2695220670523315,null,44.5,"Yes",0.1,0,10,"No",115]
[null,null,null,null,null,18.86,2.2289446550680125,null,45,"Yes",0.1,0,10,"No",115]
[null,null,null,null,null,19.03,2.1837360445724148,null,45.5,"No",null,0,30,"No",115]
[null,null,null,null,null,19.190000000000001,2.1375623772807475,null,46,"No",null,0,30,"No",115]
[null,null,null,null,null,19.36,2.0885617934021719,null,46.5,"No",null,0,30,"No",115]
[null,null,null,null,null,19.52,2.0433574322111836,null,47,"No",null,0,30,"No",115]
[null,null,null,null,null,19.690000000000001,1.9972082684475299,null,47.5,"No",null,0,30,"No",115]
[null,null,null,null,null,19.850000000000001,1.9585188653534367,null,48,"No",null,0,30,"No",115]
[null,null,null,null,null,20.010000000000002,1.9207794825198161,null,48.5,"No",null,0,30,"No",115]
[null,null,null,null,null,20.18,1.8774093823294171,null,49,"No",null,0,30,"No",115]
[null,null,null,null,null,20.34,1.8348153195530754,null,49.5,"No",null,0,30,"No",115]
[null,null,null,null,null,20.51,1.7850823040057167,null,50,"No",null,0,30,"No",120]
[null,null,null,null,null,20.67,1.7312981617184664,null,50.5,"No",null,0,30,"No",120]
[null,null,null,null,null,20.83,1.6719821066339584,null,51,"No",null,0,30,"No",120]
[null,null,null,null,null,21,1.603376627665503,null,51.5,"No",null,0,30,"No",120]
[null,null,null,null,null,21.16,1.5318598669141528,null,52,"No",null,0,30,"No",120]
[null,null,null,null,null,21.33,1.4682073777529179,null,52.5,"No",null,0,30,"No",120]
[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]
[null,null,null,null,null,46.75,0]
[null,null,null,null,null,46.92,0]
[null,null,null,null,null,47.08,0]
[null,null,null,null,null,{"$f":"F268+0.16","v":47.239999999999995},0]
[null,null,null,null,null,{"$f":"F269+0.16","v":47.399999999999991},0]
[null,null,null,null,null,47.559999999999988,0]
[null,null,null,null,null,47.719999999999985,0]
[null,null,null,null,null,47.879999999999981,0]
[null,null,null,null,null,48.039999999999978,0]
[null,null,null,null,null,48.199999999999974,0]
[null,null,null,null,null,48.359999999999971,0]
[null,null,null,null,null,48.519999999999968,0]
[null,null,null,null,null,48.679999999999964,0]
[null,null,null,null,null,48.839999999999961,0]
[null,null,null,null,null,48.999999999999957,0]
[null,null,null,null,null,49.159999999999954,0]
[null,null,null,null,null,49.319999999999951,0]
[null,null,null,null,null,49.479999999999947,0]
[null,null,null,null,null,49.639999999999944,0]
[null,null,null,null,null,49.79999999999994,0]
[null,null,null,null,null,49.959999999999937,0]
[null,null,null,null,null,50.119999999999933,0]
[null,null,null,null,null,50.27999999999993,0]
[null,null,null,null,null,50.439999999999927,0]
[null,null,null,null,null,50.599999999999923,0]
[null,null,null,null,null,50.75999999999992,0]
[null,null,null,null,null,50.919999999999916,0]
[null,null,null,null,null,51.079999999999913,0]
[null,null,null,null,null,51.23999999999991,0]
[null,null,null,null,null,51.399999999999906,0]
[null,null,null,null,null,51.559999999999903,0]
[null,null,null,null,null,51.719999999999899,0]
[null,null,null,null,null,51.879999999999896,0]
[null,null,null,null,null,52.039999999999893,0]
[null,null,null,null,null,52.199999999999889,0]
[null,null,null,null,null,52.359999999999886,0]
[null,null,null,null,null,52.519999999999882,0]
[null,null,null,null,null,52.679999999999879,0]
[null,null,null,null,null,52.839999999999876,0]
[null,null,null,null,null,52.999999999999872,0]
[null,null,null,null,null,53.159999999999869,0]
[null,null,null,null,null,53.319999999999865,0]
[null,null,null,null,null,53.479999999999862,0]
[null,null,null,null,null,53.639999999999858,0]
[null,null,null,null,null,53.799999999999855,0]
[null,null,null,null,null,53.959999999999852,0]
[null,null,null,null,null,54.119999999999848,0]
[null,null,null,null,null,54.279999999999845,0]
[null,null,null,null,null,54.439999999999841,0]
[null,null,null,null,null,54.599999999999838,0]
[null,null,null,null,null,54.759999999999835,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"]