SOV_Excel Template.xlsx

XLSX spreadsheet 494 KB Posted Feb 25, 2025

Attached to: Elwood, Il - Fence Replacement and Lighting (JOL) ARSR in Elwood, IL
Solicitation number: 25-21003734
Issued by: Department of Transportation Federal Aviation Administration Franchise Acquisition Services

About this file

Written by GovTribe AI · Feb 25, 2025

This file is an Excel template and instructions for creating electrical panel schedules and related documentation for federal construction projects. The template includes multiple worksheets for different types of electrical panels (single phase, three phase, distribution, switchboard) and includes functionality for calculating loads, demands, circuit breakers, and other electrical specifications. The template allows for automatic load transfer calculations between panels and provides standardized formatting for panel schedules that can be inserted into AutoCAD drawings.

The template includes detailed instructions for proper use, including requirements for Windows font installation, saving procedures, and steps for transferring loads between panels. It contains reference data tables for impedance values, conductor sizes, and demand factors. While comprehensive in its electrical engineering functionality, this is purely a technical template document and does not contain any specific requirements, deliverables or objectives for a particular project.

View the file

Other files

File	Type	Posted
00004 Elwood IL RFI Amendment Form.pdf	PDF	Mar 31, 2025
Elwood IL RFI 03.31.25.pdf	PDF	Mar 31, 2025
00003 Elwood IL RFI Amendment Form.pdf	PDF	Mar 26, 2025
Wage Determination IL20250020 03.14.2025.pdf	PDF	Mar 26, 2025
Elwood IL RFI 03.26.25.pdf	PDF	Mar 26, 2025
00002 Elwood IL RFI Amendment Form.pdf	PDF	Mar 25, 2025
RFIs Elwood IL combined.pdf	PDF	Mar 25, 2025
00001 Elwood IL Site Visit and Ext Amendment.pdf	PDF	Mar 4, 2025
SOV Elwood IL Excel Template.pdf	PDF	Mar 4, 2025
JOL_ARSR-21003734-Final Drawings.pdf	PDF	Feb 25, 2025
JOL_ARSR_21003734_Specifications.pdf	PDF	Feb 25, 2025
Wage Determination IL20250020 01.03.2025.pdf	PDF	Feb 25, 2025

Show all 12

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Directions

Last Modified: 2011/04/19 by TEM
INSERTION WIDTH SCHEDULE
	SCALES
PANELS		1 to 1	3/8"=1'-0"	1/4"=1'-0"	3/16"=1'-0"	1/8"=1'-0"	3/32"=1'-0"	1/16"=1'-0"
	Unit1ph/Unit3ph	5"	160"	240"	320"	480"	640"	960"
	Pnl1ph/Pnl3ph	10"	320"	480"	640"	960"	1280"	1920"
	Dist1ph/Dist3ph/Swbd3ph	6"	192"	288"	384"	576"	768"	1152"
CALCS	Unit/Unit-Bldg	4"	128"	192"	256"	384"	512"	768"

Why do we have new panel schedules?

1	Not AutoCAD Command Dependant
	These new panel schedules are not AutoCAD Command Dependant. As newer versions of AutoCAD are issued,
	these Excel panel schedules should not require any adjustments.

2	Automatic loading transfer.
	Loads can be automatically recalculated from downstream panels to the panels feeding them. See "How to transfer
	panel loads" below.

3	Per phase load in distribution panel.
	The distribution panels will also contain the per phase load for a more exact calculation.

4	The unit panels are smaller
	The unit panels have been condensed since connected loads in unit panels are irrelevant.

5	Interactive descriptions
	Column load headers (LTG, REC, MTR, etc..) contain popup information describing the load types and requirements
	for entering loads in the specified column. This information can be accessed by placing the pointer over the
	corresponding cell header.

6	Calculations are shown
	Calculations are shown on the bottom right of each panel sheet. The demand and the minimum panel ampacity
	calculations are shown.

Before you begin

1	This spreadsheet can be used with AutoCAD 2004 and newer without any special requirements.
	This spreadsheet can be used in AutoCAD 2002 if the display resolution is a minimum of (1152 x 864).
	Right-click on the desktop and select "PROPERTIES". Now select the "SETTINGS" tab to display the current
	resolution. (See the IT department for assistance)

2	Windows font "QUICK TYPE CONDENSED" must be installed for these schedules to display properly. Go to the
	Windows control panel and open "FONTS". Scroll down thru the installed font files to see if the "QUICK TYPE
	CONDENSED" font is installed. (See the IT department for assistance)

