Method and apparatus for automating electrical engineering calculations

GOVERNMENT SPONSORSHIP

This invention was not made with Government support.

A portion of the disclosure of this patent document contains material that is subject to copyright protection. The copyright owner has no objection to the facsimile or electronic reproduction by anyone of the patent document or the patent disclosure as it appears in the Patent and Trademark Office patent file or records, but otherwise reserves all copyright rights whatsoever. The following notice applies to the software and data as described below and in the screenshots and drawing hereto: Copyright. 2001-2002 Electric Power Calc, Inc. All Rights Reserved.

BACKGROUND

Numerous software-based electrical power design systems are known for designing and simulating electrical power distribution network systems. In particular, software has been developed that models and assists with the design of large electrical power distribution facilities, i.e. facilities that distribute power on the power grids for regional areas of electrical power distribution. Such software may include simulation and design functions that assist in determining short circuit problems, load flows, transient stabilities, harmonics, arcing, power station management and other aspects of a large electrical power distribution system. Such software is typically data-intensive in that the user must have an intimate working knowledge and engineering expertise associated with the design and modeling of electrical power distribution systems to use the software. Operation of this software typically involves the user's entry of a significant body of data related to the intended system upon which the software assists in determining the system's design criteria. For example, design criteria for electrical power distribution network systems may include transformer sizes, transmission line wire sizes, transmission line phases and loads sizes, load flows, e.g. unbalanced load flows and voltage drop calculations, short circuit determinations, e.g. transient short circuit currents, interrupting duty calculations, and motor accelerations. Such detailed input is required to provide plots and graphical displays of power flows, and transient stability for the design and modeling of the electrical power distribution network system. Thus, due to the complex nature of large electrical power distribution network systems, the calculations performed by existing software are not typically automated. However, in certain aspects, the software may allow the designer to quickly identify problems and shortcomings of the intended electrical design based on the output from the software in combination with the electrical engineer's knowledge.

Other electrical system design software has been developed that provides a graphical means to lay out and model the performance of an electrical system. In particular, existing software provides assistance with the design of electrical systems within either power distribution environments associated with large electrical power plants or within buildings wherein the user will specify electrical requirement needs to be met and the software will provide related design criteria. Specifically, data related to the feeder circuits for a building or an electrical power plant may be provided to these software modules so that the engineer may manually determine the appropriate electrical characteristics of distribution panel boards (hereinafter all panel boards are referred to simply as “panels”) complying with the design intentions of electrical building system. This software may include modeling features that enable the designer to graphically lay out the electrical panel board and its associated electrical loads according to standard electrical diagramming symbol formats, for example, for inclusion on a schematic. Such software may also provide libraries of components for use in the generation and creation of these electrical diagrams. From the electrical system schematics and layouts created with this software, electrical system modeling and analyses may be performed once all the required electrical system components and performance characteristics are determined and provided by the engineer. Such required data may include power flow and voltage drop calculations, fault analysis options, demand load analysis, feeder and transformer sizing calculations, motor starting calculations, and other high-level electrical design criteria. Thus these software modules are specifically programmed to address the schematic layout needs, the generation of reports and the analysis and resulting performance of new or existing, pre-designed, electrical power distribution systems.

Still other electrical design and analysis software provides a more fundamental modeling and reporting output regarding electrical power distribution systems within a building. This software provides layout, reporting and analysis of a lower-level electrical circuit design, for example at the electrical panel distribution level and building circuit level. Such software to date, however, has been limited in that it has not provided a designer of such power distribution centers with a bottom-up approach to the specification and design of such electrical power distribution systems.

Thus the need exists for electrical engineering design software that automates the design of an electrical power distribution system on a circuit-by-circuit, bottom-up basis, while also ensuring that the resulting system is in compliance with electrical codes. None of the existing software for electrical system design allow the users of such software to input individual circuit data from which information and design criteria related to those circuits is automatically created and upon which the higher level electrical power distribution system information may be automatically generated. For example, none of the existing software is capable of taking user-input branch circuit information and automatically creating distribution panel board information there from. Further, the software should have the capability to automatically recalculate all design information according to particular design criteria and/or electrical codes, particularly when the branch circuit information is modified dynamically. Finally, all the above calculations should involve information related to the design specification and selection of branch circuit components such as branch circuit panel board sizes, circuit breaker sizes and wiring specifications as well as and including distribution panel board information related thereto.

SUMMARY OF THE INVENTION

According to one particularly preferred embodiment of the present invention, a general-purpose computer-based system is provided for designing an electrical power distribution system for a building. The system includes a standards database containing standards data associated with an electrical standard for buildings; an electrical node module for accepting a set of electrical connection data for an electrical connection that provides power from a panel board to another piece of electrical equipment, the panel board having a first voltage, the set of electrical connection data being provided by a module for the another piece of electrical equipment and including at leak a second voltage for providing power to the another piece of electrical equipment; wherein the electrical node module allows a connection between the panel and the another piece of electrical equipment based on a match between the first voltage and the second voltages; wherein the electrical node module detects a mismatch between the first voltage and the second voltage when the second voltage is changed by the module for the another piece of equipment, the electrical node module automatically calculating a set of transformer data associated with a transformer required for making the electrical connection between the panel board and the another piece of equipment The system may also be arranged such that the another piece of electrical equipment is one of another electrical panel or a building equipment; or the building equipment includes at least one of a fan, a heating coil, a pump, a compressor, a motor driven equipment, a transformer or an air conditioner; or the general-purpose computer-based system of claim 1 wherein the electrical standard for buildings is an electrical code; or the set of transformer data includes at least one of: a transformer size, a primary feeder voltage, a secondary feeder voltage, a primary feeder overcurrent protection device, a secondary feeder overcurrent protection device, and a ground conductor.

According to a particularly preferred method of the present invention, a method for designing an electrical power distribution system for a building using a computer-based system is provided including the steps of accepting at a panel board module a set of electrical connection data from a module for another piece of electrical equipment, the electrical connection data being used to specify an electrical connection that provides power from the panel board at a first voltage to the another piece of electrical equipment at a second voltage, the set of electrical connection data including at least the second voltage; allowing the electrical connection where there is a match between the first and second voltages; detecting automatically a mismatch between the first and second voltages when the second voltage is changed within the set of electrical connection data and specifying a set of transformer data for a transformer in response to the detected mismatch, the transformer data being specified in connection with a standards database containing standards data associated with an electrical standard for buildings, the transformer being required for making the electrical connection.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 is an overall block diagram of the software modules and database(s) according to one embodiment of the present invention.

FIG. 2 is a power one line diagram of an electrical power distribution system according to one embodiment of the present invention.

FIG. 3 is a partial power plan for one physical portion of a building served with electrical power from the electrical power distribution system provided in FIG. 2.

FIG. 4 is a screen shot of the branch circuit panel board module according to one embodiment of the present invention.

FIG. 5 shows a subset of the data within the database of the software system according to one embodiment of the present invention.

FIG. 6 is another screen shot of another branch circuit panel board module according to one embodiment of the present invention.

FIG. 7 is a screen shot of the distribution panel board module according to one embodiment of the present invention.

FIG. 8 is a screen shot of a building equipment module according to one embodiment of the present invention.

FIG. 9 is another screen shot of another building equipment module according to one embodiment of the present invention.

FIG. 10 is a screen shot of the main distribution panel board module according to one embodiment of the present invention.

FIGS. 11-15 show various other subsets of the data within the database of the software system according to one embodiment of the present invention.

FIG. 16 is a general diagram depicting the electronic transmission of electrical inventory requirements to a component supplier according to one embodiment of the present invention.

FIG. 17 is a screen shot of the eNode module according to one embodiment of the present invention.

DETAILED DESCRIPTION OF THE INVENTION

The present invention is a computer software package that is capable of automating the design and specification of electrical power distribution systems within one or more buildings or other structures. The method and apparatus of the present invention may be embodied in numerous software formats such as a Microsoft Excel spreadsheet or other data calculation tools, although persons of skill in the art would recognize the interchangeability of different coding methods by which to achieve the objects of this invention. Further, the software of the present invention may be coded in software in a number of different formats, including, for example, the spreadsheet described as the preferred embodiment herein, or as coded software modules programmed in C or HTML, for example. In one particular embodiment, an Excel spreadsheet is used to automate the electrical circuit calculations that determine the resultant electrical equipment within a building such that any changes to the lower-level electrical circuit specifications force a recalculation of all electrical specifications, including possibly a re-specification of necessary electrical equipment. The resultant changes are then automatically distributed throughout the remainder of the design of the electrical building characteristics and are reflected by changes in the overall electrical system design. One exemplary software package embodying the present invention is sold under the name Power Calc PaK by Electric PowerCalc, Inc. of Delray Beach, Fla.

Referring to FIG. 1, the electrical power distribution system design software 90 of the present invention includes a branch circuit panel board module 10, a building equipment module 20, a distribution panel module 30 and a main distribution panel 40. In one particularly preferred embodiment, each of these modules is displayed on separate spreadsheets within the program. With this functional arrangement, data input may be provided within a software module dedicated to the specification of one portion of an electrical circuit, the branch circuit panel board module 10 for example, and resultant changes calculated by that module may be passed to the other design modules for reinterpretation and re-specification of the overall electrical design. Also included within the software of the present invention are an overall project module, eNode 50, in which the user may enter overall project data related to the design of the electrical power distribution system Finally, the software system of FIG. 1 includes an extensive database 60 of electrical engineering design information that is supplied to the software modules for making calculations and specifying electrical components. Database 60 may include, among other things, engineering equations 2 and design data 4 related to the design of the electrical power distribution system, tables of electrical standards data 1, e.g. the National Electrical Code (NEC) standards data, and certain standard features 3 of the components of the electrical power distribution system, e.g. circuit panel board mounting type. Database 60 may also optionally include an inventory 5 of electrical components that may used to specify particular electrical parts and components to be used in the design of the electrical power distribution system.

