ME001_LightingWorkbook.xlsx

XLSX spreadsheet 61 KB Posted

Attached to
Construction - Lighting Upgrade Federal contract opportunity
Solicitation number
W15QKN-21-Q-5126
Issued by
Department of the Army Materiel Command Contracting Command Picatinny Arsenal

View the file

Other files for this federal contract opportunity

Show all 18

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

Lighting Fixture Schedule

FROM AS-BUILTREPLACEMENT SCHEDULE
Fixture TypeManufacturerCatalog NumberVoltsLAMP DATAMOUNTING TYPEDESCRIPTION
QTYBALLASTTYPE (Watts)Fixture StyleFixture QtyLamp QtyLamp TypeQtyWattage /lampFixture WattageTotal Wattage /type
A12776T5HO54High Bay2x4 Fluorescent, 6-lamp instant start ballast1166HIGH BAY EQ TO 6 T5 HO116516510890
A22772T8-D83532Strip1x4 Fluorescent, 2-lamp instant start ballast1020T8 - TLED DIRECT FIT21020200
A32772T8-D83532Recessed1x4 Fluorescent, 2-lamp instant start ballast65130T8 - TLED DIRECT FIT210201300
A42774T8-D83532Recessed2x4 Fluorescent, 4-lamp instant start ballast103412T8 - TLED DIRECT FIT410404120
A52772T1244Strip1x4 Fluorescent, 2-lamp3978STRIP LED135.435.42761.2
A62771CFL26Bulb131LED A41999
A92772T832Strip4 feet strip, 2-lamp instant star balast2856T8 - TLED DIRECT FIT21020560
A102772T8U32Recessed2X2 Fluorescent, 2-lamp instant start ballast1020T8 - TLED U21326260
A112771MH150High BayMetal Halide88HIGH BAY EQ TO 150 W MH16363504

TOTAL 269 763

Lighting Savings

