When to use computer-based power analysis tools

With the vast amount of power analysis design tools available today, electrical engineers can be overwhelmed when choosing the right tool to use. Learning these tools and knowing when to use them can help an engineer be more efficient with his or her time and results.


Learning Objectives:

  • Understand how electrical calculations were performed during the pre-desktop computer era and the challenges it posed.
  • Differentiate between the two basic types of power analysis tools available for electrical engineers.
  • Learn the challenges an electrical engineer may encounter when choosing a specific type of tool.

One of the biggest challenges for electrical engineers is to find their own path to efficiently design a project’s electrical system. By mixing the best approaches used by other engineers, one can find ways to surpass previous efficiencies. A key to achieving this goal is to understand what tools are available when given a new project.

Knowing how calculations have evolved can really help us appreciate the tools we have today. Electrical engineering was formally considered an occupation in the late half of the 19th century when electrical power distribution was fully commercialized. Electrical engineers of this era performed manual calculations with slide rules, but as the power systems became more sophisticated, the calculations became more complicated. As alternating current (ac) systems dethroned direct current (dc) systems, and transformers and 3-phase systems were introduced to the system, non-manual calculation tools were necessary to eliminate the negatives of manual approaches: human error and demanding work.

They used to do what?

Figure 1: This table shows the basic formulas needed to obtain essential values of a dc or ac power system. These formulas can be easily used in handwritten calculations. Courtesy: Primera Engineers, based on Stallcup’s, Electrical Design, 2008 Edition, aSeasoned engineers often tell stories about how “back in the day, you didn’t have this or that” before the age of digital computers and computer-aided design (CAD) software, and most of the stories are true. Prior to the 1950s with its analog computers and analyzers, and the 1960s with digital computers, engineers did most their calculations by hand with the aid of slide rules. With the introduction of the per-unit system to address the change of voltages on transformers, and the introduction of symmetrical components to address the complication of three-phase systems, manual calculations became more labor intensive.

For larger projects, things can get complicated when engineers calculate all the basic parameters needed for a complete electrical system design using hand calculations. Let’s not forget the challenge of saving copies of the calculations. However, by being up-close and personal with the results, engineers from those times were able to build a natural knowledge of how the systems worked.

The handwritten form is the primal way of performing calculations, and it’s not going away. For the engineer, the key is to know which tasks are better performed using handwritten calculations. One of the good things about this format is that it is free. You only need a pen (or pencil), a piece of paper, and a calculator. This is as simple as it gets. This type of tool is perfect during a project meeting.

For example, conversations during the meeting may involve asking the lead electrical engineer to give an estimate of a circuit breaker size on a 480 V to 208 Y/120 V, 45 kVA, transformer primary side. Knowing the simple formulas to convert Volt-ampere into full-load amps) at a specific voltage (see Figure 1) and any code factors to be applied in the situation (i.e., NFPA 70: National Electrical Code table 450.3(B)), the engineer can calculate that the breaker size will probably be 70 A.

Figure 2: This is an example image of a panelboard schedule imported into AutoCad. Using the third-party software XL2CAD, an engineer can easily import spreadsheets, saving the time it takes to type it into an AutoCAD text table. Source: Primera Engineers Remember, there are additional considerations to be taken into account, such as the type of overcurrent protection device or transformer type, but overall this is a good example of how to quickly and efficiently use handwritten calculations without running into major complications. Today, manual calculations can also be assisted with the use of published tables by manufacturers and vendors. These tables can be great resources when a specific product is being used in a project. For example, Cooper Bussmann’s Selecting Protective Devices Handbook is a must when doing coordination studies using fuses and other types of overcurrent protection devices. Eaton’s Consulting Application Guide Technical Discussion is another good example of a manufacturer’s published guide that has essential information that can help an engineer throughout his or her design.

Computers and software

The desktop computer began to make its appearance in the 1960s and became commonplace in the 1980s. Software products for these computers were created to help users with their daily needs. With this same mentality, programmers have created different tools to analyze electrical systems. With the arrival of computers, storage capability also came into consideration. A key aspect of using software tools is not only the capability of software products to calculate values, but the option to store, print, and share results in a clear and organized way.

Most software products started with a spreadsheet format, which eventually took over as the primary tool for electrical calculations. Most of their evolution was purely driven by user needs. At first, these types of software calculated nonlinear load flow, short-circuit currents, and voltage drop in a quick and simple way. The interface between the software and the users consisted of collecting all the information needed to calculate a value. The software required the user to input these values in a spreadsheet form. Much of the existing software still uses this type of spreadsheet format but has an updated, more user-friendly interface that looks less like a typical spreadsheet.

