Electrical MS Excel Spreadsheets (Calculations of cables, voltage drop etc.)

Ένα πακέτο ανοιχτού λογισμικού σε EXCEL για Ηλεκτρολόγους και Μηχανολόγους που μπορείτε εύκολα να μεταφράσετε και προσαρμόσετε στις δικές σας ανάγκες

 An open source software package in EXCEL for Electricians that you can easily translate and adapt to your needs

 This section is dedicated to tools every electrical engineer can use in daily work. These spreadsheets below will make your job much more easier, alowing you to shorten the time used for endless calculations of cables, voltage drop, various selections of circuit breakers, capacitors, cable size and so on. Spreadsheets are mostly developed by expirienced electrical engineers and programmers (thank you mr. Jignesh Parmar!) and by well known manufacturers of electrical equipment. They all really did an awesome job, you must admit!

Just to mention that all calculation spreadsheets are free for download!                                         



Electrical calculations (MS Excel Spreadsheets) 		 View
Motor Starting Calculation Spreadsheet (by Hemant Kashikar)   Live File.
Cable Designing Program   Live File.
Calculate Home Electrical Load & Electrical Bill   Live File.
Calculate Bus Bar Size and Voltage Drop   Live File.
Calculate Electrical Load and Energy Consumption of Panel   Live File.
Calculate Electrical Load of Panel   Live File.
Calculate Insulation Resistance Value   Live File.
Calculate Number of Lighting Fittings and Lumen Output   Live File.
Calculate Size of Battery Bank and Inverter   Live File.
Calculate Size of Solar Panel, Battery Bank and Inverter   Live File.
Circuit Breaker Tripping Settings   Live File.
Conduit Size Selection Program   Live File.
Design of Earthing Mat for Sub-Station   Live File.
Selection of MCCB, ELCB For Main-Branch Circuit   Live File.
Selection of fuse and setting of instant short circuit tripping of CB   Live File.
Short Circuit Current Calculation at Various Point of Electrical Circuits (Isc)   Live File.
Size of Capacitor For Power Factor Improvements   Live File.
Fault Current Calculation   Live File.
Electrical Safety Program Arc Flash Calculator  Live File.
E-Feeder and Cable Calculator  Live File.
SquareD – Selecting capacitor size  Live File.
Voltage Drop Calculator – Albany Technical College  Live File.
Cable size calculations based on motor horse power (HP) and specified current  Live File.
Voltage Regulation Percentage of Small Distribution Line  Live File.
Calculate size of air conditioning for room  Live File.
Residential Load Calculations  Live File.
Pump Efficiency Calculation Tool  Live File.
Transformer Fault Current Calculation  Live File.
Powerline Voltage Drop Calculation   Live File
View
Power Factor Correction Calculation  Live File.
Calculation of Touch Voltage and Ground Current  Live File.
IDMT (Inverse Definite Minimum Time) Relay Calculation  Live File.
Calculate Size of Diesel Generator  Live File.
Electrical Pole’s Trasverse Load Calculation   Live File.
Electrical Engineering General Formulas  Live File.
CO2 Savings Calculator  Live File.
Available Fault Current Selective Coordination File.
Power Factor Table Calculator  Live File.
NEMA Motor Data Calculator  Live File.
Estimated Voltage Drop Calculator  Live File.
IEC Motor Data Calculator  Live File.
Calculation of Size of Transformer, Fuse and Circuit Breaker  Live File.
Calculate Size Of DOL and Star-Delta Starter Components   DOL File.
Calculate size of transformer and voltage due to starting of large size motor  Live File.
Power Quality Solution Selection Spreadsheet  Live File.
Spreadsheet For Calculating Size Of Motor Pump  Live File.
Spreadsheet For Calculation The Required Number Of fixtures And Illuminance Level  Live File.
Lightning Protection Risk Assessment Calculator/Spreadsheet  Manual Live File.
Load Listing, Calculations and Generator Sizing Spreadsheet Live File.
Spreadsheet for Transformer Losses Calculation Live File.
Motor Voltage Drop Calculator (Spreadsheet)  Live File.
Spreadsheet to calculate the size of neutral earthing transformer  Live File.
Spreadsheet to Calculate Short Circuit Capacity of Diesel Generator Synchronizing Panel  Live File.
Power factor correction calculations for power system   Live File.
Distribution Transformer Calculations   Live File.
Calculation of electro magnetic field (EMF) around T&D overhead lines   ZIP File
Reblog https://electrical-engineering-portal.com/download-center/electrical-ms-excel-spreadsheets
Reblog https://www.eloquens.com/category/engineering/electrical-engineering/333


