Mixed Occupancy 1
Contents
1. 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 All Programs P 3 Microsoft Access 4 Microsoft Excel Mailloop E M Microsoft FrontPage SU E Microsoft Gutlook This will start your Excel spreadsheet program Select the FILE OPEN command and locate the Mixed Occupancy 1 Line 2014 folder on your C drive Double click the Mixed Occupancy 1 Line 2014 folder to display the contents Microsoft Excel Book1 05 SSmo ar Sl Z 2 A se File Edit View Insert Format Tools Data Window Help 5 6 c er na tad File name SsBaaissE Files of type x AJ 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 26 Dose Excel Book2 pay o oc Arial 10 Ben B u 8 SW LU I L eee File Edit View Insert Format Tools Data Window DoneEx Help Adobe PDF Se pP7 sL5 i amp pPa sLs 26 pPo sLS 3 DP10 LS 26 DP11 XLS 28 DP12 xXLS 26 DP13 xXL5 28 DP14 xXLS SDP 15 xL5 Look in E You New Mame amp tj 06 InP21 XL52. 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 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 perce
3. N If you enter Y the program will size the main breaker Page 25 GENERAL ENTRIES continued SUB PANEL BKR 3 PHASE House 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 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 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 LIGHT
4. E IDPz2 sLS pPz3 sLS 6 IDPz4 L5 IDP25 sL5 26 IDPz6 L5 DP27 3L5 pPz8 sL5 26 Dp29 xLs A ppan Ls DP16 LS i pP17 3L5 pP18 L5 28 IpP19 sL5 28 DPz0 L5 E File name m My Network Places Files of type Al Microsoft Excel Files C xI xls dt htm html House Panel xls Panel xls Cancel 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 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 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
5. ING LIGHTING 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 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 28 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 29 SUB PANEL GENERAL ENTRIES FED FROM TRANSFORMER 1 PHASE TRANSFORMER 3 PHASE SECONDARY VD ADJUSTMENT XMFR Z RATING House Panel Only Select Choice If you select a transformer you can select the KVA rating or se
6. Mixed Occupancy 1 Line 2014 Instructions Copyright 2014 Durand amp Associates Page 1 enuen sasn Using Mixed Occupanoy 1 Line 2014 with Excel Excel 1997 2003 It is our recommendation that Mixed Occupancy 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 Mixed Occupancy 1 Line 2014 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 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 pro
7. NEL NAME PHASE TOTAL SQUARE FOOTAGE APPLIANCE CIRCUIT LAUNDRY CIRCUITS FEEDER FEEDER TYPE 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 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 18 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 nu
8. NG 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 wich AV Send To k LIL Create Shortcut Delete Rename Properties Then RIGHT CLICK on the white area of the window and select PASTE File Edit View Favorites Tools Help Mixed Occupancy 1 Line 2014 Sel Back gt d Search Mean Folders Address 25 C Mixed Occupancy 1 Line 2014 Blank TE Mixed Occupancy Manual Mixed Occu 4 File Edit View View h gt E B ck Y i Arrange Icons By k lt m 7 REMENE Address la C Mix v Go Customize This Folder Mixed Occupancy Manual Paste Paste Shortcut Undo Rename Ctrl Z Copy of Blank New Properties This will created a new folder titled Copy of Blank Page 6 RENAME THE FOLDER You can HIGHT 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 Mixed Occu File Edit View Ff gt Address C Mixe Go T Mixed Occupancy Manual Your New
9. USING THE TABS The template has twelve 12 tabs 1P LIGHTING H 1 600 E G 26 ee eee _ E 1 1 Mm 11 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 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 Calcs Directory f Errors CopyPaste CAD Each tab has a special purpose Panel Tabs Inp
10. blems NOTE 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 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 Mixed Occupancy 1 Line 2014 software is a spreadsheet template software program for calculating main service switchboard sub panels feeder sizes and Mixed Occupanoy 1 Line drawings This program may be used for single and multifamily dwelling loads The Mixed Occupancy 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 Mixed Occupancy 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 Mixed Occupancy 1 Line 2014 software is a spreadsheet template program The program was designed for use in conjunct
11. es 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 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 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 16 PRINTING To print your load voltage drop or fault current calculations click on the Calcs Tab
12. ion with Microsoft Excel 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 Occupancy 1 Line will create the following folders on your C drive C Mixed Occupancy 1 Line 2014 C Mixed Occupancy 1 Line 2014 Excel 2007 Read page 2 before using this version EXPLORING THE PROGRAM Mixed Occupancy 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 Occupancy 1 Line templates are located on your C drive Local Disk C File Edit View Favorites Tools Help 2 gt Search Folders adressweci Mo Mixed Occupancy 1 Line 2014 Excel 1997 2003 Version 2 Mixed Occupancy 1 Line 2014 Excel 2007 Excel 2007 Version Read page 2 If you double click on the Mixed Occupancy 1 Line folder you will find 1 file amp 1 folder Mixed Occupancy 1 Line 2014 File Edit View Favorites Tools Help ae Back gt d Search Folders Address C Mixed Occupancy 1 Line 2014 w Go Blank Occupancy Manual NOTE Please double click on the Mixed Occupancy Manual file and print the instructions Page 5 STARTI
13. lect 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 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 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 31
14. ling 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 UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE Page 14 File is Updated NUMBER OF COMMERCIAL PANELS Number af Commercial Units amp 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 Unt Lables NOTE To update dwelling panels simply open the file UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE Example Open the CP3 file and the file is automatically updated Dwelling Unit Lables UPDATE UPDATE UPDATE z UPDATE UPDATE UPDATE UPDATE UPDATE UPDATE Page 15 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 rang
15. mber 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 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 KA COMPRESSOR ENTER 100 OF THE SUPPLEMENTARY ELECTRIC HEAT USED WITH THE HEAT ENTER KA NOTE PROGRAM VILL AUTOMATICALLY ADJUST THIS AMOUNT TO 65 DE m 4 ENTER 100 OF THE NAMEPLATE RATINGS OF ELECTRIC SPACE HEATING IF LESS THAN ENTER KA FOUR SEPARATEL CONTROLLED UNITS I amp _ l NOTE PROGRAM WILL AUTOMATICALLY ADJUST THIS AMOUNT TO 65 ENTER 100 OF THE NAMEPLATE RATING S OF ELECTRIC SPACE HEATING IF FOUR OR ENTER KA MORE SEPARATELY CONTROLLED UNITS EE ee NOTE PROGRAM WILL AUTOMATICALLY 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 19 GENERAL ENTRIES continued Enter the description number
16. ntage 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 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 Dwel
17. 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 I4 4 h MS Input Calcs Z Then select the File Print Command Microsoft Excel Single SET Arial abe SB E s r an oe NN EU Y EG amp amp v 8 m xS con ox A 2 Z uw E File Edit wiew Insert Format Tools Data Window Help 3 8 Open Cro D CALCULATIONS PROJECT HAME 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 VA 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 the calculations print on more than one page go to the File Page Setup Command and reduce the percentage Page Setup Page Margins Header Footer Sheet Orientation Print Portrait t Landscape SENT 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 Auto Page 21 USING HOUSE PANEL TEMPLATE
18. ror message will appear in a pop up box w YH LL 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 24 GENERAL ENTRIES continued Below is a list of valid entries 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 Q NO NO N 2 CO lt e On e Ol C lt e M oO e 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
19. s 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 A E Then select the File Print Command Microsoft Excel Single Family Arial 3 El Den amp Ml aoran A 5 4 2 Ba 6 100 2 File Edit view Insert Format Tools Data Window DoneEx Help ENS CHN 8 Open Cro D CALCULATIONS PROJECT HAME CO Save As IOH 220 82 DWELLING UNIT Setup HEUTRAL LOAD HEC 220 61 sm FTX3WA 5400 WA TOTAL SQ FOOTAGE 1 800 5011 m VA 3 000 WA APPLIANCE CIRCUITS 2 X 1 500 Create Adobe PDF 1500 VA 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 Page Setup Page Margins Header Faater Sheet Orientation Print 2 TOUR E EA Be J Scaling Adjust En E Bp normal size Fitto 1 pagers wide by 1 tal Paper size ketter Print quality 600 dpi First page number Auto Page 17 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 PA
20. ut 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 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 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 7 VE C HIVOLTAGE _ ER a r PHASE tM OF CABLES EEDER TYPE GER FEEDER CABLE SERCABLEE RESIZE RESIZE l i e GUUS pO WIRE CUAL RESIZE GROUNDS WIRE TEMP C S SUBPANELBKR CIRCUITS 182 _ T PHASE wi T epg U PS mm C MINIMUM AMPS o G x MEME 1 BHTCHENLORDS i a8 J o o NEN 2 JN MAMBKRIFUSE BREAKER SIZE LLLI MNA AX 3 1 Yellow Cells Lime Green Cells House Panel Only 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 er
Download Pdf Manuals
Related Search