A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Visio
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Exporting Cross Functional Process flow data to excel



 
 
Thread Tools Display Modes
  #1  
Old June 29th, 2009, 05:48 PM posted to microsoft.public.visio.general
iralevine
external usenet poster
 
Posts: 1
Default Exporting Cross Functional Process flow data to excel

i am sure there is a way to do this jut need some guidance.

I have built out some pretty robust process flows for a client that cover
cross functional steps in a series of processes. I have the same standard
swimlanes across the flows (5 lanes) and for each process have mapped out the
key steps, handoffs, approvals, etc... and placed them in the appropriate
swimlane for "ownership" of that step.

What I am trying to do via export, rather than have to manually type, is
create a matrix that can show me across all of the flows what step is in
which swimlane. If i have to do some manipluation after export that is fine,
i have only thus far been able to export everything but that just leaves me
with the raw data. I still have to cut/paste, and move around information.

I am trying to get to something that has the swimlanes across the top and
the listing of the process steps along the left side and a "check" or "X" in
the corresponding swimlanes. Worst case, if i could export the data and have
a listing of the step and the swimlane it resides in, i could at least do a
data sort.

All i have been able to get so far is just a listing of every shape on each
flow, the shape ID, comments, and other data points.

Is what i am trying to achieve even possible? I am using Visio 2003 and
have Excel 2007.

Thanks in advance for any and all assistance.

Ira
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.