{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Sheet1","pole study"],"not_rendered":{"charts":4,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[{"$nulls":4},"no taper- pole stays on centre line",null,null,null,"no taper some play"]
[{"$nulls":5},"ok",null,null,"ok"]
["Pole Dimensions",null,null,null,"Pole Dimensions",null,null,null,"Pole Dimensions"]
["Measurement ","Units",null,null,"Measurement ","Units",null,null,"Measurement ","Units"]
["Length","m",1.8000000000000003,null,"Length","m",1.8,null,"Length","m",1.8]
["Inboard End OD.","m",0.053,null,"Inboard End OD.","m",0.057,null,"Inboard End OD.","m",0.047]
["Outboard End OD.","m",0.04,null,"Outboard End OD.","m",0.057,null,"Outboard End OD.","m",0.047]
["Taper ","m/m",0.00722222222222222,null,"Taper ","m/m",0,null,"Taper ","m/m",0]
["Snout Dimensions",null,null,null,"Snout Dimensions",null,null,null,"Snout Dimensions"]
["Length","m",0.5,null,"Length","m",0.5,null,"Length","m",0.5]
["Inboard End ID.","m",0.057,null,"Inboard End ID.","m",0.057,null,"Inboard End ID.","m",0.057]
["Outboard End ID.","m",0.057,null,"Outboard End ID.","m",0.057,null,"Outboard End ID.","m",0.057]
["Boat Dimensions",null,null,null,"Boat Dimensions",null,null,null,"Boat Dimensions"]
["Mast Aft of Snout","m",1.63,null,"Mast Aft of Snout","m",1.63,null,"Mast Aft of Snout","m",1.5]
["Radius of Mast","m",0.03,null,"Radius of Mast","m",0.03,null,"Radius of Mast","m",0.03]
["Spin.tack in front of mast","m",2.93,null,"Spin.tack in front of mast","m",null,null,"Spin.tack in front of mast","m"]
["Pole Retracted to Mast",null,null,null,"Pole Retracted to Mast",null,null,null,"Pole Retracted to Mast"]
["OD at inboard end of snout","m",0.048161111111111106,null,"OD at inboard end of snout","m",0.057,null,"OD at inboard end of snout","m",0.047]
["Transverse Pole/Mast Clearance","m",-0.0296852222222222,null,"Transverse Pole/Mast Clearance","m",-0.058499999999999996,null,"Transverse Pole/Mast Clearance","m",-0.028499999999999994]
[]
[]
["Pole Dimensions"]
["Measurement ","Units"]
["Length","m",2.77]
["Inboard End OD.","m",0.055]
["Outboard End OD.","m",0.022]
["Taper ","m/m",0.011913357400722023]
["Snout Dimensions"]
["Length","m",0.4]
["Inboard End ID.","m",0.057]
["Outboard End ID.","m",0.057]
["Boat Dimensions"]
["Mast Aft of Snout","m",1.63]
["Radius of Mast","m",0.03]
["Spin.tack in front of mast","m",4]
["Pole Retracted to Mast"]
["OD at inboard end of snout","m",0.04034657039711191]
["Transverse Pole/Mast Clearance","m",0.009362725631768959]

{"sheet":"pole study","index":1,"n_rows":99,"n_cols":13,"rows_kept":99,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Assumptions"]
["Assume that outboard end of pole needs to be 4m in front of the mast"]
["Inboard end of pole OD is 2mm les than inboard end of snout ID."]
["Snout is not tapered"]
[]
["Given the assumptions above the variable dimensions are:"]
["Diameter of Snout"]
["Length of Snout"]
["Diameter of outboard end of pole"]
["Position of mast aft of the Snout"]
[]
["Base figures for each variable are:"]
["Diameter of Snout",0.07]
["Length of Snout",0.4]
["Diameter of outboard end of pole",0.025]
["Position of mast aft of the Snout",1.85]
[]
[]
["Variable: outboard end of pole diameter",null,"0.04 to 0.022"]
["Pole Dimensions"]
["Measurement ","Units"]
["Length","m",2.55,2.55,2.55,2.55,2.55,2.55,2.55,2.55,2.55,2.55]
["Inboard End OD.","m",0.068,0.068,0.068,0.068,0.068,0.068,0.068,0.068,0.068,0.068]
["Outboard End OD.","m",0.04,0.038,0.036,0.034,0.032,0.03,0.028,0.026,0.024,0.022]
["Taper ","m/m",0.010980392156862747,0.011764705882352944,0.012549019607843142,0.013333333333333336,0.014117647058823532,0.014901960784313729,0.015686274509803925,0.016470588235294122,0.017254901960784316,0.018039215686274514]
["Snout Dimensions"]
["Length","m",0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4]
["Inboard End ID.","m",0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07]
["Outboard End ID.","m",0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07]
["Boat Dimensions"]
["Mast Aft of Snout","m",1.85,1.85,1.85,1.85,1.85,1.85,1.85,1.85,1.85,1.85]
["Radius of Mast","m",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
["Spin.tack in front of mast","m",4,4,4,4,4,4,4,4,4,4]
["Pole Retracted to Mast"]
["OD at inboard end of snout","m",0.05207843137254902,0.05094117647058823,0.04980392156862745,0.048666666666666664,0.04752941176470588,0.046392156862745094,0.04525490196078431,0.044117647058823525,0.04298039215686274,0.041843137254901956]
["Transverse Pole/Mast Clearance","m",0.017887254901960803,0.02314705882352945,0.02840686274509807,0.033666666666666706,0.038926470588235326,0.04418627450980396,0.04944607843137258,0.05470588235294123,0.05996568627450986,0.06522549019607848]
[]
[]
["Variable: Diameter of snout ",null,"0.08 to 0.06"]
["Pole Dimensions"]
["Measurement ","Units"]
["Length","m",2.55,2.55,2.55,2.55,2.55,2.55,2.55,2.55,2.55,2.55,2.55]
["Inboard End OD.","m",0.078,0.076,0.074,0.072,0.06999999999999999,0.068,0.066,0.064,0.062,0.06,0.057999999999999996]
["Outboard End OD.","m",0.025,0.025,0.025,0.025,0.025,0.025,0.025,0.025,0.025,0.025,0.025]
["Taper ","m/m",0.020784313725490198,0.02,0.019215686274509803,0.018431372549019606,0.017647058823529408,0.016862745098039218,0.01607843137254902,0.015294117647058824,0.014509803921568627,0.013725490196078431,0.012941176470588234]
["Snout Dimensions"]
["Length","m",0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4]
["Inboard End ID.","m",0.08,0.078,0.076,0.074,0.072,0.07,0.068,0.066,0.064,0.062,0.06]
["Outboard End ID.","m",0.08,0.078,0.076,0.074,0.072,0.07,0.068,0.066,0.064,0.062,0.06]
["Boat Dimensions"]
["Mast Aft of Snout","m",1.85,1.85,1.85,1.85,1.85,1.85,1.85,1.85,1.85,1.85,1.85]
["Radius of Mast","m",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
["Spin.tack in front of mast","m",4,4,4,4,4,4,4,4,4,4,4]
["Pole Retracted to Mast"]
["OD at inboard end of snout","m",0.047862745098039214,0.04699999999999999,0.04613725490196078,0.04527450980392156,0.044411764705882345,0.04354901960784313,0.04268627450980392,0.041823529411764704,0.04096078431372549,0.04009803921568627,0.039235294117647056]
["Transverse Pole/Mast Clearance","m",0.07863480392156863,0.07437500000000002,0.07011519607843139,0.06585539215686276,0.061595588235294124,0.057335784313725546,0.0530759803921569,0.04881617647058825,0.04455637254901962,0.040296568627451,0.036036764705882365]
[]
[]
["Variable: length of Snout ",null,"0.5 to 0.3"]
["Pole Dimensions"]
["Measurement ","Units"]
["Length","m",2.65,2.63,2.61,2.59,2.57,2.55,2.53,2.51,2.4899999999999998,2.4699999999999998,2.4499999999999997]
["Inboard End OD.","m",0.068,0.068,0.068,0.068,0.068,0.068,0.068,0.068,0.068,0.068,0.068]
["Outboard End OD.","m",0.025,0.025,0.025,0.025,0.025,0.025,0.025,0.025,0.025,0.025,0.025]
["Taper ","m/m",0.016226415094339624,0.01634980988593156,0.016475095785440614,0.016602316602316605,0.01673151750972763,0.016862745098039218,0.016996047430830042,0.01713147410358566,0.017269076305220888,0.017408906882591096,0.017551020408163268]
["Snout Dimensions"]
["Length","m",0.5,0.48,0.46,0.44,0.42,0.4,0.38,0.36,0.34,0.32,0.3]
["Inboard End ID.","m",0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07]
["Outboard End ID.","m",0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07]
["Boat Dimensions"]
["Mast Aft of Snout","m",1.85,1.85,1.85,1.85,1.85,1.85,1.85,1.85,1.85,1.85,1.85]
["Radius of Mast","m",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
["Spin.tack in front of mast","m",4,4,4,4,4,4,4,4,4,4,4]
["Pole Retracted to Mast"]
["OD at inboard end of snout","m",0.046094339622641506,0.045600760456273766,0.045099616858237546,0.044590733590733594,0.0440739299610895,0.04354901960784313,0.04301581027667984,0.04247410358565737,0.04192369477911646,0.041364372469635625,0.04079591836734694]
["Transverse Pole/Mast Clearance","m",0.023450943396226456,0.029038735741444888,0.035142845244044665,0.04183441558441561,0.04919816564758202,0.057335784313725546,0.06637039733721659,0.07645252324037188,0.08776813134892517,0.10054972165991907,0.11509183673469392]
[]
[]
["Variable: position of mast aft of snout ",null,"2.0 -1.65"]
["Pole Dimensions"]
["Measurement ","Units"]
["Length","m",2.4,2.4499999999999997,2.5,2.55,2.6,2.65,2.6999999999999997,2.75]
["Inboard End OD.","m",0.068,0.068,0.068,0.068,0.068,0.068,0.068,0.068]
["Outboard End OD.","m",0.025,0.025,0.025,0.025,0.025,0.025,0.025,0.025]
["Taper ","m/m",0.017916666666666668,0.017551020408163268,0.0172,0.016862745098039218,0.01653846153846154,0.016226415094339624,0.01592592592592593,0.01563636363636364]
["Snout Dimensions"]
["Length","m",0.4,0.4,0.4,0.4,0.4,0.4,0.4,0.4]
["Inboard End ID.","m",0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07]
["Outboard End ID.","m",0.07,0.07,0.07,0.07,0.07,0.07,0.07,0.07]
["Boat Dimensions"]
["Mast Aft of Snout","m",2,1.95,1.9,1.85,1.8,1.75,1.7,1.65]
["Radius of Mast","m",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
["Spin.tack in front of mast","m",4,4,4,4,4,4,4,4]
["Pole Retracted to Mast"]
["OD at inboard end of snout","m",0.03933333333333333,0.04079591836734694,0.0422,0.04354901960784313,0.044846153846153855,0.046094339622641506,0.0472962962962963,0.04845454545454546]
["Transverse Pole/Mast Clearance","m",0.08833333333333337,0.0773698979591837,0.06705,0.057335784313725546,0.04819230769230767,0.039587264150943435,0.03149074074074075,0.023874999999999993]
[]
[]
[0.03933333333333333]