How to Use Panel Schedules

1	Save this panel schedule file in the "ELEC" directory, or a subdirectory under "ELEC", under the job folder you
	will be working on.

2 Select a panel schedule sheet at the bottom of your screen by right-clicking on the corresponding tab.

Your base panel options should be Unit-Bldg, Unit1ph, Unit3ph, Pnl1ph, Pnl3ph, Dist1ph, Dist3ph, Swbd3ph

3 Select the "Move or Copy" command, check the "Create a Copy" box, and then select "OK".

You will now want to give your panel a name.

4 Right-click on the tab at the bottom of the screen and select rename.

You can name your panel anything you like. The longer the name, the more space the tab will take up.

Keep it short.

You can modify the order of the panel tabs by selecting and dragging the tab across the bar.

5 Select the panel tab to begin work on the panel schedule.

6 Enter the voltage for your panel in the panel schedule (ex. 208/120).

7 You may now begin filling in panel information.

To set up a Unit Load Center Schedule, ensure that the unit name, square feet, and HVAC load are entered

correctly into the Unit-Bldg Mix. Enter only the HVAC loads that need to be calculated according to

NEC 220.82 and NEC 220.84. You may now enter the unit name in the appropriate cell of the load center schedule

to automatically update load center title & unit calculations title, as well as update square feet & HVAC load from one location.

The following information can be filled in on the 1ph, 3ph, Dist panel schedules:

Panel Size, Panel Mounting, Panel AIC rating, Breaker Sizes, Circuit Descriptions, Circuit Loads.

In special cases, you may need to edit the demand and minimum panel ampacity (WARNING!! Once the

demand is edited, the demand will not auto-calculate again unless the cell is re-programmed.

The following information should be filled in on the 1ph, 3ph, Dist panel calculations:

Largest Motor Loads and Interlocked loads (optional)

Largest Motor adds the required 25% to your calculation.

Interlocked loads are the smallest of two loads that cannot operate at the same time.

The following information can be filled in on the Unit panel schedule:

Panel Size, Panel Voltage, Panel Mounting, Panel AIC rating, Breaker Sizes, Circuit Descriptions.

Notice that loads will not be entered in the panel schedule because unit panel connected loads are irrelevant.

All panel notes should be done in AutoCAD.

There are many ways to easily modify, copy, and auto-fill loads, breakers, and descriptions in Excel. If you

are unfamiliar with this program, ask someone in your group to help you out.

8	Now we want to insert the panel schedule into AutoCAD.
	Select the panel schedule by clicking and dragging the top left corner of the panel to the lower right corner of
	the panel so the entire panel is highlighted.

9 Right-click in the highlighted area and select "COPY".

	(The rest of these directions are to be completed in AutoCAD.)
10	Go to the model space in the AutoCAD drawing that you wish to place the panel schedule in.

11	Select "EDIT", "PASTE SPECIAL" command in the toolbar. Then select "PASTE LINK".
	The panel schedule should have popped into your drawing.

12	You will now need to resize the schedule so the text will show up at the correct size.
	Type "PROPERTIES" in the command line and hit the "Enter" key.
	Place the mouse pointer over the inserted panel schedule and right-click the mouse.
	Select "PROPERTIES" in the pop-up menu.
	Enter the width in inches from the table at the top of these directions that corresponds to the scale of the
	drawing you are inserting it into

13	The panel schedule size can be changed by selecting the small blue box in the bottom right hand corner of
	the Excel insertion. If the small blue box is not showing, you can click on the panel schedule and one
	should pop up. The panel should be resized so that the width matches the length of the line that was inserted
	as a block

14	The panel schedule can now be moved to the desired location in model space by clicking and dragging the
	schedule.

15	The panel schedule may now be edited by double clicking on the inserted panel in AutoCAD.
	This will automatically open the Excel file.

How to Transfer Panel Loads

*	This procedure transfers the exact connected load per phase of a downstream panel to the panel feeding
	panel. The transferred load will automatically update as loads are added to the downstream panel)

1	Select the tab of the panel you wish to have the loads transfer from.
	The panel connected loads are calculated and place below the panel schedule in a box with load and phase
	descriptions.

2 Select all the loads in the box by clicking and dragging to highlight all the cells.

3 Right-click the highlighted area and select "COPY".

4 Select the tab of the panel you wish to have the loads transfer to.

5 Select the cells where the load is to be transferred to by clicking and dragging to highlight the area.

6 Right-click the highlighted area and select "PASTE SPECIAL".

7	Select "PASTE LINK".
	The cells should now contain the loads from the downstream panel. These loads will automatically update
	as loads are added to the downstream panel.

