re: Discussion/Q&A on Best QF Status Run Options
I'm giving the spreadsheet a workout doing some research for an upcoming trip to LOTFAP. I need to go LAX-LAS so I ran some combinations. Looks like I won't be using any of these, but why waste all the hard work when it might at least give others some ideas. Here's the need to know bits:
*All flights are LAX-LAS for dates around mid-July.
* Duration is in hours, rounded up to the nearest whole number.
* Please double check the SC earn and don't book a run on my questionable maths.
* Prices are in AUD
* Based on ITA data and not cross-checked with AA.com
[TABLE="width: 370"]
[TR]
[TD="class: xl64, width: 45, bgcolor: transparent"]FROM
[/TD]
[TD="class: xl64, width: 24, bgcolor: transparent"]TO
[/TD]
[TD="class: xl64, width: 124, bgcolor: transparent"]VIA
[/TD]
[TD="class: xl64, width: 74, bgcolor: transparent"]DURATION
[/TD]
[TD="class: xl64, width: 59, bgcolor: transparent"]CARRIER
[/TD]
[TD="class: xl64, width: 44, bgcolor: transparent"]CLASS
[/TD]
[TD="class: xl64, width: 28, bgcolor: transparent"]SC
[/TD]
[TD="class: xl65, width: 46, bgcolor: transparent"]PRICE
[/TD]
[TD="class: xl67, width: 48, bgcolor: transparent"]VALUE
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]IAH,PHL,BOS,ORD
[/TD]
[TD="class: xl63"]40
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]430
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,680
[/TD]
[TD="class: xl68"]3.91
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]CLT,MIA,DFW
[/TD]
[TD="class: xl63"]23
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]340
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,340
[/TD]
[TD="class: xl68"]3.94
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]DFW, BOS, ORD
[/TD]
[TD="class: xl63"]36
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]420
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,660
[/TD]
[TD="class: xl68"]3.95
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]DFW,MCO,MIA
[/TD]
[TD="class: xl63"]23
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]370
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,470
[/TD]
[TD="class: xl68"]3.97
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]DFW,MCO,CLT
[/TD]
[TD="class: xl63"]33
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]370
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,480
[/TD]
[TD="class: xl68"]4.00
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]ATL,CLT,DFW
[/TD]
[TD="class: xl63"]19
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]340
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,380
[/TD]
[TD="class: xl68"]4.06
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]DFW, ATL, CLT
[/TD]
[TD="class: xl63"]20
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]290
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,180
[/TD]
[TD="class: xl68"]4.07
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]DFW,ORD,PHL
[/TD]
[TD="class: xl63"]21
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]340
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,390
[/TD]
[TD="class: xl68"]4.09
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]ORD,MIA,MCO,CLT
[/TD]
[TD="class: xl63"]36
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]410
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,680
[/TD]
[TD="class: xl68"]4.10
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]DFW, MIA
[/TD]
[TD="class: xl63"]22
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]300
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,230
[/TD]
[TD="class: xl68"]4.10
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]IAH,DFW,PHL
[/TD]
[TD="class: xl63"]17
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]340
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,410
[/TD]
[TD="class: xl68"]4.15
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]IAH,DFW
[/TD]
[TD="class: xl63"]12
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]220
[/TD]
[TD="class: xl66, bgcolor: transparent"]$920
[/TD]
[TD="class: xl68"]4.18
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]ORD, MCO, CLT
[/TD]
[TD="class: xl63"]32
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]370
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,550
[/TD]
[TD="class: xl68"]4.19
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]ATL,CLT,BOS,ORD
[/TD]
[TD="class: xl63"]25
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]410
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,720
[/TD]
[TD="class: xl68"]4.20
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"]MIA,ORD
[/TD]
[TD="class: xl63"]28
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]330
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,400
[/TD]
[TD="class: xl68"]4.24
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]ATL, CLT
[/TD]
[TD="class: xl63"]36
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]280
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,190
[/TD]
[TD="class: xl68"]4.25
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]ORD,MIA,PHL
[/TD]
[TD="class: xl63"]23
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]420
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,790
[/TD]
[TD="class: xl68"]4.26
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]IAH,ORD,JFK
[/TD]
[TD="class: xl63"]28
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]390
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,670
[/TD]
[TD="class: xl68"]4.28
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]IAH,DFW,MIA
[/TD]
[TD="class: xl63"]27
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]340
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,460
[/TD]
[TD="class: xl68"]4.29
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]IAH,ORD,MCO,CLT
[/TD]
[TD="class: xl63"]31
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]430
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,850
[/TD]
[TD="class: xl68"]4.30
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]IAH,ORD,CLT,MIA
[/TD]
[TD="class: xl63"]27
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]380
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,640
[/TD]
[TD="class: xl68"]4.32
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]ORD,MIA,JFK
[/TD]
[TD="class: xl63"]29
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]420
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,830
[/TD]
[TD="class: xl68"]4.36
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]CLT,MIA
[/TD]
[TD="class: xl63"]22
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]280
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,220
[/TD]
[TD="class: xl68"]4.36
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]ATL, CLT
[/TD]
[TD="class: xl63, bgcolor: transparent"]??[/TD]
[TD="class: xl63, bgcolor: transparent"]AA[/TD]
[TD="class: xl63, bgcolor: transparent"]F[/TD]
[TD="class: xl63"]450
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,965
[/TD]
[TD="class: xl68"]4.37
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]DFW,MCO,JFK
[/TD]
[TD="class: xl63"]33
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]390
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,710
[/TD]
[TD="class: xl68"]4.38
[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"]DFW,MCO,CLT
[/TD]
[TD="class: xl63"]26
[/TD]
[TD="class: xl63, bgcolor: transparent"]AA
[/TD]
[TD="class: xl63, bgcolor: transparent"]F
[/TD]
[TD="class: xl63"]340
[/TD]
[TD="class: xl66, bgcolor: transparent"]$1,500
[/TD]
[TD="class: xl68"]4.41
[/TD]
[/TR]
[/TABLE]