{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Select Winches","Vessel Sheet Loads","Comparative Handle Loads","Price Analysis","Harken Winch Specs","Anderson Winch Specs","Lewmar Winch Specs"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":31,"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":"Select Winches","index":0,"n_rows":26,"n_cols":13,"rows_kept":26,"cut":false,"hidden":false,"merged":[[5,11,5,12],[11,11,11,12],[17,11,17,12],[1,0,1,10],[0,0,0,10],[5,1,5,10],[11,1,11,10],[17,1,17,10],[2,1,2,2]]}
["COMPARISON OF SPECIFICATIONS"]
["Self-Tailing Winches"]
[null,"Calculated Power Ratios"]
[null,"Power Ratio = ( 2 * length of handle * gear ratio ) / diameter of drum"]
[null,"For manufacturer's power ratios see following Specs worksheets"]
[null,"Anderson (S/S)",null,null,null,null,null,null,null,null,null,"Mfg. Stated Power Ratio"]
["Function","Model","1st Power Ratio","2nd Power Ratio",null,"1st Gear Ratio","2nd Gear Ratio",null,"D","B","H","1st Power Ratio","2nd Power Ratio"]
["Primary","52ST",{"$f":"LenHandle*2*F8/$I8","v":16.256},53.339999999999996,null,{"$f":"VLOOKUP($B8,AndersonSpecs,4)","v":3.2},{"$f":"VLOOKUP($B8,AndersonSpecs,5)","v":10.5},null,{"$f":"VLOOKUP($B8,AndersonSpecs,10)","v":3.9370078740157481},{"$f":"VLOOKUP($B8,AndersonSpecs,11)","v":7.8740157480314963},{"$f":"VLOOKUP($B8,AndersonSpecs,12)","v":8.8582677165354333},{"$f":"VLOOKUP($B8,AndersonSpecs,7)","v":16.2},{"$f":"VLOOKUP($B8,AndersonSpecs,8)","v":52}]
["Secondary","40ST",8.689473684210526,40.10526315789474,null,{"$f":"VLOOKUP(B9,AndersonSpecs,4)","v":1.3},{"$f":"VLOOKUP(B9,AndersonSpecs,5)","v":6},null,{"$f":"VLOOKUP($B9,AndersonSpecs,10)","v":2.9921259842519685},{"$f":"VLOOKUP($B9,AndersonSpecs,11)","v":5.984251968503937},{"$f":"VLOOKUP($B9,AndersonSpecs,12)","v":6.771653543307087},{"$f":"VLOOKUP($B9,AndersonSpecs,7)","v":8.5},{"$f":"VLOOKUP($B9,AndersonSpecs,8)","v":39.5}]
["Trim","28ST",9.4342857142857142,26.851428571428571,null,{"$f":"VLOOKUP(B10,AndersonSpecs,4)","v":1.3},{"$f":"VLOOKUP(B10,AndersonSpecs,5)","v":3.7},null,{"$f":"VLOOKUP($B10,AndersonSpecs,10)","v":2.7559055118110236},{"$f":"VLOOKUP($B10,AndersonSpecs,11)","v":4.9212598425196852},{"$f":"VLOOKUP($B10,AndersonSpecs,12)","v":5.984251968503937},{"$f":"VLOOKUP($B10,AndersonSpecs,7)","v":9.5},{"$f":"VLOOKUP($B10,AndersonSpecs,8)","v":26.5}]
[]
[null,"Harken Chrome",null,null,null,null,null,null,null,null,null,"Mfg. Stated Power Ratio"]
["Model","Model","1st Power Ratio","2nd Power Ratio","3rd Power Ratio","1st Gear Ratio","2nd Gear Ratio","3rd Gear Ratio*","D","B","H","1st Power Ratio","2nd Power Ratio"]
["Primary","B56.3STC",{"$f":"LenHandle*2*F14/$I14","v":21.05263157894737},54.736842105263158,9.2631578947368425,{"$f":"VLOOKUP($B14,HarkenSpecs,4)","v":5},{"$f":"VLOOKUP($B14,HarkenSpecs,5)","v":13},{"$f":"VLOOKUP($B14,HarkenSpecs,6)","v":2.2000000000000002},{"$f":"VLOOKUP($B14,HarkenSpecs,10)","v":4.75},{"$f":"VLOOKUP($B14,HarkenSpecs,11)","v":8.875},{"$f":"VLOOKUP($B14,HarkenSpecs,12)","v":10.625},{"$f":"VLOOKUP($B14,HarkenSpecs,7)","v":21},{"$f":"VLOOKUP($B14,HarkenSpecs,8)","v":56}]
["Secondary","B40.2STC",14.666666666666666,40,{"$error":"#N/A"},{"$f":"VLOOKUP(B15,HarkenSpecs,4)","v":2.2000000000000002},{"$f":"VLOOKUP(B15,HarkenSpecs,5)","v":6},{"$f":"VLOOKUP($B15,HarkenSpecs,6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B15,HarkenSpecs,10)","v":3},{"$f":"VLOOKUP($B15,HarkenSpecs,11)","v":5.875},{"$f":"VLOOKUP($B15,HarkenSpecs,12)","v":6.9375},{"$f":"VLOOKUP($B15,HarkenSpecs,7)","v":13.5},{"$f":"VLOOKUP($B15,HarkenSpecs,8)","v":40}]
["Trim","B32.2STC",16.340425531914892,32,{"$error":"#N/A"},{"$f":"VLOOKUP(B16,HarkenSpecs,4)","v":2.4},{"$f":"VLOOKUP(B16,HarkenSpecs,5)","v":4.7},{"$f":"VLOOKUP($B16,HarkenSpecs,6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B16,HarkenSpecs,10)","v":2.9375},{"$f":"VLOOKUP($B16,HarkenSpecs,11)","v":5.375},{"$f":"VLOOKUP($B16,HarkenSpecs,12)","v":6.4375},{"$f":"VLOOKUP($B16,HarkenSpecs,7)","v":16},{"$f":"VLOOKUP($B16,HarkenSpecs,8)","v":32}]
[]
[null,"Lewmar Chrome",null,null,null,null,null,null,null,null,null,"Mfg. Stated Power Ratio"]
["Model","Model","1st Power Ratio","2nd Power Ratio",null,"1st Gear Ratio","2nd Gear Ratio",null,"D","B","H","1st Power Ratio","2nd Power Ratio"]
["Primary","54CST",{"$f":"LenHandle*2*F20/$I20","v":13.575757575757576},54.303030303030305,null,{"$f":"VLOOKUP($B20,LewmarSpecs,4)","v":2.8},{"$f":"VLOOKUP($B20,LewmarSpecs,5)","v":11.2},null,{"$f":"VLOOKUP($B20,LewmarSpecs,10)","v":4.125},{"$f":"VLOOKUP($B20,LewmarSpecs,11)","v":8.0625},{"$f":"VLOOKUP($B20,LewmarSpecs,12)","v":9.875},{"$f":"VLOOKUP($B20,LewmarSpecs,7)","v":13.8},{"$f":"VLOOKUP($B20,LewmarSpecs,8)","v":54}]
["Secondary","40CST",13.103448275862069,40,null,{"$f":"VLOOKUP(B21,LewmarSpecs,4)","v":1.9},{"$f":"VLOOKUP(B21,LewmarSpecs,5)","v":5.8},null,{"$f":"VLOOKUP($B21,LewmarSpecs,10)","v":2.9},{"$f":"VLOOKUP($B21,LewmarSpecs,11)","v":5.8125},{"$f":"VLOOKUP($B21,LewmarSpecs,12)","v":6.8125},{"$f":"VLOOKUP($B21,LewmarSpecs,7)","v":13.2},{"$f":"VLOOKUP($B21,LewmarSpecs,8)","v":40.200000000000003}]
["Trim","30CST",13.617021276595745,28.595744680851062,null,{"$f":"VLOOKUP(B22,LewmarSpecs,4)","v":2},{"$f":"VLOOKUP(B22,LewmarSpecs,5)","v":4.2},null,{"$f":"VLOOKUP($B22,LewmarSpecs,10)","v":2.9375},{"$f":"VLOOKUP($B22,LewmarSpecs,11)","v":5.4375},{"$f":"VLOOKUP($B22,LewmarSpecs,12)","v":6.3125},{"$f":"VLOOKUP($B22,LewmarSpecs,7)","v":13.8},{"$f":"VLOOKUP($B22,LewmarSpecs,8)","v":29.2}]
[]
[null,"* \"3rd Power Ratio\" actually refers to the LOWEST power ratio.  Only Harken has 3-speed winchs."]
[]
["Spreadsheet written by Jeff Stander, KP44 Beatrix."]

