{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet2","CALC 2","Module1","Module2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":39,"n_cols":25,"rows_kept":39,"cut":false,"hidden":false,"merged":[[6,1,6,2],[6,3,6,4],[3,2,3,3],[4,2,4,3],[3,0,3,1],[4,0,4,1]]}
[]
[null,"    PULLING CALCULATIONS",null,null,null,null,null,"Note: After printing, calculate reverse direction "]
[null,"2022-11-09",null,null,null,null,null,"of pull by reversing order of T1 to T10."]
["From Structure ID:"]
["To Structure ID:"]
[null,null,null,null,null,null,null,1,null,{"$f":"VLOOKUP($H$6,$N$10:$T43,7)","v":"RJN1#2"},{"$f":"VLOOKUP($H$6,$N$10:$Q43,4)","v":197600}]
["Enter Pounds from T10 Sheet 1","ALWAYS CHOOSE ONLY ONE",null,"USE WITH LENGTH             (ONLY FOR HILLS)"]
[null,"ANGLE OF CURVE ","LENGTH    (IN FEET)"," DECLINE      (IN FEET)"," INCLINE      (IN FEET)"]
["T1 = 50#",null,null,null,null,null,"Cable Weight Per 1000 Ft =",null,null,{"$f":"VLOOKUP($H$6,$N$10:$Q$43,3)","v":440}," Lbs.",null,null,null,null,"Wt/LBS Per 1000 Ft","Stock","GRIP","EYE","AU","Initial Reel Tension/LBS",null,"SWBP"]
["T1 to T2",null,null,null,null,null,null,null,null,"Grip","Eye",null,null,1,"1/C # 2 SOL AL XLPECN-PEJ",440,197600,530,"N/A","RJN1#2",50,1,"CE/Jack",1250,2]
["T2 to T3",null,null,null,null,null,"Max Allowable Tension =",null,null,{"$f":"VLOOKUP($H$6,$N$10:$S43,5)","v":530},{"$f":"VLOOKUP($H$6,$N$10:$S43,6)","v":"N/A"}," Lbs.",null,2,"2-1/C # 2 SOL AL XLPECN-PEJ",880,197602,1000,"N/A","RJN2#2",50,2,"CE/Unjack",750,3]
["T3 to T4",null,null,null,null,null,null,null,null,null,null,null,null,3,"3-1/C # 2 SOL AL XLPECN-PEJ",1320,197622,1000,"N/A","RJN3/2",50,3,"DB",300,4]
["T4 to T5",null,null,null,null,null,"Pulling Tension  = ",null,null,{"$f":"'CALC 2'!C20","v":0}," Lbs.",null,null,4,"3-1/C # 2/0 AL XLPECN-PEJ",1670,197606,1000,"N/A","RJN2/0",50,4,null,null,25]
["T5 to T6",null,null,null,null,null,null,null,null,null,null,null,null,5,"3-1/C 350 KCMIL AL XLPECN-PEJ",3335,197608,1000,5600,"RJN350",50,null,"(UGS 4003.2)"]
["T6 to T7",null,null,null,null,null,null,null,null,null,null,null,null,6,"3-1/C 750 KCMIL AL COMP EPR-PEJ",4600,195010,1000,7000,"CPJ750",50]
["T7 to T8",null,null,null,null,null,null,null,null,null,null,null,null,7,"3-1/C 750 KCMIL CU COMP EPR-PEJ",9640,195028,1000,7000,"CPC750",50]
["T8 to T9",null,null,null,null,null,null,null,null,null,null,null,null,8,"3-1/C 1000 KCMIL AL XLPECN-PEJ",6420,197628,"N/A",7000,"R-1000",50,null,{"$f":"AND(B10<>0,C10<>0)","v":false},{"$f":"AND(D10<>0,E10<>0)","v":false}]
["T9 to T10",null,null,null,null,null,null,null,null,null,null,null,null,9,"3/C 1000 KCMIL AL XLPECN-PEJ",7320,197618,1000,7000,"RJ1000",50,null,false,{"$f":"AND(D11<>0,E11<>0)","v":false}]
[null,{"$f":"IF(W26=FALSE,\"You can't have a bend & a length in the same segment!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,10,"3-1/C 1000 KCMIL CU XLPECN-PEJ",13600,197610,1000,7000,"1000CU",50,null,false,false]
[null,{"$f":"IF(X26=FALSE,\"You can't have an up & down slope in the same segment!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,11,"2-#8 AL",69,196176,364,"N/A","U/2-#8",50,null,false,false]
["    Sidewall Bearing Pressure Calculation:",null,null,null,null,null,null,null,null,null,null,null,null,12,"2-# 2 & 1-#4 AL",256,197504,1000,"N/A","U1P-#2",50,null,false,false]
["      (Use if pull terminates in a 90 degree bend)",null,null,null,null,"Choose One:",null,null,null,null,null,null,null,13,"2- 1/0 & 1- #2 AL",395,197472,1000,"N/A","U1P1/0",50,null,false,false]
[null,null,null,null,null,3,null,null,null,null,null,null,null,14,"2- 3/0 & 1- 1/0 AL",588,197536,1000,"N/A","U1P3/0",50,null,false,false]
["Radius Bend  =",null,null,1,"Feet",null,null,null,null,null,null,null,null,15,"3- 3/0 & 1- 1/0 AL",810,197592,1000,"N/A","U3P3/0",50,null,false,false]
["Sidewall Bearing Pressure =",null,null,{"$f":"J13/F25","v":0},"Lbs./Ft.",{"$f":"VLOOKUP($D$24,$V$10:$Y$14,4)","v":2},null,null,null,999,null,null,null,16,"2- 350 & 1- 3/0 AL",1090,197568,1000,"N/A","U1P350",50,null,false,false]
["Allowable SWBP =",null,null,{"$f":"VLOOKUP($F$23,$V$10:$X$13,3)","v":300},"Lbs./Ft.",null,null,null,null,null,null,null,null,17,"3- 350 & 1- 3/0 AL",1520,197594,1000,"N/A","U3P350",50,null,{"$f":"AND(W17=FALSE,W18=FALSE,W19=FALSE,W20=FALSE,W21=FALSE,W22=FALSE,W23=FALSE,W24=FALSE,W25=FALSE)","v":true},{"$f":"AND(X17=FALSE,X18=FALSE,X19=FALSE,X20=FALSE,X21=FALSE,X22=FALSE,X23=FALSE,X24=FALSE,X25=FALSE)","v":true}]
[{"$f":"IF(D25>D26*(INDEX(Y10:Y14,D24,1)),\"Warning: Conduit Sidewall Pressure Exceeded\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,18,"2- 500 & 1- 350 AL ",1621,197450,1000,"N/A","U1P500",50]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($H$6,$N$10:$U65,8)","v":50},19,"3- 500 & 1-350 AL",2215,197596,1000,"N/A","U3P500",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,20,"3- 1000 & 1- 750 AL",4300,197598,1000,"N/A","3P1000",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21,"2- 1/0 & 1- #2 CU",870,197510,1000,"N/A","TCU1/0",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,22,"2- 250 & 1- 4/0 CU",2240,197512,1000,"N/A","TCU250",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30]

{"sheet":"Sheet2","index":1,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"CURVE CONSTANT TABLE",null,null,null,"ARCTANGENT for DOWNWARD SLOPES"]
[null,"ANGLE DEGREE","K VALUE",null,null,null,"Rise/Run","Archtan in Radieans","Degree of Slope"]
[null,"*","*",null,null,"T2",{"$f":"Sheet1!D10/Sheet1!C10","v":{"$error":"#DIV/0!"}},{"$f":"ATAN(G5)","v":{"$error":"#DIV/0!"}},{"$f":"H5*(180/PI())","v":{"$error":"#DIV/0!"}}]
[null,0,1,null,null,"T3",{"$f":"Sheet1!D11/Sheet1!C11","v":{"$error":"#DIV/0!"}},{"$f":"ATAN(G6)","v":{"$error":"#DIV/0!"}},{"$f":"H6*(180/PI())","v":{"$error":"#DIV/0!"}}]
[null,11.25,1.05,null,null,"T4",{"$f":"Sheet1!D12/Sheet1!C12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,22.5,1.1000000000000001,null,null,"T5",{"$f":"Sheet1!D13/Sheet1!C13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,33.75,1.1599999999999999,null,null,"T6",{"$f":"Sheet1!D14/Sheet1!C14","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,45,1.22,null,null,"T7",{"$f":"Sheet1!D15/Sheet1!C15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,56.25,1.28,null,null,"T8",{"$f":"Sheet1!D16/Sheet1!C16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,67.5,1.34,null,null,"T9",{"$f":"Sheet1!D17/Sheet1!C17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,78.75,1.41,null,null,"T10",{"$f":"Sheet1!D18/Sheet1!C18","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,90,1.48]
[null,"*","*"]
[]
["T2","ANSWER:",{"$f":"INDEX(B5:C15,MATCH(Sheet1!B10,Sheet2!B5:B15,0),2)","v":1},"SEE PAGE 946, MATCH & INDEX FUNCTIONS"]
["T3","ANSWER",{"$f":"INDEX(B6:C16,MATCH(Sheet1!B11,Sheet2!B6:B16,0),2)","v":1},"SEE PAGE 946, MATCH & INDEX FUNCTIONS"]
["T4","ANSWER",{"$f":"INDEX(B5:C15,MATCH(Sheet1!B12,Sheet2!B5:B15,0),2)","v":1},"SEE PAGE 946, MATCH & INDEX FUNCTIONS"]
["T5","ANSWER",{"$f":"INDEX(B5:C15,MATCH(Sheet1!B13,Sheet2!B5:B15,0),2)","v":1},"SEE PAGE 946, MATCH & INDEX FUNCTIONS"]
["T6","ANSWER",{"$f":"INDEX(B5:C15,MATCH(Sheet1!B14,Sheet2!B5:B15,0),2)","v":1},"SEE PAGE 946, MATCH & INDEX FUNCTIONS"]
["T7","ANSWER",{"$f":"INDEX(B5:C15,MATCH(Sheet1!B15,Sheet2!B5:B15,0),2)","v":1},"SEE PAGE 946, MATCH & INDEX FUNCTIONS",null,null,null,"T2"]
["T8","ANSWER",{"$f":"INDEX(B5:C15,MATCH(Sheet1!B16,Sheet2!B5:B15,0),2)","v":1},"SEE PAGE 946, MATCH & INDEX FUNCTIONS",null,null,null,"T3"]
["T9","ANSWER",{"$f":"INDEX(B5:C15,MATCH(Sheet1!B17,Sheet2!B5:B15,0),2)","v":1},"SEE PAGE 946, MATCH & INDEX FUNCTIONS",null,null,null,"T4"]
["T10","ANSWER",{"$f":"INDEX(B5:C15,MATCH(Sheet1!B18,Sheet2!B5:B15,0),2)","v":1},"SEE PAGE 946, MATCH & INDEX FUNCTIONS",null,null,null,"T5"]
[null,null,null,null,null,null,null,"T6"]
[null,null,null,null,null,null,null,"T7"]
[null,null,null,null,null,null,null,"T8"]
[null,null,null,null,null,null,null,"T9"]
[null,null,null,null,null,null,null,"T10"]

{"sheet":"CALC 2","index":2,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[[5,15,6,16]]}
[null,"PULLING CALCULATIONS"]
[]
["CABLE WEIGHT PER 1000 FT",null,null,{"$f":"Sheet1!J9","v":440},null,{"$f":"50*Sheet2!C17","v":50},{"$f":"F3+(C10*D3/1000*0.25)","v":50},{"$f":"G3-(C10*D3/1000)*(SIN(D10*PI()/180))-((0.25)*(COS(D10*PI()/180)))","v":49.75},{"$f":"G3+C10*D3/1000*((SIN(E10*PI()/180))+((0.25)*(COS(E10*PI()/180))))","v":50},null,null,null,null,null,{"$f":"Sheet1!A8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O3=0,50,O3)","v":50},null,50]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coefficient of Friction ="]
[null,"ALWAYS CHOOSE ONE",null,"USE WITH LENGTH ONLY FOR HILLS",null,null,"FORMULAS",null,null,null,null,null,null,null,null,null,null,0.3]
[null,"ANGLE OF CURVE ","LENGTH","DOWNWARD SLOPE (FEET)","UPWARD SLOPE (FEET)","ANGLE OF CURVE ","LENGTH","DOWNWARD SLOPE (FEET)","UPWARD SLOPE (FEET)"]
["T1 = 50#",null,null,null,null,{"$f":"Sheet1!M28","v":50},{"$f":"Sheet1!M28","v":50},{"$f":"Sheet1!M28","v":50},{"$f":"Sheet1!M28","v":50}]
["T2",{"$f":"Sheet1!B10","v":0},{"$f":"Sheet1!C10","v":0},{"$f":"Sheet1!D10","v":0},{"$f":"Sheet1!E10","v":0},{"$f":"M4*(Sheet2!C17)","v":50},{"$f":"M4+(C10*D3/1000*R7)","v":50},{"$f":"50-((C10*D3/1000)*((SIN(ATAN(D10/C10)))-((R7)*(COS(ATAN(D10/C10))))))","v":{"$error":"#DIV/0!"}},{"$f":"50+((C10*D3/1000)*((SIN(ATAN(E10/C10)))+((R7)*(COS(ATAN(E10/C10))))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(B10>0, N(F10))+IF(C10>0,N(G10))","v":0},{"$f":"IF(D10>0, N(H10))+IF(E10>0,N(I10))","v":0},{"$f":"IF(AND(D10=0,E10=0),N(J10),N(K10))","v":0},{"$f":"IF(L10>0,N(L10))","v":false}]
["T3",{"$f":"Sheet1!B11","v":0},{"$f":"Sheet1!C11","v":0},{"$f":"Sheet1!D11","v":0},{"$f":"Sheet1!E11","v":0},{"$f":"L10*Sheet2!C18","v":0},{"$f":"L10+(C11*D3/1000*R7)","v":0},{"$f":"M10-((C11*D3/1000)*((SIN(ATAN(D11/C11)))-((R7)*(COS(ATAN(D11/C11))))))","v":{"$error":"#DIV/0!"}},{"$f":"M10+((C11*D3/1000)*((SIN(ATAN(E11/C11)))+((R7)*(COS(ATAN(E11/C11))))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(B11>0, N(F11))+IF(C11>0,N(G11))","v":0},{"$f":"IF(D11>0, N(H11))+IF(E11>0,N(I11))","v":0},{"$f":"IF(AND(D11=0,E11=0),N(J11),N(K11))","v":0},{"$f":"IF(L11>0,N(L11),N(M10))","v":0}]
["T4",{"$f":"Sheet1!B12","v":0},{"$f":"Sheet1!C12","v":0},{"$f":"Sheet1!D12","v":0},{"$f":"Sheet1!E12","v":0},{"$f":"L11*Sheet2!C19","v":0},{"$f":"L11+(C12*D3/1000*R7)","v":0},{"$f":"M11-((C12*D3/1000)*((SIN(ATAN(D12/C12)))-((R7)*(COS(ATAN(D12/C12))))))","v":{"$error":"#DIV/0!"}},{"$f":"M11+((C12*D3/1000)*((SIN(ATAN(E12/C12)))+((R7)*(COS(ATAN(E12/C12))))))","v":{"$error":"#DIV/0!"}},0,0,0,{"$f":"IF(L12>0,N(L12),N(M11))","v":0}]
["T5",{"$f":"Sheet1!B13","v":0},{"$f":"Sheet1!C13","v":0},{"$f":"Sheet1!D13","v":0},{"$f":"Sheet1!E13","v":0},{"$f":"L12*Sheet2!C20","v":0},{"$f":"L12+(C13*D3/1000*R7)","v":0},{"$f":"M12-((C13*D3/1000)*((SIN(ATAN(D13/C13)))-((R7)*(COS(ATAN(D13/C13))))))","v":{"$error":"#DIV/0!"}},{"$f":"M12+((C13*D3/1000)*((SIN(ATAN(E13/C13)))+((R7)*(COS(ATAN(E13/C13))))))","v":{"$error":"#DIV/0!"}},0,0,0,{"$f":"IF(L13>0,N(L13),N(M12))","v":0}]
["T6",{"$f":"Sheet1!B14","v":0},{"$f":"Sheet1!C14","v":0},{"$f":"Sheet1!D14","v":0},{"$f":"Sheet1!E14","v":0},{"$f":"L13*Sheet2!C21","v":0},{"$f":"L13+(C14*D3/1000*R7)","v":0},{"$f":"M13-((C14*D3/1000)*((SIN(ATAN(D14/C14)))-((R7)*(COS(ATAN(D14/C14))))))","v":{"$error":"#DIV/0!"}},{"$f":"M13+((C14*D3/1000)*((SIN(ATAN(E14/C14)))+((R7)*(COS(ATAN(E14/C14))))))","v":{"$error":"#DIV/0!"}},0,0,0,0]
["T7",{"$f":"Sheet1!B15","v":0},{"$f":"Sheet1!C15","v":0},{"$f":"Sheet1!D15","v":0},{"$f":"Sheet1!E15","v":0},{"$f":"L14*Sheet2!C22","v":0},{"$f":"L14+(C15*D3/1000*R7)","v":0},{"$f":"M14-((C15*D3/1000)*((SIN(ATAN(D15/C15)))-((R7)*(COS(ATAN(D15/C15))))))","v":{"$error":"#DIV/0!"}},{"$f":"M14+((C15*D3/1000)*((SIN(ATAN(E15/C15)))+((R7)*(COS(ATAN(E15/C15))))))","v":{"$error":"#DIV/0!"}},0,0,0,0]
["T8",{"$f":"Sheet1!B16","v":0},{"$f":"Sheet1!C16","v":0},{"$f":"Sheet1!D16","v":0},{"$f":"Sheet1!E16","v":0},{"$f":"L15*Sheet2!C23","v":0},{"$f":"L15+(C16*D3/1000*R7)","v":0},{"$f":"M15-((C16*D3/1000)*((SIN(ATAN(D16/C16)))-((R7)*(COS(ATAN(D16/C16))))))","v":{"$error":"#DIV/0!"}},{"$f":"M15+((C16*D3/1000)*((SIN(ATAN(E16/C16)))+((R7)*(COS(ATAN(E16/C16))))))","v":{"$error":"#DIV/0!"}},0,0,0,0]
["T9",{"$f":"Sheet1!B17","v":0},{"$f":"Sheet1!C17","v":0},{"$f":"Sheet1!D17","v":0},{"$f":"Sheet1!E17","v":0},{"$f":"L16*Sheet2!C24","v":0},{"$f":"L16+(C17*D3/1000*R7)","v":0},{"$f":"M16-((C17*D3/1000)*((SIN(ATAN(D17/C17)))-((R7)*(COS(ATAN(D17/C17))))))","v":{"$error":"#DIV/0!"}},{"$f":"M16+((C17*D3/1000)*((SIN(ATAN(E17/C17)))+((R7)*(COS(ATAN(E17/C17))))))","v":{"$error":"#DIV/0!"}},0,0,0,0]
["T10",{"$f":"Sheet1!B18","v":0},{"$f":"Sheet1!C18","v":0},{"$f":"Sheet1!D18","v":0},{"$f":"Sheet1!E18","v":0},{"$f":"L17*Sheet2!C25","v":0},{"$f":"L17+(C18*D3/1000*R7)","v":0},{"$f":"M17-((C18*D3/1000)*((SIN(ATAN(D18/C18)))-((R7)*(COS(ATAN(D18/C18))))))","v":{"$error":"#DIV/0!"}},{"$f":"M17+((C18*D3/1000)*((SIN(ATAN(E18/C18)))+((R7)*(COS(ATAN(E18/C18))))))","v":{"$error":"#DIV/0!"}},0,0,0,0]
[]
["PULLING TENSION",null,{"$f":"M18","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"ATAN(17.5/500)","v":3.4985718828525754E-2}]
[null,null,null,null,null,null,null,null,{"$f":"I26*(180/PI())","v":2.0045340321059042}]

{"sheet":"Module1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Module2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}