{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PROJECT INFO","CONDUIT SIZING"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":152,"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":"PROJECT INFO","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[5,0,6,2],[0,0,1,2],[2,2,4,2]]}
["PROJECT INFORMATION"]
[]
["PROJECT/PID:","l"]
["INTERSECTION NAME:"]
["REV. DATE:"]

{"sheet":"CONDUIT SIZING","index":1,"n_rows":259,"n_cols":35,"rows_kept":259,"cut":false,"hidden":false,"merged":[[55,16,55,20],[55,22,55,24],[34,5,48,5],[34,6,48,6],[34,1,48,1],[34,2,48,2],[34,3,48,3],[3,22,3,24],[0,0,0,6],[1,9,3,9],[1,8,3,8],[1,2,2,2],[1,0,3,0],[1,1,3,1],[1,3,2,3],[1,4,2,4],[1,10,3,10],[3,16,3,20],[1,7,3,7],[0,7,0,12],[0,13,3,13],[0,14,2,14],[34,0,48,0],[34,4,48,4],[4,13,18,13],[4,14,18,14],[19,13,33,13],[19,14,33,14],[34,13,48,13],[34,14,48,14],[4,12,18,12],[19,12,33,12],[34,12,48,12],[52,7,52,12],[52,13,55,13],[52,14,54,14],[53,0,55,0],[53,1,55,1],[53,2,54,2],[53,3,54,3],[53,4,54,4],[53,7,55,7],[53,8,55,8],[53,9,55,9],[53,10,55,10],[71,12,85,12],[71,13,85,13],[71,14,85,14],[71,0,85,0],[56,12,70,12],[56,13,70,13],[56,14,70,14],[56,0,70,0],[56,1,70,1],[56,2,70,2],[56,3,70,3],[56,4,70,4],[56,5,70,5],[56,6,70,6],[71,1,85,1],[71,2,85,2],[71,3,85,3],[71,4,85,4],[71,5,85,5],[71,6,85,6],[86,12,100,12],[86,13,100,13],[138,12,152,12],[138,13,152,13],[138,14,152,14],[123,4,137,4],[123,5,137,5],[123,6,137,6],[104,0,104,6],[104,7,104,12],[104,13,107,13],[104,14,106,14],[105,0,107,0],[105,1,107,1],[105,2,106,2],[105,3,106,3],[105,4,106,4],[105,7,107,7],[105,8,107,8],[105,9,107,9],[105,10,107,10],[86,14,100,14],[86,0,100,0],[86,1,100,1],[138,0,152,0],[138,1,152,1],[123,12,137,12],[123,13,137,13],[123,14,137,14],[108,12,122,12],[108,13,122,13],[108,14,122,14],[108,0,122,0],[108,1,122,1],[108,2,122,2],[108,3,122,3],[108,4,122,4],[138,2,152,2],[138,3,152,3],[138,4,152,4],[138,5,152,5],[138,6,152,6],[108,5,122,5],[108,6,122,6],[123,0,137,0],[123,1,137,1],[123,2,137,2],[123,3,137,3],[156,7,156,12],[156,13,159,13],[156,14,158,14],[157,0,159,0],[157,1,159,1],[157,2,158,2],[157,3,158,3],[157,4,158,4],[157,7,159,7],[157,8,159,8],[157,9,159,9],[157,10,159,10],[156,0,156,6],[190,12,204,12],[190,13,204,13],[190,14,204,14],[175,12,189,12],[175,13,189,13],[175,14,189,14],[175,0,189,0],[160,12,174,12],[160,13,174,13],[160,14,174,14],[175,1,189,1],[160,0,174,0],[160,1,174,1],[160,2,174,2],[160,3,174,3],[160,4,174,4],[160,5,174,5],[160,6,174,6],[175,2,189,2],[175,3,189,3],[175,4,189,4],[175,5,189,5],[175,6,189,6],[190,0,204,0],[208,7,208,12],[208,13,211,13],[208,14,210,14],[209,0,211,0],[209,1,211,1],[209,2,210,2],[209,3,210,3],[209,4,210,4],[209,7,211,7],[209,8,211,8],[209,9,211,9],[209,10,211,10],[208,0,208,6],[227,12,241,12],[227,13,241,13],[227,14,241,14],[212,12,226,12],[212,13,226,13],[212,14,226,14],[212,0,226,0],[212,1,226,1],[212,2,226,2],[212,3,226,3],[212,4,226,4],[212,5,226,5],[212,6,226,6],[227,0,241,0],[227,1,241,1],[227,2,241,2],[227,3,241,3],[227,4,241,4],[227,5,241,5],[227,6,241,6],[242,12,256,12],[242,13,256,13],[242,14,256,14],[242,0,256,0],[242,1,256,1],[242,2,256,2],[242,3,256,3],[242,4,256,4],[242,5,256,5],[242,6,256,6],[19,0,33,0],[19,1,33,1],[19,2,33,2],[19,3,33,3],[19,4,33,4],[19,5,33,5],[19,6,33,6],[4,0,18,0],[4,1,18,1],[4,2,18,2],[4,3,18,3],[190,1,204,1],[190,2,204,2],[190,3,204,3],[190,4,204,4],[190,5,204,5],[190,6,204,6],[4,4,18,4],[4,5,18,5],[4,6,18,6],[86,3,100,3],[86,4,100,4],[86,5,100,5],[86,6,100,6],[86,2,100,2],[52,0,52,6]]}
["CONDUIT",null,null,null,null,null,null,"CABLE AND WIRE",null,null,null,null,null,"IS [A] LESS THAN 0.25C?","FINAL CONDUIT  NOMINAL DIAMETER"]
["FROM","TO","RUN LENGTH","SIZE/NOMINAL DIAMETER","INSIDE DIAMETER","C","0.25C","CABLE USE","SPECIFICATION OR MATERIAL","NO. OF CONDUCTORS AWG","NO. CABLES OR WIRES*","a","[A]"]
[null,null,null,null,null,"INSIDE AREA","25% INSIDE AREA",null,null,null,null,"CROSS SECTION AREA","COMBINED CROSS SECTION AREA"]
[null,null,"FT.","IN.","IN.","SQ. IN.","SQ. IN.",null,null,null,null,"SQ. IN.","SQ. IN.",null,"IN.",null,"CONDUIT CROSS SECTION AREA",null,null,null,null,null,"CROSS SECTION AREA OF CABLE AND WIRE",null,null,null,"-","IMSA 19-1 OR 20-1","RHH/RHW/USE","ETHERNET CAT 5E ARMORED","SMARTSENSOR 6 CONDUCTOR","IMSA 50-2","RG-6/V (COAX)","RG-6/V WITH POWER (COAX)","RG-8/U (COAX)"]
["CONT.","PB-4",34,4,{"$f":"VLOOKUP(D5,$R$6:$T$16,2,FALSE)","v":4.0259999999999998},{"$f":"VLOOKUP(D5,$R$6:$T$16,3,FALSE)","v":12.72},{"$f":"VLOOKUP(D5,$R$6:$U$16,4,FALSE)","v":3.18},"SIGNALS","IMSA 19-1 OR 20-1","7/C # 14",3,{"$f":"IF(K5=\"-\",\"-\",(K5*INDEX($Y$6:$Y$40,MATCH(1,INDEX((I5=$W$6:$W$40)*(J5=$X$6:$X$40),0),0))))","v":0.66},{"$f":"IF(L5=\"-\",\"-\",SUMIF(L5:L19,\">0\"))","v":1.895},{"$f":"IF(M5=\"-\",\"-\",IF(M5<=G5, \"YES\", \"NO\"))","v":"YES"},{"$f":"IF(N5=\"-\",\"-\",IF(N5=\"YES\",D5,INDEX($R$19:$R$28,MATCH(M5,$S$19:$S$28,-1))))","v":4},null,"0.4 AREA","NOMINAL DIAMETER","INSIDE DIAMETER","INSIDE AREA ","0.25 AREA",null,"SPECIFICATION OR MATERIAL","NO. OF CONDUCTORS AWG","CROSS SECTION AREA, SQ. IN.",null,"-","-","-","-","-","-","-","-","-"]
[null,null,null,null,null,null,null,"SIGNALS","IMSA 19-1 OR 20-1","5/C # 14",3,{"$f":"IF(K6=\"-\",\"-\",(K6*INDEX($Y$6:$Y$40,MATCH(1,INDEX((I6=$W$6:$W$40)*(J6=$X$6:$X$40),0),0))))","v":0.57000000000000006},null,null,null,null,"-","-","-","-","-",null,"-","-","-",null,null,"2/C # 14","1/C # 14","8/C # 24","6/C # 20","2/C # 14","1/C # 18","1/C # 18 (COAX)","1/C # 11"]
[null,null,null,null,null,null,null,"SIGNALS","IMSA 19-1 OR 20-1","2/C # 14",3,0.30000000000000004,null,null,null,null,{"$f":"0.25*T7","v":7.4999999999999997E-2},0.5,0.622,0.3,{"$f":"0.25*T7","v":7.4999999999999997E-2},null,"IMSA 19-1 OR 20-1","2/C # 12",0.12,null,null,"3/C # 14","1/C # 12",null,null,null,null,"2/C # 16 (POWER)"]
[null,null,null,null,null,null,null,"WAVETRONIX RADAR","SMARTSENSOR 6 CONDUCTOR","6/C # 20",1,0.14000000000000001,null,null,null,null,{"$f":"0.25*T8","v":0.13250000000000001},0.75,0.82399999999999995,0.53,{"$f":"0.25*T8","v":0.13250000000000001},null,"IMSA 19-1 OR 20-1","2/C # 14",0.1,null,null,"4/C # 14","1/C # 10"]
[null,null,null,null,null,null,null,"LIGHTING","RHH/RHW/USE","1/C # 10",3,0.22499999999999998,null,null,null,null,0.215,1,1.0489999999999999,0.86,0.215,null,"IMSA 19-1 OR 20-1","3/C # 12",0.16,null,null,"5/C # 14","1/C # 8"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,0.375,1.25,1.38,1.5,0.375,null,"IMSA 19-1 OR 20-1","3/C # 14",0.13,null,null,"7/C # 14","1/C # 6"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,0.51,1.5,1.61,2.04,0.51,null,"IMSA 19-1 OR 20-1","4/C # 12",0.19,null,null,"9/C # 14","1/C # 4"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,0.84,2,2.0670000000000002,3.36,0.84,null,"IMSA 19-1 OR 20-1","4/C # 14",0.16,null,null,"12/C # 14","1/C # 2"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,1.1975,2.5,2.4689999999999999,4.79,1.1975,null,"IMSA 19-1 OR 20-1","5/C # 12",0.23,null,null,"15/C # 14"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,1.845,3,3.0680000000000001,7.38,1.845,null,"IMSA 19-1 OR 20-1","5/C # 14",0.19,null,null,"18/C # 14"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,2.4750000000000001,3.5,3.548,9.9,2.4750000000000001,null,"IMSA 19-1 OR 20-1","7/C # 12",0.3,null,null,"25/C # 14"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,3.18,4,4.0259999999999998,12.72,3.18,null,"IMSA 19-1 OR 20-1","7/C # 14",0.22,null,null,"2/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"IMSA 19-1 OR 20-1","9/C # 12",0.4,null,null,"3/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,"NOMINAL DIAMETER","0.25 AREA",null,null,null,"IMSA 19-1 OR 20-1","9/C # 14",0.33,null,null,"4/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,4,3.18,null,null,null,"IMSA 19-1 OR 20-1","12/C # 12",0.5,null,null,"5/C # 12"]
["PB-4","PS-5",9,2,{"$f":"VLOOKUP(D20,$R$6:$T$16,2,FALSE)","v":2.0670000000000002},{"$f":"VLOOKUP(D20,$R$6:$T$16,3,FALSE)","v":3.36},{"$f":"VLOOKUP(D20,$R$6:$U$16,4,FALSE)","v":0.84},"SIGNALS","IMSA 19-1 OR 20-1","7/C # 14",1,0.22,{"$f":"IF(L20=\"-\",\"-\",SUMIF(L20:L34,\">0\"))","v":0.51},{"$f":"IF(M20=\"-\",\"-\",IF(M20<=G20, \"YES\", \"NO\"))","v":"YES"},{"$f":"IF(N20=\"-\",\"-\",IF(N20=\"YES\",D20,INDEX($R$19:$R$28,MATCH(M20,$S$19:$S$28,-1))))","v":2},null,null,3.5,2.48,null,null,null,"IMSA 19-1 OR 20-1","12/C # 14",0.41,null,null,"7/C # 12"]
[null,null,null,null,null,null,null,"SIGNALS","IMSA 19-1 OR 20-1","5/C # 14",1,0.19,null,null,null,null,null,3,1.85,null,null,null,"IMSA 19-1 OR 20-1","15/C #12",0.57999999999999996,null,null,"9/C # 12"]
[null,null,null,null,null,null,null,"SIGNALS","IMSA 19-1 OR 20-1","2/C # 14",1,0.1,null,null,null,null,null,2.5,1.2,null,null,null,"IMSA 19-1 OR 20-1","15/C # 14",0.48,null,null,"12/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,2,0.84,null,null,null,"IMSA 19-1 OR 20-1","18/C # 12",0.74,null,null,"15/C #12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,1.5,0.51,null,null,null,"IMSA 19-1 OR 20-1","18/C # 14",0.55000000000000004,null,null,"18/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,1.25,0.38,null,null,null,"IMSA 19-1 OR 20-1","25/C # 12",1,null,null,"25/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,1,0.22,null,null,null,"IMSA 19-1 OR 20-1","25/C # 14",0.82]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,0.75,0.13,null,null,null,"RHH/RHW/USE","1/C # 2",0.22900000000000001]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,0.5,0.08,null,null,null,"RHH/RHW/USE","1/C # 4",0.17299999999999999,null,"-","SIGNALS","LIGHTING","COMMUNICATIONS","WAVETRONIX RADAR","LOOP LEAD-IN","VIDEO","RADIO ANTENNA"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 6",0.13800000000000001,null,"-","-","-","-","-","-","-","-"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 8",0.107,null,null,"IMSA 19-1 OR 20-1","RHH/RHW/USE","ETHERNET CAT 5E ARMORED","SMARTSENSOR 6 CONDUCTOR","IMSA 50-2","RG-6/V (COAX)","RG-8/U (COAX)"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 10",7.4999999999999997E-2,null,null,null,null,null,null,null,"RG-6/V WITH POWER (COAX)"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 12",6.0999999999999999E-2]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 14",5.2999999999999999E-2]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"ETHERNET CAT 5E ARMORED","8/C # 24",0.13]
["PB-4","PB-5",127,4,{"$f":"VLOOKUP(D35,$R$6:$T$16,2,FALSE)","v":4.0259999999999998},{"$f":"VLOOKUP(D35,$R$6:$T$16,3,FALSE)","v":12.72},{"$f":"VLOOKUP(D35,$R$6:$U$16,4,FALSE)","v":3.18},"SIGNALS","IMSA 19-1 OR 20-1","7/C # 14",2,0.44,{"$f":"IF(L35=\"-\",\"-\",SUMIF(L35:L49,\">0\"))","v":1.3850000000000002},{"$f":"IF(M35=\"-\",\"-\",IF(M35<=G35, \"YES\", \"NO\"))","v":"YES"},{"$f":"IF(N35=\"-\",\"-\",IF(N35=\"YES\",D35,INDEX($R$19:$R$28,MATCH(M35,$S$19:$S$28,-1))))","v":4},null,null,null,null,null,null,null,"SMARTSENSOR 6 CONDUCTOR","6/C # 20",0.14000000000000001]
[null,null,null,null,null,null,null,"SIGNALS","IMSA 19-1 OR 20-1","5/C # 14",2,0.38,null,null,null,null,null,null,null,null,null,null,"IMSA 50-2","2/C # 14",0.1]
[null,null,null,null,null,null,null,"SIGNALS","IMSA 19-1 OR 20-1","2/C # 14",2,0.2,null,null,null,null,null,null,null,null,null,null,"RG-6/V (COAX)","1/C # 18",0.06]
[null,null,null,null,null,null,null,"WAVETRONIX RADAR","SMARTSENSOR 6 CONDUCTOR","6/C # 20",1,0.14000000000000001,null,null,null,null,null,null,null,null,null,null,"RG-6/V WITH POWER (COAX)","1/C # 18 (COAX)",0.16]
[null,null,null,null,null,null,null,"LIGHTING","RHH/RHW/USE","1/C # 10",3,0.22499999999999998,null,null,null,null,null,null,null,null,null,null,"RG-6/V WITH POWER (COAX)","2/C # 16 (POWER)",0.16]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RG-8/U (COAX)","1/C # 11",0.13]
[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,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,"-","-","-","-","-"]
[]
["* NOTE: INCLUDE GROUNDING CONDUCTOR IN WIRE COUNT FOR LIGHTING CIRCUITS OF NOTATION \"WITH GROUND.\""]
[]
["CONDUIT",null,null,null,null,null,null,"CABLE AND WIRE",null,null,null,null,null,"IS [A] LESS THAN 0.25C?","FINAL CONDUIT  NOMINAL DIAMETER"]
["FROM","TO","RUN LENGTH","SIZE/NOMINAL DIAMETER","INSIDE DIAMETER","C","0.25C","CABLE USE","SPECIFICATION OR MATERIAL","NO. OF CONDUCTORS AWG","NO. CABLES OR WIRES*","a","[A]"]
[null,null,null,null,null,"INSIDE AREA","25% INSIDE AREA",null,null,null,null,"CROSS SECTION AREA","COMBINED CROSS SECTION AREA"]
[null,null,"FT.","IN.","IN.","SQ. IN.","SQ. IN.",null,null,null,null,"SQ. IN.","SQ. IN.",null,"IN."]
["PB-5","SP-4",20,3,{"$f":"VLOOKUP(D57,$R$6:$T$16,2,FALSE)","v":3.0680000000000001},{"$f":"VLOOKUP(D57,$R$6:$T$16,3,FALSE)","v":7.38},{"$f":"VLOOKUP(D57,$R$6:$U$16,4,FALSE)","v":1.845},"SIGNALS","IMSA 19-1 OR 20-1","7/C # 14",2,{"$f":"IF(K57=\"-\",\"-\",(K57*INDEX($Y$6:$Y$40,MATCH(1,INDEX((I57=$W$6:$W$40)*(J57=$X$6:$X$40),0),0))))","v":0.44},{"$f":"IF(L57=\"-\",\"-\",SUMIF(L57:L71,\">0\"))","v":1.095},{"$f":"IF(M57=\"-\",\"-\",IF(M57<=G57, \"YES\", \"NO\"))","v":"YES"},{"$f":"IF(N57=\"-\",\"-\",IF(N57=\"YES\",D57,INDEX($R$19:$R$28,MATCH(M57,$S$19:$S$28,-1))))","v":3}]
[null,null,null,null,null,null,null,"SIGNALS","IMSA 19-1 OR 20-1","5/C # 14",1,{"$f":"IF(K58=\"-\",\"-\",(K58*INDEX($Y$6:$Y$40,MATCH(1,INDEX((I58=$W$6:$W$40)*(J58=$X$6:$X$40),0),0))))","v":0.19}]
[null,null,null,null,null,null,null,"SIGNALS","IMSA 19-1 OR 20-1","2/C # 14",1,0.1]
[null,null,null,null,null,null,null,"WAVETRONIX RADAR","SMARTSENSOR 6 CONDUCTOR","6/C # 20",1,0.14000000000000001]
[null,null,null,null,null,null,null,"LIGHTING","RHH/RHW/USE","1/C # 10",3,0.22499999999999998]
[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,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,null,null,null,null,"-","-","-","-","-"]
["PB-5","PS-5",29,2,{"$f":"VLOOKUP(D72,$R$6:$T$16,2,FALSE)","v":2.0670000000000002},{"$f":"VLOOKUP(D72,$R$6:$T$16,3,FALSE)","v":3.36},{"$f":"VLOOKUP(D72,$R$6:$U$16,4,FALSE)","v":0.84},"SIGNALS","IMSA 19-1 OR 20-1","5/C # 14",1,0.19,{"$f":"IF(L72=\"-\",\"-\",SUMIF(L72:L86,\">0\"))","v":0.29000000000000004},{"$f":"IF(M72=\"-\",\"-\",IF(M72<=G72, \"YES\", \"NO\"))","v":"YES"},{"$f":"IF(N72=\"-\",\"-\",IF(N72=\"YES\",D72,INDEX($R$19:$R$28,MATCH(M72,$S$19:$S$28,-1))))","v":2}]
[null,null,null,null,null,null,null,"SIGNALS","IMSA 19-1 OR 20-1","2/C # 14",1,0.1]
[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,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,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":"VLOOKUP(D87,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D87,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D87,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-","-",{"$f":"IF(L87=\"-\",\"-\",SUMIF(L87:L101,\">0\"))","v":"-"},{"$f":"IF(M87=\"-\",\"-\",IF(M87<=G87, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N87=\"-\",\"-\",IF(N87=\"YES\",D87,INDEX($R$19:$R$28,MATCH(M87,$S$19:$S$28,-1))))","v":"-"}]
[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,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,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,"-","-","-","-","-"]
[]
["* NOTE: INCLUDE GROUNDING CONDUCTOR IN WIRE COUNT FOR LIGHTING CIRCUITS OF NOTATION \"WITH GROUND.\""]
[]
["CONDUIT",null,null,null,null,null,null,"CABLE AND WIRE",null,null,null,null,null,"IS [A] LESS THAN 0.25C?","FINAL CONDUIT  NOMINAL DIAMETER"]
["FROM","TO","RUN LENGTH","SIZE/NOMINAL DIAMETER","INSIDE DIAMETER","C","0.25C","CABLE USE","SPECIFICATION OR MATERIAL","NO. OF CONDUCTORS AWG","NO. CABLES OR WIRES*","a","[A]"]
[null,null,null,null,null,"INSIDE AREA","25% INSIDE AREA",null,null,null,null,"CROSS SECTION AREA","COMBINED CROSS SECTION AREA"]
[null,null,"FT.","IN.","IN.","SQ. IN.","SQ. IN.",null,null,null,null,"SQ. IN.","SQ. IN.",null,"IN."]
["-","-","-","-",{"$f":"VLOOKUP(D109,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D109,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D109,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-",{"$f":"IF(K109=\"-\",\"-\",(K109*INDEX($Y$6:$Y$40,MATCH(1,INDEX((I109=$W$6:$W$40)*(J109=$X$6:$X$40),0),0))))","v":"-"},{"$f":"IF(L109=\"-\",\"-\",SUMIF(L109:L123,\">0\"))","v":"-"},{"$f":"IF(M109=\"-\",\"-\",IF(M109<=G109, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N109=\"-\",\"-\",IF(N109=\"YES\",D109,INDEX($R$19:$R$28,MATCH(M109,$S$19:$S$28,-1))))","v":"-"}]
[null,null,null,null,null,null,null,"-","-","-","-",{"$f":"IF(K110=\"-\",\"-\",(K110*INDEX($Y$6:$Y$40,MATCH(1,INDEX((I110=$W$6:$W$40)*(J110=$X$6:$X$40),0),0))))","v":"-"}]
[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,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,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":"VLOOKUP(D124,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D124,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D124,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-","-",{"$f":"IF(L124=\"-\",\"-\",SUMIF(L124:L138,\">0\"))","v":"-"},{"$f":"IF(M124=\"-\",\"-\",IF(M124<=G124, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N124=\"-\",\"-\",IF(N124=\"YES\",D124,INDEX($R$19:$R$28,MATCH(M124,$S$19:$S$28,-1))))","v":"-"}]
[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,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,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,"-","-","-","-","-"]
["-","-","-","-",{"$f":"VLOOKUP(D139,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D139,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D139,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-","-",{"$f":"IF(L139=\"-\",\"-\",SUMIF(L139:L153,\">0\"))","v":"-"},{"$f":"IF(M139=\"-\",\"-\",IF(M139<=G139, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N139=\"-\",\"-\",IF(N139=\"YES\",D139,INDEX($R$19:$R$28,MATCH(M139,$S$19:$S$28,-1))))","v":"-"}]
[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,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,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,"-","-","-","-","-"]
[]
["* NOTE: INCLUDE GROUNDING CONDUCTOR IN WIRE COUNT FOR LIGHTING CIRCUITS OF NOTATION \"WITH GROUND.\""]
[]
["CONDUIT",null,null,null,null,null,null,"CABLE AND WIRE",null,null,null,null,null,"IS [A] LESS THAN 0.25C?","FINAL CONDUIT  NOMINAL DIAMETER"]
["FROM","TO","RUN LENGTH","SIZE/NOMINAL DIAMETER","INSIDE DIAMETER","C","0.25C","CABLE USE","SPECIFICATION OR MATERIAL","NO. OF CONDUCTORS AWG","NO. CABLES OR WIRES*","a","[A]"]
[null,null,null,null,null,"INSIDE AREA","25% INSIDE AREA",null,null,null,null,"CROSS SECTION AREA","COMBINED CROSS SECTION AREA"]
[null,null,"FT.","IN.","IN.","SQ. IN.","SQ. IN.",null,null,null,null,"SQ. IN.","SQ. IN.",null,"IN."]
["-","-","-","-",{"$f":"VLOOKUP(D161,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D161,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D161,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-",{"$f":"IF(K161=\"-\",\"-\",(K161*INDEX($Y$6:$Y$40,MATCH(1,INDEX((I161=$W$6:$W$40)*(J161=$X$6:$X$40),0),0))))","v":"-"},{"$f":"IF(L161=\"-\",\"-\",SUMIF(L161:L175,\">0\"))","v":"-"},{"$f":"IF(M161=\"-\",\"-\",IF(M161<=G161, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N161=\"-\",\"-\",IF(N161=\"YES\",D161,INDEX($R$19:$R$28,MATCH(M161,$S$19:$S$28,-1))))","v":"-"}]
[null,null,null,null,null,null,null,"-","-","-","-",{"$f":"IF(K162=\"-\",\"-\",(K162*INDEX($Y$6:$Y$40,MATCH(1,INDEX((I162=$W$6:$W$40)*(J162=$X$6:$X$40),0),0))))","v":"-"}]
[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,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,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":"VLOOKUP(D176,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D176,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D176,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-","-",{"$f":"IF(L176=\"-\",\"-\",SUMIF(L176:L190,\">0\"))","v":"-"},{"$f":"IF(M176=\"-\",\"-\",IF(M176<=G176, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N176=\"-\",\"-\",IF(N176=\"YES\",D176,INDEX($R$19:$R$28,MATCH(M176,$S$19:$S$28,-1))))","v":"-"}]
[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,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,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,"-","-","-","-","-"]
["-","-","-","-",{"$f":"VLOOKUP(D191,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D191,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D191,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-","-",{"$f":"IF(L191=\"-\",\"-\",SUMIF(L191:L205,\">0\"))","v":"-"},{"$f":"IF(M191=\"-\",\"-\",IF(M191<=G191, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N191=\"-\",\"-\",IF(N191=\"YES\",D191,INDEX($R$19:$R$28,MATCH(M191,$S$19:$S$28,-1))))","v":"-"}]
[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,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,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,"-","-","-","-","-"]
[]
["* NOTE: INCLUDE GROUNDING CONDUCTOR IN WIRE COUNT FOR LIGHTING CIRCUITS OF NOTATION \"WITH GROUND.\""]
[]
["CONDUIT",null,null,null,null,null,null,"CABLE AND WIRE",null,null,null,null,null,"IS [A] LESS THAN 0.25C?","FINAL CONDUIT  NOMINAL DIAMETER"]
["FROM","TO","RUN LENGTH","SIZE/NOMINAL DIAMETER","INSIDE DIAMETER","C","0.25C","CABLE USE","SPECIFICATION OR MATERIAL","NO. OF CONDUCTORS AWG","NO. CABLES OR WIRES*","a","[A]"]
[null,null,null,null,null,"INSIDE AREA","25% INSIDE AREA",null,null,null,null,"CROSS SECTION AREA","COMBINED CROSS SECTION AREA"]
[null,null,"FT.","IN.","IN.","SQ. IN.","SQ. IN.",null,null,null,null,"SQ. IN.","SQ. IN.",null,"IN."]
["-","-","-","-",{"$f":"VLOOKUP(D213,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D213,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D213,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-",{"$f":"IF(K213=\"-\",\"-\",(K213*INDEX($Y$6:$Y$40,MATCH(1,INDEX((I213=$W$6:$W$40)*(J213=$X$6:$X$40),0),0))))","v":"-"},{"$f":"IF(L213=\"-\",\"-\",SUMIF(L213:L227,\">0\"))","v":"-"},{"$f":"IF(M213=\"-\",\"-\",IF(M213<=G213, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N213=\"-\",\"-\",IF(N213=\"YES\",D213,INDEX($R$19:$R$28,MATCH(M213,$S$19:$S$28,-1))))","v":"-"}]
[null,null,null,null,null,null,null,"-","-","-","-",{"$f":"IF(K214=\"-\",\"-\",(K214*INDEX($Y$6:$Y$40,MATCH(1,INDEX((I214=$W$6:$W$40)*(J214=$X$6:$X$40),0),0))))","v":"-"}]
[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,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,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":"VLOOKUP(D228,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D228,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D228,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-","-",{"$f":"IF(L228=\"-\",\"-\",SUMIF(L228:L242,\">0\"))","v":"-"},{"$f":"IF(M228=\"-\",\"-\",IF(M228<=G228, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N228=\"-\",\"-\",IF(N228=\"YES\",D228,INDEX($R$19:$R$28,MATCH(M228,$S$19:$S$28,-1))))","v":"-"}]
[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,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,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,"-","-","-","-","-"]
["-","-","-","-",{"$f":"VLOOKUP(D243,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D243,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D243,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-","-",{"$f":"IF(L243=\"-\",\"-\",SUMIF(L243:L257,\">0\"))","v":"-"},{"$f":"IF(M243=\"-\",\"-\",IF(M243<=G243, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N243=\"-\",\"-\",IF(N243=\"YES\",D243,INDEX($R$19:$R$28,MATCH(M243,$S$19:$S$28,-1))))","v":"-"}]
[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,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,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,"-","-","-","-","-"]
[]
["* NOTE: INCLUDE GROUNDING CONDUCTOR IN WIRE COUNT FOR LIGHTING CIRCUITS OF NOTATION \"WITH GROUND.\""]