Page 1 of 1

Aircraft Activity Graphs - August 2012

Posted: Thu Sep 13, 2012 1:35 am
by nwadc10
More charts have been produced comparing August 2012 aircraft activity to that of July 2012 and August 2011. July 2012 and August 2011 were selected for comparison to see the difference from the month just previous to August 2012 and to see the difference of the same time period from the previous year.
  • 747-400F was removed from all charts because it is far and away the most active aicraft and literally "off the charts".
  • The 747-8F was added in July 2012 and therefore reports 0 flights in August 2011.
  • The 737-800 was added in June 2012 and therefore reports 0 flights in August 2011.
Number of 747-400F flights in the relevant months:
  • August 2012: 137
  • July 2012: 151
  • August 2011: 141
August 2012
Image


July 2012
Image


August 2011
Image

Re: Aircraft Activity Graphs - August 2012

Posted: Thu Sep 13, 2012 7:34 am
by Mike Bridge
Very nice

It would be interesting too see how the bids compare with charters / Titan flight for airframe usage

Re: Aircraft Activity Graphs - August 2012

Posted: Thu Sep 13, 2012 10:39 am
by nwadc10
I agree. In fact, I did have a formula programmed in Excel to do that but stupid me, I shutdown the computer some time after working on it and hadn't saved the file. The formula was a bit complicated and I just haven't gotten around to researching it again. It is on my eventual to-do list ;)

Re: Aircraft Activity Graphs - August 2012

Posted: Thu Sep 13, 2012 5:44 pm
by Jason Thompson
Hi Justin,

I thought about doing this for 777 flights when it's released and was going to run it by you? I've got Microsoft Word and could do with learning how to do graphs, charts and pie charts like yours.

I don't now what your thoughts are on it and me doing this?

On a side note I mailed John but waiting to hear from him.

Regards

Jason

Re: Aircraft Activity Graphs - August 2012

Posted: Fri Sep 14, 2012 10:10 am
by nwadc10
I do enjoy a good chart :) That's something we can do and we can talk about once more pressing issues are complete for the 777 fleet.

I am using Excel to produce the charts and downloading a data dump from the server which I would being obtaining for you. When we get to that point I can show you how to produce the charts. The process isn't very intuitive but if you have nothing better to do, read up on Pivot Charts in Excel until we are able to get together.

Re: Aircraft Activity Graphs - August 2012

Posted: Fri Sep 14, 2012 5:36 pm
by Jason Thompson
Thanks Justin, I'll have a look at pivot charts.

Re: Aircraft Activity Graphs - August 2012

Posted: Tue Sep 18, 2012 3:17 am
by rav72
Although I have to use Excel for 8hrs a day, 5 days a week, I still enjoy it. So, if you need any help just give us a shout.

Ralf

Re: Aircraft Activity Graphs - August 2012

Posted: Sat Sep 22, 2012 10:44 pm
by nwadc10
rav72 wrote:Although I have to use Excel for 8hrs a day, 5 days a week, I still enjoy it. So, if you need any help just give us a shout.

Ralf
We should have a discussion. It would be great to develop a workbook covering many different types of stats. I struggle to develop the complicated formulae so if you are really familiar with Excel I think we can make a good product for ourselves.