{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Overview","Index","Scenario_Definitions","Scenario","Grading Sheet","User_Defined_Ranges","Scenario Example","Enable_Macros","Maintenance_Macros","Change_Record"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":128,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Overview","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[36,1,36,2],[4,1,4,2],[2,1,2,2],[28,1,28,2],[32,1,32,2],[34,1,34,2],[30,1,30,2],[26,1,26,2]]}
[1,"2012-01-26","Title Page that provides an overall explanation of the Tool and its use."]
[]
[null,"Click here to move to the Index Worksheet"]
[]
[null,"Mutualink Scenario Exercise Development (SED) Tool"]
[null,"Date","Version"]
[null,{"$f":"update_date","v":"2012-01-26"},{"$f":"version","v":"Ver 1.0"}]
[]
[null,"Purpose:","To provide a template for the creation of Mutualink IWS based exercises based on different incident scenarios."]
[]
[null,"Technique:","This tool is a Microsoft Excel™ Workbook compatible with Excel 2007 and 2010."]
[]
[null,null,"A number of pre-defined incident scenarios have been created that can be used as a basis for developing exercises that list the actions and interactions between IWS Operators and Field Resources.  A user can create additional scenarios to suit their needs."]
[]
[]
[null,"Goal:","Provide a useful template tool that can be easily configured by each end user community to develop consistent training exercises on the use of the Mutualink system in response to a wide variety of incidents."]
[]
[null,"Tool Usage:","Go to the Index Worksheet to view a listing of the various worksheets in the tool.  Click on the worksheet name of interest to move to the particular worksheet."]
[]
[null,null,"The incident events are entered on the Scenario worksheet.  A copy of this workbook should be saved for each defined scenario exercise."]
[]
[null,null,"All worksheets are protected using the standard Excel capability to prevent users from inadvertently overwriting the data.  Cells specifically set up for user data entry are not protected.  To modify the various lists the user can turn off protection using the routine shown on the Maintenance_Macros worksheet or use the standard Excel Unprotect method.  No passwords are necessary."]
[]
[null,"Use of Marcos:","A number of Excel Macros or Visual Basic (VBA) routines have been included in this tool.  They are used to manipulate the data and modify the tool if desired.  The tool can be used without these macros using standard Excel techniques but will be more cumbersome. To have macros available, Macro operation must be allowed (refer to the Enable_Macro Worksheet) and the file must be saved as a Macro Enabled Workbook."]
[]
[]
[null,"Background"]
[]
[null,"This tool is based on the Master Event Scenario List (MSEL) format used in the US Joint Chiefs' of Staff sponsored Collation Warrior Interoperability Demonstration (CWID) Program.  In this highly successful program, war fighters from difference branches of the military took on the roles of certain individuals and participated in a number of pre-defined scenarios.  The scenarios were defined with detailed scripts (MSELs) with each participant taking the actions as defined."]
[]
[null,"The CWID scenarios involved a number of different events including military operations, terrorist activities, and natural disasters.  Different role-players with different assignments took part in the exercises.  Most role players had no experience with the various systems being demonstrated except for some brief, on site, exposure prior to the actual ten day trial."]
[]
[null,"This tool provides a means of developing scenario scripts for participants to follow.  A number of pre-defined scenarios have been included in this tool that can be used as a basis for creating scripts.  The user, at their option, can define additional scenarios and develop scripts accordingly.  Similar to the CWID Program, the tool is pre-loaded with agency names, personnel by job function, and possible actions.  Users can add or delete any of these labels to reflect their own organizational names and structure.  The action items have been specifically chosen to reflect the most common actions associated with the use of the Mutualink Communications Collaboration System."]
[]
[null,"As developed by Mutualink for CWID, this tool also contains a Grading capability that can be used to determine the  effectiveness of the execution of the scenario.  The Grading Sheet is automatically loaded with the number of actions specified in the scenario.  After the scenario exercise is completed, the users can record any defects that may have occurred either due to system or user error."]

