How to properly design a worksheet  to logically associate various items

Posted on 2014-07-13
Last Modified: 2014-08-14
I am working on an accident analysis application.
The first step in the process is to identify the Accident Sequence of Events.
The second step is to identify the Conditions associated with each Event.
The third step is where I am having a problem designing the worksheet.
The third step is to identify the six Causal Factors that are associated to the Events and Conditions, if any.
The six Causal Factors are:
What equipment failed and how it failed
Who did what wrong?
How/What/Where/Why/To What Extent/Under What Conditions?

How do I pull together the following items on worksheet “Step 3 - Define Causal Factors”
1.      Accident sequence of events
2.      Conditions
3.      The Causal Factors that are associated with each  Accident events and accident conditions
Question by:cssc1
    LVL 29

    Accepted Solution

    As a quick evaluation I just noticed that in sheet Database the Col H and I have Error #REF this means that the formula there does not link to a correct Cell is this normal ? Does Col H and I need to exist if yes then where they would point to ?

    Author Comment

    The database sheet should not be part of the application. Sorry, I should have deleted it.

    Author Closing Comment


    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now