'Enhanced' QF status credit calculator

Status
Not open for further replies.
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:
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).
 
Sponsored Post

Struggling to use your Frequent Flyer Points?

Frequent Flyer Concierge takes the hard work out of finding award availability and redeeming your frequent flyer or credit card points for flights.

Using their expert knowledge and specialised tools, the Frequent Flyer Concierge team at Frequent Flyer Concierge will help you book a great trip that maximises the value for your points.

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:
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
 
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:
 
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..
 
The Frequent Flyer Concierge team takes the hard work out of finding reward seat availability. Using their expert knowledge and specialised tools, they'll help you book a great trip that maximises the value for your points.

AFF Supporters can remove this and all advertisements

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.
 
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.
 
Status
Not open for further replies.

Enhance your AFF viewing experience!!

From just $6 we'll remove all advertisements so that you can enjoy a cleaner and uninterupted viewing experience.

And you'll be supporting us so that we can continue to provide this valuable resource :)


Sample AFF with no advertisements? More..
Back
Top