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?
Helena Sexton7EspressoYes
Justin Rates2Cadbury CocoaYes
Todd Dinnen10DecafNo
Kelly Rates16CappucinoYes
James Tailor0EspressoYes
Annie Sexton14EspressoYes
Patricia M. Black12LatteNo
Kelly Anderssen13AmericanoYes
Helena Sexton8--No
John Black1ZorroYes
Patrick Brown14Cadbury CocoaNo
Martin Bond8Bournville CocoaNo
James Dinnen6AmericanoNo
James Rates16AmericanoNo