Solved

Using Excel to document steps

Posted on 2014-01-27
3
278 Views
Last Modified: 2014-01-27
Greetings!

I need to document about 350 steps in a systems build process which have branching and merging paths and various dependencies I want to represent. I am looking to have one tab with all the data listed in a table, then be able to pivot and provide constrained views on successive tabs.

Do you happen to have an example of a spreadsheet/table with brancing, merging and dependencies represented?

Thank you!
JohnD
0
Comment
Question by:johndarby
  • 2
3 Comments
 
LVL 5

Expert Comment

by:RAdministrator
ID: 39812506
Hi, don't have anything like that and don't recommend Excel for it. You should use Visio which does what you are requesting.
0
 
LVL 41

Accepted Solution

by:
pcelba earned 500 total points
ID: 39812525
I would recommend MS Project or similar software to do this task.
And MS Project isn't the only option. You may look at RationalPlan (http://www.rationalplan.com/)

Also free software exists, e.g. OpenProject: https://www.openproject.org/
0
 
LVL 5

Expert Comment

by:RAdministrator
ID: 39812535
Yes, pcelba is right, MS Project would be another solution, and with more charting and display options.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delete all words in cell more than 5 words 7 47
Generating a graph via Excel 3 23
macro for closing opened workbook 6 19
TSQL previous 5 23
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
My experience with Windows 10 over a one year period and suggestions for smooth operation
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

914 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

13 Experts available now in Live!

Get 1:1 Help Now