Solved

Using Excel to document steps

Posted on 2014-01-27
3
263 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
Comment Utility
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
Comment Utility
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
Comment Utility
Yes, pcelba is right, MS Project would be another solution, and with more charting and display options.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

772 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

15 Experts available now in Live!

Get 1:1 Help Now