{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheeting","Graph","Module1"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":2,"reason":"part_missing"}],"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":"Sheeting","index":0,"n_rows":57,"n_cols":18,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["SHEETING CALCULATOR",null,null,null,"Version 2:  More accurately models the jib boom"]
[null,null,null,null,"Version 3:  Allows a sliding sheet attachment point"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MAIN",null,null,null,null,null,null,"JIB",null,null,null,null,null,null,"Rig","Rig","Rig"]
[null,null,null,null,null,null,null,"Rig#:",1,null,null,null,null,null,1,2,3]
["Min R:",140," mm",{"$f":"IF(MainMinR>MainMaxR,\"Error!\",\"OK\")","v":"OK"},null,null,null,"Min R:",210," mm",{"$f":"IF(JibMinR>JibMaxR,\"Error!\",\"OK\")","v":"OK"},null,null,"Luff",1330,990,740," mm"]
["Max R:",140," mm",{"$f":"IF(MainMinR>MainMaxR,\"MinR > MaxR\",\"OK\")","v":"OK"},null,null,null,"Max R:",210," mm",{"$f":"IF(JibMinR>JibMaxR,\"MinR > MaxR\",\"OK\")","v":"OK"},null,null,"Leech",1255,910,665," mm"]
["F:",170," mm",null,null,null,null,"F:",250," mm","f:",{"$f":"I22*SIN(HLOOKUP(I19,N19:P29,11)*PI()/180)","v":243.65178046815274},null,"Foot",385,350,300," mm"]
["Ht:",0," mm",null,null,null,null,"Ht:",40," mm","ht:",{"$f":"I23*SIN(HLOOKUP(I19,N19:P29,11)*PI()/180)","v":38.984284874904432},null,"Offset",80,70,60," mm"]
["R:",{"$f":"IF(MainMaxR<MainF,MainMaxR,IF(MainMinR>MainF,MainMinR,MainF))","v":140}," mm",null,null,null,null,null,null,null,"min r:",{"$f":"I20*SIN(PI()*HLOOKUP(I19,N19:P29,11)/180)","v":204.66749559324828},null,"Off%",{"$f":"O23/O22","v":0.20779220779220781},{"$f":"P23/P22","v":0.2},{"$f":"Q23/Q22","v":0.2}]
[null,null,null,null,null,null,null,null,null,null,"max r:",{"$f":"I21*SIN(PI()*HLOOKUP(I19,N19:P29,11)/180)","v":204.66749559324828},null,"Tack",{"$f":"ACOS(((O20^2+(O22-20)^2-O21^2))/(2*O20*(O22-20)))*180/PI()","v":70.31164500077395},{"$f":"ACOS(((P20^2+(P22-20)^2-P21^2))/(2*P20*(P22-20)))*180/PI()","v":66.465825197449561},{"$f":"ACOS(((Q20^2+(Q22-20)^2-Q21^2))/(2*Q20*(Q22-20)))*180/PI()","v":63.674349512757964},"deg"]
["Incr:",12.5," mm",null,null,null,null,null,null,null,"r:",{"$f":"IF(JibMaxR<JibF,JibMaxR,IF(JibMinR>JibF,JibMinR,JibF))","v":204.66749559324828},null,"Clew",{"$f":"ACOS((O21^2+(O22-20)^2-O20^2)/(2*O21*(O22-20)))*180/PI()","v":93.795811029105835},{"$f":"ACOS((P21^2+(P22-20)^2-P20^2)/(2*P21*(P22-20)))*180/PI()","v":94.115172360098299},{"$f":"ACOS((Q21^2+(Q22-20)^2-Q20^2)/(2*Q21*(Q22-20)))*180/PI()","v":94.153889411594747},"deg"]
["Base:",5," deg",null,null,null,null,"Base:",15," deg",null,null,null,"P.luff",{"$f":"O20-(O20-O21)*(1-O23/O22)","v":1270.5844155844156},{"$f":"P20-(P20-P21)*(1-P23/P22)","v":926},{"$f":"Q20-(Q20-Q21)*(1-Q23/Q22)","v":680}," mm"]
["Start:",{"$f":"SQRT(MainHt^2+(MainF-MainR*COS(PI()*MainBase/180))^2+(MainR*SIN(PI()*MainBase/180))^2)","v":32.880577410272345}," mm",null,null,null,null,"Start:",{"$f":"SQRT(JibHt^2+(JibF-JibR*COS(PI()*JibBase/180))^2+(JibR*SIN(PI()*JibBase/180))^2)","v":80.236796074016965}," mm",null,null,null,"P.foot",{"$f":"O22-O23","v":305},{"$f":"P22-P23","v":280},{"$f":"Q22-Q23","v":240}," mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pivot",{"$f":"90-180*ACOS((O27^2+O21^2-(O28-20)^2)/(2*O27*O21))/PI()","v":77.060517673087901},{"$f":"90-180*ACOS((P27^2+P21^2-(P28-20)^2)/(2*P27*P21))/PI()","v":73.748150922704085},{"$f":"90-180*ACOS((Q27^2+Q21^2-(Q28-20)^2)/(2*Q27*Q21))/PI()","v":71.214829864716719},"deg"]
["Step","Feed","eff","Try R","New R","MSA","Flag","Step","Feed","eff","Try R","New R","JSA","Flag","Diff"]
[0,{"$f":"A31*Incr+MainStart","v":32.880577410272345},{"$f":"SQRT(B31^2-MainHt^2)","v":32.880577410272345},{"$f":"IF(MainF>C31,SQRT(MainF^2-C31^2),0)","v":166.78989066837082},{"$f":"IF(D31<MainMinR,MainMinR,IF(D31>MainMaxR,MainMaxR,D31))","v":140},{"$f":"180*ACOS((E31^2+MainF^2-C31^2)/(2*MainF*E31))/(PI())","v":4.9999999999999947},{"$f":"IF(ABS($B$27-$F$31)<0.1,\"\",\"OFF\")","v":""},0,{"$f":"H31*Incr+JibStart","v":80.236796074016965},{"$f":"SQRT(I31^2-JibHt^2)","v":70.129658326671475},{"$f":"IF(JibF>J31,SQRT(JibF^2-J31^2),0)","v":233.34099757283377},{"$f":"IF(K31<JibMinR,JibMinR,IF(K31>JibMaxR,JibMaxR,K31))","v":204.66749559324828},{"$f":"180*ACOS((L31^2+JibF^2-J31^2)/(2*JibF*L31))/(PI())","v":14.999999999999982},{"$f":"IF(ABS($I$27-$M$31)<0.1,\"\",\"OFF\")","v":""},{"$f":"M31-F31","v":9.9999999999999876}]
[1,{"$f":"A32*Incr+MainStart","v":45.380577410272345},{"$f":"SQRT(B32^2-MainHt^2)","v":45.380577410272345},{"$f":"IF(MainF>C32,SQRT(MainF^2-C32^2),0)","v":163.8310202431465},{"$f":"IF(D32<MainMinR,MainMinR,IF(D32>MainMaxR,MainMaxR,D32))","v":140},{"$f":"180*ACOS((E32^2+MainF^2-C32^2)/(2*MainF*E32))/(PI())","v":12.671723229357324},"",1,{"$f":"H32*Incr+JibStart","v":92.736796074016965},{"$f":"SQRT(I32^2-JibHt^2)","v":84.144749562085607},{"$f":"IF(JibF>J32,SQRT(JibF^2-J32^2),0)","v":228.66099633832351},{"$f":"IF(K32<JibMinR,JibMinR,IF(K32>JibMaxR,JibMaxR,K32))","v":204.66749559324828},{"$f":"180*ACOS((L32^2+JibF^2-J32^2)/(2*JibF*L32))/(PI())","v":19.222574991297446},"",6.5508517619401214]
[2,57.880577410272345,57.880577410272345,159.84316925866264,140,18.46342326026944,"",2,105.23679607401697,97.749725220670214,223.18418703972816,204.66749559324828,23.156477232559652,"",4.6930539722902118]
[3,70.380577410272338,70.380577410272338,154.74680715089622,140,23.8164175369246,"",3,117.73679607401697,111.09535851045693,216.85020507883763,204.66749559324828,26.939093767346048,"",3.1226762304214475]
[4,82.880577410272338,82.880577410272338,148.42779351637569,140,29.002701614663295,"",4,130.23679607401698,124.26523481817986,209.5813482657355,204.66749559324828,30.637393544556076,"",1.6346919298927816]
[5,95.380577410272338,95.380577410272338,140.72151737699195,140,34.128172335040311,"",5,142.73679607401698,137.30993586142193,201.27635638353823,204.66749559324828,34.289929466088005,"",0.16175713104769329]
[6,107.88057741027234,107.88057741027234,131.38409727827121,140,39.248685082660955,"",6,155.23679607401698,150.26206569895885,191.80068231678081,204.66749559324828,37.921666168042307,"",-1.3270189146186482]
[7,120.38057741027234,120.38057741027234,120.03548051459381,140,44.400658850181223,"",7,167.73679607401698,163.14367376631145,180.97052753233672,204.66749559324828,41.550374816384142,"",-2.850284033797081]
[8,132.88057741027234,132.88057741027234,106.03184496703157,140,49.612256719137612,"",8,180.23679607401698,175.97024803022549,168.52495937837168,204.66749559324828,45.189788036185035,"",-4.4224686829525766]
[9,145.38057741027234,145.38057741027234,88.116330562818007,140,54.908477251776219,"",9,192.73679607401698,188.75300817117989,154.07300877061951,204.66749559324828,48.851325309448676,"",-6.0571519423275433]
[10,157.88057741027234,157.88057741027234,63.03747517627118,140,60.314007887934345,"",10,205.23679607401698,201.50029279264069,136.98110135993568,204.66749559324828,52.545125257838279,"",-7.7688826300960656]
[11,170.38057741027234,170.38057741027234,0,140,65.855252391715652,"",11,217.73679607401698,214.21843500821856,116.08898409379994,204.66749559324828,56.280721091897774,"",-9.5745312998178775]
[12,182.88057741027234,182.88057741027234,0,140,71.562192863865548,"",12,230.23679607401698,226.91233505303492,88.752365185836709,204.66749559324828,60.067528502167086,"",-11.494664361698462]
[13,195.38057741027234,195.38057741027234,0,140,77.470526219706855,"",13,242.73679607401698,239.58584620355018,44.326204712671917,204.66749559324828,63.91523992657342,"",-13.555286293133435]
[14,207.88057741027234,207.88057741027234,0,140,83.624533878256031,"",14,255.23679607401698,252.24204170383976,0,204.66749559324828,67.834183946590116,"",-15.790349931665915]
[15,220.38057741027234,220.38057741027234,0,140,90.081368339360878,"",15,267.73679607401698,264.88340360387252,0,204.66749559324828,71.835693109223854,"",-18.245675230137024]
[16,232.88057741027234,232.88057741027234,0,140,96.918005352544029,"",16,280.23679607401698,277.51195903352067,0,204.66749559324828,75.932519446799262,"",-20.985485905744767]
[17,245.38057741027234,245.38057741027234,0,140,104.24345652405223,"",17,292.73679607401698,290.12938029174654,0,204.66749559324828,80.139341610816643,"",-24.104114913235591]
[18,257.88057741027234,257.88057741027234,0,140,112.22232488715743,"",18,305.23679607401698,302.73705952579263,0,204.66749559324828,84.47342146721931,"",-27.748903419938117]
[19,270.38057741027234,270.38057741027234,0,140,121.12624914251812,"",19,317.73679607401698,315.33616524619208,0,204.66749559324828,88.95549519011108,"",-32.17075395240704]
[20,282.88057741027234,282.88057741027234,0,140,131.46900009785227,"",20,330.23679607401698,327.92768564734541,0,204.66749559324828,93.611033538931281,"",-37.857966558920992]
[]
[null,"The \"feed\" represents the amount of line that is spooled."]
[null,"Subtract the feed of step 0 from that of step 20 to see the amount of line spooled"]
[null," from \"fully sheeted in\" to \"fully sheeted out\".  This is given below:"]
[]
[null,{"$f":"B51-B31","v":250},"mm","Net line spooled",null,null,null,{"$f":"I51-I31","v":250},"mm"]

{"sheet":"Graph","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
["Step","MSA","JSA"]
[{"$f":"Sheeting!A31","v":0},{"$f":"IF(Sheeting!F31<$H$25,Sheeting!F31,$H$25)","v":4.9999999999999947},{"$f":"Sheeting!M31","v":14.999999999999982}]
[{"$f":"Sheeting!A32","v":1},{"$f":"IF(Sheeting!F32<$H$25,Sheeting!F32,$H$25)","v":12.671723229357324},{"$f":"Sheeting!M32","v":19.222574991297446}]
[{"$f":"Sheeting!A33","v":2},{"$f":"IF(Sheeting!F33<$H$25,Sheeting!F33,$H$25)","v":18.46342326026944},{"$f":"Sheeting!M33","v":23.156477232559652}]
[{"$f":"Sheeting!A34","v":3},{"$f":"IF(Sheeting!F34<$H$25,Sheeting!F34,$H$25)","v":23.8164175369246},{"$f":"Sheeting!M34","v":26.939093767346048}]
[{"$f":"Sheeting!A35","v":4},{"$f":"IF(Sheeting!F35<$H$25,Sheeting!F35,$H$25)","v":29.002701614663295},{"$f":"Sheeting!M35","v":30.637393544556076}]
[{"$f":"Sheeting!A36","v":5},{"$f":"IF(Sheeting!F36<$H$25,Sheeting!F36,$H$25)","v":34.128172335040311},{"$f":"Sheeting!M36","v":34.289929466088005}]
[{"$f":"Sheeting!A37","v":6},{"$f":"IF(Sheeting!F37<$H$25,Sheeting!F37,$H$25)","v":39.248685082660955},{"$f":"Sheeting!M37","v":37.921666168042307}]
[{"$f":"Sheeting!A38","v":7},{"$f":"IF(Sheeting!F38<$H$25,Sheeting!F38,$H$25)","v":44.400658850181223},{"$f":"Sheeting!M38","v":41.550374816384142}]
[{"$f":"Sheeting!A39","v":8},{"$f":"IF(Sheeting!F39<$H$25,Sheeting!F39,$H$25)","v":49.612256719137612},{"$f":"Sheeting!M39","v":45.189788036185035}]
[{"$f":"Sheeting!A40","v":9},{"$f":"IF(Sheeting!F40<$H$25,Sheeting!F40,$H$25)","v":54.908477251776219},{"$f":"Sheeting!M40","v":48.851325309448676}]
[{"$f":"Sheeting!A41","v":10},{"$f":"IF(Sheeting!F41<$H$25,Sheeting!F41,$H$25)","v":60.314007887934345},{"$f":"Sheeting!M41","v":52.545125257838279}]
[{"$f":"Sheeting!A42","v":11},{"$f":"IF(Sheeting!F42<$H$25,Sheeting!F42,$H$25)","v":65.855252391715652},{"$f":"Sheeting!M42","v":56.280721091897774}]
[{"$f":"Sheeting!A43","v":12},{"$f":"IF(Sheeting!F43<$H$25,Sheeting!F43,$H$25)","v":71.562192863865548},{"$f":"Sheeting!M43","v":60.067528502167086}]
[{"$f":"Sheeting!A44","v":13},{"$f":"IF(Sheeting!F44<$H$25,Sheeting!F44,$H$25)","v":77.470526219706855},{"$f":"Sheeting!M44","v":63.91523992657342}]
[{"$f":"Sheeting!A45","v":14},{"$f":"IF(Sheeting!F45<$H$25,Sheeting!F45,$H$25)","v":83.624533878256031},{"$f":"Sheeting!M45","v":67.834183946590116}]
[{"$f":"Sheeting!A46","v":15},{"$f":"IF(Sheeting!F46<$H$25,Sheeting!F46,$H$25)","v":90},{"$f":"Sheeting!M46","v":71.835693109223854}]
[{"$f":"Sheeting!A47","v":16},{"$f":"IF(Sheeting!F47<$H$25,Sheeting!F47,$H$25)","v":90},{"$f":"Sheeting!M47","v":75.932519446799262}]
[{"$f":"Sheeting!A48","v":17},{"$f":"IF(Sheeting!F48<$H$25,Sheeting!F48,$H$25)","v":90},{"$f":"Sheeting!M48","v":80.139341610816643}]
[{"$f":"Sheeting!A49","v":18},{"$f":"IF(Sheeting!F49<$H$25,Sheeting!F49,$H$25)","v":90},{"$f":"Sheeting!M49","v":84.47342146721931}]
[{"$f":"Sheeting!A50","v":19},{"$f":"IF(Sheeting!F50<$H$25,Sheeting!F50,$H$25)","v":90},{"$f":"Sheeting!M50","v":88.95549519011108}]
[{"$f":"Sheeting!A51","v":20},{"$f":"IF(Sheeting!F51<$H$25,Sheeting!F51,$H$25)","v":90},{"$f":"Sheeting!M51","v":93.611033538931281}]
[]
["R",{"$f":"Sheeting!B24","v":140},{"$f":"Sheeting!I24","v":0},null,"Max main sheeting angle",null,null,90]
["F",{"$f":"Sheeting!B22","v":170},{"$f":"Sheeting!I22","v":250}]
["Ht",{"$f":"Sheeting!B23","v":0},{"$f":"Sheeting!I23","v":40}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"R = radius"]
[]
[]
[null,null,null,null,null,null,"Ht = height"]
[]
[]
[null,null,"F = fairlead"]