{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["CABLE PULL TENSION ESTIMATOR","2-TENSION ESTIMATOR SAMPLE","3-600v COPPER CABLE WEIGHTS","License Agreement"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":1,"defined_names":1,"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":"CABLE PULL TENSION ESTIMATOR","index":0,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"GREENLEE CABLE PULL TENSION ESTIMATOR"]
[null,"",""]
[null,"Total Wt. per Ft. of Cables (lb) =",null,"Coefficient of Friction=",null,null,"Initial Cable Tension ="]
[null,null,"1st Leg","2nd Leg","3rd Leg","4th Leg","5th Leg","6th Leg","7th Leg","8th Leg","9th Leg","10th Leg"]
[null,"Length to Next Bend (ft)"]
[null,"Vertical Rise(+) or Drop (-)"]
[null,"Bend Angle at end of leg"]
[null,"Cable Weight",0,0,0,0,0,0,0,0,0,0]
[null,"Vertical Weight",0,0,0,0,0,0,0,0,0,0]
[null,"Frictional Drag","0","0","0","0","0","0","0","0","0","0"]
[null,"Force Before Bend ",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Bend Increase",0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,0,0]
[null,"Force","","","","","","","","","",""]
[null,"",{"$nulls":5},""]
[null,"See Sheet 2 for example"]
[null,"See Sheet 3 for 600v copper cable weights per ft."]
{"$rows_empty":11}
[{"$nulls":9},"Weight Correction Factor is",1]

{"sheet":"2-TENSION ESTIMATOR SAMPLE","index":1,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Total Wt. per ft. of Cable (lb) =",2.592,"Coefficient of Friction=",null,0.3,"Initial Cable Tension =",null,0]
[null,null,"1st Leg","2nd Leg","3rd Leg","4th Leg","5th Leg","6th Leg","7th Leg","8th Leg","9th Leg","10th Leg"]
[null,"Length to Next Bend (ft)",3,12,3,5,6]
[null,"Vertical Rise(+) or Drop (-)",-3,null,null,4]
[null,"Bend Angle at End of Leg",90,90,45,45]
[null,"Cable Weight",7.776,31.104,7.776,12.96,15.552,0,0,0,0,0]
[null,"Vertical Weight",-7.776,0,0,10.368,0,0,0,0,0,0]
[null,"Frictional Drag",2.8580263156108286e-16,9.331199999999999,2.3327999999999998,2.3327999999999998,4.6655999999999995,"0","0","0","0","0"]
[null,"Force Before Bend ",-7.776,4.477199699948721,9.505173859645922,24.731427816296165,35.96798413487966,35.96798413487966,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Increase",-4.854000300051278,7.172373859645923,12.030627816296164,31.302384134879656,35.96798413487966,35.96798413487966,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Force",-4.854000300051278,7.172373859645923,12.030627816296164,31.302384134879656,35.96798413487966,"","","","",""]

{"sheet":"3-600v COPPER CABLE WEIGHTS","index":2,"n_rows":31,"n_cols":22,"rows_kept":31,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"Typical THHN and THWN 600 volt copper cable weight per foot",{"$nulls":6},"Jamming",null,null,null,"Wedging Factor",{"$nulls":4},"Moron"]
[{"$nulls":11}," d ","D/d<3","D/d<3","D/d>3","D/d>3","All",1,2,3,4]
[null,"Wire Size","Wt/Ft.","Number Used","Quantity wt.",null,null,"Cable Dia.","Dia.","D/d","JAM?","D-d","4+",3,"4+",3,2,"Cable","Cable","Cable","Cable"]
[null,"14 Ga.",".017",null,0,null,null,0.12,0,"",false,8.333333333333334,"","","","","",0,0,0,0]
[null,"12 Ga.",".025",null,0,null,null,0.14,0,"",false,7.142857142857142,"","","","","",0,0,0,0]
[null,"10 Ga.",".040",null,0,null,null,0.17,0,"",false,5.88235294117647,"","","","","",0,0,0,0]
[null,"8 Ga.",".065",null,0,null,null,0.22,0,"",false,4.545454545454546,"","","","","",0,0,0,0]
[null,"6 ga.",".098",null,0,null,null,0.26,0,"",false,3.846153846153846,"","","","","",0,0,0,0]
[null,"4 Ga.",".157",null,0,null,null,0.33,0,"",false,3.0303030303030303,"","","","","",0,0,0,0,""]
[null,"3 Ga.",".195",null,0,null,null,0.36,0,"",false,2.7777777777777777,"","","","","",0,0,0,0,""]
[null,"2 Ga.",".240",null,0,null,null,0.39,0,"",false,2.564102564102564,"","","","","",0,0,0,0,""]
[null,"1 Ga.",".305",null,0,null,null,0.45,0,"",false,2.2222222222222223,"","","","","",0,0,0,0]
[null,"1/0",".378",null,0,null,null,0.49,0,"",false,2.0408163265306123,"","","","","",0,0,0,0]
[null,"2/0",".470",null,0,null,null,0.54,0,"",false,1.8518518518518519,"","","","","",0,0,0,0]
[null,"3/0",".585",null,0,null,null,0.59,0,"",false,1.6949152542372883,"","","","","",0,0,0,0]
[null,"4/0",".730",null,0,null,null,0.65,0,"",false,1.5384615384615383,"","","","","",0,0,0,0]
[null,"250 mcm",".864",null,0,null,null,0.72,0,"",false,1.3888888888888888,"","","","","",0,0,0,0]
[null,"300 mcm","1.028",null,0,null,null,0.77,0,"",false,1.2987012987012987,"","","","","",0,0,0,0]
[null,"350 mcm","1.192",null,0,null,null,0.82,0,"",false,1.2195121951219514,"","","","","",0,0,0,0]
[null,"400 mcm","1.365",null,0,null,null,0.87,0,"",false,1.1494252873563218,"","","","","",0,0,0,0]
[null,"500 mcm","1.678",null,0,null,null,0.96,0,"",false,1.0416666666666667,"","","","","",0,0,0,0]
[null,"600mcm","2.023",null,0,null,null,1.06,0,"",false,0.9433962264150942,"","","","","",0,0,0,0]
[null,"750 mcm","2.508",null,0,null,null,1.16,0,"",false,0.8620689655172413,"","","","","",0,0,0,0]
[null,"1000mcm","3.230",null,0,null,null,1.32,0,"",false,0.7575757575757576,"","","","","",0,0,0,0]
[null,"Total Weight per Foot =",null,null,0,"◄ If a weight value is displayed here, it",{"$nulls":4},false,{"$nulls":5},1,null,null,null,0]
[null,null,"Conduit I.D. =",null,null,"does not need to be entered on sheet 1."]
[null,"JAMMING  IS","NOT PROBABLE"]
[null,null,"","",""]
[]
[null,"Enter the number of each cable size to be used. (i.e. 3x350mcm and 1x4/0)."]
[null,"Enter the inside diameter of the conduit being used."]

{"sheet":"License Agreement","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}