{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Tensions","Tension graphs","Heel graphs","Sag graphs","Twist graphs","JS sag","Sag draft","Twist"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":0,"defined_names":106,"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":"Tensions","index":0,"n_rows":60,"n_cols":19,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Jibstay & Topping lift tension calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABBREVIATIONS"]
["Set basic rig dimensions into beige cells.  These are relatively constant.",null,null,null,null,null,null,null,null,null,null,null,"BS",null,"Backstay"]
["Set tensions into yellow cells, along with shroud location and pivot offset.",null,null,null,null,null,null,null,null,null,null,null,"JS",null,"Jibstay"]
["Read resulting jibstay and topping lift tensions in green cells.",null,null,null,null,null,null,null,null,null,null,null,"TL",null,"Topping lift"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sh",null,"Shrouds"]
[1,null,"1=A, 2=B, 3=C",null,null,null,null,{"$f":"90-ATAN(ShOffset/(HLOOKUP(RigNumber,DefaultTable,21)/2))*180/PI()","v":90},"deg","Max main boom"]
[{"$f":"HLOOKUP(RigNumber,DefaultTable,2)","v":1680},"mm","Mast height, top to deck",null,null,null,null,{"$f":"HLOOKUP(RigNumber,DefaultTable,6)","v":2.6909776041774309},"sq.ft","Jib area",null,null,"Default settings by rig"]
[500,"mm","Mast step to transom",null,null,null,null,{"$f":"0.0012","v":1.1999999999999999E-3},null,"Density",null,null,null,null,"Rig number"]
[{"$f":"ATAN(BsBase/BsHt)*180/PI()","v":16.574007756908987},"deg","Backstay angle wrt mast",null,null,null,null,1,null,"Coef lift",null,null,1,null,1,2,3]
[3.5,"lb","Backstay tension",null,null,null,null,0.4,null,"Coef drag",null,null,2,"BS ht",1680,1260,960,null,"mm"]
[{"$f":"SIN(BsAngle*PI()/180)*BsTens","v":0.9983875817096628},"lb","Horizontal component",null,null,null,null,20,"ft/s","Wind speed",null,null,3,"Hounds",220,160,120,null,"mm"]
[{"$f":"COS(BsAngle*PI()/180)*BsTens","v":3.3545822745444673},"lb","Vertical component",null,null,null,null,30,"deg","Apparent wind",null,null,4,"Shrouds ht",1160,900,740,null,"mm"]
[{"$f":"HLOOKUP(RigNumber,DefaultTable,3)","v":220},"mm","JS point to top of mast",null,null,null,null,{"$f":"JibArea*Density*CoefLift*WindSpeed*WindSpeed","v":1.291669250005167},"lb","Jib lift",null,null,5,"Jib boom",385,350,305,null,"mm"]
[{"$f":"BsHt-HoundsHt","v":1460},"mm","Deck to JS point",null,null,null,null,{"$f":"JibArea*Density*CoefDrag*WindSpeed*WindSpeed","v":0.51666770000206674},"lb","Jib drag",null,null,6,"Jib area",{"$f":"2500/(25.4*25.4*1.2*1.2)","v":2.6909776041774309},{"$f":"1650/(25.4*25.4*1.2*1.2)","v":1.7760452187571045},{"$f":"1050/(25.4*25.4*1.2*1.2)","v":1.130210593754521},null,"sq.ft"]
[{"$f":"HLOOKUP(RigNumber,DefaultTable,4)","v":1160},"mm","Deck to shroud point",null,null,null,null,{"$f":"JibLift*COS(AppWindAngle*PI()/180)+JibDrag*SIN(AppWindAngle*PI()/180)","v":1.3769522337927012},"lb","Jib side force",null,null,7,"Sail CE",2.2999999999999998,2,1.8,null,"ft"]
[0,"mm","Chainplate offset",null,null,null,null,{"$f":"JibLift*SIN(AppWindAngle*PI()/180)-JibDrag*COS(AppWindAngle*PI()/180)","v":0.19838727148591628},"lb","Jib drive force",null,null,8,"JS length",1420,1080,840,null,"mm"]
[{"$f":"ATAN(ShOffset/ShHt)*180/PI()","v":0},"deg","Shroud angle wrt mast",null,null,null,null,{"$f":"SQRT(JibLift*JibLift+JibDrag+JibDrag)","v":1.6436985281410468},"lb","Tot jib force",null,null,9,"Wind start",1,8,15,null,"ft/s"]
[8,"lb","Shroud tension, each",null,null,null,null,5.5,"lb","Bulb wt",null,null,10,"Pivot start",50,40,30,null,"mm"]
[{"$f":"180*ATAN(HLOOKUP(RigNumber,DefaultTable,21)/(2*ShHt))/PI()","v":6.8817236306369498},"deg","Shroud base angle",null,null,null,null,1.3,"ft","Draught",null,null,11,"Default pivot",72.5,62.5,55,null,"mm"]
[{"$f":"SIN(ShAngle*PI()/180)*2*ShTens*COS(PI()*ShBaseAngle/180)","v":0},"lb","Shroud horiz component",null,null,null,null,{"$f":"HLOOKUP(RigNumber,DefaultTable,7)","v":2.2999999999999998},"ft","Sail CE height",null,null,12,"Default wind",14.5,18.5,25,null,"ft/s"]
[{"$f":"COS(ShAngle*PI()/180)*2*ShTens*COS(PI()*ShBaseAngle/180)","v":15.884729808159479},"lb","Shroud vert component",null,null,null,null,{"$f":"HLOOKUP(RigNumber,DefaultTable,15)","v":0.45833333333333331},null,"Jib contribution",null,null,13,"Main area",{"$f":"3500/(25.4*25.4*1.2*1.2)","v":3.7673686458484035},{"$f":"2500/(25.4*25.4*1.2*1.2)","v":2.6909776041774309},{"$f":"1500/(25.4*25.4*1.2*1.2)","v":1.6145865625064586},null,"sq.ft"]
[{"$f":"ShTensHoriz*(ShHt)/(JibHt)","v":0},"lb","Shroud horiz at JS",null,null,null,null,{"$f":"((SailCE*JibSide)/JibContrib)/(BulbWt*Draught)","v":0.96640512784942278},null,"sin(heel)",null,null,14,"Jib ratio",{"$f":"O15/(O15+O22)","v":0.41666666666666663},{"$f":"P15/(P15+P22)","v":0.39759036144578314},{"$f":"Q15/(Q15+Q22)","v":0.41176470588235298}]
[{"$f":"BsTensHoriz*BsHt/(JibHt)","v":1.1488295460768723},"lb","BS horiz at JS",null,null,null,null,{"$f":"IF(SinHeel>0.7,NA(),ASIN(SinHeel)*180/PI())","v":{"$error":"#N/A"}},"deg","Estimated heel",null,null,15,"Jib contrib",{"$f":"O23*(1+JibContribFactor)","v":0.45833333333333331},{"$f":"P23*(1+JibContribFactor)","v":0.43734939759036151},{"$f":"Q23*(1+JibContribFactor)","v":0.45294117647058829}]
[{"$f":"HLOOKUP(RigNumber,DefaultTable,5)","v":385},"mm","Jib tack to TL point",null,null,null,null,0.1,null,"Jib contrib factor",null,null,16,"Modulus",20000,20000,20000]
[72.5,"mm","Pivot offset",null,null,null,null,null,null,null,null,null,17,"Jib leech",1250,910,660,null,"mm"]
[{"$f":"JibBoom-PivotOffset","v":312.5},"mm","Jib forces triangle base",null,null,null,null,null,null,null,null,null,18,"Mid-leech gap",35,31,28,null,"mm"]
[{"$f":"ATAN(JibBase/JibHt)*180/PI()","v":12.081356123096},"deg","Jib tension angle",null,null,null,null,null,null,"Tensions vs pivot offset",null,null,19,"Jib draft",0.08,7.0000000000000007E-2,0.06]
[{"$f":"(HoundsShHoriz+HoundsBsHoriz)/SIN(JibAngle*PI()/180)","v":5.4889031920649032},"lb","Jib force from BS & Sh horiz",null,null,null,null,null,null,{"$f":"HLOOKUP(RigNumber,DefaultTable,12)","v":14.5},"default wind speed",null,20,"Jib luff allowance",3,2,1,null,"mm"]
[{"$f":"COS(JibAngle*PI()/180)*JibTensHoriz","v":5.3673316392711463},"lb","Vert jib force",null,null,null,null,null,null,"Tensions vs wind speed",null,null,21,"Beam",280,280,280,null,"mm"]
[{"$f":"JibTensHoriz*JibBase/JibBoom","v":4.4552785649877462},"lb","JS share of jib forces",null,null,null,null,null,null,{"$f":"HLOOKUP(RigNumber,DefaultTable,11)","v":72.5},"default pivot offset",null,22,"Max draft posn",0.4,0.4,0.4]
[{"$f":"JibTensHoriz*PivotOffset/JibBoom","v":1.033624627077157},"lb","TL share of jib force",null,null,null,null,null,null,"Heel graph",null,null,null,null,null,null,"Draw all graphs"]
[{"$f":"JibTensVert+ShTensVert+BsTensVert","v":24.606643721975093},"lb","Mast compression",null,null,null,null,null,null,{"$f":"DefaultPivotOffset","v":72.5},"default pivot offset",null,null,null,null,null,"(Recommended)"]
[null,null,"(These tensions are static values)"]
[]
[]
[]
[null,null,null,"Working area for \"Pivot\" macro",null,null,null,null,null,null,null,"Working area for \"Wind\" & \"Heel\" macro"]
[null,"Pivot offset",null,"TL","JS",null,null,null,null,null,null,null,"Wind","Heel","TL","JS"]
[null,null,null,{"$f":"RevTlTens","v":0},{"$f":"RevJsTens","v":15.310639205000887},null,null,null,null,null,null,null,{"$f":"WindSpeed","v":20},{"$f":"H24","v":{"$error":"#N/A"}},{"$f":"RevTlTens","v":0},{"$f":"RevJsTens","v":15.310639205000887}]
[5,{"$f":"HLOOKUP(RigNumber,DefaultTable,10)","v":50},null,0,12.165648979781514,null,null,null,null,null,null,1,{"$f":"HLOOKUP(RigNumber,DefaultTable,9)","v":1},0.13842747248373496,0.98269559744687984,4.4901129463658869,30]
["Pivot increment",{"$f":"B41+PivotIncrem","v":55},null,0,11.719504398312063,null,null,null,null,null,null,"Wind",{"$f":"M41+WindIncrem","v":2},0.55371797046274696,0.93115416818688834,4.6981465079888407,30]
["incr.",{"$f":"B42+PivotIncrem","v":60},null,0,11.319167099699358,null,null,null,null,null,null,"incr.",{"$f":"M42+WindIncrem","v":3},1.2459442352478163,0.87840001954063018,5.0237562067499288,30]
[null,65,null,0,10.989955213111829,null,null,null,null,null,null,null,4,2.215389382338476,0.82385601378522622,5.3997218564174485,30]
[null,70,null,0,10.699229930090013,null,null,null,null,null,null,null,5,3.4627911174779662,0.7669775064854949,5.8054232555761311,30]
[null,75,null,7.5466855394401566E-2,10.576159943170675,null,null,null,null,null,null,null,6,4.9896887850569049,0.70725933701587584,6.231443378346488,30]
[null,80,null,0.16533633697213168,10.476536079948378,null,null,null,null,null,null,null,7,6.7988840424114976,0.64424029787179293,6.6750344994720834,30]
[null,85,null,0.2581125496386576,10.376909249487237,null,null,null,null,null,null,null,8,8.8950377250763744,0.57750518443441079,7.1531519383606161,30]
[null,90,null,0.35394575997325672,10.277280061165971,null,null,null,null,null,null,null,9,11.285445504170719,0.5066847504615476,7.648371627444706,30]
[null,95,null,0.45299660409681741,10.177649126218435,null,null,null,null,null,null,null,10,13.981068604682335,0.43145401943004646,8.1381801331764922,30]
[null,100,null,0.55543699716214778,10.09651069793507,null,null,null,null,null,null,null,11,16.997953744894399,0.35152943513967017,8.6644827791429293,30]
[null,105,null,0.66145114028815555,9.9944726486756945,null,null,null,null,null,null,null,12,20.359280683288361,0.26666530031720237,9.207897354095115,30]
[null,110,null,0.7712366373398305,9.8924319533763985,null,null,null,null,null,null,null,13,24.098475158268229,0.17664987766075313,9.7468733885675096,30]
[null,115,null,0.88500573579335251,9.7903892821917466,null,null,null,null,null,null,null,14,28.26423531649057,8.1301438613647692E-2,10.321354742435441,30]
[null,120,null,1.0029867080749224,9.6883453071992012,null,null,null,null,null,null,null,15,32.929241257555304,0,10.950410678498848,30]
[null,125,null,1.1254253922832802,9.6045003721196593,null,null,null,null,null,null,null,16,38.206626712779226,0,11.764273451157397,30]
[null,null,null,null,null,null,null,null,null,null,null,null,17,44.284984896570968,0,12.622436980076939,30]
[null,null,null,null,null,null,null,null,null,null,null,null,18,{"$error":"#N/A"},0,13.485600633940937,30]
[null,null,null,null,null,null,null,null,null,null,null,null,19,{"$error":"#N/A"},0,14.375739140729229,30]
[null,null,null,null,null,null,null,null,null,null,null,null,20,{"$error":"#N/A"},0,15.310639205000887,30]

{"sheet":"Tension graphs","index":1,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"ShOffset","v":0},"Shroud offset"]
[null,null,null,null,null,null,null,null,null,{"$f":"BsTens","v":3.5},"Backstay tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"ShTens","v":8},"Shroud tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"DefaultWindSpeed","v":14.5},"Wind speed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"ShOffset","v":0},"Shroud offset"]
[null,null,null,null,null,null,null,null,null,{"$f":"BsTens","v":3.5},"Backstay tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"ShTens","v":8},"Shroud tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"DefaultPivotOffset","v":72.5},"Pivot offset"]

