{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Training Reference Sheet","DATA ENTRY SHEET - Cost Sheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Training Reference Sheet","index":0,"n_rows":19,"n_cols":22,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,21],[8,1,8,21],[1,20,1,21],[1,3,1,17]],"flags":["formulas_cached_only"]}
[null,"BASIC MASS TRANSIT SECURITY TRAINING PROGRAM"]
["Training Description","Focus","Standard","Categories of Employees to Receive",{"$nulls":16},"Federal Course Availability"]
[null,null,null,"Front-Line Employees","Station\nManagers","Administrative and Support Staff","Maintenance Workers",{"$nulls":4},"Maintenance Workers","Mid-Level Management","Mid-Level Management","Senior Management","Operations Control Center Staff","Security Guards","Law Enforcement Officers","Security Guards","Law Enforcement","Title","Duration"]
["Security Awareness","Enhance capability to identify, report, and react to suspicious activity and security incidents","2 Hours Annually (minimum)                              Recurring","X","X","X","X",{"$nulls":4},"X","X","X","X","X","X","X","X","X","System Security Awareness for Transportation Employees","4 Hours Classroom                               6 Hours Train the Trainer"]
["Behavior Recognition","Recognize behaviors associated with terrorists' reconnaissance and planning activities, including the conduct of surveillance. Applies lessons learned from the Israeli security meeting.","2 Hours Annually (minimum)                              Recurring","X","X",null,"X",{"$nulls":4},"X","X","X","X","X","X","X","X","X","Terrorist Awareness Recognition and Reaction (TARR)","4 Hours Classroom                              6 Hours Train the Trainer"]
["Immediate Emergency Response","Prepare passenger rail train operators to deal with explosive detonations, incendiaries, released chemical hazards, and similar threats in the confines of trains and system infrastructure.","4 Hours Annually (minimum)                              Recurring","X","X",{"$nulls":10},"X",null,"X",null,"X","Incident Management for Transit Employees and Passenger Management (courses in development by NTI)                           Transit agencies do conduct local programs on this subject","TBD"]
["National Incident Management System (NIMS) ","Ensure transit agency emergency preparedness and response personnel gain and retain the knowledge and skills necessary to operate under NIMS in accordance with the National Response Plan (NRP).","Train on NIMS once; reinforce in drills and exercises",null,"              X\n\n\n\n\n\n\n",{"$nulls":9},"X","X",null,"X",null,"X","National Incident Management System (NIMS) for Transit","1 to 3 Days"]
["Operations Control Center Readiness","Identify security vulnerabilities.                 Understand and exercise role of OCC personnel in preventing terrorist attacks.                   Distinguish characteristics of improvised explosive devices (IEDs) and weapons of mass destruction.                                                   Specify priorities during a terrorist attack and manage incident response.                                                 Apply transit agency's operational plans for  response to IED and WMD scenarios, directing and coordinating activities in the system.","Train for OCC readiness once; reinforce in drills and exercises",{"$nulls":12},"X",{"$nulls":4},"Rail Operations Control Center Response to WMD Incidents","6 Hours"]
[null,"MASS TRANSIT SECURITY FOLLOW-ON COURSES"]
["Training Description","Focus","Standard","Front-Line Employees","Station\nManagers","Administrative and Support Staff","Maintenance Workers",{"$nulls":6},"Mid-Level Management","Senior Management","Operations Control Center Staff",null,null,"Security Guards","Law Enforcement","Federal Course Title","Duration"]
["Management of Transit Emergencies I (4-day course)","Ensure employees throughout the transit agency understand individual roles in emergency response and the transit system's role in emergencies or disasters in the system and the broader community.",null,"X","x","X","X",{"$nulls":6},"X","X","X",null,null,"X","X","1) Effectively Managing Transit Emergencies                  ","1) 4 Days          "]
["Management of Transit Emergencies II (1-day course)","Ensure employees throughout the transit agency understand individual roles in emergency response and the transit system's role in emergencies or disasters in the system and the broader community.",null,"X","x","X","X",{"$nulls":6},"X","X","X",null,null,"X","X"," 2) Managing Terrorist Incidents in Rail Tunnels ","2) 6 Hours"]
["Coordinated Interagency Emergency Response","Advance interoperability of the transit agency with multiple responding entities in emergency response.",null,"X","x",null,"X",{"$nulls":11},"X","X","Connecting Communities Emergency Response and Preparedness Forum","2 Days"]
["Managing Counterrorism Programs","Enable transit agency management officials to develop and manage a counterrorism program in a transit system.",null,null,"\n    \n\n          X\n\n",{"$nulls":8},"X","X","X",{"$nulls":4},"Strategic Counterrorism for Transit Managers","2 Days"]
["Prevention and Mitigation - IEDS and WMD:  T4 3-day course","Enhance capabilities to identify threats from improvised explosive devices and weapons of mass destruction (chemical, biological, radiological, nuclear) to identify, report, and react to suspicious activity and security incidents",null,"X","X","X","X",{"$nulls":11},"X","X","1) Transit Terrorist Tools & Tactics  (T4)  ","1) T4 - 3 days                                                                                                                                                                                                                                 "]
["Prevention and Mitigation - IEDS and WMD:  CBRNE Incident Management 1-day course","Enhance capabilities to identify threats from improvised explosive devices and weapons of mass destruction (chemical, biological, radiological, nuclear) to identify, report, and react to suspicious activity and security incidents",null,"X","X","X","X",{"$nulls":11},"X","X","2) Transit Explosives (CBRNE) Incident Management Seminar","2) CBRNE Incident Management - 5 hours                        "]
["Transit Vehicle Hijacking Prevention and Response  ","Enable employees to develop and implement plans and procedures to respond to transit vehicle hijackings and workplace violence",null,"X","X",null,"X",{"$nulls":8},"X",null,null,"X","X","Threat Management and Emergency Response to Bus and Rail Hijackings","1 Day"]
["Integrated Anti-Terrorism Security Program","Enhance capabilities of transit agency security officials, law enforcement personnel, and others with interaction with passengers to detect, deter, and prevent acts of terrorism.",{"$nulls":11},"X","X",null,null,null,"X","X","Land Transportation Anti-Terrorism Training Program (FLETC)","5 Days"]
["Transit System Security Design","Expand integration of security considerations into designs of new transit systems and improvements of existing systems.   ",{"$nulls":11},"X","X",{"$nulls":5},"Transit System Security Design Review","3 days"]

{"sheet":"DATA ENTRY SHEET - Cost Sheet","index":1,"n_rows":30,"n_cols":32,"rows_kept":30,"cut":false,"hidden":false,"merged":[[9,21,10,21],[0,0,0,21],[2,25,3,25],[2,26,3,26],[2,27,3,27],[2,23,3,23],[2,24,3,24],[9,22,10,22],[25,0,26,19],[25,21,26,21],[2,21,3,21],[2,22,3,22],[2,3,2,17],[9,1,9,20],[20,0,20,21],[21,3,21,17],[21,21,22,21],[21,22,22,22],[21,27,22,27],[21,28,22,28],[21,31,22,31],[21,23,22,23],[21,24,22,24],[21,25,22,25],[21,26,22,26],[1,0,1,21],[9,27,10,27],[9,28,10,28],[9,31,10,31],[9,23,10,23],[9,24,10,24],[9,25,10,25],[9,26,10,26],[2,31,3,31],[2,28,3,28]],"flags":["formulas_cached_only"]}
["BASIC MASS TRANSIT SECURITY TRAINING PROGRAM"]
["Paperwork Burden Disclosure  Notice: Public reporting burden for this form is estimated to average .75 hour per response. The burden estimate includes the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and submitting the form. You are not required to respond to this collection of information unless it displays a valid OMB control number.  Send comments regarding the accuracy of the burden estimate and any suggestions for reducing the burden to: Information Collections Management, Department of Homeland Security, Federal Emergency Management Agency, 500 C Street, SW, Washington, DC 20472, Paperwork Reduction Project (1660-NEW) NOTE: Do not send your completed form to this address. OMB Control Number 1660-NEW, FEMA Form Number 089-27, Expiration Date: XX-XX-XXXX"]
["Training Description","Focus","Standard","Categories of Employees to Receive",{"$nulls":17},"TOTAL TRAINING COST","Total # of Employees","Hours of Training","Employee Cost","Class Size","# of Classes Needed","Trainer Cost per Class","Total Trainer Cost","State M&A","Transit System M&A","TOTAL TRAINING COST"]
[null,null,null,"Front-Line Employees","Station\nManagers","Administrative and Support Staff","Maintenance Workers",{"$nulls":4},"Maintenance Workers","Mid-Level Management","Mid-Level Management","Senior Management","Operations Control Center Staff","Security Guards","Law Enforcement Officers","Security Guards","Law Enforcement","Duration",{"$nulls":8},"3% of Total","2.5% of Total"]
["Security Awareness","Enhance capability to identify, report, and react to suspicious activity and security incidents","2 Hours Annually (minimum)                              Recurring",{"$nulls":17},"4 Hours Classroom                               6 Hours Train the Trainer",0,0,null,0,25,0,0,0,0,0,0]
["Behavior Recognition","Recognize behaviors associated with terrorists' reconnaissance and planning activities, including the conduct of surveillance. Applies lessons learned from the Israeli security meeting.","2 Hours Annually (minimum)                              Recurring",{"$nulls":17},"4 Hours Classroom                              6 Hours Train the Trainer",0,0,null,0,25,0,0,0,0,0,0]
["Immediate Emergency Response","Prepare passenger rail train operators to deal with explosive detonations, incendiaries, released chemical hazards, and similar threats in the confines of trains and system infrastructure.","4 Hours Annually (minimum)                              Recurring",{"$nulls":17},"TBD",0,0,null,0,25,0,0,0,0,0,0]
["National Incident Management System (NIMS) ","Ensure transit agency emergency preparedness and response personnel gain and retain the knowledge and skills necessary to operate under NIMS in accordance with the National Response Plan (NRP).","Train on NIMS once; reinforce in drills and exercises",{"$nulls":17},"1 to 3 Days",0,0,null,0,25,0,0,0,0,0,0]
["Operations Control Center Readiness","Identify security vulnerabilities. Understand and exercise role of OCC personnel in preventing terrorist attacks. Distinguish characteristics of improvised explosive devices (IEDs) and weapons of mass destruction. Specify priorities during a terrorist attack and manage incident response.                                                 Apply transit agency's operational plans for  response to IED and WMD scenarios, directing and coordinating activities in the system.","Train for OCC readiness once; reinforce in drills and exercises",{"$nulls":17},"6 Hours",0,0,null,0,25,0,0,0,0,0,0]
[null,"MASS TRANSIT SECURITY FOLLOW-ON COURSES",{"$nulls":19},"TOTAL TRAINING COST","Total # of Employees","Hours of Training","Employee Cost","Class Size","# of Classes Needed","Trainer Cost per Class","Total Trainer Cost","State M&A","Transit System M&A","TOTAL TRAINING COST"]
["Training Description","Focus","Standard","Front-Line Employees","Station\nManagers","Administrative and Support Staff","Maintenance Workers",{"$nulls":6},"Mid-Level Management","Senior Management","Operations Control Center Staff",null,null,"Security Guards","Law Enforcement","Duration",{"$nulls":8},"3% of Total","2.5% of Total"]
["Management of Transit Emergencies I (4-day course)","Ensure employees throughout the transit agency understand individual roles in emergency response and the transit system's role in emergencies or disasters in the system and the broader community.",{"$nulls":18},"1) 4 Days                                                                2) 6 Hours",0,0,null,0,25,0,0,0,0,0,0]
["Management of Transit Emergencies II (1-day course)","Ensure employees throughout the transit agency understand individual roles in emergency response and the transit system's role in emergencies or disasters in the system and the broader community.",{"$nulls":18},"1) 4 Days                                                                2) 6 Hours",0,0,null,0,25,0,0,0,0,0,0]
["Coordinated Interagency Emergency Response","Advance interoperability of the transit agency with multiple responding entities in emergency response.",{"$nulls":18},"2 Days",0,0,null,0,25,0,0,0,0,0,0]
["Managing Counterrorism Programs","Enable transit agency management officials to develop and manage a counterrorism program in a transit system.",{"$nulls":18},"2 Days",0,0,null,0,25,0,0,0,0,0,0]
["Prevention and Mitigation - IEDS and WMD:  T4 3-day course","Enhance capabilities to identify threats from improvised explosive devices and weapons of mass destruction (chemical, biological, radiological, nuclear) to identify, report, and react to suspicious activity and security incidents",{"$nulls":18},"1) T4 - 3 days                                                                                                                                                                                                               2) CBRNE Incident Management - 5 hours                        ",0,0,null,0,25,0,0,0,0,0,0]
["Prevention and Mitigation - IEDS and WMD:  CBRNE Incident Management 1-day course","Enhance capabilities to identify threats from improvised explosive devices and weapons of mass destruction (chemical, biological, radiological, nuclear) to identify, report, and react to suspicious activity and security incidents",{"$nulls":18},"1) T4 - 3 days                                                                                                                                                                                                               2) CBRNE Incident Management - 5 hours                        ",0,0,null,0,25,0,0,0,0,0,0]
["Transit Vehicle Hijacking Prevention and Response  ","Enable employees to develop and implement plans and procedures to respond to transit vehicle hijackings and workplace violence",{"$nulls":18},"1 Day",0,0,null,0,25,0,0,0,0,0,0]
["Integrated Anti-Terrorism Security Program","Enhance capabilities of transit agency security officials, law enforcement personnel, and others with interaction with passengers to detect, deter, and prevent acts of terrorism.",{"$nulls":18},"5 Days",0,0,null,0,25,0,0,0,0,0,0]
["Transit System Security Design","Expand integration of security considerations into designs of new transit systems and improvements of existing systems.   ",{"$nulls":18},"3 days",0,0,null,0,25,0,0,0,0,0,0]
["TRAIN-THE-TRAINER COURSES"]
["Training Description","Focus","Standard","Categories of Employees to Receive",{"$nulls":17},"TOTAL TRAINING COST","Total # of Employees","Hours of Training","Employee Cost","Class Size","# of Classes Needed","Trainer Cost per Class","Total Trainer Cost","State M&A","Transit System M&A","TOTAL TRAINING COST"]
[null,null,null,"Front-Line Employees","Station\nManagers","Administrative and Support Staff","Maintenance Workers",{"$nulls":4},"Maintenance Workers","Mid-Level Management","Mid-Level Management","Senior Management","Operations Control Center Staff","Security Guards","Law Enforcement Officers","Security Guards","Law Enforcement","Duration",{"$nulls":8},"3% of Total","2.5% of Total"]
["Security Awareness Train-the-Trainer","Enhance capability to identify, report, and react to suspicious activity and security incidents","2 Hours Annually (minimum)                              Recurring",{"$nulls":17},"4 Hours Classroom                               6 Hours Train the Trainer",0,0,null,0,25,0,0,0,0,0,0]
["Behavior Recognition Train-the-Trainer","Recognize behaviors associated with terrorists' reconnaissance and planning activities, including the conduct of surveillance. Applies lessons learned from the Israeli security meeting.","2 Hours Annually (minimum)                              Recurring",{"$nulls":17},"4 Hours Classroom                              6 Hours Train the Trainer",0,0,null,0,25,0,0,0,0,0,0]
["TOTAL TRAINING COSTS - ALL COURSES",{"$nulls":20},0]
[]
["FEMA Form 089-27"]
[]
[{"$nulls":22},0,36,0,{"$nulls":4},0]