ΠΡΟΣΟΧΗ !!! Tο blog https://mixanikos365.blogspot.com/ δημοσιεύει άρθρα τηρώντας κατά γράμμα τον Νόμο Ν.2121/1993 περί πνευματικών δικαιωμάτων, δημοσιεύοντας άρθρα ΑΠΟΚΛΕΙΣΤΙΚΑ για λόγους ενημέρωσης και εκπαίδευσης (αρ.25) τόσο των μελών της ομάδας όσο και όλης της ανθρωπότητας , επίσης χρησιμοποιεί της παράθεσης σύντομων αποσπασμάτων άρθρων , βιβλίων , και συγγραμμάτων νομίμως δημοσιευμένων για την υποστήριξη της γνώμης εκείνου που τα παραθέτει και την κριτική της γνώμης των αναγνωστών και των blogger του ιστοτόπου μας υπό την προϋπόθεση ότι ΠΑΝΤΑ αναφέρεται η προέλευσή τους και ο δημιουργός και εκδότης τους (α.19) με ενεργό LINK και παραπέμπει στην αρχική πηγή δημοσίευσης. Παρακαλούμε διαβάστε τους Όρους χρήσης , και ποιες δημοσιεύσεις υπάγονται στις εξαιρέσεις του Ν.2121/1993 . ΠΑΡΟΛΑ αυτά αν κάποιος κάτοχος προστατευμένου ©COPYRIGHT ή Creative Commons περιεχομένου εντοπίσει παράβαση του έργου του στον ιστότοπο μας παρακαλούμε να επικοινωνήσει ΑΜΕΣΑ μαζί μας για να το ΔΙΑΓΡΑΨΟΥΜΕ ή να το ΤΡΟΠΟΠΟΙΗΣΟΥΜΕ άμεσα ανάλογα με την επιθυμία του ... !!!

 -  -  -  - 

More links

(1) Cable size and Voltage Drop Calculation

  • Calculate Voltage drop of Cable.
  • Calculate  Size of Cable as per Electrical Load.
  • Calculate Current Capacity of Cable.
  • Calculate No of Run of Cable.
  • Calculate Motor Starting Voltage Drop.
  • Calculate Motor Running Voltage Drop.
  • Select appropriate Starter for Motor.

(2) Selection of  Main /Branch Circuit MCB as per NEC-210.

  • Calculate  Size and Type of Main MCCB/RCCB/ELCB for Continuous Load
  • Calculate  Size and Type of Main MCCB/RCCB/ELCB for Non Continuous Load
  • Calculate  Sensitivity of MCCB/RCCB/ELCB.
  • Calculate Size and Type of Sub Circuit MCCB/MCB for Continuous and Non Continuous Load
  • Calculate Total Load .
  • Calculate Max.Length of Cable.
  • Calculate Main and Branch Circuit Current.

(3) C.B Tripping Setting & Fuse for Motor Protection

    FREE DOWNLOAD           BUY UNLOCK VERSION($) 
  • Calculate Size of Fuse for Electrical Circuit.
  • Calculate  Tripping Setting of Circuit Breaker.
  • Calculate Various Specification of Motor.
  • Calculate Motor Full Load Current.
  • Calculate Motor Locked Rotor Current.
  • Calculate Motor Protection Setting

