{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Calculations","Tables"],"not_rendered":{"macros":1,"external_links":1,"defined_names":22},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Calculations","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[23,1,23,10],[25,1,25,10],[26,1,26,10],[27,1,27,10],[28,1,28,10],[29,1,29,10],[30,1,30,10],[31,1,31,10]],"flags":["formulas_cached_only"]}
[]
[null,"        Minimum Conduit Size Calculator"]
[null,"# of Conductors","Size of Conductors","Type of Insulation","Calculated Area"]
[{"$nulls":3},"THW","",null,"RHW","= RHW & RHW"]
[{"$nulls":3},"THW","",null,"THHN","= THHN & THWN"]
[{"$nulls":3},"THW","",null,"THW","= THW, TW, & THWN"]
[{"$nulls":3},"THW","",null,"XHHW","= XHHW & XHH"]
[{"$nulls":3},"THW","",null,"LV","= Low Voltage Cables"]
[{"$nulls":3},"THW","",null,"Fiber","= Fiber Optic Cables"]
[null,"# of Cables","Size of Cable","Type of Cable"]
[{"$nulls":3},"LV","",null,"EMT","= Electrical Metallic Tubing (Thinwall)"]
[{"$nulls":3},"LV","",null,"ENT","= Electrical Non-Metallic Tubing (Smurf Tube)"]
[{"$nulls":3},"LV","",null,"FMC","= Flexible Metal Conduit"]
[{"$nulls":3},"Fiber","",null,"IMC","= Intermediate Metal Conduit"]
[{"$nulls":3},"Fiber","",null,"LFNC_A","= Liquidtight Flexible Non-Metallic Conduit Type A"]
[{"$nulls":3},"Fiber","",null,"LFNC_B","= Liquidtight Flexible Non-Metallic Conduit Type B"]
[{"$nulls":4},"========",null,"LFMC","= Liquidtight Flexible Metal Conduit (Sealtite)"]
[{"$nulls":3},"Total Area",{"v":0,"d":"0.000"},null,"RMC","= Rigid Metal Conduit (GRC)"]
[{"$nulls":3},"Conduit Type","EMT",null,"PVC-40","= Schedule 40 PVC (Plastic)"]
[{"$nulls":3},"Minimum Conduit Size","",null,"PVC-80","= Schedule 80 PVC (Plastic)"]
[]
[]
[]
[null,"Directions: Items in red color must be provided. Items in blue color are calculated. The top half of the calculator is for line voltage conductors while the bottom half is for low voltage and fiber optic cables. If you are doing line voltage, enter the total number of conductors of this size and insulation starting in cell B4. In cell C4, choose the conductor size from the drop down list. AWG sizes are shown as the number such as \"12\", \"4\", or \"3/0\". Kcmil or MCM are shown as the number such as \"250\", \"500\", or \"750\". Wire sizes must be between #14 AWG and 1000 Kcmil."]
[]
[null,"If you are doing low voltage or fiber optics, enter the total number of cables of this type starting in cell B11. In cell C11, choose the cable type from the drop down list. Only a certain number of cable types are listed. Low voltage cables are in the format of (AWG)/(# of conductors). Their sizes are based on some typical industry sizes for stranded multi-conductor cables with shielding and a PVC jacket. Fiber optic cables are in shown as the number of fiber strands followed by an \"f\". Their sizes are based on Beldon riser or plenum series - whichever was larger for that number of fibers. You may wish to replace the values in the tables with areas of cabling you work with the most. Keep in mind that NEC 800.110 Exception states that conduit fill rules don't apply to communications wiring. Use this calculator as a general guide only."]
[]
[null,"Once you have entered the quantity and size of the conductors, choose the insulation type in the \"D\" column to the right of the wire size. The insulation types must be picked from the drop down list provided. Note that these four insulation types cover nine different types as noted to the right of the calculation box."]
[]
[null,"Finally, choose the conduit type from the drop down list. An explanation of the acronyms is listed to the right of the calculation box. If \"N/A\" appears in the Minimum Conduit Size in calculated cell E15, that means that that type of conduit is not manufactured large enough to legally contain the set of conductors that you have designated."]
[]
[null,"This spreadsheet has been prepared and distributed by Design & Construction Engineers without cost or obligation. Design & Constructions Engineers makes no guarantee to the accuracy of the information contained or the results generated. The figures in the tables were taken from the tables found in the 2002 NEC. If you find errors or wish to report problems with this spreadsheet, please contact me via email at tstahlnecker@dcengineers.com so that I can make corrections and post them to our web site."]

{"sheet":"Tables","index":1,"n_rows":60,"n_cols":35,"rows_kept":60,"flags":["formulas_cached_only"]}
["Wire Table",null,null,"Cable Size Table",null,null,"THW Wire Size",null,null,"THHN Wire Size",null,null,"RHW Wire Size",null,null,"XHHW Wire Size",null,null,"Low Voltage Wire Size",null,null,"Fiber Wire Size"]
[]
["RHW",null,null,"22/2",null,null,"14",0.0139,null,"14",0.0097,null,"14",0.0293,null,"14",0.0139,null,"22/2",{"v":0.014741138128806711,"d":"0.0147"},null,"2f",{"v":0.026590440219984007,"d":"0.0266"}]
["THHN",null,null,"22/3",null,null,"12",0.0181,null,"12",0.0133,null,"12",0.0353,null,"12",0.0181,null,"22/3",{"v":0.017203361371057706,"d":"0.0172"},null,"4f",{"v":0.031415926535897934,"d":"0.0314"}]
["THW",null,null,"22/4",null,null,"10",0.0243,null,"10",0.0211,null,"10",0.0437,null,"10",0.0243,null,"22/4",{"v":0.020106192982974676,"d":"0.0201"},null,"6f",{"v":0.0380132711084365,"d":"0.0380"}]
["XHHW",null,null,"22/6",null,null,"8",0.0437,null,"8",0.0366,null,"8",0.0835,null,"8",0.0437,null,"22/6",{"v":0.028352873698647883,"d":"0.0284"},null,"8f",{"v":0.04337361357362408,"d":"0.0434"}]
[{"$nulls":3},"22/8",null,null,"6",0.0726,null,"6",0.0507,null,"6",0.1041,null,"6",{"v":0.059,"d":"0.0590"},null,"22/8",{"v":0.03463605900582747,"d":"0.0346"},null,"12f",{"v":0.051070515574919075,"d":"0.0511"}]
["Cable Table",null,null,"20/2",null,null,"4",0.0973,null,"4",0.0824,null,"4",0.1333,null,"4",0.0814,null,"20/2",{"v":0.018385385606970867,"d":"0.0184"},null,"24f",{"v":0.19322051456638661,"d":"0.1932"}]
["LV",null,null,"20/3",null,null,"3",0.1134,null,"3",0.0973,null,"3",0.1521,null,"3",0.0962,null,"20/3",{"v":0.021382464998495533,"d":"0.0214"},null,"36f",{"v":0.32573289269480415,"d":"0.3257"}]
["Fiber",null,null,"20/4",null,null,"2",0.1333,null,"2",0.1158,null,"2",{"v":0.175,"d":"0.1750"},null,"2",0.1146,null,"20/4",{"v":0.025446900494077322,"d":"0.0254"},null,"48f",{"v":0.30876279457827543,"d":"0.3088"}]
[{"$nulls":3},"20/6",null,null,"1",0.1901,null,"1",0.1562,null,"1",{"v":0.266,"d":"0.2660"},null,"1",0.1534,null,"20/6",{"v":0.03529893505573491,"d":"0.0353"},null,"72f",{"v":0.48274969352122205,"d":"0.4827"}]
[{"$nulls":3},"18/2",null,null,"1/0",0.2223,null,"1/0",0.1855,null,"1/0",0.3039,null,"1/0",0.1825,null,"18/2",{"v":0.022167077763729583,"d":"0.0222"},null,"96f",{"v":0.7253316972589747,"d":"0.7253"}]
[{"$nulls":3},"18/3",null,null,"2/0",0.2624,null,"2/0",0.2223,null,"2/0",0.3505,null,"2/0",{"v":0.219,"d":"0.2190"},null,"18/3",{"v":0.026880252142277666,"d":"0.0269"},null,"144f",{"v":0.8445928375745504,"d":"0.8446"}]
[{"$nulls":3},"18/4",null,null,"3/0",0.3117,null,"3/0",0.2679,null,"3/0",0.4072,null,"3/0",0.2642,null,"18/4",{"v":0.031730871199420314,"d":"0.0317"}]
[{"$nulls":3},"18/6",null,null,"4/0",0.3718,null,"4/0",0.3237,null,"4/0",0.4754,null,"4/0",0.3197,null,"18/6",{"v":0.04908738521234052,"d":"0.0491"}]
[{"$nulls":3},"18/8",null,null,"250",0.4596,null,"250",{"v":0.397,"d":"0.3970"},null,"250",0.6291,null,"250",0.3904,null,"18/8",{"v":0.0660519855417254,"d":"0.0661"}]
[{"$nulls":3},"16/2",null,null,"300",0.5281,null,"300",0.4608,null,"300",0.7088,null,"300",0.4536,null,"16/2",{"v":0.028652110398902312,"d":"0.0287"}]
[{"$nulls":3},"16/4",null,null,"350",0.5958,null,"350",0.5242,null,"350",{"v":0.787,"d":"0.7870"},null,"350",0.5166,null,"16/4",{"v":0.04486272849142564,"d":"0.0449"}]
[{"$nulls":3},"14/2",null,null,"400",0.6619,null,"400",0.5863,null,"400",0.8626,null,"400",0.5782,null,"14/2",{"v":0.047916356550714925,"d":"0.0479"}]
[{"$nulls":3},"14/4",null,null,"500",0.7901,null,"500",0.7073,null,"500",1.0082,null,"500",0.6984,null,"14/4",{"v":0.06927918659512551,"d":"0.0693"}]
[{"$nulls":3},"12/2",null,null,"600",0.9729,null,"600",0.8676,null,"600",1.2135,null,"600",0.8709,null,"12/2",{"v":0.0660519855417254,"d":"0.0661"}]
[{"$nulls":3},"12/4",null,null,"700",{"v":1.101,"d":"1.1010"},null,"700",0.9887,null,"700",1.3561,null,"700",0.9923,null,"12/4",{"v":0.08814130888727865,"d":"0.0881"}]
[{"$nulls":3},"CAT3",null,null,"750",1.1652,null,"750",1.0496,null,"750",1.4272,null,"750",1.0532,null,"CAT3",{"v":0.03463605900582747,"d":"0.0346"}]
[{"$nulls":3},"CAT5",null,null,"800",1.2272,null,"800",1.1085,null,"800",1.4957,null,"800",1.1122,null,"CAT5",{"v":0.03463605900582747,"d":"0.0346"}]
[{"$nulls":3},"2f",null,null,"900",1.3561,null,"900",1.2311,null,"900",1.6377,null,"900",1.2351]
[{"$nulls":3},"4f",null,null,"1000",1.4784,null,"1000",1.3478,null,"1000",1.7719,null,"1000",1.3519]
[{"$nulls":3},"6f"]
[{"$nulls":3},"8f"]
[{"$nulls":3},"12f"]
["Conduit Table",null,null,"24f",null,null,"EMT Conduit",null,null,"RMC Conduit",null,null,"PVC-80 Conduit",null,null,"ENT Conduit",null,null,"FMC Conduit",null,null,"IMC Conduit",null,null,"LFNC-A Conduit",null,null,"LFNC-B Conduit",null,null,"LFMC Conduit",null,null,"PVC-40 Conduit"]
[{"$nulls":3},"36f"]
["EMT",null,null,"48f",null,null,0,"1/2\"",null,0,"1/2\"",null,0,"1/2\"",null,0,"1/2\"",null,0,"3/8\"",null,0,"1/2\"",null,0,"3/8\"",null,0,"3/8\"",null,0,"3/8\"",null,0,"1/2\""]
["ENT",null,null,"72f",null,null,0.304,"1/2\"",null,0.314,"1/2\"",null,0.217,"1/2\"",null,0.246,"1/2\"",null,0.116,"3/8\"",null,0.342,"1/2\"",null,0.192,"3/8\"",null,0.192,"3/8\"",null,0.192,"3/8\"",null,0.285,"1/2\""]
["FMC",null,null,"96f",null,null,0.305,"3/4\"",null,0.315,"3/4\"",null,0.218,"3/4\"",null,0.247,"3/4\"",null,0.117,"1/2\"",null,0.343,"3/4\"",null,0.193,"1/2\"",null,0.193,"1/2\"",null,0.193,"1/2\"",null,0.286,"3/4\""]
["IMC",null,null,"144f",null,null,0.533,"3/4\"",null,0.549,"3/4\"",null,0.409,"3/4\"",null,0.454,"3/4\"",null,0.317,"1/2\"",null,0.586,"3/4\"",null,0.312,"1/2\"",null,0.314,"1/2\"",null,0.314,"1/2\"",null,0.508,"3/4\""]
["LFNC_A",{"$nulls":5},0.534,"1\"",null,{"v":0.55,"d":"0.550"},"1\"",null,{"v":0.41,"d":"0.410"},"1\"",null,0.455,"1\"",null,0.318,"3/4\"",null,0.587,"1\"",null,0.313,"3/4\"",null,0.315,"3/4\"",null,0.315,"3/4\"",null,0.509,"1\""]
["LFNC_B",{"$nulls":5},0.864,"1\"",null,0.887,"1\"",null,0.688,"1\"",null,0.785,"1\"",null,0.533,"3/4\"",null,0.959,"1\"",null,0.535,"3/4\"",null,0.541,"3/4\"",null,0.541,"3/4\"",null,0.832,"1\""]
["LFMC",{"$nulls":5},0.865,"1-1/4\"",null,0.888,"1-1/4\"",null,0.689,"1-1/4\"",null,0.786,"1-1/4\"",null,0.534,"1\"",null,{"v":0.96,"d":"0.960"},"1-1/4\"",null,0.536,"1\"",null,0.542,"1\"",null,0.542,"1\"",null,0.833,"1-1/4\""]
["RMC",{"$nulls":5},1.496,"1-1/4\"",null,1.526,"1-1/4\"",null,1.237,"1-1/4\"",null,{"v":1.41,"d":"1.410"},"1-1/4\"",null,0.817,"1\"",null,1.647,"1-1/4\"",null,0.854,"1\"",null,0.873,"1\"",null,0.873,"1\"",null,1.453,"1-1/4\""]
["PVC40",{"$nulls":5},{"v":1.4969999999999999,"d":"1.497"},"1-1/2\"",null,1.527,"1-1/2\"",null,1.238,"1-1/2\"",null,{"v":1.4109999999999998,"d":"1.411"},"1-1/2\"",null,0.818,"1-1/4\"",null,1.648,"1-1/2\"",null,0.855,"1-1/4\"",null,0.874,"1-1/4\"",null,0.874,"1-1/4\"",null,1.454,"1-1/2\""]
["PVC80",{"$nulls":5},2.036,"1-1/2\"",null,2.071,"1-1/2\"",null,1.711,"1-1/2\"",null,1.936,"1-1/2\"",null,1.277,"1-1/4\"",null,2.225,"1-1/2\"",null,1.502,"1-1/4\"",null,1.528,"1-1/4\"",null,1.528,"1-1/4\"",null,1.986,"1-1/2\""]
[{"$nulls":6},2.037,"2\"",null,2.072,"2\"",null,1.712,"2\"",null,{"v":1.9369999999999998,"d":"1.937"},"2\"",null,{"v":1.2779999999999998,"d":"1.278"},"1-1/2\"",null,2.226,"2\"",null,1.503,"1-1/2\"",null,1.529,"1-1/2\"",null,1.529,"1-1/2\"",null,{"v":1.9869999999999999,"d":"1.987"},"2\""]
[{"$nulls":6},3.356,"2\"",null,3.408,"2\"",null,2.874,"2\"",null,3.205,"2\"",null,1.858,"1-1/2\"",null,{"v":3.63,"d":"3.630"},"2\"",null,2.018,"1-1/2\"",null,1.981,"1-1/2\"",null,1.981,"1-1/2\"",null,3.291,"2\""]
[{"$nulls":6},{"v":3.3569999999999998,"d":"3.357"},"2-1/2\"",null,3.409,"2-1/2\"",null,2.875,"2-1/2\"",null,3.206,"N/A",null,1.859,"2\"",null,3.631,"2-1/2\"",null,{"v":2.0189999999999997,"d":"2.019"},"2\"",null,1.982,"2\"",null,1.982,"2\"",null,3.292,"2-1/2\""]
[{"$nulls":6},5.858,"2-1/2\"",null,4.866,"2-1/2\"",null,4.119,"2-1/2\"",{"$nulls":4},3.269,"2\"",null,5.135,"2-1/2\"",null,3.343,"2\"",null,3.246,"2\"",null,3.246,"2\"",null,4.695,"2-1/2\""]
[{"$nulls":6},5.859,"3\"",null,4.867,"3\"",null,{"v":4.12,"d":"4.120"},"3\"",{"$nulls":4},{"v":3.27,"d":"3.270"},"2-1/2\"",null,5.136,"3\"",null,3.344,"N/A",null,3.247,"N/A",null,3.247,"2-1/2\"",null,{"v":4.696000000000001,"d":"4.696"},"3\""]
[{"$nulls":6},8.846,"3\"",null,7.499,"3\"",null,6.442,"3\"",{"$nulls":4},4.909,"2-1/2\"",null,7.922,"3\"",{"$nulls":7},4.881,"2-1/2\"",null,7.268,"3\""]
[{"$nulls":6},8.847,"3-1/2\"",null,{"v":7.5,"d":"7.500"},"3-1/2\"",null,{"v":6.4430000000000005,"d":"6.443"},"3-1/2\"",{"$nulls":4},{"v":4.91,"d":"4.910"},"3\"",null,7.923,"3-1/2\"",{"$nulls":7},{"v":4.882000000000001,"d":"4.882"},"3\"",null,7.269,"3-1/2\""]
[{"$nulls":6},11.545,"3-1/2\"",null,{"v":10.01,"d":"10.010"},"3-1/2\"",null,8.688,"3-1/2\"",{"$nulls":4},7.069,"3\"",null,10.584,"3-1/2\"",{"$nulls":7},7.475,"3\"",null,9.737,"3-1/2\""]
[{"$nulls":6},11.546,"4\"",null,10.011,"4\"",null,8.689,"4\"",{"$nulls":4},{"v":7.07,"d":"7.070"},"3-1/2\"",null,{"v":10.584999999999999,"d":"10.585"},"4\"",{"$nulls":7},7.476,"3-1/2\"",null,9.738,"4\""]
[{"$nulls":6},14.753,"4\"",null,12.882,"4\"",null,11.258,"4\"",{"$nulls":4},9.621,"3-1/2\"",null,13.631,"4\"",{"$nulls":7},9.731,"3-1/2\"",null,12.554,"4\""]
[{"$nulls":6},14.754,"N/A",null,12.883,"5\"",null,{"v":11.258999999999999,"d":"11.259"},"5\"",{"$nulls":4},9.622,"4\"",null,13.632,"N/A",{"$nulls":7},9.732,"4\"",null,12.555,"5\""]
[{"$nulls":9},20.212,"5\"",null,17.855,"5\"",{"$nulls":4},12.566,"4\"",{"$nulls":10},12.692,"4\"",null,19.761,"5\""]
[{"$nulls":9},20.213,"6\"",null,17.856,"6\"",{"$nulls":4},12.567,"N/A",{"$nulls":10},12.693,"N/A",null,19.762,"6\""]
[{"$nulls":9},29.158,"6\"",null,25.598,"6\"",{"$nulls":19},28.567,"6\""]
["Conduit Fill Rates",{"$nulls":8},{"v":29.159000000000002,"d":"29.159"},"N/A",null,25.599,"N/A",{"$nulls":19},28.568,"N/A"]
[]
[1,{"v":0.53,"d":"53%"}]
[2,{"v":0.31,"d":"31%"}]
[3,{"v":0.4,"d":"40%"}]