Existing Lighting.xlsx

XLSX spreadsheet 66 KB Posted Sep 7, 2021

Attached to: 127EAX21Q0080 Upgrade the lighting
Solicitation number: 127EAX21Q0080
Issued by: Department of Agriculture Forest Service

View the file

Other files

File	Type	Posted
Executed Solicitation_127EAX21Q0080.pdf	PDF	Sep 7, 2021

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.

LAKESIDE

	Room	Type	Area	Control(s)	Usage hrs/wk	F32T8 Fixtures/
Area	Other Fixtures/
Area	Fixture Code	Watts/
Fixture	Watts/
Group	Lamps/
Fixt	Watts/
Lamp	kWh/
Year	Light Readings (fc)	Length (x)
in feet	Width (y) in feet	Height (z) in feet	Notes
	1	Storage	Storage	Manual Switch	6	1		F32T8	64	64	2	32	20		8.67	9.42	7.87
	2	Office	Rec. Lands & Minerals	Occupancy Sensor	50	2		F32T8	64	128	2	32	333		10.00	9.42	7.87
	3	Mechanical/
Storage	Furnace
(Rec. Lands)	Manual Switch	6		1	CF2T36W	36	36	1	36	11		9.30	9.42	8.00	No spare parts easily accessible, assumed 36 W
	4	Dining	Break Room	Manual Switch	50	6		F32T8	64	384	2	32	998		18.40	9.33	7.87
	5	Office	Fire Staff	Manual Switch	50	2		F32T8	64	128	2	32	333		10.50	9.42	7.94
	6	Copy Room	Copy Room	Manual Switch	50	2		F32T8	64	128	2	32	333		8.42	9.42	10.50
	7	Corridor	C	Manual Switch	50	3		F32T8	64	192	2	32	499		38.50	3.58	6.86
	8	Office	Planning Staff	Manual Switch	50	2		F32T8	64	128	2	32	333		9.75	13.50	9.60
	9	Office	LEO	Occupancy Sensor	50	2		F32T8	64	128	2	32	333		9.60	13.50	9.60
	10	Office	Deputy Ranger	Manual Switch	50	4		F32T8	64	256	2	32	666		11.00	17.00	9.60
	11	Office	Rec/Staff	Manual Switch	50	4		F32T8	64	256	2	32	666		11.25	17.00	9.60
	12	Office	DFR	Occupancy Sensor	50	4		F32T8	64	256	2	32	666		11.75	17.00	9.60
	13	Utility	Furnace (DFR)	Manual Switch	6		1	CF2T36W	36	36	1	36	11		4.17	5.33	8.04	No spare parts easily accessible, assumed 36 W
	14	Restroom	Women's Restroom	Timer	13	2		F32T8	32	64	1	32	43		8.00	11.33	9.60
	15	Office	Admin.	Occupancy Sensor	50	4		F32T8	64	256	2	32	666		12.00	17.00	9.60
	16	Corridor/
