vgutkovsky

Nm, stupid question. Hang on a couple hours, I'll generate it for you. Note to everyone else: this is just a one-time thing, not taking other orders :-) Kinda of curious about this route myself though.

vgutkovsky

The two A380 flights that I see on the SIN-SYD route are 221 and 231. Here's saver availability including both of those:



Much rosier picture than the JFK - FRA route. But the vast majority of this availability is on SQ231. Not sure if that's not as good...? If you're wondering about February, looks like SQ231 is flying on 777 instead of A380 that month for some reason, so was excluded from the above chart. It goes back to the A380 on March 1st.

Here's the picture for just SQ221:



Looks like there's virtually no saver availability on this flight. As of now, they've released availability 9 days in advance and then nothing else for the rest of the year.

hondaman82

That's what i thought, ZERO saver all year long, thanks for the confirmation vgutkovsky

vgutkovsky

Why not fly on 231? Is it not as good? Except for February, it's an A380, so presumably suites?

hondaman82

it is the old suites, i have flew on it a few times, want to try the new suites lol

vgutkovsky

Well, I don't think the correct conclusion is that there's no saver availability. The chart above paints a pretty clear picture: there's availability, but they open it up late. If I were you, I would run a search for this route every day for the next week to see availability for the day after. As of yesterday's search, the day after yesterday (i.e. today) had non-waitlist availability. If there's non-waitlist availability every time you search, there's a good chance that you'll be able to get it last minute, assuming you don't mind living a little dangerously. I'm assuming you're not local to Singapore, but I'd bet that if you're willing to go there and wait for availability to open up around the time you want to fly, you wouldn't be waiting for more than a couple days. Using that assumption, you can buy your return ticket (from SYD to wherever) assuming a stay in SYD of +- 2 days. Like I said, it's living a little dangerously, but not too much, assuming you run the check every day for the next week or two. Really depends on how badly you want to fly this product IMO.

vgutkovsky

Visit the link again. I've added all the code as a download at the bottom of page, with detailed instructions. You should be able to use QlikView without any issues, no need to reinvent the wheel. Enjoy.

kamchatsky

Actually the new A380 for SQ 221 (and SQ232) with new Suites is only available from 18 December. That's why no availability from that day onwards.

vgutkovsky

Oooooh, that makes sense, thanks!

sandyph

good stuff OP
been meaning to try QlikView for a while now (only using BO at work), this might push me to actually start learning

vgutkovsky

Fyd

I used to live in SIN for a while and flew that route - SQ221 is more popular with business travelers based on the schedule.
SQ does something similar on other routes, ie SIN-FRA - the more popular time/plane is not/rarely available on saver award, but the less popular time/plane is...
Great visualization btw

daft009

this tool of yours looks awesome! thanks a lot for sharing!
though I would like to attempt to modify it for J as well, to maximise my points use.
Would I just add more origins/destinations in the qlikview code under "airports_temp:"?
have changed the imacro to business instead of first.

vgutkovsky

Correct. You would need to change 3 things for J availability:

1. In the iMacros code, change line 75 to select Business from the drop-down menu
   
2. In the QlikView code script (CTRL+E) under the Combinations tab, add or delete rows under airports_temp in the same format as what's already there, which is 2 comma-separated fields. The first field should be the 3-letter airport code. The second field should be enclosed in double quotes and should match what's in the Singapore site drop-down menu exactly (including capitalization).
   
3. In the QlikView code script under the Data tab, you'll need to update line 39. This logic fixes a strange SQ "feature" which is that when first class is not available, the site returns economy class availability (which we obviously don't want when searching for Suites). Fortunately, they at least put up a message that "FIRST CLASS is unavailable" when they do that. This code block searches for that message. I don't know what the message would say if there's no business class availability. Presumably "BUSINESS CLASS is unavailable" but I don't know.

Also, I just noticed a bug in the QlikView app and uploaded a fixed version, so download that.

Vandekeybuslouisa

Hey, I am not familiar with QlikView and donwloaded the the app onto my desktop QlikView Personal use. However when I click on the link from Singapore Airlines I receive the message that I can only see my own work and do not have access to others. Can someone from this forum explain in details (with screenshots even better) what to do exactly to install to proper software in order to be able to use this great tool. I spent now more than 3 hours to find out how it works, but without any luck. Many thanks for your kind help.