Lighting Spreadsheet.xls

XLS spreadsheet 15 MB Posted

Attached to
Replacement Lighting, Powell Compound Federal contract opportunity
Solicitation number
AG-82B1-S-10-0295
Issued by
Department of Agriculture Forest Service Washington Office Economic Recovery Operations Center Intermountain

About this file

Lighting Spreadsheet

View the file

Other files for this federal contract opportunity

Other files attached to Replacement Lighting, Powell Compound, newest first.
File Type Posted
AG-82B1-S-10-0295 Body.pdf PDF
AG-82B1-S-10-0295 SF 18.pdf PDF
AG-82B1-S-10-0295 Drawings.pdf PDF
Expierence Questionnaire.doc DOC document

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

POWELL SITE

Existing Building(s) Lighting Spreadsheet Tool - Updated Jan 20, 2010
Project Name:POWELL WORK CENTERUtility Invoice Number:Utility Invoice Number
Dominant Building Type:Serving Utility:Utility Name
Space Heat Fuel Source:Utility Contact Name:Utility Contact Name
Customer NameCLEARWATER FSUtility Phone Number:Utility Phone
Contact Name:Energy Rate ($/kWh) & estimated $ savings/yr:$0.05CUSTOMER SIMPLE PAYBACK:
Facility Street Address:Demand Rate ($/kW) & estimated $ savings/yr:$0.000.0yearsThis Section for Calculating PV of Periodic Lamp Replacement Cost
Facility City:Audit Prepared By (Name and Phone Number):Auditor InfoUses a user-defined function called dfuncPV
Facility State & Zip:Trade Ally/Contractor Name:Trade Ally NameProgram Parameters
Building & Account NumberDate & Time (fills in automatically):3/24/10 7:23 AM
Discount Rate=dfuncPV(Number,OperatingHours,AverageLife,Cost,Labor,Labor_Rate,Discount_Rate,Measure_Life)
Summary Table >>Total Existing Kilowatt-HoursTotal Proposed Kilowatt-HoursTotal Estimated Annual kWh Site Savings (unadjusted)Annual Hours (weighted)Kilowatt-Hour Reduction PercentageTotal kWh Site Savings (adjusted for HVAC)Measure Life
79,30629,10850,1971,28263%Labor Rate
Project Cost>>Lesser of Credit/Reimbursement -or- 0% Project Cost>>Project Cost Cap
LocationExisting Lamp/Ballast CombinationNotes:Proposed Lamp/Ballast CombinationSummary/Design InfoContractor CostBPA Estimate Material and Labor Costs (Preliminary Only)ExistingProposed
For instance; building and room nameAnnual Operat HoursExisting Lamp/BallastQ'tyWatts EachMean Lumens EachTotal WattsTotal kWhFor high performance lamps and ballasts on the CEE list, include model numbers and CEE list date. Field notes on fixtures, mounting height, difficulty, approvals, etc…Annual Operat HoursProposed Lamp/BallastQ'tyWatts EachMean Lumens EachTotal WattsTotal kWhAnnual kWh SavingskWh ReductionLight Level ChangeUnit$ per unitTotal $Installed Cost Per UnitNumber of UnitsTotalNotesCutsheetsRated Average Lamp Life (hours/lamp for ballast type and start frequency)Lamp Cost ($/lamp)Lamp Change Labor (hours/lamp)PV Lamp Periodic ReplacementRated Average Lamp Life (hours/lamp for ballast type and start frequency)Lamp Cost ($/lamp)Lamp Change Labor (hours/lamp)PV Lamp Periodic ReplacementNet PV Lamp Periodic Replacement (Costs(+) or Savings(-))
0.00
1Old Barn (2406)000$00$00.00
2Tack Shed1,000T12 8' Fluorescent, 2-75 Watt Lamps, Energy Efficient Ballast115810,1811581581,000High Performance T8, 4-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.1959,07195956340%-11%18' 4LT8 Kit LBF1,2,312,0000.0030,0000.000.00
3Tack Shed1,000Incandescent, 1-300 Watt Bulb23004,8026006001,000Standard 4' T8 2 lamp 32 Watt 80+CRI lamp with Reduced Light Output ballast, (2-F32T8)2554,37211011049082%-9%2New 2-lamp fixture or screw-in CFL (32-42 watts) Cost based on new fixture1,2,47500.0024,0000.000.00
4Exterior Tack Shed500Incandescent, 1-200 Watt Bulb12003,154200100500High Pressure Sodium, 50W1683,28068346666%4%1Outdoor Use - Cold rated down to -20 F6a or 6b0.00
5Exterior Old Barn1Incandescent, 1-200 Watt Bulb12003,15420001High Pressure Sodium, 50W1683,280680066%4%1Existing fixture may not work - consider de-commissioningAssume 1 hr Labor0.00
6Exterior Old Barn1Metal Halide, 150 Watt Lamp11858,64018501No recommendation (leave fixture as-is)100000100%-100%1No Change0.00
7Shop/Garage (2310)Most likely not used much (4x) 10 kW unit heaters
8Mid Bay200Incandescent, 1-300 Watt Bulb73004,8022,100420200Standard 4' T8 2 lamp 32 Watt 80+CRI lamp with Reduced Light Output ballast, (2-F32T8)7554,3723857734382%-9%7New 2-lamp fixture or screw-in CFL (32-42 watts) Cost based on new fixture (some of the fixtures may not need to be re-lit)1,2,47500.0024,0000.000.00
9Sign Bay200Incandescent, 1-300 Watt Bulb73004,8022,100420200Standard 4' T8 2 lamp 32 Watt 80+CRI lamp with Reduced Light Output ballast, (2-F32T8)7554,3723857734382%-9%7New 2-lamp fixture or screw-in CFL (32-42 watts) Cost based on new fixture (some of the fixtures may not need to be re-lit)1,2,47500.0024,0000.000.00
10Garage200T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast8884,868704141200High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.8484,594384776445%-6%8Existing fixtures too old to retrofit recommend replacement1,2,420,0000.0030,0000.000.00
111313 BldgCadet Wall heaters (120v/240v 750/1500 watt - 4x), single pane windows
12General Interior1,500T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts41769,7367041,0561,500High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.4484,59419228876873%-53%4Recommend delamping to 2 lamps. Reflector kit is recommended - cost based on kit1,2,320,0000.0030,0000.000.00
13Back Room1,500Incandescent, 1-60 Watt Typical Bulb4608002403601,500Screw-In CFL, 14 Watt414720568427677%-10%4CFL screw in or hardwire GU Base - Cost based on screw in51,2000.0010,0000.000.00
14Shower/Bath1,000Incandescent, 1-60 Watt Typical Bulb6608003603601,000Screw-In CFL, 14 Watt614720848427677%-10%6CFL screw in or hardwire GU Base - Cost based on screw in51,2000.0010,0000.000.00
15Multipurpose Bldg (1401)Baseboard Heaters (manual thermostats), Single pane windows
16General Interior2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast15884,8681,3202,6402,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.15484,5947201,4401,20045%-6%152L Reballast LBF1,220,0000.0030,0000.000.00
17General Interior2,000T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts51769,7368801,7602,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.5484,5942404801,28073%-53%5Recommend delamping to 2 lamps. Reflector kit is recommended - cost based on kit1,2,320,0000.0030,0000.000.00
18General InteriorCan reduce as much as 50% of lighting usage in Line 16 and 170Assume 30% reduction in hours0Occupancy Sensor, Timer, Photocell, or Control Panel controlling the above fixtures (50 to 200 watts) (reduce proposed operating hours accordingly)200002Ceiling Mount Sensor Dual Tech Highlighted in Red for consideration only)80.00
19Multipurpose (adjacent room)Cadet Wall Heaters (manual thermostats), Single pane windows
20Multi-Purpose (adjacent room)1,500T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast8884,8687041,0561,500High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.8484,59438457648045%-6%82L Reballast LBF1,220,0000.0030,0000.000.00
21Restroom500Incandescent, 1-60 Watt Typical Bulb560800300150500Screw-In CFL, 14 Watt514720703511577%-10%5CFL screw in or hardwire GU Base - Cost based on screw in51,2000.0010,0000.000.00
22Back Room500Incandescent, 1-60 Watt Typical Bulb26080012060500Screw-In CFL, 14 Watt21472028144677%-10%2CFL screw in or hardwire GU Base - Cost based on screw in51,2000.0010,0000.000.00
23Exterior1,500Incandescent, 1-60 Watt Typical Bulb3608001802701,500Screw-In CFL, 14 Watt314720426320777%-10%3Because of cold weather - CFLs not recommended unless in new enclosed fixtures - price based on new fixtures6c1,2000.0010,0000.000.00
24Exercise Bldg (2016)Baseboard Heaters (manual thermostats), Double pane windows
25General Area1,500T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts31769,7365287921,500High Performance T8, 4-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.3959,07128542836546%-7%34L Reballast LBF1,220,0000.0030,0000.000.00
26Tree Cooler Bldg (1514)
27General500T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,86817688500High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,59496484045%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
28General500T12 8' Fluorescent, 2-75 Watt Lamps, Energy Efficient Ballast115810,18115879500High Performance T8, 4-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.1959,07195483240%-11%18' 4LT8 Kit LBF1,2,312,0000.0030,0000.000.00
29Cooler200Incandescent, 1-75 Watt Typical Bulb5751,08637575200Screw-In CFL, 18 Watt51897890185776%-10%5CFL screw in or new one lamp fluorescent - Cost based on screw in51,2000.0010,0000.000.00
30Exterior Lighting
31Warehouse (2206)1High Pressure Sodium, 150 Watt Lamp61858,6401,11011No recommendation (leave fixture as-is)600001100%-100%6No Change0.00
32Warehouse (2206)1High Pressure Sodium, 35 Watt Lamp1622,0066201No recommendation (leave fixture as-is)100000100%-100%1No Change10,0000.00- 00.000.00
33Fuel Depot4,380Incandescent, 1-100 Watt Typical Bulb51001,5485002,1904,380Screw-In CFL, 18 Watt518978903941,79682%-37%5Because of cold weather - CFLs not recommended unless in new enclosed fixtures - price based on new fixtures61,0000.0010,0000.000.00
34Admin Bldg1High Pressure Sodium, 100 Watt Lamp21207,79024001No recommendation (leave fixture as-is)200000100%-100%2No Change0.00
35Admin Flag Pole4,380Halogen, 300 Watt13004,6803001,3144,380Metal Halide Pulse Start, 150 Watt Lamp117516,00017576754842%242%1Not sure of existing flag pole wattage - need more info6d1,5000.0012,0000.000.00
36Exterior Pole Lights4,380Mercury Vapor, 400 Watt Lamp945419,1004,08617,8974,380High Pressure Sodium, 150W917013,1201,5306,70111,19563%-31%9Not sure of existing pole wattage - need more info724,0000.0024,0000.000.00
371360 Bldg (Quad)Building relatively efficient
38NotesBuilding has Circline Lamps in the Bedrooms with 1 40-watt and 1 32-watt circular lamps per fixture. May want to standardize to 4-ft fixtures. None of the Fluor Fixtures have electronic ballasts.Kitchen, bedroom reading light, vanities, living room have 20-watt (2-ft) fluorescents. Again may want to standardize to a T8/electronic system.Standardize? See notes10a,10b
39Living Room1,500T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,8681762641,500High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,5949614412045%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
40Vestibule4,380T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,8681767714,380High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,5949642035045%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
41Warehouse (2206)Building has relatively efficient lighting - 4-ft fluorescent fixtures T8 lamps, LED exit signs. Heating a combination of electric baseboard in offices, wall heaters in hallway, 3 kw & 7.5 kw unit heaters in bays.
42Alcove on main floor200T12 8' Fluorescent, 2-75 Watt Lamps, Energy Efficient Ballast115810,18115832200High Performance T8, 4-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.1959,07195191340%-11%18' 4LT8 Kit LBF (no reflector needed)1,2,312,0000.0030,0000.000.00
43Main Bay Floor1,500Metal Halide, 250 Watt Lamp629511,3001,7702,6551,500HIGH OUTPUT (high-bay) FLUORESCENT (Install New Fixture)615309181,3771,27848%-100%6New high bay flourescent910,0000.00- 00.000.00
44Carpenter Bay1,500Metal Halide, 250 Watt Lamp229511,3005908851,500HIGH OUTPUT (high-bay) FLUORESCENT (Install New Fixture)2153030645942648%-100%2New high bay flourescent910,0000.00- 00.000.00
45Carpenter Bay1,500T12 8' Fluorescent, 2-75 Watt Lamps, Energy Efficient Ballast315810,1814747111,500High Performance T8, 4-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.3959,07128542828440%-11%38' 4LT8 Kit LBF1,2,312,0000.0030,0000.000.00
46Garage2,000Metal Halide, 250 Watt Lamp429511,3001,1802,3602,000HIGH OUTPUT (high-bay) FLUORESCENT (Install New Fixture)415306121,2241,13648%-100%4New high bay flourescent910,0000.00- 00.000.00
47Garage150T12 8' Fluorescent, 2-75 Watt Lamps, Energy Efficient Ballast515810,181790119150High Performance T8, 4-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.5959,071475714740%-11%58' 4LT8 Kit LBF1,2,312,0000.0030,0000.000.00
48Fire Cashe150Metal Halide, 250 Watt Lamp229511,30059089150HIGH OUTPUT (high-bay) FLUORESCENT (Install New Fixture)21530306464348%-100%2New high bay flourescent910,0000.00- 00.000.00
49Fire Cashe1,500T12 8' Fluorescent, 2-75 Watt Lamps, Energy Efficient Ballast215810,1813164741,500High Performance T8, 4-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2959,07119028518940%-11%28' 4LT8 Kit LBF1,2,312,0000.0030,0000.000.00
50Admin Bldg (2014)
51EntrySee Line 38 Bldg 1360 Circline Lamp description (1 32-watt lamp). Consider standardizing to single lamp 4-ft fixture1
52Exit Signs throughout8,760Incandescent Exit Sign, 2-15 Watt Lamps63021801,5778,760New LED Exit Sign632181581,41990%0%6New LED Exit Sign1110,0000.00100,0000.000.00
53Reception Area2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast3884,8682645282,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.3484,59414428824045%-6%32L Reballast LBF1,220,0000.0030,0000.000.00
54Reception Area (Track Lighting)2,000Incandescent, 120 Watt Reflector Lamp51201,4406001,2002,000Screw-In CFL, 25 - 27 Watt5261,48813026094078%3%5CFL Screw-in5b2,0000.0010,0000.000.00
55Adjacent Office2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast3884,8682645282,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.3484,59414428824045%-6%32L Reballast LBF1,220,0000.0030,0000.000.00
56Adjacent Office2,000T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts11769,7361763522,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.1484,594489625673%-53%1Recommend delamping to 2 lamps. Reflector kit is recommended - cost based on kit1,2,320,0000.0030,0000.000.00
57Hallway2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast4884,8683527042,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.4484,59419238432045%-6%42L Reballast LBF1,220,0000.0030,0000.000.00
58Mens Restroom1,000T12 4' Fluorescent, 1-40 Watt Lamp, Energy Efficient Ballast1462,43446461,000High Performance T8, 1-4' lamp with Reduced Light Output ballast. Consult CEE's qualifying products list.1252,29725252146%-6%11L Reballast LBF1,2 (1 lamp ballast)20,0000.0030,0000.000.00
59Mens Restroom1,000T12 Other Fluorescent, 2-20 Watt Lamps, Magnetic Pre-Heat Ballast1501,88750501,000Standard 2' T8 1 lamp 17 Watt 80+CRI lamp, (1-F17T8)1161,10316163468%-42%11L Reballast LBF2, 10b (1 or 2 lp)9,0000.0024,0000.000.00
60Womens Restroom1,000T12 4' Fluorescent, 1-40 Watt Lamp, Energy Efficient Ballast1462,43446461,000High Performance T8, 1-4' lamp with Reduced Light Output ballast. Consult CEE's qualifying products list.1252,29725252146%-6%11L Reballast LBF1,220,0000.0030,0000.000.00
61Womens Restroom1,000T12 Other Fluorescent, 2-20 Watt Lamps, Magnetic Pre-Heat Ballast1501,88750501,000Standard 2' T8 1 lamp 17 Watt 80+CRI lamp, (1-F17T8)1161,10316163468%-42%11L Reballast LBF2, 10b (1 or 2 lp)9,0000.0024,0000.000.00
62Mollys Office2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,8681763522,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,5949619216045%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
63Chads Office2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast4884,8683527042,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.4484,59419238432045%-6%42L Reballast LBF1,220,0000.0030,0000.000.00
64Computer Room2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,8681763522,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,5949619216045%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
65Dougs Area2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast6884,8685281,0562,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.6484,59428857648045%-6%62L Reballast LBF1,220,0000.0030,0000.000.00
66Matts Office2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,8681763522,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,5949619216045%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
67Marks Office2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,8681763522,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,5949619216045%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
68Marks Office2,000T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts21769,7363527042,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,5949619251273%-53%2Recommend delamping to 2 lamps. Reflector kit is recommended - cost based on kit1,2,320,0000.0030,0000.000.00
69Across from Marks2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,8681763522,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,5949619216045%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
70Next office2,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast3884,8682645282,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.3484,59414428824045%-6%32L Reballast LBF1,220,0000.0030,0000.000.00
71Fire Management1,000T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast5884,8684404401,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.5484,59424024020045%-6%52L Reballast LBF1,220,0000.0030,0000.000.00
72Track Lighting1,000Incandescent, 120 Watt Reflector Lamp21201,4402402401,000Screw-In CFL, 25 - 27 Watt2261,488525218878%3%2CFL Screw-in52,0000.0010,0000.000.00
73Back StairsSee Line 38 Bldg 1360 Circline Lamp description (1 32-watt lamp). Consider standardizing to single lamp 4-ft fixture2
74Back Stairs1,000T12 Other Fluorescent, 2-20 Watt Lamps, Magnetic Pre-Heat Ballast2501,8871001001,000Standard 2' T8 1 lamp 17 Watt 80+CRI lamp, (1-F17T8)2161,10332326868%-42%21L Reballast LBF2 & 10b (1 or 2 lp)9,0000.0024,0000.000.00
75Front StairsSee Line 38 Bldg 1360 Circline Lamp description (1 32-watt lamp). Consider standardizing to single lamp 4-ft fixture1
76Upper Hallway2,000T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts21769,7363527042,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,5949619251273%-53%2Recommend delamping to 2 lamps. Reflector kit is recommended - cost based on kit1,2,320,0000.0030,0000.000.00
77Conference Room1,000T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts101769,7361,7601,7601,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.10484,5944804801,28073%-53%10Recommend delamping to 2 lamps. Reflector kit is recommended - cost based on kit1,2,320,0000.0030,0000.000.00
78Conference Room1,000T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts101769,7361,7601,7601,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.10484,5944804801,28073%-53%10Recommend delamping to 2 lamps. Reflector kit is recommended - cost based on kit1,2,320,0000.0030,0000.000.00
79Kitchen1,000Incandescent, 1-60 Watt Typical Bulb16080060601,000Screw-In CFL, 14 Watt11472014144677%-10%1CFL Screw-in51,2000.0010,0000.000.00
80Mens Restroom500Incandescent, 1-60 Watt Typical Bulb36080018090500Screw-In CFL, 14 Watt31472042216977%-10%3CFL Screw-in51,2000.0010,0000.000.00
81Womens Restroom500Incandescent, 1-60 Watt Typical Bulb36080018090500Screw-In CFL, 14 Watt31472042216977%-10%3CFL Screw-in51,2000.0010,0000.000.00
82Main General OfficeSee Line 38 Bldg 1360 Circline Lamp description (1 32-watt lamp). Consider standardizing to single lamp 4-ft fixture6
83General Office2,000T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts171769,7362,9925,9842,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.17484,5948161,6324,35273%-53%17Recommend delamping to 2 lamps. Reflector kit is recommended - cost based on kit1,2,320,0000.0030,0000.000.00
84Office2,000T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts11769,7361763522,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.1484,594489625673%-53%1Recommend delamping to 2 lamps. Reflector kit is recommended - cost based on kit1,2,320,0000.0030,0000.000.00
85Office2,000T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts11769,7361763522,000High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.1484,594489625673%-53%1Recommend delamping to 2 lamps. Reflector kit is recommended - cost based on kit1,2,320,0000.0030,0000.000.00
86Upper Attic100Incandescent, 1-300 Watt Bulb73004,8022,100210100Screw-In CFL, 35 - 36 Watt (includes circline)7361,7852522518588%-63%7screw-in CFL (32-42 watts)57500.0010,0000.000.00
87Houses (1009, 1013, 1014)Quatities: total of all the houses (assumed similar layout)
88General1,500Incandescent, 1-60 Watt Typical Bulb12608007201,0801,500Screw-In CFL, 14 Watt121472016825282877%-10%12CFL Screw-in51,2000.0010,0000.000.00
89General1,500Incandescent, 2-60 Watt Typical Bulbs91201,6001,0801,6201,500Screw-In CFL, 14 Watt18147202523781,24277%-10%18CFL Screw-in51,2000.0010,0000.000.00
90Bathroom Vanity (3 lp globe fix)1,000Incandescent, 3-60 Watt Typical Bulbs31801,6005405401,000Hard-Wired CFL, 1-32 Watt Lamp (new fixture)3332,040999944182%28%3New fixture w/F17 lamps or CFLs10a,10b1,2000.0010,0000.000.00
91House (2613)
92General500T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast3884,868264132500High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.3484,594144726045%-6%32L Reballast LBF1,220,0000.0030,0000.000.00
93Bathroom Vanity (3 lp globe fix)300Incandescent, 3-40 Watt Typical Bulbs11201,60012036300Hard-Wired CFL, 1-32 Watt Lamp (new fixture)1332,04033102673%28%1New fixture w/F17 lamps or CFLs10a,10b1,2000.0010,0000.000.00
94Bathroom fan300Incandescent, 1-60 Watt Typical Bulb1608006018300Screw-In CFL, 14 Watt1147201441477%-10%1CFL Screw-in (space restrictions)51,2000.0010,0000.000.00
95Exterior300Incandescent, 75 Watt Reflector Lamp1758017523300Screw-In CFL, 18 Watt1189781851776%22%1Because of cold weather - CFLs not recommended unless in new enclosed fixtures - price based on new fixtures6c2,0000.0010,0000.000.00
96Exterior300Incandescent, 1-300 Watt Bulb13004,80230090300Screw-In CFL, 18 Watt1189781858594%-80%1Because of cold weather - CFLs not recommended unless in new enclosed fixtures - price based on new fixtures6c7500.0010,0000.000.00
97Houses (1335, 1334)Quatities: total of all the houses (assumed similar layout)
98Kitchen1,000T12 4' Fluorescent, 1-40 Watt Lamp, Energy Efficient Ballast6462,4342762761,000High Performance T8, 1-4' lamp with Reduced Light Output ballast. Consult CEE's qualifying products list.6252,29715015012646%-6%61L Reballast LBF1,220,0000.0030,0000.000.00
99Rooms (4 rooms/house)500Incandescent, 2-60 Watt Typical Bulbs81201,600960480500Screw-In CFL, 14 Watt161472022411236877%-10%16CFL Screw-in51,2000.0010,0000.000.00
100Rooms (4 rooms/house) reading light1,000Incandescent, 1-75 Watt Typical Bulb8751,0866006001,000Screw-In CFL, 18 Watt81897814414445676%-10%8CFL Screw-in51,2000.0010,0000.000.00
101Restroom vanity500T12 Other Fluorescent, 2-20 Watt Lamps, Magnetic Pre-Heat Ballast4501,887200100500Standard 2' T8 2 lamp 17 Watt 80+CRI lamp, (2-F17T8)4322,206128643636%17%42L Reballast LBF2,10b9,0000.00- 00.000.00
102Exterior500Incandescent, 1-60 Watt Typical Bulb460800240120500Screw-In CFL, 14 Watt41472056289277%-10%4Because of cold weather - CFLs not recommended unless in new enclosed fixtures - price based on new fixtures6c1,2000.0010,0000.000.00
103Houses (1312, 1311)Quatities: total of all the houses (assumed similar layout)
104Kitchen600T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast8884,868704422600High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.8484,59438423019245%-6%82L Reballast LBF1,220,0000.0030,0000.000.00
105Kitchen600Incandescent, 1-60 Watt Typical Bulb460800240144600Screw-In CFL, 14 Watt414720563411077%-10%4CFL Screw-in51,2000.0010,0000.000.00
106HallwaySee Line 38 Bldg 1360 Circline Lamp description (1 32-watt lamp). Consider standardizing to single lamp 4-ft fixture6
107Bathroom300Standard 4' T8 2 lamp 32 Watt4604,93224072300No recommendation (leave fixture as-is)4000072100%-100%4No change1,2- 00.00- 00.000.00
108Miscellaneous space300T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast6884,868528158300High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.6484,594288867245%-6%62L Reballast LBF1,220,0000.0030,0000.000.00
109Miscellaneous space300T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts21769,736352106300High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,59496297773%-53%2Recommend delamping to 2 lamps. Reflector kit is recommended - cost based on kit1,2,320,0000.0030,0000.000.00
110Rooms (6 Rm / house)600T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast12884,8681,056634600High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.12484,59457634628845%-6%122L Reballast LBF1,220,0000.0030,0000.000.00
111Exterior300Incandescent, 1-60 Watt Typical Bulb46080024072300Screw-In CFL, 14 Watt41472056175577%-10%4Because of cold weather - CFLs not recommended unless in new enclosed fixtures - price based on new fixtures6c1,2000.0010,0000.000.00
112Wash House (1604)
113General500T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,86817688500High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,59496484045%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
114General500Incandescent, 1-60 Watt Typical Bulb560800300150500Screw-In CFL, 14 Watt514720703511577%-10%5Screw in - if wet location, need wet-rated bulb or fixture51,2000.0010,0000.000.00
115Duplex (1372)Includes both sides - assumed similar
116Kitchen1,500T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,8681762641,500High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,5949614412045%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
117Garage500Incandescent, 1-60 Watt Typical Bulb26080012060500Screw-In CFL, 14 Watt21472028144677%-10%2Screw in51,2000.0010,0000.000.00
118Bathroom (vanity)300T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,86817653300High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,59496292445%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
119Bedroom 1 & 2See Line 38 Bldg 1360 Circline Lamp description (1 32-watt lamp). Consider standardizing to single lamp 4-ft fixture4
120Closet100Incandescent, 1-60 Watt Typical Bulb26080012012100Screw-In CFL, 14 Watt214720283977%-10%2Screw in51,2000.0010,0000.000.00
121Wash Closet500Incandescent, 1-60 Watt Typical Bulb26080012060500Screw-In CFL, 14 Watt21472028144677%-10%2Screw in51,2000.0010,0000.000.00
122Stairs1,000PL lights (2 13-watt), non electronic fluorescent. Consider standardizing lamps4No recommendation (leave fixture as-is)442,10a,10b
123Upper Bedroom1,000PL lights (2 13-watt) , non electronic fluorescent. Consider standardizing lamps4No recommendation (leave fixture as-is)442,10a,10b
124Upper Storage100Incandescent, 1-60 Watt Typical Bulb46080024024100Screw-In CFL, 14 Watt4147205661877%-10%4Screw in1,2000.0010,0000.000.00
125Exterior500Incandescent, 1-60 Watt Typical Bulb460800240120500Screw-In CFL, 14 Watt41472056289277%-10%4Because of cold weather - CFLs not recommended unless in new enclosed fixtures - price based on new fixtures6c1,2000.0010,0000.000.00
126Duplex (1062)Includes both sides - assumed similar to 1372
127Kitchen1,500T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,8681762641,500High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,5949614412045%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
128Garage500Incandescent, 1-60 Watt Typical Bulb26080012060500Screw-In CFL, 14 Watt21472028144677%-10%2Screw in51,2000.0010,0000.000.00
129Bathroom (vanity)300T12 4' Fluorescent, 2-40 Watt Lamps, Energy Efficient Ballast2884,86817653300High Performance T8, 2-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2484,59496292445%-6%22L Reballast LBF1,220,0000.0030,0000.000.00
130Bedroom 1 & 2See Line 38 Bldg 1360 Circline Lamp description (1 32-watt lamp). Consider standardizing to single lamp 4-ft fixture4
131Closet100Incandescent, 1-60 Watt Typical Bulb26080012012100Screw-In CFL, 14 Watt214720283977%-10%2Screw in51,2000.0010,0000.000.00
132Wash Closet300Incandescent, 1-60 Watt Typical Bulb26080012036300Screw-In CFL, 14 Watt2147202882877%-10%2Screw in51,2000.0010,0000.000.00
133Stairs1,000PL lights (2 13-watt), non electronic fluorescent. Consider standardizing lamps4No recommendation (leave fixture as-is)442,10a,10b
134Upper Bedroom500PL lights (2 13-watt) , non electronic fluorescent. Consider standardizing lamps4No recommendation (leave fixture as-is)442,10a,10b
135Upper Storage100Incandescent, 1-60 Watt Typical Bulb46080024024100Screw-In CFL, 14 Watt4147205661877%-10%4Screw in51,2000.0010,0000.000.00
136Exterior500Incandescent, 1-60 Watt Typical Bulb460800240120500Screw-In CFL, 14 Watt41472056289277%-10%4Because of cold weather - CFLs not recommended unless in new enclosed fixtures - price based on new fixtures6c1,2000.0010,0000.000.00
137Rambler House (1036)Not sure which rambler I visited? (1006, 1036, 1046). Quantities reflect all the houses.0
138Living Room1,000Incandescent, 3-60 Watt Typical Bulbs31801,6005405401,000Screw-In CFL, 14 Watt91472012612641477%35%9Screw in51,2000.0010,0000.000.00
139Master Bedroom1,000Incandescent, 2-60 Watt Typical Bulbs31201,6003603601,000Screw-In CFL, 14 Watt614720848427677%-10%6Screw in51,2000.0010,0000.000.00
140Restroom vanity500Incandescent, 4-40 Watt Typical Bulbs31601,610480240500Standard 2' T8 2 lamp 17 Watt 80+CRI lamp, (2-F17T8)3322,206964819280%37%3New fixture w/F17 lamps or CFLs10a,10b1,5000.00- 00.000.00
141Bathroom fan500Incandescent, 1-60 Watt Typical Bulb36080018090500Screw-In CFL, 14 Watt31472042216977%-10%3CFL Screw-in (space restrictions)51,2000.0010,0000.000.00
142Bedroom 21,000Incandescent, 2-60 Watt Typical Bulbs31201,6003603601,000Screw-In CFL, 14 Watt614720848427677%-10%6Screw in51,2000.0010,0000.000.00
143Bedroom 31,000Incandescent, 2-60 Watt Typical Bulbs31201,6003603601,000Screw-In CFL, 14 Watt614720848427677%-10%6Screw in51,2000.0010,0000.000.00
144Kitchen1,000T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts31769,7365285281,000High Performance T8, 4-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.3959,07128528524346%-7%34L Reballast LBF1,220,0000.0030,0000.000.00
145Restroom vanity500Incandescent, 4-40 Watt Typical Bulbs31601,610480240500Standard 2' T8 2 lamp 17 Watt 80+CRI lamp, (2-F17T8)3322,206964819280%37%3New fixture w/F17 lamps or CFLs10a,10b1,5000.00- 00.000.00
146HallwaySee Line 38 Bldg 1360 Circline Lamp description (1 32-watt lamp). Consider standardizing to single lamp 4-ft fixture310a,10b
147Exterior1,000Incandescent, 1-60 Watt Typical Bulb6608003603601,000Screw-In CFL, 14 Watt614720848427677%-10%6Because of cold weather - CFLs not recommended unless in new enclosed fixtures - price based on new fixtures6c1,2000.0010,0000.000.00
148Utility Closet500Incandescent, 2-60 Watt Typical Bulbs31201,600360180500Screw-In CFL, 14 Watt614720844213877%-10%6Screw in51,2000.0010,0000.000.00
149Garage500Incandescent, 1-60 Watt Typical Bulb960800540270500Screw-In CFL, 14 Watt9147201266320777%-10%9Screw in51,2000.0010,0000.000.00
150Triplex (1064)Not sure which unit I visited? . Quantities only reflect all Unit.
151Mechanical Room500Incandescent, 1-60 Watt Typical Bulb36080018090500Screw-In CFL, 14 Watt31472042216977%-10%3Screw in51,2000.0010,0000.000.00
152Lower FloorSee Line 38 Bldg 1360 Circline Lamp description (1 32-watt lamp). Consider standardizing to single lamp 4-ft fixture9
153Bathroom fan500Incandescent, 1-60 Watt Typical Bulb36080018090500Screw-In CFL, 14 Watt31472042216977%-10%3CFL Screw-in (space restrictions)51,2000.0010,0000.000.00
154Kitchen1,500T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts31769,7365287921,500High Performance T8, 4-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.3959,07128542836546%-7%34L Reballast LBF1,220,0000.0030,0000.000.00
155Kitchen1,000Incandescent, 3-60 Watt Typical Bulbs31801,6005405401,000Screw-In CFL, 14 Watt91472012612641477%35%9Screw in51,2000.0010,0000.000.00
156Kitchen1,000T12 Other Fluorescent, 2-20 Watt Lamps, Magnetic Pre-Heat Ballast3501,8871501501,000Standard 2' T8 2 lamp 17 Watt 80+CRI lamp, (2-F17T8)3322,20696965436%17%32L Reballast LBF2,10b9,0000.00- 00.000.00
157Bathroom500Incandescent, 2-60 Watt Typical Bulbs31201,600360180500Screw-In CFL, 14 Watt614720844213877%-10%6Screw in51,2000.0010,0000.000.00
158Bedroom 11,000Incandescent, 2-60 Watt Typical Bulbs31201,6003603601,000Screw-In CFL, 14 Watt614720848427677%-10%6Screw in51,2000.0010,0000.000.00
159Bedroom 21,000Incandescent, 2-60 Watt Typical Bulbs31201,6003603601,000Screw-In CFL, 14 Watt614720848427677%-10%6Screw in51,2000.0010,0000.000.00
160Stairs500Incandescent, 1-60 Watt Typical Bulb660800360180500Screw-In CFL, 14 Watt614720844213877%-10%6Screw in51,2000.0010,0000.000.00
161Stairs500T12 4' Fluorescent, 1-40 Watt Lamp, Energy Efficient Ballast3462,43413869500High Performance T8, 1-4' lamp with Reduced Light Output ballast. Consult CEE's qualifying products list.3252,29775383246%-6%31L Reballast LBF1,220,0000.0030,0000.000.00
162Exterior1,000Incandescent, 1-65 Watt PAR Lamp6656083903901,000Screw-In CFL, 14 Watt614720848430678%19%6Because of cold weather - CFLs not recommended unless in new enclosed fixtures - price based on new fixtures6c2,0000.0010,0000.000.00
163Duplex (1359)Not sure which unit I visited? . Quantities only reflect all Unit.
164Mechanical Room500Incandescent, 1-60 Watt Typical Bulb26080012060500Screw-In CFL, 14 Watt21472028144677%-10%2Screw in51,2000.0010,0000.000.00
165Lower FloorSee Line 38 Bldg 1360 Circline Lamp description (1 32-watt lamp). Consider standardizing to single lamp 4-ft fixture6
166Bathroom fan500Incandescent, 1-60 Watt Typical Bulb26080012060500Screw-In CFL, 14 Watt21472028144677%-10%2CFL Screw-in (space restrictions)51,2000.0010,0000.000.00
167Kitchen1,500T12 4' Fluorescent, 4-40 Watt Lamps, Energy Efficient Ballasts21769,7363525281,500High Performance T8, 4-4' lamps with Reduced Light Output ballast. Consult CEE's qualifying products list.2959,07119028524346%-7%24L Reballast LBF1,220,0000.0030,0000.000.00
168Kitchen1,000Incandescent, 3-60 Watt Typical Bulbs21801,6003603601,000Screw-In CFL, 14 Watt614720848427677%35%6Screw in51,2000.0010,0000.000.00
169Kitchen1,000T12 Other Fluorescent, 2-20 Watt Lamps, Magnetic Pre-Heat Ballast2501,8871001001,000Standard 2' T8 2 lamp 17 Watt 80+CRI lamp, (2-F17T8)2322,20664643636%17%22L Reballast LBF2,10b9,0000.00- 00.000.00
170Bathroom500Incandescent, 2-60 Watt Typical Bulbs21201,600240120500Screw-In CFL, 14 Watt41472056289277%-10%4Screw in51,2000.0010,0000.000.00
171Bedroom 11,000Incandescent, 2-60 Watt Typical Bulbs21201,6002402401,000Screw-In CFL, 14 Watt414720565618477%-10%4Screw in51,2000.0010,0000.000.00
172Bedroom 21,000Incandescent, 2-60 Watt Typical Bulbs21201,6002402401,000Screw-In CFL, 14 Watt414720565618477%-10%4Screw in51,2000.0010,0000.000.00
173Stairs500Incandescent, 1-60 Watt Typical Bulb460800240120500Screw-In CFL, 14 Watt41472056289277%-10%4Screw in51,2000.0010,0000.000.00
174Stairs500T12 4' Fluorescent, 1-40 Watt Lamp, Energy Efficient Ballast2462,4349246500High Performance T8, 1-4' lamp with Reduced Light Output ballast. Consult CEE's qualifying products list.2252,29750252146%-6%21L Reballast LBF1,220,0000.0030,0000.000.00
175Exterior1,000Incandescent, 1-65 Watt PAR Lamp4656082602601,000Screw-In CFL, 14 Watt414720565620478%19%4Because of cold weather - CFLs not recommended unless in new enclosed fixtures - price based on new fixtures6c2,0000.0010,0000.000.00
TOTALS>>>56861,84379,30658820,49829,10850,1970goes to ProjectSave
Adding and Deleting Rows:

