{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Overview","CPA","Sketch","Data","Drafting"],"not_rendered":{"charts":2,"images":6,"macros":1,"external_links":0,"defined_names":85,"comments":2,"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":"Overview","index":0,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,11,0],[8,1,11,9],[5,0,7,0],[5,1,7,9],[0,1,0,7],[0,8,0,9],[1,1,1,9],[2,0,4,0],[2,1,4,9]]}
["Title and revision","Cable Pulling Analysis",null,null,null,null,null,null,"Rev 4"]
["Purpose","To provide a quick and easy method of performing detailed cable pulling calculations and ensuring that the CSA and FortisAlberta structural design requirements are met."]
["Legal requirements and internal policies","CSA C22.3 No1-10\nCSA C22.1\nFortisAlberta Distribution Design Manual D08-04\n"]
[]
[]
["Method of calculations","The Cable Pulling Analysis (CPA) spreadsheet follows guidelines laid down in FortisAlberta’s design standards for calculating underground cable pulling tensions. Please see the CPA documentation for details on the calculations found in this sheet."]
[]
[]
["Limitations","Certain assumptions and design details are used in the CPA that may not be realized during actual construction. Field practices may vary from site to site as will factors such as equipment wear and tear or cleanliness of the cable and duct. Also, data used in the CPA may be outdated or not match what is actually used out in the field and therefore must be checked.\n\nA major limitation of the CPA is that it is unable to account for duct strength and therefore the conduit may collapse under high tension even if the CPA indicates the pull is safe. A full list of all other limitations of the CPA can be found in the documentation (Part 3)."]

{"sheet":"CPA","index":1,"n_rows":60,"n_cols":39,"rows_kept":60,"cut":false,"hidden":false,"merged":[[47,8,47,9],[36,2,36,4],[44,9,45,10],[6,7,6,8],[26,26,26,27],[27,26,27,27],[0,10,4,14],[8,10,18,12],[0,2,0,9],[1,2,1,4],[1,6,1,8],[15,2,15,3],[2,2,2,4],[2,6,2,8],[3,2,3,4],[3,6,3,8]]}
["Project Description:",null,null,null,null,null,null,null,null,null,"Notes: \n1. Plan View and Profile are automatically produced in the \"Sketch\" tab.\n2. Cable, conduit, pull rope data, coefficients of friction and other data tables are listed in the \"Data\" Tab.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ignore (not for designer use)"]
["Project Number:",null,null,null,null,"Cell","Adjustable Auto Calc or Fill",null,null,"Green",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End","End","End","End","End","End"]
["Designer:",null,null,null,null,"Colour","Fixed Auto Calculation or Fill",null,null,"Yellow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Straight","Straight","Straight","Straight","Straight","Straight"]
["Date:",null,null,null,null,"Codes","To be filled in by designer",null,null,"Tan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Down","Up","Pull Box","Down","Pull Box","Pull Box"]
["Section 1: Conduit, Conductor and Pulling Apparatus Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Up","Left","Convex Up","Pull Box","Convex Up","Down"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Left","Right","Block Up","Block Down","Cancel Last Entry","Cancel Last Entry"]
[null,"Conduit Type","4\" DB2",null,null,null,"Method of Cable Attachment","One Basket Grip on Three Cables",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Right","Pull Box","Block Down",null,"Block Up","Block Down"]
[null,"Conduit I.D.[mm]",{"$f":"CONVERT(IF(C7<>\"\",VLOOKUP(C7,data_conduits,2,FALSE),0),\"mm\",IF(english=TRUE,\"in\",\"mm\"))","v":100.1014},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pull Box","Convex Down","Block Convex Up"]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Convex Down","Dip","Block Left"]
[null,"Conductor Type","#1 AL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Convex Up","Block Up","Block Right"]
[null,"Number of Cables",3,{"$f":"IF(ISBLANK(manual_cable_type), IF(USEB=\"No\", IF(AND(H7=AF16, C11>3), \"Max 3 Cables for 1 grip!\", IF(AND(C11<>3, H7=AF16), \"Change Method of Cable Attachment\", \"\")), IF(AND(H7=AF16, C11>1), \"Max 1 USEB cable per grip!\", IF(AND(C11<>3, H7=AF16), \"Change Method of Cable Attachment\", \"\"))), IF(AND(H7=AF16, C11>3), \"Max 3 Cables for 1 grip!\", IF(AND(C11<>3, H7=AF16), \"Change Method of Cable Attachment\", \"\")))","v":""},null,null,null,null,"Optional Fields",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dip","Block Down"]
[null,"Nominal O.D. [mm]",{"$f":"IF(AND($C$11>0,$C$10<>\"\"),VLOOKUP($C$10,data_conductors,8,FALSE),0)","v":29.692599999999999},null,null,null,null,"Basic Coefficient of Friction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Block Up","Block Convex Down"]
[null,"Per Cable Mass [kg/m]",{"$f":"IF(AND($C$11>0,$C$10<>\"\"),VLOOKUP($C$10,data_conductors,7,FALSE)/1000,0)","v":0.82137000000000004},null,null,null,null,"Puller Equipment Tension Allowance",5000,"lbs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(auto-calc)",true,"(logic check)",true,"(english)",false,null,"Block Down","Block Left"]
[null,"Standard Reel Length [m]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(n)",{"$f":"SUM(INDEX(infoRange,2))","v":3},null,null,null,null,null,"Block Convex Up","Block Right"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(o.d.)",{"$f":"MAX(INDEX(infoRange,3))","v":29.692599999999999},null,null,null,"Aluminum Compression",null,"Block Convex Down"]
[null,"Configuration",{"$f":"determineConf(d,dD,n)","v":"Cradled"},null,null,null,null,"Weight Correction Factor",{"$f":"calcWc(configurationType,d,dD,n)","v":1.2371271638948407},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(unit mass)",{"$f":"INDEX(infoRange,4)*TRANSPOSE(INDEX(infoRange,2))","v":2.4641100000000002},null,{"$f":"IF(AND(E11>0,E10<>\"\"),E11*E13,\"\")","v":""},null,"One Basket Grip on Three Cables",null,"Block Left"]
[null,"Lubrication","No",null,null,null,null,"Total Cables Unit Weight [N/m]",{"$f":"AB16*9.801","v":24.150742110000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(unit area)",{"$f":"0.25*PI()*(INDEX(infoRange,3)^2*TRANSPOSE(INDEX(infoRange,2)))","v":2077.3400380288667},null,null,null,"One Basket Grip on Each Cable",null,"Block Right"]
[null,"Initial Reel Tension [N]",444.82220000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(reel)",{"$f":"MIN(INDEX(infoRange,5))","v":0}]
[]
["Section 2: Design Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(initial reel)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA22/2","v":222.4111}]
[null,"Section",1,{"$f":"IF(ISBLANK(C23),\"\",C22+1)","v":2},{"$f":"IF(ISBLANK(D23),\"\",D22+1)","v":3},"","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,444.82220000000001]
[null,"Type","Down","Straight",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1112]
[null,"Initial Reel Tension [N]",{"$f":"tension","v":444.82220000000001},444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,444.82220000000001,null,null,null,null,null,null,null,null,1,1]
[null,"Length [m]",null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(USEB cable?)",{"$f":"IF(VLOOKUP(C10,cable_mat,6,FALSE) = \"Yes\", \"Yes\", \"No\")","v":"No"}]
[null,"Grade [°]",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(concentric wire?)",{"$f":"IF(VLOOKUP(C10, list_conductors_type, 2,FALSE) = \"Primary\", \"Yes\", \"No\")","v":"Yes"}]
[null,"Angle [°]",90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(conduit material type)",null,{"$f":"VLOOKUP(C7,conduit_mat,2,FALSE)","v":"PVC"}]
[null,"Radius [m]",{"$f":"IF(REPLACE(C23, 6, 15, \"\")=\"Block\", 0.4223, IF(OR(C27=90, C27=45, C27=22.5), VLOOKUP(conduitType, data_conduits, 5, FALSE), VLOOKUP(conduitType, data_conduits, 7, FALSE)))","v":0.91439999999999999},0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,0.40600000000000003,null,null,null,null,null,null,null,null,"(cable material type)",null,{"$f":"VLOOKUP(C10,cable_mat,2,FALSE)","v":"LLDPE"},null,{"$f":"IF(ISBLANK(AE29)=TRUE,1,2)","v":1}]
[null,{"$f":"IF(AND(C29=\"\", D29=\"\", E29=\"\", F29=\"\", G29=\"\", H29=\"\", I29=\"\", J29=\"\", K29=\"\", L29=\"\", M29=\"\", N29=\"\", O29=\"\", P29=\"\", Q29=\"\"), \"\", \"Minimum Req'd Radius\")","v":""},{"$f":"IF(OR(C23=\"Straight\", C23=\"End\", C23=\"Pull Box\", C23=\"Dip\", ISBLANK(C23)), \"\", IF(REPLACE(C23, 6, 15, \"\")=\"Block\", C60, IF(VLOOKUP($C$10, list_conductors_type, 2, FALSE)= \"Primary\", IF(MAX(C30/concentricSWBP, VLOOKUP($C$10, data_bending_radius, 5, FALSE), VLOOKUP(conduitType, data_conduits, 7, FALSE))>C28, \"Min \"&ROUND(MAX(C30/concentricSWBP, VLOOKUP($C$10, data_bending_radius, 5, FALSE), VLOOKUP(conduitType, data_conduits, 7, FALSE)), 4)&\"m\", \"\"), IF(MAX(C30/shieldedSWBP, VLOOKUP($C$10, data_bending_radius, 5, FALSE), VLOOKUP(conduitType, data_conduits, 7, FALSE))>C28, \"Min \"&ROUND(MAX(C30/shieldedSWBP, VLOOKUP($C$10, data_bending_radius, 5, FALSE), VLOOKUP(conduitType, data_conduits, 7, FALSE)), 4)&\"m\", \"\"))))","v":""},"","","","","","","","","","","","","","",{"$f":"VLOOKUP(conduitType, data_conduits, 5, FALSE)","v":0.91439999999999999}]
[null,"Pull Tension [N]",754.2970991821137,843.9297164596137,843.9297164596137,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Formulas for Not unique)"]
[null,{"$f":"\"SWBP \"&IF(english,\"[lb/ft]\",\"[N/m]\")","v":"SWBP [N/m]"},470.57819144487956,13.777044352500003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal O.D. [mm]",{"$f":"IF(AND($C$11>0,$C$10<>\"\"),VLOOKUP($C$10,data_conductors,8,FALSE),0)","v":29.692599999999999}]
[null,"Coefficient of Friction",0.3,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit Mass  [kg/m]",{"$f":"IF(AND($C$11>0,$C$10<>\"\"),VLOOKUP($C$10,data_conductors,7,FALSE)/1000,0)","v":0.82137000000000004}]
[null,"Effective Friction",0.37113814916845217,0.37113814916845217,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard Reel Length [m]",{"$f":"IF(AND($C$11>0,$C$10<>\"\"),VLOOKUP($C$10,data_conductors,9,FALSE),0)","v":800}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum Calculated Pull Tension [N]",{"$f":"MAX(INDEX(outputRange,1,))","v":843.9297164596137},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(manual cable jacket material)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum Calculated SWBP [N/m]",{"$f":"MAX(INDEX(outputRange,2,))","v":470.57819144487956},null,null,null,null,null,null,null,null,null,null,null,null,"(conductor tension constant)",{"$f":"VLOOKUP(C10,cable_mat,4,FALSE)","v":2.6700000000000002E-2},null,"(manual tension constant)"]
[null,"Progress:","Done",null,null,{"$f":"IF(ISBLANK(manual_friction), IF(C23=\"End\", \"\", IF(OR(C33 <> C32*Wc, IF(lub=\"Yes\", C32<>VLOOKUP(conduit_mat_type, lub_friction_cond, IF(ISBLANK(manual_cable_mat), IF(cable_mat_type=\"LLDPE\", 2, 3), IF(manual_cable_mat=\"LLDPE\", 2, 3)), FALSE), C32<>VLOOKUP(conduit_mat_type, unlub_friction_cond, IF(ISBLANK(manual_cable_mat), IF(cable_mat_type=\"LLDPE\", 2, 3), IF(manual_cable_mat=\"LLDPE\", 2, 3)), FALSE))), \"Update Incomplete\", \"\")), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(conductor area)",{"$f":"VLOOKUP(C10,cable_mat,5,FALSE)","v":83690},null,"(manual conductor area)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(manual cable type)"]
["Section 3: Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(table 6 maximum pulling tension cable grips)",{"$f":"IF(concentric_1=\"No\",IF(n=1, unshieldedSingle, unshieldedMultiple),IF(n=1,concentricSingle,concentricMultiple))","v":22241},null,"(manual maximum tension cable grips)",null,{"$f":"IF(concentric=\"No\",IF(n=1, unshieldedSingle, unshieldedMultiple),IF(n=1,concentricSingle,concentricMultiple))","v":22241}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(table 7 (standard) max pulling tension)",{"$f":"IF(H7=AF15, VLOOKUP(C10, max_pulling_tension, IF(n=1, 2, 3), FALSE), IF(H7=AF16, VLOOKUP(C10, max_pulling_tension, IF(n=1, 4, 5), FALSE), VLOOKUP(C10, max_pulling_tension, IF(n=1, 4, 6), FALSE)))","v":4465.7920000000004},null,"(Manual maximum tension)",{"$f":"IF(H7=AF15, IF(C11=1, 1, C11-1)*manual_cond_area*manual_tens_const, MIN(IF(C11=1, 1, C11-1)*manual_cond_area*manual_tens_const, manual_max_tens))","v":0}]
[null,"Pull Tension [N]",{"$f":"O35","v":843.9297164596137},{"$f":"ROUND(C41/4.448, 0)&\" lbs\"","v":"190 lbs"},null,null,null,{"$f":"IF(J41=\"OK\",\"\",\"Over \")&\"Maximum Tension Allowance \" &IF(J41=\"OK\",\"Remaining\",\"\") &\" [%]\"","v":"Maximum Tension Allowance Remaining [%]"},{"$f":"IF(ISBLANK(manual_tens_const), ABS((O35-AC41)/AC41)*100, ABS(manual_max_tens_b-O35)/manual_max_tens_b*100)","v":81.116110318407692},{"$f":"IF(ISBLANK(manual_tens_const), IF(AC41-O35<0, \"NOT OK\", \"OK\"), IF(MIN(IF(C11=1, 1, C11-1)*manual_cond_area*manual_tens_const, manual_max_tens)-O35<0, \"NOT OK\", \"OK\"))","v":"OK"},null,null,null,null,{"$f":"IF(Q41=\"OK\",\"\",\"Over \")&\"Puller\"&\" Tension Allowance \" &IF(Q41=\"OK\",\"Remaining\",\"\")&\" [%]\"","v":"Puller Tension Allowance Remaining [%]"},{"$f":"ABS(AC42-O35)/AC42*100","v":96.205351994336269},{"$f":"IF(AC42-O35<0, \"NOT OK\", \"OK\")","v":"OK"},null,null,null,null,null,null,null,null,null,null,"(table 7 expanded as calculated by the CPA)",{"$f":"MIN(IF(AND(n>=3, H7=AF17), IF(concentric_1=\"Yes\", concentricSingle*2, unshieldedSingle*2), IF(H7=AF15, 99999, AC39)), IF(USEB=\"Yes\", AC36*AC37*2, IF(n>1, AC36*AC37*(n-1), AC36*AC37*n)))","v":4469.0460000000003},null,"(concentric wire?)","Yes"]
[null,"Maximum SWBP [N/m]",{"$f":"O36","v":470.57819144487956},null,null,null,null,{"$f":"IF(J42=\"OK\",\"\",\"Over \")&\"Cable SWBP Allowance \" &IF(J42=\"OK\",\"Remaining\",\"\") &\" [%]\"","v":"Cable SWBP Allowance Remaining [%]"},{"$f":"IF(ISBLANK(manual_tens_const), IF(VLOOKUP($C$10, list_conductors_type, 2, FALSE)= \"Primary\", ABS(concentricSWBP-C42)/(concentricSWBP)*100, ABS(shieldedSWBP-C42)/(shieldedSWBP)*100), IF(manual_cable_type=\"Concentric Wire\", ABS(concentricSWBP-C42)/(concentricSWBP)*100, ABS(shieldedSWBP-C42)/(shieldedSWBP)*100))","v":98.38767714549823},{"$f":"IF(VLOOKUP($C$10, list_conductors_type, 2, FALSE)= \"Primary\",IF(concentricSWBP-C42>0,\"OK\",\"NOT OK\"),IF(shieldedSWBP-C42>0,\"OK\",\"NOT OK\"))","v":"OK"},null,null,null,null,{"$f":"IF(Q42=\"OK\",\"\",\"Over \")&\"Pulling Equipment Tension Allowance \" &IF(Q42=\"OK\",\"Remaining\",\"\")&\" [%]\"","v":"Pulling Equipment Tension Allowance Remaining [%]"},{"$f":"IF(H7=AF15, ABS(4000*4.448-O35)/(4000*4.448)*100, ABS(3280*4.448-O35)/(3280*4.448)*100)","v":94.215475601122364},{"$f":"IF(3280*4.448-O35<0, \"NOT OK\", \"OK\")","v":"OK"},null,null,null,null,null,null,null,null,null,null,"(maximum pulling tension, puller equipment)",{"$f":"IF(I13=\"\", 5000*4.448, I13*4.448)","v":22240.000000000004}]
[]
[]
[null,"Groove Snag Potential",{"$f":"d/VLOOKUP(\"Pull Rope\",data_conductors,8,FALSE)","v":1.3496636363636363},{"$f":"IF(C45>1,\"Low\",IF(C42<maxSWBP,IF(C45>0.9,\"Moderate\",\"High\"),\"High\"))","v":"Low"},null,null,null,"Calculated System Linear Length [m]",11.293156881433958,{"$f":"IF(C14>0,IF(length>AB18,\"Larger Reel or Splicing/Pull Box\",IF(CEILING(n*length/AB18,1)=1,CEILING(n*length/AB18,1)&\" Reel\",CEILING(n*length/AB18,1)&\" Reels\")),\"Unavailable\")","v":"Unavailable"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USEB Cable Minor Dimenstion",{"$f":"VLOOKUP(C10, data_conductors, 6, FALSE)","v":0}]
[null,"Jamming Ratio",{"$f":"IF(USEB=\"Yes\", dD/Y, dD/d)","v":3.3712574850299402},{"$f":"IF(n=1,\"Low\",IF(C46<2.5,\"Low\",IF(C46<2.8,\"Moderate\",IF(C46<=3,\"High\", \"Low\"))))","v":"Low"},null,null,null,"Total Length of Cable Needed [m]",{"$f":"n*length","v":33.879470644301875},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USEB Cable Major Dimenstion",{"$f":"VLOOKUP(C10, data_conductors, 5, FALSE)","v":0}]
[null,"XSect Area Used [%]",{"$f":"IF(USEB=\"Yes\", ((PI()*Z^2/4+Z*(Y-Z)*n)/(PI()*(dD/2)^2))*100, AB17/(PI()*(dD/2)^2)*100)","v":26.39595670239045},{"$f":"IF(AB14=1,IF(C47<53,\"OK\",\"NOT OK\"),IF(AB14=2,IF(C47<31,\"OK\",\"NOT OK\"),IF(C47<40,\"OK\",\"NOT OK\")))","v":"OK"}]
[null,"Clearance [mm]",{"$f":"IF(USEB=\"Yes\", dD-1.05*Y, calcClearance(n,d,dD,0.05))","v":38.197443740341214},{"$f":"IF(ISERROR(C48), \"NOT OK\", IF(C48>12.6,\"OK\",\"NOT OK\"))","v":"OK"},null,null,null,"Volume of Lubricant Needed [L]",{"$f":"IF(lub=\"Yes\",(n*PI()*((0.254/1000)^2+2*d/2000*(0.254/1000))*1000*length+(PI()*((0.254/1000)^2+2*VLOOKUP(\"Pull Rope\",data_conductors,8,FALSE)/2000*(0.254/1000)))*1000*length)*IF(lub=\"Yes\",1,0),\"No Lubrication\")","v":"No Lubrication"},null,null,null,"Lubrication Required",{"$f":"IF(lub=\"Yes\",\"Selected\",IF(OR(I41<30,P41<30,P42<0,J41=\"NOT OK\",J42=\"NOT OK\",Q41=\"NOT OK\",Q42=\"NOT OK\"), \"Yes\", \"No\"))","v":"No"}]
[]
[]
[]
[null,{"$f":"IF(english,\"Metric\",\"English\") &\" Units for Comparison Purposes Only (not printed)\"","v":"English Units for Comparison Purposes Only (not printed)"}]
[]
[null,{"$f":"\"Pull Tension \"&IF(english,\"[N]\",\"[lb]\")","v":"Pull Tension [lb]"},{"$f":"IF(C30<>\"\",CONVERT(C30,IF(english=TRUE,\"lbf\",\"N\"),IF(english=TRUE,\"N\",\"lbf\")),\"\")","v":169.57273365030846},189.72294760772411,189.72294760772411,"","","","","","","","","","",""]
[null,{"$f":"\"SWBP \"&IF(english,\"[N/m]\",\"[lb/ft]\")","v":"SWBP [lb/ft]"},{"$f":"IF(C31<>\"\",IF(english=TRUE,C31*14.5939041994751,C31/14.5939041994751),\"\")","v":32.244845862548893},{"$f":"IF(D31<>\"\",IF(english=TRUE,D31*14.5939041994751,D31/14.5939041994751),\"\")","v":0.94402732566899561},"","","","","","","","","","","",""]
[]
[]
[]
[null,"Minimum Req'd Radius:",1,{"$f":"C59+1","v":2},{"$f":"D59+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15]
[null,"→ If using Blocks",{"$f":"IF(VLOOKUP($C$10, list_conductors_type, 2, FALSE)= \"Primary\", IF(MAX(C30/concentricSWBP, VLOOKUP($C$10, data_bending_radius, 5, FALSE))>C28, \"Min \"&ROUND(MAX(C30/concentricSWBP, VLOOKUP($C$10, data_bending_radius, 5, FALSE)), 3)&\"m\", \"\"), IF(MAX(C30/shieldedSWBP, VLOOKUP($C$10, data_bending_radius, 5, FALSE))>C28, \"Min \"&ROUND(MAX(C30/shieldedSWBP, VLOOKUP($C$10, data_bending_radius, 5, FALSE)), 3)&\"m\", \"\"))","v":""},"","","","","","","","","","","","","",""]

{"sheet":"Sketch","index":2,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,3,38,5],[32,5,33,6],[35,4,35,5]]}
["Overall Summary:"]
[]
[]
[null,null,null,{"$f":"CPA!B7","v":"Conduit Type"},{"$f":"CPA!C7","v":"4\" DB2"}]
[null,null,null,{"$f":"CPA!B8","v":"Conduit I.D.[mm]"},{"$f":"CPA!C8","v":100.1014}]
[]
[null,null,null,{"$f":"CPA!B10","v":"Conductor Type"},{"$f":"CPA!C10","v":"#1 AL"},null,null,null,{"$f":"CPA!#REF!","v":{"$error":"#REF!"}},{"$f":"CPA!#REF!","v":{"$error":"#REF!"}},{"$f":"CPA!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"CPA!B11","v":"Number of Cables"},{"$f":"CPA!C11","v":3},null,null,null,{"$f":"CPA!#REF!","v":{"$error":"#REF!"}},{"$f":"CPA!#REF!","v":{"$error":"#REF!"}},{"$f":"CPA!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"CPA!B12","v":"Nominal O.D. [mm]"},{"$f":"CPA!C12","v":29.692599999999999},null,null,null,null,{"$f":"CPA!#REF!","v":{"$error":"#REF!"}},{"$f":"CPA!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"CPA!B13","v":"Per Cable Mass [kg/m]"},{"$f":"CPA!C13","v":0.82137000000000004},null,null,null,{"$f":"CPA!G13","v":0},{"$f":"CPA!#REF!","v":{"$error":"#REF!"}},{"$f":"CPA!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"CPA!B14","v":"Standard Reel Length [m]"},{"$f":"CPA!C14","v":0},null,null,null,null,{"$f":"CPA!#REF!","v":{"$error":"#REF!"}},{"$f":"CPA!#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,null,{"$f":"CPA!B16","v":"Configuration"},{"$f":"CPA!C16","v":"Cradled"}]
[null,null,null,{"$f":"CPA!B17","v":"Lubrication"},{"$f":"CPA!C17","v":"No"}]
[null,null,null,{"$f":"CPA!B18","v":"Initial Reel Tension [N]"},{"$f":"CPA!C18","v":444.82220000000001}]
[]
[null,null,null,{"$f":"CPA!H16","v":"Weight Correction Factor"},{"$f":"CPA!I16","v":1.2371271638948407}]
[null,null,null,{"$f":"CPA!H17","v":"Total Cables Unit Weight [N/m]"},{"$f":"CPA!I17","v":24.150742110000003}]
[]
[null,null,null,{"$f":"CPA!B41","v":"Pull Tension [N]"},{"$f":"CPA!C41","v":843.9297164596137},{"$f":"ROUND(E20/4.448, 0)&\" lbs\"","v":"190 lbs"}]
[null,null,null,{"$f":"CPA!B42","v":"Maximum SWBP [N/m]"},{"$f":"CPA!C42","v":470.57819144487956}]
[null,null,null,{"$f":"CPA!B45","v":"Groove Snag Potential"},{"$f":"CPA!C45","v":1.3496636363636363},{"$f":"CPA!D45","v":"Low"}]
[null,null,null,{"$f":"CPA!B46","v":"Jamming Ratio"},{"$f":"CPA!C46","v":3.3712574850299402},{"$f":"CPA!D46","v":"Low"}]
[null,null,null,{"$f":"CPA!B47","v":"XSect Area Used [%]"},{"$f":"CPA!C47","v":26.39595670239045},{"$f":"CPA!D47","v":"OK"}]
[null,null,null,{"$f":"CPA!B48","v":"Clearance [mm]"},{"$f":"CPA!C48","v":38.197443740341214},{"$f":"CPA!D48","v":"OK"}]
[]
[null,null,null,{"$f":"CPA!H41","v":"Maximum Tension Allowance Remaining [%]"},{"$f":"CPA!I41","v":81.116110318407692},{"$f":"CPA!J41","v":"OK"}]
[null,null,null,{"$f":"CPA!H42","v":"Cable SWBP Allowance Remaining [%]"},{"$f":"CPA!I42","v":98.38767714549823},{"$f":"CPA!J42","v":"OK"}]
[null,null,null,{"$f":"CPA!O41","v":"Puller Tension Allowance Remaining [%]"},{"$f":"CPA!P41","v":96.205351994336269},{"$f":"CPA!Q41","v":"OK"}]
[null,null,null,{"$f":"CPA!O42","v":"Pulling Equipment Tension Allowance Remaining [%]"},{"$f":"CPA!P42","v":94.215475601122364},{"$f":"CPA!Q42","v":"OK"}]
[]
[]
[null,null,null,{"$f":"CPA!H45","v":"Calculated System Linear Length [m]"},{"$f":"CPA!I45","v":11.293156881433958},{"$f":"CPA!J45","v":"Unavailable"}]
[null,null,null,{"$f":"CPA!H46","v":"Total Length of Cable Needed [m]"},{"$f":"CPA!I46","v":33.879470644301875}]
[]
[null,null,null,{"$f":"CPA!H48","v":"Volume of Lubricant Needed [L]"},{"$f":"CPA!I48","v":"No Lubrication"}]
[null,null,null,{"$f":"CPA!M48","v":"Lubrication Required"},{"$f":"CPA!N48","v":"No"}]
[]
[null,null,null,{"$f":"IF(OR(F24=\"NOT OK\",F25=\"NOT OK\",F27=\"NOT OK\",F28=\"NOT OK\",F29=\"NOT OK\",F30=\"NOT OK\",F31=\"NOT OK\",E37=\"YES\"),\"NOT OK\",IF(OR(F22=\"High\",F23=\"High\"),\"Caution\",\"OK\"))","v":"OK"}]

{"sheet":"Data","index":3,"n_rows":86,"n_cols":18,"rows_kept":86,"cut":false,"hidden":false,"merged":[[14,15,14,16],[77,4,77,5],[74,4,74,5],[75,4,75,5],[76,4,76,5],[41,7,41,8],[64,4,64,5],[56,4,56,5],[49,4,49,5],[42,7,42,8],[40,7,40,8],[43,7,43,8],[63,7,65,11],[46,10,46,11],[34,9,34,10],[36,9,36,10],[16,13,17,13],[42,9,42,10],[16,14,17,14],[44,7,44,8],[44,9,44,10],[38,7,38,8],[32,9,33,10],[39,7,39,8],[43,9,43,10],[34,7,34,8],[35,7,35,8],[37,7,37,8],[36,7,36,8],[38,9,38,10],[39,9,39,10],[40,9,40,10],[41,9,41,10],[32,7,33,8],[35,9,35,10],[37,9,37,10]]}
["Conductor Data"]
[]
["600V 1/0",null,null,"Conductor","Conductor","Insulation","Insulation","Major","Minor","Mass","Nominal","Reel",null,"List of"]
[null,null,null,null,"O.D.","Thickness","Diameter","Dimension","Dimension","Density","O.D.","Length",null,"Common U/G Cables"]
[null,null,null,null,"[mm]","[mm]","[mm]","[mm]","[mm]","[kg/km]","[mm]","[m]",null,"used"]
[null,null,"Secondary","600V 6 AWG",{"$f":"G6-2*F6","v":4.3940000000000001},1.143,6.68,19.3,12.62,268,{"$f":"SQRT(I6^2 + 4*((I6*H6 - I6^2)/PI()))","v":16.327906504033084},null,null,"600V 1/0","Secondary"]
[null,null,null,"600V 4 AWG",5.5139999999999993,1.143,7.8,22.56,14.76,402,{"$f":"SQRT(I7^2 + 4*((I7*H7 - I7^2)/PI()))","v":19.0903934560362},null,null,"600V 4/0","Secondary"]
[null,null,null,"600V 3 AWG",6.1740000000000013,1.143,8.4600000000000009,24.36,15.9,476,20.593167413501636,null,null,"600V 300 MCM","Secondary"]
[null,null,null,"600V 2 AWG",6.8072000000000008,1.08839,8.9839800000000007,25.07,16.09,538.36,21.044148592604149,300,null,"600V #4 AL","Secondary"]
[null,null,null,"600V 1 AWG",7.7459999999999987,1.397,10.54,28.58,18.03,669,23.817474044514377,null,null,"600V 2 AWG","Secondary"]
[null,null,null,"600V 1/0",8.700800000000001,1.39,{"$f":"0.452*25.4","v":11.4808},{"$f":"1.199*25.4","v":30.454599999999999},{"$f":"0.747*25.4","v":18.973799999999997},800.54,25.245998942293912,1000,null,"#1 AL","Primary"]
[null,null,null,"600V 2/0",9.7059999999999995,1.397,12.5,32.49,19.989999999999998,958,26.790872162747871,null,null,"500 MCM","Primary"]
[null,null,null,"600V 3/0",10.926,1.397,13.72,34.93,21.21,1135,28.642247387476178,null,null,"750 MCM","Primary"]
[null,null,null,"600V 4/0",12.256799999999998,1.39,{"$f":"0.592*25.4","v":15.036799999999998},{"$f":"1.505*25.4","v":38.226999999999997},{"$f":"0.913*25.4","v":23.190200000000001},1385.33,31.333243579421588,500]
[null,null,null,"600V 250 MCM",13.488,1.651,16.79,41.73,24.94,1653,33.987692439840906,null,null,null,null,"Nominal O.D calculation:"]
[null,null,null,"600V 300 MCM",{"$f":"G16-2*F16","v":14.784799999999997},1.65,{"$f":"0.712*25.4","v":18.084799999999998},46.74,{"$f":"1.128*25.4","v":28.651199999999996},2101.06,38.48074591923924,300,null,"Changed Values (Rev 2)"]
[null,null,null,"600V 350 MCM",{"$f":"G17-2*F17","v":15.928000000000001},1.651,19.23,49.02,29.79,2421,40.209877767834755,null,null,"Added in new 600V 2 AWG and edited nominal OD eqn (Rev 3)"]
[null,null,null,"600V #4 AL",5.19,null,null,16.489999999999998,{"$f":"0.649*25.4","v":16.4846},269.33,16.48803738838663,1100]
[null,null,"Primary","#1 AL",7.35,null,null,null,null,821.37,29.692599999999999,800]
[null,null,null,"1/0",9.19,null,null,null,null,1033,32.6,null,null,"Notes:"]
[null,null,null,"2/0",10.31,null,null,null,null,1138,33.700000000000003,null,null,"1.  To add conductors: "]
[null,null,null,"3/0",11.58,null,null,null,null,1306,35.5,null,null,"Have all required information handy for the cable to be added"]
[null,null,null,"4/0",13,null,null,null,null,1432,37,null,null,"Press 'Add New Cable Type' button"]
[null,null,null,"250 MCM",14.17,null,null,null,null,1590,38.5,null,null,"Input all information into the form. Press okay"]
[null,null,null,"350 MCM",16.760000000000002,null,null,null,null,1945,41.1,700,null,"2.  To change conductor information:"]
[null,null,null,"500 MCM",18.8,null,null,null,null,2477.52,43.9,500,null,"      Unprotect sheet."]
[null,null,null,"750 MCM",23.11,null,null,null,null,3196.22,49.02,450,null,"      Change conductor information."]
[null,null,null,"1000 MCM",28.37,null,null,null,null,4458,58.4]
[null,null,"Pull Rope","Pull Rope",null,null,null,null,null,296.7423,22,900]
[]
[]
[]
["Conduit Data",null,null,"Type","I.D. [mm]","O.D [mm]","Material","Rigid Bend Radius [m]",null,"Min CEC Bending Radius (CEC P1, rule 12-922 T7) m"]
[]
[null,null,null,"6\" DB2",149.75839999999999,159.38499999999999,"PVC",{"$f":"CONVERT(60,\"in\",\"m\")","v":1.524},null,0.76200000000000001]
[null,null,null,"4\" DB2",100.1014,107.0864,"PVC",{"$f":"CONVERT(36,\"in\",\"m\")","v":0.91439999999999999},null,0.40600000000000003]
[null,null,null,"3\" DB2",76.2,82.55,"PVC",{"$f":"CONVERT(36,\"in\",\"m\")","v":0.91439999999999999},null,0.33]
[null,null,null,"2\" DB2",50.83,57.15,"PVC",{"$f":"CONVERT(24,\"in\",\"m\")","v":0.60960000000000003},null,0.24099999999999999]
[null,null,null,"6\" PVC",154.05099999999999,168.27500000000001,"PVC",{"$f":"CONVERT(36,\"in\",\"m\")","v":0.91439999999999999},null,0.76200000000000001]
[null,null,null,"4\" PVC",102.2604,114.3,"PVC",{"$f":"CONVERT(36,\"in\",\"m\")","v":0.91439999999999999},null,0.40600000000000003]
[null,null,null,"3\" PVC",77.930000000000007,88.9,"PVC",{"$f":"CONVERT(36,\"in\",\"m\")","v":0.91439999999999999},null,0.33]
[null,null,null,"2\" PVC",52.5,60.3,"PVC",{"$f":"CONVERT(24,\"in\",\"m\")","v":0.60960000000000003},null,0.24099999999999999]
[null,null,null,"4\" HDPE",93.47,114.3,"HDPE",{"$f":"19*4.5*0.0254","v":2.1717},null,0.40600000000000003]
[null,null,null,"4\" TR",{"$f":"4*25.4","v":101.6},{"$f":"4.5*25.4","v":114.3},"PVC",0.91,null,0.40600000000000003]
[null,null,null,"1.5\" HDPE",38.96,48.26,"HDPE",{"$f":"19*1.5*0.0254","v":0.72389999999999999},null,0.19700000000000001]
[]
[null,null,null,null,null,null,null,"Material Selection Table",null,null,"Conduit",null,null,null,"Cable"]
[null,null,null,null,null,null,null,null,null,null,"Type","Material","Type","Jacket","Conductor","Conductor Cable ","Conductor","USEB cable?"]
["Dynamic Coefficients Of Friction",null,null,null,null,null,null,null,null,null,null,null,null,"Material","Material","Constant (N/cmil)","Area (cmil)"]
[null,null,"Lubricated",null,"Cable Jacket",null,null,null,null,null,"6\" DB2","PVC","600V 1/0","PVC","Alu Strand",3.56E-2,105600,"Yes"]
[null,null,null,"Conduit","LLDPE","PVC",null,null,null,null,"4\" DB2","PVC","600V 4/0","PVC","Alu Strand",3.56E-2,211600,"Yes"]
[null,null,null,"PVC",0.25,0.15,null,null,null,null,"3\" DB2","PVC","600V 300 MCM","PVC","Alu Strand",3.56E-2,300000,"Yes"]
[null,null,null,"Steel",0.49,0.22,null,null,null,null,"2\" DB2","PVC","600V #4 AL","PVC","Alu Strand",3.56E-2,41740,"No"]
[null,null,null,"HDPE",0.23,0.25,null,null,null,null,"6\" PVC","PVC","600V 2 AWG","PVC","Alu Strand",3.56E-2,66370,"Yes"]
[null,null,null,null,null,null,null,null,null,null,"4\" PVC","PVC","#1 AL","LLDPE","Alu Solid",2.6700000000000002E-2,83690,"No"]
[null,null,null,null,null,null,null,null,null,null,"3\" PVC","PVC","500 MCM","LLDPE","Alu Stranded",3.56E-2,500000,"No"]
[null,null,"Un Lubricated",null,"Cable Jacket",null,null,null,null,null,"2\" PVC","PVC","750 MCM","LLDPE","Alu Stranded",3.56E-2,750000,"No"]
[null,null,null,"Conduit","LLDPE","PVC",null,null,null,null,"4\" HDPE","HDPE"]
[null,null,null,"PVC",0.3,0.56000000000000005,null,null,null,null,"4\" TR","PVC"]
[null,null,null,"Steel",0.68,0.55000000000000004,null,null,null,null,"1.5\" HDPE","HDPE"]
[null,null,null,"HDPE",0.38,0.56000000000000005]
[]
[]
[null,null,null,null,null,null,null,"Fortis Maximum Pulling Tension               (D08-04 Table 7)"]
[null,null,null,null,"(in Newtons)",null,null,null,null,null,null,null,null,null,"Maximum Pulling Tension (N)"]
["Maximum Pulling Tension Cable Grips (D08-04 Table 6)",null,null,"Type of Cable","Single Cable","Multiple Cables",null,null,null,null,null,null,null,"Aluminum Compression",null,null,"Basket Grip"]
[null,null,null,"Unshielded",8896,8896,null,null,null,null,null,null,"Cable","One Cable","Three Cables","One Cable","3 Cables, 1 Grip","3 Grips, 1 Per Cable"]
[null,null,null,"Concentric Wire",44482,22241,null,null,null,null,null,null,"600V 1/0",{"$f":"1690*4.448","v":7517.1200000000008},"n/a",{"$f":"1690*4.448","v":7517.1200000000008},"n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"600V 4/0",15066,"n/a",{"$f":"2000*4.448","v":8896},"n/a","n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,"600V 300 MCM",{"$f":"4800*4.448","v":21350.400000000001},"n/a",{"$f":"2000*4.448","v":8896},"n/a","n/a"]
[null,null,null,null,null,"(in N/m)",null,null,null,null,null,null,"600V #4 AL",{"$f":"334*4.448","v":1485.6320000000001},"n/a",{"$f":"334*4.448","v":1485.6320000000001},"n/a","n/a"]
[null,null,null,null,null,14594,null,null,null,null,null,null,"600V 2 AWG",{"$f":"624*4.448","v":2775.5520000000001},"n/a",{"$f":"624*4.448","v":2775.5520000000001},"n/a","n/a"]
["Groove Snag Potential SWBP Limit (as per EL3333):",null,null,null,null,null,null,null,null,null,null,null,"#1 AL",{"$f":"502*4.448","v":2232.8960000000002},{"$f":"1004*4.448","v":4465.7920000000004},{"$f":"502*4.448","v":2232.8960000000002},{"$f":"1004*4.448","v":4465.7920000000004},{"$f":"1004*4.448","v":4465.7920000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,"500 MCM",{"$f":"4000*4.448","v":17792},{"$f":"8000*4.448","v":35584},{"$f":"4000*4.448","v":17792},{"$f":"5000*4.448","v":22240.000000000004},{"$f":"8000*4.448","v":35584}]
[null,null,null,null,"(in N/m of bend radius)",null,null,null,null,null,null,null,"750 MCM",{"$f":"6000*4.448","v":26688.000000000004},{"$f":"12000*4.448","v":53376.000000000007},{"$f":"6000*4.448","v":26688.000000000004},{"$f":"5000*4.448","v":22240.000000000004},{"$f":"12000*4.448","v":53376.000000000007}]
["Maximum SWBP of Bend Radius",null,null,"Type of Cable","SWBP (N/m)",null,null,null,null,null,null,"Minimum Required Bending Radius"]
[null,null,null,"Concentric Wire",29186.35,null,null,null,null,null,null,null,null,"Min Dynamic Bending Radius",null,"Min Static Bending Radius"]
[null,null,null,"Shielded Wire",21889.759999999998,null,null,null,null,null,null,null,"Cable","Inch","m","Inch","m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"600V 1/0",14,{"$f":"N79*0.0254","v":0.35559999999999997},6,{"$f":"P79*0.0254","v":0.15239999999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,"600V 4/0",16,0.40639999999999998,8,0.20319999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,"600V 300 MCM",16,0.40639999999999998,9,0.2286]
[null,null,null,null,null,null,null,null,null,null,null,null,"600V #4 AL",6,0.15239999999999998,5,0.127]
[null,null,null,null,null,null,null,null,null,null,null,null,"600V 2 AWG",8,0.20319999999999999,5,0.127]
[null,null,null,null,null,null,null,null,null,null,null,null,"#1 AL",14,0.35559999999999997,9,0.2286]
[null,null,null,null,null,null,null,null,null,null,null,null,"500 MCM",24,0.60959999999999992,15,0.38100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,"750 MCM",36,0.91439999999999999,16,0.40639999999999998]

{"sheet":"Drafting","index":4,"n_rows":154,"n_cols":9,"rows_kept":154,"cut":false,"hidden":true,"merged":[]}
["Drafting"]
[]
[null,null,{"$f":"\"i\"","v":"i"},"j","k","ij","l",null,"Notes:"]
[null,null,0,0,1.8754657503626797E-10,0,1.8754657503626797E-10,null,"1.  Do not attempt to alter or delete this sheet."]
[null,null,1.1257781304062409E-2,0,-0.14304367466838222,1.1257781304062409E-2,0.14348599409881116,null,"2.  These values are used to graph the profile and plan view."]
[null,null,4.4753921395392471E-2,0,-0.28256513952293705,4.4753921395392471E-2,0.28608734951738402]
[null,null,9.9663634137411083E-2,0,-0.41512891286530945,9.9663634137411083E-2,0.42692488129202477]
[null,null,0.17463486016716878,0,-0.53747083464101864,0.17463486016716878,0.56513027920588343]
[null,null,0.26782155908409777,0,-0.64657844070560244,0.26782155908409777,0.69985146102264095]
[null,null,0.37692916509134278,0,-0.73976513968966651,0.37692916509134278,0.83025782585684105]
[null,null,0.49927108682092147,0,-0.81473636579470232,0.49927108682092147,0.95554537510455406]
[null,null,0.6318348601295074,0,-0.86964607861828891,0.6318348601295074,1.0749416693621294]
[null,null,0.77135632496345163,0,-0.90314221879546785,0.77135632496345163,1.1877105907719787]
[null,null,0.91439999981245346,0,-0.91440000018754652,0.91439999981245346,1.293156881433958]
[null,null,1.9143999998124535,0,-0.91440000018754652,1.9143999998124535,2.293156881433958]
[null,null,2.9143999998124537,0,-0.91440000018754652,2.9143999998124537,3.293156881433958]
[null,null,3.9143999998124537,0,-0.91440000018754652,3.9143999998124537,4.2931568814339585]
[null,null,4.9143999998124537,0,-0.91440000018754652,4.9143999998124537,5.2931568814339585]
[null,null,5.9143999998124537,0,-0.91440000018754652,5.9143999998124537,6.2931568814339585]
[null,null,6.9143999998124537,0,-0.91440000018754652,6.9143999998124537,7.2931568814339585]
[null,null,7.9143999998124537,0,-0.91440000018754652,7.9143999998124537,8.2931568814339585]
[null,null,8.9143999998124528,0,-0.91440000018754652,8.9143999998124528,9.2931568814339567]
[null,null,9.9143999998124528,0,-0.91440000018754652,9.9143999998124528,10.293156881433958]
[null,null,10.914399999812453,0,-0.91440000018754652,10.914399999812453,11.293156881433958]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,0.91439999972918151,0,-0.91440000018754652,0.9143999998957254,1.2931568815172301]
[null,null,21.828799995095075,23.914400000000001,-1.0017174303813681,45.207556881246411,45.587584216128612]
[null,null,21.828799994479763,26.914400000000001,-1.2303174304306674,48.207556881246411,48.594624991718447]
[null,null,21.828799993864454,29.914400000000001,-1.5128825700336093,51.207556881246411,51.606190779014511]
[null,null,21.828799993249142,32.914400000000001,-1.7414825700488437,54.207556881246411,54.614782725182629]
[null,null,21.828799992633833,35.914400000000001,-1.8288000001875466,57.207556881246411,57.614158829942568]
[null,null,21.828799992018521,38.914400000000001,-1.7414825699386065,60.207556881246411,60.605305565329729]
[null,null,21.828799991403212,41.914400000000001,-1.5128825698552417,63.207556881246411,63.594840160171373]
[null,null,21.8287999907879,44.914400000000001,-1.230317430073933,66.207556881246404,66.588392919109907]
[null,null,21.828799990172591,47.914400000000001,-1.0017174301608938,69.207556881246404,69.586454953861292]
[null,null,21.828799989557282,50.914400000562644,-0.91440000018754652,72.20755688180904,72.586313763430553]
[null,null,21.828799989527944,51.057443675407022,-0.90314221873679035,72.350600556653433,72.729799757714602]
[null,null,21.828799989499327,51.196965140227228,-0.86964607850237874,72.490122021473638,72.872401113126244]
[null,null,21.828799989472138,51.329528913513286,-0.81473636562441365,72.62268579475969,73.013238644889398]
[null,null,21.828799989447045,51.451870835212112,-0.73976513946919253,72.745027716458509,73.151444042787261]
[null,null,21.828799989424667,51.560978441181135,-0.64657844044037149,72.854135322427538,73.286165224583641]
[null,null,21.828799989405553,51.654165140053308,-0.5374708343375616,72.947322021299712,73.416571589393186]
[null,null,21.828799989390177,51.729136366032876,-0.4151289125310989,73.022293247279279,73.541859138612111]
[null,null,21.828799989378915,51.784046078720522,-0.28256513916620224,73.077202959966925,73.661255432836967]
[null,null,21.828799989372044,51.817542218754618,-0.14304367429790746,73.110699100001028,73.77402435421034]
[null,null,21.828799989369735,51.828800000000001,5.6263976628652054E-10,73.121956881246405,73.879470644832338]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]
[null,null,312.3791818067441,110.04792036051589,-1.7000000003486757,357.86641910135569,358.57058215773861]