{"sheet":"Index","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
[1.1000000000000001,"2012-01-26","This worksheet, click on the worksheet title to move to that particular worksheet."]
[]
[]
[null,"Mutualink Scenario Event Development Tool (SED)"]
[]
[null,"Worksheet Title","Description","Date","Version"]
[null,"Overview","Title Page that provides an overall explanation of the Tool and its use.","2012-01-26",1]
[null,"Index","This worksheet, click on the worksheet title to move to that particular worksheet.","2012-01-26",1.1000000000000001]
[null,"Scenario_Definitions","This worksheet is used to define the scenarios and the associated scenario data.","2012-01-26",1]
[null,"Scenario","This worksheet is used to create the individual scenario exercises.","2012-01-26",1]
[null,"Grading Sheet","This worksheet is used to summarize the actions and tabulate any reported defects that occur during the exercise.","2012-01-26",1]
[null,"User_Defined_Ranges","This worksheet contains the defined ranges and provides the user with the ability to add/delete/modify the lists.","2012-01-26",1]
[null,"Scenario Example","This worksheet is an example of a Scenario Event Sequence Listing.","2012-01-26",1]
[null,"Enable_Macros","Instructions for enabling Visual Basic.","2012-01-26",1]
[null,"Maintenance_Macros","This worksheet contains a number of Macros (Visual Basic Routines) that automate certain capabilities of the Tool.  They are only available if the Tool has been saved with Macros (a standard Excel option and the running of macros has been enabled before the Tool was open.","2012-01-26",1]
[null,"Change_Record","This worksheet provides a high level summary of the changes in the ISC Tool made with each revision.","2012-01-26",1]

{"sheet":"Scenario_Definitions","index":2,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,1,2,7],[3,1,3,7]]}
[1,"2012-01-26","This worksheet is used to define the scenarios and the associated scenario data."]
[null,0,"add a name and data",null,null,null,null,{"$f":"LEN(F2)","v":0}]
[1,"Scenario Definitions"]
["Total","Sorted by Number"]
[{"$f":"ROWS(SD_data_range)","v":27},"No.","Scenario Name","Category","Primary Entity","Scenario Description",null,"Desc Length"]
[null,1,"PROTESTOR GATHERING","Private Enterprise","Bank","An unknown number of protesters have appeared in the lobby at the Common National Bank Corporate Offices.  Some are shouting threatening comments.  Bank security personnel are monitoring the activities on their video surveillance system.  The situation is very tense and seems to be quickly escalating.",null,{"$f":"LEN(F6)","v":302}]
[null,2,"BOMB THREAT","Public/ Private Agency","County EOC","The County EOC received an alert from DHS that a usually reliable informant has told them that some of the facilities within the county that store/use large volumes of chlorine will be bombed within the next 24 hours.  There are over 75 such facilities within the county. No other details are available at this time.",null,{"$f":"LEN(F7)","v":316}]
[null,3,"HURRICANE","Public/ Private Agency","County EOC","The National Weather Service has just issued a weather bulletin that has identified the path of Hurricane Nancy and there will be a direct hit on the county's shore line within four hours.  It is the peak of tourist season.",null,{"$f":"LEN(F8)","v":223}]
[null,4,"SNOW STORM","Public/ Private Agency","County EOC","A freak, early winter blizzard has hit the county.  It started on a Thursday morning during rush hour.  It is now 2PM and over 12 inches of snow have accumulated.  Traffic jams are everywhere, school buses are stuck, and the 911 Center is being overwhelmed with weather related calls.",null,{"$f":"LEN(F9)","v":284}]
[null,5,"PLANT EXPLOSION","Private Enterprise","Factory","An employee called 9-1-1 reporting an explosion just occurred at the Hendrix Chlorine plant.  The plant’s disaster team is responding.  Damage and injuries are unknown.  There is a fire but the source and intensity are also unknown.  9-1-1 just reported that the principle at the local elementary school just called saying they heard a loud noise and think it was an explosion.",null,{"$f":"LEN(F10)","v":377}]
[null,6,"CAR ACCIDENT","Public Safety","Fire","An off-duty Battalion Chief in his personal car without a radio has just come across a car in a ravine on the edge of town. Smoke is visible under the hood. He called the 9-1-1 center and is on scene with his Smartphone.",null,{"$f":"LEN(F11)","v":220}]
[null,7,"TORNADO","Public Safety","Fire","A tornado has touched down at multiple locations throughout the city and county.  Reports of injuries, power outages, trees down, and gas line breaks are flooding the 9-1-1 center.  Some hospitals are already running low on supplies.  Many ambulance companies report they are low on manpower.",null,{"$f":"LEN(F12)","v":292}]
[null,8,"TRAIN DERAILMENT","Public Safety","Fire","A commuter train derailment near City Center has occurred, many passenger cars were involved. A large fire of unknown origin has also been reported.  A number of victims report that their eyes burn. Many conflicting reports have been received at the 9-1-1 center.",null,{"$f":"LEN(F13)","v":263}]
[null,9,"MASS CASULTY EVENT","Public/ Private Agency","Hospital","Following the collapse of the spectator stands during a football game at Jefferson High, the two local hospitals are running out of critical ER supplies.  Ambulances are backed up at both facilities.  The 9-1-1 Center is flooded with calls which are totally inconsistent involving everything from a shooter to a bomb to a \"simple\" structural failure.",null,{"$f":"LEN(F14)","v":350}]
[null,10,"PATIENT TRANSFER","Public/ Private Agency","Hospital","A patient has just been brought into the Farmland ER with extensive burns on most of his body.  You know your small regional hospital is not equipped to handle the situation.  You need to transport the patient to Johnson Regional Hospital that has an extensive burn unit.  There is a blinding snow storm in progress with heavy winds making air transport impossible.",null,{"$f":"LEN(F15)","v":365}]
[null,11,"POWER OUTAGE","Public/ Private Agency","Hospital","A hospital has had a major power outage; the cause and projected recovery time are not known.  The ER has back up power but is overwhelmed at the present time.  The extent of the power outage is unknown.  Emergency generators have become problematic.",null,{"$f":"LEN(F16)","v":250}]
[null,12,"SHOTS FIRED","Public/ Private Agency","Hospital","Multiple E911 calls as well as an ER nurse have reported that multiple shots have been heard directly outside the ER entrance as Mercy Hospital.  The ER nurse also said they are expecting multiple ambulances to arrive shortly due to a major car accident on the interstate.",null,{"$f":"LEN(F17)","v":272}]
[null,13,"CAR THEFT","Private Enterprise","Mall Security","The three Johnson Corporation owned shopping malls in the area all have video surveillance systems.  The after-hours remote monitoring center has just seen a woman knocked to the ground and someone attempting to start her car at the Town Crossing Mall.",null,{"$f":"LEN(F18)","v":252}]
[null,14,"SHOPPING MALL ACCIDENT","Private Enterprise","Mall Security","A customer has fallen over the balcony onto the lower level at the Crown Mall.  They appear to be badly hurt. The mall security guard is with the victim.  Someone said they saw the victim get pushed off the balcony but that has not been confirmed.  The crowd seems to be panicking.",null,{"$f":"LEN(F19)","v":281}]
[null,15,"SUSPICIOUS PACKAGES","Private Enterprise","Mall Security","A patrolling security guard at the Benton Mall has just spotted a suspicious package near the Food Commons Area and has called the Security Office. Almost simultaneously, the security video system at the Pratt Mall across town captured a man with a hoody dropping a backpack near the food court and running out the mall exit.",null,{"$f":"LEN(F20)","v":325}]
[null,16,"BOATING MISHAP","Public Safety","Police","A 9-1-1 operator has just received a distress call from a pleasure boat on Central River.  Contact was lost before the location and severity of the emergency was given.",null,{"$f":"LEN(F21)","v":168}]
[null,17,"CAR CHASE","Public Safety","Police","While monitoring South Suburb’s police dispatch channel Johnson county Dispatch heard that a high speed chase is in progress and may be headed toward the county on Route 9.",null,{"$f":"LEN(F22)","v":172}]
[null,18,"HAZMAT ACCIDENT","Public Safety","Police","A police officer has just arrived at the scene of a tow truck, single car traffic accident and has observed some ruptured 55 gallon chemical drums in one of the trucks are emitting a strange odor.  Multiple injuries have occurred.  The accident is two hundred yards from an elementary school that is in session and near the Felix strip mall.",null,{"$f":"LEN(F23)","v":341}]
[null,19,"INCOMPATIBLE RADIO SYSTEMS","Public Safety","Police","The city’s new 700MHz digital radio system has significantly helped the department.  However, the neighboring communities can no longer communicate with the city since they have not participated in the new system.  A car chase through the city and surrounding communities is in progress. Shots may have been fired at the police car involved in the chase.",null,{"$f":"LEN(F24)","v":354}]
[null,20,"PERSONAL THREATS","Public Safety","Police","The mayor and members of the city council have received threats regarding the opening of the new industrial park with on-site ceremonies scheduled for tomorrow morning.",null,{"$f":"LEN(F25)","v":168}]
[null,21,"RADIO SYSTEM FAILURE","Public Safety","Police","The city’s newly installed public safety trunked radio system has just gone down.  All sites are impacted. It’s a Friday night with a much anticipated, high rivalry high school football game in progress.",null,{"$f":"LEN(F26)","v":203}]
[null,22,"SCHOOL INTRUDER","Public/ Private Agency","School","A young intruder has entered the school and is acting strangely.  The unarmed, lone school security guard has locked down the school and school admin secretary can see the intruder clearly on the video surveillance system on the school's IWS.",null,{"$f":"LEN(F27)","v":242}]
[null,23,"SCHOOL VANDELISM","Public/ Private Agency","School","Jackson High School has been the target of vandalism twice in the past month.  Although the perpetrators have been caught on tape, no identification has been made and the incidents were not discovered until Monday morning.  The janitor found a suspicious box in the boiler room as did the principle in the cafeteria.",null,{"$f":"LEN(F28)","v":316}]
[null,24,"STUDENT IN TROUBLE","Public/ Private Agency","School","Someone has pushed the emergency call button near University Hall but is not in view of the camera.  Campus Police have responded but there was a brief transmission from the officer's radio but now he cannot be raised.  A number of violent crimes including a rape have occurred in this area.",null,{"$f":"LEN(F29)","v":291}]
[null,25,"MEDICAL EMERGENCY","Public/ Private Agency","Stadium","A stadium soda/beer vendor repotted to Stadium Security that a fan in the upper level just collapsed.  Someone said it looked like a heart attack.  Vehicle and pedestrian traffic has clogged up all of the streets around the stadium as is typical on game day.",null,{"$f":"LEN(F30)","v":258}]
[null,26,"MTA EMERGENCY","Public/ Private Agency","Transit Authority","A security guard on the Number 9, light rail metro liner, using his radio called Transit Dispatch indicating he had a situation with an unruly passenger who said he had a gun.  The guard's transmission was cut off and Transit Operations just reported the train had made an unscheduled stop in the Jones River Tunnel.",null,{"$f":"LEN(F31)","v":316}]
[null,27,"TERRORIST EVENT","Private Enterprise","Utility","Ajax Light and Power just reported that they had a major outage at one of their transmission substations and an employee spotted someone in the area running with a rifle.  There is thick black smoke coming from one or more of the substation transformers.",null,{"$f":"LEN(F32)","v":254}]
[]
[]
[]
[null,{"$f":"COUNTA(SD_c_scenario_name)","v":27},"= Scenarios Listed"]
[null,{"$f":"SUBTOTAL(103,SD_c_scenario_name)","v":27},"= Scenarios Shown"]

