Maintenance Spreadsheet

[dioxide45]

I don't know if you are putting this in an Access database or just an Excel spreadsheet with all the data. If in Access, I think two separate tables is best. Then you aren't really duplicating MF amounts.

1. Spreadsheet one would include all of the possible combinations that have primary keys across Resort, Size, Season, View. This spreadsheet would contain the DC point allocations.
2. Spreadsheet two would include all the the possible combinations to capture MF amounts. It would have primary keys across Resort, Size, and Season. Though season would be blank for all states except for Florida. Season is only a factor in the tax MF amount in Florida because of the Tax. The spreadsheet shouldn't capture tax amounts for California or the USVI since that isn't billed by Marriott.

These two spreadsheets can then be joined up in MS Access to produce whatever data you want to extract. I can't see the last updated spreadsheet, but I would also compile the data in list form instead of linear. Meaning, Have a separate record for each year, don't add new columns for each year. You can always pivot to put the years in to columns. Lists are so much easier to work with and query.

 

[Superchief]

So, you're saying resorts in Utah, where there is MountainSide and Summit Watch, even though they have Silver, Gold, Platinum, they all pay the same maitenance fee based on Unit size, respectively?

No wonder people didn't buy Silver weeks.

I bought some Gold and silver weeks at MVC resorts because the prices were substantially lower and we actually preferred off season in many of these locations. If I had known at that time that maintenance fees would keep increasing at 2x rate of inflation, MR reward points would become worthless and the DC point system would allocate substantially lower points to non-prime seasons, I would definitely not have purchased these weeks.

I also have noticed dramatic increases in the MF's at resorts that previously were relatively good cost per point values, especially Canyon Villas and Mountainside. Recreation/activity, front desk, and resort management fees appear to be driving these increases. I have a pet peeve with making all owners pay for added activities that I'm not interested in. These should be self-funded.

 

[StevenTing]

I don't know if you are putting this in an Access database or just an Excel spreadsheet with all the data. If in Access, I think two separate tables is best. Then you aren't really duplicating MF amounts.

1. Spreadsheet one would include all of the possible combinations that have primary keys across Resort, Size, Season, View. This spreadsheet would contain the DC point allocations.
   
2. Spreadsheet two would include all the the possible combinations to capture MF amounts. It would have primary keys across Resort, Size, and Season. Though season would be blank for all states except for Florida. Season is only a factor in the tax MF amount in Florida because of the Tax. The spreadsheet shouldn't capture tax amounts for California or the USVI since that isn't billed by Marriott.
   

These two spreadsheets can then be joined up in MS Access to produce whatever data you want to extract. I can't see the last updated spreadsheet, but I would also compile the data in list form instead of linear. Meaning, Have a separate record for each year, don't add new columns for each year. You can always pivot to put the years in to columns. Lists are so much easier to work with and query.

Right now it's just a flat spreadsheet. I wanted to get all of the data in first before converting it to different tables.

I'm trying to decide which will be easier to update in the future. I want to stay away from Access as not everyone has it. Maybe I'll put it in a MySQL DB and then create some basic scripts people can run.

 

[dioxide45]

Hi Steven
Just looking at the Resort Codes
Phuket Beach Club is MPU/MP1
Mai Khao Beach is MKB
I will take a look at the Summary information for my resorts tomorrow.

Did Marriott even sell individual weeks at Mai Khao Beach Club? Isn't it 100% AP points? If so, we would never see nor know the annual MF amount.

 

[dioxide45]

Oceana Palms has a Platinum Plus for Presidents Day also.

 

[jimf41]

I will check Frenchman's Cove then because the points listed are what it costs to trade into Frenchman's Cove.

I don't think so Suzanne. The points listed for a Plat 2bdrm and a week 51 2bdrm are what you are allotted not what is required for a reservation. Trying to compile the points required for a reservation would make it an enormous SS and would be even more complex when you consider the different checkin days.

 

[bazzap]

Did Marriott even sell individual weeks at Mai Khao Beach Club? Isn't it 100% AP points? If so, we would never see nor know the annual MF amount.

That is correct, but AP points were aligned with DC points at the end of 2015 (from their previous 10:1 basis) in preparation for AP/DC "integration" during 2016.
It should then become possible to make a DC points reservation for Mai Khao Beach resort, so I thought it might be of interest to include whatever details are available an relevant.

 

