Aircraft Activity Graphs - August 2012

Here is where the coffee machine and Coke machine are kept. Please clean up after yourself and do not remove the magazines from this area. A good place to exchange thoughts with Operations personel and other pilots.

Moderators: Staff, HR, Flight Ops

Post Reply
User avatar
nwadc10
Site Admin
Posts: 3948
www.meble-kuchenne.warszawa.pl
Joined: Wed Jun 09, 2004 10:17 pm
Location: Ramsey, MN, USA

Aircraft Activity Graphs - August 2012

Post 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
Justin Erickson, Captain #1040
Chief Executive Officer
Globe Cargo PIREP (GCP) Developer
ceo-at-globecargova.org
Vatsim ID: 871725

Image
Mike Bridge
Member with over 30 posts
Posts: 562
Joined: Tue Dec 04, 2007 6:28 am
Location: Brisbane - Australia
Contact:

Re: Aircraft Activity Graphs - August 2012

Post by Mike Bridge »

Very nice

It would be interesting too see how the bids compare with charters / Titan flight for airframe usage
Mike Bridge
Brisbane, Australia - YBBN
#3316
User avatar
nwadc10
Site Admin
Posts: 3948
Joined: Wed Jun 09, 2004 10:17 pm
Location: Ramsey, MN, USA

Re: Aircraft Activity Graphs - August 2012

Post 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 ;)
Justin Erickson, Captain #1040
Chief Executive Officer
Globe Cargo PIREP (GCP) Developer
ceo-at-globecargova.org
Vatsim ID: 871725

Image
Jason Thompson
Member with over 30 posts
Posts: 225
Joined: Fri Jan 14, 2011 6:32 pm
Location: Leicester , East Midlands, UK

Re: Aircraft Activity Graphs - August 2012

Post 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
Regards

Jason
User avatar
nwadc10
Site Admin
Posts: 3948
Joined: Wed Jun 09, 2004 10:17 pm
Location: Ramsey, MN, USA

Re: Aircraft Activity Graphs - August 2012

Post 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.
Justin Erickson, Captain #1040
Chief Executive Officer
Globe Cargo PIREP (GCP) Developer
ceo-at-globecargova.org
Vatsim ID: 871725

Image
Jason Thompson
Member with over 30 posts
Posts: 225
Joined: Fri Jan 14, 2011 6:32 pm
Location: Leicester , East Midlands, UK

Re: Aircraft Activity Graphs - August 2012

Post by Jason Thompson »

Thanks Justin, I'll have a look at pivot charts.
Regards

Jason
rav72

Re: Aircraft Activity Graphs - August 2012

Post 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
User avatar
nwadc10
Site Admin
Posts: 3948
Joined: Wed Jun 09, 2004 10:17 pm
Location: Ramsey, MN, USA

Re: Aircraft Activity Graphs - August 2012

Post 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.
Justin Erickson, Captain #1040
Chief Executive Officer
Globe Cargo PIREP (GCP) Developer
ceo-at-globecargova.org
Vatsim ID: 871725

Image
Post Reply