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
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
| File | Type | Posted |
|---|---|---|
| Revised Attachment 4 LED Lights.xlsx | XLSX spreadsheet | |
| SF30_1232SA26Q0445_0002.pdf | ||
| Questions and Answers_1232SA26Q0445.pdf | ||
| FAR Text_52.225-9_52.225-10_52.222-90.docx | DOCX document | |
| SF30_1232SA26Q0445_0001.pdf | ||
| Site Visit Sign In Sheet.pdf | ||
| Attachment 1 SF1442 Solicitation Terms and Conditions_1232SA26Q0445.pdf | ||
| Attachment 2 Statement of Work.pdf | ||
| Attachment 3 DOL WD SD20260005_2026_01_16.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' | Bulbs | Cans | Sconce | Notes | ||||
| Wing | Room | Name | Name | ||||||
| B | 32D | Cage | 23 | ||||||
| B | 32E | Soil Grinding | 10 | ||||||
| B | 32F | Soil Grinding | 2 | ||||||
| B | 32G | Soil Grinding | 2 | ||||||
| B | No # | Soil Grinding | 14 | ||||||
| B | 32C | Pass-through | 4 | ||||||
| B | 32A | Egg Wash | 8 | ||||||
| 32B | Storage | 1 | |||||||
| B | 32 | Head House | 48 | ||||||
| B | 29E | Black Lab | 24 | ||||||
| B | 29D | White Lab | 48 | ||||||
| B | 29C | Storage | 48 | ||||||
| B | 29A | Rest Room | 2 | ||||||
| B | 29 | Growth Chambers (Hallway) | 79 | ||||||
| B | 31 | Greenhouse (Hallway) | 4 | ||||||
| B | 31A | Greenhouse | 1 | ||||||
| B | 31B | Greenhouse | 1 | ||||||
| B | 31C | Greenhouse | 1 | ||||||
| B | 31D | Greenhouse | 1 | ||||||
| B | 30 | Greenhouse Hallway | 3 | ||||||
| 30A-F | Greenhouse Hallway | 1 | |||||||
| 30G | Greenhouse | 1 | |||||||
| 30H | Greenhouse | 1 | |||||||
| 30J | Greenhouse | 1 | |||||||
| B | 27B | Rearing | Receiving | 26 | |||||
| B | 27C | Rearing | Wash room | 8 | |||||
| B | 27G | Rearing | Cooridor | 20 | |||||
| B | 25O | Rearing | Blue Lab | 20 | |||||
| B | 27J | Rearing | Emergence | 4 | |||||
| B | 27I | Rearing | Emergence | 4 | |||||
| B | 27H | Rearing | Emergence | 4 | |||||
| B | 25I | Rearing | 2 | ||||||
| B | 25H | Rearing | 2 | ||||||
| B | 27L | Rearing | Growth Chambers | 28 | |||||
| B | 27A | Rearing | Insect Ball Room | 22 | |||||
| B | 25 | Rearing | Hallway | 10 | |||||
| B | 25D | Rearing | Janitor | 1 | |||||
| B | 25C | Rearing | Rest Room | 1 | |||||
| B | 25B | Rearing | Shower | 1 | |||||
| B | 25A | Rearing | Lockers | 2 | Revised | ||||
| B | 25E | Rearing | Orange Lab | 34 | Revised | ||||
| B | 25G | Rearing | Storage | 4 | Revised | ||||
| B | 25F | Rearing | Storage (Diet Prep) | 12 | Revised | ||||
| B | 28 | Rearing | Mech Room | 12 | Revised | ||||
| B | 27 | Rearing | Hallway | 2 | Revised | ||||
| B | 26 | Rearing | Office | 4 | Revised | ||||
| B | 3 | Rearing | Comm Room 3 | 2 | Revised | ||||
| B | 24 | Rearing | Office | 10 | Revised | ||||
| B | 22 | Mech Room | 12 | Revised | |||||
| B | 21 | Hallway | 21 | Revised | |||||
| B | 20 | Old Generator | 8 | Revised | |||||
| A | 18 | Cold Room | 4 | ||||||
| A | 17 | Storage | 4 | ||||||
| A | 16 | Pekarcik | 6 | ||||||
| A | 15 | Nielson | 6 | ||||||
| A | 14 | Safety | 6 | ||||||
| A | 9 | Comm Room II | 4 | ||||||
| A | 19 | Insect Holding Lab | 36 | ||||||
| A | 19A | Insect Holding Lab | 4 | ||||||
| A | 13A | Storage | 2 | ||||||
| A | 13 | Pekarcik Lab | 42 | ||||||
| A | 11 | Lab | 42 | ||||||
| A | 10 | Break Room | 21 | ||||||
| A | 10A | Break Room | 2 | ||||||
| A | No # | RO Down (Below Brk Rm) | 14 | ||||||
| A | 38C | Safe | 6 | ||||||
| A | 38D | Storage | 6 | ||||||
| A | 38A | Admin Area | 48 | ||||||
| A | 38E | Schneider | 15 | ||||||
| A | 38F | Coomes | 12 | ||||||
| A | 36 | Mail Room | 18 | 16 | |||||
| A | 38G | McCuin | 12 | ||||||
| A | 37 | Hallway | 24 | ||||||
| A | 39 | Entry Way (East) | 4 | ||||||
| D | 1 | North Entry | 0 | 4 | Removed 4 Cans - these are LED | ||||
| D | Men's Rest Room | 6 | 14 | ||||||
| D | Women's Room | 6 | 14 | ||||||
| D | 4 | Hallway | 0 | 8 | Removed 15 Cans - these are LED | ||||
| D | 6 | Custodian | 2 | ||||||
| A | 33 | Custodian | 2 | ||||||
| A | 34 | Rest Room | 2 | 6 | |||||
| A | 35 | Rest Room | 2 | 6 | |||||
| A | 40 | Roeder Lab | 42 | ||||||
| A | 40A | Storage | 4 | ||||||
| A | 41A | Storage | 6 | ||||||
| A | 41 | Roeder Lab | 36 | ||||||
| A | 41A | Office | 6 | ||||||
| A | 42 | Common Equip Room | 12 | ||||||
| A | 43 | IT | 6 | ||||||
| A | 44 | Schneider Lab | 42 | ||||||
| A | 44A | Storage | 4 | ||||||
| A | 44B | Sutradhar Office | 6 | ||||||
| A | 45 | Student Office | 6 | ||||||
| A | 47 | Daniels Office | 6 | ||||||
| A | 49 | Roeder Office | 6 | ||||||
| A | 48 | lab | 42 | ||||||
| A | 48A | Storage | 4 | ||||||
| A | 50 | Hessler Lab | 42 | ||||||
| A | 50A | Storage | 4 | ||||||
| A | 51 | Beckendorf Office | 6 | ||||||
| A | 52 | Hessler Office | 6 | ||||||
| A | 53 | Office | 6 | ||||||
| A | 54 | Lab | 42 | ||||||
| A | 54A | Storage | 2 | ||||||
| A | 54B | Storage | 2 | ||||||
| A | 55 | Maint Mech Office | 6 | ||||||
| A | 56 | Comm Room 1 | 4 | ||||||
| A | 57 | Mechanical | 12 | ||||||
| A | 58 | Electrical | 6 | ||||||
| A | 59 | Hallway | 2 | 2 | |||||
| C | 59, 60, 71 | Hallway | 15 | ||||||
| C | 61 | Neupane Office | 9 | ||||||
| C | 62 | Yin Office | 9 | ||||||
| C | 63 | Vacant | 9 | ||||||
| C | 64 | Custodian | 2 | ||||||
| C | 65 | Lehman Office | 9 | ||||||
| C | 66 | Osborne Office | 9 | ||||||
| C | 67 | Vacant Office | 9 | ||||||
| C | 68 | Men's Room | 8 | 6 | |||||
| C | 69 | Women's Room | 8 | 6 | |||||
| C | 70 | Growth Chambers | 6 | ||||||
| C | 72 | Lab | 52 | ||||||
| C | 73 | Vacant Office | 12 | ||||||
| C | 74 | Plant Phys Lab | 68 | ||||||
| C | 75 | Lahr Office | 12 | ||||||
| C | 76 | Gibson Office | 12 | ||||||
| C | 77 | Yin Lab | 52 | ||||||
| C | 78 | Hallway | 12 | 0 | Removed 14 Cans, these are LED | ||||
| C | 82A | Agro Lab | 28 | ||||||
| C | 80 | Wagner Office | 12 | ||||||
| C | 82 | Common Soils Lab | 48 | ||||||
| C | 81F | Storage | 2 | ||||||
| C | 81E | Storage | 2 | ||||||
| C | 81D | Storage | 2 | ||||||
| C | 81C | Storage | 2 | ||||||
| C | 81B | Storage | 2 | ||||||
| C | 81A | Storage | 2 | ||||||
| C | No # | Roof Access | 14 | ||||||
| C | 89 | Common Equip Room | 12 | ||||||
| C | 88 | Cold Room | 4 | ||||||
| C | 90 | Hallway | 12 | ||||||
| C | 83 | Student Office | 12 | ||||||
| C | 82B | Soil Science Lab | 32 | ||||||
| C | 84 | Soil Prep | 24 | ||||||
| C | 86 | Soil Micro Lab | 64 | ||||||
| C | 87 | Nichols Office | 12 | ||||||
| C | Foyer | 6 | |||||||
| Chem Storage | 5 | ||||||||
| Shop | Gator spot | 20 | |||||||
| Shop | 6 | 14 | |||||||
| Shop | Rest Room | 2 | |||||||
| Shop | Breezeway to Car Stalls | 4 | |||||||
| Seed Storage | Main | 16 | |||||||
| Seed Storage | Cooler | 12 | |||||||
| Seed Storage | Seed house lab | 12 | |||||||
| Seed Drying | Boiler Room | 2 | 1 | Updated # of 4 foot lamps | |||||
| Seed Drying | Drying Rooms | 8 |
Totals 1936 14 142 15 12
| Total | 2119 | ||
| 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 .