Hello, Automator

1. Look at the table below. It has random number of rows and random coffee drinkers
2. Sometimes the number of coffee caps or type of coffee are missing
3. Task: create a RF on-fly generated test suite to find out if the table has any missing numbers or missing names.
4. Make sure the generated test suite has as many test cases as many rows the current table has.
5. Suite setup should capture screen.
6. Test case name should have the coffee drinker name
7. Test case should fail if either number of caps or the coffee type is missing
8. Sometimes due to program glitches the type of coffee reported as "... Cocoa". This is a bug, the test for this row should fail.
9. Sometimes the same person reported twice or more in the table. This is a bug. Have a special test to check for duplicates and fail it if any. Generate a valid fail message and list all duplicated persons.
10. 0 caps with reported type of coffee does not make sense. This is a bug. Report it.
11. Sometimes extra table is generated. Have a special test case to verify if the second table is NOT displayed. Fail this test otherwise.

Cups of coffee consumed by each manager per day
NameCups per dayType of CoffeeSugar?
Todd Black1GuillermoNo
Justin Black9Cadbury CocoaYes
Martin Fuller7CappucinoNo
Helena Anderssen14Bournville CocoaYes
John Dinnen16EspressoYes
Patrick Fuller8GuillermoNo
James Anderssen13DecafYes
Justin Bond1EspressoNo
Robert Black16Bournville CocoaNo
John Tailor4GuillermoYes
Joe Black..--No
Robert Sexton3DecafNo
Helena Bond3EspressoNo
Justin Rates6CappucinoYes
Robert Tailor0LatteYes