{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","BC-Pref"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":3,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":38,"n_cols":53,"rows_kept":38,"merged":[[0,1,0,5],[1,14,1,17],[3,15,3,17],[4,14,4,15],[4,17,4,19],[5,17,5,18],[6,17,6,18],[11,16,11,17],[12,4,13,7],[13,16,13,19],[15,2,15,3],[15,8,15,9],[25,15,25,19],[27,8,32,10],[28,15,28,16],[28,18,28,19]]}
[null,"Bridle Calculator Pro",{"$nulls":4},"Version 1.0"]
[null,"by Delbert Hall",{"$nulls":12}," Go to Bridle Calculator Preference Page"]
[{"$nulls":44},"Basket 1"]
[null,"Beam Info",{"$nulls":3},"Beam 1",null,"Beam 2 ",{"$nulls":7},"Baskets",{"$nulls":26},"Basket 1",null,"Basket Length","A","B",null,"Total Leg (1) Length",null,"BP below B1","BP above deck","BP below B2"]
[null,"Height of Beam (in)",{"$nulls":3},"9\"",null,"9\"",{"$nulls":6},"Leg 1",null,null,"Leg 2",{"$nulls":13},"Beam 1 Height ",null,{"$f":"F8","v":"106'- 0\""},{"$nulls":8},"Base length","ELOH 1",{"$f":"IF(P7 =\"Yes\",AQ6+AS10 +AS10, AQ6+AS10)","v":184.75},{"$f":"SQRT(((AR10/2)*(AR10/2))+((AR13/2)*(AR13/2)))","v":14.941814230541082},{"$f":"(AS5-AR16)/2","v":73.5},null,{"$f":"AR6+[3]!s2i(P14)+(D26*AS10)","v":196.71521512161274},null,{"$f":"SQRT((AW5*AW5)-[3]!s2i(F9)*[3]!s2i(F9))","v":196.0634485577115},{"$f":"[3]!s2i(F8)-AY5","v":1075.9365514422884},{"$f":"AY5-AL11","v":196.0634485577115}]
[null,"Width of Beam (in)",{"$nulls":3},"28\"",null,"28\"",{"$nulls":6},"Sling Length","Split Y/N",null,"Sling Length",null,"Split Y/N",{"$nulls":11},"Beam 2 Height ",null,{"$f":"H8","v":"106'- 0\""},null,null,0,{"$f":"[3]!s2i(AH5)","v":1272},0,{"$f":"AL6/12","v":106},null,null,{"$f":"[3]!s2i(O7)","v":180},{"$f":"SQRT((AU5*AU5)-(AT5*AT5))+AW12","v":74.34021512161274}]
[null,"Circumference of Beam (in)",{"$nulls":3},{"$f":"[3]!i2s((([3]!s2i(F5)+[3]!s2i(F6))*2),5,1)","v":"74\""},null,{"$f":"[3]!i2s((([3]!s2i(H5)+[3]!s2i(H6))*2),5,1)","v":"74\""},{"$nulls":6},"15'-0\"","Yes",null,"15'-0\"",null,"Yes",{"$nulls":11},"BP Height",null,{"$f":"(Q21)","v":"89' - 8\""},null,null,{"$f":"[3]!s2i(AH8)","v":16},{"$f":"[3]!s2i(AH7)","v":1076},{"$f":"AK7/12","v":1.3333333333333333},{"$f":"AL7/12","v":89.66666666666667},{"$nulls":8},"Total Leg (2) Length"]
[null,"Height above Deck (ft - in)",{"$nulls":3},"106'- 0\"",null,"106'- 0\"",{"$nulls":23},"BP from Beam 1 ",null,{"$f":"F9","v":"1'-4\""},null,null,{"$f":"[3]!s2i(AH9)","v":162},{"$f":"[3]!s2i(AH6)","v":1272},{"$f":"AK8/12","v":13.5},{"$f":"AL8/12","v":106},{"$nulls":3},"Beam 1",{"$nulls":4},{"$f":"SQRT(([3]!s2i(H9))*([3]!s2i(H9))+(BA5*BA5))","v":244.45219545003556}]
[null,"Distance from Apex to Beam (ft - in)",{"$nulls":3},"1'-4\"",null,{"$f":"[3]!i2s(AK8-AK7)","v":"12' - 2\""},null,null," ",{"$nulls":4},"Diameter of wire rope sling:","3/8\"",null,"Shackle Size:",{"$f":"IF(AI15=0.375,\"5/8\"&CHAR(34), \"3/4\"&CHAR(34))","v":"5/8\""},{"$nulls":3}," ",{"$nulls":7},"Span ",null,{"$f":"G10","v":"13'-6\""},{"$nulls":9},"Adjusted Beam Height","Shackle"]
[null,"Span (ft - in)",{"$nulls":4},"13'-6\"",{"$nulls":36},{"$f":"[3]!s2i(F5)+ AI15","v":9.375},{"$f":"IF(AI15=0.375, 2.375, 3)","v":2.375},{"$nulls":3},"Basket 1","Basket 2"]
[null,"Note: Typically, Leg 1 (Beam 1 to Apex) will be the short leg.",{"$nulls":35},{"$f":"AL6-[3]!s2i(AH6)","v":0},{"$nulls":8},"H2",null,"Shackle/Spit","Shackle/split"]
[{"$nulls":16},"Bridle Info",{"$nulls":14},"Y/N",null,null,"Wire Rope Dia.",{"$nulls":8},"Adjusted Beam Width",null,null,{"$f":"[3]!s2i(AH9)-[3]!s2i(AH8)","v":146},null,{"$f":"IF(P7=\"Yes\",AS10,0)","v":2.375},{"$f":"IF(T7=\"Yes\",AS10,0)","v":2.375}]
[{"$nulls":4},"Materials",{"$nulls":3}," ",{"$nulls":22},"Yes",null,null,"3/8\"",{"$nulls":8},{"$f":"[3]!s2i(F6)+ AI15","v":28.375}]
[{"$nulls":14},"Leg 1 Base Length","10'-0\"",{"$f":"IF(AG19<>0,\"  Warning: Base length cannot be made!\",\"\")","v":""},{"$nulls":14},"No",null,null,"1/2\"",{"$nulls":9},"Basket 2"]
[{"$nulls":14},"Leg 1 Total Length",{"$f":"([3]!i2s(MROUND(AW5,1)))","v":"16' - 5\""},null,null,"Leg 2 Total Length",{"$f":"([3]!i2s(MROUND(AW16,1)))","v":"20' - 4\""},{"$nulls":14},{"$f":"[3]!s2i(Q9)","v":0.375},{"$nulls":3},"Chain Needed",{"$nulls":4},"Total","Basket Length","A","B",null,"Total Leg (2) Length",null," "]
[null,null,"Leg 1",{"$nulls":5},"Leg 2",{"$nulls":29},{"$f":"AI19*12","v":21.361980328422824},null,{"$f":"IF(AM16<=(AS10/2),0)","v":false},null,null,{"$f":"AR10+AR13","v":37.75},{"$f":"IF(T7 =\"Yes\",AQ20+AS10 +AS10, AQ20+AS10)","v":184.75},{"$f":"SQRT(((AR20/2)*(AR20/2))+((AR23/2)*(AR23/2)))","v":14.941814230541082},{"$f":"(AS16-AR26)/2","v":73.5},null,{"$f":"SQRT(([3]!s2i(H9))*([3]!s2i(H9))+(BA5*BA5))","v":244.45219545003556},{"$f":"AW16-AR29","v":170.11198032842282}]
[null,null,"Basket","Leg ",{"$nulls":4},"Leg","Basket",{"$nulls":5},"Bridle Angle",{"$f":"DEGREES(ATAN(AK7/AY5))+DEGREES(ATAN(AU12/BA5))","v":{"v":41.33882172144917,"d":"41"}},"degrees",{"$f":"IF(Q17>120,\"Warning: Angle too great!\",\"\")","v":""},{"$nulls":21},{"$f":"IF(AND(AM16>=(AS10/2),AM16<(AS10 + AS10/2)), \"S\")","v":false}]
[{"$nulls":8},{"$f":"AP26","v":{"v":6.328993442807608,"d":"6"}},null,"Links of STAC  chain",{"$nulls":20},"Basket","Leg 1",null,"Leg 2","Basket",null,null,"Chain Link Length",null,{"$f":"IF(AM16>=(AS10 + AS10/2), (AM16-AS10)/AM19)","v":6.328993442807608},null,"Basket 2","Beam 2"]
[null,{"$f":"IF('BC-Pref'!D11=\"Yes\",\"2' Slings  \",\"\")","v":"2' Slings  "},{"$f":"IF('BC-Pref'!D11=\"Yes\",TRUNC(AF20/2),0)","v":0},{"$f":"IF('BC-Pref'!D11=\"Yes\",TRUNC(AG20/2),0)","v":0},{"$nulls":4},{"$f":"IF('BC-Pref'!D11=\"Yes\",TRUNC(AI20/2),0)","v":1},{"$f":"IF('BC-Pref'!D11=\"Yes\",TRUNC(AJ20/2),0)","v":0},{"$f":"IF('BC-Pref'!D11=\"Yes\",\"  2' Slings  \",\"\")","v":"  2' Slings  "},{"$nulls":4},"Bridle Point",{"$f":"([3]!i2s(MROUND(AY5,1)))","v":"16' - 4\""},"below Beam 1",{"$nulls":12},2,{"$f":"AF20-(C19*2)","v":{"v":0,"d":"0.00"}},{"$f":"AG20-(D19*2)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(I19<>0,AI20-(I19*2)-(I19 *(AS10/12)), AI20-(I19*2))","v":{"v":1.7801650273685687,"d":"1.78"}},{"$f":"AJ20-(J19*2)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"('BC-Pref'!U5)","v":3},{"$nulls":3},"Base Length","Adjusted Beam Height"]
[null,{"$f":"IF('BC-Pref'!D12=\"Yes\",\"2.5' Slings  \",\"\")","v":""},{"$f":"IF('BC-Pref'!D12=\"Yes\",TRUNC(AF21/2.5),0)","v":0},{"$f":"IF('BC-Pref'!D12=\"Yes\",TRUNC(AG21/2.5),0)","v":0},{"$nulls":4},{"$f":"IF('BC-Pref'!D12=\"Yes\",TRUNC(AI21/2.5),0)","v":0},{"$f":"IF('BC-Pref'!D12=\"Yes\",TRUNC(AJ21/2.5),0)","v":0},{"$f":"IF('BC-Pref'!D12=\"Yes\",\"  2.5' Slings  \",\"\")","v":""},{"$nulls":19},2.5,{"$f":"AF21-(P20*2.5)","v":{"v":0,"d":"0.00"}},{"$f":"AG21-(Q20*2.5)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(I20<>0,AI21-(I20*2.5)-(I20 *(AS10/12)), AI21-(I20*2.5))","v":{"v":3.9780816940352355,"d":"3.98"}},{"$f":"AJ21-(J20*2.5)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"AM16<=(AS10/2)","v":false},0,{"$f":"[3]!s2i(R7)","v":180},{"$f":"[3]!s2i(H5)+ AI15","v":9.375}]
[null,"5' Slings  ",{"$f":"IF('BC-Pref'!D13=\"Yes\",TRUNC(AF22/5),0)","v":1},{"$f":"IF('BC-Pref'!D13=\"Yes\",TRUNC(AG22/5),0)","v":0},{"$nulls":4},{"$f":"IF('BC-Pref'!D13=\"Yes\",TRUNC(AI22/5),0)","v":0},{"$f":"IF('BC-Pref'!D13=\"Yes\",TRUNC(AJ22/5),0)","v":1},{"$f":"IF('BC-Pref'!D13=\"Yes\",\"  5' Slings  \",\"\")","v":"  5' Slings  "},{"$nulls":4},"Bridle Point",{"$f":"([3]!i2s(MROUND(AZ5,1)))","v":"89' - 8\""},"above deck",{"$nulls":12},5,{"$f":"AF22-(C21*5)","v":{"v":0,"d":"0.00"}},{"$f":"AG22-(D21*5)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(I21<>0,AI22-(I21*5)-(I21 *(AS10/12)), AI22-(I21*5))","v":{"v":3.9780816940352355,"d":"3.98"}},{"$f":"AJ22-(J21*5)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"IF(AND(AM16>=(AS10/2)),AM16<(AS10 + AS10/2))","v":false},"S"]
[null,{"$f":"IF('BC-Pref'!D14=\"Yes\",\"10' Slings  \",\"\")","v":"10' Slings  "},{"$f":"IF('BC-Pref'!D14=\"Yes\",TRUNC(AF23/10),0)","v":1},{"$f":"IF('BC-Pref'!D14=\"Yes\",TRUNC(AG23/10),0)","v":1},{"$nulls":4},{"$f":"IF('BC-Pref'!D14=\"Yes\",TRUNC(AI23/10),0)","v":1},{"$f":"IF('BC-Pref'!D14=\"Yes\",TRUNC(AJ23/10),0)","v":1},{"$f":"IF('BC-Pref'!D14=\"Yes\",\"  10' Slings  \",\"\")","v":"  10' Slings  "},{"$nulls":19},10,{"$f":"AF23-(C22*10)","v":{"v":5,"d":"5.00"}},{"$f":"AG23-(D22*10)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(I22<>0,AI23-(I22*10)-(I22 *(AS10/12)), AI23-(I22*10))","v":{"v":3.9780816940352355,"d":"3.98"}},{"$f":"AJ23-(J22*10)","v":{"v":5,"d":"5.00"}},{"$nulls":4},{"$f":"(AM16>=(AS10 + AS10/2))","v":true},{"$f":"(AM16-AS10)/AM19","v":6.328993442807608},null,"Adjusted Beam Width"]
[null,{"$f":"IF('BC-Pref'!D15=\"Yes\",\"20' Slings  \",\"\")","v":"20' Slings  "},{"$f":"IF('BC-Pref'!D15=\"Yes\",TRUNC(AF24/20),0)","v":0},{"$f":"IF('BC-Pref'!D15=\"Yes\",TRUNC(AG24/20),0)","v":0},{"$nulls":4},{"$f":"IF('BC-Pref'!D15=\"Yes\",TRUNC(AI24/20),0)","v":0},{"$f":"IF('BC-Pref'!D15=\"Yes\",TRUNC(AJ24/20),0)","v":0},{"$f":"IF('BC-Pref'!D15=\"Yes\",\"  20' Slings  \",\"\")","v":"  20' Slings  "},{"$nulls":19},20,{"$f":"AF24-(C23*20)","v":{"v":15,"d":"15.00"}},{"$f":"AG24-(D23*20)","v":{"v":10,"d":"10.00"}},null,{"$f":"IF(I23<>0,AI24-(I23*20)-(I23 *(AS10/12)), AI24-(I23*20))","v":{"v":14.175998360701902,"d":"14.18"}},{"$f":"AJ24-(J23*20)","v":{"v":15,"d":"15.00"}},{"$nulls":7},{"$f":"[3]!s2i(H6)+ AI15","v":28.375}]
[null,{"$f":"IF('BC-Pref'!D16=\"Yes\",\"30' Slings  \",\"\")","v":"30' Slings  "},{"$f":"IF('BC-Pref'!D16=\"Yes\",TRUNC(AF25/30),0)","v":0},{"$f":"IF('BC-Pref'!D16=\"Yes\",TRUNC(AG25/30),0)","v":0},{"$nulls":4},{"$f":"IF('BC-Pref'!D16=\"Yes\",TRUNC(AI25/30),0)","v":0},{"$f":"IF('BC-Pref'!D16=\"Yes\",TRUNC(AJ25/30),0)","v":0},{"$f":"IF('BC-Pref'!D16=\"Yes\",\"  30' Slings  \",\"\")","v":"  30' Slings  "},{"$nulls":19},30,{"$f":"AF25-(C24*30)","v":{"v":15,"d":"15.00"}},{"$f":"AG25-(D24*30)","v":{"v":10,"d":"10.00"}},null,{"$f":"IF(I24<>0,AI25-(I24*30)-(I24 *(AS10/12)), AI25-(I24*30))","v":{"v":14.175998360701902,"d":"14.18"}},{"$f":"AJ25-(J24*30)","v":{"v":15,"d":"15.00"}}]
[null,{"$f":"IF('BC-Pref'!D17=\"Yes\",\"50' Slings  \",\"\")","v":"50' Slings  "},{"$f":"IF('BC-Pref'!D17=\"Yes\",TRUNC(AF29/50),0)","v":0},{"$f":"IF('BC-Pref'!D17=\"Yes\",TRUNC(AF28/50),0)","v":0},{"$nulls":4},{"$f":"IF('BC-Pref'!D17=\"Yes\",TRUNC(AF28/50),0)","v":0},{"$f":"IF('BC-Pref'!D17=\"Yes\",TRUNC(AG29/50),0)","v":0},{"$f":"IF('BC-Pref'!D17=\"Yes\",\"  50' Slings  \",\"\")","v":"  50' Slings  "},{"$nulls":19},50,{"$f":"AF29-(C25*50)","v":{"v":15,"d":"15.00"}},{"$f":"AF28-(D25*50)","v":{"v":10,"d":"10.00"}},null,{"$f":"IF(I25<>0,AG28-(I25*50)-(I25*(AS10/12)), AG28-(I25*50))","v":{"v":14.175998360701902,"d":"14.18"}},{"$f":"AG29-(J25*50)","v":{"v":15,"d":"15.00"}},{"$nulls":7},"Total"]
[null,"Total Slings  ",{"$f":"SUM(C19:C25)","v":2},{"$f":"SUM(D19:D25)","v":1},{"$nulls":4},{"$f":"SUM(I19:I25)","v":2},{"$f":"SUM(J19:J25)","v":2},"  Total Slings",{"$nulls":4},"Forces",{"$nulls":4}," ",{"$nulls":20},{"$f":"VLOOKUP(TRUE,AO20:AP22,2,)","v":6.328993442807608},null,{"$f":"AR20+AR23","v":37.75}]
[{"$nulls":31},"Leg1","Leg 2"]
[{"$nulls":8},"Note: \"S\" indicates to add an additional shackle, but do not add any STAC chain. ",{"$nulls":7},"Load",500,"lb",{"$nulls":12},{"$f":"[3]!s2i(P14)/12","v":10},{"$f":"(AX16)/12","v":14.175998360701902},{"$nulls":10},"ELOH 2"]
[{"$nulls":15},"Leg 1/Beam 1",null,null,"Leg 2/Beam2",{"$nulls":12},{"$f":"[3]!s2i(O7)/12","v":15},{"$f":"[3]!s2i(R7)/12","v":15},{"$nulls":10},{"$f":"SQRT((AU16*AU16)-(AT16*AT16))+AX12","v":74.34021512161274}]
[{"$nulls":15},"Tension on Leg",{"$f":"R28*((AW5*AU12)/(AK7*BA5+AY5*AU12))","v":{"v":452.115254535933,"d":"452"}},null,{"$f":"R28*((AW8*AK7)/(AK7*BA5+AY5*AU12))","v":{"v":61.57044285592064,"d":"62"}},"Tension on leg"]
[{"$nulls":15},"Vertical (Downward) Force on Beam",{"$f":"(R28*AY5*AU12)/((AY5*AU12)+(BA5*AK7))","v":{"v":450.61728395061726,"d":"451"}},null,{"$f":"R28-Q31","v":{"v":49.382716049382736,"d":"49"}},"Vertical (Downward) Force on Beam"]
[{"$nulls":15}," Horizontal Force on Beam -->",{"$f":"Q31*(AK7/AY5)","v":{"v":36.77318029570229,"d":"37"}},null,{"$f":"S31*(AU12/BA5)","v":{"v":36.77318029570231,"d":"37"}},"<-- Horizontal Force on Beam "]
[{"$nulls":17},"Horizonal forces on both beams must be equal."]
[]
[]
[]
[]
[{"$nulls":10},"  "]

{"sheet":"BC-Pref","index":1,"n_rows":17,"n_cols":21,"rows_kept":17,"merged":[[1,6,1,9]]}
[null,"Bridle Calculator - Preferences"]
[{"$nulls":6},"Go to Main Bridle Calculator Page"]
[]
[{"$nulls":6},"STAC/Deck Chain Length"]
[{"$nulls":7},"Inside Length of Chain Link","3\"",{"$nulls":11},{"$f":"[3]!s2i(I5)","v":3}]
[]
[]
[{"$nulls":7},"Note: Be sure to include the inch symbol in your measurement above."]
[null,"Available Steel Slings"]
[{"$nulls":3},"Y/N"]
[null,null,"2' Steel","Yes"]
[null,null,"2.5' Steel","No"]
[null,null,"5' Steel","Yes"]
[null,null,"10' Steel","Yes"]
[null,null,"20' Steel","Yes"]
[null,null,"30' Steel","Yes"]
[null,null,"50' Steel","Yes"]