▲Wirig Diagram Hot
▲ ▲ ▼

Cable Size Calculation in Excel: Easy Formula & Chart

By

Calculating cable size is a critical step in electrical engineering and installations. This process involves determining the correct wire gauge based on factors like current, voltage, and obstacle protection. Excel, with its robust computations and user-friendly interface, makes these calculations efficient. This article will guide you through creating a cable size calculation formula in Excel.

Before diving into the formula, let's understand the key parameters: current (I), voltage drop (VD), and ambient temperature (Ta). We'll also need the installation's protection method (e.g., fuses, circuit breakers), which affects the minimum cable size. Our goal is to find the correct cable cross-sectional area (ACA) and its corresponding wire gauge.

Cable Size Calculation Formulas

Cable size calculations involve two key formulas: ACG (Calculated Area of Conductors) and AG (Allowance for Groups of Conductors). Both depend on the current rating, cable properties, and protection method.

How to Calculate Cable Size from kW
How to Calculate Cable Size from kW
Cable Size Selection
Cable Size Selection
the electrical cable size calculator
the electrical cable size calculator

The formulas are as follows: ACG = I * KNAC (where KNAC is the cable's 'n' factor) and AG = ACG * KAG (where KAG represents the allowance for groups of conductors). The final cable size (ACA) will be AG + ACG.

Formulating ACG in Excel

To calculate ACG in Excel,we'll use the ACG formula and input the values for I and KNAC. Assuming our current (I) is in cell A2 and KNAC in cell B2, we'd input "=A2*B2" in a cell to get the ACG value.

an electrical calculator with the text how to calculate cable size mm2 for 3 phase
an electrical calculator with the text how to calculate cable size mm2 for 3 phase
Electrical Wire & Cable Sizes with Current Rating ⚡ Cheat Sheet for Safe Wiring Guide
Electrical Wire & Cable Sizes with Current Rating ⚡ Cheat Sheet for Safe Wiring Guide
the table is shown with numbers and symbols for each element in this diagram, which are labeled
the table is shown with numbers and symbols for each element in this diagram, which are labeled

To make this dynamic, we can insert these values into a generic cell, like "=I*KNAC". We can then change 'I' and 'KNAC' as needed within the formula. Moreover, using the cell references allows us to calculate ACG for multiple values with ease.

Formulating AG and ACA in Excel

Next, calculate AG using the ACG value and KAG. Assuming KAG is in cell C2, input "=ACG*C2" in another cell. AG will depend on your calculated ACG, so link the AG cell to its ACG cell.

Finally, calculate the required cable size (ACA) by adding ACG and AG cells. In our example, if ACG is in cell D2 and AG in cell E2, input "=D2+E2" to get ACA.

1.3K reactions · 236 shares | IEC Standard Cable Size Calculation with example ⚡👇 #fblifestyle #electrical #education #Cable #reelsvideoシ | Md. Shamim Hassan | Facebook
1.3K reactions · 236 shares | IEC Standard Cable Size Calculation with example ⚡👇 #fblifestyle #electrical #education #Cable #reelsvideoシ | Md. Shamim Hassan | Facebook
an electrical wiring diagram for the as / s cable size calculator
an electrical wiring diagram for the as / s cable size calculator
How to Calculate Cable Size for any Electrical Load?
How to Calculate Cable Size for any Electrical Load?
table size chart for cable sizes
table size chart for cable sizes
3-Phase Cable Size Calculation – Practical Engineering Approach (11 kV / LV Industrial Feeders) This example shows a complete, standards-based method to select power cables for a 365 kW 3-phase load… | Amir Sohail . PE Eng
3-Phase Cable Size Calculation – Practical Engineering Approach (11 kV / LV Industrial Feeders) This example shows a complete, standards-based method to select power cables for a 365 kW 3-phase load… | Amir Sohail . PE Eng
the size and measurements for cable sizes
the size and measurements for cable sizes

Accounting for Different Protection Methods

Different protection methods (fuses, circuit breakers) require varied calculations. Some will need additional safety factors for overloading, while others may have max. current limits. Excel allows easy switching between these methods with simple adjustments in your formulas.

To switch between protection methods, use IF statements in Excel, like "=IF(Method,"max current", "I * safety factor"). This allows dynamic switching between calculation methods based on your chosen protection type.

Finding the Corresponding Wire Gauge

The final step is finding the wire gauge that corresponds to your calculated ACA. Excel's VLOOKUP or INDEX MATCH functions can help retrieve the gauge from a table of ACA to gauge values.

Cable Size Calculation for LT & HT Motors | Electrical Technology
Cable Size Calculation for LT & HT Motors | Electrical Technology
Cable size &rating
Cable size &rating

If your ACA values and gauges are in columns A and B, and the calculated ACA is in cell F2, use "=VLOOKUP(F2,A:B,2,FALSE)" to find the corresponding gauge.

By following these steps, you'll create an efficient cable size calculation tool in Excel. This will save time and ensure accurate, safe designs for electrical systems. To keep your spreadsheet dynamic and user-friendly, include input cells for all variables while outputting the final gauge in a visible location.

Now that you've become proficient in creating cable size calculation formulas in Excel, explore other aspects of electrical engineering to further enhance your skills. Who knows, you might create the next industry-standard calculation tool!

💬 Comments ↗ Share ★ Save
AD