The following computations are used in a Business Continuity project to determine the system recovery order.
I have a 172 Application Names and each is listed in Order of Priority (1-172), which is determined by a Ranking Figure that is a computation of the number of users, the timeframe the system is required and finally the board members perceived importance.
Some Application Names have recovery dependencies on other Applications Names and must be restored prior so I need a way of establishing the correct order of restoration. So for each Application Name there is another list which includes any dependent system. The idea is that I would determine whether each dependency is higher is the list that the Application Name to which it is linked, and if not increase the Ranking Figure of the dependency to ensure it is recovered prior to the Application Name that depends on it (i.e. maybe add Ranking Figure of Application Name)
This is further complicated by the fact that a) I would like the calculation to be dynamic and b) the data resides on two separate worksheets and shown in the example of the data in the attached spreadsheet.
Many thanks in advance
Regards
Dave
Bookmarks