EPLC COMMUNICATIONS MATRIX Column Instructions For Completing This Document Complete the Project Name, National Center, Project Manager Name, and Project Description fields For each identified communication, complete the following: ID: A unique ID number used to identify the communication within the communications matrix. Communications Vehicle: This column should be populated with a description of the type of communication that will be conducted Target Audience: This field should be populated with a description of the target audience for this communications vehicle. Description/Purpose: This field should be populated with a description of the purpose of the communications vehicle. Frequency: This field should be populated with the frequency of which the communication will be distributed. Owner: This field should be populated with the name of the owner of the communication. Distribution Vehicle: This field should be populated with the type of distribution vehicle that will be used to disseminate the communication. Internal/External: This field should indicate if the communication is for internal, external, or both internal and external distribution. Comments: This column should be populated with any additional comments.
A B C D E F G H I
Column Instructions For Changing the Contents of Drop-Down Menus Highlight the cell of which you wish to change the content of the drop down menu. E, F From the file menu click "Data" -> "Validation" and change the content of the source field
OR
Click "Format" -> "Sheet" -> "Unhide" -> "DropDown_Elements" Add/Change the appropriate values Click "Format" -> "Sheet" -> "Hide"
Column Instructions For Filtering Data Highlight the header of the cell you wish to filter data on Any From the file menu click "Date" -> "Filter" ->"Auto Filter" Then select your filter criteria from the drop down menu that appears on your header cell
EPLC COMMUNICATIONS MATRIX
Project Name: National Center: Project Manager Name: Project Description: Communicatons ID Vehicle 0 Weekly status report Target Audience Project Team Description/Purpose Communicate updated project status Frequency Weekly Owner John Doe Distribution Vehicle email Internal / External? Internal & External Comments
UP Template Version: 11/30/06
Page 2 of 2