ORIGINAL SETTING	NEW SETTING	OUTPUT
Mitigation Status = proposed	In Progress	Mark the actual start date with today’s date.
Mitigation Status = proposed	Complete	Mark the actual start date with today’s date and the actual finish date with today’s date.
Mitigation Status = In Progress	Proposed	Remove the actual start date.
Mitigation Status = In Progress	Rejected	Remove the actual start date.
Mitigation Status = In Progress	Complete	Mark the actual finish date with today’s date.
Mitigation Status = In Progress	Approved	Remove the actual start date.
Mitigation Status = Rejected	In Progress	Mark the actual start date with today’s date.
Mitigation Status = Rejected	Complete	Mark the actual start date with today’s date and the actual finish date with today’s date.
Mitigation Status = Complete	Proposed	Remove the actual start and finish dates.
Mitigation Status = Complete	In Progress	Remove the actual finish date.
Mitigation Status = Complete	Approved	Remove the actual start and finish dates.
Mitigation Status = Complete	Rejected	Remove the actual start and finish dates.
Mitigation Status = Approved	In Progress	Mark the actual start date with today’s date.
Mitigation Status = Approved	Complete	Mark the actual start date with today’s date and the actual finish date with today’s date.
Mitigation Status = Risk Closed	Proposed	Remove the actual start and finish dates.
Mitigation Status = Risk Closed	In Progress	Mark the actual start date with today’s date unless it is already marked and remove the actual finish date if there is one.
Mitigation Status = Risk Closed	Rejected	Remove the actual start and finish dates if they exist.
Mitigation Status = Risk Closed	Approved	Remove the actual start and finish dates if they exist.
Risk Status = Open (Any) or Impacting	Closed (Any)	Set all mitigation status to “Risk Closed.”  Do not change the actual dates.
User sets an actual start on mitigation		Set mitigation status to In Progress unless it is already in In Progress or Complete status.
User sets an actual finish on a mitigation		Set mitigation status to Complete if not already in Complete status.
Create new risk	Set risk ID based on a timestamp	Set the risk ID based on a timestamp if the user did not type in the ID column to create the risk.  ID = T + timestamp for threats.  O + timestamp for opportunities.  User can overwrite.
Create new mitigation step	Set mitigation ID based on a timestamp	Set the risk ID based on a timestamp if the user did not type in the ID column to create the mitigation.  ID = M + timestamp.  User can overwrite.