User`s Manual - Durand & Associates
Contents
1. Page 7 TURNING ON AUTOMATIC UPDATING IN EXCEL Continued Go to the Tools menu and select Options Options Show M Formula bar I Status bar M windows in TaskBe Comments None Comment indicator only Comment amp indicator Objects Show all Show placeholders Hide all Page breaks if Row amp column headers Horizontal scroll bar Formulas v Outline symbols Vertical scroll bar 7 Gridlines v Zero values v Sheet tabs Color Automatic Select the Edit Tab Options Transition View Settings I Edit directly in cell M Extend list formats and formulas Allow cell drag and drop v Enable automatic percent entry Alert before overwriting cells T Move selection after Enter Uncheck the Ask Direction kihi to update automatic Fixed decimal links Places 2 M Cut copy and sort objects with cells M Ask to update automatic links M Provide feedback with Animation Enable AutoComplete for cell values Page 8 USING THE PROGRAM Select the FILE OPEN command and locate the 1 Line 2014 folder on your C drive Double click the 1 Line 2014 folder to display the contents EA Microsoft Excel Book1 DeEB828RrFr taag EI Ca Era 44 10 gt E Arial 10 ME File Edit View Insert Format Tools Data Window Help gt File name ae E My Network el Places Files oF type all Microsoft Excel Files 4 xds de her 4 htral Now display2. USING THE TABS The template has twelve 12 tabs 1449 H Input schedule f Calcs Directory Errors S Input Ready S Schedule S Calcs S Directory S Errors CopyPaste CAD The first five tabs are for the Panel and the second five tabs are for the Subpanel Each tab has a special purpose Panel Tabs Input This sheet is used to enter information Schedule This sheet is used to review and print the panel schedule Calcs This sheet is used to review and print load calculations Directory This sheet is used to review and print the circuit directory Errors This sheet is used to review and print the errors Subpanel Tabs S Input This sheet is used to enter information S Schedule This sheet is used to review and print the panel schedule S Calcs This sheet is used to review and print load calculations S Directory This sheet is used to review and print the circuit directory S Errors This sheet is used to review and print the errors Misc Tabs Copy Paste This sheet explains the Paste Values command for Excel CAD This sheet explains how to use the Copy Picture command and paste into a CAD program Page 25 USING THE XMFR PANEL TEMPLATES There are 24 XMFR panel templates X1 through X24 do not change the name of these files Each file links to the MSWBD file and forwards all the load calculations The XMFR panel files also read information from the MSWBD files It is best to have the M
3. ATS DISTANCE FROM MSMBD ENGINE GENERATOR GENERATOR SING KV OF GENERATOR GEN SET DISTANCE FROM ATS Auto Transfer Switch Select Yes or No Size of Transfer Switch Enter Amps ATS Distance from MSWBD Enter Distance in Feet Engine Generator Select Yes or No Generator Sizing Select Manual or Auto KW of Generator Enter KW Genset Distance from ATS Enter Distance in Feet Page 17 IDENTIFY CIRCUIT LOADS Use the pulldown menu to identify your circuit loads Panel When you choose Panel all load calculations forward from the Panel Template Xmfr When you choose Xmfr all load calculations forward from the Xmir Panel Template Space When you choose Space a space is shown on the 1 Line Spare When you choose Spare a spare circuit breaker is shown on the 1 Line Manual When you choose Manual you may input manual load on the M Loads tab and the M Feeders tab MCC May be selected for the first four 4 circuits C1 C2 C3 or C4 When you choose MCC all load alculations forward from the Motor Control Center Template MAIN SWITCHBOARD 4004 4004 460 277 WY THREE PHASE WYE MAIN BKR FUSED SWITCH 1004 3 POLE 604 3 POLE E 154 3 POLE i 1004 SPACE A Sener A A 30 50 15 50 1 4 EMT 1 1 1147 EMT 1 34 EMT 1 1 2 EMT 44500 THHN CU 4 CU 443 THHN CU 3 5 THHN CU 3414 RAW CU i TO UFER GND 1436 CU GND 1310 CU GND 1414 CU GND 449K NEC 250 66 B 15 4 K 0 0
4. VD 20 2 K 0 0 VD WAR 25 KWA ACWW 8 GND 26K 20 1 1 114 EMT 4 4 THHN CU 1 46 THHN CU N 1 48 CU GND 23K 0 0 VD PANEL SPARE or SPACE AMPS XP When you select SPARE or SPACE you need to select the amp rating for each Page 18 Spare or Space Size Amps IDENTIFY CIRCUIT LOADS WITH METERS SHOWN Use the pulldown menu to identify your circuit loads with meters Panel w m When you choose Panel w m all load calculations forward from the Panel Template PANEL WIM Xmfr w m When you choose Xmir w m all load calculations forward from the Xmir Panel Template Space wm When you choose Space w m a space 1 del ae Wy is shown on the 1 Line MCC W W Spare wm When you choose Spare w m a spare circuit breaker is shown on the 1 Line Manual w m When you choose Manual w m you may input manual load on the M Loads tab and the M Feeders tab MCC May be selected for the first four 4 circuits C1 C2 C3 or C4 When you choose MCC w m all load alculations forward from the Motor Control Center Template MAIN SWITCHBOARD 4004 MAIN BKR FUSED SWITCH 1004 3 POLE 60A 3 POLE 154 3 POLE 1004 SPACE O A AN A o A IA E 30 50 15 50 4 4 EMT 1 1 1 4 EMT 1 34 EMT 4 1 2 EMT 44500 THHN CU 4 CU 4 43 THHN CU 3 6 THHN CU 3 14 RHW CU ih TO UFER GND 1 8 CU GND 1 10 CU GND 1 14 CU GND 4 9K NEC 250 66 B 15 4K 0 0 VD 20 2 K 0 0 VD 2K 0 1
5. P17 xL5 2 P18 XL5 2 P19 XLS 28 P20 XLS SUPZ1 KLS 28 p22 xL5 p23 xL5 26 P24 XL5 MUXLALS 27 x14 XL5 28 7x15 XLS SM X16 XLS A Then click on OPEN When these files are open all linked formulas will update automatically Page 23 PRINTING LOAD CALCS If you want to print the load calculations click on the CALCS tab and use the FILE and PRINT command PRINTING THE 1 LINE lf you want to print the 1 Line calculations click on the 1 LINE tab and use the FILE and PRINT command You may want to use the PRINT PREVIEW command to make sure the 1 Line fits on the page If it prints on more than one page you may have to adjust the percentage under PAGE SETUP NOTE The 1 Line printout may produce additional blank pages CREATING PDF FILES If you wish to create PDF files of printouts you will need to have Adobe Acrobat lf you have Adobe Acrobat a El Microsoft Excel MSWBD Create Adobe PDF command appears under the FILE menu Ext File Edit View Insert Forme D O new Ctrl N Een Open Ctro ei Save Chrl s Save AS Page Setup Print Ctrl P yr hat Page 24 USING THE PANEL TEMPLATES There are 24 panel templates P1 through P24 Do not change the name of these files Each file links to the MSWBD file and forwards all the load calculations The panel files also read information from the MSWBD files It is best to have the MSWBD file open when working with the panel files
6. 3 Phase Delta 3Y 3 Phase Wye Hi Leg Size Select size from pulldown menu This option only appears when using a 3 phase delta service If you select AUTO the program will size the L2 Hi Leg to the load If you select FULL the program will size L2 the same as L1 amp L3 Neutral Size Select size from pulldown menu When MINIMUM is selected the line to neutral load must be identified with an N in the panel templates Hertz Enter Hertz Minimum Amps Enter the minimum amps The minimum amps is the smallest size allowed for the service If the load exceeds the minimum amps the program will automatically size the service to the correct size Page 11 GENERAL INFORMATION continued Minimum Amps L2 Enter the minimum amps for L2 This option only appears when using a 3 phase delta service and when AUTO is selected for L2 Hi Leg If the load exceeds the minimum amps the program will automatically size L2 to the correct size Minimum Neutral Amps Enter the minimum neutral amps This option only appears when AUTO is selected for neutral size If the load exceeds the minimum amps the program will automatically size the neutral to the correct size Factor Enter percent factor This factor is used two ways If you enter 20 the ampacity of the panel and conductors will be increased 20 You can also use this factor to correct for voltage drop Factor L2 Enter percent factor for L2 This option only ap
7. Manual par VIEW Arrange Icons By Refresh EIER Customize This Folder Paste Shortcut Undo Copy Chrl z File Edit Per gt Properties This will create a new folder titled Copy of Blank Page 5 RENAME THE FOLDER You can RIGHT CLICK on the new folder and ore select the RENAME command Search Sharing and Security Cl Winzip i Scan with AG Send To b UE Copy Create Shortcut Delete Properties File Edit Vie Qe F Back r Address m C v GO Type in your new project name C Your New Project Use this method to create a new project each time you start a new 1 Line Now that you have created a new folder close all windows Page 6 USING THE PROGRAM Go to your START MENU select ALL PROGRAMS and select EXCEL Mailloop b Microsoft Access Ed Microsoft Excel Microsoft FrontPage Se EE Microsoft Outlook This will start your Excel spreadsheet program TURNING ON AUTOMATIC UPDATING IN EXCEL Go to the Tools menu and select Options Ed Microsoft Excel Book1 Eile Edit View Insert Format Tools Data Window Help Ad ade ES E Customi CELIA Ca Share Workbook Track Changes Protection b Online Collaboration ot
8. o O Eu RA WIRETEMPC o SUBPRANELPHAS WIRELENGTH O Z O O o YO B Ss CoNDUTTYPE O Z OZO OoOO O UO OMT USTIA S O O mmm N O O III KITCHEN LOAI 0 E O o O O CA E SA MAINBERIFUS O OZ O O OO O O i y ONAM O A BREAKER SIZE N ENGEREN Yellow Cells Lime Green Cells Each unprotected yellow cell requires a user entry If an invalid entry is made a RED error message will appear to the left of the entry or an error message will appear in a pop up box When you select a cell a hint box will appear You may also use SHAY the pulldown menu THW CA THHN CA XHHW CA Page 27 GENERAL ENTRIES continued Below is a list of valid entries for the general information section of the panel schedule PANEL Enter the panel name such as LPA If entry is too long it may be cut off when printed As a general rule 22 characters are allowed OF CIRCUITS 30 Enter number of circuits Even number from 6 to 84 or use the pulldown menu PHASE 3Y Enter phase Note You may put a 1 Phase panel on a 3 Phase source HI LEG SIZE AUTO Select Auto or Full 3 Phase Delta Only NEUTRAL SIZE AUTO Select Auto or Full mb Most of the time you will select Full and the neu tral conductor will be sized the same as the line conductor If you select auto you must identify each line to neutral circuit with a N on the panel schedule MIN NET AMPS You may enter zero and the program will calcu late the
9. 1 Line 2014 Load Calculation Software Copyright 2013 Durand amp Associates Page 1 enuen sasn 1 LINE 2014 COPYRIGHT 2013 DURAND 8 ASSOCIATES This software and manual are protected by Federal Copyright Laws and may not be copied or duplicated for the purpose of resale or distribution A registered user may copy the template files for their own personal use provided they retain sole possession of such copies The 1 Line 201 4 software is aspreadsheet template software program for calculating main service switchboard subpanels feeder sizes and 1 Line drawings This program may be used for industrial and commercial loads The 1 Line 2014 software is for reference purposes only and Durand amp Associates cannot assume any responsibility for the accuracy of the program contents In using this program the user agrees to hold harmless and wave all claims against Durand Associates SOFTWARE REQUIREMENTS 1 Line 2014 was created with Microsoft Excel 97 To use these templates you must have Microsoft Excel Version 97 or later installed on your computer If you are using Excel 2007 or later please use the 1 Line folder C 1 Line 2014 Excel 2007 Page 2 INTRODUCTION The 1 Line 2014 software is a spreadsheet template program The program was designed for use in conjunction with Microsoft Excel on the Windows platform The program should also work on other platforms that can read and write Microsoft Excel 97 file forma
10. CU AL Select Type Wire Type Select Type Wire Size Select Size Wire Size Hi Leg L2 Select Size This option only appears in the 3 Phase Delta Mode Neutral Size Select Size Conduit Type Select Type Number of Conduits Enter Number Page 14 SERVICE ENTRANCE FEEDER OPTIONS MANUAL 8 BUSWAY When MANUAL and BUSWAY are selected the following will be displayed Overhead Underground Select Method Conduit Busway Select Method Busway Length Enter Busway Length Busway Size Select Size Busway CU AL Select Type FAULT CURRENT CALCULATIONS NONE Select Method Select Method Page 15 FAULT CURRENT CALCULATIONS UTILITY TRANSFORMER INFINITE BUS Faut Current Calculations for Incoming Power SELECT METHOD UTILITY TRANSFORMER INFINITE BUS UTILITY VOLTAGE ADJUSTMENT 1 1 TRANSFORMER KWA 350 0 TRANSFORMER 552 RATING 5 0 PRIMARY WOLTAGE 13 200 Use this method when the Available Fault Current is not known and the transformer KVA is known Select Method Select Method Utility voltages may Utility Voltage Adjustment Enter 1 0 or 1 1 vary 10 For power Therefore For Transformer KVA Enter KVA worst case conditions l enter 1 1 as the utility Transformer Z Rating Enter Rating voltage adjustment FAULT CURRENT CALCULATIONS TRANSFORMER KNOWN AFC Use this method when the primary fault current is known and the transformer KVA is known F
11. Line drawing Show Ufer Ground Yes No If YES is selected Ufer ground will appear on the 1 Line drawing Show True Phase Connection Yes No If YES is selected directories and panel schedules will display actual phase SERVICE ENTRANCE FEEDER OPTIONS AUTO When AUTO is selected the following will be displayed Service Entrance Feeder Options SERVICE FEEDER SIZING WIRE TYPE WIRE CUAL WIRE TEMP E WIRE LEMSTA 20 CONDUIT TYPE EMT OVERHEAD 1 UNDERGROUND OVERHEAD Service Feeder Sizing Select Method AUTO Program will automatically size service entrance conductors When load exceeds 1200 amps the MANUAL method must be used MANUAL You enter the conductor and conduit sizes NONE No service entrance conductors will be shown Wire Type Select Type Wire CU AL Select Type Wire Temp C Select Temp Wire Length Enter Wire Length Conduit Type Select Conduit Type Overhead Underground Select Method Page 13 SERVICE ENTRANCE FEEDER OPTIONS MANUAL amp CONDUIT When MANUAL and CONDUIT are selected the following will be displayed OVERHEAD 1 UNDERGROUND CONDUIT BUSWAY CONDUIT LENGTH CONDUIT SIZE WIRE CUAL WIRE TYPE WIRE SIZE L1 amp L3 WIRE SIZE HI LEG L2 WIRE SIZE NEUTRAL CONDUIT TYPE NUMBER OF CONDUITS Overhead Underground Select Method Conduit Busway Select Method Conduit Length Enter Conduit Length Conduit Size Select Size Wire
12. SWBD file open when working with the XMFR panel files USING THE TABS The template has twelve 12 tabs Bl N eee eee 44 PI S Input S Schedule s Cales S Directory f S Errars Y CopyPaste ACAD re The first five tabs are for the Panel and the second seven tabs are for the Subpanel Each tab has a special purpose Subpanel Tabs S Input This sheet is used to enter information S Schedule This sheet is used to review and print the subpanel schedule S Calcs This sheet is used to review and print subpanel load calculations S Directory This sheet is used to review and print the subpanel circuit directory S Errors This sheet is used to review and print the subpanel errors Misc Tabs Copy Paste This sheet explains the Paste Values command for Excel CAD This sheet explains how to use the Copy Picture command and paste into a CAD program Page 26 GENERAL ENTRIES Some cells in the template files are protected You may only enter information into certain cells If you are using a color monitor these cells are yellow or lime green FANEL P N AFC CALCULATION METHOD AUTO FED FROM MAIN SWITCHBOARD ENTE BEE OF CIRCUITS ar E HIVOLTAGE O Z OZ O O O O O aso AFCATTHISPFANEL CA LowYoLTAGE O OY am FEEDER _ PHASE loa O NUMBER OF CONDUITS SS a AUTO WRESZE O O O O qe MINNET AMPS CT SC WESEL CSS GMDOWBREN O Z O Z O Z O O O MESE WIRETYPE O THH WIRESIZENEUTRAL CS WBECWAL O OZ OZ OoOO O O Oo
13. VD VAY PANEL 25 KVA P NA 8 GND 26K 20 4 1 1 4 EMT 4 4 THHN CU 1 46 THHN CU N 1 48 CU GND 23K 0 0 VD PANEL xP Page 19 IDENTIFY OVERCURRENT DEVICE Use the pulldown menu to identify your overcurrent device Breaker 1004 3 POLE Fuse FUSED SWITCH 1004 3 POLE Page 20 MANUAL LOADS lf you select MANUAL you may enter the load and feeder information on the M Load tab and the M Feeder tab M Load Tab Loana Joiscommect 1 Fuse 20 M Feeder Tab ee fj eao thn j cu f 8 Page 21 LINKED FILES The MSWBD file and all Panel files are linked back and forth File links are only updated when the files are open lf the file is closed and information is change the closed file will not update formula calculations When this happens a link update color of orange will appear on your MSWBD template Example Circut Loads UPDATE SPACE SPARE SPACE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE To avoid this you may want to open all active files SEE NEXT PAGE Page 22 OPENING MORE THAN ONE FILE Let s say you have a main switchboard and 6 panels 1 Start your Excel program 2 Select Open 3 When the files appear use the mouse to select the MSWBD files and P1 P6 files pen r 12 XL5 28 P13 xL5 3 p14 xLs S P15 xL5 20 P16 XLS 2
14. ault Current Calculations for Incoming Power SELECT METHOD TRANSFORMER KNOWN AFC AVAILABLE FAULT CURRENT 42 000 UTILITY VOLTAGE ADJUSTMENT TRANSFORMER KWA TRANSFORMER 9 20 RATING 0 PRIMARY VOLTAGE 13 200 Select Method Select Method Available Fault Current Enter AFC T lity voltages may Utility Voltage Adjustment Enter 1 0 or 1 1 atv 10 for power Therefore for Transformer KVA Enter KVA en Transformer Z Rating Enter Rating Sal ae Bellen Primary Voltage Enter Voltage Page 16 FAULT CURRENT CALCULATIONS NO TRANSFORMER KNOWN AFC This is the most common method and should be used in most projects Use this method when the utility provides the Available Fault Current Even if there is a utility transformer most utilities will give you the fault current on the secondary side and you should use this method Faut Current Calculations for Incoming Power SELECT METHOD NO TRANSFORMER KNOWW AFC AVAILABLE FAULT CURRENT 42 000 UTILITY VOLTAGE ADJUSTMENT 1 1 Select Method Select Method ma vary 10 For Available Fault Current Enter AFC BOWE Te ete el worst case conditions Utility Voltage Adjustment Enter 1 0 or 1 1 Etre ete eure voltage adjustment AUTOMATIC TRANSFER SWITCH amp ENGINE GENERATOR Automatic Transfer Switch amp Engine Generator Located at Circuit Position 21 AUTOTRANSFERSVMIT CH YES TRANSFER SWATCH SIZING SIZE OF TRANSFER SWITCH LAMPS
15. calculations VD Calcs This sheet is used to review and print the voltage drop calculations MCC 1 Line This sheet is used to review and print the MCC 1 Line Page 36 GENERAL INFORMATION General Information AVAILABLE FAULT CURRENT WIRE TYPE WIRE CUAL MCC Name Enter the name of the MCC Fed From Enter the power source for the MCC Of Circuits Enter the number of circuits 1 20 Phase Select the phase from the pulldown menu 1 1 Phase 3D 3 Phase Delta 3Y 3 Phase Wye Minimum Amps Enter the minimum amps The minimum amps is the smallest size allowed for the service If the load exceeds the minimum amps the program will automatically size the service to the correct size Ground Wire Select YES or NO Wire Type Select wire type Wire CU AL Select CU or AL Wire Temp C Select 60 75 or 90 Wire Length Enter the length of the wire Conduit Type Select conduit type Factor Enter percent factor This factor is used two ways If you enter 20 the ampacity of the MCC and conductors will be increased 20 You can also use this factor to correct for voltage drop Main Disconnect Select BREAKER FUSED SWITCH or NON FUSED SWITCH Page 37 MOTOR INFORMATION Enter motor Select Select Select Select of description Phase Motor HP Overcurrent FLA for Protection Overcurrent Protection Enter Select Select Select Select Select Select Conduit Conduit Wire CU o
16. ed are two folders 1 Blank 2 Your New Project This is the folder you just created Page 9 EXPLORING THE SAMPLE PROJECT Double click on the YOUR NEW FOLDER to display the contents has XLS 28 x19 xL5 28 x20 XL5 26 21 XL5 20 x22 xL5 3 x23 xL5 MM x24 xLs Files of type All Microsoft Excel Files d ds 2 xt htm html The files in this folder are MSWBD P1 P24 X1 X24 and MCC 1 4 MSWBD Main Switchboard P1 P24 Panels X1 X24 Transformer Panels MCC 1 4 Motor Control Centers DO NOT RENAME THESE FILES This will corrupt the files Page 10 WORKING WITH THE MAIN SWITCHBOARD MSWBD Double click on the MSWBD file to display the Main Switchboard Template This may take a few seconds to open as Excel updates the links to the Panel files 1 Line 2009 Version 9 04 Copyright Durand amp Associates Main Switch Board CODE YEAR 2008 General Information PANEL NAME MAIN SWITCHBOARD FED FROM SERVICE OF CIRCUITS 4 HIGH VOLTAGE 480 LOW VOLTAGE 277 ay FULL 60 350 0 MANUAL 400 AFTER CT GENERAL INFORMATION Code Year Select 2002 2005 2008 2011 or 2014 Panel Name Enter the name of the Main Switchboard Fed From Enter the power source for the Main Switchboard Of Circuits Enter the number of Panels 1 24 High Voltage Enter high voltage Low Voltage Enter low voltage Phase Select the phase from the pulldown menu 1 Phase 3D
17. er Y the program will size the main breaker If this is a 3 phase delta panel with a reduced size hi leg L2 the program will size overcurrent protection using fuses SUB PANEL BKR 3 PHASE Select choice from pulldown menu If you want a subpanel fed from this panel select 1 Phase or 3 Phase BREAKER POSITION 1 3 5 If you have a subpanel select the breaker position from the pulldown menu Page 29 GENERAL ENTRIES continued SHOW VD CALCS If you want voltage drop calculations to appear on the load calculation printout enter YES You may enter any information in the green cells and it will appear on the panel schedule A O DATED 2 1 06 ABC ELECTRIC COMPANY FOR SERVICE CALL 555 626 1800 DISPLAY ONLY Also in the general information section there are a group of cells displaying wire and conduit size information These cells only display information when no errors are present in the tem plate AFC AT THIS PANEL 2d 241 FEEDER NUMBER OF CONDUITS 1 FEEDER CONDUIT 114 WIRE SIZE L1 4100 WIRE SIZE L2 t HI LEG 1 Hb WIRE SIZE L3 4100 WIRE SIZE NEUTRAL Hb WIRE SIZE GROUND Hb CIRCUIT ENTRIES Once you have completed the general entries you may begin making the circuit entries Each circuit entry consists of the following LIGHTING LIGHTING LIGHTING Enter circuit description Page 30 CIRCUIT ENTRIES continued 3 PHASE DELTA CIRCUITS If you are entering 1 phase line to neutral loads on a 3 p
18. hase delta panel do not put them in the orange cells Hi Leg L2 No 1 phase line to neutral loads LOAD IDENTIFIERS H HARMONIC LOAD On 3 phase wye panels loads subject to harmonic currents such as electronic ballast and computer equipment must be identified by placing an H in the harmonic identifier column ra a LIGHTING LIGHTING LIGHTING Enter H or a space Space Bar HOW THE PROGRAM CALCULATES HARMONIC LOADS When the harmonic load is 50 or more of the load on 3 phase wye panels the NEC requires the neutral conductor to be considered a current carrying conductor Therefore the feeder conduit has four 4 current carrying conductors and the conductor ampacity must be derated to 80 The program does this automatically Page 31 LOAD IDENTIFIERS continued NEUTRAL LOADS If you have selected AUTO for neutral sizing the program will calculate the neutral load and size the neutral separate from the line conductors This is known as reduced neutral sizing For this to work properly you need to identify each line to neutral load in the panel Enter N or a space Space Bar HOW THE PROGRAM CALCULATES NEUTRAL CONDUCTOR SIZE In the auto sizing mode the largest line to neutral load is the ampacity used The neutral con ductor is sized on that load or 34 of line conductor ampacity per Code requirements CIRCUIT LOAD IDENTIFIERS There are several ways to identify
19. loads Listed below are the options G General Load D Receptacle Load Diversity C Continuous Load K Kitchen Load M Motor Load Enter G D C K orM Page 32 ENTERING CIRCUIT LOADS LINE TO NEUTRAL LOADS 1 Pole Breaker Enter the VA Volts X Amps into the cell LINE TO LINE LOADS 2 Pole Breaker Enter one half of the VA in each cell Example 50 Amps X 240 Volts 12 000 VA 12 000 VA 2 6 000 VA in each cell LINE TO LINE LOADS 3 Pole Breaker Enter one third of the VA in each cell Example 40 Amps X 208 Volts X 1 732 14 410 VA 14 410 VA 3 4 803 VA in each cell Page 33 SUBPANEL GENERAL ENTRIES FED FROM Select Choice TRANSFORMER 1 PHASE TRANSFORMER 3 PHASE KVA SECONDARY If you select a transformer you can select the i ES KVA rating or select AUTO and the program will size the transformer automatically VD ADJUSTMENT If you are using a transformer a voltage drop adjustment appears Use this rather than Factor to adjust for voltage drop XMFR Z RATING If you are using a transformer a transformer Z rating appears Enter the Z rating of the transformer Page 34 PRINTOUTS Each panel schedule template is designed to print out four 4 sheets for the panel and four 4 sheets for the subpanel Panel Schedule Load Calculation Directory Error Checking Report Using the mouse click on the tab to display the sheet you wish to prin
20. pears when using a 3 phase delta service and when AUTO is selected for L2 Hi Leg This factor is used two ways If you enter 20 the ampacity of the L2 conductor will be increased 20 You can also use this factor to correct for voltage drop Main Breaker Sizing Select method AUTO Program will automatically size main breaker and feeder conductors When load exceeds 1200 amps the MANUAL method must be used MANUAL You enter the conductor and conduit size NONE If you have seven 7 or more circuits you must have a main breaker Main Breaker Amps Enter amps This option only appears when the main breaker sizing is set for MANUAL Main Breaker Position Select position This option only appears when a main breaker is used DISPLAY OPTIONS 1 Line Display Options SHOWY MAIN METER SHAW CURRENT TRANSFORMER SHOW FAULT CURRENT SHOW VOLTAGE DROP SHOW CONDUIT LEMGTH SHOW UFER GROUND SHOW TRUE PHASE CONNECTION Show Meter Yes No If YES is selected a meter will appear on the 1 Line drawing Show Current Transformer Yes No If YES is selected a CT will appear on the 1 Line drawing Show Fault Current Yes No If YES is selected fault current will appear on the 1 Line drawing Page 12 DISPLAY OPTIONS continued Show Voltage Drop Yes No If YES is selected voltage drop will appear on the 1 Line drawing Show Conduit Length Yes No If YES is selected conduit length will appear on the 1
21. proper wire size You may also enter a minimum value and the program will use the minimum value If the minimum value is less than the neutral load the program will size the neutral to handle the neutral load The program will size the neutral to carry at least 34 percent of the line con ductors per NEC requirements Enter Y or N If you enter Y an equipment ground conductor will be added to the feeder conduit s GND WIRE Y N WIRE TYPE THHN Select the wire type WIRE CU AL CU Enter CU or AL WIRE TEMP 75 Enter the wire insulation temperature Page 28 GENERAL ENTRIES continued WIRE LENGTH Enter wire length CONDUIT TYPE EMT Select conduit type MINIMUM AMPS 100 Enter minimum amps If the load exceeds the minimum amps the program will automatically size the wire for Code requirements MINIMUM AMPS L2 100 Enter minimum amps for hi leg L2 If the load exceeds the minimum amps the program will automatically size the wire per Code KITCHEN LOADS Enter the number of kitchen loads FACTOR Enter percentage factor Example If you enter 20 the program will provide 20 spare capacity for future loads You may also use this factor to adjust for voltage drop FACTOR L2 Enter percentage factor for hi leg L2 Example If you enter 20 the program will provide 20 spare capacity for future loads You may also use this factor to adjust for voltage drop MAIN BKR FUSE Enter Y or N If you ent
22. r AL YES or NO Wire YES or NO Length Type Type Temp END OF USER S GUIDE Page 38
23. t When the sheet is displayed use the FILE PRINT command NO COPY PASTE Do not use the COPY and PASTE commands on this template as they can corrupt the file Each cell in this template has been formatted with error checking and performance codes When you copy a cell and use the paste command these formats and performance codes are pasted to the new location PASTE SPECIAL Values Only To avoid corrupting the file use the COPY and the EDIT PASTE SPECIAL command selecting VALUES from the paste special menu Paste Special Paste Call e Formulas Validation C All except borders Formats Column widths Click on Values and click OK Operation None C Multiply Add l Divide O Subtract Transpose Cancel Page 35 USING THE MOTOR CONTROL CENTER TEMPLATES There are 4 MCC templates MCC 1 through MCC 4 Do not change the name of these files Each file links to the MSWBD file and forwards all the load calculations The MCC files also read information from the MSWBD files It is best to have the MSWBD file open when working with the MCC files USING THE TABS The template has five 5 tabs ALAT HA Input Cales Z AFC Calcs Z VD Cales f MCC 1 ine Read T Each tab has a special purpose Panel Tabs Input This sheet is used to enter information Calcs This sheet is used to review and print load calculations AFC Calcs This sheet is used to review and print the fault current
24. ts LOADING THE PROGRAM Insert the CD in your drive and follow the setup instructions The installation of 1 Line will create the following folder on your C drive C 1 Line 2014 EXPLORING THE PROGRAM 1 Line software is a complex spreadsheet template program The program uses 53 files which link to one another DO NOT CHANGE THE FILE NAMES If a file name is changed the template can become corrupt Page 3 LOCATING THE PROGRAM FILES The 1 Line templates are located on your C drive Sel File Edit View Favorites Tools Help ae Back gt a O Search MES Folders 553 Address gt En v Go 5 1 Line 2014 1 Line 2014 Folder If you double click on the 1 Line folder you will find 1 folder AAA File Edit View Favorites Tools Help ae Q Back gt Dd yo Search Folders Bee Address china Me 5 Blank Blank Folder 2 1 Line 2014 Manual pdf Page 4 STARTING A NEW PROJECT If you want to start a new project RIGHT CLICK on the blank folder and select COPY Open Explore Search Sharing and Security Winzip Scan with ave Send To Create Shortcut Delete Rename Properties Then RIGHT CLICK on the white area of the window and select PASTE fe C 1 Line 2014 Sele File Edit View Favorites Tools Help we Back EA w search We Folders EHRE Address E C 1 Line 2014 E gt s Blank gt 1 Line 2014
Download Pdf Manuals
Related Search