Solved

Using Excel to document steps

Posted on 2014-01-27
3
292 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
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 on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

776 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