Dog happiness

Download the starter worksheeet. It has data about dog happiness, collected from happiness-recording collars. For each dog, there's the dog's name, its happiness level, and phone number:


Happiness values should be between 1 to 10. Sometimes the collars malfunction, because of excess drool. The data will always be numeric, but sometimes might be out of range.

Write a program that runs when the user clicks the Run button. It shows the average happiness and dog count, but only for valid data. That is, invalid happiness values are not included in the average and count. Invalid values are highlighted.

The program also shows the happiest and saddest dogs. It shows their name, happiness, and phone number. Again, invalid data is excluded.

Here's the output:


Important! The program should work no matter how many dogs there are. Assume the data is contiguous, that is, if there is a blank row, that's the end of the data.

Upload your workbook. The usual coding standards apply.

(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)

Referenced in: