Are you sure you don't work for Starwood or Hilton.....

I'd imagine that the information that you're asking for in the spreadsheet is highly confidential and is in some respects the basis of Marriott's business and competitive advantage.

I've already been surprised that the Conceirge has been so generous with the facts in percentage terms - any such information could be used by competitors to work out how to target Marriott's customers.

I think what I'm saying is that you shouldn't expect any responses to that spreadsheet and although it is an interesting point in maths it just restates the obvious (losing a plat costs more than losing a casual user...probably). I also think that the spreadsheet is missing out on the key people who benefit from this change and sit somewhere between 'casual' and silver members (or perhaps are just silver members) - i.e. those people who might spend 1/2 weeks at a hotel on holiday each year, are pretty agnostic about which chain they stay at and so earn perhaps enough points for 1/2 nights per year in a hotel - and as such who benefit immensely from the change in reward patterns (i.e. theoretically they can use their stay anytime). If you look at my figures below there might be perhaps 20million such active members.

Having said that - if you spend a little bit more time with google you should be able to populate many areas of the spreadsheet yourself, for example;

Total number of elites, 3.5m source
Total number of MR members, 28m source
Useful thoughts on traveller spend source

I'm sure there is much more out there - happy hunting.