Office		Manual Switch	50		1	F86T8	86	86	1	86	224		23	8.42
	17	Corridor	A	Manual Switch	50	4		F32T8	32	128	1	32	333		38?	5.83
	18	Corridor	B	Manual Switch	50	4		F32T8	64	256	2	32	666		4.00	3.83
	19	Office	Fire Prevention	Occupancy Sensor	50	2		F32T8	64	128	2	32	333		11.33	8.75	9.60
	20	Office	Business Auto. Assist	Occupancy Sensor	50	2		F32T8	64	128	2	32	333		11.75	8.75	9.60
	21	Reception	Reception	Manual Switch	50	6		F32T8	64	384	2	32	998		16.25	17.00	9.60
	22	Vestibule	Vestibule	Manual Switch	50		1	F20T12	40	40	2	20	104		6.00	10.00	9.30	No spare parts easily accessible, assumed 20 W
	23	Exerior	Exterior	Photocell	72		1	LED10W	10	10	1	10	37		ext	ext	ext	No spare parts easily accessible, assumed 10 W
	24	Exerior	Exterior	Photocell	72		1	CFS23W	23	23	1	23	86		ext	ext	ext	No spare parts easily accessible, assumed 23 W
	25	Restroom	Men's Restroom	Timer	13	1		F32T8	128	128	4	32	87		8.00	11.33
	26	Server Room	Server Room	Manual Switch	6	1		F32T8	64	64	2	32	20		4.17	7.67
	27	Office	Recreation			2		F32T8	64	128	2	32	333		10.25	11.58
	28	Office	Wildlife Staff			2		F32T8	64	128	2	32	333		10.25	13.60
	29	Office	Wildlife Technicians			2		F32T8	64	128	2	32	333		10.25	9.60
	30	Office	Operations Fuelwood			2		F32T8	64	128	2	32	333		12.10	11.50
	31	Office	Resource Clerk			4		F32T8	64	256	2	32	666		12.10	15.80
	32	Conference	Conference Room			10		F32T8	64	640	2	32			27.00	18.75
	33	Restroom	Unisex				1	F20T12	40	40	2	20	104		5.00	6.17
	34	Restroom	Men's				1	F20T12	40	40	2	20	104		6.25	4.50
	35	Restroom	Women's				1	F20T12	40	40	2	20	104		6.25	4.50
	36	Storage				1		F32T8	64	64	2	32			4.50	4.83
	37	Vestibule	Vestibule	Manual Switch	50		1	F20T12	40	40	2	20	104		4.83	4.83
	38	Office	Operations Staff			2		F32T8	64	128	2	32			12.08	11.17
	39					2		F32T8	64	128	2	32			10.25	9.42
	40	Corridor	D			8		F32T8	64	512	2	32			4.00	52.50
	41	Corridor/
Office				2		F32T8	0	0	2		0		12.17	17.50
		Exerior	Exterior	Photocell	72		8	Flood	23	23	1	23	86		ext	ext	ext
	12-1A	Modular Office	Fire			20		F32T8	0	0	2		0					Approx. Area: 1600 SF
	12-2	Separate Building	GIS Office			10		F32T8	0	0	2		0					Approx. Area: 1300 SF
	12-2C	Separate Building	Timber Office			10		F32T8	64	640	2	32						Area included with Bldg 12-2
				TOTAL F32T8 FIXTURES WITH 2 BULBS EACH =		135
	Count	Key:	Lamp Type									Assumptions:
	135	F32T8	Fluorescent, Tubular Shape, 32W, 1" diameter								ESTIMATED HAZARDOUS WASTE TO RECYCLE	14 Occupants
	2	CF2T36W	Compact Fluorescent, Twin Tube Shape, 36W								272	Lights are always on in offices, hallways, and common areas during work hours		48" Fluorescent Tube Bulbs
	1	CFS23W	Compact Fluorescent, Spiral Shape, 23W								142	Storage spaces/computer rooms are used 1 hour per day		Ballasts
	1	LED10W	LED, 10W
	5	F20T12	Fluorescent, Tubular Shape, 20W, 1.5" diameter
	1	F86T8	Fluorescent, Tubular Shape, 86W, 1" diameter
	8	Flood	Exterior Flood

Assumptions:	Restrooms used 3 times per day, 6 minutes per visit
14 Occupants	For exterior lighting, usage calculated using night-time hours (avg 12 hours of night time hrs)
Occupied 50 hours/week, 52 weeks/year
Lights are always on in offices, hallways, and common areas during work hours	Conference rooms are used half the time
Storage spaces/computer rooms are used 1 hour per day
Restrooms used 3 times per day, 6 minutes per visit

&"Arial,Regular"&16LAKESIDE RANGER STATION - EXISTING LIGHTING - 5250 SF

&F Tab: &A Printed: &D &P OF &N

ALPINE

	Room No.	Type	Area	Control(s)	Usage hrs/wk	Fixture Code	Fixtures/
