{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sheet1","Data check page","Displacement","BendingMoment","Shear","Disp Graph","BM Graph","SF Graph"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Disp Graph","index":5,"reason":"not_a_worksheet"},{"sheet":"BM Graph","index":6,"reason":"not_a_worksheet"},{"sheet":"SF Graph","index":7,"reason":"not_a_worksheet"}],"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":"Sheet1","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Frew 19.4 COM interface testing spreadsheet"]
[]
["Enter the filename:",null,null,"C:\\Users\\vikram.gadicherla\\Desktop\\Frewman.fwd"]
[]
[]
["Click to obtain basic data:",null,null,null,"Number of nodes","Number of stages"]
[null,null,null,null,23,12]
[]
["Enter required last analysis stage and click the Analyse button:",null,null,null,"Last stage:",11]
[]
[]
[null,null,null,null,null,null,"Complete!"]
[]
[]
["Click the Plot button to plot graphs for the analysed stages:"]

{"sheet":"Data check page","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Data check"]
[]
["Material","Unit weight","E ","Cohesion","Phi"]
[1,20,59999.995999999999,30,30]
[2,20.999998046875,49999.995999999999,0,30]
[3,20,40000,0,30]
[]
["Node data for Stage 6"]
["Node","Level","EI","Left zone","Right zone"]
[1,50,500000.06400000001,1,0]
[2,49,500000.06400000001,1,0]
[3,48,500000.06400000001,1,0]
[4,47,500000.06400000001,1,0]
[5,46,500000.06400000001,1,0]
[6,45,500000.06400000001,1,0]
[7,44,500000.06400000001,1,0]
[8,43,500000.06400000001,1,0]
[9,42,500000.06400000001,1,0]
[10,41,500000.06400000001,1,0]
[11,40,500000.06400000001,1,1]
[12,39,500000.06400000001,1,1]
[13,38,500000.06400000001,2,1]
[14,37,500000.06400000001,2,1]
[15,36,500000.06400000001,2,2]
[16,35,500000.06400000001,2,2]
[17,34,500000.06400000001,2,2]
[18,33,500000.06400000001,2,2]
[19,32,0,2,2]
[20,31,0,2,2]
[21,30,0,2,2]
[22,29,0,2,2]
[23,28,0,2,2]

