How To Create Decision Tree Analysis in Excel? Wondering, how to create and use a Decision Tree in excel? Well, these can be easily drawn with the help of Microsoft. Easily create decision trees with the help of our decision tree templates which are available in PDF, Word, Excel® and PowerPoint®. Hi, I hope someone is going to be able to help me because it's my first Visio VBA project. I would like to be able to import a decision tree from an Excel file to be able to draw this decision tree in Visio VBA. I looked at the FlowchartSample VB6 project from the Microsoft KB to get started. The project reads an Excel file and the build the tree in Visio. All the different shapes are connected but I would like to be able to specify 'YES' or 'NO' based on some information in the Excel file. The Excel file should look like this: Step ID Description NextStepIfTrue NextStepIfFalse ShapeType 1 Client is a male? 2 3 Decision 2 Client is a male End 3 Client is a female End The connector between the stepID 1 and stepID 2 should indicate 'YES' and the connector between stepID 1and stepID 3 should indicate 'NO'. Anyone has an idea? Please don't hesitate if my question is not clear enough. Thanks for your attention, Lecoq.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2018
Categories |