(4) Calculate Size of air condition for room.

     FREE DOWNLOAD.            BUY UNLOCK VERSION($)
  • Calculate Size of Air Conditioning for Your Room.
  • Calculate AC Size in BTU/Hr.
  • Calculate AC size in Tone.
  • Calculate Heating and Cooling BTU.

(5) Calculate Motor-Pump Size:

  • Calculate Pump Hydraulic Power
  • Calculate Motor-Pump Shaft Power
  • Calculate Pump Size.
  • Calculate Motor Size.

(6) Calculate Electrical Unit Consumption & Energy Bill

  • Calculate Electrical Unit (KWH) consumption per month
  • Quick Calculate Electrical Bill as per Electrical Slab Rate
  • Calculate Total KW.

(7) Calculate Insulation Resistance Value

  • Calculate minimum Insulation Resistance Value for Various Electrical Equipments.
  • Calculate IR Value of Electrical Equipments.
  • Graph of  IR Value
  • Calculate Earth Resistivity.

(8) Calculate Polarization Index Value

  • Graph of  IR Value
  • Calculate Polarization Index Value with Graph

 (9) Calculate Earth Resistance Value

  •  Calculate Earth Resistivity.

 (10) Calculate Touch Voltage and Ground Current.

      FREE DOWNLOAD              BUY UNLOCK VERSION($)
  • Calculate Resistance of Each Phase.
  • Calculate  Resistance of neutral/Ground.
  • Calculate Neutral Current and Load.
  • Calculate Touch Voltage for Metal part to Earth.
  • Calculate Body Resistance and Body Current.

 (11) Calculate Size of Diesel Generator.

   FREE DOWNLOAD             BUY UNLOCK VERSION($)
  • Calculate Size of D.G Set for Linear,Non-Linear Load
  • Calculate Size of D.G Set for Motor Load
  • Calculate D.G Set Efficiency.
  • Calculate UPL (Unit per Liter) of D.G Set
  • Calculate Unit Power Cost of D.G Set
  • Calculate Approximate Fuel Consumption.

 (12) Calculate Size of Inverter-UPS with Battery Bank .

  • Calculate Total Demand Load
  • Calculate Size of Battery Bank in Amp.Hr.
  • Select Type of Connection of Batteries in Battery Bank
  • Select Rating of Each Battery in Battery Bank
  • Calculate Size of Inverter/UPS.

 (13) Calculate Transverse Load on PCC/RCC/RSJ/Tublar Pole.

  • Calculate Crippling load on Pole
  • Calculate Wind Load on Pole.
  • Calculate wind Load on all Conductors.
  • Calculate Transverse Load on Pole
  • Decide spacing between Two Conductor as per IS:5613.
  • Calculate required Voltage level of Overhead Line according to Distance.

 (14) Design of Earthing Mat for Sub-Station:

      FREE DOWNLOAD      BUY UNLOCK VERSION($)
  • Program is design as per ANSI/IEEE 80-1986 Code.
  • Calculate Step Potential of Switch yard.
  • Calculate Touch Potential of Switch yard.
  • Calculate Total Length of Earthing Mat Conductor.
  • Calculate Size of Earthing Mat Conductor.
  • Calculate Total No of Earthing Rods.

 (15) Calculate Size of Solar Panel / Battery Bank / Inverter.

  • Calculate Total Demand Load
  • Calculate Size of Solar Panel.
  • Select Type of Connection of Solar Panel.
  • Select Rating of Each Solar Panel.
  • Calculate Energy from Solar Panel as per Daily Sun lights.
  • Calculate Size Battery Bank.
  • Select Type of connection of Batteries in Battery Bank
  • Calculate size of Inverter

 (16) Size of Capacitor  For Power Factor Improvements

  • Calculate Active and Reactive Power of System.
  • Calculate Leading Kvar of system.
  • Calculate Kvar/Phase.
  • Calculate Size of Capacitor for Power Factor Improvements.
  • Calculate Size of Main Fuse of Capacitor Bank
  • Calculate Size of Main Circuit Breaker
  • Calculate Thermal/Magnetic Setting of Circuit Breaker.
  • Calculate Max.Demand/KVA Demand/Total Annual cost befor Power Factor Correction.
  • Calculate Max.Demand/KVA Demand/Total Annual cost After Power Factor Correction.
  • Calculate Annual Saving by improving Power Factor by Capacitor.
  • Design Capacitor bank according to it’s Step Combination.

 (17) Residence Distribution Box’s- MCB- Wire Size Calculation

  • Calculate Size of Residence Distribution Box.
  • Calculate Per Phase Load on Distribution Box.
  • Calculate Unbalance Neutral Current.
  • Calculate Total Current on Distribution Box.
  • Calculate Total KW Load on Distribution Box.
  • Calculate Size of Main MCCB/ELCB/RCB of Distribution Box
  • Calculate Size of Branch Circuit MCB.
  • Calculate Size of Wire for Branch MCB.

 (18) Electrical Panel’s MCB & Cable Size Calculation.

  • Calculate Voltage / Voltage Difference of Each Phase
  • Calculate Unbalanced Load in Neutral Wire.
  • Calculate Expected Temperature rise in Each Phase.
  • Calculate Load in Each Phase and Outgoing Feeders.
  • Calculate Starting/Full Load/Continuous/Non Continuous Load
  • Calculate Size of Cables for Each Outgoing Feeder.

(19) Calculate Electrical Load and Energy Consumption of Panel.

  • Calculate Continuous and non Continuous Electrical Load of Panel.
  • Calculate total Energy Consumption(KWH) in Daily/Monthly of Panel.
  • Calculate Size of MCB of each branch circuit of Panel.
  • Calculate Voltage / Voltage Difference of Each Phase
  • Calculate Unbalanced Load in Neutral Wire.
  • Calculate Expected Temperature rise in Each Phase.
  • Calculate Load in Each Phase.
  • Calculate Starting/Full Load/Continuous/Non Continuous Load
  • Calculate Size/Type/Tripping setting of Main MCCB.

(20) Calculate % Voltage Regulation of Small Distribution Line.

     FREE DOWNLOAD          BUY UNLOCK VERSION($)
  • Calculate % Voltage Regulation of Small Distribution Line
  • Calculate % Voltage drop of Individual Load.
  • Calculate % Voltage drop of Various ACSR, AAAC, AAC conductor overhead Line.
  • Calculate Receiving end Voltage of Distribution Line.
  • Calculate Total % Voltage Regulation of Distribution Line.

 (21) IDMT Over current & Earth Fault Relay Setting:

     FREE DOWNLOAD           BUY UNLOCK VERSION($)
  • Calculate IDMT Over Current Relay Setting (50/51)
  • Calculate IDMT Over Current Relay Pick up setting.
  • Calculate IDMT Over Current Relay PSM.
  • Calculate IDMT Over Current Relay Time setting.
  • Calculate Actual Operating time according to Various IES Curve.
  • Calculate Low current Setting(I>).
  • Calculate High Current Setting(I>>)
  • Calculate Actual Operating Time of Relay(t>)
  • Calculate Actual Operating Time of Relay(t>>)
  • Calculate IDMT Earth Fault Relay Setting (50N/51N) 
  •  Calculate IDMT Earth Fault Relay Pick up setting.
  • Calculate IDMT Earth Fault Relay PSM
  • Calculate IDMT Earth Fault Relay Time setting
  • Calculate Actual Operating time according to Various IES Curve.
  • Calculate Low current Setting(Ie>)
  • Calculate High Current Setting(Ie>>)
  •  Calculate Actual Operating Time of Relay(te>)
  •  Calculate Actual Operating Time of Relay(te>>)

(22) IDMT Relay Setting & Curves:

  • Calculation of Actual Plug (Relay Pick up) setting of Various IDMT Relay.
  • Calculate PSM of Various IDMT Relay.
  • Calculate Time setting of Various IDMT Relay.
  • Calculate Total Grading Time of Various IDMT Relay.
  • Calculate Actual Operating time according to Various IES Curve.
  • Draw Various IDMT Relay characteristic Curve.

(23) IDMT Over Current Relay Grading Calculation (50/51):

    FREE DOWNLOAD            BUY UNLOCK VERSION($)
  • Calculate IDMT Over current Relay Grading up to 5 Nos of Radial Bus bar System.
  • Calculate Relay Pick up setting of IDMT Over current Relay from Downstream to Source End.
  • Calculate PSM of Various IDMT Relay from Downstream to Source End.
  • Calculate Time setting of Various IDMT Relay from Downstream to Source End.
  • Calculate Total Grading Time of Various IDMT Relay from Downstream to Source End.
  • Calculate Actual Relay Operating time according to Various IES Curve.

(24) Transformer IDMT Over Current & Earth Fault Relay Setting:

    FREE DOWNLOAD        BUY UNLOCK VERSION($)
  • Calculate LT & HT Side IDMT Over Current Relay Setting (50/51)
  • Calculate LT & HT Side IDMT Over Current Relay Pick up setting.
  • Calculate LT & HT Side IDMT Over Current Relay PSM.
  • Calculate LT & HT Side IDMT Over Current Relay Time setting.
  • Calculate Actual Operating time according to Various IES Curve.
  • Calculate LT & HT Side Low current Setting(I>).
  • Calculate LT & HT Side High Current Setting(I>>)
  • Calculate LT & HT Side Actual Operating Time of Relay(t>)
  • Calculate LT & HT Side Actual Operating Time of Relay(t>>)
  • Calculate LT & HT Side IDMT Earth Fault Relay Setting (50N/51N) 
  •  Calculate LT & HT Side IDMT Earth Fault Relay Pick up setting.
  • Calculate LT & HT Side IDMT Earth Fault Relay PSM
  • Calculate LT & HT Side IDMT Earth Fault Relay Time setting
  • Calculate Actual Operating time according to Various IES Curve.
  • Calculate LT & HT Side Low current Setting(Ie>)
  • Calculate LT & HT Side High Current Setting(Ie>>)
  •  Calculate LT & HT Side Actual Operating Time of Relay(te>)
  •  Calculate LT & HT Side Actual Operating Time of Relay(te>>)
  • Calculate Differential Protection Relay setting:
  • Calculate Percentage Differential Current at Normal tapping
  • Calculate Percentage Differential Current at Highest tapping
  • Calculate Percentage Differential Current at Lowest tapping

(25)  Size of Transformer’s Circuit Breaker & Fuse (As per NEC 450.3)

     FREE DOWNLOAD.           BUY UNLOCK VERSION($)
  • Calculate Size of Circuit Breaker on Primary side of Transformer as per NEC 450.3
  • Calculate Size of Fuse on Primary side of Transformer as per NEC 450.3
  • Calculate Size of Circuit Breaker on Secondary side of Transformer as per NEC 450.3
  • Calculate Size of Fuse on Secondary side of Transformer as per NEC 450.3
  • Calculate Size of Transformer
  • Calculate Transformer Full Load Losses.

 (26) Size of Transformer & Voltage drop due to starting of large Motor

  • Calculate Lock Rotor Current.
  • Calculate Motor Starting Current.
  • Calculate Motor Full Load Current.
  • Calculate Non-time Delay/Time Delay fuse Size.
  • Calculate Circuit Breaker Size.
  • Calculate Overload Relay setting.
  • Calculate Type of Contactor.
  • Calculate Size of Main Contactor.
  • Calculate Size of Star Contactor.
  • Calculate Size of Delta Contactor.
  • Standard Arrangement of Main and Auxiliary Contactor

 (27) Calculate Number of Plate / Pipe Earthing:

  • Calculate Permissible Current Density of Earth Electrode (Id).
  • Calculate No of Copper Plates Earthing Required .
  • Calculate No of Pipe Earthing Required.
  • Calculate Overall Earthing Resistance of Earthing Electrodes.
  • Calculate Resistance of Earthing Strip/Wire.
  • Calculate Resistance as per Arrangement of Plate/Pipe Earthing.

 (28) Calculate Size of Earthing Strip / Wire:

  • Calculate Resistance of Earthing Strip/Wire.
  • Calculate Minimum Size of of Earth Strip/Wire.

(29) Calculate Size of  DOL &  Star Delta Starter Parts:

    FREE DOWNLOAD.           BUY UNLOCK VERSION($)
  • Calculate Lock Rotor Current.
  • Calculate Motor Starting Current.
  • Calculate Motor Full Load Current.
  • Calculate Non-time Delay/Time Delay fuse Size.
  • Calculate Circuit Breaker Size.
  • Calculate Overload Relay setting.
  • Calculate Type of Contactor.
  • Calculate Size of Main Contactor.
  • Calculate Size of Star Contactor.
  • Calculate Size of Delta Contactor.
  • Standard Arrangement of Main and Auxiliary Contactor.

(30) Calculate No of Fixtures & Lux  as per Sq.Ft Area:

  • Calculate required No of Fixtures.
  • Calculate required No of Lamps.
  • Calculate Watts / Sq.foot.
  • Calculate Energy Cost / Year.
  • Calculate Actual Lux Level.

 (31) Calculate No’s of Fixtures & Lumen for Indoor Lighting.

    FREE DOWNLOAD         BUY UNLOCK VERSION($)
  • Calculate Total Lumen Output for particular Area.
  • Calculate Total No of Lighting Lamps.
  • Calculate Total No of Lighting Fixtures.
  • Calculate No of Fittings along with the Length and Width of Room.

 (32) Size and Short Circuit Capacity of D.G Synchronous Panel

  • Calculate Size of D.G Synchronous Panel.
  • Calculate Total Fault  Current of D.G Synchronous Panel.
  • Total Equivalent Impedance of  D.G Synchronous Panel.
  • Calculate Short Circuit Current of D.G Synchronous Panel.

(33) Short Circuit Current at various Point of Distribution System

  • Calculate Total impedance of upper stream.
  • Calculate Total impedance of Lower stream.
  • Calculate impedance of Transformer.
  • Calculate Fault current on Secondary of Transformer.
  • Calculate minimum size of Cable to withstand Isc.
  • Calculate Fault current at various location of Distribution System.
  • Calculate Min Size of Cable at various location of Distribution System.

  (34) Short Circuit Current Calculation (Base KVA Method)(Isc).

  • Calculate Short Circuit Current  at Substation.
  • Calculate Short Circuit Current at Distribution point.
  • Calculate Short Circuit Current at Transformer.
  • Calculate Short Circuit Current at Main Panel.
  • Calculate Short Circuit Current at Sub Distribution Board.

  (35) Technical Losses of Distribution Line

  • Calculate Total Connected Load of distribution Line.
  • Calculate Diversity Factor (DF) of distribution Line.
  • Calculate Load Factor (LF) of distribution Line.
  • Calculate Distribution Transformer Losses.
  • Calculate HT & LT Line Losses.

 (36) Transformer Losses Calculation(As per Test Result)

  • Calculate Total Core loss at actual voltage and freq.
  • Total Copper loss estimated at test current
  • Calculate Stray losses at test current
  • Calculate Total Copper loss at full load current.
  • Calculate Stray losses at full load current.
  • Calculate Total No Load losses at actual load.
  • Total Load Load losses at actual load
  • Total Losses at actual load.
  • Efficiency at actual load.

 (37) Transformer Losses and Payback period Calculation

  • Comparison of Transformer No Load Losses.
  • Comparison of Transformer Load Losses.
  • Comparison of Transformer Annual Amount of Losses.
  • Comparison of Transformer Carbon Dioxide emission rate.
  • Calculate Total Owning Cost  (TOC) of Transformer.
  • Calculate Transformer Payback Period.
  • Calculate Annual Rate of Returns.

(38) Transformer Losses-Regulation-Efficiency(TC Name Plate)

    FREE DOWNLOAD          BUY UNLOCK VERSION($)
  • Calculate No Load Losses at various Loading of Transformer.
  • Calculate Full Load Losses at various Loading of Transformer.
  • Calculate Percentage Impedance
  • Calculate Transformer regulation at various Power Factor.
  • Calculate Transformer Efficiency at Unity P.F at various Loading condition.
  •   Calculate Transformer Efficiency at various P.F at various Loading condition.

 (39) Calculate Voltage Drop and No’s of Street Light Pole

  • Calculate Voltage drop in Street Light Pole
  • Calculate Distance between Each Street Light Pole
  • Calculate Wattage of each Street Light Luminaire
  • Calculate Required Street Light Watt as per Given Area.
  • Calculate Luminaire Payback Period

 (40)  No of Street Light Poles & Payback Period

  • Calculate Wattage of each Street Light Luminaire
  • Calculate Required Street Light Watt as per Given Area.
  • Calculate Luminaire Payback Period

(41) Calculate Size of Neutral Earthing Transformer (NET)

  • Calculate Total Capacitive charging current (It).
  • Calculate Neutral Earthing Transformer  Secondary Current.
  • Calculate Required Grounding Resistor value at primary side (Rp).
  • Calculate Required Resistance value at secondary side (Rsec).
  • Calculate Neutral Earthing Transformer X/R Ratio
  • Calculate Fault current through Neutral (single line to ground fault) (If)
  • Calculate Rating of Neutral Earthing Transformer (P).

(42) Calculate Bus bar Size for Panel

  • Calculate Bus Bar Cross Section Area
  • Calculate Current Rating of Bus Bar
  • Calculate Peak elector-magnetic Force between Phase Conductors
  • Calculate Force on Insulator of Bus bar Support.
  • Calculate Mechanical Strength of Bus Bar.
  • Calculate Maximum Temperature Rise of Bus Bar.

(43) Calculate Size of Cable Tray

  • Calculate Cable Tray width
  • Calculate Cable Tray area
  • Calculate Cable Tray length
  • Calculate Cable Tray Weight
  • Calculate Remaining width of Cable Tray
  • Calculate Remaining Area of Cable Tray

(44) Calculate Size of Conduit

  • Calculate Total Area of Multiple Cables.
  • Calculate Total Area of Conduit for Multiple Cables.
  • Calculate Fill up area of Conduit.
  • Calculate % Fill up area of Conduit.
  • Calculate No of Conduits for Multiple Cables.
  • Calculate Size of Conduits for Multiple Cables.

(45) Building Lighting Protection Calculation

   FREE DOWNLOAD    
  • Calculate Area of Building / Structure
  • Calculate Collection area of Structure
  • Calculate Probable No of Strike on Structure
  • Calculate Overall Risk Factor
  • Calculate whether Lighting Protection Required or Not
  • Calculate Number of Down Conductor

(46) Cable Voltage drop for different size of cable

  • Calculate Voltage of Cable having Different Size
  • Calculate Starting Current
  • Calculate Running Current
  • Calculate Starting Voltage Drop
  • Calculate Running Voltage Drop

(47) Calculate Cable / Wire Trunking size

  • Calculate Size of  Trunking for Different size of Cables.
  • Calculate Size of  Trunking for Different size of Wires.

(48) Calculate Exhaust Fan Size

  • Calculate Size of  Ventilation Fan

(49) Calculate Pole Foundation Size

   FREE DOWNLOAD     
  • Calculate Size of  Foundation for Pole

(50) Calculate ventilation for Transformer & DG Room

  • Calculate Heat Loss of Electrical Equipment in Electrical / DG Room.
  • Calculate Air Quantity Required for Ventilation.
  • Calculate No’s of Ventilation Fan.
  • Calculate Rating of Ventilation Fan.

