Lighting Spreadsheet 20090818 revision 4WCP.XLSX

XLSX spreadsheet 57 KB Posted

Attached to
Recovery, Replace light fixtures at the National Center for Genetic Resources Preservation in Fort Collins, CO
Solicitation number
AG-82HW-S-09-0019
Issued by

About this file

Lighting Spreadsheet 20090818 revision 4WCP

View the file

Other files

File Type Posted
Abstract of Bids S-09-0019.pdf PDF
Amendment 2.pdf PDF
NSSL 0231.TIF TIF image
NSSL 0229.TIF TIF image
NSSL 0233.TIF TIF image
2002 lighting plan revised areas.pdf PDF
NSSL 0230.TIF TIF image
NSSL 0228.TIF TIF image
Ballast selection list20090819.pdf PDF
NSSL 0227.TIF TIF image
Amendment 1 in PDF.pdf PDF
Pre-bid walk through attendance list Ft Collins Lighting.pdf PDF
NSSL 0234.TIF TIF image
NSSL 0232.TIF TIF image
Lithonia 20 20C fixtrures.pdf.pdf PDF
WAL-14 spec.pdf.pdf PDF
M-2x4.pdf.pdf PDF
IMH1.pdf.pdf PDF
Wage Determination Ft Collins CO.pdf PDF
Buy American excepted material or components.pdf PDF
Lithonia 20C 20fixtures 2020090721 1 .pdf PDF
IMH175C 2020090721 1 .pdf PDF
Copy of Lighting Spreadsheet 20090720 revision 2GMG.pdf PDF
AG-82HW-S-09-0019 - Replace Light Fixtures- Ft Collins - construction over 100K.DOC DOC document
WAL-14_specDL 2020090721 1 .pdf PDF
M-2x4 2020090721 1 .pdf PDF
Show all 26

On GovTribe

Work with this file

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

Text version

Sheet1

Location Room Number Fixture Type Length Quantity Ballast/ Fixture Remove Existing Fixture Existing Ballast Subtotal to be Removed Bulbs/ Fixture Existing Bulb Subtotal to be Removed Retrofit single pin ends to "tombstone" bi-pin ends for T8 Bulbs Install 4' T8 Bulbs Install 3' T-8 Bulbs Install 4' U shaped T8 bulbs Install Lithonia C 2 32 277 GEB10RS Install Lithonia TC225-277-GEB10RS or equal Install Prudential WAL-14 P 2T8 04' TMW SC 277 SUR OC2C or equal Install Prudential WAL-14 P 2T8 04' TMW SC 277 WM OC2C or equal Install Metal Halide Pulse Start ballasts and lamps. Replace trim rings Install Rab Lighting WPC1FCH70 Install Rab Lighting WP2C100 Install Lithonia 2M 2 32 A12125 277 GEB10RS Install Program Start Ballast Upgrade w/ Harris Lighting retrofit MKSR-84-44-T8-W or equal Install Occupancy Sensor Watt Stopper WS DT-205 or equal Install Occupancy Sensor Watt Stopper WS PW-100 or equal Install Occupancy Sensors Watt Stopper WT-1100 or equal Install Occupancy Sensor Watt Stopper WS UW-100 or equal Install Occupancy Sensor Watt Stopper DT-305 or equal Install Occupancy Sensor Watt Stopper WS TS-400 or equal Install Occupancy Sensor Watt Stopper WS-200 or equal Install Occupancy Sensors Watt Stopper DW-100 or equal Install Occupancy Sensor Watt Stopper TS-200 or equal Install Occupancy Sensor Watt Stopper WPIR or equal Install Occupancy Sensor Watt Stopper W-2000H or equal Action to be taken Additional Controls & Information Comments & Legend for Actions

