+ Reply to Thread
Results 1 to 2 of 2

Generating a Dynamc Dependency list

  1. #1
    Registered User
    Join Date
    06-26-2011
    Location
    Brisbane
    MS-Off Ver
    Excel 2007
    Posts
    28

    Generating a Dynamc Dependency list

    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
    Attached Files Attached Files
    Last edited by dave_gordon; 08-09-2012 at 01:08 AM.

  2. #2
    Registered User
    Join Date
    06-26-2011
    Location
    Brisbane
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Generating a Dynamc Dependency list

    I can't imagine why this is so difficult - or maybe it's me being incredibly stupid!

    In the attached very basic example I am using the following formula;

    INDEX('Sheet2'!$A$1:$F$1,1,MATCH(A2,'Sheet2'!$A$1:$F$4,0))

    This throws a '#N/A' so I then tried;

    =LOOKUP(REPT("Z",255),CHOOSE({1,2},"",INDEX('Sheet2'!$A$1:$F$1,1,MATCH(A2,'Sheet2'!$A$1:$F$4,0))))

    but now I just get blanks.

    Any help would be much apprechiated.

    Regards
    Dave
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1