LED Fixture Schedule 2025.xlsx

XLSX spreadsheet 41 KB Posted

Attached to
LED Lighting Conversion State and local contract opportunity
Solicitation number
25-BM14
Issued by
Dane County, Wisconsin

About this file

This is a LED Fixture Schedule spreadsheet detailing lighting conversion specifications for three City of Sun Prairie, Wisconsin municipal facilities: the Westside Community Services Building, Fire Station 1, and Fleet Maintenance Facility. The document provides a comprehensive inventory of approximately 878 existing light fixtures across the three locations, specifying fixture types (T8, CFL, T5 HO, T12, and dimmable fluorescent), quantities, current wattages, and emergency lighting designations. The conversion involves replacing these fixtures with new LED lighting while implementing control systems such as occupancy sensors, photocells, and dimmable controls. The schedule itemizes projected energy savings in kilowatt-hours, identifies which rooms require new controls with associated material and installation costs, and lists available utility incentives for each conversion. The project spans approximately 85,085 square feet across all three facilities, with the contract period running from November 5, 2025, to June 30, 2026, with an option for one additional year extension.

The spreadsheet indicates significant energy efficiency improvements across all three locations, with the Westside facility showing total kWh savings of 76,378.91, the Fleet facility demonstrating 12,073.25 kWh savings, and Fire Station 1 achieving 14,946.25 kWh savings. Control system upgrades total $5,405.00 for the Westside facility, with various occupancy sensors and photocells specified throughout. The document references utility rebate incentives totaling $1,067.90 for Westside alone, indicating the city is leveraging energy efficiency programs to offset project costs. A mandatory site walkthrough is scheduled for September 18 and 19, 2025, with bids due October 9, 2025, at 2:00 PM. Contractors must provide DLC or ENERGY STAR certified LED products, detailed project specifications, cost breakdowns, recycling methods, utility rebate assistance, and proof of insurance and licensing. Liquidated damages of $500 per day apply for project delays. The project reflects the city's commitment to infrastructure modernization through capital improvement and building maintenance budgets allocated for energy efficiency improvements between 2025 and 2028.

View the file

Other files for this state and local contract opportunity

Other files attached to LED Lighting Conversion, newest first.
File Type Posted
Firestation 1 lighting floor plan 2.pdf PDF
RFB 25-BM14 LED Lighting Conversion.pdf PDF
WCSB 1st floor light power area A.pdf PDF
WCSB 1st floor power area B.pdf PDF
25-BM14 Notice of Intent to Award Letter.pdf PDF
25-BM14 Draft Contract.pdf PDF
Fleet Lighting Plan.pdf PDF
WCSB 1st floor lighting area B.pdf PDF
WCSB 2nd floor light power area B.pdf PDF
25-BM14 QA.pdf PDF
Attachment 1 ENERGY AUDIT MASTER.xlsx XLSX spreadsheet
Firestation 1 lighting floor plan.pdf PDF
25-BM14 Sign in Log.pdf PDF
Fire Station 1 Second Floor Plan 201_500BW.pdf PDF
25-BM LED Lighting Conversion Bid.pdf PDF
Fire station 1 First Floor Plan 200_500BW.pdf PDF
Show all 16

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 LED Fixture Schedule Westside, Fleet, Fire Station 1.

Westside
Assumptions
RoomFixture Type# of FixturesFixture WattageEx Room WattageEmergency (Y or N)ControlRun-TimeDaysNew Fixture WattageNew Room WattagekWh savingsNew Control?Control Cost (material +install)Incentive# of T8#of CFL Pin
B19T81064640Nwall42503030034020
B19 emerT8264128Y-243653060595.684
B18T84642560.1250301203.48
B17T89645760.1250302707.6518
B16T876444842503021023814
B16 emT816464Y243653030297.842
B21T8364192Nwall0.125030902.556
B21 emT816464Y243653030297.842
B22T8264128N0.125030601.74
B22 emT816464Y243653030297.842
B20T8364192N22503090516
B20 emT816464Y243653030297.842
B10 (corridor)T8964576Nwall122503027091818
B10 emT846425624365301201191.368
B26 - workoutT8171282176122506010203468Occ Sensor