Area	Watts/
Fixture	Watts/
Group	Lamps/
Fixture	Watts/
Lamp	kWh/
Year	Light Readings (fc)	Length (x)
in feet	Width (y) in feet	Height (z) in feet	Notes
	1	Vestibule (a)	Entrance				2	2	8.33	7.67
	1	Lobby (b)	Reception	manual		2FL	1	2	12.17	8.00		Ceiling Mount Fluorescent Fixture with 2 48" bulbs
	1	Lobby (b)	Reception	Always On		EXIT	EXIT	---	---	---	---
	1	Office (c)	Front Desk	manual		2FL	6	2	20.83	13.83	9.00
	2	Private Office	SSS	Vacancy Sensor		2FL	2	2	12.17	13.83	9.00
	3	Private Office	FMO	Vacancy Sensor		2FL	2	2	9.67	13.83	9.00
	4	Group Office	Resource Clerk	Vacancy S. + Manual		2FL	8	2	21.17	18.17	9.00
	5	Group Office		Vacancy Sensor		2FL	10	2	29.17	13.83	9.00
	5	Group Office		Always On		EXIT	EXIT	---	---	---	---
	6	Private Office		Vacancy Sensor		2FL	4	2	14.20	13.50	9.00
	7	Mail & Printer	Copy/Mail	Manual		CFAN w/Lights	CFAN w/Lights	4	10.17	6.83	9.00
	8	Utility	Furnace 2	Manual		Ceiling	Ceiling	1	3.67	3.16	9.00
	9	Restroom	Men's Room			2FL	2	2	15.50	6.83	9.00
	10	Restroom	Women's Room	Vacancy Sensor		2FL	2	2	15.50	6.83	9.00
	11	Group Office		Vacancy Sensor		2FL	4	2	15.50	13.17	9.00
	12	Employee Entrance	Back Entrance			Ext Ceiling	Exterior Ceiling	3?	15.50	6.83	9.00
	13	Corridor	E-W Hallway			2FL	3	2	5.00	35.83	7.00
	13	Corridor	E-W Hallway	Always On		EXIT	EXIT	---	---	---	7.00
	14	Corridor	N-S Hallway			2FL	7	2	82.17	4.00	7.00
	14	Corridor	N-S Hallway	Always On		EXIT	EXIT	---	---	---	7.00
	15	Conference	Conference Room	Manual		2FL	10	2	15.50	35.50	9.00
	15	Conference	Conference Room	Manual		Ceilling Fan	Ceiling Fan (2)	0	15.50	35.50	9.00
	16	Private Office	District Ranger	Vacancy Sensor		2FL	4	2	14.17	13.50	9.00
	17	Group Office	Recreation + Special Uses	Manual - 2 Switches		2FL	10	2	29.17	13.50	9.00
	18	Group Office	Biologists	Manual - 1 Switch		2FL	8	2	20.67	18.17	9.00
	19	Private Office		Vacancy Sensor		2FL	2	2	9.17	13.83	9.00
	20	Private Office		Manual		2FL	2	2	10.67	13.83	9.00
	21	Dining	Break Room	Vacancy Sensor		2FL	4	2	14.67	15.33	9.00
	22	Telecom	Computer			2FL	2	2	15.50	6.17	9.00
	23	Exterior Front	Front Entrance			Ext Wall Big	Screw In - 1 fixture	1	---	---	---
	24	Exterior Sides	North and South Walls			Wall Pack	Wall Pack (2)	1	---	---	---
	25	Exterior Front	Vestibule Window			Ext Wall Small	Screw In - 2 fixtures	2	---	---	---
	26	Exterior Behind Bldg	Exterior Behind Bldg			Ext Pole	Pole Top - (2 )	1	---	---	---
	27	Back Building				2FL	11	2
	27	Back Building				CFAN	Ceiling Fan (2)
	27	Back Building					Screw In - 5 fixtures	1
	28	Exterior	Exterior Flood Lights			Ext Flood	Ext. Flood (2)	2	---	---	---
						TOTAL	106

Count	Key:	Lamp Type	Assumptions:
106	2FL	ceiling mount fluorescent with two 48" bulbs	36 Occupants
6	Ceilling	ceiling mount screw in bulb
5	CFAN	ceiling fan with light
4	EXIT	exit sign	Hazardous Waste Generated:
2	Wall Pack	exterior wall pack	212	48 " Fluorescent Bulbs	48" fluorescent Tube Bulbs
2	Ext Pole	exterior pole light	106	Ballasts	Ballasts
3	Ext Wall	exterior wall mounted screw in bulb	2		Wall Packs
1	Ext Ceilling	exterior ceiling mounted with screw in bulbs
2	Ext Flood	exterior flood lights with 2 bulbs
11	Vacancy Sensors

