Advanced Excel Data Analysis

Task 1.

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.

Task 2.

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.



Skills: Data Mining, Data Processing, Excel

See more: advanced excel data analysis, advanced data analysis excel, excel data analysis xls, advanced excel analysis, data analysis advanced excel, excel flight data analysis, task five, excel for data analysis, excel advanced 2010, excel 2010 advanced, data analysis for excel, nps data, survey analysis, sort excel, PEST, incident, HR Projects, helicopter, excel projects, excel data sheet

About the Employer:
( 32 reviews ) Sydney, Australia

Project ID: #1550183

Awarded to:


Hello, I am a MS Excel expert. I have taken a look at the workbooks you have provided and I am confident this is something I will be able to do for you. I am well practised in this area and I am always extremely accur More

$295 USD in 3 days
(1 Review)

13 freelancers are bidding on average $374 for this job


Please see what I said.

$250 USD in 3 days
(30 Reviews)

Hi, Did so many projects of such kind. Not only analysis , but also can present such data in visual form. Please look at one of my sample at my website. [login to view URL] More

$250 USD in 2 days
(13 Reviews)

Hello I can do this for you. Please see my Private message for more details. Regards Faisal

$250 USD in 5 days
(4 Reviews)

Hi Mr. Kate, I can do this job easily. Please check PMB for sample work.

$250 USD in 3 days
(2 Reviews)

Hi... I would like to apply for the job.

$250 USD in 2 days
(4 Reviews)

Hi Please see detailed proposal in PM

$250 USD in 5 days
(6 Reviews)

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

$450 USD in 8 days
(3 Reviews)

Hi Kale, Thank you for posting this requirement. Kindly check your PMB for more details. Regards.

$650 USD in 10 days
(2 Reviews)

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

$250 USD in 5 days
(0 Reviews)

Hey! i am expert in excel using VBA. I can do complex extraction analysis in excel using visual basic.

$250 USD in 2 days
(0 Reviews)


$750 USD in 10 days
(0 Reviews)

When does your project start.

$711 USD in 14 days
(0 Reviews)