{"sheet":"Heel graphs","index":2,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,30,"Apparent wind"]

{"sheet":"Sag graphs","index":3,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"BsTens","v":3.5},"Backstay tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"ShTens","v":8},"Shrouds tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"ShOffset","v":0},"Shrouds offset"]
[null,null,null,null,null,null,null,null,null,{"$f":"DefaultPivotOffset","v":72.5},"Pivot offset"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"BsTens","v":3.5},"Backstay tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"ShTens","v":8},"Shrouds tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"ShOffset","v":0},"Shrouds offset"]
[null,null,null,null,null,null,null,null,null,{"$f":"DefaultWindSpeed","v":14.5},"Wind speed"]

{"sheet":"Twist graphs","index":4,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"DefaultPivotOffset","v":72.5},"Pivot offset"]
[null,null,null,null,null,null,null,null,null,{"$f":"DefaultTwist","v":9.9529551683004005},"Default twist"]
[null,null,null,null,null,null,null,null,null,{"$f":"BsTens","v":3.5},"Backstay tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"ShTens","v":8},"Shrouds tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"ShOffset","v":0},"Shrouds offset"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"DefaultPivotOffset","v":72.5},"Pivot offset"]
[null,null,null,null,null,null,null,null,null,{"$f":"BsTens","v":3.5},"Backstay tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"ShTens","v":8},"Shrouds tension"]
[null,null,null,null,null,null,null,null,null,{"$f":"ShOffset","v":0},"Shrouds offset"]

{"sheet":"JS sag","index":5,"n_rows":64,"n_cols":25,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,1,2,3,4,5,6,null,"Working area for 'Sag' macros"]
["Elongation adjust factor",2,null,null,null,"Sag","Angle","Elong","Tens","Force",null,null,"Wind","Sag",null,null,"Pivot","Sag",null,null,null,null,null,"Total",{"$f":"EntryNominal+DefaultTwist","v":33.188893887914347}]
["JS length",{"$f":"HLOOKUP(RigNumber,DefaultTable,8)","v":1420},"mm",null,0.5,0.5,{"$f":"ATAN(F3/(JsLength/2))*180/PI()","v":4.0349133832011205E-2},{"$f":"ElongAdjust*(2*SQRT(F3*F3+(JsLength/2)^2)-JsLength)","v":7.0422526459879009E-4},{"$f":"JsTensStatic+JsLeverage+H3*Modulus/JsLength","v":7.0948261145823981},{"$f":"I3*SIN(2*G3*PI()/180)","v":9.992707881722936E-3},{"$f":"F3","v":0.5},"Draft",null,"Sag","Twist","Entry",null,"Sag",null,"Draft",null,null,null,"entry",{"$f":"VLOOKUP(DefaultWindSpeed,M5:X24,12)","v":41.212683044648948}]
["Modulus",{"$f":"HLOOKUP(RigNumber,DefaultTable,16)","v":20000},null,null,null,{"$f":"SagStart+SagIncrement","v":1},{"$f":"ATAN(F4/(JsLength/2))*180/PI()","v":8.0698227643113407E-2},{"$f":"ElongAdjust*(2*SQRT(F4*F4+(JsLength/2)^2)-JsLength)","v":2.8169000115667586E-3},{"$f":"JsTensStatic+JsLeverage+H4*Modulus/JsLength","v":7.1245820969340601},{"$f":"I4*SIN(2*G4*PI()/180)","v":2.0069205531523179E-2},{"$f":"F4","v":1},{"$f":"DraftInterp","v":0.11995560871217423},null,{"$f":"JsSagTotal","v":14.901724119190613},{"$f":"MidLeechTwist","v":8.8736787831954427},{"$f":"EntryInterp","v":35.48537689875441},null,{"$f":"JsSagTotal","v":14.901724119190613},null,{"$f":"DraftInterp","v":0.11995560871217423},{"$f":"NominalDraft","v":0.08},{"$f":"DefaultTwist","v":9.9529551683004005},{"$f":"'Sag draft'!G7","v":23.235938719613948},{"$f":"X5","v":24.830176110750749}]
["Jib lever wrt boom",1,null,null,null,{"$f":"F4+SagIncrement","v":1.5},0.1210472414126357,6.3380210967807216E-3,7.174175351655383,3.0313281678520501E-2,1.5,5.2304431807440342E-2,{"$f":"Tensions!M41","v":1},1.6079996687620466,9.7590760851414746,15.071100025609272,{"$f":"Tensions!B41","v":50},12.231646248897441,null,0.11209559665192152,{"$f":"$U$4","v":0.08},{"$f":"$V$4","v":9.9529551683004005},{"$f":"$W$4","v":23.235938719613948},{"$f":"P5+O5","v":24.830176110750749}]
["Jib sag force distribn",{"$f":"0.5*JibBase/JibBoom","v":0.40584415584415584},null,null,null,{"$f":"F5+SagIncrement","v":2},0.1613961351203837,1.1267583282005944E-2,7.2436058049684142,4.0808722974049597E-2,2,6.5871693246424945E-2,{"$f":"Tensions!M42","v":2},3.0571532828971568,9.5843699376910081,19.046093463330568,{"$f":"Tensions!B42","v":55},12.494319590418845,null,0.11310349898070642,{"$f":"$U$4","v":0.08},{"$f":"$V$4","v":9.9529551683004005},{"$f":"$W$4","v":23.235938719613948},{"$f":"P6+O6","v":28.630463401021576}]
["Jib sag force on JS",{"$f":"SagDistrib*TotJib","v":0.66708544161568462},"lb",null,null,2.5,0.20174486874687728,1.7605579233077151E-2,7.3328733535750512,5.1639312952758337E-2,2.5,7.5224914508200014E-2,{"$f":"Tensions!M43","v":3},4.303361867067335,9.3611384820061954,21.813366756015228,{"$f":"Tensions!B43","v":60},12.696232721734743,null,0.11387825866544192,0.08,9.9529551683004005,23.235938719613948,31.174505238021425]
["Leverage at TL",{"$f":"TotJib*(((JibLever*JibBoom)-PivotOffset)/JibBase)","v":1.6436985281410468},"lb",null,null,3,0.24209340227358911,2.5351999520353274E-2,7.4419778646634471,6.2888830993825307E-2,3,8.2113513654441014E-2,{"$f":"Tensions!M44","v":4},5.3861876541298557,9.1529684699593652,23.867064346022076,{"$f":"Tensions!B44","v":65},12.859733918703684,null,0.11450562814355351,0.08,9.9529551683004005,23.235938719613948,33.020032815981438]
["TL releases at jib force",{"$f":"TlTensStatic*JibBase/((JibLever*JibBoom)-PivotOffset)","v":1.033624627077157},"lb",null,null,3.5,0.28244169568318273,3.4506832619626948E-2,7.5709191759208228,7.4641051282381035E-2,3.5,8.7469611915070883E-2,{"$f":"Tensions!M45","v":5},6.3424770580258043,8.9615527950098013,25.475593957162197,{"$f":"Tensions!B45","v":70},12.991431612301263,null,0.11501096458654303,0.08,9.9529551683004005,23.235938719613948,34.437146752171998]
["Leverage at JS",{"$f":"IF(TotJib>TlRelForce,(TotJib-TlRelForce)*(((JibLever*JibBoom)-PivotOffset)/PivotOffset),0)","v":2.6296288838960771},"lb","after release",null,4,0.32278970895975034,4.5070064910305518E-2,7.7196970955078452,8.6979741770712618E-2,4,9.1920312617168723E-2,{"$f":"Tensions!M46","v":6},7.2082209642337434,8.7839909705702528,26.819453484300958,{"$f":"Tensions!B46","v":75},12.924620184458142,null,0.114754602851003,0.08,9.9529551683004005,23.235938719613948,35.603444454871209]
["JS stretch due to lever",{"$f":"JsLeverage*JsLength/Modulus","v":0.18670365075662149},"mm","after release",null,4.5,0.36313740208905138,5.7041680677230033E-2,7.8883114020842466,9.998866314003127E-2,4.5,9.5728346169464601E-2,{"$f":"Tensions!M47","v":7},8.0121476170635297,8.6156307368648974,27.976317754422745,{"$f":"Tensions!B47","v":80},12.829172772183627,null,0.11438836214857477,0.08,9.9529551683004005,23.235938719613948,36.591948491287638]
["TL release due to lever",{"$f":"JsStretch*JibBase/PivotOffset","v":0.80475711533026506},"mm","after release",null,5,0.40348473505875015,7.0421662110675243E-2,8.0767618448088268,0.11375156776224682,5,9.9047337899098503E-2,{"$f":"Tensions!M48","v":8},8.7572665249807784,8.4565903775733844,28.989332325343511,{"$f":"Tensions!B48","v":85},12.733675049152342,null,0.11402192839903857,0.08,9.9529551683004005,23.235938719613948,37.445922702916896]
["(First cut est)",{"$f":"VLOOKUP(SagForce,SagForceTable,2)+SagIncrement","v":15},"mm",null,null,5.5,0.44383166785865424,8.5209989305894851E-2,8.2850481433330465,0.12835219866181624,5.5,0.10210254398969824,{"$f":"Tensions!M49","v":9},9.4721686742738633,8.3024713593952928,29.924793965708268,{"$f":"Tensions!B49","v":90},12.638127520992807,null,0.11365530354253867,0.08,9.9529551683004005,23.235938719613948,38.227265325103559]
["JS sag (total)",{"$f":"VLOOKUP(SagForce,SagForceTable,2)+SagIncrement*((SagForce-VLOOKUP(SagForce,SagForceTable,1))/(VLOOKUP(FirstCutSag,SagTable,5)-VLOOKUP(SagForce,SagForceTable,1)))","v":14.901724119190613},"mm",null,null,6,0.48417816048095236,0.10140664026312152,8.5131699878010281,0.14387428847784078,6,0.10481859750446526,{"$f":"Tensions!M50","v":10},10.15032905127075,8.1533392439087731,30.761258310400326,{"$f":"Tensions!B50","v":95},12.542530696445541,null,0.11328848953116027,0.08,9.9529551683004005,23.235938719613948,38.914597554309097]
["Revised JS tension",{"$f":"IF(FirstCutSag>=SagTableMaxSag,NA(),VLOOKUP(JsSagTotal,SagTensTable,4)+((FirstCutSag-JsSagTotal)/SagIncrement)*(VLOOKUP(JsSagTotal,SagTensTable,4)-VLOOKUP(FirstCutSag,SagTensTable,4)))","v":15.310639205000887},"lb","(dynamic)",null,6.5,0.52452417292045239,0.11901159088756685,8.7611270388495548,0.16040155842637946,6.5,0.10736863355830338,{"$f":"Tensions!M51","v":11},10.806909006206149,8.0082657342042882,31.548778460887643,{"$f":"Tensions!B51","v":100},12.443344740784356,null,0.11290790368596321,0.08,9.9529551683004005,23.235938719613948,39.557044195091933]
["Revised TL tension",{"$f":"IF(TlLeverForce>TlTensStatic,0,TlTensStatic-TlLeverForce)","v":0},"lb","(dynamic)",null,7,0.56486966517481896,0.13802481499124042,9.0289189276336881,0.17801771726350515,7,0.10973710500791418,{"$f":"Tensions!M52","v":12},11.446527359508982,7.865084396817922,32.283610577960111,{"$f":"Tensions!B52","v":105},12.341271175043673,null,0.11251623780916914,0.08,9.9529551683004005,23.235938719613948,40.148694974778032]
["Total TL lift",{"$f":"DefaultLift+TlRelDist","v":2.7669298282061137},"mm",null,null,7.5,0.60521459724481175,0.15844628429158547,9.3165452558075632,0.1968064602478905,7.5,0.1119648127036383,{"$f":"Tensions!M53","v":13},12.06666731531066,7.7249803142335383,32.976599818408324,{"$f":"Tensions!B53","v":110},12.239145085902514,null,0.11212437039514501,0.08,9.9529551683004005,23.235938719613948,40.701580132641865]
["Total entry angle",43.746391911943405,"deg",null,null,8,0.64555892913452373,0.18027596841102422,9.6240055955179677,0.21685146810379979,8,0.11404027547238448,{"$f":"Tensions!M54","v":14},12.671184461350204,7.5871301913090434,33.625552853339904,{"$f":"Tensions!B54","v":115},12.136967068956654,null,0.11173230372924789,0.08,9.9529551683004005,23.235938719613948,41.212683044648948]
["Jib luff allowance",{"$f":"HLOOKUP(RigNumber,DefaultTable,20)","v":3},"mm",null,null,8.5,0.68590262085161746,0.20351383488014108,9.9512994894491911,0.23823640598555693,8.5,0.1158909413765068,{"$f":"Tensions!M55","v":15},13.220765782170407,7.5248740296365977,34.204216693139891,{"$f":"Tensions!B55","v":120},12.034737723185319,null,0.11134004010981741,0.08,9.9529551683004005,23.235938719613948,41.72909072277649]
["JS sag (into draft)",{"$f":"JsSagTotal*COS(PI()*JsSagAngle/180)-LuffAllow*COS(PI()*JsSagAngle/180)","v":8.5978948534019199},"mm",null,null,9,0.72624563240756523,0.22815984913449938,10.29842645077818,0.26104492244044336,9,0.11687396593725941,{"$f":"Tensions!M56","v":16},13.574517446274678,7.7712030700529526,34.513908546112106,{"$f":"Tensions!B56","v":125},11.92783674117115,null,0.11091543850575901,0.08,9.9529551683004005,23.235938719613948,42.285111616165061]
["JS sag (into twist)",{"$f":"JsSagTotal*SIN(PI()*JsSagAngle/180)","v":10.304058890605354},"mm",null,null,9.5,0.76658792381788365,0.25421397451691519,10.665385963206573,0.28536064837361824,9.5,0.11758496399132083,{"$f":"Tensions!M57","v":17},13.917894435101889,8.0344656038896307,34.738046176188334,null,null,null,null,0.08,9.9529551683004005,23.235938719613948,42.772511780077963]
["Mid-leech twist (TL)",{"$f":"MidLeechTwist","v":8.8736787831954427},"deg",null,null,10,0.80692945510237435,0.28167617227700248,11.052177480954281,0.31126719601259578,10,0.11828631137857754,{"$f":"Tensions!M58","v":18},14.251833330538242,8.3138119732154809,34.959141494722488,null,null,null,null,0.08,9.9529551683004005,23.235938719613948,43.272953467937967]
[null,null,null,null,null,10.5,0.84727018628535977,0.31054640157253743,11.458800428778718,0.3388481578728133,10.5,0.1189311398971227,{"$f":"Tensions!M59","v":19},14.581350369626627,8.5839723138186947,35.162419598124707,null,null,null,null,0.08,9.9529551683004005,23.235938719613948,43.746391911943405]
[null,null,null,null,null,11,0.8876100773959209,0.34082461946809417,11.885254201955572,0.36818710572258206,11,0.11952786558974367,{"$f":"Tensions!M60","v":20},14.901724119190613,8.8736787831954427,35.350533590540927,null,null,null,null,0.08,9.9529551683004005,23.235938719613948,44.224212373736371]
[null,null,null,null,null,11.5,0.92794908846813484,0.37251078093640899,12.331538166298035,0.39936758954955154,11.5]
[null,null,null,null,null,12,0.96828717954131283,0.40560483885838039,12.797651658156788,0.43247313652714092,12]
[null,null,null,null,null,12.5,1.0086243106602359,0.44010674402352379,13.283593984426412,0.46758724998166862,12.5]
[null,null,null,null,null,13,1.0489604418753939,0.47601644513088104,13.789364422558204,0.50479340836026887,13]
[null,{"$f":"DefaultPivotOffset","v":72.5},null,null,null,13.5,1.0892955332432213,0.51333388878856567,14.314962220553763,0.54417506419870132,13.5]
["Draw JS sag vs wind graph",null,null,null,null,14,1.1296295448263352,0.55205901951376291,14.860386596964991,0.58581564308989975,14]
[null,null,null,null,null,14.5,1.1699624366937704,0.59219177973500337,15.425636740926125,0.62979854265438573,14.5]
[null,null,null,null,null,15,1.2102941689212194,0.63373210979079886,16.01071181213451,0.67620713150937406,15]
[null,{"$f":"DefaultWindSpeed","v":14.5},null,null,null,15.5,1.2506247015912662,0.67667994793100661,16.615610940869832,0.72512474823999273,15.5]
["Draw JS sag vs pivot offset",null,null,null,null,16,1.2909539947936242,0.72103523031637451,17.240333227987691,{"$f":"I34*SIN(2*G34*PI()/180)","v":0.77663470037013604},{"$f":"F34","v":16}]
[null,null,null,null,null,16.5,1.3312820086253725,0.76679789101990536,17.884877744938827,0.83082026333509984,16.5]
[null,null,null,null,null,17,1.3716087031911925,0.81396786202822113,18.549243533788349,0.88776467945504511,17]
[null,{"$f":"DefaultPivotOffset","v":72.5},null,null,null,17.5,1.4119340386036046,0.86254507323883445,19.233429607177264,0.94755115690647174,17.5]
["Draw mid-leech twist vs wind graph",null,null,null,null,18,1.452257974983203,0.91252945246469608,19.937434948386585,1.0102628686992712,18]
[null,null,null,null,null,18.5,1.4925804724588929,0.96392092543146646,20.661258511298843,1.0759829516497095,18.5]
[null,null,null,null,null,19,1.5329014911681267,1.0167194157797894,21.404899220430153,1.1447945053576103,19]
[null,null,null,null,null,19.5,1.5732209912571391,1.0709248450662017,22.168355970943004,{"$f":"I41*SIN(2*G41*PI()/180)","v":1.2167805911835237},{"$f":"F41","v":19.5}]
[null,null,null,null,null,20,1.6135389328811822,1.1265371327622233,22.951627628633446,1.2920242312253516,20]
[null,null,null,null,null,20.5,1.6538552762047631,1.1835561962552674,23.754713029943929,1.3706084072971658,20.5]
[null,null,null,null,null,21,1.6941699814018769,1.2419819508509136,24.577610981995285,1.4526160599100955,21]
[null,null,null,null,null,21.5,1.7344830086562442,1.3018143097715438,25.420320262567536,1.5381300872512498,21.5]
[null,null,null,null,null,22,1.7747943181615446,1.3630531841581615,26.282839620125536,1.6272333441661284,22]
[null,null,null,null,null,22.5,1.8151038701216524,1.4256984830694819,27.165167773806104,1.7200086411397106,22.5]
[null,null,null,null,null,23,1.8554116247508714,1.4897501134860249,28.067303413475727,1.8165387432829214,23]
[null,null,null,null,null,23.5,1.895717542274169,1.5552079803060224,28.989245199672872,1.9169063693128956,23.5]
[null,null,null,null,null,24,1.9360215829274119,1.62207198635042,29.93099176367847,2.0211941905423725,24]
[null,null,null,null,null,24.5,1.9763237069575992,1.6903420323615137,30.89254170749669,2.1294848298644786,24.5]
[null,null,null,null,null,25,2.016623874623098,1.7600180170034037,31.87389360386134,2.2418608607401609,25]
[null,null,null,null,null,25.5,2.0569220461938751,1.8310998368638138,32.875045996261484,2.3584048061880667,25.5]
[null,null,null,null,null,26,2.0972181819517339,1.9035873864545465,33.895997398947856,2.4791991377742897,26]
[null,null,null,null,null,26.5,2.1375122421905455,1.9774805582114823,34.936746296932867,2.6043262746027454,26.5]
[null,null,null,null,null,27,2.1778041872164833,2.0527792424968538,35.997291146022611,2.7338685823090718,27]
[null,null,null,null,null,27.5,2.218093977348258,2.1294833275983365,37.077630372804059,2.8679083720524376,27.5]
[null,null,null,null,null,28,2.258381572917346,2.207592699730867,38.177762374670685,3.0065278995113855,28]
[null,null,null,null,null,28.5,2.2986669342682271,2.2871072430384629,39.297685519848095,3.1498093638810549,28.5]
[null,null,null,null,null,29,2.3389500217586154,2.3680268395928579,40.437398147374779,3.2978349068681165,29]
[null,null,null,null,null,29.5,2.3792307957596917,2.4503513693953209,41.596898567127781,3.4506866116904567,29.5]
[null,null,null,null,null,30,{"$f":"NA()","v":{"$error":"#N/A"}},2.5340807103789302,42.776185059854676,{"$error":"#N/A"},30]
[]
[null,null,null,null,null,{"$f":"MAX(F3:F62)","v":30}]

{"sheet":"Sag draft","index":6,"n_rows":68,"n_cols":29,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Fore","Aft"]
["Nominal draft",{"$f":"HLOOKUP(RigNumber,DefaultTable,19)","v":0.08},null,null,"Entry angle calcs",null,null,null,"Exit angle calcs"]
["Max draft position",{"$f":"HLOOKUP(RigNumber,DefaultTable,22)","v":0.4},null,null,null,null,{"$f":"B3","v":0.08},null,null,null,{"$f":"B3","v":0.08}]
["First sag",{"$f":"VLOOKUP($B$3,I19:J68,2)","v":1.9333199231259215},{"$f":"VLOOKUP($B$3,W19:X68,2)","v":1.294327484783679},null,"First entry",null,{"$f":"VLOOKUP(NominalDraft,K19:O68,4)","v":22.323030979122983},null,"First exit",null,{"$f":"VLOOKUP(NominalDraft,Y19:AC68,4)","v":14.882020652748654}]
["Next sag",{"$f":"VLOOKUP($B$3,I19:L68,4)","v":2.197388534481135},{"$f":"VLOOKUP($B$3,W19:Z68,4)","v":1.4719726607206951},null,"Next entry",null,{"$f":"VLOOKUP(NominalDraft,K19:O68,5)","v":23.811233044397852},null,"Next exit",null,{"$f":"VLOOKUP(NominalDraft,Y19:AC68,5)","v":15.8741553629319}]
["Nominal sag",{"$f":"B5+(B6-B5)*($B$3-VLOOKUP($B$3,K19:M68,1))/(VLOOKUP($B$3,K19:M68,3)-VLOOKUP($B$3,K19:M68,1))","v":2.0953075220897417},{"$f":"C5+(C6-C5)*($B$3-VLOOKUP($B$3,Y19:AA68,1))/(VLOOKUP($B$3,Y19:AA68,3)-VLOOKUP($B$3,Y19:AA68,1))","v":1.3819043875148702},null,"Nominal entry",null,{"$f":"G5+((G6-G5)*(G4-VLOOKUP(G4,K19:O68,1))/(VLOOKUP(G4,K19:O68,3)-VLOOKUP(G4,K19:O68,1)))","v":23.235938719613948},null,"Nominal exit",null,{"$f":"K5+((K6-K5)*(K4-VLOOKUP(K4,Y19:AC68,1))/(VLOOKUP(K4,Y19:AC68,3)-VLOOKUP(K4,Y19:AC68,1)))","v":15.371130951137859}]
["Additnl sag",{"$f":"JsSagDraft","v":8.5978948534019199}]
["Total sag",{"$f":"B8+B7+C7","v":12.075106763006533}]
["Sag distrib (approx)",{"$f":"B9*MaxDraft","v":4.8300427052026134},{"$f":"B9*(1-MaxDraft)","v":7.2450640578039192},null,null,null,{"$f":"DraftInterp","v":0.11995560871217423},null,null,null,{"$f":"DraftInterp","v":0.11995560871217423}]
["First draft",{"$f":"VLOOKUP(B10,J19:K68,2)","v":0.1159690752784424},null,null,"First entry",null,{"$f":"VLOOKUP(G10,K19:O68,4)","v":34.228647501321909},null,"First exit",null,{"$f":"VLOOKUP(K10,Y19:AC68,4)","v":22.819098334214605}]
["Next draft",{"$f":"VLOOKUP(B10,J19:M68,4)","v":0.12068987460205784},null,null,"Next entry",null,{"$f":"VLOOKUP(G10,K19:O68,5)","v":35.716849566596771},null,"Next exit",null,{"$f":"VLOOKUP(K10,Y19:AC68,5)","v":23.811233044397852}]
["Interpolated draft",{"$f":"(B11+(B12-B11)*(B10-VLOOKUP(B10,J19:M68,1))/(VLOOKUP(B10,J19:M68,3)-VLOOKUP(B10,J19:M68,1)))","v":0.11995560871217423},null,null,"Interpolated",null,{"$f":"G11+((G12-G11)*(G10-VLOOKUP(G10,K19:O68,1))/(VLOOKUP(G10,K19:O68,3)-VLOOKUP(G10,K19:O68,1)))","v":35.48537689875441},null,"Interpolated",null,{"$f":"K11+((K12-K11)*(K10-VLOOKUP(K10,Y19:AC68,1))/(VLOOKUP(K10,Y19:AC68,3)-VLOOKUP(K10,Y19:AC68,1)))","v":23.226586289822983}]
[]
[]
["Width at mid-leech",{"$f":"JibBoom/2","v":192.5},"(Full chord)",null,null,null,"Portion of jib forward of max draft position",null,null,null,null,null,null,null,null,null,null,null,null,null,"Portion of jib aft of max draft position"]
["Chord at mid-leech",{"$f":"JibBoom*MaxDraft/2","v":77},"(Forward of sail max draft)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"JibBoom*(1-MaxDraft)/2","v":115.5},"(Aft of sail max draft)"]
[null,"d","Approx r","Theta (radians)","Theta (degrees)","Half chord","r-d","d","% draft","sag",{"$f":"I18","v":"% draft"},"next sag","next draft","Entry","Next entry","d","Approx r","Theta (radians)","Theta (degrees)","Half chord","r-d","d","% draft","sag",{"$f":"W18","v":"% draft"},"next sag","next draft","Exit","Next exit"]
[1,1,{"$f":"$B$17^2/(2*B19)","v":2964.5},{"$f":"$B$17/C19","v":2.5974025974025976E-2},{"$f":"D19*180/PI()","v":1.4882020652748658},{"$f":"C19*SIN(D19)","v":76.991342283393593},{"$f":"C19*COS(D19)","v":2963.5000562195714},{"$f":"C19-G19","v":0.99994378042856624},{"$f":"H19/$B$16","v":5.1945131450834613E-3},{"$f":"($B$17-F19)","v":8.6577166064074618E-3},{"$f":"I19","v":5.1945131450834613E-3},{"$f":"J20","v":3.4627362031656617E-2},{"$f":"K20","v":1.0387274149467307E-2},{"$f":"E19","v":1.4882020652748658},{"$f":"E20","v":2.9764041305497315},1,{"$f":"$P$17^2/(2*P19)","v":6670.125},{"$f":"$P$17/Q19","v":1.7316017316017316E-2},{"$f":"R19*180/PI()","v":0.99213471018324373},{"$f":"Q19*SIN(R19)","v":115.49422808076258},{"$f":"Q19*COS(R19)","v":6669.125024986788},{"$f":"Q19-U19","v":0.99997501321195159},{"$f":"V19/$B$16","v":5.1946753933088397E-3},{"$f":"($P$17-T19)","v":5.7719192374179329E-3},{"$f":"W19","v":5.1946753933088397E-3},{"$f":"X20","v":2.3086638564407735E-2},{"$f":"Y20","v":1.0388572008765527E-2},{"$f":"S19","v":0.99213471018324373},{"$f":"S20","v":1.9842694203664875}]
[null,{"$f":"B19+$A$19","v":2},1482.25,5.1948051948051951E-2,{"$f":"D20*180/PI()","v":2.9764041305497315},{"$f":"C20*SIN(D20)","v":76.965372637968343},{"$f":"C20*COS(D20)","v":1480.2504497262275},{"$f":"C20-G20","v":1.9995502737724564},{"$f":"H20/$B$16","v":1.0387274149467307E-2},{"$f":"($B$17-F20)","v":3.4627362031656617E-2},1.0387274149467307E-2,{"$f":"J21","v":7.7898424782446796E-2},1.5576531660455846E-2,{"$f":"E20","v":2.9764041305497315},{"$f":"E21","v":4.4646061958245964},{"$f":"P19+$A$19","v":2},{"$f":"$P$17^2/(2*P20)","v":3335.0625},{"$f":"$P$17/Q20","v":3.4632034632034632E-2},{"$f":"R20*180/PI()","v":1.9842694203664875},{"$f":"Q20*SIN(R20)","v":115.47691336143559},{"$f":"Q20*COS(R20)","v":3333.0626998883126},{"$f":"Q20-U20","v":1.9998001116873638},{"$f":"V20/$B$16","v":1.0388572008765527E-2},{"$f":"($P$17-T20)","v":2.3086638564407735E-2},{"$f":"W20","v":1.0388572008765527E-2},{"$f":"X21","v":5.194104304747782E-2},{"$f":"Y21","v":1.5580911224202141E-2},{"$f":"S20","v":1.9842694203664875},{"$f":"S21","v":2.9764041305497315}]
[null,3,988.16666666666663,7.792207792207792E-2,4.4646061958245964,76.922101575217553,985.16818432202888,2.9984823446377504,1.5576531660455846E-2,7.7898424782446796E-2,1.5576531660455846E-2,0.13845339133119694,2.0760535900979732E-2,4.4646061958245964,5.952808261099463,{"$f":"P20+$A$19","v":3},{"$f":"$P$17^2/(2*P21)","v":2223.375},{"$f":"$P$17/Q21","v":5.1948051948051951E-2},{"$f":"R21*180/PI()","v":2.9764041305497315},{"$f":"Q21*SIN(R21)","v":115.44805895695252},{"$f":"Q21*COS(R21)","v":2220.3756745893411},{"$f":"Q21-U21","v":2.999325410658912},1.5580911224202141E-2,5.194104304747782E-2,{"$f":"W21","v":1.5580911224202141E-2},{"$f":"X22","v":9.2329941872094423E-2},{"$f":"Y22","v":2.0770914728738907E-2},{"$f":"S21","v":2.9764041305497315},{"$f":"S22","v":3.9685388407329749}]
[null,4,741.125,0.1038961038961039,5.952808261099463,76.861546608668803,737.1285968390614,3.9964031609385984,2.0760535900979732E-2,0.13845339133119694,2.0760535900979732E-2,0.21626775455503378,2.5937539456405131E-2,5.952808261099463,7.4410103263743279,4,1667.53125,6.9264069264069264E-2,3.9685388407329749,115.40767005812791,1663.5328489147178,3.9984010852822394,2.0770914728738907E-2,9.2329941872094423E-2,2.0770914728738907E-2,0.1442460694542973,2.5957804678384561E-2,3.9685388407329749,4.9606735509162183]
[null,5,592.9,0.12987012987012989,7.4410103263743279,76.783732245444966,587.90702365464199,4.9929763453579881,2.5937539456405131E-2,0.21626775455503378,2.5937539456405131E-2,0.31131002554384679,3.1105798060152311E-2,7.4410103263743279,8.9292123916491928,5,1334.0250000000001,8.6580086580086577E-2,4.9606735509162183,115.3557539305457,1329.0281225994111,4.9968774005890282,2.5957804678384561E-2,0.1442460694542973,2.5957804678384561E-2,0.20768008699680252,3.1140803851470188E-2,4.9606735509162183,5.952808261099463]
[null,6,494.08333333333331,0.15584415584415584,8.9292123916491928,76.688689974456153,488.09546720675399,5.9878661265793198,3.1105798060152311E-2,0.31131002554384679,3.1105798060152311E-2,0.42354174877164041,3.6263571377723458E-2,8.9292123916491928,10.417414456924059,6,1111.6875,0.1038961038961039,5.952808261099463,115.2923199130032,1105.692895258592,5.9946047414080113,3.1140803851470188E-2,0.20768008699680252,3.1140803851470188E-2,0.28262058448892446,3.6319135803989128E-2,5.952808261099463,6.9449429712827069]
[null,7,423.5,0.18181818181818182,10.417414456924059,76.57645825122836,416.51926250978823,6.9807374902117658,3.6263571377723458E-2,0.42354174877164041,3.6263571377723458E-2,0.55291752062318267,4.1409123788740287E-2,10.417414456924059,11.905616522198926,7,952.875,0.12121212121212122,6.9449429712827069,115.21737941551108,945.88356635773209,6.9914336422679071,3.6319135803989128E-2,0.28262058448892446,3.6319135803989128E-2,0.36905408315000443,4.1492025024732572E-2,6.9449429712827069,7.9370776814659498]
[null,8,370.5625,0.20779220779220781,11.905616522198926,76.447082479376817,362.5912436706675,7.9712563293325047,4.1409123788740287E-2,0.55291752062318267,4.1409123788740287E-2,0.69938501126587482,4.6540725166595347E-2,11.905616522198926,13.393818587473788,8,833.765625,0.13852813852813853,7.9370776814659498,115.13094591685,825.77841018273898,7.9872148172610196,4.1492025024732572E-2,0.36905408315000443,4.1492025024732572E-2,0.46696503831576308,4.665869709022847E-2,7.9370776814659498,8.9292123916491928]
[null,9,329.38888888888891,0.23376623376623376,13.393818587473788,76.300614988734125,320.42979929431931,8.9590895945696047,4.6540725166595347E-2,0.69938501126587482,4.6540725166595347E-2,0.86288498985577178,5.1656651655325611E-2,13.393818587473788,14.882020652748656,9,741.125,0.15584415584415584,8.9292123916491928,115.03303496168424,732.14320081013102,8.9817991898689797,4.665869709022847E-2,0.46696503831576308,4.665869709022847E-2,0.57633584276696581,5.1818378819434185E-2,8.9292123916491928,9.9213471018324366]
[null,10,296.45,0.25974025974025977,14.882020652748656,76.137115010144228,286.50609455634981,9.9439054436501806,5.1656651655325611E-2,0.86288498985577178,5.1656651655325611E-2,1.0433513530644234,5.6755186443315737E-2,14.882020652748656,16.37022271802352,10,667.01250000000005,0.17316017316017315,9.9213471018324366,114.92366415723303,657.03746207725897,9.9750379227410804,5.1818378819434185E-2,0.57633584276696581,5.1818378819434185E-2,0.69714683049946302,5.6970298428148616E-2,9.9213471018324366,10.91348181201568]
[null,11,269.5,0.2857142857142857,16.37022271802352,75.956648646935577,258.57462660966172,10.925373390338279,5.6755186443315737E-2,1.0433513530644234,5.6755186443315737E-2,1.2407111569112743,6.1834620533437086E-2,16.37022271802352,17.858424783298386,11,606.375,0.19047619047619047,10.91348181201568,114.80285316950054,595.40821755258139,10.966782447418609,5.6970298428148616E-2,0.69714683049946302,5.6970298428148616E-2,0.82937628093478111,6.2113685683110723E-2,10.91348181201568,11.905616522198926]
[null,12,247.04166666666666,0.31168831168831168,17.858424783298386,75.759288843088726,235.13850221398002,11.903164452686639,6.1834620533437086E-2,1.2407111569112743,6.1834620533437086E-2,1.454884651885493,6.689325350923514E-2,17.858424783298386,19.346626848573251,12,555.84375,0.20779220779220781,11.905616522198926,114.67062371906522,543.88686550600119,11.956884493998814,6.2113685683110723E-2,0.82937628093478111,6.2113685683110723E-2,0.97300042357052519,6.7247772055747806E-2,11.905616522198926,12.89775123238217]
[null,13,228.03846153846155,0.33766233766233766,19.346626848573251,75.545115348114507,215.16151023793378,12.876951300527764,6.689325350923514E-2,1.454884651885493,6.689325350923514E-2,1.6857853213383152,7.1929394296780011E-2,19.346626848573251,20.834828913848117,13,513.08653846153845,0.22510822510822512,12.89775123238217,114.52699957642947,500.141342340807,12.945196120731453,6.7247772055747806E-2,0.97300042357052519,6.7247772055747806E-2,1.1279934430690588,7.2371790875544406E-2,12.89775123238217,13.889885942565414]
[null,14,211.75,0.36363636363636365,20.834828913848117,75.314214678661685,197.90359159786985,13.846408402130152,7.1929394296780011E-2,1.6857853213383152,7.1929394296780011E-2,1.9333199231259215,7.6941361921791657E-2,20.834828913848117,22.323030979122983,14,476.4375,0.24242424242424243,13.889885942565414,114.37200655693094,462.5059302564577,13.931569743542298,7.2371790875544406E-2,1.1279934430690588,7.2371790875544406E-2,1.294327484783679,7.7484977482988271E-2,13.889885942565414,14.882020652748654]
[null,15,197.63333333333333,0.38961038961038963,22.323030979122983,75.066680076874079,182.82212116338843,14.811212169944895,7.6941361921791657E-2,1.9333199231259215,7.6941361921791657E-2,2.197388534481135,8.1927486261661978E-2,22.323030979122983,23.811233044397852,15,444.67500000000001,0.25974025974025972,14.882020652748654,114.20567251521632,429.75914183452477,14.915858165475242,7.7484977482988271E-2,1.294327484783679,7.7484977482988271E-2,1.4719726607206951,8.2586569382069916E-2,14.882020652748654,15.8741553629319]
[null,16,185.28125,0.41558441558441561,23.811233044397852,74.802611465518865,169.51020889463007,15.771041105369932,8.1927486261661978E-2,2.197388534481135,8.1927486261661978E-2,2.4778846000902774,8.6886108791990754E-2,23.811233044397852,25.299435109672718,16,416.8828125,0.27705627705627706,15.8741553629319,114.0280273392793,400.98489789395154,15.89791460604846,8.2586569382069916E-2,1.4719726607206951,8.2586569382069916E-2,1.6608970559363883,8.7675806392291056E-2,15.8741553629319,16.866290073115142]
[null,17,174.38235294117646,0.44155844155844159,25.299435109672718,74.522115399909723,157.65677699871824,16.725575942458221,8.6886108791990754E-2,2.4778846000902774,8.6886108791990754E-2,2.7746949833500167,9.1815583327262362E-2,25.299435109672718,26.787637174947577,17,392.36029411764707,0.29437229437229434,16.866290073115142,113.83910294406361,375.48270138713104,16.877592730516028,8.7675806392291056E-2,1.6608970559363883,8.7675806392291056E-2,1.8610667353669044,9.2751930800155702E-2,16.866290073115142,17.858424783298386]
[null,18,164.69444444444446,0.46753246753246752,26.787637174947577,74.225305016649983,147.01994465394645,17.674499790498004,9.1815583327262362E-2,2.7746949833500167,9.1815583327262362E-2,3.0877000207773904,9.6714276755287515E-2,26.787637174947577,28.275839240222446,18,370.5625,0.31168831168831168,17.858424783298386,113.6389332646331,352.70775332097003,17.854746679029972,9.2751930800155702E-2,1.8610667353669044,9.2751930800155702E-2,2.0724457510898304,9.7814187510104372E-2,17.858424783298386,18.850559493481629]
[null,19,156.02631578947367,0.49350649350649356,28.275839240222446,73.91229997922261,137.40881751408082,18.617498275392848,9.6714276755287515E-2,3.0877000207773904,9.6714276755287515E-2,3.4167735795443974,0.10158056976504094,28.275839240222446,29.764041305497312,19,351.05921052631578,0.32900432900432902,18.850559493481629,113.42755424891017,332.22997943062069,18.829231095695093,9.7814187510104372E-2,2.0724457510898304,9.7814187510104372E-2,2.2949961500157059,0.10286182419486363,18.850559493481629,19.842694203664873]
[null,20,148.22499999999999,0.51948051948051954,29.764041305497312,73.583226420455603,128.67074032022961,19.554259679770382,0.10158056976504094,3.4167735795443974,0.10158056976504094,3.761783118107104,0.10641285756753109,29.764041305497312,31.252243370772181,20,333.50625000000002,0.34632034632034631,19.842694203664873,113.20500384998429,313.70534884248877,19.800901157511248,0.10286182419486363,2.2949961500157059,0.10286182419486363,2.5286779820074798,0.10789409144517009,19.842694203664873,20.834828913848117]
[null,21,141.16666666666666,0.54545454545454553,31.252243370772181,73.238216881892896,120.68219158491692,20.484475081749736,0.10641285756753109,3.761783118107104,0.10641285756753109,4.1225897498974575,0.11120955060933471,31.252243370772181,32.74044543604704,21,317.625,0.36363636363636365,20.834828913848117,112.97132201799252,296.85538739680476,20.769612603195242,0.10789409144517009,2.5286779820074798,0.10789409144517009,2.7734493084262368,0.11291024291883935,20.834828913848117,21.826963624031361]
[null,22,134.75,0.5714285714285714,32.74044543604704,72.877410250102542,113.34216150770307,21.407838492296932,0.11120955060933471,4.1225897498974575,0.11120955060933471,4.499048310044401,0.1159690752784424,32.74044543604704,34.228647501321909,22,303.1875,0.38095238095238093,21.826963624031361,112.72655069157376,281.45227823812343,21.735221761876574,0.11291024291883935,2.7734493084262368,0.11291024291883935,3.0292662111011879,0.1179095354891482,21.826963624031361,22.819098334214605]
[null,23,128.89130434782609,0.59740259740259738,34.228647501321909,72.500951689955599,106.56725735672593,22.324046991100161,0.1159690752784424,4.499048310044401,0.1159690752784424,4.8910074250895406,0.12068987460205784,34.228647501321909,35.716849566596771,23,290.00543478260869,0.39826839826839827,22.819098334214605,112.47073378889881,267.30784920094766,22.697585581661031,0.1179095354891482,3.0292662111011879,0.1179095354891482,3.2960828017216954,0.12289122939249282,22.819098334214605,23.811233044397852]
[null,24,123.52083333333333,0.62337662337662336,35.716849566596771,72.108992574910459,100.28803247243719,23.232800860896134,0.12068987460205784,4.8910074250895406,0.12068987460205784,5.2983095856605047,0.1253704089360019,35.716849566596771,37.20505163187164,24,277.921875,0.41558441558441561,23.811233044397852,112.2039171982783,254.26531334194513,23.656561658054869,0.12289122939249282,3.2960828017216954,0.12289122939249282,3.5738512316492574,0.12785458837529065,23.811233044397852,24.803367754581092]
[null,25,118.58,0.64935064935064934,37.20505163187164,71.701690414339495,94.446196279819631,24.133803720180367,0.1253704089360019,5.2983095856605047,0.1253704089360019,5.7207912220644488,0.13000915664537552,37.20505163187164,38.693253697146503,25,266.80500000000001,0.4329004329004329,24.803367754581092,111.92614876835074,242.19299173775656,24.61200826224345,0.12785458837529065,3.5738512316492574,0.12785458837529065,3.8625217021470917,0.13279887984009578,24.803367754581092,25.79550246476434]
[null,26,114.01923076923077,0.67532467532467533,38.693253697146503,71.279208777935551,88.992468114995987,25.026762654234787,0.13000915664537552,5.7207912220644488,0.13000915664537552,6.1582827827615887,0.13460461477614108,38.693253697146503,40.181455762421372,26,256.54326923076923,0.45021645021645024,25.79550246476434,111.63747829785291,230.97948486155079,25.563784369218439,0.13279887984009578,3.8625217021470917,0.13279887984009578,4.162042475025018,0.1377233749908936,25.79550246476434,26.787637174947584]
[null,27,109.79629629629629,0.70129870129870131,40.181455762421372,70.841717217238411,83.884907951889133,25.911388344407158,0.13460461477614108,6.1582827827615887,0.13460461477614108,6.6106088156781198,0.1391552997172858,40.181455762421372,41.669657827696234,27,247.04166666666666,0.46753246753246758,26.787637174947584,111.33795752497498,220.52991698091964,26.51174968574702,0.1377233749908936,4.162042475025018,0.1377233749908936,4.4723598836971803,0.14262734897753956,26.787637174947584,27.779771885130828]
[null,28,105.875,0.72727272727272729,41.669657827696234,70.38939118432188,79.087604804422483,26.787395195577517,0.1391552997172858,6.6106088156781198,0.1391552997172858,7.0775880523159884,0.14365974785323643,41.669657827696234,43.157859892971096,28,238.21875,0.48484848484848486,27.779771885130828,111.02764011630282,210.76298532182363,27.455764678176365,0.14262734897753956,4.4723598836971803,0.14262734897753956,4.793418344649794,0.14751008103931462,27.779771885130828,28.771906595314064]
[null,29,102.22413793103448,0.75324675324675328,43.157859892971096,69.922411947684012,74.569636469286465,27.654501461748012,0.14365974785323643,7.0775880523159884,0.14365974785323643,7.5590334946149937,0.14811651620620012,43.157859892971096,44.646061958245966,29,230.00431034482759,0.50216450216450215,28.771906595314064,110.70658165535021,201.60861974475952,28.395690600068065,0.14751008103931462,4.793418344649794,0.14751008103931462,5.1251603693166174,0.15237085464756128,28.771906595314064,29.764041305497308]
[null,30,98.816666666666663,0.77922077922077926,44.646061958245966,69.440966505385006,70.304237296973142,28.512429369693521,0.14811651620620012,7.5590334946149937,0.14811651620620012,8.0547525045226536,0.15252418306811044,44.646061958245966,46.134264023520828,30,222.33750000000001,0.51948051948051943,29.764041305497308,110.37483963068338,193.00611048034446,29.331389519655545,0.15237085464756128,5.1251603693166174,0.15237085464756128,5.4675265763590488,0.15720895764737078,29.764041305497308,30.756176015680555]
[null,31,95.629032258064512,0.80519480519480524,46.134264023520828,68.945247495477346,66.268127017453253,29.36090524061126,0.15252418306811044,8.0547525045226536,0.15252418306811044,8.564546896224229,0.15688134862186434,46.134264023520828,47.622466088795704,31,215.16532258064515,0.53679653679653683,30.756176015680555,110.03247342364095,184.90259823352628,30.262724347118876,0.15720895764737078,5.4675265763590488,0.15720895764737078,5.8204557043482623,0.16202368239828738,30.756176015680555,31.748310725863799]
[null,32,92.640625,0.83116883116883122,47.622466088795704,68.435453103775771,62.440965390291112,30.199659609708888,0.15688134862186434,8.564546896224229,0.15688134862186434,9.0882130309852158,0.16118663555154183,47.622466088795704,49.110668154070567,32,208.44140625,0.55411255411255411,31.748310725863799,109.67954429565174,177.25184738832968,31.189558861670321,0.16202368239828738,5.8204557043482623,0.16202368239828738,6.1838846248461721,0.16681432591400203,31.748310725863799,32.74044543604704]
[null,33,{"$f":"$B$17^2/(2*B51)","v":89.833333333333329},{"$f":"$B$17/C51","v":0.85714285714285721},49.110668154070567,67.911786969014784,58.804905989661528,31.028427343671801,0.16118663555154183,9.0882130309852158,0.16118663555154183,9.6255419145564645,0.16543868964130407,49.110668154070567,50.598870219345436,33,202.125,0.5714285714285714,32.74044543604704,109.31611537515383,170.01324226155461,32.111757738445391,0.16681432591400203,6.1838846248461721,0.16681432591400203,6.5577483558823957,0.17158019000099933,32.74044543604704,33.732580146230283]
[null,{"$f":"B51+$A$19","v":34},87.191176470588232,0.88311688311688319,50.598870219345436,67.374458085443536,55.344228714637197,31.846947755951035,0.16543868964130407,9.6255419145564645,0.16543868964130407,10.176319297091396,0.16963618036267436,50.598870219345436,52.087072284620291,34,196.18014705882354,0.58874458874458868,33.732580146230283,108.9422516441176,163.15096048363117,33.029186575192369,0.17158019000099933,6.5577483558823957,0.17158019000099933,6.9419800758238779,0.17632058139613166,33.732580146230283,34.724714856413527]
[null,35,84.7,0.90909090909090906,52.087072284620291,66.823680702908604,52.045035280185189,32.654964719814814,0.16963618036267436,10.176319297091396,0.16963618036267436,10.740325775522649,0.17377780144991059,52.087072284620291,53.575274349895153,35,190.57499999999999,0.60606060606060608,34.724714856413527,108.55801992417612,156.63328808124464,33.941711918755345,0.17632058139613166,6.9419800758238779,0.17632058139613166,7.3365111376343037,0.18103481190308676,34.724714856413527,35.716849566596771]
[null,36,82.347222222222229,0.93506493506493504,53.575274349895153,66.259674224477351,48.894995443114439,33.452226779107789,0.17377780144991059,10.740325775522649,0.17377780144991059,11.317336898345232,0.17786227146318567,53.575274349895153,55.063476415170022,36,185.28125,0.62337662337662336,35.716849566596771,108.1634888623657,150.4320487086558,34.849201291344201,0.18103481190308676,7.3365111376343037,0.18103481190308676,7.7412710835193934,0.18572219852771907,35.716849566596771,36.708984276780022]
[null,37,80.121621621621628,0.96103896103896091,55.063476415170022,65.682663101654768,45.883134364958387,34.238487256663241,0.17786227146318567,11.317336898345232,0.17786227146318567,11.907123272751221,0.18188833433929766,55.063476415170022,56.551678480444892,37,180.27364864864865,0.64069264069264076,36.708984276780022,107.75872891648061,144.52212543206272,35.751523216585923,0.18572219852771907,7.7412710835193934,0.18572219852771907,8.1561876599554353,0.19038206361221527,36.708984276780022,37.701118986963259]
[null,38,78.013157894736835,0.98701298701298712,56.551678480444892,65.092876727248779,42.999653534422038,35.013504360314798,0.18188833433929766,11.907123272751221,0.18188833433929766,12.50945067406019,0.18585475992963865,56.551678480444892,58.039880545719761,38,175.52960526315789,0.65800865800865804,37.701118986963259,107.34381234004456,138.88105801780645,36.648547245351438,0.19038206361221527,8.1561876599554353,0.19038206361221527,8.5811868330966661,0.19501373496806323,37.701118986963259,38.693253697146503]
[null,39,76.012820512820511,1.0129870129870131,58.039880545719761,64.49054932593981,40.235779226365068,35.777041286455443,0.18585475992963865,12.50945067406019,0.18585475992963865,13.124080157388413,0.18976034452515933,58.039880545719761,59.528082610994623,39,171.02884615384616,0.67532467532467533,38.693253697146503,106.91881316690333,133.48870217249399,37.540143981352173,0.19501373496806323,8.5811868330966661,0.19501373496806323,9.0161928045588269,0.19961654600779671,38.693253697146503,39.685388407329746]
[null,40,74.112499999999997,1.0389610389610391,59.528082610994623,63.875919842611587,37.583633678906828,36.528866321093169,0.18976034452515933,13.124080157388413,0.18976034452515933,13.750768171498457,0.19360391136807056,59.528082610994623,61.016284676269478,40,166.75312500000001,0.69264069264069261,39.685388407329746,106.48380719544117,128.32693989349914,38.426185106500867,0.19961654600779671,9.0161928045588269,0.19961654600779671,9.4611280275745742,0.20418983587548298,39.685388407329746,40.677523117512983]
[null,41,72.304878048780495,1.0649350649350648,61.016284676269478,63.249231828501543,35.036125110426909,37.268752938353586,0.19360391136807056,13.750768171498457,0.19360391136807056,14.389266674770042,0.19738431115003352,61.016284676269478,62.504486741544362,41,162.6859756097561,0.7099567099567099,40.677523117512983,106.03887197242543,123.37943220372563,39.306543406030471,0.20418983587548298,9.4611280275745742,0.20418983587548298,9.9159132235171938,0.20873294957592869,40.677523117512983,41.669657827696234]
[null,42,70.583333333333329,1.0909090909090911,62.504486741544362,62.610733325229958,32.586853436951877,37.996479896381452,0.19738431115003352,14.389266674770042,0.19738431115003352,15.039323253231693,0.20110042249659366,62.504486741544362,63.99268880681921,42,158.8125,0.72727272727272729,41.669657827696234,105.58408677648281,118.63140720663372,40.181092793366275,0.20873294957592869,9.9159132235171938,0.20873294957592869,10.380467398788923,0.21324523810257176,41.669657827696234,42.661792537879478]
[null,43,68.941860465116278,1.1168831168831168,63.99268880681921,61.960676746768307,30.230029134521995,38.711831330594279,0.20110042249659366,15.039323253231693,0.20110042249659366,15.700681240591777,0.20475115243762623,63.99268880681921,65.480890872094079,43,155.11918604651163,0.74458874458874458,42.661792537879478,105.11953260121108,114.06947771176657,41.049708334745063,0.21324523810257176,10.380467398788923,0.21324523810257176,10.854707862069688,0.21772605856403335,42.661792537879478,43.653927248062722]
[null,44,67.375,1.1428571428571428,65.480890872094079,61.299318759408223,27.960403155756946,39.41459684424305,0.20475115243762623,15.700681240591777,0.20475115243762623,16.373079840206394,0.20833543686356165,65.480890872094079,66.969092937368941,44,151.59375,0.76190476190476186,43.653927248062722,104.64529213793031,109.68148372642358,41.912266273576421,0.21772605856403335,10.854707862069688,0.21772605856403335,11.338550241922491,0.22217477430930013,43.653927248062722,44.646061958245966]
[null,45,65.87777777777778,1.1688311688311688,66.969092937368941,60.626920159793606,25.773206181542164,40.104571596235616,0.20833543686356165,16.373079840206394,0.20833543686356165,17.05625424892083,0.21185224096717364,66.969092937368941,68.457295002643818,45,148.22499999999999,0.77922077922077926,44.646061958245966,104.16144975807751,105.45635594545972,42.768644054540275,0.22217477430930013,11.338550241922491,0.22217477430930013,11.831908504751198,0.22659075505151066,44.646061958245966,45.63819666842921]
[null,46,64.445652173913047,1.1948051948051948,68.457295002643818,59.94374575107917,23.664095787732126,40.781556386180924,0.21185224096717364,17.05625424892083,0.21185224096717364,17.749935782720101,0.21530055967071587,68.457295002643818,69.94549706791868,46,145.00271739130434,0.79653679653679654,45.63819666842921,103.6680914952488,101.38399704388854,43.618720347415803,0.22659075505151066,11.831908504751198,0.22659075505151066,12.334694973106551,0.23097337699031717,45.63819666842921,46.630331378612453]
[null,47,63.074468085106382,1.2207792207792207,69.94549706791868,59.250064217279899,21.629110348493576,41.445357736612806,0.21530055967071587,17.749935782720101,0.21530055967071587,18.453852004123291,0.21867941803820332,69.94549706791868,71.433699133193542,47,141.91755319148936,0.81385281385281383,46.630331378612453,103.16530502689345,97.455178120853304,44.462375070636057,0.23097337699031717,12.334694973106551,0.23097337699031717,12.846820344336351,0.2353220229327965,46.630331378612453,47.622466088795704]
[null,48,61.760416666666664,1.2467532467532467,71.433699133193542,58.546147995876709,19.664628694312526,42.095787972354138,0.21867941803820332,18.453852004123291,0.21867941803820332,19.16772685125563,0.22198787167264059,71.433699133193542,72.921901198468419,48,138.9609375,0.83116883116883122,47.622466088795704,102.65317965566365,93.661448085436675,45.299489414563325,0.2353220229327965,12.846820344336351,0.2353220229327965,13.36819370957528,0.23963608241288353,47.622466088795704,48.614600798978941]
[null,49,60.5,1.2727272727272727,72.921901198468419,57.83227314874437,17.767334703016687,42.732665296983313,0.22198787167264059,19.16772685125563,0.22198787167264059,19.891280768531203,0.22522500709800972,72.921901198468419,74.410103263743281,49,136.125,0.84848484848484851,48.614600798978941,102.13180629042472,89.995054135519922,46.129945864480078,0.23963608241288353,13.36819370957528,0.23963608241288353,13.898722573069918,0.24391495180930045,48.614600798978941,49.606735509162185]
[null,50,59.29,1.2987012987012987,74.410103263743281,57.108719231468797,15.934186133633123,43.355813866366873,0.22522500709800972,19.891280768531203,0.22522500709800972,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},74.410103263743281,{"$f":"NA()","v":{"$error":"#N/A"}},50,133.4025,0.86580086580086579,49.606735509162185,101.60127742693008,86.448871776709666,46.953628223290337,0.24391495180930045,13.898722573069918,0.24391495180930045,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},49.606735509162185,{"$f":"NA()","v":{"$error":"#N/A"}}]

{"sheet":"Twist","index":7,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
["JIB","(Calculations from the \"Leech\" spreadsheet)"]
["Leech length",null,{"$f":"HLOOKUP(RigNumber,DefaultTable,17)","v":1250},"mm",null,"g",{"$f":"C3/2","v":625},"mm"]
["Foot",null,{"$f":"HLOOKUP(RigNumber,DefaultTable,5)","v":385},"mm",null,"head",20,"mm"]
[]
["TL lift (mm)",null,0.5,0.71,0.97,1.2749999999999999,1.6,1.9750000000000001,2.4,2.85,3.33,3.85,4.4000000000000004,5,5.6,6.3,7,7.7,8.4499999999999993,9.25,10.050000000000001]
["h",null,{"$f":"($C$3-C6)/2","v":624.75},624.64499999999998,624.51499999999999,624.36249999999995,624.20000000000005,624.01250000000005,623.79999999999995,623.57500000000005,623.33500000000004,623.07500000000005,622.79999999999995,622.5,{"$f":"($C$3-O6)/2","v":622.20000000000005},621.85,621.5,621.15,620.77499999999998,620.375,619.97500000000002]
["d",null,{"$f":"SQRT($G$3^2-C7^2)","v":17.675901674313533},21.062382937360031,24.617367345026736,28.221775170070938,31.612655693565635,35.119792763482238,38.711238678193389,42.180793911446571,45.590325453981762,49.015756395264773,52.394274496361078,55.845769759221689,{"$f":"SQRT($G$3^2-O7^2)","v":59.094500590155732},62.670387744132839,66.051116568911993,69.26526907476827,72.549289279771983,75.893737389853186,79.094875782189305]
["r",null,{"$f":"$G$3^2/(2*C8)","v":11049.648476141188},9273.0485710407738,7933.9312470980994,6920.6312793224997,6178.3009277437404,5561.3226796453955,5045.369424203478,4630.3656685560436,4284.0777742888831,3984.6880750955502,3727.7450995826839,3497.3553205925409,{"$f":"$G$3^2/(2*O8)","v":3305.0875808998067},3116.5037752345011,2956.9901334859028,2819.7753738481874,2692.1352633354682,2573.4995629048153,2469.3445443652968]
["Phi",null,{"$f":"($C$3/C9)/2","v":5.6562885357803301E-2},6.7399625399552091E-2,7.8775575504085552E-2,9.0309680544227E-2,0.10116049821941003,0.11238333684314315,0.12387596377021885,0.13497854051662903,0.14588904145274165,0.15685042046484729,0.16766167838835544,0.17870646322950942,{"$f":"($C$3/O9)/2","v":0.18910240188849833},0.2005452407812251,0.21136357302051839,0.22164886103925846,0.23215772569527035,0.24285995964753018,0.25310360250300579]
["Mid-leech gap",0.5,{"$f":"C$9*(COS(2*($B11-0.5)*C$10)-1)+C$8","v":17.675901674313533},{"$f":"D$9*(COS(2*($B11-0.5)*D$10)-1)+D$8","v":21.062382937360031},24.617367345026736,28.221775170070938,31.612655693565635,35.119792763482238,38.711238678193389,42.180793911446571,45.590325453981762,49.015756395264773,52.394274496361078,55.845769759221689,59.094500590155732,62.670387744132839,66.051116568911993,69.26526907476827,72.549289279771983,75.893737389853186,79.094875782189305]
["Mid-leech twist",{"$f":"B11","v":0.5},{"$f":"180*ASIN(C$11/($G$4+$B12*($C$4-$G$4)))/PI()","v":5.0076299701130944},5.9702332600869328,6.9825614409542132,8.0112068364877942,8.9812873305242107,9.9873693080225472,11.020874093851512,12.022759184875895,13.010958473256812,14.007748788717876,14.995142761921588,16.008596577641061,{"$f":"180*ASIN(O$11/($G$4+$B12*($C$4-$G$4)))/PI()","v":16.967229430087247},18.028100317887219,19.036980461657159,20.001863839919647,20.993871856720688,22.010956450120805,22.991339086512902]
[null,null,{"$f":"C6","v":0.5},{"$f":"D6","v":0.71},0.97,1.2749999999999999,1.6,1.9750000000000001,2.4,2.85,3.33,3.85,4.4000000000000004,5,5.6,6.3,7,7.7,8.4499999999999993,9.25,10.050000000000001]
[null,null,{"$f":"D6","v":0.71},{"$f":"E6","v":0.97},1.2749999999999999,1.6,1.9750000000000001,2.4,2.85,3.33,3.85,4.4000000000000004,5,5.6,6.3,7,7.7,8.4499999999999993,9.25,10.050000000000001,{"$f":"NA()","v":{"$error":"#N/A"}}]
[]
["Default gap",null,{"$f":"HLOOKUP(RigNumber,DefaultTable,18)","v":35}]
["Default twist",null,{"$f":"180*ASIN(C16/($G$4+$B12*($C$4-$G$4)))/PI()","v":9.9529551683004005}]
["Lower TL lift",null,{"$f":"HLOOKUP(C16,C11:U14,3)","v":1.6}]
["Upper TL lift",null,{"$f":"HLOOKUP(C16,C11:U14,4)","v":1.9750000000000001}]
["Lift diff",null,{"$f":"C19-C18","v":0.375}]
["Lower twist",null,{"$f":"HLOOKUP(C16,C11:U14,2)","v":8.9812873305242107}]
["Upper twist",null,{"$f":"HLOOKUP(C19,C6:U14,7)","v":9.9873693080225472}]
["% incr",null,{"$f":"(C17-C21)/(C22-C21)","v":0.96579390100226337}]
["Default TL lift",null,{"$f":"C18+C23*C20","v":1.9621727128758488},null,"(by linear interpolation)"]
["Gap reduced due to JS sag (twist)",null,null,null,null,null,{"$f":"JsSagTwist","v":10.304058890605354},"mm"]
[null,null,{"$f":"C6","v":0.5},{"$f":"D6","v":0.71},0.97,1.2749999999999999,1.6,1.9750000000000001,2.4,2.85,3.33,3.85,4.4000000000000004,5,5.6,6.3,7,7.7,8.4499999999999993,9.25,10.050000000000001]
["Gap - JS sag",null,{"$f":"C$9*(COS(2*($B11-0.5)*C$10)-1)+C$8-$G$25","v":7.3718427837081784},10.758324046754677,14.313308454421382,17.917716279465584,21.308596802960281,24.815733872876883,28.407179787588035,31.876735020841217,35.286266563376408,38.711697504659419,42.090215605755724,45.541710868616335,48.790441699550378,52.366328853527484,55.747057678306639,58.961210184162915,62.245230389166629,65.589678499247839,68.790816891583944]
["Twist after JS sag",null,{"$f":"180*ASIN(C$27/($G$4+$B12*($C$4-$G$4)))/PI()","v":2.0862658149169131},{"$f":"180*ASIN(D$27/($G$4+$B12*($C$4-$G$4)))/PI()","v":3.0454168042201362},4.0532176813718817,5.0763152835480803,6.040281943996292,7.0391105018586089,8.0641860667553882,9.0569418865232052,10.035200052684045,11.021006354416103,11.996557273419684,12.996841321451406,13.942053286168754,14.98695717623111,15.979542078584167,16.927803789102935,17.901639893593085,18.898923758272396,19.859068879758468]
[null,null,{"$f":"C6","v":0.5},{"$f":"D6","v":0.71},0.97,1.2749999999999999,1.6,1.9750000000000001,2.4,2.85,3.33,3.85,4.4000000000000004,5,5.6,6.3,7,7.7,8.4499999999999993,9.25,10.050000000000001]
[null,null,{"$f":"D6","v":0.71},0.97,1.2749999999999999,1.6,1.9750000000000001,2.4,2.85,3.33,3.85,4.4000000000000004,5,5.6,6.3,7,7.7,8.4499999999999993,9.25,10.050000000000001,{"$f":"NA()","v":{"$error":"#N/A"}}]
[]
["Current lift",null,{"$f":"TlLiftTotal","v":2.7669298282061137}]
["Upper lift",null,{"$f":"HLOOKUP(C32,C26:U30,5)","v":2.85}]
["Lower lift",null,{"$f":"HLOOKUP(C32,C26:U30,4)","v":2.4}]
["Upper twist",null,{"$f":"HLOOKUP(C33,C26:U30,3)","v":9.0569418865232052}]
["Lower twist",null,{"$f":"HLOOKUP(C32,C26:U30,3)","v":8.0641860667553882}]
["Current twist",null,{"$f":"C36+(C35-C36)*(C32-C34)/(C33-C34)","v":8.8736787831954427},null,"(by linear interpolation)"]