To Add Rows: 1) move the curser to the number box on the left hand side of the row you want to add and left-click to highlight the row, 2) right-click in the highlighted area and choose "copy", 3) right-click again on the row number and choose "insert copied cells".

To Delete Rows: 1) move the curser to the number box on the left hand side of the row you want to add and left-click to highlight the row, 2) right-click in the highlighted area and choose "delete".

P.S. The print area on this worksheet is set so the note box does not print. The print area is set on the other worksheets as well.

&L&P&R&D, &T Add A Row Automatically copies the Existing Lamp/Ballast Combination Quantity unless user types in a changed value. For instance, type in a different value if one or more fixtures are removed or added.

Mean lamp(s) light output per existing luminaire. Does not include luminaire efficiency. Automatically draws from the Data Existing tab column D of this workbook.

Quantity of existing luminaires. User input value.

Existing watts per luminaire. Automatically draws from the Data Existing tab column C of this workbook.

These are drop-down boxes. Make a selection and it will automatically draw from the Data Existing tab column B of this workbook and populate column F, G, H, I, and J of this spreadsheet.

Estimated annual operating hours of each lighting measure (not the building). This value is user calculated and input.

Area of building, room number, location, office name, etc.. Be specific enough that someone unfamiliar with the building can easily find the room or area. You can group exact same rooms together if they have the same hours of operation and are closely located.

