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