Morning all,
Just wanted to gauge your thoughts on the best way to implement a decision making process in excel.
Ultimately we have about 100 resolutions depending on what happens at certain points. At each level the options will split and currently there is someone gathering data in the form of a decision tree.
I have started to think about how to do this through excel in a format where the user will answer questions in an order until they reach the only possible answer. I believe named ranges would be the best practice for this so depending on what they select from the first option would then depict what the options were on the second question and so forth. The issue I can forsee is that it's not going to be a straight line of questioning and something that may need 10 question to reach a resolution could also be resolved earlier depending on the answer to questioning. The chap who is gathering the detail for me is doing so for one example for now but I would like to have a template I can ask him to complete to save my work further down the line.
I'm going to mock up an example which I'll attach later if required but just wanted some opinions before I invest too much time into it.
If any of you have any templates you're happy to share that would be great or if you have any experience also I'd love to hear from you.
Thanks
Dave
Bookmarks