MA022 - Lighting Workbook
INTERIOR LIGHTING
BuildingSpace TypeFixture QtyEXISTINGPROPOSEDPROPOSED CONTROLSSAVINGS
LocationExisting ControlsHours Reduction FactorFixture Code (from As-Built)TypeLamp QtyLamp WattageLamp TypeActual Fixture WattageAnnual Runtime HourskWbasekwh baseLamp QtyLamp TypeLamp WattageFixture WattagekWeekWh eeControl Measure?Control TypeReduction FactorCFIFLamp kWh SavingsLamp kW SavingsControls kWh SavingsControls kW SavingsTOTAL kWh SavingsTOTAL Demand Savings (kw)Comments
Training CtrROOM 103Office (Occupied)Occupancy Sensor0.311A1654T5HO32418203.56464861HIGH BAY EQ TO 6 T5 HO165165.01.8153303No---0.00.6803183.181.190.000.0031831.19
Training CtrROOM 102Misc / Storage---08A2232T8-D835649000.512461T8 - TLED DIRECT FIT1020.00.16144YesOccupancy Sensor0.30.720316.800.2543.200.033600.29
Training CtrROOM 104Misc / Storage---06A3232T8-D835649000.384346T8 - TLED DIRECT FIT1020.00.12108YesOccupancy Sensor0.30.720237.600.1932.400.032700.22
Training CtrROOM 105Misc / Storage---02A3232T8-D835649000.128115T8 - TLED DIRECT FIT1020.00.0436YesOccupancy Sensor0.30.72079.200.0610.800.01900.07
Training CtrROOM 106Misc / Storage---02A3232T8-D835649000.128115T8 - TLED DIRECT FIT1020.00.0436YesOccupancy Sensor0.30.72079.200.0610.800.01900.07
Training CtrROOM 117Misc / Storage---01A3232T8-D835649000.06458T8 - TLED DIRECT FIT1020.00.0218YesOccupancy Sensor0.30.72039.600.035.400.00450.04
Training CtrROOM 118Misc / Storage---01A4432T8-D8351289000.128115T8 - TLED DIRECT FIT1040.00.0436YesOccupancy Sensor0.30.72079.200.0610.800.01900.07
Training CtrROOM 120 - AOffice (Occupied)---01A4432T8-D83512826000.128333T8 - TLED DIRECT FIT1040.00.04104YesOccupancy Sensor0.30.680228.800.0631.200.012600.07
Training CtrROOM 120 - BOffice (Occupied)---02A4432T8-D83512826000.256666T8 - TLED DIRECT FIT1040.00.08208YesOccupancy Sensor0.30.680457.600.1262.400.025200.14
Training CtrROOM 120 - COffice (Occupied)---02A4432T8-D83512826000.256666T8 - TLED DIRECT FIT1040.00.08208YesOccupancy Sensor0.30.680457.600.1262.400.025200.14
Training CtrROOM 120 - DOffice (Occupied)---02A4432T8-D83512826000.256666T8 - TLED DIRECT FIT1040.00.08208YesOccupancy Sensor0.30.680457.600.1262.400.025200.14
Training CtrROOM 121Office (Occupied)---02A4432T8-D83512826000.256666T8 - TLED DIRECT FIT1040.00.08208YesOccupancy Sensor0.30.680457.600.1262.400.025200.14
Training CtrROOM 113Office (Occupied)---02A4432T8-D83512826000.256666T8 - TLED DIRECT FIT1040.00.08208YesOccupancy Sensor0.30.680457.600.1262.400.025200.14
Training CtrROOM 113 - AOffice (Occupied)---05A4432T8-D83512826000.641664T8 - TLED DIRECT FIT1040.00.2520YesOccupancy Sensor0.30.6801144.000.30156.000.0413000.34
Training CtrROOM 110Misc / Storage---02A5244T12889000.176158STRIP LED35.470.80.1416127YesOccupancy Sensor0.30.72030.960.0238.230.03690.06
Training CtrROOM 111 - AMisc / Storage---02A2232T8-D835649000.128115T8 - TLED DIRECT FIT1020.00.0436YesOccupancy Sensor0.30.72079.200.0610.800.01900.07
Training CtrROOM 111 - BMisc / Storage---02A3232T8-D835649000.128115T8 - TLED DIRECT FIT1020.00.0436Yes---0.00.72079.200.060.000.00790.06
Training CtrROOM 112 - AMisc / Storage---010A5244T12889000.88792STRIP LED35.470.80.708637YesOccupancy Sensor0.30.720154.800.12191.160.153460.28
Training CtrROOM 112 - BMisc / Storage---02A3232T8-D835649000.128115T8 - TLED DIRECT FIT1020.00.0436Yes---0.00.72079.200.060.000.00790.06
Training CtrROOM 107 - 108Misc / Storage---08A5244T12889000.704634STRIP LED35.470.80.5664510YesOccupancy Sensor0.30.720123.840.10152.930.122770.22
Training CtrROOM 107 - 108Misc / Storage---02A3232T8-D835649000.128115T8 - TLED DIRECT FIT1020.00.0436Yes---0.00.72079.200.060.000.00790.06
Training CtrROOM 202Misc / Storage---01A6126CFL269000.02623LED A499.00.0098YesOccupancy Sensor0.30.72015.300.012.430.00180.01
Training CtrROOM 213Office (Occupied)---08A4432T8-D83512826001.0242662T8 - TLED DIRECT FIT1040.00.32832YesOccupancy Sensor0.30.6801830.400.48249.600.0720800.54
Training CtrROOM 212Office (Occupied)---09A4432T8-D83512826001.1522995T8 - TLED DIRECT FIT1040.00.36936YesOccupancy Sensor0.30.6802059.200.54280.800.0723400.61
Training CtrROOM 207Office (Occupied)---08A4432T8-D83512826001.0242662T8 - TLED DIRECT FIT1040.00.32832YesOccupancy Sensor0.30.6801830.400.48249.600.0720800.54
Training CtrROOM 211Office (Occupied)---09A4432T8-D83512826001.1522995T8 - TLED DIRECT FIT1040.00.36936YesOccupancy Sensor0.30.6802059.200.54280.800.0723400.61
Training CtrROOM 210Office (Occupied)---08A4432T8-D83512826001.0242662T8 - TLED DIRECT FIT1040.00.32832YesOccupancy Sensor0.30.6801830.400.48249.600.0720800.54
Training CtrROOM 214Office (Occupied)---02A3232T8-D8356426000.128333T8 - TLED DIRECT FIT1020.00.04104YesOccupancy Sensor0.30.680228.800.0631.200.012600.07
Training CtrROOM 122 - COffice (Occupied)---02A4432T8-D83512826000.256666T8 - TLED DIRECT FIT1040.00.08208NoOccupancy Sensor0.30.680457.600.1262.400.025200.14
Training CtrROOM 122 - AOffice (Occupied)---04A4432T8-D83512826000.5121331T8 - TLED DIRECT FIT1040.00.16416NoOccupancy Sensor0.30.680915.200.24124.800.0310400.27
Training CtrROOM 123 - AOffice (Occupied)---01A4432T8-D83512826000.128333T8 - TLED DIRECT FIT1040.00.04104NoOccupancy Sensor0.30.680228.800.0631.200.012600.07
Training CtrROOM 123 - BOffice (Occupied)---02A4432T8-D83512826000.256666T8 - TLED DIRECT FIT1040.00.08208NoOccupancy Sensor0.30.680457.600.1262.400.025200.14
Training CtrRANGEMisc / Storage---015A5244T12889001.321188STRIP LED35.470.81.062956NoOccupancy Sensor0.30.720232.200.19286.740.235190.42
Training CtrRANGEMisc / Storage---06A3232T8-D835649000.384346T8 - TLED DIRECT FIT1020.00.12108No---0.00.720237.600.190.000.002380.19
Training CtrTELEMisc / Storage---01A6126CFL269000.02623LED A499.00.0098NoOccupancy Sensor0.30.72015.300.012.430.00180.01
Training CtrROOM 134 - AOffice (Occupied)---014A4432T8-D83512826001.7924659T8 - TLED DIRECT FIT1040.00.561456NoOccupancy Sensor0.30.6803203.200.84436.800.1136400.95
Training CtrROOM 134 - BOffice (Occupied)---02A4432T8-D83512826000.256666T8 - TLED DIRECT FIT1040.00.08208NoOccupancy Sensor0.30.680457.600.1262.400.025200.14
Training CtrH1Corridors / Stairwells---08A10232T8U6487600.5124485T8 - TLED U1326.00.2081822NoOccupancy Sensor0.30.7202663.040.22546.620.0432100.26
Training CtrH2Corridors / Stairwells---08A4432T8-D83512887601.0248970T8 - TLED DIRECT FIT1040.00.322803NoOccupancy Sensor0.30.7206167.040.51840.960.0770080.58
Training CtrH3Corridors / Stairwells---01A10232T8U6487600.064561T8 - TLED U1326.00.026228NoOccupancy Sensor0.30.720332.880.0368.330.014010.03
Training CtrH4Corridors / Stairwells---06A3232T8-D8356487600.3843364T8 - TLED DIRECT FIT1020.00.121051NoOccupancy Sensor0.30.7202312.640.19315.360.0326280.22
Training CtrH5Corridors / Stairwells---02A4432T8-D83512887600.2562243T8 - TLED DIRECT FIT1040.00.08701NoOccupancy Sensor0.30.7201541.760.13210.240.0217520.14
Training CtrH6Corridors / Stairwells---09A4432T8-D83512887601.15210092T8 - TLED DIRECT FIT1040.00.363154NoOccupancy Sensor0.30.7206937.920.57946.080.0878840.65
Training CtrBOILER ROOMMisc / Storage---08A111150MH1509001.21080HIGH BAY EQ TO 150 W MH6363.00.504454NoOccupancy Sensor0.30.720626.400.50136.080.117620.61
OMSOIL ROOMMisc / Storage---06A6126CFL269000.156140LED A499.00.05449NoOccupancy Sensor0.30.72091.800.0714.580.011060.09
OMSCOOLANT ROOMMisc / Storage---04A6126CFL269000.10494LED A499.00.03632NoOccupancy Sensor0.30.72061.200.059.720.01710.06
OMSMAINTENANCE BAYMisc / Storage---022A9232T8649001.4081267T8 - TLED DIRECT FIT1020.00.44396NoOccupancy Sensor0.30.720871.200.70118.800.109900.79
OMSROOM M12Office (Occupied)---04A3232T8-D8356426000.256666T8 - TLED DIRECT FIT1020.00.08208NoOccupancy Sensor0.30.680457.600.1262.400.025200.14
OMSROOM M11Misc / Storage---04A3232T8-D835649000.256230T8 - TLED DIRECT FIT1020.00.0872NoOccupancy Sensor0.30.720158.400.1321.600.021800.14
OMSROOM M05Misc / Storage---02A3232T8-D835649000.128115T8 - TLED DIRECT FIT1020.00.0436NoOccupancy Sensor0.30.72079.200.0610.800.01900.07
OMSROOM M04Misc / Storage---03A3232T8-D835649000.192173T8 - TLED DIRECT FIT1020.00.0654NoOccupancy Sensor0.30.720118.800.1016.200.011350.11
OMSROOM M03Misc / Storage---01A3232T8-D835649000.06458T8 - TLED DIRECT FIT1020.00.0218NoOccupancy Sensor0.30.72039.600.035.400.00450.04
OMSROOM M01Misc / Storage---01A9232T8649000.06458T8 - TLED DIRECT FIT1020.00.0218NoOccupancy Sensor0.30.72039.600.035.400.00450.04
OMSMAINTENANCE BAYMisc / Storage---05A9232T8649000.32288T8 - TLED DIRECT FIT1020.00.190NoOccupancy Sensor0.30.720198.000.1627.000.022250.18
OMSROOM M13Office (Occupied)---03A3232T8-D8356426000.192499T8 - TLED DIRECT FIT1020.00.06156NoOccupancy Sensor0.30.680343.200.0946.800.013900.10
OMSROOM M10Misc / Storage---03A3232T8-D835649000.192173T8 - TLED DIRECT FIT1020.00.0654NoOccupancy Sensor0.30.720118.800.1016.200.011350.11
OMSROOM M02Misc / Storage---02A3232T8-D835649000.128115T8 - TLED DIRECT FIT1020.00.0436NoOccupancy Sensor0.30.72079.200.0610.800.01900.07
OMSROOM M08Bathroom---04A3232T8-D8356426000.256666T8 - TLED DIRECT FIT1020.00.08208NoOccupancy Sensor0.30.680457.600.1262.400.025200.14
OMSROOM M06Bathroom---04A3232T8-D8356426000.256666T8 - TLED DIRECT FIT1020.00.08208NoOccupancy Sensor0.30.680457.600.1262.400.025200.14
OMSROOM M21Misc / Storage---01A6126CFL269000.02623LED A499.00.0098NoOccupancy Sensor0.30.72015.300.012.430.00180.01
OMSHALLWAYCorridors / Stairwells---04A3232T8-D8356487600.2562243T8 - TLED DIRECT FIT1020.00.08701NoOccupancy Sensor0.30.7201541.760.13210.240.0217520.14
Training CtrSTAIRS 1Corridors / Stairwells---02A5244T128887600.1761542STRIP LED35.470.80.14161240No---0.00.720301.340.020.000.003010.02
Training CtrSTAIRS 2Corridors / Stairwells---02A5244T128887600.1761542STRIP LED35.470.80.14161240No---0.00.720301.340.020.000.003010.02

