Gold Status Moving Target
 

Could anyone explain how ANZ sets the targets to retain Gold status? I lost Gold a few months ago, now I have Silver, but the requirement to upgrade to GOld keeps changing day by day - always further away from the travel points I’ve just earned. Before my flight to Australia this week I required 80 points, and after the flight today it requires 97 points.

From the Air New Zealand site: " Your account is reviewed daily [my emphasis] to see if, in the previous 12 months, you have earned enough Status Points to move up to Gold status." So if you earned status points just over a year ago, they will have recently expired (hence the moving target).

To retain a status the period is fixed 12 months, but to attain a higher status a rolling 12 month period is used. So older flights will continually be dropping off the calculation to increase status.

The Air NZ method of rolling period is fairer than Qantas uses (fixed 12 month period for both retaining and attaining status) since people's travel plans don't usually fit nicely into fixed periods.

I had to make a spreadsheet so could see the rolling year on days other than today. Did find it easier if could see how many would actually have in the future on a given date.

Agreed, making a spreadsheet was crucial to attaining Gold for me. I started by picking a big flight from the past year and set that as Row 1 - now you have defined your year a bit. I am by no means an Excel expert, and I'm sure there are better ways to do this. My sheet looked like this:

Columns:

Flight Number, Flight Date, Status Points from Flight, Rolling total (formula)

First Row has column labels, and flight entries start on Row 2.

Formula for the Rolling Total column in Row 3 was:

=SUM($C$2:C3)

and in Row 4:

=SUM($C$2:C4)

Then copy down the formula to the last row of flights.

To make sure I crossed the Gold threshold even when Status Points over 1 year old started falling off, I added two more columns:

Flight Date, Status Points from Flight, Rolling total (formula), Rolling total (copied as values), New Rolling Total (formula)

For the New Rolling Total column, I set the formula to only Sum flights within the calendar year based on the Flight Date column, for example:

=SUM($C$3:C49)

or
=SUM($C$5:C52)

Every time I planned or booked a flight, I would enter the flight and its projected Status Points into the sheet. Worked a charm - just keep in mind that Status Points expire after 364 days at midnight NZ time, regardless of where your flights originated.

Or you can get a little fancier:
https://docs.google.com/spreadsheets...it?usp=sharing
With the first sheet a rolling 364 view
Then other sheets to track current gold year (they get their data from the first sheet so only one data entry)

Plus some fancy colouring Has demo data.

Lovely!

I use a spreadsheet too. It's the only way I can be sure about future status point levels.

In Google Sheets, I essentially have column A (date), column B (Status Points for flight), and column C (rolling 12-month total). In row 10, for example, the formula for column C is:
=SUMIF(A1:A10,">" & EDATE(A10,-12),B:B10)

You then only need rows for your actual flight dates.

Of course, you also need other columns for SPs earned from NZ flights, SPs earned from non NZ flights, SPs earned from credit cards, and another formula for calculating the rollover of a status tier you've already reached, etc.

Oh man... life is a lot easier when you get your status by flying internationally... a lot less flights to juggle!

Unless flying mostly trans tasman - then it takes even more flights to qualify! Though I do appreciate the extra few SP now appearing on TT fares.