Introduction: The statisticians need a nice report with population densities.
What you will learn:
- Primarily:
- Excel
- DataTables
- Secondarily:
- For Each Row
- Nested if operators
Client Name: World Stats Agency
Process Name: PopulationDensity
Description: You need to calculate the population density for the largest countries in the world and present the results in Excel:
- Read the Excel sheet ‘Excel and Datatables – Countries.xlsx’ in to UiPath.
- For each country calculate the population density by dividing the population by the area.
- Create a new column in the Excel sheet called ‘Population Density’ and print the densities there.
- Color the cells in the new column based on the size of the density:
- If the density is less than 30 the cell must be green.
- If the density is between 30 and 100 the cell must be yellow.
- If the density is above 100 then cell must be red.
- Type in all the countries with red densities in a new sheet.