&"Arial,Regular"&16ALPINE RANGER STATION - EXISTING LIGHTING - 5336 SF

&F Tab: &A Printed: &D Page &P of &N

CLIFTON

						Fixture Type
	Room	Type	Area	Control(s)	Usage hrs/wk	2x4 Troffer	2x2 Troffer	Watts/
Fixture	Watts/
Group	Other	Watts/
Lamp	kWh/
Year	Light Readings (fc)	Length (x)
in feet	Width (y) in feet	Height (z) in feet	Notes
	1a		Lobby			2	2x4 Troffer					22.0	17.33	11.83
	1a		Lobby				Exit Light			1		---	---	---
	1b		Lobby			1	2x4 Troffer					27.0	7.30	4.00
	1c		Lobby			2	2x4 Troffer					51.0	10.63	6.33
	1d		Lobby			2	2x4 Troffer					13.5	6.50	11.58
	2		Office			2	2x4 Troffer					30.0	13.75	11.50
	3		Office			2	2x4 Troffer					30.0	8.25	11.5
	4		Office			1	2x4 Troffer					21.0	8.25	11.43
	4		Office				Exit Light	0.00	0.00	1	0	---	---	---
	5		Office			2	2x4 Troffer					35.0	8.83	11.44
	6		Office			1	2x4 Troffer					31.0	8.75	11.00
	7	Dining	Break Room			1	2x4 Troffer					48.0	15.00	11.75
	7	Dining	Break Room				Exit Light	0.00	0.00	1	0	---	---	---
	8					1	2x4 Troffer						15.00	7.00
	9					1	2x4 Troffer					34.0	8.25	11.00
	10						48" Lamp- Fluorescent			2		16.5	8.17	11.00
	11						48" Lamp- Fluorescent			2		15.5	8.17	11.00
	11						Closet Fixture	0.00	0.00	1	0
	12		Office			2	2x4 Troffer					47.0	8.83	11
	13		Office			3	2x4 Troffer					67.0	15.17	11.00
	14		Conference			4	2x4 Troffer					69.0	15.08	18.33
	15		Vestibule			1	2x4 Troffer					24.5	12.25	4.00
	15		Vestibule				Exit Light	0.00	0.00	1	0	---	---	---
	16		Office			2	2x4 Troffer					62.0	12.25	11.25
	17					1	2x4 Troffer					29.0	5.92	7.00
	18		Corridor				3			2x2 Troffer		33.0	19.17	3.92
	19		Office			1	2x4 Troffer					29.0	6.28	7.33
	20		Corridor				1			2x2 Troffer		21.0	13.90	4.00
	21		Office			1	2x4 Troffer						5.25	11.23
	22						1			2x2 Troffer			7.54	6.33
	23		Office			2						43.0	18.50	6.17
	24		Exterior				Wall Pack			4		---	---	---
	25		Entrance				Ceiling Fixture			1		---	---	---
				TOTAL		35	5
		CONTROL TYPES: Manual, Vacancy Sensor, Occupancy Sensor, Always On, Timer, Photocell						0.00	0.00		0

Count	Fixture Type	Hazardous Waste to Dispose/Recycle
35	2'x4' Troffers with 2 Tubular Fluorescent Bulbs
5	2'x2' Troffers with 2 Tubular Fluorescent Bulbs	10	24" fluorescent bulbs
4	Exit Light	74	48" fluorescent bulbs
1	Closet Fixture	44	Ballasts
2	Interior Wall Fixture	4	Wall Packs
4	Exterior Wall Pack
1	Exterior Ceiling Fixture
4	Fixture with One 48" Fluorescent Bulb

&"Arial,Regular"&14CLIFTON RANGER STATION - EXISTING LIGHTING - 2870 SF

&F Tab: &A Printed: &D PAGE &P OF &N

Summary of All