In operation, data is entered by the user into each of the software modules such that a minimum set of electrical requirements needed to specify and define the electrical characteristics and elements of each module are provided by the user. This user-entered data is combined with and relies upon the engineering equations, design data and standards data contained within database 60 to calculate the remaining electrical power distribution system variables so as to fully specify a complete system. In this fashion, the design of the electrical power distribution system is specified in a bottom-up fashion. For example, users may first enter data into the branch circuit panel board module 10. From that data, related information is pulled from database 60, such as NEC data and engineering equations related to the specification of particulars operation of the branch circuit panel board. Then, the user-entered data and resultant, calculated data is automatically fed from the branch circuit panel board module 10 to the distribution panel board module 30. Thus, in an automated, sequential fashion, each of the software modules of the software of the present invention are functionally interconnected and interrelated so as to provide an “upward” data flow in specifying the design of the system. Likewise, as higher-level modules are defined by the data entered into lower level modules, certain design characteristics and criteria may also be fed back down to the lower level modules in further specifying the design of the electrical power distribution system. For example, data entered into the branch circuit panel board module 10 may be calculated within that module, fed up to the distribution panel module 30, at which point, additional calculations may be generated using the standards data and the equations within database 60, and from which, supplemental data may be transferred back to the branch circuit panel board module 10 from the distribution panel module 30 as shown by path 70. In this fashion, data flows throughout the software of the present invention so that user-specified input data at the lower level design modules, such as the building equipment module 20 and branch circuit panel board module 10, are transmitted and bubbled upwards while corresponding data is transmitted and bubbled downward so as to define and completely specify an electrical power distribution system for a building.

Referring to FIG. 2, the electrical power distribution system 100 that is automatically designed by the software of the present invention is shown. A plurality of branch circuit panels 110-112 are provided as shown in FIG. 2. These branch circuit panels boards may be the type located within a building's internal electrical closets, e.g. along walls, within a house garage, or within an electrical room in a commercial building. Branch circuit panel boards 110-112 provide power to individual branch circuits 115 to which they are coupled. Branch circuits 115 may consist of individual, end-use circuits, for example wall outlets within a building, as well as other varied electrical consumption circuits, e.g. lighting, dryers, and small air conditioners. Also shown on FIG. 2, larger electrical equipment, building equipment 120 and 130, and 173 and 175 is also provided for within the electrical power distribution system of the building. Building equipment 120 may include, for example, a large, air handling unit 120 and exhaust fans 130 supplied by the distribution panel board 150 and condenser unit 122 supplied by distribution panel board 150 (not shown in FIG. 3). The building equipment is typically fed through local circuit protection devices 134 which provide an electrical disconnect feature for the building equipment under electrical failure conditions.

Downstream electrical equipment and circuits, such as branch circuit panel board 110 and building equipment 120 through 130 are then fed to distribution panel board 150 via a plurality of feeder circuits 140-147. Distribution panel board 150 provides power to the branch panels and building equipment from the main distribution panel boards 180 (if provided or needed) further up the electrical power distribution system within the building. Distribution panel board 150 may also include feeder circuit protection 152-158 for each feeder circuit 140, for example, with the overcurrent protection devices (circuit breakers) within distribution panel board 150. Distribution panel board circuit breakers 152 through 158 may include various types of circuit breakers specifically tailored to the needs of the coupled branch circuit. For example, circuit breaker 155 shown in FIG. 2 is a 225 Amp, 3-pole circuit breaker provided as the overcurrent protection device for associated branch circuit panel board 112 along feeder 141. Likewise, circuit breaker 158 is a 20 Amp, 2-pole overcurrent protection breaker associated with building equipment 130 fed through feeder 147. In a similar fashion, each of feeder circuits 140 may be provided with certain electrical overcurrent protection elements within electrical distribution panel board 150.

In operation, distribution panel board 150 provides a 480-volt feed capacity to the plurality of downstream branch circuit panel boards 110-112 and building equipment 120-130. Often, downstream branch circuit panel board circuits and electrical building equipment operate at voltages lower than those provided by the distribution panel board. In such instances, step down transformers 160, 162 may be used within the feeder circuits 142/143 or sub-feeder circuits 148/149 to step down the voltage so as to accommodate the lower voltage. For example, branch feeder circuit 142 is shown as distributing power from distribution panel board 150 at 480 volts, which is stepped down to a 208-volt feeder 143 by step down transformer 162 to supply branch panel board 111 with the required voltage.

Also optionally included within distribution panel board 150 is transient voltage surge suppression system device 165. Transient voltage surge suppression system device 165 monitors and regulates the voltage levels within the distribution panel board 150 so as to suppress and control voltage spikes that are introduced within that portion of the electrical power distribution system by virtue of the operation of the branch circuits and building equipment. Likewise, transient voltage surge suppression system device 165 monitors the voltage arriving from up-stream electrical feeder circuits 170 so as to suppress downstream traveling voltage transients and insure the proper operation of distribution panel board 150.

At one of the highest levels of the electrical power distribution system upon which the software of the present invention operates is main distribution panel board 180. Typically, main distribution panel 180 provides voltage and current to a plurality of distribution panel boards 150 through feeder circuit 170. Similar to distribution panel board 150, main distribution panel board 180 may also include downstream electrical devices such as building equipment and other distribution panel boards for which the main distribution panel board supplies electrical power. For example, large building equipment such as an irrigation pump 175 or an elevator 173 may be connected through local circuit protection 187 and 184 respectively to main distribution panel board 180. Again, as with distribution panel 150, main distribution panel board 180 may contain overcurrent protection devices, or circuit breakers, that protect against electrical failures within the feeder circuits, the connections to the feeder circuit and the building equipment itself. Circuit breakers 182, 185, 188, 189, shown in FIG. 2, are examples of such circuit breakers. Main distribution panel board 180 is provided with electrical power from upstream service transformer 190 via feeder circuit 192 and through overcurrent protection device 194.

The electrical power distribution system within a building, as shown in FIG. 2, is typically provided power from the outside by a commercial power company. This commercial-grade power is delivered by primary feeder 196. Primary feeder 196 provides electrical power through service transformer 190 to main distribution panel board 180 within the building. In operation, the commercial power company provides electrical power at a significantly higher voltage than is required for the operation of branch circuits 115 within a building. For example, the outside power company may provide a 15-kV power feed which is stepped down by service transformer 190 to a 480 volt feed to main distribution panel board 180. From main distribution panel board 180, the electrical power is further distributed to distribution panel board 150 through feeder circuits 170. From distribution panels board 150, individual branch circuit panels 110-112 and building equipment 120-130 may be fed either directly with 480 Volts or indirectly by further stepping down the voltage to 208 volts or 120 volts, for example through step down transformers 160 and 162. Step down transformers may be used in this way throughout the electrical power distribution system of FIG. 2 so as to provide the required voltage at any point in the system. The power distribution system of FIG. 2 is, in general, well known and typical of the electrical power distribution systems found within buildings.

FIG. 3 provides the internal, electrical layout schematics of a building that is provided electrical power by the electrical power distribution system shown in FIG. 2. Within building 200 are numerous branch circuits and building equipment for which electrical power is needed. In particular, branch circuit panel board 111 is shown within an electrical closet in the top left portion of building 200. Branch circuit panel board 111 is the same as that shown on FIG. 2. As an example, branch circuit panel board 111 feeds electrical power to stove 117, also shown on the left side of building 200 and referred to in FIG. 2. Among the plurality of branch circuits fed by branch circuit panel board 111 are various electrical circuits within building 200. For example, these branch circuits may supply power through electrical outlets on the walls, on the building floor, within kitchen and dorm areas, and for any other electrical needs within the building. One particular branch circuit 215, FIGS. 2 and 3, serves electrical outlets on the floor of a multi-purpose room and are supplied electrical power by branch circuit panel board 111.

From a circuit design perspective, each of the branch circuits within building 200 of FIG. 3 includes a subset of specific and necessary design information related to that branch circuit. According to the software of the present invention, the electrical engineer/system designer begins the overall design of the electrical power distribution system of FIG. 2 by supplying this minimum subset of information for each of the branch circuits to be designed, thus beginning the design of overall electrical power distribution system at the “lowest level” branch circuits shown in FIG. 3. As each of the individual branch circuits' parameters are specified, the software of the present invention calculates and defines the electrical system requirements and specifies the electrical components required to hierarchically construct the associated branch circuit panel boards, distribution panel boards and main distribution panel boards. This is achieved by providing either or both of the user-specified values and subsequently calculated electrical characteristics from one level of the electrical power distribution system to the next for use in calculating its own variables. In this fashion, a bottom-up approach to the electrical design of the system is achieved by the software of the present invention. In one particularly advantageous aspect of the invention, individual changes made by the electrical engineer within a particular branch circuit cause the software to automatically re-calculate the variables needed by the upstream portions of the electrical power distribution system including changes to the branch circuit characteristics, the branch circuit panel boards and other upstream electrical distribution equipment. In a likewise fashion, the specification by the electrical designer of branch circuit panel boards 110, 111 and 112 may also be modified in a real-time basis, and the software of the present invention automatically re-calculates the electrical design parameters necessary to specify and define the upstream distribution panel and main distribution panel boards. Furthermore, the addition of electrical equipment after the “finalization” of a design does not necessitate an entire re-calculation of the loads and tolerances of the overall electrical distribution system. For example, adding a piece of building equipment will automatically cause the software of the present invention to re-calculate and modify as necessary the design and specifications of the electrical power distribution system and will likewise automatically flag errors that may result from the addition of such equipment.

Central to the operation of the software of present invention is the specification and definition of the load types for each of the branch circuits that are supplied by electrical power by the branch circuit panel board. By defining and associating a particular load type with each physical branch circuit, the software of the present invention defines an associated set of branch circuit variables that completely specify the electrical design of that particular branch circuit. For example, as shown in FIG. 3, branch circuit 215 consists of four, floor-based, electrical receptacles that are connected to branch circuit panel board 111 within building 200. For this particular receptacle cluster, the following branch circuit variables are needed to define that branch circuit: overcurrent circuit protection device size (i.e. circuit breaker size), conductor size, conduit size, ground conductor size, and voltage drop. Certain branch circuit variables are calculated automatically by the software of the present invention according to the load input for a particular branch circuit. For example, with respect to the branch circuit 215 of FIG. 3, the software of the present invention, following the user input of the maximum possible potential loads for the four electrical outlets, will calculate a maximum, permissible voltage drop for that branch circuit based on the engineering equations 2 and the design data 4 portions of database 60 (FIG. 1). From the total load calculated for that branch circuit and the permissible voltage drop, the software within the branch circuit panel board module will consult database 60 (FIG. 1) and select appropriately specified physical components for constructing the electrical power distribution system according to building standards data 1 within database 60. In particular and with respect to the four floor-based electrical outlets of branch circuit 215, the design data 4 portion of the database 60 is consulted to provide a maximum permissible voltage drop for the load type specified by the user (selected from a group provided by the software). The engineering equations 2 of database 60 are then used to calculate currents based on the user input information regarding the total load of the four outlets. This results in a calculation of the following branch circuit variables: a permissible length of a conductor or wire of particular size that may be used to electrically connect the four outlets, the actual ground conductor size used within that electrical circuit, the conduit size used to house the conductors and ground conductor, and the size of the overcurrent protection device (e.g. circuit breaker) needed within branch circuit panel board 111 to support that branch circuit load. In this fashion, the electrical circuit designer need only input end-use electrical requirements for a particular room, such as the number of electrical outlets, the specification of the building equipment, and other such load types, from which the software will automatically calculate the physical components needed to produce that circuit according to and in compliance with particular building codes, such as the NEC.