Must be 25% or greater in order to receive a reimbursement or credit. Font turns red if less than 25%.

Proposed watts per luminaire. Automatically drawn from the Data Proposed tab column C of this workbook.

Mean lamp(s) light output per proposed luminaire. Does not include luminaire efficiency. Automatically drawn from the Data Proposed tab column D of this workbook.

Spreadsheet automatically calculates this value. It is a per room per measure calculation.

These are drop-down boxes. Make a selection and it will automatically draw from the Data Proposed tab column B of this workbook and populate column N, O, P, and Q of this spreadsheet.

Weighted average of existing lighting system hours of operation per year.

Calculated from column Q of this worksheet. Column Q is a hidden column.

Calculated from column I of this worksheet. Column I is a hidden column.

Automatically copies the Existing Annual Operating Hours of the measure unless user types in a changed value. For instance, type in a different value if an occupancy sensor is installed.

Total Project Estimated Annual kWh savings at the site. This value is unadjusted for interactions and busbar savings. This cell sums up values in column R.

OPTIONAL: This value should be the most representative utility demand rate in dollars per kilowatt per month. You may have to average seasonal demand rates.

This cell automatically calculates the estimated dollar savings per year (12 months) associated with kW or Demand savings. This number is added to the energy savings value and put into the estimated dollar savings cell in the letter tab of this workbook.

