Attachment 4 LED Lights List.xlsx

XLSX spreadsheet 20 KB Posted

Attached to
Replace Fluorescent Lights with LEDs (Brookings, SD) Federal contract opportunity
Solicitation number
1232SA26Q0445
Issued by
Department of Agriculture Agricultural Research Service

About this file

This is an LED lighting inventory and specification document prepared for a fluorescent-to-LED retrofit project at the USDA Agricultural Research Service facility in Brookings, South Dakota (Solicitation 1232SA26Q0445).

The spreadsheet catalogs lighting requirements across multiple building wings and rooms, specifying quantities of T-8 lamps in 4-foot and 8-foot configurations, plus can lights and sconce fixtures. The total project requires 1,936 four-foot T-8 lamps, 14 eight-foot bulbs, 142 can lights, and 15 sconce fixtures, for a combined total of 2,119 light fixtures. The document identifies specific room locations and current fixture counts, with notations indicating which can lights have already been converted to LED. Key specifications include 4-foot lamps rated at 14-17 watts with a color temperature of 4,100K. Site visit updates note that three lights must remain configured as emergency lights, and the shop may convert 8-foot lamps to 4-foot alternatives. The spreadsheet was last updated on 4/17/2026 following an on-site facility assessment, with revisions documenting LED conversions already completed and clarifying lamp types in specific areas.

View the file

Other files for this federal contract opportunity

Other files attached to Replace Fluorescent Lights with LEDs (Brookings, SD), newest first.
File Type Posted
Revised Attachment 4 LED Lights.xlsx XLSX spreadsheet
SF30_1232SA26Q0445_0002.pdf PDF
Questions and Answers_1232SA26Q0445.pdf PDF
FAR Text_52.225-9_52.225-10_52.222-90.docx DOCX document
SF30_1232SA26Q0445_0001.pdf PDF
Site Visit Sign In Sheet.pdf PDF
Attachment 1 SF1442 Solicitation Terms and Conditions_1232SA26Q0445.pdf PDF
Attachment 2 Statement of Work.pdf PDF
Attachment 3 DOL WD SD20260005_2026_01_16.pdf PDF

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

Text version

Sheet1

T-8 Lamps; 4'T-8 Lamps; 8'BulbsCansSconceNotes
WingRoomNameName
B32DCage23
B32ESoil Grinding10
B32FSoil Grinding2
B32GSoil Grinding2
BNo #Soil Grinding14
B32CPass-through4
B32AEgg Wash8
32BStorage1
B32Head House48
B29EBlack Lab24
B29DWhite Lab48
B29CStorage48
B29ARest Room2
B29Growth Chambers (Hallway)79
B31Greenhouse (Hallway)4
B31AGreenhouse1
B31BGreenhouse1
B31CGreenhouse1
B31DGreenhouse1
B30Greenhouse Hallway3
30A-FGreenhouse Hallway1
30GGreenhouse1
30HGreenhouse1
30JGreenhouse1
B27BRearingReceiving26
B27CRearingWash room8
B27GRearingCooridor20
B25ORearingBlue Lab20
B27JRearingEmergence4
B27IRearingEmergence4
B27HRearingEmergence4
B25IRearing2
B25HRearing2
B27LRearingGrowth Chambers28
B27ARearingInsect Ball Room22
B25RearingHallway10
B25DRearingJanitor1
B25CRearingRest Room1
B25BRearingShower1
B25ARearingLockers2Revised
B25ERearingOrange Lab34Revised
B25GRearingStorage4Revised
B25FRearingStorage (Diet Prep)12Revised
B28RearingMech Room12Revised
B27RearingHallway2Revised
B26RearingOffice4Revised
B3RearingComm Room 32Revised
B24RearingOffice10Revised
B22Mech Room12Revised
B21Hallway21Revised
B20Old Generator8Revised
A18Cold Room4
A17Storage4
A16Pekarcik6
A15Nielson6
A14Safety6
A9Comm Room II4
A19Insect Holding Lab36
A19AInsect Holding Lab4
A13AStorage2
A13Pekarcik Lab42
A11Lab42
A10Break Room21
A10ABreak Room2
ANo #RO Down (Below Brk Rm)14
A38CSafe6
A38DStorage6
A38AAdmin Area48
A38ESchneider15
A38FCoomes12
A36Mail Room1816
A38GMcCuin12
A37Hallway24
A39Entry Way (East)4
D1North Entry04Removed 4 Cans - these are LED
DMen's Rest Room614
DWomen's Room614
D4Hallway08Removed 15 Cans - these are LED
D6Custodian2
A33Custodian2
A34Rest Room26
A35Rest Room26
A40Roeder Lab42
A40AStorage4
A41AStorage6
A41Roeder Lab36
A41AOffice6
A42Common Equip Room12
A43IT6
A44Schneider Lab42
A44AStorage4
A44BSutradhar Office6
A45Student Office6
A47Daniels Office6
A49Roeder Office6
A48lab42
A48AStorage4
A50Hessler Lab42
A50AStorage4
A51Beckendorf Office6
A52Hessler Office6
A53Office6
A54Lab42
A54AStorage2
A54BStorage2
A55Maint Mech Office6
A56Comm Room 14
A57Mechanical12
A58Electrical6
A59Hallway22
C59, 60, 71Hallway15
C61Neupane Office9
C62Yin Office9
C63Vacant9
C64Custodian2
C65Lehman Office9
C66Osborne Office9
C67Vacant Office9
C68Men's Room86
C69Women's Room86
C70Growth Chambers6
C72Lab52
C73Vacant Office12
C74Plant Phys Lab68
C75Lahr Office12
C76Gibson Office12
C77Yin Lab52
C78Hallway120Removed 14 Cans, these are LED
C82AAgro Lab28
C80Wagner Office12
C82Common Soils Lab48
C81FStorage2
C81EStorage2
C81DStorage2
C81CStorage2
C81BStorage2
C81AStorage2
CNo #Roof Access14
C89Common Equip Room12
C88Cold Room4
C90Hallway12
C83Student Office12
C82BSoil Science Lab32
C84Soil Prep24
C86Soil Micro Lab64
C87Nichols Office12
CFoyer6
Chem Storage5
ShopGator spot20
Shop614
ShopRest Room2
ShopBreezeway to Car Stalls4
Seed StorageMain16
Seed StorageCooler12
Seed StorageSeed house lab12
Seed DryingBoiler Room21Updated # of 4 foot lamps
Seed DryingDrying Rooms8

Totals 1936 14 142 15 12

Total2119
4/17/2026 Site Visit Updates
1. Updated Can lights on the list that are already LED
2. Updated B25A to B20, those lamps are 4 foot, not 8 foot
3. In the Shop, may convert the 8 foot lamps to 4 foot lamps
4. There are 3 lights that are considered emergency lights. Those need to continue to be configured as emergency lights
5. Watts: 4 foot lamps can be 14 to 17 watts
6. Light color: 4,100 K

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