The physical presentation of the software according to the present invention will now be described with respect to FIGS. 4 through 10 which illustrate one particular embodiment of the present invention.

Referring to FIG. 4, an exemplary spreadsheet 310 illustrating one embodiment of the branch circuit panel board module 10 (FIG. 1) is shown. From a user-operability standpoint, the spreadsheet of FIG. 4 operates as any other spreadsheet in that it is programmed to either directly accept a user's data input within each of the required fields or is programmed to provide a drop-down box from which the user selects a particular value from one of the preprogrammed, pre-specified values. Equations and databases within the spreadsheet are also programmed and provided as part of the module so that other output cells in the spreadsheet automatically provide results based on the user input provided above.

In the example of FIG. 4, the branch circuit panel board spreadsheet embodies the characteristic electrical information for branch circuit panel board 111, identified as PNL LA in FIG. 2 and branch circuit panel label LA within panel board designation field 315. In operation, the user of the software activates the software to create an individual spreadsheet similar to that shown in FIG. 4 for the design of each of the branch circuit panel boards 110-112 within the electrical power distribution system. Certain fields within the branch circuit panel board module are populated by the user in advance of the specifying individual branch circuits so as to provide overall characteristics of the branch circuit panel board. These fields are indicated by the single line shaded areas within FIG. 4. Subsequently, individual branch circuit data are provided by the user so as to specify electrical characteristics of each of the individual branch circuit panel board circuits that comprise that branch circuit panel board. These fields are indicated by the circled cell values within FIG. 4. The operation of the spreadsheet with respect to the specification of overall panel characteristics will be discussed first.

In order to begin the specification of a particular branch circuit panel board, the user must first specify certain overall panel board information, or standard features, within spreadsheet header region 318. In particular, the value for the panel board field 315, shown as panel board LA in FIG. 4, is provided by the user. Subsequently, the user specifies a panel board mounting method 320, an interrupting ratings 322, an amperage interrupting capacity (AIC) rating 324, a branch circuit panel board phase 326, a phase-to-phase voltage 328, a mains rating type 332, a temperature correction factor 334, and a bus bar type 330. In addition, the user may also specify the presence of a transient voltage surge suppression system device 336, National Electric Manufacture Association designation (NEMA) 338, the presence of an isolated ground 340 and a neutral conductor rating 342. FIG. 5 illustrates one embodiment of this standard features data 3 within database 60. The data provided in FIG. 5 show exemplary values for each of the above-mentioned user-selected input data which may be programmed in the branch circuit panel board module as selectable, drop-down boxes within each one of the cells shown in the spreadsheet of FIG. 4. Following these initial user selections, other fields within header region 318 are automatically populated by the spreadsheet according to engineering equations 2 and design data 4 in combination with the previously described, user-specified input. Specifically, phase-to-neutral calculation 344 is made based upon the phase-to-phase voltage selected at 328. Still other information within header region 318 is calculated automatically by the spreadsheet, but these values are dependent upon the information entered by the user within spreadsheet center region 350.

Prior to the entry of branch circuit information, the different branch circuit load types must be defined by the software of the present invention. Central to the specification of each branch circuit, the spreadsheet of FIG. 4 provides the user with pre-defined load types as shown in spreadsheet analysis section 380. Each of the individual load types is identified by a single-letter designation in the macro field (MC) column 385 for which a description of the load type is provided in the description column 383. Analysis section 380 also provides additional load-related fields such as the load kVA 384, a default-demand factor, 386, the demand kVA 388 and analysis notes section 390. Several of the additional fields in the analysis section 380 are automatically populated with calculated values dependent upon spreadsheet data input by the user into center region 350. Other portions of the analysis section are pre-defined by the spreadsheet according to electrical standards data. For example, the default demand factor 386 is predefined, although this data may be overridden by the user in their specification to override the demand factor as shown in field 387. Further, a section is provided within analysis section 380 for engineer analysis notes as shown in 390 which is automatically populated by the spreadsheet of FIG. 4 depending on the loads used within the specification of the branch circuit panel board. The details of these populated fields will follow a discussion of the center region of spreadsheet 350.

As provided in FIG. 4, center region 350 of branch circuit panel board spreadsheet 310 is divided up and presented according to the actual physical layout of a branch circuit panel board used within the electrical power distribution system. In particular, the center region 350 of the spreadsheet of FIG. 4 is divided into three circuit panel board sections 400-404. Center section 400 graphically represents the three bus bars used for power distribution within the branch circuit panel board. In the particular branch circuit panel board of FIG. 4 shows a three-phase panel board with three different buses each carrying a different phase (A, B, and C) of the three-phase branch circuit. The center region 350 of the branch circuit panel board spreadsheet is further divided into two column groups, a right column group 404 and a left column group 402, with each row in the column groups graphically representing the actual circuit breaker connections to the load circuits within the branch circuit panel board. Left branch circuit panel board column group 402 identifies the odd number circuit breaker positions within the branch circuit panel board as identified by the circuit number identifiers shown in circuit number field 410. Similarly, the right branch circuit panel board column group 404 identifies the even numbered circuit breaker positions within the branch circuit panel board as identified by circuit number field 414. Thus, each line entry within center section 350 indicates an individual connection of a circuit breaker to one bus from the three phases within the central portion 400 of the branch circuit panel board. For example, branch circuit 1 in the left branch circuit panel board column group 402 enables a circuit breaker connection only to phase A of the center, three-pole bus structure. Likewise, branch circuits 3 and 5 in the left branch circuit panel board column group 402 only permit a circuit breaker to be connected to phases B and C respectively of center bus, three-pole bus structure. The branch circuits within right column group 404 of the branch circuit panel board function similarly. In this fashion, the layout of the spreadsheet mimics the actual, physical layout of the branch circuit panel board, thereby making it easier for installation personnel to correctly identify the proper circuit breakers and loads associated with a particular circuit breaker panel without the need for additional wiring diagrams or schematics that provide the same information as that contained on the branch panel spreadsheet.

Referring to center region 350 of the branch circuit panel board spreadsheet, the software user/electrical system designer specifies the characteristics of the desired branch circuits, by providing key data within the fields of center section 350. By way of reference, certain user input data within branch circuit panel board spreadsheet 310 is indicated by circled values within the spreadsheet cells. Other, calculated values are similarly represented by values within triangles around them within the spreadsheet cells. In particular, each branch circuit design may be completed by entering data within a single data line entry area, e.g. 351, to define that particular branch circuit within that associated branch circuit panel board. As shown at entry 351, corresponding to branch circuit 215 (LA-14) of FIG. 3, the designer defines branch circuit 215 by adding the power requirements or kVA of electrical loads within that circuit and inputs that sum in corresponding kVA field 355. In addition, the user specifies the load macro type for the circuit. The load macro type is defined as one of a pre-determined set of loads provided in macro field (MC) column 382 of the analysis section 380. In the example of branch circuit 215 of FIG. 3, the system designer selects macro type R for receptacle load and inputs that value into field 356 of line 351. In addition, the system designer specifies the number of electrical poles within the branch circuit as shown in the P field 358 of branch circuit entry 351. Once the necessary, user-defined fields are input, e.g. total kVA, load type, and the number of poles, the software of the present invention refers to the standards data 1, engineering equations 2 and the design data 4 within database(s) 60 to automatically calculate and determine the physical characteristics of the electrical equipment needed to fully specify and construct branch circuit 215 of FIG. 3.

As shown in FIG. 4, several output values are provided by the software of the present invention based on the above-mentioned inputs for branch circuit entry 351. The first calculated value is the circuit breaker trip value, shown in field 360 of branch circuit 351. In the example of branch circuit 351, the single pole, floor receptacle circuit having a 1.2 kVA load is determined to have a circuit breaker trip value of 20 Amps. Further, the spreadsheet automatically calculates and determines the following circuit characteristics using the engineering equations 2, standards data 1 and design data 4 within database 60: the wiring conductor size of #12 (AWG) as shown in the AWG field 362, the ground conductor size of 12 as shown in GND field 364, the conduit size of ¾ in. as shown in C (IN) field 366, the percentage voltage drop of 3% as shown in the % VD field 368 and the maximum run-length distance of 90 ft. for the branch circuit conductor to satisfy the percent voltage drop indicated as shown in the FT field 370. In this fashion, a complete specification of a particular branch circuit is automatically provided by the spreadsheet of the present invention following the identification and input of a minimum set of input electrical data, i.e. load value, load type and number of poles, from which the desired electrical circuit variables are determined.

To complete the specification of the branch circuit panel board, the electrical system designer/spreadsheet user continues to input the minimum required data within center region 350 for each of the plurality of branch circuits supported by that panel board. Following the input of the minimum set of data for each desired branch circuit, the remaining branch circuit variables are automatically calculated by the branch circuit panel board spreadsheet. As another example, the user may specify a branch circuit 117 for a stove 117 (FIG. 3) by entering specific data in lines 352-354. In the particular example of FIG. 4, the user specifies the total 3.0 kVA load in the kVA field 355 for each of the three different phases (branch circuits) associated with the stove. Further, the three-pole nature of the stove circuit is input on branch circuit line 352 in the P field 342, and the load type is identified as power load (P) in the macro field (MC) column 385. As with branch circuit 351, the branch circuit panel board module automatically calculates the circuit breaker trip value of 35 Amps with the wiring size of #8 AWG, a ground conductor size of #10 AWG, a conduit size of 1 in. and a percentage voltage-drop of 3%, resulting in a maximum run length of 92 feet.

After the user has input the necessary data for each branch circuit shown in center region 350, the software of the present invention provides a summation function and summarizes the information related to each of the different load types in analysis region 380. Specifically, all of the loads and associated branch circuits of a particular load type are summed and reported within analysis region 380 to provide a total kVA load for each load type. In the example of FIG. 4, lighting loads identified with macro code L in both macro field (MC) columns 385 and 356 show a total load of 9.0 kVA in column 384, which is a summation of all L-type loads within center region 350.