{"sheet":"Vessel Sheet Loads","index":1,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,2,31,4],[31,5,31,7],[31,8,31,10],[31,11,31,13],[0,0,0,13],[18,0,19,0],[18,2,18,13],[18,1,19,1],[28,0,28,13],[29,0,30,0],[29,1,30,1],[29,2,29,13],[26,0,26,7],[24,0,24,7],[1,0,2,0],[1,2,1,13],[8,0,8,7],[9,0,9,7],[25,0,25,7],[17,0,17,13]]}
["Calculated Genoa Sheet Loadings",null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDDEN","HIDDEN","HIDDEN"]
["Sail","Area",{"$f":"C19","v":"Load (lbs.) for Apparent Wind (Knots)"},null,null,null,null,null,null,null,null,null,null,null,true,true,{"$f":"IF(P2,Q4,1)","v":0.2}]
[null,"Square Feet",5,{"$f":"C3+5","v":10},{"$f":"D3+5","v":15},{"$f":"E3+5","v":20},{"$f":"F3+5","v":25},{"$f":"G3+5","v":30},35,40,45,50,55,60,{"$f":"IF(NOT(UseFPS),1/2.2,1)","v":1}]
["Furling Genoa",479.6,{"$f":"KgPerLb*$B4*C$3*C$3*0.00431","v":51.676899999999996},206.70759999999999,465.09209999999996,826.83039999999994,1291.9224999999999,1860.3683999999998,2532.1680999999999,3307.3215999999998,4185.8288999999995,5167.6899999999996,6252.9048999999995,7441.4735999999994,null,null,{"$f":"VLOOKUP(B16,TravellerBlock,2)","v":0.2}]
["Genoa Part Furled (100%)",385,41.483749999999993,165.93499999999997,373.35374999999999,663.7399999999999,1037.09375,1493.415,2032.7037499999999,2654.9599999999996,3360.1837499999997,4148.375,5019.5337499999996,5973.66,null,"1:1",{"$f":"1/LEFT(P5)","v":1}]
["Working Staysail",160,17.239999999999998,68.959999999999994,155.16,275.83999999999997,430.99999999999994,620.64,844.75999999999988,1103.3599999999999,1396.4399999999998,1723.9999999999998,2086.04,2482.56,null,"2:1",{"$f":"1/LEFT(P6)","v":0.5}]
["Storm Staysail",115,12.391249999999999,49.564999999999998,111.52124999999999,198.26,309.78124999999994,446.08499999999998,607.17124999999999,793.04,1003.6912499999999,1239.1249999999998,1499.3412499999999,1784.34,null,"3:1",0.33333333333333331]
["Asym. Cr. Spinnaker",1295,139.53625,558.14499999999998,1255.8262499999998,2232.58,3488.4062499999995,5023.3049999999994,6837.276249999999,8930.32,11302.436249999999,13953.624999999998,16883.88625,20093.219999999998,null,"4:1",0.25]
["Genoa Sheet Load (lbs.) = SA * V**2 * 0.00431 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5:1",0.2]
["Formula Source: Harken (http://www.harken.com/content.aspx?id=9096)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6:1",0.16666666666666666]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7:1",0.14285714285714285]
["Mainsail Dimensions",{"$f":"B21","v":1},{"$f":"B22","v":0.75},{"$f":"B23","v":0.50127226463104324},{"$f":"B24","v":0.27989821882951654},null,null,null,null,null,null,null,null,null,null,"8:1",0.125]
["P. Foot length of Main in feet",45.33,{"$f":"SQRT($B$22)*P","v":39.256931553548597},{"$f":"SQRT($B$23)*P","v":32.093904572161719},{"$f":"SQRT($B$24)*P","v":23.982021414906587}]
["E. Luff Length of Main in feet",14.6,{"$f":"SQRT($B$22)*E","v":12.643970895252803},{"$f":"SQRT($B$23)*E","v":10.336885214064882},{"$f":"SQRT($B$24)*E","v":7.7241895578565227}]
["X. Distance from Aft end of boom to mainsheet attachment point in feet",0,{"$f":"X-(E-E_2)","v":-1.9560291047471967},{"$f":"X-(E-E_3)","v":-4.2631147859351177},{"$f":"X-(E-E_4)","v":-6.8758104421434769}]
["R: Traveller Block Ratio","5:1"]
[]
[{"$f":"CONCATENATE(\"Calculated Main Sheet Loadings\",IF(P2,\" Including Traveller Purchase\",\"\"))","v":"Calculated Main Sheet Loadings Including Traveller Purchase"}]
["Sail","Area as % of Main",{"$f":"CONCATENATE(\"Load (\",IF(UseFPS,\"lbs.\",\"kg.\"),\") for Apparent Wind (Knots)\")","v":"Load (lbs.) for Apparent Wind (Knots)"}]
[null,null,5,{"$f":"C20+5","v":10},{"$f":"D20+5","v":15},{"$f":"E20+5","v":20},{"$f":"F20+5","v":25},{"$f":"G20+5","v":30},35,40,45,50,55,60]
["Mainsail",1,{"$f":"KgPerLb*E^2*P^2*0.00431*C$3^2/(SQRT(P^2+E^2)*(E-X))*tp","v":13.575412065219911},54.301648260879645,122.17870858697923,217.20659304351858,339.38530163049785,488.71483434791691,665.19519119577581,868.82637217407432,1099.6083772828131,1357.5412065219914,1642.6248598916093,1954.8593373916676]
["Mainsail 1st Reef",0.75,{"$f":"KgPerLb*E_2^2*P_2^2*0.00431*C$3^2/(SQRT(P_2^2+E_2^2)*(E_2-X_2))*tp","v":8.8174887864916602},35.269955145966641,79.357399078424947,141.07982058386656,220.43721966229151,317.42959631369979,432.05695053809131,564.31928233546626,714.2165917058245,881.74887864916604,1066.9161431654909,1269.7183852547992]
["Mainsail 2nd Reef",{"$f":"197/393","v":0.50127226463104324},{"$f":"KgPerLb*E_3^2*P_3^2*0.00431*C$3^2/(SQRT(P_3^2+E_3^2)*(E_3-X_3))*tp","v":4.817963822650932},19.271855290603728,43.361674403858387,77.087421162414913,120.44909556627329,173.44669761543355,236.08022730989566,308.34968464965965,390.25506963472549,481.79638226509314,582.97362254076279,693.7867904617342]
["Storm Trysail / Third Reef",{"$f":"110/393","v":0.27989821882951654},{"$f":"KgPerLb*E_4^2*P_4^2*0.00431*C$3^2/(SQRT(P_4^2+E_4^2)*(E_4-X_4))*tp","v":2.0102645914731814},8.0410583658927255,18.092381323258632,32.164233463570902,50.25661478682953,72.369525293034528,98.502964982185873,128.65693385428361,162.83143190932768,201.02645914731812,243.24201556825494,289.47810117213811]
["Main Sheet Load (lbs) = E**2 * P**2 * 0.00431 * V**2 /(sqrt(P**2 + E**2) * (E - X))"]
["Formula Source: Harken (http://www.harken.com/MainsheetLoading)"]
["This formula is not so well accepted as the Genoa Sheet Loadings and should only be used as a rough guide"]
[]
["Control Line Loadings"]
[null,"% of Main-sheet loads",{"$f":"CONCATENATE(\"Max \",C19)","v":"Max Load (lbs.) for Apparent Wind (Knots)"}]
[null,null,5,{"$f":"C31+5","v":10},{"$f":"D31+5","v":15},{"$f":"E31+5","v":20},{"$f":"F31+5","v":25},{"$f":"G31+5","v":30},35,40,45,50,55,60]
["Based on Main Sheet Loadings:",null,"No Reef",null,null,"First Reef",null,null,"Second Reef",null,null,"Trysail"]
["Outhaul/Cunningham",0.5,{"$f":"KgPerLb*C21*$B$33","v":6.7877060326099556},{"$f":"KgPerLb*D21*$B$33","v":27.150824130439823},{"$f":"KgPerLb*E21*$B$33","v":61.089354293489613},{"$f":"KgPerLb*F22*$B$33","v":70.539910291933282},{"$f":"KgPerLb*G22*$B$33","v":110.21860983114576},{"$f":"KgPerLb*H22*$B$33","v":158.71479815684989},{"$f":"KgPerLb*I23*$B$33","v":118.04011365494783},{"$f":"KgPerLb*J23*$B$33","v":154.17484232482983},{"$f":"KgPerLb*K23*$B$33","v":195.12753481736274},{"$f":"KgPerLb*L24*$B$33","v":100.51322957365906},{"$f":"KgPerLb*M24*$B$33","v":121.62100778412747},{"$f":"KgPerLb*N24*$B$33","v":144.73905058606906}]

{"sheet":"Comparative Handle Loads","index":2,"n_rows":76,"n_cols":15,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,0,0,14],[19,3,19,14],[39,0,40,0],[39,3,39,14],[10,0,11,0],[10,3,10,14],[28,0,29,0],[39,1,40,1],[28,1,29,1],[8,0,8,14],[1,0,1,12],[71,0,72,0],[71,1,72,1],[49,3,49,14],[49,0,50,0],[59,1,60,1],[49,1,50,1],[71,3,71,14],[69,0,69,14],[28,3,28,14],[59,0,60,0],[59,3,59,14],[3,2,3,8],[37,0,37,14],[4,2,4,12],[5,0,5,8],[19,0,20,0],[19,1,20,1],[10,1,11,1],[6,0,6,8]]}
["Comparative Winch Handle Loads"]
["Power Ratio = 2 * length of handle * gear ratio / diameter of drum.  \nThis formula is the theoretical maximum and is subject to friction losses."]
["Length of Handle (in.) =",10]
["Max Handle Load (lb.) =",30,"  (Brion Toss recommends 35# as desired max handle load)"]
["Friction Losses (in %)",0.2,"  (Some estimates are as high as 35%, depends on # of wraps, load, and internal construction of the winch)"]
["Loads less than Max Handle Load (I.e. allowable loads) are indicated by bold numbers in following pages, e.g:",null,null,null,null,null,null,null,null,75]
["Greyed out boxes are outside the normal wind range of the subject sail, e.g. ……………………………………….",null,null,null,null,null,null,null,null,114]
[]
["FIRST WINCH SPEED"]
[]
["Sail","Model","1st Speed","Anderson Winch Handle Load (lbs.) for Apparent Wind (Knots)"]
[null,null,"Power Ratio",5,{"$f":"D12+5","v":10},15,20,25,30,35,40,45,50,55,60]
[{"$f":"'Vessel Sheet Loads'!$A$4","v":"Furling Genoa"},{"$f":"'Select Winches'!$B$8","v":"52ST"},{"$f":"VLOOKUP(B13,AndersonSpecs,4)*2*LenHandle/VLOOKUP(B13,AndersonSpecs,10)","v":16.256},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$4/$C13","v":2.5431545275590555},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$4/$C13,0)","v":10},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$4/$C13,0)","v":23},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$4/$C13,0)","v":41},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$4/$C13,0)","v":64},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$4/$C13,0)","v":92},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$4/$C13,0)","v":125},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$4/$C13,0)","v":163},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$4/$C13,0)","v":206},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$4/$C13,0)","v":254},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$4/$C13,0)","v":308},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$4/$C13,0)","v":366}]
[{"$f":"'Vessel Sheet Loads'!$A$5","v":"Genoa Part Furled (100%)"},{"$f":"'Select Winches'!$B$8","v":"52ST"},16.256,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$5/$C14","v":2.0415231299212597},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$5/$C14,0)","v":8},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$5/$C14,0)","v":18},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$5/$C14,0)","v":33},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$5/$C14,0)","v":51},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$5/$C14,0)","v":73},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$5/$C14,0)","v":100},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$5/$C14,0)","v":131},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$5/$C14,0)","v":165},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$5/$C14,0)","v":204},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$5/$C14,0)","v":247},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$5/$C14,0)","v":294}]
[{"$f":"'Vessel Sheet Loads'!$A$6","v":"Working Staysail"},{"$f":"'Select Winches'!$B$9","v":"40ST"},8.689473684210526,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$6/$C15","v":1.5872077528770443},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$6/$C15,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$6/$C15,0)","v":14},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$6/$C15,0)","v":25},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$6/$C15,0)","v":40},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$6/$C15,0)","v":57},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$6/$C15,0)","v":78},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$6/$C15,0)","v":102},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$6/$C15,0)","v":129},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$6/$C15,0)","v":159},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$6/$C15,0)","v":192},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$6/$C15,0)","v":229}]
[{"$f":"'Vessel Sheet Loads'!$A$7","v":"Storm Staysail"},{"$f":"'Select Winches'!$B$9","v":"40ST"},8.689473684210526,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$7/$C16","v":1.1408055723803756},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$7/$C16,0)","v":5},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$7/$C16,0)","v":10},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$7/$C16,0)","v":18},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$7/$C16,0)","v":29},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$7/$C16,0)","v":41},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$7/$C16,0)","v":56},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$7/$C16,0)","v":73},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$7/$C16,0)","v":92},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$7/$C16,0)","v":114},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$7/$C16,0)","v":138},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$7/$C16,0)","v":164}]
[{"$f":"'Vessel Sheet Loads'!$A$8","v":"Asym. Cr. Spinnaker"},{"$f":"'Select Winches'!$B$8","v":"52ST"},16.256,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$8/$C17","v":6.8669414370078741},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$8/$C17,0)","v":27},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$8/$C17,0)","v":62},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$8/$C17,0)","v":110},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$8/$C17,0)","v":172},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$8/$C17,0)","v":247},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$8/$C17,0)","v":336},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$8/$C17,0)","v":439},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$8/$C17,0)","v":556},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$8/$C17,0)","v":687},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$8/$C17,0)","v":831},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$8/$C17,0)","v":989}]
[{"$f":"'Vessel Sheet Loads'!$A$24","v":"Storm Trysail / Third Reef"},{"$f":"'Select Winches'!$B$8","v":"52ST"},16.256,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$24/$C18","v":9.8930344068562076E-2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$24/$C18,0)","v":0},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$24/$C18,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$24/$C18,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$24/$C18,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$24/$C18,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$24/$C18,0)","v":5},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$24/$C18,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$24/$C18,0)","v":8},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$24/$C18,0)","v":10},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$24/$C18,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$24/$C18,0)","v":14}]
[]
["Sail","Model","1st Speed","Harken Winch Handle Load (lbs.) for Apparent Wind (Knots)"]
[null,null,"Power Ratio",5,{"$f":"D21+5","v":10},15,20,25,30,35,40,45,50,55,60]
[{"$f":"$A$13","v":"Furling Genoa"},{"$f":"'Select Winches'!$B$14","v":"B56.3STC"},{"$f":"VLOOKUP(B22,HarkenSpecs,4)*2*LenHandle/VLOOKUP(B22,HarkenSpecs,10)","v":21.05263157894737},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$4/$C22","v":1.9637222000000001},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$4/$C22,0)","v":8},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$4/$C22,0)","v":18},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$4/$C22,0)","v":31},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$4/$C22,0)","v":49},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$4/$C22,0)","v":71},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$4/$C22,0)","v":96},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$4/$C22,0)","v":126},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$4/$C22,0)","v":159},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$4/$C22,0)","v":196},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$4/$C22,0)","v":238},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$4/$C22,0)","v":283}]
[{"$f":"$A$14","v":"Genoa Part Furled (100%)"},{"$f":"'Select Winches'!$B$14","v":"B56.3STC"},21.05263157894737,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$5/$C23","v":1.5763824999999998},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$5/$C23,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$5/$C23,0)","v":14},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$5/$C23,0)","v":25},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$5/$C23,0)","v":39},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$5/$C23,0)","v":57},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$5/$C23,0)","v":77},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$5/$C23,0)","v":101},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$5/$C23,0)","v":128},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$5/$C23,0)","v":158},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$5/$C23,0)","v":191},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$5/$C23,0)","v":227}]
[{"$f":"$A$15","v":"Working Staysail"},{"$f":"'Select Winches'!$B$15","v":"B40.2STC"},14.666666666666666,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$6/$C24","v":0.9403636363636364},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$6/$C24,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$6/$C24,0)","v":8},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$6/$C24,0)","v":15},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$6/$C24,0)","v":24},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$6/$C24,0)","v":34},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$6/$C24,0)","v":46},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$6/$C24,0)","v":60},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$6/$C24,0)","v":76},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$6/$C24,0)","v":94},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$6/$C24,0)","v":114},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$6/$C24,0)","v":135}]
[{"$f":"$A$16","v":"Storm Staysail"},{"$f":"'Select Winches'!$B$15","v":"B40.2STC"},14.666666666666666,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$7/$C25","v":0.67588636363636367},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$7/$C25,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$7/$C25,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$7/$C25,0)","v":11},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$7/$C25,0)","v":17},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$7/$C25,0)","v":24},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$7/$C25,0)","v":33},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$7/$C25,0)","v":43},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$7/$C25,0)","v":55},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$7/$C25,0)","v":68},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$7/$C25,0)","v":82},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$7/$C25,0)","v":97}]
[{"$f":"$A$17","v":"Asym. Cr. Spinnaker"},{"$f":"'Select Winches'!$B$14","v":"B56.3STC"},21.05263157894737,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$8/$C26","v":5.3023774999999995},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$8/$C26,0)","v":21},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$8/$C26,0)","v":48},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$8/$C26,0)","v":85},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$8/$C26,0)","v":133},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$8/$C26,0)","v":191},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$8/$C26,0)","v":260},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$8/$C26,0)","v":339},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$8/$C26,0)","v":429},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$8/$C26,0)","v":530},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$8/$C26,0)","v":642},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$8/$C26,0)","v":764}]
[{"$f":"$A$18","v":"Storm Trysail / Third Reef"},{"$f":"'Select Winches'!$B$14","v":"B56.3STC"},21.05263157894737,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$24/$C27","v":7.6390054475980892E-2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$24/$C27,0)","v":0},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$24/$C27,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$24/$C27,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$24/$C27,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$24/$C27,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$24/$C27,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$24/$C27,0)","v":5},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$24/$C27,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$24/$C27,0)","v":8},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$24/$C27,0)","v":9},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$24/$C27,0)","v":11}]
[]
["Sail","Model","1st Speed","Lewmar Winch Handle Load (lbs.) for Apparent Wind (Knots)"]
[null,null,"Power Ratio",5,{"$f":"D30+5","v":10},15,20,25,30,35,40,45,50,55,60]
[{"$f":"$A$13","v":"Furling Genoa"},{"$f":"'Select Winches'!$B$20","v":"54CST"},{"$f":"VLOOKUP(B31,LewmarSpecs,4)*2*LenHandle/VLOOKUP(B31,LewmarSpecs,10)","v":13.575757575757576},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$4/$C31","v":3.0452458928571429},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$4/$C31,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$4/$C31,0)","v":27},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$4/$C31,0)","v":49},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$4/$C31,0)","v":76},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$4/$C31,0)","v":110},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$4/$C31,0)","v":149},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$4/$C31,0)","v":195},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$4/$C31,0)","v":247},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$4/$C31,0)","v":305},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$4/$C31,0)","v":368},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$4/$C31,0)","v":439}]
[{"$f":"$A$14","v":"Genoa Part Furled (100%)"},{"$f":"'Select Winches'!$B$20","v":"54CST"},13.575757575757576,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$5/$C32","v":2.4445781249999996},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$5/$C32,0)","v":10},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$5/$C32,0)","v":22},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$5/$C32,0)","v":39},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$5/$C32,0)","v":61},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$5/$C32,0)","v":88},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$5/$C32,0)","v":120},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$5/$C32,0)","v":156},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$5/$C32,0)","v":198},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$5/$C32,0)","v":244},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$5/$C32,0)","v":296},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$5/$C32,0)","v":352}]
[{"$f":"$A$15","v":"Working Staysail"},{"$f":"'Select Winches'!$B$21","v":"40CST"},13.103448275862069,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$6/$C33","v":1.0525473684210527},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$6/$C33,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$6/$C33,0)","v":9},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$6/$C33,0)","v":17},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$6/$C33,0)","v":26},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$6/$C33,0)","v":38},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$6/$C33,0)","v":52},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$6/$C33,0)","v":67},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$6/$C33,0)","v":85},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$6/$C33,0)","v":105},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$6/$C33,0)","v":127},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$6/$C33,0)","v":152}]
[{"$f":"$A$16","v":"Storm Staysail"},{"$f":"'Select Winches'!$B$21","v":"40CST"},13.103448275862069,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$7/$C34","v":0.75651842105263156},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$7/$C34,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$7/$C34,0)","v":7},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$7/$C34,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$7/$C34,0)","v":19},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$7/$C34,0)","v":27},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$7/$C34,0)","v":37},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$7/$C34,0)","v":48},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$7/$C34,0)","v":61},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$7/$C34,0)","v":76},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$7/$C34,0)","v":92},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$7/$C34,0)","v":109}]
[{"$f":"$A$17","v":"Asym. Cr. Spinnaker"},{"$f":"'Select Winches'!$B$20","v":"54CST"},13.575757575757576,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$8/$C35","v":8.2226718749999996},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$8/$C35,0)","v":33},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$8/$C35,0)","v":74},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$8/$C35,0)","v":132},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$8/$C35,0)","v":206},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$8/$C35,0)","v":296},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$8/$C35,0)","v":403},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$8/$C35,0)","v":526},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$8/$C35,0)","v":666},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$8/$C35,0)","v":822},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$8/$C35,0)","v":995},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$8/$C35,0)","v":1184}]
[{"$f":"$A$18","v":"Storm Trysail / Third Reef"},{"$f":"'Select Winches'!$B$20","v":"54CST"},13.575757575757576,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$24/$C36","v":0.11846202056895533},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$24/$C36,0)","v":0},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$24/$C36,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$24/$C36,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$24/$C36,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$24/$C36,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$24/$C36,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$24/$C36,0)","v":8},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$24/$C36,0)","v":10},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$24/$C36,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$24/$C36,0)","v":14},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$24/$C36,0)","v":17}]
[]
["SECOND WINCH SPEED"]
[]
["Sail","Model","2nd Speed","Anderson Winch Handle Load (lbs.) for Apparent Wind (Knots)"]
[null,null,"Power Ratio",5,{"$f":"D41+5","v":10},15,20,25,30,35,40,45,50,55,60]
[{"$f":"$A$13","v":"Furling Genoa"},{"$f":"'Select Winches'!$B$8","v":"52ST"},{"$f":"VLOOKUP(B42,AndersonSpecs,5)*2*LenHandle/VLOOKUP(B42,AndersonSpecs,10)","v":53.339999999999996},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$4/$C42","v":0.77505661792275971},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$4/$C42,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$4/$C42,0)","v":7},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$4/$C42,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$4/$C42,0)","v":19},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$4/$C42,0)","v":28},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$4/$C42,0)","v":38},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$4/$C42,0)","v":50},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$4/$C42,0)","v":63},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$4/$C42,0)","v":78},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$4/$C42,0)","v":94},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$4/$C42,0)","v":112}]
[{"$f":"$A$14","v":"Genoa Part Furled (100%)"},{"$f":"'Select Winches'!$B$8","v":"52ST"},53.339999999999996,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$5/$C43","v":0.62217847769028867},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$5/$C43,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$5/$C43,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$5/$C43,0)","v":10},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$5/$C43,0)","v":16},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$5/$C43,0)","v":22},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$5/$C43,0)","v":30},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$5/$C43,0)","v":40},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$5/$C43,0)","v":50},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$5/$C43,0)","v":62},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$5/$C43,0)","v":75},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$5/$C43,0)","v":90}]
[{"$f":"$A$15","v":"Working Staysail"},{"$f":"'Select Winches'!$B$9","v":"40ST"},40.10526315789474,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$6/$C44","v":0.34389501312335957},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$6/$C44,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$6/$C44,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$6/$C44,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$6/$C44,0)","v":9},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$6/$C44,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$6/$C44,0)","v":17},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$6/$C44,0)","v":22},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$6/$C44,0)","v":28},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$6/$C44,0)","v":34},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$6/$C44,0)","v":42},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$6/$C44,0)","v":50}]
[{"$f":"$A$16","v":"Storm Staysail"},{"$f":"'Select Winches'!$B$9","v":"40ST"},40.10526315789474,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$7/$C45","v":0.24717454068241468},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$7/$C45,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$7/$C45,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$7/$C45,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$7/$C45,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$7/$C45,0)","v":9},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$7/$C45,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$7/$C45,0)","v":16},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$7/$C45,0)","v":20},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$7/$C45,0)","v":25},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$7/$C45,0)","v":30},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$7/$C45,0)","v":36}]
[{"$f":"$A$17","v":"Asym. Cr. Spinnaker"},{"$f":"'Select Winches'!$B$8","v":"52ST"},53.339999999999996,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$8/$C46","v":2.0927821522309715},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$8/$C46,0)","v":8},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$8/$C46,0)","v":19},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$8/$C46,0)","v":33},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$8/$C46,0)","v":52},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$8/$C46,0)","v":75},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$8/$C46,0)","v":103},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$8/$C46,0)","v":134},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$8/$C46,0)","v":170},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$8/$C46,0)","v":209},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$8/$C46,0)","v":253},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$8/$C46,0)","v":301}]
[{"$f":"$A$18","v":"Storm Trysail / Third Reef"},{"$f":"'Select Winches'!$B$9","v":"40ST"},40.10526315789474,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$24/$C47","v":4.0099766129123825E-2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$24/$C47,0)","v":0},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$24/$C47,0)","v":0},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$24/$C47,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$24/$C47,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$24/$C47,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$24/$C47,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$24/$C47,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$24/$C47,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$24/$C47,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$24/$C47,0)","v":5},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$24/$C47,0)","v":6}]
["Control & Trim Lines",{"$f":"'Select Winches'!$B$10","v":"28ST"},26.851428571428571,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$33/$C47","v":0.13539781062424058},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!D$33/$C$58,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!E$33/$C$58,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!F$33/$C$58,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!G$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!H$33/$C$58,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!I$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!J$33/$C$58,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!K$33/$C$58,0)","v":5},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!L$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!M$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!N$33/$C$58,0)","v":4}]
[]
["Sail","Model","2nd Speed","Harken Winch Handle Load (lbs.) for Apparent Wind (Knots)"]
[null,null,"Power Ratio",5,{"$f":"D51+5","v":10},15,20,25,30,35,40,45,50,55,60]
[{"$f":"$A$13","v":"Furling Genoa"},{"$f":"'Select Winches'!$B$14","v":"B56.3STC"},{"$f":"VLOOKUP(B52,HarkenSpecs,5)*2*LenHandle/VLOOKUP(B52,HarkenSpecs,10)","v":54.736842105263158},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$4/$C52","v":0.75527776923076928},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$4/$C52,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$4/$C52,0)","v":7},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$4/$C52,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$4/$C52,0)","v":19},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$4/$C52,0)","v":27},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$4/$C52,0)","v":37},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$4/$C52,0)","v":48},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$4/$C52,0)","v":61},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$4/$C52,0)","v":76},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$4/$C52,0)","v":91},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$4/$C52,0)","v":109}]
[{"$f":"$A$14","v":"Genoa Part Furled (100%)"},{"$f":"'Select Winches'!$B$14","v":"B56.3STC"},54.736842105263158,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$5/$C53","v":0.60630096153846147},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$5/$C53,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$5/$C53,0)","v":5},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$5/$C53,0)","v":10},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$5/$C53,0)","v":15},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$5/$C53,0)","v":22},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$5/$C53,0)","v":30},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$5/$C53,0)","v":39},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$5/$C53,0)","v":49},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$5/$C53,0)","v":61},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$5/$C53,0)","v":73},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$5/$C53,0)","v":87}]
[{"$f":"$A$15","v":"Working Staysail"},{"$f":"'Select Winches'!$B$15","v":"B40.2STC"},40,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$6/$C54","v":0.3448},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$6/$C54,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$6/$C54,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$6/$C54,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$6/$C54,0)","v":9},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$6/$C54,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$6/$C54,0)","v":17},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$6/$C54,0)","v":22},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$6/$C54,0)","v":28},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$6/$C54,0)","v":34},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$6/$C54,0)","v":42},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$6/$C54,0)","v":50}]
[{"$f":"$A$16","v":"Storm Staysail"},{"$f":"'Select Winches'!$B$15","v":"B40.2STC"},40,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$7/$C55","v":0.24782500000000002},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$7/$C55,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$7/$C55,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$7/$C55,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$7/$C55,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$7/$C55,0)","v":9},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$7/$C55,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$7/$C55,0)","v":16},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$7/$C55,0)","v":20},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$7/$C55,0)","v":25},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$7/$C55,0)","v":30},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$7/$C55,0)","v":36}]
[{"$f":"$A$17","v":"Asym. Cr. Spinnaker"},{"$f":"'Select Winches'!$B$14","v":"B56.3STC"},54.736842105263158,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$8/$C56","v":2.0393759615384615},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$8/$C56,0)","v":8},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$8/$C56,0)","v":18},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$8/$C56,0)","v":33},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$8/$C56,0)","v":51},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$8/$C56,0)","v":73},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$8/$C56,0)","v":100},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$8/$C56,0)","v":131},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$8/$C56,0)","v":165},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$8/$C56,0)","v":204},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$8/$C56,0)","v":247},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$8/$C56,0)","v":294}]
[{"$f":"$A$18","v":"Storm Trysail / Third Reef"},{"$f":"'Select Winches'!$B$15","v":"B40.2STC"},40,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$24/$C57","v":4.0205291829463627E-2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$24/$C57,0)","v":0},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$24/$C57,0)","v":0},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$24/$C57,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$24/$C57,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$24/$C57,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$24/$C57,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$24/$C57,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$24/$C57,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$24/$C57,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$24/$C57,0)","v":5},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$24/$C57,0)","v":6}]
["Control & Trim Lines",{"$f":"'Select Winches'!$B$16","v":"B32.2STC"},32,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$33/$C57","v":0.13575412065219911},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!D$33/$C$58,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!E$33/$C$58,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!F$33/$C$58,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!G$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!H$33/$C$58,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!I$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!J$33/$C$58,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!K$33/$C$58,0)","v":5},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!L$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!M$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!N$33/$C$58,0)","v":4}]
[]
["Sail","Model","2nd Speed","Lewmar Winch Handle Load (lbs.) for Apparent Wind (Knots)"]
[null,null,"Power Ratio",5,{"$f":"D61+5","v":10},15,20,25,30,35,40,45,50,55,60]
[{"$f":"$A$13","v":"Furling Genoa"},{"$f":"'Select Winches'!$B$20","v":"54CST"},{"$f":"VLOOKUP(B62,LewmarSpecs,5)*2*LenHandle/VLOOKUP(B62,LewmarSpecs,10)","v":54.303030303030305},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$4/$C62","v":0.76131147321428572},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$4/$C62,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$4/$C62,0)","v":7},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$4/$C62,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$4/$C62,0)","v":19},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$4/$C62,0)","v":27},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$4/$C62,0)","v":37},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$4/$C62,0)","v":49},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$4/$C62,0)","v":62},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$4/$C62,0)","v":76},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$4/$C62,0)","v":92},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$4/$C62,0)","v":110}]
[{"$f":"$A$14","v":"Genoa Part Furled (100%)"},{"$f":"'Select Winches'!$B$20","v":"54CST"},54.303030303030305,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$5/$C63","v":0.6111445312499999},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$5/$C63,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$5/$C63,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$5/$C63,0)","v":10},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$5/$C63,0)","v":15},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$5/$C63,0)","v":22},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$5/$C63,0)","v":30},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$5/$C63,0)","v":39},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$5/$C63,0)","v":50},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$5/$C63,0)","v":61},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$5/$C63,0)","v":74},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$5/$C63,0)","v":88}]
[{"$f":"$A$15","v":"Working Staysail"},{"$f":"'Select Winches'!$B$21","v":"40CST"},40,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$6/$C64","v":0.3448},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$6/$C64,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$6/$C64,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$6/$C64,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$6/$C64,0)","v":9},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$6/$C64,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$6/$C64,0)","v":17},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$6/$C64,0)","v":22},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$6/$C64,0)","v":28},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$6/$C64,0)","v":34},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$6/$C64,0)","v":42},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$6/$C64,0)","v":50}]
[{"$f":"$A$16","v":"Storm Staysail"},{"$f":"'Select Winches'!$B$21","v":"40CST"},40,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$7/$C65","v":0.24782500000000002},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$7/$C65,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$7/$C65,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$7/$C65,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$7/$C65,0)","v":6},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$7/$C65,0)","v":9},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$7/$C65,0)","v":12},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$7/$C65,0)","v":16},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$7/$C65,0)","v":20},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$7/$C65,0)","v":25},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$7/$C65,0)","v":30},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$7/$C65,0)","v":36}]
[{"$f":"$A$17","v":"Asym. Cr. Spinnaker"},{"$f":"'Select Winches'!$B$21","v":"40CST"},40,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$8/$C66","v":2.7907250000000001},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$8/$C66,0)","v":11},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$8/$C66,0)","v":25},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$8/$C66,0)","v":45},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$8/$C66,0)","v":70},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$8/$C66,0)","v":100},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$8/$C66,0)","v":137},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$8/$C66,0)","v":179},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$8/$C66,0)","v":226},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$8/$C66,0)","v":279},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$8/$C66,0)","v":338},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$8/$C66,0)","v":402}]
[{"$f":"$A$18","v":"Storm Trysail / Third Reef"},{"$f":"'Select Winches'!$B$21","v":"40CST"},40,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$24/$C67","v":4.0205291829463627E-2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$D$24/$C67,0)","v":0},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$E$24/$C67,0)","v":0},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$F$24/$C67,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$G$24/$C67,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$H$24/$C67,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$I$24/$C67,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$J$24/$C67,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$K$24/$C67,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$L$24/$C67,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$M$24/$C67,0)","v":5},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!$N$24/$C67,0)","v":6}]
["Control & Trim Lines",{"$f":"'Select Winches'!$B$22","v":"30CST"},28.595744680851062,{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!$C$33/$C67","v":0.13575412065219911},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!D$33/$C$58,0)","v":1},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!E$33/$C$58,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!F$33/$C$58,0)","v":2},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!G$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!H$33/$C$58,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!I$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!J$33/$C$58,0)","v":4},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!K$33/$C$58,0)","v":5},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!L$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!M$33/$C$58,0)","v":3},{"$f":"ROUND((1-FrictionLosses)*'Vessel Sheet Loads'!N$33/$C$58,0)","v":4}]
[]
["HIGH SPEED for HARKEN 3-SPEED WINCHES"]
[]
["Sail","Model","3rd Speed","3-Speed Harken Winch Handle Load (lbs.) for Apparent Wind (Knots) - Highest Speed"]
[null,null,"Power Ratio",5,{"$f":"D73+5","v":10},15,20,25,30,35,40,45,50,55,60]
[{"$f":"$A$13","v":"Furling Genoa"},{"$f":"'Select Winches'!$B$14","v":"B56.3STC"},{"$f":"VLOOKUP(B74,HarkenSpecs,6)*2*LenHandle/VLOOKUP(B74,HarkenSpecs,10)","v":9.2631578947368425},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!C$4/$C74","v":4.4630049999999999},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!D$4/$C74","v":17.85202},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!E$4/$C74","v":40.167044999999995},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!F$4/$C74","v":71.408079999999998},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!G$4/$C74","v":111.575125},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!H$4/$C74","v":160.66817999999998},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!I$4/$C74","v":218.68724499999999},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!J$4/$C74","v":285.63231999999999},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!K$4/$C74","v":361.50340499999993},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!L$4/$C74","v":446.3005},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!M$4/$C74","v":540.02360499999998},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!N$4/$C74","v":642.67271999999991}]
[{"$f":"$A$14","v":"Genoa Part Furled (100%)"},{"$f":"'Select Winches'!$B$14","v":"B56.3STC"},{"$f":"VLOOKUP(B75,HarkenSpecs,6)*2*LenHandle/VLOOKUP(B75,HarkenSpecs,10)","v":9.2631578947368425},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!C$5/$C75","v":3.5826874999999996},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!D$5/$C75","v":14.330749999999998},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!E$5/$C75","v":32.244187499999995},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!F$5/$C75","v":57.322999999999993},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!G$5/$C75","v":89.567187500000003},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!H$5/$C75","v":128.97674999999998},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!I$5/$C75","v":175.55168749999999},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!J$5/$C75","v":229.29199999999997},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!K$5/$C75","v":290.19768749999997},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!L$5/$C75","v":358.26875000000001},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!M$5/$C75","v":433.50518749999998},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!N$5/$C75","v":515.90699999999993}]
[{"$f":"$A$18","v":"Storm Trysail / Third Reef"},{"$f":"'Select Winches'!$B$14","v":"B56.3STC"},{"$f":"VLOOKUP(B76,HarkenSpecs,6)*2*LenHandle/VLOOKUP(B76,HarkenSpecs,10)","v":9.2631578947368425},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!C$24/$C76","v":0.17361376017268385},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!D$24/$C76","v":0.69445504069073538},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!E$24/$C76","v":1.5625238415541547},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!F$24/$C76","v":2.7778201627629415},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!G$24/$C76","v":4.340344004317096},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!H$24/$C76","v":6.2500953662166188},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!I$24/$C76","v":8.5070742484615085},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!J$24/$C76","v":11.111280651051766},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!K$24/$C76","v":14.062714573987391},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!L$24/$C76","v":17.361376017268384},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!M$24/$C76","v":21.007264980894746},{"$f":"(1-FrictionLosses)*'Vessel Sheet Loads'!N$24/$C76","v":25.000381464866475}]

{"sheet":"Price Analysis","index":3,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,5,3,6],[4,5,4,6],[2,7,2,8],[3,7,3,8],[4,7,4,8],[0,0,0,6],[20,0,23,0],[2,0,5,0],[11,0,14,0],[14,3,14,7],[23,3,23,7],[5,3,5,7],[2,5,2,6]]}
["COMPARATIVE PRICE ANALYSIS"]
[]
["Anderson","Discount",0.4]
[null,"List Price",{"$f":"SUM(F8:F10)","v":15356}]
[null,"Disc. Price",{"$f":"SUM(G8:G10)","v":9213.5999999999985}]
[null,"Special Price",{"$f":"C5-I6","v":9213.5999999999985}]
["Winch","Quantity","Model","MSRP (each)","Extended Price (each)","Total MSRP","Total Discounted Price"]
["Primary",2,{"$f":"VLOOKUP(A8,'Select Winches'!$A$8:$B$10,2)","v":"52ST"},{"$f":"VLOOKUP(C8,AndersonSpecs,16)","v":3399},{"$f":"(1-$C$3)*D8","v":2039.3999999999999},{"$f":"$B8*D8","v":6798},4078.7999999999997]
["Secondary",4,{"$f":"VLOOKUP(A9,'Select Winches'!$A$8:$B$10,2)","v":"40ST"},{"$f":"VLOOKUP(C9,AndersonSpecs,16)","v":1394},{"$f":"(1-$C$3)*D9","v":836.4},5576,3345.6]
["Trim",3,{"$f":"VLOOKUP(A10,'Select Winches'!$A$8:$B$10,2)","v":"28ST"},{"$f":"VLOOKUP(C10,AndersonSpecs,16)","v":994},{"$f":"(1-$C$3)*D10","v":596.4},2982,1789.1999999999998]
[]
["Harken","Discount",0.4]
[null,"List Price",{"$f":"SUM(F17:F19)","v":16981}]
[null,"Disc. Price",{"$f":"SUM(G17:G19)","v":10188.6}]
[null,"Special Price",{"$f":"C14-I15","v":10188.6}]
["Winch","Quantity","Model","MSRP (each)","Extended Price (each)","Total MSRP","Total Discounted Price"]
["Primary",{"$f":"B8","v":2},{"$f":"VLOOKUP(A17,'Select Winches'!$A$14:$B$16,2)","v":"B56.3STC"},{"$f":"VLOOKUP(C17,HarkenSpecs,16)","v":4350},{"$f":"(1-$C$12)*D17","v":2610},{"$f":"$B17*D17","v":8700},5220]
["Secondary",{"$f":"B9","v":4},{"$f":"VLOOKUP(A18,'Select Winches'!$A$14:$B$16,2)","v":"B40.2STC"},{"$f":"VLOOKUP(C18,HarkenSpecs,16)","v":1249},{"$f":"(1-$C$12)*D18","v":749.4},4996,2997.6]
["Trim",{"$f":"B10","v":3},{"$f":"VLOOKUP(A19,'Select Winches'!$A$14:$B$16,2)","v":"B32.2STC"},{"$f":"VLOOKUP(C19,HarkenSpecs,16)","v":1095},{"$f":"(1-$C$12)*D19","v":657},3285,1971]
[null," "]
["Lewmar","Discount",0.4]
[null,"List Price",{"$f":"SUM(F26:F28)","v":13377}]
[null,"Disc. Price",{"$f":"SUM(G26:G28)","v":8026.2}]
[null,"Special Price",{"$f":"C23-I24","v":8026.2}]
["Winch","Quantity","Model","MSRP (each)","Extended Price (each)","Total MSRP","Total Discounted Price"]
["Primary",{"$f":"B8","v":2},{"$f":"VLOOKUP(A26,'Select Winches'!$A$20:$B$23,2)","v":"54CST"},{"$f":"VLOOKUP(C26,LewmarSpecs,16)","v":2930},{"$f":"(1-$C$21)*D26","v":1758},{"$f":"$B26*D26","v":5860},3516]
["Secondary",{"$f":"B9","v":4},{"$f":"VLOOKUP(A27,'Select Winches'!$A$20:$B$23,2)","v":"40CST"},{"$f":"VLOOKUP(C27,LewmarSpecs,16)","v":1130},{"$f":"(1-$C$21)*D27","v":678},4520,2712]
["Trim",{"$f":"B10","v":3},{"$f":"VLOOKUP(A28,'Select Winches'!$A$20:$B$23,2)","v":"30CST"},{"$f":"VLOOKUP(C28,LewmarSpecs,16)","v":999},{"$f":"(1-$C$21)*D28","v":599.4},2997,1798.1999999999998]

