Ahoy!
Monday is a lovely day. And you know why? Because there is a new RPA Challenge to strain your brains!
This time we will take a look at topic, that is actually very real-world scenario. There is an Excel spreadsheet with input data for further processing and our goal (or goal of our robot) is to perform validation check based on set of rules.
Goal of robot
- Use this input file: InputData.xlsx (12.8 KB)
- Perform validation checks as defined in Sheet “Validation”
| Column | Rule | |
|---|---|---|
| 1 | Date | Must ba a valid date in format YYYY-MM-DD |
| 2 | UserDescription | Cannot be empty. |
| 3 | ErrorCode | Must be exactly three characters long. |
| 4 | Result | Can only contain APPROVED or REJECTED |
- Cells, that contain invalid data,
highlightwith red colour.
How to participate 
- Send me your code in PM
- Post in Reply: Excel sheet with results (highlighted errors)
First three correct, original solvers earn 3 robopoints, next get 1 robopoint.
There is a leaderboard with your score. Those on top positions will be badged by a special challenger badge 
The challenge deadline is 19.9. by the end of the day. You can still submit your projects after the deadline but you cannot earn robopoints. 
A new challenge is published every week or 2 weeks so don’t worry if you did not catch this one. Keep in mind, your submitted files may be published after the deadline so others can learn from solutions.
Deadline is over