Depending on the default demand factor which is pre-specified by the software according to electrical engineering constraints and standards data, e.g. electrical code requirements, a demand load or kVA is calculated by the software for the purpose of creating and calculating a total load for the branch circuit panel board. In the case of lighting loads L, which are permitted to have a 125% demand factor, the total demand of 11.3 kVA is provided by the software. After calculating all of the total demand kVAs, the spreadsheet/branch circuit panel board module 10 of FIG. 1 sums the total demand of 58.1 kVA as shown at the bottom of analysis region 380 in demand kVA field 388. Optionally, the software enables a user to override the predetermined demand factors by entering an override value in field 387. Such an override would depend upon independently determined electrical design considerations which are often at the discretion of the user/electrical system designer responsible for designing a particular branch circuit panel board. Finally, the software of the present invention provides analysis notes 390 in analysis region 380 according to electrical engineering considerations associated with a particular load type. For example, if an inappropriate number of poles are selected for a particular branch circuit entry, then a note identifying the design error will automatically appear in the analysis notes section within field 390 associated with that particular load type. In alternative programming embodiments according to the present invention, the user may either be prohibited from or cautioned against further computations and advancement of the spreadsheet information until that error is rectified.

Once the total demand kVA is calculated within analysis section 380, this data is used to populate the fields within footer section 430 for other reporting purposes. In particular, the total calculated demand of 58.1 kVA from line 420 field 388 is presented in field 432 and from which is calculated the 161.3 total amperes required by the branch circuit panel board as shown in field 434. Also presented within footer section 430 are the total load (connected) of 56.7 kVA for the branch circuit panel board, as calculated in line 420 of field 384 and shown in footer section 436. From the total potential connected load, the total potential 157.4 amperes needed for the branch circuit panel board are calculated by the software and presented in field 438. Both the connected and calculated demand values are provided as an informational tool in aiding the system design engineer to provide data and to show local officials compliance with the associated electrical building codes.

Finally, the spreadsheet calculates the need for a step-down transformer, and if needed, will automatically calculate the minimum size step-down transformer required to provide the necessary amperes for the branch circuit panel board. In the example shown in FIG. 4, the calculated demand kVA is used to determine a step-down transformer kVA value of 75 kVA which provides a maximum demand amperage of 208.2, field 435. Once the step-down transformer size and the current carrying capacity of the step-down transformer has been determined, certain fields of header portion 318 within the branch circuit panel board module are determined to size the branch circuit panel board appropriately. As shown in FIG. 4, the step-down transformer requires that 208.2 amperes, field 435, be available which results in a minimum panel board mains rating value of 300 as shown in field 440. From this panel board mains rating, standards data and electrical codes are used to automatically determine and calculate values for the electrical conductor specification 350 AWG, field 442. Further, the #2 ground conductor size, field 444, the 3 ½ in. conduit size, field 446, the number of sets of wires, field 448, and the physical number of wires, field 450, are all determined or otherwise calculated. In addition, a 400 panel board frame size, field 454, a maximum permissible voltage drop of 2%, field 456, and a corresponding maximum conductor run length of 115 ft., field 458, are also determined or calculated by the spreadsheet according to the panel board mains maximum rating provided in field 440. Finally, based upon the conductor size provided in field 442, a calculated maximum feeder capacity of 310 Amps, field 439, is reported as the total feeder current capacity required for the feeder circuit associated with the branch circuit panel board of FIG. 4, i.e. feeder circuit 143 of FIG. 2.

As those of skill in the arts of electrical engineering and software programming will recognize, the software of the present invention provides an automated calculation mechanism by which individual characteristics of particular branch circuits within a particular branch circuit panel board may be easily modified. By altering one piece of input data, the associated calculations pertaining thereto and all subsequent determinations and calculations throughout the entire spreadsheet are repeatedly performed to provide a real-time output reflecting the updated input data For example, if an additional branch circuit is specified within the branch circuit panel board, then the corresponding loads, conductor sizes and all other associated physical electrical characteristics needed to create that branch circuit would be provided by the software according to the present invention. Further, the software would then revise the previously-calculated total load values, total demand load values, required panel board mains rating sizes, panel board frame sizes, etc. so as to further refine the specification of that particular branch circuit panel board. It is precisely this iterative, bottom-up, automated approach to the specification of both the individual branch circuit characteristics and the branch circuit panel board that has been heretofore lacking from software of other electrical engineering calculation software programs.

FIG. 5 provides an exemplary subset of the data contained within database(s) 60 including a number of the user-specified field and software determined/calculated fields as described above with respect to the branch circuit panel board module in FIG. 4. As an example, a listing of the various branch circuit load type values 505-507 is shown. These load types reflect those presented to the engineer/user in field 382 of FIG. 4. Various physical attributes of the branch circuit panel boards are also provided including mounting types, shown in field 320 and having values of “surface” (value 508) or “recessed” (value 509), and phase-to-phase voltage values, shown in field 328 and having values of 480V, 208V, and 240V. Similarly, the data shown in FIG. 5 and contained in database(s) 60 include all the various categories and corresponding values for many of the fields provided in FIG. 4. Further, these data categories include both user-selectable inputs, such as the load type, field 382, as well as program generated outputs, such as wire AWG, field 362. In addition, certain data fields, for example, panel board frame in field 455, may be set to be either automatically selected, i.e. the AUTO value 515 shown in field 455 of FIG. 5, or the user may override the automatic selection to specify one of the remaining values. As an example, the branch circuit panel board panel frame field 454 of FIG. 4 is shown as set to automatic in field 455 of FIG. 4. If the user/engineer so desires, he or she may set field 455 of FIG. 4 in the branch circuit panel board module to automatically select the appropriate panel board frame size based on the calculated panel board mains rating provided in field 440 of FIG. 4. These automatic calculations and selections are performed by the software of the present invention based on the engineering equations 2, and other data within database(s) 60. However, the user may also select one of the alternative, defined values within the database field 455 of FIG. 5 as the value entry for branch circuit panel board frame field 455 of FIG. 4, either by under-specifying the panel, e.g. a 250 Amp panel board shown as value 512 of FIG. 5, or by over-specifying the panel board, e.g. a 600 Amp panel as shown as value 514. According to one embodiment of the invention, these values are presented to and selected by the user in the form of drop-down boxes within the spreadsheet of FIG. 4. In this manner, and similar to other auto-selected fields, the user may either accept a pre-determined calculated value based on standard engineering calculations and electrical code data or may specify a user-selected value in contravention of the software's automatic selection.

Referring to FIG. 6, a second branch circuit panel board spreadsheet is provided, as part of branch circuit panel board module 10. The branch circuit data of FIG. 6 shows the data associated with an additional branch circuit panel board 110 of FIG. 2. With respect to branch panel board HA 110 as designated in panel board designation field 554, one of the user-specified fields within header 518, the phase-to-phase voltage field 560 has been selected to be identical to the voltage provided by the distribution panel board 150 of FIG. 2, i.e. 480 volts. As with branch circuit panel board 111, the spreadsheet of FIG. 6, permits the user to input various loads in center section 550 such that the branch circuit panel board module automatically calculates the total load kVA for that panel board and provides the corresponding branch circuit and branch circuit panel board characteristics necessary to carry that load. This panel board is unlike the branch circuit panel board 111 of FIG. 2 as further shown in 310 of FIG. 4 in which the phase-to-phase voltage of 208V, field 328, was different from the voltage provided by distribution panel board 150 of FIG. 2. In branch circuit panel board of FIG. 2, a step-down transformer, 162 of FIG. 2, is required on 480V feeder 142 to provide a 208V feeder 143 to the branch circuit panel board. The requirement for this transformer is populated automatically by the software branch panel board circuit module 310 as shown by the AUTO value in field 539 of FIG. 4. In contrast, a step-down transformer is not needed for feeder circuit 140 of FIG. 2 to provide power to branch circuit panel board 110, as reflected by the lack of a step down transformer determination field area in the branch circuit panel board shown in FIG. 6. Consequently, and unlike the determination made in the spreadsheet of FIG. 4 for branch circuit panel board 111, the panel board mains rating is directly determined by the software of the present invention from the calculated demand amperes needed to support the panel; in this case, 234.3 Amps, as indicated at 534 of FIG. 6, are determined to be needed, which results in a panel board mains rating of 300 Amps, being automatically selected by the program, as indicated at 547 of FIG. 6.

In a like fashion, the software of the present invention would include as many spreadsheets as necessary for defining each branch circuit panel board in the overall electrical power distribution system shown in FIG. 2, in addition to specifying the physical characteristics of the components needed to construct each of the branch circuits and branch circuit panel boards.

FIG. 7 provides an embodiment of the distribution panel board module 30 (FIG. 1) and the associated software. The distribution panel board module contains many of the same fields and associated calculations as presented in the branch circuit panel board module 10 in that the user specifies much of the same minimum subset of data related to the distribution panel board 150 of FIG. 2. This minimum subset of data may be the same or may be different from the minimum subset of data needed to specify each branch circuit depending on the electrical considerations in the design of the electrical power distribution system 100 of FIG. 2. For example, the load types shown in field 682 of FIG. 7, which are different from those in fields 382 and 582 of FIGS. 4 and 6 respectively, may require a different data subset which the software uses to determine the physical components necessary to construct the circuits that support those loads. Details of the minimum subset with respect to the particular example of FIG. 7 are provided below. Unlike the branch circuit panel board module, however, much of the minimum subset of data involved with the distribution panel board module of FIG. 7 is automatically transferred by the software from associated branch circuit panel board modules and values for corresponding circuit fields are automatically calculated based upon process described below. In this fashion, the design of the overall system is automated by the software and is performed on a “bottom level up” basis.

As with branch circuit panel board module, certain user-selected values are input to the distribution panel board module and are indicated by the shaded fields within the module of FIG. 7. In particular, the distribution panel board module consists of a header region 618, a center region 650, a footer region 630 and an analysis section 680. In the example shown in FIG. 7, panel designation DP 1 is used to designate distribution panel board 150 of FIG. 2 in panel board designation field 615. Similarly the user/engineer specifies other values for data field within header region 618 in defining the characteristics of distribution panel DP 1 which include: the mounting method 620, the interrupting ratings 622, the AIC rating 624, the number of phases 626, and the phase-to-phase voltage for the distribution panel board 628. Further, the user may specify a current temperature correction factor 634, a bus bar type 631, the presence of a transient voltage surge suppression system device 636, the NEMA designation for the distribution panel board 638, the presence of an isolated ground for the panel 640, and the neutral conductor rating 642. As with the branch circuit panel board module of FIGS. 4 and 6, data values from database(s) 60 may be presented by the software in the form of drop-down boxes from which the user/engineer selects the desired parameters. Similar to the discussion above, many of these fields may be automatically provided for by the software by selecting an AUTO value from a particular field within the spreadsheet. For example, the activation of AUTO selection field 655 of panel board frame 670 will result in the software automatically selecting an appropriate value for the panel board frame based on the NEC data and calculations presented in the spreadsheet, in this case the total calculated demand amperes, field 685. Alternatively, the user may override the automatic selection by selecting a particular pre-defined value from the database 60.