tc={CF839CAB-199A-47B1-90BA-991C825DAAA7}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Add ceiling fan wattage145$ 139.5068
B26 emT81128128243656060595.68Occ Sensor50$ 6.004
B33 (corridor)T886451242503024027216
B33 emT856432024365301501489.210
B10aT82641280.125030601.74
B2726W CFL952468n42501412634218
B29 - M LockerT8964576n425030270306Occ Sensor145$ 27.00
B29 emT8264128Y243653060595.68Occ Sensor50$ 6.00
B 29 CFLCFL626156N4250742114Occ Sensor0$ 4.20
B31 - W LockerT8964576n425030270306Occ Sensor145$ 27.0018
B31 emT8264128Y243653060595.68Occ Sensor50$ 6.004
B31 CFLCFL626156N4250742114Occ Sensor0$ 4.2012
B37T87644480.1250302105.9514
B37 emT816464Y243653030297.842
B34T81464896N0.12503042011.928
B34 emT816464Y24365030302978.42
B38T8264128N0.125030601.74
B38 emT816464Y243653030297.842
B11T8464256N4250301201368
B11 emT8364192Y243653090893.526
B15T8864512N22503024013616
B15 emT816464Y243653030297.842
B14T8864512N22503024013616
B14 emT816464Y243653030297.842
B41T8264128N0.125030601.74
B13T8 (3 lamp, 1 ex)374.67224N4250351051199
B12 em3 T8296192Y243654590893.526
122CFL1152572N42501415441822
122 emCFL15252Y243651414332.882
126 ToiletsT8364192N42503090102.006
126 Toilets emT816464Y4250303034.002
120T8464256N24365301201,191.368
120 emT8432128Y243651560595.684
119T816464Y243653030297.842
121CFL652312Y2436514841,997.2812
116T8464256N425030120136.008
116 emT8464256Y24365301201,191.368
112 (vehicle bay)8' T5 HO152163240N836511216804,555.20PHOTOCELLL500$ 168.00
112 (vehicle bay) em8 T5 HO132162808Y24365112145611,843.52PHOTOCELLL500$ 145.60
St-2 emT8396288Y24365451351,340.289
Pass emT816464Y243653030297.841
110 EMS Supply2 T816464N4250303034.001
110 EMS Supply em2 T816464Y243653030297.841
Pass 1082 T8264128N4250306068.004
Pass 108 em2 T8364192Y243653090893.526
113 Decon2 T8264128N2250306034.004
113 Decon em2 T816464Y243653030297.841
114 Outdoor storage2 T816464N0.2525030302.131
128ALL LED - 201700- 0
128 emALL LED - 201700- 0
PatioALL LED - 201700- 0
129 Kitchen CFLALL LED - 201700- 0
129 Kitchen T8ALL LED - 201700- 0
129 Kitchen emALL LED - 201700- 0
104 CorridorALL LED - 201700- 0
104 Corridor emALL LED - 201700- 0
101 StorageALL LED - 201700- 0
101 storage emALL LED - 201700- 0
132 SleepingALL LED - 201700- 0
132a ToiletALL LED - 201700- 0
133 SleepingALL LED - 201700- 0
133a ToiletALL LED - 201700- 0
134 SleepingALL LED - 201700- 0
134a ToiletALL LED - 201700- 0
106 TLTALL LED - 201700- 0
111ALL LED - 201700- 0
111 emALL LED - 201700- 0
111aALL LED - 201700- 0
111a emALL LED - 201700- 0
122ALL LED - 201700- 0
122 emALL LED - 201700- 0
125ALL LED - 201700- 0
126ALL LED - 201700- 0
111BALL LED - 201700- 0
111CALL LED - 201700- 0
111C emALL LED - 201700- 0
117ALL LED - 201700- 0
116ALL LED - 201700- 0
115ALL LED - 201700- 0
121ALL LED - 201700- 0
118ALL LED - 201700- 0
193 SleepingALL LED - 201700- 0
194 SleepingALL LED - 201700- 0
195 SleepingALL LED - 201700- 0
196 SleepingALL LED - 201700- 0
197 SleepingALL LED - 201700- 0
198 SleepingALL LED - 201700- 0
199 SleepingALL LED - 201700- 0
105ALL LED - 201700- 0
138ALL LED - 201700- 0
103ALL LED - 201700- 0
1492 T8464256N0.1250301203.40OC8
144a emCFL15252Y243651414332.882
1402 T8664384N425030180204.0012
140CFL452208N42501456152.008
140 emCFL15252Y243651414332.882
141CFL15252N0.125014140.952
1473 T819696N0.125045451.283
14442W Dimmable Fluor131682184N225052676754.00PHOTOCELLL500$ 67.6052
14542W Dimmable Fluor181683024N2250529361,044.00PHOTOCELLL500$ 93.6072
14642W Dimmable Fluor131682184N225052676754.00PHOTOCELLL500$ 67.6052
144, 145, 146 em42W Dimmable Fluor61681008Y24365523126,096.96PHOTOCELLL0$ 31.2024
1026 T82192384N225090180102.0012
102CFL452208N2250145676.008
101 CorridorCFL1852936N8250142521,368.0036
101 Corridor emCFL952468Y24365141262,995.9218
1513 T819696N0.125045451.283
1542 T8664384N425030180204.0012
154CFL452208N42501456152.008
154CFL15252Y243651414332.882
1502 T8564320N0.1250301504.2510
146aCFL126262436577166.441
155 emCFL252104243651428665.764
1572 T8664384N0.1250301805.10OC145$ 18.0012
1582 T8664384N0.1250301805.10OC145$ 18.0012
1863 T83.3396319.68N625045149.85254.759.99
1853 T8296192N42504590102.006
183CFL15252N6250141457.002
1846 T82192384N425090180204.0012
1809 T83288864N4250135405459.00OC145$ 40.5027
1826 T82192384N625090180306.00OC145$ 18.0012
1816 T82192384N625090180306.00OC145$ 18.0012
1796 T82192384N625090180306.00OC145$ 18.0012
1562 T8464256N625030120204.008
156CFL1052520N625014140570.0020
156 em2 T8, CFL855440Y24365181442,592.96412
1776 T83192576N625090270459.00OC145$ 27.0012
1622 T8464256N0.1250301203.40OC$ 12.008
1762 T816464N0.125030300.852
1602 T816464N0.125030300.852
1592 T8264128N0.125030601.704
1612 T8664384N0.1250301805.10OC145$ 18.0012
1784 T81128128N62506060102.00OC145$ 6.004
1664 T82128256N0.1250601203.408
1652 T816464N2250303017.002
1644 T8, 1 T86106.6667640N225050300170.0020
1694 T81128128N2250606034.004
1664 T81128128N2250606034.004
1674 T81128128N2250606034.004
1713 T8296192N0.125045902.556
1723 T8296192N0.125045902.556
1882 T8864512N625030240408.0016
188 em2 T8464256Y24365301201,191.368
1892 T8364192N0.5250309012.756
1902 T8, 1 T8551.2256N0.1250241203.40OC145$ 12.005
2016 T8, CFL17126.11764705882144N625054.23529411769221,833.00548
201 em3 T8, CFL1069.6696Y2436526.42643,784.321212
203CFL652312N42501484228.00OC145$ 8.4012
2053 T8464256N425030120136.00OC145$ 12.0012
2043 T8696576N625045270459.00OC145$ 27.0018
204 em2 T8364192Y243653090893.526
201CFL51365N425073530.00OC145$ 3.505
2132 T816464N0.2525030302.132
2083 T8296192N42504590102.00OC145$ 9.006
2093 T8296192N42504590102.00OC145$ 9.006
49,030.6820,752.8576,378.91$ 5,405.00$ 1,067.90860.99428
Fleet Facility
Assumptions
RoomFixture Type# of FixturesFixture WattageEx Room WattageEmergency (Y or N)Controlled E WattageControlRun-TimeDaysNew Fixture WattageNew Room WattageNew EM wattageNew Wattage (No em)kWh savingsNew Control?Control Cost (material +install)Incentive# of T8#of CFL Pin# of biax
1004 32W T84128512N0W2250602400240136.0N016
1022 Biax280160N0W4250469209268.0N04
1024 32 W2128256N160W24250601200120816.0N08
101CFL12626N0W10250770747.5N001
1034 32W T82128256Y256W42506012012001,447.4N08
103 rCFL526130Y130W82507353501,092.2N01
1044 32W T84128512N0W2250602400240136.0N016
1052 32W T816464N0W2250303003017.0N02
106 corridor2x2 biax480320Y320W22504618418401,351.4N008
1072 32W T813232N0W225030300301.0N02
1084 32W T816464N0W225060600602.0N04
109CFL12626N0W225077079.5N001
1102 32WT813232N0W225030300301.0N02
1112 32W T8 / CFL429116N0W2250114404436.0N081
1122 32W T8 / CFL22958N0W225018.53703710.5N061
113 Garage4 32 W T8241283072N0W8250601440014403,264.0N096
113 Garage em4 32 W T86128768Y768W2436560036003,574.1N024
1162 32W T8264128N0W0.525030600608.5N04
1172 32 W T8864512N0W0.525030240024034.0N016
1192 32W T8564320N0W0.525030150015021.3N010
12,073.25222512
Fire Station 1
Assumptions
RoomFixture Type# of FixturesFixture WattageEx Room WattageEmergency (Y or N)ControlRun-TimeDaysNew Fixture WattageNew Room WattagekWh savingsIncentive# of T8#of CFL PinHPS
Garage - FireT85664.003,584.00Nwall1225030.001,680.005,712.0092
Garage - FireHPS8270.002,160.00Nwall12250135.001,080.003,240.008
OfficeT8 / CFL14258.388290Nwall325025.433,611.003,509.2521653
Living AreaT8 / CFL4483.273664Nwall525038.091,676.002,485.001088
Basement2 32W T81332.00416.00Nwall125015195.0055.2526
Garage - EMS1 40W T121540600.00Nwall1225015225.001,125.0015
Dining Room26W CFL426104.00Nwall5250728.0095.004

17,698.00 8,047.00 14,946.25 $ - 0 457 65 8 Add ceiling fan wattage

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