I have some data in a set of excel spreadsheets for six years. The data is a set of information for helicopter usage across 8 helicopters. There is some variation in the helicopters across the years.
The files are divided by year and by identified helicopter and in each file, the hours of use are divided up by month .
The hours of usage are categorised by a set of usage codes:
Incident HR&FM Transp Survey Pest Infra Traing Other
I need to consolidate this data into a more user friendly sheet. Specifically I need to create a table that shows usage by each helicopter, by hours per usage code for each year of the five year period.
I also need to have a table for each of the helicopters showing me hours per usage for each year and also the trends in usage by month throughout each of the years.
I am attaching some samples of the data (Park Air 1 NPS [url removed, login to view] and Park Air 1 NPS [url removed, login to view]). Overall there are 41 excel spreadsheets like this.
I have another spreadsheet (Flight Section - Summary of Hours [url removed, login to view]) showing similar data for earlier years. This is in a simpler format. I need to collate the data into one table. I am attaching the file.
Quality and reliability in this work is essential. In your response please demonstrate your ability to carry out a project of this kind?
If you can offer any additional analysis and trend data analysis on this data, please let me know in your response.
If you are able to carry out this sort of work to a high standard, I may have some other projects in the short and long term.
13 freelancers are bidding on average $374 for this job
Hi Kate, I am a Data Analyst by profession and I am confident of being able to produce an analysis to your requirements. I've sent you my bid in a message. Kindly peruse my bid. MAV-IT
Hi Sir, I read your all of the details of your Project. I have two years experience as a virtual assistant, and I am able to do this project in less days... Please read PM... Thanks