Like the branch circuit panel board of FIGS. 4 and 6, center region 650 is also laid out so as to mimic the physical configuration of the distribution panel board itself in that a center field 600 identifies the three bar buss for that distribution panel board to support the three-phased buses associated with the distribution panel board. Further, the left distribution panel board column group 602 contains data related to the circuit breakers associated with the odd circuit breaker positions within the distribution panel board. Likewise, right distribution panel board column group 604 provides for the even numbered circuit breaker positions within the distribution panel board for connection to the central bus. As a general rule, the inputs to each panel board supported by the distribution panel board are shown in circles. The general outputs from the distribution panel board are shown in triangles.

The data within center region 650 of the distribution panel board module is automatically populated by the software of the present invention directly from the data generated within each of the individual branch circuit panel board modules as shown in FIGS. 4 and 6. Again, inputs on any sheet are shown in circles, whether provided manually by the software user or by other portions of the design software. Likewise, outputs from any sheet are shown in triangles. For example, distribution panel board entry 654, as identified by the HA value in the load served field 661, is automatically populated with the information from branch circuit panel HA 110 as calculated in the branch circuit panel board spreadsheet of FIG. 6. In particular, the total calculated demand of 194.8 kVA, as shown in field 532 of FIG. 6, is input by the software into field 632 of FIG. 7. Likewise, the automatically-calculated data within the header of panel board HA is input by the software into distribution panel board entry 654 within the distribution panel board module, including the maximum conductor run length (237 ft. of field 557 of FIG. 6) in field 658, the percentage voltage drop (2.0% of field 556 of FIG. 6) in field 656, the number of sets of conductors (1 of field 548 of FIG. 6) in field 648, the quantity of conductors (4 of field 558 of FIG. 6) in field 651, the AWG rating of the conductors (350 of field 542FIG. 6) in field 642, the ground conductor size (4 of field 544FIG. 6) in field 644, and the conduit size (3½ in. of field 546 of FIG. 6) in field 646. In addition, the total panel board mains rating (300 of field 547 of FIG. 6) is provided as the electrical breaker trip value shown in field 647 within distribution circuit panel board entry 654. Similar to the branch circuit panel board module, the distribution panel board spreadsheet automatically calculates a total connected load values, field 684, for each of the different load types, field 682, based on the data imported from the associated branch circuit panel board modules. After calculating a default-demand factor for each load, field 686, which may be overridden by the user, a total demand of 502.5 kVA is calculated as shown in field 688. Similar to the analysis field of the branch circuit panel board modules, analysis notes may automatically be generated in field 690 by the software so as to notify the user of improper input or data for the branch circuit panel board or outputs from the distribution panelboards.

To complete the spreadsheet, fields within footer region 630 are calculated by the distribution panel board spreadsheet based on the data concerning the total connected loads and total demand loads 684 and 688 respectively. Specifically, the distribution panel board module uses the calculated demand kVA values to determine an appropriate ampere rating for the distribution panel board as shown in field 685. This value is then used by the distribution panel board module to calculate a panel board mains rating, 800 in field 660, according to the electrical standards data and other engineering calculations. As with the branch circuit panel board, this panel board's calculated amperes is then used to calculate and determine the other electrical characteristics and physical requirements of the distribution panel board, including the maximum conductor length, 421 ft. of field 698, the overall panel board frame size, 800 of field 670, the number of sets of feeder conductors, 3 of field 671, the number of feeder wires necessary, 4 of field 672, the AWG rating of the feeder wires, 300 of field 673, the ground conductor size, 2 of field 674, and corresponding feeder conduit size, 3 in. of field 675.

As a user-friendly feature of the software of the present invention, the capability exists to independently add additional branch circuit information on a circuit-by-circuit basis, apart from the automatic population of branch circuit data from associated branch circuit panel board modules. For example, the exhaust fan 130 of FIG. 2 is shown in circuit entry line 692 on the left-hand side of the distribution panel board module of FIG. 7. The data for this distribution panel circuit may be entered by the user by specifying certain minimum circuit characteristics such as the total load, value 2 kVA at 689, the number of poles for that circuit, value 2 at 694, and the load type, value M at 690. From this minimum set of information, just as with the branch circuit panel board module, the various electrical characteristics necessary to create that circuit that feeds the distribution panel board circuit are automatically calculated by the distribution panel board spreadsheet. In particular, the trip value 20 at entry circuit 692, the number of sets of conductors, 1 at 696, the number of conductors necessary for the feeder circuit, 3 at 695, the AWG rating of the conductors, 12 at 697, the ground conductor size, 12 at 698, the conduit size, ¾ in. at 699, the maximum allowable voltage drop, 2.0% at 693, and the corresponding maximum conductor length, 576 ft. at 691, are all calculated automatically by the spreadsheet based upon the user-input data In this fashion, the distribution panel board is more flexible in that it may accept data from other modules such as the branch circuit panel board module as well as independent, user-specified, circuit data.

Building equipment module 20 of FIG. 1 provides another example of a circuit to be included within the distribution panel board module 30 of FIG. 1. In the electrical power distribution system of FIG. 2, such building equipment may include air conditioning unit 120 which might draw power from distribution panel board DP 1150. FIG. 8 provides one spreadsheet embodiment 705 for calculating the electrical component specifications for connecting this building equipment. Specifically, the building equipment module includes header portion 718, a center region 750, a footer portion 730, and an engineer's notes section 780. In the header portion 718, certain user-input information is required to define the set of variables that permit the spreadsheet to calculate the remaining building equipment variables. This information is shown in the shaded fields in FIG. 8. In particular, the user must provide the distribution voltage, 480V at 728, and the distribution panel board designation to which the building equipment is to be connected, panel board DP 1 at 729. In addition, the user must provide the number of phases required by the piece of building equipment, 3 at 730. Further input by the user, are a building equipment identifier (Building Equipment Name) 715, which indicates the piece of equipment being added, in the example of FIG. 8. The user then specifies a component identifier for each piece of building equipment, e.g. the above-mentioned air conditioning unit AHU 1 of field 715, including the subcomponents thereof, e.g. a HEATING COIL and FANs 1-3 of field 707-710. Further, for each subcomponent (e.g. the HEATING COIL) the user/engineer specifies a load type, HTR of 756, the phase-to-phase voltage, 480V at 711, the number of phases, 3 of 752, and the total power required, 20 kVA of 753. Alternative specifications of the power required may also be provided for by the software, from which standard equations and calculations may be used to arrive at common units of electrical power. For example, the horsepower requirements for the FANs are input as the power requirement 754 from which the Amps required to run the fans are determined by the software from the data and standards information within database(s) 60. From all the input data, the software of the present invention consults database 60, including the building electrical characteristic codes and engineering equations, to determine the rated current capacity needed for each of the different elements as shown in NEC field 760. In addition, separate cooling and heating electrical loads may be calculated by the software based upon the ampere rating 760 of a subcomponent to accommodate different functioning modes of the various building equipment components. In the example of FIG. 8 FAN1 may be used for both heating and cooling cycles as identified in field 758 from which different electrical current requirements for different operative cycles are provided by the software in fields 762 and 764. Based upon this information, total calculated demand loads (in kVA) may be calculated for heating cycles, cooling cycles, or any other appropriate operative cycle for a building equipment element or subcomponent thereof as shown in fields 766 and 768. The building equipment module then sums all such power requirements to provide total cooling and heating cycle demand loads as identified in fields 769 and 770.

The above-calculated building equipment total demand loads are then used to populate footer portion 730 of the building equipment module. As with the branch circuit panel board module 10 and the distribution panel board module 30, footer region 730 is used to calculate and compare the final output electrical parameters needed to create the appropriate feeder circuit connections and overcurrent protection so as to properly connect the building equipment to the distribution panel board. In particular, the number of sets of conductors, 1 at 771, the number of conductors, 3 at 772, the feeder conductor size, 4 at 773, the ground conductor rating, 8 at 774, the conduit size, 1 ¼ in. at 775 and the fuse size for overcurrent protection, e.g., element 134 of FIG. 2, are automatically calculated by the building equipment module. Based upon different operating constraints of the building equipment, for example, whether cooling cycles or heating cycles are being accounted for, the building equipment module selects the most demanding requirements for the building equipment and appropriately selects output values for each of these calculated values according to the maximum load condition for the system. As shown in line 732 of field 775 of the footer portion, for example, the more rigorous standard of 1¼ inch conduit size will be selected by the module as between the cooling cycle conduit size, determined to be a minimum of 1¼ inches, and the heating cycle conduit size, as determined to be a minimum of ¾ of an inch. Likewise, other data within the building equipment module are populated along the RESULTS line. In alternative embodiments of the software, the fields in footer portion 730 may be programmable so as to be overridden by a user selection Finally, engineering analysis notes are provided in section 780 of the building equipment module that notifies the user of error conditions and possible warnings regarding the connection of the building equipment. Optionally, the software may be programmed to prevent further data entry if these errors are not corrected in order to continue the design process.

As with the branch panel board module data, the building equipment spreadsheet 705 provides its data to the distribution panel board module as shown in the distribution panel board spreadsheet of FIG. 7 at line 700 of the left distribution panel board column group 602. As described above, this data is used by the distribution panel board module to calculate the necessary electrical characteristics of the building equipment including the proper sizing and selection of electrical components needed to construct the associated feeder circuits.

Referring to FIG. 9, another example of a building equipment spreadsheet associated with building equipment module 20 of the software of the present invention is provided. Specific to FIG. 9, the data associated with condenser unit 122 of FIG. 2, as identified by the indicator CU 1815, is calculated and specified. Much of the data in this building equipment module is similar to that shown in FIG. 8 with respect to the inputs, calculations and the outputs provided. In particular, a minimum set of user-defined inputs are provided as needed to derive outputs populated as shown on results line 832. Further, these results are also fed back to the distribution panel board module of FIG. 7 as input CU 1 shown in field 829 of FIG. 7, for further calculation and specification of appropriate electrical components for distribution panel board 150 of FIG. 2.

