{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheeting","Graph"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Sheeting","index":0,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["ARM WINCH SHEETING CALCULATOR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Main boom measurements",null,null,null,null,null,"Jib boom measurements",null,null,null,null,null,null,"Rig","Rig","Rig"]
["R:",130," mm","R^2:",{"$f":"B20^2","v":16900},null,"Rig#:",1,null,"r:",{"$f":"H21*SIN(PI()*HLOOKUP(H20,N20:P30,11)/180)","v":126.20194480178442},null,null,1,2,3]
["F:",130," mm","P^2:",{"$f":"B21^2","v":16900},null,"R:",130," mm","f:",{"$f":"H22*SIN(HLOOKUP(H20,N20:P30,11)*PI()/180)","v":126.20194480178442},null,"Luff",1330,990,740," mm"]
["Diff:",{"$f":"B21-B20","v":0}," mm","2P:",{"$f":"B21*2","v":260},null,"F:",130," mm","h:",{"$f":"H23*SIN(HLOOKUP(H20,N20:P30,11)*PI()/180)","v":9.7078419078295717},null,"Leech",1255,910,665," mm"]
["Ht:",20," mm","Ht^2:",{"$f":"B23^2","v":400},null,"Ht:",10," mm","Ht^2:",{"$f":"K22^2","v":94.242194507412094},null,"Foot",385,350,300," mm"]
["Incr:",5," deg","Adj:",{"$f":"IF(B22<0,ABS(2*B22),0)","v":0},null,null,{"$f":"B24","v":5},null,"r^2:",{"$f":"K20^2","v":15926.930871752642},null,"Offset",60,55,50," mm"]
["Start:",2.9912766152198795,null,null,null,null,"Start:",38.866665010354424,null,"f^2:",{"$f":"K21^2","v":15926.930871752642},null,"Off%",{"$f":"N24/N23","v":0.15584415584415584},{"$f":"O24/O23","v":0.15714285714285714},{"$f":"P24/P23","v":0.16666666666666666}]
["Base:",5,"degrees",null,null,null,"Base:",15,"degrees","2rf:",{"$f":"2*K20*K21","v":31853.861743505284},null,"Tack",{"$f":"ACOS(((N21^2+(N23-20)^2-N22^2))/(2*N21*(N23-20)))*180/PI()","v":70.31164500077395},{"$f":"ACOS(((O21^2+(O23-20)^2-O22^2))/(2*O21*(O23-20)))*180/PI()","v":66.465825197449561},{"$f":"ACOS(((P21^2+(P23-20)^2-P22^2))/(2*P21*(P23-20)))*180/PI()","v":63.674349512757964},"degrees"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Clew",{"$f":"ACOS((N22^2+(N23-20)^2-N21^2)/(2*N22*(N23-20)))*180/PI()","v":93.795811029105835},{"$f":"ACOS((O22^2+(O23-20)^2-O21^2)/(2*O22*(O23-20)))*180/PI()","v":94.115172360098299},{"$f":"ACOS((P22^2+(P23-20)^2-P21^2)/(2*P22*(P23-20)))*180/PI()","v":94.153889411594747},"degrees"]
[null,null,null,null,null,null,null,null,null,null,null,null,"P.luff",{"$f":"N21-(N21-N22)*(1-N24/N23)","v":1266.6883116883116},{"$f":"O21-(O21-O22)*(1-O24/O23)","v":922.57142857142856},{"$f":"P21-(P21-P22)*(1-P24/P23)","v":677.5}," mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,"P.foot",{"$f":"N23-N24","v":325},{"$f":"O23-O24","v":295},{"$f":"P23-P24","v":250}," mm"]
["(Note:  The button macros will fail if you insert or delete rows or columns.)",null,null,null,null,null,null,null,null,null,null,null,"Pivot",{"$f":"90-180*ACOS((N28^2+N22^2-(N29-20)^2)/(2*N28*N22))/PI()","v":76.116158244426458},{"$f":"90-180*ACOS((O28^2+O22^2-(O29-20)^2)/(2*O28*O22))/PI()","v":72.756692919059617},{"$f":"90-180*ACOS((P28^2+P22^2-(P29-20)^2)/(2*P28*P22))/PI()","v":70.299184917775733},"degrees"]
[]
["Mr",100,"mm",null,null,null,"Jr",85,"mm"]
["Me",170,"mm",null,null,null,"Je",160,"mm"]
["Ame",100,"mm",null,null,null,"Aje",95,"mm"]
["Calc arm angle:",null,null,{"$f":"180*ACOS((MarmRadius^2+AMdistExit^2-MdistExit^2)/(2*MarmRadius*AMdistExit))/PI()","v":116.42333876589676},"degrees wrt main take-off"]
["Calc arm angle:",null,null,{"$f":"180*ACOS((JarmRadius^2+AJdistExit^2-JdistExit^2)/(2*JarmRadius*AJdistExit))/PI()","v":125.3765401519416},"degrees wrt jib take-off"]
[]
["Step",null,"Feed","EF","X","MSA","Flag","Step",null,"Feed","EF","X","JSA","Flag","Diff","%"]
[0,{"$f":"$D$35-$A39*$B$24","v":116.42333876589676},{"$f":"MdistExit-SQRT(MarmRadius^2+AdistExit^2-2*MarmRadius*AdistExit*COS(PI()*B39/180))+$B$22+$B$25+$E$24","v":2.9912766152198795},{"$f":"SQRT(($B$23+C39)^2-$E$23)","v":11.340141110125421},{"$f":"($E$20-D39^2+$E$21)/$E$22","v":129.50538922924017},{"$f":"360*ACOS(E39/$B$20)/(2*PI())","v":4.9996031333638147},{"$f":"IF(ABS($B$26-$F$39)<0.1,\"\",\"OFF\")","v":""},{"$f":"A39","v":0},{"$f":"$D$36-$A39*$B$24","v":125.3765401519416},{"$f":"JdistExit-SQRT(JarmRadius^2+AdistExit^2-2*JarmRadius*AdistExit*COS(PI()*I39/180))+$H$25","v":34.345829663709381},{"$f":"SQRT(J39^2-$K$23)","v":32.945315612103755},{"$f":"($K$24+$K$25-K39^2)/$K$26","v":0.96592583249337338},{"$f":"180*ACOS(L39)/PI()","v":14.999998626528766},{"$f":"IF(ABS($H$26-$M$39)<0.1,\"\",\"OFF\")","v":""},{"$f":"M39-F39","v":10.000395493164952},{"$f":"O39/M39","v":0.66669309392324916}]
[1,111.42333876589676,{"$f":"MdistExit-SQRT(MarmRadius^2+AdistExit^2-2*MarmRadius*AdistExit*COS(PI()*B40/180))+$B$22+$B$25+$E$24","v":7.7486665682314761},{"$f":"SQRT(($B$23+C40)^2-$E$23)","v":19.235085035291302},{"$f":"($E$20-D40^2+$E$21)/$E$22","v":128.57696732186582},{"$f":"360*ACOS(E40/$B$20)/(2*PI())","v":8.4853615499449617},{"$f":"IF(ABS($B$26-$F$39)<0.1,\"\",\"OFF\")","v":""},{"$f":"A40","v":1},{"$f":"$D$36-$A40*$B$24","v":120.3765401519416},{"$f":"JdistExit-SQRT(JarmRadius^2+AdistExit^2-2*JarmRadius*AdistExit*COS(PI()*I40/180))+$H$25","v":38.175751794891212},{"$f":"SQRT(J40^2-$K$23)","v":36.920804847642849},{"$f":"($K$24+$K$25-K40^2)/$K$26","v":0.95720626147077248},{"$f":"180*ACOS(L40)/PI()","v":16.822432634106889},{"$f":"IF(ABS($H$26-$M$39)<0.1,\"\",\"OFF\")","v":""},{"$f":"M40-F40","v":8.3370710841619271},{"$f":"O40/M40","v":0.49559247853718907}]
[2,106.42333876589676,12.820605221243488,26.022915422540866,127.39541489581262,11.488491549208728,"",2,115.3765401519416,42.308021583840016,41.179199795907408,0.9467654342984958,18.779334385748985,"",7.2908428365402571,0.38823755340727284]
[3,101.42333876589676,18.197437850759748,32.542960196679303,125.92675285245133,14.380595580654781,"",3,110.3765401519416,46.734485013147875,45.715094825852994,0.93439194557429639,20.869869446676137,"",6.4892738660213567,0.31093983997369368]
[4,96.423338765896759,23.868929350270868,39.044627829434575,124.13660399100362,17.273747587800589,"",4,105.3765401519416,51.446371759077877,50.522143389466699,0.91986883746721038,23.093085603709952,"",5.8193380159093628,0.25199482285617453]
[5,91.423338765896759,29.824283713360934,45.633970324194713,121.99054135557891,20.217290103171138,"",5,100.3765401519416,56.434298994582932,55.593056297550078,0.902976036833816,25.447946025503114,"",5.2306559223319766,0.20554334393392618]
[6,86.423338765896759,36.052164584519637,52.362631280428197,119.45444171303816,23.237062470494433,"",6,95.376540151941597,61.6882723707282,60.919625356511638,0.88349290947951031,27.933374984107104,"",4.6963125136126713,0.16812549562251866]
[7,81.423338765896759,42.54071683853909,59.256571472523845,116.49484129739106,26.348098829951354,"",7,90.376540151941597,67.19768268005275,66.492754214738682,0.86120093071719606,30.548308095251489,"",4.2002092653001348,0.13749400628681713]
[8,76.423338765896759,49.277589147418588,66.327855069182874,113.0792909304672,29.559866972874413,"",8,85.376540151941597,72.951296031682503,72.302485421973998,0.83588647931327731,33.291742380186925,"",3.7318754073125113,0.11209612776330627]
[9,71.423338765896759,56.249957491819394,73.580269213317408,109.17670762498359,32.878795677006558,"",9,80.376540151941597,78.937234328428246,78.338016115509191,0.80734377456871376,36.162783062784392,"",3.2839873857778343,9.0811245917558542E-2]
[10,66.423338765896759,63.444549572314408,81.012300629758911,104.75771979489832,36.309644931968656,"",10,75.376540151941597,85.142941195767079,84.587695564771352,0.77537799659668283,39.160684373890291,"",2.8510394419216354,7.2803616369445184E-2]
[11,61.423338765896759,70.847670073964522,88.618842002521717,99.795003238969585,39.856326543249772,"",11,70.376540151941597,91.555125860201869,91.038996461790987,0.73980866296502146,42.284880858028956,"",2.4285543147791842,5.743315968970162E-2]
[12,56.423338765896759,78.445226736128987,96.392233437802687,94.263605126431358,43.522445424815679,"",12,65.376540151941597,98.159673068117584,97.678448095433595,0.70047339003479991,45.53500350129486,"",2.0125580764791806,4.4198043740612654E-2]
[13,51.423338765896759,86.222757177884532,104.32293200668691,88.141253298185319,47.311695543370298,"",13,60.376540151941597,104.94149959273963,104.49151229772474,0.65723226181542216,48.910870619171689,"",1.5991750758013907,3.2695698431803401E-2]
[14,46.423338765896759,94.16545642798927,112.39996192797894,81.40864830226495,51.228184357665597,"",14,55.376540151941597,111.88432452086259,111.46236978901122,0.60997319637342262,52.412435086563065,"",1.1842507288974673,2.2594842749465625E-2]
[15,41.423338765896759,102.25820510698713,120.61122964294053,74.049735707761016,55.276732015001969,"",15,50.376540151941597,118.97029595060378,118.57355997045394,0.55861900709939882,56.039653413284384,"",0.76292139828241545,1.3613956400764649E-2]
[16,36.423338765896759,110.48559820780592,128.94375261969449,66.051956385965497,59.463179658670398,"",16,45.376540151941597,126.17936958358004,125.8053699728365,0.50313744558054241,59.792210278119946,"",0.32903061944954715,5.5029010956290222E-3]
[17,31.423338765896759,118.83197442006369,137.38383136808062,57.40647261010303,63.79473822965533,"",17,40.376540151941597,133.48823964004188,133.13477354804729,0.44355670058423058,63.668966194668293,"",-0.12577203498703682,-1.9754056411484359E-3]
[18,26.423338765896759,127.28144594226349,145.91718308288398,48.108368004446604,68.280412843707239,"",18,35.376540151941597,140.86841982006956,140.53351738320632,0.3799913596936883,67.666852541511432,"",-0.61356030219580759,-9.0673687211830657E-3]
[19,21.423338765896759,135.81792872512619,154.52904876491186,38.156819568505739,72.931548517038607,"",19,30.376540151941597,148.28261104985017,147.96449082551439,0.3126895972128837,71.778606906911762,"",-1.1529416101268453,-1.6062468468105995E-2]
[20,16.423338765896759,144.42517308849264,163.20428163862849,27.555240210843195,77.762563442300703,"",20,25.376540151941597,155.67736506520328,155.37438591716835,0.24212643372638051,75.98792174471599,"",-1.7746416975847126,-2.3354260214494112E-2]

{"sheet":"Graph","index":1,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
["Step","MSA","JSA"]
[{"$f":"Sheeting!A39","v":0},{"$f":"IF(Sheeting!F39<$H$25,Sheeting!F39,$H$25)","v":4.9996031333638147},{"$f":"Sheeting!M39","v":14.999998626528766}]
[{"$f":"Sheeting!A40","v":1},{"$f":"IF(Sheeting!F40<$H$25,Sheeting!F40,$H$25)","v":8.4853615499449617},{"$f":"Sheeting!M40","v":16.822432634106889}]
[{"$f":"Sheeting!A41","v":2},{"$f":"IF(Sheeting!F41<$H$25,Sheeting!F41,$H$25)","v":11.488491549208728},{"$f":"Sheeting!M41","v":18.779334385748985}]
[{"$f":"Sheeting!A42","v":3},{"$f":"IF(Sheeting!F42<$H$25,Sheeting!F42,$H$25)","v":14.380595580654781},{"$f":"Sheeting!M42","v":20.869869446676137}]
[{"$f":"Sheeting!A43","v":4},{"$f":"IF(Sheeting!F43<$H$25,Sheeting!F43,$H$25)","v":17.273747587800589},{"$f":"Sheeting!M43","v":23.093085603709952}]
[{"$f":"Sheeting!A44","v":5},{"$f":"IF(Sheeting!F44<$H$25,Sheeting!F44,$H$25)","v":20.217290103171138},{"$f":"Sheeting!M44","v":25.447946025503114}]
[{"$f":"Sheeting!A45","v":6},{"$f":"IF(Sheeting!F45<$H$25,Sheeting!F45,$H$25)","v":23.237062470494433},{"$f":"Sheeting!M45","v":27.933374984107104}]
[{"$f":"Sheeting!A46","v":7},{"$f":"IF(Sheeting!F46<$H$25,Sheeting!F46,$H$25)","v":26.348098829951354},{"$f":"Sheeting!M46","v":30.548308095251489}]
[{"$f":"Sheeting!A47","v":8},{"$f":"IF(Sheeting!F47<$H$25,Sheeting!F47,$H$25)","v":29.559866972874413},{"$f":"Sheeting!M47","v":33.291742380186925}]
[{"$f":"Sheeting!A48","v":9},{"$f":"IF(Sheeting!F48<$H$25,Sheeting!F48,$H$25)","v":32.878795677006558},{"$f":"Sheeting!M48","v":36.162783062784392}]
[{"$f":"Sheeting!A49","v":10},{"$f":"IF(Sheeting!F49<$H$25,Sheeting!F49,$H$25)","v":36.309644931968656},{"$f":"Sheeting!M49","v":39.160684373890291}]
[{"$f":"Sheeting!A50","v":11},{"$f":"IF(Sheeting!F50<$H$25,Sheeting!F50,$H$25)","v":39.856326543249772},{"$f":"Sheeting!M50","v":42.284880858028956}]
[{"$f":"Sheeting!A51","v":12},{"$f":"IF(Sheeting!F51<$H$25,Sheeting!F51,$H$25)","v":43.522445424815679},{"$f":"Sheeting!M51","v":45.53500350129486}]
[{"$f":"Sheeting!A52","v":13},{"$f":"IF(Sheeting!F52<$H$25,Sheeting!F52,$H$25)","v":47.311695543370298},{"$f":"Sheeting!M52","v":48.910870619171689}]
[{"$f":"Sheeting!A53","v":14},{"$f":"IF(Sheeting!F53<$H$25,Sheeting!F53,$H$25)","v":51.228184357665597},{"$f":"Sheeting!M53","v":52.412435086563065}]
[{"$f":"Sheeting!A54","v":15},{"$f":"IF(Sheeting!F54<$H$25,Sheeting!F54,$H$25)","v":55.276732015001969},{"$f":"Sheeting!M54","v":56.039653413284384}]
[{"$f":"Sheeting!A55","v":16},{"$f":"IF(Sheeting!F55<$H$25,Sheeting!F55,$H$25)","v":59.463179658670398},{"$f":"Sheeting!M55","v":59.792210278119946}]
[{"$f":"Sheeting!A56","v":17},{"$f":"IF(Sheeting!F56<$H$25,Sheeting!F56,$H$25)","v":63.79473822965533},{"$f":"Sheeting!M56","v":63.668966194668293}]
[{"$f":"Sheeting!A57","v":18},{"$f":"IF(Sheeting!F57<$H$25,Sheeting!F57,$H$25)","v":68.280412843707239},{"$f":"Sheeting!M57","v":67.666852541511432}]
[{"$f":"Sheeting!A58","v":19},{"$f":"IF(Sheeting!F58<$H$25,Sheeting!F58,$H$25)","v":72.931548517038607},{"$f":"Sheeting!M58","v":71.778606906911762}]
[{"$f":"Sheeting!A59","v":20},{"$f":"IF(Sheeting!F59<$H$25,Sheeting!F59,$H$25)","v":77.762563442300703},{"$f":"Sheeting!M59","v":75.98792174471599}]
[]
["R",{"$f":"Sheeting!B20","v":130},{"$f":"Sheeting!H21","v":130},null,"Max main sheeting angle",null,null,80]
["F",{"$f":"Sheeting!B21","v":130},{"$f":"Sheeting!H22","v":130}]
["Ht",{"$f":"Sheeting!B23","v":20},{"$f":"Sheeting!H23","v":10}]