Hi, using the following article, I am unable build a basic expert system using Microsoft Excel (2010/2013/2016) to answer 3 questions and then produce or display report. I reviewed a couple of articles online using Microsoft excel but not having much luck. I am not sure if excel is appropriate. The goal is to open a spreadsheet, answer the questions (like an survey), and view the results. When finished click close or exit the spreadsheet.
Article URL: https://www.wkastudio.com/Tutorials/Creating%20expert%20system%20from%20rules%20stored%20in%20spreadsheets_Wine%20Selection.pdf
Question 1: What is your Major?
Response ID1: Math
Response ID2: Technology
Response ID3: English
Question 2: What is is your Grade level?
Response ID Q1: Freshman
Response ID Q2: Sophomore
Response ID Q3: Junior
Response ID Q3: Senior
NOTE: Question #3 is asked if one of the following responses is selected: Sophomore, Junior, or Senior. If Freshman is selected then the class report is ran.
Question 3:Have you completed your general education English 1&2, Math 1&2, and Science 1&2 level courses?
Response ID Q1: Yes
Response ID Q2: No
---End of Questions---
Class report is generated
Please share any articles and suggestions.