AFF Status Runs Spreadsheet

[BrentH]

lobo76 (the ideas man) suggested creating a sticky with all the details on the spreadsheet

What Is The Spreadsheet?

The AFF Status Run spreadsheet lists great fares found by members within the AFF community.

This lets us refer to fares by "fare codes" (e.g. "A57", "B39", etc), and communicate about them without alerting airline representatives who may remove them.

How Do I Get Access?

Eligibility:

At this stage, the only people being refused access are airline employees.

Additional eligibility criteria has been discussed, and may be added later.

Requesting Access:

lobo76 is the creator, and guardian of the spreadsheet.

If you want access:

1. Send lobo76 a Private Message with your email address. Gmail is best or you may need to link your non gmail email to a Google account, Hotmail addresses are apparently not supported. Note: Send one private message to him and then wait. PM boxes only have very limited space, and fill up quickly - meaning others can't send PMs. Expect it to take 48 hours.
2. Once access has been granted you will receive a notification email from Google Drive including a link to the spreadsheet. lobo76 will also endeavor to send you a PM indicating the access has been granted.
3. Make sure you have space in your own PM inbox to receive a reply from lobo76 notifying you that you have access (or letting you know of any problems).
4. Please don't use read receipts.
5. Please don't request access to the document via Google Drive. lobo76 ignores these emails as they cannot be linked back to a forum ID.
6. If you meet lobo76 in person, buy the man a drink. He deserves it for all his hard work here!

Usage Protocol:

Adding New Fares:

• 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).
• 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.
• Don't add fares that do not yet exist.

Fare (Points or Cash Cost) Changes:

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

Fares That Are No Longer Available:

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

Change Management:

• If you need to roll back bad changes, please make sure you're not undoing any "good" changes too.
• 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.
• 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.

Sorting:

• 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")

Tips: Staying up-to-date with changes...

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

Have I missed anything here?

Mods: Feel free to edit as needed if I miss anything.

 

[MarkD]

Missed one thing...... Dont tell the Airlines what it contains!!!

 

[kpc]

Poor lobo76 will have a hard time trying to keep the airline infiltrators out:shock:

 

[Hvr]

Poor lobo76 will have a hard time trying to keep the airline infiltrators out:shock:

Well I guess if he has any doubts he can ask for some one to vouch for the requester.

 

[BrentH]

I reckon we need to start looking at nailing down eligibility requirements, to make things a bit easier for him...

 

[Hvr]

I reckon we need to start looking at nailing down eligibility requirements, to make things a bit easier for him...

Well over at FT they have a 180 days with 180 posts, requirement for access to certain fora. Post padding is policed and access can be withdrawn.

Given this spreadsheet is going to be a valuable resource I believe that access should be seen as a privilege not a right.

However, I believe admin should be consulted to ensure any access requirements fit into his goals for this site.

 

[admin]

I hadn't been consulted and have just seen this post. I support any AFF member wants to help others, especially when they contribute so much of their time. Lets run with this, as specified by the creators, for the moment. We can always tweak things later.

I understand the need to exclude some members (such as airline Reps!), but feel that membership should be as open as possible and not too restrictive. AFF is all about sharing info.

I'm not sure if the thread belongs in the Virgin forum. Should probably go somewhere else.

Well over at FT they have a 180 days with 180 posts, requirement for access to certain fora. Post padding is policed and access can be withdrawn.

Given this spreadsheet is going to be a valuable resource I believe that access should be seen as a privilege not a right.

However, I believe admin should be consulted to ensure any access requirements fit into his goals for this site.

 

[JohnK]

The secret society is out in the open? :shock:

 

[k_sheep]

I don't really fly Virgin at all, but props to Lobo76 for all his hard work, and for sharing the love

 

[Gold Member]

I don't really fly Virgin at all, but props to Lobo76 for all his hard work, and for sharing the love

Lobo76 for PM! Not a difficult proposition given the current political environment.

 

[ShaneN]

While I support the objective, I do not think it is possible, necessary or desirable to set up a limited access spreadsheet with the latest information on status runs. Things change too rapidly. There are many forums on this site which provide the information.

Also, a lot of the fun is in the searching.

 

[k_sheep]

Lobo76 for PM! Not a difficult proposition given the current political environment.

I'll second that

Wait, does this count as "post padding"?

 

[JessicaTam]

I'll second that

Wait, does this count as "post padding"?

I think you have enough posts to not worry about being accused of that!

 

[Deleted member 29185]

Also, a lot of the fun is in the searching.

Except not everyone thinks it's fun :shock:.

Someone actually suggested making the spreadsheet available to all and just occasionally refer to it! A quiet, on the sideline, spreadsheet would possibly work well and remove all the guesswork for lobo76. VA/QF would likely leave it alone if it was "softly, softly", but may also see "good" status runs canned within hours.

Worth pondering and perhaps trying.

 

[ShaneN]

Any spreadsheet is static. Availability of status runs is constantly changing. I do not think this is a useful exercise.

 

[Deleted member 29185]

Any spreadsheet is static. Availability of status runs is constantly changing. I do not think this is a useful exercise.

That's fine. Don't participate. As a recipient of a nice run from the spreadsheet, I hope you'll excuse me for disagreeing with your sentiments!

 

[kamchatsky]

I reckon the user must be AFFers for 1 year and have 100 posts in order to access this spreadsheet. It is not hard to achieve this except for people who just want to take take take.

 

[samh004]

I think you have enough posts to not worry about being accused of that!

So you're saying I can no longer post pad?

What am I even doing here? I fly QF

 

[nitrocdh]

Thanks a lot lobo76 and all others involved for all the time and effort you are putting into this even if I don't manage to get access. If you have a community behind it keeping tabs on the runs then it should limit the redundancy of the data.

 

[Bolthead]

The secret society is out in the open? :shock:

I have a great name:

Let's call it "The Skulls"

or has that been used some where else...:shock: