Electrical Tools (MS Excel Spreadsheets)




This section is dedicated to tools every electrical engineer can use in daily work. These spreadsheets below will make your job much more easier, allowing you to shorten the time used for endless calculations of cables, voltage drop, various sections of circuit breakers, capacitors, cable size and so on.

Most of spreadsheets are developed by two electrical engineers and programmers mr. Jignesh Parmar and mr. Hemant Kashikar. They all really did an awsome job, you must admit.

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


Electrical calculations (MS Excel Spreadsheets)



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

4 comments:

  1. good job. but can i print out my work?

    ReplyDelete
  2. Nice blog… Thanks for sharing very useful information about electrical circuits.
    Designing Electrical Circuits

    ReplyDelete
  3. Accurate estimating is the backbone of every successful electrical project, and Best Bid Electrical Estimating Software is built to deliver exactly that. By automating complex calculations and material takeoffs, it reduces costly errors that often occur with manual methods.
    The software enables contractors to analyze digital blueprints with precision. Its on-screen takeoff tools allow users to measure circuits, fixtures, and wiring layouts directly from plans, ensuring nothing is missed. This leads to more reliable estimates and better project planning.
    Another key feature is its real-time material pricing database. Instead of relying on outdated costs, contractors can generate up-to-date estimates that reflect current market conditions. This helps avoid underbidding or overpricing projects.
    Best Bid also enhances collaboration within teams. Estimates can be reviewed, edited, and shared easily, making communication smoother between project managers and estimators.
    By improving accuracy and reducing guesswork, the software allows contractors to bid with confidence. In a competitive industry, having precise estimates not only saves money but also increases the likelihood of winning profitable projects.

    ReplyDelete
  4. Best Bid Electrical Estimating Software helps contractors, electricians, and construction companies streamline the bidding and project planning process with greater accuracy and efficiency. This software is designed to calculate material costs, labor expenses, and project timelines while reducing manual errors in electrical estimates. Advanced estimating solutions often include automated takeoffs, real-time pricing databases, proposal generation, and integration with accounting or project management systems.

    Electrical estimating tools are widely used for residential, commercial, and industrial projects to improve productivity and increase profitability. By using digital estimation platforms, businesses can create faster and more professional bids, manage budgets effectively, and stay competitive in the construction industry. Many modern solutions also offer cloud-based access, enabling teams to collaborate remotely and update estimates in real time
    .
    Whether you are a small electrical contractor or a large enterprise, electrical estimating software can help simplify complex calculations, save valuable time, and improve overall project accuracy for successful business operations.

    ReplyDelete