[suzannesimon]

I don't think so Suzanne. The points listed for a Plat 2bdrm and a week 51 2bdrm are what you are allotted not what is required for a reservation. Trying to compile the points required for a reservation would make it an enormous SS and would be even more complex when you consider the different checkin days.

All I was saying was my FC weeks were incorrect on the chart for the points. We don't need to know what is needed to trade into a resort. Marriott already has done that on the owners' website.

 

[pedro47]

To the OP, thanks for you are a person who loved to do research and your efforts are outstanding and I feel it makes you happy.

May the force be with you.

 

[StevenTing]

My OCD has been satisfied temporarily. Here is the updated link for Maintenance Fees and DC Points. This link has also been updated at VPE and I will also Add it to my signature.

The link is Read Only.

On the Raw Data Tab, DC Points highlighed in Blue have been confirmed by Tuggers. Those in Light and Dark Green came from spreadsheets from GregT's site.

[Link deleted.]

 

[StevenTing]

So the next question is how do I display my signature. I believe I have it configured.

Also, please let me know if the link is not working.

 

[Fasttr]

So the next question is how do I display my signature. I believe I have it configured.

Also, please let me know if the link is not working.

Link works perfectly.

 

[JIMinNC]

My OCD has been satisfied temporarily. Here is the updated link for Maintenance Fees and DC Points. This link has also been updated at VPE and I will also Add it to my signature.

The link is Read Only.

On the Raw Data Tab, DC Points highlighed in Blue have been confirmed by Tuggers. Those in Light and Dark Green came from spreadsheets from GregT's site.

[Link deleted.]

Very, very nice!!

One thing I noticed...you have a "Grand Ocean Platinum 52" category listed. I may be wrong, but I'm pretty sure GO is the same as Barony and week 52 is just a standard Silver week.

 

[dioxide45]

Are you only going to capture the MF amount for annual weeks? I guess EOY is exactly half of the amount, so capturing EOY fees isn't really necessary.

 

[StevenTing]

Yea. Only annual weeks.

 

[GaryDouglas]

Do you plan on doing pre-2009?

 

[jimf41]

Nice job Steven. I'll dig up some old bills and see if I can fill in some blanks at Ocean Pointe.

 

[StevenTing]

Do you plan on doing pre-2009?

Depends on how much I hate myself. What you see right now is 20 hours worth of work to reconcile all of the posts on TUG and the information from Marriott's website. My goal of going to 2009 was to essentially capture MF just before when Destination Club went live.

 

[youppi]

Good job Steven.
It would be interesting to see which 2BR is 2BR LO. Same thing for 3BR.

 

[StevenTing]

Good job Steven.
It would be interesting to see which 2BR is 2BR LO. Same thing for 3BR.

In terms of MF and DC Points, I don't think it is relevant. It's not something I plan on doing.

 

[StevenTing]

Very, very nice!!

One thing I noticed...you have a "Grand Ocean Platinum 52" category listed. I may be wrong, but I'm pretty sure GO is the same as Barony and week 52 is just a standard Silver week.

If someone can confirm, I'll be happy to update. For some reason I came up with it. Maybe it's supposed to be Week 51 for Christmas.

For now, I'll leave it as is.

 

[StevenTing]

I had to update the link because apparently when I upload a new copy, it generates a new link.

[Link deleted.]

It should also be updated in my signature.

 

[klpca]

DSVII white week

Good job Steven. Thanks for spending the time to compile the information. FYI, according to my Marriott account, the point allocation for DSVII (white week) is 2150 points (vs 1575 on the spreadsheet).

 

[StevenTing]

Good job Steven. Thanks for spending the time to compile the information. FYI, according to my Marriott account, the point allocation for DSVII (white week) is 2150 points (vs 1575 on the spreadsheet).

Thanks. I have made an update in my local spreadsheet. I'll probably upload a new copy next week since it generates a new link each time.

 

[JIMinNC]

If someone can confirm, I'll be happy to update. For some reason I came up with it. Maybe it's supposed to be Week 51 for Christmas.

For now, I'll leave it as is.

Both 51 and 52 are just Silver. See attached weeks calendar.