REQUIRED: This value should be the most representative energy rate in dollars per kilowatt-hour. Usually the highest block rate in the utilities rate structure. May have to average seasonal energy rates.

This is the Reimbursement or Credit amount. Based on the total rebate amounts or 70% of project cost whichever is less. Only gives a Credit if the kWh Reduction is at least 25%.

This value is taken from the Data Proposed tab column F.

This value is the multiplication of column M and column X of this spreadsheet. It is the total reimbursement or credit per measure.

Font is RED if Wattage Reduction is NOT between 20 and 50%. The value(s) below are only related to each measure.

Font is RED if Change in Light Level is NOT between -10% and +10%. Calculates total change in light output of lamp(s) only. Ignores luminaire efficiency. Use the below value(s) to determine how close you are to the existing light level.

Per measure summary info. Use this info to check yourself.

This value is only related to the lighting kilowatt-hour reduction affected by the installation. Does not depict total building kilowatt-hour reduction percentage.

Input the project cost into the cell to the right or use the contractor bid info form to the right of this page. Includes labor and materials from the installation contractors' invoices. Also, can include in-house labor costs. Direct installation labor costs only.

This value is taken from the Data Proposed tab column E.

CAA or CRC Reimbursement or Credit per unit and total per measure Charlie Grist:

Electric Savings including estimated interactive effects of lighting and HVAC Charlie Grist:

Select building type from list. If multiple building types are present consider separate audit sheets for separate buildings. Or select the type that most closely matches the primary areas of the building where proposed lighting measures occur.

This value is used to estimate interactive effects of lighting energy savings on HVAC.

Charlie Grist:

Select dominant space heat type from list. If multiple space heat types are present, consider separate audit sheets for separate buildings. Or select the type that most closely matches the primary areas of the building where proposed lighting measures occur.

This value is used to estimate interactive effects of lighting energy savings on HVAC.

Input building for this project This value takes into account the energy…

This is the start of the file's text. The full file is on GovTribe.

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