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?
Justin Anderssen3--Yes
Helena Brown7--Yes
Kelly Rates14CappucinoNo
Annie Tailor2GuillermoYes
James Black13Cadbury CocoaYes
Kelly Brown5GuillermoYes
Justin Sexton8Bournville CocoaYes
Todd Fuller7EspressoYes
Joe Tailor7--No
Robert Sexton6EspressoYes
John Fuller14CappucinoNo
Justin Black10CappucinoNo
Helena Sexton16LatteYes