FIG. 10 provides one embodiment of the main distribution panel board module 40 (FIG. 1) as a spreadsheet that which defines the electrical characteristics of the main distribution panel board 180 (FIG. 2). Main distribution panel board module 905 and its associated characteristics are very similar to those provided in distribution panel board spreadsheet 605 shown in FIG. 7. Specifically, the user/engineer inputs certain overall data into a header section 918 (shaded fields) which is used in conjunction with data fed from the distribution panel board spreadsheet(s), branch circuit panel boards, and building equipment, as fed into center section 950, so as to automatically calculate and provide the electrical specifications needed to create the connections for the main distribution panel board within the electrical power distribution system. Again, the layout of center section 950 mimics the actual physical layout of a main distribution panel board. Individual distribution panel board inputs, branch circuit panel board inputs and building equipment inputs are provided on a line-by-line basis within the main distribution panel board spreadsheet such that the main distribution panel board spreadsheet calculates and sums the total required demand kVA and amperes required for specifying the entire design of the main distribution panel board. As with the branch circuit panel board and distribution panel board specifications, analysis section 980 provides a list of selectable load types, which may require minimum subsets of input data different from those required for the branch and distribution panel boards to fully specify the electrical connections to the main distribution panel board. Analysis section 980 also provides and calculates default demand factors from which total demand loads are calculated. Analysis section also provides a section in which the software may provide automatic engineering warnings and announcements related to the various load types.

Similar to the discussion above with respect to branch circuit panel board 111 (FIG. 2), the software of the present invention may be programmed to determine the need for a service transformer 190 (FIG. 2) to connect the main distribution panel board 180 to the outside power primary circuit 196. Such a determination results from the voltage provided on the primary lines and a calculation of the total required amperes in footer section 930 of the main distribution panel board. Once the main distribution panel board module has calculated the appropriate service transformer size based upon the electrical engineering calculations and electrical codes contained within database 60, certain fields are automatically calculated within the header section 918, so as to fully specify the electrical design characteristics of the main distribution panel board. For example, as shown in FIG. 10, a panel board mains rating of 1000, field 960 has been determined as the minimum rating based upon a calculated service transformer value of 902.1 Amps calculated in field 934. Further, a panel board frame size, 1000 at 970, a maximum permissible voltage drop, 3.0% at 966, and a corresponding maximum transformer feeder conductor length, 323 feet at 998, are provided as outputs of the main distribution panel board spreadsheet. Further, the number of sets of conductors, 4 at 971, the number of feeder wires necessary, 4 at 972, the conductor size, 250 at 973, the ground conductor size, 2 at 974, and the conduit size for the transformer feeder, 3 in. at 975, are automatically calculated by the main distribution panel board spreadsheet. As such, the entire electrical specification of the physical and electrical parameters of the main distribution panel board may be provided to engineers and design personnel such that an appropriately sized main distribution panel board may be constructed and laid out according to building codes and accepted electrical engineering practices and equations.

Next will be described the series of steps performed by the software of the present invention in an exemplary calculation and determination of branch circuit variables and panel board value selections for a particular branch circuit. In these steps, numerous logical determinations, table look-ups and engineering calculations are required to be performed to make these determinations and further specify the physical characteristics of the electrical components of the branch circuit and feeder circuit. It should be recognized within this world of equations, electrical standards and programmed decision making, that much of the implementation of the software of the present invention results in design choices being made that are at the discretion of the engineer and software programmer. Thus while one particular programming embodiment is described below, an infinite variation of alternative implementations are possible. Further, it is impractical to provide more than one example of a sample branch circuit calculation given the numerosity of the logical determinations and equation solving performed by the software described in this application. In essence, the panoply of calculations, determinations, table look-ups and discretionary judgments that are automatically calculated and programmed within the software are well known to those of skill in the arts of electrical engineering and software programming and are not critical to the basic invention(s) herein.

Referring back to branch circuit 215 of FIG. 3, i.e., branch circuit LA-14 of building 200, is shown as having four floor-based electrical outlets or receptacles for which a branch circuit is to be created. As previously described and shown in the branch circuit panel board spreadsheet of FIG. 4, three independent inputs are required from the user of the software of the present invention in order to make the remaining electrical calculations necessary to describe fully the entire branch circuit. First, the user/engineer must provide a load type 356 of FIG. 4, in this case, a “receptacle load” identified by the designation R in load selection field 382. Second the user/engineer must specify the number of poles used by this branch circuit. With reference to branch circuit 215 at FIG. 3, a single pole circuit shown as being input in field 358 of FIG. 4. Finally, the user/engineer specifies the total kVA load of branch circuit 215 of FIG. 3. For the kVA load, the user must add the individual loads required by each of the four receptacles to obtain a total kVA. In the example of FIG. 4, a load of 1.2 kVA has been arbitrarily determined. Once this minimum set of three branch circuit variables has been input by the user, the software of the present invention automatically calculates the remaining characteristics needed to specify the physical, electrical components needed to create that particular branch circuit.

The data pertaining to branch circuit 215 of FIG. 3 is provided on circuit line 351 of FIG. 4 where the above-mentioned minimum user inputs are identified as circled values. Based on the user selectable input provided at field 351, the software determines that the single pole determination provided in field 358 requires two conductors, one hot and one neutral, to carry the current that completes branch circuit 215. The software provides this at field 363 in line 351 of branch circuit 215 in FIG. 4. Further, based upon the 1.2 kVA load and the user-specified single pole circuit, which necessitates a phase-to-neutral voltage of 120 volts as determined by the spreadsheet from the data shown at 344 of FIG. 4, it can be determined that a maximum of 10.0 Amps are required to be carried by branch circuit 215. This can be calculated from the electric power formula I=Electrical Load (kVA) times 1000/L-N Voltage (Line-Neutral) which is contained within the engineering equations library 2 of database 60. At this point, the software of the present invention refers to the trip rating table according to NEC standard 240-6, shown in FIG. 11. This table would typically be contained within the standards data 1 within database 60 in FIG. 1. From this table, the software determines that the inverse of 10.0 Amps results in a value that corresponds to a trip rating of 20 Amps, line 1010. This results in the selection of a 20 Amp circuit breaker for the branch circuit panel board to provide protection for branch circuit 215. Next, the electrical circuit size is determined based upon the previously determined circuit breaker size of branch circuit 215 and the user-specified temperature correction factor, field 334 of FIG. 4. Standard, values for the user-selectable temperature correction factors are provided in field 380 of FIG. 5. As shown in NEC table 310-16 provided in FIG. 12, a 20 Amp circuit breaker at 30 degrees results in the selection of a conductor size of 12, line 1110. This conductor size is also referred to as the AWG rating in NEC terminology. Although 14 is also an acceptable AWG rating, the particular embodiment of the software described herein is programmed to choose the more conservative value for circuit variables where a choice of more than one value is available according to the standard. The software of the present invention then automatically inputs the AWG value of 12 into field 362 of branch circuit line 351 (FIG. 4).

Next, the maximum conductor length is determined based on voltage drop selected by the user in field 456 of FIG. 4. According to NEC standards and good engineering practice, any particular stage of the electrical power distribution circuit of FIG. 2 may suffer a voltage drop of no greater than 5%. Thus if the user specifies a maximum of 2.0% voltage drop in the feeder to the branch circuit panel board, as selected by the user in field 456 of FIG. 4, then the software of automatically determines that a 3% voltage drop may be accepted within each of the individual branch circuits. Thus, the software automatically populates the voltage drop field 368 with 3.0% for each of the branch circuits. Once the maximum permissible voltage drop for each branch circuit is determined, the maximum conductor length for branch circuit 215 may be calculated by the software. In particular, the maximum conductor length is provided by the formula: L=VD×1000/2×R×I, where VD=voltage drop, L=conductor length, R=conductor resistivity, and I=load current. Since the maximum current capacity of the branch circuit conductor (10.0 A) and the maximum voltage drop (3.0%) have already been determined, the maximum conductor length can be determined by the software once the resistivity of the conductor is determined. In this regard, the software of the invention refers to NEC table 310-16 shown in FIG. 13 to determine that an AWG gauge wire of 12 at a temperature of 30 degrees has a maximum resistivity of 2.00, line 1210 of FIG. 13. It should be noted that the conductor resistivity is partially dependent upon the type of conduit in which the conductor is housed. This is reflected in the three different resistivities, one each for PVC, AL and steel, provided in NEC table 310-16 in FIG. 13. As mentioned above, the software of the present invention will make the most conservative determination in selecting circuit values where multiple choices are available. Thus, a maximum resistivity column is created within database 60 as shown in FIG. 13 from which all resistivites are selected. Thus once the resistivity is determined, the software calculates the maximum conductor length to be 90 feet which is displayed in the branch circuit panel board 310 at field 370 of line entry 351. Those of skill in the art will realize that this conductor length represents the maximum wire run length from the branch circuit panel board LA 111 in FIG. 2 to the farthest of the electrical receptacles in branch circuit 215.

Next, the ground conductor, size is determined by the software with the aid of NEC tables 250-66 and 250-122 provided in FIG. 14. According to precise adherence to the NEC code, two different tables are used to determine the proper ground conductor size depending on whether the ground conductor is to be used for the mains or service line or somewhere else within the electric power distribution system. In the example of branch circuit 215, the ground conductor determination is made with the assistance of NEC table 250-122. Further, the selection of a ground conductor size, like the power conductor determination above, is dependent upon the circuit breaker size, in this case 20. In addition, the ground wire conductor size is dependent upon the type of metal used for the branch circuit panel board bus bar, and thus the ground conductor wire. Thus, for branch circuit 215 having circuit breaker size 20, field 360 of FIG. 4, and a copper bus bar, field 330, the ground wire conductor size is selected by the software to be 12, line 1310 of FIG. 14. This is provided by the software in field 364 for branch circuit 215 on line 351 in FIG. 4

Next, the conduit size for the conductors is determined by the software based upon the number of conductors and the AWG rating of each conductor as provided above. Referring back to FIG. 13, the NEC code provides a cross sectional area for each conductor based on the AWG size of the conductor. For the 12 AWG hot and neutral conductors, line 1210 of FIG. 13 shows the cross sectional area of the conductor to be 0.0117 in. Commensurate with the conservative nature of the software of the present invention, one additional conductor cross section is added to the sum of the conductors' cross sections within a branch circuit as a safety margin for fit. Given the two conductors determined above, field 363 of FIG. 4, plus a third “safety conductor” the total conductor cross section is determined to be 0.0351. Based on the NEC rules and formulae for conduits, as provided in FIG. 15, the software determines that 1/(sum of the total conductor area/0.4) is 11.396 which results in the selection of a 3/4 in. conduit, line 1410. This selection is presented at field 366 in line 351 for branch circuit 215 of FIG. 4.

