ME006_LightingWorkbook.xlsx

XLSX spreadsheet 49 KB Posted Jul 19, 2021

Attached to: Construction - Lighting Upgrade Federal contract opportunity
Solicitation number: W15QKN-21-Q-5126
Issued by: Department of the Army Materiel Command Contracting Command Picatinny Arsenal

View the file

Other files for this federal contract opportunity

Other files attached to Construction - Lighting Upgrade, newest first.
File	Type	Posted
ME010 7828-339 E3 Lighting Plan sht 39 of 51.PDF	PDF	Jul 19, 2021
ME001 29-06-71 Elec 2nd FP sht 57.PDF	PDF	Jul 19, 2021
ME010_LightingWorkbook.xlsx	XLSX spreadsheet	Jul 19, 2021
Inquiries Responses to W15QKN-21-Q-5126 Lighting Upgrade.pdf	PDF	Jul 19, 2021
ME001 29-06-71 Elec 1st FP sht 56.PDF	PDF	Jul 19, 2021
ME001_LightingWorkbook.xlsx	XLSX spreadsheet	Jul 19, 2021
ME006 7829-126 Elec Sch sht 26.PDF	PDF	Jul 19, 2021
ME006 7829-123 Elec FP sht 23.PDF	PDF	Jul 19, 2021
Amendment 0001 Extending Sol Lighting Upgrade.pdf	PDF	Jul 8, 2021
W15QKN-21-Q-5126 Lighting Upgrade Posted to FBO.pdf	PDF	Jun 29, 2021
W15QKN-21-Q-5126 Lighting Upgrade Posted to FBO.pdf	PDF	Jun 29, 2021
Attachment 2 SOW Lighting Upgrade Dexter ME.pdf	PDF	Jun 22, 2021
Attachment 1 SOW Lighting Upgrade Auburn ME.pdf	PDF	Jun 22, 2021
Attachment 4 DavisBacon ME20210015 Auburn.pdf	PDF	Jun 22, 2021
Attachment 5 DavisBacon ME20210017 Dexter.pdf	PDF	Jun 22, 2021
Attachment 3 SOW Lighting Upgrade Saco ME.pdf	PDF	Jun 22, 2021
Contractor Cost Breakdown Form.xls	XLS spreadsheet	Jun 22, 2021
Attachment 6 DavisBacon ME20210019 Saco.pdf	PDF	Jun 22, 2021

Show all 18

On GovTribe

Work with this file on GovTribe

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.

Lighting Fixture Schedule

FROM AS-BUILT										REPLACEMENT SCHEDULE
Fixture Type	Manufacturer	Catalog Number	Volts	LAMP DATA			MOUNTING TYPE	DESCRIPTION
				QTY	BALLAST	TYPE (Watts)			Fixture Style	Fixture Qty	Lamp Qty	Lamp Type	Wattage /lamp	Fixture Wattage	Total Wattage /type
A1			277	3	T8-D835	32	Recessed	2x4 Fluorescent, 3-lamp instant start ballast		15	45	T8 - TLED DIRECT FIT	10	30	450
A2			277	2	T8-D835	32	Wrap Around	1x4 Fluorescent, 2-lamp instant start ballast		42	84	T8 - TLED DIRECT FIT	10	20	840
A3			277	4	T8-D835	32	Wrap Around	1x4 Fluorescent, 4-lamp instant start ballast		2	8	T8 - TLED DIRECT FIT	10	40	80
A4			277	2	T8-D835	32	Recessed	1x4 Fluorescent, 2-lamp instant start ballast		10	20	T8 - TLED DIRECT FIT	10	20	200
A5			277	2	T8-D835	32	Recessed	2x4 Fluorescent, 2-lamp instant start ballast		24	48	T8 - TLED DIRECT FIT	10	20	480
A6			277	4	T5HO	54	High Bay	2x4 Fluorescent, 4-lamp instant start ballast		21	172	HIGH BAY EQ TO 4 T5 HO		136	136
A7			277	2	T8 8 FT	64	Strip	8 feet strip, 2-lamp instant start balast		8	16	8 FT TLED	30	60	480
A8			277	3	T8-D835	32	Wrap Around	1x4 Fluorescent, 3-lamp instant start ballast		6	18	T8 - TLED DIRECT FIT	10	30	180
A9			277	2	T8	32	Strip	4 feet strip, 2-lamp instant star balast		10	20	T8 - TLED DIRECT FIT	10	20	200
									TOTAL	138	431

