Use Evolutionary Solver to solve Problem 4 in Chapter 70, “Using Solver for capital budgeting.”

Data from in Problem 4 in Chapter 70

Jill is trying to determine her class schedule for the next semester. A semester consists of two seven-week half semesters. Jill must take four courses during each half semester. There are five time slots during each semester. Of course, Jill cannot take the same course twice. Jill has associated a value with each course and time slot. This data is in the file named Classdata.xlsx. For example, Course 1 during Time Slot 5 in Semester 1 has a value of 5. Which courses should Jill take during each semester to maximize her total value from the semester’s courses?