I often tweak my formulas as I go along in an effort to become more efficient and accurate. Here’s a log of it:
- 02.20.18 – SEMI-MAJOR – Will no longer average in a zero for a lack of international first class award availability across all routes. However, if a carrier does offer it, we’ll include it. In other words, we’ll give them credit if they do but won’t hold it against them if they don’t. Reason being similar to 02.18.18’s major update.
- 02.18.18 Replacing ATH->YYZ hypothetical redemptions with LON->PVG. Availability for that route was poor among all carriers.
- 02.18.18 – MAJOR: Removing first-class hypothetical redemptions from all non-North America-Asia routes. Reason being is that three-cabin layouts on non-ultra long haul routes are becoming rarer by the day. Moving to a two-class(economy/business) hypothetical redemption chart will allow us to provide more realistic valuations.
- 02.17.18 – MAJOR: Hypothetical dates are now standardized as the following: next Friday, Friday after next and 4 Fridays from the date of calculation. Previously, I would simply look at hypothetical awards 2, 7 and 21 days in the future. This way I’m always looking at the same day of the week, regardless of when the calc is being performed.
- 02.15.18 Started excluding Icelandair from business class cash price searches. Reason being is that their product is more akin to a domestic one than a true international business class
- 02.14.18 Began removing zeros from the best/worst redemption chart(but not the valuation).
- 02.13.18 Began including ULCC’s(ultra-low cost carriers) in economy cash price searches
- 02.13.18 Began entering a zero for negative redemption values. In other words, when the taxes/fees/carrier surcharges exceed the lowest cash price.
- Removed the IAD-JNB city pair – There was very little award availability across all carriers for this city pair, making calculations cumbersome.
- MAJOR: Began entering a zero instead of a null value for any case in which there is no award availability. Previously, the average would ignore any cell without a value. The rational was this: if there is no award availability, the currency is effectively worthless for that hypothetical redemption. By ignoring this, we’re effectively giving the currency in question a “pass” instead of reducing the average, as we believe should be the case.