FlyerTalk Forums - View Single Post - I built my own Flying Blue analytics suite… UXP question for the experts
Old Dec 10, 2025 | 7:11 am
  #1  
VikingXNL
50 Countries Visited
All eyes on you!
 
Join Date: May 2025
Location: AMS
Posts: 140
I built my own Flying Blue analytics suite… UXP question for the experts

So… this escalated quickly.

I started with a simple Excel sheet to track XP, rollover timing and flight planning. Got tired of the manual work. Thought: 'Can I automate this a bit?'

Fast-forward a few weeks and… I somehow built a full analytics platform for Flying Blue.

Think:
  • XP cycle engine
  • Synamic qualification windows
  • Full flight ledger
  • Miles portfolio analytics
  • Redemption value tracking
  • XP run simulator
  • Rollover projections
  • CPM benchmarking

Basically: the Flying Blue dashboard I always wished existed. Well... it's live now.

👉 skystatus.pro

If you’ve ever tried turning Flying Blue rules into deterministic logic, you know XP alone can get messy. But translating it into code that behaves exactly like FB does? That was a different game.

The main villain: the dynamic qualification period. Mid-year level-ups, shifting windows, rollover caps, promotion resets… It took a lot of iterations, but the XP engine now matches FB behavior cycle-for-cycle, including all edge cases.

There’s one thing I haven’t implemented yet: UXP and Ultimate.

This is essentially a second state machine layered on top of XP, and since I’ve never been Ultimate, I don’t have real-world corner cases to validate against.

Questions for Ultimate experts here:
  1. When you level up to Platinum, does UXP start accruing only from that promotion date onward?
  2. Or is there still a hidden pre-accrual mechanism like in the old calendar-year setup?
  3. Does a mid-cycle level-up fully reset UXP together with XP, or only XP?
  4. How does UXP rollover behave when your cycle gets shortened because of a promotion?
  5. Any odd cases where UXP behaves differently from XP during promotions or requalification?

If anyone who has gone through Ultimate transitions can share real experiences, that would help enormously.

For those curious, here are some screenshots showing how the XP logic is visualised inside the tool.










Last edited by VikingXNL; Dec 10, 2025 at 8:48 am
VikingXNL is offline