{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calcs","Profile"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Profile","index":1,"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":"Calcs","index":0,"n_rows":135,"n_cols":10,"rows_kept":135,"cut":false,"hidden":false,"merged":[[2,4,2,5],[14,4,14,5],[5,4,5,5],[9,4,9,5]]}
["JRB Catenary Cable V20170930",null,null,null,null,null,null,null,"JRB STRUCTURAL ENGINEERING PTY LTD","Notes:"]
[]
[null,"x","y",null,"Solving Striaght Line"]
["Left",0,0,null,"m1 = ",{"$f":"(C5-C4)/(B5-B4)","v":0.25}]
["Right",20,5,null,"c1 =",{"$f":"C4-F4*B4","v":0}]
[null,null,null,null,"Normal Line"]
["L =",23,"m",null,"m2 =",{"$f":"-1/F4","v":-4}]
["r =",10,"kg/m"]
["d = ",{"$f":"B5-B4","v":20},"m",null,"Solving Catenary Profile"]
["h = ",{"$f":"C5-C4","v":5},"m",null,"Solving for a"]
["H = ",{"$f":"a*9.81*B8","v":1164.7314314830869},"N",null,"a =",{"$f":"solve_a(B7,B10,B9)","v":11.872899403497316}]
[null,null,null,null,"Error =",2.0657118682265718E-8]
["x_cat =",{"$f":"a*ASINH(F4)-k","v":10.315226493200406},"m",null,"Iterations =",16]
["x_lin =",{"$f":"(B15-$F$7*B13-$F$5)/($F$4-$F$7)","v":9.2375984341845676},"m",null,"Exit Flag =",1]
["y_cat =",{"$f":"a*COSH(($B$13+k)/a)+w","v":-2.0011126275172071},"m",null,"Now Solving Parameters"]
["y_lin =",{"$f":"F4*B14+F5","v":2.3093996085461419},"m",null,"x1 =",{"$f":"1/2*(a*LN((L+h)/(L-h))-d)","v":-7.3770820895103091}]
["max_sag =",{"$f":"SQRT((B14-B13)^2+(B16-B15)^2)","v":4.4431743124516396},"m",null,"k =",{"$f":"F16-B4","v":-7.3770820895103091}]
[null,null,null,null,"w = ",{"$f":"C4-a*COSH(F16/a)","v":-14.239417208255295}]
[]
[null,null,null,null,"x_lowest =",{"$f":"-1*k","v":7.3770820895103091},"m"]
[null,null,null,null,"y_lowest =",{"$f":"a+w","v":-2.3665178047579793},"m"]
[]
["y = a*cosh((x+k)/a)+w",null,null,null,null,"y' = sinh((x+k)/a)"]
[{"$f":"CONCATENATE(\"y = \",TEXT(a,\"0.00\"),\"*cosh((x\",TEXT(k,\"+0.00;-0.00\"),\")/\",TEXT(a,\"0.00\"),\")\",TEXT(w,\"+0.00;-0.00\"))","v":"y = 11.87*cosh((x-7.38)/11.87)-14.24"},null,null,null,null,{"$f":" CONCATENATE(\"y' = sinh((x\",TEXT(k,\"+0.00;-0.00\"),\")/\",TEXT(a,\"0.00\"),\")\")","v":"y' = sinh((x-7.38)/11.87)"}]
[]
["Li (m)","x (m)","y (m)","y'","V (N)","T (N)","xint (m)","yint (m)","sag (m)"]
[0,{"$f":"B4","v":0},{"$f":"a*COSH((B27+k)/a)+w","v":0},{"$f":"SINH((B27+k)/a)","v":-0.66209575200808823},{"$f":"$B$11*D27","v":-771.16373301525152},{"$f":"SQRT(E27^2+$B$11^2)","v":1396.8868281298448},{"$f":"(C27-$F$7*B27-$F$5)/($F$4-$F$7)","v":0},{"$f":"$F$4*G27+$F$5","v":0},{"$f":"SQRT((B27-G27)^2+(H27-C27)^2)","v":0}]
[{"$f":"A27+L/100","v":0.23},{"$f":"a*ASINH(A28/a+SINH(($B$27+k)/a))-k","v":0.1926294207247663},-0.12567057061217035,-0.6427239042240287,-748.60073301525142,1384.5585451527907,0.15172873230279879,3.7932183075699698E-2,0.16863785852424937]
[0.46,0.38696344108893488,-0.24868863993519597,-0.62335205643996949,-726.03773301525166,1372.4904725522019,0.30568591162836317,7.6421477907090793E-2,0.33511583895518826]
[0.69000000000000006,0.58299466791691668,-0.3689836320027613,-0.60398020865590984,-703.47473301525145,1360.6895338303739,0.46188118580350718,0.11547029645087679,0.4993636794399427]
[0.92,0.78071350509389426,-0.48648409149583216,-0.58460836087185042,-680.91173301525134,1349.1627387541037,0.62032233620699884,0.15508058405174971,0.66130973073695098]
[1.1500000000000001,0.98010804065682411,-0.60111778952699346,-0.5652365130877911,-658.34873301525147,1337.9171729772465,0.78101514661183602,0.195253786652959,0.82088103145739133]
[1.3800000000000001,1.1811639354207015,-0.71281184121252572,-0.54586466530373179,-635.78573301525159,1326.959986506896,0.94396327069888952,0.23599081767472238,0.97800339511475176]
[1.61,1.38386431409858,-0.82149283536752016,-0.52649281751967225,-613.22273301525149,1316.2983809802909,1.1091680990651294,0.27729202476628234,1.1326015095402988]
[1.84,1.588189659958215,-0.92708697657304029,-0.50712096973561271,-590.65973301525139,1305.9395957280294,1.2766286266493694,0.31915715666234235,1.2845990491589527]
[2.0700000000000003,1.7941177141384754,-1.0295202397628138,-0.48774912195155329,-568.0967330152514,1295.8908926091126,1.4463413215979031,0.36158533039947577,1.4339188005410499]
[2.3000000000000003,2.0016233808228394,-1.1287185373601254,-0.46837727416749392,-545.53373301525141,1286.1595396148164,1.6182999966897018,0.40457499917242545,1.5804828015501395,"x"]
[2.5300000000000002,2.2106786395327056,-1.2246078988632476,-0.44900542638343449,-522.97073301525143,1276.7527932513601,1.7924956845335469,0.44812392113338673,1.7242124942944477]
[2.7600000000000002,2.4212524658576093,-1.3171146626304093,-0.42963357859937495,-500.40773301525132,1267.6778797258016,1.9689165178353008,0.49222912945882519,1.8650288919598785]
[2.99,2.6333107619798213,-1.4061656794536823,-0.41026173081531558,-477.84473301525139,1258.9419749754386,2.1475476161095535,0.53688690402738837,2.0028527594554331]
[3.22,2.8468162983746996,-1.4916885273367022,-0.39088988303125616,-455.2817330152514,1250.5521835981142,2.3283709802734345,0.58209274506835862,2.1376048076384637]
[3.45,3.0617286680725675,-1.5736117367055282,-0.37151803524719679,-432.71873301525147,1242.5155167590324,2.5113653966081744,0.62784134915204359,2.2692059007081782]
[3.68,3.278004254850547,-1.6518650250877691,-0.35214618746313731,-410.15573301525137,1234.8388691687344,2.6965063516033929,0.67412658790084823,2.3975772761632159]
[3.91,3.4955962166808985,-1.7263795400952944,-0.33277433967907788,-387.59273301525138,1227.5289952464964,2.8837659592066589,0.72094148980166473,2.5226407765151397]
[4.1400000000000006,3.7144544856942643,-1.7970881093439246,-0.31340249189501856,-365.02973301525151,1220.5924846032055,3.0731129019842665,0.76827822549606661,2.6443190917372319]
[4.370000000000001,3.9345257858200133,-1.8639254957437412,-0.29403064411095903,-342.46673301525141,1214.0357369973835,3.264512387655603,0.81612809691390076,2.7625360112108863]
[4.6000000000000014,4.1557536691406067,-1.9268286564004242,-0.27465879632689977,-319.90373301525159,1207.8649369369632,3.4579261223910596,0.86448153059776489,2.8772166837140292]
[4.8300000000000018,4.3780785718423596,-1.985737003186566,-0.25528694854284029,-297.34073301525149,1202.0860281172424,3.6533123021606757,0.91332807554016893,2.9882878837824767]
[5.0600000000000023,4.6014378904613782,-2.0405926628772182,-0.23591510075878064,-274.77773301525127,1196.7046879015898,3.8506256232866578,0.96265640582166445,3.0956782825708404]
[5.2900000000000027,4.8257660789124763,-2.0913407346013599,-0.2165432529747211,-252.21473301525111,1191.7263020654511,4.0498173131878934,1.0124543282969733,3.1993187211501097]
[5.5200000000000031,5.0509947665524901,-2.137929542246221,-0.19717140519066173,-229.65173301525118,1187.1559400354904,4.2508351821091157,1.0627087955272789,3.2991424840103689]
[5.7500000000000036,5.2770528972711475,-2.1803108793685944,-0.17779955740660225,-207.08873301525114,1182.9983308637857,4.4536236964037634,1.1134059241009409,3.3950855703941651]
[5.980000000000004,5.5038668893265559,-2.2184402441221049,-0.15842770962254288,-184.52573301525118,1179.2578401814662,4.6581240736903808,1.1645310184225952,3.4870869609752333]
[6.2100000000000044,5.7313608153537361,-2.2522770617046426,-0.13905586183848329,-161.96273301525099,1175.9384483766189,4.8642743999318361,1.216068599982959,3.5750888773226897]
[6.4400000000000048,5.9594566016791566,-2.2817848918695844,-0.11968401405442378,-139.39973301525089,1173.0437302374382,5.0720097681993037,1.2680024420498259,3.6590370315573595]
[6.6700000000000053,6.1880742457787603,-2.3069316191293883,-0.10031216627036439,-116.83673301525094,1170.5768362932515,5.281262438584859,1.3203156096462147,3.7388808636176898]
[6.9000000000000057,6.417132050428247,-2.3276896234117359,-8.0940318486304758E-2,-94.273733015250698,1168.5404760731533,5.4919620184238243,1.3729905046059561,3.8145737636103072]
[7.1300000000000061,6.6465468728198456,-2.3440359291054556,-6.1568470702245123E-2,-71.710733015250455,1166.9369034845995,5.7040356616879828,1.4260089154219957,3.8860732768254977]
[7.3600000000000065,6.8762343866666447,{"$f":"a*COSH((B59+k)/a)+w","v":-2.3559523306544037},{"$f":"SINH((B59+k)/a)","v":-4.2196622918185774E-2},{"$f":"$B$11*D59","v":-49.147733015250544},{"$f":"SQRT(E59^2+$B$11^2)","v":1165.7679044926476},{"$f":"(C59-$F$7*B59-$F$5)/($F$4-$F$7)","v":5.9174082861205122},{"$f":"$F$4*G59+$F$5","v":1.479352071530128},{"$f":"SQRT((B59-G59)^2+(H59-C59)^2)","v":3.9533412891508051}]
[{"$f":"A59+L/100","v":7.590000000000007},{"$f":"a*ASINH(A60/a+SINH(($B$27+k)/a))-k","v":7.1061093550905232},-2.3634254931184273,-2.282477513412666E-2,-26.584733015250912,1165.0347872549269,6.1320028064102745,1.5330007016025686,4.0163441908145376]
[7.8200000000000074,7.3360859118993424,-2.3664470264168411,-3.4529273500669127E-3,-4.0217330152505371,1164.7383748383527,6.3477403814542415,1.5869350953635604,4.075053016632264]
[8.0500000000000078,7.5660778487086722,-2.3650135322953716,1.591892043399256E-2,18.54126698474952,1164.879000611669,6.5645406735386631,1.6411351683846658,4.1294435612086851]
[8.2800000000000082,7.795998905257588,-2.3591266234052721,3.5290768218051896E-2,41.104266984749415,1165.4565063737875,6.7823221170882544,1.6955805292720636,4.179496467859023]
[8.5100000000000087,8.0257630602096217,-2.3487929142452604,5.4662616002111482E-2,63.667266984749602,1166.4702432423846,7.001002194492524,1.750250548623131,4.22519729035099]
[8.7400000000000091,8.2552848197212203,-2.3340239840846984,7.4034463786170873E-2,86.230266984749562,1167.9190752911359,7.2204977164235729,1.8051244291058932,4.2665365269231357]
[8.9700000000000095,8.4844795011008305,-2.3148363123515416,9.3406311570230049E-2,108.79326698474927,1169.8013858881582,7.4407251040121833,1.8601812760030458,4.3035096263993697]
[9.2000000000000099,8.7132635089708508,-2.2912511873222812,0.11277815935428992,131.35626698474979,1172.1150866535288,7.6616006702496762,1.915400167562419,4.3361169665843144]
[9.4300000000000104,8.9415546014796234,-2.2632945892853407,0.13215000713834926,153.9192669847497,1174.8576289209529,7.8830408980313313,1.9707602245078328,4.3643638054810419]
[9.6600000000000108,9.1692721442875129,-2.2309970496570237,0.15152185492240866,176.48226698474966,1178.0260175584906,8.1049627123513002,2.026240678087825,4.3882602062141336]
[9.8900000000000112,9.3963373502641598,-2.1943934878031488,0.17089370270646809,199.04526698474965,1181.6168269763557,8.3272837442949399,2.081820936073735,4.4078209368585402]
[10.120000000000012,9.6226735030781896,-2.1535230275552006,0.19026555049052768,221.60826698474986,1185.6262191266794,8.5499225846488365,2.1374806461622091,4.4230653466625753]
[10.350000000000012,9.8482061631282427,-2.1084287956029293,0.20963739827458722,244.17126698474999,1190.0499632811973,8.7727990251553027,2.1931997562888257,4.434017220405611]
[10.580000000000013,10.072863354548733,-2.0591577040931845,0.22900924605864656,266.73426698474987,1194.8834573583033,8.9958342856710001,2.24895857141775,4.4407046128435343]
[10.810000000000013,10.296575732317621,-2.005760219866378,0.24838109384270582,289.29726698474968,1200.1217505609529,9.2189512257421438,2.3047378064355359,4.4431596653648109]
[11.040000000000013,10.51927672878972,-1.948290122817502,0.26775294162676544,311.8602669847499,1205.7595670814476,9.4420745393744419,2.3605186348436105,4.4414184071057941]
[11.270000000000014,10.740902679270876,-1.8868042558792659,0.28712478941082487,334.42326698474994,1211.7913306280889,9.6651309320480578,2.4162827330120145,4.4355205428549489]
[11.500000000000014,10.961392926529554,-1.8213622690937825,0.30649663719488451,356.98626698475016,1218.2111895317446,9.8880492792998655,2.4720123198249664,4.4255092301137005]
[11.730000000000015,11.180689904407471,-1.7520263601694097,0.32586848497894383,379.54926698475003,1225.0130421972256,10.110760766461288,2.527690191615322,4.4114308476781616]
[11.960000000000015,11.398739200935609,-1.6788610138153111,0.34524033276300325,402.11226698475002,1232.1905626745629,10.333199009394619,2.5832997523486547,4.3933347580643813]
[12.190000000000015,11.615489601582173,-1.6019327420132026,0.36461218054706279,424.67526698475018,1239.7372261383498,10.555300156309526,2.6388250390773815,4.3712730660241137]
[12.420000000000016,11.830893113452742,-1.5213098272282028,0.38398402833112233,447.23826698475028,1247.6463340787579,10.777002970960652,2.694250742740163,4.3453003752921404]
[12.650000000000016,12.044904971427769,-1.4370620703847141,0.40335587611518164,469.80126698475016,1255.9110390251044,10.998248897723851,2.7495622244309628,4.3154735455755215]
[12.880000000000017,12.257483627358358,-1.3492605452435189,0.42272772389924129,492.36426698475043,1264.5243686414553,11.218982109221157,2.8047455273052893,4.2818514516439787]
[13.110000000000017,12.468590723547646,-1.2579773606185007,0.44209957168330061,514.9272669847503,1273.4792490531697,11.43914953731108,2.8597873843277699,4.2444947462145102]
[13.340000000000018,12.67819105182326,-1.1632854316694559,0.46147141946736003,537.49026698475029,1282.7685272830711,11.65870088838202,2.914675222095505,4.2034656281464455]
[13.570000000000018,12.886252499557152,-1.065258261306786,0.48084326725141968,560.05326698475062,1292.3849926956491,11.877588643981605,2.9693971609954013,4.1588276172807364]
[13.800000000000018,13.092745984015117,-0.963969732547028,0.500215115035479,582.6162669847505,1302.3213973669813,12.095768047885516,3.0239420119713789,4.1106453370726452]
[14.030000000000019,13.297645376421297,-0.85949391246938234,0.51958696281953864,605.17926698475071,1312.5704753165983,12.313197080756661,3.0782992701891652,4.0589843059845823]
[14.260000000000019,13.500927417105634,-0.75190486824462432,0.53895881060359785,627.74226698475047,1323.124960555047,12.529836423571274,3.1324591058928184,4.003910738428166]
[14.49000000000002,13.702571623067621,-0.64127649554145449,0.5583306583876575,650.30526698475069,1333.977603917228,12.745649410995066,3.1864123527487664,3.9454913558748488]
[14.72000000000002,13.902560189239722,{"$f":"a*COSH((B91+k)/a)+w","v":-0.52768235946277642},{"$f":"SINH((B91+k)/a)","v":0.57770250617171692},{"$f":"$B$11*D91","v":672.86826698475068},{"$f":"SQRT(E91^2+$B$11^2)","v":1345.1211886665462},{"$f":"(C91-$F$7*B91-$F$5)/($F$4-$F$7)","v":12.960601975881438},{"$f":"$F$4*G91+$F$5","v":3.2401504939703596},{"$f":"SQRT((B91-G91)^2+(H91-C91)^2)","v":3.8837932085943012}]
[{"$f":"A91+L/100","v":14.950000000000021},{"$f":"a*ASINH(A92/a+SINH(($B$27+k)/a))-k","v":14.100877884672375},-0.4111955480266456,0.59707435395577657,695.43126698475101,1356.5485448684308,13.174662586038318,3.2936656465095795,3.8188835083312189]
[15.180000000000021,14.297511944790868,-0.29188853808428661,0.616446201739836,717.99426698475099,1368.2525625437763,13.387802174371572,3.346950543592893,3.7508294720951456]
[15.410000000000021,14.49245196079624,-0.16983307346055732,0.6358180495238952,740.55726698475075,1380.2262036233642,13.599994063464564,3.399998515866141,3.6796981771151365]
[15.640000000000022,14.685689767199051,-4.5100055010713902E-2,0.65518989730795452,763.12026698475063,1392.4625127332936,13.811213885596587,3.4528034713991467,3.6055564269020874]
[15.870000000000022,14.877219328388938,8.2240557789770463E-2,0.6745617450920145,785.68326698475119,1404.9546268490212,14.021439499140122,3.5053598747850305,3.5284706282659104]
[16.100000000000023,15.067036625055922,0.21211983416841029,0.69393359287607392,808.24626698475117,1417.6957838617657,14.230650902209906,3.5576627255524764,3.4485066790527044]
[16.330000000000023,15.255139541193111,0.34446994878791948,0.71330544066013335,830.80926698475128,1430.6793301059397,14.438830144367145,3.6097075360917863,3.3657298662977024]
[16.560000000000024,15.441527752325669,0.47922424842118616,0.73267728844419278,853.37226698475126,1443.8987268999631,14.645961237111498,3.6614903092778746,3.2802047744325908]
[16.790000000000024,15.626202615529447,0.61631730912960236,0.75204913622825198,875.93526698475091,1457.3475561554585,14.852030063822914,3.7130075159557285,3.1919952031399799]
[17.020000000000024,15.809167061724711,0.7556849845224054,0.77142098401231152,898.49826698475113,1471.0195251114928,15.057024289746176,3.7642560724365439,3.1011640944123573]
[17.250000000000025,15.99042549065668,0.89726444568300145,0.79079283179637105,921.06126698475123,1484.9084702513471,15.260933272543465,3.8152333181358662,3.0077734683469068]
[17.480000000000025,16.169983668906053,1.040994213349089,0.81016467958043048,943.62426698475122,1499.0083604593904,15.463747973876071,3.8659369934690178,2.911884367190118]
[17.710000000000026,16.34784863120894,1.1868141829278223,0.82953652736449013,966.18726698475143,1513.3132994750638,15.665460872414959,3.9163652181037398,2.8135568071360839]
[17.940000000000026,16.524028585307303,1.3346656429160308,0.84890837514854922,988.75026698475108,1527.8175276999073,15.866065878622411,3.9665164696556028,2.7128497373791047]
[18.170000000000027,16.698532820497988,1.4844912872802354,0.86828022293260887,1011.3132669847514,1542.5154234120357,16.065558251593455,4.0163895628983637,2.6098210059231901]
[18.400000000000027,16.871371620000538,1.6362352223316101,0.88765207071666807,1033.8762669847511,1557.4015034405754,16.26393451819618,4.065983629549045,2.5045273316584389]
[18.630000000000027,17.042556177221446,1.7898429686095572,0.9070239185007275,1056.4392669847512,1572.4704233504424,16.461192394704788,4.1152980986761971,2.3970242822248022]
[18.860000000000028,17.212098515954505,1.9452614582629568,0.92639576628478726,1079.0022669847515,1587.7169771854408,16.657330711077879,4.1643326777694698,2.2873662571983862]
[19.090000000000028,17.380011414523988,2.1024390283928707,0.94576761406884668,1101.5652669847516,1603.1360968151855,16.852349337997367,4.2130873344993418,2.1756064761519949]
[19.320000000000029,17.546308333848447,2.2613254107937646,0.96513946185290589,1124.1282669847512,1618.7228509287131,17.046249116750012,4.261562279187503,2.0617969711605189]
[19.550000000000029,17.711003349378398,2.4218717185032741,0.98451130963696576,1146.6912669847518,1634.472443715016,17.239031792003967,4.3097579480009918,1.9459885833420387]
[19.78000000000003,17.874111086840049,2.5840304295433629,1.0038831574210254,1169.2542669847519,1650.3802132680487,17.430699947506721,4.3576749868766802,1.8282309630467861]
[20.01000000000003,18.035646661699978,2.7477553682089475,1.0232550052050846,1191.8172669847518,1666.4416297511425,17.621256944707966,4.4053142361769915,1.7085725733278712]
[20.24000000000003,18.195625622251011,2.9130016842334303,1.0426268529891436,1214.3802669847512,1682.6522933531444,17.810706864291173,4.4526767160727934,1.5870606963499814]
[20.470000000000031,18.354063896208267,3.0797258301351977,1.0619987007732035,1236.9432669847517,1699.0079320661077,17.999054450580768,4.4997636126451921,1.4637414424141464]
[20.700000000000031,18.510977740695058,3.2478855370240733,1.0813705485572624,1259.5062669847512,1715.5043993119064,18.186305058777485,4.5465762646943713,1.3386597612987243,"x"]
[20.930000000000032,18.666383695491799,3.4174397891233976,1.1007423963413223,1282.0692669847517,1732.1376714428502,18.372464604962492,4.5931161512406229,1.2118594556378095]
[21.160000000000032,18.82029853941593,3.5883487972403589,1.120114244125382,1304.6322669847521,1748.9038451391243,18.557539518800958,4.6393848797002395,1.0833831960793707]
[21.390000000000033,18.97273924969803,3.7605739713962141,1.1394860919094416,1327.1952669847522,1765.7991347238133,18.741536698867844,4.6853841747169609,0.95327253798509592]
[21.620000000000033,19.123722964217528,3.9340778928076201,1.158857939693501,1349.7582669847523,1782.8198694142723,18.924463470512407,4.7311158676281018,0.82156793945330886]
[21.850000000000033,19.273266946461085,4.1088242853915364,1.1782297874775609,1372.3212669847528,1799.9624905267549,19.106327546173148,4.776581886543287,0.68830878046443411]
[22.080000000000034,19.421388553067569,{"$f":"a*COSH((B123+k)/a)+w","v":4.2847779869484324},1.1976016352616197,{"$f":"$B$11*D123","v":1394.884266984752},{"$f":"SQRT(E123^2+$B$11^2)","v":1817.2235486494856},19.287136988051458,{"$f":"$F$4*G123+$F$5","v":4.8217842470128645},{"$f":"SQRT((B123-G123)^2+(H123-C123)^2)","v":0.55353338296589083}]
[22.310000000000034,{"$f":"a*ASINH(A124/a+SINH(($B$27+k)/a))-k","v":19.568105203825148},{"$f":"a*COSH((B124+k)/a)+w","v":4.4619049201620999},1.2169734830456789,1417.4472669847516,1834.5997007977469,19.466900173050046,{"$f":"$F$4*G124+$F$5","v":4.8667250432625115},{"$f":"SQRT((B124-G124)^2+(H124-C124)^2)","v":0.41727903172963493}]
[22.540000000000035,{"$f":"a*ASINH(A125/a+SINH(($B$27+k)/a))-k","v":19.713434353988497},{"$f":"a*COSH((B125+k)/a)+w","v":4.6401720635392554},1.2363453308297387,1440.0102669847522,1852.0877075630458,19.645625759880762,{"$f":"$F$4*G125+$F$5","v":4.9114064399701904},{"$f":"SQRT((B125-G125)^2+(H125-C125)^2)","v":0.27958199583082188}]
[22.770000000000035,{"$f":"a*ASINH(A126/a+SINH(($B$27+k)/a))-k","v":19.857393468787194},{"$f":"a*COSH((B126+k)/a)+w","v":4.819547422397795},1.2557171786137979,1462.5732669847521,1869.6844302670684,19.823322658246251,{"$f":"$F$4*G126+$F$5","v":4.9558306645615628},{"$f":"SQRT((B126-G126)^2+(H126-C126)^2)","v":0.14047755061071146}]
[23.000000000000036,{"$f":"a*ASINH(A127/a+SINH(($B$27+k)/a))-k","v":20.000000000000018},{"$f":"a*COSH((B127+k)/a)+w","v":5.0000000000000231},1.2750890263978576,1485.1362669847522,1887.3868281298473,20.000000000000025,{"$f":"$F$4*G127+$F$5","v":5.0000000000000062},{"$f":"SQRT((B127-G127)^2+(H127-C127)^2)","v":1.8310267194088951E-14}]
[]
[]
[null,null,null,null,"Max Design Tension =",{"$f":"MAX(F27:F127)/1000","v":1.8873868281298474},"kN (unfactored)"]
[]
[]
[null,null,null,null,null,{"$f":"3*F130","v":5.6621604843895419}]
[]
[null,null,null,null,null,{"$f":"5*3.77","v":18.850000000000001}]