{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":456,"n_cols":5,"rows_kept":456}
["Capability* (Select)","Section","Req/Pref","Function","Conforms Completely"]
["N/A",1.3,null,"Prospective CMMS Provider Qualifications","Able with Work-Around"]
[null,"1.3.A","Req","Minimum five years providing maintenance management software","Cannot Perform"]
[null,"1.3.B","Req","Client renewal rate of at least 95%"]
[null,"1.3.C","Req","Minimum of five hundred (500) current, active clients"]
["N/A",1.4,null,"System Requirements"]
[null,"1.4.A","Req","Cloud-based, software-as-a-service (SaaS)"]
[null,"1.4.B","Req","Web access compatible with:"]
[null,"1.4.B.1","Req"," Microsoft Internet Explorer (version 11 and higher)"]
[null,"1.4.B.2","Req","Microsoft Edge (version 44 and higher)"]
[null,"1.4.B.3","Req","Google Chrome (version 77 and higher)"]
[null,"1.4.B.4","Req","Mozilla Firefox (version 40 and higher)"]
[null,"1.4.C","Req","Mobile application compatible with:"]
[null,"1.4.C.1","Req","Android 8.0 and higher"]
[null,"1.4.C.2","Req","Apple iOS 12 and higher"]
[null,"1.4.C.3","Req","Windows Mobile 10"]
["N/A",1.5,null,"Data Security & Availability"]
[null,"1.5.A","Req"," Data is encrypted in transit"]
[null,"1.5.A.1","Pref","Encrypted at rest (preferred)"]
[null,"1.5.B","Req","Data resides in a secured data center"]
[null,"1.5.C","Pref","Preferred cloud hosting with resilient providers, such as Amazon Web Services or Google"]
[null,"1.5.D","Pref"," Minimum 99.7% uptime; 99.9% is preferred"]
[null,"1.5.E","Req","Database backed up at least daily"]
[null,"1.5.E.1","Req","       Proof that backups are tested "]
[null,"1.5.F","Req","Data owned by OWNER and available at any time in an Excel-compatible format"]
[null,"1.5.G","Req","User Security"]
[null,"1.5.G.1","Req","Unique User ID"]
[null,"1.5.G.2","Req","Require password that meets the following:"]
[null,"1.5.G.2.a","Req","Password reset requirement after specified number of days (Owner configurable)"]
[null,"1.5.G.2.b","Pref"," Combination of upper and lower-case and special character (Preferred)"]
[null,"1.5.G.3","Pref","Single Sign-On Authentication capability (Preferred)"]
[null,"1.5.G.3.a","Req","Supports CAS, Central Authentication Service"]
[null,"1.5.G.3.b","Req","     Supports Shibboleth"]
[null,"1.5.H","Req","FERPA Compliant"]
[null,"1.5.H.1","Req","Family Educational Rights and Privacy Act (FERPA) (20 U.S.C. § 1232g; 34 CFR Part 99) is a Federal law that protects the privacy of student education records"]
[null,"1.5.H.2","Req","UAH does not anticipate maintaining student information in the CMMS, other than potentially contact information, as a service requester"]
["N/A",1.6,null,"Service & Support"]
[null,"1.6.A","Req","Provide training "]
[null,"1.6.B","Req","Robust online tutorials and intuitive instructions"]
[null,"1.6.C","Req","Assist with bulk importing of data during implementation"]
[null,"1.6.D","Req","Technical support during business hours (7AM to 5PM Central Time)"]
[null,"1.6.D.1","Req","Support available via phone, e-mail, and online chat  "]
[null,"1.6.D.2","Req","Average support response times meet the below requirements:"]
[null,"1.6.D.2.a","Req","     Less than four-hour response for normal/low-priority tickets"]
[null,"1.6.D.2.b","Req","     Less than one-hour response for high-priority/critical tickets"]
["N/A",1.7,null,"Functional Requiremetns"]
[{"$nulls":3},"System will provide the minimum REQUIRED functions, unless otherwise indicated.  System should provide functionality “out-of-the-box” without work-around. Shortcomings of SYSTEM should be addressed in proposal response.  "]
["N/A",1.8,null,"General Functions"]
[null,"1.8.A","Req","Accommodate 3-D (e.g. QR) bar codes"]
[null,"1.8.B","Req","Web interface should accommodate OWNER logo and style guidelines"]
[null,"1.8.C","Req","OWNER configurable user-defined fields available in all modules/forms"]
[null,"1.8.C.1","Req","UDFs are available for queries and reports"]
[null,"1.8.D","Req","Global search capability in all modules"]
[null,"1.8.D.1","Req","“Wild card” character (e.g. %) available to assist with searching"]
[null,"1.8.E","Req","Ability to integrate with UAH’s building controls system, which employs Johnson Controls"]
[null,"1.8.E.1","Req","Automatically create work order from alarm generated in building controls system"]
[null,"1.8.F","Req","Ability to integrate with Banner Financial System"]
[null,"1.8.G","Pref","CAD and/or REVIT Viewer (preferred, but not required)"]
["N/A",1.9,null,"Location/Asset Information"]
[null,"1.9.A","Req","Parent/Child hierarchy with at least three levels"]
[null,"1.9.1","Pref","Unlimited levels (preferred, but not required)"]
[null,"1.9.2","Req","Location hierarchy (assets/equipment shown via relative location hierarchy)"]
[null,"1.9.B","Req","Associate asset/equipment with location"]
[null,"1.9.C","Req","Ability to add/modify user-defined fields to capture asset attributes"]
[null,"1.9.D","Req","Copy/Duplicate assets to create new"]
[null,"1.9.D.1","Req","Paste with Find & Replace function"]
[null,"1.9.E","Req","Accommodate hyperlink to web address or shared file location for referenced documents, files, etc. "]
[null,"1.9.F","Req","Attach images and files to asset/location"]
[null,"1.9.G","Req","Ability to “retire” assets without deleting them or their history from the database"]
[null,"1.9.H","Req","Minimum required fields for asset information:"]
[null,"1.9.H.1","Req","Unique equipment ID (alphanumeric)"]
[null,"1.9.H.2","Req","Asset/equipment description"]
[null,"1.9.H.3","Req","Location ID (alphanumeric)"]
[null,"1.9.H.4","Req","Location description"]
[null,"1.9.H.5","Req","Criticality/Priority Level (OWNER definable)"]
[null,"1.9.H.6","Req","Owner"]
[null,"1.9.H.7","Req","Department"]
[null,"1.9.H.8","Req","System Type dropdown list (OWNER definable)"]
[null,"1.9.H.9","Req","Date installed"]
[null,"1.9.H.10","Req","Manufacturer"]
[null,"1.9.H.11","Req"," Model and serial numbers"]
[null,"1.9.H.12","Req","Warranty end date"]
[null,"1.9.H.12.a","Req","Alerts user that equipment is under warranty when Work Order (WO) initiated"]
[null,"1.9.H.13","Req","Installation/Replacement cost"]
[null,"1.9.H.14","Req","Capacity/Size"]
[null,"1.9.H.15","Req","Parts list"]
[null,"1.9.H.15.a","Req","Link to inventory"]
[null,"1.9.H.16","Req","Life expectancy in years or months (can be a user-defined field)"]
[null,"1.9.H.17","Req","                 Asset condition (can be a user-defined field)"]
[null,"1.9.H.18","Req","                 Hazards (e.g. asbestos, confined space, etc.)"]
[null,"1.9..I","Req"," Aggregate and track asset lifecycle costs"]
[null,"1.9.J","Req","Track fleet vehicles and related maintenance, costs, etc."]
[null,"1.9.K","Req","Associate/list asset parts, such as belts, filters, lubricant, etc."]
[null,"1.9.L","Req","Associate/link parent and child assets"]
[null,"1.9.M","Req","View Work Order history for Asset/Location"]
[null,"1.9.N","Req","Associate and trend meter data for assets/locations"]
[null,"1.9.N.1","Req","                  Establish alarm thresholds or triggers for meters that creates follow-up work orders"]
["N/A",{"v":1.1,"d":"1.10"},null,"Submit Service Requests (SR)"]
[null,"1.10.A","Req","Submit via web interface with username and password"]
[null,"1.10.B","Req","Submit via web interface as a general user – no username or password required "]
[null,"1.10.B.1","Req","Requester provides their contact information with service request"]
[null,"1.10.C","Req","Ability to submit service requests via:"]
[null,"1.10.C.1","Req","Text"]
[null,"1.10.C.2","Req","E-mail"]
[null,"1.10.C.3","Req","QR(3-D) code"]
[null,"1.10.D","Req","Provide custom link or “button” to service request form"]
[null,"1.10.D.1","Req","Link/button can be sent out via e-mail or put on facility department website"]
[null,"1.10.E","Req","Minimum fields available on submission form:"]
[null,"1.10.E.1","Req","Requester (auto-populate if user is logged in)"]
[null,"1.10.E.2","Req","Requester contact information (auto-populate if user is logged in)"]
[null,"1.10.E.3","Req","Service type dropdown list (OWNER definable)"]
[null,"1.10.E.4","Req","Service Location (dropdown list and free text)"]
[null,"1.10.E.5","Req","Requested completion date & time"]
[null,"1.10.E.6","Req","Request description (free text)"]
[null,"1.10.E.7","Req","Priority dropdown list (OWNER definable)"]
[null,"1.10.F","Req","Ability to select which fields are visible"]
[null,"1.10.G","Req","Ability to select which fields are required"]
[null,"1.10.H","Req","Acknowledgement of SR submission to Requester"]
[null,"1.10.I","Req","Auto-notification to Requester of SR approval, scheduling, and completion"]
[null,"1.10.I.1","Req","Notifications, including text, are OWNER configurable"]
[null,"1.10.J","Req","Requester receives customer survey upon completion of WO"]
[null,"1.10.K","Pref","Ability to attach file to SR with submission (preferred, but not required)"]
[null,"1.10.L","Req","Auto date/timestamp of submission"]
[null,"1.10.M","Req","Duplicate WO/request confirmation"]
[null,"1.10.N","Req","Communicate with Requester to coordinate access and solicit more information"]
[null,"1.10.O","Req","Route requests back to Requester for approval "]
["N/A",1.11,null,"Create Work Orders"]
[null,"1.11.A","Req","Staff can create work orders (WO) via web interface and mobile application"]
[null,"1.11.B","Req","Create child/ren WO under parent WO"]
[null,"1.11.B.1","Req","Option to generate follow-up WO(s) on failed task(s"]
[null,"1.11.C","Req","Select WO Priority from dropdown list (OWNER definable)"]
[null,"1.11.D","Req","Includes various Work Order (WO) types (e.g. PM, CM, EM, etc.)"]
[null,"1.11.D.1","Req","  OWNER definable"]
[null,"1.11.E","Req","Select OWNER configurable problem code"]
[null,"1.11.F","Req","Duplicate WO confirmation"]
["N/A",1.12,null,"Job Plans"]
[null,"1.12.A","Req","Unlimited number tasks associated with Job Plan"]
[null,"1.12.B","Req","Duplicate/copy to create new Job Plan(s)"]
[null,"1.12.C","Req","Estimate duration"]
[null,"1.12.D","Req","Identify required parts and tools"]
[null,"1.12.E","Req","List safety hazards and necessary Personal Protective Equipment (PPE)"]
[null,"1.12.F","Pref","Identify required trade or skill sets for Job Plan (preferred, not required)"]
["N/A",1.13,null,"Preventive Maintenance"]
[null,"1.13.A","Req","Create & Schedule Preventive Maintenance (PM) work order"]
[null,"1.13.B","Req","Assign PM to asset (location or equipment)"]
[null,"1.13.C","Req","Select PM frequency"]
[null,"1.13.D","Req","Assign WO priority at PM level"]
[null,"1.13.D.1","Req","Automatically sets WO priority when WO is generated"]
[null,"1.13.E","Req","Assign to Department (select from dropdown list)"]
[null,"1.13.F","Req","Assign to specific skill/trade (select from dropdown list)"]
[null,"1.13.G","Req","Ability to assign to Contractor"]
[null,"1.13.H","Req","Nest work orders or tasks (e.g. semi-annual PM supersedes quarterly PM)"]
[null,"1.13.I","Req","Generate PM work orders based upon calendar (e.g. monthly, quarterly, etc.) or run-time (e.g. run-hours)"]
[null,"1.13.J","Req","Assign parts to PMs"]
[null,"1.13.J.1","Req","Pull parts and deduct from inventory"]
[null,"1.13.J.2","Req","Auto-notify, if needed parts are not available "]
[null,"1.13.K","Req","Ability to generate PM labor and material forecast report"]
[null,"1.13.L","Req","Create follow-up work orders for failed tasks"]
[null,"1.13.L.1","Pref","Option for one-to-one ratio (one work order per failed task) (preferred, but not required)"]
[null,"1.13.L.2","Pref","Options for many-to-one ratio (one work order for all failed task) (preferred, but not required)"]
["N/A",1.14,null,"Workflow Management"]
[null,"1.14.A","Req"," OWNER should have capability to create/configure workflows and notifications, including the below functionalities"]
[null,"1.14.B","Req","Auto-assign SRs to staff, trade, or department based upon:"]
[null,"1.14.B.1","Req","Service Type selected"]
[null,"1.14.B.2","Req","Location"]
[null,"1.14.C","Req","Route/assign Work Orders based upon:"]
[null,"1.14.C.1","Req","Shop"]
[null,"1.14.C.2","Req","Zone"]
[null,"1.14.C.3","Req","Problem/Failure/Reason Code"]
[null,"1.14.C.4","Req"," Priority"]
[null,"1.14.D","Req","Ability to route WOs to Contractor(s)"]
[null,"1.14.E","Req","Staff/contractor notified when assigned WO via:"]
[null,"1.14.E.1","Req","E-mail"]
[null,"1.14.E.2","Req","Text"]
[null,"1.14.F","Req","Ability to route WOs for approval (e.g. supervisor, financial, purchasing, etc.)"]
[null,"1.14.G","Req","Automated alerts and notifications based upon saved criteria"]
[null,"1.14.H","Req","Work Order Substatus (OWNER configurable) can route or escalate"]
["N/A",1.15,null,"Work Order Management"]
[null,"1.15.A","Req","Calendar View"]
[null,"1.15.A.1","Req","Provide calendar view of work orders"]
[null,"1.15.A.1.a","Req"," User selectable layout (day, week, and month)"]
[null,"1.15.A.2","Req","Calendar integrates with common calendar applications, such as Microsoft Outlook and Google Calendar"]
[null,"1.15.B","Req","Allow for batch WO processing (e.g. completing, closing, etc.)"]
[null,"1.15.B.1","Req","Current, open work orders"]
[null,"1.15.B.2","Req"," Forecasted work orders"]
[null,"1.15.C","Req","Route notification of new SR or WO to predetermined recipients based on service type"]
[null,"1.15.D","Req","Ability to assign WO to Contractor"]
[null,"1.15.D.1","Req","Automatically notify Contractor of assigned WO"]
[null,"1.15.D.2","Req","Track correspondence with Contractor against respective WO"]
[null,"1.15.E","Req","Allow for inspection checklists"]
[null,"1.15.E.1","Req","Checklists can be saved and scheduled similar to (or as) PMs"]
[null,"1.15.E.2","Req","Checklists can be completed via mobile device"]
[null,"1.15.E.3","Req","Option to generate child work order(s) for failed task(s)/inspection"]
[null,"1.15.F","Req","Work Order Execution/Completion"]
[null,"1.15.F.1","Req","Ability to indicate task completion with checkbox for each step (if job plan associated)"]
[null,"1.15.F.2","Req","Indicate work that requires two personnel due to safety requirements"]
[null,"1.15.F.3","Req","Indicate existing known/potential hazards (e.g. asbestos) for location"]
[null,"1.15.F.4","Req","WO should have the below minimum fields:"]
[null,"1.15.F.4.a","Req","Associated location and/or equipment ID"]
[null,"1.15.F.4.b","Req","Placeholder for asset information to be printed on work order dependent upon:"]
[null,"1.15.F.4.b.1","Req","WO type"]
[null,"1.15.F.4.b.2","Req","Request/service type"]
[null,"1.15.F.4.b.3","Req","Asset classification"]
[null,"1.15.F.4.c","Req","Estimated labor hours"]
[null,"1.15.F.4.d","Req","Actual labor hours"]
[null,"1.15.F.4.e","Req","Work performed by (allow multiple entries)"]
[null,"1.15.F.4.f","Req","Incorporate standard labor rates based upon type/user to tabulate labor costs for WO"]
[null,"1.15.F.4.G.1","Req","Ability to log material/tools used and associated costs"]
[null,"1.15.F.4.g.1","Req","Should correspond to Parts Inventory (if material listed in Parts)"]
[null,"1.15.F.4.h","Req","Area to document notes and work accomplished"]
[null,"1.15.F.4.i","Req","Select failure code(s) from a customized dropdown list "]
[null,"1.15.F.4.j","Req","Placeholder to list required PPE, tools, and parts on WO"]
[null,"1.15.F.4.k","Req","Attach invoices to WOs"]
[null,"1.15.F.4.l","Req","Safety requirements, including Lockout/Tagout and MDS"]
[null,"1.15.F.5","Req","Ability to create additional WO"]
[null,"1.15.F.5.A","Req","New WO should be linked as a child to originating WO"]
[null,"1.15.F.6","Req","Assign/attribute labor & material costs to GL codes and/or departments"]
[null,"1.15.G","Req","Chargebacks"]
[null,"1.15.G.1","Req","Flag work orders to charge back to customer"]
[null,"1.15.G.2","Req","Capture and report chargeback costs"]
[null,"1.15.G.3","Req","Export chargeback costs in Excel format"]
["N/A",1.16,null,"Mobile Application (Functions performed via mobile device)"]
[null,"1.16.A","Req","Application or webpage configured for mobile devices"]
[null,"1.16.A.1","Req","Full functionality available on Android and iOS devices"]
[null,"1.16.B","Req","Submit SRs and WOs"]
[null,"1.16.C","Req","Assign & receive WOs"]
[null,"1.16.D","Req","Notify staff of WO assigned to them"]
[null,"1.16.D.1","Req","Receive push notifications"]
[null,"1.16.E","Req","Notify user/group of new SR (ability to enable/disable)"]
[null,"1.16.F","Req","Has on-board timer to capture work order “start” and “end” times"]
[null,"1.16.F.1","Req","Returns total time attributed to WO"]
[null,"1.16.F.2","Req","Timer can be paused or allow multiple entries"]
[null,"1.16.G","Req","Check parts availability in inventory"]
[null,"1.16.G.1","Req"," Reserve/request parts"]
[null,"1.16.H","Req","Assign parts to WO via barcode"]
[null,"1.16.I","Req","Synchronize data changes to and from database once network connection is restored"]
[null,"1.16.J","Req","Ability to incorporate images taken by device into WO, asset, etc."]
[null,"1.16.K","Req","Accommodate voice to text for notes and freeform fields"]
[null,"1.16.L","Req","Refresh/update automatically"]
[null,"1.16.M","Req","View associated (attached & linked) drawings, O&M manuals, etc."]
[null,"1.16.N","Req","Create follow-up work order"]
[null,"1.16.O","Req","Attach pictures"]
["N/A",1.17,null,"Capital Replacement Planning"]
[{"$nulls":3},"(Can be incorporated into asset record; if separate module, it should link to respective asset(s) )"]
[null,"1.17.A","Req","Minimum fields captured per asset/equipment:"]
[null,"1.17.A.1","Req","Date installed"]
[null,"1.17.A.2","Req","Life expectancy (in years)"]
[null,"1.17.A.3","Req","Installation or estimated replacement cost"]
[null,"1.17.B","Req","Report(s) that provide multi-year capital expenditure forecast (minimum 10 years)"]
[null,"1.17.B.1","Req","Ability to export data/report into Excel-compatible format"]
[null,"1.17.C","Pref","Calculate the Facility Condition Index (FCI) by building (preferred but not required)"]
["N/A",1.18,null,"Contract Management "]
[null,"1.18.A","Req","Attach and store contracts and related documents"]
[null,"1.18.B","Req","Maintain pertinent contract information, such as type, amount, limit, etc."]
[null,"1.18.C","Req","Link to contractor information, including contact, licenses, etc."]
[null,"1.18.D","Req","Report (notify of) expiring contract documents"]
["N/A",1.19,null,"Contractor/Vendor Management"]
[null,"1.19.A","Req","Associate service provided by contractor to service type"]
[null,"1.19.B","Req","Maintain contact information for multiple personnel at vendor/contractor company"]
[null,"1.19.C","Req","Attach contract (or link to contract)"]
[null,"1.19.D","Req","Track contract cost (associate WO costs against contractor)"]
[null,"1.19.E","Pref","Report contractor costs approaching contract limit"]
[null,"1.19.F","Req","Alert of contract renewal dates (could be handled via Contract Management functionality)"]
[null,"1.19.G","Pref","Associate assets with contract/contractor (preferred but not required)"]
[null,"1.19.H","Req","Track and report performance indicators (e.g. response time)"]
[null,"1.19.I","Req","Accommodate list of licenses, certifications, and insurance requirements for each contractor"]
[null,"1.19.I.1","Req","Alert/notify of license/certification/insurance expirations (preferred but not required)"]
[null,"1.19.J","Req","Send work order to contractor"]
[null,"1.19.J.1","Req","Contractor receives work order via e-mail"]
[null,"1.19.J.2","Req","Contractor can accept work order via e-mail"]
[null,"1.19.J.3","Req","Contractor can complete work order via e-mail"]
[null,"1.19.K","Req","Ability to rate contractor"]
["N/A",{"v":1.2,"d":"1.20"},null,"Customer Surveys"]
[null,"1.20.A","Req","Ability to create and deliver custom customer surveys"]
[null,"1.20.A.1","Req","Report results"]
[null,"1.20.A.2","Req","Create custom surveys"]
["N/A",1.21,null,"Inventory/Parts Management"]
[null,"1.21.A","Req","Maintain parts inventory"]
[null,"1.21.B","Req","Set minimum and maximum inventory levels"]
[null,"1.21.B.1","Req","Alert when minimum level is reached"]
[null,"1.21.C","Req","Incorporate bar codes"]
[null,"1.21.C.1","Req","2-D bar code"]
[null,"1.21.C.2","Req","3-D bar code"]
[null,"1.21.D","Req","Link to supplier contact information"]
[null,"1.21.E","Req","Auto-notify supplier when alert/order levels are reached (preferred but not required)"]
[null,"1.21.F","Req","Inventory-related reports available, such as turnover, inventory age, and product expiration"]
[null,"1.21.G","Req","Identify parts as critical spares"]
[null,"1.21.H","Req"," Integrate suppliers’ online portal, where applicable"]
[null,"1.21.I","Req"," Parts reserved when PMs are generated"]
[null,"1.21.J","Req","Notify if PM forecasted parts are not available"]
[null,"1.21.K","Req","Receive parts on mobile device via barcode"]
[null,"1.21.L","Req"," Report parts usage/throughput"]
[null,"1.21.M","Req"," Report shelf life and time on shelf by part"]
["N/A",1.22,null,"Purchasing "]
[null,"1.22.A","Req","Ability to submit purchase order (PO) request"]
[null,"1.22.B","Req","Route PO for approval"]
[null,"1.22.B.1","Req","Approvers and route dependent upon requested amount"]
[null,"1.22.C","Req","Associate WOs and invoices to PO"]
[null,"1.22.D","Req","Track charges against PO amount; report"]
[null,"1.22.E","Req","Notify approvers and requesters of status"]
["N/A",1.23,null,"Lease Management (Preferred but not required)"]
[null,"1.23.A","Pref","Identify space as leased or owned"]
[null,"1.23.B","Pref","Store or link to electronic copies of lease agreements"]
[null,"1.23.C","Pref","Maintain lease/building specific documents"]
[null,"1.23.D","Pref","House information, such as:"]
[null,"1.23.D.1","Pref","Site/tenant contact information"]
[null,"1.23.D.2","Pref","Lease type"]
[null,"1.23.D.3","Pref","Rental rates"]
[null,"1.23.E","Pref","Ability to auto-notify of lease renewals/expiration"]
["N/A",1.24,null,"Project Management"]
[null,"1.24.A","Req","Create and track projects"]
[null,"1.24.B","Req","Estimate project budget and duration"]
[null,"1.24.C","Req","Assign project/task OWNER(s)"]
[null,"1.24.D","Req","Generate task work orders associated with project"]
[null,"1.24.E","Req","Incorporate Gantt chart view"]
[null,"1.24.F","Req","Identify project task dependencies"]
[null,"1.24.G","Req","Create project templates with associated work orders and tasking"]
["N/A",1.25,null,"Document Management"]
[null,"1.25.A","Req","Store or link to electronic copies of drawings, operations & maintenance manuals, test reports, procedures, etc."]
[null,"1.25.B","Req","Associate files with asset"]
[null,"1.25.C","Pref","Identify document owner (preferred but not required)"]
[null,"1.25.D","Pref","Identify document version/revision (preferred but not required)"]
[null,"1.25.E","Pref","Track last review date (preferred but not required)"]
[null,"1.25.F","Pref","Provide reminder of scheduled review date (preferred but not required)"]
["N/A",1.26,null,"Utility Management (Preferred, But Not Required)"]
[null,"1.26.A","Pref","Ability to capture/upload utility data (Excel compatible format)"]
[null,"1.26.A.1","Pref","For electrical bills, document consumption (KWH) and demand (KW) separately, including on & off-peak rates/amounts"]
[null,"1.26.B","Pref","Delineate utility use and costs by: (Preferred, but not required)"]
[null,"1.26.B.1","Pref","Type (e.g. electric, gas, water, sewer, etc.)"]
[null,"1.26.B.2","Pref","Date Range"]
[null,"1.26.B.3","Pref","Actual versus Estimated"]
[null,"1.26.B.4","Pref","Capture utility credits (e.g. sewer)"]
["N/A","1.26.C","Pref","Report and graph use & costs (Preferred, but not required)"]
[null,"1.26.C.1","Pref","Ability to normalize with weather data"]
[null,"1.26.C.2","Pref","Ability to overlay and compare multiple years (normalized for weather)"]
[null,"1.26.C.3","Pref","Identify null or missing data"]
[null,1.27,null,"Space Planning (Preferred, But Not Required)"]
[null,"1.27.A","Pref","Store space/floor plans"]
[null,"1.27.B","Pref","Associate occupants with locations (seat assignments)"]
[null,"1.27.C","Pref","Ability to create various layout scenarios"]
[null,"1.27.D","Pref","Maintain historical copies past configurations"]
[null,1.28,null,"Move Management (Preferred, But Not Required)"]
[null,"1.28.A","Pref","Coordinate & manage move projects"]
[null,"1.28.B","Pref","Assign & track project tasks"]
[null,"1.28.C","Pref","Communicate tasks to assignees"]
[null,"1.28.D","Pref","View status via Gantt chart"]
[null,"1.28.E","Pref"," Track & report costs by project"]
[null,1.29,null,"Key Management (Preferred, but not required)"]
[null,"1.29.A","Pref","Maintain inventory of keys and associated locksets"]
[null,"1.29.B","Pref","Ability to track check-out/check-in of keys"]
[null,"1.29.C","Pref","Track and report to whom keys are assigned"]
[null,"1.29.D","Pref"," Maintain contact information associated with keys"]
[null,"1.29.E","Pref","  House information such as bitting, master pins, and bottom pins"]
[null,{"v":1.3,"d":"1.30"},null,"Training Management (Preferred, But Not Required) "]
[null,"1.30.A","Pref","Track training/education of staff "]
[null,"1.30.B","Pref","Identify skill sets/specialties of staff"]
[null,"1.30.C","Pref","Document training activities by staff member"]
[null,"1.30.D","Pref","Assign training requirements to staff"]
[null,"1.30.E","Pref","Track staff training progress/completion"]
[null,"1.30.F","Pref","Store or link to training documents and resources"]
[null,"1.30.G","Pref","Maintain list of staff licenses, certifications, credentials, etc."]
[null,"1.30.G.1","Pref","      Notify of expiration/renewal "]
[null,"1.30.H","Pref","Track continuing education units by staff member"]
[null,1.31,null,"Timesheets"]
[null,"1.31.A","Pref","Capture and report staff labor hours (preferred, but not required)"]
[null,"1.31.B","Pref","Export timesheet information in Excel format (preferred, but not required)"]
[null,1.32,null,"Inspections"]
[null,"1.32.A","Req","Generate inspections on a regular or as-needed basis"]
[null,"1.32.B","Req","Create follow-up work orders for failed inspections/tasks"]
[null,"1.32.B.1","Pref","      Option for one-to-one ratio (one work order per failed task/inspection) (preferred, but not required)"]
[null,"1.32.B.2","Pref","      Options for many-to-one ratio (one work order for all failed tasks/inspections) (preferred, but not required)"]
[null,"1.32.C","Req","Ability to assign ratings to inspections"]
[null,"1.32.C.1","Req","       Low rating trigger follow-up work order"]
["N/A",1.33,null,"User Interface"]
[null,"1.33.A","Req","User-friendly, intuitive interface for all user types"]
[null,"1.33.A.1","Req","Minimal training necessary for end users"]
[null,"1.33.B","Req","User configurable dashboard for at least higher permission group levels"]
[null,"1.33.C","Req","Numerous means to filter and sort for desired data through the various pages/forms"]
[null,"1.33.C.1","Req","        Query by various means, such as:"]
[null,"1.33.C.1.a","Req","              Asset ID"]
[null,"1.33.C.1.b","Req","              Location ID"]
[null,"1.33.C.1.c","Req","              Work Order Number"]
[null,"1.33.C.1.d","Req","              Assigned Staff"]
[null,"1.33.C.1.e","Req","              Work Order Status"]
[null,"1.33.C.1.f","Req","              Work Order Type"]
[null,"1.33.C.1.g","Req","              Completed Date Range"]
[null,"1.33.C.2","Req","Ability to print resulting data"]
[null,"1.33.C.3","Req","Ability to export resulting data into Excel-compatible format"]
[null,"1.33.C.4","Req","Ability to save query"]
["N/A",1.34,null,"Reports amd Dashboard"]
[null,"1.34.A","Req","Dynamic reporting/ad hoc report capabilities"]
[null,"1.34.A.1","Req","Save ad hoc reports for future use"]
[null,"1.34.A.2","Req","Save reports into group folders"]
[null,"1.34.A.2.a","Req"," Report folders accessible to specific users/groups "]
[null,"1.34.B","Req","OWNER configurable Dashboard"]
[null,"1.34.B.1","Req","User group specific dashboard"]
[null,"1.34.B.1.a","Pref","User specific dashboard (Preferred, but not required"]
[null,"1.34.B.2","Req","Color coded indicators and/or lists based upon set criteria"]
[null,"1.34.C","Req","Incorporates standard and configurable KPIs, including:"]
[null,"1.34.C.1","Req"," PM/CM ratio"]
[null,"1.34.C.2","Req","WO aging report"]
[null,"1.34.C.3","Req","Average time to complete WOs"]
[null,"1.34.C.4","Req","Average time to review & approve WOs"]
[null,"1.34.C.5","Req","Estimated labor hours versus actual hours"]
[null,"1.34.C.6","Req","Operating and maintenance costs per asset, location, and/or building"]
[null,"1.34.C.7","Req","Tenant/client satisfaction"]
[null,"1.34.C.8","Req","Quantity of open Wos"]
[null,"1.34.C.9","Req","Quantity of closed Wos"]
[null,"1.34.C.10","Req","Quantity of PM WOs and percent completion"]
[null,"1.34.C.10.a","Req","Also show by Priority"]
[null,"1.34.C.11","Req"," Number of Service Requests by:"]
[null,"1.34.C.11.a","Req","Problem/Failure Code"]
[null,"1.34.C.11.b","Req","Status"]
[null,"1.34.C.12.c","Req","High priority WOs"]
[null,"1.34.C.13","Req","Safety-related WOs "]
[null,"1.34.C.14","Req"," Backlog count"]
[null,"1.34.C.15","Req","WOs by Shop"]
[null,"1.34.C.16","Req","WOs by Zone"]
[null,"1.34.C.17","Req","WOs by Requester"]
[null,"1.34.C.18","Req","WOs by Department (Requested)"]
[null,"1.34.C.19","Req","WOs by Assigned Labor/Contractor"]
[null,"1.34.C.20","Req"," Past Due Wos"]
[null,"1.34.C.21","Req","Percent WOs Rework"]
[null,"1.34.D","Req","Build and schedule customized reports to auto-generate"]
[null,"1.34.D.1","Req","Automatically send to designee(s) via e-mail"]
[null,"1.34.E","Req"," Available reports include, at the minimum, the following:"]
[null,"1.34.E.1","Req","Cost reports by:"]
[null,"1.34.E.1.a","Req","Asset"]
[null,"1.34.E.1.b","Req","Location"]
[null,"1.34.E.1.c","Req","    Site/Chapter"]
[null,"1.34.E.2.a","Req"," Budget forecast reports"]
[null,"1.34.E.2.b","Req","Operations"]
[null,"1.34.E.3","Req","Capital"]
[null,"1.34.E","Req","Utility costs/use"]
[null,"1.34.F","Req","Able to query and report by site/chapter, region, and aggregate globally"]
[null,"1.34.G","Req","Print directly from report (no need to export)"]
[null,"1.34.H","Req","Report formats include the following:"]
[null,"1.34.H.1","Req"," Browser view"]
[null,"1.34.H.2","Req","PDF"]
[null,"1.34.H.3","Req","     Excel compatible (.csv, .xlsx) "]
["N/A",1.35,null,"Data Integration"]
[null,"1.35.A","Req","Ability to export specific data at a prescribed frequency in an Excel-compatible format"]
[null,"1.35.B","Req","Ability to import data to update specific table(s)"]
[null,"1.35.C","Req","Application Program Interface (API) available"]
[null,"1.35.C.1","Pref"," Preferable with applications, such as Banner Finance"]
["N/A",1.36,null,"User Administration"]
[null,"1.36.A","Req","Username and password protected"]
[null,"1.36.B","Req","Multiple permission groups with rights configurable OWNER (those with appropriate permissions)"]
[null,"1.36.C","Req","Create user groups based upon site/chapter and/or users"]
[null,"1.36.C.1","Req","Users can belong to multiple user groups"]
[null,"1.36.D","Req","Users can reset own password "]
[null,"1.36.E","Pref","Ability for user to request access (preferred, but not required)"]
[null,"1.36.F","Req","Users can update their contact information"]
[null,"1.36.G","Req","Ability to bulk upload users"]
[null,"1.36.H","Req","Able to deactivate users without losing their history"]
[null,"1.36.I","Req","Send notifications/e-mails to specified user(s)"]