Lighting Savings

MA022 - Lighting Workbook
INTERIOR LIGHTING
Building		Space Type			Fixture Qty		EXISTING								PROPOSED					PROPOSED CONTROLS			SAVINGS
	Location		Existing Controls	Hours Reduction Factor		Fixture Code (from As-Built)	Type	Lamp Qty	Lamp Wattage	Lamp Type	Actual Fixture Wattage	Annual Runtime Hours	kWbase	kwh base	Lamp Type	Lamp Wattage	Fixture Wattage	kWee	kWh ee	Control Measure?	Control Type	Reduction Factor	CF	IF	Lamp kWh Savings	Lamp kW Savings	Controls kWh Savings	Controls kW Savings	TOTAL kWh Savings	TOTAL Demand Savings (kw)	Comments
Training Ctr	ROOM 125	Office (Occupied)	---	0	6	A1		3	32	T8-D835	96	2600	0.576	1498	T8 - TLED DIRECT FIT	10	30.0	0.18	468	Yes	Occupancy Sensor	0.3	0.68	0	1029.60	0.27	140.40	0.04	1170	0.31
Training Ctr	ROOM 123	Classroom	---	0	9	A2		2	32	T8-D835	64	2600	0.576	1498	T8 - TLED DIRECT FIT	10	20.0	0.18	468	Yes	Occupancy Sensor	0.3	0.68	0	1029.60	0.27	140.40	0.04	1170	0.31
Training Ctr	ROOM 122	Classroom	---	0	9	A2		2	32	T8-D835	64	2600	0.576	1498	T8 - TLED DIRECT FIT	10	20.0	0.18	468	Yes	Occupancy Sensor	0.3	0.68	0	1029.60	0.27	140.40	0.04	1170	0.31
Training Ctr	ROOM B1	Bathroom	Occupancy Sensor	0.3	1	A3		4	32	T8-D835	128	1820	0.128	233	T8 - TLED DIRECT FIT	10	40.0	0.04	73	Yes	---	0.0	0.68	0	160.16	0.06	0.00	0.00	160	0.06
Training Ctr	ROOM 119	Office (Occupied)	---	0	2	A2		2	32	T8-D835	64	2600	0.128	333	T8 - TLED DIRECT FIT	10	20.0	0.04	104	Yes	Occupancy Sensor	0.3	0.68	0	228.80	0.06	31.20	0.01	260	0.07
Training Ctr	ROOM B2	Bathroom	Occupancy Sensor	0.3	1	A2		2	32	T8-D835	64	1820	0.064	116	T8 - TLED DIRECT FIT	10	20.0	0.02	36	Yes	---	0.0	0.68	0	80.08	0.03	0.00	0.00	80	0.03
Training Ctr	ROOM B3	Bathroom	Occupancy Sensor	0.3	1	A3		4	32	T8-D835	128	1820	0.128	233	T8 - TLED DIRECT FIT	10	40.0	0.04	73	Yes	---	0.0	0.68	0	160.16	0.06	0.00	0.00	160	0.06
Training Ctr	ROOM 116	Misc / Storage	---	0	2	A2		2	32	T8-D835	64	900	0.128	115	T8 - TLED DIRECT FIT	10	20.0	0.04	36	Yes	Occupancy Sensor	0.3	0.72	0	79.20	0.06	10.80	0.01	90	0.07
Training Ctr	ROOM 115	Misc / Storage	---	0	6	A4		2	32	T8-D835	64	900	0.384	346	T8 - TLED DIRECT FIT	10	20.0	0.12	108	Yes	Occupancy Sensor	0.3	0.72	0	237.60	0.19	32.40	0.03	270	0.22
Training Ctr	ROOM 112	Misc / Storage	---	0	4	A4		2	32	T8-D835	64	900	0.256	230	T8 - TLED DIRECT FIT	10	20.0	0.08	72	Yes	Occupancy Sensor	0.3	0.72	0	158.40	0.13	21.60	0.02	180	0.14
Training Ctr	ROOM 105	Office (Occupied)	---	0	15	A6		4	54	T5HO	216	2600	3.24	8424	HIGH BAY EQ TO 4 T5 HO	0	136.0	2.04	5304	Yes	Occupancy Sensor	0.3	0.68	0	3120.00	0.82	1591.20	0.42	4711	1.23
Training Ctr	ROOM 102	Misc / Storage	---	0	8	A7		2	64	T8 8 FT	128	900	1.024	922	8 FT TLED	30	60.0	0.48	432	Yes	Occupancy Sensor	0.3	0.72	0	489.60	0.39	129.60	0.10	619	0.50
Training Ctr	ROOM 101	Misc / Storage	---	0	1	A2		2	32	T8-D835	64	900	0.064	58	T8 - TLED DIRECT FIT	10	20.0	0.02	18	Yes	Occupancy Sensor	0.3	0.72	0	39.60	0.03	5.40	0.00	45	0.04
Training Ctr	ROOM 103	Misc / Storage	---	0	4	A9		2	32	T8	64	900	0.256	230	T8 - TLED DIRECT FIT	10	20.0	0.08	72	Yes	Occupancy Sensor	0.3	0.72	0	158.40	0.13	21.60	0.02	180	0.14
Training Ctr	ROOM 110	Bathroom	---	0	3	A5		2	32	T8-D835	64	2600	0.192	499	T8 - TLED DIRECT FIT	10	20.0	0.06	156	Yes	Occupancy Sensor	0.3	0.68	0	343.20	0.09	46.80	0.01	390	0.10
Training Ctr	ROOM 110	Bathroom	---	0	2	A9		2	32	T8	64	2600	0.128	333	T8 - TLED DIRECT FIT	10	20.0	0.04	104	Yes	---	0.0	0.68	0	228.80	0.06	0.00	0.00	229	0.06
Training Ctr	ROOM 109	Bathroom	---	0	3	A5		2	32	T8-D835	64	2600	0.192	499	T8 - TLED DIRECT FIT	10	20.0	0.06	156	Yes	Occupancy Sensor	0.3	0.68	0	343.20	0.09	46.80	0.01	390	0.10
Training Ctr	ROOM 120	Misc / Storage	---	0	4	A9		2	32	T8	64	900	0.256	230	T8 - TLED DIRECT FIT	10	20.0	0.08	72	Yes	Occupancy Sensor	0.3	0.72	0	158.40	0.13	21.60	0.02	180	0.14
Training Ctr	ROOM 126	Office (Occupied)	---	0	6	A1		3	32	T8-D835	96	2600	0.576	1498	T8 - TLED DIRECT FIT	10	30.0	0.18	468	Yes	Occupancy Sensor	0.3	0.68	0	1029.60	0.27	140.40	0.04	1170	0.31
Training Ctr	ROOM 127	Office (Occupied)	---	0	3	A1		3	32	T8-D835	96	2600	0.288	749	T8 - TLED DIRECT FIT	10	30.0	0.09	234	Yes	---	0.0	0.68	0	514.80	0.13	0.00	0.00	515	0.13
Training Ctr	ROOM 118	Office (Occupied)	---	0	2	A2		2	32	T8-D835	64	2600	0.128	333	T8 - TLED DIRECT FIT	10	20.0	0.04	104	Yes	---	0.0	0.68	0	228.80	0.06	0.00	0.00	229	0.06
Training Ctr	ROOM 124	Office (Occupied)	---	0	6	A2		2	32	T8-D835	64	2600	0.384	998	T8 - TLED DIRECT FIT	10	20.0	0.12	312	Yes	Occupancy Sensor	0.3	0.68	0	686.40	0.18	93.60	0.02	780	0.20
Training Ctr	ROOM 129	Corridors / Stairwells	---	0	1	A2		2	32	T8-D835	64	8760	0.064	561	T8 - TLED DIRECT FIT	10	20.0	0.02	175	Yes	Occupancy Sensor	0.3	0.72	0	385.44	0.03	52.56	0.00	438	0.04
Training Ctr	ROOM 111	Office (Occupied)	---	0	6	A8		3	32	T8-D835	96	2600	0.576	1498	T8 - TLED DIRECT FIT	10	30.0	0.18	468	Yes	Occupancy Sensor	0.3	0.68	0	1029.60	0.27	140.40	0.04	1170	0.31
Training Ctr	ROOM 108	Misc / Storage	---	0	9	A2		2	32	T8-D835	64	900	0.576	518	T8 - TLED DIRECT FIT	10	20.0	0.18	162	No	Occupancy Sensor	0.3	0.72	0	356.40	0.29	48.60	0.04	405	0.32
Training Ctr	HALLWAY	Corridors / Stairwells	---	0	18	A5		2	32	T8-D835	64	8760	1.152	10092	T8 - TLED DIRECT FIT	10	20.0	0.36	3154	No	---	0.0	0.72	0	6937.92	0.57	0.00	0.00	6938	0.57
OMS	OMS	OMS	---	0	6	A6		4	54	T5HO	216	2600	1.296	3370	HIGH BAY EQ TO 4 T5 HO	0	136.0	0.816	2122	No	Occupancy Sensor	0.3	0.68	0	1248.00	0.33	636.48	0.17	1884	0.49