Ballasts	24" Fl. Bulbs	48" Fl. Bulbs	Luminaire Type	Alpine	Clifton	Lakeside	Count	ALPINE
106		212	ceiling mount fluorescent fixture with two 48" bulbs	106			106	fluorescent fixure with 2 bulbs	2FL
6		6	fixture with one 48" fluorescent bulb		4	2	6	ceiling mount screw in bulb	Ceilling
5		10	Fluorescent, Tubular Shape, 20W, 1.5" diameter			5	5	ceiling fan with light	CFAN
1		1	Fluorescent, Tubular Shape, 86W, 1" diameter			1	4	exit sign	EXIT
135		272	Fluorescent, Tubular Shape, 32W, 1" diameter			135	2	exterior wall pack	Wall Pack
35		70	2'x4' Troffers with 2 tubular fluorescent bulbs		35		2	exterior pole light	Ext Pole
5	10		2'x2' Troffers with 2 tubular fluorescent bulbs		5		3	exterior wall mounted screw in bulb	Ext Wall
			Ceiling Fan (3 with lights)	5			1	exterior ceiling mounted with screw in bulbs	Ext Ceilling
			Interior Wall Fixture		2		2	exterior flood lights with 2 bulbs	Ext Flood
			Ceiling Mount, Screw in Bulb	6	3			CLIFTON
			Compact Fluorescent, Twin Tube Shape, 36W			2	35	2'x4' Troffers with 2 Tubular Fluorescent Bulbs
			Exit Sign	4	4		5	2'x2' Troffers with 2 Tubular Fluorescent Bulbs
			Exterior Ceiling Mount, Screw in Bulb	1	1		4	Exit Light
			Exterior Wall Mount, Screw in Bulb	3			1	Closet Fixture
			Exterior Flood Lights with 2 Bulbs	2		8	2	Interior Wall Fixture
			Exterior Pole Light	2			4	Exterior Wall Pack
			Exterior Wall Pack	2	4		1	Exterior Ceiling Fixture
			Compact Fluorescent, Spiral Shape, 23W, Exterior, Photo Cell			1	2	Fixture with One 48" Fluorescent Bulb
			LED, 10W, Exterior, Photo Cell			1		LAKESIDE
293	10	571	TOTALS - Fluorescent Tubes & Ballasts to Be Removed				135	Fluorescent, Tubular Shape, 32W, 1" diameter, all but 2 have 2 bulbs	F32T8
		ESTIMATED HAZARDOUS WASTE TO RECYCLE OR DISPOSE OF					2	Fluorescent, Tubular Shape, 20W, 1.5" diameter	F20T12
		TOTAL	TYPE	Alpine	Clifton	Lakeside	1	Fluorescent, Tubular Shape, 86W, 1" diameter	F86T8
		10	24" fluorescent bulbs		10		1	Compact Fluorescent, Twin Tube Shape, 36W	CF2T36W
		571	48" fluorescent bulbs	212	74	285	5	Compact Fluorescent, Spiral Shape, 23W, Exterior, Photo Cell	CFS23W
		293	Ballasts	106	44	143	1	LED, 10W, Exterior, Photo Cell	LED10W
		6	Wall packs	2	4		8	Exterior flood lights with 2 bulbs	Flood
		6	Misc Compact Fluorescent Bulbs			6

&"Arial,Regular"&16ALL 3 RANGER STATIONS - EXISTING LIGHTING SUMMARY

&F Tab: &A Printed: &D Page &P of &N

ECM Lighting (old)

Fixture Type	Number of Lamp	Fixture Qty	Existing kW Per Space	Annual Usage Hours	Annual kWh per Space
CFQ26W 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
CFQ26W 2-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
CFS18W 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
CFS23W 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
CFT42W	1	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
EXLED 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
EXLED 2-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
F24T8 2-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
F32T8	1	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
F32T8	2	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
F32T8	3	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
F32T8	4	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
F75T12 2-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
F75T12 6-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
FU32T8 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
FU32T8	2	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
FU32T8	3	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
H 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
H 2-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
HPS70 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
HPS100 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
HPS150 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
HPS400 2-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
I60 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
I72 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
I75 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
I100	1	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
LED5.5W 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
LED9W 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
LED17W 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
MH100 1-Lamp		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!
MH150	1	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!

File details come from the government source that posted it. Updated Sep 7, 2021.