'Enhanced' QF status credit calculator

[JohnM]

Annoying when going to select business calls you cannot use the scrollbar on the drop down, have to up/down arrow.

Typical work experience kid result.

 

[sudoer]

@sbor90 would love a PM with instructions.

No problem, PM me your Gmail address and I'll share some instructions once I finish writing them up today

 

[sudoer]

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

 

[AisleSeat]

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).

 

[sudoer]

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.

 

[Lynda2475]

Interesting Cathay Dragon | Airline Partners | Qantas Frequent Flyer states that you can earn points and SCs on KA flights, but the new points calculator doesnt allow you to select KA as an airline just CX. Nice inconsistencies in the website.

 

[sudoer]

Interesting Cathay Dragon | Airline Partners | Qantas Frequent Flyer states that you can earn points and SCs on KA flights, but the new points calculator doesnt allow you to select KA as an airline just CX. Nice inconsistencies in the website.

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)

 

[Lynda2475]

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

 

[sudoer]

SC Calculator is finished and emailed to all who PMed. If anyone else wants a copy just PM me your Gmail address.

 

[dylarr]

Your solution is so, so much better than even the old, much beloved calculator that Qantas just nixed.

What a win!

 

[sudoer]

Your solution is so, so much better than even the old, much beloved calculator that Qantas just nixed.

Glad you like it. I found a small bug in calculating total points haul - drag cell H20 across G20 to fix.

 

[levelnine]

SC Calculator is finished and emailed to all who PMed. If anyone else wants a copy just PM me your Gmail address.

This is a magnificent resource. Thanks so much for making it and, more importantly, sharing it with the AFF community.

 

[JohnM]

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.

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

 

[dasheighty]

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

 

[sudoer]

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]

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

Thanks for this ... wonder how long it will stay there though!

 

[GoldCanyon340]

Thanks for this ... wonder how long it will stay there though!

Probably not long now

 

[dasheighty]

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.

 

[dasheighty]

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..

Not sure how old the bookmark is, but it would be in the last 18 months (new latop).
Have you tried it against your spreadsheet for accuracy?

 

[esseeeayeenn]

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.