Hello,
Please find attached a PDF to help explain/visualize what i am trying to achieve. The following example will make much more sense if you have the PDF open.
Looking at 'Define your Equipment type' we have three inputs. This can be seen on the attached excel file. For example if you pick 'Vessel' followed by 'Liquid' and finally 'Group 2' the output i'm trying to achieve is Table 4. Alternatively if you pick steam generator, table 5 will be output to the screen as no further inputs are required.
I hope that makes sense. I have attempted to complete this exercise by assigning a numeric value to each of the options and then depending on the value returned assign the correct table which works OK but is not the cleanest of methods especially if the table is to be expanded at a later time.
Many Thanks in advance!!
Bookmarks