Figure 3: This shows a Panelboard Schedule using Microsoft Excel. Typical values calculated in this example are connected, demand, and design load for a specific panelboard. Courtesy: Primera Engineers

When Microsoft released the powerful Excel program in early to mid-1990s, companies took it upon themselves to create a large number of templates for calculation purposes. This helped them take control of and analyze the information the way they preferred. Another advantage of using Excel is the option to export spreadsheets into AutoCAD. Using DotSoft’s XL2CAD, a third-party software, an engineer can easily import Microsoft Excel spreadsheets into AutoCAD drawings (see Figure 2), and therefore saving the time it takes to type it into an AutoCAD text table.

In today’s world, spreadsheets are still very useful for tasks such as: panelboard schedules (to calculate connected and demand load; see Figure 3), reviewing metered information (to calculate sum, average, low and maximum values), and for service/feeder calculations. 

The majority of companies own Microsoft Office licenses, which includes Excel. As a result, using this software can be seen as a no-cost option. There are still companies that are hesitant to spend money on new software that promises to facilitate all their needs by a single click of a button. These companies have already spent years of effort creating all these spreadsheet templates and have mastered their use. Alas, most companies eventually encounter the frustrating task of updating calculation values when there is a design change.

For example, most of these spreadsheets are separate, so if the mechanical engineer changes the horsepower size on some of the project’s motors, the electrical engineer has to make these changes in multiple locations. In addition to updating all spreadsheets affected by these changes (panelboard schedules, equipment schedules, riser diagrams, service calculations), the engineer must update all files created and imported into the AutoCAD drawings. This is where sophisticated software can be a game changer.

<< First < Previous 1 2 Next > Last >>

JACOB , FL, United States, 12/11/13 08:11 PM:

Thank you Mr. Hernandez for your interesting article.
The softwares you have mentioned in the article are mainly used in power engineering. However, when you deal with Residential and Commercial occupancies, where the NEC must be applicable, those softwares are not useful since they don't take into consideration the multiple requirements of the Code. On the other hand, the available spreadsheets are not designed for commecial use (mostly, particular use), the application of the NEC is in many cases superficial, poor interfase, prone to errors when data has to be editted, limited to two or three tiers of feeders, etc.
My question is: Do you know a pro software package oriented to the application of the NEC whose purpose is the calculation of service/branch-ckts/feeders, taking into consideration demand loads, wire/conduit/busway sizes, OCP, different load types and occupancies, step-down transformers, etc., including a recap report of the input data and a report of the corresponding results?. Your assistance will be appreciated.
Thank you,
Jacobo Mendelovici
ANANTHA , Non-US/Not Applicable, India, 12/12/13 01:54 AM:

Interesting. Glad if a hard copy is got
The Top Plant program honors outstanding manufacturing facilities in North America. View the 2013 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
The true cost of lubrication: Three keys to consider when evaluating oils; Plant Engineering Lubrication Guide; 11 ways to protect bearing assets; Is lubrication part of your KPIs?
Contract maintenance: 5 ways to keep things humming while keeping an eye on costs; Pneumatic systems; Energy monitoring; The sixth 'S' is safety
Transport your data: Supply chain information critical to operational excellence; High-voltage faults; Portable cooling; Safety automation isn't automatic
Case Study Database

Case Study Database

Get more exposure for your case study by uploading it to the Plant Engineering case study database, where end-users can identify relevant solutions and explore what the experts are doing to effectively implement a variety of technology and productivity related projects.

These case studies provide examples of how knowledgeable solution providers have used technology, processes and people to create effective and successful implementations in real-world situations. Case studies can be completed by filling out a simple online form where you can outline the project title, abstract, and full story in 1500 words or less; upload photos, videos and a logo.

Click here to visit the Case Study Database and upload your case study.

Maintaining low data center PUE; Using eco mode in UPS systems; Commissioning electrical and power systems; Exploring dc power distribution alternatives
Synchronizing industrial Ethernet networks; Selecting protocol conversion gateways; Integrating HMIs with PLCs and PACs
Why manufacturers need to see energy in a different light: Current approaches to energy management yield quick savings, but leave plant managers searching for ways of improving on those early gains.

Annual Salary Survey

Participate in the 2013 Salary Survey

In a year when manufacturing continued to lead the economic rebound, it makes sense that plant manager bonuses rebounded. Plant Engineering’s annual Salary Survey shows both wages and bonuses rose in 2012 after a retreat the year before.

Average salary across all job titles for plant floor management rose 3.5% to $95,446, and bonus compensation jumped to $15,162, a 4.2% increase from the 2010 level and double the 2011 total, which showed a sharp drop in bonus.

2012 Salary Survey Analysis

2012 Salary Survey Results

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.