In article " Voltage drop calculations Part One ", I indicated that there are eight methods for Voltage Drop Calculations as follows:
1 Ohm’s Law Method,
2 European method,
3 U.S method which divided to:
 Circularmils method,
 Chapter (9) tables method.
5 Quick OnLine method,
6 AmpereFeet method,
7 Lookup tables,
8 Excel spreadsheets.
And I explained the first two methods: Ohm’s Law Method and European Methods in this Article.
And, I explained the third method: U.S Method Circularmils Method In Article " Voltage drop calculations Part Two ",
And, I explained the third method: U.S Method Chapter (9) tables Method In Articles:
And, in Article " Voltage Drop Calculations Part Four ", I explained the following methods for Voltage Drop Calculations:
 Approximate Mathematical method,
 AmpereFeet method,
 Lookup tables,
Also, in Article " Voltage Drop Calculations Part Five ", I explained the Quick OnLine Method with (8) Voltage Drop Calculators.
Today I will continue explaining other methods for Voltage Drop Calculations as follows.
8 Excel Spreadsheets Method for Voltage Drop Calculations
8 Excel Spreadsheets Method for Voltage Drop Calculations
Under this method, I will explain the following excel
spreadsheets for Voltage Drop Calculations:
First: Excel Spreadsheet for US / NEC Methods:
Second: Excel Spreadsheet for European Method /Code

First: Excel Spreadsheet for US / NEC Methods:
1 Excel
Spreadsheet for Voltage Drop Calculator
This Excel Spreadsheet Calculate
the Voltage Drop as per US Circular Mils Method.
How to use this Excel Spreadsheet:
1 Put the input data which are:
Note: if you have the Cable Cross section
Area in AWG/Kcmil use the shown table to get the equivalent Cmils.
2 Get Voltage drop (V D) in V from the
following Formula:
3 Get Voltage drop (V D) in percent from the
following Formula:
(V
D) % = Voltage drop (V D) in V x 100 / Voltage
4 From the Results section, select the Result that match with the
actual method of installation from the following choices:
5 If the (V D %) > the predetermined
Value according to Country Regulations (2.5 % or 3%), change the Cable Cross
section Area in Cmils with a higher size.

2 Excel Spreadsheet for Voltage Drop
Calculations
This Excel Spreadsheet Calculate
the following as per US Chapter (9) Tables Method:
How to use this Excel Spreadsheet:
1 Fill in blank
cells 1 to 8 as follows:
Note: if the
wire is smaller than 1/0 AWG, then Parallel wires are not allowed except per
310.4 exceptions.
2 The Result
Window will show the following Calculated
information (in grey color) which are:
Notes:

3 Siemens Voltage Drop Calculations Spreadsheet
This voltage drop calculator will provide an approximate
value for use in project design. You can review this spreadsheet in the Previous
Article "Siemens Voltage Drop Calculations Spreadsheet ".

Second:
Excel Spreadsheet for European
Method /Code
2 Excel
Spreadsheet for 3Phase Voltage Drop Calculations
This Excel Spreadsheet Calculate
only the 3Phase
Voltage Drop as per
European method /Code.
How to use this Excel Spreadsheet:
1 Put the required general data which are:
2 Put the Load data which are:
Load Current (A) = (Load power (KW) x 1000) / (√3 x Voltage (V) x P.F)
Note: If P.F is unknown, you can use P.F = 0.85
3 Put the Cable Data which are:
4 Get Voltage drop (V D) in Volts from the following Formula:
Voltage drop (V D) = K x Load Current (A) x Length (L) / 1000
5 Get Voltage drop (V D) in Percent from the following Formula:
(V D %) = (V D x 100 / Voltage)
6 if the (V D %) > the predetermined Value according to Country
Regulations (2.5 % or 3%), you must reselect another cable with higher size
and repeat the calculations.
Notes:

End of Course EE4 
جزاك الله خيرا
ReplyDelete