[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

How to properly design a worksheet  to logically associate various items

Posted on 2014-07-13
3
Medium Priority
?
64 Views
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:
 Failures
Errors
Mistakes
Problems
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
Root-Cause-Analysis-Ver-9.xlsm
0
Comment
Question by:cssc1
  • 2
3 Comments
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 40194254
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 ?
gowflow
0
 

Author Comment

by:cssc1
ID: 40194383
The database sheet should not be part of the application. Sorry, I should have deleted it.
0
 

Author Closing Comment

by:cssc1
ID: 40260664
thanks
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

872 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