![Open in Visual Studio Code](https://classroom.github.com/assets/open-in-vscode

](https://classroom.github.com/online_ide?assignment_repo_id=11844862&assignment_repo_type=AssignmentRepo)
# Course DIP225 practical task Nr.1
**you should submit your program in result.py file**
Write a program that reads information from the file “test1.xlsx” located in the “tests” folder and calculates the number of people whose salary is higher than 3000 EUR per month.
The existing file contains three columns:
| id | hours | rate |
|————|—————|————–|
To determine the monthly salary, you need to multiply the hourly rate by the specified hours. Be careful – some rows may have incorrect data (text instead of numbers). We recommend checking the data type of the obtained values before performing the calculation.
To complete the task, you need to use a **for** loop and **if** conditional statement.
The program should output a numerical value.
To enable the software to perform autotest of your submission, it is necessary to add the library name to the setup.txt file.
To do this, first find out which python version of the library you are using. Type the command pip freeze in the terminal of your IDE.
Find the required python library from the list. (In this example, it is the library openpyxl==3.1.2).
Update the setup.txt file by adding the found library name and version.
Finally, you can resubmit the program.