News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Create Mulitple Business Models with Excel Data

Started by smjcwarner, February 17, 2012, 09:16:41 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

smjcwarner

I need to create a series of flowcharts for business processes based on an excel spreadsheet.  How do I use the below listed data to automatically create a new flow chart when the master group number changes?

MASTER GROUP #   COVER PAGE   COVER PAGE SHEET COUNT   NOTES PAGE   NOTES PAGE SHEET COUNT   POG #   POG SHEET COUNT
CID-022112-2001   YES                  2 SHEETS                           YES                   1 SHEET                                31934_00001   1 SHEET
CID-022112-2002   YES                  2 SHEETS                                YES                   1 SHEET                                31934_00002   1 SHEET
CID-022112-2003   YES                  2 SHEETS                       YES                   1 SHEET                                31933_00001   1 SHEET
CID-022112-2004   YES                  2 SHEETS                                YES                   1 SHEET                                31933_00002    1 SHEET
CID-022112-2005   YES                  2 SHEETS                                YES                   1 SHEET                                31934_00004   1 SHEET

Based on the above data, I need to have five flowcharts that has the data listed for each column.

Can this be done automatically with Visio, if so, how, if not, is there a program out there that accomplish this task?

aledlund

I'm unaware of any program (including Visio) that will create a legitimate BPMN drawing from imported excel data. Sounds like an opportunity (I'd start with David Parker's latest book).
al

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 148 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1069KB.
Tokens: post-login.
Cache hits: 13: 0.00217s for 26,723 bytes (show)
Cache misses: 3: (show)
Queries used: 17.

[Show Queries]