TOTAL 80627 29953 TOTAL 50674 12 7186 2 57860 14

EXTERIOR LIGHTS
BuildingSpace TypeFix QtyEXISTINGPROPOSEDCONTROLSCALCULATIONS
LocationFixture Type (from As-Builts)TypeLamp QtyLamp WattageLamp TypeActual Fixture WattageAnnual Runtime HourskWbasekwh baseLamp TypeLamp WattageFixture WattagekWeekWh eeControl Measure?Control TypeAnnual Runtime Hours after CMCFIFLamp kWh SavingsLamp kW SavingsControls kWh SavingsControls kW SavingsTOTAL kWh SavingsTOTAL Demand Savings (kw)Comments
ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/ANoExisting Photocell0.010ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A
---ERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A0
TOTALERROR:#N/AERROR:#N/ATOTALERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/AERROR:#N/A

TOTAL (ALL LIGHTING) ERROR:#N/A ERROR:#N/A

SUMMARY OF FIXTURE TYPESFixturesLamps
U00

TOTAL 0 0

Space TypeRuntime HoursLogicCFIF
---01.000.00
24hr Load87600.720
Corridors / Stairwells87600.720
Exterior43801.000.00
Misc / Storage9000.720
Office (Occupied)26000.680
Office (Unused)9000.680
Classroom26000.680
Bathroom26000.680
OMS26000.680
Control MeasureReductionLogicY/N
---0.0No Change
Occupancy Sensor0.3NJ TRMYes
Daylight Dimming0NJ TRMNo
Existing Photocell0.0No Change

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