TOTAL 36910 15418 TOTAL 21491 5 3492 1 24984 6

EXTERIOR LIGHTS

Building

Space Type

Fix Qty

EXISTING

PROPOSED

CONTROLS

CALCULATIONS

Location

Fixture Type (from As-Builts)

Type

Lamp Qty

Lamp Wattage

Lamp Type

Actual Fixture Wattage

Annual Runtime Hours

kWbase

kwh base

Lamp Type

Lamp Wattage

Fixture Wattage

kWee

kWh ee

Control Measure?

Control Type

Annual Runtime Hours after CM

Lamp kWh Savings

Lamp kW Savings

Controls kWh Savings

Controls kW Savings

TOTAL kWh Savings

TOTAL Demand Savings (kw)

Comments

ERROR:#N/A

Existing Photocell

0.0

ERROR:#N/A

---

ERROR:#N/A

TOTAL

ERROR:#N/A

TOTAL

ERROR:#N/A

TOTAL (ALL LIGHTING) ERROR:#N/A ERROR:#N/A

SUMMARY OF FIXTURE TYPES	Fixtures	Lamps
U	0	0

TOTAL 0 0

Space Type	Runtime Hours	Logic	CF	IF
---	0		1.00	0.00
24hr Load	8760		0.72	0
Corridors / Stairwells	8760		0.72	0
Exterior	4380		1.00	0.00
Misc / Storage	900		0.72	0
Office (Occupied)	2600		0.68	0
Office (Unused)	900		0.68	0
Classroom	2600		0.68	0
Bathroom	2600		0.68	0
OMS	2600		0.68	0

Control Measure	Reduction	Logic	Y/N
---	0.0	No Change
Occupancy Sensor	0.3	NJ TRM	Yes
Daylight Dimming	0	NJ TRM	No
Existing Photocell	0.0	No Change

Sheet1

File details come from the government source that posted it. Updated Jul 19, 2021.