'Enhanced' QF status credit calculator | Page 3 | Australian Frequent Flyer
Australian Frequent Flyer

Welcome to Australia's leading independent Frequent Flyer and Travel Resource since 1998!
Our site contains tons of information that will improve your travel experience.

Joining AFF is fast, simple & absolutely free - register now and take immediate advantage of these great BENEFITS.

Once registered, this box will disappear. And you will see fewer advertisements :)

'Enhanced' QF status credit calculator

sbor90

Established Member
Joined
Feb 23, 2015
Messages
1,459
Flights
My Map
Quite a few people have PMed me about this. The sheet is still a work in progress, but coming along nicely:


Before sharing how I've got this working I want to ensure that the sheet isn't making huge amounts of unnecessary API calls - as that's a surefire way to get the attention of Qantas. If anyone is a Google Sheets/Excel gun (particularly with lookups) and wants to help contribute please let me know :)

Some of the data the API will return:
  • List of valid origins
  • List of valid destinations from each specific origin
  • List of valid carriers marketing each citypair
  • List of valid classes for that carrier on that citypair (i.e. business will show for DPS-KUL on MH, but not KUL-LHR it's not a valid QFF earn category)
  • Points for route/carrier/class including status bonus where applicable
  • SC earns (duh)
  • Distance of citypair (I'm fetching the 'debug' distance which appears to be a more accurate figure - but there is also the distance used for SC calculations)
Will respond to all your PMs as soon as I can
 
Last edited:

AisleSeat

Established Member
Joined
Nov 11, 2016
Messages
1,080
Flights
My Map
Quite a few people have PMed me about this. The sheet is still a work in progress, but coming along nicely:


Before sharing how I've got this working I want to ensure that the sheet isn't making huge amounts of unnecessary API calls - as that's a surefire way to get the attention of Qantas. If anyone is an Google Sheets/Excel gun (particularly with lookups) and wants to help contribute please let me know :)

Some of the data the API will return:
  • List of valid origins
  • List of valid destinations from each specific origin
  • List of valid carriers marketing each citypair
  • List of valid classes for that carrier on that citypair (i.e. business will show for DPS-KUL on MH, but not KUL-LHR it's not a valid QFF earn category)
  • Points for route/carrier/class including status bonus where applicable
  • SC earns (duh)
  • Distance of citypair (I'm fetching the 'debug' distance which appears to be a more accurate figure - but there is also the distance used for SC calculations)
Will respond to all your PMs as soon as I can
Outstanding. I wondered about using cell references in the API call, but wasn't sure how to get it working (That was something that was bugging me when i was looking at the new flight schedule, which now requires two separate API calls; one to show the schedule and then another to show the aircraft type for a specific flight).
 

sbor90

Established Member
Joined
Feb 23, 2015
Messages
1,459
Flights
My Map
I wondered about using cell references in the API call, but wasn't sure how to get it working
I'm concatenating the cell references into the URL and calling with ImportJSON like below

=ImportJSON(CONCATENATE("https://services.unique.qantas.com/calculator/v2/segment/"&Calculator!$B4&"/"&Calculator!$C4&"/"&Calculator!$D4&"/"&Calculator!$E4&".json?status_tier="&Calculator!$I1&"&date="&(TO_TEXT(Calculator!$A4))),"/points/base_plus_cabin_bonus","noInherit,noHeaders,truncate")

This is a huge learning curve for me (lots of trial and error!) so I have no doubt there's a better way to do this. At the moment I'm assuming ImportJSON is trying to call the API with those cell values even when they are blank, so the next thing I plan to focus on is an IF statement which only makes the call once the necessary cells have valid values.
 
Last edited:

sbor90

Established Member
Joined
Feb 23, 2015
Messages
1,459
Flights
My Map

Lynda2475

Active Member
Joined
May 1, 2009
Messages
833
Qantas
Gold
Virgin
Red
Which route(s) are you looking at? The carriers API endpoint is returning KA as a valid carrier on some routes (HKG-TPE/PEK/SHA) but not others (HKG-KUL)
I was looking at HKG-SGN
 

JohnM

Senior Member
Joined
Jun 7, 2006
Messages
7,950
Qantas
Platinum
Flights
My Map
Good stuff!

No fault of @sbor90, but a limitation of what can be drawn from QF: There is no information for the following sectors (all of which are in my upcoming DONE4):

CBR-DOH QR
EVN-DOH QR
DFW-KOA AA
KOA-NRT JL

Both the old and enhanced QF calculators couldn't return a SC or points value for these sectors. A quarter of a DONE4 inaccessible. :rolleyes:

If only the QF work experience kids would populate their database with all OneWorld flights. They continue to overreach - to new lows. :mad:
 

sbor90

Established Member
Joined
Feb 23, 2015
Messages
1,459
Flights
My Map
I have just clicked on my bookmarked calculator and have a functioning "old" calculator, with the ability to enter multi-city with results.
Has anyone tried entering Frequent Flyer - Flying Qantas & Partner Airlines - Points Calculators - Earning Points into their browser and see what happens?

Both my laptops have given the same result. YMMV
That's working for me also! It seems you may have a very old bookmark saved, the one I'd saved from 2014~2015 was Qantas Points Calculators | Frequent Flyer which redirects..
 

ferntree

Member
Joined
Nov 9, 2015
Messages
112
Qantas
Platinum
Joined
Jun 12, 2012
Messages
63
Thanks for this ... wonder how long it will stay there though!
Probably not long now that the old link has been exposed.

Strange thing though, the address that I posted was a copy and paste from my browser, with the https// address, yet when it appears here it has the "description".
Not to worry as long as someone can get at it and make use of it. Someone may wish to check a few sectors to see if it still aligns with the new one.
 

esseeeayeenn

Established Member
Joined
Jul 2, 2014
Messages
2,676
Qantas
Platinum
Flights
My Map
According to the new calculator both SDU (Rio) and GRU (Sao Paulo) are valid departure points but if you select them there are no valid destinations.
Perhaps they have deleted all the LATAM routes a bit early.
 

Community Statistics

Threads
84,870
Messages
1,985,968
Members
52,240
Latest member
JFEP
Top