ME010_LightingWorkbook.xlsx

XLSX spreadsheet 51 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
ME006 7829-126 Elec Sch sht 26.PDF	PDF	Jul 19, 2021
ME006 7829-123 Elec FP sht 23.PDF	PDF	Jul 19, 2021
ME001 29-06-71 Elec 1st FP sht 56.PDF	PDF	Jul 19, 2021
ME006_LightingWorkbook.xlsx	XLSX spreadsheet	Jul 19, 2021
ME001_LightingWorkbook.xlsx	XLSX spreadsheet	Jul 19, 2021
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
Inquiries Responses to W15QKN-21-Q-5126 Lighting Upgrade.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
Contractor Cost Breakdown Form.xls	XLS spreadsheet	Jun 22, 2021
Attachment 6 DavisBacon ME20210019 Saco.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
Attachment 2 SOW Lighting Upgrade Dexter ME.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	Qty	Wattage /lamp	Fixture Wattage	Total Wattage /type
A1			277	4	T5HO	54	High Bay	2x4 Fluorescent, 4-lamp instant start ballast		27	108	HIGH BAY EQ TO 4 T5 HO	1	136	136	14688
A2			277	1	T8-D835	32	Wrap Around	1x4 Fluorescent, 1-lamp instant start ballast		4	4	T8 - TLED DIRECT FIT	1	10	10	40
A3			277	2	T8-D835	32	Wrap Around	1x4 Fluorescent, 2-lamp instant start ballast		40	80	T8 - TLED DIRECT FIT	2	10	20	800
A4			277	2	T8-D835	32	Recessed	2x4 Fluorescent, 2-lamp instant start ballast		67	134	T8 - TLED DIRECT FIT	2	10	20	1340
A5			277	3	T8-D835	32	Recessed	2x4 Fluorescent, 3-lamp instant start ballast		21	63	T8 - TLED DIRECT FIT	3	10	30	630
A6			277	4	T8-D836	32	Recessed	2x4 Fluorescent, 4-lamp instant start ballast		10	1	T8 - TLED DIRECT FIT	4	10	40	10
A7			277	1	T8-D836	32	Strip	4 feet strip, 1-lamp instant star balast		2	2	T8 - TLED DIRECT FIT	1	10	10	20

