Genetic Algorithm Game using Excel

1. Use an excel spreadsheet, , roll two dice six times. Fill in the yellow block with these numbers. 2. The fitness scores should be calculated automatically. Low values for this problem are best. 3. 1st Parent: Roll two dice, if the numbers are same reroll one die to until the numbers are different. Use the two values to select the 1st parent, the solution with the lowest fitness of the two. Take the X part of the selected parent and it forms the X part of the new child (orange). 4. 2nd Parent: Roll two dice, if numbers are the same or appear in 1st parent, reroll until you get two different numbers (including different to the 1st parent). the solution with the lowest fitness of the two. Take the Y part of the selected parent and it forms the Y part of the new child (orange). 5. Mutation: Roll a die for each part of the child solutions. If the roll is 1, roll another die and replace the appropriate element with the new number – even if the same as the previous value. 6. Copy the average (red) into the table and the lowest value 7. Copy the child solutions after mutation (orange) into the yellow area and repeat steps 1-6 10 times