NBM_Work_Order_History_I.xlsx

XLSX spreadsheet 15 KB Posted

Attached to
Complete Faciltiy Maintanenace (CFM) for the National Building Museum
Solicitation number
EQWPME-16-5132
Issued by

About this file

From the source

Work Order History I

View the file

Other files

File Type Posted
Amendment_A0012.pdf PDF
Floor_Plans.pdf PDF
Amendment_A0011.pdf PDF
List_of_trash_and_recycle_by_floor_and_type.docx DOCX document
Q A_Part_2_Amendment_A0010.pdf PDF
NBM_Work_Order_History_II.xlsx XLSX spreadsheet
RFP_Rev _4_Amendment_A0010.pdf PDF
Amendment_A0010.pdf PDF
Amendment_A009.pdf PDF
SF1449.pdf PDF
cba_signed_2015_-_2017_ATL_NBM.pdf PDF
Amendment_A008.pdf PDF
Updated_NBM_Inventory_9-16_Amendment_A008.xlsx XLSX spreadsheet
Q A_Amendment_A008.pdf PDF
RFP_Rev _3_Amendment_A008.pdf PDF
Wage_Determination_Amendment_A008.pdf PDF
Amendment_A007.pdf PDF
Amendment_A006.pdf PDF
Amendment_A005.pdf PDF
Corrected_RFP_Rev _2.pdf PDF
Amendment__A004.pdf PDF
RFP_Rev _2.pdf PDF
Amendment_A003.pdf PDF
Amendment_A003_RFP_Cover_Sheet_Question_Cut_Off_Date_Revision.pdf PDF
cba_signed_2015_-_2017_ATL_NBM.pdf PDF
Amendment_A002_Site_Visit_Information.docx DOCX document
Amendment__A002.pdf PDF
Site_Visit_Information.pdf PDF
Amendment__A001.pdf PDF
RFP_Rev _1.pdf PDF
RFP.pdf PDF
Inventory.xlsx XLSX spreadsheet
Show all 32

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Export Worksheet

