Residential 1-Line 2014
Contents
1. Enter YES or NO This option only appears when you are using a conduit feeder Select wire type This option only appears when you are using a conduit feeder oelect conduit type This option only appears when you are using a conduit feeder Page 17 GENERAL ENTRIES continued MAJOR APPLIANCES DESCRIPTION GT KV AS EAI RANGE S amp OVEN S Lo d CLOTHES DRYER S WATER HEATERCS ee RANGE S amp OVEN S Enter number of ranges ovens and rating CLOTHES DRYER S Enter number of dryers and KVA rating WATER HEATER S Enter number of water heaters and KVA rating HEATING COOLING 1 ENTER THE TOTAL NAMEPLATE RATING KYA OF AIR CONDITIONING ENTER KYA AND COOLING EQUIPMENT 2 ENTER 100 OF THE NAMEPLATE RATING S OF THE HEAT PUMP WHEN THE HEAT PUMP ENTER KYA IS USED WITHOUT ANY SUPPLEMENTAL ELECTRIC HEATING 3 ENTER 100 OF THE MA amp MEPLATE RATING S IN KYA OF THE HEAT PUMP ENTER COMPRESSOR ENTER 100 OF THE SUPPLEMENTARY ELECTRIC HEAT USED WITH THE HEAT ENTER KA NOTE PROGRAM VILL AUTOMATICALLY ADJUST THIS AMOUNT TO 65 poc 4 ENTER 100 OF THE NAMEPLATE RATING S OF ELECTRIC SPACE HEATING IF LESS THAN ENTER FOUR SEPARATELY CONTROLLED UNITS I eee NOTE PROGRAM WILL AUTOMATICALLY ADJUST THIS AMOUNT TO 65 ENTER 100 OF THE NAMEPLATE RATING S OF ELECTRIC SPACE HEATING IF FOUR OR ENTER MORE SEPARATELY CONTROLLED UNITS EE ee NOTE PROGRAM WILL AUTO2. HOWEVER ONLY 1 OF THE DWELLINGS HAYE A HEATING OR AIF CONDITIONING LOADS CHECK EACH AND MAKE SURE EACH HAS A HEATING OR AIF CONDITIONING LOAD IF AMY OF THE DO NOT HAYE A HEATING OR AR CONDITIONING LOAD YOU VILL NEED TO ENTER 4 LOAD THIS WILL MEET THE REQUIREMENTS OF NEC 220647405 Page 15 PRINTING To print your load voltage drop or fault current calculations click on the Calcs Tabs To print your 1 Line Drawing click on the 1 Line Tab Wlall H Input Cales VD cales Cales Z 1 Line Draw 5 AutoShapes LI gt 4 E Then select the File Print Command Microsoft Excel Single Family Arial 3 El Den amp amp Ml aoran A 5 4 2 Ba 6 100 2 File Edit view Insert Format Tools Data Window DoneEx Help ENS CHN g Open Cro D CALCULATIONS PROJECT CO Save As IOH 220 82 DWELLING UNIT Setup HEUTRAL LOAD HEC 220 61 sm FTX3WA 5400 WA TOTAL SQ FOOTAGE 1 800 Sa m VA 3 000 WA APPLIANCE CIRCUITS 2 X 1 500 Create Adobe PDF 1500 LAUNDRY CIRCUITS 1 X 1 500 V Y TOTAL CONNECTED NEUTRAL LO 16 000 KYA PER PHASE DEMAND 15 000 WA 2 8 000 VA FIRST 3 000 va ie 100 3 000 If the calculations print on more than one page go to the File Page Setup Command and reduce the percentage Pape Setup Page Margins
3. Header Footer Sheet Orientation Print 2 TOUR E EA 2 E Scaling Adjust En EN normal size Fit bo 1 pagers wide by 1 tal Paper size e Print quality 600 dpi First page number Auto Page 16 DWELLING UNIT TEMPLATES GENERAL ENTRIES PANEL MAME SELECT PHASE ENTER TOTAL SQUARE FOOTAGE APPLIANCE CIRCUITS 2 OR GREATER J LAUNDRY CIRCUITS ZERO OR GREATER J PANEL NAME PHASE TOTAL SQUARE FOOTAGE APPLIANCE CIRCUIT LAUNDRY CIRCUITS FEEDER FEEDER LENGTH WIRE CUAL WIRE TEMP MINIMUM AMPS 36 FACTOR GROUND WIRE YN SELECT WIRE CONDUIT TPE FEEDER TYPE LENGTH WIRE CU AL WIRE TEMP MINIMUM AMPS FACTOR GROUND WIRE Y N SELECT WIRE TYPE CONDUIT TYPE Enter panel name Select 1 or 3Y Enter the total square footage of the dwelling Enter the number of appliance circuits Minimum 2 Enter the number of laundry circuits Select CONDUIT SER or MC Enter total length of wire from service cap to panel select CU or AL Enter wire temperature 60 75 or 90 Enter the minimum amps Enter the 96 factor This will increase the design load by the percentage Example If the calculated load is 90 amps and you enter 2096 the program will add 18 amps to the calculated load giving you a design load of 108 amps NOTE Increasing the 96 factor forces the program to increase the wire size thus reducing the voltage drop
4. in the harmonic identifier column nn M Enter H or a space Space Bar HOW THE PROGRAM CALCULATES HARMONIC LOADS When the harmonic load is 5096 or more of the load on 3 phase wye panels the NEC re quires 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 26 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 27 SUB PANEL GENERAL ENTRIES FED FROM Select Choice TRANSFORMER 1 PHASE TRANSFORMER 3 PHASE KVA SECONDARY _ If you select a transformer you can select the 2 KVA rating or select AUTO and the program will in 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 tran
5. 1 phase the program will automatically place a 2 pole circuit breaker circuit positions 1 amp 3 If this is a 3 phase delta panel feeding 1 phase sub panel the program will automatically place a 3 pole circuit breaker in circuit positions 1 3 amp 5 In this case the 1 phase sub panel will be con nected to L1 and L3 If you select 3 phase the program will automati cally place a 3 pole circuit breaker in circuit posi tions 1 3 amp 5 Page 24 GENERAL ENTRIES continued You may enter any information in the green cells and it will appear on the panel schedule Ul UU 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 NUMBER OF CABLES 1 FEEDER CABLE SER CABLE WIRE SIZE L1 1 WIRE SIZE L2 1 WIRE SIZE MELTRAL x1 WIRE SIZE GROUND 3 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 25 CIRCUIT ENTRIES continued 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
6. both Excel 2000 and Excel 2007 installed on our machines You may also wish to installed both version of Excel on your machines Page 2 RESIDENTIAL 1 LINE 2014 COPYRIGHT 2014 DURAND amp 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 Residential 1 Line 2014 software is a spreadsheet template software program for calculating main service switchboard sub panels feeder sizes and Residential 1 Line drawings This program may be used for single and multifamily dwelling loads The Residential 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 amp Associates SOFTWARE REQUIREMENTS Residential 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 have Excel 2007 be sure to read page 2 of this manual before using this program Page 3 INTRODUCTION The Residential 1 Line 2014 software is a spreadsheet template program The program was de signed for use in conjunction with Microsoft Excel on the Windows platfo
7. created a new folder close all windows Page 7 USING THE PROGRAM Go to your START MENU select ALL PROGRAMS and select EXCEL All Programs 3 Microsoft Access 4 Microsoft Excel Mailloop E Microsoft FrontPage F SU E Microsoft Outlook This will start your Excel spreadsheet program Select the FILE OPEN command and locate the Residential 1 Line 2014 folder on your C drive Double click the Residential 1 Line 2014 folder to display the contents Microsoft Excel Book1 S 7 18 Ele Edit View Insert Format Tools Data Window Help ba 2 Z M oo 5 y Your New Name Now displayed are two 2 folders 1 Blank 2 Your New Project This is the folder you just created Double click on Your New Folder Page 8 EXPLORING THE SAMPLE PROJECT Microsoft Excel Book EB Format Tools Data Window DoneEx Help Adobe Y SE OS 5c E 21 Z u u D Look in c Your New Name amp tj 7 Tools y 1 Hause Panel xls Se DP17 xLS 3 Main Panel xls Se IpP18 sLS DP13 xLsS 2 amp pP2n xLs 26 IP21 LS a DP22 xLS 26 DP23 xXLS i DP24 xLS InP25 sLS ee 8 0P26 L5 15 amp ppz7 xL5 16 26 OP23 xL5 26 Dp29 xL5 18 2 pP3o sLs 18 20 File gt Open 2 Places Files of type All Microsoft Ex
8. 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 21 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 w MAIN PANEL BOFCRCUTS i C HIVOLTAGE _ co RE PHASE _ tM OF CABLES EEDER SER FEEDER CABLE SERCABLE RESIZE RESIZE Pc x MESEENMEUTRAL WIRE CUAL QWRESIZEGROUND 000000 0 3 O WIRE TEMP C s j SUBPANELBKR CIRCUITS 18 2 PHAS WRELENGTH TaS PI MINIMLIM AMPS o ai EE KITCHENLOADS j o ooo ojus NEN 2 a LeLCICCIILLIl LOI XI OOIIT MAMBKRIFUSE BREAKER SIZE NETT j J C MN U o 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 w YH KL ua When you select a cell a hint box will appear You may also use the pulldown menu TH A THH 4 HHW _A Page 22 GENERAL ENTRIES continued Below is a list of valid entries
9. Cl winzip k Scan with Ava Send k LIL Create Shortcut Delete Rename Properties Then RIGHT CLICK on the white area of the window and select PASTE Residential 1 Line 2014 mI File Edit View Favorites Tools Help ae Q Back ZO Search Folders Y Address 2 C Residential 1 Line 2014 m Blank Multifamily Instructions pdf View k Icons By k Refresh Customize This Folder Residential 1 D amp Paste Shortcut s gt gt Undo Rename File Edt Fav u New k Back ki d ras Address s CiReside v GO Lj Blank 2 Multifamily Instructions pdf This will created a new folder titled Copy of Blank P Page 6 RENAME THE FOLDER You can RIGHT CLICK on the new folder and select the RENAME command Type in your new project name Open Explore Search Sharing and Security ll winzip h Scan with AV Send To b ut Copy Create Shortcut Delete Properties Residential 1 File Edit view Fay gt gt Q Back LJ cp Address ca C Reside v 50 Multifamily Instructions pdf ON Your New Mame Use this method to create a new project each time you start a new Multifamily 1 Line Now that you have
10. MATICALLY ADJUST THIS AMOUNT TO 40 B ENTER 100 OF THE MAMEFLATE RATINGS OF ELECTRIC THERMAL STORAGE ENTER KA AMD OTHER HEATING SYSTEMS WHERE THE USUAL LOAD IS EXPECTED TO BE CONTINUOUS AT THE FULL MAMEFLATE VALUE SYSTEMS QUALIFYING UNDER THIS SELECTION SHALL NOT BE CALCULATED UNDER ANY OTHER SELECTION IN 220 6200 Enter heating amp cooling loads listed above Page 18 GENERAL ENTRIES continued Enter the description number of units and the amps for each item Enter the description number of units amps and the phase for each item NOTE Phase column only appears when using a 3 Phase panel Page 19 PRINTING To print your load calculations click on the Calcs Tab I4 4 h Input Calcs Z Then select the File Print Command Microsoft Excel Single SET Arial abe SB s r an oe NN EU Y EG amp lh v 8 m xS con ox A 2 Z uw E File Edit wiew Insert Format Tools Data Window Help 3 g Open Cro D CALCULATIONS PROJECT CO Save As IOH 220 82 DWELLING UNIT Setup NEUTRAL LOAD HEC 220 61 amm BFTX3wvAj 5400 WA TOTAL SQ FOOTAGE 1 800 5011 m VA 3 000 WA APPLIANCE CIRCUITS 2 X 1 500 Create Adobe PDF 1500 LAUNDRY CIRCUITS 1 X 1 500 V Y TOTAL CONNECTED NEUTRAL LO 16 000 KYA PER PHASE DEMAND 16 000 VA 2 8 000 VA FIRST 3 000 vA 100 3 000 If t
11. PDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE Page 14 File is Updated DWELLING PANEL ERRORS If a Dwelling Panel contains an error the ERROR will be displayed Dwelling Unit Lables DP1 DP DPZ DP DP3 ERROR IM SUB PANEL DP4 DP DPS DP DPE DP To correct this error open the Dwelling Panel File and correct the error CODE CHECK RANGES The program automatically checks the Code requirements for ranges If an error is detected it will display the error and solution Code Check Ranges THIS PROGRAM CALCULATES THE MULTIFAMILY SERVICE SIZE PER NEC 220 84 MEC SECTION 220 54 4102 REQUIRES THAT EACH DYYELLING HAYE ELECTRIC COOKING EQUIPMENT YOUR SERVICE CONFIGURATION HAS 30 EVVELLIMG UNITS HOVWEVER ONLY 1 OF THE A RANGE CHECK EACH CYVELLING AMD SURE LEAST ONE 1 RANGE 15 ENTERED IF ANY OF THE CVWELLINGS DO HAWE RANGE YOU VILL NEED TO ENTER 1 RANGE AT 8 KWN THIS WILL MEET THE REGUIREMENTS OF NEC 220 64 402 EXCEPTION CODE ELECTRIC HEATING OR COOLING The program automatically checks the Code requirements for heating amp cooling If an error is detected it will display the error and solution Code Check Electric Heating or Air Conditioning THIS PROGRAM CALCULATES THE MULTIFAMILY SERVICE SIZE PER NEC 220 84 NEC SECTION 220 84 4 3 REQUIRES THAT EACH DWELLING HAVE ELECTRIC HEATING OR AIR CONDITIONING YOUR SERVICE CONFIGURATION HAS 30 DVWELLING UNITS
12. Residential 1 Line 2014 Multifamily Instructions enuen s Jes Copyright 2014 Durand amp Associates Using 1 Line 2014 with Excel Excel 1997 2003 It is our recommendation that Residential 1 Line 2014 should be run in conjunction with Excel 1997 2003 This product was designed with Excel 1997 and runs fine with all versions of Excel through 2003 Excel 1997 2003 creates files with a xls file extension This xls file extension is the most common file extension for the Excel spreadsheets Excel 2007 Excel 2007 creates files with a new file extension xlsx This file extension in not reverse compatible with previous versions of Excel Thus if you create files with Excel 2007 other users may not be able to use them Having said that we have created a version of Residential 1 Line 2014 that uses the new Excel 2007 XIsx file extension We have tested this xIsx version and found the following 1 The new Excel 2007 takes longer to load files and the recalculation time is a little slow 2 The menus in Excel 2007 are not the same and some commands no longer exist We tried running the old files in Excel 2007 Compatibility Mode and found it seemed to run properly 4 The new xlsx files we created seem to run properly and slow with Excel 2007 Summary Microsoft plans to release Service Pack 1 for Excel 2007 at some date in the future This may or may not solve the slow performance problems NOTE We have
13. YES or NO Fault Current Calcs Select YES or NO Show Ufer Ground Select YES or NO SERVICE FEED IN AUTO MODE When auto mode is selected the program will automatically calculate the feeder size If the design load exceeds 1 200 amps you will have to use the manual mode Service Feeder Sizing Select AUTO or MANUAL Feeder Type Select CONDUIT SER or MC Si Length Enter the length of the conduit or cable run Page 11 SERVICE FEED IN AUTO MODE continued FAULT CURRENT AT SERVICE POINT 65000 WIRE CUAL AL WIRE TEMP 759 FACTOR 0 GROUND WIRE NO WIRE TYPE THHM CONDUIT TYPE PYC 40 OVERHEAD UNDERGROUND OVERHEAD Fault Current at Service Point Enter fault current If you have an overhead service enter the fault current at the service point The service point would be at the top of your service riser at the service cap lf you have an underground service where the utility pulls cable to the meter enter the fault current at the meter Wire CU AL Select CU or AL Wire Temp Select 60 75 or 90 9o Factor Enter Factor Enter the 96 factor This will increase the design load by the percentage Example If the calculated load is 90 amps and you enter 20 the program will add 18 amps to the calculated load giving you a design load of 108 amps Ground Wire Select YES or NO This option only appears when you are using a conduit feeder Wire Type Select Wire Type This option only appear
14. cel Files 5 xI xls xle htm html w Cancel The files in this folder are MAIN PANEL HOUSE PANEL and DP1 DP30 DO NOT RENAME THESE FILES This will corrupt the files Page 9 WORKING WITH THE MAIN PANEL Double click on the MAIN PANEL file to display the Main Panel Template This may take a few seconds to open as Excel updates the links to the other files Project Mame amp Address PROJECT SAMPLE PROJECT ADDRESS 123 MAIN ST CITY ASTATEJZIP SOMEVVHERE 95620 Phase x Voltage CODE YEAR PHASE HIGH VOLTAGE LOW VOLTAGE Main Breaker amp House Panel MAIN BREAKER MINIMUM SERVICE SIZE HOUSE PANEL GENERAL INFORMATION Project Name Enter the project name Address Enter the address City State Zip Enter the city state and zip code Code Year Select the Code Year from the pulldown menu Phase Select the phase from the pulldown menu 1 1 Phase 3Y 3 Phase Wye High Voltage Enter high voltage Low Voltage Enter low voltage Main Breaker Select YES or NO You must have a main breaker when your have seven 7 or more meters Minimum Service Size 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 House Panel Select YES or NO Page 10 GENERAL INFORMATION continued Voltage Drop Calcs Select
15. for the general information section of the panel schedule PANEL 34 OF CIRCUITS PHASE GND WIRE Y N WIRE TYPE WIRE CU AL WIRE TEMP WIRE LENGTH CONDUIT TYPE MINIMUM AMPS KITCHEN LOADS 95 FACTOR MAIN BKR FUSE lt THHN NO NO N 2 CO lt C lt 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 Enter number of circuits Even number from 6 to 84 or use the pulldown menu Enter phase Note You may put a 1 Phase panel on a 3 Phase source Enter Y or N If you enter Y an equipment ground conductor will be added to the feeder conduit s select the wire type Enter CU or AL Enter the wire insulation temperature Enter wire length Select conduit type Enter minimum amps If the load exceeds the minimum amps the program will automatically size the wire for Code requirements Enter the number of kitchen loads 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 Enter Y or N If you enter Y the program will size the main breaker Page 23 GENERAL ENTRIES continued SUB PANEL BKR 3 PHASE select choice from pulldown menu If you want a sub panel fed from this panel select 1 Phase or 3 Phase NOTE If you select
16. he calculations print on more than one page go to the File Page Setup Command and reduce the percentage Pape Setup Page Margins Header Footer Sheet Orientation Print Portrait t Landscape Bean Scaling Options Adjust to Es Bp normal size Fit bo 1 pagers wide by 1 ES Fall Paper size ketter Print quality 600 dpi First page number Auta Page 20 USING HOUSE PANEL TEMPLATE USING THE TABS The template has twelve 12 tabs 1P LIGHTING H 1 600 E G 26 iz ee eee _ E 1 1 _ RE __ lcl B 3 m B an N Input Schedule Calcs Directory Z Errors S Input Schedule Z S Calcs S Directory S Errors CopyPaste Z The first five tabs are for the Panel and the second five tabs are for the Sub Panel 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 Sub Panel Tabs o Input This sheet is used to enter information S Schedule This sheet is used to review and print the panel schedule o Calcs This sheet is used to review and print load calculations o Directory This sheet is used to review and print the circuit directory o Errors This
17. rm The program should also work on other platforms that can read and write Microsoft Excel 97 file formats LOADING THE PROGRAM Insert the CD in your drive and follow the setup instructions The installation of Residential 1 Line will create the following folder on your C drive C Residential 1 Line 2014 C Residential 1 Line 2014 Excel 2007 Read page 2 before using this version EXPLORING THE PROGRAM Residential 1 Line software is a complex spreadsheet template program The program uses 32 files which link to one another DO NOT CHANGE THE FILE NAMES If a file name is changed the template can become corrupt Page 4 LOCATING THE PROGRAM FILES The Residential 1 Line templates are located on your C drive Local Disk C File Edit View Favorites Tools Help we lt Back gt J Search Folders Address S C v Go Residential 1 Line 2014 Excel 1997 2003 Version Residential 1 Line 2014 Excel 2007 Excel 2007 Version Read page 2 r Residential 1 Line 2014 File Edit View Favorites Tools Help Back gt 2 Search Folders 3 Address Ci Residential 1 Line 2014 Blank Multifamily Instructions pdf NOTE Please double click on the Multifamily Instructions file and print the instructions Page 5 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
18. s when you are using a conduit feeder Conduit Type Select Conduit Type This option only appears when you are using a conduit feeder Overhead Underground Select OVERHEAD or UNDERGROUND Page 12 SERVICE FEED IN MANUAL MODE continued MANLIAL Service Feeder Sizing Select AUTO or MANUAL Line 1 Feeder Description Line 2 Feeder Description Line 3 Feeder Description Line 4 Feeder Description Line 5 Feeder Description Ufer Ground Enter Ufer Ground Size Fault Current at Service Point Enter fault current If you have an overhead service enter the fault current at the service point The service point would be at the top of your service riser at the service cap If you have an underground service where the utility pulls cable to the meter enter the fault current at the meter Page 13 NUMBER OF DWELLINGS continued Number D eellina Units amp OFUMITS 3l Enter the number of dwellings UPDATE DWELLING PANELS If the Main Pane Voltage or Phase change the Dwelling Panels may need updating When this condition is present the dwelling panel display turns orange Dwelling Unit Lables UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE lt lt UPDATE UPDATE UPDATE NOTE To update dwelling panels simply open the file Example Open the DP3 file and the file is automatically updated Dwelling Unt Lables UPDATE UPDATE U
19. sformer Page 28 PRINTOUTS Each panel schedule template is designed to print out four 4 sheets for the panel and four 4 sheets for the sub panel Panel Schedule Load Calculation Directory Error Checking Report Using the mouse click on the tab to display the sheet you wish to print 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 aj C Formulas t Validation All except borders f Formats t Column widths Click on Values and click OK Operation None f Multiply t Add t Divide Subtract Transpose Cancel Page 29
Download Pdf Manuals
Related Search