{"sheet":"Displacement","index":2,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Node","Level","Displacement"]
[null,null,"Stage 0","Stage 1","Stage 2","Stage 3","Stage 4","Stage 5","Stage 6","Stage 7","Stage 8","Stage 9","Stage 10","Stage 11"]
[1,50,-1.4680641470476985,0,12.077232822775841,5.4395790211856365,5.4395790211856365,34.149907529354095,37.78509795665741,37.78456524014473,37.938337773084641,39.119124412536621,38.783781230449677,46.231314539909363]
[2,49,-1.55430450104177,0,11.518597602844238,5.7571479119360447,5.7571479119360447,36.748133599758148,41.019737720489502,41.020281612873077,41.210360825061798,43.387584388256073,43.053489178419113,49.798507243394852]
[3,48,-1.6445021610707045,0,10.95975935459137,6.1475075781345367,6.1475075781345367,39.433524012565613,44.039219617843628,44.040847569704056,44.248912483453751,47.333355993032455,46.987414360046387,53.073178976774216]
[4,47,-1.7383785452693701,0,10.407296940684319,6.5458049066364765,6.5458049066364765,42.060520499944687,46.630840748548508,46.633623540401459,46.832431107759476,50.666514784097672,50.302401185035706,55.783051997423172]
[5,46,-1.8435643287375569,0,9.8901605233550072,6.8587777204811573,6.8587777204811573,44.345729053020477,48.583149909973145,48.587217926979065,48.75868558883667,53.123060613870621,52.743323147296906,57.675402611494064]
[6,45,-1.9651243928819895,0,9.4174221158027649,7.0556355640292168,7.0556355640292168,46.011988073587418,49.69145730137825,49.696922302246094,49.843017011880875,54.47101965546608,54.083913564682007,58.525744825601578]
[7,44,-2.1165222860872746,0,8.981313556432724,7.1349660865962505,7.1349660865962505,46.8110591173172,49.780607223510742,49.787480384111404,49.916286021471024,54.530184715986252,54.146986454725266,58.158062398433685]
[8,43,-2.3116546217352152,0,8.5663702338933945,7.1062357164919376,7.1062357164919376,46.554472297430038,48.735752701759338,48.743791878223419,48.861660063266754,53.19802463054657,52.830204367637634,56.46819993853569]
[9,42,-2.5719041004776955,0,8.1541566178202629,6.9802361540496349,6.9802361540496349,45.145519077777863,46.534158289432526,46.542778611183167,46.650979667901993,50.48881471157074,50.143849104642868,53.447633981704712]
[10,41,-2.9333035927265882,0,7.725854404270649,6.7646801471710205,6.7646801471710205,42.611166834831238,43.276861310005188,43.285239487886429,43.37751492857933,46.581991016864777,46.259127557277679,49.213506281375885]
[11,40,-3.4774215891957283,0,7.2639081627130508,6.4632981084287167,6.4632981084287167,39.13407027721405,39.211563766002655,39.21886533498764,39.278030395507813,41.818287223577499,41.50831326842308,44.042997062206268]
[12,39,-4.4703688472509384,0,6.7539024166762829,6.077449768781662,6.077449768781662,35.047844052314758,34.698605537414551,34.704003483057022,34.707903861999512,36.564070731401443,36.261886358261108,38.344074040651321]
[13,38,-6.7348540760576725,0,6.1881993897259235,5.6105512194335461,5.6105512194335461,30.714338645339012,30.102252960205078,30.105406418442726,30.066302046179771,31.277123838663101,30.982455238699913,32.627824693918228]
[14,37,-6.6053969785571098,0,5.5715413764119148,5.0749094225466251,5.0749094225466251,26.469584554433823,25.735653936862946,25.73700062930584,25.675034150481224,26.38961561024189,26.104198768734932,27.363931760191917]
[15,36,-4.0035638958215714,0,4.9243713729083538,4.4961487874388695,4.4961487874388695,22.574948146939278,21.821670234203339,21.821815520524979,21.752577275037766,22.145655006170273,21.871881559491158,22.818854078650475]
[16,35,-2.8026090003550053,0,4.2827771976590157,3.9140712469816208,3.9140712469816208,19.178697839379311,18.467353656888008,18.466789275407791,18.400311470031738,18.603002652525902,18.343273550271988,19.046064466238022]
[17,34,-2.0926762372255325,0,3.6646851804107428,3.3494089730083942,3.3494089730083942,16.22144877910614,15.583760105073452,15.582824125885963,15.524611808359623,15.619106590747833,15.375527553260326,15.886293724179268]
[18,33,-1.5800523106008768,0,3.0696110334247351,2.8039866592735052,2.8039866592735052,13.556530699133873,13.006511144340038,13.005401007831097,12.95797061175108,12.988540343940258,12.762720696628094,13.114419765770435]
[19,32,-1.1743820505216718,0,2.4875407107174397,2.2698040120303631,2.2698040120303631,11.02585531771183,10.568100027740002,10.566897690296173,10.531093925237656,10.515489615499973,10.308318771421909,10.515982285141945]
[20,31,-0.84059732034802437,0,2.0459194201976061,1.8593911081552505,1.8593911081552505,9.4963302835822105,9.1442614793777466,9.1435601934790611,9.1186799108982086,9.1692013666033745,8.9958207681775093,9.1960355639457703]
[21,30,-0.55899115977808833,0,1.5539336018264294,1.4041076647117734,1.4041076647117734,7.3843216523528099,7.1270200423896313,7.1265851147472858,7.1088741533458233,7.1698096580803394,7.0351893082261086,7.1938079781830311]
[22,29,-0.31190644949674606,0,0.97216205904260278,0.86963287321850657,0.86963287321850657,4.6507073566317558,4.4966200366616249,4.496381152421236,4.4845868833363056,4.5322692021727562,4.4479891657829285,4.5515666715800762]
[23,28,3.870310738562921E-6,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"BendingMoment","index":3,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Node","Level","Bending Moment"]
[null,null,"Stage 0","Stage 1","Stage 2","Stage 3","Stage 4","Stage 5","Stage 6","Stage 7","Stage 8","Stage 9","Stage 10","Stage 11"]
[1,50,0,0,0,0,0,0,0,0,0,0,0,0]
[2,49,4.0927261579781776E-15,4.0927261579781776E-15,5.4668422698974609E-2,-23.451531250000002,-23.451531250000002,-32.668718750000004,107.87646875,107.8799453125,117.784046875,165.006953125,174.11534374999999,148.4429375]
[3,48,1.5461409930139781E-14,1.5461409930139781E-14,0.39078683471679687,3.9925346679687501,3.9925346679687501,29.193330078125001,213.95337499999999,213.91409375000001,229.25259375000002,308.00490625000003,310.85374999999999,283.7483125]
[4,47,-9.5496943686157471E-15,-9.5496943686157471E-15,-20.747304687500002,47.944261718749999,47.944261718749999,171.09253125000001,319.90009375,319.83234375000001,330.30534375000002,440.81681250000003,439.28018750000001,410.95387499999998]
[5,46,-4.9112713895738124E-14,-4.9112713895738124E-14,-23.3796015625,60.205339843750004,60.205339843750004,311.79487499999999,424.37543750000003,424.30865625000001,421.33043750000002,558.57506250000006,554.23118750000003,525.01856250000003]
[6,45,-4.501998773775995E-14,-4.501998773775995E-14,-18.927794921875002,59.578285156250004,59.578285156250004,438.57834374999999,514.61062500000003,514.59409374999996,510.13675000000001,650.64512500000001,644.801875,615.00443749999999]
[7,44,1.7280399333685636E-14,1.7280399333685636E-14,-10.796730468750001,54.066980468750003,54.066980468750003,535.46993750000001,574.67162500000006,574.78100000000006,571.33643749999999,705.24487499999998,699.12275,669.05006249999997]
[8,43,2.1373125491663814E-14,2.1373125491663814E-14,-1.38404296875,48.332613281249998,48.332613281249998,586.49400000000003,588.68737499999997,588.99149999999997,588.16425000000004,702.32281250000005,698.24637500000006,675.30937500000005]
[9,42,8.3673512563109396E-14,8.3673512563109396E-14,8.1461118164062505,44.412957031250002,44.412957031250002,575.67025000000001,540.81000000000006,541.24862500000006,544.20012499999996,616.63681250000002,616.63593750000007,621.84587499999998]
[10,41,8.7766238721087577E-14,8.7766238721087577E-14,17.0639453125,42.682960937499999,42.682960937499999,487.01209375000002,415.17506250000002,415.57581249999998,423.37225000000001,423.96009375,430.30018749999999,477.98818750000004]
[11,40,1.5006662579253317E-13,1.5006662579253317E-13,24.530017578125001,42.333328125000001,42.333328125000001,304.52518750000002,222.50407812500001,222.966953125,240.37174999999999,258.16387500000002,260.43648437500002,275.33909375000002]
[12,39,1.5415935195051135E-13,1.5415935195051135E-13,28.99555078125,41.384921875000003,41.384921875000003,122.26406250000001,37.785128906250002,38.005398437499998,27.060734374999999,14.910334960937501,14.7848603515625,5.8864760742187503]
[13,38,1.0004441719502211E-13,1.0004441719502211E-13,26.578654296875001,35.275480468750004,35.275480468750004,-51.734710937500004,-123.462875,-123.7699609375,-134.173546875,-219.59821875,-220.55540625,-246.89165625000001]
[14,37,-1.2278178473934531E-14,-1.2278178473934531E-14,17.55486328125,23.742835937500001,23.742835937500001,-181.57998437500001,-233.18828125000002,-233.50178124999999,-241.36896874999999,-334.8298125,-336.07931250000001,-375.3911875]
[15,36,-3.5743141779676081E-13,-3.5743141779676081E-13,-5.2608745117187503,-0.88943194580078122,-0.88943194580078122,-272.29965625,-301.63743750000003,-301.88656250000003,-306.78946875000003,-371.73225000000002,-372.95293750000002,-407.99112500000001]
[16,35,-5.8616933529265221E-13,-5.8616933529265221E-13,-13.240343750000001,-10.235052734375,-10.235052734375,-224.381296875,-239.258671875,-239.426890625,-242.0445,-282.16006249999998,-283.2279375,-309.49818750000003]
[17,34,-8.1490725278854372E-13,-8.1490725278854372E-13,-12.283033203125001,-10.415126953125,-10.415126953125,-147.180953125,-153.50470312499999,-153.600046875,-154.745265625,-175.915015625,-176.73978124999999,-193.09410937500002]
[18,33,-1.0727490007411689E-12,-1.0727490007411689E-12,-6.6820356445312505,-5.8257255859375006,-5.8257255859375006,-63.886093750000001,-65.751773437500006,-65.790148437500008,-66.137210937500001,-74.157656250000002,-74.618890625000006,-81.803546874999995]
[19,32,-1.3014869182370604E-12,-1.3014869182370604E-12,7.2309194365516305E-10,4.105095285922289E-10,4.105095285922289E-10,2.6950147002935409E-10,1.3844692148268222E-10,1.3731187209486961E-10,1.3614771887660026E-10,1.257285475730896E-11,2.4359906092286109E-11,-7.2817783802747733E-11]
[20,31,-1.5593286661896856E-12,-1.5593286661896856E-12,7.6024298323318369E-10,4.2874307837337257E-10,4.2874307837337257E-10,2.605956979095936E-10,1.184380380436778E-10,1.1731754057109355E-10,1.1602242011576891E-10,-1.7447746358811856E-11,-4.7584762796759607E-12,-1.0714575182646514E-10]
[21,30,-1.7880665836855769E-12,-1.7880665836855769E-12,7.9739402281120422E-10,4.4697662815451624E-10,4.4697662815451624E-10,2.5163171812891962E-10,9.8370946943759915E-11,9.726500138640404E-11,9.583891369402409E-11,-4.7526555135846138E-11,-3.3935066312551496E-11,-1.4153192751109601E-10]
[22,29,-2.0168045011814686E-12,-2.0168045011814686E-12,8.3460327005013829E-10,4.6526838559657334E-10,4.6526838559657334E-10,2.4258042685687544E-10,7.8216544352471828E-11,7.7125150710344312E-11,7.5568095780909069E-11,-7.7692675404250628E-11,-6.3198967836797237E-11,-1.7600541468709708E-10]
[23,28,-2.2455424186773597E-12,-2.2455424186773597E-12,8.7175430962815883E-10,4.83501935377717E-10,4.83501935377717E-10,2.3347092792391778E-10,5.8003934100270274E-11,5.6927092373371123E-11,5.5239070206880573E-11,-1.0791700333356858E-10,-9.2521077021956452E-11,-2.1053710952401161E-10]

{"sheet":"Shear","index":4,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Node","Level","Shear Force"]
[null,null,"Stage 0","Stage 1","Stage 2","Stage 3","Stage 4","Stage 5","Stage 6","Stage 7","Stage 8","Stage 9","Stage 10","Stage 11"]
[1,50,0,0,0,0,0,0,0,0,0,0,0,0]
[2,49,-7.7307049650698906E-15,-7.7307049650698906E-15,-0.19539341735839844,42.468804687500004,42.468804687500004,40.751425781249999,-106.9766875,-106.957046875,-114.62629687500001,-154.00245312500002,-155.426875,-141.87415625]
[3,48,6.8212102632969615E-15,6.8212102632969615E-15,10.400986328125001,-67.837281250000004,-67.837281250000004,-141.88626562499999,-106.01182031250001,-105.9761953125,-106.2606484375,-137.90493750000002,-132.58240624999999,-131.25546875000001]
[4,47,3.2287061912938956E-14,3.2287061912938956E-14,11.8851943359375,-28.106402343750002,-28.106402343750002,-141.30078125,-105.2110234375,-105.1972734375,-96.038929687500001,-125.2850703125,-121.68871093750001,-120.635109375]
[5,46,1.7735146684572101E-14,1.7735146684572101E-14,-0.90975451660156248,-5.8170112304687498,-5.8170112304687498,-133.742890625,-97.3552578125,-97.380882812500005,-89.915703125000007,-104.91416406250001,-102.76084375000001,-102.02528906250001]
[6,45,-3.3196556614711879E-14,-3.3196556614711879E-14,-6.2914355468750003,3.0691784667968749,3.0691784667968749,-111.83751562500001,-75.148109375000004,-75.236171874999997,-75.003,-73.334898437500001,-72.445796874999999,-72.015765625]
[7,44,-3.3196556614711879E-14,-3.3196556614711879E-14,-8.7718759765624998,5.6228359375000005,5.6228359375000005,-73.957828125000006,-37.038378906250003,-37.198710937500003,-39.0137421875,-25.83883203125,-26.722246093750002,-30.152457031250002]
[8,43,-3.3196556614711879E-14,-3.3196556614711879E-14,-9.4714208984375006,4.8270122070312498,4.8270122070312498,-20.10016796875,16.930822265625,16.766191406250002,13.568146484375001,44.304027343750001,41.243429687500004,23.602095703125002]
[9,42,-3.3196556614711879E-14,-3.3196556614711879E-14,-9.2239941406250008,2.8248264160156249,2.8248264160156249,49.740953125000004,86.756156250000004,86.707851562499997,82.396000000000001,139.181359375,133.973078125,98.660585937500002]
[10,41,-3.3196556614711879E-14,-3.3196556614711879E-14,-8.1919531249999995,1.0398140869140626,1.0398140869140626,135.57253125,172.46687500000002,172.62226562500001,167.24112500000001,258.652921875,251.05890625000001,202.79718750000001]
[11,40,-3.3196556614711879E-14,-3.3196556614711879E-14,-5.9658022460937499,0.64901934814453122,0.64901934814453122,182.374015625,188.69496875000002,188.78520312500001,198.15575000000001,204.52487500000001,207.75765625,236.05085937500002]
[12,39,2.5011104298755527E-14,2.5011104298755527E-14,-1.0243178710937499,3.5289233398437503,3.5289233398437503,178.12995312500001,172.98346875000001,173.368453125,187.27265625000001,238.88104687500001,240.4959375,261.11537500000003]
[13,38,8.3218765212222932E-14,8.3218765212222932E-14,5.7203432617187504,8.8210429687499996,8.8210429687499996,151.922015625,135.48670312499999,135.75359374999999,134.21484375,174.87007812499999,175.43209375000001,190.638828125]
[14,37,2.2873791749589145E-13,2.2873791749589145E-13,15.919763671875,18.082457031250001,18.082457031250001,110.28247656250001,89.087281250000004,89.058304687499998,86.307953124999997,76.067015624999996,76.198765625000007,80.549726562499998]
[15,36,2.8694557840935886E-13,2.8694557840935886E-13,15.397603515625001,16.9889453125,16.9889453125,21.400662109375002,3.0351892089843751,2.9625524902343749,0.33776647949218752,-26.334884765625002,-26.425693359375,-32.94649609375]
[16,35,2.2873791749589145E-13,2.2873791749589145E-13,3.5110791015625002,4.7628471679687499,4.7628471679687499,-62.559351562499998,-74.066367187500006,-74.143257812499996,-76.022093749999996,-97.908617187499999,-98.106578124999999,-107.4485]
[17,34,2.4328983272425832E-13,2.4328983272425832E-13,-3.2791542968750003,-2.2046633300781249,-2.2046633300781249,-80.247601562500009,-86.753445312500006,-86.818367187500002,-87.953640625000006,-104.0011953125,-104.30452343750001,-113.847328125]
[18,33,2.4328983272425832E-13,2.4328983272425832E-13,-6.1415166015625005,-5.2075634765625001,-5.2075634765625001,-73.590476562500001,-76.752351562499996,-76.800023437500002,-77.372632812500001,-87.957507812499998,-88.369890624999996,-96.547054687500008]
[19,32,2.4328983272425832E-13,2.5784174795262518E-13,-3.7151039578020572E-11,-1.8226273823529481E-11,-1.8226273823529481E-11,8.8912202045321463E-12,2.0052539184689523E-11,1.9994331523776056E-11,2.0125298760831356E-11,2.9976945370435715E-11,2.9176590032875536E-11,3.4313416108489038E-11]
[20,31,2.4328983272425832E-13,2.4328983272425832E-13,-3.7151039578020572E-11,-1.8226273823529481E-11,-1.8226273823529481E-11,8.92032403498888E-12,2.0081643015146257E-11,2.002343535423279E-11,2.015440259128809E-11,3.0006049200892446E-11,2.9205693863332273E-11,3.4342519938945768E-11]
[21,30,2.2873791749589145E-13,2.2873791749589145E-13,-3.7180143408477309E-11,-1.8255377653986215E-11,-1.8255377653986215E-11,8.9930836111307143E-12,2.015440259128809E-11,2.0096194930374622E-11,2.0227162167429926E-11,3.0078808777034285E-11,2.9278453439474106E-11,3.4415279515087608E-11]
[22,29,2.2873791749589145E-13,2.2873791749589145E-13,-3.7180143408477309E-11,-1.8255377653986215E-11,-1.8255377653986215E-11,9.0658431872725486E-12,2.0227162167429926E-11,2.0168954506516458E-11,2.0299921743571759E-11,3.0151568353176118E-11,2.9351213015615939E-11,3.448803909122944E-11]
[23,28,2.2873791749589145E-13,2.2873791749589145E-13,-3.7151039578020572E-11,-1.8226273823529481E-11,-1.8226273823529481E-11,9.0949470177292824E-12,2.025626599788666E-11,2.0198058336973192E-11,2.0329025574028492E-11,3.0180672183632848E-11,2.9380316846072676E-11,3.4517142921686171E-11]