(51) Calculate Ceiling Fan Size

  • Calculate Ceiling Fan Size
  • Calculate Number of Fan.
  • Calculate Height of Fan above Floor .
  • Calculate Total Air Deliver.

(52) Calculate Lighting Fixture Beam Angle

  • Calculate Lighting Fixture Beam Angle
  • Calculate Illumination at Surface from Beam Angle.
  • Calculate Lighting Fixture Lumen from Beam Angle.
  • Calculate Illuminated Diameter from Beam Angle.
Reblog https://electricalnotes.wordpress.com/electrical-tools-excel-base/

INSULATION RESISTANCE (10.6.13).XLS
CONDUIT SIZE (10.6.13).XLS
LIGHTING LUMEN CALCULATION(10.6.13).XLS
EXCEL DECK WEIGHT AND COST CALCULATOR.XLS
TRANSFORMER IDMT RELAY SETTING (10.6.13).XLSX
BATTERYSIZECALCULATOR28-5-11.XLS
SHORT CIRCUIT CALCULATION (10.6.13).XLS
BATTERY BANK SIZE & INVETOR (10.6.13).XLS
OFPLATE-PIPEEARTHINGSIZEOFEARTHINGSTRIP18.12.12.XLS
HOMEELECTRICALBILL28-5-11.XLS
SELECTION OF MAIN CB AND BRANCH CB(10.6.13).XLS
EXCEL OVERTURN CALCULATOR.XLS
C.BTRIPPINGSETTINGMOTORDATA22.8.12.XLS
EXCEL ANCHOR BOLT CALCULATOR.XLS
STOCK LIST OF STORE MATERIAL FOR THE MONTH OF JUNE 2012.XLS
ACSIZECALCULATION28-5-11.XLS
BUSBAR SIZE CALCULATION (10.6.13).XLS
SOLARPANELDESIGN28-5-11.XLS
NO OF FIXTURE & LUX LEVEL ESTIMATOR (10.6.13).XLSX
POWERFACTORCORRECTION28-5-11.XLS
 S.S EARTHING MAT DESIGN (10.6.13).XLS
ELECTRICAL PANEL LOAD CALCULATION (10.6.13).XLS
SIZE OF CAPACITOR FOR POWER FACTOR IMPROVEMENT (10.6.13).XLS
EXCEL CONST COST CALCULATOR.XLS
IDMT RELAY CURVE (10.6.13).XLSX
SIZEOFCAPACITORBANKFORP.FCORRECTION.XLS
C.BTRIPPINGSETTING-MOTORDATA28-5-11.XLS
CALCULATION FOR THE ANGLE REQUIREMENT.XLSX
BUSBARSIZECALCULATION28-5-11.XLS
EXCEL SITE PLAN SLOPE CALCULATOR.XLS
SELECTIONOFMAINCBBRANCHCB28-5-11.XLS
TOUCH VOLTAGE & GROUND CURRENT (10.6.13).XLS
CABLE SIZE DESIGN (10.6.13).XLS
POWERFACTORCORRECTION22.8.12.XLS
LIGHTINGLUMENCALCULATION28-5-11.XLS
EXCEL BUILDING WEIGHT CALCULATOR.XLS
C.B TRIPPING SETTING & MOTOR DATA (10.6.13) (1).XLS
CALCULATEVOLTAGEREGULATIONOFLINE..XLS
CONDUITSIZE22.8.12.XLS
SHORTCIRCUITCALCULATION22.8.12.XLS
CTRICALLOADCALCULATIONENERGYCONSUMPTION22.8.12..XLS
EXCEL ADA RAMP LENGTH CALCULATOR.XLS
INSULATIONRESISTANCE28-5-11.XLS
 ELECTRICAL LOAD CALCULATION & ENERGY CONSUMPTION (10.6.13)..XLS