CIRCUIT BREAKER PANELBOARD WINDOWS EXCEL SPREADSHEET TO NFPA-70 UPLOADS AUTOCAD, US $55.00 – Picture 0

CIRCUIT BREAKER PANELBOARD WINDOWS EXCEL SPREADSHEET TO NFPA-70 UPLOADS AUTOCAD, US $55.00 – Picture 1

CIRCUIT BREAKER PANELBOARD WINDOWS EXCEL SPREADSHEET TO NFPA-70 UPLOADS AUTOCAD, US $55.00 – Picture 2

CIRCUIT BREAKER PANELBOARD WINDOWS EXCEL SPREADSHEET TO NFPA-70 UPLOADS AUTOCAD, US $55.00 – Picture 3

CIRCUIT BREAKER PANELBOARD WINDOWS EXCEL SPREADSHEET TO NFPA-70 UPLOADS AUTOCAD, US $55.00 – Picture 4

CIRCUIT BREAKER PANELBOARD WINDOWS EXCEL SPREADSHEET TO NFPA-70 UPLOADS AUTOCAD, US $55.00 – Picture 5

CIRCUIT BREAKER PANELBOARD WINDOWS EXCEL SPREADSHEET TO NFPA-70 UPLOADS AUTOCAD, US $55.00 – Picture 6

CIRCUIT BREAKER PANELBOARD WINDOWS EXCEL SPREADSHEET TO NFPA-70 UPLOADS AUTOCAD, US $55.00 – Picture 7

CIRCUIT BREAKER PANELBOARD WINDOWS EXCEL SPREADSHEET TO NFPA-70 UPLOADS AUTOCAD, US $55.00 – Picture 8

Circuit Breaker Panelboard Windows Excel Spreadsheet To Nfpa-70 Uploads Autocad

US $55.00

Middletown, Connecticut, United States
Jan 29th

Open on mobile:
QR code

