Excel table to a flowchart
A solution to this problem alone will make Office worth the price for us.
We have a workflow in place. An Analyst will supply the QA group with a
visio diagram of the workflow, and the database developer with an excel file
of each status (decision box on the diagram) and each status available from
it.
For example, I can move work from a status of Open, to either Filed or
Pending. From Open, I need to have 3 statuses available, Open, Filed and
Pending. The spreadsheet woudl look something like this
Column 1 Column 2
Open Open
Open Filed
Open Pending
The Diagram is something like this:
Open ----Pending
|
|
V
Filed
Is there a way, some privately developed piece of code even, to take this
excel file and generate the diagram?
Because the analyst has to create the same work twice, they often miss a
status or two when updating a workflow with 8 or 9 steps.
Thanks, Sean
|