WO NumDescriptionStatusPriorityReported DateActual StartActual FinishWork TypeFailure ClassProblem codeLocation
15-11126087test test IgnoreWAPPR416-SEP-15 01:14:28SERVICECALLDC0030ZZ
15-11126088sink faucet looseWAPPR416-SEP-15 01:16:26SERVICECALLDC0030ZZ
15-10806951Unit making noiseCLOSE417-AUG-15 07:45:0906-AUG-15 12:00:0006-AUG-15 12:00:00CLIENTREQUESTHVAC MECTOO LOUDDC0030ZZ
15-10806952Unit making noiseCLOSE417-AUG-15 07:48:0506-AUG-15 12:00:0006-AUG-15 12:00:00CLIENTREQUESTHVACDC0030ZZ
15-10806953Toilet continually runningCLOSE417-AUG-15 07:50:1307-AUG-15 12:00:0007-AUG-15 12:00:00CLIENTREQUESTPLUMBINGCONSTANTLY FLUSHINGDC0030ZZ
15-11125311OOS (Beams) 9/15-17 & 9/25-9/28 4pm-7amCLOSE415-SEP-15 07:06:1517-SEP-15 01:28:5719-NOV-15 12:14:54CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
15-11458294OOS Beams 10/7-10/13 4pm-7am,10/16-19 4pm-6am,10/27-29 4pm-7amCLOSE406-OCT-15 09:29:0414-OCT-15 11:12:3430-NOV-15 05:18:16CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
15-11687935OOS Beams 11/6-11/12 4pm-7amCLOSE405-NOV-15 07:13:3010-NOV-15 10:45:4303-DEC-15 12:17:32CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
15-11688914OOS VIP visit 11/9 4pm-9pm(stby)CLOSE406-NOV-15 08:58:4810-NOV-15 03:46:4603-DEC-15 12:18:05CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
15-11925967OOS (BEAMS) 12/1-12/3 4pm-7amCLOSE401-DEC-15 09:19:1704-DEC-15 08:10:5222-DEC-15 10:28:41CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
15-11933623OOS (Beams) 12/21 7am-1/22/16 4pmCLOSE417-DEC-15 08:03:0022-DEC-15 09:42:1910-FEB-16 11:01:20CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
15-11931738OOS (BEAMS) 12/16-12/18 4pm-7am(not daily)CLOSE410-DEC-15 08:45:4317-DEC-15 10:43:2922-DEC-15 10:02:14CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
15-12156836OOS Backflow PM 1/4 7am (2 hrs)CLOSE429-DEC-15 07:32:4705-JAN-16 12:19:5911-JAN-16 12:01:22CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
16-12384237OOS (BEAMS) 2/12 4pm-2/18 7amCLOSE409-FEB-16 07:53:3717-FEB-16 08:52:0822-FEB-16 10:37:06CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
16-12613522OOS (Beams) 2/25-2/29 8pm-7am(not daily)CLOSE425-FEB-16 09:37:5502-MAR-16 09:07:5603-MAR-16 10:26:41CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
16-12626007OOS (Beams) 3/2-3/23 4pm-6am(not daily)CLOSE425-FEB-16 11:33:3903-MAR-16 12:45:3024-MAR-16 09:44:31CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
16-12920212OOS (Beams) 4/5-4/7, 4/12-4/14, 4/26-4/27 5pm-7amCLOSE404-APR-16 09:21:3806-APR-16 07:38:4611-MAY-16 09:50:35CLIENTREQUESTFIRE SHOPOUT OF SERVIDC0030ZZ
15-10806955light out above security deskCLOSE417-AUG-15 07:52:4010-AUG-15 12:00:0010-AUG-15 12:00:00SERVICECALLLIGHTOUTBULBDC0030ZZ
15-10806958Filter needs to be replacedCLOSE417-AUG-15 07:54:3610-AUG-15 12:00:0010-AUG-15 12:00:00SERVICECALLFILTERDC0030ZZ
15-10806960dirty filterCLOSE417-AUG-15 07:57:1311-AUG-15 12:00:0011-AUG-15 12:00:00SERVICECALLFILTERDC0030ZZ
15-10806963light outCLOSE417-AUG-15 07:59:3912-AUG-15 12:00:0012-AUG-15 12:00:00SERVICECALLLIGHTOUTBULBDC0030ZZ
15-10806965light outCLOSE417-AUG-15 08:01:2012-AUG-15 12:00:0012-AUG-15 12:00:00SERVICECALLLIGHTOUTBULBDC0030ZZ
15-10806967sink backing upCLOSE417-AUG-15 08:02:5912-AUG-15 12:00:0012-AUG-15 12:00:00SERVICECALLSINKDC0030ZZ
15-10806971hanidcap stall toilet clogged upCLOSE417-AUG-15 08:04:5612-AUG-15 12:00:0012-AUG-15 12:00:00SERVICECALLTOILETSDC0030ZZ
15-10806973Light outCLOSE417-AUG-15 08:07:3913-AUG-15 12:00:0013-AUG-15 12:00:00SERVICECALLLIGHTOUTBULBDC0030ZZ
15-10806974toilet continually runningCLOSE417-AUG-15 08:10:3913-AUG-15 12:00:0013-AUG-15 12:00:00SERVICECALLTOILETSDC0030ZZ
15-10806975toilet clogged upCLOSE417-AUG-15 08:12:3713-AUG-15 12:00:0013-AUG-15 12:00:00SERVICECALLTOILETSDC0030ZZ
15-10824601NO POWER TO CHILLERSCLOSE124-AUG-15 01:57:4519-AUG-15 02:01:1725-AUG-15 12:51:44SERVICECALLSWITCHGEARNO POWERDC0030ZZ
15-11126775TROUBLE BEAM DETECTORCLOSE218-SEP-15 09:10:2718-SEP-15 09:13:2103-DEC-15 12:15:17SERVICECALLFIRE SHOPTROUBLEDC0030ZZ
15-11688869Leaves in water fountainCLOSE406-NOV-15 07:45:4527-OCT-15 07:52:1127-OCT-15 07:53:04SERVICECALLPHYSBLDGFOUNTAINDC0030ZZ
15-11685827Trouble/Alarm follow upCLOSE102-NOV-15 10:46:0803-DEC-15 12:16:4303-DEC-15 12:16:43SERVICECALLFIRE SHOPALARMINGDC0030ZZ
15-11680974clogged toiletCLOSE428-OCT-15 11:58:5320-AUG-15 12:00:2420-AUG-15 12:00:35SERVICECALLPLUMBINGNO FLUSHDC0030ZZ
15-11680977Soap Dispenser leakingCLOSE428-OCT-15 12:02:3523-AUG-15 12:09:0623-AUG-15 12:09:17SERVICECALLINSPECTIONSAFETYDC0030ZZ
15-11680984Clogged ToiledCLOSE428-OCT-15 12:11:3623-AUG-15 12:13:0623-AUG-15 12:13:39SERVICECALLPLUMBINGCLOGDC0030ZZ
15-11680989Toilet not workingCLOSE428-OCT-15 12:15:2524-AUG-15 12:18:3524-AUG-15 12:18:47SERVICECALLPLUMBINGNO FLUSHDC0030ZZ
15-11680995Light OutCLOSE428-OCT-15 12:20:5124-AUG-15 12:21:4924-AUG-15 12:21:59SERVICECALLLIGHTSLIGHTOUTDC0030ZZ
15-11680997Toilet not workingCLOSE428-OCT-15 12:23:5024-AUG-15 12:26:0324-AUG-15 12:26:16SERVICECALLPLUMBINGNO FLUSHDC0030ZZ
15-11681003Broken MotorCLOSE428-OCT-15 12:27:1824-AUG-15 12:30:5924-AUG-15 12:31:16SERVICECALLHVAC MECUNIT REPLACEMENT/INSTALLDC0030ZZ
15-11681010Broken ThermostatCLOSE428-OCT-15 12:34:1824-AUG-15 12:35:3924-AUG-15 12:35:58SERVICECALLHVAC MECUNIT REPLACEMENT/INSTALLDC0030ZZ
15-11681029Clogged UrinalCLOSE428-OCT-15 12:51:2524-AUG-15 01:21:3624-AUG-15 01:22:27SERVICECALLPLUMBINGCLOGDC0030ZZ
15-11681065A vibration from duct workCLOSE428-OCT-15 01:44:3125-AUG-15 01:45:5625-AUG-15 01:46:08SERVICECALLHVAC MECDUCTDC0030ZZ
15-11681067Broken Access PanelCLOSE428-OCT-15 01:51:0026-AUG-15 01:52:4726-AUG-15 01:53:02SERVICECALLPHYSBLDGMISSING COMPDC0030ZZ
15-11680873Bad placement of thermometerCLOSE428-OCT-15 10:33:4601-SEP-15 08:35:3906-NOV-15 08:38:43SERVICECALLHVAC MECUNIT REPLACEMENT/INSTALLDC0030ZZ
15-11680875Exhaust Fan Making NoiseCLOSE428-OCT-15 10:34:3516-AUG-15 11:36:0116-AUG-15 12:37:23SERVICECALLHVAC MECTOO LOUDDC0030ZZ
15-11680883Fan Coil Unit not workingCLOSE428-OCT-15 10:45:2318-AUG-15 10:47:2128-AUG-15 10:47:50SERVICECALLHVAC MECINSPECTDC0030ZZ
15-11680891Sink not workingCLOSE428-OCT-15 10:52:3018-AUG-15 10:54:1018-AUG-15 10:54:24SERVICECALLPLUMBINGBATH SINKDC0030ZZ
15-11680895Clogged toiletCLOSE428-OCT-15 10:55:5018-AUG-15 10:57:3618-AUG-15 10:57:52SERVICECALLPLUMBINGCLOGDC0030ZZ
15-11680901Light OutCLOSE428-OCT-15 11:00:1418-AUG-15 11:03:1518-AUG-15 11:03:28SERVICECALLLIGHTSLIGHTOUTDC0030ZZ
15-11680913Toilet not workingCLOSE428-OCT-15 11:05:0318-AUG-15 11:06:4318-AUG-15 11:06:59SERVICECALLPLUMBINGNO FLUSHDC0030ZZ
15-11680922Light fixture brokenCLOSE428-OCT-15 11:08:5718-AUG-15 11:14:1118-AUG-15 11:16:28SERVICECALLLIGHTSBROKEN FIXTUREDC0030ZZ
15-116809452 lights outCLOSE428-OCT-15 11:33:0819-AUG-15 11:34:4519-AUG-15 11:35:00SERVICECALLLIGHTSLIGHTOUTDC0030ZZ
15-11680950Light OutCLOSE428-OCT-15 11:39:5319-AUG-15 11:41:0319-AUG-15 11:41:16SERVICECALLLIGHTSLIGHTOUTDC0030ZZ
15-11680953Fan Coil Unit Making NoiseCLOSE428-OCT-15 11:44:4719-AUG-15 11:45:4519-AUG-15 11:46:00SERVICECALLHVAC MECTOO LOUDDC0030ZZ
15-11680958Sink not workingCLOSE428-OCT-15 11:49:0020-AUG-15 11:51:4520-AUG-15 11:51:56SERVICECALLPLUMBINGBATH SINKDC0030ZZ
15-11680870Fan Coil Unit SmokingCLOSE428-OCT-15 10:27:3221-AUG-15 10:30:2621-AUG-15 10:50:52SERVICECALLHVAC MECINSPECTDC0030ZZ
15-11692393FIRE ALARMCLOSE118-NOV-15 11:30:0318-NOV-15 11:37:1212-APR-16 06:55:11SERVICECALLFIRE SHOPALARMINGDC0030ZZ
15-11690487Outage (Beam)CLOSE412-NOV-15 12:25:4012-NOV-15 12:28:4912-APR-16 06:55:11SERVICECALLFIRE SHOPOUT OF SERVIDC0030ZZ
15-11922453Trouble NAC PanelCLOSE230-NOV-15 08:59:3130-NOV-15 09:01:2707-DEC-15 11:19:41SERVICECALLFIRE SHOPTROUBLEDC0030ZZ
15-11927882Trouble NAC Panel Rm 429A(2-12v7ah)CLOSE203-DEC-15 11:31:1804-DEC-15 08:15:3607-DEC-15 11:18:46SERVICECALLFIRE SHOPTROUBLEDC0030ZZ
16-12667712SUPERVISORYCLOSE318-MAR-16 10:34:0518-MAR-16 10:35:5622-MAR-16 10:58:07SERVICECALLFIRE SHOPSUPERVISORYDC0030ZZ
16-12915005Repair/Program Dialer 3/30 (JH)CLOSE630-MAR-16 11:53:0731-MAR-16 08:46:3111-MAY-16 09:51:38SERVICECALLFIRE SHOPREPAIRDC0030ZZ

SQL

select wonum, description, status, wopriority, reportdate, actstart, actfinish, worktype, failurecode, problemcode, location from workorder where siteid = 'NCR' and worktype in ('SERVICECALL','CLIENTREQUEST') and reportdate >= TO_TIMESTAMP ('2015-08-15 00:00:59.000' , 'YYYY-MM-DD HH24:MI:SS.FF') and reportdate <= TO_TIMESTAMP ('2016-08-16 23:59:59.000' , 'YYYY-MM-DD HH24:MI:SS.FF') and location like '%DC0030%'

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