{"sheet":"Harken Winch Specs","index":4,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,3,2,5],[1,6,2,8],[1,0,3,0],[1,1,3,1],[1,2,3,2]]}
["Harken Winch Specs"]
["Part No.","SIZE","SPEEDS","Gear Ratio",null,null,"Mfg. Rated Power Ratio",null,null,"Drum","Base","Height","Line","Min.","Max","List"]
[null,null,null,null,null,null,null,null,null,"Dia.(ins)","Dia.(ins)","(ins)","Entry","Line","Line","Price"]
[null,null,null,"1st","2nd","3rd","1st","2nd","3rd",null,null,null,"Hght.(ins)","Dia.(ins)","Dia.(ins)"]
["B16STC",16,1,2.2999999999999998,{"$f":"-NA()","v":{"$error":"#N/A"}},{"$f":"-NA()","v":{"$error":"#N/A"}},16,{"$f":"-NA()","v":{"$error":"#N/A"}},{"$f":"-NA()","v":{"$error":"#N/A"}},2.75,4.75,5.5625,2,0.25,0.5,694]
["B32.2STC",32,2,2.4,4.7,{"$f":"-NA()","v":{"$error":"#N/A"}},16,32,{"$f":"-NA()","v":{"$error":"#N/A"}},2.9375,5.375,6.4375,2.75,0.3125,0.5,1095]
["B40.2STC",40,2,2.2000000000000002,6,{"$f":"-NA()","v":{"$error":"#N/A"}},13.5,40,{"$f":"-NA()","v":{"$error":"#N/A"}},3,5.875,6.9375,2.75,0.3125,0.5,1249]
["B42.2STC",42,2,2.5,7.3,{"$f":"-NA()","v":{"$error":"#N/A"}},14,42,{"$f":"-NA()","v":{"$error":"#N/A"}},3.5625,6.5,7.6875,3.375,0.3125,0.5625,1464.08]
["B44.2STC",44,2,2.5,8.1999999999999993,{"$f":"-NA()","v":{"$error":"#N/A"}},13.8,44,{"$f":"-NA()","v":{"$error":"#N/A"}},3.625,6.6875,8.125,3.375,0.3125,0.5625,1835]
["B46.2STC",46,2,2.5,9.1999999999999993,{"$f":"-NA()","v":{"$error":"#N/A"}},13,46,{"$f":"-NA()","v":{"$error":"#N/A"}},3.9375,6.875,8.5625,3.5625,0.3125,0.5625,2169]
["B48.2STC",48,2,2.5,10,{"$f":"-NA()","v":{"$error":"#N/A"}},12,48,{"$f":"-NA()","v":{"$error":"#N/A"}},4,7.5,9,3.9375,0.3125,0.5625,2729]
["B53.2STC",53,2,3,12,{"$f":"-NA()","v":{"$error":"#N/A"}},13.1,53,{"$f":"-NA()","v":{"$error":"#N/A"}},4.4375,8.6875,9.6875,4.1875,0.3125,0.5625,3150]
["B56.2STC",56,2,5,13,{"$f":"-NA()","v":{"$error":"#N/A"}},21,56,{"$f":"-NA()","v":{"$error":"#N/A"}},4.75,8.875,10.625,4.9375,0.3125,0.625,4100]
["B56.3STC",56,3,5,13,2.2000000000000002,21,56,9,4.75,8.875,10.625,4.9375,0.3125,0.625,4350]
["B64.2STC",64,2,5.7,16.5,{"$f":"-NA()","v":{"$error":"#N/A"}},22.5,64,{"$f":"-NA()","v":{"$error":"#N/A"}},5.125,9.625,12.125,5.875,0.3125,0.75,5660]
["B64.3STC",64,3,5.7,16.5,2.2999999999999998,22.5,64,9,5.125,9.625,11.8125,5.875,0.3125,0.75,6060]
["B66.2STC",66,2,7.3,20,{"$f":"-NA()","v":{"$error":"#N/A"}},25,66,{"$f":"-NA()","v":{"$error":"#N/A"}},5.875,10.4375,13,5.875,0.375,0.8125,6760]
["B66.3STC",66,3,7.3,20,2.8,25,66,9.3000000000000007,5.875,10.4375,13,5.875,0.375,0.8125,7160]
["B74.2STC",74,2,7.3,22,{"$f":"-NA()","v":{"$error":"#N/A"}},22,25,{"$f":"-NA()","v":{"$error":"#N/A"}},5.875,10.4375,13,5.875,0.375,0.8125,7888]
["B74.3STC",74,3,7.3,22,2.8,25,74,9.3000000000000007,5.875,10.4375,13,5.875,0.375,0.875,8288]

