I'm looking for software that can assist me in analyzing the course of action during an emergency response exercise by investigating communication between those who participated in the exercise.
I have a log (in a spreadsheet table) of 6-700 messages between 20 emergency response agencies during an emergency response exercise. For each of the 6-700 messages, I have information about time that the message was sent, who the sender was, the message content, and the receiver of the message. I have furthermore categorized the messages according to which event the message is about (several hazard events during the exercise) and according to several other criteria (e.g. if a question/request or information is communicated, if the message contains information about location or place names, if the message is about allocation of resources, if it is a situation report etc.).
I picture information visualized in a matrix with time on one axis and different emergency response agencies on the other, and messages containing requests and information moving between the agencies plotted in the matrix in a way that enable identification of different threads and different types of content. An aim is to identify threads that have a satisfactory outcome (e.g. question resolved, decision made, action taken) or unsatisfactory outcome (messages getting lost on the way).
A further aim is to find new ways to evaluate an exercise just after it has been taking place.
All suggestions are welcome.