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 Smith12DecafYes
Patricia M. Sexton3AmericanoNo
James Brown11LatteNo
Kelly Rates..ZorroYes
Annie Fuller11ZorroYes
Joe Anderssen12LatteYes
James Black11CappucinoYes
Patrick Tailor7ZorroNo
Joe Rates4Bournville CocoaNo
Justin Sexton13DecafNo
Todd Anderssen0CappucinoYes
Annie Dinnen5Cadbury CocoaNo