{"sheet":"Anderson Winch Specs","index":5,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[[11,3,11,4],[10,0,10,15],[0,0,0,14],[1,1,2,1],[11,1,12,1],[1,2,2,2],[11,2,12,2],[1,3,1,5],[11,6,11,8],[1,6,1,8],[1,0,2,0],[11,0,12,0]]}
["Anderson Self Tailing Winches (Metric)"]
["Part No.","SIZE","SPEEDS","Gear Ratio",null,null,"Mfg. Rated Power Ratio",null,null,"Drum","Base","Height","Line Entry","Line Size","Weight"]
[null,null,null,"1st","2nd","3rd","1st","2nd","3rd",null,null,null,null,null,"kg"]
["12ST",12,1,1.3,{"$f":"-NA()","v":{"$error":"#N/A"}},{"$f":"-NA()","v":{"$error":"#N/A"}},9.5,{"$f":"-NA()","v":{"$error":"#N/A"}},{"$f":"-NA()","v":{"$error":"#N/A"}},"70mm","114mm","130mm","40mm","10-12mm",2.8]
["28ST",28,2,1.3,3.7,{"$f":"-NA()","v":{"$error":"#N/A"}},9.5,26.5,{"$f":"-NA()","v":{"$error":"#N/A"}},"70mm","125mm","152mm","62mm","10-12mm",4.0999999999999996]
["40ST",40,2,1.3,6,{"$f":"-NA()","v":{"$error":"#N/A"}},8.5,39.5,{"$f":"-NA()","v":{"$error":"#N/A"}},"76mm","152mm","172mm","68mm","10-12mm",4.9000000000000004]
["46ST",46,2,2.8,8.4,{"$f":"-NA()","v":{"$error":"#N/A"}},15.5,46.6,{"$f":"-NA()","v":{"$error":"#N/A"}},"90mm","180mm","205mm","85mm","12-14mm",7.3]
["52ST",52,2,3.2,10.5,{"$f":"-NA()","v":{"$error":"#N/A"}},16.2,52,{"$f":"-NA()","v":{"$error":"#N/A"}},"100mm","200mm","225mm","98mm","12-16mm",9.9]
["58ST",58,2,3.7,13.1,{"$f":"-NA()","v":{"$error":"#N/A"}},16.100000000000001,57.7,{"$f":"-NA()","v":{"$error":"#N/A"}},"115mm","230mm","258mm","100mm","14-18mm",15]
[]
["Anderson Self Tailing Winches (English)"]
["Part No.","SIZE","SPEEDS","Gear Ratio",null,null,"Mfg. Rated Power Ratio",null,null,"Drum","Base","Height","Line Entry","Line Size","Weight","List"]
[null,null,null,"1st","2nd","3rd","1st","2nd","3rd",null,null,null,null,null,"lbs","Price"]
["12ST",12,1,1.3,{"$f":"-NA()","v":{"$error":"#N/A"}},{"$f":"-NA()","v":{"$error":"#N/A"}},9.5,{"$f":"-NA()","v":{"$error":"#N/A"}},{"$f":"-NA()","v":{"$error":"#N/A"}},{"$f":"SUBSTITUTE(J4,\"mm\",\"\")/25.4","v":2.7559055118110236},4.4881889763779528,5.1181102362204731,1.5748031496062993,"3/8 - 1/2",{"$f":"O4*2.2","v":6.16},524]
["28ST",28,2,1.3,3.7,{"$f":"-NA()","v":{"$error":"#N/A"}},9.5,26.5,{"$f":"-NA()","v":{"$error":"#N/A"}},2.7559055118110236,4.9212598425196852,5.984251968503937,2.4409448818897639,"3/8 - 1/2",9.02,994]
["40ST",40,2,1.3,6,{"$f":"-NA()","v":{"$error":"#N/A"}},8.5,39.5,{"$f":"-NA()","v":{"$error":"#N/A"}},2.9921259842519685,5.984251968503937,6.771653543307087,2.6771653543307088,"3/8 - 1/2",10.780000000000001,1394]
["46ST",46,2,2.8,8.4,{"$f":"-NA()","v":{"$error":"#N/A"}},15.5,46.6,{"$f":"-NA()","v":{"$error":"#N/A"}},3.5433070866141736,7.0866141732283472,8.0708661417322833,3.3464566929133861,"1/2 - 9/16",16.060000000000002,{"$f":"1075/0.75","v":1433.3333333333333}]
["52ST",52,2,3.2,10.5,{"$f":"-NA()","v":{"$error":"#N/A"}},16.2,52,{"$f":"-NA()","v":{"$error":"#N/A"}},3.9370078740157481,7.8740157480314963,8.8582677165354333,3.8582677165354333,"1/2 - 9/16",21.78,3399]
["58ST",58,2,3.7,13.1,{"$f":"-NA()","v":{"$error":"#N/A"}},16.100000000000001,57.7,{"$f":"-NA()","v":{"$error":"#N/A"}},4.5275590551181102,9.0551181102362204,10.15748031496063,3.9370078740157481,"9/16 - 11/16",33,{"$f":"2228/0.75","v":2970.6666666666665}]

{"sheet":"Lewmar Winch Specs","index":6,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,13,2,13],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,1,3,1],[0,0,0,15],[1,0,3,0],[1,3,2,5],[1,6,2,8],[1,2,3,2],[1,14,2,14],[1,12,2,12]]}
["Lewmar Self Tailing Winches"]
["Part No.","SIZE","SPEEDS","Gear Ratio",null,null,"Mfg. Rated Power Ratio",null,null,"Drum","Base","Height","Line Entry","Line Size","Weight","List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price"]
[null,null,null,"1st","2nd","3rd","1st","2nd","3rd","in.","in.","in.",null,"in.","lbs"]
["16CST",16,2,2,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},15.8,{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"NA()","v":{"$error":"#N/A"}},2.5625,4.75,5.75,2.3125,"5/16-1/2",1.9,620]
["30CST",30,2,2,4.2,{"$f":"NA()","v":{"$error":"#N/A"}},13.8,29.2,{"$f":"NA()","v":{"$error":"#N/A"}},2.9375,5.4375,6.3125,2.6875,"5/16-1/2",12.8,999]
["40CST",40,2,1.9,5.8,{"$f":"NA()","v":{"$error":"#N/A"}},13.2,40.200000000000003,{"$f":"NA()","v":{"$error":"#N/A"}},2.9,5.8125,6.8125,3.125,"5/16-1/2",14.7,1130]
["44CST",44,2,2.4,7.6,{"$f":"NA()","v":{"$error":"#N/A"}},13.9,44.8,{"$f":"NA()","v":{"$error":"#N/A"}},3.4375,6.625,7.5625,3.3125,"5/16-9/16",22,1630]
["48CST",48,2,2.6,9,{"$f":"NA()","v":{"$error":"#N/A"}},13.9,48.6,{"$f":"NA()","v":{"$error":"#N/A"}},3.625,7.125,8.1875,3.375,"5/16-9/16",27.7,1744]
["50CST",50,2,2.8,10.5,{"$f":"NA()","v":{"$error":"#N/A"}},13.8,50.6,{"$f":"NA()","v":{"$error":"#N/A"}},4.125,7.875,9.375,4.1875,"5/16-5/8",37.200000000000003,2048]
["54CST",54,2,2.8,11.2,{"$f":"NA()","v":{"$error":"#N/A"}},13.8,54,{"$f":"NA()","v":{"$error":"#N/A"}},4.125,8.0625,9.875,4.5,"5/16-5/8",38.700000000000003,2930]
["58CST",58,2,3.1,13.5,{"$f":"NA()","v":{"$error":"#N/A"}},13.5,58.1,{"$f":"NA()","v":{"$error":"#N/A"}},4.625,9,10.5,4.6875,"5/16-11/16",47.5]
["64CST",64,2,3.1,14.8,{"$f":"NA()","v":{"$error":"#N/A"}},13.4,64,{"$f":"NA()","v":{"$error":"#N/A"}},4.625,9.125,10.6875,4.8125,"5/16-11/16",54.1]