TOTAL 171 392

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 Qty	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 101	Office (Occupied)	---	0	15	A1		4	54	T5HO	216	2600	3.24	8424	1	HIGH BAY EQ TO 4 T5 HO	136	136.0	2.04	5304	No	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	2	A2		1	32	T8-D835	32	900	0.064	58		T8 - TLED DIRECT FIT	10	10.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	2	A2		1	32	T8-D835	32	900	0.064	58		T8 - TLED DIRECT FIT	10	10.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 104	Misc / Storage	---	0	8	A3		2	32	T8-D835	64	900	0.512	461		T8 - TLED DIRECT FIT	10	20.0	0.16	144	Yes	Occupancy Sensor	0.3	0.72	0	316.80	0.25	43.20	0.03	360	0.29
Training Ctr	ROOM 105	Misc / Storage	---	0	3	A3		2	32	T8-D835	64	900	0.192	173		T8 - TLED DIRECT FIT	10	20.0	0.06	54	Yes	Occupancy Sensor	0.3	0.72	0	118.80	0.10	16.20	0.01	135	0.11
Training Ctr	ROOM 106	Misc / Storage	---	0	6	A3		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 107	Office (Occupied)	---	0	5	A3		2	32	T8-D835	64	2600	0.32	832		T8 - TLED DIRECT FIT	10	20.0	0.1	260	Yes	Occupancy Sensor	0.3	0.68	0	572.00	0.15	78.00	0.02	650	0.17
Training Ctr	ROOM 108	Office (Occupied)	---	0	6	A4		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 109	Misc / Storage	---	0	6	A3		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 110	Bathroom	---	0	4	A3		2	32	T8-D835	64	2600	0.256	666		T8 - TLED DIRECT FIT	10	20.0	0.08	208	Yes	Occupancy Sensor	0.3	0.68	0	457.60	0.12	62.40	0.02	520	0.14
Training Ctr	ROOM 111	Bathroom	---	0	8	A3		2	32	T8-D835	64	2600	0.512	1331		T8 - TLED DIRECT FIT	10	20.0	0.16	416	Yes	Occupancy Sensor	0.3	0.68	0	915.20	0.24	124.80	0.03	1040	0.27
Training Ctr	ROOM 112	Office (Occupied)	---	0	14	A4		2	32	T8-D835	64	2600	0.896	2330		T8 - TLED DIRECT FIT	10	20.0	0.28	728	Yes	Occupancy Sensor	0.3	0.68	0	1601.60	0.42	218.40	0.06	1820	0.48
Training Ctr	ROOM 113	Office (Occupied)	---	0	2	A5		3	32	T8-D835	96	2600	0.192	499		T8 - TLED DIRECT FIT	10	30.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 114	Office (Occupied)	---	0	2	A5		3	32	T8-D835	96	2600	0.192	499		T8 - TLED DIRECT FIT	10	30.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 115	Office (Occupied)	---	0	3	A5		3	32	T8-D835	96	2600	0.288	749		T8 - TLED DIRECT FIT	10	30.0	0.09	234	Yes	Occupancy Sensor	0.3	0.68	0	514.80	0.13	70.20	0.02	585	0.15
Training Ctr	ROOM 116	Office (Occupied)	---	0	2	A6		4	32	T8-D836	128	2600	0.256	666		T8 - TLED DIRECT FIT	10	40.0	0.08	208	Yes	Occupancy Sensor	0.3	0.68	0	457.60	0.12	62.40	0.02	520	0.14
Training Ctr	ROOM 117	Office (Occupied)	---	0	2	A4		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 118	Office (Occupied)	---	0	2	A6		4	32	T8-D836	128	2600	0.256	666		T8 - TLED DIRECT FIT	10	40.0	0.08	208	Yes	Occupancy Sensor	0.3	0.68	0	457.60	0.12	62.40	0.02	520	0.14
Training Ctr	ROOM 119	Office (Occupied)	---	0	2	A6		4	32	T8-D836	128	2600	0.256	666		T8 - TLED DIRECT FIT	10	40.0	0.08	208	Yes	Occupancy Sensor	0.3	0.68	0	457.60	0.12	62.40	0.02	520	0.14
Training Ctr	ROOM 120	Office (Occupied)	---	0	4	A4		2	32	T8-D835	64	2600	0.256	666		T8 - TLED DIRECT FIT	10	20.0	0.08	208	Yes	Occupancy Sensor	0.3	0.68	0	457.60	0.12	62.40	0.02	520	0.14
Training Ctr	ROOM 121	Bathroom	---	0	2	A7		1	32	T8-D836	32	2600	0.064	166		T8 - TLED DIRECT FIT	10	10.0	0.02	52	Yes	Occupancy Sensor	0.3	0.68	0	114.40	0.03	15.60	0.00	130	0.03
Training Ctr	ROOM 122	Bathroom	---	0	1	A4		2	32	T8-D835	64	2600	0.064	166		T8 - TLED DIRECT FIT	10	20.0	0.02	52	Yes	Occupancy Sensor	0.3	0.68	0	114.40	0.03	15.60	0.00	130	0.03
Training Ctr	ROOM 123	Office (Occupied)	---	0	6	A4		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 124	Office (Occupied)	---	0	22	A4		2	32	T8-D835	64	2600	1.408	3661		T8 - TLED DIRECT FIT	10	20.0	0.44	1144	Yes	Occupancy Sensor	0.3	0.68	0	2516.80	0.66	343.20	0.09	2860	0.75
Training Ctr	ROOM 125	Office (Occupied)	---	0	2	A5		3	32	T8-D835	96	2600	0.192	499		T8 - TLED DIRECT FIT	10	30.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 126	Office (Occupied)	---	0	2	A5		3	32	T8-D835	96	2600	0.192	499		T8 - TLED DIRECT FIT	10	30.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 127	Office (Occupied)	---	0	2	A5		3	32	T8-D835	96	2600	0.192	499		T8 - TLED DIRECT FIT	10	30.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 128	Office (Occupied)	---	0	3	A5		3	32	T8-D835	96	2600	0.288	749		T8 - TLED DIRECT FIT	10	30.0	0.09	234	Yes	Occupancy Sensor	0.3	0.68	0	514.80	0.13	70.20	0.02	585	0.15
Training Ctr	ROOM 129	Office (Occupied)	---	0	2	A6		4	32	T8-D836	128	2600	0.256	666		T8 - TLED DIRECT FIT	10	40.0	0.08	208	No	Occupancy Sensor	0.3	0.68	0	457.60	0.12	62.40	0.02	520	0.14
Training Ctr	ROOM 130	Office (Occupied)	---	0	2	A6		4	32	T8-D836	128	2600	0.256	666		T8 - TLED DIRECT FIT	10	40.0	0.08	208	No	Occupancy Sensor	0.3	0.68	0	457.60	0.12	62.40	0.02	520	0.14
Training Ctr	ROOM 136	Office (Occupied)	---	0	3	A5		3	32	T8-D835	96	2600	0.288	749		T8 - TLED DIRECT FIT	10	30.0	0.09	234	No	Occupancy Sensor	0.3	0.68	0	514.80	0.13	70.20	0.02	585	0.15
Training Ctr	ROOM 137	Office (Occupied)	---	0	2	A5		3	32	T8-D835	96	2600	0.192	499		T8 - TLED DIRECT FIT	10	30.0	0.06	156	No	Occupancy Sensor	0.3	0.68	0	343.20	0.09	46.80	0.01	390	0.10
Training Ctr	ROOM 138	Office (Occupied)	---	0	12	A4		2	32	T8-D835	64	2600	0.768	1997		T8 - TLED DIRECT FIT	10	20.0	0.24	624	No	Occupancy Sensor	0.3	0.68	0	1372.80	0.36	187.20	0.05	1560	0.41
OMS	MAINTENANCE BAY	OMS	---	0	12	A1		4	54	T5HO	216	2600	2.592	6739	1	HIGH BAY EQ TO 4 T5 HO	136	136.0	1.632	4243	No	Occupancy Sensor	0.3	0.68	0	2496.00	0.65	1272.96	0.33	3769	0.99

TOTAL 39317 17095 TOTAL 22222 6 5129 1 27350 8

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

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