BUY IT NOW Email Shipping Within 24-Hours Below is a complete description of this Excel spreadsheet. This Excel spreadsheet is a powerful tool for use by electrical engineering professionals working in the built environment. Written for 3-phase electrical systems under 600-Volts. This spreadsheet looks up, calculates and designs electrical wiring, overcurrent protection, voltage drops and bracing plus all other necessary calculations for 15,000 Amp Services to 15 Amp branch circuits. Revised over the past 15 years and shared with many colleagues. It is a serious design and production tool used many times throughout a project. It is n excellent spreadsheet just to open and make quick, reliability, code compliant calculations for sizing services, generators, feeders, loads and just about every other design calculation necessary. It is a production workhorse producing all the MDP, Distribution and Panelboard schedule for a project with updatable links from Excel to the drawings for quick accurate changes saving many hours of design and CAD work. Once appreciated users quickly rely on this spreadsheet for quick accurate code compliant solutions to their design and CAD work. If you fit the above description and decide to buy this spreadsheet I can email the 4.2 MB excel file free anywhere in the world as an attachment. I cannot take returns but do offer a satisfaction guarantee it is just as described and will support you using it for 30-days. Please examine the photographs carefully, read the description and answers to posted questions. Your firm’s panelboard schedule can be added to the spreadsheet after purchase to keep your drawings looking consistent. There is a schedule already in the spreadsheet and yours can be added. You can email a copy of your schedule to me and I will add it to the spreadsheet and send a new excel file back to you. ?The spreadsheet uses all Windows operating systems including Windows XP Windows 7 running Excel. The spreadsheet is written in Microsoft Excel 2010 and can be saved and used in earlier excel versions. The spreadsheet is saved as .xlsx macro enabled file. This spread sheet opens in 30 seconds or less depending on machine resources. Free support for 30-days vie email with prompt responses to all Inquires. Ask about incorporating your companies own panel schedules in spreadsheet for drawing Consistency. Please see full description below. Thank you for reading introduction. Full Excel Spreadsheet Description: This Excel spreadsheet is in use by a professional electrical engineer for the design and construction of hundreds of millions of dollars' worth of projects including high-rise offices, hospitals, university campuses, suspension bridges, railroads and many other types of electrical projects. The design criteria are based on NFPA-70. Originally developed in 1998 it is revised several times into this current 168-pole version developed in Windows XP using Microsoft Excel macro enabled software. It is a rather large and complex but reliable spreadsheet and will take from 25 to 30 seconds to open depending on your computer speed. This spreadsheet is remarkably intuitive to the professional user in that it is based on the concept that many electrical distribution systems are three-phase AC power from the generation station to small branches. Substation, switchgear, distribution panels and panelboards usually use three-phase bus and wire systems. This spreadsheet takes full advantage of many of the programming features of Microsoft Excel® to make it a practicable valuable tool. The spreadsheet is fully annotated with comments that appear with a hovering cursor that give a detailed description of how each feature operates. By having this spreadsheet available for use by the electrical team thousands of hours of design and CAD time has been saved especially in the design and construction administration phases of a project. It is also an excellent standalone tool for making small individual designs and calculations quickly, completely and accurately. There are many electrical professionals who have used this spreadsheet for their work including designers, engineers, electricians and CAD operators who are delighted it is available and have become reliant on it. The name of the original Excel file is panelboard.xlsx. Save the file with a different name as many times as necessary. Repeat the process for each MDP, distribution panel, panelboard and switchgear on the project. The sheet where all data is entered is called the form and is appears similar to an actual panel with updating calculations as each load design parameter is added. Enter into the panel form the design criteria and the spreadsheet fills in all of the values for each circuit. A well-organized and detailed Panel Schedule automatically creates on the schedule sheet. Print the schedule or copy and paste the schedule directly into an AutoCAD drawing. Paste the schedule “with or without” updateable links. If the links are updatable any changes made on the opened excel file will automatically update the pasted schedule on the AutoCAD drawing the next time it is opened saving many hours of CAD inputting. The schedules will print on the AutoCad drawing as if they were drawn manually. The worksheets and workbook are protected and the formulas and tables hidden and not editable to prevent accidently changing vital information. Only cells on the spreadsheet form that have a white background are available for data entry. This includes the dropdown boxes. 1. Directly enter user data into the white cells on the spreadsheet form or select data from a drop-down menu. Enter first values for all criteria in the white cells then the results will populate blue cells. Incorrect values or too many numbers will cause the cell with calculations to show ###### instead of the correct data. If this happens simply enter the correct value. 2. The Blue cells display vales calculated by the program. Blue cells do not accept user input. 3. Inactive Yellow Cells fill in the form and display messages. Yellow cells do not accept user values. Message examples that can appear in yellow cells are: Panel connection has no neutral such as a 208-Volt 3?/3-Wire and a 120-Volt load exists. “NO NEUTRAL” Nonstandard motor specified such as a 100-HP single-phase 120-Volt motor. “Unavailable motor horsepower” User determined data to select or enter onto the spreadsheet Form Panel Details Enter Accessories such as: TVSS, Isolated Ground, etc Enter percent to Oversize or Undersize the panel main circuit breaker 100% = as designed) Standard ampere ratings. Enter percent to Over/Under size the panel main bus. 100%=as designed. Standard industrial bus ratings Enter user data for Number of Poles to use. (1 through 168) Select 3-phase connection. 120/208/3?4W - 277/480/3?4W - 208/3?3W - 480/3?3W - 240/3?3W Select Panel mounting for information purposes. Flush Surface, Freestanding Select Panel Main. Main Lugs or Main Circuit Breaker Select Maximum fault time in seconds. (1, 2, 4, 8, 16, 30, 60, 100) Feeder Details Enter the length in feet of the feeder from power source to panel. Select copper or aluminum wire for the feeder wire. (CU or AL Select the insulation type for the feeder wire. (NFPA-70 Tables) Enter percent to over/under size feeder phase wire (100% = as designed Enter percent to over/under size feeder neutral wire (100% = as designed Enter percent to over/under size feeder ground wire (100% = as designed) Enter percent to over/under size feeder circuit breaker (100% = as designed) Enter available short circuit current in amps at feeder origination point. Branch Details Enter the length in feet of the branch from the panel to the load termination. Select copper or aluminum wire for the branch wire. (CU or AL) Select the insulation type for the branch wire. (NFPA-70 Tables) Enter percent to over/under size branch phase wire (100% = as designed) Enter percent to over/under size branch neutral wire (100% = as designed) Enter percent to over/under size branch ground wire (100% = as designed) Enter percent to over/under size branch breaker (100% = as designed) Enter available short circuit current in amps at Panel where each branch circuit originates. Enter number of poles used for each branch circuit breaker on the panel. (1,2 or 3) Enter the numeric value of the connected load. Select the value unit for the connected load. (“ ”, “Amps”, “KVA”, “HP” or “Spare”) Enter a Diversity Factor up to 100% for each branch circuit load. (100% means on continuously) Enter the Power Factor of the load connected to the branch. Select a Type of Load for each branch. Connected and diversified totaled on the schedule. Select from six load type choices: “Air Conditioning” “Existing Load” “Heating” “Lighting” “Receptacles” “Miscellaneous” Spreadsheet designed calculations displayed on the spreadsheet Form for the panel, feeder and branchs Panel Design Main circuit breaker trip in Amps from standard breakers. Panel Bus size in Amps based on industrial standard sizes. Panel bracing from industrial standard (withstand rating in Amps) Panel Main Circuit Breaker Trip from standard breakers. NFPA 240-6 Total connected KVA Total diversified KVA Percent diversity factor for all panel loads. Power factor for total panel loads. Total connected amps for each phase and neutral. (A B C N) Total diversified amps for each phase and neutral. (A B C N) Total diversity factor for each phase. (A B C) Total diversified KVA for each phase. (A B C) Feeder Design Voltage drop in feeder Number of paralleled sets of wires. (1 set is a single wire for each phase) Size of phase wires in AWG or kcmil. Size of neutral wires in AWG or kcmil. Size of ground wire in AWG or kcmil. Size of feeder conduit in inches. Size of feeder breaker trip in Amps. NFPA 240-6 Ampacity of designed feeder in Amps. Load side available short circuit current of feeder in amps. Branch Design Branch voltage. Ampacity of designed branch. Branch breaker trip in Amps. (Standard breaker trips from NFPA 240-6 Number of paralleled sets of wires. (1 set is a single wire for each phase) Size of the branch circuit’s phase wires in AWG or kcmil. Size of the branch circuit’s neutral wires in AWG or kcmil. Size of the branch circuit has ground wire in AWG or kcmil. Size of branch circuit conduit in inches. Voltage drop percent for branch circuit. Available short circuit current at branch circuit termination. Branch circuit phase (1 or 3) Connected load to branch circuit in KVA. Connected diversified load to branch circuit in KVA. Panel Schedule Many electrical construction projects have more than one panel whether it is a Main Distribution Panel, Switchgear, Distribution Panels or circuit breaker panelboards. Normally all panel schedules are saved on one or more drawings in the Electrical Set of drawings. It is convenient to save a blank original panelboard.xlsx file as the name of each panel you want to create. Enter values for the panel, feeder, each branch and loads connected to the panel. The Panel Schedule will populate and updated instantly with changes made on the Panel form. This schedule can be selected, copied, pasted and printed. Paste panel schedules into an AUTOCAD drawing with updateable links for future changes to the excel spreadsheet to carry over into the AutoCAD drawing. Copy and paste a Panelboard that is less than 168 Poles to the last poles used. AutoCad drawing will plot the properly pasted panel schedules to look like a Cad operator drew them in. Sometimes without elaborate paths specified each panel’s excel file must be domicile in the directory it is copied from and pasted into the drawings for the links in the drawing to find and update the AutoCAD drawing. This name and location must not change after pasting into the drawing in order for the updateable links to find it upon opening the next time. If the panel files location changes after pasting into an AutoCAD drawing you can update the path for the links to the new location of the panel schedule file from within AutoCAD. Save each Excel file with an intuitive name to recognize which panel and job it goes with. Thereafter as loads are added to or subtracted from a project and the changes are made in the appropriate Excel file form the AUTOCAD drawing will automatically be updated with the new information the next time the drawing is opened and can be plotted with all of the updates saving hours of CAD inputting and possible transfer errors. Thank You

Condition:	New: A brand-new, unused, unopened, undamaged item in its original packaging (where packaging is applicable). Packaging should be the same as what is found in a retail store, unless the item is handmade or was packaged by the manufacturer in non-retail packaging, such as an unprinted box or plastic bag. See the seller's listing for full details. ...	Brand	WINDOWS
Country/Region of Manufacture	United States
Model	EXCEL