Once all branch circuits are specified as described above, the branch circuit panel board spreadsheet is completed by the software as follows. First, the branch circuit loads for each of the load types in field 382 are summed and displayed by the software in field 384 of FIG. 4. Second, each of the total loads values are multiplied by the default demand factor for that load type, field 386, to arrive at a total demand kVA for each load type, field 388 of FIG. 4. The default demand factors for particular load types may be selected by the software of the present invention according to standards data within database 60 or alternatively, may be overridden by the user/engineer. Third, the total demand kVAs are then summed to provide a final, total demand kVA for the entire branch circuit panel board, field 388. After calculation of the total demand kVA, for example 58.1 kVA of FIG. 4, the total demand kVA is provided by the spreadsheet within the footer region 430, field 432. The software then applies electrical power equations to arrive at the total number of amperes required for the branch circuit panel board, e.g. 161.3 Amps in field 434. For the engineer's reference, and strictly for the purpose of comparing the total possible connected load to the total probable demand load, the total, load kVA, unmitigated by the demand factor, is also calculated and presented in the footer region 430, e.g. 56.7 kVA at field 436. Depending on the presence of a step-down transformer, which may modify the total required amperes as shown at field 435 in the spreadsheet of FIG. 4, the spreadsheet then determines the total number of amperes needed by branch circuit panel board 111 and compares this to NEC tables to arrive at a main panel board rating. In the example of FIG. 4, the engineer and software have determined that a transformer is needed, see field 539, and the total required amperes are calculated to be 208.2 Amps. The next highest mains panel board rating of 300 (Amp), field 440FIGS. 4 and 5, is then selected by the software to support that particular calculated demand load.

Next, the software calculates a number of electrical characteristics involving the feeder circuits 143 of branch circuit panel board 111 of FIG. 2 based upon the total number of amperes by that panel board. These calculations result in the determination of feeder wire characteristics. Specifically, the number of sets of wires 448 of FIG. 4, the number of wires 450, the rating of the wires 442, the ground conductor size, 444 and the conduit size 446 respectively, are determined according to NEC tables and formulas similar to the previously described process involving the branch circuits. As is well known in the art, the determination of feeder circuit characteristics may need to be performed according to different NEC tables and codes, as well as different engineering calculations in arriving at the appropriate data, although many of the calculations are similar to those used to determine the branch circuit values. In addition, certain physical characteristics of the branch circuit panel boards are determined according to standard manufactured sizes, and not necessarily NEC-determined values. In particular, the panel board frame, field 454, is selected according to a table of standard manufacturer panel board sizes and in accordance with the calculated panel board mains rating and standard frame size formulas, field 440. Finally, the maximum length of feeder wire is calculated, field 458, to determine a maximum length of 115 feet for the feeder conductors to the branch circuit panel board.

Similar to the specification of a minimum subset of circuit variables for branch circuits, minimum subsets of circuit variables for a distribution panel board may be provided so as to fully define the electrical characteristics and physical electrical components needed to construct the distribution panel board and the associated feeder circuits. As shown in FIG. 7, e.g. line 654, the distribution panel board requires the kVA input of each of the individual feeder circuits from the branch circuit panel boards so as to calculate a total connected load for each of the different branch circuit panel board load types. In addition, distribution panel board 605, FIG. 7, sums each of the individual branch circuit panel board load types so as to arrive at a total connected and total calculated demand load, fields 684 and 688 for the distribution panel board. These calculations are performed in a manner similar to those calculated for the branch circuit panel board described above. From a total calculated demand load, e.g. 502.5, the total demand amperes are calculated, e.g. 604.4 field 685. As is known by those skilled in the art and similar to the analogous branch circuit panel board calculations illustrated above, the software of the present invention performs the additional calculations needed to arrive at the conduit sizing, panel board mains rating and maximum feeder length for the distribution panel board in accordance with NEC code and standard electrical engineering calculations.

One particular advantage of the software embodiment of this particular invention is that the output data created by the software may be exported to other software modules which provide analysis functions and other circuit determination functions so as to determine a proper operation of the circuit. While the present invention is focused on a bottom-up, specification of the components of an electrical power distribution system, an overall electrical circuit evaluation for each one of the individual branch and feeder circuits, as well as the main and distribution panel board operation, are adequately covered and well-known in the art. Those of skill in the art will appreciate that the data within this invention is easily exported from the spreadsheets of the current program and provided, for example in PDF format, to other standard programs that can perform electrical simulation analyses to determine the proper operation of the circuits and panel boards.

As a further advantage of the software of the present invention, and unlike any other heretofore known software, its output data consist of the physical specifications for the electrical components required to construct an electrical distribution system. As such, this specification of physical, electrical components, may be easily translated into standard inventory lists that are capable of being remotely transmitted to distribution warehouses so that the necessary electrical components are automatically delivered to a construction site. FIG. 16 provides one example of such an arrangement. For example, a user of the software system 90 may specify the minimum set of variables for each of a set of branch circuits, thereby constructing a branch circuit panel board according to the description given above. Once the conductor lengths, panel board sizes, conduit sizes and all other physical specifications for the electrical system components have been specified, actual electrical component parts lists 1505 may be generated by system 90, possibly with the aid of an inventory database 5 that may be part of database(s) 60, FIG. 1. This parts list may then be transmitted over the internet 1510, possibly through a web-based interface, directly to a supplier of electronic components 1520. At the suppliers, the received parts list may be correlated with the standard parts lists by the suppliers own computer systems 1530. These computer systems can them perform a check for the requested parts against existing inventory within the supplier's establishment 1540. As a result of this comparison, an inventory list derived from and fully-satisfying the list of needed electrical components may be generated to construct the electrical distribution system. Such inventories, for example, may be provided by standard electrical contracting houses, Home Depot, or other distributors of electrical equipment. Once the inventory list is created by the electrical component distribution company, the components may then be automatically picked and shipped to the desired location, or directly to the job site 1550. This direct delivery approach minimizes the time, effort and expense in generating independent inventory lists and reduces the lag time in constructing the actual electrical power distribution systems.

As an alternative to the electrical component supplier generating the inventory list, the electrical suppliers themselves may publish electronic inventories with prices. Users of the software of the present invention would then be able to download the inventory lists directly to their databases 60 so that standard component lists may be generated directly by the user/engineer. Price comparison among different suppliers would be facilitated with this arrangement since the user would be in possession of the end parts list of needed components.

As mentioned previously, the above-described panel board designs are typically used in the specification of the design of the electrical power distribution circuits found within a building. As each of the individual branch circuits are specified, the overall design of each branch panel is fully specified, and by derivation, subsequent higher order panels are also specified such as distribution panels and main distribution panels, all associated with the design of electric power distribution systems within a building.

It should be understood that in the discussion below that one particularly preferred embodiment of the present invention is described in the context of a spreadsheet program with associated software and worksheets performing the various tasks, via a single project workbook containing a plurality of worksheets. Those of skill in the art would realize that the calculations and data input and displays below could also easily be programmed within general programming modules coded in appropriate fashion to accomplish the same tasks and to provide the same results.

As provided in FIG. 17, the eNode worksheet 1610 is a worksheet that summarizes information from other worksheets and performs project-level calculation functions. In particular, global information about the project is kept in the eNode worksheet, for example region 1602. A plurality of project information, may be provided for, such as: the project name 1630, the project number 1631, any optional feature(s), region 1604, panel board data, region 1606, and building equipment data, region 1608. Typically, this data is automatically collected by the eNode worksheet for global use throughout the electrical engineering workbook, including panel board worksheets (FIG. 4 modules), distribution panel board worksheets (FIG. 7 modules) and building equipment worksheets (FIG. 8 modules). In practice, the user completes the input of this information, either directly in the eNode worksheet or through an information transfer from other worksheets that feed the eNode worksheet, and the eNode worksheet becomes the PROJECT FILE for the specific project. As such, the eNode worksheet lists the electrical nodes of the electrical power distribution system for the entire project. In one particularly preferred embodiment, an electrical node represents an electrical point of connection on the electrical power distribution system and the riser diagram associated with the electrical power distribution system.

Specifically, with reference to panels, the eNode worksheet extracts and imports data regarding the electrical power distribution system of the project and aggregates the information from all panel worksheets (i.e. branch, distribution and main) for inclusion the PROJECT FILE. In particular the eNode worksheet imports data regarding the panel board physical characteristics, panel board feeder size, panel board features, panel board load types and load capacity (typically in kVA), panel board connected loads, panel board demand loads, panel board transformer sizes, and panel board power flow. Likewise, the eNode worksheet automatically imports the characteristics of the building equipment feeder size, building equipment disconnect, building equipment enclosed circuit breaker, building equipment motor (MTR) starter, building equipment load (in kVA), building equipment demand load, building equipment transformer size, and building equipment power flow. From this, the eNode worksheet calculates total electrical loads per panel 1601, such as demand load 1680 and connectivity 1682, while also determining the need for and specifying the electrical requirements for a coupling transformer between panels or between a panel and building equipment 1681. Finally, the eNode calculates and displays the total loads by load type 1609.

The eNode worksheet operates as follows: First, the module identifies and retrieves relevant input from other worksheets involved in the design of the electrical power distribution system. Second, the module recognizes and controls the hierarchy of the panels, and building equipment, and reports for the design, Specifically, the worksheet performs a bottom-up arrangement and design of electrical nodes, from electrical equipment and branch circuit panel(s), to distribution panel(s) (if any), to main distribution panel(s) (if any). Specifically, the eNode worksheet analyzes input circuit details from the electrical equipment, branch circuit, distribution and main panel spreadsheet(s), and performs calculations to address the following circumstances in the hierarchical design of the electrical power distribution system within a building:

(i) checking for equivalent voltages connections between two panels, e.g. Panel (node) A feeding Panel (node) B, and permitting the connection if the voltages match;

(ii) checking for equivalent voltages connections between two panels, e.g. Panel (node) A feeding Panel (node) B, and upon determining a voltage mismatch, declining direct connection capability and performing calculations to specify an appropriate step-down transformer to accommodate the electrical connection;

(iii) checking for equivalent voltages connections between one panel and building equipment, e.g. Panel (node) A feeding building equipment (node) B, and permitting the connection if the voltages match;

(iv) checking for equivalent voltages connections between one panel and building equipment, e.g. Panel (node) A feeding building equipment (node) B, and upon determining a voltage mismatch, declining direct connection capability and performing calculations to specify an appropriate transformer to accommodate the electrical connection; and