How to Hide and Unhide rows in Panels

*	Locate the row headers on the far left side of your panel schedule. They are in numerical order from the top of the
	schedule on down.
*	Notice on most of the panels that some numbers are skipped (i.e.. 1,4,5,6,….). This means that rows 2 and 3
	are hidden. These rows are typically hidden because they contain calculation multipliers.
*	Notice on the 3 phase panel that rows are hidden near the bottom of the panel (i.e.. …,28,29,96,97,…). These are
	hidden rows containing additional panel sections that can be un-hidden when needed.
*	Rows may be hidden to display the actual panel size (i.e.. 24 circuit, 30 circuit, etc.).

Hiding Rows

1	Select the top row header of the rows you want to hide (i.e.. To hide rows 24-42, select row 24). Hold the shift key
	and select the bottom row header of the rows you want to hide (i.e.. To hide rows 24-42, select row 42).

2	Right-click in the shaded area and select the "Hide" command in the pop-up menu.
	The rows that you selected and all the rows in between should now be hidden.

Un-Hiding Rows

1	Select the row header above the rows you want to unhide (i.e.. To un-hide rows 24-42, select row 23). Hold the shift
	key and select the row header below the rows you want to hide (i.e.. To un-hide rows 24-42, select row 43).

2	Right-click in the shaded area and select the "Unhide" command in the pop-up menu.
	The rows that you selected and all the rows in between should now be unhidden.

How to copy Panel Information

*	To change a panel from a single phase panel to a three phase panel, you must copy the information from a single
	phase panel to a new three phase panel in sections. Copy each side and each section of a muti-section panels separately.

1	Select all the descriptions on the left side of the panel and copy-paste (paste special, formulas) them into the new panel.
	Use "paste special, formulas" to aviod formatting problems with pasted cells.

2 Copy the right side of the panel the same way.

Things to Remember

*	Be careful not to have multiple sessions of the panel schedule open for editing. This can cause data loss and
	resizing problems.

*	Make sure to close the Excel file before trying to save the AutoCAD file. Your machine may crash and you may loose any
	unsaved information.

*	The load columns for the right side of the panels have changed order to match the left side when read from left
	to right. This was done to make transferring loads from downstream panels to feeding panels easier.

*	For a load to be recalculated and shown properly in AutoCAD, the panel must be edited, the drawing must be
	reopened, or the OLE link must be updated in from the Edit menu in the AutoCAD toolbar.

*	Panels should be sized based upon "TOTAL AMPACITY".
	Demand & Connected loads are the loads to be provided to the project owner or the power company as
	requested.

*	When you "HIDE" or "UNHIDE" rows in excel, the panel schedule needs to be re-inserted. This is done by
	right-clicking the panel schedule in AutoCAD and selecting "CUT". The drawing should disappear from AutoCAD.
	Go to the excel file and copy-paste your panel schedule back into AutoCAD.

What if someone asks for our panel schedules electronically so that they're editable (e.g. for as-builts)?

* So as not to allow anyone outside of JSE to our formulas and calculations:

* Save file to another location (don't change the filename).

*	Go to your first Panelboard tab and highlight the panel schedule, demand calcs, and ampacity required calcs. Right click your
	mouse button can copy. Right click again and paste special. When the past special tab appears, select "values" then hit ok.

*	Repeat this process for all panels and calculations that are used for drawing output. This step overwrites the panel schedules
	and calcs to show only values and not the formulas used to obtain the values.

* Delete all unused tabs from the entire spreadsheet (i.e. Directions tab, Dist3ph tab, Tabulation tab, Data 500 tab, etc.)

* Save file and transmit.

Load Areas

		JOB NAME
		Job Location
		JSE Project 1XXXXXX
		Load Description:		Totals		Interior Lighting		Exterior Lighting		Receptacles		Motor		A/C		Space Heat		Kitchen		Miscellaneous
		Area Description:	Square Footage:	VA/
sq ft	Conn. kVA	VA/
sq ft	Conn. kVA	Pnl Serving	VA/
sq ft	Conn. kVA	Pnl Serving	VA/
sq ft	Conn. kVA	Pnl Serving	VA/
sq ft	Conn. kVA	Pnl Serving	VA/
sq ft	Conn. kVA	Pnl Serving	VA/
sq ft	Conn. kVA	Pnl Serving	VA/
sq ft	Conn. kVA	Pnl Serving	VA/
sq ft	Conn. kVA	Pnl Serving
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
					0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0		0.0
		Totals	0	ERROR:#DIV/0!	0.0	ERROR:#DIV/0!	0.0	ERROR:#DIV/0!	0.0	ERROR:#DIV/0!	0.0	ERROR:#DIV/0!	0.0	ERROR:#DIV/0!	0.0	ERROR:#DIV/0!	0.0	ERROR:#DIV/0!	0.0	ERROR:#DIV/0!	0.0

Load Panels

JOB NAME																																							Average Pole Loading	INT LTG	EXT LTG	REC	MTR	A/C	HTG	KIT	MISC
Job Location																																							120	0.860048258	0.8373470023	0.7423067493	2.1020790454	2.9460257921	2.6362383106	1.4874070344	1.7970909435
JSE Project 1XXXXXX																																							277	2	2	1.5	2	4	5	1.5	1
		Totals						Interior Lighting				Exterior Lighting			Receptacles				Motor				A/C				Space Heat				Kitchen				Miscellaneous
Panel Name	Voltage	Est Load	Actual Load Lookup	Actual Load	Est Poles Lookup	Est Poles	Diff (%)	Est Load	Actual Load Lookup	Actual Load	Est Poles	Est Load	Actual Load	Est Poles	Est Load	Actual Load Lookup	Actual Load	Est Poles	Est Load	Actual Load Lookup	Actual Load	Est Poles	Est Load	Actual Load Lookup	Actual Load	Est Poles	Est Load	Actual Load Lookup	Actual Load	Est Poles	Est Load	Actual Load Lookup	Actual Load	Est Poles	Est Load	Actual Load Lookup	Actual Load	Est Poles
LC1	L	0.0	ERROR:#VALUE!		0			0.0	ERROR:#REF!		0	0.0		0	0.0	ERROR:#REF!		0	0.0	ERROR:#REF!		0	0.0	ERROR:#REF!		0	0.0	ERROR:#REF!		0	0.0	ERROR:#REF!		0	0.0	ERROR:#REF!		0
HC1	H	0.0	ERROR:#VALUE!		0			0.0	ERROR:#REF!		0	0.0		0	0.0	ERROR:#REF!		0	0.0	ERROR:#REF!		0	0.0	ERROR:#REF!		0	0.0	ERROR:#REF!		0	0.0	ERROR:#REF!		0	0.0	ERROR:#REF!		0
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
		0.0	ERROR:#VALUE!		ERROR:#VALUE!			0.0	ERROR:#REF!			0.0			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!			0.0	ERROR:#REF!
Totals		0.0		0.0

Impedance Data

	Copper						Aluminum
	Steel Conduit			PVC Conduit			Steel Conduit			PVC Conduit
Feeder Designation	Reactance	Resistance	C Value	Reactance	Resistance	C Value	Reactance	Resistance	C Value	Reactance	Resistance	C Value
14	0.073	3.1	389	0.058	3.1	389	0.073	N/A	237	0.058	N/A	237
12	0.068	2	617	0.054	2	617	0.068	3.2	376	0.054	3.2	376
10	0.063	1.2	981	0.05	1.2	982	0.063	2	599	0.05	2	599
8	0.065	0.78	1557	0.052	0.78	1559	0.065	1.3	951	0.052	1.3	952
6	0.064	0.49	2425	0.051	0.49	2430	0.064	0.81	1481	0.051	0.81	1482
4	0.06	0.31	3806	0.048	0.31	3826	0.06	0.51	2346	0.048	0.51	2350
3	0.059	0.25	4774	0.047	0.25	4811	0.059	0.4	2952	0.047	0.4	2961
2	0.057	0.2	5907	0.045	0.19	6044	0.057	0.32	3713	0.045	0.32	3730
1	0.057	0.16	7293	0.046	0.15	7493	0.057	0.25	4645	0.046	0.25	4678
36526	0.055	0.12	8925	0.044	0.12	9317	0.055	0.2	5777	0.044	0.2	5838
36557	0.054	0.1	10755	0.043	0.1	11424	0.054	0.16	7187	0.043	0.16	7301
36586	0.052	0.079	12844	0.042	0.077	13923	0.052	0.13	8826	0.042	0.13	9110
36617	0.051	0.063	15082	0.041	0.062	16673	0.051	0.1	10741	0.041	0.1	11174
250	0.052	0.054	16483	0.041	0.052	18594	0.052	0.086	12122	0.041	0.085	12862
300	0.051	0.045	18177	0.041	0.044	20868	0.051	0.072	13910	0.041	0.071	14923
350	0.05	0.039	19704	0.04	0.038	22737	0.05	0.063	15484	0.04	0.061	16813
400	0.049	0.035	20566	0.04	0.033	24297	0.049	0.055	16671	0.04	0.054	18506
500	0.048	0.029	22185	0.039	0.027	26706	0.048	0.045	18756	0.039	0.043	21391
600	0.048	0.025	22965	0.039	0.023	28033	0.048	0.038	20093	0.039	0.036	23451
750	0.048	0.021	24137	0.038	0.019	29735	0.048	0.031	21766	0.038	0.029	25976
1000	0.046	0.018	25278	0.037	0.015	31491	0.046	0.025	23478	0.037	0.023	28779

Data 750

	Copper								Aluminum
Feeder Designation	# of sets	Conduit Size 3 Phase N&G	Conduit Size 3 Phase G	Phase Conductors	Neutral Conductor	Ground Conductor	XFMR Secondary Ground Conductor		# of sets	Conduit Size 3 Phase N&G	Conduit Size 3 Phase G	Phase Conductors	Neutral Conductor	Ground Conductor	XFMR Secondary Ground Conductor
15	1	3/4	3/4	12	12	12	8
20	1	3/4	3/4	12	12	12	8
30	1	3/4	3/4	10	10	10	8
40	1	1	3/4	8	8	10	8
50	1	1	3/4	8	8	10	8
60	1	1	1	6	6	8	8
70	1	1 1/4	1 1/4	4	4	8	8
85	1	1 1/4	1 1/4	4	4	8	8
100	1	1 1/4	1 1/4	3	3	8	8	100	1	1 1/2	1 1/2	1	1	6	6
115	1	1 1/2	1 1/4	2	2	6	8	120	1	2	1 1/2	1/0	1/0	4	6
130	1	1 1/2	1 1/2	1	1	6	6	135	1	2	2	2/0	2/0	4	4
150	1	2	1 1/2	1/0	1/0	6	6	155	1	2	2	3/0	3/0	4	4
175	1	2	2	2/0	2/0	6	4	180	1	2 1/2	2	4/0	4/0	4	2
200	1	2 1/2	2	3/0	3/0	6	4	205	1	3	2 1/2	250	250	4	2
230	1	2 1/2	2	4/0	4/0	4	2	230	1	3	2 1/2	300	300	2	1/0
255	1	3	2 1/2	250	250	4	2	250	1	3	3	350	350	2	1/0
285	1	3	3	300	300	4	2	270	1	3	3	400	400	2	1/0
310	1	3	3	350	350	4	2	310	1	4	4	500	500	2	1/0
335	1	3	3	400	400	4	1/0	360	2	2 1/2	2	4/0	4/0	1	1/0
380	1	4	4	500	500	3	1/0	410	2	3	2 1/2	250	250	1	1/0
400	2	2 1/2	2	3/0	3/0	3	1/0	460	2	3	2 1/2	300	300	1/0	3/0
460	2	2 1/2	2	4/0	4/0	2	1/0	500	2	3	3	350	350	1/0	3/0
510	2	3	2 1/2	250	250	2	1/0	620	2	4	4	500	500	2/0	4/0
620	2	3	3	350	350	1	2/0	750	3	3	3	350	350	3/0	4/0
760	2	4	4	500	500	1/0	2/0	810	3	4	3	400	400	3/0	4/0
855	3	3	2 1/2	300	300	1/0	2/0	1000	4	3	3	350	350	4/0	4/0
1000	3	4	3	400	400	2/0	3/0	1200	4	4	4	500	500	250	250
1200	3	4	4	600	600	3/0	3/0	1600	6	4	3	400	400	350	250
1600	4	4	4	600	600	4/0	3/0	2000	6	4	4	600	600	400	250
2000	5	4	4	600	600	250	3/0	2500	7	4	4	750	750	600	250
2500	6	4	4	600	600	350	3/0	3000	8	4	4	750	750	600	250
3000	8	4	4	500	500	400	3/0	4000	12	4	4	600	600	400	250
4000	11	4	4	500	500	500	3/0

XFMR Z

-
3	3.89%
6	3.22%
9	2.58%
15	6.10%
30	5.60%
45	5.40%
50	5.40%
75	6.40%
112.5	5.80%
150	4.40%
225	7.00%
300	7.40%
500	8.00%
750	7.60%
1000	10.00%
1200	10.00%
1500	10.00%
2000	10.00%
2500	10.00%
2800	10.00%

Output for Drawing

SCHEDULE OF FEEDERS & SERVICES
Feeder/Service Description						Number of Runs			Conductor Size											Conduit Diameter (in)
Designation			Equipment Served	Conductor Ampacity (Amps)	Copper or Aluminum				Phase Conductor				Neutral Conductor				Equipment Ground
F	A	00	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	01	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	02	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	03	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	04	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	05	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	06	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	07	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	08	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	09	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	10	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	11	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	12	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	13	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	14	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	15	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	16	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	17	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	18	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	19	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	20	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	21	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	22	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
F	A	31	-	-	-		-			-		ERROR:#REF!		-		ERROR:#REF!		-		-
ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!			ALUMINUM	-
0	0	00										ERROR:#REF!				ERROR:#REF!				EG
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!			-	-
0	0	00										ERROR:#REF!				ERROR:#REF!			100	1
0	0	00										ERROR:#REF!				ERROR:#REF!			120	1
0	0	00										ERROR:#REF!				ERROR:#REF!			135	1
0	0	00										ERROR:#REF!				ERROR:#REF!			155	1
0	0	00										ERROR:#REF!				ERROR:#REF!			180	1
0	0	00										ERROR:#REF!				ERROR:#REF!			205	1
0	0	00										ERROR:#REF!				ERROR:#REF!			230	1
0	0	00										ERROR:#REF!				ERROR:#REF!			250	1
0	0	00										ERROR:#REF!				ERROR:#REF!			270	1
0	0	00										ERROR:#REF!				ERROR:#REF!			310	1
0	0	00										ERROR:#REF!				ERROR:#REF!			360	1
0	0	00										ERROR:#REF!				ERROR:#REF!			410	1
0	0	00										ERROR:#REF!				ERROR:#REF!			460	1
0	0	00										ERROR:#REF!				ERROR:#REF!			500	1
0	0	00										ERROR:#REF!				ERROR:#REF!			620	1
0	0	00										ERROR:#REF!				ERROR:#REF!			750	1
0	0	00										ERROR:#REF!				ERROR:#REF!			810	1
0	0	00										ERROR:#REF!				ERROR:#REF!			1000	1
0	0	00										ERROR:#REF!				ERROR:#REF!			1200	1
0	0	00										ERROR:#REF!				ERROR:#REF!			1600	1
0	0	00										ERROR:#REF!				ERROR:#REF!			2000	1
0	0	00										ERROR:#REF!				ERROR:#REF!			2500	1
0	0	00										ERROR:#REF!				ERROR:#REF!			3000	1
0	0	00										ERROR:#REF!				ERROR:#REF!			4000	2
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!			ALUMINUM	-
0	0	00										ERROR:#REF!				ERROR:#REF!				EG
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!			-	-
0	0	00										ERROR:#REF!				ERROR:#REF!			100	1
0	0	00										ERROR:#REF!				ERROR:#REF!			120	1
0	0	00										ERROR:#REF!				ERROR:#REF!			135	1
0	0	00										ERROR:#REF!				ERROR:#REF!			155	1
0	0	00										ERROR:#REF!				ERROR:#REF!			180	1
0	0	00										ERROR:#REF!				ERROR:#REF!			205	1
0	0	00										ERROR:#REF!				ERROR:#REF!			230	1
0	0	00										ERROR:#REF!				ERROR:#REF!			250	1
0	0	00										ERROR:#REF!				ERROR:#REF!			270	1
0	0	00										ERROR:#REF!				ERROR:#REF!			310	1
0	0	00										ERROR:#REF!				ERROR:#REF!			360	1
0	0	00										ERROR:#REF!				ERROR:#REF!			410	1
0	0	00										ERROR:#REF!				ERROR:#REF!			460	1
0	0	00										ERROR:#REF!				ERROR:#REF!			500	1
0	0	00										ERROR:#REF!				ERROR:#REF!			620	1
0	0	00										ERROR:#REF!				ERROR:#REF!			750	1
0	0	00										ERROR:#REF!				ERROR:#REF!			810	1
0	0	00										ERROR:#REF!				ERROR:#REF!			1000	1
0	0	00										ERROR:#REF!				ERROR:#REF!			1200	1
0	0	00										ERROR:#REF!				ERROR:#REF!			1600	1
0	0	00										ERROR:#REF!				ERROR:#REF!			2000	1
0	0	00										ERROR:#REF!				ERROR:#REF!			2500	2
0	0	00										ERROR:#REF!				ERROR:#REF!			3000	2
0	0	00										ERROR:#REF!				ERROR:#REF!			4000	2
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
0	0	00										ERROR:#REF!				ERROR:#REF!				-
KEY: "CU" - COPPER "AL" - ALUMINUM
NOTES: COPPER OR ALUMINUM REFERS TO ALL CONDUCTORS (PHASE, NEUTRAL, AND GROUND)

DATA VALIDATION

Description	MAX CONDUCTOR SIZE	CONDUIT TYPES	CONDUCTOR MATERIAL	NEUTRAL/GROUND CONFIGURATION	PHASE	VOLTAGE	COPPER	ALUMINUM
Values	-	-	-	-	-	-	-	-
\|	500	EMT	CU	S	1	480	15	100
\|	750	PVC	AL	G	3	208	20	120
\/		RGS		NG		240	30	135
		MC		SD			40	155
							50	180
							60	205
							70	230
							85	250
							100	270
							115	310
							130	360
							150	410
							175	460
							200	500
							230	620
							255	750
							285	810
							310	1000
							335	1200
							380	1600
							400	2000
							460	2500
							510	3000
							620	4000
							760
							855
							1000
							1200
							1600
							2000
							2500
							3000
							4000

EGC TABLES

EGC QTY FOR 500 MAX						EGC QTY FOR 750 MAX
ALUMINUM			COPPER			ALUMINUM			COPPER			OCPD	CU 500	CU 750	AL 500	AL 750
	EG	XFMR		EG	XFMR		EG	XFMR		EG	XFMR	-
			-						-			15	14	14	12	12
			15	1	1				15	1	1	20	12	12	10	10
			20	1	1				20	1	1	25	10	10	8	8
			30	1	1				30	1	1	30	10	10	8	8
			40	1	1				40	1	1	35	10	10	8	8
			50	1	1				50	1	1	40	10	10	8	8
			60	1	1				60	1	1	45	10	10	8	8
			70	1	1				70	1	1	50	10	10	8	8
-			85	1	1	-			85	1	1	60	10	10	8	8
100	1	1	100	1	1	100	1	1	100	1	1	70	8	8	6	6
120	1	1	115	1	1	120	1	1	115	1	1	80	8	8	6	6
135	1	1	130	1	1	135	1	1	130	1	1	90	8	8	6	6
155	1	1	150	1	1	155	1	1	150	1	1	100	8	8	6	6
180	1	1	175	1	1	180	1	1	175	1	1	110	6	6	4	4
205	1	1	200	1	1	205	1	1	200	1	1	125	6	6	4	4
230	1	1	230	1	1	230	1	1	230	1	1	150	6	6	4	4
250	1	1	255	1	1	250	1	1	255	1	1	175	6	6	4	4
270	1	1	285	1	1	270	1	1	285	1	1	200	6	6	4	4
310	1	1	310	1	1	310	1	1	310	1	1	225	4	4	2	2
360	1	1	335	1	1	360	1	1	335	1	1	250	4	4	2	2
410	1	1	380	1	1	410	1	1	380	1	1	300	4	4	2	2
460	1	1	400	1	1	460	1	1	400	1	1	350	3	3	1	1
500	1	1	460	1	1	500	1	1	460	1	1	400	3	3	1	1
620	1	1	510	1	1	620	1	1	510	1	1	450	2	2	1/0	1/0
750	1	1	620	1	1	750	1	1	620	1	1	500	2	2	1/0	1/0
810	1	1	760	1	1	810	1	1	760	1	1	600	1	1	2/0	2/0
1000	1	1	855	1	1	1000	1	1	855	1	1	700	1	1	2/0	2/0
1200	1	1	1000	1	1	1200	1	1	1000	1	1	800	1/0	1/0	3/0	3/0
1600	1	1	1200	1	1	1600	1	1	1200	1	1	1000	2/0	2/0	4/0	4/0
2000	1	1	1600	1	1	2000	1	1	1600	1	1	1200	3/0	3/0	250	250
2500	2	1	2000	1	1	2500	1	1	2000	1	1	1600	4/0	4/0	350	350
3000	2	1	2500	1	1	3000	1	1	2500	1	1	2000	250	250	400	400
4000	2	1	3000	1	1	4000	2	1	3000	1	1	2500	350	350	300	600
			4000	1	1				4000	1	1	3000	400	400	300	600
												4000	500	500	400	400

LFS

LIGHTING FIXTURE SCHEDULE
TYPE	DESCRIPTION	MANUFACTURER CATALOG NO.	LAMPS	WATTAGE	POWER FACTOR	LOAD (VA)
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.95	ERROR:#N/A
					0.95	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
					0.9	ERROR:#N/A
NOTES:

1. ALL LIGHTING FIXTURES MAY NOT NECESSARILY BE USED.

2. FINAL FIXTURE SELECTIONS TO BE SUBMITTED TO AND APPROVED BY OWNER.

3. ALL EXTERIOR FIXTURES TO HAVE COLD WEATHER BALLASTS.

4. ALL FIXTURES ARE TO BE LISTED.

5. ALL OUTDOOR EMERGENCY FIXTURES SHALL BE DAMP AND/OR WET LOCATION LISTED (AS APPLICABLE TO INSTALLATION) AND SHALL BE

PROVIDED WITH 0°F, COLD WEATHER BALLASTS (FLUORESCENT AND HID FIXTURES).

6. ALL EXTERIOR AND SITE/LANDSCAPE LIGHTING MUST ADHERE TO ALL LOCAL LIGHTING ORDINANCES AND REQUIREMENTS. PROVIDE SHIELDING, GLARE CONTROL, HARDWARE OPTIONS AND ACCESSORIES AS NECESSARY TO COMPLY.

7. FINAL APPROVAL OF ALL LIGHT FIXTURES TO BE BY THE ARCHITECT AND OWNER DURING SUBMITTAL PHASE AND PRIOR TO ANY ORDERING, PURCHASE OR INSTALLATION OF LIGHT FIXTURES.

8. ALL RECESSED LIGHTING FIXTURES SHALL BE TYPE IC RATED, MANUFACTURED WITH NO PENETRATIONS BETWEEN THE INSIDE OF THE RECESSED FIXTURE AND THE CEILING CAVITY AND SEALED TO PREVENT AIR LEAKAGE, OR SHALL BE INSTALLED IN A SEALED BOX MAINTAINING THE REQUIRED CLEARANCES OF NOT LESS THAN 1" FROM COMBUSTIBLE MATERIAL AND NOT LESS THAN 3" FROM INSULATION MATERIAL.

ResCheck

			UNITS
FIXTURE TYPE	# HIGH EFF LAMPS	# LOW EFF LAMPS
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
X
	Total Lamps:		0	0	0	0	0	0
	Total High Eff Lamps:		0	0	0	0	0	0
	Total Low Eff Lamps:		0	0	0	0	0	0
	Pass/Fail:		PASS	PASS	PASS	PASS	PASS	PASS

LTG Loads

CIRCUIT DESCRIPTION	CIRCUIT NUMBER	VOLTAGE		FIXTURE TYPE:
				COUNT:	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
			POLE	TOTAL LOAD (kVA)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00
			1	0.00

Resi Matrix

METER CENTERS

MC1A

MC1B

MC1C

MC1D

MC1E

MC2A

MC2B

MC2C

MC2D

Correct #'s

UNITS

ERROR:#REF!

A7N

ERROR:#REF!

A7S

ERROR:#REF!

A9S

ERROR:#REF!

A10E

ERROR:#REF!

A10C

ERROR:#REF!

A10S

ERROR:#REF!

A11

ERROR:#REF!

A12

ERROR:#REF!

A13

ERROR:#REF!

A14

ERROR:#REF!

A15

ERROR:#REF!

A16

ERROR:#REF!

B1C

ERROR:#REF!

B1E

ERROR:#REF!

TOTALS:

ERROR:#REF!

TOTAL UNITS:

ERROR:#REF!

TABULATION

TABULATION OF FEEDERS AND SERVICES
Max Conductor Size	Feeder/Service Description											Number of Runs	Conductor Size						Conduit Diameter (in)	Voltage Drop												Fault Current Calculation
	Designation			Equipment Served	XFMR kVA	OCPD Rating	Copper or Aluminum	Conductor Ampacity		RGS, EMT or PVC	Length of run (ft)		Phase Conductor		Neutral Conductor		Equipment Ground			Voltage	Phase	Ampacity Required	Ferrous?	Reactance	Resistance	Load PF	Load RF	Effective Length (kFT)	Point to Point	Fed From	Cumulative	Starting AFC	C Value	f-Value	Fed XFMR kVA	M Value	Calculated Fault Value
-	F	A	00	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	01	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	02	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	03	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	04	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	05	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	06	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	07	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	08	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
	F	A	09	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	10	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	11	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	12	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	13	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	14	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	15	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	16	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	17	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	18	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	19	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	20	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-
-	F	A	21	-	-	-	-	-	-	-	-	-		-		-		-	-	-	-	-	FE	ERROR:#VALUE!	ERROR:#VALUE!	0.95	0.31	ERROR:#VALUE!	-	-	-	-	-	-	-	-	-

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Feb 25, 2025.