Mixed Occupancy Instructions
Contents
1. This sheet is used to review and print the circuit directory o 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 22 USING COMMERCIAL PANEL TEMPLATES USING THE TABS The template has Seven 7 tabs Input Schedule Directory Errors CopyPaste CAD Each tab has a special purpose Panel Tabs Input This sheet is used to enter information ochedule 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 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 23 GENERAL ENTRIES oome 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 MUSS MAIN PANEL ON po eor arats VOLTAGE SaN LOWVOLTAGE f 120 JFEDR PHASE _ tM OF CABLES FEEDER TYPE jFEEDERCABLE SERCABLE a a lee e2. o E L3 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 BER 8 3 Example 50 Amps X 240 Volts 2 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 M um Example 40 Amps X 208 Volts X 1 732 2 14 410 VA 14 410 VA 3 4 803 VA in each cell Page 29 SUB PANEL GENERAL ENTRIES FED FROM TRANSFORMER 1 PHASE TRANSFORMER 3 5 KVA SECONDARY _ VD ADJUSTMENT 110 XMFR ZRATING 10 House Panel Only Select Choice If you select a transformer you can select the KVA rating or select AUTO and the program will size the transformer automatically If you are using a transformer a voltage drop adjustment appears Use this rather than Factor to adjust for voltage drop If you are using a transformer a transformer Z rating appears Enter the 96 Z rating of the transformer Page 30 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 c
3. Occupancy 1 Line 2011 folder to display the contents 26 Microsoft Excel Book1 E File Edit View Insert Format Tools Data Window Help Adobe PDF amp V BAT o a Ww x BL EL 4 wor Aria F 8 k Seiaaeas os amp sa BN ij 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 Book2 File Edit View Insert Format Tools Data Window DoneEx Help Adobe AM 7T Open Favorites a File name My Network Places Files of type The files in this folder are MAIN PANEL HOUSE PANEL CP1 CP10 and DP1 DP30 DO NOT RENAME THESE FILES This will corrupt the files 86 0P7 L5 pra sLs 2 pPo sLS DP10 L5 3 pP11 9L5 SDP 12 xL5 3 0P13 xL5 S6 0P14 xL5 86 DP15 L5 SDP 16 xL5 SDP 17 xL5 SDP 18 xL5 SDP 19 L5 3 IDP20 LS 06 InpP21 XL5 S IpPz2 sLS 4 IPz3 L5 i IpPz4 sL5 3 IPz5 sL5 3 IDPz6 L5 a IDP27 3LS 3 IpPz8 sLS 3 IpPz2 sL5 3 pP30 sL5 i House Panel xls 34 Main Panel xls 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 MAME S
4. THIS AMOUNT TO 8559 5 ENTER 100 OF THE NAMEPLATE RATINGS OF ELECTRIC SPACE HEATING IF FOUR OR ENTER MORE SEPARATELY CONTROLLED UNITS MOTE PROGRAM VILL AUTOMATICALLY ADJUST THIS AMOUNT TO 4055 ENTER 100 OF THE NAMEPLATE RATINGS OF ELECTRIC THERMAL STORAGE ENTER AND OTHER HEATING SYSTEMS WHERE THE USUAL LOAD IS EXPECTED TO BE CONTINUOUS AT THE FULL NAMEPLATE VALUE SYSTEMS QUALIFYING UNDER THIS SELECTION SHALL NOT BE CALCULATED UNDER ANY OTHER SELECTION IM 220 6200 Enter heating amp cooling loads listed above Page 19 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 20 PRINTING To print your load calculations click on the Calcs Tab MS Input Then select the File Print Command EA Microsoft Excel Single Family Arial 8 Chl 3 D lt Gla Bs fe 4 100 2 File Edit View Insert Format Tools Data Window DoneEx Help DI new CkriH N 87 Open D CALCULATIONS PROJECT HAME Save As 220 82 DWELLING UNIT Setup HEUTRAL LOAD HEC 220 61 amm 5 400 YA TOTAL SQ FOOTAGE 1 800 501 3 000 VA APPLIANCE CIRCUITS 2 X 1 500 Create Adobe PDF 1 500 VA LAUNDRY CIRCUITS 1 X 1 500 Y
5. TOTAL COMNECTED MELITRAL LO 15 000 KVA PER PHASE DEMAND 15 000 2 8 000 VA FIRST 3 000 V4 100 3 000 If the calculations print on more than one page go to the File Page Setup Command and reduce the percentage Page 5etup Page Margins Header Faater Sheet Orientation Print Print i Scaling un f Adjust En Es BE normal size Fit bo 1 page s wideby 1 Paper size Letter e Print quality J600 dpi First page number Auto Page 21 USING HOUSE PANEL TEMPLATE USING THE TABS The template has twelve 12 tabs AIP LIGHTING H C 1 600 G B ue a 8 8 28 Input lt Schedule Calcs Directory Errors f S Input S Schedule 5 Cales S Directory 4 S Errors CopyPaste CAD 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 ochedule 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
6. 000 PER PHASE DEMAND 15 000 2 8 000 VA FIRST 3 000 V4 100 3 000 If the calculations print on more than one page go to the File Page Setup Command and reduce the percentage Page 5etup Page Margins Header Faater Sheet Orientation Print Print i Scaling un f Adjust En Es BE normal size Fit bo 1 page s wideby 1 Paper size Letter e Print quality J600 dpi First page number Auto Page 17 DWELLING UNIT TEMPLATES GENERAL ENTRIES PANEL NAME SELECT PHASE ENTER TOTAL SQUARE FOOTAGE APPLIANCE CIRCUITS 2 OR GREATER LAUNDRY CIRCUITS ZERO OR GREATER PANEL NAME PHASE TOTAL SQUARE FOOTAGE APPLIANCE CIRCUIT LAUNDRY CIRCUITS 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 FEEDER FEEDER TYPE CONDLIT LENGTH WIRE CUAL WIRE TEMP MINIMUM AMPS FACTOR GROUND WIRE YN SELECT WIRE THHN CONDUIT TYPE EMT FEEDER TYPE Select CONDUIT SER or MC LENGTH Enter total length of wire from service cap to panel WIRE CU AL Select CU or AL WIRE TEMP Enter wire temperature 60 75 or 90 MINIMUM AMPS Enter the minimum amps FACTOR Enter the factor This will increase the design load GROUND WIRE Y N SELECT WIRE TYPE CONDUIT TYPE by the percentage Example If the calculated load is 90 amps and you ent
7. AMPLE PROJECT ADDRESS 123 MAIN ST CIT T ISTATELZIP SOMEVVHERE CA 95620 Phase amp Voltage CODE YEAR PHASE HIGH VOLTAGE Lowy 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 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 Length Enter the length of the conduit or
8. Mixed Occupancy 1 Line 2011 Instructions Copyright 2010 Durand amp Associates menue s Jes Using Mixed Occupancy 1 Line 2011 with Excel Excel 1997 2003 Itis our recommendation that Mixed Occupancy 1 Line 2011 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 Mixed Occupancy 1 Line 2011 that uses the new Excel 2007 xlsx 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 he menus in Excel 2007 are not the same and some commands no longer exist 3 Wetried running the old xls 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
9. OTE To update dwelling panels simply open the file z UPDATE z UPDATE z UPDATE z UPDATE z UPDATE lt UPDATE lt UPDATE z UPDATE UPDATE z UPDATE Example Open the CP3 file and the file is automatically updated Dwelling Unt Lables UPDATE UPDATE lt UPDATE UPDATE UPDATE z UPDATE UPDATE UPDATE lt lt UPDATE Page 15 File is Updated DWELLING PANEL ERRORS If a Dwelling Panel contains an error the ERROR will be displayed Dwelling Unit Lables DP DP DP DP3 ERROR IN 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 6474 2 REQUIRES THAT EACH DWELLING ELECTRIC COOKING EQUIPMENT YOUR SERVICE CONFIGURATION HAS 30 DVWELLING UNITS HOWEVER ONLY 1 OF THE DWELLINGS HAVE RANGE CHECK EACH DVWELLING AND MAKE SURE LEAST ONE 1 RANGE 15 ENTERED IF ANY OF THE CVWELLINGS DO NOT HAYE A RANGE VOU VILL NEED TO ENTER 1 RANGE AT 8 EM THIS VILL MEET THE REGLIIREMERNTS OF NEC 220 647402 EXCEPTION CODE ELECTRIC HEATING OR COOLING The program automatically checks the Code requirements for heating amp cooling If an error is detected it
10. TE Mixed Occupancy 2011 File Edit View Favorites Tools id Address C Mixed Occupancy 2011 C Blank Mixed Occupancy Instructions pdf f Mixed BX View Edit View F a Arrange Icons By Refresh Q ddress Go A Customize This Folder Paste Shortcut Undo Delete _ Blank 7 Mixed Occupancy Instructio te Copy of Blank Ctrl4 zZ New Properties This will created a new folder titled Copy of Blank Page 6 RENAME THE FOLDER 0 You can RIGHT CLICK on the new folder and Ee select the RENAME command Search Sharing and Security Cl winzip Scan with Ava Send To b Create Shortcut Delete Properties w Mixed Sele File Edit View ae a Back gt Address Go Type in your new project name Mixed oo NE E Your New Use this method to create a new project each time you start a new Mixed Occupancy 1 Line Now that you have created a new folder close all windows Page 7 USING THE PROGRAM Go to your START MENU select ALL PROGRAMS and select EXCEL Fr Mailloop Microsoft Access Microsoft Excel All Programs Microsoft FrontPage EM Microsoft Outlook This will start your Excel spreadsheet program select the FILE OPEN command and locate the Mixed Occupancy 1 Line 2011 folder on your C drive Double click the Mixed
11. We have both Excel 2003 and Excel 2007 installed on our machines You may also wish to installed both version of Excel on your machines Page 2 MIXED Occupancy 1 LINE 2011 COPYRIGHT 2010 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 Mixed Occupancy 1 Line 2011 software is a spreadsheet template software program for calculating main service switchboard sub panels feeder sizes and Mixed Use 1 Line drawings This program may be used for single and multifamily dwelling loads The Mixed Occupancy 1 Line 2011 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 Mixed Occupancy 1 Line 2011 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 Mixed Occupancy 1 Line 2011 software is a spreadsheet template program The program was designed for use in conjunction with Microsoft Exce
12. c ee _ WIRE CUAL jwRESUEEGROUND 0 0 0 I an CORTE EM WIRE LENGTH faving APS e a ee __ KITCHENLOADS rector ggg NEN MAINBKRAFUSE BREAKER o X 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 LI o vH EL a When you select a cell a hint box will appear You may also use the pulldown menu AHA THw C THH AHH i Page 24 House Panel Only GENERAL ENTRIES continued Below is a list of valid entries for the general information section of the panel schedule PANEL OF CIRCUITS PHASE GND WIRE Y N WIRE TYPE WIRE CU AL WIRE TEMP WIRE LENGTH CONDUIT TYPE MINIMUM AMPS KITCHEN LOADS FACTOR MAIN BKR FUSE THHN c M No M N c3 Enter the panel name such as 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 feed
13. cable run Page 11 SERVICE FEED IN AUTO MODE continued FAULT CURRENT SERVICE POINT 5000 WIRE AL WIRE TEMP io 36 FACTOR 0 GROUND WIRE M WIRE THHM CONDUIT TYPE Py C 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 If 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 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 appears 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 MANUAL OVERHEAD Service Feeder Sizing Select AUTO or MANUAL Line 1 Feeder Description Line 2 Feeder Description Line 3 Feeder Description Lin
14. e 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 Humber of D vellina Units amp OFUMITS 20 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 Unt Lables UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE NOTE To update dwelling panels simply open the file Example Open the file and the file is automatically updated Dwelling Unit Lables UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE Page 14 File is Updated NUMBER OF COMMERCIAL PANELS Number af Commercial Units OFUMITS Enter the number of dwellings UPDATE COMMERCIAL PANELS If the Main Pane Voltage or Phase change the Commercial Panels may need updating When this condition is present the commercial panel display turns orange Dwelling Unit Lables N
15. er 2096 the program will add 18 amps to the calculated load giving you a design load of 108 amps NOTE Increasing the factor forces the program to increase the wire size thus reducing the voltage drop 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 select conduit type This option only appears when you are using a conduit feeder Page 18 GENERAL ENTRIES continued MAJOR APPLIANCES DESCRIPTION ary EA RANGES amp OVEN S a es ee ee CLOTHES DRYER S WATER HEATER S _ RANGE S amp OVEN S Enter number of ranges ovens and KVA 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 KA AND COOLING EQUIPMENT ae ae 2 EMTER 100 OF THE NAMEPLATE RATINGS OF THE HEAT PUMP WHEN THE HEAT PUMP ENTER IS USED WITHOUT ANY SUPPLEMENTAL ELECTRIC HEATING a a 3 ENTER 100 OF THE NAMEPLATE RATINGS IM EYA OF THE HEAT PUMP ENTER COMPRESSOR ENTER 100 OF THE SUPPLEMENTARY ELECTRIC HEAT USED WITH THE HEAT PUMP ENTER MOTE PROGRAM VILL AUTOMATICALLY ADJUST THIS AMOUNT TO 5555 4 ENTER 100 OF THE NAMEPLATE RATINGS OF ELECTRIC SPACE HEATING IF LESS THAN ENTER FOUR SEPARATELY CONTROLLED UNITS MOTE PROGRAM VILL AUTOMATICALLY ADJUST
16. er 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 2096 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 25 GENERAL ENTRIES continued SUB PANEL BKR 3 PHASE Panel Only 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 1 phase the program will automatically place a 2 pole circuit breaker in 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 26 GENERAL ENTRIES continued You may enter any information in the green cells and it will appear on the panel schedule ae UU DATED 2 1 06 ABC ELECTRIC COMPANY FOR SERVICE CALL 555 626 1900 DISPLAY ONLY Als
17. l on the Windows platform 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 Mixed Use 1 Line will create the following folders on your C drive C Mixed Use 1 Line 2011 C Mixed Use 1 Line 2011 Excel 2007 Read page 2 before using this version EXPLORING THE PROGRAM Mixed Use 1 Line software is a complex spreadsheet template program The program uses 42 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 Mixed Occupanoy 1 Line templates are located on your C drive Local Disk C File Edit View Favorites Tools Help Back gt du pa Search Folders ME Occupancy 2011 Excel 1997 2003 Version Mixed Occupancy 2011 Excel 2007 Excel 2007 Version Read page 2 Ja Mixed Occupancy Instructions pdf NOTE Please double click on the Mixed Occupancy 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 Scan with Ava Send Ta Cut Create Shortcut Delete Rename Properties Then RIGHT CLICK on the white area of the window and select PAS
18. o 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 amp 1 WIRE SIZE L2 amp 1 WIRE SIZE NEUTRAL 1 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 ae 204 1 gf 204 1P 11 20 1 CIRCUIT DE LY 20A4P L 1600 9 20A4P 1800 20A 1P 1800 Enter circuit description Page 27 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 H in the harmonic identifier column Enter 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 8096 The program does this automatically Page 28 ENTERING CIRCUIT LOADS LINE TO NEUTRAL LOADS 1 Pole Breaker ss penses spp L Hi cy 1500 t
19. orrupt 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 3 All o O Enrmulas Validation t All except borders t Formats t Column widths Click on Values and click OK Operation None t Multiply f Add f Divide O Subtract Transpose Cancel Page 31
20. 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 HAWE ELECTRIC HEATING OR AIR CONDITIONING YOUR SERVICE CONFIGURATION HAS 30 DWELLING UNITS HOWEVER ONLY 1 OF THE DWELLINGS HAYE 4 HEATING OR AIF CONDITIONING LOADS CHECK EACH SURE EACH DWELLING HAS 4 HEATING OR AIF CONDITIONING LOAD IF AMY OF THE DVVELLINCGS DO NOT HAYE A HEATING OR AIF CONDITIONING LOAD YOU WILL NEED TO ENTER LOAD THIS WILL MEET THE REQUIREMENTS OF NEC 220 647 4103 Page 16 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 IM 4 b Input Calcs VD Cales Cales f 1 Line Draw b AutoShapes in 4 Then select the File Print Command EA Microsoft Excel Single Family Arial 8 BY 3 D Gla amp BECO fe 4 100 2 File Edit View Insert Format Tools Data Window DoneEx Help DI new CkriH N 87 Open D CALCULATIONS PROJECT HAME MEE 220 82 DWELLING UNIT Setup NEUTRAL LOAD HEC 220 61 prin FTX3VAJ 5400 VA Sa FOOTAGE 1 800 501 OVA 3000 APPLIANCE CIRCUITS 2 X 1 500 Create Adobe PDF 1 500 VA LAUNDRY CIRCUITS 1 X 1 500 Y TOTAL CONNECTED NEUTRAL LO 16
Download Pdf Manuals
Related Search