(v) performing all necessary electrical engineering calculations to specify values for the electrical connection variables that define the electrical connection between nodes A and node B for any permitted connections, after which the eNode Worksheet communicates those values to the relevant panel worksheets.

In making the calculations and performing the analyses provided in (ii) and (iv) above, the eNode analyzes the panelboard hierarchy and determines whether a transformer is required due to different voltages between electrical nodes in the electrical power distribution system. In the particularly preferred embodiment of the invention provided in this description, the panelboard hierarchy is: building equipment<branch circuit panelboard<distribution panelboard<main distribution panelboard. By the preferred rules of the present embodiment, if any two electrical nodes operate on the same voltage, then eNode treats them as being in the in same hierarchy, i.e. each panel can feed the other without a transformer. If voltages are different between the electrical nodes, then a transformer is specified as part of the electrical connection between the two nodes to bridge the hierarchical order of the panels. A step up or step down transformer is determined by the feeding and receiving voltages, if a higher order electrical node is operating at a higher voltage than a lower order electrical node, a step-down transformer is specified; if a higher ordered electrical node is operating at a voltage less than that of the lower order electrical node, a step-up transformer is specified.

If required, a set of transformer data is calculated by the eNode worksheet such that the transformer will be fully specified and indicated as needed on the eNode worksheet 1681. The set of specified and calculated data for determining an appropriate transformer includes at least one of a electrical transformer size (kVa), a primary feeder voltage, a secondary feeder voltage, a primary feeder overcurrent protection device, a secondary feeder overcurrent protection device, and a separately driven ground conductor. The eNode selects an appropriate commercial transformer based on the set of calculated and specified transformer data with the assistance of the standards database. The need for the transformer is indicated on the eNode worksheet 1681 and will automatically be specified on the relevant panelboard spreadsheet. See e.g. 435, 539 in FIG. 4C. The feeder data so calculated are displayed in the eNode worksheets and exported to the respective panel and building equipment worksheets so as to override any data independently calculated by the individual sheets. The eNode indicates all this information on its summary page.

Third, the eNode worksheet performs calculations for and displays the cumulative load by load type throughout the entire power distribution system. Examples of cumulative loads by type include the total: receptacle load, lighting load, motor load, air conditioning, heating etc. Fourth, the eNode worksheet compares the result of its calculations to the electrical code standards in the database 1. And fifth, the eNode worksheet provides visual warnings, within the eNode worksheet and the panel or building equipment worksheets if the calculated values exceed the code standards.

In one particularly preferred embodiment, as shown in FIG. 17, the eNode Worksheet 1610 is divided into six (6) regions. Region 1602 of FIG. 17 displays general project data including the project name 1630, project number 1631, engineer name 1632, building name 1633, submittal date 1634, client name 1635, design phase 1636, building total area 1637, and current date 1638. These data are input directly by the user on other project worksheets and imported directly into the eNode worksheet.

As shown in region 1604 of FIG. 17, optional feature(s) data input areas are provided for the user. Such input capabilities include providing a section for mounting method 1641, AIC rating 1642, panel frame 1643, panel mains rating 1644, conduit size 1645, NEMA 1646, branch circuit breaker options 1647, Macro (Mc) 1648, load type 1649, interrupting ratings 1650, main circuit breaker (MCB) options 1651, TVSS 1652, and transformer (XFMR) 1653. Also in region 1604 of FIG. 17, two columns indicate hical kWH charges 1619 and hours per day 1621. Conceptually, the user enters the local kWH utility charges and also select the number of hours per day the facility will be used from the drop-down menu.

As shown in region 1606 of FIG. 17, summary data areas are provided for the panelboard electrical power load summary (in kVA). A panel boards section 1601 includes headers for eNode number and the “Electrical Enclosure/Panel board/Equipment/Device” 1610. Section 1603 provides regions for data input including line Voltage, phase, and mains. Section 1609 is labeled Load Type kVA and includes, RCPT (100% 1661 & 50% 1662) loads, LTG load 1663, HVAC heating load 1665, HVAC cooling 1666, spare load 1667, motor load 1660, PWR (power) 1664, other load 1669, and added load 1670. Region 1613, labeled Electrical Load, includes regions for calculated data by the eNode, i.e. demand load (kVA) 1671, XFMR 1672, and connectivity power flows 1673.

As shown in FIG. 17, three regions 1608, 1610 and 1612, all with labels including Electrical Power Load Summary (kVA), provide the power load summary for the building equipment, the distribution panel boards, and the main distribution panels respectively. Each of regions 1608, 1610 and 1612 includes input column regions 1601, 1603, 1609, and 1613 similar to those provided for the electric power load summary for the panelboards.

In operation, the User inputs general information in the eNode Worksheet about the Project, such as the Project Name, Project. No., Engineer's Name, Building Name, Submittal Date, Client Name, Design Phase, Building Total Area, and Today's Date. The workbook is programmed and designed such that this input propagates throughout the entire workbook across multiple, active worksheets. As an example and with respect to FIG. 4, this information input to the eNode module would be propagated from and input to corresponding respective data cells within region 430 of panel 310. With respect to FIG. 8, the top region of Building Equipment panel 705. When information input is completed by the user, the eNode module becomes the PROJECT FILE for the specific Project.

As illustrated at line 1601 in FIG. 17, the user may input the panel name in 1610 of FIG. 17 to start the design of the power distribution system. The system of the present invention is programmed such that the data entered into region 1602 will automatically populate downward (to lower level modules). In the alternative, the user may input the panel name in 315 of FIG. 4 panel 310. In this case, system of the present invention is programmed such that the certain data will automatically populate upward (to higher level modules) 1610 of FIG. 17 and vice versa. This process continues, in a data bidirectional fashion, for all the panels and equipment sheets used for the design of the electrical power distribution system. In sum, the eNode acts as a central data processing module for keeping track of the changes upward and downward within the power distribution system.

As provided in the programming within panel 310 of FIG. 4, after the user inputs all branch circuit loads into that panel and determines the voltage level (the hierarchy) of the panel, the eNode worksheet identifies and retrieves relevant input from across the design of the electrical power distribution system. In a particularly preferred embodiment, the following data from region 318 of FIG. 4 will be automatically identified when entered by the user, retrieved by the eNode worksheet and input to the corresponding cell within the eNode worksheet: phase datum 3 at 326, phase-to-phase Voltage datum 208 at 328, and panel mains rating datum 300 at 440. The following data from region 380 of FIG. 4 will be automatically identified when entered by the user or calculated by the lower level worksheet, retrieved by the eNode worksheet and input to the corresponding cell within the eNode worksheet: largest motor load datum [xxx], remaining motor load datum [xxx], first 10 kVA of receptacle load datum [xxx], remaining receptacle loads datum [xxx], lighting load datum [xxx], power load datum [xxx], climate control heating load datum [xxx], climate control cooling load datum [xxx], and other loads datum [xxx]. The eNode worksheet will automatically calculate, using the engineering equations 2 within the database 60, the total connected load, by load type, as displayed at line 1609 of FIG. 17. The same is true for all the remaining panel boards within the power distribution system.

The eNode module also provides certain error functions and industry average calculations that my assist with the specification of electrical nodes and the electrical connections between them. As one example, an error indication (“pop up”) may be programmed within the eNode module to identify for the user when the total rated capacity of any one specified panel is exceeded (i.e. the total amperage capacity of the panelboard is exceeded). Thus, a panel that is rated for 200 amps and is calculated within the eNode module as having a total connected load of 400 Amps is flagged within the eNode module and displayed both there and on the relevant panel spreadsheet for the user's attention. Likewise, voltage mismatches between a panel and its connected building equipment may be programmed for identification. The eNode may be programmed to monitor the building equipment utilization voltage and compare it with the electrical panel from which the building equipment is fed. The electrical connection between the two is only allowed if both the panel and the equipment utilization voltage are the same. If the voltages are different, the eNode can display a error indication (“pop up”) for the user to indicate that either or both of the voltages must be adjusted

The eNode may also check for and indicate other system errors, particularly those outside of the standards specification or as exceptions to the standards. These are may be flagged on the relevant spreadsheets for user attention as needed. Examples of such errors include: exceeding the number of single pole breakers in a double tub arrangement, a incorrectly double fed panel, an incorrect panel feeding hierarchy based on panel phases, and a selection of non-compliant voltages (specifically applicable to non-US standards).

As another feature, the eNode module may be programmed to calculate certain averages and provide a comparison to the relevant national or industry averages, possibly as provided by the standards database. As one example of this, the eNode may be programmed to retrieve all the connected loads by type from all the panels within a Project and display these totals per panel on the eNode worksheet. Then, the eNode may total all of the load types in all the panels and also displays load type per square foot. This total may then be compared to the national, industry or other designated average for that type of building. Finally, eNode may be programmed to indicate compliance or noncompliance with this average and provide a visual indication to the system user of the same.

As is well known in the art, the software of the present invention may be embodied in a number of formats, including storage on a hard disk drive, or imprinting onto a CD-ROM, floppy disc or ZIP drive. Alternatively, the software of the present invention may be provided on a web-based interface for download and use on either a project-by-project basis, or alternatively, as a repetitively useable fully-licensed software package. As appreciated by those of the skill in the art, modifications to existing electrical circuits may be easily updated once the software for the present invention is populated with appropriate data for existing electrical power distribution systems, thereby simplifying the addition of additional branch circuits and/or the expansion of the electrical system to additional branch circuit panel boards, distribution panel boards and/or main distribution panel boards.

Although various preferred embodiments of the present invention have been disclosed for illustrative purposes, those skilled in the art will appreciate that various modifications, additions and/or substitutions are possible without departing from the scope and spirit of the present invention as disclosed in the claims. In this regard, the invention of the present invention is not limited in any way in the use of any particular existing other heretofore developed standards data, design criteria, engineering equations or other data. Although the NEC has been used as an example throughout the specification, other existing standards may be used instead of, or in combination with the NEC data One such alternative standard is the SI (Standards International) system used in Europe. Further, different building standards and design data may be used such as the Canadian building standard.

	Number	Date	Country
	61260842	Nov 2009	US
	60380317	Oct 2001	US

	Number	Date	Country
Parent	10280610	Oct 2002	US
Child	12655040		US

Method and apparatus for automating electrical engineering calculations

Information

Publication Number

Date Filed

Date Published

Inventors

CPC

US Classifications

International Classifications

Abstract

Description

Claims

RELATED APPLICATIONS

Provisional Applications (2)

Continuation in Parts (1)