FTA Logo
Skip Navigation
Site Map | Web Accessibility | FAQs | United We Ride | Contact Us
About FTA
News & Events
Planning & Environment
Grants & Financing
Legislation & Regulations
Research, Technical Assistance & Training
Civil Rights & Accessibility
Publications, Circulars/Guidance
Safety & Security
Transit Safety  TRACS (Advisory Committee)
Transit Safety  Rail Transit Safety Initiative
Transit Safety  Transit Safety
Transit Security  Transit Security
Emergency Management  Emergency Management
Training & Conferences  Training & Conferences
Drugs & Alcohol  Drug & Alcohol
Safety & Security Statistics  Safety & Security Statistics
Publications  Publications
Regional Offices Regional Map of United States
Click on the Region to view each page.
You are here: Home >> Safety & Security >> Transit Security >> Security Initiatives >> Security Manpower Planning Model
Home | Links | Site Map | Safety and Security Points of Contact | What's New | Feedback | Email Updates
Security  InitiativesSecurity  Initiatives
Transit WatchTransit Watch
Guidelines and  Best PracticesGuidelines and  Best Practices
Emergency  ManagementEmergency  Management
Training ToolsTraining Tools
Security  NewslettersSecurity  Newsletters
Weapons of  Mass DestructionWeapons of  Mass Destruction
Other Security  PublicationsOther Security  Publications
Security Manpower Planning Model

Security Manpower Planning ModelThe Security Manpower Planning Model is a flexible decision support tool created to enable transit security planners the ability to assess impacts of strategic decisions on resources and staffing. Based on the data inputted, the model identifies staffing levels and budgeting. The SMPM is can be used by any transit agency with existing or planned security resources, regardless of operating mode(s) or size. Further, the model can assist security planners in assessing impacts of various scenarios on resource and deployment strategies.

The SMPM is a macro-based application that runs within Microsoft Excel 2003.  The application may also run within other versions of Excel, with the following caveats:

  • Microsoft Excel 1997: SMPM will not work properly due to missing Visual Basic (VBA) features.
  • Microsoft Excel 2000: Users are not prevented from selecting non-data-entry cells, but cannot make entries in those cells.
  • Microsoft Excel 2007: Changes to program functionality causes minor formatting differences. A separate SMPM version for Excel 2007 will be produced.
  • Microsoft Excel for Mac 2004: SMPM should function correctly, but it has not been tested.
  • Microsoft Excel for Mac 2008: SMPM will likely not work due to the removal of VBA from this version of Excel for Mac.
  • Spreadsheet programs other than Microsoft Excel: Proper functioning of SMPM with "clone" programs such as OpenOffice has not been tested and is not guaranteed.

Subscribers to FTA's Office of Safety and Security "What's New" Email Updates will receive notification when new versions of the application are available.  Click here to subscribe.

Item Format
Security Manpower Planning Model (for Microsoft Excel 2003)
Version 1.0 2
May 2008

Security Manpower Planning Model Instruction Manual
May, 2008


Home | Related Links | FOIA | DOT.gov | WhiteHouse.gov | FirstGov.gov | Regulations.gov | FTA Web Policies | Privacy Policy
Adobe Acrobat Reader | MS Word Viewer | MS Excel Viewer | MS PowerPoint Viewer
Region I Region II Region III Region IV Region V Region VII Region VI Region VIII Region IX Region X Region X Region IX LMRO