Vault
B01F1(4’)4142884RXLB&UWRT8&PSBReplace existing lamps and ballast and upgrade with retrofit T8 bulbs and Program start ballast (RXLB&UWRT8&PSB)
B02D(4’)3132663RXLB&UWRT8&PSB
B03H(8’)4814829619248RXLB&UWHLR,T8,PSBReplace existing lamps and ballast and upgrade with Harris Lighting 8' to 2x4' retrofit kit T8 bulbs and Program start ballast (RXLB&UWHLR,T8&PSB)
146D(4’)3132663RXLB&UWRT8&PSB
147F1(4’)3132663RXLB&UWRT8&PSB
148H(8’)4814829619248RXLB&UWHLR,T8,PSB
235D(4’)2122442RXLB&UWRT8&PSB
AA(4’)1112221RXLB&UWRT8&PSB
236F1(4’)3132663RXLB&UWRT8&ISBCold (0° F) Rated Ballasts to be used, relocate west light obscured by ductwork to area over west compressor
302F1(4’)2122442RXLB&UWRT8&PSB
303EE(8’)224481682RXLB&UWHLR,T8,ISBCold (0° F) Rated Ballasts to be used
304D(4’)2122442RXLB&UWRT8&PSB
305F(4’)2122442RXLB&UWRT8&PSB
Stair 3F(4’)4142884RXF&RPWPLT8 4' SURRelocation of light on 3rd floor landing may be needed to allow for door operation, Verify in fieldRemove existing fixture and replace with Prudential Lighting WAL-14 P 2T8 04' TMW SC 277 SUR OC2C or similar (RXF&RPWPLT8 4' SUR)
I1(6’)42441684RXF&RPWPLT8 4' WMRemove existing fixture and replace with Prudential Lighting WAL-14 P 2T8 04' TMW SC 277 WM OC2C or similar (RXF&RPWPLT8 4' WM)
Stair 4F(4’)4142884RXF&RPWPLT8 4' SUR
I1(6’)42441684RXF&RPWPLT8 4' WM
Elevator4'61616661RXLB&UWRT8&PSBIOS WS DT-205Install Occupancy Sensor-Watt Stopper DT-205 (IOS- WS DT-205)
Subtotal1451613130416480000088000031981000000000Lamps 480 @ 4';16 New fixtures; 98 retrofit from 2 bulb 8' to use 4-4' bulbs
North Wing
1st Floor
101F(4’)11122211RXLB&UWRT8&PSBIOS- WS PW-100Replace existing lamps and ballast and upgrade with retrofit T8 bulbs and Program start ballast (RXLB&UWRT8&PSB) Install Occupancy Sensor, Watt Saver PW-100 (IOS- WS PW-100)
102Z(4’)21236622RXLB&UWRT8&PSBIOS-WS WT-1100Install Occupancy Sensor-Watt Stopper WT-1100 (IOS- WS WT-1100)
P(6’)1112241REMXF&RPWL&T8Remove existing fixture and replace with Lithonia TC225-277-GEB10RS fixture with Program Start ballast, T-8 bulbs (REMXF&RPWL&T8)
103Z(4’)21236622RXLB&UWRT8&PSBIOS-WS WT-1100
P(6’)1112241REMXF&RPWL&T8
104F(4’)21224421RXLB&UWRT8&PSBIOS-WS UW-100Install Occupancy Sensor- Watt Stopper UW-100 (IOS-WS UW-100)
107B(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305Install Occupancy Sensor-Watt Stopper DT-305 (IOS-WS-DT-305)
108B(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
109B(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
110B(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
111B(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
112A(4’)4283121281RXLB&UWRT8&PSBIOS-WS DT-305
113B(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
114A(4’)621231818121RXLB&UWRT8&PSBIOS-WS DT-305
115A(4’)22436641RXLB&UWRT8&PSBIOS-WS DT-305
116A(4’)621231818121RXLB&UWRT8&PSBIOS-WS DT-305
118A(4’)32639961RXLB&UWRT8&PSBIOS-WS DT-305
119B(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
121B(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
122B(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
123A(4’)621231818121RXLB&UWRT8&PSBIOS-WS DT-305
124AA(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
126AA(4’)21224421RXLB&UWRT8&PSBIOS-WS DT-305
127E(4’)6162121261RXLB&UWRT8&PSBIOS-WS DT-305
128D(4’)11122211RXLB&UWRT8&PSBIOS-WS UW-100
129A(4’)521031515101RXLB&UWRT8&PSBIOS-WS DT305
130A(4’)1723435151342RXLB&UWRT8&PSBIOS- Qty 2, w in p, WS DT-305Install Occupancy Sensor- Qty 2, wired in parallel, Watt Stopper DT-305 (IOS- Qty 2, w in p, WS DT-305)
(2’)2242444RXLB&UWRT8&PSB2' fixtures utilize "U" shaped 4' bulbs
131D(4’)2122442RXLB&UWRT8&PSB
132A(4’)2024036060402RXLB&UWRT8&PSBIOS- Qty 2, w in p, WS DT-305
(2’)2242444RXLB&UWRT8&PSB2' fixtures utilize "U" shaped 4' bulbs
133A(4’)2024036060402RXLB&UWRT8&PSBIOS- Qty 2, w in p, WS DT-305
(2’)2242444RXLB&UWRT8&PSB2' fixtures utilize "U" shaped 4' bulbs
134A(4’)2024036060402RXLB&UWRT8&PSBIOS- Qty 2, w in p, WS DT-305
(2’)2242444RXLB&UWRT8&PSB2' fixtures utilize "U" shaped 4' bulbs
135A(4’)2024036060402RXLB&UWRT8&PSBIOS- Qty 2, w in p, WS DT-305
(2’)2242444RXLB&UWRT8&PSB2' fixtures utilize "U" shaped 4' bulbs
137A(4’)2024036060402RXLB&UWRT8&PSBIOS- Qty 2, w in p, WS DT-305
(2’)2242444RXLB&UWRT8&PSB2' fixtures utilize "U" shaped 4' bulbs
138AA(4')6162121261RXLB&UWRT8&PSBIOS-WS DT-305
139AA(4’)21224421RXLB&UWRT8&PSBIOS-WS DT-305
140AA(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
141AA(4')313231RXB&UWT8 PSBIOS-WS W-2000H
144AA(4’)21224421RXLB&UWRT8&PSBIOS- WS PW-100
145AA(4’)21224421RXLB&UWRT8&PSBIOS-WS DT-305
145AAA(4')11122211RXLB&UWRT8&PSBIOS- WS PW-100
149H(8’)21224821RXLB&UWHLR,T8,PSBIOS, WS TS-400Replace existing lamps and ballast and upgrade with Harris Lighting retrofit MKSR-84-44-T8-W T8 bulbs and program start ballast. Note: one strip light is on circuit H1B-13, the other is on emergency lighting circuit and is currently not switched. Add additional Switch to control.
150F(4’)11122211RXLB&UWRT8&PSBIOS, WS TS-400Install Occupancy Sensor Watt Saver TS-400 (IOS, WS TS-400)
151H(8’)313261231RXLB&UWHLR,T8,PSBIOS, WS TS-400Note: Demo existing S3 located on sheet E17@K-11.6, convert switch at K.-10.6 to S1
Subtotal2472406641062382402004015034235300001Lamps 8 @ 3'; 623 @ 4'; 24 @ 4' U shaped / 2 New Lithonia fixtures / 5 Harris retrofits / 46 occupancy sensors in 40 rooms
South Wing
1st Floor155(4’)18236540362RXB&UWT8 PSBIOS- Qty 2, w in p, WS DT-305Remove existing ballast and upgrade to program start ballast (RXB&UWT8 PSB)
Room157H(8’)21224821RXLB&UWHLR,T8,PSBIOS, WS DT-305Replace existing lamps and ballast and upgrade with retrofit T8 bulbs and Program start ballast
158(4’)921830181RXB&UWT8 PSBIOS-WS DT-305
159(4’)1422830282RXB&UWT8 PSBIOS- Qty 2, w in p, WS DT-305
162B(4’)41428841RXLB&UWRT8&PSBIOS, WS DT-205
163GG(4')No changes needed
HH(4')No changes needed
163AZ(4’)11122211RXLB&UWRT8&PSBIOS-WS UW-100
163BZ(4’)11122211RXLB&UWRT8&PSBIOS, WS UW-100
164F1(4’)21224421RXLB&UWRT8&PSBIOS, WS WS-200Install Occupancy Sensor- Watt Stopper WS-200 (IOS, WS WS-200)
165F1(4’)31326631RXLB&UWRT8&PSBIOS, WS TS-200Install Occupancy Sensor- Watt Stopper TS-200 (IOS, WS TS-200)
166D(4’)11122211RXLB&UWRT8&PSBIOS, WS TS-200
167F1(4’)11122212RXLB&UWRT8&PSBIOS- Qty 2, w in p, WS DT-305
H(8’)41428164RXLB&UWHLR,T8,PSB
16881820081RXB&UWT8 PSBIOS, WS WPIR
16921220022RXB&UWT8 PSBIOS- Qty 2, w in p, WS DT-305
170Z(4’)21236621RXLB&UWRT8&PSBIOS-WS WT-1100
G(8’)1112241RXLB&UWHLR,T8,PSB
172Z(4’)21236621RXLB&UWRT8&PSBIOS-WS WT-1100
G(8’)1112241RXLB&UWHLR,T8,PSB
173A(4’)4283121281RXLB&UWRT8&PSBIOS, WS DT-205
174A(4’)22436641RXLB&UWRT8&PSBIOS, WS DT-205Reconnect switch (H1A-5) to north fixture, center single bulb. South fixture, center bulb to remain on emergency lighting circuit
Suspend(4')1112001RXB&UWT8 PSBre-feed existing pendant light from emergency circuit to control from switch for north fixture, center single bulb
175BBMetal Halide, down throw121212RXLB&UPulSBL, RTR, RFLReplace Existing Metal Halide lamps and Ballasts and Upgrade to Electronic Pulse start ballasts and ceramic metal halide bulbs. Replace existing trim rings and resecure. Re feed lights to create two separate switched light banks. Re-use Switch for "Q". (RXLB&UPulSBL, RTR, RFL)
QMetal Halide,up throw44DL&ABwW&CDemo lights and abandon box with wire and cover with steel plate for future modification as needed (DL&ABwW&C) Box is hidden in sconce
P(6')3132684RMXF&ILC232-T8Remove existing fixtures and replace with Lithonia C 2 32 277 GEB10RS (RMXF&ILC232-T8)
F(4')4142884RXLB&UWRT8&PSB
176A(4’)4283121281RXLB&UWRT8&PSBIOS, WS DT-305
177A(4’)621231818121RXLB&UWRT8&PSBIOS, WS DT-305
178A(4’)4283121281RXLB&UWRT8&PSBIOS, WS DT-305
179A(4’)4283121281RXLB&UWRT8&PSBIOS, WS DT-305
Subtotal124718214015800400012001628302214010210Lamps: 158 @ 4' / Abandon 4 fixtures / 4 new fixtures / 8 Harris retrofit / Upgrade 12 metal halide ballasts/ 25 Occupancy Sensors in 21 rooms
North Wing
2nd Floor
202E(4’)21224421RXLB&UWRT8&PSBIOS-WS DT-305
203A(4’)621231818121RXLB&UWRT8&PSBIOS-WS DT-305
204B(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
205B(4’)41428841RXLB&UWRT8&PSBIOS-WS DT-305
207E(4’)621231818121RXLB&UWRT8&PSBIOS-WS DT-305
208A(4’)4283121281RXLB&UWRT8&PSBIOS-WS DT-305
209A(4’)4283121281RXLB&UWRT8&PSBIOS-WS DT-305
210E(4’)1623234848321RXLB&UWRT8&PSBIOS-WS DT-305
211E(4’)32639961RXLB&UWRT8&PSBIOS-WS DT-305
212E(4’)22436641RXLB&UWRT8&PSBIOS-WS DT-305
213E(4’)22436641RXLB&UWRT8&PSBIOS-WS DT-305
214A(4’)32639961RXLB&UWRT8&PSBIOS-WS DT-305
215A(4’)1623234848321RXLB&UWRT8&PSBIOS-WS DT-305
216D(4’)31326631RXLB&UWRT8&PSBIOS-WS DT-305
217D(4’)6162121261RXLB&UWRT8&PSBIOS-WS DT-305
218H(8’)1112241RXLB&UWHLR,T8,PSB
(6')261261265226Remove existing fixtures and replace with 26 -twin tube T-8 with instant start ballastInstall 2 switches inside room to control banks individually.
219H(8’)1112241RXLB&UWHLR,T8,PSB
(6')261261265226Remove existing fixtures and replace with 26 -twin tube T-8 with instant start ballastInstall 2 switches inside room to control banks individually.
220H(8’)1112241RXLB&UWHLR,T8,PSB
(6')261261265226Remove existing fixtures and replace with 26 -twin tube 4' T-8 with instant start ballastInstall 2 switches inside room to control banks individually.
221B(4')6162121261RXLB&UWRT8&PSBIOS-WS DT-305
222(4')18236236363618RXLB&UWRT8&PSBIOS- WS DW-100Install Occupancy Sensor, Watt Stopper DW-100 (IOS ws DW-100)
228A(4')12233321RXLB&UWRT8&PSBIOS- WS PW-100
229A(4')1823635454362RXLB&UWRT8&PSBIOS- Qty 2, w in p, WS DT-305
231A(4')2024036060402RXLB&UWRT8&PSBIOS- Qty 2, w in p, WS DT-305
232A(4')2224436666442RXLB&UWRT8&PSBIOS- Qty 2, w in p, WS DT-305
233A(4')2124236363422RXLB&UWRT8&PSBIOS- Qty 2, w in p, WS DT-305
239H(8')616212246RXLB&UWHLR,T8,PSBInstall 2 switches inside room to control banks individually.
240H(8')2122482RXLB&UWHLR,T8,PSB
Subtotal27678360726180718007800000034911010024001800Lamps 718 @ 4' / 11 Harris Retrofit / 78 New fixtures / 26 Occupancy Sensors in 22 rooms
South Wing
2nd Floor242(4’)921830181RXB&UWT8 PSBIOS-WS DT-305
242A(4’)3263061RXB&UWT8 PSBIOS-WS DT-305
243(4’)2124230422RXB&UWT8 PSBIOS- Qty 2, w in p, WS DT-305
(4’)111201
244(4’)1122230222RXB&UWT8 PSBIOS-Qty 2, w in p, WS DT-305
246H(8’)1211222448121RXLB&UWRT8&PSBIOS-WS DT-205
247(4’)921830182RXB&UWT8 PSBIOS-Qty 2, w in p, WS DT-305
248AA(4’)11122211RXLB&UWRT8&PSBIOS-WS WT-1100
P(6’)1112241REMXF&RPWL&T8
248AAA21224421RXLB&UWRT8&PSBIOS-WS DT-205
B1213321RXF&RP L2M2&T8Remove existing fixture and replace with Lithonia 2M 2 32 A12125 277 GEB10RS (RXF&RP L2M2&T8)
249AA(4’)21224421RXLB&UWRT8&PSBIOS-WS WT-1100
P(6’)1112241REMXF&RPWL&T8
249AAA21224421RXLB&UWRT8&PSBIOS-WS DT-205
250A(4’)22436641RXLB&UWRT8&PSBIOS-WS DT305
251A(4’)821632424161RXLB&UWRT8&PSBIOS-WS DT305
252A(4’)22436641RXLB&UWRT8&PSBIOS-WS DT305
253B(4’)3132663RXLB&UWRT8&PSB
B1(4’)3262666RXLB&UWRT8&PSB
Subtotal9431599301128002000011471230201100000Lamps 112 @ 4'; 8 @ 3' /12 Harris retrofit / 16 Occ Sensors in 13 rooms /
North Wing
3rd Floor301H(8’)2412424896242RXLB&UWHLR,T8,PSBIOS- WS TS-400, Qty 2Note: Demo existing S3 located on sheet E21@M-5, convert switches at H.2-9 to S1
North Wing Stairwells
Stair1I1(6’)727428147RXF&RPWPLT8 4' WM
2I1(6’)32341263RXF&RPWPLT8 4' WM
F(4’)2122442RXF&RPWPLT8 4' SUR
ElevatorMain Lobby(4')61616661RXLB&UWRT8&PSBIOS WS DT-205
Subtotal181204403000002100006010000000Lamps 30 @ 4' / 12 Prudential WAL-14
South Wing Stairwell
Stair5I1(6’)42841684RXF&RPWPLT8 4' WM
Exterior LightingHandrails(4')818188Remove existing lamps and ballasts. Replace with T-8 bulbs with new ballasts rated for low temperature startVerify fixture qty and size
Door 95 (room 175)11RXF&RPWRABWP1FC70Convert to 277V fixture to be supplied by emergency lighting circuits, demo existing plugmold in lobby, repair wall & paint as necessaryRemove existing exterior light and motion sensor, replace with RAB Lighting WP1FCH70QT/ PCS Fully shielded, Full Cutoff wallpack with Daylight sensor (RXF&RPWRABWP1FC70)
Loading Dock22RXF&RPWRABWP2C100CVerify voltageRemove existing exterior light and motion sensor, replace with RAB Lighting WP2CH100QT , Cutoff wallpack (RXF&RPWRABWP2C100)
Subtotal83880000000001208000000000000
Note: Replacement Program start ballasts shall be Sylvania Quicktronic PROStart PSX or equivalent.
Replacement bulbs shall be Octron XPS-841 bulbs or equivalent. Bulbs used in Room 218,219, 220 shall be Octron XPS-835 or other approved.

Vault 145 16 131 304 16 480 0 0 0 0 8 8 0 0 31 98 1 0 0 0 0 0 0 0 0 0 0

North Wing 1st Floor 247 2 406 641 0 623 8 24 0 2 0 0 0 0 0 401 5 0 3 10 2 35 3 0 0 0 0 1

South Wing 1st Floor 124 7 182 140 158 0 0 4 0 0 0 12 0 0 162 8 3 0 2 2 14 0 1 0 2 1 0

North Wing 2nd Floor 276 78 360 618 0 718 0 0 78 0 0 0 0 0 0 0 349 11 0 1 0 0 24 0 0 18 0 0 0

South Wing 2nd Floor 94 3 159 93 0 112 8 0 0 2 0 0 0 0 0 1 147 12 3 0 2 0 11 0 0 0 0 0 0

North Wing 3rd Floor 24 24 48 0 96 0 0 0 0 0 0 0 0 0 0 0 24 0 0 0 0 0 2 0 0 0 0 0

North Wing Stairwells18126440300000210000060100000000
South Wing Stairwell44160800000400000000000000000
Exterior Lighting83880000000001208000000000000

Base Bid Totals, which are approximate 940 125 1276 1912 16 2225 16 24 82 4 10 22 12 1 2 1 1104 158 8 4 14 4 84 5 1 18 2 1 1 1396

Add/Alt 1
Hallways
1st FloorNorthB4'35135203512RXB&UWT8 PSB; IOS WS W-2000H WIPInstall Occupancy Sensor Watt Stopper W-2000H wired in parallel (IOS WS W-2000H WIP)
B14'172172017RXB&UWT8 PSB; IOS WS W-2000H WIP
SouthB4'811320134RXB&UWT8 PSB; IOS WS W-2000H WIP
B14'5152010RXB&UWT8 PSB; IOS WS W-2000H WIP
2nd FloorNorthB4'36148204812RXB&UWT8 PSB; IOS WS W-2000H WIPAdd Additional ballast for single bulb emergency light operationWire second ballast to switched circuit leg
B14'122122012RXB&UWT8 PSB; IOS WS W-2000H WIP
SouthB4'6162065RXB&UWT8 PSB; IOS WS W-2000H WIP
B14'323203RXB&UWT8 PSB; IOS WS W-2000H WIP
Add Alt. 1 Totals1220139014433

Sheet2

Sheet3

File details come from the government source that posted it. Updated .