Data Reporting of 43 Wind Turbines - Excel ( Macros & Microsoft Script)

An Automated sheet to get all information regarding the services being run on 43 Wind Turbines in the industry.

The functions used for creating the dashboard:

1. VLOOKUP
2. XLOOKUP
3. A Reset Button creation Using MACROS + Microsoft Script
4. INDEX + MATCH
5. CONCATENATE

The Benefits of the projects are: - The user just need to update the first sheet. - The dashboard gives all the information to the user related to: - The amount of services which have been performed till now on the Wind turbines. - The Turbines out of 43 which are running today. - Creating a timetable for the services being run. - The amount of services that have been completed on the windturbines.