AFF Status Runs
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTU
1
WELCOME TO THE
2
3
4
5
6
7
8
9
10
STATUS RUN SPREADSHEET
11
12
13
This is a community resource so please read through the following rules prior to making changes
14
15
Adding New Fares:
16
17
Aim to be a contributor, and give - not just take. Look for new fares and add them - particularly if you know of QF/partner/YUPP status runs (these are big areas of improvement for the spreadsheet).
18
After adding a new fare, please sort the sheet by the Status Credit Yield. (You can do this by clicking the arrow over "Points/SC" or "$/SC", then click "Sort A-Z") This will ensure your fare appears in the right place.
19
20
21
Fare (Points or Cash Cost) Changes:
22
23
If you spot a fare change, make the update into the spreadsheet. (Leave a note in the notes column saying what the fare used to be.)
24
If you do change a fare, make sure the Status Credit Yield column is up to date and calculated correctly. The Status Credit Yield is either the points or cash cost, divided by the Status Credits earned. So if a fare costs $100 and earns 15 Status Credits, then the Status Credit Yield is $100 / 15 = $6.67. If the same fare costs 6900 points, 6900 / 15 = 460.
25
26
27
Fares That Are No Longer Available:
28
29
If a fare is no longer available, Markis10 suggests you use Strikethrough temporarily so that others who are looking for the fare (and might not understand where to find it) can still see it easily. It's wise to check months ahead. Several people have reported fares were no longer available when they were, but on obscure dates. If you're unsure, leave a note in the "Notes" column and someone can check.
30
After the fare is well and truly dead (has been struck-through for days? weeks? no longer being talked about?) move it to the Archive sheet.
31
No fares should be deleted. If a fare is no longer current it should be moved to the archive, if you cant find a AFF code in it's original sheet look in the archive
32
33
34
Change Management:
35
36
If you need to roll back bad changes, please make sure you're not undoing any "good" changes too.
37
If you're making significant changes to the spreadsheet (i.e. anything other than simply adding or editing fares), please leave a note in the Changelog sheet.
38
There are a LOT of columns that use calculated fields and conditional formatting. Be careful when importing/pasting data, or rolling back, that you don't kill these. Every time you muck up the spreadsheet, God delays a flight.
39
40
41
Sorting:
42
43
If you're sorting or filtering columns to find fares from your city, or under a certain number of points, etc - please make sure you re-order it by Status Credit Yield when you're done. (Again, you can do this by clicking the arrow over "Points/SC" or "$/SC", then click "Sort A-Z")
44
45
46
Tips: Staying up-to-date with changes...
47
48
We had a suggestion earlier this week that we add a "Date Added" column, to make it easier to work out which fares are new. There's an easy way to do this already. Look at the "AFF Number" column (column A) for the highest numbered fare (e.g. "A58"). If you've seen this one before, then nothing new has been added.
49
If you want alerts about who is changing what, and when - you can receive notifications by clicking "Tools" > "Notification Rules". Then select the changes you want to be notified about. [Warning: You will get 100's of emails about this. Every minuscule change will result in a notification.] I'll see if I can come up with a better solution to be notified when fares are added or improved...
50
51
52
.
53
54
55
.
56
57
58
.
59
60
61
.
62
63
64
.
65
66
67
.
68
69
70
.
71
72
73
.
74
75
76
.
77
78
79
.
80
81
82
.
83
84
85
.
86
87
88
.
89
90
91
.
92
93
94
.
95
96
97
.
98
99
100
.
Loading...