{"sheet":"Scenario","index":3,"n_rows":81,"n_cols":18,"rows_kept":81,"cut":false,"hidden":false,"merged":[[10,15,11,19],[9,15,9,19],[3,5,7,7],[9,0,9,2],[10,0,10,2],[11,0,11,2],[6,0,6,2],[7,0,7,2],[3,3,4,3],[3,0,4,2],[9,5,9,6],[10,5,10,6],[11,5,11,6],[8,12,10,13]]}
[1,"2012-01-26","This worksheet is used to create the individual scenario exercises."]
[0,null,null,null,null,"add data",null,null,null,{"$f":"IF(LEN(F2)>SC_activity_len_limit,\"Activity Desc. Is \" & LEN(F2) & \" characters. Limit it to \" & SC_activity_len_limit,LEN(F2))","v":8},1000]
[]
["Scenario Type:  ",null,null,{"$f":"selected_event","v":"PROTESTOR GATHERING"},null,{"$f":"VLOOKUP(D4,SD_lookup_table,4,FALSE)","v":"An unknown number of protesters have appeared in the lobby at the Common National Bank Corporate Offices.  Some are shouting threatening comments.  Bank security personnel are monitoring the activities on their video surveillance system.  The situation is very tense and seems to be quickly escalating."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select a Scenario from the list box table."]
[null,null,null,"PROTESTOR GATHERING",null,null,null,null,null,null,null,null,null,"PROTESTOR GATHERING"]
["Category:  ",null,null,{"$f":"VLOOKUP(selected_event_label,SD_lookup_table,2,FALSE)","v":"Private Enterprise"}]
["Primary Entity:  ",null,null,{"$f":"VLOOKUP(selected_event_label,SD_lookup_table,3,FALSE)","v":"Bank"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Click to go to Bottom of the List"]
["Scenario Name:  ",null,null,"Bank Protestors",null,"Tom Berger",null,"Created By",null,null,null,null,null,null,null,"Activities are"]
["Created Date:  ",null,null,"2012-01-05",null,"Mutualink, Inc.",null,"Organization",null,null,null,null,null,null,null,"Sorted by Number"]
["Revised Date:  ",null,null,"2012-01-10",null,"tberger@mutualink.net,  603-661-5682",null,"Contact Info"]
[]
[null,null,"Summary:  ","This scenario exercise includes three IWSs (2 @ Commons Bank facilities, 1 @ Local Police), a video feed from the bank, and two radio channels (1 for bank security and 1 for the police).  A cell phone is also brought into the incident as is a Public Address system and a file is transferred.",null,null,null,null,null,{"$f":"LEN(SC_summary)","v":291}]
[{"$f":"MAX(SC_c_number)","v":59},null,null,null,null,null,null,null,null,350]
["No.","Seq. No.","Entity & IWS","Person","H","Activity/Event","Action","File name, number, etc.",null,"Activity Desc Length","Highlight Column Color"]
[1,1,"Common Bk Corp Lobby","Security Guard",null,"The Main Lobby Security Guard at Common National Bank's Corporate Office creates an incident with the off-site Corporate Security Office to inform them about the protesters' presence.","I: Create an incident","Session named \"Protestors\"",null,{"$f":"IF(LEN(F17)>SC_activity_len_limit,\"Activity Desc. Is \" & LEN(F17) & \" characters. Limit it to \" & SC_activity_len_limit,LEN(F17))","v":183},1000]
[2,2,"Common Bk Corp Security Office","Shift Supervisor",null,"Common Bank Corporate Security Shift Supervisor responds to the session request and, via IWS Intercom requests info on the situation.","I: Accept an incident request","Session named \"Protestors\"",null,133,1000]
[3,3,"Common Bk Corp Lobby","Security Guard",null,"In response to Shift Supervisor's request, the Security Guard brings the local lobby video feed into the incident to allow the Shift Supervisor to view real time events as he describes them.","V: Bring a camera/video  into an incident",null,null,190,1000]
[4,4,"Common Bk Corp Security Office","Shift Supervisor",null,"Opens video icon to view real time video feed from the lobby on his IWS.","V: Open video feed shared by others",null,null,72,1000]
[5,5,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor brings Common Bank Security radio channel into the incident and asks all security guards at the Corporate Offices to converge on the Main Lobby area but not to enter the lobby or confront the protestors.  All personnel to maintain a low key presence.  Supervisor asks all guards to acknowledge transmission receipt.","R: Bring a radio into an incident","Common Bank radio channel SEC 1",null,332,1000]
[6,6,"Common Bk Corp Security Office","Security Guard",null,"Multiple security guards respond to dispatch request.","I: Field call into an incident",null,null,53,1000]
[7,7,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor creates an incident named \"Bank Help\" and invites City Police to join.","I: Create an incident","Session named \"Bank Help\"",null,87,1000]
[8,8,"City Police Dispatch #1","Dispatcher",null,"City Police Dispatcher via City Dispatch #1 IWS accepts the invitation and discusses the situation with Shift Supervisor and asks to be brought into the active incident session.","I: Accept an incident request","Session named \"Bank Help\"",null,177,1000]
[9,9,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor invites City Police to join the existing session named Protestors as requested.","I: Invite others to an incident","Session named \"Protestors\"",null,96,1000]
[10,10,"City Police Dispatch #1","Dispatcher",null,"Police Dispatch accepts invitation request and joins the Protestor incident and announces his presence via IWS Intercom.","I: Accept an incident request","Session named \"Protestors\"",null,120,1000]
[11,11,"City Police Dispatch #1","Dispatcher",null,"Police Dispatch terminates the Bank Help incident.","I: Terminate an incident","Session named \"Bank Help\"",null,50,1000]
[12,12,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor terminates the Bank Help incident.","I: Terminate an incident","Session named \"Bank Help\"",null,51,1000]
[13,13,"City Police Dispatch #1","Dispatcher",null,"Opens video icon to view real time video feed from the lobby.","V: Open video feed shared by others",null,null,61,1000]
[14,14,"City Police Dispatch #1","Dispatcher",null,"Via the IWS Intercom function, the Police Dispatcher asks the Lobby Security Guard for details on the protestors including their numbers, any visible weapons or backpacks, and their overall mode.","I: Contact another IWS by intercom",null,null,195,1000]
[15,15,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard responds to the Police Dispatcher's questions.","I: Contact another IWS by intercom",null,null,67,1000]
[16,16,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher suggests , via IWS Intercom, to Common Bank Shift Supervisor that they alert appropriate bank official and bring them into the incident.","I: Contact another IWS by intercom",null,null,154,1000]
[17,17,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor agrees to contact VP of Security and asks Police, Lobby Guard, and Security Officers to standby via TX function on IWS.","R: Transmit/Receive via radio","Common Bank radio channel SEC 1",null,136,1000]
[18,18,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor creates a new incident to contact Security VP.","I: Create an incident","Session named \"Emergency\"",null,63,1000]
[19,19,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor brings Telco resource into the incident and dials Security VP's cell phone number as listed in the IWS phone directory.","T: Dial out to a phone","Phone number is: 555-123-4567",null,136,1000]
[20,20,"Common Bk Corp Security Office","VP of Security",null,"Security VP answers call, Shift Supervisor updates Security VP, Security VP asks to be brought into the session.","T: Answer an incoming telco call",null,null,112,1000]
[21,21,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor announces to all session participants that Security VP will be joining the session shortly and asks everyone to standby.","R: Transmit/Receive via radio",null,null,137,1000]
[22,22,"Common Bk Corp Lobby","Security Guard",null,"Security Guard sends a Chat message to the Shift Supervisor asking him to mention to the Security VP that he should mute his cell phone when not talking to avoid the broadcast of background noise.","C: Create and send a chat/text  message",null,null,196,1000]
[23,23,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor receives the Chat message and responds to the Security Guard that he will ask the Security VP to mute his cell phone.","C: Receive a chat/text message",null,null,134,1000]
[24,24,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor tells the Security VP that he will be brought into the incident and asks the VP to keep his cell phone on mute unless he wants to talk to avoid the broadcast of background noise.  Security VP is then brought into the session by moving Telco resource into the Protestor incident.","T: Move a telco connection between incidents","Session named \"Protestors\"",null,295,1000]
[25,25,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor terminates the \"Emergency\" session.","I: Terminate an incident","Session named \"Emergency\"",null,52,1000]
[26,26,"Common Bk Corp Security Office","Shift Supervisor",null,"Via the IWS Intercom, Shift Supervisor announces that the Security VP has joined the session.","I: Contact another IWS by intercom",null,null,93,1000]
[27,27,"City Police Dispatch #1","Dispatcher",null,"Via the IWS Intercom, the Police Dispatcher asks if a floor plan of the Bank Lobby is available that shows all entrances and exits.","I: Contact another IWS by intercom",null,null,131,1000]
[28,28,"Common Bk Corp Lobby","Security Guard",null,"Via the IWS Intercom, the Lobby Security Guard responds that he has a floor plan on his IWS and will share it.","I: Contact another IWS by intercom",null,null,110,1000]
[29,29,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard locates the floor plan file on his IWS and sends it to all IWS participants","F: Send a file","Filename = Common Bank Lobby Floor Plan",null,96,1000]
[30,30,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher receives the file.","F: Receive a file","Filename = Common Bank Lobby Floor Plan",null,36,1000]
[31,31,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher views the file.","F: View a file",null,null,33,1000]
[32,32,"Common Bk Corp Security Office","Shift Supervisor",null,"Bank Security Supervisor receives the file.","F: Receive a file",null,null,43,1000]
[33,33,"Common Bk Corp Security Office","Shift Supervisor",null,"Bank Security Supervisor opens the file.","F: View a file",null,null,{"$f":"IF(LEN(F49)>SC_activity_len_limit,\"Activity Desc. Is \" & LEN(F49) & \" characters. Limit it to \" & SC_activity_len_limit,LEN(F49))","v":40},1000]
[34,34,"Common Bk Corp Security Office","VP of Security",null,"Via IWS Intercom, Security VP asks Lobby Security Guard for an update.  Requests that all personnel hear the update.","I: Contact another IWS by intercom",null,null,116,1000]
[35,35,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard, through the IWS Tx function, provides an update to all session participants indicating that the Protestors have settled down and are no longer very vocal and the situation has seemed to stabilize.","R: Transmit/Receive via radio",null,null,218,1000]
[36,36,"Common Bk Corp Security Office","VP of Security",null,"Security VP suggests to Police Dispatch that the police announce to the protestors via the Bank Lobby Public Address system that the protestors are breaking the law and asks them to move outside of the Lobby or totally disburse.","I: Contact another IWS by intercom",null,null,228,1000]
[37,37,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher agrees to make the announcement. But as a precautionary matter tells participants that he will contact Police District 9 via radio and have  officers standing by in case of trouble.","I: Contact another IWS by intercom",null,null,199,1000]
[38,38,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher creates a new session named D 9 Radio Alert.","I: Create an incident","Session named D9 Radio Alert",null,62,1000]
[39,39,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher brings D9 Radio Resource into the incident and briefs District 9 Officers on the situation and asks them to standby.","R: Move a radio resource between incidents","D9 Radio Resource",null,134,1000]
[40,40,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher announces to session Protestor participants that District 9 Officers have been briefed and will be brought into the incident through the IWS's Intercom function.","I: Contact another IWS by intercom",null,null,179,1000]
[41,41,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher moves D9 Radio Resource from D9 Radio Alert incident to Protestor incident and announces their presence via the IWS Transmit function.","R: Move a radio resource between incidents",null,null,152,1000]
[42,42,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher terminates the D9 Radio Alert incident.","I: Terminate an incident","Session named D9 Radio Alert",null,57,1000]
[43,43,"Common Bk Corp Lobby","Security Guard",null,"At the request of Common Bank Security Shift Supervisor, the Common Bank Lobby Security Guard brings the Lobby Public Address Resource into the Protestor incident.","P:  Bring Public Address Resource into incident",null,null,163,1000]
[44,44,"Common Bk Corp Lobby","Security Guard",null,"Security Guard transmits through the IWS Intercom function that the Public Address Resource is in the incident and ready for the Police Broadcast message.","I: Contact another IWS by intercom",null,null,154,1000]
[45,45,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher broadcasts warning to all participants and audio is transmitted over the Bank Lobby P/A system.","P: Transit audio via Public Address",null,null,113,1000]
[46,46,"Common Bk Corp Lobby","Security Guard",null,"Security Guard removes the P/A Resources from the incident.","P:  Remove P/A Resource from incident",null,null,59,1000]
[47,47,"Common Bk Corp Lobby","Security Guard",null,"Security Guard reports that protestors are reluctantly leaving.  Other IWS operators watch lobby video.","I: Transmit via IWS",null,null,103,1000]
[48,48,"Common Bk Corp Lobby","Security Guard",null,"Security Guard through the IWS Tx function, informs all participants that the Lobby P/A is no longer in the incident.","I: Transmit via IWS",null,null,117,1000]
[49,49,"Common Bk Corp Security Office","VP of Security",null,"Bank Security VP via his cell phone that is in the incident asks all participants to stand by and remain in the session for a few minutes while all IWSs watch video.","I: Transmit via IWS",null,null,165,1000]
[50,50,"Common Bk Corp Security Office","Shift Supervisor",null,"After five minutes, the Bank Security Supervisor reports that through the IWS video feed showing the lobby that all protestors have vacated the lobby and suggests to Security VP that everyone stand-down.","I: Transmit via IWS",null,null,203,1000]
[51,51,"Common Bk Corp Security Office","VP of Security",null,"Security VP agrees and asks everyone to terminate the incident after thanking everyone for their participation.","I: Transmit via IWS",null,null,111,1000]
[52,52,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher acknowledges termination request.","I: Transmit via IWS",null,null,51,1000]
[53,53,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher removes Police Radio Resource from the incident.","R: Terminate a radio  connection",null,null,66,1000]
[54,54,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher terminates the incident.","I: Terminate an incident",null,null,42,1000]
[55,55,"Common Bk Corp Security Office","VP of Security",null,"Security VP hangs up his cell phone.","T: Terminate a telco call",null,null,36,1000]
[56,56,"Common Bk Corp Security Office","Shift Supervisor",null,"Bank Security Supervisor terminates the incident.","I: Terminate an incident",null,null,49,1000]
[57,57,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard removes video feed from the incident.","V: Terminate camera/video feed",null,null,58,1000]
[58,58,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard removes Security Radio Resource from the incident.","R: Move a radio resource between incidents",null,null,71,1000]
[59,59,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard terminates the incident.","I: Terminate an incident",null,null,45,1000]
[]
[null,null,null,"Click to go to listing top",null,null,null,null,null,{"$f":"MAX(SC_c_max_length)","v":332}]
[]
[]
[{"$f":"COUNTA(SC_c_agency)","v":59},null,"= Events Listed"]
[{"$f":"SUBTOTAL(103,SC_c_agency)","v":59},null,"= Events Shown"]

{"sheet":"Grading Sheet","index":4,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[12,7,12,11],[7,1,7,3],[8,1,8,3],[9,1,9,3],[1,0,1,1],[2,1,2,3],[3,1,3,3],[4,1,4,3],[6,1,6,3]]}
[1,"2012-01-26","This worksheet is used to summarize the actions and tabulate any reported defects that occur during the exercise."]
["Scenario Grade Sheet"]
[{"$f":"Scenario!A4","v":"Scenario Type:  "},{"$f":"Scenario!D4","v":"PROTESTOR GATHERING"}]
[{"$f":"Scenario!A7","v":"Category:  "},{"$f":"Scenario!D7","v":"Private Enterprise"}]
[{"$f":"Scenario!A8","v":"Primary Entity:  "},{"$f":"Scenario!D8","v":"Bank"}]
[]
[{"$f":"Scenario!A10","v":"Scenario Name:  "},{"$f":"Scenario!D10","v":"Bank Protestors"}]
[{"$f":"Scenario!A11","v":"Created Date:  "},{"$f":"Scenario!D11","v":"2012-01-05"}]
[{"$f":"Scenario!A12","v":"Revised Date:  "},{"$f":"IF(Scenario!D12<1,\"\",Scenario!D12)","v":"2012-01-10"}]
[{"$f":"Scenario!H10&\":  \"","v":"Created By:  "},{"$f":"Scenario!F10","v":"Tom Berger"}]
[]
[null,{"$f":"COUNTIF(SC_c_action,A12)","v":0},0,{"$f":"IF(B12>0,(B12-C12)/B12,\"-\")","v":"-"},null,null,null,{"$f":"SUM(IF(first_25_actions<>first_25_past,1,0))","v":0},"Zero means first actions equals last 25 actions since the Update Table routine was run"]
["Activity","To Be Performed","Defects Reported","Success Rate",null,null,null,{"$f":"IF(H12=0,\"\", \"Click on Update Table\")","v":""}]
[]
["Total: All Activities",{"$f":"SUM(B16:B65)","v":59},{"$f":"SUM(C16:C65)","v":0},{"$f":"IF(B15>0,(B15-C15)/B15,\"-\")","v":1}]
["C: Create and send a chat/text  message",{"$f":"COUNTIF(SC_c_action,A16)","v":1},0,{"$f":"IF(B16>0,(B16-C16)/B16,\"-\")","v":1},null,null,null,1]
["C: Receive a chat/text message",1,0,1,null,null,null,1]
["F: Receive a file",2,0,1,null,null,null,2]
["F: Save a file",0,0,"-",null,null,null,0]
["F: Send a file",1,0,1,null,null,null,1]
["F: View a file",2,0,1,null,null,null,2]
["I: Accept an incident request",3,0,1,null,null,null,3]
["I: Contact another IWS by intercom",11,0,1,null,null,null,11]
["I: Create an incident",4,0,1,null,null,null,4]
["I: Deny an incident invitation",0,0,"-",null,null,null,0]
["I: Field call into an incident",1,0,1,null,null,null,1]
["I: Invite others to an incident",1,0,1,null,null,null,1]
["I: Terminate an incident",7,0,1,null,null,null,7]
["I: Transmit via IWS",6,0,1,null,null,null,6]
["P:  Bring Public Address Resource into incident",1,0,1,null,null,null,1]
["P:  Remove P/A Resource from incident",1,0,1,null,null,null,1]
["P: Transit audio via Public Address",1,0,1,null,null,null,1]
["R: Bring a radio into an incident",1,0,1,null,null,null,1]
["R: Move a radio resource between incidents",3,0,1,null,null,null,3]
["R: Terminate a radio  connection",1,0,1,null,null,null,1]
["R: Transmit/Receive via radio",3,0,1,null,null,null,3]
["T: Answer an incoming telco call",1,0,1,null,null,null,1]
["T: Dial out to a phone",1,0,1,null,null,null,1]
["T: Move a telco connection between incidents",1,0,1,null,null,null,1]
["T: Terminate a telco call",1,0,1,null,null,null,1]
["V: Bring a camera/video  into an incident",1,0,1]
["V: Move a video source between incidents",0,0,"-"]
["V: Open video feed shared by others",2,0,1]
["V: Terminate camera/video feed",1,0,1]
["Z:  Response/Acknowledgement",0,0,"-"]
[null,null,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]
[null,null,0,0]

{"sheet":"User_Defined_Ranges","index":5,"n_rows":95,"n_cols":3,"rows_kept":95,"cut":false,"hidden":false,"merged":[[74,1,74,3],[3,1,3,3]]}
[1,"2012-01-26","This worksheet contains the defined ranges and provides the user with the ability to add/delete/modify the lists."]
[]
[]
[null,"Lists Used on Scenario  Worksheet"]
["Category Count",null,"Used in Current Scenario"]
[{"$f":"ROWS(l_actions)","v":30},"l_actions",{"$f":"COUNTIF(SC_c_action,B6)","v":0}]
[null,"C: Create and send a chat/text  message",1]
[null,"C: Receive a chat/text message",1]
[null,"F: Receive a file",2]
[null,"F: Save a file",0]
[null,"F: Send a file",1]
[null,"F: View a file",2]
[null,"I: Accept an incident request",3]
[null,"I: Contact another IWS by intercom",11]
[null,"I: Create an incident",4]
[null,"I: Deny an incident invitation",0]
[null,"I: Field call into an incident",1]
[null,"I: Invite others to an incident",1]
[null,"I: Terminate an incident",7]
[null,"I: Transmit via IWS",6]
[null,"P:  Bring Public Address Resource into incident",1]
[null,"P:  Remove P/A Resource from incident",1]
[null,"P: Transit audio via Public Address",1]
[null,"R: Bring a radio into an incident",1]
[null,"R: Move a radio resource between incidents",3]
[null,"R: Terminate a radio  connection",1]
[null,"R: Transmit/Receive via radio",3]
[null,"T: Answer an incoming telco call",1]
[null,"T: Dial out to a phone",1]
[null,"T: Move a telco connection between incidents",1]
[null,"T: Terminate a telco call",1]
[null,"V: Bring a camera/video  into an incident",1]
[null,"V: Move a video source between incidents",0]
[null,"V: Open video feed shared by others",2]
[null,"V: Terminate camera/video feed",1]
[null,"Z:  Response/Acknowledgement",0]
[null,null,{"$f":"SUM(C6:C36)","v":59}]
[{"$f":"ROWS(l_agency)","v":18},"l_agency",{"$f":"COUNTIF(SC_c_agency,B38)","v":0}]
[null,"Agency / IWS Name"]
[null,"Ajax Chemical",{"$f":"COUNTIF(SC_c_agency,B40)","v":0}]
[null,"Benton Refinery",{"$f":"COUNTIF(SC_c_agency,B41)","v":0}]
[null,"City EMS Dispatch",0]
[null,"City Fire Dispatch",0]
[null,"City Police Dispatch #1",19]
[null,"City Police Dispatch #2",0]
[null,"Common Bk Corp Lobby",15]
[null,"Common Bk Corp Security Office",25]
[null,"County EMS Dispatch",0]
[null,"County Sherriff",0]
[null,"Federal Mall",0]
[null,"Hospital #1",0]
[null,"Hospital #2",0]
[null,"Hospital #3",0]
[null,"Langform Processing",0]
[null,"Liincoln Mall",0]
[null,"State Highway Patrol",0]
[null,"Tranist Dispatch",0]
[null,null,{"$f":"SUM(C39:C57)","v":59}]
[{"$f":"ROWS(l_person)","v":13},"l_person",{"$f":"COUNTIF(SC_c_person,B59)","v":0}]
[null,"EMT #1",0]
[null,"Battalion Chief",0]
[null,"Dispatcher",19]
[null,"ER Admin",0]
[null,"Firefighter",0]
[null,"Hospital Admin",0]
[null,"IWS Operator",0]
[null,"Paramedic",0]
[null,"Police Officer",0]
[null,"Security Guard",16]
[null,"Sherriff",0]
[null,"Shift Supervisor",18]
[null,"VP of Security",6]
[null,null,{"$f":"SUM(C59:C72)","v":59}]
[]
[null,"Lists Used on Scenario_Definitions Worksheet"]
[]
[{"$f":"ROWS(l_entity)","v":13},"l_entity"]
[null,"Bank"]
[null,"County EOC"]
[null,"Factory"]
[null,"Fire"]
[null,"Hospital"]
[null,"Mall Security"]
[null,"Other"]
[null,"Plant"]
[null,"Police"]
[null,"School"]
[null,"Stadium"]
[null,"Transit Authority"]
[null,"Utility"]
[]
[{"$f":"ROWS(l_category)","v":3},"l_category"]
[null,"Private Enterprise"]
[null,"Public Safety"]
[null,"Public/ Private Agency"]

{"sheet":"Scenario Example","index":6,"n_rows":81,"n_cols":16,"rows_kept":81,"cut":false,"hidden":false,"merged":[[3,12,6,16],[10,0,10,2],[10,5,10,6],[11,0,11,2],[11,5,11,6],[8,15,10,16],[9,0,9,2],[9,5,9,6],[3,0,4,2],[3,3,4,3],[3,5,7,7],[6,0,6,2],[7,0,7,2]]}
[1,"2012-01-26","This worksheet is an example of a Scenario Event Sequence Listing."]
[0,null,null,null,null,"add data",null,null,null,8,1000]
[]
["Scenario Type:  ",null,null,"PROTESTOR GATHERING",null,"An unknown number of protesters have appeared in the lobby at the Common National Bank Corporate Offices.  Some are shouting threatening comments.  Bank security personnel are monitoring the activities on their video surveillance system.  The situation is very tense and seems to be quickly escalating.",null,null,null,null,null,null,"This is an example of a Scenario Event Sequence Listing. Data cannot be changed."]
[]
[null,null,null,"HURRICANE"]
["Category:  ",null,null,"Private Enterprise"]
["Primary Entity:  ",null,null,"Bank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click to go to Bottom of the List"]
["Scenario Name:  ",null,null,"Bank Protestors",null,"Tom Berger",null,"Created By"]
["Created Date:  ",null,null,"2012-01-05",null,"Mutualink, Inc.",null,"Organization"]
["Revised Date:  ",null,null,"2012-01-10",null,"tberger@mutualink.net,  603-661-5682",null,"Contact Info"]
[]
[null,null,"Summary:  ","This scenario exercise includes three IWSs (2 @ Commons Bank facilities, 1 @ Local Police), a video feed from the bank, and two radio channels (1 for bank security and 1 for the police).  A cell phone is also brought into the incident as is a Public Address system and a file is transferred.",null,null,null,null,null,291]
[59,null,null,null,null,null,null,null,null,350]
["No.","Seq. No.","Entity & IWS","Person","H","Activity/Event","Action","File name, number, etc.",null,"Activity Desc Length","Highlight Column Color"]
[1,1,"Common Bk Corp Lobby","Security Guard",null,"The Main Lobby Security Guard at Common National Bank's Corporate Office creates an incident with the off-site Corporate Security Office to inform them about the protesters' presence.","I: Create an incident","Session named \"Protestors\"",null,183,14]
[2,2,"Common Bk Corp Security Office","Shift Supervisor",null,"Common Bank Corporate Security Shift Supervisor responds to the session request and, via IWS Intercom requests info on the situation.","I: Accept an incident request","Session named \"Protestors\"",null,133,47]
[3,3,"Common Bk Corp Lobby","Security Guard",null,"In response to Shift Supervisor's request, the Security Guard brings the local lobby video feed into the incident to allow the Shift Supervisor to view real time events as he describes them.","V: Bring a camera/video  into an incident",null,null,190,14]
[4,4,"Common Bk Corp Security Office","Shift Supervisor",null,"Opens video icon to view real time video feed from the lobby on his IWS.","V: Open video feed shared by others",null,null,72,47]
[5,5,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor brings Common Bank Security radio channel into the incident and asks all security guards at the Corporate Offices to converge on the Main Lobby area but not to enter the lobby or confront the protestors.  All personnel to maintain a low key presence.  Supervisor asks all guards to acknowledge transmission receipt.","R: Bring a radio into an incident","Common Bank radio channel SEC 1",null,332,47]
[6,6,"Common Bk Corp Security Office","Security Guard",null,"Multiple security guards respond to dispatch request.","I: Field call into an incident",null,null,53,14]
[7,7,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor creates an incident named \"Bank Help\" and invites City Police to join.","I: Create an incident","Session named \"Bank Help\"",null,87,47]
[8,8,"City Police Dispatch #1","Dispatcher",null,"City Police Dispatcher via City Dispatch #1 IWS accepts the invitation and discusses the situation with Shift Supervisor and asks to be brought into the active incident session.","I: Accept an incident request","Session named \"Bank Help\"",null,177,1000]
[9,9,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor invites City Police to join the existing session named Protestors as requested.","I: Invite others to an incident","Session named \"Protestors\"",null,96,1000]
[10,10,"City Police Dispatch #1","Dispatcher",null,"Police Dispatch accepts invitation request and joins the Protestor incident and announces his presence via IWS Intercom.","I: Accept an incident request","Session named \"Protestors\"",null,120,1000]
[11,11,"City Police Dispatch #1","Dispatcher",null,"Police Dispatch terminates the Bank Help incident.","I: Terminate an incident","Session named \"Bank Help\"",null,50,1000]
[12,12,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor terminates the Bank Help incident.","I: Terminate an incident","Session named \"Bank Help\"",null,51,1000]
[13,13,"City Police Dispatch #1","Dispatcher",null,"Opens video icon to view real time video feed from the lobby.","V: Open video feed shared by others",null,null,61,1000]
[14,14,"City Police Dispatch #1","Dispatcher",null,"Via the IWS Intercom function, the Police Dispatcher asks the Lobby Security Guard for details on the protestors including their numbers, any visible weapons or backpacks, and their overall mode.","I: Contact another IWS by intercom",null,null,195,1000]
[15,15,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard responds to the Police Dispatcher's questions.","I: Contact another IWS by intercom",null,null,67,1000]
[16,16,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher suggests , via IWS Intercom, to Common Bank Shift Supervisor that they alert appropriate bank official and bring them into the incident.","I: Contact another IWS by intercom",null,null,154,1000]
[17,17,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor agrees to contact VP of Security and asks Police, Lobby Guard, and Security Officers to standby via TX function on IWS.","R: Transmit/Receive via radio","Common Bank radio channel SEC 1",null,136,1000]
[18,18,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor creates a new incident to contact Security VP.","I: Create an incident","Session named \"Emergency\"",null,63,1000]
[19,19,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor brings Telco resource into the incident and dials Security VP's cell phone number as listed in the IWS phone directory.","T: Dial out to a phone","Phone number is: 555-123-4567",null,136,1000]
[20,20,"Common Bk Corp Security Office","VP of Security",null,"Security VP answers call, Shift Supervisor updates Security VP, Security VP asks to be brought into the session.","T: Answer an incoming telco call",null,null,112,1000]
[21,21,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor announces to all session participants that Security VP will be joining the session shortly and asks everyone to standby.","R: Transmit/Receive via radio",null,null,137,1000]
[22,22,"Common Bk Corp Lobby","Security Guard",null,"Security Guard sends a Chat message to the Shift Supervisor asking him to mention to the Security VP that he should mute his cell phone when not talking to avoid the broadcast of background noise.","C: Create and send a chat/text  message",null,null,196,1000]
[23,23,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor receives the Chat message and responds to the Security Guard that he will ask the Security VP to mute his cell phone.","C: Receive a chat/text message",null,null,134,1000]
[24,24,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor tells the Security VP that he will be brought into the incident and asks the VP to keep his cell phone on mute unless he wants to talk to avoid the broadcast of background noise.  Security VP is then brought into the session by moving Telco resource into the Protestor incident.","T: Move a telco connection between incidents","Session named \"Protestors\"",null,295,1000]
[25,25,"Common Bk Corp Security Office","Shift Supervisor",null,"Shift Supervisor terminates the \"Emergency\" session.","I: Terminate an incident","Session named \"Emergency\"",null,52,1000]
[26,26,"Common Bk Corp Security Office","Shift Supervisor",null,"Via the IWS Intercom, Shift Supervisor announces that the Security VP has joined the session.","I: Contact another IWS by intercom",null,null,93,1000]
[27,27,"City Police Dispatch #1","Dispatcher",null,"Via the IWS Intercom, the Police Dispatcher asks if a floor plan of the Bank Lobby is available that shows all entrances and exits.","I: Contact another IWS by intercom",null,null,131,1000]
[28,28,"Common Bk Corp Lobby","Security Guard",null,"Via the IWS Intercom, the Lobby Security Guard responds that he has a floor plan on his IWS and will share it.","I: Contact another IWS by intercom",null,null,110,1000]
[29,29,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard locates the floor plan file on his IWS and sends it to all IWS participants","F: Send a file","Filename = Common Bank Lobby Floor Plan",null,96,1000]
[30,30,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher receives the file.","F: Receive a file","Filename = Common Bank Lobby Floor Plan",null,36,1000]
[31,31,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher views the file.","F: View a file",null,null,33,1000]
[32,32,"Common Bk Corp Security Office","Shift Supervisor",null,"Bank Security Supervisor receives the file.","F: Receive a file",null,null,43,1000]
[33,33,"Common Bk Corp Security Office","Shift Supervisor",null,"Bank Security Supervisor opens the file.","F: View a file",null,null,40,1000]
[34,34,"Common Bk Corp Security Office","VP of Security",null,"Via IWS Intercom, Security VP asks Lobby Security Guard for an update.  Requests that all personnel hear the update.","I: Contact another IWS by intercom",null,null,116,1000]
[35,35,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard, through the IWS Tx function, provides an update to all session participants indicating that the Protestors have settled down and are no longer very vocal and the situation has seemed to stabilize.","R: Transmit/Receive via radio",null,null,218,1000]
[36,36,"Common Bk Corp Security Office","VP of Security",null,"Security VP suggests to Police Dispatch that the police announce to the protestors via the Bank Lobby Public Address system that the protestors are breaking the law and asks them to move outside of the Lobby or totally disburse.","I: Contact another IWS by intercom",null,null,228,1000]
[37,37,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher agrees to make the announcement. But as a precautionary matter tells participants that he will contact Police District 9 via radio and have  officers standing by in case of trouble.","I: Contact another IWS by intercom",null,null,199,1000]
[38,38,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher creates a new session named D 9 Radio Alert.","I: Create an incident","Session named D9 Radio Alert",null,62,1000]
[39,39,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher brings D9 Radio Resource into the incident and briefs District 9 Officers on the situation and asks them to standby.","R: Move a radio resource between incidents","D9 Radio Resource",null,134,1000]
[40,40,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher announces to session Protestor participants that District 9 Officers have been briefed and will be brought into the incident through the IWS's Intercom function.","I: Contact another IWS by intercom",null,null,179,1000]
[41,41,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher moves D9 Radio Resource from D9 Radio Alert incident to Protestor incident and announces their presence via the IWS Transmit function.","R: Move a radio resource between incidents",null,null,152,1000]
[42,42,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher terminates the D9 Radio Alert incident.","I: Terminate an incident","Session named D9 Radio Alert",null,57,1000]
[43,43,"Common Bk Corp Lobby","Security Guard",null,"At the request of Common Bank Security Shift Supervisor, the Common Bank Lobby Security Guard brings the Lobby Public Address Resource into the Protestor incident.","P:  Bring Public Address Resource into incident",null,null,163,1000]
[44,44,"Common Bk Corp Lobby","Security Guard",null,"Security Guard transmits through the IWS Intercom function that the Public Address Resource is in the incident and ready for the Police Broadcast message.","I: Contact another IWS by intercom",null,null,154,1000]
[45,45,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher broadcasts warning to all participants and audio is transmitted over the Bank Lobby P/A system.","P: Transit audio via Public Address",null,null,113,1000]
[46,46,"Common Bk Corp Lobby","Security Guard",null,"Security Guard removes the P/A Resources from the incident.","P:  Remove P/A Resource from incident",null,null,59,1000]
[47,47,"Common Bk Corp Lobby","Security Guard",null,"Security Guard reports that protestors are reluctantly leaving.  Other IWS operators watch lobby video.","I: Transmit via IWS",null,null,103,1000]
[48,48,"Common Bk Corp Lobby","Security Guard",null,"Security Guard through the IWS Tx function, informs all participants that the Lobby P/A is no longer in the incident.","I: Transmit via IWS",null,null,117,1000]
[49,49,"Common Bk Corp Security Office","VP of Security",null,"Bank Security VP via his cell phone that is in the incident asks all participants to stand by and remain in the session for a few minutes while all IWSs watch video.","I: Transmit via IWS",null,null,165,1000]
[50,50,"Common Bk Corp Security Office","Shift Supervisor",null,"After five minutes, the Bank Security Supervisor reports that through the IWS video feed showing the lobby that all protestors have vacated the lobby and suggests to Security VP that everyone stand-down.","I: Transmit via IWS",null,null,203,1000]
[51,51,"Common Bk Corp Security Office","VP of Security",null,"Security VP agrees and asks everyone to terminate the incident after thanking everyone for their participation.","I: Transmit via IWS",null,null,111,1000]
[52,52,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher acknowledges termination request.","I: Transmit via IWS",null,null,51,1000]
[53,53,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher removes Police Radio Resource from the incident.","R: Terminate a radio  connection",null,null,66,1000]
[54,54,"City Police Dispatch #1","Dispatcher",null,"Police Dispatcher terminates the incident.","I: Terminate an incident",null,null,42,1000]
[55,55,"Common Bk Corp Security Office","VP of Security",null,"Security VP hangs up his cell phone.","T: Terminate a telco call",null,null,36,1000]
[56,56,"Common Bk Corp Security Office","Shift Supervisor",null,"Bank Security Supervisor terminates the incident.","I: Terminate an incident",null,null,49,1000]
[57,57,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard removes video feed from the incident.","V: Terminate camera/video feed",null,null,58,1000]
[58,58,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard removes Security Radio Resource from the incident.","R: Move a radio resource between incidents",null,null,71,1000]
[59,59,"Common Bk Corp Lobby","Security Guard",null,"Lobby Security Guard terminates the incident.","I: Terminate an incident",null,null,45,1000]
[]
[null,null,null,"Click to go to listing top",null,null,null,null,null,332]
[]
[]
[59,null,"= Events Listed"]
[59,null,"= Events Shown"]

{"sheet":"Enable_Macros","index":7,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,0,4,1]]}
[1,"2012-01-26","Instructions for enabling Visual Basic."]
[]
["Enable Macro Instructions"]
[]
["These instructions will only take effect after a file is re-opened.  So, if this file is opened, follow the instructions listed below then close this file and re-open it."]
[]
["For Excel 2007, to enable Macros to use the program features, follow these steps…"]
[1,"Open Excel but not this workbook!"]
[2,"Click on the Office Button in the upper left hand corner"]
[3,"Click on Excel Options in the lower right hand corner"]
[4,"Click on Trust Center"]
[5,"Click on Trust Center Settings… in the right middle of the screen"]
[6,"Click on Macro Setting on the left hand side of the screen"]
[7,"Click the select dot for Enable all macros"]
[8,"Check the box for Trust access to VBA…"]
[9,"Click OK"]
[10,"Click OK"]
[11,"Open this workbook"]
[]
["For Excel 2010, to enable Macros to use the program features, follow these steps…"]
[1,"Open Excel but not this workbook!"]
[2,"Click on File Menu (Office Backstage)"]
[3,"Click on Excel Options"]
[4,"Click on Trust Center"]
[5,"Click on Trust Center Settings"]
[6,"Click on Macro Setting on the left hand side of the screen"]
[7,"Click the select dot for Enable all macros"]
[8,"Check the box for Trust access to VBA…"]
[9,"Click OK"]
[10,"Click OK"]
[11,"Open this workbook"]

{"sheet":"Maintenance_Macros","index":8,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[36,1,36,10],[48,3,48,8],[24,1,26,7],[2,1,2,7],[3,1,3,7],[6,1,8,7],[15,1,17,7],[19,4,19,7],[46,1,46,10],[5,1,5,7]]}
[1,"2012-01-26","This worksheet contains a number of Macros (Visual Basic Routines) that automate certain capabilities of the Tool.  They are only available if the Tool has been saved with Macros (a standard Excel option and the running of macros has been enabled before the Tool was open."]
[]
[null,"Visual Basic Tool Maintenance Routines"]
[null,"(These routines only operate if the Tool has been saved with Macros and Macro operation has been enabled before the Tool is opened.)"]
[]
["P","Sheet Protection is ON"]
[null,"All Worksheets are normally protected so no entries can be made except on the Scenarios worksheet.  No Password is used (null).  "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This option allows the user to change the header and footer on all worksheets as specified below to be changed simultaneously."]
[]
[]
[]
[null,null,null,null,"Header and Footer Values to Use"]
[null,null,null,null,"Right Header",null,"Version","Ver 1.0",null,null,"©"]
[null,null,null,null,"Left Footer",null,"Update Date","2012-01-26"]
[]
[]
[null,"Row 1 on each worksheet contains the version number, date, and a brief description of the worksheet that is used  shown on the Index Worksheet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Interior Color Fill Table with Color Indexes for Excel 2007"]
[]
[null,2,1,19,55,47,18,48,47,42,45]
[null,2,16,15,24,24,19,19,24,20,19]
[null,15,16,15,37,24,15,35,15,24,40]
[null,15,56,16,42,37,48,15,15,37,40]
[null,48,56,56,49,55,18,12,47,50,46]
[null,16,1,52,56,49,56,56,56,49,53]
[]
[]
[null,"Turn Worksheet Protection Off to use this Routine."]
[]
[null,null,null,"Color Index Determination Tool"]
[]
[null,null,null,null,"Fill in a cell color"]
[]
[null,null,null,null,"Cell Color Index is",14]

{"sheet":"Change_Record","index":9,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,0,2,2]]}
[1,"2012-01-26","This worksheet provides a high level summary of the changes in the ISC Tool made with each revision."]
[]
["Change Record"]
[]
["Version","Date","Change Summary"]
[1,"2012-01-26","Initial release of the Scenario Exercise Development tool"]